{% extends "layout_report.html" %}
{% load tz %}
{% load humanize %}
{% load app_filters %}
{% block content %}
    {{ block.super }}
    {% regroup txns by receiver.customer as customer_list %}
    {% for customer in customer_list %}
        {% regroup customer.list by receiver.inv_class as inv_class_list %}
        {% for inv_class in inv_class_list %}
            {% regroup inv_class.list by receiver.group as group_list %}
            {% for group in group_list %}
                <div class="row mt-3">
                    <div class="col-3">
                        Inventory Owner: {{ customer.grouper}}
                    </div>
                </div>
                <div class="row">
                    <div class="col-3">
                        Inventory Class: {{ inv_class.grouper }}
                    </div>
                    <div class="col-3">
                        Inventory Group: {{ group.grouper }}
                    </div>
                </div>
                    <div class="row mt-1">
                    <div class="col-1"></div>
                    <div class="col-2"></div>
                    <div class="col-1 text-nowrap"><span class="font-weight-bolder"><u>Cust Item</u></span></div>
                    <div class="col-1"></div>
                    <div class="col-1"><span class="font-weight-bolder"><u>Transaction</u></span></div>
                    <div class="col-2"></div>
                    <div class="col-1"><span class="font-weight-bolder"><u>Produced/</u></span></div>
                    <div class="col-1"></div>
                    <div class="col-1"></div>
                    <div class="col-1"></div>
                </div>
                <div class="row">
                    <div class="col-1"><span class="font-weight-bolder"><u>Receiver</u></span></div>
                    <div class="col-2"><span class="font-weight-bolder"><u>Item</u></span></div>
                    <div class="col-1"><span class="font-weight-bolder"><u>Code</u></span></div>
                    <div class="col-1"><span class="font-weight-bolder"><u>Lot</u></span></div>
                    <div class="col-1"><span class="font-weight-bolder"><u>Date</u></span></div>
                    <div class="col-2"><span class="font-weight-bolder"><u>Reference</u></span></div>
                    <div class="col-1"><span class="font-weight-bolder"><u>Received</u></span></div>
                    <div class="col-1"><span class="font-weight-bolder"><u>Consumed</u></span></div>
                    <div class="col-1"><span class="font-weight-bolder"><u>Shipped</u></span></div>
                    <div class="col-1"><span class="font-weight-bolder"><u>Adjustment</u></span></div>
                </div>
                {% regroup group.list by receiver.item as item_list %}
                {% for item in item_list %}
                    {% for txn in item.list %}
                    <div class="row">
                        <div class="col-1 text-nowrap">{{ txn.receiver }}</div>
                        <div class="col-2 text-nowrap">{{ txn.receiver.item.name }}</div>
                        <div class="col-1">{{ txn.receiver.cust_item_code }}</div>
                        <div class="col-1">{{ txn.receiver.lot }}</div>
                        <div class="col-1">{{ txn.transaction_date }}</div>
                        <div class="col-2">{{ txn.reference }}</div>
                        <div class="col-1 text-right">{{ txn.received | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 text-right">{{ txn.consumed | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 text-right">{{ txn.shipped | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 text-right">{{ txn.adjustment | floatformat:'0' | intcomma }}</div>
                    </div>
                    {% endfor %}
                    <div class="row mb-3">
                        <div class="col-1 text-nowrap"></div>
                        <div class="col-2"></div>
                        <div class="col-1"></div>
                        <div class="col-1"></div>
                        <div class="col-1"></div>
                        <div class="col-2"></div>
                        <div class="col-1 border-top border-dark text-right">{{ item.list | item_total_received | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 border-top border-dark text-right">{{ item.list | item_total_consumed | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 border-top border-dark text-right">{{ item.list | item_total_shipped | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 border-top border-dark text-right">{{ item.list | item_total_adjustment | floatformat:'0' | intcomma }}</div>
                    </div>
                {% endfor %}
                <div class="row" style="page-break-after: always;">
                </div>
                <hr />
            {% endfor %}
        {% endfor %}
    {% endfor %}
    <div class="row mt-3">
        <div class="col-1 text-nowrap"></div>
        <div class="col-2"></div>
        <div class="col-1"></div>
        <div class="col-1"></div>
        <div class="col-1"></div>
        <div class="col-2"></div>
        <div class="col-1 border-top border-dark text-right">{{ txns | item_total_received | floatformat:'0' | intcomma }}</div>
        <div class="col-1 border-top border-dark text-right">{{ txns | item_total_consumed | floatformat:'0' | intcomma }}</div>
        <div class="col-1 border-top border-dark text-right">{{ txns | item_total_shipped | floatformat:'0' | intcomma }}</div>
        <div class="col-1 border-top border-dark text-right">{{ txns | item_total_adjustment | floatformat:'0' | intcomma }}</div>
    </div>
{% endblock content %}