{% extends "layout_report.html" %}
{% load tz %}
{% load humanize %}
{% load app_filters %}
{% block content %}
    {{ block.super }}
<div class="row align-items-end">
    <div class="col-6">
        <div class="row align-items-end">
            <div class="col-2 p-0"><span class="font-weight-bolder"><u>Item Code</u></span></div>
            <div class="col-1 p-0"><span class="font-weight-bolder"><u>Class</u></span></div>
            <div class="col-2 p-0"><span class="font-weight-bolder"><u>Group</u></span></div>
            <div class="col-5 p-0"><span class="font-weight-bolder"><u>Item</u></span></div>
            <div class="col-2 p-0"><span class="font-weight-bolder"><u>Lot</u></span></div>
        </div>
    </div>
    <div class="col-6">
        <div class="row align-items-end">
            <div class="col-2 text-right p-0"><span class="font-weight-bolder"><u>Open</u></span></div>
            <div class="col-2 text-right p-0"><span class="font-weight-bolder"><u>Produced/<br />Received</u></span></div>
            <div class="col-2 text-right p-0"><span class="font-weight-bolder"><u>Consumed</u></span></div>
            <div class="col-2 text-right p-0"><span class="font-weight-bolder"><u>Shipped</u></span></div>
            <div class="col-2 text-right p-0"><span class="font-weight-bolder"><u>Adjustment</u></span></div>
            <div class="col-2 text-right p-0"><span class="font-weight-bolder"><u>End</u></span></div>
        </div>
    </div>
</div>
{% regroup txns by cic as cic_list %}
{% for cic in cic_list %}
{% for txn in cic.list %}
<div class="row">
    <div class="col-6">
        <div class="row">
            <div class="col-2 p-0">{{ txn.receiver.cust_item_code }}</div>
            <div class="col-1 p-0">{{ txn.receiver.inv_class }}</div>
            <div class="col-2 p-0">{{ txn.receiver.group }}</div>
            <div class="col-5 p-0 text-nowrap" title="{{ txn.receiver.item.name }}">{{ txn.receiver.item.name | truncatechars:25 }}</div>
            <div class="col-2 p-0">{{ txn.receiver.lot }}</div>
        </div>
    </div>
    <div class="col-6">
        <div class="row">
            <div class="col-2 text-right p-0">{{ txn.open_balance | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ txn.received_tot | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ txn.consumed_tot | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ txn.shipped_tot | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ txn.adjustment_tot | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ txn.end_balance | floatformat:'0' | intcomma }}</div>
        </div>
    </div>
</div>
{% endfor %}
<div class="row mt-1 bg-warning">
    <div class="col-6">
        <div class="row">
            <div class="col-2 pl-1 p-0">{{ cic.list.0.receiver.cust_item_code }}</div>
            <div class="col-1 p-0"></div>
            <div class="col-2 p-0"></div>
            <div class="col-5 p-0 text-nowrap" title="{{ cic.list.0.receiver.item.name }}">{{ cic.list.0.receiver.item.name | truncatechars:25 }}</div>
            <div class="col-2 text-right p-0">TOTAL</div>
        </div>
    </div>
    <div class="col-6">
        <div class="row">
            <div class="col-2 text-right p-0">{{ cic.list | running_total_open | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ cic.list.0.received_tot_block | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ cic.list.0.consumed_tot_block | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ cic.list.0.shipped_tot_block | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ cic.list.0.adjustment_tot_block | floatformat:'0' | intcomma }}</div>
            <div class="col-2 text-right p-0">{{ cic.list | running_total_end | floatformat:'0' | intcomma }}</div>
        </div>
    </div>
</div>
{% endfor %}
<div class="row mt-3 bg-warning">
    <div class="col-6">
        <div class="row">
            <div class="col-4 text-nowrap p-0"> Finished Goods Totals</div>
            <div class="col-8 p-0"></div>
        </div>
    </div>
    <div class="col-6">
        <div class="row">
            <div class="col-2 border-top border-dark text-right p-0">{{ txns | report_total_open | floatformat:'0' | intcomma }}</div>
            <div class="col-2 border-top border-dark text-right p-0">{{ txns | report_total_received | floatformat:'0' | intcomma }}</div>
            <div class="col-2 border-top border-dark text-right p-0">{{ txns | report_total_consumed | floatformat:'0' | intcomma }}</div>
            <div class="col-2 border-top border-dark text-right p-0">{{ txns | report_total_shipped | floatformat:'0' | intcomma }}</div>
            <div class="col-2 border-top border-dark text-right p-0">{{ txns | report_total_adjustment | floatformat:'0' | intcomma }}</div>
            <div class="col-2 border-top border-dark text-right p-0">{{ txns | report_total_end | floatformat:'0' | intcomma }}</div>
        </div>
    </div>
</div>
{% endblock content %}