src/Repository/PricingRepository.php line 82

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Pricing;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Common\Persistence\ManagerRegistry;
  9. /**
  10.  * @method Pricing|null find($id, $lockMode = null, $lockVersion = null)
  11.  * @method Pricing|null findOneBy(array $criteria, array $orderBy = null)
  12.  * @method Pricing[]    findAll()
  13.  * @method Pricing[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  14.  */
  15. class PricingRepository extends ServiceEntityRepository
  16. {
  17.     public function __construct(ManagerRegistry $registry)
  18.     {
  19.         parent::__construct($registry, Pricing::class);
  20.     }
  22.     public function findAllDiscountsOfCompany($company)
  23.     {
  24.         return $this->createQueryBuilder('p')
  25.             ->join('p.discountProduct', 'product')
  26.             ->andWhere('product.company = :company')
  27.             ->andWhere('p.isADiscount = true')
  28.             ->setParameter('company', $company)
  29.             ->orderBy('p.endDate', 'ASC')
  30.             ->getQuery()
  31.             ->getResult()
  32.         ;
  33.     }
  35.     public function findOnSale($sorting = null, $order = null)
  36.     {
  37.         $now = new \DateTime();
  38.         $products =  $this->createQueryBuilder('p')
  39.         // ->select('size(prod.inCarts)')
  40.             ->andWhere('p.isADiscount = true')
  41.             ->leftJoin('p.products', 'prod')
  42.             ->andWhere('p.startDate <= :now')
  43.             ->andWhere('p.endDate >= :now')
  44.             ->setParameter('now', $now);
  46.             if ($sorting != null) {
  47.      
  48.                 if ($sorting == "popularity") {
  49.                   if (strtolower($order) == "asc") {
  50.                     $order = "ASC";
  51.                   } else {
  52.                     $order = "DESC";
  53.                   }
  54.             
  55.                    $sorting = 'size(prod.inCarts)';
  56.             
  57.                 }
  58.                 if ($sorting == "price") {
  59.                   if (strtolower($order) == "asc") {
  60.                     $order = "ASC";
  61.                   } else {
  62.                     $order = "DESC";
  63.                   }
  64.                  
  65.                   $sorting = "p.price";
  66.                   
  67.                 }
  68.                 if ($sorting == "date") {
  69.                   if (strtolower($order) == "asc") {
  70.                     $order = "ASC";
  71.                   } else {
  72.                     $order = "DESC";
  73.                   }
  74.             
  75.                   $sorting ="p.startDate";
  76.                 }
  77.                 $products->orderBy( $sorting , $order);
  78.               }
  79.   
  80. // dd($products);
  81.             return $products->getQuery()
  82.             ->getResult();
  84.     }
  86.     public function findOnSaleFrontpage($maxResults = 10)
  87.     {
  88.         $now = new \DateTime();
  89.         return $this->createQueryBuilder('p')
  90.             ->andWhere('p.isADiscount = true')
  91.             ->andWhere('p.startDate <= :now')
  92.             ->andWhere('p.endDate >= :now')
  93.             ->setParameter('now', $now)
  94.             ->setMaxResults($maxResults)
  95.             ->orderBy('RAND()')
  96.             ->getQuery()
  97.             ->getResult()
  98.         ;
  99.     }
  100. }