Symfony2: formbuilder : dynamically modify querybuilder

Question

I am using the formbuilder to create a form as followed:

public function buildForm(FormBuilderInterface $builder, array $options)
{
    $builder
        ->add('content',    'textarea')
        ->add('rosters',    'entity', array( 
            'class'    =>   'PlatformBundle:team',
            'property' =>   'display',
            'multiple' =>   true,
            'expanded' =>   true,
            'required' =>   true
        ))
        ->add('send',       'submit')
    ;
}

At the moment I get all "teams". I need to adapt the form to display certain teams depending of the request. I can use the query-builder inside the form builder

public function buildForm(FormBuilderInterface $builder, array $options)
{
    $builder
        ->add('content',    'textarea')
        ->add('rosters',    'entity', array( 
            'class'    =>   'PlatformBundle:team',
            'property' =>   'display',
            'query_builder' => function(TeamRepository $t) use ($userId) {
                return $r->createQueryBuilder('t')
                    ->where('(t.user = :user')
            },
            'multiple' =>   true,
            'expanded' =>   true,
            'required' =>   true
        ))
        ->add('send',       'submit')
    ;
}

But the query changes for different questionnaire. In brief: always the same questionnaire but different teams to be listed (Am I making sense?).

Does someone has an idea how dynamically modify the querybuilder inside a formbuilder?

Francesco Abeni · Accepted Answer · 2015-07-23 21:53:31Z

1

I suggest two possible alternatives.

If the request comes from the form itself (i.e. you already submitted the form with some data and want to refine the fields) you can access the submitted data like this:

public function buildForm(FormBuilderInterface $builder, array $options)
{
    $data = $builder->getData();
    // now you can access form data

If the request comes from another source, you should use the "options" parameter. First, build a new $option for the requested user:

public function setDefaultOptions(OptionsResolverInterface $resolver)
{
    $resolver->setDefaults(array(
        'user' => null,
    ));
}

Note: I set the default to null but you can set it to whatever you want.

After that you can pass the $option where you build the form, i.e.

// some controller
$option = array('user' => $request->get('user');
$teamForm = $this->createForm(new TeamType(), null, $options);
// ...

answered Jul 23, 2015 at 21:53

Francesco Abeni

4,2691 gold badge21 silver badges31 bronze badges

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

2 Comments

Raphael_b Over a year ago

Thanks; that's another method; which seems lighter. worth a try! cheers

Francesco Abeni Over a year ago

@Raphael_b happy to hear that!

marc_s · Accepted Answer · 2015-07-22 15:53:02Z

For those looking for an answer...

The best solution I found is create a variable in the formtype and to import it form the controller. My formType will look like that:

class formType extends AbstractType
{
    // declare and construct the query in the class  to use it in the function
    private $qb; 
    public function __construct ($qb)
    {
        $this->qb = $qb;
    }
    /**
     * @param FormBuilderInterface $builder
     * @param array $options
     */
    public function buildForm(FormBuilderInterface $builder, array $options)
    {
        // declare the variable within the function
        $qb = $this->qb;
        $builder
            ->add('content',    'textarea', array('required' => false))
            ->add('rosters',    'entity', array( 
                'class'    =>   'PlatformBundle:Team',
                // use ($qb) -> $qb is query built in the controller (or repository) 
                'query_builder' => function(TeamRepository $r) use ($qb) {
                    return $qb;
                },
                'property' =>   'display',
                'multiple' =>   true,
                'expanded' =>   true,
                'required' =>   true
            ))
            ->add('send',       'submit');
    }

In my controller I just pass $qb as an argument of the formtype

$qb = $this->getDoctrine()->getManager()->getRepository('PlatformBundle:Team')->qbteam($Id);

        $form = $this->createForm(new formType($qb), $form);

with qbteam a function in the team repository which return the query (not a result).

public function qbteam($Id){
    $qb = $this->createQueryBuilder('r')
        ->leftJoin('r.team', 'm')
        ->addSelect('m')
        ->where('m.user = :user')
        ->setParameter('user', $Id);
    return $qb; 
}

I hope it will help others. cheers

Collectives™ on Stack Overflow

Symfony2: formbuilder : dynamically modify querybuilder

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related