app/Plugin/OrderBySale4/Event.php line 55

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of OrderBySale4
  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\OrderBySale4;
  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\OrderBySale4\Entity\Config;
  22. use Plugin\OrderBySale4\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.         }
  98.     }
  99. }