{% extends "layout_report.html" %}
{% load static %}
{% load app_filters %}
{% load humanize %}
{% load tz %}
{% block content %}
{{ block.super }}
{% if qstr.sort_by == 'detail' %}
Item
Receiver
Lot
Qty
Staged
Date
Staged
Qty*
Available
{% regroup txn_list by receiver.item as item_list %}
{% for item in item_list %}
Customer:
{{ item.list.0.receiver.customer }}
Item:
{{ item.list.0.receiver.item.name }}
Total Staged:
{{ item.list.0.total_staged_item }} lbs.
{% regroup item.list by job as job_list %}
{% for job in job_list %}
Reference:
{{ job.grouper }}
Line:
{{ job.list.0.line }}
Qty Req:
{{ job.list.0.job_qty_req | floatformat:'0' | intcomma }}
Staged:
{{ job.list.0.total_staged_job | floatformat:'0' | intcomma }}
Status:
{{ job.list.0.job_status }}
Job Start:
{{ job.list.0.job_start }}
Job Complete:
{{ job.list.0.job_complete }}
{% for txn in job.list %}
{{ txn.receiver.item }}
{{ txn.receiver }}
{{ txn.receiver.lot }}
{{ txn.consumed | floatformat:'0' | intcomma }}
{{ txn.transaction_date }}
{{ txn.receiver.qty_on_hand | floatformat:'0' | intcomma }}
{% endfor %}
{% if forloop.last %}{% endif %}
{% endfor %}
{% endfor %}
{% else %}
{% regroup txn_list by receiver.inv_class as class_list %}
{% for inv_class in class_list %}
Class:
{{ inv_class.grouper }}
{% regroup inv_class.list by line as line_list%}
{% for line in line_list %}
{% regroup line.list by job_status as status_list %}
{% for status in status_list %}
{{ status.list.0.line }}
{{ status.list.0.job_status }}
{{ status.list.0.total_staged_status | floatformat:'0' | intcomma }}
{% endfor %}
Line Total:
{{ line.list.0.total_staged_line | floatformat:'0' | intcomma }}
{% endfor %}
Class Total:
{{ inv_class.list.0.total_staged_class | floatformat:'0' | intcomma }}
{% endfor %}
Overall Staged Total:
{{ total | floatformat:'0' | intcomma }}
{% endif %}
{% endblock content %}
{% block body_scripts %}
{{ block.super }}
{% endblock body_scripts %}