adumitru68 / QueryBuilder

src/Traits/InsertMultiple.php

Braces +18 added lines, -12 removed lines

@@ -29,8 +29,9 @@ 
     {
         $this->setFieldsList($fieldsList);
 
-        foreach ($rowsForInsert as $row)
-            $this->addSingleRow($row);
+        foreach ($rowsForInsert as $row) {
+                    $this->addSingleRow($row);
+        }
 
         return $this;
     }
@@ -45,8 +46,9 @@ 
     {
         $this->setFieldsList($fieldsList);
 
-        foreach ($query->getBindParams() as $key => $value)
-            $this->queryStructure->setParams($key, $value);
+        foreach ($query->getBindParams() as $key => $value) {
+                    $this->queryStructure->setParams($key, $value);
+        }
 
         $this->queryStructure->replaceElement(QueryStructure::SET_FIELDS, $query);
 
@@ -59,8 +61,9 @@ 
      */
     private function setFieldsList($fieldList)
     {
-        if (!is_array($fieldList))
-            $fieldList = QueryHelper::explode($fieldList);
+        if (!is_array($fieldList)) {
+                    $fieldList = QueryHelper::explode($fieldList);
+        }
 
         $this->queryStructure->replaceElement(QueryStructure::FIELDS, $fieldList);
 
@@ -74,13 +77,15 @@ 
     private function addSingleRow(array $rowValues)
     {
 
-        if ($this->getNumberOfFields() !== count($rowValues))
-            throw new QueryException('Ivalid number of fields.', QueryException::QUERY_ERROR_INVALID_FIELDS_COUNT);
+        if ($this->getNumberOfFields() !== count($rowValues)) {
+                    throw new QueryException('Ivalid number of fields.', QueryException::QUERY_ERROR_INVALID_FIELDS_COUNT);
+        }
 
         $pdoRowValues = array();
 
-        foreach ($rowValues as $value)
-            $pdoRowValues[] = $this->queryStructure->bindParam('value', $value);
+        foreach ($rowValues as $value) {
+                    $pdoRowValues[] = $this->queryStructure->bindParam('value', $value);
+        }
 
         $pdoRowValuesString = '( ' . QueryHelper::implode($pdoRowValues, ', ') . ' )';
 
@@ -94,8 +99,9 @@ 
      */
     private function getInsertMultipleRowsSyntax()
     {
-        if (is_a($this->queryStructure->getElement(QueryStructure::SET_FIELDS), QuerySelect::class))
-            return $this->getSyntaxWithSelect();
+        if (is_a($this->queryStructure->getElement(QueryStructure::SET_FIELDS), QuerySelect::class)) {
+                    return $this->getSyntaxWithSelect();
+        }
 
         $fields = '( ' . QueryHelper::implode($this->queryStructure->getElement(QueryStructure::FIELDS), ', ') . ' )';
         $values = QueryHelper::implode($this->queryStructure->getElement(QueryStructure::SET_FIELDS), ', ');

src/Traits/SelectFields.php

Braces +16 added lines, -10 removed lines

@@ -30,17 +30,21 @@ 
 
                 $fields = $this->prepareArrayFields($fields);
 
-                if (count($fields))
-                    $this->queryStructure->setElement(QueryStructure::FIELDS, implode(', ', $fields)); else
-                    $this->queryStructure->setElement(QueryStructure::FIELDS, '*');
+                if (count($fields)) {
+                                    $this->queryStructure->setElement(QueryStructure::FIELDS, implode(', ', $fields));
+                } else {
+                                        $this->queryStructure->setElement(QueryStructure::FIELDS, '*');
+                    }
                 break;
 
             case QueryStructure::ELEMENT_TYPE_STRING:
 
                 $fields = trim($fields);
-                if ('' !== $fields)
-                    $this->queryStructure->setElement(QueryStructure::FIELDS, $fields); else
-                    $this->queryStructure->setElement(QueryStructure::FIELDS, '*');
+                if ('' !== $fields) {
+                                    $this->queryStructure->setElement(QueryStructure::FIELDS, $fields);
+                } else {
+                                        $this->queryStructure->setElement(QueryStructure::FIELDS, '*');
+                    }
                 break;
 
             default:
@@ -61,11 +65,13 @@ 
         $prepareArray = [];
 
         foreach ($fieldsArray as $field) {
-            if (gettype($field) !== QueryStructure::ELEMENT_TYPE_STRING)
-                throw new QueryException('Invalid select field type!', QueryException::QUERY_ERROR_SELECT_INVALID_FIELD);
+            if (gettype($field) !== QueryStructure::ELEMENT_TYPE_STRING) {
+                            throw new QueryException('Invalid select field type!', QueryException::QUERY_ERROR_SELECT_INVALID_FIELD);
+            }
 
-            if ('' !== trim($field))
-                $prepareArray[] = trim($field);
+            if ('' !== trim($field)) {
+                            $prepareArray[] = trim($field);
+            }
         }
 
         return $prepareArray;

src/Traits/GroupBy.php

Braces +9 added lines, -6 removed lines

@@ -28,8 +28,9 @@ 
     {
         $column = trim($column);
 
-        if (!$this->validateColumn($column, $allowedColumns))
-            throw new QueryException('Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        if (!$this->validateColumn($column, $allowedColumns)) {
+                    throw new QueryException('Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        }
 
         $this->queryStructure->setElement(QueryStructure::GROUP_BY, $column);
 
@@ -47,8 +48,9 @@ 
     {
         $column = trim($column);
 
-        if (!$this->validateColumn($column, $allowedColumns))
-            throw new QueryException('Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        if (!$this->validateColumn($column, $allowedColumns)) {
+                    throw new QueryException('Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        }
 
         $this->queryStructure->setElement(QueryStructure::GROUP_BY, $column . ' DESC');
 
@@ -73,8 +75,9 @@ 
      */
     private function getGroupBySyntax()
     {
-        if (count($this->queryStructure->getElement(QueryStructure::GROUP_BY)))
-            return 'GROUP BY ' . QueryHelper::implode($this->queryStructure->getElement(QueryStructure::GROUP_BY), ', ');
+        if (count($this->queryStructure->getElement(QueryStructure::GROUP_BY))) {
+                    return 'GROUP BY ' . QueryHelper::implode($this->queryStructure->getElement(QueryStructure::GROUP_BY), ', ');
+        }
 
         return '';
     }

src/Traits/Replacement.php

Braces +3 added lines, -2 removed lines

@@ -27,8 +27,9 @@
     {
         $syntax = QueryHelper::clearMultipleSpaces($syntax);
 
-        if (!$withReplacement)
-            return $syntax;
+        if (!$withReplacement) {
+                    return $syntax;
+        }
 
         return $this->replaceValues($syntax);
     }

src/Traits/WhereAndHavingBuilder.php

Braces +14 added lines, -9 removed lines

@@ -55,9 +55,11 @@ 
             case 'IN':
             case 'NOT IN':
             case '!IN':
-                if (is_a($value, QuerySelect::class))
-                    return $this->inSelectObject($field, $value, $operator, $glue, $clauseType); elseif (is_array($value))
-                    return $this->inArray($field, $value, $operator, $glue, $clauseType);
+                if (is_a($value, QuerySelect::class)) {
+                                    return $this->inSelectObject($field, $value, $operator, $glue, $clauseType);
+                } elseif (is_array($value)) {
+                                        return $this->inArray($field, $value, $operator, $glue, $clauseType);
+                    }
                 break;
 
             default:
@@ -138,8 +140,9 @@ 
      */
     private function getWhereAndHavingSyntax($clauseType)
     {
-        if (count($this->queryStructure->getElement($clauseType)) == 0)
-            return '';
+        if (count($this->queryStructure->getElement($clauseType)) == 0) {
+                    return '';
+        }
 
         $where = '';
         $last_type = 'where_start';
@@ -168,11 +171,13 @@ 
      */
     private function validateWhereParam($param)
     {
-        if (count($param) < 2)
-            throw new QueryException('Invalid where array!', QueryException::QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY);
+        if (count($param) < 2) {
+                    throw new QueryException('Invalid where array!', QueryException::QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY);
+        }
 
-        if (count($param) == 2)
-            $param[] = '=';
+        if (count($param) == 2) {
+                    $param[] = '=';
+        }
 
         $param[2] = trim(strtoupper($param[2]));
         $param[2] = QueryHelper::clearMultipleSpaces($param[2]);

src/Traits/SetFields.php

Braces +6 added lines, -4 removed lines

@@ -48,8 +48,9 @@ 
      */
     public function setFieldsByArray(array $updateFieldsArray)
     {
-        foreach ($updateFieldsArray as $fieldName => $fieldValue)
-            $this->setField($fieldName, $fieldValue);
+        foreach ($updateFieldsArray as $fieldName => $fieldValue) {
+                    $this->setField($fieldName, $fieldValue);
+        }
 
         return $this;
     }
@@ -59,8 +60,9 @@ 
      */
     private function getSettingFieldsSyntax()
     {
-        if (!count($this->queryStructure->getElement(QueryStructure::SET_FIELDS)))
-            return '';
+        if (!count($this->queryStructure->getElement(QueryStructure::SET_FIELDS))) {
+                    return '';
+        }
 
         return 'SET ' . implode(', ', $this->queryStructure->getElement(QueryStructure::SET_FIELDS));
     }

src/Traits/OrderBy.php

Braces +9 added lines, -6 removed lines

@@ -28,8 +28,9 @@ 
     {
         $column = trim($column);
 
-        if (!$this->validateColumn($column, $allowedColumns))
-            throw new QueryException('Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        if (!$this->validateColumn($column, $allowedColumns)) {
+                    throw new QueryException('Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        }
 
         $this->queryStructure->setElement(QueryStructure::ORDER_BY, $column);
 
@@ -47,8 +48,9 @@ 
     {
         $column = trim($column);
 
-        if (!$this->validateColumn($column, $allowedColumns))
-            throw new QueryException('Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        if (!$this->validateColumn($column, $allowedColumns)) {
+                    throw new QueryException('Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME);
+        }
 
         $this->queryStructure->setElement(QueryStructure::ORDER_BY, $column . ' DESC');
 
@@ -73,8 +75,9 @@ 
      */
     private function getOrderBySyntax()
     {
-        if (count($this->queryStructure->getElement(QueryStructure::ORDER_BY)))
-            return 'ORDER BY ' . QueryHelper::implode($this->queryStructure->getElement(QueryStructure::ORDER_BY), ', ');
+        if (count($this->queryStructure->getElement(QueryStructure::ORDER_BY))) {
+                    return 'ORDER BY ' . QueryHelper::implode($this->queryStructure->getElement(QueryStructure::ORDER_BY), ', ');
+        }
 
         return '';
     }

src/Traits/Join.php

Braces +5 added lines, -3 removed lines

@@ -116,9 +116,11 @@
     {
         $join = $typeJoin . ' ' . $tableJoin;
 
-        if (is_null($onRight))
-            $join .= " USING ( $onLeft )"; else
-            $join .= " ON $onLeft = $onRight";
+        if (is_null($onRight)) {
+                    $join .= " USING ( $onLeft )";
+        } else {
+                        $join .= " ON $onLeft = $onRight";
+            }
 
         $this->queryStructure->setElement(QueryStructure::JOIN, $join);
 

src/Traits/TableValidation.php

Braces +12 added lines, -8 removed lines

@@ -45,22 +45,26 @@
     {
         $table = trim($table);
 
-        if ('' === $table)
-            throw new QueryException('Table name is empty string!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT);
+        if ('' === $table) {
+                    throw new QueryException('Table name is empty string!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT);
+        }
 
-        if (DbConfig::getInstance()->useTablePrefix())
-            $table = str_ireplace('::', DbConfig::getInstance()->getTablePrefix(), $table);
+        if (DbConfig::getInstance()->useTablePrefix()) {
+                    $table = str_ireplace('::', DbConfig::getInstance()->getTablePrefix(), $table);
+        }
 
         return $table;
     }
 
     private function validateTableSubQuery($table)
     {
-        if ($this->statement !== QueryStatement::QUERY_STATEMENT_SELECT)
-            throw new QueryException('Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT);
+        if ($this->statement !== QueryStatement::QUERY_STATEMENT_SELECT) {
+                    throw new QueryException('Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT);
+        }
 
-        if (!is_a($table, QuerySelect::class))
-            throw new QueryException('Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT);
+        if (!is_a($table, QuerySelect::class)) {
+                    throw new QueryException('Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT);
+        }
 
         return $table;
     }