CruzerSoftwares / Dolphin

src/Dolphin/Builders/InsertQueryBuilder.php

Spacing +21 added lines, -21 removed lines

@@ -17,48 +17,48 @@ 
  */
 class InsertQueryBuilder extends QueryBuilder
 {
-    public function buildInsert($table, $obj){
+    public function buildInsert($table, $obj) {
         $qb = new QueryBuilder();
         $query = "INSERT INTO ".$table." (";
-        foreach($obj as $key => $val){
-            $query.= $qb->quote($key).", ";
+        foreach ($obj as $key => $val) {
+            $query .= $qb->quote($key).", ";
         }
 
         $query = rtrim($query, ", ");
-        $query.= ") VALUES ";
+        $query .= ") VALUES ";
 
         return $query;
     }
 
-    public function buildInsertPlaceholder($rows){
+    public function buildInsertPlaceholder($rows) {
         $ar = array();
         $query = "(";
 
-        foreach($rows as $key => $val){
+        foreach ($rows as $key => $val) {
             $ar[$key] = $val;
-            $query.= ":".$key.", ";
+            $query .= ":".$key.", ";
         }
 
         $query = rtrim($query, ", ");
-        $query.=") ";
+        $query .= ") ";
 
         return ['query' => $query, 'array' => $ar];
     }
 
-    public function buildInsertPlaceholders($rows){
+    public function buildInsertPlaceholders($rows) {
         $bindAr = array();
         $query = "";
 
-        foreach($rows as $i => $row){
-            $query.="(";
-            foreach($row as $key => $val){
-                $param = ":" . $key . $i;
-                $query.= $param.", ";
+        foreach ($rows as $i => $row) {
+            $query .= "(";
+            foreach ($row as $key => $val) {
+                $param = ":".$key.$i;
+                $query .= $param.", ";
                 $bindAr[$param] = $val;
             }
 
             $query = rtrim($query, ", ");
-            $query.="), ";
+            $query .= "), ";
         }
 
         $query = rtrim($query, ", ");
@@ -82,21 +82,21 @@ 
         $dataToBuild = $rows;
         $methodToCall = 'buildInsertPlaceholder';
 
-        if(is_array($rows) && isset($rows[0]) && is_array($rows[0])){
+        if (is_array($rows) && isset($rows[0]) && is_array($rows[0])) {
             $dataToBuild = $rows[0];
             $methodToCall = 'buildInsertPlaceholders';
         }
 
         $query   = $this->buildInsert($table, $dataToBuild);
         $dataRet = $this->$methodToCall($rows);
-        $query.= $dataRet['query'];
+        $query .= $dataRet['query'];
         $bindAr = $dataRet['array'];
 
-        try{
+        try {
             $stmt = $db->prepare($qb->queryPrefix($query));
 
-            if(is_array($rows) && isset($rows[0]) && is_array($rows[0])){
-                foreach($bindAr as $param => $val){
+            if (is_array($rows) && isset($rows[0]) && is_array($rows[0])) {
+                foreach ($bindAr as $param => $val) {
                     $stmt->bindValue($param, $val);
                 }
 
@@ -106,7 +106,7 @@ 
 
             $stmt->execute($bindAr);
             return $db->lastInsertId();
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
     }

src/Dolphin/Save.php

Indentation +8 added lines, -8 removed lines

@@ -23,15 +23,15 @@
     }
 
     public function buildQueryStrSingleFromArr($row = array()){
-      $ar = [];
-      $query = "UPDATE ".$this->table." SET ";
-      foreach($row as $key => $val){
-          $ar[':'.$key] = $val;
-          if($key == 'id') continue;
-          $query.= $this->qb->quote($key)." =:".$key.",";
-      }
+        $ar = [];
+        $query = "UPDATE ".$this->table." SET ";
+        foreach($row as $key => $val){
+            $ar[':'.$key] = $val;
+            if($key == 'id') continue;
+            $query.= $this->qb->quote($key)." =:".$key.",";
+        }
 
-      return ['ar' => $ar, 'query' => $query];
+        return ['ar' => $ar, 'query' => $query];
     }
     public function createQuery($row){
         $ar = [];

Spacing +12 added lines, -12 removed lines

@@ -22,34 +22,34 @@ 
         $this->qb = new QueryBuilder();
     }
 
-    public function buildQueryStrSingleFromArr($row = array()){
+    public function buildQueryStrSingleFromArr($row = array()) {
       $ar = [];
       $query = "UPDATE ".$this->table." SET ";
-      foreach($row as $key => $val){
+      foreach ($row as $key => $val) {
           $ar[':'.$key] = $val;
-          if($key == 'id') continue;
-          $query.= $this->qb->quote($key)." =:".$key.",";
+          if ($key == 'id') continue;
+          $query .= $this->qb->quote($key)." =:".$key.",";
       }
 
       return ['ar' => $ar, 'query' => $query];
     }
-    public function createQuery($row){
+    public function createQuery($row) {
         $ar = [];
-        if(isset($row) && isset($row->id) && $row->id > 0 ){
+        if (isset($row) && isset($row->id) && $row->id > 0) {
             $query = "UPDATE ".$this->table." SET ";
             $mixedData = $this->buildQueryStrSingleFromArr($row);
             $query = rtrim($mixedData['query'], ",");
-            $query.= " WHERE ".$this->qb->quote('id')."=:id";
+            $query .= " WHERE ".$this->qb->quote('id')."=:id";
 
             return ['query' => $query, 'data' => $mixedData['ar']];
         }
 
         $queryVal = '';
         $query = "INSERT INTO ".$this->table." (";
-        foreach($row as $key => $val){
-            $query.= $this->qb->quote($key).", ";
+        foreach ($row as $key => $val) {
+            $query .= $this->qb->quote($key).", ";
             $ar[$key] = $val;
-            $queryVal.= ":".$key.", ";
+            $queryVal .= ":".$key.", ";
         }
 
         $query = rtrim($query, ", ").") VALUES (".$queryVal.rtrim($query, ", ").") ";
@@ -74,10 +74,10 @@ 
 
         list($query, $data) = $this->createQuery($row);
 
-        try{
+        try {
             $stmt = Connection::get()->prepare($this->qb->queryPrefix($query));
             $stmt->execute($data);
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
 

Braces +3 added lines, -1 removed lines

@@ -27,7 +27,9 @@
       $query = "UPDATE ".$this->table." SET ";
       foreach($row as $key => $val){
           $ar[':'.$key] = $val;
-          if($key == 'id') continue;
+          if($key == 'id') {
+              continue;
+          }
           $query.= $this->qb->quote($key)." =:".$key.",";
       }