{% extends "layout_report.html" %}
{% load static %}
{% load app_filters %}
{% load humanize %}
{% load tz %}
{% block content %}
    {{ block.super }}
{% if show_filters %}
<h3>Filters:</h3>
 {% if qstr.customer %}<h4>Customer: {{ qstr.customer }} </h4>{% endif %}
 {% if qstr.inv_class %}<h4>Inv Class: {{ qstr.inv_class }} </h4>{% endif %}
 {% if qstr.group %}<h4>Group: {{ qstr.group }}</h4>{% endif %}
 {% if qstr.package %}<h4>Package: {{ qstr.package }}</h4>{% endif %}
 {% if qstr.cust_item_code %}<h4>Cust Item Code: {{ qstr.cust_item_code }}</h4>{% endif %}
 {% if qstr.item %}<h4>Item: {{ qstr.item }}</h4>{% endif %}
 {% if qstr.description %}<h4>Description: {{ qstr.description }}</h4>{% endif %}
<hr />
<hr />
{% endif %}
<div class="row no-print pb-3 align-items-center">
    <div class="col-3">
    Filter: <input type="text" id="filter_box" name="filter_box" autofocus />
    </div>
    <div class="col-4" id="id_buildings">
        <div class="row">
            <div class="col-6">
                <input type="checkbox" id="building1" name="building1" value="B1" checked>
                <label for="building1"> Building 1</label>
            </div>
            <div class="col-6">
                <input type="checkbox" id="building2" name="building2" value="B2" checked>
                <label for="building"> Building 2</label>
            </div>
        </div>
    </div>
    <div class="col-1 mt-1">
        View by:
    </div>
    <div class="col-2">
        <select name="sort_by" maxlength="11" tabindex="2" class="select form-control" id="id_sort_by"> 
            <option value="receiver">By Receiver</option> 
            <option value="item">By Item</option> 
            <option value="package">By Package</option>
        </select>
    </div>
</div>
{% if qstr.sort_by == 'receiver' %}
{% if invlog_filtered %}
    {% regroup invlog_filtered by customer as customer_list %}
    {% for customer in customer_list %}
        {% regroup customer.list by inv_class as inv_class_list %}
        {% for inv_class in inv_class_list %}
            {% regroup inv_class.list by group as group_list %}
            {% for group in group_list %}
                <div class="col groupBlock breaker">
                    <div class="row mt-3">
                        <div class="col-3 text-nowrap">Inventory Owner: {{ customer.grouper}}</div>
                        <div class="col-2 text-nowrap">Inventory Class: {{ inv_class.grouper }}</div>
                        <div class="col-2 text-nowrap">Group: {{ group.grouper }}</div>
                    </div>
                    <div class="row mt-3">
                        <div class="col"><span class="font-weight-bolder small"><u>Receiver</u></span></div>
                        <div class="col-2"><span class="font-weight-bolder small"><u>Item</u></span></div>
                        <div class="col" ><span class="font-weight-bolder small" style="white-space: nowrap;"><u>Item Code</u></span></div>
                        <div class="col-2"><span class="font-weight-bolder small"><u>Description/Car</u></span></div>
                        <div class="col"><span class="font-weight-bolder small"><u>Lot</u></span></div>
                        <div class="col"><span class="font-weight-bolder small"><u>CofAMFR</u></span></div>
                        <div class="col"><span class="font-weight-bolder small"><u>Package</u></span></div>
                        <div class="col"><span class="font-weight-bolder small" style="white-space: nowrap;"><u>Unit Weight</u></span></div>
                        <div class="col"><span class="font-weight-bolder small" style="white-space: nowrap;"><u>Qty. On Hand</u></span></div>
                    </div>
                    {% for record in group.list %}
                    <div class="row filter_row" search_string="">
                        <div class="filter_field" hidden>{{ customer.grouper }}</div>
                        <div class="filter_field" hidden>{{ inv_class.grouper }}</div>
                        <div class="filter_field" hidden>{{ group.grouper }}</div>
                        <div class="col"><span class="small filter_field building_field" style="white-space: nowrap;">{{ record.receiver }}</span></div>
                        <div class="col-2"><span class="small filter_field">{{ record.item }}</span></div>
                        <div class="col"><span class="small filter_field">{{ record.cust_item_code }}</span></div>
                        <div class="col-2"><span class="small filter_field">{% if record.car %}{{ record.car }}-{{ record.car_location }}{% else %}{{ record.description|default_if_none:"" }}{% endif %}</span></div>
                        <div class="col"><span class="small filter_field" style="white-space: nowrap;">{{ record.lot }}</span></div>
                        <div class="col"><span class="small" style="white-space: nowrap;">{{ record.cofa_mfr | floatformat:'4' | intcomma }}</span></div>
                        <div class="col"><span class="small filter_field" style="white-space: nowrap;">{{ record.package }}</span></div>
                        <div class="col"><span class="small" style="white-space: nowrap;">{{ record.unit_weight | floatformat:'0' | intcomma }}</span></div>
                        <div class="col"><span class="small" style="white-space: nowrap;">{{ record.qty_on_hand | floatformat:'0' | intcomma }}</span></div>
                    </div>
                    {% endfor %}
                    <div class="text-right mt-2 small total_row">Group Total Qty_on_hand for {{ group.grouper }} = <span class="runningTotal">{{ group.list | running_total | floatformat:'0' | intcomma }}</span> </div> 
                </div>
            {% endfor %}
        {% endfor %}
    {% endfor %}
    <div class="row final_qty">
        Total Qty on hand: {{ total.qty_on_hand__sum | floatformat:'0' | intcomma }}
    </div>
  {% else %}
    <p>There are no records in the log.</p>
  {% endif %}
{% elif qstr.sort_by == 'item' %}
<div class="row">
    <div class="col-3"><span class="font-weight-bolder"><u>Item</u></span></div>
    <div class="col-1 text-nowrap text-right"><span class="font-weight-bolder"><u>Qty On Hand</u></span></div>
</div>
{% regroup invlog_filtered by customer as customer_list %}
{% for customer in customer_list %}
    {% regroup customer.list by inv_class as inv_class_list %}
    {% for inv_class in inv_class_list %}
        {% regroup inv_class.list by group as group_list %}
        {% for group in group_list %}
            {% regroup group.list by item as item_list %}
            <div class="col groupBlock breaker">
                <div class="row mb-3">
                    <div class="col-2">Inventory Owner: {{ customer.grouper}}</div>
                    <div class="col-2">Inventory Class: {{ inv_class.grouper }}</div>
                    <div class="col-2">Group: {{ group.grouper }}</div>
                </div>
                {% for item in item_list %}
                    <div class="row filter_row" search_string="">
                        <div class="col-3 filter_field">{{ item.grouper }}</div>
                        <div class="col-1 text-right">{{ item.list.0.total_item | floatformat:'0' | intcomma }}</div>
                    </div>
                {% endfor %}
            </div>
        {% endfor %}
    {% endfor %}
{% endfor %}
{% elif qstr.sort_by == 'package' %}
<div class="row">
    <div class="col-1"><span class="font-weight-bolder"><u>Class</u></span></div>
    <div class="col-2"><span class="font-weight-bolder"><u>Package</u></span></div>
    <div class="col-2"><span class="font-weight-bolder"><u>Qty On Hand</u></span></div>
</div>
{% regroup invlog_filtered by inv_class as class_list %}
{% for inv_class in class_list %}
    {% regroup inv_class.list by package as package_list %}
    {% for package in package_list %}
        <div class="row filter_row" search_string="">
            <div class="col-1 filter_field">{{ inv_class.grouper }}</div>
            <div class="col-2 filter_field">{{ package.grouper }}</div>
            <div class="col-2 text-right">{{ package.list.0.total_class_package | floatformat:'0' | intcomma }}</div>
        </div>
    {% endfor %}
{% endfor %}
{% else %}
<p>Report Type Invalid</p>
{% endif %}
{% endblock content%}
{% block body_scripts %}
    {{ block.super }}
    <script type="text/javascript" src="{% static 'informant_reports/js/inv_on_hand_support.js' %}"></script>
    <script type="text/javascript" src="{% static 'informant_reports/js/filter_report.js' %}"></script>
{% endblock body_scripts %}