{% extends "layout_report.html" %}
{% load app_filters %}
{% load humanize %}
{% load tz %}
{% block content %}
    {{ block.super }}
{% if show_filters %}
<h4>Filters:</h4>
 {% if qstr %}<h6>Job: {{ qstr.job }} </h6>{% endif %}
 {% if job %}<h6>Job: {{ job }} </h6>{% endif %}
 {% if trmc %}<h6>TRMC: {{ trmc }} </h6>{% endif %}
 {% if tncmc %}<h6>TNCMC: {{ tncmc }} </h6>{% endif %}
 {% if tmc %}<h6>TMC: {{ tmc }} </h6>{% endif %}
<hr /> 
{% endif %}
{% if tmc <= 0 or trmc <= 0 %}
    <div class="pt-2 pb-2 text-danger">REPORT NOTE: TMC or TRMC = 0.  Some percent yield values are not available for job {{ job.job }}</div>
{% endif %}
<div class="row">
    <div class="col-1">
        <div class="row">Customer:</div>
        <div class="row">Product:</div>
        <div class="row">Description:</div>
        <div class="row">Job:</div>
    </div>
    <div class="col-5">
        <div class="row">{{ job.customer }}</div>
        <div class="row">{{ job.product }}</div>
        <div class="row">{{ job.description }}</div>
        <div class="row">{{ job.job }}</div>
    </div>
    <div class="col-1 mr-4">
        <div class="row">Order #:</div>
        <div class="row">Started:</div>
        <div class="row">Complete:</div>
        <div class="row">CS Cert:</div>
        <div class="row text-nowrap">Production Line:</div>
    </div>
    <div class="col-4">
        <div class="row">{{ job.order_number }}</div>
        <div class="row">{{ job.job_start }}</div>
        <div class="row">{{ job.job_complete }}</div>
        <div class="row">{{ job.cs_cert }}</div>
        <div class="row">{{ job.line }}</div>
    </div>
</div>
<div class="row">
<h6>FINISHED GOODS PRODUCTION</h6>
</div>
<div class="row">
    <div class="col-1"><span class="font-weight-bolder">I.D.#</span></div>
    <div class="col-2"><span class="font-weight-bolder">Item</span></div>
    <div class="col-2"><span class="font-weight-bolder">Cust Item Code</span></div>
    <div class="col-3"><span class="font-weight-bolder">Description/Car</span></div>
    <div class="col-1"><span class="font-weight-bolder">Lot</span></div>
    <div class="col-1 text-right"><span class="font-weight-bolder">Units</span></div>
    <div class="col-1 text-right"><span class="font-weight-bolder">Pounds</span></div>
    <div class="col-1 text-right"><span class="font-weight-bolder">%Yield</span></div>
</div>
<div class="row small p-0 m-0">
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-2 p-0 m-0"><span class="font-weight-bolder">---------------------------</span></div>
    <div class="col-2 p-0 m-0"><span class="font-weight-bolder">---------------------------</span></div>
    <div class="col-3 p-0 m-0"><span class="font-weight-bolder">-------------------------------------------</span></div>
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-1 text-right p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-1 text-right p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
</div>
{% for fg in fg_list %}
<div class="row">
    <div class="col-1" title="{{ fg.receiver }}">{{ fg.receiver| truncatechars:11 }}</div>
    <div class="col-2 text-nowrap" title="{{ fg.receiver.item }}">{{ fg.receiver.item | truncatechars:19 }}</div>
    <div class="col-2">{{ fg.receiver.cust_item_code }}</div>
    <div class="col-3">{% if fg.receiver.package_id == 'BULK' %}{{ fg.car }}{% else %}{{ fg.receiver.description }}{% endif %}</div>
    <div class="col-1 text-nowrap" title="{{ fg.receiver.lot }}">{{ fg.receiver.lot | truncatechars:8 }}</div>
    <div class="col-1 text-right">{{ fg.units | floatformat:'1' | intcomma }}</div>
    <div class="col-1 text-right">{{ fg.received | floatformat:'0' | intcomma }}</div>
    {% if fg.pct_yield == "n/a" %}
    <div class="col-1 text-right">{{ fg.pct_yield }}</div>
    {% else %}
    <div class="col-1 text-right">{{ fg.pct_yield | floatformat:'2' | intcomma }}</div>
    {% endif %}
</div>
{% endfor %}
<div class="row mt-3">
    <div class="col-10"></div>
    <div class="col-1 border-dark border-top text-right">{{ total_fg | floatformat:'0' | intcomma }}</div>
    {% if total_fg_yield == "n/a" %}
    <div class="col-1 border-dark border-top text-right">{{ total_fg_yield }}</div>
    {% else %}
    <div class="col-1 border-dark border-top text-right">{{ total_fg_yield | floatformat:'2' | intcomma }}</div>
    {% endif %}
</div>

<div class="row">
<h6>NON-CONFORMING MATERIAL PRODUCTION</h6>
</div>
<div class="row">
    <div class="col-1"><span class="font-weight-bolder">I.D.#</span></div>
    <div class="col-2"><span class="font-weight-bolder">Item</span></div>
    <div class="col-1"><span class="font-weight-bolder">CIC</span></div>
    <div class="col-3"><span class="font-weight-bolder">Description/Car</span></div>
    <div class="col-2"><span class="font-weight-bolder">Lot</span></div>
    <div class="col-1"><span class="font-weight-bolder">Group</span></div>
    <div class="col-1 text-right"><span class="font-weight-bolder">Pounds</span></div>
    <div class="col-1 text-right"><span class="font-weight-bolder">%Yield</span></div>
</div>
<div class="row small p-0 m-0">
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-2 p-0 m-0"><span class="font-weight-bolder">---------------------------</span></div>
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-3 p-0 m-0"><span class="font-weight-bolder">-------------------------------------------</span></div>
    <div class="col-2 p-0 m-0"><span class="font-weight-bolder">---------------------------</span></div>
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-1 text-right p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-1 text-right p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
</div>
{% for ncm in ncm_list %}
<div class="row">
    <div class="col-1" title="{{ ncm.receiver }}">{{ ncm.receiver | truncatechars:11 }}</div>
    <div class="col-2 text-nowrap" title="{{ ncm.receiver.item }}">{{ ncm.receiver.item | truncatechars:19 }}</div>
    <div class="col-1">{{ ncm.receiver.cust_item_code }}</div>
    <div class="col-3">{% if ncm.receiver.package_id == 'BULK' %}{{ ncm.car }}{% else %}{{ ncm.receiver.description }}{% endif %}</div>
    <div class="col-2 text-nowrap" title="{{ ncm.receiver.lot }}">{{ ncm.receiver.lot | truncatechars:16 }}</div>
    <div class="col-1">{{ ncm.receiver.group }}</div>
    <div class="col-1 text-right">{{ ncm.received | floatformat:'0' | intcomma }}</div>
    {% if ncm.pct_yield  == "n/a" %}
    <div class="col-1 text-right">{{ ncm.pct_yield }}</div>
    {% else %}
    <div class="col-1 text-right">{{ ncm.pct_yield | floatformat:'2' | intcomma }}</div>
    {% endif %}
</div>
{% endfor %}
<div class="row mt-2">
    <div class="col-7"></div>
    <div class="col-3">TOTAL IDENTIFIED LOSSES</div>
    <div class="col-1 border-dark border-top text-right">{{ total_ncm | floatformat:'0' | intcomma }}</div>
    {% if total_ncm_yield == "n/a" %}
    <div class="col-1 border-dark border-top text-right">{{ total_ncm_yield }}</div>
    {% else %}
    <div class="col-1 border-dark border-top text-right">{{ total_ncm_yield | floatformat:'2' | intcomma }}</div>
    {% endif %}
</div>
<div class="row mt-2">
    <div class="col-7"></div>
    <div class="col-3">UN-IDENTIFIED LOSSES</div>
    <div class="col-1 border-dark border-top text-right">{{ unidentified_ncm_loss | floatformat:'0' | intcomma }}</div>
    {% if unidentified_ncm_yield == "n/a" %}
    <div class="col-1 border-dark border-top text-right">{{ unidentified_ncm_yield }}</div>
    {% else %}
    <div class="col-1 border-dark border-top text-right">{{ unidentified_ncm_yield | floatformat:'2' | intcomma }}</div>
    {% endif %}
</div>

<div class="row">
<h6>RAW MATERIAL CONSUMPTION</h6>
</div>
<div class="row">
    <div class="col-1"><span class="font-weight-bolder">Receiver</span></div>
    <div class="col-2"><span class="font-weight-bolder">Item</span></div>
    <div class="col-2"><span class="font-weight-bolder">Cust Item Code</span></div>
    <div class="col-3"><span class="font-weight-bolder">Description/Car</span></div>
    <div class="col-1"><span class="font-weight-bolder">Lot</span></div>
    <div class="col text-right"><span class="font-weight-bolder">Consumed</span></div>
    <div class="col text-right"><span class="font-weight-bolder">%Cons</span></div>
</div>
<div class="row small p-0 m-0">
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-2 p-0 m-0"><span class="font-weight-bolder">---------------------------</span></div>
    <div class="col-2 p-0 m-0"><span class="font-weight-bolder">---------------------------</span></div>
    <div class="col-3 p-0 m-0"><span class="font-weight-bolder">-------------------------------------------</span></div>
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col text-right p-0 m-0"><span class="font-weight-bolder">-----------------</span></div>
    <div class="col text-right p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
</div>
{% if report_type == 'detail' %}
{% for rm in rm_list_detail %}
<div class="row">
    <div class="col-1">{{ rm.receiver }}</div>
    <div class="col-2 text-nowrap" title="{{ rm.receiver.item }}">{{ rm.receiver.item | truncatechars:19}}</div>
    <div class="col-2">{{ rm.receiver.cust_item_code }}</div>
    <div class="col-3">{{ rm.receiver.description }}</div>
    <div class="col-1 text-nowrap">{{ rm.receiver.lot }}</div>
    <div class="col text-right">{{ rm.consumed | floatformat:'0' | intcomma }}</div>
    {% if rm.pct_yield == "n/a" %}
    <div class="col text-right">{{ rm.pct_yield }}</div>
    {% else %}
    <div class="col text-right">{{ rm.pct_yield_detail | floatformat:'2' | intcomma }}</div>
    {% endif %}
</div>
{% endfor %}

{% else %}
{% for rm in rm_list %}
<div class="row">
    <div class="col-1">{{ rm.receiver }}</div>
    <div class="col-2 text-nowrap" title="{{ rm.receiver.item }}">{{ rm.receiver.item | truncatechars:19}}</div>
    <div class="col-2">{{ rm.receiver.cust_item_code }}</div>
    <div class="col-3">{{ rm.receiver.description }}</div>
    <div class="col-1 text-nowrap">{{ rm.receiver.lot }}</div>
    <div class="col text-right">{{ rm.total_consumed | floatformat:'0' | intcomma }}</div>
    {% if rm.pct_yield == "n/a" %}
    <div class="col text-right">{{ rm.pct_yield }}</div>
    {% else %}
    <div class="col text-right">{{ rm.pct_yield | floatformat:'2' | intcomma }}</div>
    {% endif %}
</div>
{% endfor %}
{% endif %}
<div class="row mt-3">
    <div class="col-10"></div>
    <div class="col-1 border-dark border-top text-right">{{ total_rm | floatformat:'0' | intcomma }}</div>
    {% if total_rm_yield == "n/a" %}
    <div class="col-1 border-dark border-top text-right">{{ total_rm_yield }}</div>
    {% else %}
    <div class="col-1 border-dark border-top text-right">{{ total_rm_yield | floatformat:'2' | intcomma }}</div>
    {% endif %}
</div>

<div class="row">
<h6>INVENTORY SUMMARY INFORMATION</h6>
</div>
<div class="row">
    <div class="col-2"><span class="font-weight-bolder">Item</span></div>
    <div class="col-1"><span class="font-weight-bolder">Class</span></div>
    <div class="col-1"><span class="font-weight-bolder">Group</span></div>
    <div class="col-2"><span class="font-weight-bolder">Cust Item Code</span></div>
    <div class="col text-right"><span class="font-weight-bolder">Consumed</span></div>
    <div class="col text-right"><span class="font-weight-bolder">%TMC</span></div>
    <div class="col text-right"><span class="font-weight-bolder">%TRMC</span></div>
    <div class="col text-right"><span class="font-weight-bolder">Frm WT%</span></div>
</div>
<div class="row small p-0 m-0">
    <div class="col-2 p-0 m-0"><span class="font-weight-bolder">---------------------------</span></div>
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-1 p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col-2 p-0 m-0"><span class="font-weight-bolder">---------------------------</span></div>
    <div class="col text-right p-0 m-0"><span class="font-weight-bolder">------------------</span></div>
    <div class="col text-right p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col text-right p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
    <div class="col text-right p-0 m-0"><span class="font-weight-bolder">-------------</span></div>
</div>
{% if report_type == 'detail' %}
{% for frm in frm_list_detail %}
<div class="row">
    <div class="col-2 text-nowrap" title="{{ frm.item__name }}">{{ frm.item__name | truncatechars:19 }}</div>
    <div class="col-1">{{ frm.item__inv_class__name }}</div>
    <div class="col-1">{{ frm.item__inv_group__name }}</div>
    <div class="col-2">{{ frm.item__cust_item_code }}</div>
    <div class="col text-right">{{ frm.consumed | floatformat:'0' | intcomma }}</div>
    {% if frm.pct_yield == "n/a" %}
    <div class="col text-right">{{ frm.pct_yield_detail }}</div>
    {% else %}
    <div class="col text-right">{{ frm.pct_yield_detail | floatformat:'2' | intcomma }}</div>
    {% endif %}
    {% if frm.pct_trmc == "n/a" %}
    <div class="col text-right">{{ frm.pct_trmc_detail }}</div>
    {% else %}
    <div class="col text-right">{{ frm.pct_trmc_detail | floatformat:'2' | intcomma }}</div>
    {% endif %}
    <div class="col text-right">{{ frm.tgt | floatformat:'2' | intcomma }}</div>
</div>
{% endfor %}

{% else %}
{% for frm in frm_list %}
<div class="row">
    <div class="col-2 text-nowrap" title="{{ frm.item__name }}">{{ frm.item__name | truncatechars:19 }}</div>
    <div class="col-1">{{ frm.item__inv_class__name }}</div>
    <div class="col-1">{{ frm.item__inv_group__name }}</div>
    <div class="col-2">{{ frm.item__cust_item_code }}</div>
    <div class="col text-right">{{ frm.total_consumed_item | floatformat:'0' | intcomma }}</div>
    {% if frm.pct_yield == "n/a" %}
    <div class="col text-right">{{ frm.pct_yield }}</div>
    {% else %}
    <div class="col text-right">{{ frm.pct_yield | floatformat:'2' | intcomma }}</div>
    {% endif %}
    {% if frm.pct_trmc == "n/a" %}
    <div class="col text-right">{{ frm.pct_trmc }}</div>
    {% else %}
    <div class="col text-right">{{ frm.pct_trmc | floatformat:'2' | intcomma }}</div>
    {% endif %}
    <div class="col text-right">{{ frm.tgt | floatformat:'2' | intcomma }}</div>
</div>
{% endfor %}
{% endif %}
<div class="row mt-3">
    <div class="col-8"></div>
    <div class="col-1 border-dark border-top text-right">{{ total_rm | floatformat:'0' | intcomma }}</div>
</div>

<div class="row ml-5">
    <div class="col-2">
        <div class="row">Avg Rate: (lbs/hr)</div>
        <div class="row">Act Rate: (lbs/hr)</div>
        <div class="row mt-3">&nbsp;</div>
        <div class="row small">&nbsp;</div>
        <div class="row">Uptime:</div>
        <div class="row">Changeover:</div>
        <div class="row">Maintenance:</div>
        <div class="row">NoManPower:</div>
        <div class="row">Color:</div>
        <div class="row">Other:</div>
    </div>
    <div class="col-1">
        <div class="row text-right">{{ job.avg_rate | intcomma}}</div>
        <div class="row text-right">{{ job.act_rate | intcomma }}</div>
        <div class="row mt-3"><span class="font-weight-bolder">Hrs.</span></div>
        <div class="row small"><span class="font-weight-bolder">--------</span></div>
        <div class="row text-right">{{ job.hrs_run | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.hrs_cln | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.hrs_mnt | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.hrs_nmp | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.hrs_clr | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.hrs_oth | floatformat:'2' }}</div>
    </div>
    <div class="col-1">
        <div class="row">&nbsp;</div>
        <div class="row">&nbsp;</div>
        <div class="row mt-3"><span class="font-weight-bolder">%</span></div>
        <div class="row small"><span class="font-weight-bolder">--------</span></div>
        <div class="row text-right">{{ job.run_pct | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.cln_pct | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.mnt_pct | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.nmp_pct | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.clr_pct | floatformat:'2' }}</div>
        <div class="row text-right">{{ job.oth_pct | floatformat:'2' }}</div>
    </div>
    <div class="col-2">
        <div class="row">&nbsp;</div>
        <div class="row">&nbsp;</div>
        <div class="row mt-3">&nbsp;</div>
        <div class="row small">&nbsp;</div>
        <div class="row">&nbsp;</div>
        <div class="row">{{ cln_code_desc }}</div>
        <div class="row">&nbsp;</div>
        <div class="row">&nbsp;</div>
        <div class="row">&nbsp;</div>
        <div class="row">&nbsp;</div>
    </div>
</div>
<div class="row mt-5 print-only">
    <hr />
    <span>Completion Report</span>
    <span>FRM-140</span>
    <span>Revision:</span>
    <span>Level:</span>
    <span>Issue Date:</span>
    <span>Approved by:</span>
    <span>Reviewed by:</span>
    <span>Retention:</span>
</div>
{% endblock content %}