src/Repository/Sale/SaleRepository.php line 14

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Slivki\Repository\Sale;
  7. use DateTimeImmutable;
  8. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  9. use Doctrine\Persistence\ManagerRegistry;
  10. use Slivki\Entity\Sale;
  12. final class SaleRepository extends ServiceEntityRepository implements SaleRepositoryInterface
  13. {
  14.     public function __construct(ManagerRegistry $registry)
  15.     {
  16.         parent::__construct($registry, Sale::class);
  17.     }
  19.     public function findAllActiveSalesByCategoryId(int $categoryId): array
  20.     {
  21.         $queryBuilder = $this->createQueryBuilder('sale');
  22.         $expr = $queryBuilder->expr();
  24.         return $queryBuilder
  25.             ->innerJoin('sale.categories', 'category')
  26.             ->andWhere($expr->eq('category.ID', ':categoryId'))
  27.             ->andWhere($expr->eq('sale.active', ':active'))
  28.             ->andWhere($expr->between(':now', 'sale.since', 'sale.till'))
  29.             ->setParameters([
  30.                 'active' => true,
  31.                 'categoryId' => $categoryId,
  32.                 'now' => (new DateTimeImmutable())->format('Y-m-d H:i:s'),
  33.             ])
  34.             ->getQuery()
  35.             ->getResult();
  36.     }
  37. }