quickapps /
cms
| @@ 87-93 (lines=7) @@ | ||
| 84 | "{$tableAlias}.{$column} {$conjunction}" => $value, |
|
| 85 | ]; |
|
| 86 | ||
| 87 | if ($token->where() === 'or') { |
|
| 88 | $query->orWhere($conditions); |
|
| 89 | } elseif ($token->where() === 'and') { |
|
| 90 | $query->andWhere($conditions); |
|
| 91 | } else { |
|
| 92 | $query->where($conditions); |
|
| 93 | } |
|
| 94 | ||
| 95 | return $query; |
|
| 96 | } |
|
| @@ 74-80 (lines=7) @@ | ||
| 71 | $conditions = ["{$tableAlias}.{$column} {$cmp}" => $range['lower']]; |
|
| 72 | } |
|
| 73 | ||
| 74 | if ($token->where() === 'or') { |
|
| 75 | $query->orWhere($conditions); |
|
| 76 | } elseif ($token->where() === 'and') { |
|
| 77 | $query->andWhere($conditions); |
|
| 78 | } else { |
|
| 79 | $query->where($conditions); |
|
| 80 | } |
|
| 81 | ||
| 82 | return $query; |
|
| 83 | } |
|
| @@ 312-320 (lines=9) @@ | ||
| 309 | $conditions = ['Contents.promote {$conjunction}' => 0]; |
|
| 310 | } |
|
| 311 | ||
| 312 | if (!empty($conditions)) { |
|
| 313 | if ($token->where() === 'or') { |
|
| 314 | $query->orWhere($conditions); |
|
| 315 | } elseif ($token->where() === 'and') { |
|
| 316 | $query->andWhere($conditions); |
|
| 317 | } else { |
|
| 318 | $query->where($conditions); |
|
| 319 | } |
|
| 320 | } |
|
| 321 | ||
| 322 | return $query; |
|
| 323 | } |
|
| @@ 384-392 (lines=9) @@ | ||
| 381 | }) |
|
| 382 | ]; |
|
| 383 | ||
| 384 | if (!empty($conditions)) { |
|
| 385 | if ($token->where() === 'or') { |
|
| 386 | $query->orWhere($conditions); |
|
| 387 | } elseif ($token->where() === 'and') { |
|
| 388 | $query->andWhere($conditions); |
|
| 389 | } else { |
|
| 390 | $query->where($conditions); |
|
| 391 | } |
|
| 392 | } |
|
| 393 | ||
| 394 | return $query; |
|
| 395 | } |
|
| @@ 464-470 (lines=7) @@ | ||
| 461 | $value = str_replace(["'", '@'], ['"', ' '], $value); |
|
| 462 | $conditions = ["{$not} MATCH(SearchDatasets.words) AGAINST('{$value}' IN BOOLEAN MODE) > 0"]; |
|
| 463 | ||
| 464 | if ($token->where() === 'or') { |
|
| 465 | $query->orWhere($conditions); |
|
| 466 | } elseif ($token->where() === 'and') { |
|
| 467 | $query->andWhere($conditions); |
|
| 468 | } else { |
|
| 469 | $query->where($conditions); |
|
| 470 | } |
|
| 471 | ||
| 472 | return $query; |
|
| 473 | } |
|
