src/Repository/ProfileTopPlacementRepository.php line 24

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 App\Specification\Profile\ProfileIsModerationPassed;
  14. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  15. use Doctrine\Persistence\ManagerRegistry;
  16. use Happyr\DoctrineSpecification\Filter\Filter;
  17. use Happyr\DoctrineSpecification\Repository\EntitySpecificationRepositoryTrait;
  19. class ProfileTopPlacementRepository extends ServiceEntityRepository
  20. {
  21.     use EntitySpecificationRepositoryTrait;
  23.     private ProfileRepository $profileRepository;
  24.     public function __construct(ManagerRegistry $registry)
  25.     {
  26.         parent::__construct($registry, TopPlacement::class);
  28.         $this->profileRepository = $registry->getRepository(Profile::class);
  29.     }
  31.     public function getCurrentlyPlaced(City $city, \DateTimeInterface $currentTime): ?Profile
  32.     {
  33.         $qb = $this->createQueryBuilder('top_profile_placement')
  34.             ->select('top_profile_placement, profile') //, photo
  35.             ->join('top_profile_placement.profile', 'profile')
  36. //            ->join('profile.photos', 'photo')
  37.             ->andWhere('profile.city = :city')
  38.             ->andWhere('top_profile_placement.placedAt <= :currentTime AND :currentTime < top_profile_placement.expiresAt')
  39.             ->setParameter('city', $city->getId())
  40.             ->setParameter('currentTime', $currentTime)
  41.             ->setMaxResults(1);
  42.         $this->applySpecification($qb, new ProfileIsModerationPassed(), 'profile');
  43.         $placement = $qb->getQuery()->getOneOrNullResult();
  45.         return $placement ? $placement->getProfile() : null;
  46.     }
  48.     public function getCurrentlyPlacedAndSatisfiedBy(City $city, \DateTimeInterface $currentTime, ?Filter $spec = null): ?Profile
  49.     {
  50.         $qb = $this->profileRepository->createQueryBuilder($dqlAlias = 'p')
  51.             ->select('top_profile_placement, p') //, photo
  52.             ->join('p.topPlacements', 'top_profile_placement')
  53. //            ->join('p.photos', 'photo')
  54.             ->andWhere('p.city = :city')
  55.             ->andWhere(':currentTime BETWEEN top_profile_placement.placedAt AND top_profile_placement.expiresAt')
  56.             ->setParameter('city', $city->getId())
  57.             ->setParameter('currentTime', $currentTime)
  58.             ->setMaxResults(1);
  59.         $this->applySpecification($qb, new ProfileIsModerationPassed(), $dqlAlias);
  60.         if (null !== $spec) {
  61.             $this->applySpecification($qb, $spec, $dqlAlias);
  62.         }
  64.         $profiles = $qb->getQuery()->getResult();
  66.         return $profiles[0] ?? null;
  67.     }
  69.     public function getPlacementsByPeriod(City $city, \DateTimeInterface $dateStart, \DateTimeInterface $dateEnd): array
  70.     {
  71.         $qb = $this->createQueryBuilder('top')
  72.             ->andWhere('top.city = :city')
  73.             ->setParameter('city', $city->getId())
  74.         ;
  75. /*
  76.         $orX = $qb->expr()->orX(
  77.             'top.placedAt <= :dateStart AND :dateStart < top.expiresAt',
  78.             'top.placedAt < :dateEnd AND :dateEnd <= top.expiresAt',
  79.             ':dateStart <= top.placedAt AND top.placedAt < :dateEnd',
  80.             ':dateStart < top.expiresAt AND top.expiresAt <= :dateEnd'
  81.         );
  82. */
  83.         $orX = $qb->expr()->orX(
  84.             ':dateStart <= top.placedAt AND top.placedAt < :dateEnd',
  85.             ':dateStart < top.expiresAt AND top.expiresAt <= :dateEnd',
  86.             'top.placedAt <= :dateStart AND :dateEnd <= top.expiresAt',
  87.         );
  89.         $qb->andWhere($orX)
  90.             ->setParameter('dateStart', $dateStart)
  91.             ->setParameter('dateEnd', $dateEnd)
  92.         ;
  94.         return $qb->getQuery()->getResult();
  95.     }
  96. }