adumitru68 / QueryBuilder

src/Statements/QueryInsertMultiple.php

Spacing +6 added lines, -6 removed lines

@@ -49,32 +49,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->getInsertMultipleRowsSyntax();
+		$syntax[ ] = $this->getInsertMultipleRowsSyntax();
 
 		$syntax = implode( ' ', $syntax );
 

src/Dependencies/QueryStructure.php

Spacing +7 added lines, -7 removed lines

@@ -60,7 +60,7 @@ 
 	/**
 	 * @var array
 	 */
-	private static $usedInstanceIds = [];
+	private static $usedInstanceIds = [ ];
 
 	/**
 	 * @var array
@@ -132,7 +132,7 @@ 
 		while ( in_array( $instance, self::$usedInstanceIds ) ) {
 			$instance = QueryHelper::random( 7 );
 		}
-		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;
 
@@ -241,7 +241,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;
@@ -252,12 +252,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/Dependencies/QueryHelper.php

Spacing +1 added lines, -1 removed lines

@@ -88,7 +88,7 @@
 		foreach ( $brutArray as $value ) {
 			$value = trim( $value );
 			if ( '' !== $value )
-				$newArray[] = $value;
+				$newArray[ ] = $value;
 		}
 
 		return $newArray;

src/Traits/Where.php

Spacing +2 added lines, -2 removed lines

@@ -278,7 +278,7 @@ 
 	 * @param string $glue
 	 * @return $this
 	 */
-	public function whereExpression( $whereString, array $bindParams = [], $glue = 'AND' )
+	public function whereExpression( $whereString, array $bindParams = [ ], $glue = 'AND' )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 
@@ -290,7 +290,7 @@ 
 	 * @param array $bindParams
 	 * @return $this
 	 */
-	public function orWhereExpression( $whereString, array $bindParams = [] )
+	public function orWhereExpression( $whereString, array $bindParams = [ ] )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 

src/Traits/OrderBy.php

Spacing +2 added lines, -2 removed lines

@@ -24,7 +24,7 @@ 
 	 * @return $this
 	 * @throws QueryException
 	 */
-	public function orderBy( $column, array $allowedColumns = [] )
+	public function orderBy( $column, array $allowedColumns = [ ] )
 	{
 		$column = trim( $column );
 
@@ -43,7 +43,7 @@ 
 	 * @return $this
 	 * @throws QueryException
 	 */
-	public function orderByDesc( $column, array $allowedColumns = [] )
+	public function orderByDesc( $column, array $allowedColumns = [ ] )
 	{
 		$column = trim( $column );
 

src/Traits/Having.php

Spacing +2 added lines, -2 removed lines

@@ -278,7 +278,7 @@ 
 	 * @param string $glue
 	 * @return $this
 	 */
-	public function havingExpression( $whereString, array $bindParams = [], $glue = 'AND' )
+	public function havingExpression( $whereString, array $bindParams = [ ], $glue = 'AND' )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 
@@ -290,7 +290,7 @@ 
 	 * @param array $bindParams
 	 * @return $this
 	 */
-	public function orHavingExpression( $whereString, array $bindParams = [] )
+	public function orHavingExpression( $whereString, array $bindParams = [ ] )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 

src/Traits/WhereAndHavingBuilder.php

Spacing +2 added lines, -2 removed lines

@@ -118,7 +118,7 @@ 
 	{
 		$pdoArray = array();
 		foreach ( $value as $item ) {
-			$pdoArray[] = $this->queryStructure->bindParam( 'a', $item );
+			$pdoArray[ ] = $this->queryStructure->bindParam( 'a', $item );
 		}
 		$body = [
 			$field,
@@ -189,7 +189,7 @@ 
 			throw new QueryException( 'Invalid where array!', QueryException::QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY );
 
 		if ( count( $param ) == 2 )
-			$param[] = '=';
+			$param[ ] = '=';
 
 		$param[ 2 ] = trim( strtoupper( $param[ 2 ] ) );
 		$param[ 2 ] = QueryHelper::clearMultipleSpaces( $param[ 2 ] );

src/DB/DbService.php

Spacing +6 added lines, -6 removed lines

@@ -46,7 +46,7 @@ 
 	/**
 	 * @var array
 	 */
-	private $parameters = [];
+	private $parameters = [ ];
 
 	/**
 	 * @var string;
@@ -125,7 +125,7 @@ 
 		$column = null;
 
 		foreach ( $Columns as $cells ) {
-			$column[] = $cells[ 0 ];
+			$column[ ] = $cells[ 0 ];
 		}
 
 		return $column;
@@ -209,7 +209,7 @@ 
 	 * @param array $parameters
 	 * @throws DbException
 	 */
-	private function queryInit( $query, $parameters = [] )
+	private function queryInit( $query, $parameters = [ ] )
 	{
 		$this->lastStatement = self::getQueryStatement( $query );
 		$this->createPdoConnection();
@@ -220,7 +220,7 @@ 
 			 * Prepare query
 			 */
 			$this->sQuery = $this->pdo->prepare( $query );
-			$this->prepareParams($parameters);
+			$this->prepareParams( $parameters );
 			$this->pdoBindValues();
 			$this->sQuery->execute();
 			if ( DbConfig::getInstance()->isEnableLogQueryDuration() ) {
@@ -246,7 +246,7 @@ 
 			$this->bindMore( $parameters );
 		else
 			foreach ( $parameters as $key => $val )
-				$this->parameters[] = array( $key + 1, $val );
+				$this->parameters[ ] = array( $key + 1, $val );
 	}
 
 	private function pdoBindValues()
@@ -288,7 +288,7 @@ 
 	 */
 	public function bind( $para, $value )
 	{
-		$this->parameters[] = [ ":" . $para, $value ];
+		$this->parameters[ ] = [ ":" . $para, $value ];
 	}
 
 	public function CloseConnection()

sample/select.php

Spacing +1 added lines, -1 removed lines

@@ -14,7 +14,7 @@
 $query = QueryBuild::select( 'employees' )
 	->fields( 'lastName, jobTitle, officeCode' )
 	->whereEqual( 'jobTitle', "Sales Rep" )
-	->whereIn( 'officeCode', [ 2, 3, 4 ] )->orderBy('lastName')->havingEqual('officeCode',2);
+	->whereIn( 'officeCode', [ 2, 3, 4 ] )->orderBy( 'lastName' )->havingEqual( 'officeCode', 2 );