adumitru68 / QueryBuilder

src/Statements/QueryDelete.php

Spacing +8 added lines, -8 removed lines

@@ -53,37 +53,37 @@ 
 		/**
 		 *  Explain
 		 */
-		$syntax[] = $this->getExplainSyntax();
+		$syntax[ ] = $this->getExplainSyntax();
 
 		/**
 		 * UPDATE statement
 		 */
-		$syntax[] = $this->statement;
+		$syntax[ ] = $this->statement;
 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
 		/**
 		 * TABLE update
 		 */
-		$syntax[] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[ ] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
 		/**
 		 * WHERE clause
 		 */
-		$syntax[] = $this->getWhereSyntax();
+		$syntax[ ] = $this->getWhereSyntax();
 
 		/**
 		 * ORDER BY clause
 		 */
-		$syntax[] = $this->getOrderBySyntax();
+		$syntax[ ] = $this->getOrderBySyntax();
 
 		/**
 		 * LIMIT clause
 		 */
-		$syntax[] = $this->getLimitSyntax();
+		$syntax[ ] = $this->getLimitSyntax();
 
 		$syntax = implode( ' ', $syntax );
 
@@ -99,7 +99,7 @@ 
 		if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) )
 			throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
 
-		return PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
+		return PdoWrapperService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) )->rowCount();
 	}
 
 

src/Statements/QueryInsert.php

Spacing +7 added lines, -7 removed lines

@@ -62,32 +62,32 @@ 
 		/**
 		 *  Explain
 		 */
-		$syntax[] = $this->getExplainSyntax();
+		$syntax[ ] = $this->getExplainSyntax();
 
 		/**
 		 * UPDATE statement
 		 */
-		$syntax[] = $this->statement;
+		$syntax[ ] = $this->statement;
 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
 		/**
 		 * IGNORE clause
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
 
 		/**
 		 * INTO table
 		 */
-		$syntax[] = 'INTO ' . $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[ ] = 'INTO ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
 		/**
 		 * FIELDS update
 		 */
-		$syntax[] = $this->getSettingFieldsSyntax();
+		$syntax[ ] = $this->getSettingFieldsSyntax();
 
 		$syntax = implode( ' ', $syntax );
 
@@ -99,7 +99,7 @@ 
 	 * @return bool|mixed|\PDOStatement
 	 */
 	public function execute() {
-		return PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
+		return PdoWrapperService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) )->rowCount();
 	}
 
 

src/Statements/QueryUpdate.php

Spacing +10 added lines, -10 removed lines

@@ -53,47 +53,47 @@ 
 		/**
 		 *  Explain
 		 */
-		$syntax[] = $this->getExplainSyntax();
+		$syntax[ ] = $this->getExplainSyntax();
 
 		/**
 		 * UPDATE statement
 		 */
-		$syntax[] = $this->statement;
+		$syntax[ ] = $this->statement;
 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
 		/**
 		 * IGNORE clause
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
 
 		/**
 		 * TABLE update
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::TABLE );
 
 		/**
 		 * FIELDS update
 		 */
-		$syntax[] = $this->getSettingFieldsSyntax();
+		$syntax[ ] = $this->getSettingFieldsSyntax();
 
 		/**
 		 * WHERE clause
 		 */
-		$syntax[] = $this->getWhereSyntax();
+		$syntax[ ] = $this->getWhereSyntax();
 
 		/**
 		 * ORDER BY clause
 		 */
-		$syntax[] = $this->getOrderBySyntax();
+		$syntax[ ] = $this->getOrderBySyntax();
 
 		/**
 		 * LIMIT clause
 		 */
-		$syntax[] = $this->getLimitSyntax();
+		$syntax[ ] = $this->getLimitSyntax();
 
 		$syntax = implode( ' ', $syntax );
 
@@ -110,6 +110,6 @@ 
 		if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) )
 			throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
 
-		return PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
+		return PdoWrapperService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) )->rowCount();
 	}
 }
\ No newline at end of file

src/Traits/Having.php

Spacing +2 added lines, -2 removed lines

@@ -305,7 +305,7 @@ 
 	 * @return $this
 	 * @throws \Qpdb\QueryBuilder\Dependencies\QueryException
 	 */
-	public function havingExpression( $whereString, array $bindParams = [], $glue = 'AND' )
+	public function havingExpression( $whereString, array $bindParams = [ ], $glue = 'AND' )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 
@@ -318,7 +318,7 @@ 
 	 * @return $this
 	 * @throws \Qpdb\QueryBuilder\Dependencies\QueryException
 	 */
-	public function orHavingExpression( $whereString, array $bindParams = [] )
+	public function orHavingExpression( $whereString, array $bindParams = [ ] )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 

src/Traits/TableValidation.php

Spacing +1 added lines, -1 removed lines

@@ -52,7 +52,7 @@
 		if ( '' === $table )
 			throw new QueryException( 'Table name is empty string!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
 
-		return QueryHelper::addBacktick($table);
+		return QueryHelper::addBacktick( $table );
 	}
 
 	/**

src/Traits/OrderBy.php

Spacing +4 added lines, -4 removed lines

@@ -26,12 +26,12 @@ 
 	 * @return $this
 	 * @throws QueryException
 	 */
-	public function orderBy( $column, array $allowedColumns = [] )
+	public function orderBy( $column, array $allowedColumns = [ ] )
 	{
 		if ( !$this->validateColumn( $column, $allowedColumns ) )
 			throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
 
-		$column = $this->queryStructure->prepare($column);
+		$column = $this->queryStructure->prepare( $column );
 		$this->queryStructure->setElement( QueryStructure::ORDER_BY, $column );
 
 		return $this;
@@ -44,12 +44,12 @@ 
 	 * @return $this
 	 * @throws QueryException
 	 */
-	public function orderByDesc( $column, array $allowedColumns = [] )
+	public function orderByDesc( $column, array $allowedColumns = [ ] )
 	{
 		if ( !$this->validateColumn( $column, $allowedColumns ) )
 			throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
 
-		$column = $this->queryStructure->prepare($column);
+		$column = $this->queryStructure->prepare( $column );
 		$this->queryStructure->setElement( QueryStructure::ORDER_BY, $column . ' DESC' );
 
 		return $this;

src/Traits/GroupBy.php

Spacing +4 added lines, -4 removed lines

@@ -26,12 +26,12 @@ 
 	 * @return $this
 	 * @throws QueryException
 	 */
-	public function groupBy( $column, array $allowedColumns = [] )
+	public function groupBy( $column, array $allowedColumns = [ ] )
 	{
 		if ( !$this->validateColumn( $column, $allowedColumns ) )
 			throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
 
-		$column = $this->queryStructure->prepare($column);
+		$column = $this->queryStructure->prepare( $column );
 		$this->queryStructure->setElement( QueryStructure::ORDER_BY, $column );
 
 		$this->queryStructure->setElement( QueryStructure::GROUP_BY, $column );
@@ -46,12 +46,12 @@ 
 	 * @return $this
 	 * @throws QueryException
 	 */
-	public function groupByDesc( $column, array $allowedColumns = [] )
+	public function groupByDesc( $column, array $allowedColumns = [ ] )
 	{
 		if ( !$this->validateColumn( $column, $allowedColumns ) )
 			throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
 
-		$column = $this->queryStructure->prepare($column);
+		$column = $this->queryStructure->prepare( $column );
 		$this->queryStructure->setElement( QueryStructure::ORDER_BY, $column );
 
 		$this->queryStructure->setElement( QueryStructure::GROUP_BY, $column . ' DESC' );

src/Abstracts/AbstractTableDao.php

Spacing +6 added lines, -6 removed lines

@@ -37,7 +37,7 @@ 
 	 */
 	public function __construct() {
 		$this->table = $this->getTableName();
-		$this->primary = (array)$this->getPrimaryKey();
+		$this->primary = ( array ) $this->getPrimaryKey();
 		$this->orderField = $this->getOrderField();
 	}
 
@@ -64,7 +64,7 @@ 
 	 * @return array|bool
 	 * @throws QueryException
 	 */
-	public function getRowById( $id, array $fields = [] ) {
+	public function getRowById( $id, array $fields = [ ] ) {
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::select( $this->table )->fields( $fields );
 		foreach ( $conditions as $field => $value )
@@ -146,14 +146,14 @@ 
 			throw new QueryException( 'Order field is not defined' );
 
 		$query = /** @lang text */
-			"UPDATE `{$this->table}` SET `{$this->orderField}` = CASE `{$this->primary[0]}` \r\n";
+			"UPDATE `{$this->table}` SET `{$this->orderField}` = CASE `{$this->primary[ 0 ]}` \r\n";
 		foreach ( $updates_ord as $position => $id ) {
 			$pos = $position + 1;
 			$query .= " WHEN '$id' THEN '$pos' \r\n";
 		}
 		$query .= "ELSE `{$this->orderField}` END";
 
-		return PdoWrapperService::getInstance()->query( $query, [] );
+		return PdoWrapperService::getInstance()->query( $query, [ ] );
 	}
 
 
@@ -164,12 +164,12 @@ 
 	 */
 	protected function getPrimaryKeyConditions( $id ) {
 
-		$id = (array)$id;
+		$id = ( array ) $id;
 
 		if ( count( $this->primary ) !== count( $id ) )
 			throw new QueryException( 'Invalid primary key', QueryException::QUERY_CRUD_INVALID_PRIMARY );
 
-		$conditions = [];
+		$conditions = [ ];
 
 		foreach ( $this->primary as $index => $key )
 			$conditions[ $key ] = $id[ $index ];

src/Statements/QuerySelect.php

Spacing +13 added lines, -13 removed lines

@@ -120,62 +120,62 @@ 
 		/**
 		 *  Explain
 		 */
-		$syntax[] = $this->getExplainSyntax();
+		$syntax[ ] = $this->getExplainSyntax();
 
 		/**
 		 * SELECT statement
 		 */
-		$syntax[] = $this->statement;
+		$syntax[ ] = $this->statement;
 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
 		/**
 		 * DISTINCT clause
 		 */
-		$syntax[] = $this->getDistinctSyntax();
+		$syntax[ ] = $this->getDistinctSyntax();
 
 		/**
 		 * FIELDS
 		 */
-		$syntax[] = $this->getSelectFieldsSyntax();
+		$syntax[ ] = $this->getSelectFieldsSyntax();
 
 		/**
 		 * FROM table or queryStructure
 		 */
-		$syntax[] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[ ] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
 		/**
 		 * JOIN CLAUSES
 		 */
-		$syntax[] = $this->getJoinSyntax();
+		$syntax[ ] = $this->getJoinSyntax();
 
 		/**
 		 * WHERE clause
 		 */
-		$syntax[] = $this->getWhereSyntax();
+		$syntax[ ] = $this->getWhereSyntax();
 
 		/**
 		 * GROUP BY clause
 		 */
-		$syntax[] = $this->getGroupBySyntax();
+		$syntax[ ] = $this->getGroupBySyntax();
 
 		/**
 		 * HAVING clause
 		 */
-		$syntax[] = $this->getHavingSyntax();
+		$syntax[ ] = $this->getHavingSyntax();
 
 		/**
 		 * ORDER BY clause
 		 */
-		$syntax[] = $this->getOrderBySyntax();
+		$syntax[ ] = $this->getOrderBySyntax();
 
 		/**
 		 * LIMIT clause
 		 */
-		$syntax[] = $this->getLimitSyntax();
+		$syntax[ ] = $this->getLimitSyntax();
 
 		$syntax = implode( ' ', $syntax );
 
@@ -200,7 +200,7 @@ 
 			case $this->queryStructure->getElement( QueryStructure::COLUMN ):
 				return PdoWrapperService::getInstance()->queryFetchAll( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ), \PDO::FETCH_COLUMN );
 			default:
-				return PdoWrapperService::getInstance()->queryFetchAll($this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ), \PDO::FETCH_ASSOC);
+				return PdoWrapperService::getInstance()->queryFetchAll( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ), \PDO::FETCH_ASSOC );
 		}
 	}