app/Customize/Controller/Review/CustomizeReviewController.php line 135

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.  */
  13. namespace Customize\Controller\Review;
  15. use Eccube\Controller\AbstractController;
  16. use Eccube\Controller\Mypage\MypageController;
  17. use Eccube\Entity\BaseInfo;
  18. use Eccube\Entity\Customer;
  19. use Eccube\Entity\Product;
  20. use Eccube\Entity\Order;
  21. use Eccube\Event\EccubeEvents;
  22. use Eccube\Event\EventArgs;
  23. use Eccube\Exception\CartException;
  24. use Eccube\Form\Type\Front\CustomerLoginType;
  25. use Eccube\Repository\BaseInfoRepository;
  26. use Eccube\Repository\CustomerFavoriteProductRepository;
  27. use Eccube\Repository\OrderRepository;
  28. use Eccube\Repository\ProductRepository;
  29. use Eccube\Service\CartService;
  30. use Eccube\Service\PurchaseFlow\PurchaseContext;
  31. use Eccube\Service\PurchaseFlow\PurchaseFlow;
  32. use Knp\Component\Pager\Paginator;
  33. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  34. use Symfony\Component\HttpFoundation\Request;
  35. use Symfony\Component\HttpKernel\Exception\BadRequestHttpException;
  36. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  37. use Symfony\Component\Routing\Annotation\Route;
  38. use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
  39. use Doctrine\ORM\Query\ResultSetMapping;
  41. use Eccube\Entity\Master\ProductStatus;
  42. use Eccube\Form\Type\AddCartType;
  43. use Eccube\Form\Type\Master\ProductListMaxType;
  44. use Eccube\Form\Type\Master\ProductListOrderByType;
  45. use Eccube\Form\Type\SearchProductType;
  46. use Eccube\Repository\Master\ProductListMaxRepository;
  47. use Knp\Bundle\PaginatorBundle\Pagination\SlidingPagination;
  48. use Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter;
  49. use Plugin\ProductReview4\Repository\ProductReviewRepository;
  52. class CustomizeReviewController extends AbstractController
  53. {
  55.     /**
  56.      * @var PurchaseFlow
  57.      */
  58.     protected $purchaseFlow;
  60.     /**
  61.      * @var CustomerFavoriteProductRepository
  62.      */
  63.     protected $customerFavoriteProductRepository;
  65.     /**
  66.      * @var CartService
  67.      */
  68.     protected $cartService;
  70.     /**
  71.      * @var ProductRepository
  72.      */
  73.     protected $productRepository;
  75.     /**
  76.      * @var BaseInfo
  77.      */
  78.     protected $BaseInfo;
  80.     /**
  81.      * @var AuthenticationUtils
  82.      */
  83.     protected $helper;
  85.     /**
  86.      * @var ProductListMaxRepository
  87.      */
  88.     protected $productListMaxRepository;
  90.     private $title = '';
  92.     /**
  93.      * @var ProductReviewRepository
  94.      */
  95.     protected $productReviewRepository;
  97.     /**
  98.      * ProductController constructor.
  99.      *
  100.      * @param PurchaseFlow $cartPurchaseFlow
  101.      * @param CustomerFavoriteProductRepository $customerFavoriteProductRepository
  102.      * @param CartService $cartService
  103.      * @param ProductRepository $productRepository
  104.      * @param BaseInfoRepository $baseInfoRepository
  105.      * @param AuthenticationUtils $helper
  106.      * @param ProductListMaxRepository $productListMaxRepository
  107.      * @param ProductReviewRepository $productReviewRepository
  108.      */
  109.     public function __construct(
  110.         PurchaseFlow $cartPurchaseFlow,
  111.         CustomerFavoriteProductRepository $customerFavoriteProductRepository,
  112.         CartService $cartService,
  113.         ProductRepository $productRepository,
  114.         BaseInfoRepository $baseInfoRepository,
  115.         AuthenticationUtils $helper,
  116.         ProductListMaxRepository $productListMaxRepository,
  117.         ProductReviewRepository $productReviewRepository
  118.     ) {
  119.         $this->purchaseFlow = $cartPurchaseFlow;
  120.         $this->customerFavoriteProductRepository = $customerFavoriteProductRepository;
  121.         $this->cartService = $cartService;
  122.         $this->productRepository = $productRepository;
  123.         $this->BaseInfo = $baseInfoRepository->get();
  124.         $this->helper = $helper;
  125.         $this->productListMaxRepository = $productListMaxRepository;
  126.         $this->productReviewRepository = $productReviewRepository;
  127.     }
  129.     /**
  130.      * レビュー図一覧
  131.      *
  132.      * @Route("/review_list", name="review_list")
  133.      * @Template("Review/index.twig")
  134.      */
  135.     public function index(Request $request, Paginator $paginator)
  136.     {
  138.         // Page指定
  139.         $currentPage = 1;
  140.         if (isset($_GET['pageno'])) {
  141.             $currentPage = $_GET['pageno'];
  142.         }
  143.         $limitPerPage = 10;
  144.         $offset = ($currentPage - 1) * $limitPerPage;
  145.         
  146.         $options = [];
  147.         
  149.         $qb = $this->entityManager->createQueryBuilder();
  150.         $qb->select('a')->from('Plugin\ProductReview4\Entity\ProductReview','a');
  152.         $orderby_name = "新着順";
  153.         $orderby  = 1;
  154.         if(isset($_GET["orderby"])){
  155.             $orderby = $_GET["orderby"];
  156.             if($orderby == 1){
  157.                 $qb->orderBy('a.id','desc');
  158.                 $orderby_name = "新着順";
  159.             }elseif($orderby == 2){
  160.                 $qb->orderBy('a.recommend_level','desc');
  161.                 $qb->addorderBy('a.id','desc');
  162.                 $orderby_name = "評価の高い順";
  163.             }elseif($orderby == 3){
  164.                 $qb->orderBy('a.recommend_level','asc');
  165.                 $qb->addorderBy('a.id','desc');                
  166.                 $orderby_name = "評価の低い順";
  167.             }elseif($orderby == 4){
  168.                 $qb->orderBy('a.ref_count','desc');
  169.                 $qb->addorderBy('a.id','desc');                
  170.                 $orderby_name = "参考になったの多い順";
  171.             }
  172.         }else{
  173.             $qb->orderBy('a.id','desc');
  174.         }
  175.         $qb->where('a.Status = 1');
  177.         $where = false;
  178.         $category_name = "絞り込み";
  179.         $category_id = "";
  180.         if(isset($_GET["category_id"]) && $_GET["category_id"]){
  181.             $category_id = $_GET["category_id"];
  182.             $qb->join('Eccube\Entity\Product', 'p', \Doctrine\ORM\Query\Expr\Join::WITH, 'a.Product = p.id');
  183.             $qb->join('Eccube\Entity\ProductCategory', 'pc', \Doctrine\ORM\Query\Expr\Join::WITH, 'pc.product_id = p.id');
  184.             //$qb->join('Eccube\Entity\Category', 'c', \Doctrine\ORM\Query\Expr\Join::WITH, 'pc.category_id = c.id');
  185.             $qb->andWhere('pc.category_id = :category_id')->setParameter('category_id',$category_id);
  187.             $cate = $this->entityManager->getRepository('Eccube\Entity\Category')->findOneBy(['id'=>$category_id]);
  188.             $category_name = $cate->getName();
  189.             $where = true;
  190.         }
  192.         $categories = $this->entityManager->getRepository('Eccube\Entity\Category')->findBy(["id"=>[7,18,8,12,17,11,9,19,20,21,10,22]]);
  193.         $category_map = [];
  194.         foreach($categories as $cate){
  195.             $category_map[] = $cate->getId();
  196.         }
  198.         $keyword = "";
  199.         if(isset($_GET["keyword"]) && $_GET["keyword"]){
  200.             $keyword = $_GET["keyword"];
  201.             if($where){
  202.                 $qb->andwhere('(a.title like :keyword or a.comment like :keyword or p.name like :keyword)')->setParameter('keyword' , '%'.$keyword.'%');
  203.             }else{
  204.                 $qb->join('Eccube\Entity\Product', 'p', \Doctrine\ORM\Query\Expr\Join::WITH, 'a.Product = p.id');
  205.                 $qb->andWhere('(a.title like :keyword or a.comment like :keyword or p.name like :keyword)')->setParameter('keyword' , '%'.$keyword.'%');
  206.             }
  207.         }
  209.         
  210.         //echo $qb->getDql();
  211.         //exit;
  213.         $data = $qb->getQuery();//->select('a')
  214.                 //->select('p.name')
  215.                 //->from('Plugin\ProductReview4\Entity\ProductReview','a')
  216.                 //->join(sprintf('(%s)', $sub_qb->getDql()), 'b',\Doctrine\ORM\Query\Expr\Join::WITH, 'b.product_id = a.product_id')
  217.                 //->join('Eccube\Entity\Product', 'p', \Doctrine\ORM\Query\Expr\Join::WITH, 'a.product_id = p.id')
  218.                 //->getQuery();
  219.                 //;
  221.         $pagination = $paginator->paginate($data, $currentPage, $limitPerPage, $options);
  222.         //var_dump($pagination);
  223.         //$ids = [];
  224.         //$ProductList = array();
  225.         
  227.         
  228.         $ReviewAveList = array();
  229.         $ReviewCntList = array();
  230.         foreach ($pagination as $Review) {
  231.         //    foreach($Reviews as $Review){
  232.                 $Product = $Review->getProduct();//getProduct();
  233.                 $ids[] = $Product->getId();
  234.                 $rate = $this->entityManager->getRepository('Plugin\ProductReview4\Entity\ProductReview')->getAvgAll($Product);
  235.                 $ReviewAveList[$Product->getId()] = round($rate['recommend_avg']);
  236.                 $ReviewCntList[$Product->getId()] = intval($rate['review_count']);
  238.         //    }
  239.         }
  241.         $user_id = "";
  242.         $Customer = $this->getUser();
  243.         if($Customer){
  244.             $user_id = $Customer->getId();
  245.         }
  247.         return [
  248.         //    'subtitle' => $this->getPageTitle($searchData),
  249.             'pagination' => $pagination,
  250.         //    'search_form' => $searchForm->createView(),
  251.         //    'disp_number_form' => $dispNumberForm->createView(),
  252.         //    'order_by_form' => $orderByForm->createView(),
  253.         //    'forms' => $forms,
  254.         //    'Category' => $Category,
  255.             'categories' => $categories,
  256.             'ReviewAveList' => $ReviewAveList,
  257.             'ReviewCntList' => $ReviewCntList,
  258.             'orderby_name' => $orderby_name,
  259.             "keyword" => $keyword,
  260.             "category_id"=>$category_id,
  261.             "category_name"=>$category_name,
  262.             "orderby"=>$orderby,
  263.             "category_map"=>$category_map,
  264.             "user_id" => $user_id,
  265.         //    "ProductReviews" => $ProductReviews,
  266.         ];
  267.     }
  271.     /**
  272.      *
  273.      * @Route("/mypage/myreview_list", name="mypage_myreview_list")
  274.      * @Template("Mypage/review-list.twig")
  275.      */
  276.     public function mypage_myreview_list(Request $request, Paginator $paginator)
  277.     {
  279.         $Customer = $this->getUser();
  280.         if($Customer == null){
  282.         }
  283.         $review_id = 0;
  284.         if(isset($_GET["id"])){
  285.             $review_id = $_GET["id"];
  286.         }
  288.  // Page指定
  289.         $currentPage = 1;
  290.         if (isset($_GET['pageno'])) {
  291.             $currentPage = $_GET['pageno'];
  292.         }
  293.         $limitPerPage = 10;
  294.         //$offset = ($currentPage - 1) * $limitPerPage;
  295.         
  296.         $options = [];
  297.         
  299.         //$qb = $this->entityManager->createQueryBuilder();
  300.         $qb = $this->productReviewRepository->createQueryBuilder('r');
  302.         //$qb->select('a')->from('Plugin\ProductReview4\Entity\ProductReview','a');
  303.         $qb->orderBy('r.id','desc');
  304.         
  305.         $qb->where('r.Status = 1');
  306.         $qb->andWhere('r.Customer = :customer_id')
  307.             ->setParameter('customer_id', $Customer->getId())
  308.             ->andWhere('r.OrderItem > 0')
  309.             ;
  310.         if($review_id){
  311.             $qb->andWhere('r.id = :id')->setParameter('id', $review_id);
  312.         }
  314.         $data = $qb->getQuery();//->select('a')
  316.         //var_dump($data->getSql());
  317.         //exit;
  319.                 //->select('p.name')
  320.                 //->from('Plugin\ProductReview4\Entity\ProductReview','a')
  321.                 //->join(sprintf('(%s)', $sub_qb->getDql()), 'b',\Doctrine\ORM\Query\Expr\Join::WITH, 'b.product_id = a.product_id')
  322.                 //->join('Eccube\Entity\Product', 'p', \Doctrine\ORM\Query\Expr\Join::WITH, 'a.product_id = p.id')
  323.                 //->getQuery();
  324.                 //;
  326.         $pagination = $paginator->paginate($data, $currentPage, $limitPerPage, $options);
  327.         //var_dump($pagination);
  328.         //$ids = [];
  329.         //$ProductList = array();
  331.         return [
  332.         //    'subtitle' => $this->getPageTitle($searchData),
  333.             'pagination' => $pagination,
  334.             'review_id' => $review_id,
  335.         //    'search_form' => $searchForm->createView(),
  336.         //    'disp_number_form' => $dispNumberForm->createView(),
  337.         //    'order_by_form' => $orderByForm->createView(),
  338.         //    'forms' => $forms,
  339.         //    'Category' => $Category,
  340.         //    'categories' => $categories,
  341.         //    'ReviewAveList' => $ReviewAveList,
  342.         //    'ReviewCntList' => $ReviewCntList,
  343.         //    'orderby_name' => $orderby_name,
  344.         //    "keyword" => $keyword,
  345.         //    "category_id"=>$category_id,
  346.         //    "category_name"=>$category_name,
  347.         //    "orderby"=>$orderby,
  348.         //    "category_map"=>$category_map,
  349.         //    "user_id" => $user_id,
  350.         //    "ProductReviews" => $ProductReviews,
  351.         ];        
  352.     }
  354.     /**
  355.      * レビュー
  356.      *
  357.      * @Route("/review_list/addref", name="review_list_addref")
  358.      */
  359.     public function addref(Request $request)
  360.     {
  361.     
  362.         $Customer = $this->getUser();
  363.         if($Customer == null){
  364.             $msg = [];
  365.             $msg["err"] = 1;
  366.             $this->json($msg, 200);
  367.         }
  369.         $user_id = $Customer->getId();
  370.         $rid = $_GET["rid"];
  372.         $Review = $this->entityManager->getRepository('Plugin\ProductReview4\Entity\ProductReview')->findOneBy(['id'=>$rid]);
  373.         $Review->setRefCount($Review->getRefCount() + 1);
  374.         $ref_users = $Review->getRefUsers();
  375.         if(!in_array($user_id, $ref_users)){
  376.             $ref_users[] = $user_id;
  377.             $Review->setRefUsers($ref_users);
  378.         }
  379.         $this->entityManager->persist($Review);
  380.         $this->entityManager->flush();
  383.         $msg = [];
  384.         $msg["err"] = 0;
  385.         $msg["success"] = 1;
  386.         $msg["user_id"] = $user_id;
  387.         $msg["rid"] = $rid;
  388.         $msg["ref_count"] = $Review->getRefCount();
  389.         return $this->json($msg, 200);
  390.     }
  393.     /**
  394.      *  Login
  395.      *
  396.      *  @Route("/mypage/review_list", name="mypage_review_list")
  397.      *  @throws \Exception
  398.      *
  399.      */
  400.     public function login(){
  401.         
  402.         $Customer = $this->getUser();
  403.         if (empty($Customer)) {
  404.             throw new BadRequestHttpException();
  405.         }
  407.         return $this->redirectToRoute('review_list');
  408.     }
  410.     /**
  411.      *  Login
  412.      *
  413.      *  @Route("/mypage/product_review/{id}", name="mypage_product_review")
  414.      *  @param Request $request
  415.      *  @param Product $Product
  416.      *  @throws \Exception
  417.      *
  418.      */
  419.     public function product_login(Request $request, Product $Product){
  420.         
  421.         $Customer = $this->getUser();
  422.         if (empty($Customer)) {
  423.             throw new BadRequestHttpException();
  424.         }
  426.         return $this->redirectToRoute('product_review',$Product->getId());
  427.     }
  429. }