src/Eccube/Controller/TopController.php line 34

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;
  16. use Eccube\Controller\AbstractController;
  17. use Eccube\Repository\ProductRepository;
  18. use Symfony\Component\HttpFoundation\Request;
  19. use Symfony\Component\HttpFoundation\Response;
  20. use Symfony\Component\Routing\Annotation\Route;
  22. class TopController extends AbstractController
  23. {
  24.     private $productRepository;
  26.     public function __construct(ProductRepository $productRepository)
  27.     {
  28.         $this->productRepository = $productRepository;
  29.     }
  31.     /**
  32.      * @Route("/", name="homepage")
  33.      */
  34.     public function index(Request $request): Response
  35.     {
  36.         $searchData = array();
  38.             $qb = $this->entityManager->createQueryBuilder();
  40.             $query = $qb->select("plob")
  42.                 ->from("Eccube\\Entity\\Master\\ProductListOrderBy", "plob")
  44.                 ->where('plob.id = :id')
  46.                 //->setParameter('id', $this->eccubeConfig['eccube_product_order_newer'])
  47.                 ->setParameter('id', 4)
  49.                 ->getQuery();
  51.             $searchData['orderby'] = $query->getOneOrNullResult();
  54.             /*$cat_id = 8;
  56.             $qb = $this->entityManager->createQueryBuilder();
  58.             $query = $qb->select("ctg")
  60.                 ->from("Eccube\\Entity\\Category", "ctg")
  62.                 ->where('ctg.id = :id')
  64.                 ->setParameter('id', $cat_id)
  66.                 ->getQuery();
  68.             $searchData['category_id'] = $query->getOneOrNullResult();*/
  72.             $qb = $this->productRepository->getQueryBuilderBySearchData($searchData);
  74.             $query = $qb->setMaxResults(20)->getQuery();
  76.             $products = $query->getResult();
  77.         return $this->render('index.twig', [
  78.             'Products' => $products,
  79.         ]);
  80.     }
  81. }