| @@ 236-258 (lines=23) @@ | ||
| 233 | ||
| 234 | if (in_array($fieldName, $this->fields)) { |
|
| 235 | ||
| 236 | if ($filtering->hasOperator()) { |
|
| 237 | if ($filtering->isListOperator()) { |
|
| 238 | $whereCondition = |
|
| 239 | $this->entityAlias . '.' . $fieldName . ' ' . |
|
| 240 | $op->getMeta() . ' ' . |
|
| 241 | '(:field_' . $fieldName . $saltObj->getSalt() . ')'; |
|
| 242 | } else if ($filtering->isFieldEqualsOperator()) { |
|
| 243 | $whereCondition = |
|
| 244 | $this->entityAlias . '.' . $fieldName . ' ' . |
|
| 245 | $op->getMeta() . ' ' . |
|
| 246 | $this->entityAlias . '.' . $value; |
|
| 247 | } else { |
|
| 248 | $whereCondition = |
|
| 249 | $this->entityAlias . '.' . $fieldName . ' ' . |
|
| 250 | $op->getMeta() . ' ' . |
|
| 251 | ':field_' . $fieldName . $saltObj->getSalt(); |
|
| 252 | } |
|
| 253 | } else { |
|
| 254 | $whereCondition = |
|
| 255 | $this->entityAlias . '.' . $fieldName . ' ' . |
|
| 256 | $op->getMeta() . ' ' . |
|
| 257 | ':field_' . $fieldName . $saltObj->getSalt(); |
|
| 258 | } |
|
| 259 | ||
| 260 | $this->qBuilder->andWhere($whereCondition); |
|
| 261 | ||
| @@ 343-366 (lines=24) @@ | ||
| 340 | ||
| 341 | if (in_array($fieldName, $this->fields)) { |
|
| 342 | ||
| 343 | if ($filtering->hasOperator()) { |
|
| 344 | if ($filtering->isListOperator()) { |
|
| 345 | $whereCondition = |
|
| 346 | $this->entityAlias . '.' . $fieldName . ' ' . |
|
| 347 | $op->getMeta() |
|
| 348 | .' (:field_' . $fieldName . $saltObj->getSalt() . ')'; |
|
| 349 | } else if ($filtering->isFieldEqualsOperator()) { |
|
| 350 | $whereCondition = |
|
| 351 | $this->entityAlias . '.' . $fieldName . ' ' . |
|
| 352 | $op->getMeta() . ' ' . |
|
| 353 | $this->entityAlias . '.' . $value |
|
| 354 | ; |
|
| 355 | } else { |
|
| 356 | $whereCondition = |
|
| 357 | $this->entityAlias . '.' . $fieldName . ' ' . |
|
| 358 | $op->getMeta() . ' ' . |
|
| 359 | ':field_' . $fieldName . $saltObj->getSalt(); |
|
| 360 | } |
|
| 361 | } else { |
|
| 362 | $whereCondition = |
|
| 363 | $this->entityAlias . '.' . $fieldName . ' ' . |
|
| 364 | '=' . ' ' . |
|
| 365 | ':field_' . $fieldName . $saltObj->getSalt(); |
|
| 366 | } |
|
| 367 | ||
| 368 | if ($orCondition['orCondition'] != null) { |
|
| 369 | $orCondition['orCondition'] .= ' OR ' . $whereCondition; |
|