app/Plugin/SalesRankingB4/Controller/SalesRankingController.php line 28

Open in your IDE?
  1. <?php
  3. namespace Plugin\SalesRankingB4\Controller;
  5. use Eccube\Controller\AbstractController;
  6. use Eccube\Repository\OrderItemRepository;
  7. use Eccube\Repository\ProductRepository;
  8. use Eccube\Entity\Master\ProductStatus;
  9. use Eccube\Entity\Master\OrderStatus;
  10. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Plugin\SalesRankingB4\Repository\SalesRankingConfigRepository;
  15. /**
  16.  * Class SalesRankingController.
  17.  */
  18. class SalesRankingController extends AbstractController
  19. {
  20.     /**
  21.      * @Route("/block/sales_ranking_block", name="block_sales_ranking_block")
  22.      * @Template("@SalesRankingB4/Block/sales_ranking_block.twig")
  23.      *
  24.      * @param SalesRankingConfigRepository $configRepository
  25.      *
  26.      * @return array
  27.      */
  28.     public function index(SalesRankingConfigRepository $configRepository)
  29.     {
  30.         $OrderItem = $this->container->get(OrderItemRepository::class);
  31.         $Product = $this->container->get(ProductRepository::class);
  32.         $excludes = [OrderStatus::CANCEL, OrderStatus::PENDING, OrderStatus::PROCESSING, OrderStatus::RETURNED];
  34.         $Config = $configRepository->get();
  36.         $Date = new \DateTime();
  37.         $end = $Date->format("Y-m-d 23:59:59");
  38.         $term = "- " . $Config->getTerm() . " day";
  39.         $start = $Date->modify($term)->format("Y-m-d 00:00:00");
  41.         $query = $OrderItem->createQueryBuilder('oi')
  42.             ->select('SUM(oi.quantity) as total,p.id')
  43.             ->innerJoin('Eccube\Entity\Product', 'p', 'WITH', 'p.id = oi.Product')
  44.             ->innerJoin('Eccube\Entity\Order', 'o', 'WITH', 'oi.Order = o')
  45.             ->where('p.Status = :Disp')
  46.             ->andWhere('o.OrderStatus NOT IN (:excludes)')
  47.             ->andWhere('o.create_date >= :start')
  48.             ->andWhere('o.create_date <= :end')
  49.             ->orderBy('total', 'DESC')
  50.             ->setParameter('Disp', ProductStatus::DISPLAY_SHOW)
  51.             ->setParameter(':excludes', $excludes)
  52.             ->setParameter(':start', $start)
  53.             ->setParameter(':end', $end)
  54.             ->groupBy('p.id')
  55.             ->setMaxResults($Config->getDisplayNum())
  56.             ->getQuery();
  58.         $ranking_products= array();
  59.         $result = $query->getResult();
  61.         foreach ($result as $item) {
  62.             $ranking_products[] = $Product->find($item['id']);
  63.         }
  65.         return [
  66.             'ranking_products' => $ranking_products,
  67.             'display_name_flg' => $Config->getDisplayName(),
  68.             'display_code_flg' => $Config->getDisplayCode(),
  69.             'display_price_flg' => $Config->getDisplayPrice(),
  70.             'display_description_list_flg' => $Config->getDisplayDescriptionList(),
  71.         ];
  72.     }
  73. }