@@ -52,23 +52,23 @@ discard block |
||
| 52 | 52 | */ |
| 53 | 53 | public function write($source, SpecificationInterface $specification, Compiler $compiler) |
| 54 | 54 | { |
| 55 | - if (!$this->targetAcceptable($source)) { |
|
| 55 | + if (!$this->targetAcceptable($source)){ |
|
| 56 | 56 | return null; |
| 57 | 57 | } |
| 58 | 58 | |
| 59 | - if ($specification instanceof Specification\FilterInterface) { |
|
| 59 | + if ($specification instanceof Specification\FilterInterface){ |
|
| 60 | 60 | return $this->writeFilter($source, $specification, $compiler); |
| 61 | 61 | } |
| 62 | 62 | |
| 63 | - if ($specification instanceof Specification\SorterInterface) { |
|
| 63 | + if ($specification instanceof Specification\SorterInterface){ |
|
| 64 | 64 | return $this->writeSorter($source, $specification, $compiler); |
| 65 | 65 | } |
| 66 | 66 | |
| 67 | - if ($specification instanceof Specification\Pagination\Limit) { |
|
| 67 | + if ($specification instanceof Specification\Pagination\Limit){ |
|
| 68 | 68 | return $source->limit($specification->getValue()); |
| 69 | 69 | } |
| 70 | 70 | |
| 71 | - if ($specification instanceof Specification\Pagination\Offset) { |
|
| 71 | + if ($specification instanceof Specification\Pagination\Offset){ |
|
| 72 | 72 | return $source->offset($specification->getValue()); |
| 73 | 73 | } |
| 74 | 74 | |
@@ -83,15 +83,15 @@ discard block |
||
| 83 | 83 | */ |
| 84 | 84 | protected function writeFilter($source, Specification\FilterInterface $filter, Compiler $compiler) |
| 85 | 85 | { |
| 86 | - if ($filter instanceof Specification\Filter\All || $filter instanceof Specification\Filter\Map) { |
|
| 86 | + if ($filter instanceof Specification\Filter\All || $filter instanceof Specification\Filter\Map){ |
|
| 87 | 87 | return $source->where(static function () use ($compiler, $filter, $source): void { |
| 88 | 88 | $compiler->compile($source, ...$filter->getFilters()); |
| 89 | 89 | }); |
| 90 | 90 | } |
| 91 | 91 | |
| 92 | - if ($filter instanceof Specification\Filter\Any) { |
|
| 92 | + if ($filter instanceof Specification\Filter\Any){ |
|
| 93 | 93 | return $source->where(static function () use ($compiler, $filter, $source): void { |
| 94 | - foreach ($filter->getFilters() as $subFilter) { |
|
| 94 | + foreach ($filter->getFilters() as $subFilter){ |
|
| 95 | 95 | $source->orWhere(static function () use ($compiler, $subFilter, $source): void { |
| 96 | 96 | $compiler->compile($source, $subFilter); |
| 97 | 97 | }); |
@@ -99,9 +99,9 @@ discard block |
||
| 99 | 99 | }); |
| 100 | 100 | } |
| 101 | 101 | |
| 102 | - if ($filter instanceof Specification\Filter\InjectionFilter) { |
|
| 102 | + if ($filter instanceof Specification\Filter\InjectionFilter){ |
|
| 103 | 103 | $expression = $filter->getFilter(); |
| 104 | - if ($expression instanceof Specification\Filter\Expression) { |
|
| 104 | + if ($expression instanceof Specification\Filter\Expression){ |
|
| 105 | 105 | return $source->where( |
| 106 | 106 | $filter->getInjection(), |
| 107 | 107 | $this->getExpressionOperator($expression), |
@@ -110,7 +110,7 @@ discard block |
||
| 110 | 110 | } |
| 111 | 111 | } |
| 112 | 112 | |
| 113 | - if ($filter instanceof Specification\Filter\Expression) { |
|
| 113 | + if ($filter instanceof Specification\Filter\Expression){ |
|
| 114 | 114 | return $source->where( |
| 115 | 115 | $filter->getExpression(), |
| 116 | 116 | $this->getExpressionOperator($filter), |
@@ -127,11 +127,11 @@ discard block |
||
| 127 | 127 | */ |
| 128 | 128 | protected function getExpressionOperator(Specification\Filter\Expression $filter): string |
| 129 | 129 | { |
| 130 | - if ($filter instanceof Specification\Filter\Like) { |
|
| 130 | + if ($filter instanceof Specification\Filter\Like){ |
|
| 131 | 131 | return 'LIKE'; |
| 132 | 132 | } |
| 133 | 133 | |
| 134 | - if ($filter instanceof Specification\Filter\InArray || $filter instanceof Specification\Filter\NotInArray) { |
|
| 134 | + if ($filter instanceof Specification\Filter\InArray || $filter instanceof Specification\Filter\NotInArray){ |
|
| 135 | 135 | return static::ARRAY_OPERATORS[get_class($filter)]; |
| 136 | 136 | } |
| 137 | 137 | |
@@ -144,11 +144,11 @@ discard block |
||
| 144 | 144 | */ |
| 145 | 145 | protected function getExpressionArgs(Specification\Filter\Expression $filter): array |
| 146 | 146 | { |
| 147 | - if ($filter instanceof Specification\Filter\Like) { |
|
| 147 | + if ($filter instanceof Specification\Filter\Like){ |
|
| 148 | 148 | return [sprintf($filter->getPattern(), $this->fetchValue($filter->getValue()))]; |
| 149 | 149 | } |
| 150 | 150 | |
| 151 | - if ($filter instanceof Specification\Filter\InArray || $filter instanceof Specification\Filter\NotInArray) { |
|
| 151 | + if ($filter instanceof Specification\Filter\InArray || $filter instanceof Specification\Filter\NotInArray){ |
|
| 152 | 152 | return [new Parameter($this->fetchValue($filter->getValue()))]; |
| 153 | 153 | } |
| 154 | 154 | |
@@ -163,8 +163,8 @@ discard block |
||
| 163 | 163 | */ |
| 164 | 164 | protected function writeSorter($source, Specification\SorterInterface $sorter, Compiler $compiler) |
| 165 | 165 | { |
| 166 | - if ($sorter instanceof Specification\Sorter\SorterSet) { |
|
| 167 | - foreach ($sorter->getSorters() as $subSorter) { |
|
| 166 | + if ($sorter instanceof Specification\Sorter\SorterSet){ |
|
| 167 | + foreach ($sorter->getSorters() as $subSorter){ |
|
| 168 | 168 | $source = $compiler->compile($source, $subSorter); |
| 169 | 169 | } |
| 170 | 170 | |
@@ -174,9 +174,9 @@ discard block |
||
| 174 | 174 | if ( |
| 175 | 175 | $sorter instanceof Specification\Sorter\AscSorter |
| 176 | 176 | || $sorter instanceof Specification\Sorter\DescSorter |
| 177 | - ) { |
|
| 177 | + ){ |
|
| 178 | 178 | $direction = static::SORTER_DIRECTIONS[get_class($sorter)]; |
| 179 | - foreach ($sorter->getExpressions() as $expression) { |
|
| 179 | + foreach ($sorter->getExpressions() as $expression){ |
|
| 180 | 180 | $source = $source->orderBy($expression, $direction); |
| 181 | 181 | } |
| 182 | 182 | |
@@ -194,7 +194,7 @@ discard block |
||
| 194 | 194 | */ |
| 195 | 195 | protected function fetchValue($value) |
| 196 | 196 | { |
| 197 | - if ($value instanceof Specification\ValueInterface) { |
|
| 197 | + if ($value instanceof Specification\ValueInterface){ |
|
| 198 | 198 | throw new CompilerException('Value expects user input, none given'); |
| 199 | 199 | } |
| 200 | 200 | |
@@ -207,11 +207,11 @@ discard block |
||
| 207 | 207 | */ |
| 208 | 208 | protected function targetAcceptable($target): bool |
| 209 | 209 | { |
| 210 | - if (class_exists(SelectQuery::class) && $target instanceof SelectQuery) { |
|
| 210 | + if (class_exists(SelectQuery::class) && $target instanceof SelectQuery){ |
|
| 211 | 211 | return true; |
| 212 | 212 | } |
| 213 | 213 | |
| 214 | - if (class_exists(Select::class) && $target instanceof Select) { |
|
| 214 | + if (class_exists(Select::class) && $target instanceof Select){ |
|
| 215 | 215 | return true; |
| 216 | 216 | } |
| 217 | 217 | |
@@ -52,23 +52,28 @@ discard block |
||
| 52 | 52 | */ |
| 53 | 53 | public function write($source, SpecificationInterface $specification, Compiler $compiler) |
| 54 | 54 | { |
| 55 | - if (!$this->targetAcceptable($source)) { |
|
| 55 | + if (!$this->targetAcceptable($source)) |
|
| 56 | + { |
|
| 56 | 57 | return null; |
| 57 | 58 | } |
| 58 | 59 | |
| 59 | - if ($specification instanceof Specification\FilterInterface) { |
|
| 60 | + if ($specification instanceof Specification\FilterInterface) |
|
| 61 | + { |
|
| 60 | 62 | return $this->writeFilter($source, $specification, $compiler); |
| 61 | 63 | } |
| 62 | 64 | |
| 63 | - if ($specification instanceof Specification\SorterInterface) { |
|
| 65 | + if ($specification instanceof Specification\SorterInterface) |
|
| 66 | + { |
|
| 64 | 67 | return $this->writeSorter($source, $specification, $compiler); |
| 65 | 68 | } |
| 66 | 69 | |
| 67 | - if ($specification instanceof Specification\Pagination\Limit) { |
|
| 70 | + if ($specification instanceof Specification\Pagination\Limit) |
|
| 71 | + { |
|
| 68 | 72 | return $source->limit($specification->getValue()); |
| 69 | 73 | } |
| 70 | 74 | |
| 71 | - if ($specification instanceof Specification\Pagination\Offset) { |
|
| 75 | + if ($specification instanceof Specification\Pagination\Offset) |
|
| 76 | + { |
|
| 72 | 77 | return $source->offset($specification->getValue()); |
| 73 | 78 | } |
| 74 | 79 | |
@@ -83,15 +88,18 @@ discard block |
||
| 83 | 88 | */ |
| 84 | 89 | protected function writeFilter($source, Specification\FilterInterface $filter, Compiler $compiler) |
| 85 | 90 | { |
| 86 | - if ($filter instanceof Specification\Filter\All || $filter instanceof Specification\Filter\Map) { |
|
| 91 | + if ($filter instanceof Specification\Filter\All || $filter instanceof Specification\Filter\Map) |
|
| 92 | + { |
|
| 87 | 93 | return $source->where(static function () use ($compiler, $filter, $source): void { |
| 88 | 94 | $compiler->compile($source, ...$filter->getFilters()); |
| 89 | 95 | }); |
| 90 | 96 | } |
| 91 | 97 | |
| 92 | - if ($filter instanceof Specification\Filter\Any) { |
|
| 98 | + if ($filter instanceof Specification\Filter\Any) |
|
| 99 | + { |
|
| 93 | 100 | return $source->where(static function () use ($compiler, $filter, $source): void { |
| 94 | - foreach ($filter->getFilters() as $subFilter) { |
|
| 101 | + foreach ($filter->getFilters() as $subFilter) |
|
| 102 | + { |
|
| 95 | 103 | $source->orWhere(static function () use ($compiler, $subFilter, $source): void { |
| 96 | 104 | $compiler->compile($source, $subFilter); |
| 97 | 105 | }); |
@@ -99,9 +107,11 @@ discard block |
||
| 99 | 107 | }); |
| 100 | 108 | } |
| 101 | 109 | |
| 102 | - if ($filter instanceof Specification\Filter\InjectionFilter) { |
|
| 110 | + if ($filter instanceof Specification\Filter\InjectionFilter) |
|
| 111 | + { |
|
| 103 | 112 | $expression = $filter->getFilter(); |
| 104 | - if ($expression instanceof Specification\Filter\Expression) { |
|
| 113 | + if ($expression instanceof Specification\Filter\Expression) |
|
| 114 | + { |
|
| 105 | 115 | return $source->where( |
| 106 | 116 | $filter->getInjection(), |
| 107 | 117 | $this->getExpressionOperator($expression), |
@@ -110,7 +120,8 @@ discard block |
||
| 110 | 120 | } |
| 111 | 121 | } |
| 112 | 122 | |
| 113 | - if ($filter instanceof Specification\Filter\Expression) { |
|
| 123 | + if ($filter instanceof Specification\Filter\Expression) |
|
| 124 | + { |
|
| 114 | 125 | return $source->where( |
| 115 | 126 | $filter->getExpression(), |
| 116 | 127 | $this->getExpressionOperator($filter), |
@@ -127,11 +138,13 @@ discard block |
||
| 127 | 138 | */ |
| 128 | 139 | protected function getExpressionOperator(Specification\Filter\Expression $filter): string |
| 129 | 140 | { |
| 130 | - if ($filter instanceof Specification\Filter\Like) { |
|
| 141 | + if ($filter instanceof Specification\Filter\Like) |
|
| 142 | + { |
|
| 131 | 143 | return 'LIKE'; |
| 132 | 144 | } |
| 133 | 145 | |
| 134 | - if ($filter instanceof Specification\Filter\InArray || $filter instanceof Specification\Filter\NotInArray) { |
|
| 146 | + if ($filter instanceof Specification\Filter\InArray || $filter instanceof Specification\Filter\NotInArray) |
|
| 147 | + { |
|
| 135 | 148 | return static::ARRAY_OPERATORS[get_class($filter)]; |
| 136 | 149 | } |
| 137 | 150 | |
@@ -144,11 +157,13 @@ discard block |
||
| 144 | 157 | */ |
| 145 | 158 | protected function getExpressionArgs(Specification\Filter\Expression $filter): array |
| 146 | 159 | { |
| 147 | - if ($filter instanceof Specification\Filter\Like) { |
|
| 160 | + if ($filter instanceof Specification\Filter\Like) |
|
| 161 | + { |
|
| 148 | 162 | return [sprintf($filter->getPattern(), $this->fetchValue($filter->getValue()))]; |
| 149 | 163 | } |
| 150 | 164 | |
| 151 | - if ($filter instanceof Specification\Filter\InArray || $filter instanceof Specification\Filter\NotInArray) { |
|
| 165 | + if ($filter instanceof Specification\Filter\InArray || $filter instanceof Specification\Filter\NotInArray) |
|
| 166 | + { |
|
| 152 | 167 | return [new Parameter($this->fetchValue($filter->getValue()))]; |
| 153 | 168 | } |
| 154 | 169 | |
@@ -163,8 +178,10 @@ discard block |
||
| 163 | 178 | */ |
| 164 | 179 | protected function writeSorter($source, Specification\SorterInterface $sorter, Compiler $compiler) |
| 165 | 180 | { |
| 166 | - if ($sorter instanceof Specification\Sorter\SorterSet) { |
|
| 167 | - foreach ($sorter->getSorters() as $subSorter) { |
|
| 181 | + if ($sorter instanceof Specification\Sorter\SorterSet) |
|
| 182 | + { |
|
| 183 | + foreach ($sorter->getSorters() as $subSorter) |
|
| 184 | + { |
|
| 168 | 185 | $source = $compiler->compile($source, $subSorter); |
| 169 | 186 | } |
| 170 | 187 | |
@@ -176,7 +193,8 @@ discard block |
||
| 176 | 193 | || $sorter instanceof Specification\Sorter\DescSorter |
| 177 | 194 | ) { |
| 178 | 195 | $direction = static::SORTER_DIRECTIONS[get_class($sorter)]; |
| 179 | - foreach ($sorter->getExpressions() as $expression) { |
|
| 196 | + foreach ($sorter->getExpressions() as $expression) |
|
| 197 | + { |
|
| 180 | 198 | $source = $source->orderBy($expression, $direction); |
| 181 | 199 | } |
| 182 | 200 | |
@@ -194,7 +212,8 @@ discard block |
||
| 194 | 212 | */ |
| 195 | 213 | protected function fetchValue($value) |
| 196 | 214 | { |
| 197 | - if ($value instanceof Specification\ValueInterface) { |
|
| 215 | + if ($value instanceof Specification\ValueInterface) |
|
| 216 | + { |
|
| 198 | 217 | throw new CompilerException('Value expects user input, none given'); |
| 199 | 218 | } |
| 200 | 219 | |
@@ -207,11 +226,13 @@ discard block |
||
| 207 | 226 | */ |
| 208 | 227 | protected function targetAcceptable($target): bool |
| 209 | 228 | { |
| 210 | - if (class_exists(SelectQuery::class) && $target instanceof SelectQuery) { |
|
| 229 | + if (class_exists(SelectQuery::class) && $target instanceof SelectQuery) |
|
| 230 | + { |
|
| 211 | 231 | return true; |
| 212 | 232 | } |
| 213 | 233 | |
| 214 | - if (class_exists(Select::class) && $target instanceof Select) { |
|
| 234 | + if (class_exists(Select::class) && $target instanceof Select) |
|
| 235 | + { |
|
| 215 | 236 | return true; |
| 216 | 237 | } |
| 217 | 238 | |