src/Repository/Director/DirectorRepository.php line 14

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Slivki\Repository\Director;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\Persistence\ManagerRegistry;
  9. use Slivki\Entity\Director;
  10. use Slivki\Exception\Director\DirectorNotFoundException;
  12. final class DirectorRepository extends ServiceEntityRepository implements DirectorRepositoryInterface
  13. {
  14.     public function __construct(ManagerRegistry $registry)
  15.     {
  16.         parent::__construct($registry, Director::class);
  17.     }
  19.     public function findById(int $id): ?Director
  20.     {
  21.         $queryBuilder = $this->createQueryBuilder('director');
  22.         $expr = $queryBuilder->expr();
  24.         return $queryBuilder
  25.             ->andWhere($expr->eq('director.ID', ':id'))
  26.             ->setParameter(':id', $id)
  27.             ->getQuery()
  28.             ->getOneOrNullResult();
  29.     }
  31.     public function getById(int $id): Director
  32.     {
  33.         $director = $this->findById($id);
  34.         if (!$director instanceof Director) {
  35.             throw new DirectorNotFoundException();
  36.         }
  38.         return $director;
  39.     }
  41.     public function getByEmail(string $email): Director
  42.     {
  43.         $queryBuilder = $this->createQueryBuilder('director');
  44.         $expr = $queryBuilder->expr();
  46.         $director = $queryBuilder
  47.             ->andWhere($expr->eq('director.email', ':email'))
  48.             ->setParameter('email', $email)
  49.             ->getQuery()
  50.             ->getOneOrNullResult();
  52.         if (!$director instanceof Director) {
  53.             throw new DirectorNotFountException();
  54.         }
  56.         return $director;
  57.     }
  58. }