src/IlaveU/FrontBundle/Repository/ProductFrontRepository.php line 44

  1. <?php
  3. namespace App\IlaveU\FrontBundle\Repository;
  5. use App\IlaveU\ShopBundle\Entity\Product\Product;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  8. use Scienta\DoctrineJsonFunctions\Query\AST\Functions\Mysql as DqlFunctions;
  10. /**
  11.  * @method Product|null find($id, $lockMode = null, $lockVersion = null)
  12.  * @method Product|null findOneBy(array $criteria, array $orderBy = null)
  13.  * @method Product[]    findAll()
  14.  * @method Product[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  15.  */
  16. class ProductFrontRepository extends ServiceEntityRepository
  17. {
  18.     public function __construct(ManagerRegistry $registry)
  19.     {
  20.         parent::__construct($registry, Product::class);
  21.     }
  28.     public function findNewProducts($maxResult=20)
  29.     {
  30.         
  31.         return $this->createQueryBuilder('p')
  32.             ->andWhere('p.isPublished = TRUE ')
  33.             ->orderBy('p.id', 'DESC')
  34.             ->setMaxResults($maxResult)
  35.             ->getQuery()
  36.             
  37.         ;
  38.     }
  41.     public function findDeals($maxResult=20)
  42.     {
  43.         $now = new \DateTime();
  44.         return $this->createQueryBuilder('p')
  45.             ->leftJoin("p.promotion","promotion")
  46.             ->andWhere('p.isPublished = TRUE ')
  47.             ->andWhere('promotion IS NOT NULL ')
  48.             ->andWhere('promotion.endAt > :now ')
  49.             ->setParameter("now",$now)
  50.             ->orderBy('p.id', 'DESC')
  51.             ->setMaxResults($maxResult)
  52.             ->getQuery()
  53.             
  54.         ;
  55.     }
  59.     /**
  60.      * @return Product[] Returns an array of PubBanner objects
  61.     */
  63.     public function findAll()
  64.     {
  65.         return $this->createQueryBuilder('p')
  67.         
  68.         
  69.             ->andWhere('p.isPublished = TRUE AND user.isValid = TRUE ')
  70.             ->orderBy('p.id', 'DESC')
  71.             ->getQuery()
  72.             
  73.         ;
  74.     }
  79.     public function findByKeyWord($value,$maxResult=20)
  80.     {
  81.         return $this->createQueryBuilder('p')
  82.             ->andWhere('p.isPublished = TRUE AND p.name LIKE :val')
  83.             ->orWhere('p.skuCode LIKE :val')
  84.             ->orWhere('p.metaTitle LIKE :val')
  85.             ->orWhere('p.metaDescription LIKE :val')
  86.             ->orWhere('p.description LIKE :val')
  87.             ->setParameter('val', "%".$value."%")
  88.             ->orderBy('p.id', 'ASC')
  89.             ->setMaxResults($maxResult)
  90.             ->getQuery()
  91.             
  92.         ;
  93.     }
  97.     public function findByKeyWordAndCategory($value,$maxResult=20)
  98.     {
  99.         return $this->createQueryBuilder('p')
  100.             ->andWhere('p.isPublished = TRUE  ')
  101.             ->andWhere('p.name LIKE :val')
  102.             ->orWhere('p.description LIKE :val')
  103.             ->setParameter('val', "%".$value."%")
  104.             ->orderBy('p.id', 'DESC')
  105.             ->setMaxResults($maxResult)
  106.             ->getQuery()
  107.             
  108.         ;
  109.     }
  112.     public function findByCategories($value,$maxResult=20,$isRand=true)
  113.     {
  115.         $queryBuilder = $this->createQueryBuilder('p');
  116.         $queryBuilder->leftJoin("p.parentCategory","parentCategory");
  117.         $queryBuilder->leftJoin("p.categoriesProduct","categoriesProduct");
  118.         $queryBuilder->andWhere('p.isPublished = TRUE  ');
  119.         $queryBuilder->andWhere('parentCategory.name LIKE :val OR categoriesProduct.name LIKE :val OR parentCategory.slug LIKE :val OR categoriesProduct.slug LIKE :val');
  120.         $queryBuilder->setParameter('val',$value);
  121.         $queryBuilder->orderBy('p.id', 'DESC');
  122.         $queryBuilder->setMaxResults($maxResult);
  123.         return $queryBuilder->getQuery();
  125.        
  126.     }
  130.     public function findBestSellers($maxResult = 20,$catogoryName=null,$createdAtLimit=null,$countryCode=null)
  131.     {
  132.         // Your logic to find the best selling products, for example:
  134.             $config = new \Doctrine\ORM\Configuration();
  135.             $config->addCustomStringFunction(DqlFunctions\JsonExtract::FUNCTION_NAME, DqlFunctions\JsonExtract::class);
  136.             $config->addCustomStringFunction(DqlFunctions\JsonSearch::FUNCTION_NAME, DqlFunctions\JsonSearch::class);
  138.             $params = [];
  139.             $queryBuilder = $this->createQueryBuilder('p');
  141.             
  143.             $queryBuilder->leftJoin('p.orderItems', 'oi');
  144.             $queryBuilder->leftJoin('oi.parentOrder', 'o');
  145.             $queryBuilder->select('p, COUNT(oi.id) as HIDDEN soldQuantity');
  146.             if($createdAtLimit){
  147.                 $queryBuilder->andWhere('o.createdAt BETWEEN :createdAtLimit AND :today' );
  148.                 $params[ 'today'] = new \DateTime("today");
  149.                 $params[ 'createdAtLimit'] = $createdAtLimit;
  150.             }
  151.             if($catogoryName){
  152.                 $queryBuilder->leftJoin("p.parentCategory","parentCategory");
  153.                 $queryBuilder->leftJoin("p.categoriesProduct","categoriesProduct");
  154.                 $queryBuilder->andWhere('parentCategory.name LIKE :catogoryName OR categoriesProduct.name LIKE :catogoryName' );
  155.                 $params[ 'catogoryName'] = $catogoryName;
  156.             }
  158.             
  159.             
  160.             $queryBuilder->groupBy('p.id');
  161.             // if($countryCode){
  162.                
  163.             //     $queryBuilder->addOrderBy("JSON_EXTRACT(p.metaData, :key)");
  164.             //     $params[ 'key'] = "shipFromCountry";
  165.                 
  166.             // }
  167.             $queryBuilder->addOrderBy('soldQuantity', 'DESC');
  168.            
  169.             
  170.             $queryBuilder->setMaxResults($maxResult);
  171.             $queryBuilder->setParameters($params);
  172.             return $queryBuilder
  173.             ->getQuery();
  174.             
  175.     }
  178.     // /**
  179.     //  * @return PubBanner[] Returns an array of PubBanner objects
  180.     //  */
  181.     /*
  182.     public function findByExampleField($value)
  183.     {
  184.         return $this->createQueryBuilder('p')
  185.             ->andWhere('p.exampleField = :val')
  186.             ->setParameter('val', $value)
  187.             ->orderBy('p.id', 'ASC')
  188.             ->setMaxResults(10)
  189.             ->getQuery()
  190.             
  191.         ;
  192.     }
  193.     */
  195.     /*
  196.     public function findOneBySomeField($value): ?PubBanner
  197.     {
  198.         return $this->createQueryBuilder('p')
  199.             ->andWhere('p.exampleField = :val')
  200.             ->setParameter('val', $value)
  201.             ->getQuery()
  202.             ->getOneOrNullResult()
  203.         ;
  204.     }
  205.     */
  206. }