src/AdminBundle/Repository/AreaRepository.php line 8

Open in your IDE?
  1. <?php
  3. namespace AdminBundle\Repository;
  5. use AdminBundle\Entity\Area;
  6. use Doctrine\ORM\Query;
  8. class AreaRepository extends BaseRepository
  9. {
  10. public function getAirportAreas()
  11. {
  12. $queryBuilder = $this->createQueryBuilder('a')
  13. ->where('a.category = :category')
  14. ->setParameter('category', Area::CATEGORY_AIRPORT)
  15. ->orderBy('a.areaPriority', 'ASC');
  17. return $queryBuilder->getQuery()->getArrayResult(Query::HYDRATE_ARRAY);
  18. }
  20. public function getWithQueueActive()
  21. {
  22. return $this
  23. ->createQueryBuilder('a')
  24. ->select('
  25. a.id as areaId,
  26. a.areaName, a.areaCode, a.areaCoords,
  27. a.areaType, a.maxAllowQueueDistance,
  28. a.queueLimits
  29. ')
  30. ->where('a.queueActive = :true')
  31. ->setParameter('true', true)
  32. ->getQuery()
  33. ->getArrayResult(Query::HYDRATE_ARRAY)
  34. ;
  35. }
  36. }