{% extends "layout_report.html" %}
{% load tz %}
{% load humanize %}
{% load app_filters %}
{% block content %}
    {{ block.super }}
<div class="row align-items-end">
    <div class="col"><span class="font-weight-bolder"><u>Receiver</u></span></div>
    <div class="col"><span class="font-weight-bolder"><u>Class</u></span></div>
    <div class="col"><span class="font-weight-bolder"><u>Group</u></span></div>
    <div class="col"><span class="font-weight-bolder"><u>CustItemCode</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>Lot</u></span></div>
    <div class="col"><span class="font-weight-bolder"><u><span class="text-nowrap">Last Trans</span><br />Date</u></span></div>
    <div class="col"><span class="font-weight-bolder"><u>Qty On Hand</u></span></div>
    <div class="col"><span class="font-weight-bolder">&nbsp;</span></div>
</div>
{% regroup inv_list by customer as inventory_list %}
{% for customer in inventory_list %}
    <div class="row pb-3">Customer: {{ customer.grouper }}</div>
    {% for inv in customer.list %}
        <div class="row{% if forloop.last %} pb-3{% endif %}{% ifchanged inv.cust_item_code %} pt-2{% endifchanged %}">
            <div class="col text-nowrap">{{ inv.receiver }}</div>
            <div class="col">{{ inv.inv_class }}</div>
            <div class="col">{{ inv.group }}</div>
            <div class="col">{{ inv.cust_item_code }}</div>
            <div class="col-2">{{ inv.item.name }}</div>
            <div class="col-2">{{ inv.lot }}</div>
            <div class="col">{{ inv.latest_date }}</div>
            <div class="col text-right">{{ inv.qty_on_hand | floatformat:'0' | intcomma }}</div>
            <div class="col">
                {% if inv.days_inactive > 45 and inv.days_inactive <= 90 %}*
                {% elif inv.days_inactive > 90 and inv.days_inactive <= 180 %}**
                {% elif inv.days_inactive > 180 and inv.days_inactive <= 360 %}***
                {% else %}****{% endif %}
            </div>
        </div>
    {% endfor %}
{% endfor %}
{% endblock content %}