app/Customize/Controller/FaqController.php line 111

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of EC-CUBE, Addition by INSPIRATION
  5.  *
  6.  */
  8. namespace Customize\Controller;
  10. use Customize\Repository\CategoriesRepository;
  11. use Customize\Repository\FaqsRepository;
  12. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  13. use Symfony\Component\Routing\Annotation\Route;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use Eccube\Controller\AbstractController;
  17. class FaqController extends AbstractController
  18. {
  19.     /**
  20.      * @var CategoriesRepository
  21.      */
  22.     protected $categoriesRepository;
  24.     /**
  25.      * @var FaqsRepository
  26.      */
  27.     protected $faqsRepository;
  29.     /**
  30.      * FaqController constructor.
  31.      *
  32.      * @param FaqsRepository $faqsRepository
  33.      */
  34.     public function __construct(
  35.         CategoriesRepository $categoriesRepository,
  36.         FaqsRepository $faqsRepository
  37.     )
  38.     {
  39.         $this->categoriesRepository = $categoriesRepository;
  40.         $this->faqsRepository = $faqsRepository;
  41.     }
  43.     /**
  44.      * よくある質問.
  45.      *
  46.      * @Route("/faq", name="faq", methods={"GET"})
  47.      * @Template("Faq/index.twig")
  48.      */
  49.     public function index()
  50.     {
  51.         $qb = $this->categoriesRepository->createQueryBuilder('c')
  52.             ->andWhere('c.del_flg = 0')
  53.             ->andWhere('c.release_flg = 1')
  54.             ->andWhere('c.program_name = :programName')
  55.             ->setParameter(':programName', 'Faq')
  56.             ->orderBy('c.rank');
  58.         $CategoryDatas = $qb->getQuery()->getResult();
  60.         return [
  61.             'CategoryDatas' => $CategoryDatas,
  62.         ];
  63.     }
  65.     /**
  66.      * よくある質問検索結果.
  67.      *
  68.      * @Route("/faq/result", name="faq_result", methods={"GET"})
  69.      * @Template("Faq/result.twig")
  70.      */
  71.     public function result(Request $request)
  72.     {
  73.         $Result = $request->query->get('query');
  75.         return [
  76.             'Result' => $Result,
  77.         ];
  78.     }
  80.     /**
  81.      * よくある質問カテゴリー画面.
  82.      *
  83.      * @Route("/faq/category/{id}", name="faq_category", methods={"GET"}, requirements={"id" = "\d+"})
  84.      * @Template("Faq/category.twig")
  85.      */
  86.     public function category($id)
  87.     {
  88.         $CategoryData = $this->categoriesRepository->findOneBy(['id' => $id]);
  90.         $qb = $this->faqsRepository->createQueryBuilder('f')
  91.             ->andWhere('f.del_flg = 0')
  92.             ->andWhere('f.release_flg = 1')
  93.             ->andWhere('f.category = :findCategory')
  94.             ->setParameter(':findCategory', $id)
  95.             ->orderBy('f.rank');
  97.         $FaqListDatas = $qb->getQuery()->getResult();
  99.         return [
  100.             'CategoryData' => $CategoryData,
  101.             'FaqListDatas' => $FaqListDatas,
  102.         ];
  103.     }
  105.     /**
  106.      * よくある質問詳細画面.
  107.      *
  108.      * @Route("/faq/detail/{id}", name="faq_detail", methods={"GET"}, requirements={"id" = "\d+"})
  109.      * @Template("Faq/detail.twig")
  110.      */
  111.     public function detail($id)
  112.     {
  113.         $FaqData = $this->faqsRepository->findOneBy(['id' => $id]);
  115.         $qb = $this->faqsRepository->createQueryBuilder('f')
  116.             ->andWhere('f.del_flg = 0')
  117.             ->andWhere('f.release_flg = 1')
  118.             ->andWhere('f.category = :findCategory')
  119.             ->andWhere('f.id NOT IN (:excludes)')
  120.             ->setParameter(':findCategory', $FaqData['category'])
  121.             ->setParameter(':excludes', $FaqData['id'])
  122.             ->orderBy('f.rank');
  124.         $RelationDatas = $qb->getQuery()->getResult();
  127.         return [
  128.             'FaqData' => $FaqData,
  129.             'RelationDatas' => $RelationDatas,
  130.         ];
  131.     }
  132. }