public function userSelectBox(UserRepository $u): QueryBuilder
    {
    	$role = 'ROLE_SCHOOL';
          return $u->createQueryBuilder('u')
		        ->where('u.roles LIKE :roles')
		        ->setParameter('roles', '%"'.$role.'"%')
	            ->andWhere('u.active = :active')
	            ->setParameter('active', 1)		        
             	->orderBy('u.id', 'DESC');
     }

By toihid

Leave a Reply