src/Paginator/WorkExample/WorkExamplePaginator.php line 29

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Slivki\Paginator\WorkExample;
  7. use Doctrine\ORM\EntityManagerInterface;
  8. use Knp\Component\Pager\Pagination\PaginationInterface;
  9. use Knp\Component\Pager\PaginatorInterface;
  10. use Slivki\Entity\WorkExample;
  11. use Slivki\Message\Query\Beauty\Offer\GetWorkExampleOfMasterQuery;
  12. use Slivki\Message\Query\WorkExample\GetWorkExamplesQuery;
  14. use function sprintf;
  16. final class WorkExamplePaginator implements WorkExamplePaginatorInterface
  17. {
  18.     private EntityManagerInterface $entityManager;
  19.     private PaginatorInterface $paginator;
  21.     public function __construct(
  22.         EntityManagerInterface $entityManager,
  23.         PaginatorInterface $paginator
  24.     ) {
  25.         $this->entityManager = $entityManager;
  26.         $this->paginator = $paginator;
  27.     }
  29.     public function findAllByQuery(GetWorkExamplesQuery $query): PaginationInterface
  30.     {
  31.         $queryBuilder = $this->entityManager->createQueryBuilder();
  32.         $expr = $queryBuilder->expr();
  34.         $currentUserPosition = $query->getCurrentUserPosition();
  36.         $queryBuilder
  37.             ->addSelect('workExample')
  38.             ->addSelect(
  39.                 sprintf(
  40.                     '%s as %s',
  41.                     $currentUserPosition === null
  42.                         ? 0
  43.                         : $expr->min(
  44.                         sprintf(
  45.                             "ST_Distance(geoLocation.point, GeomFromEWKT('SRID=4326;POINT(%s %s)'))",
  46.                             $currentUserPosition->getLatitude(),
  47.                             $currentUserPosition->getLongitude(),
  48.                         ),
  49.                     ),
  50.                     WorkExamplePaginatorInterface::DISTANCE_SORT_FIELD,
  51.                 ),
  52.             )
  53.             ->addSelect('RAND() as HIDDEN rand')
  54.             ->from(WorkExample::class, 'workExample')
  55.             ->innerJoin('workExample.offer', 'offer')
  56.             ->innerJoin('workExample.geoLocations', 'geoLocation')
  57.             ->andWhere($expr->eq('offer.active', ':active'))
  58.             ->andWhere($expr->eq('offer.hidden', ':hidden'))
  59.             ->andWhere($expr->between('current_timestamp()', 'offer.activeSince', 'offer.activeTill'))
  60.             ->addGroupBy('workExample')
  61.             ->addOrderBy($query->getSortField(), $query->getSortDirection())
  62.             ->setParameter('active', true)
  63.             ->setParameter('hidden', false)
  64.         ;
  66.         if (null !== $query->getCategoryId()) {
  67.             $queryBuilder
  68.                 ->innerJoin('offer.categories', 'category')
  69.                 ->andWhere($expr->eq('category', ':categoryId'))
  70.                 ->setParameter('categoryId', $query->getCategoryId())
  71.             ;
  72.         }
  74.         if (null !== $query->getOfferId()) {
  75.             $queryBuilder->andWhere($expr->eq('workExample.offer', ':offerId'));
  76.             $queryBuilder->setParameter('offerId', $query->getOfferId());
  77.         }
  79.         if (null !== $query->getMinPrice()) {
  80.             $queryBuilder->andWhere($expr->gte('workExample.price', ':minPrice'));
  81.             $queryBuilder->setParameter('minPrice', $query->getMinPrice());
  82.         }
  84.         if (null !== $query->getMaxPrice()) {
  85.             $queryBuilder->andWhere($expr->lte('workExample.price', ':maxPrice'));
  86.             $queryBuilder->setParameter('maxPrice', $query->getMaxPrice());
  87.         }
  89.         return $this->paginator->paginate($queryBuilder->getQuery(), $query->getPage(), $query->getPerPage());
  90.     }
  92.     public function findByMaster(GetWorkExampleOfMasterQuery $query): PaginationInterface
  93.     {
  94.         $queryBuilder = $this->entityManager->createQueryBuilder();
  95.         $expr = $queryBuilder->expr();
  97.         $queryBuilder
  98.             ->addSelect('workExample')
  99.             ->from(WorkExample::class, 'workExample')
  100.             ->andWhere($expr->eq('workExample.beautyMaster', ':masterId'))
  101.             ->setParameter('masterId', $query->getMasterId());
  103.         return $this->paginator->paginate($queryBuilder->getQuery(), $query->getPage(), $query->getPerPage());
  104.     }
  105. }