Symfony2: Pass Parameter to Form entity object for query_builder

Question

In My form i use this code

$form->add('user', 'entity', 
        array(
                'label' => 'User Name',
                'class' => 'DotArtBundle:User',
                'property' => 'name',
                'query_builder' => function(EntityRepository $er){
                                return $er->createQueryBuilder('u')->where('u.type = 1');
                            }
            )
    );

I want

if user role is ROLE_ADMIN run this code and show all user (This code do this)

if user role is ROLE_USER this code only show authenticated user in list

  'query_builder' => function(EntityRepository $er){
         return $er->createQueryBuilder('u')->where('u.type = 1 and u.id = ' . $this->getUser()->getId());
    }

Error I check this code and return error:

 $where  = 'u.id = '.$userid;
 $form = $this->createFormBuilder($poduct)
              ->add('user', 'entity', 
                      array(
                        'label' => 'نانم کاربری',
                        'class' => 'DotArtBundle:User',
                        'property' => 'name',
                        'query_builder' => function(EntityRepository $er){
                                               return $er->createQueryBuilder('u')->where($where);
                                                }
                                )
                        )
Notice: Undefined variable: where in C:\xampp\htdocs\ArtGirl\src\Dot\ArtBundle\Controller\ProductController.php line 38

no, I define $form = $this->createForm....()->add(...)->getForm(); — Mahdi Sabori
– Mahdi Sabori, Commented Apr 25, 2013 at 19:19
Your question is about asking how to access the role of the user then? — cheesemacfly
– cheesemacfly, Commented Apr 25, 2013 at 19:28
If user role is ADMIN show in ComboBox all user, else if user role is USER show in ComboBox just Authenticated User — Mahdi Sabori
– Mahdi Sabori, Commented Apr 25, 2013 at 19:32

Mahdi Sabori · Accepted Answer · 2013-04-26 05:35:38Z

3

Solution:

$where  = '';
$userid = $this->getUser()->getId();
if (!$this->get('security.context')->isGranted('ROLE_ADMIN')){
    $where = ' and u.id = ' . $userid;
}


$form->add('user', 'entity', 
    array(
            'label' => 'نانم کاربری',
            'class' => 'DotArtBundle:User',
            'property' => 'name',
            'query_builder' => function(EntityRepository $er) use ($where){
                            return $er->createQueryBuilder('u')->where('u.type = 1 '.$where);
                        }
        )
)

answered Apr 26, 2013 at 5:35

Mahdi Sabori

773 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Symfony2: Pass Parameter to Form entity object for query_builder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related