app/Customize/Controller/TopController.php line 27

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 Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  17. use Symfony\Component\Routing\Annotation\Route;
  19. use Eccube\Controller\AbstractController;
  21. class TopController extends AbstractController
  22. {
  23.     /**
  24.      * @Route("/", name="homepage", methods={"GET"})
  25.      * @Template("index.twig")
  26.      */
  27.     public function index()
  28.     {
  29.         $ProductRepository = $this->entityManager->getRepository(\Eccube\Entity\Product::class);
  30.         
  31.         $qb = $ProductRepository->createQueryBuilder('p')
  32.             ->where('p.Status = 1')
  33.             ->orderBy('p.update_date', 'DESC')
  34.             ->setMaxResults(4);
  35.         $Products = $qb->getQuery()->getResult();
  37.         $BlogRepository = $this->entityManager->getRepository(\Plugin\CMBlogPro42\Entity\Blog::class);
  38.         $qb = $BlogRepository->createQueryBuilder('b')
  39.             ->where('b.Status = 1')
  40.             ->orderBy('b.update_date', 'DESC')
  41.             ->setMaxResults(3);
  42.         $Blogs = $qb->getQuery()->getResult();
  44.         return [
  45.             'topProducts' => $Products,
  46.             'topBlogs' => $Blogs,
  47.         ];
  48.     }
  49. }