@@ -26,12 +26,12 @@ discard block |
||
| 26 | 26 | * @return $this |
| 27 | 27 | * @throws QueryException |
| 28 | 28 | */ |
| 29 | - public function orderBy( $column, array $allowedColumns = [] ) |
|
| 29 | + public function orderBy( $column, array $allowedColumns = [ ] ) |
|
| 30 | 30 | { |
| 31 | 31 | if ( !$this->validateColumn( $column, $allowedColumns ) ) |
| 32 | 32 | throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
| 33 | 33 | |
| 34 | - $column = $this->queryStructure->prepare($column); |
|
| 34 | + $column = $this->queryStructure->prepare( $column ); |
|
| 35 | 35 | $this->queryStructure->setElement( QueryStructure::ORDER_BY, $column ); |
| 36 | 36 | |
| 37 | 37 | return $this; |
@@ -44,12 +44,12 @@ discard block |
||
| 44 | 44 | * @return $this |
| 45 | 45 | * @throws QueryException |
| 46 | 46 | */ |
| 47 | - public function orderByDesc( $column, array $allowedColumns = [] ) |
|
| 47 | + public function orderByDesc( $column, array $allowedColumns = [ ] ) |
|
| 48 | 48 | { |
| 49 | 49 | if ( !$this->validateColumn( $column, $allowedColumns ) ) |
| 50 | 50 | throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
| 51 | 51 | |
| 52 | - $column = $this->queryStructure->prepare($column); |
|
| 52 | + $column = $this->queryStructure->prepare( $column ); |
|
| 53 | 53 | $this->queryStructure->setElement( QueryStructure::ORDER_BY, $column . ' DESC' ); |
| 54 | 54 | |
| 55 | 55 | return $this; |
@@ -28,8 +28,9 @@ discard block |
||
| 28 | 28 | */ |
| 29 | 29 | public function orderBy( $column, array $allowedColumns = [] ) |
| 30 | 30 | { |
| 31 | - if ( !$this->validateColumn( $column, $allowedColumns ) ) |
|
| 32 | - throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
|
| 31 | + if ( !$this->validateColumn( $column, $allowedColumns ) ) { |
|
| 32 | + throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
|
| 33 | + } |
|
| 33 | 34 | |
| 34 | 35 | $column = $this->queryStructure->prepare($column); |
| 35 | 36 | $this->queryStructure->setElement( QueryStructure::ORDER_BY, $column ); |
@@ -46,8 +47,9 @@ discard block |
||
| 46 | 47 | */ |
| 47 | 48 | public function orderByDesc( $column, array $allowedColumns = [] ) |
| 48 | 49 | { |
| 49 | - if ( !$this->validateColumn( $column, $allowedColumns ) ) |
|
| 50 | - throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
|
| 50 | + if ( !$this->validateColumn( $column, $allowedColumns ) ) { |
|
| 51 | + throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
|
| 52 | + } |
|
| 51 | 53 | |
| 52 | 54 | $column = $this->queryStructure->prepare($column); |
| 53 | 55 | $this->queryStructure->setElement( QueryStructure::ORDER_BY, $column . ' DESC' ); |
@@ -74,8 +76,9 @@ discard block |
||
| 74 | 76 | */ |
| 75 | 77 | private function getOrderBySyntax() |
| 76 | 78 | { |
| 77 | - if ( count( $this->queryStructure->getElement( QueryStructure::ORDER_BY ) ) ) |
|
| 78 | - return 'ORDER BY ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::ORDER_BY ), ', ' ); |
|
| 79 | + if ( count( $this->queryStructure->getElement( QueryStructure::ORDER_BY ) ) ) { |
|
| 80 | + return 'ORDER BY ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::ORDER_BY ), ', ' ); |
|
| 81 | + } |
|
| 79 | 82 | |
| 80 | 83 | return ''; |
| 81 | 84 | } |
@@ -26,11 +26,13 @@ |
||
| 26 | 26 | */ |
| 27 | 27 | protected function validateColumn( $columnName, array $allowed ) |
| 28 | 28 | { |
| 29 | - if ( is_integer( $columnName ) ) |
|
| 30 | - return true; |
|
| 29 | + if ( is_integer( $columnName ) ) { |
|
| 30 | + return true; |
|
| 31 | + } |
|
| 31 | 32 | |
| 32 | - if ( !count( $allowed ) ) |
|
| 33 | - return true; |
|
| 33 | + if ( !count( $allowed ) ) { |
|
| 34 | + return true; |
|
| 35 | + } |
|
| 34 | 36 | |
| 35 | 37 | return false; |
| 36 | 38 | } |
@@ -26,12 +26,12 @@ discard block |
||
| 26 | 26 | * @return $this |
| 27 | 27 | * @throws QueryException |
| 28 | 28 | */ |
| 29 | - public function groupBy( $column, array $allowedColumns = [] ) |
|
| 29 | + public function groupBy( $column, array $allowedColumns = [ ] ) |
|
| 30 | 30 | { |
| 31 | 31 | if ( !$this->validateColumn( $column, $allowedColumns ) ) |
| 32 | 32 | throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
| 33 | 33 | |
| 34 | - $column = $this->queryStructure->prepare($column); |
|
| 34 | + $column = $this->queryStructure->prepare( $column ); |
|
| 35 | 35 | $this->queryStructure->setElement( QueryStructure::ORDER_BY, $column ); |
| 36 | 36 | |
| 37 | 37 | $this->queryStructure->setElement( QueryStructure::GROUP_BY, $column ); |
@@ -46,12 +46,12 @@ discard block |
||
| 46 | 46 | * @return $this |
| 47 | 47 | * @throws QueryException |
| 48 | 48 | */ |
| 49 | - public function groupByDesc( $column, array $allowedColumns = [] ) |
|
| 49 | + public function groupByDesc( $column, array $allowedColumns = [ ] ) |
|
| 50 | 50 | { |
| 51 | 51 | if ( !$this->validateColumn( $column, $allowedColumns ) ) |
| 52 | 52 | throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
| 53 | 53 | |
| 54 | - $column = $this->queryStructure->prepare($column); |
|
| 54 | + $column = $this->queryStructure->prepare( $column ); |
|
| 55 | 55 | $this->queryStructure->setElement( QueryStructure::ORDER_BY, $column ); |
| 56 | 56 | |
| 57 | 57 | $this->queryStructure->setElement( QueryStructure::GROUP_BY, $column . ' DESC' ); |
@@ -28,8 +28,9 @@ discard block |
||
| 28 | 28 | */ |
| 29 | 29 | public function groupBy( $column, array $allowedColumns = [] ) |
| 30 | 30 | { |
| 31 | - if ( !$this->validateColumn( $column, $allowedColumns ) ) |
|
| 32 | - throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
|
| 31 | + if ( !$this->validateColumn( $column, $allowedColumns ) ) { |
|
| 32 | + throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
|
| 33 | + } |
|
| 33 | 34 | |
| 34 | 35 | $column = $this->queryStructure->prepare($column); |
| 35 | 36 | $this->queryStructure->setElement( QueryStructure::ORDER_BY, $column ); |
@@ -48,8 +49,9 @@ discard block |
||
| 48 | 49 | */ |
| 49 | 50 | public function groupByDesc( $column, array $allowedColumns = [] ) |
| 50 | 51 | { |
| 51 | - if ( !$this->validateColumn( $column, $allowedColumns ) ) |
|
| 52 | - throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
|
| 52 | + if ( !$this->validateColumn( $column, $allowedColumns ) ) { |
|
| 53 | + throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME ); |
|
| 54 | + } |
|
| 53 | 55 | |
| 54 | 56 | $column = $this->queryStructure->prepare($column); |
| 55 | 57 | $this->queryStructure->setElement( QueryStructure::ORDER_BY, $column ); |
@@ -78,8 +80,9 @@ discard block |
||
| 78 | 80 | */ |
| 79 | 81 | private function getGroupBySyntax() |
| 80 | 82 | { |
| 81 | - if ( count( $this->queryStructure->getElement( QueryStructure::GROUP_BY ) ) ) |
|
| 82 | - return 'GROUP BY ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::GROUP_BY ), ', ' ); |
|
| 83 | + if ( count( $this->queryStructure->getElement( QueryStructure::GROUP_BY ) ) ) { |
|
| 84 | + return 'GROUP BY ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::GROUP_BY ), ', ' ); |
|
| 85 | + } |
|
| 83 | 86 | |
| 84 | 87 | return ''; |
| 85 | 88 | } |