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

<div class="row">
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Job</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Status</u></span></div>
    <div class="col-2 pl-0 pr-0"><span class="font-weight-bolder"><u>Product</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Lot</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Originated</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Started</u></span></div>
    <div class="col pl-0 pr-0"><span class="font-weight-bolder"><u>Completed</u></span></div>
    <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Qty Sch</u></span></div>
    <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Qty Prod</u></span></div>
    <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Yield%</u></span></div>
    <div class="col pl-0 pr-0 text-right"><span class="font-weight-bolder"><u>Rate</u></span></div>
</div>
{% regroup job_list by customer as customer_list %}
    {% for customer in customer_list %}
        <div class="row mt-2 mb-3"><u>Customer: {{ customer.grouper }}</u></div>
        {% for job in customer.list %}
        <div class="row">
            <div class="col pl-0 pr-0">{{ job.job }}</div>
            <div class="col pl-0 pr-0">{{ job.status }}</div>
            <div class="col-2 pl-0 pr-0">{{ job.product }}</div>
            <div class="col pl-0 pr-0">{{ job.lot }}</div>
            <div class="col pl-0 pr-0">{{ job.date_originated|date:"m/d/y" }}</div>
            <div class="col pl-0 pr-0">{{ job.job_start|date:"m/d/y" }}</div>
            <div class="col pl-0 pr-0">{{ job.job_complete|date:"m/d/y" }}</div>
            <div class="col pl-0 pr-0 text-right">{{ job.qty_ordered | floatformat:'0' | intcomma }}</div>
            <div class="col pl-0 pr-0 text-right">{{ job.qty_produced | floatformat:'0' | intcomma }}</div>
            <div class="col pl-0 pr-0 text-right">{{ job.yield_pct | floatformat:'2' }}</div>
            <div class="col pl-0 pr-0 text-right">{{ job.avg_rate | floatformat:'0' | intcomma }}</div>
        </div>
        {% endfor %}
    {% endfor %}

{% endblock content %}