adumitru68 / QueryBuilder

src/Traits/WhereAndHavingBuilder.php

Spacing +12 added lines, -12 removed lines

@@ -77,7 +77,7 @@ 
 			default:
 				$valuePdoString = $this->queryStructure->bindParam( $this->temporaryParam[ 0 ], $this->temporaryParam[ 1 ] );
 				$body = $this->temporaryParam[ 0 ] . ' ' . $operator . ' ' . $valuePdoString;
-				$this->registerCondition($body);
+				$this->registerCondition( $body );
 				break;
 		}
 	}
@@ -98,7 +98,7 @@ 
 			$this->queryStructure->bindParam( 'max', $max )
 		];
 		$body = implode( ' ', $body );
-		$this->registerCondition($body);
+		$this->registerCondition( $body );
 	}
 
 	private function makeInCondition()
@@ -111,10 +111,10 @@ 
 
 	private function inQuerySelect()
 	{
-		$field = $this->temporaryParam[0];
+		$field = $this->temporaryParam[ 0 ];
 		/** @var QuerySelect $subquerySelect */
-		$subquerySelect = $this->temporaryParam[1];
-		$operator = $this->temporaryParam[2];
+		$subquerySelect = $this->temporaryParam[ 1 ];
+		$operator = $this->temporaryParam[ 2 ];
 		$subquerySelectParams = $subquerySelect->getBindParams();
 		foreach ( $subquerySelectParams as $key => $value ) {
 			$this->queryStructure->setParams( $key, $value );
@@ -127,19 +127,19 @@ 
 			' )'
 		];
 		$body = implode( ' ', $body );
-		$this->registerCondition($body);
+		$this->registerCondition( $body );
 
 	}
 
 	private function inArray()
 	{
-		$field = $this->temporaryParam[0];
-		$value = $this->temporaryParam[1];
-		$operator = $this->temporaryParam[2];
+		$field = $this->temporaryParam[ 0 ];
+		$value = $this->temporaryParam[ 1 ];
+		$operator = $this->temporaryParam[ 2 ];
 
 		$pdoArray = array();
 		foreach ( $value as $item ) {
-			$pdoArray[] = $this->queryStructure->bindParam( 'a', $item );
+			$pdoArray[ ] = $this->queryStructure->bindParam( 'a', $item );
 		}
 		$body = [
 			$field,
@@ -148,7 +148,7 @@ 
 		];
 		$body = implode( ' ', $body );
 		$body = QueryHelper::clearMultipleSpaces( $body );
-		$this->registerCondition($body);
+		$this->registerCondition( $body );
 	}
 
 	/**
@@ -216,7 +216,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 ] );

Braces +14 added lines, -10 removed lines

@@ -103,10 +103,11 @@ 
 
 	private function makeInCondition()
 	{
-		if ( is_a( $this->temporaryParam[ 1 ], QuerySelect::class ) )
-			$this->inQuerySelect();
-		elseif ( is_array( $this->temporaryParam[ 1 ] ) )
-			$this->inArray();
+		if ( is_a( $this->temporaryParam[ 1 ], QuerySelect::class ) ) {
+					$this->inQuerySelect();
+		} elseif ( is_array( $this->temporaryParam[ 1 ] ) ) {
+					$this->inArray();
+		}
 	}
 
 	private function inQuerySelect()
@@ -182,8 +183,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';
@@ -212,11 +214,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 ] );

sample/select.php

Spacing +1 added lines, -1 removed lines

@@ -8,7 +8,7 @@
 
 use Qpdb\QueryBuilder\QueryBuild;
 
-include_once $_SERVER['DOCUMENT_ROOT'] . '/vendor/autoload.php';
+include_once $_SERVER[ 'DOCUMENT_ROOT' ] . '/vendor/autoload.php';
 
 
 $query = QueryBuild::select( 'employees' )