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