{% extends "base.html.twig" %}

{% block title %}Products{% endblock %}

{% block body %}
    Check out these great products:
    <table>
        <thead>
            <tr>
                <th>Id</th>
                <th>Name</th>
                <th>Price</th>
                <th>Raise price</th>
                <th>Delete</th>
            </tr>
        </thead>
        <tbody>
            {% for product in products %}
                {% set idAttr = {'id': product.id} %}
                {% set productLink = path('product_show', idAttr) %}
            <tr>
                <td><a href="{{ productLink }}">{{ product.id }}</a></td>
                <td><a href="{{ productLink }}">{{ product.name }}</a></td>
                <td>{{ "%10.2f"|format(product.price) }}</td>
                <td class="op"><a href="{{ path('product_raise', idAttr) }}">+</a></td>
                <td class="op"><a href="{{ path('product_delete', idAttr) }}">X</a></td>
            </tr>
            {% endfor %}
        </tbody>
    </table>

<h3>Lists comparison</h3>
<ul>
    <li>DQL === QueryBuilder ? {{ dql_qb ? "Y" : "N" }}</li>
    <li>DQL == SQL ? {{  dql_sql ? "Y" : "N" }}</li>
</ul>
{% endblock %}