src/Repository/OptionValueRepository.php line 100

  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Category;
  6. use App\Entity\OptionValue;
  7. use App\Entity\ProductCollection;
  8. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  9. use Doctrine\Persistence\ManagerRegistry;
  11. /**
  12.  * @extends ServiceEntityRepository<OptionValue>
  13.  *
  14.  * @method OptionValue|null find($id, $lockMode = null, $lockVersion = null)
  15.  * @method OptionValue|null findOneBy(array $criteria, array $orderBy = null)
  16.  * @method OptionValue[]    findAll()
  17.  * @method OptionValue[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  18.  */
  19. class OptionValueRepository extends ServiceEntityRepository
  20. {
  21.     public function __construct(ManagerRegistry $registry)
  22.     {
  23.         parent::__construct($registry, OptionValue::class);
  24.     }
  26.     public function save(OptionValue $entity, bool $flush = false): void
  27.     {
  28.         $this->getEntityManager()->persist($entity);
  30.         if ($flush) {
  31.             $this->getEntityManager()->flush();
  32.         }
  33.     }
  35.     public function remove(OptionValue $entity, bool $flush = false): void
  36.     {
  37.         $this->getEntityManager()->remove($entity);
  39.         if ($flush) {
  40.             $this->getEntityManager()->flush();
  41.         }
  42.     }
  44.     public function findUniqueColors($variants,$option)
  45.     {
  46.         return $this->createQueryBuilder('o')
  47.                         // ->select('o.value')
  48.                         ->groupBy('o.value')
  49.                         ->andWhere('o.productVariant in (:variants)')
  50.                         ->andWhere('o.productOption = :option')
  51.                         ->setParameter(':variants',$variants)
  52.                         ->setParameter(':option',$option)
  53.                         ->getQuery()
  54.                         ->getResult();
  55.                         
  56.     }
  58.     public function findCategoryColors($products)
  59.     {
  60.         return $this->createQueryBuilder('o')
  61.                     ->join("o.productVariant","pv")
  62.                     ->andWhere('pv.product in (:products)')
  63.                     ->andWhere('o.name = :color ')
  64.                     ->setParameter(':color',"Color")
  65.                     ->setParameter(':products',$products)
  66.                     ->groupBy('o.value')
  67.                     ->getQuery()
  68.                     ->getResult();
  69.     }
  71.     public function findCategoryColorsTest(Category $category)
  72.     {
  73.         return $this->createQueryBuilder('o')
  74.                     ->join("o.productVariant","pv")
  75.                     ->join("pv.product","p")
  76.                     ->join("p.categories",'categories')
  77.                     ->andWhere("categories = :category")
  78.                     ->andWhere("o.name = :color")
  79.                     ->setParameter(":color","Color")
  80.                     ->setParameter(":category",$category)
  81.                     ->groupBy("o.value")
  82.                     ->getQuery()
  83.                     ->getResult();
  84.     }
  88.     public function findCategorySizesTest($category){
  90.         return $this->createQueryBuilder('o')
  91.                     ->join("o.productVariant","pv")
  92.                     ->join("pv.product","p")
  93.                     ->join("p.categories","categories")
  94.                     ->andWhere("categories = :category")
  95.                     ->andWhere("o.name = :size")
  96.                     ->setParameter(":size","Size")
  97.                     ->setParameter(":category",$category)
  98.                     ->groupBy("o.value")
  99.                     ->getQuery()
  100.                     ->getResult();
  102.     }
  103.     
  104.     public function findCollectionColors(ProductCollection $collection)
  105.     {
  106.         return $this->createQueryBuilder('o')
  107.                     ->join("o.productVariant","pv")
  108.                     ->join("pv.product","p")
  109.                     ->join("p.collections","collections")
  110.                     ->andWhere('collections = :collection')
  111.                     ->andWhere('o.name = :color')
  112.                     ->setParameter(':collection',$collection)
  113.                     ->setParameter(":color","Color")
  114.                     ->groupBy('o.value')
  115.                     ->getQuery()
  116.                     ->getResult();
  117.     }
  119.     public function findCollectionSizes(ProductCollection $collection)
  120.     {
  121.         return $this->createQueryBuilder('o')
  122.                     ->join("o.productVariant","pv")
  123.                     ->join("pv.product","p")
  124.                     ->join("p.collections","collections")
  125.                     ->andWhere('collections = :collection')
  126.                     ->andWhere('o.name = :name')
  127.                     ->setParameter(':collection',$collection)
  128.                     ->setParameter(":name","Size")
  129.                     ->groupBy('o.value')
  130.                     ->getQuery()
  131.                     ->getResult();
  132.     }
  134.     public function findCategorySizes($products)
  135.     {
  136.         return $this->createQueryBuilder('o')
  137.                     ->join("o.productVariant","pv")
  138.                     ->andWhere('pv.product in (:products)')
  139.                     ->andWhere('o.name = :size ')
  140.                     ->setParameter(':size',"Size")
  141.                     ->setParameter(':products',$products)
  142.                     ->groupBy('o.value')
  143.                     ->getQuery()
  144.                     ->getResult();
  145.     }
  148.     public function findUniqueSizes($variants,$option)
  149.     {
  150.                 return $this->createQueryBuilder('o')
  151.                         // ->select('o.value')
  152.                         // ->groupBy('o.value')
  153.                         ->andWhere('o.productVariant in (:variants)')
  154.                         ->andWhere('o.productOption = :option')
  155.                         ->setParameter(':variants',$variants)
  156.                         ->setParameter(':option',$option)
  157.                         ->getQuery()
  158.                         ->getResult();
  159.     }
  161.     // public function findUniqueProducts()
  162.     // {
  163.     //     return $this->createQueryBuilder('o')
  164.     //                 // ->distinct()
  165.     //                 ->andWhere('o.name = :name')
  166.     //                 ->setParameter('name','Color')
  167.     //                 // ->groupBy('o.value')
  168.     //                 ->getQuery()
  169.     //                 ->getResult();
  170.     // }
  172. //    /**
  173. //     * @return OptionValue[] Returns an array of OptionValue objects
  174. //     */
  175. //    public function findByExampleField($value): array
  176. //    {
  177. //        return $this->createQueryBuilder('o')
  178. //            ->andWhere('o.exampleField = :val')
  179. //            ->setParameter('val', $value)
  180. //            ->orderBy('o.id', 'ASC')
  181. //            ->setMaxResults(10)
  182. //            ->getQuery()
  183. //            ->getResult()
  184. //        ;
  185. //    }
  187. //    public function findOneBySomeField($value): ?OptionValue
  188. //    {
  189. //        return $this->createQueryBuilder('o')
  190. //            ->andWhere('o.exampleField = :val')
  191. //            ->setParameter('val', $value)
  192. //            ->getQuery()
  193. //            ->getOneOrNullResult()
  194. //        ;
  195. //    }
  196. }