|
@@ 167-172 (lines=6) @@
|
| 164 |
|
protected function buildQueryForAnd($queryBuilder, $key, $value) |
| 165 |
|
{ |
| 166 |
|
$sqlOptions = self::buildFilter([$key => $value]); |
| 167 |
|
if (in_array($sqlOptions['method'], ['in', 'notIn'])) { |
| 168 |
|
$queryBuilder->andWhere( |
| 169 |
|
$queryBuilder->expr()->{$sqlOptions['method']}($this->collection . "." . $sqlOptions['key'], $sqlOptions['value']) |
| 170 |
|
); |
| 171 |
|
return $queryBuilder; |
| 172 |
|
} |
| 173 |
|
$queryBuilder->andWhere( |
| 174 |
|
'`' . $this->collection . "`.`" . $sqlOptions['key'].'`' |
| 175 |
|
. ' ' . $sqlOptions['operand'] |
|
@@ 187-190 (lines=4) @@
|
| 184 |
|
$subKey = array_keys($orValue)[0]; |
| 185 |
|
$subValue = $orValue[$subKey]; |
| 186 |
|
$sqlOptions = self::buildFilter([$subKey => $subValue]); |
| 187 |
|
if (in_array($sqlOptions['method'], ['in', 'notIn'])) { |
| 188 |
|
$orQuery[] = $queryBuilder->expr()->{$sqlOptions['method']}($this->collection . "." . $sqlOptions['key'], $sqlOptions['value']); |
| 189 |
|
continue; |
| 190 |
|
} |
| 191 |
|
$orQuery[] = |
| 192 |
|
'`' . $this->collection . "`.`" . $sqlOptions['key'].'`' |
| 193 |
|
. ' ' . $sqlOptions['operand'] |
soupmix /
sql
