app/Customize/Controller/TopController.php line 31

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;
  24. class TopController extends AbstractController
  25. {
  26.     use BaseHelper;
  27.     /**
  28.      * @Route("/", name="homepage", methods={"GET"})
  29.      * @Template("index.twig")
  30.      */
  31.     public function index()
  32.     {
  33.         if ($this->isGranted('IS_AUTHENTICATED_FULLY')) {
  34.             if ($myPageUrl = (env('MY_PAGE_URL') ?? null)) {
  35.                 $redirectMyPage = $this->generateRedirectMyPage();
  36.                 if ($this->session->get('redirect', null) === $myPageUrl && $this->session->get('has_redirect_mypage', false) === false) {
  37.                     $this->session->set('has_redirect_mypage', true);
  38.                     return $this->redirect($redirectMyPage);
  39.                 }
  40.             }
  41.         }
  43.         // Lấy sản phẩm có category_id 1001 và 1002 lấy 4 sản phẩm
  44.         $categoryId1 = Category::$CATEGORY_TYPE_ROUTER_TERMINAL_ID; // 1001
  45.         $categoryId2 = Category::$CATEGORY_TYPE_GIGABIT_ADDITION_ID; // 1002
  46.         $category1 = $this->entityManager->getRepository(Category::class)->find($categoryId1);
  47.         $category2 = $this->entityManager->getRepository(Category::class)->find($categoryId2);
  49.         $productRepository = $this->entityManager->getRepository(Product::class);
  51.         if ($category1 && $category2) {
  52.             $searchData1 = ['category_id' => $category1];
  53.             $searchData2 = ['category_id' => $category2];
  54.             $qb1 = $productRepository->getQueryBuilderBySearchData($searchData1);
  55.             $products1 = $qb1->getQuery()->setMaxResults(4)->getResult();
  56.             $qb2 = $productRepository->getQueryBuilderBySearchData($searchData2);
  57.             $products2 = $qb2->getQuery()->setMaxResults(4)->getResult();
  58.         }
  60.         // Lấy tất cả các banner đang active status = 1 sắp xếp theo sort_no
  61.         $bannerRepository = $this->entityManager->getRepository(Banner::class);
  62.         $banners = $bannerRepository->getVisibleBanners();
  66.         // Lấy 5 sản phẩm top ranking
  67.         $qbRanking = $productRepository->createQueryBuilder('p')
  68.             ->where('p.Status = :status')
  69.             ->setParameter('status', 1)
  70.             ->andWhere('p.ranking IS NOT NULL')
  71.             ->innerJoin('p.ProductClasses', 'pc')
  72.             ->andWhere('pc.visible = :visible')
  73.             ->setParameter('visible', true)
  74.             ->groupBy('p.id')
  75.             ->orderBy('p.ranking', 'ASC')
  76.             ->addOrderBy('p.id', 'DESC')
  77.             ->setMaxResults(5);
  79.         $topRankingProducts = $qbRanking->getQuery()->getResult();
  81.         return [
  82.             'router_products' => $products1 ?? [],
  83.             'gigabit_products' => $products2 ?? [],
  84.             'top_ranking_products' => $topRankingProducts,
  85.             'banners' => $banners ?? [],
  86.         ];
  87.     }
  88. }