macroparts /
vortex
| @@ 2610-2622 (lines=13) @@ | ||
| 2607 | * @param string $alias |
|
| 2608 | * @return mixed |
|
| 2609 | */ |
|
| 2610 | private function stringContainsExpression($query, $field, $params, $alias) |
|
| 2611 | { |
|
| 2612 | $contains = $query->expr()->orX(); |
|
| 2613 | ||
| 2614 | $index = 0; |
|
| 2615 | foreach ($params as $string) { |
|
| 2616 | $contains->add($query->expr()->like($field, ":contains_{$alias}_{$index}")); |
|
| 2617 | $query->setParameter("contains_{$alias}_{$index}", '%' . $string . '%'); |
|
| 2618 | $index++; |
|
| 2619 | } |
|
| 2620 | ||
| 2621 | return $contains; |
|
| 2622 | } |
|
| 2623 | ||
| 2624 | /** |
|
| 2625 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2643-2654 (lines=12) @@ | ||
| 2640 | * @param string $alias |
|
| 2641 | * @return mixed |
|
| 2642 | */ |
|
| 2643 | private function dateLtExpression($query, $field, $params, $alias) |
|
| 2644 | { |
|
| 2645 | $lt = $query->expr()->orX(); |
|
| 2646 | $index = 0; |
|
| 2647 | foreach ($params as $datetime) { |
|
| 2648 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2649 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2650 | $index++; |
|
| 2651 | } |
|
| 2652 | ||
| 2653 | return $lt; |
|
| 2654 | } |
|
| 2655 | ||
| 2656 | /** |
|
| 2657 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2663-2674 (lines=12) @@ | ||
| 2660 | * @param string $alias |
|
| 2661 | * @return mixed |
|
| 2662 | */ |
|
| 2663 | private function integerLtExpression($query, $field, $params, $alias) |
|
| 2664 | { |
|
| 2665 | $lt = $query->expr()->orX(); |
|
| 2666 | $index = 0; |
|
| 2667 | foreach ($params as $datetime) { |
|
| 2668 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2669 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2670 | $index++; |
|
| 2671 | } |
|
| 2672 | ||
| 2673 | return $lt; |
|
| 2674 | } |
|
| 2675 | ||
| 2676 | /** |
|
| 2677 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2683-2694 (lines=12) @@ | ||
| 2680 | * @param string $alias |
|
| 2681 | * @return mixed |
|
| 2682 | */ |
|
| 2683 | private function integerLteExpression($query, $field, $params, $alias) |
|
| 2684 | { |
|
| 2685 | $lte = $query->expr()->orX(); |
|
| 2686 | $index = 0; |
|
| 2687 | foreach ($params as $datetime) { |
|
| 2688 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2689 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2690 | $index++; |
|
| 2691 | } |
|
| 2692 | ||
| 2693 | return $lte; |
|
| 2694 | } |
|
| 2695 | ||
| 2696 | /** |
|
| 2697 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2703-2714 (lines=12) @@ | ||
| 2700 | * @param string $alias |
|
| 2701 | * @return mixed |
|
| 2702 | */ |
|
| 2703 | private function dateLteExpression($query, $field, $params, $alias) |
|
| 2704 | { |
|
| 2705 | $lte = $query->expr()->orX(); |
|
| 2706 | $index = 0; |
|
| 2707 | foreach ($params as $datetime) { |
|
| 2708 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2709 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2710 | $index++; |
|
| 2711 | } |
|
| 2712 | ||
| 2713 | return $lte; |
|
| 2714 | } |
|
| 2715 | ||
| 2716 | /** |
|
| 2717 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2723-2734 (lines=12) @@ | ||
| 2720 | * @param string $alias |
|
| 2721 | * @return mixed |
|
| 2722 | */ |
|
| 2723 | private function dateGtExpression($query, $field, $params, $alias) |
|
| 2724 | { |
|
| 2725 | $gt = $query->expr()->orX(); |
|
| 2726 | $index = 0; |
|
| 2727 | foreach ($params as $datetime) { |
|
| 2728 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2729 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2730 | $index++; |
|
| 2731 | } |
|
| 2732 | ||
| 2733 | return $gt; |
|
| 2734 | } |
|
| 2735 | ||
| 2736 | /** |
|
| 2737 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2743-2754 (lines=12) @@ | ||
| 2740 | * @param string $alias |
|
| 2741 | * @return mixed |
|
| 2742 | */ |
|
| 2743 | private function integerGtExpression($query, $field, $params, $alias) |
|
| 2744 | { |
|
| 2745 | $gt = $query->expr()->orX(); |
|
| 2746 | $index = 0; |
|
| 2747 | foreach ($params as $datetime) { |
|
| 2748 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2749 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2750 | $index++; |
|
| 2751 | } |
|
| 2752 | ||
| 2753 | return $gt; |
|
| 2754 | } |
|
| 2755 | ||
| 2756 | /** |
|
| 2757 | * @return string |
|
| @@ 2779-2790 (lines=12) @@ | ||
| 2776 | * @param string $alias |
|
| 2777 | * @return mixed |
|
| 2778 | */ |
|
| 2779 | private function integerGteExpression($query, $field, $params, $alias) |
|
| 2780 | { |
|
| 2781 | $gte = $query->expr()->orX(); |
|
| 2782 | $index = 0; |
|
| 2783 | foreach ($params as $datetime) { |
|
| 2784 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2785 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2786 | $index++; |
|
| 2787 | } |
|
| 2788 | ||
| 2789 | return $gte; |
|
| 2790 | } |
|
| 2791 | ||
| 2792 | /** |
|
| 2793 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2799-2810 (lines=12) @@ | ||
| 2796 | * @param string $alias |
|
| 2797 | * @return mixed |
|
| 2798 | */ |
|
| 2799 | private function dateGteExpression($query, $field, $params, $alias) |
|
| 2800 | { |
|
| 2801 | $gte = $query->expr()->orX(); |
|
| 2802 | $index = 0; |
|
| 2803 | foreach ($params as $datetime) { |
|
| 2804 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2805 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2806 | $index++; |
|
| 2807 | } |
|
| 2808 | ||
| 2809 | return $gte; |
|
| 2810 | } |
|
| 2811 | ||
| 2812 | /** |
|
| 2813 | * Does some crazy things |
|
