{% extends "layout_report.html" %}
{% load tz %}
{% load humanize %}
{% block content %}
    {{ block.super }}

<div class="row">
    <div class="col-1 pl-0 pr-0"><span class="font-weight-bolder"><u>ItemCode</u></span></div>
    <div class="col-3 pl-0 pr-0"><span class="font-weight-bolder"><u>Ingredient</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Qty Scheduled</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Qty Staged</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Qty Required</u></span></div>
    <div class="col pl-0 pr-0"><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>Qty Excess</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Qty Shortfall</u></span></div>
</div>

{% for item in final_report %}
<div class="row">
    <div class="col-4 pl-0 pr-0">
        <div class="row">
            <div class="col-3 ml-3 pl-0 pr-0">{{ item.item__cust_item_code }}</div>
            <div class="col pl-0 pr-0">{{ item.item__name }}</div>
        </div>
    </div>
    <div class="col pl-0 pr-0">
        <div class="row">
            <div class="col-1 pl-0 pr-0 text-right">{{ item.qty_scheduled | floatformat:'0' | intcomma   }}</div>
            <div class="col-1 ml-5 pl-0 pr-0 text-right">{{ item.qty_staged | floatformat:'0' | intcomma   }}</div>
            <div class="col-2 pl-0 pr-0 text-right">{{ item.qty_required | floatformat:'0' | intcomma   }}</div>
            <div class="col-2 pl-0 pr-0 text-right">{{ item.qty_available | floatformat:'0' | intcomma   }}</div>
            <div class="col-2 pl-0 pr-0 text-right">{{ item.qty_excess | floatformat:'0' | intcomma   }}</div>
            <div class="col-2 pl-0 pr-0 text-right">{{ item.qty_shortfall | floatformat:'0' | intcomma   }}</div>
        </div>
    </div>
</div>
{% endfor %}
</div>
{% endblock content %}