public function getUsersForRiaAdmin(User $riaAdmin)
{
$riaGroupNames = $riaAdmin->getGroupIds();
$qb = $this->createQueryBuilder('u');
$qb->leftJoin('u.groups', 'g')->leftJoin('u.profile', 'up')->where($qb->expr()->in('g.id', $riaGroupNames))->andWhere('up.ria_user_id = :owner_id AND (u.roles LIKE :role_ria_admin OR u.roles LIKE :role_ria_user)')->orWhere('u.id = :owner_id')->setParameters(array('owner_id' => $riaAdmin->getRia()->getId(), 'role_ria_admin' => '%"ROLE_RIA_ADMIN"%', 'role_ria_user' => '%"ROLE_RIA_USER"%'));
//echo '<pre>';
//echo($qb->getQuery()->getSQL());die;
return $qb->getQuery()->getResult();
}
