{% load humanize %}
{% if frmlog_record.job %}
<div class="row ml-1 mt-3 mb-0"><h4>Job Detail</h4></div>
<div class="row ml-2 no-gutters">
    <div class="col">
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Job:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.job }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Customer:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.customer_id }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Lot:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.lot }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Date Reqd:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.date_required }}</div>
        </div>
    </div>
    <div class="col">
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Status:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.status }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Description:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.description }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Group:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.group_id }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Est Rate:</div>
            <div class="col-7 text-right pr-5">{{ frmlog_record.job.est_rate | floatformat:'0' | intcomma }}</div>
        </div>
    </div>
    <div class="col">
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Orig Date:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.date_originated }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Product:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.product}}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Order Qty:</div>
            <div class="col-7 text-right pr-5">{{ frmlog_record.job.qty_ordered | floatformat:'0' | intcomma }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Line:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.line_id }}</div>
        </div>
    </div>
    
    <div class="col">
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Order#:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.order_number }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Ver:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.job.frm_ver }}</div>
        </div>
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Revenue/lb:</div>
            <div class="col-7 text-right pr-5">{{ frmlog_record.job.revenue_lb | floatformat:'4' | intcomma }}</div>
        </div>
    </div>
</div>
{% else %}
<div class="row ml-1 mt-3 mb-0"><h6>No job is related to this formulation.</h6></div>
{% endif %}

<div class="row ml-1 mt-3 mb-0"><h4>Formula Info</h4></div>
{% comment %}
<div class="row ml-2 no-gutters">
    <div class="col">
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Customer:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.customer_id }}</div>
        </div>
    </div>
    <div class="col">
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Product:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.product }}</div>
        </div>
    </div>
    <div class="col">
        <div class="row no-gutters">
            <div class="col-5 font-weight-bolder">Ver:</div>
            <div class="col-7 d-flex align-items-end">{{ frmlog_record.frm_ver }}</div>
        </div>
    </div>
</div>
{% endcomment %}

<div class="row">
    <div class="col-2"><h5><u>Remarks:</u></h5></div>
    <div class="col-10">{{ frmlog_record.remarks }}</div>
</div>

<div class="row ml-1 mt-1 mb-0"><h5><u>Formulation Items:</u></h5></div>
<div class="row">
    <div class="col-3 font-weight-bolder">Item</div>
    <div class="col-2 font-weight-bolder">Customer</div>
    <div class="col font-weight-bolder">Tgt</div>
    <div class="col font-weight-bolder">Adjust</div>
    <div class="col font-weight-bolder">Range</div>
    <div class="col font-weight-bolder">&nbsp;</div>
    <div class="col font-weight-bolder">Link ID</div>
    <div class="col font-weight-bolder">Link Total</div>
</div>

{% for item in frm_items %}
<div class="row"> 
    <div class="col-3">{{ item.item }}</div>
    <div class="col-2">{{ item.item_customer }}</div>
    <div class="col text-right">{{ item.tgt }}</div>
    <div class="col">{{ item.adjust }}</div>
    <div class="col">{{ item.min }}</div>
    <div class="col">{{ item.max }}</div>
    <div class="col">{{ item.link_id }}</div>
    <div class="col">{{ item.link_total }}</div>
</div>
{% endfor %}

<div class="row ml-1 mt-1 mb-0"><h5><u>Deviations:</u></h5></div>
<div class="row ml-1">
    <div class="col font-weight-bolder">DevID</div>
    <div class="col font-weight-bolder">Scan</div>
</div>
{% for dev in frm_dev %}
<div class="row ml-1"> 
    <div class="col">{{ dev.devid }}</div>
    <div class="col"><a href='{{ MEDIA_URL }}{{ dev.scan }}' target='_blank'>{{ dev.filename }}</a></div>
</div>
{% endfor %}
<div class="row ml-1"><h6><span class="font-weight-bolder">DRW %</span>:{{ frmlog_record.drw_pct|default_if_none:""|floatformat:'4' }}</h6> </div>
<div class="row ml-1">
    <div class="col font-weight-bolder">Receiver</div>
</div>
{% for devrw in frm_devrws %}
<div class="row ml-1"> 
    <div class="col">{{ devrw.receiver }}</div>
</div>
{% endfor %}