app/Plugin/OrderBySale42/Event.php line 55

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of OrderBySale42
  5.  *
  6.  * Copyright(c) U-Mebius Inc. All Rights Reserved.
  7.  *
  8.  * https://umebius.com/
  9.  *
  10.  * For the full copyright and license information, please view the LICENSE
  11.  * file that was distributed with this source code.
  12.  */
  14. namespace Plugin\OrderBySale42;
  16. use Doctrine\ORM\EntityManagerInterface;
  17. use Doctrine\ORM\QueryBuilder;
  18. use Eccube\Entity\Master\OrderStatus;
  19. use Eccube\Event\EccubeEvents;
  20. use Eccube\Event\EventArgs;
  21. use Plugin\OrderBySale42\Entity\Config;
  22. use Plugin\OrderBySale42\Repository\ConfigRepository;
  23. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  25. class Event implements EventSubscriberInterface
  26. {
  27.     /**
  28.      * @var EntityManagerInterface
  29.      */
  30.     private $entityManager;
  32.     /**
  33.      * @var ConfigRepository
  34.      */
  35.     private $configRepository;
  37.     public function __construct(
  38.         EntityManagerInterface $entityManager,
  39.         ConfigRepository $configRepository
  40.     ) {
  41.         $this->entityManager = $entityManager;
  42.         $this->configRepository = $configRepository;
  43.     }
  45.     /**
  46.      * @return array
  47.      */
  48.     public static function getSubscribedEvents()
  49.     {
  50.         return [
  51.             EccubeEvents::FRONT_PRODUCT_INDEX_SEARCH => 'onFrontProductIndexSearch',
  52.         ];
  53.     }
  55.     public function onFrontProductIndexSearch(EventArgs $eventArgs)
  56.     {
  57.         /* @var $qb QueryBuilder */
  58.         $qb = $eventArgs->getArgument('qb');
  59.         $searchData = $eventArgs->getArgument('searchData');
  61.         $ProductListOrderBy = $searchData['orderby'];
  63.         if ($ProductListOrderBy) {
  64.             $Config = $this->configRepository->findOneBy([
  65.                 'product_list_order_by_id' => $ProductListOrderBy->getId(),
  66.             ]);
  68.             $excludes = [OrderStatus::CANCEL, OrderStatus::PENDING, OrderStatus::PROCESSING, OrderStatus::RETURNED];
  70.             /*if ($Config) {
  71.                 if ($Config->getType() == Config::ORDER_BY_AMOUNT) {
  72.                     $qb->addSelect('(SELECT CASE WHEN SUM(oi.price * oi.quantity) IS NULL THEN -1 ELSE SUM(oi.price * oi.quantity) END
  73.                     FROM \Eccube\Entity\OrderItem AS oi 
  74.                     LEFT JOIN oi.Order AS o 
  75.                     WHERE 
  76.                      oi.Product=p.id 
  77.                      AND o.OrderStatus not in (:excludes)
  78.                      ) AS HIDDEN  buy_quantity')
  79.                         ->orderBy('buy_quantity', 'DESC')
  80.                         ->groupBy('p.id')
  81.                         ->setParameter('excludes', $excludes)
  82.                     ;
  83.                 } elseif ($Config->getType() == Config::ORDER_BY_QUANTITY) {
  84.                     $qb->addSelect('(SELECT CASE WHEN SUM(oi.quantity) IS NULL THEN -1 ELSE SUM(oi.quantity) END
  85.                     FROM \Eccube\Entity\OrderItem AS oi 
  86.                     LEFT JOIN oi.Order AS o 
  87.                     WHERE 
  88.                      oi.Product=p.id 
  89.                      AND o.OrderStatus not in (:excludes)
  90.                      ) AS HIDDEN buy_quantity')
  91.                         ->orderBy('buy_quantity', 'DESC')
  92.                         ->groupBy('p.id')
  93.                         ->setParameter('excludes', $excludes)
  94.                     ;
  95.                 }
  96.             }*/
  97.             if ($Config) {
  98.                 if ($Config->getType() == Config::ORDER_BY_AMOUNT) {
  99.                     $select = '(SELECT CASE WHEN SUM(oi.price * oi.quantity) IS NULL THEN -1 ELSE SUM(oi.price * oi.quantity) END';
  100.                 } elseif ($Config->getType() == Config::ORDER_BY_QUANTITY) {
  101.                     $select = '(SELECT CASE WHEN SUM(oi.quantity) IS NULL THEN -1 ELSE SUM(oi.quantity) END';
  102.                 }
  103.     
  104.                 $select .= ' FROM \Eccube\Entity\OrderItem AS oi
  105.                         LEFT JOIN oi.Order AS o
  106.                         WHERE
  107.                          oi.Product=p.id
  108.                          AND o.OrderStatus not in (:excludes)';
  109.     
  110.                 if ($Config->getTargetDays()) {
  111.                     $targetDate = new \DateTime();
  112.                     $targetDate->setTime(0, 0, 0, 0);
  113.                     $targetDate->sub(new \DateInterval('P' . $Config->getTargetDays() . 'D'));
  114.                     $qb->setParameter('target_date', $targetDate);
  115.                     $select .= ' AND o.order_date >= :target_date';
  116.                 }
  117.     
  118.                 $select .= ') AS HIDDEN buy_quantity';
  119.     
  120.                 $qb->addSelect($select)
  121.                     ->orderBy('buy_quantity', 'DESC')
  122.                     ->groupBy('p.id')
  123.                     ->setParameter('excludes', $excludes);
  124.             }
  125.             $qb->addOrderBy('p.id', 'ASC');
  126.         }
  127.     }
  128. }