src/Repository/Product/AutoProductVariantRepository.php line 23

Open in your IDE?
  1. <?php
  3. namespace App\Repository\Product;
  5. use App\Entity\Booking\Cabin;
  6. use App\Entity\Booking\Quote;
  7. use App\Entity\Product\AutoProductVariant;
  8. use App\Repository\ApplicationFilterRepository;
  9. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  10. use Doctrine\Persistence\ManagerRegistry;
  11. use Exception;
  13. /**
  14.  * @method AutoProductVariant|null find($id, $lockMode = null, $lockVersion = null)
  15.  * @method AutoProductVariant|null findOneBy(array $criteria, array $orderBy = null)
  16.  * @method AutoProductVariant[]    findAll()
  17.  * @method AutoProductVariant[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  18.  */
  19. class AutoProductVariantRepository extends ServiceEntityRepository
  20. {
  21.     public function __construct(ManagerRegistry $registry)
  22.     {
  23.         parent::__construct($registry, AutoProductVariant::class);
  24.     }
  26.     const TYPE_PRICE_FIX = "fixe";
  27.     const TYPE_PRICE_BY_DAY = "byDay";
  28.     const TYPE_PRICE_BY_NIGHT = "byNight";
  30.     const ATTRIBUTION_CABIN = "cabin";
  31.     const ATTRIBUTION_PASSENGER = "passenger";
  33.     const SPECIFICITY_INCLUDED = "included";
  34.     const SPECIFICITY_NOT_INCLUDED = "notIncluded";
  35.     const SPECIFICITY_OFFERED = "offered";
  37.     /**
  38.      * @throws Exception
  39.      */
  40.     public function findByQuoteAndCabin(Quote $quote, Cabin $cabin)
  41.     {
  42.         $qb = $this->createQueryBuilder('apv')->innerJoin('apv.applicationFilter', 'af');
  43.         $qb = ApplicationFilterRepository::addApplicationFilterQueryBuilderForObject($qb, $quote);
  44.         $qb = ApplicationFilterRepository::addApplicationFilterQueryBuilderForCruiseHistory($qb, $quote->getCruiseHistory());
  45.         $qb = ApplicationFilterRepository::addApplicationFilterQueryBuilderForCabin($qb, $cabin);
  46.         return $qb->getQuery()->getResult();
  47.     }
  49.     public function findActives(): array
  50.     {
  51.         $qb = $this->createQueryBuilder('apv');
  53.         return $qb
  54.             ->join('apv.applicationFilter', 'af')
  55.             ->where($qb->expr()->eq('af.active', true))
  56.             ->andWhere($qb->expr()->orX(
  57.                 $qb->expr()->isNull('af.applicationDateEnd'),
  58.                 $qb->expr()->gte('af.applicationDateEnd', ':now')
  59.             ))
  60.             ->setParameter('now', new \DateTime())
  61.             ->getQuery()
  62.             ->getResult();
  63.     }
  64. }