src/Repository/ProductVariantRepository.php line 53

  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Category;
  6. use App\Entity\ProductCollection;
  7. use App\Entity\ProductVariant;
  8. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  9. use Doctrine\Persistence\ManagerRegistry;
  11. /**
  12.  * @extends ServiceEntityRepository<ProductVariant>
  13.  *
  14.  * @method ProductVariant|null find($id, $lockMode = null, $lockVersion = null)
  15.  * @method ProductVariant|null findOneBy(array $criteria, array $orderBy = null)
  16.  * @method ProductVariant[]    findAll()
  17.  * @method ProductVariant[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  18.  */
  19. class ProductVariantRepository extends ServiceEntityRepository
  20. {
  21.     public function __construct(ManagerRegistry $registry)
  22.     {
  23.         parent::__construct($registry, ProductVariant::class);
  24.     }
  26.     public function save(ProductVariant $entity, bool $flush = false): void
  27.     {
  28.         $this->getEntityManager()->persist($entity);
  30.         if ($flush) {
  31.             $this->getEntityManager()->flush();
  32.         }
  33.     }
  35.     public function remove(ProductVariant $entity, bool $flush = false): void
  36.     {
  37.         $this->getEntityManager()->remove($entity);
  39.         if ($flush) {
  40.             $this->getEntityManager()->flush();
  41.         }
  42.     }
  44.     public function findLinkedVariants($product,$color)
  45.     {
  46.         return $this->createQueryBuilder('p')
  47.                     ->andWhere('p.product = :product')
  48.                     ->setParameter(':product',$product)
  49.                     ->join('p.optionValues','ov')
  50.                     ->andWhere('ov.value = :color')
  51.                     ->setParameter(':color',$color)
  52.                     ->getQuery()
  53.                     ->getResult();
  54.     }
  56.     public function findPriceRange($products)
  57.     {
  58.         return $this->createQueryBuilder('v')
  59.                     ->select('MAX(v.price) as max_price ,MIN(v.price) as min_price')
  60.                     ->join('v.product','p')
  61.                     ->andWhere('v.product in (:products)')
  62.                     ->setParameter(':products',$products)
  63.                     ->getQuery()
  64.                     ->getResult();
  65.     }
  67.     public function findCategoryPriceRange(Category $category)
  68.     {
  69.         return $this->createQueryBuilder('v')
  70.                     ->select('MAX(v.price) as max_price ,MIN(v.price) as min_price')
  71.                     ->join('v.product','p')
  72.                     ->join('p.categories',"categories")
  73.                     ->andWhere('categories = :category')
  74.                     ->setParameter(":category",$category)
  75.                     ->getQuery()
  76.                     ->getResult();
  77.     }
  80.     public function findCollectionPriceRange(ProductCollection $collection)
  81.     {
  82.         return $this->createQueryBuilder('v')
  83.                     ->select('MAX(v.sellingPrice) as max_price ,MIN(v.sellingPrice) as min_price')
  84.                     ->join('v.product','p')
  85.                     ->join('p.collections',"collections")
  86.                     ->andWhere('collections = :collection')
  87.                     ->setParameter(":collection",$collection)
  88.                     ->getQuery()
  89.                     ->getResult();
  90.     }
  93.     public function findByNameLike(string $searchInput)
  94.     {
  95.         return $this->createQueryBuilder('v')
  96.                         ->andWhere('v.name LIKE :searchInput')
  97.                         ->setParameter('searchInput','%'.$searchInput.'%')
  98.                         ->setMaxResults(10)
  99.                         ->getQuery()
  100.                         ->getResult();
  101.     }
  105. //    /**
  106. //     * @return ProductVariant[] Returns an array of ProductVariant objects
  107. //     */
  108. //    public function findByExampleField($value): array
  109. //    {
  110. //        return $this->createQueryBuilder('p')
  111. //            ->andWhere('p.exampleField = :val')
  112. //            ->setParameter('val', $value)
  113. //            ->orderBy('p.id', 'ASC')
  114. //            ->setMaxResults(10)
  115. //            ->getQuery()
  116. //            ->getResult()
  117. //        ;
  118. //    }
  120. //    public function findOneBySomeField($value): ?ProductVariant
  121. //    {
  122. //        return $this->createQueryBuilder('p')
  123. //            ->andWhere('p.exampleField = :val')
  124. //            ->setParameter('val', $value)
  125. //            ->getQuery()
  126. //            ->getOneOrNullResult()
  127. //        ;
  128. //    }
  129. }