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;
  16. class ProfileTopPlacementRepository extends ServiceEntityRepository
  17. {
  18.     public function __construct(ManagerRegistry $registry)
  19.     {
  20.         parent::__construct($registry, TopPlacement::class);
  21.     }
  23.     public function getCurrentlyPlaced(City $city, \DateTimeInterface $currentTime): ?Profile
  24.     {
  25.         $qb = $this->createQueryBuilder('top_profile_placement')
  26.             ->select('top_profile_placement, profile') //, photo
  27.             ->join('top_profile_placement.profile', 'profile')
  28. //            ->join('profile.photos', 'photo')
  29.             ->andWhere('profile.city = :city')
  30.             ->andWhere('top_profile_placement.placedAt <= :currentTime AND :currentTime < top_profile_placement.expiresAt')
  31.             ->setParameter('city', $city->getId())
  32.             ->setParameter('currentTime', $currentTime)
  33.             ->setMaxResults(1);
  34.         ;
  35.         $placement = $qb->getQuery()->getOneOrNullResult();
  37.         return $placement ? $placement->getProfile() : null;
  38.     }
  40.     public function getPlacementsByPeriod(City $city, \DateTimeInterface $dateStart, \DateTimeInterface $dateEnd): array
  41.     {
  42.         $qb = $this->createQueryBuilder('top')
  43.             ->andWhere('top.city = :city')
  44.             ->setParameter('city', $city->getId())
  45.         ;
  47.         $orX = $qb->expr()->orX(
  48.             'top.placedAt <= :dateStart AND :dateStart < top.expiresAt',
  49.             'top.placedAt < :dateEnd AND :dateEnd <= top.expiresAt',
  50.             ':dateStart <= top.placedAt AND top.placedAt < :dateEnd',
  51.             ':dateStart < top.expiresAt AND top.expiresAt <= :dateEnd'
  52.         );
  54.         $qb->andWhere($orX)
  55.             ->setParameter('dateStart', $dateStart)
  56.             ->setParameter('dateEnd', $dateEnd)
  57.         ;
  59.         return $qb->getQuery()->getResult();
  60.     }
  61. }