{% extends "layout_report.html" %} {% load static %} {% load app_filters %} {% load humanize %} {% load tz %} {% block content %} {{ block.super }}
Report:

{% if qstr.sort_by == 'product' %}

Product

#Jobs
Prime/QQ
(lbs)/(%)
Off Spec
(lbs)/(%)
Loss ID
(lbs)/(%)
Consumed
(lbs)
UnID Losses
(lbs)/(%)
1st Pass
Yield (%)
RWProd
(lbs)
RWEnd
(lbs)
Send
(lbs)
{% for job in job_list %}
{{ job.product }}
{{ job.num_jobs | floatformat:'0' }}
{{ job.tprd | floatformat:'0' | intcomma }}/
{{ job.pct_prime | floatformat:'1' }}%
{{ job.offspec | floatformat:'0' | intcomma }}/
{{ job.pct_offspec | floatformat:'1' }}%
{{ job.lossid | floatformat:'0' | intcomma }}/
{{ job.pct_lossid | floatformat:'1' }}%
{{ job.consumed | floatformat:'0' | intcomma }}
{{ job.unid_losses | floatformat:'0' | intcomma }}/
{{ job.pct_unid_losses | floatformat:'1' }}%
{{ job.pct_1st | floatformat:'1' }}%
{{ job.ncmrwprod | floatformat:'0' | intcomma }}
{{ job.ncmrwend | floatformat:'0' | intcomma }}
{{ job.ncmse | floatformat:'0' | intcomma }}
{% endfor %}
{% subtotal job_list "tprd" 0 %}/
{% sub_pct job_list "tprd" "consumed" 1 %}%
{% subtotal job_list "offspec" 0 %}/
{% sub_pct job_list "offspec" "consumed" 1 %}%
{% subtotal job_list "lossid" 0 %}/
{% sub_pct job_list "lossid" "consumed" 1 %}%
{% subtotal job_list "consumed" 0 %}
{% subtotal job_list "unid_losses" 0 %}/
{% sub_pct job_list "unid_losses" "consumed" 1 %}%
{% sub_pct2 job_list "tprd" "ncmrwcons" "consumed" 1 %}%
{% subtotal job_list "ncmrwprod" 0 %}
{% subtotal job_list "ncmrwend" 0 %}
{% subtotal job_list "ncmse" 0 %}
{% elif qstr.sort_by == 'job' %}

Product

Job

Line
Complete
Date
Prime/QQ
(lbs)/(%)
Off Spec
(lbs)/(%)
Loss ID
(lbs)/(%)
Consumed
(lbs)
UnID Losses
(lbs)/(%)
1st Pass
Yield (%)
RWProd
(lbs)
RWEnd
(lbs)
Send
(lbs)
{% regroup job_list by product as product_list %} {% for product in product_list %}
{{ product.grouper }}
{% for job in product.list %}
{{ job.job }}
{{ job.line }}
{{ job.job_complete | date:"m/d/y" }}
{{ job.tprd_job | floatformat:'0' | intcomma }}/
{{ job.pct_tprd_job | floatformat:'1' }}%
{{ job.offspec_job | floatformat:'0' | intcomma }}/
{{ job.pct_offspec_job | floatformat:'1' }}%
{{ job.lossid_job | floatformat:'0' | intcomma }}/
{{ job.pct_lossid_job | floatformat:'1' }}%
{{ job.consumed_job | floatformat:'0' | intcomma }}
{{ job.unid_losses_job | floatformat:'0' | intcomma }}/
{{ job.pct_unid_losses_job | floatformat:'1' }}%
{{ job.pct_1st_job | floatformat:'1' }}%
{{ job.ncmrwprod_job | floatformat:'0' | intcomma }}
{{ job.ncmrwend_job | floatformat:'0' | intcomma }}
{{ job.ncmse_job | floatformat:'0' | intcomma }}
{% endfor %}
{% subtotal product.list "tprd_job" 0 %}/
{% sub_pct product.list "tprd_job" "consumed_job" 1 %}%
{% subtotal product.list "offspec_job" 0 %}/
{% sub_pct product.list "offspec_job" "consumed_job" 1 %}%
{% subtotal product.list "lossid_job" 0 %}/
{% sub_pct product.list "lossid_job" "consumed_job" 1 %}%
{% subtotal product.list "consumed_job" 0 %}
{% subtotal product.list "unid_losses_job" 0 %}/
{% sub_pct product.list "unid_losses_job" "consumed_job" 1 %}%
{% sub_pct2 product.list "tprd_job" "ncmrwcons_job" "consumed_job" 1 %}%
{% subtotal product.list "ncmrwprod_job" 0 %}
{% subtotal product.list "ncmrwend_job" 0 %}
{% subtotal product.list "ncmse_job" 0 %}
{% endfor %}
{% subtotal job_list "tprd_job" 0 %}/
{% sub_pct job_list "tprd_job" "consumed_job" 1 %}%
{% subtotal job_list "offspec_job" 0 %}/
{% sub_pct job_list "offspec_job" "consumed_job" 1 %}%
{% subtotal job_list "lossid_job" 0 %}/
{% sub_pct job_list "lossid_job" "consumed_job" 1 %}%
{% subtotal job_list "consumed_job" 0 %}
{% subtotal job_list "unid_losses_job" 0 %}/
{% sub_pct job_list "unid_losses_job" "consumed_job" 1 %}%
{% sub_pct2 job_list "tprd_job" "ncmrwcons_job" "consumed_job" 1 %}%
{% subtotal job_list "ncmrwprod_job" 0 %}
{% subtotal job_list "ncmrwend_job" 0 %}
{% subtotal job_list "ncmse_job" 0 %}
{% elif qstr.sort_by == 'month' %}

Month

#Jobs
Prime/QQ
(lbs)/(%)
Off Spec
(lbs)/(%)
Loss ID
(lbs)/(%)
Consumed
(lbs)
UnID Losses
(lbs)/(%)
1st Pass
Yield (%)
RWProd
(lbs)
RWEnd
(lbs)
Send
(lbs)
{% for job in job_list %}
{{ job.year }}/ {{ job.month }}
{{ job.num_jobs | floatformat:'0' }}
{{ job.tprd | floatformat:'0' | intcomma }}/
{{ job.pct_prime | floatformat:'1' }}%
{{ job.offspec | floatformat:'0' | intcomma }}/
{{ job.pct_offspec | floatformat:'1' }}%
{{ job.lossid | floatformat:'0' | intcomma }}/
{{ job.pct_lossid | floatformat:'1' }}%
{{ job.consumed | floatformat:'0' | intcomma }}
{{ job.unid_losses | floatformat:'0' | intcomma }}/
{{ job.pct_unid_losses | floatformat:'1' }}%
{{ job.pct_1st | floatformat:'1' }}%
{{ job.ncmrwprod | floatformat:'0' | intcomma }}
{{ job.ncmrwend | floatformat:'0' | intcomma }}
{{ job.ncmse | floatformat:'0' | intcomma }}
{% endfor %}
{% subtotal job_list "tprd" 0 %}/
{% sub_pct job_list "tprd" "consumed" 1 %}%
{% subtotal job_list "offspec" 0 %}/
{% sub_pct job_list "offspec" "consumed" 1 %}%
{% subtotal job_list "lossid" 0 %}/
{% sub_pct job_list "lossid" "consumed" 1 %}%
{% subtotal job_list "consumed" 0 %}
{% subtotal job_list "unid_losses" 0 %}/
{% sub_pct job_list "unid_losses" "consumed" 1 %}%
{% sub_pct2 job_list "tprd" "ncmrwcons" "consumed" 1 %}%
{% subtotal job_list "ncmrwprod" 0 %}
{% subtotal job_list "ncmrwend" 0 %}
{% subtotal job_list "ncmse" 0 %}
{% elif qstr.sort_by == 'line_month' %}

Line

Month
Prime/QQ
(lbs)/(%)
Off Spec
(lbs)/(%)
Loss ID
(lbs)/(%)
Consumed
(lbs)
UnID Losses
(lbs)/(%)
1st Pass
Yield (%)
RWProd
(lbs)
RWEnd
(lbs)
Send
(lbs)
{% regroup job_list by line as line_list %} {% for line in line_list %}
{{ line.grouper }}
{% for job in line.list %}
{{ job.year }}/ {{ job.month }}
{{ job.tprd_job | floatformat:'0' | intcomma }}/
{{ job.pct_tprd_job | floatformat:'1' }}%
{{ job.offspec_job | floatformat:'0' | intcomma }}/
{{ job.pct_offspec_job | floatformat:'1' }}%
{{ job.lossid_job | floatformat:'0' | intcomma }}/
{{ job.pct_lossid_job | floatformat:'1' }}%
{{ job.consumed_job | floatformat:'0' | intcomma }}
{{ job.unid_losses_job | floatformat:'0' | intcomma }}/
{{ job.pct_unid_losses_job | floatformat:'1' }}%
{{ job.pct_1st_job | floatformat:'1' }}%
{{ job.ncmrwprod_job | floatformat:'0' | intcomma }}
{{ job.ncmrwend_job | floatformat:'0' | intcomma }}
{{ job.ncmse_job | floatformat:'0' | intcomma }}
{% endfor %}
{% subtotal line.list "tprd_job" 0 %}/
{% sub_pct line.list "tprd_job" "consumed_job" 1 %}%
{% subtotal line.list "offspec_job" 0 %}/
{% sub_pct line.list "offspec_job" "consumed_job" 1 %}%
{% subtotal line.list "lossid_job" 0 %}/
{% sub_pct line.list "lossid_job" "consumed_job" 1 %}%
{% subtotal line.list "consumed_job" 0 %}
{% subtotal line.list "unid_losses_job" 0 %}/
{% sub_pct line.list "unid_losses_job" "consumed_job" 1 %}%
{% sub_pct2 line.list "tprd_job" "ncmrwcons_job" "consumed_job" 1 %}%
{% subtotal line.list "ncmrwprod_job" 0 %}
{% subtotal line.list "ncmrwend_job" 0 %}
{% subtotal line.list "ncmse_job" 0 %}
{% endfor %}
{% subtotal job_list "tprd_job" 0 %}/
{% sub_pct job_list "tprd_job" "consumed_job" 1 %}%
{% subtotal job_list "offspec_job" 0 %}/
{% sub_pct job_list "offspec_job" "consumed_job" 1 %}%
{% subtotal job_list "lossid_job" 0 %}/
{% sub_pct job_list "lossid_job" "consumed_job" 1 %}%
{% subtotal job_list "consumed_job" 0 %}
{% subtotal job_list "unid_losses_job" 0 %}/
{% sub_pct job_list "unid_losses_job" "consumed_job" 1 %}%
{% sub_pct2 job_list "tprd_job" "ncmrwcons_job" "consumed_job" 1 %}%
{% subtotal job_list "ncmrwprod_job" 0 %}
{% subtotal job_list "ncmrwend_job" 0 %}
{% subtotal job_list "ncmse_job" 0 %}
{% elif qstr.sort_by == 'line_job' %}

Line

Job

Product
Complete
Date
Prime/QQ
(lbs)/(%)
Off Spec
(lbs)/(%)
Loss ID
(lbs)/(%)
Consumed
(lbs)
UnID Losses
(lbs)/(%)
1st Pass
Yield (%)
RWProd
(lbs)
RWEnd
(lbs)
Send
(lbs)
{% regroup job_list by line as line_list %} {% for line in line_list %}
{{ line.grouper }}
{% for job in line.list %}
{{ job.job }}
{{ job.product }}
{{ job.job_complete | date:"m/d/y" }}
{{ job.tprd_job | floatformat:'0' | intcomma }}/
{{ job.pct_tprd_job | floatformat:'1' }}%
{{ job.offspec_job | floatformat:'0' | intcomma }}/
{{ job.pct_offspec_job | floatformat:'1' }}%
{{ job.lossid_job | floatformat:'0' | intcomma }}/
{{ job.pct_lossid_job | floatformat:'1' }}%
{{ job.consumed_job | floatformat:'0' | intcomma }}
{{ job.unid_losses_job | floatformat:'0' | intcomma }}/
{{ job.pct_unid_losses_job | floatformat:'1' }}%
{{ job.pct_1st_job | floatformat:'1' }}%
{{ job.ncmrwprod_job | floatformat:'0' | intcomma }}
{{ job.ncmrwend_job | floatformat:'0' | intcomma }}
{{ job.ncmse_job | floatformat:'0' | intcomma }}
{% endfor %}
{% subtotal line.list "tprd_job" 0 %}/
{% sub_pct line.list "tprd_job" "consumed_job" 1 %}%
{% subtotal line.list "offspec_job" 0 %}/
{% sub_pct line.list "offspec_job" "consumed_job" 1 %}%
{% subtotal line.list "lossid_job" 0 %}/
{% sub_pct line.list "lossid_job" "consumed_job" 1 %}%
{% subtotal line.list "consumed_job" 0 %}
{% subtotal line.list "unid_losses_job" 0 %}/
{% sub_pct line.list "unid_losses_job" "consumed_job" 1 %}%
{% sub_pct2 line.list "tprd_job" "ncmrwcons_job" "consumed_job" 1 %}%
{% subtotal line.list "ncmrwprod_job" 0 %}
{% subtotal line.list "ncmrwend_job" 0 %}
{% subtotal line.list "ncmse_job" 0 %}
{% endfor %}
{% subtotal job_list "tprd_job" 0 %}/
{% sub_pct job_list "tprd_job" "consumed_job" 1 %}%
{% subtotal job_list "offspec_job" 0 %}/
{% sub_pct job_list "offspec_job" "consumed_job" 1 %}%
{% subtotal job_list "lossid_job" 0 %}/
{% sub_pct job_list "lossid_job" "consumed_job" 1 %}%
{% subtotal job_list "consumed_job" 0 %}
{% subtotal job_list "unid_losses_job" 0 %}/
{% sub_pct job_list "unid_losses_job" "consumed_job" 1 %}%
{% sub_pct2 job_list "tprd_job" "ncmrwcons_job" "consumed_job" 1 %}%
{% subtotal job_list "ncmrwprod_job" 0 %}
{% subtotal job_list "ncmrwend_job" 0 %}
{% subtotal job_list "ncmse_job" 0 %}
{% elif qstr.sort_by == 'run' %}

Line

Job

Product
Complete
Date
Prime/QQ
(lbs)/(%)
Off Spec
(lbs)/(%)
Loss ID
(lbs)/(%)
Consumed
(lbs)
UnID Losses
(lbs)/(%)
1st Pass
Yield (%)
RWProd
(lbs)
RWEnd
(lbs)
Send
(lbs)
{% regroup job_list by range as range_list %} {% for range in range_list %} {% for job in range.list %}
{{ job.line }}
{{ job.job }}
{{ job.product }}
{{ job.job_complete | date:"m/d/y" }}
{{ job.tprd_job | floatformat:'0' | intcomma }}/
{{ job.pct_tprd_job | floatformat:'1' }}%
{{ job.offspec_job | floatformat:'0' | intcomma }}/
{{ job.pct_offspec_job | floatformat:'1' }}%
{{ job.lossid_job | floatformat:'0' | intcomma }}/
{{ job.pct_lossid_job | floatformat:'1' }}%
{{ job.consumed_job | floatformat:'0' | intcomma }}
{{ job.unid_losses_job | floatformat:'0' | intcomma }}/
{{ job.pct_unid_losses_job | floatformat:'1' }}%
{{ job.pct_1st_job | floatformat:'1' }}%
{{ job.ncmrwprod_job | floatformat:'0' | intcomma }}
{{ job.ncmrwend_job | floatformat:'0' | intcomma }}
{{ job.ncmse_job | floatformat:'0' | intcomma }}
{% endfor %}
Run Size
{{ range.list.0.qty_prod_avg | floatformat:'0' | intcomma}}
{% subtotal range.list "tprd_job" 0 %}/
{% sub_pct range.list "tprd_job" "consumed_job" 1 %}%
{% subtotal range.list "offspec_job" 0 %}/
{% sub_pct range.list "offspec_job" "consumed_job" 1 %}%
{% subtotal range.list "lossid_job" 0 %}/
{% sub_pct range.list "lossid_job" "consumed_job" 1 %}%
{% subtotal range.list "consumed_job" 0 %}
{% subtotal range.list "unid_losses_job" 0 %}/
{% sub_pct range.list "unid_losses_job" "consumed_job" 1 %}%
{% sub_pct2 range.list "tprd_job" "ncmrwcons_job" "consumed_job" 1 %}%
{% subtotal range.list "ncmrwprod_job" 0 %}
{% subtotal range.list "ncmrwend_job" 0 %}
{% subtotal range.list "ncmse_job" 0 %}
{% endfor %}
{% subtotal job_list "tprd_job" 0 %}/
{% sub_pct job_list "tprd_job" "consumed_job" 1 %}%
{% subtotal job_list "offspec_job" 0 %}/
{% sub_pct job_list "offspec_job" "consumed_job" 1 %}%
{% subtotal job_list "lossid_job" 0 %}/
{% sub_pct job_list "lossid_job" "consumed_job" 1 %}%
{% subtotal job_list "consumed_job" 0 %}
{% subtotal job_list "unid_losses_job" 0 %}/
{% sub_pct job_list "unid_losses_job" "consumed_job" 1 %}%
{% sub_pct2 job_list "tprd_job" "ncmrwcons_job" "consumed_job" 1 %}%
{% subtotal job_list "ncmrwprod_job" 0 %}
{% subtotal job_list "ncmrwend_job" 0 %}
{% subtotal job_list "ncmse_job" 0 %}
{% else %}

Invalid Report Type

{% endif %} {% endblock content %} {% block body_scripts %} {{ block.super }} {% endblock body_scripts %}