level23 /
druid-client
| 1 | <?php |
||
| 2 | declare(strict_types=1); |
||
| 3 | |||
| 4 | namespace Level23\Druid\Concerns; |
||
| 5 | |||
| 6 | use Closure; |
||
| 7 | use InvalidArgumentException; |
||
| 8 | use Level23\Druid\Filters\LikeFilter; |
||
| 9 | use Level23\Druid\Filters\FilterInterface; |
||
| 10 | use Level23\Druid\HavingFilters\HavingBuilder; |
||
| 11 | use Level23\Druid\HavingFilters\OrHavingFilter; |
||
| 12 | use Level23\Druid\HavingFilters\NotHavingFilter; |
||
| 13 | use Level23\Druid\HavingFilters\AndHavingFilter; |
||
| 14 | use Level23\Druid\HavingFilters\QueryHavingFilter; |
||
| 15 | use Level23\Druid\HavingFilters\EqualToHavingFilter; |
||
| 16 | use Level23\Druid\HavingFilters\LessThanHavingFilter; |
||
| 17 | use Level23\Druid\HavingFilters\HavingFilterInterface; |
||
| 18 | use Level23\Druid\HavingFilters\GreaterThanHavingFilter; |
||
| 19 | use Level23\Druid\HavingFilters\DimensionSelectorHavingFilter; |
||
| 20 | |||
| 21 | trait HasHaving |
||
| 22 | { |
||
| 23 | protected ?HavingFilterInterface $having = null; |
||
| 24 | |||
| 25 | /** |
||
| 26 | * Build our "having" part of the query. |
||
| 27 | * |
||
| 28 | * The operator can be '=', '>', '>=', '<', '<=', '<>', '!=' or 'like' |
||
| 29 | * |
||
| 30 | * @param Closure|string|FilterInterface|HavingFilterInterface $havingOrMetricOrClosure |
||
| 31 | * @param float|string|null $operator |
||
| 32 | * @param float|string|null|bool $value |
||
| 33 | * @param string $boolean |
||
| 34 | * |
||
| 35 | * @return $this |
||
| 36 | */ |
||
| 37 | 23 | public function having( |
|
| 38 | Closure|string|HavingFilterInterface|FilterInterface $havingOrMetricOrClosure, |
||
| 39 | float|string|null $operator = null, |
||
| 40 | float|string|bool|null $value = null, |
||
| 41 | string $boolean = 'and' |
||
| 42 | ): self { |
||
| 43 | 23 | $having = null; |
|
| 44 | |||
| 45 | 23 | if ($value === null && $operator !== null) { |
|
| 46 | 2 | $value = $operator; |
|
| 47 | 2 | $operator = '='; |
|
| 48 | } |
||
| 49 | |||
| 50 | 23 | if (is_string($havingOrMetricOrClosure) && is_string($operator) && $value !== null) { |
|
| 51 | 19 | if ($operator == '=') { |
|
| 52 | 6 | $having = new DimensionSelectorHavingFilter($havingOrMetricOrClosure, (string)$value); |
|
| 53 | 13 | } elseif ($operator == '<>' || $operator == '!=') { |
|
| 54 | 4 | $having = new NotHavingFilter(new DimensionSelectorHavingFilter($havingOrMetricOrClosure, |
|
| 55 | 4 | (string)$value)); |
|
| 56 | 9 | } elseif ($operator == '>') { |
|
| 57 | 3 | $having = new GreaterThanHavingFilter($havingOrMetricOrClosure, floatval($value)); |
|
| 58 | 6 | } elseif ($operator == '<') { |
|
| 59 | 1 | $having = new LessThanHavingFilter($havingOrMetricOrClosure, floatval($value)); |
|
| 60 | 5 | } elseif ($operator == '>=') { |
|
| 61 | 2 | $having = new OrHavingFilter([ |
|
| 62 | 2 | new GreaterThanHavingFilter($havingOrMetricOrClosure, floatval($value)), |
|
| 63 | 2 | new EqualToHavingFilter($havingOrMetricOrClosure, floatval($value)), |
|
| 64 | 2 | ]); |
|
| 65 | 3 | } elseif ($operator == '<=') { |
|
| 66 | 1 | $having = new OrHavingFilter([ |
|
| 67 | 1 | new LessThanHavingFilter($havingOrMetricOrClosure, floatval($value)), |
|
| 68 | 1 | new EqualToHavingFilter($havingOrMetricOrClosure, floatval($value)), |
|
| 69 | 1 | ]); |
|
| 70 | 2 | } elseif (strtolower($operator) == 'like') { |
|
| 71 | 1 | $having = new QueryHavingFilter(new LikeFilter($havingOrMetricOrClosure, (string)$value)); |
|
| 72 | 1 | } elseif (strtolower($operator) == 'not like') { |
|
| 73 | 19 | $having = new NotHavingFilter( |
|
| 74 | 19 | new QueryHavingFilter(new LikeFilter($havingOrMetricOrClosure, (string)$value)) |
|
| 75 | 19 | ); |
|
| 76 | } |
||
| 77 | 4 | } elseif ($havingOrMetricOrClosure instanceof FilterInterface) { |
|
| 78 | 1 | $having = new QueryHavingFilter($havingOrMetricOrClosure); |
|
| 79 | 3 | } elseif ($havingOrMetricOrClosure instanceof HavingFilterInterface) { |
|
| 80 | 2 | $having = $havingOrMetricOrClosure; |
|
| 81 | 2 | } elseif ($havingOrMetricOrClosure instanceof Closure) { |
|
| 82 | |||
| 83 | // let's create a bew builder object where the user can mess around with |
||
| 84 | 2 | $obj = new HavingBuilder(); |
|
| 85 | |||
| 86 | // call the user function |
||
| 87 | 2 | call_user_func($havingOrMetricOrClosure, $obj); |
|
| 88 | |||
| 89 | // Now retrieve the having filter which was created and add it to our current filter set. |
||
| 90 | 2 | $having = $obj->getHaving(); |
|
| 91 | } |
||
| 92 | |||
| 93 | 23 | if ($having === null) { |
|
| 94 | 1 | throw new InvalidArgumentException('The arguments which you have supplied cannot be parsed'); |
|
| 95 | } |
||
| 96 | |||
| 97 | 22 | strtolower($boolean) == 'and' ? $this->addAndHaving($having) : $this->addOrHaving($having); |
|
| 98 | |||
| 99 | 22 | return $this; |
|
| 100 | } |
||
| 101 | |||
| 102 | /** |
||
| 103 | * Add a having filter |
||
| 104 | * |
||
| 105 | * @param Closure|string|HavingFilterInterface $havingOrMetricOrClosure |
||
| 106 | * @param float|string|null $operator |
||
| 107 | * @param float|string|null $value |
||
| 108 | * |
||
| 109 | * @return $this |
||
| 110 | */ |
||
| 111 | 1 | public function orHaving( |
|
| 112 | Closure|HavingFilterInterface|string $havingOrMetricOrClosure, |
||
| 113 | float|string|null $operator = null, |
||
| 114 | float|string|null $value = null |
||
| 115 | ): self { |
||
| 116 | 1 | return $this->having($havingOrMetricOrClosure, $operator, $value, 'or'); |
|
| 117 | } |
||
| 118 | |||
| 119 | /** |
||
| 120 | * @return \Level23\Druid\HavingFilters\HavingFilterInterface|null |
||
| 121 | */ |
||
| 122 | 21 | public function getHaving(): ?HavingFilterInterface |
|
| 123 | { |
||
| 124 | 21 | return $this->having; |
|
| 125 | } |
||
| 126 | |||
| 127 | /** |
||
| 128 | * Helper method to add an OR filter |
||
| 129 | * |
||
| 130 | * @param \Level23\Druid\HavingFilters\HavingFilterInterface $havingFilter |
||
| 131 | */ |
||
| 132 | 1 | protected function addOrHaving(HavingFilterInterface $havingFilter): void |
|
| 133 | { |
||
| 134 | 1 | if (!$this->having instanceof HavingFilterInterface) { |
|
| 135 | 1 | $this->having = $havingFilter; |
|
| 136 | |||
| 137 | 1 | return; |
|
| 138 | } |
||
| 139 | |||
| 140 | 1 | if ($this->having instanceof OrHavingFilter) { |
|
| 141 | 1 | $this->having->addHavingFilter($havingFilter); |
|
|
0 ignored issues
–
show
Bug
introduced
by
Loading history...
|
|||
| 142 | |||
| 143 | 1 | return; |
|
| 144 | } |
||
| 145 | |||
| 146 | 1 | $this->having = new OrHavingFilter([$this->having, $havingFilter]); |
|
| 147 | } |
||
| 148 | |||
| 149 | /** |
||
| 150 | * Helper method to add an OR filter |
||
| 151 | * |
||
| 152 | * @param \Level23\Druid\HavingFilters\HavingFilterInterface $havingFilter |
||
| 153 | */ |
||
| 154 | 21 | protected function addAndHaving(HavingFilterInterface $havingFilter): void |
|
| 155 | { |
||
| 156 | 21 | if (!$this->having instanceof HavingFilterInterface) { |
|
| 157 | 21 | $this->having = $havingFilter; |
|
| 158 | |||
| 159 | 21 | return; |
|
| 160 | } |
||
| 161 | |||
| 162 | 17 | if ($this->having instanceof AndHavingFilter) { |
|
| 163 | 2 | $this->having->addHavingFilter($havingFilter); |
|
| 164 | |||
| 165 | 2 | return; |
|
| 166 | } |
||
| 167 | |||
| 168 | 17 | $this->having = new AndHavingFilter([$this->having, $havingFilter]); |
|
| 169 | } |
||
| 170 | } |