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

<div class="small">
<div class="row">
    <div class="col-1 pl-0 pr-0"><span class="font-weight-bolder"><u>Customer</u></span></div>
    <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u>Product</u></span></div>
    <div class="col-1 pl-0 pr-0"><span class="font-weight-bolder"><u>Ver</u></span></div>
    <div class="col pl-4 pr-0"><span class="font-weight-bolder"><u>Line</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Qty Ordered</u></span></div>
    <div class="col 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>Formula PPH</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Formula Wt%</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Qty Req'd</u></span></div>
</div>

{% if item_list %}
{% regroup item_list by frmlog.job.customer.name as cust_list %}
    {% for cust in cust_list %}
     <div class="row">
        <div class="col-1 pl-3 pr-0">
            <div class="row">{{ cust.grouper }}</div>
        </div>
    {% regroup cust.list by frmlog as frm_list %}
         
        <div class="col-11 pl-3 pr-0">
         {% for frmlog in frm_list %}
            <div class="row">
                <div class="col-2 pl-0 pr-0">{{ frmlog.grouper.job.product }}</div>
                <div class="col-1 pl-3 pr-0">{{ frmlog.grouper.job.frm_ver }}</div>
                <div class="col-2 pl-5 pr-0">{{ frmlog.grouper.job.line }}</div>
                <div class="col-1 pl-0 pr-0">{{ frmlog.grouper.job.qty_ordered | floatformat:'0' | intcomma  }}</div>
                <div class="col pl-5 pr-0">
         {% for frm in frmlog.list %}
                <div class="row">
                    <div class="col-3 pl-0 pr-0{% if frm.frmlog.locked_by is None %} text-danger{% endif %}">{{ frm.item.name }}</div>
                    <div class="col-1 pl-0 pr-0 text-right{% if frm.frmlog.locked_by is None %} text-danger{% endif %}">{{ frm.tgt | floatformat:'3' | intcomma  }}</div>
                    <div class="col-3 pl-0 pr-0 text-right{% if frm.frmlog.locked_by is None %} text-danger{% endif %}">{{ frm.pct | floatformat:'3' | intcomma  }}</div>
                    <div class="col-3 pl-0 pr-0 text-right{% if frm.frmlog.locked_by is None %} text-danger{% endif %}">{{ frm.qty_required | floatformat:'0' | intcomma  }}</div>
                </div>
                    
         
                {% endfor %} 
                </div>
            </div>
            {% endfor %}
        </div>
    </div>
    {% endfor %}
    <div class="row text-danger">**Items in red indicate unlocked formulas.</div>
{% else %}
<div class="row">No locked Formulations with active jobs found</div>
{% endif %}
</div>
{% endblock content %}

{% block body_scripts %}
    <script>
        var URL = "{% url 'sched_inv_req_vs_onhand' %}" + window.location.search;
        window.open(URL, '_blank');
    </script>
{% endblock body_scripts %}