src/Eccube/Controller/TopController.php line 23

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 Eccube\Controller;
  17. use Eccube\Repository\CustomCategoryRepository;
  18. use Eccube\Repository\ProductRepository;
  19. use Symfony\Component\HttpFoundation\Request;
  20. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  21. use Symfony\Component\Routing\Annotation\Route;
  23. class TopController extends AbstractController
  24. {
  26.     /**
  27.      * @var ProductRepository
  28.      */
  29.     protected $productRepository;
  31.     public function __construct(ProductRepository $productRepository)
  32.     {
  33.         $this->productRepository = $productRepository;
  34.     }
  37.     /**
  38.      * @Route("/", name="homepage", methods={"GET"})
  39.      * @Template("index.twig")
  40.      */
  41.     public function index(Request $request, CustomCategoryRepository $categoryRepository)
  42.     {
  43.         // 商品カテゴリ一覧を取得
  44.         $parentCategoryId = 7; //商品カテゴリの親ID
  45.         $childCategories = $categoryRepository->getChildCategoriesByParentId($parentCategoryId);
  46.         $categories = $categoryRepository->getList();
  48.         //ピックアップタグがついた商品を取得
  49.         $productRepository = $this->getDoctrine()->getRepository('Eccube\Entity\Product');
  50.         $pickup_tag_id = 5; //ピックアップタグのID
  51.         $pickup_products = $productRepository->findByTagWithLimit($pickup_tag_id, 4);
  53.         //ランキングを表示
  54.         $parentCategoryId = 51; // 親カテゴリのIDを指定します。
  55.         $parentCategory = $this->getDoctrine()->getRepository('Eccube\Entity\Category')->find($parentCategoryId);
  57.         // 子カテゴリを昇順で取得
  58.         $subCategories = $parentCategory->getChildren()->toArray();
  59.         usort($subCategories, function ($a, $b) {
  60.             return $a->getSortNo() <=> $b->getSortNo();
  61.         });
  63.         // 各子カテゴリに属する商品を取得
  64.         $productsBySubcategory = [];
  65.         foreach ($subCategories as $subcategory) {
  66.             $queryBuilder = $this->productRepository->createQueryBuilder('p');
  67.             $queryBuilder
  68.                 ->innerJoin('p.ProductCategories', 'pc')
  69.                 ->where('pc.Category = :Category')
  70.                 ->setParameter('Category', $subcategory);
  71.             $products = $queryBuilder->getQuery()->getResult();
  72.             $productsBySubcategory[$subcategory->getId()] = $products;
  73.         }
  75.         return $this->render('index.twig', [
  76.             'childCategories' => $childCategories,
  77.             'categories' => $categories,
  78.             //ピックアップ商品
  79.             'pickup_products' => $pickup_products,
  80.             //ランキング一覧
  81.             'products_by_subcategory' => $productsBySubcategory,
  82.         ]);
  83.     }
  85. }