src/Paginator/Beauty/Master/MasterPaginator.php line 48

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Slivki\Paginator\Beauty\Master;
  7. use Doctrine\ORM\EntityManagerInterface;
  8. use Knp\Component\Pager\Pagination\PaginationInterface;
  9. use Knp\Component\Pager\PaginatorInterface;
  10. use Slivki\Entity\BeautyMaster;
  11. use Slivki\Entity\GeoLocation;
  12. use Slivki\Message\Query\Beauty\Category\GetMastersWithFilterQuery as GetMastersWithFilterQueryForCategory;
  13. use Slivki\Message\Query\Beauty\Offer\GetMastersWithFilterQuery as GetMastersWithFilterQueryForOffer;
  15. final class MasterPaginator implements MasterPaginatorInterface
  16. {
  17.     private EntityManagerInterface $entityManager;
  18.     private PaginatorInterface $paginator;
  20.     public function __construct(
  21.         EntityManagerInterface $entityManager,
  22.         PaginatorInterface $paginator
  23.     ) {
  24.         $this->entityManager = $entityManager;
  25.         $this->paginator = $paginator;
  26.     }
  28.     public function findAllMasterForOfferQueryByFilter(GetMastersWithFilterQueryForOffer $query): PaginationInterface
  29.     {
  30.         $queryBuilder = $this->entityManager->createQueryBuilder();
  31.         $expr = $queryBuilder->expr();
  33.         $locationIdsSubQuery = $this->entityManager->createQueryBuilder()
  34.             ->addSelect('gl.ID')
  35.             ->from(GeoLocation::class, 'gl')
  36.             ->innerJoin('gl.offers', 'o')
  37.             ->andWhere($expr->eq('o.ID', ':offerId'));
  39.         $queryBuilder
  40.             ->addSelect('bm')
  41.             ->from(BeautyMaster::class, 'bm')
  42.             ->innerJoin('bm.locations', 'l')
  43.             ->andWhere($expr->in('l.ID', $locationIdsSubQuery->getDQL()))
  44.             ->addGroupBy('bm.id')
  45.             ->addOrderBy($expr->asc('bm.id'))
  46.             ->setParameter('offerId', $query->getOfferId());
  48.         return $this->paginator->paginate($queryBuilder->getQuery(), $query->getPage(), $query->getPerPage());
  49.     }
  51.     public function findAllMasterForCategoryQueryByFilter(GetMastersWithFilterQueryForCategory $query): PaginationInterface
  52.     {
  53.         $queryBuilder = $this->entityManager->createQueryBuilder();
  54.         $expr = $queryBuilder->expr();
  56.         $queryBuilder
  57.             ->addSelect('bm')
  58.             ->from(BeautyMaster::class, 'bm')
  59.             ->innerJoin('bm.categories', 'c')
  60.             ->innerJoin('bm.locations', 'l')
  61.             ->innerJoin('l.offers', 'o')
  62.             ->andWhere($expr->eq('c.ID', ':categoryId'))
  63.             ->andWhere($expr->eq('o.active', ':offerActive'))
  64.             ->andWhere($expr->eq('o.hidden', ':offerHidden'))
  65.             ->andWhere($expr->between('current_timestamp()', 'o.activeSince', 'o.activeTill'))
  66.             ->addOrderBy($expr->asc('bm.id'))
  67.             ->setParameters([
  68.                 'categoryId' => $query->getCategoryId(),
  69.                 'offerActive' => true,
  70.                 'offerHidden' => false,
  71.             ]);
  73.         return $this->paginator->paginate($queryBuilder->getQuery(), $query->getPage(), $query->getPerPage());
  74.     }
  75. }