symfony2 form querybuilder with parameters

Question

I want to put my entity in the function of the query builder:

->add( 'weeks', 'entity', array(
    'class' => 'MV\CaravanBundle\Entity\CaravanRow',
    'property' => 'line',
    'query_builder' => function(EntityRepository $er ) use ( $caravan ) {
        return $er->createQueryBuilder('w')
                  ->orderBy('w.dateFrom', 'ASC')
                  ->where('w.caravan = ?', $caravan )
                  ->andWhere('w.visible = 1')
                  ->andWhere('w.booked = 0');
}

but get the message:

Expression of type 'Entity\Name' not allowed in this context

So what is the (best) way to give the querybuilder information.

Squazic · Accepted Answer · 2012-12-12 19:45:00Z

43

You should set the parameter separately like so:

->add( 'weeks', 'entity', array(
    'class' => 'MV\CaravanBundle\Entity\CaravanRow',
    'property' => 'line',
    'query_builder' => function(EntityRepository $er ) use ( $caravan ) {
        return $er->createQueryBuilder('w')
                  ->orderBy('w.dateFrom', 'ASC')
                  ->where('w.caravan = ?1')
                  ->andWhere('w.visible = 1')
                  ->andWhere('w.booked = 0')
                  ->setParameter(1, $caravan);
}

You can either use an integer or string, but the syntax is slightly different for each. See the docs

answered Dec 12, 2012 at 19:45

Squazic

3,7103 gold badges28 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jean-Luc Barat Over a year ago

your link is died !

Snopzer Over a year ago

Can i Pass EnityManger Query instead of QueryBuider.? Does it works .?

Sam · Accepted Answer · 2013-09-19 11:41:18Z

15

I recently ran across almost the same problem. Only difference was the 'query_builder' option has to be set inside 'setDefaultOptions'. Basicly the form is created like this:

$builder->add('field', 'query_type', array('id' => 1));

The 'query_type' class looks like this:

class QueryType extends AbstractType
{
     public function setDefaultOptions(OptionsResolverInterface $options)
     {
              $resolver->setRequired(array('id'));

              $resolver->setNormalizers(array(
                  'query_builder' => function (Options $options, $configs) {
                          return function (EntityRepository $er) use ( $options ) {
                              return $er->getSomething( $options['id'] );

                       };
                  },
              ));
     }
}

I use the setNormalizers function to access my $options array and from there on i can call the querybuilder with parameters.

Hope this is useful for someone!

answered Sep 19, 2013 at 11:41

Sam

2,6472 gold badges22 silver badges25 bronze badges

1 Comment

Aistis Over a year ago

Good solution if you need options in your anonymous function, when defining default options.

Collectives™ on Stack Overflow

symfony2 form querybuilder with parameters

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related