brunobmorais / php-database

src/ModelAbstract.php

Spacing +1 added lines, -1 removed lines

@@ -87,7 +87,7 @@
         }
 
         return $classname . ' {' . implode(', ', array_map(
-            function ($p_0) use ($data) {
+            function($p_0) use ($data) {
                 $p_0->setAccessible(true);
 
                 return $p_0->getName() . ': ' . $p_0->getValue($data);

Indentation +2 added lines, -2 removed lines

@@ -49,8 +49,8 @@
     }
 
     /**
-    * @param $objArray
-    * @return array|null
+     * @param $objArray
+     * @return array|null
      */
     public function toMap($objArray = null): ?array
     {

src/Crud.php

Spacing +4 added lines, -4 removed lines

@@ -27,7 +27,7 @@ 
      */

     public function select(string $fields = '*', string $add = '', array $values = null, bool $returnModel = false, bool $debug = false)

     {

-        if (strlen($add) > 0) {

+        if (strlen($add)>0) {

             $add = ' ' . $add;

         }

 

@@ -66,7 +66,7 @@ 
         $numparams = substr($numparams, 1);

         $sql = "INSERT INTO {$this->getTable()} ({$fields}) VALUES ({$numparams})";

         if ($debug) {

-            echo $sql.'<pre>'.print_r($values).'</pre>';

+            echo $sql . '<pre>' . print_r($values) . '</pre>';

             return;

         }

         $result = $this->executeSQL($sql, $values);

@@ -148,7 +148,7 @@ 
             $sql .= " WHERE $where";

         }

         if ($debug) {

-            echo $sql.'<pre>'.print_r($values).'</pre>';

+            echo $sql . '<pre>' . print_r($values) . '</pre>';

             return;

         }

         $result = $this->executeSQL($sql, $values);

@@ -223,7 +223,7 @@ 
             $sql .= " WHERE $where";

         }

         if ($debug) {

-            echo $sql.'<pre>'.print_r($values).'</pre>';

+            echo $sql . '<pre>' . print_r($values) . '</pre>';

             return;

         }

         $result = $this->executeSQL($sql, $values);

Braces +3 added lines, -2 removed lines

@@ -33,8 +33,9 @@
 

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

 

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

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

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

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

+        }

 

         $sql .= "{$add}";

 

src/DatalayerTrait.php

Braces +3 added lines, -2 removed lines

@@ -132,8 +132,9 @@
      */
     protected function setTable(string $tableName, string $tableAlias = ""): self
     {
-        if (!empty($tableAlias))
-            $this->tableAlias = $tableAlias;
+        if (!empty($tableAlias)) {

+                    $this->tableAlias = $tableAlias;

+        }

         $this->tableName = $tableName;
         return $this;
     }

Indentation +11 added lines, -11 removed lines

@@ -142,9 +142,9 @@ 
     }
 
     /**
-        * @param string $tableName
-        * @param string $tableAlias
-        * @return CrudBuilder|Crud|DatalayerTrait
+     * @param string $tableName
+     * @param string $tableAlias
+     * @return CrudBuilder|Crud|DatalayerTrait
      */
     protected function setTable(string $tableName, string $tableAlias = ""): self
     {
@@ -199,7 +199,7 @@ 
 
     protected function getResult(): array
     {
-       return $this->resultArray;
+        return $this->resultArray;
     }
 
     protected function setResult(array $array): self
@@ -209,9 +209,9 @@ 
     }
 
     /**
-        * @param string $query
-        * @param array|null $params
-        * @return PDOStatement|void
+     * @param string $query
+     * @param array|null $params
+     * @return PDOStatement|void
      */
     protected function executeSQL(string $query, ?array $params = null)
     {
@@ -239,8 +239,8 @@ 
     }
 
     /**
-    * @param PDOStatement|null $prepare
-    * @return array|null
+     * @param PDOStatement|null $prepare
+     * @return array|null
      */
     protected function fetchArrayAssoc(PDOStatement $prepare = null): ?array
     {
@@ -303,8 +303,8 @@ 
     }
 
     /**
-    * @param PDOStatement|null $prepare
-    * @return stdClass|null
+     * @param PDOStatement|null $prepare
+     * @return stdClass|null
      */
     protected function fetchOneObj(PDOStatement $prepare = null): ?stdClass
     {

Spacing +4 added lines, -4 removed lines

@@ -72,7 +72,7 @@ 
     {
         try {
             if (strpos($_SERVER['SERVER_NAME'], mb_strtolower(CONFIG_DATA_LAYER["homologation"])) && !strpos($this->getDatabase(), ucfirst(CONFIG_DATA_LAYER["homologation"]))) {
-                $database = $this->getDatabase().ucfirst(CONFIG_DATA_LAYER["homologation"] ?? "");
+                $database = $this->getDatabase() . ucfirst(CONFIG_DATA_LAYER["homologation"] ?? "");
                 $this->setDatabase($database);
             }
 
@@ -115,13 +115,13 @@ 
     protected function setDatabase(string $database): self
     {
         if (strpos($_SERVER['SERVER_NAME'], mb_strtolower(CONFIG_DATA_LAYER["homologation"])) && !strpos($database, ucfirst(CONFIG_DATA_LAYER["homologation"]))) {
-            $database = $database.ucfirst(CONFIG_DATA_LAYER["homologation"] ?? "");
+            $database = $database . ucfirst(CONFIG_DATA_LAYER["homologation"] ?? "");
             $this->database = $database;
         } else {
             $this->database = $database;
         }
 
-        if (!empty($this->instance)){
+        if (!empty($this->instance)) {
             $this->executeSQL("USE {$this->getDatabase()}");
         }
 
@@ -248,7 +248,7 @@ 
             $prepare = empty($prepare) ? $this->getPrepare() : $prepare;
             return $prepare->rowCount();
         } catch (PDOException $e) {
-            $this->setError($e);}
+            $this->setError($e); }
     }
 
     /**

src/CrudBuilder.php

Spacing +14 added lines, -14 removed lines

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

     {

         try {

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

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

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

             return $this;

         } catch (\PDOException $e) {

@@ -197,7 +197,7 @@ 
     protected function addOrderBy(string $parameter, $order = null): self

     {

         try {

-            $query = ", {$parameter} ".($order ?? 'ASC')." ";

+            $query = ", {$parameter} " . ($order ?? 'ASC') . " ";

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

             return $this;

         } catch (\PDOException $e) {

@@ -212,7 +212,7 @@ 
     protected function limit(string $texto): self

     {

         $query = "LIMIT {$texto}";

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

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

         return $this;

     }

 

@@ -224,7 +224,7 @@ 
     {

         try {

             $query = "OFFSET {$texto}";

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

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

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -239,7 +239,7 @@ 
     {

         try {

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

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

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

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -254,7 +254,7 @@ 
     {

         try {

             $query = "HAVING {$texto}";

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

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

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -269,7 +269,7 @@ 
     {

         try {

             $query = "AND {$texto}";

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

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

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -284,7 +284,7 @@ 
     {

         try {

             $query = "OR {$codition}";

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

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

             return $this;

         } catch (\PDOException $e) {

             $this->setError($e);

@@ -301,7 +301,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);

@@ -318,7 +318,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);

@@ -335,7 +335,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);

@@ -348,9 +348,9 @@ 
     protected 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 {

@@ -421,7 +421,7 @@ 
      */

     private function add(string $query, string $type, array $params = []): void

     {

-        $query = $query." ";

+        $query = $query . " ";

         try {

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

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

Indentation +60 added lines, -60 removed lines

@@ -17,7 +17,7 @@ 
     use DatalayerTrait;

 

     /**

-    * @var array

+     * @var array

      */

     private array $sqlPartsSelect = [

         'main'      => [],

@@ -37,13 +37,13 @@ 
 

     /**

      *

-    * <code>

-    *   $qb = $this->select('u.id, p.id')

-    *           ->where('phonenumbers=?', [$number]);

-    * </code>

-    * @param string $fields

-    * @param array $paramns

-    * @return $this

+     * <code>

+     *   $qb = $this->select('u.id, p.id')

+     *           ->where('phonenumbers=?', [$number]);

+     * </code>

+     * @param string $fields

+     * @param array $paramns

+     * @return $this

      */

     public function selectBuilder(string $fields = "*", array $paramns = []): self

     {

@@ -59,9 +59,9 @@ 
     }

 

     /**

-    * @param string $fields

-    * @param array $paramns

-    * @return $this

+     * @param string $fields

+     * @param array $paramns

+     * @return $this

      */

     protected function insertBuilder(string $fields, array $paramns): self

     {

@@ -80,9 +80,9 @@ 
     }

 

     /**

-    * @param string $fields

-    * @param array $paramns

-    * @return $this

+     * @param string $fields

+     * @param array $paramns

+     * @return $this

      */

     protected function updateBuilder(string $fields, array $paramns): self

     {

@@ -103,9 +103,9 @@ 
     }

 

     /**

-    * @param string $fields

-    * @param array $paramns

-    * @return $this

+     * @param string $fields

+     * @param array $paramns

+     * @return $this

      */

     protected function deleteBuilder(): self

     {

@@ -119,9 +119,9 @@ 
     }

 

     /**

-    * @param string $query

-    * @param array $paramns

-    * @return $this

+     * @param string $query

+     * @param array $paramns

+     * @return $this

      */

     protected function query(string $query, array $paramns = []): self

     {

@@ -134,9 +134,9 @@ 
     }

 

     /**

-    * @param string $texto

-    * @param array $paramns

-    * @return $this

+     * @param string $texto

+     * @param array $paramns

+     * @return $this

      */

     protected function where(string $texto, array $paramns = []): self

     {

@@ -150,9 +150,9 @@ 
     }

 

     /**

-    * @param string $condition

-    * @param array $paramns

-    * @return $this

+     * @param string $condition

+     * @param array $paramns

+     * @return $this

      */

     protected function andWhere(string $condition, array $paramns = []): self

     {

@@ -166,9 +166,9 @@ 
     }

 

     /**

-    * @param string $condition

-    * @param array $paramns

-    * @return $this

+     * @param string $condition

+     * @param array $paramns

+     * @return $this

      */

     protected function orWhere(string $condition, array $paramns = []): self

     {

@@ -182,9 +182,9 @@ 
     }

 

     /**

-    * @param string $parameter

-    * @param $order

-    * @return $this

+     * @param string $parameter

+     * @param $order

+     * @return $this

      */

     protected function orderBy(string $parameter, $order = null): self

     {

@@ -198,9 +198,9 @@ 
     }

 

     /**

-    * @param string $parameter

-    * @param $order

-    * @return $this

+     * @param string $parameter

+     * @param $order

+     * @return $this

      */

     protected function addOrderBy(string $parameter, $order = null): self

     {

@@ -214,8 +214,8 @@ 
     }

 

     /**

-    * @param string $texto

-    * @return $this

+     * @param string $texto

+     * @return $this

      */

     protected function limit(string $texto): self

     {

@@ -225,8 +225,8 @@ 
     }

 

     /**

-    * @param string $texto

-    * @return $this

+     * @param string $texto

+     * @return $this

      */

     protected function offset(string $texto): self

     {

@@ -240,8 +240,8 @@ 
     }

 

     /**

-    * @param string $texto

-    * @return $this

+     * @param string $texto

+     * @return $this

      */

     protected function groupBy(string $texto): self

     {

@@ -255,8 +255,8 @@ 
     }

 

     /**

-    * @param string $texto

-    * @return $this

+     * @param string $texto

+     * @return $this

      */

     protected function having(string $texto): self

     {

@@ -300,10 +300,10 @@ 
     }

 

     /**

-    * @param string $table

-    * @param string $alias

-    * @param string $codition

-    * @return $this

+     * @param string $table

+     * @param string $alias

+     * @param string $codition

+     * @return $this

      */

     protected function innerJoin(string $table, string $alias, string $codition): self

     {

@@ -317,10 +317,10 @@ 
     }

 

     /**

-    * @param string $table

-    * @param string $alias

-    * @param string $codition

-    * @return $this

+     * @param string $table

+     * @param string $alias

+     * @param string $codition

+     * @return $this

      */

     protected function leftJoin(string $table, string $alias, string $codition): self

     {

@@ -334,10 +334,10 @@ 
     }

 

     /**

-    * @param string $table

-    * @param string $alias

-    * @param string $codition

-    * @return $this

+     * @param string $table

+     * @param string $alias

+     * @param string $codition

+     * @return $this

      */

     protected function rightJoin(string $table, string $alias, string $codition): self

     {

@@ -375,7 +375,7 @@ 
     }

 

     /**

-    * @return void

+     * @return void

      */

     protected function debug(): void

     {

@@ -389,10 +389,10 @@ 
 

 

     /**

-    * @param string $query

-    * @param string $type

-    * @param array $params

-    * @return void

+     * @param string $query

+     * @param string $type

+     * @param array $params

+     * @return void

      */

     private function add(string $query, string $type, array $params = []): void

     {

Braces +6 added lines, -4 removed lines

@@ -49,8 +49,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) {

@@ -404,8 +405,9 @@ 
                 $this->sqlPartsSelect[$type] = $query;

             }

 

-            if (!empty($params))

-                $this->setParameter($params);

+            if (!empty($params)) {

+                            $this->setParameter($params);

+            }

         } catch (\PDOException $e) {

             $this->setError($e);

         }

example/ExampleDao.php

Spacing +1 added lines, -1 removed lines

@@ -14,7 +14,7 @@
 

     public function findName(): array {

         $this->selectBuilder()

-            ->where("NOME=?",["Joao"])

+            ->where("NOME=?", ["Joao"])

             ->orderBy("NOME")

             ->executeQuery()

             ->fetchArrayAssoc();