1 | <?php |
||
2 | |||
3 | namespace Kir\MySQL\Builder\Expr; |
||
4 | |||
5 | /** |
||
6 | * Defines fields that are sortable. Sortable fields have an alias. |
||
7 | * The alias can be passed as a sort specifier - along with the direction in which to sort. |
||
8 | */ |
||
9 | class DBOrderSpec implements DBOrderSpecInterface, OrderBySpecification { |
||
10 | /** @var array<string, string> */ |
||
11 | private $sortSpecification; |
||
12 | /** @var array<string, string> */ |
||
13 | private $sortingInstruction; |
||
14 | /** @var array<string, mixed> */ |
||
15 | private $options; |
||
16 | |||
17 | /** |
||
18 | * @param array<string, string> $sortSpecification |
||
19 | * @param array<string, string> $sortingInstruction |
||
20 | * @param array{max_sort_instructions?: positive-int} $options |
||
0 ignored issues
–
show
Documentation
Bug
introduced
by
![]() |
|||
21 | * @return static |
||
22 | */ |
||
23 | public static function from(array $sortSpecification, array $sortingInstruction, array $options = []) { |
||
24 | return new static($sortSpecification, $sortingInstruction, $options); |
||
25 | } |
||
26 | |||
27 | /** |
||
28 | * @inheritDoc |
||
29 | */ |
||
30 | public function __construct(array $sortSpecification, array $sortingInstruction, array $options = []) { |
||
31 | $this->sortSpecification = $sortSpecification; |
||
32 | $this->sortingInstruction = $sortingInstruction; |
||
33 | $this->options = $options; |
||
34 | } |
||
35 | |||
36 | /** |
||
37 | * @return array<int, array{string, string&('ASC'|'DESC')}> |
||
0 ignored issues
–
show
|
|||
38 | */ |
||
39 | public function getFields(): array { |
||
40 | $fields = []; |
||
41 | $max = $this->options['max_sort_instructions'] ?? 16; |
||
42 | foreach($this->sortingInstruction as $alias => $direction) { |
||
43 | $direction = strtolower($direction) === 'desc' ? 'DESC' : 'ASC'; |
||
44 | if(!array_key_exists($alias, $this->sortSpecification)) { |
||
45 | throw new DBSortAliasNotFoundException('Sorting: Alias for DB-Expression not found'); |
||
46 | } |
||
47 | $fields[] = [$this->sortSpecification[$alias], $direction]; |
||
48 | if($max < 1) { |
||
49 | throw new DBSortTooManyInstructionsException(); |
||
50 | } |
||
51 | $max--; |
||
52 | } |
||
53 | return $fields; |
||
54 | } |
||
55 | } |
||
56 |