src/Repository/City/CityRepository.php line 110

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Slivki\Repository\City;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\ORM\NonUniqueResultException;
  9. use Doctrine\Persistence\ManagerRegistry;
  10. use Slivki\Entity\City;
  11. use Slivki\Exception\CityNotFoundException;
  13. final class CityRepository extends ServiceEntityRepository implements CityRepositoryInterface
  14. {
  15.     public function __construct(ManagerRegistry $registry)
  16.     {
  17.         parent::__construct($registry, City::class);
  18.     }
  20.     /**
  21.      * @return City[]
  22.      */
  23.     public function getActiveCities(): array
  24.     {
  25.         $qb = $this->createQueryBuilder('city');
  26.         $expr = $qb->expr();
  28.         return $qb
  29.             ->andWhere($expr->eq('city.active', ':active'))
  30.             ->setParameter('active', true)
  31.             ->addOrderBy($expr->asc('city.position'))
  32.             ->addOrderBy($expr->asc('city.name'))
  33.             ->getQuery()
  34.             ->getResult();
  35.     }
  37.     public function findById(int $id): ?City
  38.     {
  39.         $qb = $this->createQueryBuilder('c');
  40.         $expr = $qb->expr();
  42.         return $qb
  43.             ->andWhere($expr->eq('c.ID', ':id'))
  44.             ->setParameters([
  45.                 'id' => $id,
  46.             ])
  47.             ->getQuery()
  48.             ->getOneOrNullResult();
  49.     }
  51.     public function getById(int $id): City
  52.     {
  53.         $city = $this->findById($id);
  55.         if (!$city instanceof City) {
  56.             throw new CityNotFoundException();
  57.         }
  59.         return $city;
  60.     }
  62.     public function findActiveNearestCity(string $latitude, string $longitude): ?City
  63.     {
  64.         $qb = $this->createQueryBuilder('city');
  65.         $expr = $qb->expr();
  67.         return $qb
  68.             ->andWhere($expr->eq('city.active', ':active'))
  69.             ->addOrderBy($expr->min(
  70.                 \sprintf('ST_Distance(city.point, GeomFromEWKT(\'SRID=4326;POINT(%s)\'))', \implode(' ', [$latitude, $longitude])))
  71.             )
  72.             ->addGroupBy('city.ID')
  73.             ->setParameters([
  74.                 'active' => true,
  75.             ])
  76.             ->setMaxResults(1)
  77.             ->getQuery()
  78.             ->getOneOrNullResult();
  79.     }
  81.     public function findAllSortByName(): array
  82.     {
  83.         $qb = $this->createQueryBuilder('c');
  84.         $expr = $qb->expr();
  85.         
  86.         return $qb
  87.             ->andWhere($expr->eq('c.active', ':active'))
  88.             ->setParameter('active', true)
  89.             ->addOrderBy($expr->asc('c.name'))
  90.             ->getQuery()
  91.             ->getResult();
  92.     }
  94.     public function findActiveByDomain(string $domain): ?City
  95.     {
  96.         $queryBuilder = $this->createQueryBuilder('city');
  97.         $expr = $queryBuilder->expr();
  99.         return $queryBuilder
  100.             ->andWhere($expr->eq('city.active', ':active'))
  101.             ->andWhere($expr->eq('city.domain', ':domain'))
  102.             ->setParameters(
  103.                 [
  104.                     'active' => true,
  105.                     'domain' => $domain,
  106.                 ]
  107.             )
  108.             ->setMaxResults(1)
  109.             ->getQuery()
  110.             ->getOneOrNullResult();
  111.     }
  112. }