{% extends "base.html" %}

{% block title %}
	» Report Runs » {{run.id}}
{% endblock %}

{% block nav %}
	<a href="/report_runs">Report Runs</a> &raquo; {{run.id}}
{% endblock %}

{% block content %}
	<table>
		<caption>Bill Check</caption>
		<thead>
			<tr>
				<th>Date Created</th>
				<th>Created By</th>
				<th>Title</th>
				<th>State</th>
				<th>Number Of Rows</th>
				<th>Delete</th>
				<th>Download Spreadsheet</th>
			</tr>
		</thead>
		<tbody>
			<tr>
				<td>{{run.date_created|date_format}}</td>
				<td>{{run.creator}}</td>
				<td>{{run.title}}</td>
				<td>{{run.state}}</td>
				<td>{{rows|length}} (truncated at {{ROW_LIMIT}})</td>
				<td>
					<form hx-delete="/report_runs/{{run.id}}"
							hx-confirm="Are you sure you want to delete this report run?">
						<fieldset style="border: none;">
							<input type="submit" name="delete" value="Delete">
						</fieldset>
					</form>
				</td>
				<td><a href="/report_runs/{{run.id}}/spreadsheet">Download</a></td>
			</tr>
		</tbody>
	</table>

	<table class="sticky">
		<caption>Bill Level</caption>
		<thead>
			<tr>
				<th>Bill</th>
				<th>Contract</th>
				<th>Supply</th>
				<th>Import MPAN Core</th>
				<th>Export MPAN Core</th>
				<th>Site</th>
				<th>Issues</th>
				<th>Start</th>
				<th>Finish</th>
				<th>Problem</th>
			</tr>
		</thead>
		<tbody>
			{% for row_bundle in bill_row_bundles %}
				{% set row = row_bundle['row'] %}
				{% set data = row.data['data'] %}
				{% set properties = row.data.get('properties', {}) %}
				{% set market_role_code = data['market_role_code'] %}
				<tr>
					<td>
						{% if market_role_code == 'X' %}
							<a href="/e/supplier_bills/{{data['id']}}">View</a>
						{% elif market_role_code in DC_MARKET_ROLE_CODES %}
							<a href="/e/dc_bills/{{data['id']}}">View</a>
						{% elif market_role_code == MOP_MARKET_ROLE_CODES %}
							<a href="/e/mop_bills/{{data['id']}}">View</a>
						{% endif %}
					</td>
					<td style="white-space: nowrap">
						{% if market_role_code == 'X' %}
							<a href="/e/supplier_contracts/{{data['contract_id']}}">{{data['contract_name']}}</a>
						{% elif market_role_code in DC_MARKET_ROLE_CODES %}
							<a href="/e/dc_contracts/{{data['contract_id']}}">{{data['contract_name']}}</a>
						{% elif market_role_code == MOP_MARKET_ROLE_CODES %}
							<a href="/e/mop_contracts/{{data['contract_id']}}">{{data['contract_name']}}</a>
						{% endif %}
					</td>
					<td>
						<a href="/e/supplies/{{data['supply_id']}}">View</a>
					</td>
					<td style="white-space: nowrap">
						{% if data['imp_mpan_core'] is not none %}
							{{data['imp_mpan_core']}}
						{% endif %}
					</td>
					<td style="white-space: nowrap">
						{% if data['exp_mpan_core'] is not none %}
							{{data['exp_mpan_core']}}
						{% endif %}
					</td>
					<td style="white-space: nowrap">
						{% if data['site_id'] is not none %}
						  <a href="/sites/{{data['site_id']}}" title="{{data.site_name}}">{{data.site_code}}</a>
						{% endif %}
					</td>
					<td style="white-space: nowrap">
						{% if row_bundle['issues']|length > 0 %}
							<ul>
								{% for issue in row_bundle['issues'] %}
									<li>
										{% if issue.contract.party.market_role.code == 'X' %}
											<a href="/e/supplier_issues/{{issue.id}}">Supplier:
												{{issue.id}} {{issue.properties['subject']}}</a>
										{% elif issue.contract.party.market_role.code in DC_MARKET_ROLE_CODES %}
											<a href="/e/dc_issues/{{issue.id}}">DC:
												{{issue.id}} {{issue.properties['subject']}}</a>
										{% else %}
											<a href="/e/mop_issues/{{issue.id}}">MOP:
												{{issue.id}} {{issue.properties['subject']}}</a>
										{% endif %}
									</li>
								{% endfor %}
							</ul>
						{% endif %}
					</td>
					<td style="white-space: nowrap">
					 {{data['start_date']}}
					</td>
					<td style="white-space: nowrap">
					 {{data['finish_date']}}
					</td>
					<td style="text-align: right;">
					  {{data['problem']}}
					</td>
				</tr>
			{% endfor %}
		</tbody>
	</table>

	<table class="sticky">
		<caption>Element Level</caption>
		<thead>
			<tr>
				<th>View</th>
				<th>Contract</th>
				<th>Supply</th>
				<th>Import MPAN Core</th>
				<th>Export MPAN Core</th>
				<th>Site</th>
				<th>Issues</th>
				<th>Period Start</th>
				<th>Period Finish</th>
				<th>Element Name</th>
				<th>Problem</th>
				<th>Difference GBP</th>
				<th>Actual GBP</th>
				<th>Virtual GBP</th>
			</tr>
		</thead>
		<tbody>
			{% for row_bundle in element_row_bundles %}
				{% set row = row_bundle['row'] %}
				{% set data = row.data['data'] %}
				{% set properties = row.data.get('properties', {}) %}
				{% set market_role_code = data['market_role_code'] %}
				<tr>
					<td><a href="/report_run_rows/{{row.id}}">View</a></td>
					<td style="white-space: nowrap">
						{% if market_role_code == 'X' %}
							<a href="/e/supplier_contracts/{{data['contract_id']}}">{{data['contract_name']}}</a>
						{% elif market_role_code in DC_MARKET_ROLE_CODES %}
							<a href="/e/dc_contracts/{{data['contract_id']}}">{{data['contract_name']}}</a>
						{% elif market_role_code == MOP_MARKET_ROLE_CODES %}
							<a href="/e/mop_contracts/{{data['contract_id']}}">{{data['contract_name']}}</a>
						{% endif %}
					</td>
					<td>
						<a href="/e/supplies/{{data['supply_id']}}">View</a>
					</td>
					<td style="white-space: nowrap">
						{% if data['imp_mpan_core'] is not none %}
							{{data['imp_mpan_core']}}
						{% endif %}
					</td>
					<td style="white-space: nowrap">
						{% if data['exp_mpan_core'] is not none %}
							{{data['exp_mpan_core']}}
						{% endif %}
					</td>
					<td style="white-space: nowrap">
						{% if data['site_id'] is not none %}
						  <a href="/sites/{{data['site_id']}}" title="{{data.site_name}}">{{data.site_code}}</a>
						{% endif %}
					</td>
					<td style="white-space: nowrap">
						{% if row_bundle['issues']|length > 0 %}
							<ul>
								{% for issue in row_bundle['issues'] %}
									<li>
										{% if issue.contract.party.market_role.code == 'X' %}
											<a href="/e/supplier_issues/{{issue.id}}">Supplier:
												{{issue.id}} {{issue.properties['subject']}}</a>
										{% elif issue.contract.party.market_role.code in DC_MARKET_ROLE_CODES %}
											<a href="/e/dc_issues/{{issue.id}}">DC:
												{{issue.id}} {{issue.properties['subject']}}</a>
										{% else %}
											<a href="/e/mop_issues/{{issue.id}}">MOP:
												{{issue.id}} {{issue.properties['subject']}}</a>
										{% endif %}
									</li>
								{% endfor %}
							</ul>
						{% endif %}
					</td>
					<td style="white-space: nowrap">
					 {{data['period_start']}}
					</td>
					<td style="white-space: nowrap">
					 {{data['period_finish']}}
					</td>
					<td>{{data['element_name']}}</td>
					<td style="text-align: right;">
					  {{data['problem']}}
					</td>
					<td style="text-align: right;">
					  {{"{:0,.2f}".format(data['parts']['gbp']['difference'])}}
					</td>
					<td style="text-align: right;">
					  {{data['parts']['gbp']['actual_str']}}
					</td>
					<td style="text-align: right;">
					  {{data['parts']['gbp']['virtual_str']}}
					</td>
				</tr>
			{% endfor %}
		</tbody>
	</table>
{% endblock %}