/**
* @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;
}
