src/Repository/Offer/FoodOfferExtensionRepository.php line 64

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Slivki\Repository\Offer;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\Persistence\ManagerRegistry;
  9. use Slivki\Entity\FoodOfferExtension;
  10. use Slivki\Exception\FoodOfferExtensionNotFoundException;
  12. final class FoodOfferExtensionRepository extends ServiceEntityRepository implements FoodOfferExtensionRepositoryInterface
  13. {
  14.     public function __construct(ManagerRegistry $registry)
  15.     {
  16.         parent::__construct($registry, FoodOfferExtension::class);
  17.     }
  19.     public function findById(int $id): ?FoodOfferExtension
  20.     {
  21.         $queryBuilder = $this->createQueryBuilder('foe');
  22.         $expr = $queryBuilder->expr();
  24.         return $queryBuilder
  25.             ->andWhere($expr->eq('foe.ID', ':id'))
  26.             ->setParameter('id', $id)
  27.             ->getQuery()
  28.             ->getOneOrNullResult();
  29.     }
  31.     public function getById(int $id): FoodOfferExtension
  32.     {
  33.         $foodOfferExtension = $this->findById($id);
  34.         if (!$foodOfferExtension instanceof FoodOfferExtension) {
  35.             throw new FoodOfferExtensionNotFoundException();
  36.         }
  38.         return $foodOfferExtension;
  39.     }
  41.     public function findActiveByOfferIdAndShippingType(int $offerId, int $shippingType): array
  42.     {
  43.         $queryBuilder = $this->createQueryBuilder('foe');
  44.         $expr = $queryBuilder->expr();
  46.         $queryBuilder
  47.             ->andWhere($expr->eq('foe.offer', ':offerId'))
  48.             ->andWhere($expr->eq('foe.active', ':isActive'))
  49.             ->setParameter('offerId', $offerId)
  50.             ->setParameter('isActive', true);
  52.         if (FoodOfferExtension::DELIVERY_METHOD === $shippingType) {
  53.             $queryBuilder->andWhere($expr->eq('foe.isDelivery', ':isDelivery'))
  54.                 ->setParameter('isDelivery', true);
  55.         }
  57.         if (FoodOfferExtension::DELIVERY_METHOD_PICKUP === $shippingType) {
  58.             $queryBuilder->andWhere($expr->eq('foe.isPickup', ':isPickup'))
  59.                 ->setParameter('isPickup', true);
  60.         }
  62.         return $queryBuilder
  63.             ->getQuery()
  64.             ->getResult();
  65.     }
  67.     public function findAllActiveByOfferId(int $offerId): array
  68.     {
  69.         $queryBuilder = $this->createQueryBuilder('foe');
  70.         $expr = $queryBuilder->expr();
  72.         return $queryBuilder
  73.             ->andWhere($expr->eq('foe.offer', ':offerId'))
  74.             ->andWhere($expr->eq('foe.active', ':isActive'))
  75.             ->setParameter('offerId', $offerId)
  76.             ->setParameter('isActive', true)
  77.             ->getQuery()
  78.             ->getResult();
  79.     }
  80. }