Guest User

Untitled

a guest
Nov 22nd, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.71 KB | None | 0 0
  1. $user = $builder->getData();
  2.         $builder->add('agency', 'entity', array(
  3.             'class' => 'StartrackUserBundle:User',
  4.             'query_builder' => function(EntityRepository $er) {
  5.                 $qb = $er->createQueryBuilder('u');
  6.                
  7.                 return $qb->select('u, g')
  8.                           ->leftJoin('u.groups', 'g')
  9.                           ->where($qb->expr()->like('g.name', $qb->expr()->literal('%Agency%')))
  10.                           ->andWhere($qb->expr()->not($qb->expr()->eq('g.user_id', $user->getId())));
  11.                          
  12.             },
  13.             'empty_value' => '-',
  14.             'property' => 'name',
  15.             'required' => false
  16.         ));
Add Comment
Please, Sign In to add comment