vendor/roothirsch/core-bundle/Repository/UserRepository.php line 13

Open in your IDE?
  1. <?php
  3. namespace Roothirsch\CoreBundle\Repository;
  5. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  6. use Roothirsch\CoreBundle\Entity\User;
  7. use Symfony\Component\Security\Core\Exception\AuthenticationCredentialsNotFoundException;
  9. class UserRepository extends ServiceEntityRepository
  10. {
  11.     public function __construct(\Doctrine\Persistence\ManagerRegistry $registry)
  12.     {
  13.         parent::__construct($registry, User::class);
  14.     }
  16.     /**
  17.      * {@inheritdoc}
  18.      */
  19.     public function findOneByApiToken($apiToken)
  20.     {
  21.         $apiUser = $this->findOneBy(['apiToken' => $apiToken]);
  23.         if (!$apiUser) {
  24.             throw new AuthenticationCredentialsNotFoundException();
  25.         }
  27.         return $apiUser;
  28.     }
  30.     /**
  31.      * @param string $email
  32.      *
  33.      * @return null|User
  34.      */
  35.     public function findUserByEmail($email)
  36.     {
  37.         return $this->findOneBy(['email' => $email]);
  38.     }
  40.     /**
  41.      * @param string $securityToken
  42.      *
  43.      * @return null|User
  44.      */
  45.     public function findUserBySecurityToken($securityToken)
  46.     {
  47.         return $this->findOneBy(['securityToken' => $securityToken]);
  48.     }
  50.     /**
  51.      * @param string $registrationToken
  52.      *
  53.      * @return null|User
  54.      */
  55.     public function findUserByRegistrationToken($registrationToken)
  56.     {
  57.         return $this->findOneBy(['registrationToken' => $registrationToken]);
  58.     }
  60.     /**
  61.      * Finds coworkers for a user.
  62.      *
  63.      * @param User $user
  64.      *
  65.      * @return array|mixed
  66.      */
  67.     public function findCoworkersForUser(User $user)
  68.     {
  69.         $company = $user->getCompany();
  70.         if (!is_object($company)) {
  71.             return [];
  72.         }
  74.         $dql = 'SELECT u FROM AppBundle:User AS u JOIN u.company c WHERE c.id = :company AND u.id != :user ORDER BY u.lastName';
  76.         $em = $this->getEntityManager();
  77.         $query = $em->createQuery($dql);
  78.         $query->setParameters(
  79.             [
  80.                 'company' => $company->getId(),
  81.                 'user' => $user->getId(),
  82.             ]
  83.         );
  85.         return $query->getResult();
  86.     }
  87. }