{% extends "layout_report.html" %}
{% load static %}
{% load app_filters %}
{% load humanize %}
{% load tz %}
{% block content %}
    {{ block.super }}
<div class="row align-items-center">
    <div class="col-9 text-left"></div>
    <div class="col-3 text-right">
        <div class="row pb-1 no-print" id="control">
            <div class="col-4 mt-1">
                Report:
            </div>
            <div class="col-8">
                <select name="sort_by" maxlength="8" tabindex="2" class="select form-control" id="id_sort_by"> 
                    <option value="month">By Month</option>
                    <option value="line">By Line</option> 
                    <option value="line_code">By Line and Code</option> 
                    <option value="code">By Code</option>
                </select>
            </div>
        </div>
    </div>
</div>
<hr class="no-print"/>
{% if qstr.sort_by == 'line_code' %}
{% regroup changeover_list by prolog.line as line_list %}
    <div class="row justify-content-end">
        <div class="col-1"><span class="font-weight-bolder"><u>Code</u></span></div>
        <div class="col-5"><span class="font-weight-bolder"><u>Description</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Avg</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Min</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Max</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Count</u></span></div>
    </div>
    {% for line in line_list %}
    <div class="row mb-2">Line: {{ line.grouper }}</div>
    {% for code in line.list %}
    <div class="row">
        <div class="col-1">{{ code.code }}</div>
        <div class="col-5 text-nowrap">{{code.code.description }}</div>
        <div class="col text-right">{{ code.line_code_avg | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.line_code_min | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.line_code_max | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.line_code_count | floatformat:'0' | intcomma }}</div>
    </div>
{% endfor %}
    <div class="row">
        <div class="col-3"></div>
        <div class="col-3 text-nowrap">Per Line</div>
        <div class="col border-dark border-top text-right">{{ line.list.0.line_avg | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ line.list.0.line_min | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ line.list.0.line_max | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ line.list.0.line_count | floatformat:'0' | intcomma }}</div>
    </div>
{% endfor %}
    <div class="row mt-2">
        <div class="col-3"></div>
        <div class="col-3 text-nowrap">Overall</div>
        <div class="col border-dark border-top text-right">{{ overall_avg | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_min | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_max | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_count | floatformat:'0' | intcomma }}</div>
    </div>
{% elif qstr.sort_by == 'code' %}
    <div class="row justify-content-end">
        <div class="col-1"><span class="font-weight-bolder"><u>Code</u></span></div>
        <div class="col-5"><span class="font-weight-bolder"><u>Description</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Avg</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Min</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Max</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Count</u></span></div>
    </div>
    {% for code in changeover_list %}
    <div class="row">
        <div class="col-1">{{ code.code }}</div>
        <div class="col-5 text-nowrap">{{code.code.description }}</div>
        <div class="col text-right">{{ code.code_avg | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.code_min | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.code_max | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.code_count | floatformat:'0' | intcomma }}</div>
    </div>
{% endfor %}
    <div class="row mt-2">
        <div class="col-3"></div>
        <div class="col-3 text-nowrap">Overall</div>
        <div class="col border-dark border-top text-right">{{ overall_avg | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_min | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_max | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_count | floatformat:'0' | intcomma }}</div>
    </div>
{% elif qstr.sort_by == 'line' %}
    <div class="row justify-content-end">
        <div class="col-1"><span class="font-weight-bolder"><u>Line</u></span></div>
        <div class="col-5"><span class="font-weight-bolder"><u></u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Avg</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Min</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Max</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Count</u></span></div>
    </div>
    {% for code in changeover_list %}
    <div class="row">
        <div class="col-1">{{ code.prolog.line }}</div>
        <div class="col-5 text-nowrap"></div>
        <div class="col text-right">{{ code.line_avg | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.line_min | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.line_max | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.line_count | floatformat:'0' | intcomma }}</div>
    </div>
{% endfor %}
    <div class="row mt-2">
        <div class="col-3"></div>
        <div class="col-3 text-nowrap">Overall</div>
        <div class="col border-dark border-top text-right">{{ overall_avg | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_min | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_max | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_count | floatformat:'0' | intcomma }}</div>
    </div>
{% else %}
    <div class="row justify-content-end">
        <div class="col-1"><span class="font-weight-bolder"><u>Period</u></span></div>
        <div class="col-5"><span class="font-weight-bolder"><u></u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Avg</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Min</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Max</u></span></div>
        <div class="col text-right"><span class="font-weight-bolder"><u>Count</u></span></div>
    </div>
    {% for code in changeover_list %}
    <div class="row">
        <div class="col-1">{{ code.year }}/{{ code.month }}</div>
        <div class="col-5 text-nowrap"></div>
        <div class="col text-right">{{ code.month_avg | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.month_min | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.month_max | floatformat:'2' | intcomma }}</div>
        <div class="col text-right">{{ code.month_count | floatformat:'0' | intcomma }}</div>
    </div>
{% endfor %}
    <div class="row mt-2">
        <div class="col-3"></div>
        <div class="col-3 text-nowrap">Overall</div>
        <div class="col border-dark border-top text-right">{{ overall_avg | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_min | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_max | floatformat:'2' | intcomma }}</div>
        <div class="col border-dark border-top text-right">{{ overall_count | floatformat:'0' | intcomma }}</div>
    </div>
{% endif %}

{% endblock content %}
{% block body_scripts %}
    {{ block.super }}
    <script type="text/javascript" src="{% static 'informant_reports/js/filter_report.js' %}"></script>
{% endblock body_scripts %}