@@ 5-37 (lines=33) @@ | ||
2 | ||
3 | namespace Napp\Core\Dbal\Criteria; |
|
4 | ||
5 | class WithAttributeInValuesCriterion implements CriterionInterface |
|
6 | { |
|
7 | /** |
|
8 | * @var string |
|
9 | */ |
|
10 | protected $attribute; |
|
11 | ||
12 | /** |
|
13 | * @var array |
|
14 | */ |
|
15 | protected $values; |
|
16 | ||
17 | /** |
|
18 | * @param string $attribute |
|
19 | * @param array $values |
|
20 | */ |
|
21 | public function __construct($attribute, $values) |
|
22 | { |
|
23 | $this->attribute = $attribute; |
|
24 | $this->values = $values; |
|
25 | } |
|
26 | ||
27 | /** |
|
28 | * @param \Illuminate\Database\Eloquent\Builder $query |
|
29 | * @return \Illuminate\Database\Eloquent\Builder |
|
30 | */ |
|
31 | public function apply($query) |
|
32 | { |
|
33 | $query->getQuery()->whereIn($query->getModel()->getTable() . '.' . $this->attribute, $this->values); |
|
34 | ||
35 | return $query; |
|
36 | } |
|
37 | } |
|
38 |
@@ 5-37 (lines=33) @@ | ||
2 | ||
3 | namespace Napp\Core\Dbal\Criteria; |
|
4 | ||
5 | class WithAttributeNotInValuesCriterion implements CriterionInterface |
|
6 | { |
|
7 | /** |
|
8 | * @var string |
|
9 | */ |
|
10 | protected $attribute; |
|
11 | ||
12 | /** |
|
13 | * @var array |
|
14 | */ |
|
15 | protected $values; |
|
16 | ||
17 | /** |
|
18 | * @param string $attribute |
|
19 | * @param array $values |
|
20 | */ |
|
21 | public function __construct($attribute, $values) |
|
22 | { |
|
23 | $this->attribute = $attribute; |
|
24 | $this->values = $values; |
|
25 | } |
|
26 | ||
27 | /** |
|
28 | * @param \Illuminate\Database\Eloquent\Builder $query |
|
29 | * @return \Illuminate\Database\Eloquent\Builder |
|
30 | */ |
|
31 | public function apply($query) |
|
32 | { |
|
33 | $query->getQuery()->whereNotIn($query->getModel()->getTable() . '.' . $this->attribute, $this->values); |
|
34 | ||
35 | return $query; |
|
36 | } |
|
37 | } |
|
38 |