Total Complexity | 132 |
Total Lines | 1229 |
Duplicated Lines | 0 % |
Changes | 0 |
Complex classes like DataList often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use DataList, and based on these observations, apply Extract Interface, too.
1 | <?php |
||
35 | class DataList extends ViewableData implements SS_List, Filterable, Sortable, Limitable |
||
36 | { |
||
37 | |||
38 | /** |
||
39 | * The DataObject class name that this data list is querying |
||
40 | * |
||
41 | * @var string |
||
42 | */ |
||
43 | protected $dataClass; |
||
44 | |||
45 | /** |
||
46 | * The {@link DataQuery} object responsible for getting this DataList's records |
||
47 | * |
||
48 | * @var DataQuery |
||
49 | */ |
||
50 | protected $dataQuery; |
||
51 | |||
52 | /** |
||
53 | * Create a new DataList. |
||
54 | * No querying is done on construction, but the initial query schema is set up. |
||
55 | * |
||
56 | * @param string $dataClass - The DataObject class to query. |
||
57 | */ |
||
58 | public function __construct($dataClass) |
||
59 | { |
||
60 | $this->dataClass = $dataClass; |
||
61 | $this->dataQuery = new DataQuery($this->dataClass); |
||
62 | |||
63 | parent::__construct(); |
||
64 | } |
||
65 | |||
66 | /** |
||
67 | * Get the dataClass name for this DataList, ie the DataObject ClassName |
||
68 | * |
||
69 | * @return string |
||
70 | */ |
||
71 | public function dataClass() |
||
72 | { |
||
73 | return $this->dataClass; |
||
74 | } |
||
75 | |||
76 | /** |
||
77 | * When cloning this object, clone the dataQuery object as well |
||
78 | */ |
||
79 | public function __clone() |
||
80 | { |
||
81 | $this->dataQuery = clone $this->dataQuery; |
||
82 | } |
||
83 | |||
84 | /** |
||
85 | * Return a copy of the internal {@link DataQuery} object |
||
86 | * |
||
87 | * Because the returned value is a copy, modifying it won't affect this list's contents. If |
||
88 | * you want to alter the data query directly, use the alterDataQuery method |
||
89 | * |
||
90 | * @return DataQuery |
||
91 | */ |
||
92 | public function dataQuery() |
||
93 | { |
||
94 | return clone $this->dataQuery; |
||
95 | } |
||
96 | |||
97 | /** |
||
98 | * @var bool - Indicates if we are in an alterDataQueryCall already, so alterDataQuery can be re-entrant |
||
99 | */ |
||
100 | protected $inAlterDataQueryCall = false; |
||
101 | |||
102 | /** |
||
103 | * Return a new DataList instance with the underlying {@link DataQuery} object altered |
||
104 | * |
||
105 | * If you want to alter the underlying dataQuery for this list, this wrapper method |
||
106 | * will ensure that you can do so without mutating the existing List object. |
||
107 | * |
||
108 | * It clones this list, calls the passed callback function with the dataQuery of the new |
||
109 | * list as it's first parameter (and the list as it's second), then returns the list |
||
110 | * |
||
111 | * Note that this function is re-entrant - it's safe to call this inside a callback passed to |
||
112 | * alterDataQuery |
||
113 | * |
||
114 | * @param callable $callback |
||
115 | * @return static |
||
116 | * @throws Exception |
||
117 | */ |
||
118 | public function alterDataQuery($callback) |
||
119 | { |
||
120 | if ($this->inAlterDataQueryCall) { |
||
121 | $list = $this; |
||
122 | |||
123 | $res = call_user_func($callback, $list->dataQuery, $list); |
||
124 | if ($res) { |
||
125 | $list->dataQuery = $res; |
||
126 | } |
||
127 | |||
128 | return $list; |
||
129 | } |
||
130 | |||
131 | $list = clone $this; |
||
132 | $list->inAlterDataQueryCall = true; |
||
133 | |||
134 | try { |
||
135 | $res = $callback($list->dataQuery, $list); |
||
136 | if ($res) { |
||
137 | $list->dataQuery = $res; |
||
138 | } |
||
139 | } catch (Exception $e) { |
||
140 | $list->inAlterDataQueryCall = false; |
||
141 | throw $e; |
||
142 | } |
||
143 | |||
144 | $list->inAlterDataQueryCall = false; |
||
145 | return $list; |
||
146 | } |
||
147 | |||
148 | /** |
||
149 | * Return a new DataList instance with the underlying {@link DataQuery} object changed |
||
150 | * |
||
151 | * @param DataQuery $dataQuery |
||
152 | * @return static |
||
153 | */ |
||
154 | public function setDataQuery(DataQuery $dataQuery) |
||
155 | { |
||
156 | $clone = clone $this; |
||
157 | $clone->dataQuery = $dataQuery; |
||
158 | return $clone; |
||
159 | } |
||
160 | |||
161 | /** |
||
162 | * Returns a new DataList instance with the specified query parameter assigned |
||
163 | * |
||
164 | * @param string|array $keyOrArray Either the single key to set, or an array of key value pairs to set |
||
165 | * @param mixed $val If $keyOrArray is not an array, this is the value to set |
||
166 | * @return static |
||
167 | */ |
||
168 | public function setDataQueryParam($keyOrArray, $val = null) |
||
169 | { |
||
170 | $clone = clone $this; |
||
171 | |||
172 | if (is_array($keyOrArray)) { |
||
173 | foreach ($keyOrArray as $key => $value) { |
||
174 | $clone->dataQuery->setQueryParam($key, $value); |
||
175 | } |
||
176 | } else { |
||
177 | $clone->dataQuery->setQueryParam($keyOrArray, $val); |
||
178 | } |
||
179 | |||
180 | return $clone; |
||
181 | } |
||
182 | |||
183 | /** |
||
184 | * Returns the SQL query that will be used to get this DataList's records. Good for debugging. :-) |
||
185 | * |
||
186 | * @param array $parameters Out variable for parameters required for this query |
||
187 | * @return string The resulting SQL query (may be paramaterised) |
||
188 | */ |
||
189 | public function sql(&$parameters = []) |
||
190 | { |
||
191 | return $this->dataQuery->query()->sql($parameters); |
||
192 | } |
||
193 | |||
194 | /** |
||
195 | * Return a new DataList instance with a WHERE clause added to this list's query. |
||
196 | * |
||
197 | * Supports parameterised queries. |
||
198 | * See SQLSelect::addWhere() for syntax examples, although DataList |
||
199 | * won't expand multiple method arguments as SQLSelect does. |
||
200 | * |
||
201 | * @param string|array|SQLConditionGroup $filter Predicate(s) to set, as escaped SQL statements or |
||
202 | * paramaterised queries |
||
203 | * @return static |
||
204 | */ |
||
205 | public function where($filter) |
||
206 | { |
||
207 | return $this->alterDataQuery(function (DataQuery $query) use ($filter) { |
||
208 | $query->where($filter); |
||
209 | }); |
||
210 | } |
||
211 | |||
212 | /** |
||
213 | * Return a new DataList instance with a WHERE clause added to this list's query. |
||
214 | * All conditions provided in the filter will be joined with an OR |
||
215 | * |
||
216 | * Supports parameterised queries. |
||
217 | * See SQLSelect::addWhere() for syntax examples, although DataList |
||
218 | * won't expand multiple method arguments as SQLSelect does. |
||
219 | * |
||
220 | * @param string|array|SQLConditionGroup $filter Predicate(s) to set, as escaped SQL statements or |
||
221 | * paramaterised queries |
||
222 | * @return static |
||
223 | */ |
||
224 | public function whereAny($filter) |
||
225 | { |
||
226 | return $this->alterDataQuery(function (DataQuery $query) use ($filter) { |
||
227 | $query->whereAny($filter); |
||
228 | }); |
||
229 | } |
||
230 | |||
231 | |||
232 | |||
233 | /** |
||
234 | * Returns true if this DataList can be sorted by the given field. |
||
235 | * |
||
236 | * @param string $fieldName |
||
237 | * @return boolean |
||
238 | */ |
||
239 | public function canSortBy($fieldName) |
||
240 | { |
||
241 | return $this->dataQuery()->query()->canSortBy($fieldName); |
||
242 | } |
||
243 | |||
244 | /** |
||
245 | * Returns true if this DataList can be filtered by the given field. |
||
246 | * |
||
247 | * @param string $fieldName (May be a related field in dot notation like Member.FirstName) |
||
248 | * @return boolean |
||
249 | */ |
||
250 | public function canFilterBy($fieldName) |
||
251 | { |
||
252 | $model = singleton($this->dataClass); |
||
253 | $relations = explode(".", $fieldName); |
||
254 | // First validate the relationships |
||
255 | $fieldName = array_pop($relations); |
||
256 | foreach ($relations as $r) { |
||
257 | $relationClass = $model->getRelationClass($r); |
||
258 | if (!$relationClass) { |
||
259 | return false; |
||
260 | } |
||
261 | $model = singleton($relationClass); |
||
262 | if (!$model) { |
||
263 | return false; |
||
264 | } |
||
265 | } |
||
266 | // Then check field |
||
267 | if ($model->hasDatabaseField($fieldName)) { |
||
268 | return true; |
||
269 | } |
||
270 | return false; |
||
271 | } |
||
272 | |||
273 | /** |
||
274 | * Return a new DataList instance with the records returned in this query |
||
275 | * restricted by a limit clause. |
||
276 | * |
||
277 | * @param int $limit |
||
278 | * @param int $offset |
||
279 | * @return static |
||
280 | */ |
||
281 | public function limit($limit, $offset = 0) |
||
282 | { |
||
283 | return $this->alterDataQuery(function (DataQuery $query) use ($limit, $offset) { |
||
284 | $query->limit($limit, $offset); |
||
285 | }); |
||
286 | } |
||
287 | |||
288 | /** |
||
289 | * Return a new DataList instance with distinct records or not |
||
290 | * |
||
291 | * @param bool $value |
||
292 | * @return static |
||
293 | */ |
||
294 | public function distinct($value) |
||
295 | { |
||
296 | return $this->alterDataQuery(function (DataQuery $query) use ($value) { |
||
297 | $query->distinct($value); |
||
298 | }); |
||
299 | } |
||
300 | |||
301 | /** |
||
302 | * Return a new DataList instance as a copy of this data list with the sort |
||
303 | * order set. |
||
304 | * |
||
305 | * @see SS_List::sort() |
||
306 | * @see SQLSelect::orderby |
||
307 | * @example $list = $list->sort('Name'); // default ASC sorting |
||
308 | * @example $list = $list->sort('Name DESC'); // DESC sorting |
||
309 | * @example $list = $list->sort('Name', 'ASC'); |
||
310 | * @example $list = $list->sort(array('Name'=>'ASC', 'Age'=>'DESC')); |
||
311 | * |
||
312 | * @param String|array Escaped SQL statement. If passed as array, all keys and values are assumed to be escaped. |
||
|
|||
313 | * @return static |
||
314 | */ |
||
315 | public function sort() |
||
360 | } |
||
361 | } |
||
362 | }); |
||
363 | } |
||
364 | |||
365 | /** |
||
366 | * Return a copy of this list which only includes items with these charactaristics |
||
367 | * |
||
368 | * @see SS_List::filter() |
||
369 | * |
||
370 | * @example $list = $list->filter('Name', 'bob'); // only bob in the list |
||
371 | * @example $list = $list->filter('Name', array('aziz', 'bob'); // aziz and bob in list |
||
372 | * @example $list = $list->filter(array('Name'=>'bob', 'Age'=>21)); // bob with the age 21 |
||
373 | * @example $list = $list->filter(array('Name'=>'bob', 'Age'=>array(21, 43))); // bob with the Age 21 or 43 |
||
374 | * @example $list = $list->filter(array('Name'=>array('aziz','bob'), 'Age'=>array(21, 43))); |
||
375 | * // aziz with the age 21 or 43 and bob with the Age 21 or 43 |
||
376 | * |
||
377 | * Note: When filtering on nullable columns, null checks will be automatically added. |
||
378 | * E.g. ->filter('Field:not', 'value) will generate '... OR "Field" IS NULL', and |
||
379 | * ->filter('Field:not', null) will generate '"Field" IS NOT NULL' |
||
380 | * |
||
381 | * @todo extract the sql from $customQuery into a SQLGenerator class |
||
382 | * |
||
383 | * @param string|array Escaped SQL statement. If passed as array, all keys and values will be escaped internally |
||
384 | * @return $this |
||
385 | */ |
||
386 | public function filter() |
||
387 | { |
||
388 | // Validate and process arguments |
||
389 | $arguments = func_get_args(); |
||
390 | switch (sizeof($arguments)) { |
||
391 | case 1: |
||
392 | $filters = $arguments[0]; |
||
393 | |||
394 | break; |
||
395 | case 2: |
||
396 | $filters = [$arguments[0] => $arguments[1]]; |
||
397 | |||
398 | break; |
||
399 | default: |
||
400 | throw new InvalidArgumentException('Incorrect number of arguments passed to filter()'); |
||
401 | } |
||
402 | |||
403 | return $this->addFilter($filters); |
||
404 | } |
||
405 | |||
406 | /** |
||
407 | * Return a new instance of the list with an added filter |
||
408 | * |
||
409 | * @param array $filterArray |
||
410 | * @return $this |
||
411 | */ |
||
412 | public function addFilter($filterArray) |
||
413 | { |
||
414 | $list = $this; |
||
415 | |||
416 | foreach ($filterArray as $expression => $value) { |
||
417 | $filter = $this->createSearchFilter($expression, $value); |
||
418 | $list = $list->alterDataQuery([$filter, 'apply']); |
||
419 | } |
||
420 | |||
421 | return $list; |
||
422 | } |
||
423 | |||
424 | /** |
||
425 | * Return a copy of this list which contains items matching any of these charactaristics. |
||
426 | * |
||
427 | * @example // only bob in the list |
||
428 | * $list = $list->filterAny('Name', 'bob'); |
||
429 | * // SQL: WHERE "Name" = 'bob' |
||
430 | * @example // azis or bob in the list |
||
431 | * $list = $list->filterAny('Name', array('aziz', 'bob'); |
||
432 | * // SQL: WHERE ("Name" IN ('aziz','bob')) |
||
433 | * @example // bob or anyone aged 21 in the list |
||
434 | * $list = $list->filterAny(array('Name'=>'bob, 'Age'=>21)); |
||
435 | * // SQL: WHERE ("Name" = 'bob' OR "Age" = '21') |
||
436 | * @example // bob or anyone aged 21 or 43 in the list |
||
437 | * $list = $list->filterAny(array('Name'=>'bob, 'Age'=>array(21, 43))); |
||
438 | * // SQL: WHERE ("Name" = 'bob' OR ("Age" IN ('21', '43')) |
||
439 | * @example // all bobs, phils or anyone aged 21 or 43 in the list |
||
440 | * $list = $list->filterAny(array('Name'=>array('bob','phil'), 'Age'=>array(21, 43))); |
||
441 | * // SQL: WHERE (("Name" IN ('bob', 'phil')) OR ("Age" IN ('21', '43')) |
||
442 | * |
||
443 | * @todo extract the sql from this method into a SQLGenerator class |
||
444 | * |
||
445 | * @param string|array See {@link filter()} |
||
446 | * @return static |
||
447 | */ |
||
448 | public function filterAny() |
||
449 | { |
||
450 | $numberFuncArgs = count(func_get_args()); |
||
451 | $whereArguments = []; |
||
452 | |||
453 | if ($numberFuncArgs == 1 && is_array(func_get_arg(0))) { |
||
454 | $whereArguments = func_get_arg(0); |
||
455 | } elseif ($numberFuncArgs == 2) { |
||
456 | $whereArguments[func_get_arg(0)] = func_get_arg(1); |
||
457 | } else { |
||
458 | throw new InvalidArgumentException('Incorrect number of arguments passed to filterAny()'); |
||
459 | } |
||
460 | |||
461 | return $this->alterDataQuery(function (DataQuery $query) use ($whereArguments) { |
||
462 | $subquery = $query->disjunctiveGroup(); |
||
463 | |||
464 | foreach ($whereArguments as $field => $value) { |
||
465 | $filter = $this->createSearchFilter($field, $value); |
||
466 | $filter->apply($subquery); |
||
467 | } |
||
468 | }); |
||
469 | } |
||
470 | |||
471 | /** |
||
472 | * Note that, in the current implementation, the filtered list will be an ArrayList, but this may change in a |
||
473 | * future implementation. |
||
474 | * @see Filterable::filterByCallback() |
||
475 | * |
||
476 | * @example $list = $list->filterByCallback(function($item, $list) { return $item->Age == 9; }) |
||
477 | * @param callable $callback |
||
478 | * @return ArrayList (this may change in future implementations) |
||
479 | */ |
||
480 | public function filterByCallback($callback) |
||
481 | { |
||
482 | if (!is_callable($callback)) { |
||
483 | throw new LogicException(sprintf( |
||
484 | "SS_Filterable::filterByCallback() passed callback must be callable, '%s' given", |
||
485 | gettype($callback) |
||
486 | )); |
||
487 | } |
||
488 | /** @var ArrayList $output */ |
||
489 | $output = ArrayList::create(); |
||
490 | foreach ($this as $item) { |
||
491 | if (call_user_func($callback, $item, $this)) { |
||
492 | $output->push($item); |
||
493 | } |
||
494 | } |
||
495 | return $output; |
||
496 | } |
||
497 | |||
498 | /** |
||
499 | * Given a field or relation name, apply it safely to this datalist. |
||
500 | * |
||
501 | * Unlike getRelationName, this is immutable and will fallback to the quoted field |
||
502 | * name if not a relation. |
||
503 | * |
||
504 | * @param string $field Name of field or relation to apply |
||
505 | * @param string &$columnName Quoted column name |
||
506 | * @param bool $linearOnly Set to true to restrict to linear relations only. Set this |
||
507 | * if this relation will be used for sorting, and should not include duplicate rows. |
||
508 | * @return $this DataList with this relation applied |
||
509 | */ |
||
510 | public function applyRelation($field, &$columnName = null, $linearOnly = false) |
||
511 | { |
||
512 | // If field is invalid, return it without modification |
||
513 | if (!$this->isValidRelationName($field)) { |
||
514 | $columnName = $field; |
||
515 | return $this; |
||
516 | } |
||
517 | |||
518 | // Simple fields without relations are mapped directly |
||
519 | if (strpos($field, '.') === false) { |
||
520 | $columnName = '"' . $field . '"'; |
||
521 | return $this; |
||
522 | } |
||
523 | |||
524 | return $this->alterDataQuery( |
||
525 | function (DataQuery $query) use ($field, &$columnName, $linearOnly) { |
||
526 | $relations = explode('.', $field); |
||
527 | $fieldName = array_pop($relations); |
||
528 | |||
529 | // Apply relation |
||
530 | $relationModelName = $query->applyRelation($relations, $linearOnly); |
||
531 | $relationPrefix = $query->applyRelationPrefix($relations); |
||
532 | |||
533 | // Find the db field the relation belongs to |
||
534 | $columnName = DataObject::getSchema() |
||
535 | ->sqlColumnForField($relationModelName, $fieldName, $relationPrefix); |
||
536 | } |
||
537 | ); |
||
538 | } |
||
539 | |||
540 | /** |
||
541 | * Check if the given field specification could be interpreted as an unquoted relation name |
||
542 | * |
||
543 | * @param string $field |
||
544 | * @return bool |
||
545 | */ |
||
546 | protected function isValidRelationName($field) |
||
547 | { |
||
548 | return preg_match('/^[A-Z0-9._]+$/i', $field); |
||
549 | } |
||
550 | |||
551 | /** |
||
552 | * Given a filter expression and value construct a {@see SearchFilter} instance |
||
553 | * |
||
554 | * @param string $filter E.g. `Name:ExactMatch:not`, `Name:ExactMatch`, `Name:not`, `Name` |
||
555 | * @param mixed $value Value of the filter |
||
556 | * @return SearchFilter |
||
557 | */ |
||
558 | protected function createSearchFilter($filter, $value) |
||
559 | { |
||
560 | // Field name is always the first component |
||
561 | $fieldArgs = explode(':', $filter); |
||
562 | $fieldName = array_shift($fieldArgs); |
||
563 | |||
564 | // Inspect type of second argument to determine context |
||
565 | $secondArg = array_shift($fieldArgs); |
||
566 | $modifiers = $fieldArgs; |
||
567 | if (!$secondArg) { |
||
568 | // Use default filter if none specified. E.g. `->filter(['Name' => $myname])` |
||
569 | $filterServiceName = 'DataListFilter.default'; |
||
570 | } else { |
||
571 | // The presence of a second argument is by default ambiguous; We need to query |
||
572 | // Whether this is a valid modifier on the default filter, or a filter itself. |
||
573 | /** @var SearchFilter $defaultFilterInstance */ |
||
574 | $defaultFilterInstance = Injector::inst()->get('DataListFilter.default'); |
||
575 | if (in_array(strtolower($secondArg), $defaultFilterInstance->getSupportedModifiers())) { |
||
576 | // Treat second (and any subsequent) argument as modifiers, using default filter |
||
577 | $filterServiceName = 'DataListFilter.default'; |
||
578 | array_unshift($modifiers, $secondArg); |
||
579 | } else { |
||
580 | // Second argument isn't a valid modifier, so assume is filter identifier |
||
581 | $filterServiceName = "DataListFilter.{$secondArg}"; |
||
582 | } |
||
583 | } |
||
584 | |||
585 | // Build instance |
||
586 | return Injector::inst()->create($filterServiceName, $fieldName, $value, $modifiers); |
||
587 | } |
||
588 | |||
589 | /** |
||
590 | * Return a copy of this list which does not contain any items that match all params |
||
591 | * |
||
592 | * @example $list = $list->exclude('Name', 'bob'); // exclude bob from list |
||
593 | * @example $list = $list->exclude('Name', array('aziz', 'bob'); // exclude aziz and bob from list |
||
594 | * @example $list = $list->exclude(array('Name'=>'bob, 'Age'=>21)); // exclude bob that has Age 21 |
||
595 | * @example $list = $list->exclude(array('Name'=>'bob, 'Age'=>array(21, 43))); // exclude bob with Age 21 or 43 |
||
596 | * @example $list = $list->exclude(array('Name'=>array('bob','phil'), 'Age'=>array(21, 43))); |
||
597 | * // bob age 21 or 43, phil age 21 or 43 would be excluded |
||
598 | * |
||
599 | * @todo extract the sql from this method into a SQLGenerator class |
||
600 | * |
||
601 | * @param string|array |
||
602 | * @param string [optional] |
||
603 | * |
||
604 | * @return $this |
||
605 | */ |
||
606 | public function exclude() |
||
607 | { |
||
608 | $numberFuncArgs = count(func_get_args()); |
||
609 | $whereArguments = []; |
||
610 | |||
611 | if ($numberFuncArgs == 1 && is_array(func_get_arg(0))) { |
||
612 | $whereArguments = func_get_arg(0); |
||
613 | } elseif ($numberFuncArgs == 2) { |
||
614 | $whereArguments[func_get_arg(0)] = func_get_arg(1); |
||
615 | } else { |
||
616 | throw new InvalidArgumentException('Incorrect number of arguments passed to exclude()'); |
||
617 | } |
||
618 | |||
619 | return $this->alterDataQuery(function (DataQuery $query) use ($whereArguments) { |
||
620 | $subquery = $query->disjunctiveGroup(); |
||
621 | |||
622 | foreach ($whereArguments as $field => $value) { |
||
623 | $filter = $this->createSearchFilter($field, $value); |
||
624 | $filter->exclude($subquery); |
||
625 | } |
||
626 | }); |
||
627 | } |
||
628 | |||
629 | /** |
||
630 | * Return a copy of this list which does not contain any items with any of these params |
||
631 | * |
||
632 | * @example $list = $list->excludeAny('Name', 'bob'); // exclude bob from list |
||
633 | * @example $list = $list->excludeAny('Name', array('aziz', 'bob'); // exclude aziz and bob from list |
||
634 | * @example $list = $list->excludeAny(array('Name'=>'bob, 'Age'=>21)); // exclude bob or Age 21 |
||
635 | * @example $list = $list->excludeAny(array('Name'=>'bob, 'Age'=>array(21, 43))); // exclude bob or Age 21 or 43 |
||
636 | * @example $list = $list->excludeAny(array('Name'=>array('bob','phil'), 'Age'=>array(21, 43))); |
||
637 | * // bob, phil, 21 or 43 would be excluded |
||
638 | * |
||
639 | * @param string|array |
||
640 | * @param string [optional] |
||
641 | * |
||
642 | * @return $this |
||
643 | */ |
||
644 | public function excludeAny() |
||
645 | { |
||
646 | $numberFuncArgs = count(func_get_args()); |
||
647 | $whereArguments = []; |
||
648 | |||
649 | if ($numberFuncArgs == 1 && is_array(func_get_arg(0))) { |
||
650 | $whereArguments = func_get_arg(0); |
||
651 | } elseif ($numberFuncArgs == 2) { |
||
652 | $whereArguments[func_get_arg(0)] = func_get_arg(1); |
||
653 | } else { |
||
654 | throw new InvalidArgumentException('Incorrect number of arguments passed to excludeAny()'); |
||
655 | } |
||
656 | |||
657 | return $this->alterDataQuery(function (DataQuery $dataQuery) use ($whereArguments) { |
||
658 | foreach ($whereArguments as $field => $value) { |
||
659 | $filter = $this->createSearchFilter($field, $value); |
||
660 | $filter->exclude($dataQuery); |
||
661 | } |
||
662 | return $dataQuery; |
||
663 | }); |
||
664 | } |
||
665 | |||
666 | /** |
||
667 | * This method returns a copy of this list that does not contain any DataObjects that exists in $list |
||
668 | * |
||
669 | * The $list passed needs to contain the same dataclass as $this |
||
670 | * |
||
671 | * @param DataList $list |
||
672 | * @return static |
||
673 | * @throws InvalidArgumentException |
||
674 | */ |
||
675 | public function subtract(DataList $list) |
||
676 | { |
||
677 | if ($this->dataClass() != $list->dataClass()) { |
||
678 | throw new InvalidArgumentException('The list passed must have the same dataclass as this class'); |
||
679 | } |
||
680 | |||
681 | return $this->alterDataQuery(function (DataQuery $query) use ($list) { |
||
682 | $query->subtract($list->dataQuery()); |
||
683 | }); |
||
684 | } |
||
685 | |||
686 | /** |
||
687 | * Return a new DataList instance with an inner join clause added to this list's query. |
||
688 | * |
||
689 | * @param string $table Table name (unquoted and as escaped SQL) |
||
690 | * @param string $onClause Escaped SQL statement, e.g. '"Table1"."ID" = "Table2"."ID"' |
||
691 | * @param string $alias - if you want this table to be aliased under another name |
||
692 | * @param int $order A numerical index to control the order that joins are added to the query; lower order values |
||
693 | * will cause the query to appear first. The default is 20, and joins created automatically by the |
||
694 | * ORM have a value of 10. |
||
695 | * @param array $parameters Any additional parameters if the join is a parameterised subquery |
||
696 | * @return static |
||
697 | */ |
||
698 | public function innerJoin($table, $onClause, $alias = null, $order = 20, $parameters = []) |
||
699 | { |
||
700 | return $this->alterDataQuery(function (DataQuery $query) use ($table, $onClause, $alias, $order, $parameters) { |
||
701 | $query->innerJoin($table, $onClause, $alias, $order, $parameters); |
||
702 | }); |
||
703 | } |
||
704 | |||
705 | /** |
||
706 | * Return a new DataList instance with a left join clause added to this list's query. |
||
707 | * |
||
708 | * @param string $table Table name (unquoted and as escaped SQL) |
||
709 | * @param string $onClause Escaped SQL statement, e.g. '"Table1"."ID" = "Table2"."ID"' |
||
710 | * @param string $alias - if you want this table to be aliased under another name |
||
711 | * @param int $order A numerical index to control the order that joins are added to the query; lower order values |
||
712 | * will cause the query to appear first. The default is 20, and joins created automatically by the |
||
713 | * ORM have a value of 10. |
||
714 | * @param array $parameters Any additional parameters if the join is a parameterised subquery |
||
715 | * @return static |
||
716 | */ |
||
717 | public function leftJoin($table, $onClause, $alias = null, $order = 20, $parameters = []) |
||
721 | }); |
||
722 | } |
||
723 | |||
724 | /** |
||
725 | * Return an array of the actual items that this DataList contains at this stage. |
||
726 | * This is when the query is actually executed. |
||
727 | * |
||
728 | * @return array |
||
729 | */ |
||
730 | public function toArray() |
||
731 | { |
||
732 | $query = $this->dataQuery->query(); |
||
733 | $rows = $query->execute(); |
||
734 | $results = []; |
||
735 | |||
736 | foreach ($rows as $row) { |
||
737 | $results[] = $this->createDataObject($row); |
||
738 | } |
||
739 | |||
740 | return $results; |
||
741 | } |
||
742 | |||
743 | /** |
||
744 | * Return this list as an array and every object it as an sub array as well |
||
745 | * |
||
746 | * @return array |
||
747 | */ |
||
748 | public function toNestedArray() |
||
757 | } |
||
758 | |||
759 | /** |
||
760 | * Walks the list using the specified callback |
||
761 | * |
||
762 | * @param callable $callback |
||
763 | * @return $this |
||
764 | */ |
||
765 | public function each($callback) |
||
766 | { |
||
772 | } |
||
773 | |||
774 | /** |
||
775 | * Returns a generator for this DataList |
||
776 | * |
||
777 | * @return \Generator&DataObject[] |
||
778 | */ |
||
779 | public function getGenerator() |
||
780 | { |
||
781 | $query = $this->dataQuery->query()->execute(); |
||
782 | |||
783 | while ($row = $query->record()) { |
||
784 | yield $this->createDataObject($row); |
||
785 | } |
||
786 | } |
||
787 | |||
788 | public function debug() |
||
789 | { |
||
790 | $val = "<h2>" . static::class . "</h2><ul>"; |
||
791 | foreach ($this->toNestedArray() as $item) { |
||
792 | $val .= "<li style=\"list-style-type: disc; margin-left: 20px\">" . Debug::text($item) . "</li>"; |
||
793 | } |
||
794 | $val .= "</ul>"; |
||
795 | return $val; |
||
796 | } |
||
797 | |||
798 | /** |
||
799 | * Returns a map of this list |
||
800 | * |
||
801 | * @param string $keyField - the 'key' field of the result array |
||
802 | * @param string $titleField - the value field of the result array |
||
803 | * @return Map |
||
804 | */ |
||
805 | public function map($keyField = 'ID', $titleField = 'Title') |
||
806 | { |
||
807 | return new Map($this, $keyField, $titleField); |
||
808 | } |
||
809 | |||
810 | /** |
||
811 | * Create a DataObject from the given SQL row |
||
812 | * |
||
813 | * @param array $row |
||
814 | * @return DataObject |
||
815 | */ |
||
816 | public function createDataObject($row) |
||
837 | } |
||
838 | |||
839 | /** |
||
840 | * Get query parameters for this list. |
||
841 | * These values will be assigned as query parameters to newly created objects from this list. |
||
842 | * |
||
843 | * @return array |
||
844 | */ |
||
845 | public function getQueryParams() |
||
846 | { |
||
847 | return $this->dataQuery()->getQueryParams(); |
||
848 | } |
||
849 | |||
850 | /** |
||
851 | * Returns an Iterator for this DataList. |
||
852 | * This function allows you to use DataLists in foreach loops |
||
853 | * |
||
854 | * @return ArrayIterator |
||
855 | */ |
||
856 | public function getIterator() |
||
859 | } |
||
860 | |||
861 | /** |
||
862 | * Return the number of items in this DataList |
||
863 | * |
||
864 | * @return int |
||
865 | */ |
||
866 | public function count() |
||
867 | { |
||
868 | return $this->dataQuery->count(); |
||
869 | } |
||
870 | |||
871 | /** |
||
872 | * Return the maximum value of the given field in this DataList |
||
873 | * |
||
874 | * @param string $fieldName |
||
875 | * @return mixed |
||
876 | */ |
||
877 | public function max($fieldName) |
||
878 | { |
||
879 | return $this->dataQuery->max($fieldName); |
||
880 | } |
||
881 | |||
882 | /** |
||
883 | * Return the minimum value of the given field in this DataList |
||
884 | * |
||
885 | * @param string $fieldName |
||
886 | * @return mixed |
||
887 | */ |
||
888 | public function min($fieldName) |
||
889 | { |
||
890 | return $this->dataQuery->min($fieldName); |
||
891 | } |
||
892 | |||
893 | /** |
||
894 | * Return the average value of the given field in this DataList |
||
895 | * |
||
896 | * @param string $fieldName |
||
897 | * @return mixed |
||
898 | */ |
||
899 | public function avg($fieldName) |
||
900 | { |
||
901 | return $this->dataQuery->avg($fieldName); |
||
902 | } |
||
903 | |||
904 | /** |
||
905 | * Return the sum of the values of the given field in this DataList |
||
906 | * |
||
907 | * @param string $fieldName |
||
908 | * @return mixed |
||
909 | */ |
||
910 | public function sum($fieldName) |
||
911 | { |
||
912 | return $this->dataQuery->sum($fieldName); |
||
913 | } |
||
914 | |||
915 | |||
916 | /** |
||
917 | * Returns the first item in this DataList |
||
918 | * |
||
919 | * @return DataObject |
||
920 | */ |
||
921 | public function first() |
||
922 | { |
||
923 | foreach ($this->dataQuery->firstRow()->execute() as $row) { |
||
924 | return $this->createDataObject($row); |
||
925 | } |
||
926 | return null; |
||
927 | } |
||
928 | |||
929 | /** |
||
930 | * Returns the last item in this DataList |
||
931 | * |
||
932 | * @return DataObject |
||
933 | */ |
||
934 | public function last() |
||
935 | { |
||
936 | foreach ($this->dataQuery->lastRow()->execute() as $row) { |
||
937 | return $this->createDataObject($row); |
||
938 | } |
||
939 | return null; |
||
940 | } |
||
941 | |||
942 | /** |
||
943 | * Returns true if this DataList has items |
||
944 | * |
||
945 | * @return bool |
||
946 | */ |
||
947 | public function exists() |
||
948 | { |
||
949 | return $this->count() > 0; |
||
950 | } |
||
951 | |||
952 | /** |
||
953 | * Find the first DataObject of this DataList where the given key = value |
||
954 | * |
||
955 | * @param string $key |
||
956 | * @param string $value |
||
957 | * @return DataObject|null |
||
958 | */ |
||
959 | public function find($key, $value) |
||
960 | { |
||
961 | return $this->filter($key, $value)->first(); |
||
962 | } |
||
963 | |||
964 | /** |
||
965 | * Restrict the columns to fetch into this DataList |
||
966 | * |
||
967 | * @param array $queriedColumns |
||
968 | * @return static |
||
969 | */ |
||
970 | public function setQueriedColumns($queriedColumns) |
||
971 | { |
||
972 | return $this->alterDataQuery(function (DataQuery $query) use ($queriedColumns) { |
||
973 | $query->setQueriedColumns($queriedColumns); |
||
974 | }); |
||
975 | } |
||
976 | |||
977 | /** |
||
978 | * Filter this list to only contain the given Primary IDs |
||
979 | * |
||
980 | * @param array $ids Array of integers |
||
981 | * @return $this |
||
982 | */ |
||
983 | public function byIDs($ids) |
||
986 | } |
||
987 | |||
988 | /** |
||
989 | * Return the first DataObject with the given ID |
||
990 | * |
||
991 | * @param int $id |
||
992 | * @return DataObject |
||
993 | */ |
||
994 | public function byID($id) |
||
995 | { |
||
996 | return $this->filter('ID', $id)->first(); |
||
997 | } |
||
998 | |||
999 | /** |
||
1000 | * Returns an array of a single field value for all items in the list. |
||
1001 | * |
||
1002 | * @param string $colName |
||
1003 | * @return array |
||
1004 | */ |
||
1005 | public function column($colName = "ID") |
||
1006 | { |
||
1007 | return $this->dataQuery->distinct(false)->column($colName); |
||
1008 | } |
||
1009 | |||
1010 | /** |
||
1011 | * Returns a unque array of a single field value for all items in the list. |
||
1012 | * |
||
1013 | * @param string $colName |
||
1014 | * @return array |
||
1015 | */ |
||
1016 | public function columnUnique($colName = "ID") |
||
1017 | { |
||
1018 | return $this->dataQuery->distinct(true)->column($colName); |
||
1019 | } |
||
1020 | |||
1021 | // Member altering methods |
||
1022 | |||
1023 | /** |
||
1024 | * Sets the ComponentSet to be the given ID list. |
||
1025 | * Records will be added and deleted as appropriate. |
||
1026 | * |
||
1027 | * @param array $idList List of IDs. |
||
1028 | */ |
||
1029 | public function setByIDList($idList) |
||
1030 | { |
||
1031 | $has = []; |
||
1032 | |||
1033 | // Index current data |
||
1034 | foreach ($this->column() as $id) { |
||
1035 | $has[$id] = true; |
||
1036 | } |
||
1037 | |||
1038 | // Keep track of items to delete |
||
1039 | $itemsToDelete = $has; |
||
1040 | |||
1041 | // add items in the list |
||
1042 | // $id is the database ID of the record |
||
1043 | if ($idList) { |
||
1044 | foreach ($idList as $id) { |
||
1045 | unset($itemsToDelete[$id]); |
||
1046 | if ($id && !isset($has[$id])) { |
||
1047 | $this->add($id); |
||
1048 | } |
||
1049 | } |
||
1050 | } |
||
1051 | |||
1052 | // Remove any items that haven't been mentioned |
||
1053 | $this->removeMany(array_keys($itemsToDelete)); |
||
1054 | } |
||
1055 | |||
1056 | /** |
||
1057 | * Returns an array with both the keys and values set to the IDs of the records in this list. |
||
1058 | * Does not respect sort order. Use ->column("ID") to get an ID list with the current sort. |
||
1059 | * |
||
1060 | * @return array |
||
1061 | */ |
||
1062 | public function getIDList() |
||
1063 | { |
||
1064 | $ids = $this->column("ID"); |
||
1065 | return $ids ? array_combine($ids, $ids) : []; |
||
1066 | } |
||
1067 | |||
1068 | /** |
||
1069 | * Returns a HasManyList or ManyMany list representing the querying of a relation across all |
||
1070 | * objects in this data list. For it to work, the relation must be defined on the data class |
||
1071 | * that you used to create this DataList. |
||
1072 | * |
||
1073 | * Example: Get members from all Groups: |
||
1074 | * |
||
1075 | * DataList::Create(\SilverStripe\Security\Group::class)->relation("Members") |
||
1076 | * |
||
1077 | * @param string $relationName |
||
1078 | * @return HasManyList|ManyManyList |
||
1079 | */ |
||
1080 | public function relation($relationName) |
||
1081 | { |
||
1082 | $ids = $this->column('ID'); |
||
1083 | $singleton = DataObject::singleton($this->dataClass); |
||
1084 | /** @var HasManyList|ManyManyList $relation */ |
||
1085 | $relation = $singleton->$relationName($ids); |
||
1086 | return $relation; |
||
1087 | } |
||
1088 | |||
1089 | public function dbObject($fieldName) |
||
1090 | { |
||
1091 | return singleton($this->dataClass)->dbObject($fieldName); |
||
1092 | } |
||
1093 | |||
1094 | /** |
||
1095 | * Add a number of items to the component set. |
||
1096 | * |
||
1097 | * @param array $items Items to add, as either DataObjects or IDs. |
||
1098 | * @return $this |
||
1099 | */ |
||
1100 | public function addMany($items) |
||
1106 | } |
||
1107 | |||
1108 | /** |
||
1109 | * Remove the items from this list with the given IDs |
||
1110 | * |
||
1111 | * @param array $idList |
||
1112 | * @return $this |
||
1113 | */ |
||
1114 | public function removeMany($idList) |
||
1115 | { |
||
1116 | foreach ($idList as $id) { |
||
1117 | $this->removeByID($id); |
||
1118 | } |
||
1119 | return $this; |
||
1120 | } |
||
1121 | |||
1122 | /** |
||
1123 | * Remove every element in this DataList matching the given $filter. |
||
1124 | * |
||
1125 | * @param string|array $filter - a sql type where filter |
||
1126 | * @return $this |
||
1127 | */ |
||
1128 | public function removeByFilter($filter) |
||
1134 | } |
||
1135 | |||
1136 | /** |
||
1137 | * Shuffle the datalist using a random function provided by the SQL engine |
||
1138 | * |
||
1139 | * @return $this |
||
1140 | */ |
||
1141 | public function shuffle() |
||
1142 | { |
||
1143 | return $this->sort(DB::get_conn()->random()); |
||
1144 | } |
||
1145 | |||
1146 | /** |
||
1147 | * Remove every element in this DataList. |
||
1148 | * |
||
1149 | * @return $this |
||
1150 | */ |
||
1151 | public function removeAll() |
||
1152 | { |
||
1153 | foreach ($this as $item) { |
||
1154 | $this->remove($item); |
||
1155 | } |
||
1156 | return $this; |
||
1157 | } |
||
1158 | |||
1159 | /** |
||
1160 | * This method are overloaded by HasManyList and ManyMany list to perform more sophisticated |
||
1161 | * list manipulation |
||
1162 | * |
||
1163 | * @param mixed $item |
||
1164 | */ |
||
1165 | public function add($item) |
||
1166 | { |
||
1167 | // Nothing needs to happen by default |
||
1168 | // TO DO: If a filter is given to this data list then |
||
1169 | } |
||
1170 | |||
1171 | /** |
||
1172 | * Return a new item to add to this DataList. |
||
1173 | * |
||
1174 | * @todo This doesn't factor in filters. |
||
1175 | * @param array $initialFields |
||
1176 | * @return DataObject |
||
1177 | */ |
||
1178 | public function newObject($initialFields = null) |
||
1179 | { |
||
1180 | $class = $this->dataClass; |
||
1181 | return Injector::inst()->create($class, $initialFields, false); |
||
1182 | } |
||
1183 | |||
1184 | /** |
||
1185 | * Remove this item by deleting it |
||
1186 | * |
||
1187 | * @param DataObject $item |
||
1188 | * @todo Allow for amendment of this behaviour - for example, we can remove an item from |
||
1189 | * an "ActiveItems" DataList by chaning the status to inactive. |
||
1190 | */ |
||
1191 | public function remove($item) |
||
1192 | { |
||
1193 | // By default, we remove an item from a DataList by deleting it. |
||
1194 | $this->removeByID($item->ID); |
||
1195 | } |
||
1196 | |||
1197 | /** |
||
1198 | * Remove an item from this DataList by ID |
||
1199 | * |
||
1200 | * @param int $itemID The primary ID |
||
1201 | */ |
||
1202 | public function removeByID($itemID) |
||
1203 | { |
||
1204 | $item = $this->byID($itemID); |
||
1205 | |||
1206 | if ($item) { |
||
1207 | $item->delete(); |
||
1208 | } |
||
1209 | } |
||
1210 | |||
1211 | /** |
||
1212 | * Reverses a list of items. |
||
1213 | * |
||
1214 | * @return static |
||
1215 | */ |
||
1216 | public function reverse() |
||
1220 | }); |
||
1221 | } |
||
1222 | |||
1223 | /** |
||
1224 | * Returns whether an item with $key exists |
||
1225 | * |
||
1226 | * @param mixed $key |
||
1227 | * @return bool |
||
1228 | */ |
||
1229 | public function offsetExists($key) |
||
1232 | } |
||
1233 | |||
1234 | /** |
||
1235 | * Returns item stored in list with index $key |
||
1236 | * |
||
1237 | * @param mixed $key |
||
1238 | * @return DataObject |
||
1239 | */ |
||
1240 | public function offsetGet($key) |
||
1243 | } |
||
1244 | |||
1245 | /** |
||
1246 | * Set an item with the key in $key |
||
1247 | * |
||
1248 | * @param mixed $key |
||
1249 | * @param mixed $value |
||
1250 | */ |
||
1251 | public function offsetSet($key, $value) |
||
1254 | } |
||
1255 | |||
1256 | /** |
||
1257 | * Unset an item with the key in $key |
||
1258 | * |
||
1259 | * @param mixed $key |
||
1260 | */ |
||
1261 | public function offsetUnset($key) |
||
1266 |
The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g.
excluded_paths: ["lib/*"]
, you can move it to the dependency path list as follows:For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths