{% include "macros/style.html.twig" %}

{% set channel = lote.channel %}
{% include "macros/header.html.twig" %}

<table class="w100 my10">
    <tbody>
        <tr>
            <td class="fs15 upper tc" style="border-bottom: 2px solid #000;">Resumo de utilização</td>
            <td class="bgray tr" style="border-bottom: 2px solid #000;">
                Lote(s): <span class="fs20">
                {% for l in lotes %}
                {{ l.code~' ' }}
                {% endfor %}
                </span>
                <br>Data: <span class="fs20">{{ lote.createdAt | date('d/m/Y') }}</span>
            </td>
        </tr>
    </tbody>
</table>

<table class="w100 bgray">
    <tbody>
        <tr>
            <td>Forncedor:</td>
            <td class="fs14 fw">{{ lote.parceiro.nome }}</td>
        </tr>
    </tbody>
</table>

<style>
th {
    text-align: left;
    border-bottom: 1px solid #000;
    font-size: 11px;
}
table.borda td {
    padding: 0 5px 0 0;
    border-bottom: 1px solid #ccc;
    font-size: 11px;
}
</style>

{% for loteI in lotes %}
{% set total = 0 %}
{% set totalcompra = 0 %}
{% set totalvenda = 0 %}
{#{ dump(lote) }#}
<table class="w100 borda my10">
    <thead>
        <tr>
            <th>Un</th>
            <th>Produto</th>
            <th>Pedido</th>
            <th>CFOP</th>
            <th>Data</th>
            <th>Cliente</th>
            <th>Comp</th>
            <th>Vend</th>
            <th>Tot comp</th>
            <th>Tot vend</th>
            <th class="tr">Usado</th>
        </tr>
    </thead>
    <tbody>
        {% for p in loteI.orderitems %}
        {% if p.order.state == 'fulfilled' %}
        {#{ dump(p.unitPrice) }#}
        <tr>
            <td>Kg</td>
            <td>{{ loteI.variant.name }}</td>
            <td>{{ p.order.number }}</td>
            <td>{{ p.order.cfop }}</td>
            <td>{{ p.order.orderDate|date('d/m/Y') }}</td>
            <td>{{ p.order.cliente.nome|default('<CONSUMIDOR>') }}</td>
            <td class="tr">{{ (loteI.price/100)|number_format(2,',','.') }}</td>
            <td class="tr">{{ (p.unitPrice/100)|number_format(2,',','.') }}</td>
            <td class="tr">{{ (loteI.price*p.quantity/100)|number_format(2,',','.') }}</td>
            <td class="tr">{{ (p.unitPrice*p.quantity/100)|number_format(2,',','.') }}</td>
            <td class="tr fs20">{{ p.quantity }}</td>
        </tr>
        {% set total = total + p.quantity %}
        {% set totalcompra = totalcompra + p.quantity*loteI.price %}
        {% set totalvenda = totalvenda + p.quantity*p.unitPrice %}
        {% endif %}
        {% endfor %}
    </tbody>
    <tfooter>
        <tr>
            <td colspan="8" class="tr" style="border: 0;">
                <table class="w100">
                <tbody>
                    <tr>
                        <td>Quantidade total:</td>
                        <td class="fs30 fw">{{ loteI.onhand }}</td>
                        <td>Quantidade usada:</td>
                        <td class="fs30 fw">{{ total }}</td>
                        <td>Saldo:</td>
                        <td class="fs30 fw">{{ loteI.onhand-total }}</td>
                    </tr>
                    <tr>
                        <td>Total de compra:</td>
                        <td class="fs30 fw">R$ {{ (totalcompra/100)|number_format(2,',','.') }}</td>
                        <td>Total de venda:</td>
                        <td class="fs30 fw">R$ {{ (totalvenda/100)|number_format(2,',','.') }}</td>
                        <td>Saldo:</td>
                        <td class="fs30 fw">R$ {{ ((totalvenda-totalcompra)/100)|number_format(2,',','.') }}</td>
                    </tr>
                </tbody>
                </table>
            </td>
            <td class="tr" style="padding: 10px; border: 0;">Total</td>
            <td class="fw tr" style="border: 0; font-size:30px;">{{ total }}</td>
        </tr>
    </tfooter>
</table>
{% endfor %}