{% extends "base.html" %}
{% from "_macros.html" import report_filters with context %}
{% set title = 'Aged Receivables' if side == 'receivable' else 'Aged Payables' %}
{% block title %}{{ t(title) }}{% endblock %}
{% block content %}
{% set cur = currency %}
<div class="page-head"><h1>{{ t(title) }}</h1></div>
{% set extra %}<label class="chip"><input type="checkbox" name="detail" value="1" {{ 'checked' if detail }}> {{ t('Show documents') }}</label>{% endset %}
{{ report_filters(f, True, extra) }}
<div class="report-meta"><span>{{ t('As of') }} {{ f.date_to }}</span><span>{{ t('Amounts in') }} {{ cur }}</span></div>
<div class="card flush">
  <table class="report">
    <thead><tr><th>{{ t('Partner') }}</th>{% for k, lbl in buckets %}<th class="num">{{ t(lbl) }}</th>{% endfor %}<th class="num cons">{{ t('Total') }}</th></tr></thead>
    <tbody>
    {% for p in rows %}
      <tr class="{{ 'subtotal' if detail }}"><td><a href="{{ url_for('reports.gl', partner_id=p.id, b=f.branch_ids, date_to=f.date_to, date_from='2000-01-01') }}">{{ p.name }}</a></td>
        {% for k, lbl in buckets %}<td class="num">{{ p[k]|money(cur, true) }}</td>{% endfor %}<td class="num cons">{{ p.total|money(cur) }}</td></tr>
      {% for d in p.invoices %}
        <tr><td class="lvl-2"><a href="{{ url_for('invoices.view', inv_id=d.inv.id) }}">{{ d.inv.number }}</a> <small>{{ t('Due') }} {{ d.inv.due_date }}</small></td>
          {% for k, lbl in buckets %}<td class="num">{{ d.amount|money(cur) if d.bucket == k else '' }}</td>{% endfor %}<td class="num cons">{{ d.amount|money(cur) }}</td></tr>
      {% endfor %}
    {% else %}<tr><td class="empty" colspan="7">{{ t('Nothing open.') }}</td></tr>{% endfor %}
    </tbody>
    <tfoot><tr><td>{{ t('Total') }}</td>{% for k, lbl in buckets %}<td class="num">{{ totals[k]|money(cur) }}</td>{% endfor %}<td class="num">{{ totals.total|money(cur) }}</td></tr></tfoot>
  </table>
  <div class="notes">{{ t('Buckets are days past the due date.') }}</div>
</div>
{% endblock %}