src/Repository/ProfileTopPlacementRepository.php line 23

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by simpson <simpsonwork@gmail.com>
  4.  * Date: 2019-04-25
  5.  * Time: 13:39
  6.  */
  8. namespace App\Repository;
  10. use App\Entity\Location\City;
  11. use App\Entity\Profile\Profile;
  12. use App\Entity\Sales\Profile\TopPlacement;
  13. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  14. use Doctrine\Persistence\ManagerRegistry;
  15. use Happyr\DoctrineSpecification\Filter\Filter;
  16. use Happyr\DoctrineSpecification\Repository\EntitySpecificationRepositoryTrait;
  18. class ProfileTopPlacementRepository extends ServiceEntityRepository
  19. {
  20.     use EntitySpecificationRepositoryTrait;
  22.     private ProfileRepository $profileRepository;
  23.     public function __construct(ManagerRegistry $registry)
  24.     {
  25.         parent::__construct($registry, TopPlacement::class);
  27.         $this->profileRepository = $registry->getRepository(Profile::class);
  28.     }
  30.     public function getCurrentlyPlaced(City $city, \DateTimeInterface $currentTime): ?Profile
  31.     {
  32.         $qb = $this->createQueryBuilder('top_profile_placement')
  33.             ->select('top_profile_placement, profile') //, photo
  34.             ->join('top_profile_placement.profile', 'profile')
  35. //            ->join('profile.photos', 'photo')
  36.             ->andWhere('profile.city = :city')
  37.             ->andWhere('top_profile_placement.placedAt <= :currentTime AND :currentTime < top_profile_placement.expiresAt')
  38.             ->setParameter('city', $city->getId())
  39.             ->setParameter('currentTime', $currentTime)
  40.             ->setMaxResults(1);
  41.         $placement = $qb->getQuery()->getOneOrNullResult();
  43.         return $placement ? $placement->getProfile() : null;
  44.     }
  46.     public function getCurrentlyPlacedAndSatisfiedBy(City $city, \DateTimeInterface $currentTime, ?Filter $spec = null): ?Profile
  47.     {
  48.         $qb = $this->profileRepository->createQueryBuilder($dqlAlias = 'p')
  49.             ->select('top_profile_placement, p') //, photo
  50.             ->join('p.topPlacements', 'top_profile_placement')
  51. //            ->join('p.photos', 'photo')
  52.             ->andWhere('p.city = :city')
  53.             ->andWhere(':currentTime BETWEEN top_profile_placement.placedAt AND top_profile_placement.expiresAt')
  54.             ->setParameter('city', $city->getId())
  55.             ->setParameter('currentTime', $currentTime)
  56.             ->setMaxResults(1);
  57.         if (null !== $spec) {
  58.             $this->applySpecification($qb, $spec, $dqlAlias);
  59.         }
  61.         $profiles = $qb->getQuery()->getResult();
  63.         return $profiles[0] ?? null;
  64.     }
  66.     public function getPlacementsByPeriod(City $city, \DateTimeInterface $dateStart, \DateTimeInterface $dateEnd): array
  67.     {
  68.         $qb = $this->createQueryBuilder('top')
  69.             ->andWhere('top.city = :city')
  70.             ->setParameter('city', $city->getId())
  71.         ;
  72. /*
  73.         $orX = $qb->expr()->orX(
  74.             'top.placedAt <= :dateStart AND :dateStart < top.expiresAt',
  75.             'top.placedAt < :dateEnd AND :dateEnd <= top.expiresAt',
  76.             ':dateStart <= top.placedAt AND top.placedAt < :dateEnd',
  77.             ':dateStart < top.expiresAt AND top.expiresAt <= :dateEnd'
  78.         );
  79. */
  80.         $orX = $qb->expr()->orX(
  81.             ':dateStart <= top.placedAt AND top.placedAt < :dateEnd',
  82.             ':dateStart < top.expiresAt AND top.expiresAt <= :dateEnd',
  83.             'top.placedAt <= :dateStart AND :dateEnd <= top.expiresAt',
  84.         );
  86.         $qb->andWhere($orX)
  87.             ->setParameter('dateStart', $dateStart)
  88.             ->setParameter('dateEnd', $dateEnd)
  89.         ;
  91.         return $qb->getQuery()->getResult();
  92.     }
  93. }