/** * @param BaseUser $user * @return array */ public function listUserAdministrations(BaseUser $user) { $query = $this->entityManager->createQueryBuilder(); $query->select('administration'); $query->from('HomefinanceBundle:Administration', 'administration'); $query->leftJoin('HomefinanceBundle:Share', 'share', Join::LEFT_JOIN, 'share.administration = administration'); $query->where('administration.owner = :owner'); $query->orWhere($query->expr()->andX('share.user = :owner', 'administration.owner != :owner')); $query->orderBy('administration.name'); $query->setParameter('owner', $user); return $query->getQuery()->getResult(); }
public function findUserByEmail($email) { $query = $this->entityManager->createQueryBuilder(); $query->select('user'); $query->from('HomefinanceBundle:User', 'user'); $query->where('user.email = :email OR user.newEmail = :email'); $query->setParameter('email', $email); $user = $query->getQuery()->getOneOrNullResult(); if (!$user) { throw new EntityNotFoundException(); } return $user; }