src/Repository/Partner/PartnerCompanyDiscountRepository.php line 27

Open in your IDE?
  1. <?php
  3. namespace App\Repository\Partner;
  5. use App\Entity\Cruise\CabinCategory\CabinCategoryType;
  6. use App\Entity\Cruise\CabinCategory\CabinType;
  7. use App\Entity\Cruise\Company\Company;
  8. use App\Entity\Partner\Partner;
  9. use App\Entity\Partner\PartnerCompanyDiscount;
  10. use DateTime;
  11. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  12. use Doctrine\ORM\NonUniqueResultException;
  13. use Doctrine\ORM\Query\Expr\Join;
  14. use Doctrine\ORM\QueryBuilder;
  15. use Doctrine\Persistence\ManagerRegistry;
  17. /**
  18.  * @method PartnerCompanyDiscount|null find($id, $lockMode = null, $lockVersion = null)
  19.  * @method PartnerCompanyDiscount|null findOneBy(array $criteria, array $orderBy = null)
  20.  * @method PartnerCompanyDiscount[]    findAll()
  21.  * @method PartnerCompanyDiscount[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  22.  */
  23. class PartnerCompanyDiscountRepository extends ServiceEntityRepository
  24. {
  25.     public function __construct(ManagerRegistry $registry)
  26.     {
  27.         parent::__construct($registry, PartnerCompanyDiscount::class);
  28.     }
  30.     public function findDistinctCompanyNamesByPartner(Partner $partner): array
  31.     {
  32.         $result = $this->createQueryBuilder('pcd')
  33.             ->select('c.name')
  34.             ->innerJoin(Company::class, 'c', Join::WITH, 'c.id = pcd.company')
  35.             ->where('pcd.partner = :partner')
  36.             ->setParameter('partner', $partner)
  37.             ->groupBy('c.name')
  38.             ->getQuery()
  39.             ->getScalarResult();
  41.         return array_column($result, 'name');
  42.     }
  44.     public function findDistinctCabinTypeNamesByPartner(Partner $partner): array
  45.     {
  46.         $result = $this->createQueryBuilder('pcd')
  47.             ->select('ct.name')
  48.             ->innerJoin(CabinCategoryType::class, 'cct', Join::WITH, 'cct.id = pcd.cabinCategoryType')
  49.             ->innerJoin(CabinType::class, 'ct', Join::WITH, 'ct.id = cct.cabinType')
  50.             ->where('pcd.partner = :partner')
  51.             ->setParameter('partner', $partner)
  52.             ->groupBy('ct.name')
  53.             ->getQuery()
  54.             ->getScalarResult();
  56.         return array_column($result, 'name');
  57.     }
  59.     public function findDiscountAndCabinTypeByPartner(Partner $partner): array
  60.     {
  61.         return $this->createQueryBuilder('pcd')
  62.             ->select('ct.name as cabintypeName, cct.name as cabinCategoryTypeName, c.name as companyName, pcd.rate')
  63.             ->innerJoin(CabinCategoryType::class, 'cct', Join::WITH, 'cct.id = pcd.cabinCategoryType')
  64.             ->innerJoin(CabinType::class, 'ct', Join::WITH, 'ct.id = cct.cabinType')
  65.             ->innerJoin(Company::class, 'c', Join::WITH, 'c.id = pcd.company')
  66.             ->where('pcd.partner = :partner')
  67.             ->setParameter('partner', $partner)
  68.             ->getQuery()
  69.             ->getScalarResult();
  70.     }
  72.     /**
  73.      * @throws NonUniqueResultException
  74.      */
  75.     public function findDiscountByPartnerAndCompanyAndCabinType(Partner $partner, CabinType $cabinType, Company $company): ?PartnerCompanyDiscount
  76.     {
  77.         return $this->createQueryBuilder('pcd')
  78.             ->where('pcd.partner = :partner')
  79.             ->andWhere('pcd.company = :company')
  80.             ->andWhere('pcd.cabinType = :cabinType')
  81.             ->setParameters([
  82.                 'partner' => $partner,
  83.                 'company' => $company,
  84.                 'cabinType' => $cabinType,
  85.             ])
  86.             ->getQuery()
  87.             ->getOneOrNullResult();
  88.     }
  92.     /**
  93.      * @throws NonUniqueResultException
  94.      */
  95.     public function findByPartnerAndCompanyAndCabinTypeAtDate(Partner $partner, Company $company, CabinType $cabinType, DateTime $date): ?PartnerCompanyDiscount
  96.     {
  97.         $qb = $this->createQueryBuilder('pcd');
  98.         return $qb->where($qb->expr()->eq('pcd.partner', ':partner'))
  99.             ->andWhere($qb->expr()->eq('pcd.company', ':company'))
  100.             ->andWhere($qb->expr()->eq('pcd.cabinType', ':cabinType'))
  101.             ->andWhere($qb->expr()->andX(
  102.                 $qb->expr()->orX(
  103.                     $qb->expr()->lte('pcd.startsAt', ':date'),
  104.                     $qb->expr()->isNull('pcd.startsAt')
  105.                 ),
  106.                 $qb->expr()->orX(
  107.                     $qb->expr()->gte('pcd.endsAt', ':date'),
  108.                     $qb->expr()->isNull('pcd.endsAt')
  109.                 )
  110.             ))
  111.             ->setParameter('partner', $partner)
  112.             ->setParameter('company', $company)
  113.             ->setParameter('cabinType', $cabinType)
  114.             ->setParameter('date', $date->format('Y-m-d'))
  115.             ->orderBy('pcd.id', 'DESC')
  116.             ->setMaxResults(1)
  117.             ->getQuery()
  118.             ->getOneOrNullResult();
  119.     }
  121.     /**
  122.      * @throws NonUniqueResultException
  123.      */
  124.     public function findDefaultByPartnerAndCompanyAndCabinType(Partner $partner, Company $company, CabinType $cabinType): ?PartnerCompanyDiscount
  125.     {
  126.         $qb = $this->createQueryBuilder('pcd');
  127.         return $qb->where($qb->expr()->eq('pcd.partner', ':partner'))
  128.             ->andWhere($qb->expr()->eq('pcd.company', ':company'))
  129.             ->andWhere($qb->expr()->eq('pcd.cabinType', ':cabinType'))
  130.             ->andWhere($qb->expr()->eq('pcd.isDefault', ':isDefault'))
  131.             ->andWhere($qb->expr()->eq('pcd.isArchived', ':isArchived'))
  132.             ->setParameter('partner', $partner)
  133.             ->setParameter('company', $company)
  134.             ->setParameter('cabinType', $cabinType)
  135.             ->setParameter('isDefault', true)
  136.             ->setParameter('isArchived', false)
  137.             ->orderBy('pcd.id', 'DESC')
  138.             ->setMaxResults(1)
  139.             ->getQuery()
  140.             ->getOneOrNullResult();
  141.     }
  143.     /**
  144.      * @throws NonUniqueResultException
  145.      */
  146.     public function findByPartnerAndCompanyAtDate(Partner $partner, Company $company, DateTime $date): ?PartnerCompanyDiscount
  147.     {
  148.         $qb = $this->createQueryBuilder('pcd');
  149.         return $qb->where($qb->expr()->eq('pcd.partner', ':partner'))
  150.             ->andWhere($qb->expr()->eq('pcd.company', ':company'))
  151.             ->andWhere($qb->expr()->isNull('pcd.cabinType'))
  152.             ->andWhere($qb->expr()->andX(
  153.                 $qb->expr()->orX(
  154.                     $qb->expr()->lte('pcd.startsAt', ':date'),
  155.                     $qb->expr()->isNull('pcd.startsAt')
  156.                 ),
  157.                 $qb->expr()->orX(
  158.                     $qb->expr()->gte('pcd.endsAt', ':date'),
  159.                     $qb->expr()->isNull('pcd.endsAt')
  160.                 )
  161.             ))
  162.             ->setParameter('partner', $partner)
  163.             ->setParameter('company', $company)
  164.             ->setParameter('date', $date->format('Y-m-d'))
  165.             ->orderBy('pcd.id', 'DESC')
  166.             ->setMaxResults(1)
  167.             ->getQuery()
  168.             ->getOneOrNullResult();
  169.     }
  171.     /**
  172.      * @throws NonUniqueResultException
  173.      */
  174.     public function findDefaultByPartnerAndCompany(Partner $partner, Company $company): ?PartnerCompanyDiscount
  175.     {
  176.         $qb = $this->createQueryBuilder('pcd');
  177.         return $qb->where($qb->expr()->eq('pcd.partner', ':partner'))
  178.             ->andWhere($qb->expr()->eq('pcd.company', ':company'))
  179.             ->andWhere($qb->expr()->isNull('pcd.cabinType'))
  180.             ->andWhere($qb->expr()->eq('pcd.isDefault', ':isDefault'))
  181.             ->andWhere($qb->expr()->eq('pcd.isArchived', ':isArchived'))
  182.             ->setParameter('partner', $partner)
  183.             ->setParameter('company', $company)
  184.             ->setParameter('isDefault', true)
  185.             ->setParameter('isArchived', false)
  186.             ->orderBy('pcd.id', 'DESC')
  187.             ->setMaxResults(1)
  188.             ->getQuery()
  189.             ->getOneOrNullResult();
  190.     }
  192.     public function findWithActivePartnerAndWebsite(): array
  193.     {
  194.         $qb = $this->createQueryBuilder('pcd');
  196.         return $qb
  197.             ->join('pcd.partner', 'p')
  198.             ->where($qb->expr()->eq('p.isActive', true))
  199.             ->andWhere($qb->expr()->eq('p.withWebsite', true))
  200.             ->getQuery()
  201.             ->getResult()
  202.         ;
  203.     }
  205.     /**
  206.      * @return QueryBuilder
  207.      */
  208.     public function getQueryBuilderForGrid(): QueryBuilder
  209.     {
  210.         $qb = $this->createQueryBuilder('pcd');
  211.         return $qb
  212.             ->join('pcd.partner', 'p')
  213.             ->orderBy('p.name', 'ASC');
  214.     }
  215. }