src/Aqarmap/Bundle/FinancialAidsBundle/Repository/FinancialAidRepository.php line 36

Open in your IDE?
  1. <?php
  3. namespace Aqarmap\Bundle\FinancialAidsBundle\Repository;
  5. use Aqarmap\Bundle\FinancialAidsBundle\Entity\FinancialAid;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\ORM\Query;
  8. use Doctrine\Persistence\ManagerRegistry;
  10. class FinancialAidRepository extends ServiceEntityRepository
  11. {
  12.     public const MAX_RANDOM_RESULT = 1;
  14.     public function __construct(ManagerRegistry $registry)
  15.     {
  16.         parent::__construct($registry, FinancialAid::class);
  17.     }
  19.     /**
  20.      * @return Query
  21.      */
  22.     public function getFinancialAids()
  23.     {
  24.         $queryBuilder = $this->createQueryBuilder('financialAid');
  26.         return $queryBuilder->getQuery();
  27.     }
  29.     /**
  30.      * Get random financial Aid.
  31.      *
  32.      * @return FinancialAid|null
  33.      *
  34.      * @throws \Doctrine\ORM\NonUniqueResultException
  35.      */
  36.     public function getRandomFinancialAid()
  37.     {
  38.         return $this->createQueryBuilder('q')
  39.             ->where('q.status = :status')
  40.             ->setParameter('status', true)
  41.             ->addSelect('RAND() as HIDDEN rand')
  42.             ->addOrderBy('rand')
  43.             ->setMaxResults(self::MAX_RANDOM_RESULT)
  44.             ->getQuery()
  45.             ->getOneOrNullResult();
  46.     }
  47. }