src/Repository/ProductRepository.php line 19

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  6. use Doctrine\Persistence\ManagerRegistry;
  7. use Evo\Infrastructure\MappingORM\Product;
  9. /**
  10.  * @method Product|null find($id, $lockMode = null, $lockVersion = null)
  11.  * @method Product|null findOneBy(array $criteria, array $orderBy = null)
  12.  * @method Product[]    findAll()
  13.  * @method Product[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  14.  */
  15. class ProductRepository extends ServiceEntityRepository
  16. {
  17.     public function __construct(ManagerRegistry $registry)
  18.     {
  19.         parent::__construct($registry, Product::class);
  20.     }
  22.     public function findStoreAdditionForStoreName(string $storeName): ?Product
  23.     {
  24.         return $this->createQueryBuilder('p')
  25.             ->where('p.name LIKE :storeName')
  26.             ->andWhere('p.active = false')
  27.             ->setParameter('storeName', '%'.$storeName.'%')
  28.             ->getQuery()->getOneOrNullResult();
  29.     }
  31.     public function getStoreAdditionFromProductIds(array $productIds): ?Product
  32.     {
  33.         return $this->createQueryBuilder('p')
  34.             ->where('p.active = false')
  35.             ->andWhere('p.uniqueKey LIKE :uniqueKey')
  36.             ->andWhere('p.id IN (:productIds)')
  37.             ->setParameter('uniqueKey', 'STORE_ADDITION_%')
  38.             ->setParameter('productIds', $productIds)
  39.             ->setMaxResults(1)
  40.             ->getQuery()->getOneOrNullResult();
  41.     }
  42. }