byjg / anydataset

src/Repository/DBDataset.php

Spacing +3 added lines, -3 removed lines

@@ -140,12 +140,12 @@ 
 
         // Define the query key
         if (is_array($arKey2) && count($arKey2) > 0) {
-            $key2 = ":" . md5(json_encode($arKey2));
+            $key2 = ":".md5(json_encode($arKey2));
         } else {
             $key2 = "";
         }
 
-        return  "qry:" . $key1 . $key2;
+        return  "qry:".$key1.$key2;
     }
 
     public function getScalar($sql, $array = null)
@@ -228,7 +228,7 @@ 
     public function getDbFunctions()
     {
         if (is_null($this->_dbFunction)) {
-            $dbFunc = "\\ByJG\\AnyDataset\\Database\\DB" . ucfirst($this->_connectionManagement->getDriver()) . "Functions";
+            $dbFunc = "\\ByJG\\AnyDataset\\Database\\DB".ucfirst($this->_connectionManagement->getDriver())."Functions";
             $this->_dbFunction = new $dbFunc();
         }
 

src/Database/DBSqliteFunctions.php

Spacing +1 added lines, -1 removed lines

@@ -23,7 +23,7 @@
     function limit($sql, $start, $qty)
     {
         if (strpos($sql, ' LIMIT ') === false) {
-            return $sql . " LIMIT $start, $qty ";
+            return $sql." LIMIT $start, $qty ";
         }
 
         return $sql;

src/Database/SQLHelper.php

Spacing +5 added lines, -5 removed lines

@@ -56,8 +56,8 @@ 
                 if ($sql != "") {
                     $sql .= ", ";
                 }
-                $sql .= " " . $this->_fieldDeliLeft . $fieldname . $this->_fieldDeliRight . " = " . $this->getValue($fieldname,
-                        $fieldvalue, $param, $decimalpoint) . " ";
+                $sql .= " ".$this->_fieldDeliLeft.$fieldname.$this->_fieldDeliRight." = ".$this->getValue($fieldname,
+                        $fieldvalue, $param, $decimalpoint)." ";
             }
             $sql = "update $table set $sql where $filter ";
         } elseif ($type == SQLType::SQL_INSERT) {
@@ -68,7 +68,7 @@ 
                     $campos .= ", ";
                     $valores .= ", ";
                 }
-                $campos .= $this->_fieldDeliLeft . $fieldname . $this->_fieldDeliRight;
+                $campos .= $this->_fieldDeliLeft.$fieldname.$this->_fieldDeliRight;
                 $valores .= $this->getValue($fieldname, $fieldvalue, $param, $decimalpoint);
             }
             $sql = "insert into $table ($campos) values ($valores)";
@@ -92,7 +92,7 @@ 
      */
     protected function getValue($name, $valores, &$param, $decimalpoint)
     {
-        $paramName = "[[" . $name . "]]";
+        $paramName = "[[".$name."]]";
         if (!is_array($valores)) {
             $valores = array(SQLFieldType::TEXT, $valores);
         }
@@ -140,7 +140,7 @@ 
         if (strlen($sql) > 4) {
             $sql .= ' and ';
         }
-        $sql = " $fieldName " . $relation . " " . $this->getValue($fieldName, $value, $param, '.');
+        $sql = " $fieldName ".$relation." ".$this->getValue($fieldName, $value, $param, '.');
     }
 
     public function setFieldDelimeters($left, $right)

src/Database/DBDblibFunctions.php

Switch Indentation +44 added lines, -44 removed lines

@@ -72,50 +72,50 @@
             if ($s) $s .= '+';
             $ch = $fmt[$i];
             switch ($ch) {
-                case 'Y':
-                case 'y':
-                    $s .= "datename(yyyy,$col)";
-                    break;
-                case 'M':
-                    $s .= "convert(char(3),$col,0)";
-                    break;
-                case 'm':
-                    $s .= "replace(str(month($col),2),' ','0')";
-                    break;
-                case 'Q':
-                case 'q':
-                    $s .= "datename(quarter,$col)";
-                    break;
-                case 'D':
-                case 'd':
-                    $s .= "replace(str(day($col),2),' ','0')";
-                    break;
-                case 'h':
-                    $s .= "substring(convert(char(14),$col,0),13,2)";
-                    break;
-
-                case 'H':
-                    $s .= "replace(str(datepart(hh,$col),2),' ','0')";
-                    break;
-
-                case 'i':
-                    $s .= "replace(str(datepart(mi,$col),2),' ','0')";
-                    break;
-                case 's':
-                    $s .= "replace(str(datepart(ss,$col),2),' ','0')";
-                    break;
-                case 'a':
-                case 'A':
-                    $s .= "substring(convert(char(19),$col,0),18,2)";
-                    break;
-
-                default:
-                    if ($ch == '\\') {
-                        $i++;
-                        $ch = substr($fmt, $i, 1);
-                    }
-                    $s .= $ch;
-                    break;
+            case 'Y':
+            case 'y':
+                $s .= "datename(yyyy,$col)";
+                break;
+            case 'M':
+                $s .= "convert(char(3),$col,0)";
+                break;
+            case 'm':
+                $s .= "replace(str(month($col),2),' ','0')";
+                break;
+            case 'Q':
+            case 'q':
+                $s .= "datename(quarter,$col)";
+                break;
+            case 'D':
+            case 'd':
+                $s .= "replace(str(day($col),2),' ','0')";
+                break;
+            case 'h':
+                $s .= "substring(convert(char(14),$col,0),13,2)";
+                break;
+
+            case 'H':
+                $s .= "replace(str(datepart(hh,$col),2),' ','0')";
+                break;
+
+            case 'i':
+                $s .= "replace(str(datepart(mi,$col),2),' ','0')";
+                break;
+            case 's':
+                $s .= "replace(str(datepart(ss,$col),2),' ','0')";
+                break;
+            case 'a':
+            case 'A':
+                $s .= "substring(convert(char(19),$col,0),18,2)";
+                break;
+
+            default:
+                if ($ch == '\\') {
+                    $i++;
+                    $ch = substr($fmt, $i, 1);
+                }
+                $s .= $ch;
+                break;
             }
         }
         return $s;

src/Database/DBMysqlFunctions.php

Spacing +4 added lines, -4 removed lines

@@ -9,7 +9,7 @@ 
 
     function concat($s1, $s2 = null)
     {
-        return "concat(" . implode(func_get_args(), ', ') . ")";
+        return "concat(".implode(func_get_args(), ', ').")";
     }
 
     /**
@@ -22,7 +22,7 @@ 
     function limit($sql, $start, $qty)
     {
         if (strpos($sql, ' LIMIT ') === false) {
-            return $sql . " LIMIT $start, $qty ";
+            return $sql." LIMIT $start, $qty ";
         }
 
         return $sql;
@@ -67,7 +67,7 @@ 
     function sqlDate($fmt, $col = false)
     {
         if (!$col) $col = 'now()';
-        $s = 'DATE_FORMAT(' . $col . ",'";
+        $s = 'DATE_FORMAT('.$col.",'";
         $concat = false;
         $len = strlen($fmt);
         for ($i = 0; $i < $len; $i++) {
@@ -128,7 +128,7 @@ 
                     break;
             }
         }
-        $s.="')";
+        $s .= "')";
         if ($concat) $s = "CONCAT($s)";
         return $s;
     }

Braces +11 added lines, -4 removed lines

@@ -66,7 +66,9 @@ 
      */
     function sqlDate($fmt, $col = false)
     {
-        if (!$col) $col = 'now()';
+        if (!$col) {
+            $col = 'now()';
+        }
         $s = 'DATE_FORMAT(' . $col . ",'";
         $concat = false;
         $len = strlen($fmt);
@@ -81,8 +83,11 @@ 
                 case 'q':
                     $s .= "'),Quarter($col)";
 
-                    if ($len > $i + 1) $s .= ",DATE_FORMAT($col,'";
-                    else $s .= ",('";
+                    if ($len > $i + 1) {
+                        $s .= ",DATE_FORMAT($col,'";
+                    } else {
+                        $s .= ",('";
+                    }
                     $concat = true;
                     break;
                 case 'M':
@@ -129,7 +134,9 @@ 
             }
         }
         $s.="')";
-        if ($concat) $s = "CONCAT($s)";
+        if ($concat) {
+            $s = "CONCAT($s)";
+        }
         return $s;
     }
 

src/Database/DBPgsqlFunctions.php

Spacing +5 added lines, -5 removed lines

@@ -20,7 +20,7 @@ 
     function limit($sql, $start, $qty)
     {
         if (strpos($sql, ' LIMIT ') === false) {
-            return $sql . " LIMIT $qty OFFSET $start ";
+            return $sql." LIMIT $qty OFFSET $start ";
         }
 
         return $sql;
@@ -65,7 +65,7 @@ 
     function sqlDate($fmt, $col = false)
     {
         if (!$col) $col = 'current_timestamp';
-        $s = 'TO_CHAR(' . $col . ",'";
+        $s = 'TO_CHAR('.$col.",'";
 
         $len = strlen($fmt);
         for ($i = 0; $i < $len; $i++) {
@@ -93,7 +93,7 @@ 
                     break;
 
                 case 'H':
-                    $s.= 'HH24';
+                    $s .= 'HH24';
                     break;
 
                 case 'h':
@@ -122,11 +122,11 @@ 
                     if (strpos('-/.:;, ', $ch) !== false) {
                         $s .= $ch;
                     } else {
-                        $s .= '"' . $ch . '"';
+                        $s .= '"'.$ch.'"';
                     }
             }
         }
-        return $s . "')";
+        return $s."')";
     }
 
     /**

Braces +3 added lines, -1 removed lines

@@ -64,7 +64,9 @@
      */
     function sqlDate($fmt, $col = false)
     {
-        if (!$col) $col = 'current_timestamp';
+        if (!$col) {
+            $col = 'current_timestamp';
+        }
         $s = 'TO_CHAR(' . $col . ",'";
 
         $len = strlen($fmt);