|
public findUserBySystem ( string $system ) : |
||
| $system | string | |
| return | ||
public function findUserBySystem($system)
{
$queryBuilder = $this->createQueryBuilder('user')->select('user', 'contact')->leftJoin('user.userRoles', 'userRoles')->leftJoin('user.contact', 'contact')->leftJoin('userRoles.role', 'role')->where('role.system = :system');
$query = $queryBuilder->getQuery();
$query->setParameter('system', $system);
return $query->getResult();
}