src/Repository/Restaurants/RestaurantsRepository.php line 111

Open in your IDE?
  1. <?php
  3. namespace App\Repository\Restaurants;
  5. use App\Data\SearchrestaurantData;
  6. use App\Entity\Restaurants\Restaurants;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\Persistence\ManagerRegistry;
  9. use Doctrine\ORM\NonUniqueResultException;
  10. use Doctrine\ORM\QueryBuilder;
  11. use Knp\Component\Pager\Pagination\PaginationInterface;
  12. use Knp\Component\Pager\PaginatorInterface;
  14. /**
  15.  * @method Restaurants|null find($id, $lockMode = null, $lockVersion = null)
  16.  * @method Restaurants|null findOneBy(array $criteria, array $orderBy = null)
  17.  * @method Restaurants[]    findAll()
  18.  * @method Restaurants[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  19.  */
  20. class RestaurantsRepository extends ServiceEntityRepository
  21. {
  22.     /**
  23.      * @var PaginatorInterface
  24.      */
  25.     private $paginator;
  27.     public function __construct(ManagerRegistry $registry, PaginatorInterface $paginator)
  28.     {
  29.         parent::__construct($registry, Restaurants::class);
  30.         $this->paginator = $paginator;
  31.     }
  33.     /**
  34.      * @param $page
  35.      * @return PaginationInterface
  36.      */
  37.     public function findRestaurantsByActivated($page): PaginationInterface
  38.     {
  39.         $query = $this->createQueryBuilder('r')
  40.             ->select('r')
  41.             ->andWhere('r.activated = 1')
  42.             ->andWhere('r.online = 1')
  43.             ->orderBy('r.id', 'DESC')
  44.             ->getQuery();
  45.         return $this->paginator->paginate(
  46.             $query,
  47.             $page,
  48.             16
  49.         );
  50.     }
  52.     /**
  53.      * @param SearchrestaurantData $search
  54.      * @return PaginationInterface
  55.      */
  56.     public function findSearch(SearchrestaurantData $search): PaginationInterface
  57.     {
  58.         $query = $this->getSearchQuery($search)->getQuery();
  59.         return $this->paginator->paginate(
  60.             $query,
  61.             $search->page,
  62.             16
  63.         );
  64.     }
  66.     /**
  67.      * @param SearchrestaurantData $search
  68.      * @return QueryBuilder
  69.      */
  70.     private function getSearchQuery(SearchrestaurantData $search): QueryBuilder{
  71.         $query =  $this->createQueryBuilder('r')
  72.             ->select('r', 'c', 's', 'cm')
  73.             ->leftJoin('r.cities', 'c')
  74.             ->leftJoin('r.specialites', 's')
  75.             ->leftJoin('c.communes', 'cm')
  76.             ->andWhere('r.activated = TRUE')
  77.             ->andWhere('r.online = TRUE')
  78.             ->orderBy('r.ordre', 'ASC')
  79.         ;
  80.         if (!empty($search->q)){
  81.             $query = $query
  82.                 ->andWhere('r.name LIKE :q')
  83.                 ->setParameter('q', "%{$search->q}%")
  84.             ;
  85.         }
  87.         if (!empty($search->villes)){
  88.             $query = $query
  89.                 ->andWhere('c.id = :citie')
  90.                 ->setParameter('citie', $search->villes->getId())
  91.             ;
  92.         }
  94.         if (!empty($search->communes)){
  95.             $query = $query
  96.                 ->andWhere('cm.id = :commune')
  97.                 ->setParameter('commune', $search->communes->getId())
  98.             ;
  99.         }
  101.         if (!empty($search->specialite)){
  102.             $query = $query
  103.                 ->andWhere('s.id IN (:specialite)')
  104.                 ->setParameter('specialite', $search->specialite)
  105.             ;
  106.         }
  108.         return $query;
  109.     }
  111.     public function getRestaurantsRandom(Restaurants $restaurants, $limit)
  112.     {
  113.         return $this->createQueryBuilder('r')
  114.             ->andWhere('r.id != :restaurant')
  115.             ->setParameter('restaurant', $restaurants)
  116.             ->orderBy('RAND()')
  117.             ->setMaxResults($limit)
  118.             ->getQuery()
  119.             ->getResult()
  120.             ;
  121.     }
  123.     /**
  124.      * @return int|mixed|string|null
  125.      * @throws NonUniqueResultException
  126.      */
  127.     public function featured()
  128.     {
  129.         return $this->createQueryBuilder('r')
  130.             ->andWhere('r.online = 1')
  131.             ->andWhere('r.activated = 1')
  132.             ->orderBy('RAND()')
  133.             ->setMaxResults(1)
  134.             ->getQuery()
  135.             ->getOneOrNullResult()
  136.             ;
  137.     }
  138. }