{% set recommend_products = repository('Plugin\\Recommend4\\Entity\\RecommendProduct').getRecommendProduct %}

<div class="ec-shelfRole">
    <ul class="ec-shelfGrid">
{% for RecommendProduct in recommend_products %}
{% set ProductCategories = repository('Eccube\\Entity\\ProductCategory').findBy({product_id: RecommendProduct.Product.id}) %}
{% set hasCategory = false %}
{% for ProductCategory in ProductCategories %}
{% if ProductCategory.category_id == 7 %}
{% set hasCategory = true %}
    <li class="ec-shelfGrid__item">
                <a href="{{ url('product_detail', {'id': RecommendProduct.Product.id}) }}">
                    <img src="{{ asset(RecommendProduct.Product.mainFileName|no_image_product, "save_image") }}">
                    <p>{{ RecommendProduct.comment|raw|nl2br }}</p>
                    <dl>
                        <dt class="item_name">{{ RecommendProduct.Product.name }}</dt>
                        <dd class="item_price">
                            {% if RecommendProduct.Product.hasProductClass %}
                                {% if RecommendProduct.Product.getPrice02Min == RecommendProduct.Product.getPrice02Max %}
                                    {{ RecommendProduct.Product.getPrice02IncTaxMin|price }}
                                {% else %}
                                    {{ RecommendProduct.Product.getPrice02IncTaxMin|price }} ～ {{ RecommendProduct.Product.getPrice02IncTaxMax|price }}
                                {% endif %}
                            {% else %}
                                {{ RecommendProduct.Product.getPrice02IncTaxMin|price }}
                            {% endif %}
                        </dd>
                    </dl>
                </a>
            </li>
{% endif %}
{% endfor %}
{% endfor %}
</ul>
</div>

{% set ProductCategories = repository('Eccube\\Entity\\ProductCategory').findBy({product_id: RecommendProduct.Product.id},4,0) %}

{% set ProductCategories = repository('Eccube\\Entity\\ProductCategory').findBy({product_id: RecommendProduct.Product.id ,'category_id': 7},{},4,0) %}

/**
     * Get recommend product by display status of product.
     *
     * @return array
     */
    public function getRecommendProduct()
    {
        $query = $this->createQueryBuilder('rp')
            ->innerJoin('Eccube\Entity\Product', 'p', 'WITH', 'p.id = rp.Product')
	　　->innerJoin('Eccube\Entity\ProductCategory', 'c', 'WITH', 'c.product_id = rp.Product')
            ->where('p.Status = :Disp')
            ->andWhere('rp.visible = true')
	　　->andWhere('c.category_id = 2')
            ->orderBy('rp.sort_no', 'DESC')
	　　->setMaxResults(1)
            ->setParameter('Disp', ProductStatus::DISPLAY_SHOW)
            ->getQuery();

        return $query->getResult();
    }