1 | <?php |
||||||
2 | |||||||
3 | namespace Sanderdekroon\Parlant\Builder; |
||||||
4 | |||||||
5 | use Closure; |
||||||
6 | use InvalidArgumentException; |
||||||
7 | |||||||
8 | class WhereMetaClause |
||||||
9 | { |
||||||
10 | protected $grammar; |
||||||
11 | |||||||
12 | protected $relation; |
||||||
13 | |||||||
14 | 8 | public function __construct($grammar) |
|||||
15 | { |
||||||
16 | 8 | $this->grammar = $grammar; |
|||||
17 | 8 | } |
|||||
18 | |||||||
19 | /** |
||||||
20 | * Query the meta values (custom post fields) of posts. |
||||||
21 | * @param string|array|Closure $column The field name, an array of where clauses or an Closure detailing a nested where clause. |
||||||
22 | * @param string $operator |
||||||
23 | * @param mixed $value |
||||||
24 | * @param string $type The type comparison, for example NUMERIC or CHAR |
||||||
25 | * @param string $relation AND/OR, currently unimplemented |
||||||
26 | * @param integer $level The query level, currently unimplemented |
||||||
27 | * @return $this |
||||||
28 | */ |
||||||
29 | 8 | public function build($column, $operator = null, $value = null, $type = null, $relation = null, $level = 1) |
|||||
30 | { |
||||||
31 | /** @todo Rewrite */ |
||||||
32 | 8 | $this->relation = [$level => empty($relation) ? 'AND' : $relation]; |
|||||
33 | |||||||
34 | // If the column is an array, we will assume it is an array of key-value pairs |
||||||
35 | // and can add them each as a where clause. We will maintain the boolean we |
||||||
36 | // received when the method was called and pass it into the nested where. |
||||||
37 | 8 | if (is_array($column)) { |
|||||
38 | return $this->addArrayOfWhereMetas($column); |
||||||
0 ignored issues
–
show
Bug
Best Practice
introduced
by
![]() |
|||||||
39 | } |
||||||
40 | |||||||
41 | // If the column parameter is a closure we'll start a nested meta query. |
||||||
42 | 8 | if ($column instanceof Closure) { |
|||||
43 | 1 | $nestedMetas = $this->extractNestedMetaClosures($column); |
|||||
44 | 1 | return $this->whereNestedMeta($nestedMetas); |
|||||
0 ignored issues
–
show
|
|||||||
45 | } |
||||||
46 | |||||||
47 | // Here we will make some assumptions about the operator. If only 2 values are |
||||||
48 | // passed to the method, we will assume that the operator is an equals sign |
||||||
49 | // and keep going. Otherwise, we'll require the operator to be passed in. |
||||||
50 | 8 | list($value, $operator) = $this->prepareValueAndOperator( |
|||||
51 | 8 | $value, |
|||||
52 | 8 | $operator, |
|||||
53 | 8 | (func_num_args() == 2 || is_null($value)) |
|||||
54 | ); |
||||||
55 | |||||||
56 | // If the given operator is not found in the list of valid operators we will |
||||||
57 | // assume that the developer is just short-cutting the '=' operators and |
||||||
58 | // we will set the operators to '=' and set the values appropriately. |
||||||
59 | 7 | if ($this->invalidOperator($operator)) { |
|||||
60 | list($value, $operator) = [$operator, '=']; |
||||||
61 | } |
||||||
62 | |||||||
63 | // If no type is given or if it's an invalid one, we'll default back |
||||||
64 | // to the CHAR comparing type. The $type is checked against the |
||||||
65 | // values in the supplied posttype grammar. |
||||||
66 | 7 | $type = $this->getValidMetaType($type); |
|||||
67 | |||||||
68 | 7 | return [compact( |
|||||
0 ignored issues
–
show
|
|||||||
69 | 7 | 'column', // Metakey name |
|||||
70 | 7 | 'value', // The actual value |
|||||
71 | 7 | 'operator', // =, <, >, etc. |
|||||
72 | 7 | 'type', // CHAR, BINARY, etc |
|||||
73 | 7 | 'level' // Unimplemented, undocumented. |
|||||
74 | )]; |
||||||
75 | } |
||||||
76 | |||||||
77 | 7 | public function getRelation() |
|||||
78 | { |
||||||
79 | 7 | return $this->relation; |
|||||
80 | } |
||||||
81 | |||||||
82 | /** |
||||||
83 | * Resolve the closures and replace them with NestedMeta classes. |
||||||
84 | * @param Closure $closure |
||||||
85 | * @return NestedMeta |
||||||
86 | */ |
||||||
87 | 1 | protected function extractNestedMetaClosures($closure) |
|||||
88 | { |
||||||
89 | 1 | $nestedMeta = call_user_func($closure->bindTo(new NestedMeta)); |
|||||
90 | |||||||
91 | 1 | $query = $nestedMeta->getQuery(); |
|||||
92 | 1 | foreach ($query as $key => $meta) { |
|||||
93 | 1 | if ($meta['column'] instanceof Closure) { |
|||||
94 | 1 | $query[$key] = $this->extractNestedMetaClosures($meta['column']); |
|||||
95 | } |
||||||
96 | } |
||||||
97 | |||||||
98 | 1 | $nestedMeta->replaceQuery($query); |
|||||
99 | 1 | return $nestedMeta; |
|||||
100 | } |
||||||
101 | |||||||
102 | /** |
||||||
103 | * Nest multiple meta queries by supplying a query. If the closure contains |
||||||
104 | * another closure, it is resolved recursivly. |
||||||
105 | * @param Closure $closure |
||||||
106 | * @return NestedMeta Returns a NestedMeta instance which is further processed by the compiler. |
||||||
107 | */ |
||||||
108 | 1 | protected function whereNestedMeta($nestedMeta) |
|||||
109 | { |
||||||
110 | 1 | if (!$nestedMeta instanceof NestedMeta) { |
|||||
111 | throw new InvalidArgumentException('Invalid class supplied for nested meta query'); |
||||||
112 | } |
||||||
113 | |||||||
114 | 1 | $query = $nestedMeta->getQuery(); |
|||||
115 | |||||||
116 | 1 | foreach ($query as $key => $meta) { |
|||||
117 | 1 | if ($meta instanceof NestedMeta) { |
|||||
118 | $query[$key] = $this->whereNestedMeta($meta); |
||||||
119 | continue; |
||||||
120 | } |
||||||
121 | |||||||
122 | 1 | $query[$key] = $this->parseNestedMeta($meta); |
|||||
123 | } |
||||||
124 | |||||||
125 | 1 | $nestedMeta->replaceQuery($query); |
|||||
126 | 1 | return [$nestedMeta]; |
|||||
0 ignored issues
–
show
|
|||||||
127 | } |
||||||
128 | |||||||
129 | /** |
||||||
130 | * Parse the nested meta fields by validating them. If the meta fields is |
||||||
131 | * an instance of NestedMeta, we'll resolve that recursively. |
||||||
132 | * @param array|NestedMeta $meta |
||||||
133 | * @return array |
||||||
134 | */ |
||||||
135 | 1 | protected function parseNestedMeta($meta) |
|||||
136 | { |
||||||
137 | 1 | if ($meta instanceof NestedMeta) { |
|||||
138 | $meta = $this->whereNestedMeta($meta); |
||||||
139 | } |
||||||
140 | |||||||
141 | 1 | return $this->validateMetaFields($meta); |
|||||
0 ignored issues
–
show
It seems like
$meta can also be of type Sanderdekroon\Parlant\Builder\NestedMeta ; however, parameter $fields of Sanderdekroon\Parlant\Bu...e::validateMetaFields() does only seem to accept array , maybe add an additional type check?
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
![]() |
|||||||
142 | } |
||||||
143 | |||||||
144 | /** |
||||||
145 | * Do some basic validating of the meta fields. Checks if the operator is valid and |
||||||
146 | * if the meta type (if supplied any) is valid with the current grammar. |
||||||
147 | * @param array $fields |
||||||
148 | * @return array |
||||||
149 | */ |
||||||
150 | 1 | protected function validateMetaFields($fields) |
|||||
151 | { |
||||||
152 | 1 | extract($fields); |
|||||
153 | |||||||
154 | // If the given operator is not found in the list of valid operators we will |
||||||
155 | // assume that the developer is just short-cutting the '=' operators and |
||||||
156 | // we will set the operators to '=' and set the values appropriately. |
||||||
157 | 1 | if ($this->invalidOperator($operator)) { |
|||||
158 | list($value, $operator) = [$operator, '=']; |
||||||
159 | } |
||||||
160 | |||||||
161 | // If no type is given or if it's an invalid one, we'll default back |
||||||
162 | // to the CHAR comparing type. The $type is checked against the |
||||||
163 | // values in the supplied posttype grammar. |
||||||
164 | 1 | $type = $this->getValidMetaType($type); |
|||||
165 | |||||||
166 | 1 | return compact('column', 'value', 'operator', 'type', 'level'); |
|||||
167 | } |
||||||
168 | |||||||
169 | /** |
||||||
170 | * Adds arrays of where metas to the query. |
||||||
171 | * @param array $metaArray |
||||||
172 | */ |
||||||
173 | protected function addArrayOfWhereMetas($metaArray) |
||||||
174 | { |
||||||
175 | $build = []; |
||||||
176 | foreach ($metaArray as $array) { |
||||||
177 | $build = array_merge($build, $this->build(...$array)); |
||||||
0 ignored issues
–
show
It seems like
$this->build($array) can also be of type Sanderdekroon\Parlant\Builder\NestedMeta ; however, parameter $array2 of array_merge() does only seem to accept array|null , maybe add an additional type check?
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
![]() $array is expanded, but the parameter $column of Sanderdekroon\Parlant\Bu...hereMetaClause::build() does not expect variable arguments.
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
![]() |
|||||||
178 | } |
||||||
179 | |||||||
180 | return $build; |
||||||
181 | } |
||||||
182 | |||||||
183 | /** |
||||||
184 | * Return a valid comparator type, like CHAR or NUMERIC. |
||||||
185 | * @param string $type |
||||||
186 | * @return string Returns 'CHAR' if none is supplied or if it's invalid |
||||||
187 | */ |
||||||
188 | 7 | protected function getValidMetaType($type = null) |
|||||
189 | { |
||||||
190 | 7 | if (is_null($type) || !in_array($type, $this->grammar->getComparators())) { |
|||||
191 | 6 | return 'CHAR'; |
|||||
192 | } |
||||||
193 | |||||||
194 | 2 | return strtoupper($type); |
|||||
195 | } |
||||||
196 | |||||||
197 | /** |
||||||
198 | * Wether or not the given operator is invalid. |
||||||
199 | * @param string $operator |
||||||
200 | * @return bool |
||||||
201 | */ |
||||||
202 | 8 | protected function invalidOperator($operator) |
|||||
203 | { |
||||||
204 | 8 | return !in_array($operator, $this->grammar->getOperators()); |
|||||
205 | } |
||||||
206 | |||||||
207 | /** |
||||||
208 | * Prepare the value and operator by applying defaults and validating the operator. |
||||||
209 | * @param string $value |
||||||
210 | * @param string $operator |
||||||
211 | * @param bool $useDefault |
||||||
212 | * @param bool $termDefault |
||||||
213 | * @return array |
||||||
214 | */ |
||||||
215 | 8 | protected function prepareValueAndOperator($value, $operator, $useDefault = false, $termDefault = false) |
|||||
216 | { |
||||||
217 | 8 | if ($useDefault) { |
|||||
218 | 3 | return [$operator, $termDefault ? 'IN' : '=']; |
|||||
219 | } |
||||||
220 | |||||||
221 | 6 | if ($this->invalidOperator($operator) && !is_null($value)) { |
|||||
222 | 1 | throw new InvalidArgumentException('Illegal operator and value combination.'); |
|||||
223 | } |
||||||
224 | |||||||
225 | 5 | return [$value, $operator]; |
|||||
226 | } |
||||||
227 | } |
||||||
228 |