{% 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-2"></div>
                    <div class="col-1"></div>
                    <div class="col-1"></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 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-2"><span class="font-weight-bolder"><u>Cust Item 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>Open</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 class="col-1"><span class="font-weight-bolder"><u>End</u></span></div>
                </div>
                {% regroup group.list by receiver.item as item_list %}
                {% for item in item_list %}
                    {% for txn in item.list %}
                    {% if  txn.open_balance != 0 or txn.received_tot != 0 or txn.consumed_tot != 0 or txn.shipped_tot != 0 or txn.adjustment_tot != 0  or txn.end_balance != 0 %}
                    <div class="row">
                        <div class="col-1 text-nowrap">{{ txn.receiver }}</div>
                        <div class="col-2">{{ txn.receiver.item.name }}</div>
                        <div class="col-2">{{ txn.receiver.cust_item_code }}</div>
                        <div class="col-1">{{ txn.receiver.lot }}</div>
                        <div class="col-1 text-right">{{ txn.open_balance | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 text-right">{{ txn.received_tot | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 text-right">{{ txn.consumed_tot | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 text-right">{{ txn.shipped_tot | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 text-right">{{ txn.adjustment_tot | floatformat:'0' | intcomma }}</div>
                        <div class="col-1 text-right">{{ txn.end_balance | floatformat:'0' | intcomma }}</div>
                    </div>
                    {% endif %}
                    {% endfor %}
                    <div class="row small mt-3"></div>
                {% endfor %}
                <div class="row" style="page-break-after: always;">
                    <div class="col-1 text-nowrap"></div>
                    <div class="col-2"></div>
                    <div class="col-2"></div>
                    <div class="col-1"></div>
                    <div class="col-1 border-top border-dark text-right">{{ group.list | running_total_open | floatformat:'0' | intcomma }}</div>
                    <div class="col-1 border-top border-dark text-right">{{ group.list.0.received_tot_block | floatformat:'0' | intcomma }}</div>
                    <div class="col-1 border-top border-dark text-right">{{ group.list.0.consumed_tot_block | floatformat:'0' | intcomma }}</div>
                    <div class="col-1 border-top border-dark text-right">{{ group.list.0.shipped_tot_block | floatformat:'0' | intcomma }}</div>
                    <div class="col-1 border-top border-dark text-right">{{ group.list.0.adjustment_tot_block | floatformat:'0' | intcomma }}</div>
                    <div class="col-1 border-top border-dark text-right">{{ group.list | running_total_end | floatformat:'0' | intcomma }}</div>
                </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-2"></div>
        <div class="col-1"></div>
        <div class="col-1 border-top border-dark text-right">{{ txns | report_total_open | floatformat:'0' | intcomma }}</div>
        <div class="col-1 border-top border-dark text-right">{{ txns | report_total_received | floatformat:'0' | intcomma }}</div>
        <div class="col-1 border-top border-dark text-right">{{ txns | report_total_consumed | floatformat:'0' | intcomma }}</div>
        <div class="col-1 border-top border-dark text-right">{{ txns | report_total_shipped | floatformat:'0' | intcomma }}</div>
        <div class="col-1 border-top border-dark text-right">{{ txns | report_total_adjustment | floatformat:'0' | intcomma }}</div>
        <div class="col-1 border-top border-dark text-right">{{ txns | report_total_end | floatformat:'0' | intcomma }}</div>
    </div>
{% endblock content %}