{% 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', {}) %}
Bill Check
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']}}
{{input_textarea( 'note', properties.note, 5, 40, placeholder='Notes on checking go here...')}}

Covered
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 %}
    {% for bill_id in values['covered-bills'] %}
  • {{bill_id}} {% if bill_id == values.bill_id %} (This bill) {% endif %}
  • {% endfor %}
{% endif %}
{% 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']}}
{% endif %} {% endif %} {% endif %} {% endif %} {% endif %} {% endif %}
GBP
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'])}} {% if 'virtual-net-gbp' in values and values['virtual-net-gbp'] is number %} {{"{:0,.2f}".format(values['virtual-net-gbp'])}} {% if 'difference-net-gbp' in values and values['difference-net-gbp'] is number %} {{"{:0,.2f}".format(values['difference-net-gbp'])}}
vat {% if 'covered-vat-gbp' in values and values['covered-vat-gbp'] is number %} {{"{:0,.2f}".format(values['covered-vat-gbp'])}} {% if 'virtual-vat-gbp' in values and values['virtual-vat-gbp'] is number %} {{"{:0,.2f}".format(values['virtual-vat-gbp'])}} {% if 'difference-vat-gbp' in values and values['difference-vat-gbp'] is number %} {{"{:0,.2f}".format(values['difference-vat-gbp'])}}
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 %}
{% for table in tables %} {% for pref in ('covered-', 'virtual-', 'difference-') %} {% endfor %} {% for part in table['parts']|sort %} {% for pref in ('covered-', 'virtual-', 'difference-') %} {% endfor %} {% endfor %}
{{table.name}}
Part Covered Virtual Difference
gbp {% 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 %}
{{part}} {% 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

{{raw_data}}
{% endblock %}