app/Plugin/OrderBySale4/Event.php line 48

Open in your IDE?
  1. <?php
  3. namespace Plugin\OrderBySale4;
  5. use Doctrine\ORM\EntityManagerInterface;
  6. use Doctrine\ORM\QueryBuilder;
  7. use Eccube\Entity\Master\OrderStatus;
  8. use Eccube\Event\EccubeEvents;
  9. use Eccube\Event\EventArgs;
  10. use Plugin\OrderBySale4\Entity\Config;
  11. use Plugin\OrderBySale4\Repository\ConfigRepository;
  12. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  14. class Event implements EventSubscriberInterface
  15. {
  16.     /**
  17.      * @var EntityManagerInterface
  18.      */
  19.     private $entityManager;
  21.     /**
  22.      * @var ConfigRepository
  23.      */
  24.     private $configRepository;
  28.     public function __construct(
  29.         EntityManagerInterface $entityManager,
  30.         ConfigRepository $configRepository
  31.     )
  32.     {
  33.         $this->entityManager = $entityManager;
  34.         $this->configRepository = $configRepository;
  35.     }
  37.     /**
  38.      * @return array
  39.      */
  40.     public static function getSubscribedEvents()
  41.     {
  42.         return [
  43.             EccubeEvents::FRONT_PRODUCT_INDEX_SEARCH => 'onFrontProductIndexSearch',
  44.         ];
  45.     }
  48.     public function onFrontProductIndexSearch(EventArgs $eventArgs)
  49.     {
  50.         /* @var $qb QueryBuilder */
  51.         $qb = $eventArgs->getArgument('qb');
  52.         $searchData = $eventArgs->getArgument('searchData');
  54.         $ProductListOrderBy = $searchData['orderby'];
  56.         if ($ProductListOrderBy) {
  57.             $Config = $this->configRepository->findOneBy([
  58.                 'product_list_order_by_id' => $ProductListOrderBy->getId(),
  59.             ]);
  61.             $excludes = [OrderStatus::CANCEL, OrderStatus::PENDING, OrderStatus::PROCESSING, OrderStatus::RETURNED];
  63.             if ($Config) {
  65.                 if ($Config->getType() == Config::ORDER_BY_AMOUNT) {
  66.                     $qb->addSelect('(SELECT CASE WHEN SUM(oi.price * oi.quantity) IS NULL THEN -1 ELSE SUM(oi.price * oi.quantity) END
  67.                     FROM \Eccube\Entity\OrderItem AS oi 
  68.                     LEFT JOIN oi.Order AS o 
  69.                     WHERE 
  70.                      oi.Product=p.id 
  71.                      AND o.OrderStatus not in (:excludes)
  72.                      ) AS HIDDEN  buy_quantity')
  73.                         ->orderBy('buy_quantity', 'DESC')
  74.                         ->groupBy('p.id')
  75.                         ->setParameter('excludes', $excludes)
  76.                     ;
  77.                 } else if ($Config->getType() == Config::ORDER_BY_QUANTITY) {
  78.                     $qb->addSelect('(SELECT CASE WHEN SUM(oi.quantity) IS NULL THEN -1 ELSE SUM(oi.quantity) END
  79.                     FROM \Eccube\Entity\OrderItem AS oi 
  80.                     LEFT JOIN oi.Order AS o 
  81.                     WHERE 
  82.                      oi.Product=p.id 
  83.                      AND o.OrderStatus not in (:excludes)
  84.                      ) AS HIDDEN buy_quantity')
  85.                         ->orderBy('buy_quantity', 'DESC')
  86.                         ->groupBy('p.id')
  87.                         ->setParameter('excludes', $excludes)
  88.                     ;
  89.                 }
  90.             }
  91.         }
  93.     }
  94. }