macroparts /
vortex
| @@ 2691-2703 (lines=13) @@ | ||
| 2688 | * @param string $alias |
|
| 2689 | * @return mixed |
|
| 2690 | */ |
|
| 2691 | private function stringContainsExpression($query, $field, $params, $alias) |
|
| 2692 | { |
|
| 2693 | $contains = $query->expr()->orX(); |
|
| 2694 | ||
| 2695 | $index = 0; |
|
| 2696 | foreach ($params as $string) { |
|
| 2697 | $contains->add($query->expr()->like($field, ":contains_{$alias}_{$index}")); |
|
| 2698 | $query->setParameter("contains_{$alias}_{$index}", '%' . $string . '%'); |
|
| 2699 | $index++; |
|
| 2700 | } |
|
| 2701 | ||
| 2702 | return $contains; |
|
| 2703 | } |
|
| 2704 | ||
| 2705 | /** |
|
| 2706 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2724-2735 (lines=12) @@ | ||
| 2721 | * @param string $alias |
|
| 2722 | * @return mixed |
|
| 2723 | */ |
|
| 2724 | private function dateLtExpression($query, $field, $params, $alias) |
|
| 2725 | { |
|
| 2726 | $lt = $query->expr()->orX(); |
|
| 2727 | $index = 0; |
|
| 2728 | foreach ($params as $datetime) { |
|
| 2729 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2730 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2731 | $index++; |
|
| 2732 | } |
|
| 2733 | ||
| 2734 | return $lt; |
|
| 2735 | } |
|
| 2736 | ||
| 2737 | /** |
|
| 2738 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2744-2755 (lines=12) @@ | ||
| 2741 | * @param string $alias |
|
| 2742 | * @return mixed |
|
| 2743 | */ |
|
| 2744 | private function integerLtExpression($query, $field, $params, $alias) |
|
| 2745 | { |
|
| 2746 | $lt = $query->expr()->orX(); |
|
| 2747 | $index = 0; |
|
| 2748 | foreach ($params as $datetime) { |
|
| 2749 | $lt->add($query->expr()->lt($field, ":lt_{$alias}_{$index}")); |
|
| 2750 | $query->setParameter("lt_{$alias}_{$index}", $datetime); |
|
| 2751 | $index++; |
|
| 2752 | } |
|
| 2753 | ||
| 2754 | return $lt; |
|
| 2755 | } |
|
| 2756 | ||
| 2757 | /** |
|
| 2758 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2764-2775 (lines=12) @@ | ||
| 2761 | * @param string $alias |
|
| 2762 | * @return mixed |
|
| 2763 | */ |
|
| 2764 | private function integerLteExpression($query, $field, $params, $alias) |
|
| 2765 | { |
|
| 2766 | $lte = $query->expr()->orX(); |
|
| 2767 | $index = 0; |
|
| 2768 | foreach ($params as $datetime) { |
|
| 2769 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2770 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2771 | $index++; |
|
| 2772 | } |
|
| 2773 | ||
| 2774 | return $lte; |
|
| 2775 | } |
|
| 2776 | ||
| 2777 | /** |
|
| 2778 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2784-2795 (lines=12) @@ | ||
| 2781 | * @param string $alias |
|
| 2782 | * @return mixed |
|
| 2783 | */ |
|
| 2784 | private function dateLteExpression($query, $field, $params, $alias) |
|
| 2785 | { |
|
| 2786 | $lte = $query->expr()->orX(); |
|
| 2787 | $index = 0; |
|
| 2788 | foreach ($params as $datetime) { |
|
| 2789 | $lte->add($query->expr()->lte($field, ":lte_{$alias}_{$index}")); |
|
| 2790 | $query->setParameter("lte_{$alias}_{$index}", $datetime); |
|
| 2791 | $index++; |
|
| 2792 | } |
|
| 2793 | ||
| 2794 | return $lte; |
|
| 2795 | } |
|
| 2796 | ||
| 2797 | /** |
|
| 2798 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2804-2815 (lines=12) @@ | ||
| 2801 | * @param string $alias |
|
| 2802 | * @return mixed |
|
| 2803 | */ |
|
| 2804 | private function dateGtExpression($query, $field, $params, $alias) |
|
| 2805 | { |
|
| 2806 | $gt = $query->expr()->orX(); |
|
| 2807 | $index = 0; |
|
| 2808 | foreach ($params as $datetime) { |
|
| 2809 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2810 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2811 | $index++; |
|
| 2812 | } |
|
| 2813 | ||
| 2814 | return $gt; |
|
| 2815 | } |
|
| 2816 | ||
| 2817 | /** |
|
| 2818 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2824-2835 (lines=12) @@ | ||
| 2821 | * @param string $alias |
|
| 2822 | * @return mixed |
|
| 2823 | */ |
|
| 2824 | private function integerGtExpression($query, $field, $params, $alias) |
|
| 2825 | { |
|
| 2826 | $gt = $query->expr()->orX(); |
|
| 2827 | $index = 0; |
|
| 2828 | foreach ($params as $datetime) { |
|
| 2829 | $gt->add($query->expr()->gt($field, ":gt_{$alias}_{$index}")); |
|
| 2830 | $query->setParameter("gt_{$alias}_{$index}", $datetime); |
|
| 2831 | $index++; |
|
| 2832 | } |
|
| 2833 | ||
| 2834 | return $gt; |
|
| 2835 | } |
|
| 2836 | ||
| 2837 | /** |
|
| 2838 | * @return string |
|
| @@ 2860-2871 (lines=12) @@ | ||
| 2857 | * @param string $alias |
|
| 2858 | * @return mixed |
|
| 2859 | */ |
|
| 2860 | private function integerGteExpression($query, $field, $params, $alias) |
|
| 2861 | { |
|
| 2862 | $gte = $query->expr()->orX(); |
|
| 2863 | $index = 0; |
|
| 2864 | foreach ($params as $datetime) { |
|
| 2865 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2866 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2867 | $index++; |
|
| 2868 | } |
|
| 2869 | ||
| 2870 | return $gte; |
|
| 2871 | } |
|
| 2872 | ||
| 2873 | /** |
|
| 2874 | * @param \Doctrine\ORM\QueryBuilder $query |
|
| @@ 2880-2891 (lines=12) @@ | ||
| 2877 | * @param string $alias |
|
| 2878 | * @return mixed |
|
| 2879 | */ |
|
| 2880 | private function dateGteExpression($query, $field, $params, $alias) |
|
| 2881 | { |
|
| 2882 | $gte = $query->expr()->orX(); |
|
| 2883 | $index = 0; |
|
| 2884 | foreach ($params as $datetime) { |
|
| 2885 | $gte->add($query->expr()->gte($field, ":gte_{$alias}_{$index}")); |
|
| 2886 | $query->setParameter("gte_{$alias}_{$index}", $datetime); |
|
| 2887 | $index++; |
|
| 2888 | } |
|
| 2889 | ||
| 2890 | return $gte; |
|
| 2891 | } |
|
| 2892 | ||
| 2893 | /** |
|
| 2894 | * Does some crazy things |
|
