{% extends "layout_report.html" %}
{% load tz %}
{% load humanize %}
{% load app_filters %}
{% block content %}
    {{ block.super }}
<div class="row align-items-end">
    <div class="col-2 p-0"><span class="font-weight-bolder"><u>Product Code</u></span></div>
    <div class="col-4 p-0"><span class="font-weight-bolder"><u>Item</u></span></div>
    <div class="col-1 text-right p-0"><span class="font-weight-bolder"><u>Open</u></span></div>
    <div class="col-1 text-right p-0"><span class="font-weight-bolder"><u>Produced/<br />Received</u></span></div>
    <div class="col-1 text-right p-0"><span class="font-weight-bolder"><u>Consumed</u></span></div>
    <div class="col-1 text-right p-0"><span class="font-weight-bolder"><u>Shipped</u></span></div>
    <div class="col-1 text-right p-0"><span class="font-weight-bolder"><u>Adjustment</u></span></div>
    <div class="col-1 text-right p-0"><span class="font-weight-bolder"><u>End</u></span></div>
</div>
{% for txn in txns %}
<div class="row">
    <div class="col-2 p-0">{{ txn.receiver.cust_item_code }}</div>
    <div class="col-4 p-0">{{ txn.receiver.item.name }}</div>
    <div class="col-1 text-right p-0">{{ txn.open_balance | floatformat:'0' | intcomma }}</div>
    <div class="col-1 text-right p-0">{{ txn.received_tot | floatformat:'0' | intcomma }}</div>
    <div class="col-1 text-right p-0">{{ txn.consumed_tot | floatformat:'0' | intcomma }}</div>
    <div class="col-1 text-right p-0">{{ txn.shipped_tot | floatformat:'0' | intcomma }}</div>
    <div class="col-1 text-right p-0">{{ txn.adjustment_tot | floatformat:'0' | intcomma }}</div>
    <div class="col-1 text-right p-0">{{ txn.end_balance | floatformat:'0' | intcomma }}</div>
</div>
{% endfor %}
<div class="row mt-3 bg-warning">
    <div class="col-2 text-nowrap p-0"> Raw Materials Totals</div>
    <div class="col-4 p-0"></div>
    <div class="col-1 border-top border-dark text-right p-0">{{ txns | report_total_open | floatformat:'0' | intcomma }}</div>
    <div class="col-1 border-top border-dark text-right p-0">{{ txns | report_total_received | floatformat:'0' | intcomma }}</div>
    <div class="col-1 border-top border-dark text-right p-0">{{ txns | report_total_consumed | floatformat:'0' | intcomma }}</div>
    <div class="col-1 border-top border-dark text-right p-0">{{ txns | report_total_shipped | floatformat:'0' | intcomma }}</div>
    <div class="col-1 border-top border-dark text-right p-0">{{ txns | report_total_adjustment | floatformat:'0' | intcomma }}</div>
    <div class="col-1 border-top border-dark text-right p-0">{{ txns | report_total_end | floatformat:'0' | intcomma }}</div>
</div>
{% endblock content %}
{% block body_scripts %}
{% if not standalone %}
    <script>
        var URL = "{% url 'orcsae_fg' %}" + window.location.search;
        window.open(URL, '_blank');
    </script>
{% endif %}
{% endblock body_scripts %}