Render only one input for many fields

[pbrzoski]

Hi
I have entity CustomerMachine.php

CustomerMachine {
    protected $name;
    protected $price;
    protected $type;
}

Now, I would like create searching using LexikFormFilterBuilder, so I create something like this.

public function buildForm(FormBuilderInterface $builder, array $options)
{
    $builder->add('name', 'text', array());
    $builder->add('price', 'text', array());
    $builder->add('type', 'text', array());
}

And this works and is OK.

This renders 3 inputs in template. But I would like render only one field( search fields ), which will be create 'OR' condition on name, price, type columns. It is possible ?

[rvanlaak]

Yes that's possible. You don't have to add the fields you currently have, but should ad a search field that isn't mapped to the entity, and has a custom apply_filter:

->add('search', TextFilterType::class, array(
    'apply_filter' => function (ORMQuery $filterBuilder, $field, $values) {
        if (!empty($values['value'])) {
            $filterBuilder->getQueryBuilder()
                ->orWhere("p.name LIKE '%:value%'")
                ->orWhere("p.price LIKE '%:value%'")
                ->orWhere("p.type LIKE '%:value%'")
                ->setParameter('value', $values['value'])
            ;
        }
    },
    'mapped' => false,
))