{% extends "base.html" %} {% block inside_head %} {% endblock %} {% 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 | Site | MPRN | Covered Bills | Covered Start | Covered Finish | Problem | |
---|---|---|---|---|---|---|---|
{{values.batch}} | {{values.site_code}} {{values.site_name}} | {{values.mprn}} | {% if values['covered_bill_ids'] is not none %} {% for bill_id in values['covered_bill_ids'] %} {{bill_id}} {% if bill_id == values.g_bill_id %} {% endif %} {% endfor %} {% endif %} | {{values.covered_start[:10]}} | {{values.covered_finish[:10]}} | {% for title in columns %}{% if title in values and values[title] is not none %} {{"%.2f"|format(values[title])}} {% endif %} | {% endfor %}{{ values.covered_problem }} {{ values.virtual_problem }} |
Part | Covered | Virtual | Difference |
---|---|---|---|
gross | {{"{:0,.2f}".format(values.covered_gross_gbp)}} | {{"{:0,.2f}".format(values.virtual_gross_gbp)}} | {{"{:0,.2f}".format(values.difference_gross_gbp)}} |
net | {{"{:0,.2f}".format(values.covered_net_gbp)}} | {{"{:0,.2f}".format(values.virtual_net_gbp)}} | {{"{:0,.2f}".format(values.difference_net_gbp)}} |
vat | {{"{:0,.2f}".format(values.covered_vat_gbp)}} | {{"{:0,.2f}".format(values.virtual_vat_gbp)}} | {{"{:0,.2f}".format(values.difference_vat_gbp)}} |
vat_rate | {{values.covered_vat_rate}} | {{values.virtual_vat_rate}} | {{"{:0,.2f}".format(values.difference_vat_rate)}} |
is_commercial | {{values.covered_is_commercial}} | {{values.virtual_is_commercial}} | {{values.difference_is_commercial}} |
Part | Covered | Virtual | Difference |
---|---|---|---|
kwh | {{"{:0,.2f}".format(values.covered_kwh)}} | {{"{:0,.2f}".format(values.virtual_kwh)}} | {{"{:0,.2f}".format(values.difference_kwh)}} |
units_consumed | {% if 'covered_units_consumed' in values %} {{"{:0,.2f}".format(values.covered_units_consumed)}} {% endif %} | {{"{:0,.2f}".format(values.virtual_units_consumed)}} | {{"{:0,.2f}".format(values.difference_units_consumed)}} |
correction_factor | {% if values.covered_correction_factor is number %} {{"{:0,.2f}".format(values.covered_correction_factor)}} {% else %} {{values.covered_correction_factor|join(' | ')}} {% endif %} | {% if values.virtual_correction_factor is number %} {{"{:0,.2f}".format(values.virtual_correction_factor)}} {% else %} {{values.virtual_correction_factor|join(' | ')}} {% endif %} | {% if values.difference_correction_factor is number %} {{"{:0,.2f}".format(values.difference_correction_factor)}} | {% else %} {{values.difference_correction_factor|join(' | ')}} {% endif %}
unit_code | {{values.covered_unit_code|join(' | ')}} | {{values.virtual_unit_code|join(' | ')}} | {{values.difference_unit_code}} |
calorific_value | {{values.covered_calorific_value|join(' | ')}} | {{values.virtual_calorific_value|join(' | ')}} | {{values.difference_calorific_value}} |
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 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 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 %}