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.             ->from(WorkExample::class, 'workExample')
  54.             ->innerJoin('workExample.offer', 'offer')
  55.             ->innerJoin('workExample.geoLocations', 'geoLocation')
  56.             ->addGroupBy('workExample')
  57.             ->addOrderBy($query->getSortField(), $query->getSortDirection())
  58.         ;
  60.         if (null !== $query->getCategoryId()) {
  61.             $queryBuilder
  62.                 ->innerJoin('offer.categories', 'category')
  63.                 ->andWhere($expr->eq('category', ':categoryId'))
  64.                 ->setParameter('categoryId', $query->getCategoryId())
  65.             ;
  66.         }
  68.         if (null !== $query->getOfferId()) {
  69.             $queryBuilder->andWhere($expr->eq('workExample.offer', ':offerId'));
  70.             $queryBuilder->setParameter('offerId', $query->getOfferId());
  71.         }
  73.         if (null !== $query->getMinPrice()) {
  74.             $queryBuilder->andWhere($expr->gte('workExample.price', ':minPrice'));
  75.             $queryBuilder->setParameter('minPrice', $query->getMinPrice());
  76.         }
  78.         if (null !== $query->getMaxPrice()) {
  79.             $queryBuilder->andWhere($expr->lte('workExample.price', ':maxPrice'));
  80.             $queryBuilder->setParameter('maxPrice', $query->getMaxPrice());
  81.         }
  83.         return $this->paginator->paginate($queryBuilder->getQuery(), $query->getPage(), $query->getPerPage());
  84.     }
  86.     public function findByMaster(GetWorkExampleOfMasterQuery $query): PaginationInterface
  87.     {
  88.         $queryBuilder = $this->entityManager->createQueryBuilder();
  89.         $expr = $queryBuilder->expr();
  91.         $queryBuilder
  92.             ->addSelect('workExample')
  93.             ->from(WorkExample::class, 'workExample')
  94.             ->andWhere($expr->eq('workExample.beautyMaster', ':masterId'))
  95.             ->setParameter('masterId', $query->getMasterId());
  97.         return $this->paginator->paginate($queryBuilder->getQuery(), $query->getPage(), $query->getPerPage());
  98.     }
  99. }