CruzerSoftwares / Dolphin

src/Dolphin/Builders/InsertQueryBuilder.php

Indentation +1 added lines, -1 removed lines

@@ -66,7 +66,7 @@
     }
 
     private function checkMultipleInsert($rows = array()){
-      return is_array($rows) && isset($rows[0]) && is_array($rows[0]);
+        return is_array($rows) && isset($rows[0]) && is_array($rows[0]);
     }
     /**
      * It inserts the new rows

Spacing +22 added lines, -22 removed lines

@@ -17,55 +17,55 @@ 
  */
 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, ", ");
         return ['query' => $query, 'array' => $bindAr];
     }
 
-    private function checkMultipleInsert($rows = array()){
+    private function checkMultipleInsert($rows = array()) {
       return is_array($rows) && isset($rows[0]) && is_array($rows[0]);
     }
     /**
@@ -85,21 +85,21 @@ 
         $dataToBuild = $rows;
         $methodToCall = 'buildInsertPlaceholder';
 
-        if($this->checkMultipleInsert($rows)){
+        if ($this->checkMultipleInsert($rows)) {
             $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($this->checkMultipleInsert($rows)){
-                foreach($bindAr as $param => $val){
+            if ($this->checkMultipleInsert($rows)) {
+                foreach ($bindAr as $param => $val) {
                     $stmt->bindValue($param, $val);
                 }
 
@@ -109,7 +109,7 @@ 
 
             $stmt->execute($bindAr);
             return $db->lastInsertId();
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
     }