|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
namespace Rb\Specification\Doctrine\Condition; |
|
4
|
|
|
|
|
5
|
|
|
use Doctrine\ORM\Query\Expr\Comparison as DoctrineComparison; |
|
6
|
|
|
use Doctrine\ORM\QueryBuilder; |
|
7
|
|
|
use Rb\Specification\Doctrine\AbstractSpecification; |
|
8
|
|
|
use Rb\Specification\Doctrine\Exception\InvalidArgumentException; |
|
9
|
|
|
|
|
10
|
|
|
class Comparison extends AbstractSpecification |
|
11
|
|
|
{ |
|
12
|
|
|
const EQ = '='; |
|
13
|
|
|
const NEQ = '<>'; |
|
14
|
|
|
const LT = '<'; |
|
15
|
|
|
const LTE = '<='; |
|
16
|
|
|
const GT = '>'; |
|
17
|
|
|
const GTE = '>='; |
|
18
|
|
|
const LIKE = 'LIKE'; |
|
19
|
|
|
|
|
20
|
|
|
/** |
|
21
|
|
|
* @var string[] |
|
22
|
|
|
*/ |
|
23
|
|
|
protected static $operators = [self::EQ, self::NEQ, self::LT, self::LTE, self::GT, self::GTE, self::LIKE]; |
|
24
|
|
|
|
|
25
|
|
|
/** |
|
26
|
|
|
* @var string |
|
27
|
|
|
*/ |
|
28
|
|
|
protected $value; |
|
29
|
|
|
|
|
30
|
|
|
/** |
|
31
|
|
|
* @var string |
|
32
|
|
|
*/ |
|
33
|
|
|
protected $operator; |
|
34
|
|
|
|
|
35
|
|
|
/** |
|
36
|
|
|
* @param string $operator |
|
37
|
|
|
* @param string $field |
|
38
|
|
|
* @param string $value |
|
39
|
|
|
* @param string|null $dqlAlias |
|
40
|
|
|
* |
|
41
|
|
|
* @throws InvalidArgumentException |
|
42
|
|
|
*/ |
|
43
|
|
|
public function __construct($operator, $field, $value, $dqlAlias = null) |
|
44
|
|
|
{ |
|
45
|
|
|
if (! in_array($operator, self::$operators, true)) { |
|
46
|
|
|
throw new InvalidArgumentException( |
|
47
|
|
|
sprintf( |
|
48
|
|
|
'"%s" is not a valid operator. Valid operators: %s', |
|
49
|
|
|
$operator, |
|
50
|
|
|
implode(', ', self::$operators) |
|
51
|
|
|
) |
|
52
|
|
|
); |
|
53
|
|
|
} |
|
54
|
|
|
|
|
55
|
|
|
$this->operator = $operator; |
|
56
|
|
|
$this->value = $value; |
|
57
|
|
|
|
|
58
|
|
|
parent::__construct($field, $dqlAlias); |
|
59
|
|
|
} |
|
60
|
|
|
|
|
61
|
|
|
/** |
|
62
|
|
|
* Return a string expression which can be used as condition (in WHERE-clause). |
|
63
|
|
|
* |
|
64
|
|
|
* @param QueryBuilder $queryBuilder |
|
65
|
|
|
* @param string $dqlAlias |
|
66
|
|
|
* |
|
67
|
|
|
* @return string |
|
68
|
|
|
*/ |
|
69
|
|
View Code Duplication |
public function modify(QueryBuilder $queryBuilder, $dqlAlias) |
|
|
|
|
|
|
70
|
|
|
{ |
|
71
|
|
|
$paramName = $this->generateParameterName($queryBuilder); |
|
72
|
|
|
$queryBuilder->setParameter($paramName, $this->value); |
|
73
|
|
|
|
|
74
|
|
|
return (string) new DoctrineComparison( |
|
75
|
|
|
$this->createPropertyWithAlias($dqlAlias), |
|
76
|
|
|
$this->operator, |
|
77
|
|
|
sprintf(':%s', $paramName) |
|
78
|
|
|
); |
|
79
|
|
|
} |
|
80
|
|
|
|
|
81
|
|
|
/** |
|
82
|
|
|
* Return automatically generated parameter name. |
|
83
|
|
|
* |
|
84
|
|
|
* @param QueryBuilder $queryBuilder |
|
85
|
|
|
* |
|
86
|
|
|
* @return string |
|
87
|
|
|
*/ |
|
88
|
|
|
protected function generateParameterName(QueryBuilder $queryBuilder) |
|
89
|
|
|
{ |
|
90
|
|
|
return sprintf('comparison_%d', count($queryBuilder->getParameters())); |
|
91
|
|
|
} |
|
92
|
|
|
} |
|
93
|
|
|
|
rikbruil /
Doctrine-Specification
Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.
You can also find more detailed suggestions in the “Code” section of your repository.