app/Customize/Controller/TopController.php line 51

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of EC-CUBE
  5.  *
  6.  * Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved.
  7.  *
  8.  * http://www.ec-cube.co.jp/
  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 Customize\Controller;
  16. use Eccube\Controller\AbstractController;
  17. use Eccube\Entity\Category;
  18. use Eccube\Entity\Product;
  19. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  20. use Symfony\Component\Routing\Annotation\Route;
  21. use Customize\Helper\BaseHelper;
  22. use Customize\Entity\Banner;
  23. use Customize\Repository\DisplayContentRepository;
  24. use Eccube\Entity\Master\ProductStatus;
  26. class TopController extends AbstractController
  27. {
  28.     use BaseHelper;
  30.     /**
  31.      * PRODUCTS section on homepage. Order is display order.
  32.      * Missing / unpublished IDs are skipped.
  33.      * TODO: restore /admin/content/display and use DisplayContent::KEY_FEATURED_PRODUCTS
  34.      */
  35.     private const FEATURED_PRODUCT_IDS = [14, 3, 29, 70];
  37.     /**
  38.      * @var DisplayContentRepository
  39.      */
  40.     protected $displayContentRepository;
  42.     public function __construct(DisplayContentRepository $displayContentRepository)
  43.     {
  44.         $this->displayContentRepository = $displayContentRepository;
  45.     }
  47.     /**
  48.      * @Route("/", name="homepage", methods={"GET"})
  49.      * @Template("index.twig")
  50.      */
  51.     public function index()
  52.     {
  53.         if ($this->isGranted('IS_AUTHENTICATED_FULLY')) {
  54.             if ($myPageUrl = (env('MY_PAGE_URL') ?? null)) {
  55.                 $redirectMyPage = $this->generateRedirectMyPage();
  56.                 if ($this->session->get('redirect', null) === $myPageUrl && $this->session->get('has_redirect_mypage', false) === false) {
  57.                     $this->session->set('has_redirect_mypage', true);
  58.                     return $this->redirect($redirectMyPage);
  59.                 }
  60.             }
  61.         }
  63.         // Lấy sản phẩm có category_id 1001 và 1002 lấy 4 sản phẩm
  64.         $categoryId1 = Category::$CATEGORY_TYPE_ROUTER_TERMINAL_ID; // 1001
  65.         $categoryId2 = Category::$CATEGORY_TYPE_GIGABIT_ADDITION_ID; // 1002
  66.         $category1 = $this->entityManager->getRepository(Category::class)->find($categoryId1);
  67.         $category2 = $this->entityManager->getRepository(Category::class)->find($categoryId2);
  69.         $productRepository = $this->entityManager->getRepository(Product::class);
  71.         if ($category1 && $category2) {
  72.             $searchData1 = ['category_id' => $category1];
  73.             $searchData2 = ['category_id' => $category2];
  74.             $qb1 = $productRepository->getQueryBuilderBySearchData($searchData1);
  75.             $products1 = $qb1->getQuery()->setMaxResults(4)->getResult();
  76.             $qb2 = $productRepository->getQueryBuilderBySearchData($searchData2);
  77.             $products2 = $qb2->getQuery()->setMaxResults(4)->getResult();
  78.         }
  80.         // Lấy tất cả các banner đang active status = 1 sắp xếp theo sort_no
  81.         $bannerRepository = $this->entityManager->getRepository(Banner::class);
  82.         $banners = $bannerRepository->getVisibleBanners();
  86.         // 注目の商品: hardcoded IDs (admin display screen is temporarily hidden)
  87.         $topRankingProducts = $this->getProductsByIds($productRepository, self::FEATURED_PRODUCT_IDS);
  89.         return [
  90.             'router_products' => $products1 ?? [],
  91.             'gigabit_products' => $products2 ?? [],
  92.             'top_ranking_products' => $topRankingProducts,
  93.             'banners' => $banners ?? [],
  94.         ];
  95.     }
  97.     /**
  98.      * Load public products by display content key, preserving configured order.
  99.      *
  100.      * @param \Eccube\Repository\ProductRepository $productRepository
  101.      * @param string $configKey
  102.      *
  103.      * @return Product[]
  104.      */
  105.     private function getProductsByDisplayContentKey($productRepository, $configKey)
  106.     {
  107.         return $this->getProductsByIds(
  108.             $productRepository,
  109.             $this->displayContentRepository->getProductIdListByKey($configKey)
  110.         );
  111.     }
  113.     /**
  114.      * Load public products by IDs, preserving order.
  115.      * IDs that do not exist, are unpublished, or have no visible class are skipped.
  116.      *
  117.      * @param \Eccube\Repository\ProductRepository $productRepository
  118.      * @param int[] $ids
  119.      *
  120.      * @return Product[]
  121.      */
  122.     private function getProductsByIds($productRepository, array $ids)
  123.     {
  124.         if (empty($ids)) {
  125.             return [];
  126.         }
  128.         $qb = $productRepository->createQueryBuilder('p')
  129.             ->where('p.id IN (:ids)')
  130.             ->andWhere('p.Status = :status')
  131.             ->setParameter('ids', $ids)
  132.             ->setParameter('status', ProductStatus::DISPLAY_SHOW)
  133.             ->innerJoin('p.ProductClasses', 'pc')
  134.             ->andWhere('pc.visible = :visible')
  135.             ->setParameter('visible', true)
  136.             ->groupBy('p.id');
  138.         $products = $qb->getQuery()->getResult();
  139.         $byId = [];
  140.         foreach ($products as $product) {
  141.             $byId[$product->getId()] = $product;
  142.         }
  144.         $ordered = [];
  145.         foreach ($ids as $id) {
  146.             if (isset($byId[$id])) {
  147.                 $ordered[] = $byId[$id];
  148.             }
  149.         }
  151.         return $ordered;
  152.     }
  153. }