adumitru68 / QueryBuilder

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 ];

Braces +21 added lines, -14 removed lines

@@ -67,8 +67,9 @@ 
 	public function getRowById( $id, array $fields = [] ) {
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::select( $this->table )->fields( $fields );
-		foreach ( $conditions as $field => $value )
-			$result->whereEqual( $field, $value );
+		foreach ( $conditions as $field => $value ) {
+					$result->whereEqual( $field, $value );
+		}
 
 		return $result->first()->execute();
 	}
@@ -82,8 +83,9 @@ 
 	public function deleteRowById( $id ) {
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::delete( $this->table );
-		foreach ( $conditions as $field => $value )
-			$result->whereEqual( $field, $value );
+		foreach ( $conditions as $field => $value ) {
+					$result->whereEqual( $field, $value );
+		}
 
 		return $result->execute();
 	}
@@ -97,8 +99,9 @@ 
 	public function updateRowById( $id, array $arrayUpdater ) {
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::update( $this->table );
-		foreach ( $conditions as $field => $value )
-			$result->whereEqual( $field, $value );
+		foreach ( $conditions as $field => $value ) {
+					$result->whereEqual( $field, $value );
+		}
 		$result->setFieldsByArray( $arrayUpdater );
 
 		return $result->execute();
@@ -120,8 +123,9 @@ 
 	 * @throws QueryException
 	 */
 	public function getMaxOrder( $nullToZero = false ) {
-		if ( empty( $this->orderField ) )
-			throw new QueryException( 'Order field is not defined' );
+		if ( empty( $this->orderField ) ) {
+					throw new QueryException( 'Order field is not defined' );
+		}
 
 		$result = QueryBuild::select( $this->table )
 			->fieldExpression( "MAX(`{$this->orderField}`)", "max_order_column_alias" )
@@ -142,8 +146,9 @@ 
 	 * @throws QueryException
 	 */
 	public function saveOrder( $updates_ord = array() ) {
-		if ( empty( $this->orderField ) )
-			throw new QueryException( 'Order field is not defined' );
+		if ( empty( $this->orderField ) ) {
+					throw new QueryException( 'Order field is not defined' );
+		}
 
 		$query = /** @lang text */
 			"UPDATE `{$this->table}` SET `{$this->orderField}` = CASE `{$this->primary[0]}` \r\n";
@@ -166,13 +171,15 @@ 
 
 		$id = (array)$id;
 
-		if ( count( $this->primary ) !== count( $id ) )
-			throw new QueryException( 'Invalid primary key', QueryException::QUERY_CRUD_INVALID_PRIMARY );
+		if ( count( $this->primary ) !== count( $id ) ) {
+					throw new QueryException( 'Invalid primary key', QueryException::QUERY_CRUD_INVALID_PRIMARY );
+		}
 
 		$conditions = [];
 
-		foreach ( $this->primary as $index => $key )
-			$conditions[ $key ] = $id[ $index ];
+		foreach ( $this->primary as $index => $key ) {
+					$conditions[ $key ] = $id[ $index ];
+		}
 
 		return $conditions;
 	}

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 );
 		}
 	}
 

src/Dependencies/QueryStructure.php

Spacing +8 added lines, -8 removed lines

@@ -60,7 +60,7 @@ 
 	/**
 	 * @var array
 	 */
-	private static $usedInstanceIds = [];
+	private static $usedInstanceIds = [ ];
 
 	/**
 	 * @var array
@@ -97,7 +97,7 @@ 
 			self::EXPLAIN => 0,
 			self::STATEMENT => '',
 			self::PRIORITY => '',
-			self::FIELDS => [],
+			self::FIELDS => [ ],
 			self::SET_FIELDS => array(),
 			self::WHERE => array(),
 			self::HAVING => array(),
@@ -132,7 +132,7 @@ 
 		while ( in_array( $instance, self::$usedInstanceIds ) ) {
 			$instance = QueryHelper::random( 5 );
 		}
-		self::$usedInstanceIds[] = $instance;
+		self::$usedInstanceIds[ ] = $instance;
 
 		return $instance;
 	}
@@ -179,7 +179,7 @@ 
 			return true;
 
 		if ( $this->typeEL[ $name ] === self::ELEMENT_TYPE_ARRAY )
-			$this->syntaxEL[ $name ][] = $value;
+			$this->syntaxEL[ $name ][ ] = $value;
 		else
 			$this->syntaxEL[ $name ] = $value;
 
@@ -226,7 +226,7 @@ 
 	 * @param string $search
 	 * @return string
 	 */
-	public function bindParamsExpression( $expression, array $params = [], $search = '?' )
+	public function bindParamsExpression( $expression, array $params = [ ], $search = '?' )
 	{
 		if ( !count( $params ) )
 			return $expression;
@@ -237,12 +237,12 @@ 
 		$params = array_slice( $params, 0, substr_count( $expression, $search ) );
 
 		$i = 0;
-		$arrayReturn = [];
+		$arrayReturn = [ ];
 		$expressionToArray = explode( $search, $expression );
 
 		foreach ( $expressionToArray as $sub ) {
-			$arrayReturn[] = $sub;
-			$arrayReturn[] = array_key_exists( $i, $params ) ? $this->bindParam( 'exp', $params[ $i ] ) : '';
+			$arrayReturn[ ] = $sub;
+			$arrayReturn[ ] = array_key_exists( $i, $params ) ? $this->bindParam( 'exp', $params[ $i ] ) : '';
 			$i++;
 		}
 

src/Traits/SelectFields.php

Spacing +3 added lines, -3 removed lines

@@ -62,11 +62,11 @@ 
 
 	private function normalizeFields( $fields ) {
 		$array = Arrays::flattenValues( $fields );
-		$array = (array)$array;
+		$array = ( array ) $array;
 		$return = array();
 		array_walk_recursive( $array, function( $a ) use ( &$return ) {
 			$a = explode( ',', $a );
-			$return[] = $a;
+			$return[ ] = $a;
 		} );
 
 		return $return;
@@ -80,7 +80,7 @@ 
 			return '*';
 		}
 
-		return implode( ', ', $this->queryStructure->getElement( QueryStructure::FIELDS ));
+		return implode( ', ', $this->queryStructure->getElement( QueryStructure::FIELDS ) );
 	}
 
 }
\ No newline at end of file

src/Traits/SetFields.php

Spacing +2 added lines, -2 removed lines

@@ -28,9 +28,9 @@
 	 */
 	public function setField( $fieldName, $fieldValue )
 	{
-		$fieldName = $this->queryStructure->prepare($fieldName);
+		$fieldName = $this->queryStructure->prepare( $fieldName );
 		$valuePdoString = $this->queryStructure->bindParam( $fieldName, $fieldValue );
-		$this->queryStructure->setElement( QueryStructure::SET_FIELDS, $this->queryStructure->prepare($fieldName) . " = $valuePdoString" );
+		$this->queryStructure->setElement( QueryStructure::SET_FIELDS, $this->queryStructure->prepare( $fieldName ) . " = $valuePdoString" );
 
 		return $this;
 	}