| public findAllUsersByRoleId ( integer $roleId ) : array | ||
| $roleId | integer | |
| return | array | |
public function findAllUsersByRoleId($roleId)
{
$qb = $this->createQueryBuilder('user')->leftJoin('user.userRoles', 'userRole')->leftJoin('userRole.role', 'role')->where('role=:roleId');
$query = $qb->getQuery();
$query->setParameter('roleId', $roleId);
return $query->getResult();
}