brunobmorais / php-database

src/CrudBuilder.php

Spacing +13 added lines, -13 removed lines

@@ -186,7 +186,7 @@ 
     public function orderBy(string $texto, $order = null): self

     {

         try {

-            $query = "ORDER BY {$texto} ".($order ?? 'ASC')." ";

+            $query = "ORDER BY {$texto} " . ($order ?? 'ASC') . " ";

             $this->add($query, "orderBy");

             return $this;

         } catch (\PDOException $e) {

@@ -201,7 +201,7 @@ 
     public function limit(string $texto): self

     {

         $query = "LIMIT {$texto}";

-        $this->add($query,"limit");

+        $this->add($query, "limit");

         return $this;

     }

 

@@ -213,7 +213,7 @@ 
     {

         try {

             $query = "OFFSET {$texto}";

-            $this->add($query,"offset");

+            $this->add($query, "offset");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -228,7 +228,7 @@ 
     {

         try {

             $query = "GROUP BY {$texto}";

-            $this->add($query,"groupBy");

+            $this->add($query, "groupBy");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -243,7 +243,7 @@ 
     {

         try {

             $query = "HAVING {$texto}";

-            $this->add($query,"having");

+            $this->add($query, "having");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -258,7 +258,7 @@ 
     {

         try {

             $query = "AND {$texto}";

-            $this->add($query,"andHaving");

+            $this->add($query, "andHaving");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -273,7 +273,7 @@ 
     {

         try {

             $query = "OR {$codition}";

-            $this->add($query,"orHaving");

+            $this->add($query, "orHaving");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -290,7 +290,7 @@ 
     {

         try {

             $query = "INNER JOIN {$table} AS {$alias} ON $codition";

-            $this->add($query,"join");

+            $this->add($query, "join");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -307,7 +307,7 @@ 
     {

         try {

             $query = "LEFT JOIN {$table} AS {$alias} ON {$codition}";

-            $this->add($query,"join");

+            $this->add($query, "join");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -324,7 +324,7 @@ 
     {

         try {

             $query = "RIGHT JOIN {$table} AS {$alias} ON $codition";

-            $this->add($query,"join");

+            $this->add($query, "join");

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -337,9 +337,9 @@ 
     public function executeQuery(): self

     {

         try {

-            foreach ($this->sqlPartsSelect as $key => $part){

+            foreach ($this->sqlPartsSelect as $key => $part) {

                 if (is_array($part)) {

-                    foreach ($part as $item){

+                    foreach ($part as $item) {

                         $this->query .= $item;

                     }

                 } else {

@@ -400,7 +400,7 @@ 
 

     private function add(string $text, string $type, array $params = [])

     {

-        $text = $text." ";

+        $text = $text . " ";

         try {

             if (is_array($this->sqlPartsSelect[$type])) {

                 $this->sqlPartsSelect[$type][] = $text;

Braces +6 added lines, -4 removed lines

@@ -47,8 +47,9 @@ 
     {

         try {

             $query = "SELECT {$fields} FROM {$this->getTable()}";

-            if (!empty($this->getTableAlias()))

-                $query .= "AS {$this->getTableAlias()} ";

+            if (!empty($this->getTableAlias())) {

+                            $query .= "AS {$this->getTableAlias()} ";

+            }

             $this->add($query, "main", $paramns);

             return $this;

         } catch (\PDOException $e) {

@@ -408,8 +409,9 @@ 
                 $this->sqlPartsSelect[$type] = $text;

             }

 

-            if (!empty($params))

-                $this->params = array_merge($this->params, $params);

+            if (!empty($params)) {

+                            $this->params = array_merge($this->params, $params);

+            }

         } catch (\PDOException $e) {

             $this->setError($e);

         }