src/Eccube/Controller/TopController.php line 25

Open in your IDE?
  1. <?php
  3. namespace Eccube\Controller;
  5. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  6. use Symfony\Component\Routing\Annotation\Route;
  7. use Plugin\ProductReview42\Repository\ProductReviewRepository;
  9. class TopController extends AbstractController
  10. {
  11.     /**
  12.      * @var ProductReviewRepository
  13.      */
  14.     protected $productReviewRepository;
  16.     public function __construct(ProductReviewRepository $productReviewRepository)
  17.     {
  18.         $this->productReviewRepository = $productReviewRepository;
  19.     }
  21.     /**
  22.      * @Route("/", name="homepage", methods={"GET"})
  23.      * @Template("index.twig")
  24.      */
  25.     public function index()
  26.     {
  27.         $qb = $this->productReviewRepository->createQueryBuilder('pr');
  28.         $qb->addSelect('p')
  29.             ->innerJoin('pr.Product', 'p')
  30.             ->where('pr.Status = :Status')
  31.             ->setParameter('Status', 1)
  32.             ->andWhere('pr.reviewer_name NOT LIKE :staff_name')
  33.             ->setParameter('staff_name', '%スタッフ%')
  34.             ->orderBy('pr.create_date', 'DESC')
  35.             ->setMaxResults(20);
  37.         $Reviews = $qb->getQuery()->getResult();
  39.         return [
  40.             'Reviews' => $Reviews,
  41.         ];
  42.     }
  43. }