app/Customize/Controller/CustomizeTopController.php line 43

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\Repository\ProductRepository;
  20. use Plugin\RecentlyViewedProducts\Service\RecentlyViewedProductService;
  21. use Eccube\Controller\TopController as BaseController;
  23. class CustomizeTopController extends BaseController
  24. {
  25.     /**
  26.      * @var RecentlyViewedProductService
  27.      */
  28.     protected $recentlyViewedProductService;
  30.     /**
  31.      * RecentlyViewedProductController constructor.
  32.      */
  33.     public function __construct(RecentlyViewedProductService $recentlyViewedProductService)
  34.     {
  35.         $this->recentlyViewedProductService = $recentlyViewedProductService;
  36.     }
  39.     /**
  40.      * @Route("/books", name="books", methods={"GET"})
  41.      * @Template("@user_data/books.twig")
  42.      */
  43.     public function index()
  44.     {
  45.         $productRepository = $this->getDoctrine()->getRepository(\Eccube\Entity\Product::class);
  46.         // ProductにTagもJOINして取得する
  47.         $qb = $productRepository->createQueryBuilder('p')
  48.             ->leftJoin('p.ProductTag', 'pt')
  49.             ->leftJoin('pt.Tag', 't')
  50.             ->leftJoin('p.ProductCategories', 'pc')
  51.             ->leftJoin('pc.Category', 'c')         
  52.             ->addSelect('pt')
  53.             ->addSelect('t')
  54.             ->addSelect('pc')                        
  55.             ->addSelect('c')                         
  56.             ->where('p.Status = 1')
  57.             ->orderBy('p.id', 'DESC');
  59.         $Products = $qb->getQuery()->getResult();
  61.         $RecentlyViewedProducts = array_map(function($RecentlyViewedProduct) {
  62.             return $RecentlyViewedProduct->getProduct();
  63.         }, $this->recentlyViewedProductService->getRecentlyViewedProducts());
  67.         $recommendProducts = [];
  69.         if($this->getUser()){
  70.         $Customer = $this->getUser();
  72.         $recentlyViewedProductRepository = $this->getDoctrine()->getRepository(\Plugin\RecentlyViewedProducts\Entity\RecentlyViewedProduct::class);
  74.         $histories = $recentlyViewedProductRepository->findBy(
  75.           ['Customer' => $Customer->getId()],
  76.           ['viewed_date' => 'DESC'],
  77.           30
  78.         );
  80.       // 履歴のproduct_id一覧を作成
  81.       $viewedProductIds = array_map(function($history) {
  82.           return $history->getProduct()->getId();
  83.       }, $histories);
  87.       $historyKeywords = [];
  88.       foreach ($histories as $history) {
  89.           $product = $history->getProduct();
  90.           if (!$product) continue;
  91.       
  92.           // 検索ワード
  93.           if ($product->getSearchWord()) {
  94.               $words = array_map('trim', explode(',', $product->getSearchWord()));
  95.               $historyKeywords = array_merge($historyKeywords, $words);
  96.           }
  97.           // 著者
  98.           if ($product->getAuthor()) {
  99.               $historyKeywords[] = $product->getAuthor();
  100.           }
  101.       }
  103.       // ユーザーの所属県
  104.       if ($Customer->getPref()) {
  105.           $historyKeywords[] = $Customer->getPref()->getName();
  106.       }
  108.       // 特徴キーワードをユニークにする
  109.       $historyKeywords = array_unique($historyKeywords);
  111.       // 全商品を取得
  112.       $allProducts = $productRepository->findAll();
  114.       // 各商品のスコアを計算
  115.       $productScores = [];
  116.       foreach ($allProducts as $product) {
  117.           $keywords = [];
  118.       
  119.           // 検索ワード
  120.           if ($product->getSearchWord()) {
  121.               $words = array_map('trim', explode(',', $product->getSearchWord()));
  122.               $keywords = array_merge($keywords, $words);
  123.           }
  124.       
  125.           // 著者
  126.           if ($product->getAuthor()) {
  127.               $keywords[] = $product->getAuthor();
  128.           }
  129.       
  130.           // ここでは商品自体に「県」はないのでスキップ
  131.       
  132.           $keywords = array_unique($keywords);
  133.       
  134.           // 閲覧履歴の特徴キーワードと比較して一致数をカウント
  135.           $commonCount = count(array_intersect($historyKeywords, $keywords));
  136.       
  137.           // スコアが高いものだけ残す（ここでは0でも一応保持）
  138.           $productScores[] = [
  139.               'product' => $product,
  140.               'score' => $commonCount,
  141.           ];
  142.       }
  144.       // スコア順にソート（スコア高い順）
  145.       usort($productScores, function($a, $b) {
  146.           return $b['score'] <=> $a['score'];
  147.       });
  148.       
  149.       // Twigに渡す用のおすすめ商品リスト作成
  150.       $recommendProducts = array_map(function($item) {
  151.           return $item['product'];
  152.       }, array_slice($productScores, 0, 30)); // 例：おすすめ30件
  153. }
  156.         // Twigへ渡す
  157.         return [
  158.             'Products' => $Products,
  159.             'recommendProducts' => $recommendProducts,
  160.             'RecentlyViewedProducts' => $RecentlyViewedProducts,
  161.         ];
  162.     }
  163. }