ahmetertem / query_builder

src/qb.php

Indentation +5 added lines, -5 removed lines

@@ -238,10 +238,10 @@ 
             switch ($this->_write_field_types[$d]) {
             case 0:
               $t .= "'".$this->_write_values[$d]."'";
-              break;
-          default:
+                break;
+            default:
               $t .= $this->_write_values[$d];
-          }
+            }
             $updates[] = $t;
         }
         $update_fields = implode(', ', $updates);
@@ -270,10 +270,10 @@ 
             switch ($this->_write_field_types[$d]) {
             case 0:
               $values[] = "'".$this->_write_values[$d]."'";
-              break;
+                break;
             default:
               $values[] = $this->_write_values[$d];
-          }
+            }
         }
         $string = sprintf('insert into %1$s (%2$s) values(%3$s)', $table, $fields, implode(', ', $values));
 

Switch Indentation +12 added lines, -12 removed lines

@@ -309,18 +309,18 @@
             throw new \Exception('Specify at least 1 table name');
         }
         switch ($join_type) {
-                case qb::INNER_JOIN:
-                    $join_type_ = 'INNER JOIN';
-                    break;
-                case qb::LEFT_JOIN:
-                    $join_type_ = 'LEFT JOIN';
-                    break;
-                case qb::RIGHT_JOIN:
-                    $join_type_ = 'RIGHT JOIN';
-                    break;
-                case qb::FULL_JOIN:
-                    $join_type_ = 'FULL OUTER JOIN';
-                    break;
+        case qb::INNER_JOIN:
+            $join_type_ = 'INNER JOIN';
+            break;
+        case qb::LEFT_JOIN:
+            $join_type_ = 'LEFT JOIN';
+            break;
+        case qb::RIGHT_JOIN:
+            $join_type_ = 'RIGHT JOIN';
+            break;
+        case qb::FULL_JOIN:
+            $join_type_ = 'FULL OUTER JOIN';
+            break;
             }
         $table = $this->_table_names[0];
         $where = count($this->_conditions) > 0 ? (' on ' . implode(' and ', $this->_conditions)) : null;

Spacing +15 added lines, -15 removed lines

@@ -103,7 +103,7 @@ 
      */
     public function whereOr()
     {
-        $this->_conditions[] = '('.implode(' or ', func_get_args()).')';
+        $this->_conditions[] = '(' . implode(' or ', func_get_args()) . ')';
 
         return $this;
     }
@@ -182,7 +182,7 @@ 
         //
         $limit = null;
         if ($this->limit > 0) {
-            $limit = ' limit '.($this->limit_offset != -1 ? $this->limit_offset.', ' : null).$this->limit;
+            $limit = ' limit ' . ($this->limit_offset != -1 ? $this->limit_offset . ', ' : null) . $this->limit;
         }
 
         //
@@ -190,7 +190,7 @@ 
         //
         $group = null;
         if (count($this->_group_fields) > 0) {
-            $group = ' group by '.implode(', ', $this->_group_fields).' ';
+            $group = ' group by ' . implode(', ', $this->_group_fields) . ' ';
         }
 
         //
@@ -206,20 +206,20 @@ 
                     $pos = strpos($of[0], '.');
                     if ($pos !== false) {
                         $t = explode('.', $of[0]);
-                        $t[1] = '`'.$t[1].'`';
+                        $t[1] = '`' . $t[1] . '`';
                         $of[0] = implode('.', $t);
                         $order .= $of[0];
                     } else {
-                        $order .= '`'.$of[0].'`';
+                        $order .= '`' . $of[0] . '`';
                     }
-                    $order .= ' '.($of[1] ? 'asc' : 'desc');
+                    $order .= ' ' . ($of[1] ? 'asc' : 'desc');
                 } else {
                     $order .= $of[0];
                 }
                 ++$i;
             }
         }
-        $string = sprintf('select %1$s from %2$s%7$s%3$s%6$s%4$s%5$s', implode(', ', $_read_fields), implode(', ', $this->_table_names), count($this->_conditions) > 0 ? (' where '.implode(' and ', $this->_conditions)) : null, $order, $limit, $group, $joins);
+        $string = sprintf('select %1$s from %2$s%7$s%3$s%6$s%4$s%5$s', implode(', ', $_read_fields), implode(', ', $this->_table_names), count($this->_conditions) > 0 ? (' where ' . implode(' and ', $this->_conditions)) : null, $order, $limit, $group, $joins);
 
         return $string;
     }
@@ -234,10 +234,10 @@ 
         }
         $updates = array();
         for ($d = 0, $m = count($this->_write_fields); $d < $m; ++$d) {
-            $t = '`' . $this->_write_fields[$d].'`=';
+            $t = '`' . $this->_write_fields[$d] . '`=';
             switch ($this->_write_field_types[$d]) {
             case 0:
-              $t .= "'".$this->_write_values[$d]."'";
+              $t .= "'" . $this->_write_values[$d] . "'";
               break;
           default:
               $t .= $this->_write_values[$d];
@@ -247,9 +247,9 @@ 
         $update_fields = implode(', ', $updates);
         $limit = null;
         if ($this->limit > 0) {
-            $limit = ' limit '.($this->limit_offset != -1 ? $this->limit_offset.', ' : null).$this->limit;
+            $limit = ' limit ' . ($this->limit_offset != -1 ? $this->limit_offset . ', ' : null) . $this->limit;
         }
-        $where = count($this->_conditions) > 0 ? (' where '.implode(' and ', $this->_conditions)) : null;
+        $where = count($this->_conditions) > 0 ? (' where ' . implode(' and ', $this->_conditions)) : null;
         $string = sprintf('update %1$s set %2$s %3$s %4$s', $this->_table_names[0], $update_fields, $where, $limit);
 
         return $string;
@@ -264,12 +264,12 @@ 
             throw new \Exception('Specify at least 1 write field (set function)');
         }
         $table = $this->_table_names[0];
-        $fields = '`'.implode('`, `', $this->_write_fields).'`';
+        $fields = '`' . implode('`, `', $this->_write_fields) . '`';
         $values = array();
         for ($d = 0, $m = count($this->_write_fields); $d < $m; ++$d) {
             switch ($this->_write_field_types[$d]) {
             case 0:
-              $values[] = "'".$this->_write_values[$d]."'";
+              $values[] = "'" . $this->_write_values[$d] . "'";
               break;
             default:
               $values[] = $this->_write_values[$d];
@@ -286,10 +286,10 @@ 
             throw new \Exception('Specify at least 1 table name');
         }
         $table = $this->_table_names[0];
-        $where = count($this->_conditions) > 0 ? (' where '.implode(' and ', $this->_conditions)) : null;
+        $where = count($this->_conditions) > 0 ? (' where ' . implode(' and ', $this->_conditions)) : null;
         $limit = null;
         if ($this->limit > 0) {
-            $limit = ' limit '.($this->limit_offset != -1 ? $this->limit_offset.', ' : null).$this->limit;
+            $limit = ' limit ' . ($this->limit_offset != -1 ? $this->limit_offset . ', ' : null) . $this->limit;
         }
         $string = sprintf('delete from %1$s %2$s %3$s', $table, $where, $limit);