public function findAuthorizedUsers(User $user, Section $section)
{
$query = $this->createQueryBuilder('u')->select('u')->where('u.section = :section')->setParameter('section', $section);
if (in_array('ROLE_BUDDYCOORDINATOR', $user->getRoles())) {
return $query->getQuery()->getResult();
} else {
if (in_array('ROLE_USER', $user->getRoles())) {
$query->andWhere('u.roles LIKE :roles')->setParameter('roles', "%ROLE_BUDDYCOORDINATOR%");
}
}
return $query->getQuery()->getResult();
}