EC-CUBE4の商品詳細ページで同じカテゴリの商品一覧を表示する方法

{# 現在の商品が属するカテゴリを取得 #}
{% set categories = Product.ProductCategories %}

{% if categories|length > 0 %}

{# 子カテゴリを基準にする #}
{% set targetCategory = null %}
{% for c in categories %}
{% if targetCategory is null and c.Category.Parent is not null %}
{% set targetCategory = c.Category %}
{% endif %}
{% endfor %}

{# 子カテゴリが見つからない場合は先頭カテゴリを基準にする #}
{% if targetCategory is null %}
{% set targetCategory = categories[0].Category %}
{% endif %}

{# 同カテゴリの商品を取得(自身を除外) #}
{% set RecommendList = repository('Eccube\\Entity\\Product').createQueryBuilder('p')
.innerJoin('p.ProductCategories', 'pc')
.where('pc.Category = :cat')
.andWhere('p.id != :currentId')
.setParameter('cat', targetCategory.id)
.setParameter('currentId', Product.id)
.setMaxResults(5)
.getQuery()
.getResult()
%}

{% if RecommendList|length > 0 %}
<ul>
  {% for Rec in RecommendList %}
  <li>
    <a href="{{ url('product_detail', {'id': Rec.id}) }}">
      <figure class="recommend-img">
        {% if Rec.ProductImage|length > 0 %}
        <img src="{{ asset(Rec.ProductImage[0], 'save_image') }}" alt="{{ Rec.name }}">
        {% else %}
        <img src="{{ asset(''|no_image_product, 'save_image') }}" alt="{{ Rec.name }}">
        {% endif %}
      </figure>
      <h2 class="recommend-name">{{ Rec.name }}</h2>
      <div class="recommend-price-regular">
        {% if Rec.hasProductClass -%}
        {% if Rec.getPrice01Min is not null and Rec.getPrice01IncTaxMin == Rec.getPrice01IncTaxMax %}
        <span>通常価格：{{ Rec.getPrice01IncTaxMin|price }}</span>
        {% elseif Rec.getPrice01Min is not null and Rec.getPrice01Max is not null %}
        <span>通常価格：{{ Rec.getPrice01IncTaxMin|price }} ～ {{ Rec.getPrice01IncTaxMax|price }}</span>
        {% endif %}
        {% else %}
        {% if Rec.getPrice01Max is not null %}
        <span>通常価格：{{ Rec.getPrice01IncTaxMin|price }}</span>
        {% endif %}
        {% endif %}
      </div>
      <div class="recommend-price-sale">
        {% if Rec.hasProductClass -%}
        {% if Rec.getPrice02IncTaxMin == Rec.getPrice02IncTaxMax %}
        <span>販売価格：{{ Rec.getPrice02IncTaxMin|price }}</span>
        {% else %}
        <span>販売価格：{{ Rec.getPrice02IncTaxMin|price }} ～ {{ Rec.getPrice02IncTaxMax|price }}</span>
        {% endif %}
        {% else %}
        <span>販売価格：{{ Rec.getPrice02IncTaxMin|price }}</span>
        {% endif %}
      </div>
    </a>
  </li>
  {% endfor %}
</ul>
{% endif %}
{% endif %}