adumitru68 / QueryBuilder

config/qpdb_db_config.php

Spacing +2 added lines, -2 removed lines

@@ -44,8 +44,8 @@
 	'db_log' => [
 		'enable_log_errors' => false,
 		'enable_log_query_duration' => false,
-		'log_path_errors' => $_SERVER['DOCUMENT_ROOT'] . '/tmp/db_errors/',
-		'log_path_query_duration' => $_SERVER['DOCUMENT_ROOT'] . '/tmp/db_query_duration/',
+		'log_path_errors' => $_SERVER[ 'DOCUMENT_ROOT' ] . '/tmp/db_errors/',
+		'log_path_query_duration' => $_SERVER[ 'DOCUMENT_ROOT' ] . '/tmp/db_query_duration/',
 	],
 
 	'use_table_prefix' => false,

sample/autoloader.php

Spacing +1 added lines, -1 removed lines

@@ -10,7 +10,7 @@
 /**
  * @param $class
  */
-	function ( $class ) {
+	function( $class ) {
 
 		$nameSpace = str_replace( '\\', '/', trim( $class, '\\' ) ) . '.php';
 		$nameSpace = str_replace( 'Qpdb/QueryBuilder/', '', $nameSpace );

sample/select.php

Spacing +2 added lines, -2 removed lines

@@ -8,11 +8,11 @@
 
 use Qpdb\QueryBuilder\QueryBuild;
 
-include_once $_SERVER['DOCUMENT_ROOT'] . '/vendor/autoload.php';
+include_once $_SERVER[ 'DOCUMENT_ROOT' ] . '/vendor/autoload.php';
 
 
 $query = QueryBuild::select( 'employees22' )
-	->fields('lastName, jobTitle, officeCode')
+	->fields( 'lastName, jobTitle, officeCode' )
 	->whereEqual( 'jobTitle', "Sales Rep" )
 	->whereIn( 'officeCode', [ 2, 3, 4 ] );
 

src/Traits/OrderBy.php

Spacing +4 added lines, -4 removed lines

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

src/Traits/SelectFields.php

Spacing +2 added lines, -2 removed lines

@@ -60,14 +60,14 @@
 	 */
 	private function prepareArrayFields( $fieldsArray = array() )
 	{
-		$prepareArray = [];
+		$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 ( '' !== trim( $field ) )
-				$prepareArray[] = trim( $field );
+				$prepareArray[ ] = trim( $field );
 		}
 
 		return $prepareArray;

src/Traits/GroupBy.php

Spacing +2 added lines, -2 removed lines

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

src/Traits/WhereAndHavingBuilder.php

Spacing +15 added lines, -15 removed lines

@@ -37,16 +37,16 @@ 
 
 		$param = $this->validateWhereParam( $param );
 
-		$field = $param[0];
-		$value = $param[1];
-		$operator = $param[2];
+		$field = $param[ 0 ];
+		$value = $param[ 1 ];
+		$operator = $param[ 2 ];
 
 		switch ( $operator ) {
 			case 'BETWEEN':
 			case 'NOT BETWEEN':
 			case '!BETWEEN':
-				$min = $value[0];
-				$max = $value[1];
+				$min = $value[ 0 ];
+				$max = $value[ 1 ];
 				$body = [
 					$field,
 					$operator,
@@ -118,7 +118,7 @@ 
 	{
 		$pdoArray = array();
 		foreach ( $value as $item ) {
-			$pdoArray[] = $this->queryStructure->bindParam( 'a', $item );
+			$pdoArray[ ] = $this->queryStructure->bindParam( 'a', $item );
 		}
 		$body = [
 			$field,
@@ -138,7 +138,7 @@ 
 	 */
 	private function getWhereSyntax()
 	{
-		return $this->getWhereAndHavingSyntax(QueryStructure::WHERE);
+		return $this->getWhereAndHavingSyntax( QueryStructure::WHERE );
 	}
 
 	/**
@@ -146,7 +146,7 @@ 
 	 */
 	private function getHavingSyntax()
 	{
-		return $this->getWhereAndHavingSyntax( QueryStructure::HAVING);
+		return $this->getWhereAndHavingSyntax( QueryStructure::HAVING );
 	}
 
 	/**
@@ -161,15 +161,15 @@ 
 		$where = '';
 		$last_type = 'where_start';
 		foreach ( $this->queryStructure->getElement( $clauseType ) as $where_cond ) {
-			$glue = $where_cond['glue'];
+			$glue = $where_cond[ 'glue' ];
 			if ( $last_type == 'where_start' || $last_type == 'start_where_group' ) {
 				$glue = '';
 			}
-			$where .= ' ' . $glue . ' ' . $where_cond['body'];
-			$last_type = $where_cond['type'];
+			$where .= ' ' . $glue . ' ' . $where_cond[ 'body' ];
+			$last_type = $where_cond[ 'type' ];
 		}
 
-		if ( $this->queryStructure->getElement( $clauseType.'_invert' ) ) {
+		if ( $this->queryStructure->getElement( $clauseType . '_invert' ) ) {
 			$where = ' NOT ( ' . $where . ' ) ';
 		}
 
@@ -189,10 +189,10 @@ 
 			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] );
+		$param[ 2 ] = trim( strtoupper( $param[ 2 ] ) );
+		$param[ 2 ] = QueryHelper::clearMultipleSpaces( $param[ 2 ] );
 
 		return $param;
 	}

src/Traits/Where.php

Spacing +3 added lines, -3 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 );
 		return $this->where( $whereString, $glue );
@@ -289,7 +289,7 @@ 
 	 * @param array $bindParams
 	 * @return $this
 	 */
-	public function orWhereExpression( $whereString, array $bindParams = [] )
+	public function orWhereExpression( $whereString, array $bindParams = [ ] )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 		return $this->where( $whereString, 'OR' );
@@ -352,7 +352,7 @@ 
 	 */
 	private function where( $param, $glue = 'AND' )
 	{
-		return $this->/** @scrutinizer ignore-call */ createCondition($param, $glue, QueryStructure::WHERE );
+		return $this->/** @scrutinizer ignore-call */ createCondition( $param, $glue, QueryStructure::WHERE );
 	}
 
 }
\ No newline at end of file

src/Traits/Having.php

Spacing +3 added lines, -3 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 );
 		return $this->having( $whereString, $glue );
@@ -289,7 +289,7 @@ 
 	 * @param array $bindParams
 	 * @return $this
 	 */
-	public function orHavingExpression( $whereString, array $bindParams = [] )
+	public function orHavingExpression( $whereString, array $bindParams = [ ] )
 	{
 		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );
 		return $this->having( $whereString, 'OR' );
@@ -341,7 +341,7 @@ 
 	 */
 	private function having( $param, $glue = 'AND' )
 	{
-		return $this->createCondition($param, $glue, QueryStructure::HAVING );
+		return $this->createCondition( $param, $glue, QueryStructure::HAVING );
 	}
 
 }
\ No newline at end of file