src/Repository/ProfileTopPlacementRepository.php line 36

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;
  17. class ProfileTopPlacementRepository extends ServiceEntityRepository
  18. {
  19.     public function __construct(ManagerRegistry $registry)
  20.     {
  21.         parent::__construct($registry, TopPlacement::class);
  22.     }
  24.     public function getCurrentlyPlaced(City $city, \DateTimeInterface $currentTime): ?Profile
  25.     {
  26.         $qb = $this->createQueryBuilder('top_profile_placement')
  27.             ->select('top_profile_placement, profile') //, photo
  28.             ->join('top_profile_placement.profile', 'profile')
  29. //            ->join('profile.photos', 'photo')
  30.             ->andWhere('profile.city = :city')
  31.             ->andWhere('top_profile_placement.placedAt <= :currentTime AND :currentTime < top_profile_placement.expiresAt')
  32.             ->setParameter('city', $city->getId())
  33.             ->setParameter('currentTime', $currentTime)
  34.             ->setMaxResults(1);
  35.         ;
  36.         $placement = $qb->getQuery()->getOneOrNullResult();
  38.         return $placement ? $placement->getProfile() : null;
  39.     }
  41.     public function getCurrentlyPlacedAndSatisfiedBy(City $city, \DateTimeInterface $currentTime, ?Filter $spec = null): ?Profile
  42.     {
  43.         $qb = $this->createQueryBuilder($dqlAlias = 'top_profile_placement')
  44.             ->select('top_profile_placement, profile') //, photo
  45.             ->join('top_profile_placement.profile', 'profile')
  46. //            ->join('profile.photos', 'photo')
  47.             ->andWhere('profile.city = :city')
  48.             ->andWhere(':currentTime BETWEEN top_profile_placement.placedAt AND top_profile_placement.expiresAt')
  49.             ->setParameter('city', $city->getId())
  50.             ->setParameter('currentTime', $currentTime)
  51.             ->setMaxResults(1);
  52.         if (null !== $spec) {
  53.             $qb->andWhere($spec->getFilter($qb, $dqlAlias));
  54.         }
  56.         $placement = $qb->getQuery()->getOneOrNullResult();
  58.         return $placement ? $placement->getProfile() : null;
  59.     }
  61.     public function getPlacementsByPeriod(City $city, \DateTimeInterface $dateStart, \DateTimeInterface $dateEnd): array
  62.     {
  63.         $qb = $this->createQueryBuilder('top')
  64.             ->andWhere('top.city = :city')
  65.             ->setParameter('city', $city->getId())
  66.         ;
  67. /*
  68.         $orX = $qb->expr()->orX(
  69.             'top.placedAt <= :dateStart AND :dateStart < top.expiresAt',
  70.             'top.placedAt < :dateEnd AND :dateEnd <= top.expiresAt',
  71.             ':dateStart <= top.placedAt AND top.placedAt < :dateEnd',
  72.             ':dateStart < top.expiresAt AND top.expiresAt <= :dateEnd'
  73.         );
  74. */
  75.         $orX = $qb->expr()->orX(
  76.             ':dateStart <= top.placedAt AND top.placedAt < :dateEnd',
  77.             ':dateStart < top.expiresAt AND top.expiresAt <= :dateEnd',
  78.             'top.placedAt <= :dateStart AND :dateEnd <= top.expiresAt',
  79.         );
  81.         $qb->andWhere($orX)
  82.             ->setParameter('dateStart', $dateStart)
  83.             ->setParameter('dateEnd', $dateEnd)
  84.         ;
  86.         return $qb->getQuery()->getResult();
  87.     }
  88. }