{% extends "base.html" %} {% block title %} » Report Runs » {{row.report_run.id}} » Row {{row.id}} {% endblock %} {% block nav %} Report Runs » {{row.report_run.id}} » Row {{row.id}} {% endblock %} {% block content %} {% set values = row.data['values'] %} {% set properties = row.data.get('properties', {}) %}
| Batch | Bill | MPAN Core | Site | Checking | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Reference | Type | kWh | Net GBP | VAT GBP | Gross GBP | Start | Finish | Import | Export | Code | Name | ||
| {% if values.batch_id != None %} {{values['batch']}} {% endif %} | {% if values.bill_id != None %} {{ values['bill-reference']}} {% endif %} | {{values['bill-type']}} | {{values['bill-kwh']}} | {{values['bill-net-gbp']}} | {{values['bill-vat-gbp']}} | {{values['bill-gross-gbp']}} | {{values['bill-start-date']}} | {{values['bill-finish-date']}} | {% if values['imp-mpan-core'] != None %} {{ values['imp-mpan-core']}} {% endif %} | {% if values['exp-mpan-core'] != None %} {{ values['exp-mpan-core']}} {% endif %} | {% if values.site_id != None %} {{ values['site-code']}} {% endif %} | {{values['site-name']}} | |
| From | To | Bills | Metered kWh | Net GBP | Virtual Net GBP | Difference GBP | Problem | Virtual Problem |
|---|---|---|---|---|---|---|---|---|
| {{values['covered-from']}} | {{values['covered-to']}} |
{% if values['covered-bills'] != None %}
|
{% if values['metered-kwh'] != None %} {{"%.0f"|format(values['metered-kwh'])}} {% endif %} | {{values['covered-net-gbp']}} | {% if values['virtual-net-gbp'] != None %} {{"%.2f"|format(values['virtual-net-gbp'])}} {% endif %} | {% if values['difference-net-gbp'] != None %} {{"%.2f"|format(values['difference-net-gbp'])}} {% endif %} | {{values['covered-problem']}} | {{values['virtual-problem']}} |
| Part | Covered | Virtual | Difference |
|---|---|---|---|
| gross | {% if 'covered-gross-gbp' in values and values['covered-gross-gbp'] is number %} {{"{:0,.2f}".format(values['covered-gross-gbp'])}} {% endif %} | {% if 'virtual-gross-gbp' in values and values['virtual-gross-gbp'] is number %} {{"{:0,.2f}".format(values['virtual-gross-gbp'])}} {% endif %} | {% if 'difference-gross-gbp' in values and values['difference-gross-gbp'] is number %} {{"{:0,.2f}".format(values['difference-gross-gbp'])}} {% endif %} |
| net | {% if 'covered-net-gbp' in values and values['covered-net-gbp'] is number %} {{"{:0,.2f}".format(values['covered-net-gbp'])}} | {% endif %}{% if 'virtual-net-gbp' in values and values['virtual-net-gbp'] is number %} {{"{:0,.2f}".format(values['virtual-net-gbp'])}} | {% endif %}{% if 'difference-net-gbp' in values and values['difference-net-gbp'] is number %} {{"{:0,.2f}".format(values['difference-net-gbp'])}} | {% endif %}
| vat | {% if 'covered-vat-gbp' in values and values['covered-vat-gbp'] is number %} {{"{:0,.2f}".format(values['covered-vat-gbp'])}} | {% endif %}{% if 'virtual-vat-gbp' in values and values['virtual-vat-gbp'] is number %} {{"{:0,.2f}".format(values['virtual-vat-gbp'])}} | {% endif %}{% if 'difference-vat-gbp' in values and values['difference-vat-gbp'] is number %} {{"{:0,.2f}".format(values['difference-vat-gbp'])}} | {% endif %}
| vat-rate | {{values['covered-vat-rate']}} | {{values['virtual-vat-rate']}} | {% if values['difference-vat-rate'] is number %} {{"{:0,.2f}".format(values['difference-vat-rate'])}} {% endif %} |
| Part | Covered | Virtual | Difference |
|---|---|---|---|
| gbp | {% for pref in ('covered-', 'virtual-', 'difference-') %}{% set k = pref + table.name + "-gbp" %} {% if k in values %} {% set val = values[k] %} {% else %} {% set val = '' %} {% endif %} {% if val is none %} {% elif val is number %} {{"{:0,.2f}".format(val)}} {% else %} {{val}} {% endif %} | {% endfor %}||
| {{part}} | {% for pref in ('covered-', 'virtual-', 'difference-') %}{% set k = pref + table.name + "-" + part %} {% if k in values %} {% set val = values[k] %} {% else %} {% set val = '' %} {% endif %} {% if val is none %} {% elif val is number %} {{"{:0,.2f}".format(val)}} {% elif (val is string) or (val is boolean) %} {{val}} {% else %} {% for v in val %} {% if v is number %} {{"{:0,.2f}".format(v)}} {% else %} {{v}} {% endif %} {% if not loop.last %} | {% endif %} {% endfor %} {% endif %} | {% endfor %}
{{raw_data}}
{% endblock %}