{% extends "base.html" %}
{% from "_recon_table.html" import render_table, drill_table, drill_table2 %}
{% block title %}Reconciliation — RWA Calculator{% endblock %}

{% block content %}
<h1>Parallel-run reconciliation</h1>
<p class="muted">Run this calculator and reconcile its output against your legacy
calculator, component by component (EAD, RWA, risk weight, PD, LGD, CCF, exposure
class, …). Each row is bucketed as match / within-tolerance / break / missing, with
our reason and input drivers attached so a break can be triaged to a data fix or an
engine fix.</p>

{% if error %}<div class="callout error">Reconciliation failed: {{ error }}</div>{% endif %}

<form class="form" method="post" action="/reconciliation">
  <div class="field">
    <label for="data_path">Our data path</label>
    <input id="data_path" name="data_path" value="{{ default_path }}" placeholder="/path/to/data" required>
  </div>
  <div class="field-row">
    <div class="field">
      <label for="framework">Framework</label>
      <select id="framework" name="framework">
        {% for fw in frameworks %}<option value="{{ fw.id }}"{% if fw.id == selected_framework %} selected{% endif %}>{{ fw.name }}</option>{% endfor %}
      </select>
    </div>
    <div class="field">
      <label for="permission_mode">Permission mode</label>
      <select id="permission_mode" name="permission_mode">
        <option value="standardised"{% if selected_permission == "standardised" %} selected{% endif %}>Standardised (all SA)</option>
        <option value="irb"{% if selected_permission == "irb" %} selected{% endif %}>IRB (model permissions)</option>
      </select>
    </div>
    <div class="field">
      <label for="data_format">Data format</label>
      <select id="data_format" name="data_format">
        <option value="parquet"{% if selected_format == "parquet" %} selected{% endif %}>parquet</option>
        <option value="csv"{% if selected_format == "csv" %} selected{% endif %}>csv</option>
      </select>
    </div>
    <div class="field">
      <label for="reporting_date">Reporting date</label>
      <input id="reporting_date" name="reporting_date" type="date" value="{{ default_date }}" required>
    </div>
  </div>
  {% if reusable_run %}
  <div class="callout info">
    <label for="reuse_calculation">
      <input id="reuse_calculation" type="checkbox" name="reuse_calculation" value="1" checked>
      Use results from the calculation completed at {{ reusable_run.completed_at }} —
      the engine run is skipped and the reconciliation starts from its cached results.
      Untick to recompute from the source data.
    </label>
  </div>
  {% elif data_changed %}
  <div class="callout info">Input data has changed since the last matching calculation —
  it will be recomputed.</div>
  {% endif %}
  <div class="field">
    <label for="mapping_toml">Legacy mapping (TOML)</label>
    <textarea id="mapping_toml" name="mapping_toml" class="mono" rows="16" spellcheck="false">{{ mapping_toml }}</textarea>
    <p class="muted">Declare the join key(s) and which legacy column maps to each canonical
    component. <code>legacy_file</code> resolves relative to the data path above; numeric
    components accept <code>scale</code> and <code>unit = "percent"</code>, categoricals a
    <code>value_map</code> of synonyms.</p>
  </div>
  <div class="form-actions">
    <button class="btn btn-primary" type="submit">Run reconciliation</button>
    {% if has_saved_run %}<a class="btn btn-ghost" href="/reconciliation/reset">Reset to defaults</a>{% endif %}
  </div>
</form>

{% if result %}
{% if result.warnings %}
<div class="callout warn">{% for w in result.warnings %}<div>{{ w }}</div>{% endfor %}</div>
{% endif %}

{% if not result.success %}
<div class="callout info">No comparable components — check the mapping (legacy file path,
join keys and column names).</div>
{% else %}

<div class="callout info recon-materiality-toggle">
  {% if result.hide_immaterial %}
  Showing material rows only — {{ "{:,}".format(result.hidden_count) }} zero-gross-exposure row(s) hidden from the breakdown counts below (money totals are unaffected).
  <a href="{{ result.toggle_hide_url }}">Show all rows</a>.
  {% else %}
  Breakdown counts include every row.
  <a href="{{ result.toggle_hide_url }}">Hide zero-gross-exposure rows</a>
  for a cleaner view of the real differences.
  {% endif %}
</div>

<h2>1 · Headline — does it tie out?</h2>
<div class="stat-row">
  {% for s in result.headline %}
  <div class="stat">
    <div class="stat-num">{{ "{:,.0f}".format(s.our_total) }}</div>
    <div class="stat-lbl">{{ s.component }} — ours</div>
    <div class="muted">legacy {{ "{:,.0f}".format(s.legacy_total) }}{% if s.delta_pct is not none %} · Δ {{ "%+.2f"|format(s.delta_pct) }}%{% endif %}</div>
  </div>
  {% endfor %}
</div>
<div class="panel">
  <h3>Tie-out — legacy vs ours per component</h3>
  {{ result.chart_tie_out | safe }}
</div>
<div class="panel">
  <h3>Where the money differs — Σ|Δ| by component</h3>
  {{ result.chart_abs_delta | safe }}
</div>
<h3>By component</h3>
{{ render_table(result.component_table) }}

<h2>2 · Segment — where do breaks concentrate?</h2>
<p class="muted">Each row links into the per-key explorer, pre-filtered to that segment.</p>
{% if result.allocation_table.rows %}
<div class="panel">
  <h3>Asset-class allocation — legacy vs ours (RWA)</h3>
  {{ result.chart_allocation | safe }}
  {% if result.allocation_method_sections %}
  <h4>Split by method</h4>
  <p class="muted">The same money again, one section per methodology — STD (standardised),
  FIRB, AIRB (advanced IRB, retail included), and slotting / equity where present — because
  each asset class is reported per method (SA on COREP C 07.00, IRB on C 08.0x). All sections
  share one bar scale, so a small method reads as genuinely small.</p>
  {% for section in result.allocation_method_sections %}
  <h4 class="method-subtitle">{{ section.method }}</h4>
  {{ section.chart | safe }}
  {% endfor %}
  {% endif %}
</div>
<h3>Asset-class allocation — EAD &amp; RWA by risk class</h3>
<p class="muted">Money totalled by risk class, <strong>post-guarantee</strong>: a guaranteed
exposure's guaranteed slice is counted under the guarantor's class and its retained slice
under the borrower's, matching a post-substitution legacy extract. Offsetting deltas show
where the two engines allocate an exposure to different classes.</p>
{{ render_table(result.allocation_table) }}
{% if result.allocation_method_table.rows %}
<h3>Asset-class allocation — EAD &amp; RWA by risk class &amp; method</h3>
<p class="muted">The same post-guarantee money, split by the methodology each side applied.
Summing a class's methods reproduces its combined row above, so a class that ties out in
total but is allocated to <em>different approaches</em> by the two engines shows here as
offsetting deltas instead of a clean match. The guaranteed slice of an SA-guaranteed
exposure is counted under the guarantor's class <em>and</em> its standardised method.</p>
{{ render_table(result.allocation_method_table) }}
{% endif %}
{% endif %}
<h3>By bucket</h3>
{{ drill_table(result.bucket_table, "row_bucket", result.explorer_url, "bucket", result.hide_qs) }}
<h3>Breaks by exposure class <span class="muted">(borrower class)</span></h3>
<p class="muted">Where breaks concentrate. Each exposure is a single key, so its break is
attributed to its <strong>borrower</strong> (origination) class — a guaranteed exposure is not
split here (that post-guarantee split is in the allocation above).</p>
{{ drill_table(result.class_table, "our_exposure_class", result.explorer_url, "exposure_class", result.hide_qs) }}
<h3>By approach</h3>
{{ drill_table(result.approach_table, "our_approach", result.explorer_url, "approach", result.hide_qs) }}
<h3>By exposure class &amp; method</h3>
<p class="muted">Our-side view — how our breaks distribute across methodology (STD / FIRB / AIRB /
slotting / equity) within each exposure class. Click a method to drill the explorer to that
class × method.
{% if result.allocation_method_sections %}(Break attribution is at the borrower grain, so this
stays our-side only — the two-sided, post-guarantee money split is the by-method allocation
above.){% else %}(Map <code>[components.approach]</code> to give the legacy side a method too and
split the asset-class allocation above by methodology.){% endif %}</p>
{{ drill_table2(result.class_method_table, "method", result.explorer_url, "exposure_class", "our_exposure_class", "method", "method", result.hide_qs) }}

<h2>3 · Worklist — top {{ result.biggest_n }} of {{ "{:,}".format(result.break_count) }} break(s), largest first</h2>
<p class="muted">Click a key to open its single-loan forensic and sign it off (accept / reject
with a reason), or <a href="{{ result.explorer_url }}{% if result.hide_immaterial %}?hide_immaterial=1{% endif %}">open the full per-key explorer</a>
({{ "{:,}".format(result.total_rows) }} row(s)). Reviewed breaks drop off this worklist.
Download the full per-key detail:
<a href="{{ result.export_csv_url }}">CSV</a> · <a href="{{ result.export_excel_url }}">Excel</a>.</p>
{% if result.signoff_progress and result.signoff_progress.total %}
<p class="muted">Sign-off progress: {{ "{:,}".format(result.signoff_progress.reviewed) }} of
{{ "{:,}".format(result.signoff_progress.total) }} break(s) reviewed —
{{ "{:,}".format(result.signoff_progress.open) }} still open
({{ "{:,}".format(result.signoff_progress.accepted) }} accepted,
{{ "{:,}".format(result.signoff_progress.rejected) }} rejected{% if result.signoff_progress.changed %},
{{ "{:,}".format(result.signoff_progress.changed) }} changed since sign-off &amp; back on the worklist{% endif %}).</p>
{% endif %}
{% if result.signoff_decision_count %}
<form class="clear-all-signoff" method="post" action="{{ result.clear_all_url }}"
      data-confirm="Clear all {{ result.signoff_decision_count }} sign-off decision(s) for this dataset? This cannot be undone.">
  <input type="hidden" name="return_to" value="{{ result.explorer_url }}">
  <button class="btn btn-ghost btn-sm" type="submit">Clear all {{ "{:,}".format(result.signoff_decision_count) }} sign-off(s)</button>
</form>
{% endif %}
{% if result.biggest_breaks.rows %}
{{ drill_table(result.biggest_breaks, "_recon_key", result.loan_url_base, "key") }}
{% elif result.break_count %}
<div class="callout info">Every break has been reviewed (or its difference is unchanged).
Switch the explorer's status filter to <em>accepted</em> / <em>rejected</em> to review your
decisions.</div>
{% endif %}
<p>
  <a class="btn btn-primary" href="{{ result.explorer_url }}{% if result.hide_immaterial %}?hide_immaterial=1{% endif %}">Explore open differences →</a>
</p>

{% endif %}
{% endif %}
{% endblock %}

{% block scripts %}
<script defer src="/static/recon-signoff.js"></script>
{% endblock %}