macroparts /
vortex
| @@ 2616-2628 (lines=13) @@ | ||
| 2613 | * @param string $alias |
|
| 2614 | * @return mixed |
|
| 2615 | */ |
|
| 2616 | private function stringContainsExpression($query, $field, $params, $alias) |
|
| 2617 | { |
|
| 2618 | $contains = $query->expr()->orX(); |
|
| 2619 | ||
| 2620 | $index = 0; |
|
| 2621 | foreach ($params as $string) { |
|
| 2622 | $contains->add($query->expr()->like($field, ":contains_{$alias}_{$index}")); |
|
| 2623 | $query->setParameter("contains_{$alias}_{$index}", '%' . $string . '%'); |
|
| 2624 | $index++; |
|
| 2625 | } |
|
| 2626 | ||
| 2627 | return $contains; |
|
| 2628 | } |
|
| 2629 | ||
| 2630 | /** |
|
| 2631 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2649-2660 (lines=12) @@ | ||
| 2646 | * @param string $alias |
|
| 2647 | * @return mixed |
|
| 2648 | */ |
|
| 2649 | private function dateLtExpression($query, $field, $params, $alias) |
|
| 2650 | { |
|
| 2651 | $lt = $query->expr()->orX(); |
|
| 2652 | $index = 0; |
|
| 2653 | foreach ($params as $datetime) { |
|
| 2654 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2655 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2656 | $index++; |
|
| 2657 | } |
|
| 2658 | ||
| 2659 | return $lt; |
|
| 2660 | } |
|
| 2661 | ||
| 2662 | /** |
|
| 2663 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2669-2680 (lines=12) @@ | ||
| 2666 | * @param string $alias |
|
| 2667 | * @return mixed |
|
| 2668 | */ |
|
| 2669 | private function integerLtExpression($query, $field, $params, $alias) |
|
| 2670 | { |
|
| 2671 | $lt = $query->expr()->orX(); |
|
| 2672 | $index = 0; |
|
| 2673 | foreach ($params as $datetime) { |
|
| 2674 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2675 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2676 | $index++; |
|
| 2677 | } |
|
| 2678 | ||
| 2679 | return $lt; |
|
| 2680 | } |
|
| 2681 | ||
| 2682 | /** |
|
| 2683 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2689-2700 (lines=12) @@ | ||
| 2686 | * @param string $alias |
|
| 2687 | * @return mixed |
|
| 2688 | */ |
|
| 2689 | private function integerLteExpression($query, $field, $params, $alias) |
|
| 2690 | { |
|
| 2691 | $lte = $query->expr()->orX(); |
|
| 2692 | $index = 0; |
|
| 2693 | foreach ($params as $datetime) { |
|
| 2694 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2695 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2696 | $index++; |
|
| 2697 | } |
|
| 2698 | ||
| 2699 | return $lte; |
|
| 2700 | } |
|
| 2701 | ||
| 2702 | /** |
|
| 2703 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2709-2720 (lines=12) @@ | ||
| 2706 | * @param string $alias |
|
| 2707 | * @return mixed |
|
| 2708 | */ |
|
| 2709 | private function dateLteExpression($query, $field, $params, $alias) |
|
| 2710 | { |
|
| 2711 | $lte = $query->expr()->orX(); |
|
| 2712 | $index = 0; |
|
| 2713 | foreach ($params as $datetime) { |
|
| 2714 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2715 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2716 | $index++; |
|
| 2717 | } |
|
| 2718 | ||
| 2719 | return $lte; |
|
| 2720 | } |
|
| 2721 | ||
| 2722 | /** |
|
| 2723 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2729-2740 (lines=12) @@ | ||
| 2726 | * @param string $alias |
|
| 2727 | * @return mixed |
|
| 2728 | */ |
|
| 2729 | private function dateGtExpression($query, $field, $params, $alias) |
|
| 2730 | { |
|
| 2731 | $gt = $query->expr()->orX(); |
|
| 2732 | $index = 0; |
|
| 2733 | foreach ($params as $datetime) { |
|
| 2734 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2735 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2736 | $index++; |
|
| 2737 | } |
|
| 2738 | ||
| 2739 | return $gt; |
|
| 2740 | } |
|
| 2741 | ||
| 2742 | /** |
|
| 2743 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2749-2760 (lines=12) @@ | ||
| 2746 | * @param string $alias |
|
| 2747 | * @return mixed |
|
| 2748 | */ |
|
| 2749 | private function integerGtExpression($query, $field, $params, $alias) |
|
| 2750 | { |
|
| 2751 | $gt = $query->expr()->orX(); |
|
| 2752 | $index = 0; |
|
| 2753 | foreach ($params as $datetime) { |
|
| 2754 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2755 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2756 | $index++; |
|
| 2757 | } |
|
| 2758 | ||
| 2759 | return $gt; |
|
| 2760 | } |
|
| 2761 | ||
| 2762 | /** |
|
| 2763 | * @return string |
|
| @@ 2785-2796 (lines=12) @@ | ||
| 2782 | * @param string $alias |
|
| 2783 | * @return mixed |
|
| 2784 | */ |
|
| 2785 | private function integerGteExpression($query, $field, $params, $alias) |
|
| 2786 | { |
|
| 2787 | $gte = $query->expr()->orX(); |
|
| 2788 | $index = 0; |
|
| 2789 | foreach ($params as $datetime) { |
|
| 2790 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2791 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2792 | $index++; |
|
| 2793 | } |
|
| 2794 | ||
| 2795 | return $gte; |
|
| 2796 | } |
|
| 2797 | ||
| 2798 | /** |
|
| 2799 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2805-2816 (lines=12) @@ | ||
| 2802 | * @param string $alias |
|
| 2803 | * @return mixed |
|
| 2804 | */ |
|
| 2805 | private function dateGteExpression($query, $field, $params, $alias) |
|
| 2806 | { |
|
| 2807 | $gte = $query->expr()->orX(); |
|
| 2808 | $index = 0; |
|
| 2809 | foreach ($params as $datetime) { |
|
| 2810 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2811 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2812 | $index++; |
|
| 2813 | } |
|
| 2814 | ||
| 2815 | return $gte; |
|
| 2816 | } |
|
| 2817 | ||
| 2818 | /** |
|
| 2819 | * Does some crazy things |
|
