/
RangeFilterType.php
70 lines (63 loc) · 2.56 KB
/
RangeFilterType.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<?php
namespace Padam87\FormFilterBundle\Form;
use Doctrine\ORM\QueryBuilder;
use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
use Symfony\Component\Form\Extension\Core\Type\DateType;
use Symfony\Component\Form\Extension\Core\Type\TextType;
use Symfony\Component\Form\FormBuilderInterface;
use Symfony\Component\OptionsResolver\Options;
use Symfony\Component\OptionsResolver\OptionsResolver;
class RangeFilterType extends AbstractType
{
public function buildForm(FormBuilderInterface $builder, array $options)
{
$builder
->add(
$options['from_field_name'],
$options['from_field_type'],
$options['from_field_options']
)
->add(
$options['to_field_name'],
$options['to_field_type'],
$options['to_field_options']
)
;
}
public function configureOptions(OptionsResolver $resolver)
{
$resolver
->setDefaults(
[
'from_field_name' => 'from',
'from_field_type' => TextType::class,
'from_field_options' => [],
'from_field_expr' => 'gte',
'to_field_name' => 'to',
'to_field_type' => TextType::class,
'to_field_options' => [],
'to_field_expr' => 'lte',
'filter' => function (Options $options) {
return function(QueryBuilder $qb, $alias, $value, $field) use ($options) {
if ($value['from'] != null) {
$parameter = $field . '_from';
$qb
->andWhere($qb->expr()->{$options['from_field_expr']}($alias . '.' . $field, ':' . $parameter))
->setParameter($parameter, $value['from'])
;
}
if ($value['to'] != null) {
$parameter = $field . '_to';
$qb
->andWhere($qb->expr()->{$options['to_field_expr']}($alias . '.' . $field, ':' . $parameter))
->setParameter($parameter, $value['to'])
;
}
};
}
]
)
;
}
}