{% extends "base.html" %}
{% from "_macros.html" import export_buttons, icon with context %}
{% from "insights/_parts.html" import short with context %}
{% block title %}{{ t('13-Week Cash Forecast') }}{% endblock %}
{% block content %}
{% set cur = fc.currency %}
<div class="page-head"><div><h1>{{ t('13-Week Cash Forecast') }}</h1><small>{{ t('Bank and cash today, plus what is already known to come in and go out, week by week') }}</small></div></div>
<form class="filters" method="get">
  <label class="chip"><input type="checkbox" name="orders" value="1" {{ 'checked' if orders }} onchange="this.form.submit()"> {{ t('Include confirmed orders not yet invoiced') }}</label>
  <input type="hidden" name="orders" value="0" {{ 'disabled' if orders }}>
  {{ export_buttons() }}
</form>
<div class="kpis">
  <div class="kpi"><div class="top"><span class="label">{{ t('Bank and Cash today') }}</span><span class="ibox t-blue">{{ icon('bank') }}</span></div><div class="value num">{{ fc.opening|money(cur) }}<small>{{ cur }}</small></div></div>
  <div class="kpi"><div class="top"><span class="label">{{ t('Cash in, 13 weeks') }}</span><span class="ibox t-green">{{ icon('down') }}</span></div><div class="value num">{{ fc.total_in|sum|money(cur) }}<small>{{ cur }}</small></div>
    <div class="sub">{% if fc.overdue['in'] %}{{ fc.overdue['in']|money(cur) }} {{ t('of it is overdue (shown in week 1)') }}{% endif %}</div></div>
  <div class="kpi"><div class="top"><span class="label">{{ t('Cash out, 13 weeks') }}</span><span class="ibox t-amber">{{ icon('wallet') }}</span></div><div class="value num">{{ fc.total_out|sum|money(cur) }}<small>{{ cur }}</small></div>
    <div class="sub">{% if fc.overdue['out'] %}{{ fc.overdue['out']|money(cur) }} {{ t('of it is overdue (shown in week 1)') }}{% endif %}</div></div>
  <div class="kpi {{ 'alert' if fc.lowest < 0 }}"><div class="top"><span class="label">{{ t('Lowest balance') }}</span><span class="ibox {{ 't-red' if fc.lowest < 0 else 't-green' }}">{{ icon('alert' if fc.lowest < 0 else 'check') }}</span></div>
    <div class="value num {{ 'neg' if fc.lowest < 0 }}">{{ fc.lowest|money(cur) }}<small>{{ cur }}</small></div>
    <div class="sub">{{ t('Cash runs short — arrange funding or delay payments.') if fc.lowest < 0 else t('Cash stays positive.') }}</div></div>
</div>
<div class="card flush" style="overflow:visible">
  <div class="card-h"><h2>{{ t('Closing cash by week') }}</h2></div>
  {% set span = hi - lo %}
  <div class="fc-chart">
    {% for w in fc.weeks %}{% set v = fc.closing[loop.index0] %}
      <div class="fc-col" title="{{ w.strftime('%d %b') }}: {{ v|money(cur) }}">
        <div class="fc-plot"><div class="fc-zero" style="bottom:{{ (0 - lo) / span * 100 }}%"></div>
          <div class="fc-bar {{ 'neg' if v < 0 }}" style="bottom:{{ ([v, 0]|min - lo) / span * 100 }}%;height:{{ (v|abs) / span * 100 }}%"></div></div>
        <span class="lbl">{{ short(v) }}</span><span class="lbl">{{ w.strftime('%d/%m') }}</span>
      </div>
    {% endfor %}
  </div>
</div>
<div class="card flush" style="overflow-x:auto">
  <table class="report fc-table">
    <thead><tr><th>{{ t('Week of') }}</th>{% for w in fc.weeks %}<th class="num">{{ w.strftime('%d/%m') }}</th>{% endfor %}<th class="num">{{ t('Total') }}</th></tr></thead>
    <tbody>
      <tr class="group"><td>{{ t('Opening cash') }}</td>{% for w in fc.weeks %}<td class="num">{{ (fc.opening if loop.first else fc.closing[loop.index0 - 1])|money(cur) }}</td>{% endfor %}<td></td></tr>
      <tr class="section"><td colspan="15">{{ t('Cash in') }}</td></tr>
      {% for lbl, vals in fc.inflow %}<tr><td>{{ t(lbl) }}</td>{% for v in vals %}<td class="num">{{ v|money(cur) if v else '' }}</td>{% endfor %}<td class="num">{{ vals|sum|money(cur) }}</td></tr>{% endfor %}
      <tr class="subtotal"><td>{{ t('Total cash in') }}</td>{% for v in fc.total_in %}<td class="num">{{ v|money(cur) }}</td>{% endfor %}<td class="num">{{ fc.total_in|sum|money(cur) }}</td></tr>
      <tr class="section"><td colspan="15">{{ t('Cash out') }}</td></tr>
      {% for lbl, vals in fc.outflow %}<tr><td>{{ t(lbl) }}</td>{% for v in vals %}<td class="num">{{ v|money(cur) if v else '' }}</td>{% endfor %}<td class="num">{{ vals|sum|money(cur) }}</td></tr>{% endfor %}
      <tr class="subtotal"><td>{{ t('Total cash out') }}</td>{% for v in fc.total_out %}<td class="num">{{ v|money(cur) }}</td>{% endfor %}<td class="num">{{ fc.total_out|sum|money(cur) }}</td></tr>
      <tr class="total"><td>{{ t('Net cash flow') }}</td>{% for v in fc.net %}<td class="num {{ 'neg' if v < 0 }}">{{ v|money(cur) }}</td>{% endfor %}<td class="num">{{ fc.net|sum|money(cur) }}</td></tr>
      <tr class="grand"><td>{{ t('Closing cash') }}</td>{% for v in fc.closing %}<td class="num {{ 'neg' if v < 0 }}">{{ v|money(cur) }}</td>{% endfor %}<td></td></tr>
    </tbody>
  </table>
</div>
<p class="muted"><small>{{ t('Overdue invoices and bills are shown in the first week. Orders not yet invoiced are placed at their expected date plus the partner’s payment terms. Salaries repeat the last posted payroll at each month end. Nothing here is posted to the books.') }}</small></p>
{% endblock %}