Sulu\Bundle\SecurityBundle\Entity\UserRepository::findUsersByAccount PHP Method

findUsersByAccount() public method

public findUsersByAccount ( $accountId, $sortBy = [] )
    public function findUsersByAccount($accountId, $sortBy = [])
    {
        try {
            $qb = $this->createQueryBuilder('user')->leftJoin('user.userRoles', 'userRoles')->leftJoin('userRoles.role', 'role')->leftJoin('user.userGroups', 'userGroups')->leftJoin('user.userSettings', 'settings')->leftJoin('userGroups.group', 'grp')->leftJoin('user.contact', 'contact')->leftJoin('contact.emails', 'emails')->leftJoin('contact.accountContacts', 'accountContacts')->leftJoin('accountContacts.account', 'account')->addSelect('userRoles')->addSelect('role')->addSelect('userGroups')->addSelect('grp')->addSelect('settings')->addSelect('contact')->addSelect('emails')->where('account.id=:accountId');
            $this->addOrderBy($qb, 'user', $sortBy);
            $query = $qb->getQuery();
            $query->setParameter('accountId', $accountId);
            return $query->getResult();
        } catch (NoResultException $ex) {
            return;
        }
    }