macroparts /
vortex
| @@ 2414-2426 (lines=13) @@ | ||
| 2411 | * @param string $alias |
|
| 2412 | * @return mixed |
|
| 2413 | */ |
|
| 2414 | private function stringContainsExpression($query, $field, $params, $alias) |
|
| 2415 | { |
|
| 2416 | $contains = $query->expr()->orX(); |
|
| 2417 | ||
| 2418 | $index = 0; |
|
| 2419 | foreach ($params as $string) { |
|
| 2420 | $contains->add($query->expr()->like($field, ":contains_{$alias}_{$index}")); |
|
| 2421 | $query->setParameter("contains_{$alias}_{$index}", '%' . $string . '%'); |
|
| 2422 | $index++; |
|
| 2423 | } |
|
| 2424 | ||
| 2425 | return $contains; |
|
| 2426 | } |
|
| 2427 | ||
| 2428 | /** |
|
| 2429 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2447-2458 (lines=12) @@ | ||
| 2444 | * @param string $alias |
|
| 2445 | * @return mixed |
|
| 2446 | */ |
|
| 2447 | private function dateLtExpression($query, $field, $params, $alias) |
|
| 2448 | { |
|
| 2449 | $lt = $query->expr()->orX(); |
|
| 2450 | $index = 0; |
|
| 2451 | foreach ($params as $datetime) { |
|
| 2452 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2453 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2454 | $index++; |
|
| 2455 | } |
|
| 2456 | ||
| 2457 | return $lt; |
|
| 2458 | } |
|
| 2459 | ||
| 2460 | /** |
|
| 2461 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2467-2478 (lines=12) @@ | ||
| 2464 | * @param string $alias |
|
| 2465 | * @return mixed |
|
| 2466 | */ |
|
| 2467 | private function integerLtExpression($query, $field, $params, $alias) |
|
| 2468 | { |
|
| 2469 | $lt = $query->expr()->orX(); |
|
| 2470 | $index = 0; |
|
| 2471 | foreach ($params as $datetime) { |
|
| 2472 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2473 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2474 | $index++; |
|
| 2475 | } |
|
| 2476 | ||
| 2477 | return $lt; |
|
| 2478 | } |
|
| 2479 | ||
| 2480 | /** |
|
| 2481 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2487-2498 (lines=12) @@ | ||
| 2484 | * @param string $alias |
|
| 2485 | * @return mixed |
|
| 2486 | */ |
|
| 2487 | private function integerLteExpression($query, $field, $params, $alias) |
|
| 2488 | { |
|
| 2489 | $lte = $query->expr()->orX(); |
|
| 2490 | $index = 0; |
|
| 2491 | foreach ($params as $datetime) { |
|
| 2492 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2493 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2494 | $index++; |
|
| 2495 | } |
|
| 2496 | ||
| 2497 | return $lte; |
|
| 2498 | } |
|
| 2499 | ||
| 2500 | /** |
|
| 2501 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2507-2518 (lines=12) @@ | ||
| 2504 | * @param string $alias |
|
| 2505 | * @return mixed |
|
| 2506 | */ |
|
| 2507 | private function dateLteExpression($query, $field, $params, $alias) |
|
| 2508 | { |
|
| 2509 | $lte = $query->expr()->orX(); |
|
| 2510 | $index = 0; |
|
| 2511 | foreach ($params as $datetime) { |
|
| 2512 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2513 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2514 | $index++; |
|
| 2515 | } |
|
| 2516 | ||
| 2517 | return $lte; |
|
| 2518 | } |
|
| 2519 | ||
| 2520 | /** |
|
| 2521 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2527-2538 (lines=12) @@ | ||
| 2524 | * @param string $alias |
|
| 2525 | * @return mixed |
|
| 2526 | */ |
|
| 2527 | private function dateGtExpression($query, $field, $params, $alias) |
|
| 2528 | { |
|
| 2529 | $gt = $query->expr()->orX(); |
|
| 2530 | $index = 0; |
|
| 2531 | foreach ($params as $datetime) { |
|
| 2532 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2533 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2534 | $index++; |
|
| 2535 | } |
|
| 2536 | ||
| 2537 | return $gt; |
|
| 2538 | } |
|
| 2539 | ||
| 2540 | /** |
|
| 2541 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2547-2558 (lines=12) @@ | ||
| 2544 | * @param string $alias |
|
| 2545 | * @return mixed |
|
| 2546 | */ |
|
| 2547 | private function integerGtExpression($query, $field, $params, $alias) |
|
| 2548 | { |
|
| 2549 | $gt = $query->expr()->orX(); |
|
| 2550 | $index = 0; |
|
| 2551 | foreach ($params as $datetime) { |
|
| 2552 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2553 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2554 | $index++; |
|
| 2555 | } |
|
| 2556 | ||
| 2557 | return $gt; |
|
| 2558 | } |
|
| 2559 | ||
| 2560 | /** |
|
| 2561 | * @return string |
|
| @@ 2583-2594 (lines=12) @@ | ||
| 2580 | * @param string $alias |
|
| 2581 | * @return mixed |
|
| 2582 | */ |
|
| 2583 | private function integerGteExpression($query, $field, $params, $alias) |
|
| 2584 | { |
|
| 2585 | $gte = $query->expr()->orX(); |
|
| 2586 | $index = 0; |
|
| 2587 | foreach ($params as $datetime) { |
|
| 2588 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2589 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2590 | $index++; |
|
| 2591 | } |
|
| 2592 | ||
| 2593 | return $gte; |
|
| 2594 | } |
|
| 2595 | ||
| 2596 | /** |
|
| 2597 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2603-2614 (lines=12) @@ | ||
| 2600 | * @param string $alias |
|
| 2601 | * @return mixed |
|
| 2602 | */ |
|
| 2603 | private function dateGteExpression($query, $field, $params, $alias) |
|
| 2604 | { |
|
| 2605 | $gte = $query->expr()->orX(); |
|
| 2606 | $index = 0; |
|
| 2607 | foreach ($params as $datetime) { |
|
| 2608 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2609 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2610 | $index++; |
|
| 2611 | } |
|
| 2612 | ||
| 2613 | return $gte; |
|
| 2614 | } |
|
| 2615 | ||
| 2616 | /** |
|
| 2617 | * Does some crazy things |
|
