{% extends "core/base.html" %}{% load fmt %}
{% block title %}13-week grid{% endblock %}
{% block content %}
<div class="head"><h1>13-week cash flow</h1>
  <div class="actions">{% include "core/_scenario_picker.html" %}
  <a class="btn" href="{% url 'grid_csv' %}{% if scenario %}?scenario={{ scenario.id }}{% endif %}">Export CSV (Excel)</a></div></div>
<p class="sub">Click a group to expand its lines. Receipts are probability-weighted expectations per customer.</p>
<div class="scroll">
<table class="grid-table">
<thead><tr><th class="lbl">Week</th>{% for w in fc.weeks %}<th class="r">{{ w.index|add:1 }}<small>{{ w.start|date:"j M" }}</small></th>{% endfor %}</tr></thead>
<tbody>
<tr class="strong"><td class="lbl">Opening cash</td>{% for w in fc.weeks %}<td class="r">{{ w.opening|inr }}</td>{% endfor %}</tr>
{% for s in sections %}
<tr class="sect"><td class="lbl" colspan="14">{{ s.title }}</td></tr>
{% for g in s.groups %}
<tr class="group" data-group="{{ g.id }}"><td class="lbl"><span class="caret">&#9656;</span> {{ g.name }} <small>({{ g.lines|length }})</small></td>{% for v in g.total %}<td class="r">{{ v|dash }}</td>{% endfor %}</tr>
{% for ln in g.lines %}<tr class="detail" data-parent="{{ g.id }}" hidden><td class="lbl indent">{{ ln.label }}</td>{% for v in ln.values %}<td class="r">{{ v|dash }}</td>{% endfor %}</tr>{% endfor %}
{% endfor %}
<tr class="strong total"><td class="lbl">Total {{ s.title|lower }}</td>{% for v in s.total %}<td class="r">{{ v|inr }}</td>{% endfor %}</tr>
{% endfor %}
<tr class="strong"><td class="lbl">Net cash flow</td>{% for w in fc.weeks %}<td class="r {% if w.net < 0 %}neg{% endif %}">{{ w.net|inr }}</td>{% endfor %}</tr>
<tr class="strong closing"><td class="lbl">Closing cash</td>{% for w in fc.weeks %}<td class="r {% if w.breach %}breach-cell{% endif %}">{{ w.closing|inr }}</td>{% endfor %}</tr>
<tr><td class="lbl">Cumulative net flow</td>{% for w in fc.weeks %}<td class="r {% if w.cumulative < 0 %}neg{% endif %}">{{ w.cumulative|inr }}</td>{% endfor %}</tr>
<tr class="muted"><td class="lbl">Closing cash p10</td>{% for w in fc.weeks %}<td class="r {% if w.at_risk %}neg{% endif %}">{{ w.closing_p10|inr }}</td>{% endfor %}</tr>
<tr class="muted"><td class="lbl">Closing cash p90</td>{% for w in fc.weeks %}<td class="r">{{ w.closing_p90|inr }}</td>{% endfor %}</tr>
<tr><td class="lbl">Below minimum ({{ fc.min_cash|inr }})</td>{% for w in fc.weeks %}<td class="r">{% if w.breach %}<span class="pill bad">BREACH</span>{% elif w.at_risk %}<span class="pill warn">RISK</span>{% endif %}</td>{% endfor %}</tr>
</tbody></table>
</div>
{% endblock %}