{% extends "layout_report.html" %}
{% load static %}
{% load app_filters %}
{% load humanize %}
{% load tz %}
{% block content %}
    {{ block.super }}
<div class="row pb-1 no-print" id="control">
    <div class="col-3">
        Filter: <input type="text" tabindex="1" id="filter_box" name="filter_box" style="height:38px;" autofocus />
    </div>
    <div class="col-1 mt-1">
        Sort:
    </div>
    <div class="col-2">
        <select name="sort_by" maxlength="11" tabindex="2" class="select form-control" id="id_sort_by"> 
            <option value="item">By Item</option> 
            <option value="location">By Location</option> 
            <option value="receiver">By Receiver</option>
        </select>
    </div>
</div>
{% if qstr.sort_by == 'location' %}
    <div class="row">
        <div class="col-6">
            <div class="row">
                <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
                <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
                <div class="col-3 pl-2 pr-0"><span class="font-weight-bolder"><u></u></span></div>
                <div class="col-5 pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
            </div>
        </div>
        <div class="col-6">
            <div class="row">
                <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
                <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
                <div class="col-2 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Unit</u></span></div>
                <div class="col-2 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Qty.</u></span></div>
                <div class="col-2 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u></u></span></div>
                <div class="col-2 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u></u></span></div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-6">
            <div class="row">
                <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u>Whse</u></span></div>
                <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u>Row</u></span></div>
                <div class="col-3 pl-2 pr-0"><span class="font-weight-bolder"><u>Receiver</u></span></div>
                <div class="col-5 pl-0 pr-0"><span class="font-weight-bolder"><u>Item</u></span></div>
            </div>
        </div>
        <div class="col-6">
            <div class="row">
                <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u>Lot</u></span></div>
                <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u>Package</u></span></div>
                <div class="col-2 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Weight</u></span></div>
                <div class="col-2 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>On Hand</u></span></div>
                <div class="col-2 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Units</u></span></div>
                <div class="col-2 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Loc Qty</u></span></div>
            </div>
        </div>
    </div>
    {% for location in location_list %}
        <div class="row filter_row" search_string="">
            <div class="col-6">
                <div class="row">
                    <div class="col-2 pl-0 pr-0 filter_field">{{ location.whse }}</div>
                    <div class="col-2 pl-0 pr-0 filter_field">{{ location.row }}</div>
                    <div class="filter_field" hidden>{{ location.receiver }}</div>
                    <div class="col-3 pl-0 pr-0" title="{{ location.receiver }}">{{ location.receiver | truncatechars:9 }}</div>
                    <div class="filter_field" hidden>{{ location.receiver.item.name }}</div>
                    <div class="col-5 pl-0 pr-0" title="{{ location.receiver.item.name }}">{{ location.receiver.item.name | truncatechars:25 }}</div>
                </div>
            </div>
            <div class="col-6">
                <div class="row">
                    <div class="col-3 pl-0 pr-0 filter_field">{{ location.receiver.lot }}</div>
                    <div class="col-1 pl-0 pr-0 filter_field">{{ location.receiver.package}}</div>
                    <div class="col-2 pl-0 pr-0 text-right">{{ location.receiver.unit_weight | floatformat:'0' | intcomma }}</div>
                    <div class="col-2 pl-0 pr-0 text-right">{{ location.receiver.qty_on_hand  | floatformat:'0' | intcomma}}</div>
                    <div class="col-2 pl-0 pr-0 text-right">{{ location.units  | floatformat:'0' | intcomma}}</div>
                    <div class="col-2 pl-0 pr-0 text-right">{{ location.qty | floatformat:'0' | intcomma }}</div>
                </div>
            </div>
        </div>
    {% endfor %}
{% elif qstr.sort_by == 'receiver' %}
    <div class="row">
        <div class="col pl-2 pr-0"><span class="font-weight-bolder"><u></u></span></div>
        <div class="col-3 pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
        <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
        <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
        <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Unit</u></span></div>
        <div class="col pl-0 pr-0 mr-2 text-right"><span class="font-weight-bolder"><u>Qty.</u></span></div>
        <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
        <div class="col-1 pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
        <div class="col-1 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u></u></span></div>
        <div class="col pl-0 pr-0 mr-2 text-right"><span class="font-weight-bolder"><u></u></span></div>
    </div>
    <div class="row">
        <div class="col pl-2 pr-0"><span class="font-weight-bolder"><u>Receiver</u></span></div>
        <div class="col-3 pl-0 pr-0"><span class="font-weight-bolder"><u>Item</u></span></div>
        <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Lot</u></span></div>
        <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Package</u></span></div>
        <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Weight</u></span></div>
        <div class="col pl-0 pr-0 mr-2 text-right"><span class="font-weight-bolder"><u>On Hand</u></span></div>
        <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Whse</u></span></div>
        <div class="col-1 pl-0 pr-0"><span class="font-weight-bolder"><u>Row</u></span></div>
        <div class="col-1 pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Units</u></span></div>
        <div class="col pl-0 pr-0 mr-2 text-right"><span class="font-weight-bolder"><u>Qty</u></span></div>
    </div>
    {% for location in location_list %}
        <div class="row filter_row" search_string="">
            <div class="filter_field" hidden>{{ location.receiver }}</div>
            <div class="col pl-0 pr-0" title="{{ location.receiver }}">{{ location.receiver | truncatechars:10 }}</div>
            <div class="filter_field" hidden>{{ location.receiver.item.name }}</div>
            <div class="col-3 pl-0 pr-0" title="{{ location.receiver.item.name }}">{{ location.receiver.item.name | truncatechars:30 }}</div>
            <div class="col pl-0 pr-0 filter_field">{{ location.receiver.lot }}</div>
            <div class="col pl-0 pr-0 filter_field">{{ location.receiver.package}}</div>
            <div class="col pl-0 pr-0 text-right">{{ location.receiver.unit_weight | floatformat:'0' | intcomma }}</div>
            <div class="col pl-0 pr-0 mr-2 text-right">{{ location.receiver.qty_on_hand | floatformat:'0' | intcomma }}</div>
            <div class="col pl-0 pr-0 filter_field">{{ location.whse }}</div>
            <div class="col-1 pl-0 pr-0 filter_field">{{ location.row }}</div>
            <div class="col-1 pl-0 pr-0 text-right">{{ location.units | floatformat:'0' | intcomma }}</div>
            <div class="col pl-0 pr-0 mr-2 text-right">{{ location.qty | floatformat:'0' | intcomma }}</div>
        </div>
    {% endfor %}
{% else %}
{% comment - by item new layout - return to old%}
<div class="row ml-3">
    <div class="col-2 pl-2 pr-0"><span class="font-weight-bolder"><u>Receiver</u></span></div>
    <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u>Lot</u></span></div>
    <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u>Pkg/Weight</u></span></div>
    <div class="col pl-0 pr-0 mr-2 text-right"><span class="font-weight-bolder"><u>Qty on Hand</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Whse</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Row</u></span></div>
    <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Unit</u></span></div>
    <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Loc Qty</u></span></div>
</div>
{% regroup location_list by receiver.item.name as item_list %}
    {% for item in item_list %}
        <div class="col  border-dark border-top groupBlock">
            <div class="row">
                <div class="col-4 pl-0 pr-0"><span class="font-weight-bolder mr-2"><u>Item:</u></span>{{ item.grouper }}</div>
                <div class="col-3 pl-0 pr-0" title="{{ item.list.0.receiver.cust_item_code }}"><span class="font-weight-bolder mr-2"><u>Cust Item Code:</u></span>{{ item.list.0.receiver.cust_item_code | truncatechars:20}}</div>
                <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder mr-2"><u>Class/Grp:</u></span>{{ item.list.0.receiver.inv_class }}/{{ item.list.0.receiver.group }}</div> 
            </div>
            {% for location in item.list %}
                <div class="row filter_row ml-3" search_string="">
                    <div class="filter_field" hidden>{{ item.grouper }}</div>
                    <div class="filter_field" hidden>{{ location.receiver.cust_item_code }}</div>
                    <div class="filter_field" hidden>{{ location.receiver.inv_class}}</div>
                    <div class="filter_field" hidden>{{ location.receiver.group}}</div>
                    <div class="filter_field" hidden>{{ location.receiver }}</div>
                    <div class="col-2 pl-0 pr-0" title="{{ location.receiver }}">{{ location.receiver | truncatechars:15 }}</div>
                    <div class="col-2 pl-0 pr-0 filter_field">{{ location.receiver.lot }}</div>
                    <div class="filter_field" hidden>{{ location.receiver.package }}</div>
                    <div class="col-2 pl-0 pr-0 text-nowrap" title="{{ location.receiver.package }}/{{ location.receiver.unit_weight }}">{{ location.receiver.package | truncatechars:12 }}/{{ location.receiver.unit_weight | floatformat:'0' | intcomma | truncatechars:12}}</div>
                    <div class="col pl-0 pr-0 mr-2 text-right">{{ location.receiver.qty_on_hand | floatformat:'0' | intcomma }}</div>
                    <div class="col pl-0 pr-0 filter_field">{{ location.whse }}</div>
                    <div class="col pl-0 pr-0 filter_field">{{ location.row }}</div>
                    <div class="col pl-0 pr-0 text-right">{{ location.units | floatformat:'0' | intcomma }}</div>
                    <div class="col pl-0 pr-0 text-right">{{ location.qty | floatformat:'0' | intcomma }}</div>
                </div>
            {% endfor %}
        </div>
    {% endfor %}
{% endcomment %}
<div class="row">
    <div class="col-3">
        <div class="row"> 
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Cust Item</u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
        </div>
    </div>
    <div class="col-9">
        <div class="row">
            <div class="col pl-2 pr-0"><span class="font-weight-bolder"><u></u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
            <div class="col pl-0 pr-0 mr-2 text-right"><span class="font-weight-bolder"><u>Qty. On</u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u></u></span></div>
            <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u></u></span></div>
        </div>
    </div>
</div>
<div class="row">
    <div class="col-3">
        <div class="row"> 
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Item</u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Code</u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Class/Grp</u></span></div>
        </div>
    </div>
    <div class="col-9">
        <div class="row">
            <div class="col pl-2 pr-0"><span class="font-weight-bolder"><u>Receiver</u></span></div>
            <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u>Lot</u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Pkg/Weight</u></span></div>
            <div class="col pl-0 pr-0 mr-2 text-right"><span class="font-weight-bolder"><u>Hand</u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Whse</u></span></div>
            <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Row</u></span></div>
            <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Unit</u></span></div>
            <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Loc Qty</u></span></div>
        </div>
    </div>
</div>
{% regroup location_list by receiver.item.name as item_list %}
    {% for item in item_list %}
        <div class="col  border-dark border-top groupBlock">
        <div class="row">
        <div class="col-3">
            <div class="row">
                <div class="col pl-0 pr-0">{{ item.grouper }}</div>
                <div class="col pl-0 pr-0" title="{{ item.list.0.receiver.cust_item_code }}">{{ item.list.0.receiver.cust_item_code | truncatechars:11}}</div>
                <div class="col pl-0 pr-0">{{ item.list.0.receiver.inv_class }}/{{ item.list.0.receiver.group }}</div> 
            </div>
        </div>
        <div class="col-9"></div>
        </div>
        <div class="row">
        <div class="col-3"></div>
        <div class="col-9">
            {% for location in item.list %}
                <div class="row filter_row" search_string="">
                    <div class="filter_field" hidden>{{ item.grouper }}</div>
                    <div class="filter_field" hidden>{{ location.receiver.cust_item_code }}</div>
                    <div class="filter_field" hidden>{{ location.receiver.inv_class}}</div>
                    <div class="filter_field" hidden>{{ location.receiver.group}}</div>
                    <div class="filter_field" hidden>{{ location.receiver }}</div>
                    <div class="col pl-0 pr-0" title="{{ location.receiver }}">{{ location.receiver | truncatechars:7 }}</div>
                    <div class="col-2 pl-0 pr-0 filter_field">{{ location.receiver.lot }}</div>
                    <div class="filter_field" hidden>{{ location.receiver.package }}</div>
                    <div class="col pl-0 pr-0 text-nowrap" title="{{ location.receiver.package }}/{{ location.receiver.unit_weight }}">{{ location.receiver.package | truncatechars:7 }}/{{ location.receiver.unit_weight | floatformat:'0' | intcomma | truncatechars:6}}</div>
                    <div class="col pl-0 pr-0 mr-2 text-right">{{ location.receiver.qty_on_hand | floatformat:'0' | intcomma }}</div>
                    <div class="col pl-0 pr-0 filter_field">{{ location.whse }}</div>
                    <div class="col pl-0 pr-0 filter_field">{{ location.row }}</div>
                    <div class="col pl-0 pr-0 text-right">{{ location.units | floatformat:'0' | intcomma }}</div>
                    <div class="col pl-0 pr-0 text-right">{{ location.qty | floatformat:'0' | intcomma }}</div>
                </div>
            {% endfor %}
        </div>
        </div>
        </div>
    {% endfor %}
{% endif %}
{% endblock content %}
{% block body_scripts %}
    {{ block.super }}
    <script type="text/javascript" src="{% static 'informant_reports/js/filter_report.js' %}"></script>
{% endblock body_scripts %}