src/Aqarmap/Bundle/AnnouncementBundle/Repository/AnnouncementRepository.php line 44

Open in your IDE?
  1. <?php
  3. namespace Aqarmap\Bundle\AnnouncementBundle\Repository;
  5. use Doctrine\ORM\EntityRepository;
  6. use Doctrine\ORM\NonUniqueResultException;
  8. class AnnouncementRepository extends EntityRepository
  9. {
  10.     /**
  11.      * @return int|mixed|string|null
  12.      *
  13.      * @throws NonUniqueResultException
  14.      */
  15.     public function getActiveAnnouncement(array $criteria = [])
  16.     {
  17.         $criteria = array_merge([
  18.             'topBar' => null,
  19.             'appearOnMobile' => null,
  20.         ], $criteria);
  22.         $date = new \DateTime();
  23.         $date = $date->format('Y-m-d H:i:s');
  25.         $QueryBuilder = $this->createQueryBuilder('a');
  26.         if ($criteria['topBar']) {
  27.             $QueryBuilder
  28.                 ->andWhere($QueryBuilder->expr()->in('a.topBar', ':topBar'))
  29.                 ->setParameter('topBar', $criteria['topBar'])
  30.             ;
  31.         }
  33.         if ($criteria['appearOnMobile']) {
  34.             $QueryBuilder
  35.                 ->andWhere($QueryBuilder->expr()->in('a.appearOnMobile', ':appearOnMobile'))
  36.                 ->setParameter('appearOnMobile', $criteria['appearOnMobile'])
  37.             ;
  38.         }
  40.         $QueryBuilder
  41.             ->andWhere($QueryBuilder->expr()->gte('a.endAt', ':endAt'))
  42.             ->setParameter('endAt', $date);
  44.         return $QueryBuilder->getQuery()->getOneOrNullResult();
  45.     }
  46. }