{% extends "base.html" %}
{% block title %}{{ t('Statement') }} · {{ nm(p) }}{% endblock %}
{% block content %}
{% set list_title = 'Customer Statements' if side == 'customer' else 'Vendor Statements' %}
<div class="page-head">
  <div><small><a href="{{ url_for('statements.index', side=side, date_from=date_from, date_to=date_to) }}">{{ t(list_title) }}</a></small>
    <h1>{{ nm(p) }}</h1><small>{{ t('Statement of Account') }} · {{ date_from }} — {{ date_to }}{% if p.email %} · {{ p.email }}{% endif %}</small></div>
  <div class="actions">
    <a class="btn ghost" href="{{ url_for('statements.pdf', side=side, pid=p.id, date_from=date_from, date_to=date_to) }}" target="_blank">{{ icon('file') }}PDF</a>
    {% if can_write %}
      {% if side == 'customer' and overdue %}<a class="btn ghost" href="{{ url_for('statements.email', side=side, pid=p.id, date_from=date_from, date_to=date_to, kind='reminder') }}">{{ icon('alert') }}{{ t('Send payment reminder') }}</a>{% endif %}
      <a class="btn" href="{{ url_for('statements.email', side=side, pid=p.id, date_from=date_from, date_to=date_to) }}">{{ icon('mail') }}{{ t('Email statement') }}</a>
    {% endif %}
  </div>
</div>
<form class="filters" method="get">
  <label>{{ t('From') }} <input type="date" name="date_from" value="{{ date_from }}"></label>
  <label>{{ t('To') }} <input type="date" name="date_to" value="{{ date_to }}"></label>
  <button class="btn">{{ t('Apply') }}</button>
</form>
{% for s in sections %}
{% set cur = s.currency %}
<div class="stat-row">
  <div class="stat"><div><div class="l">{{ t('Opening balance') }}</div><div class="v num">{{ s.opening|money(cur) }} <small class="muted">{{ cur }}</small></div></div></div>
  <div class="stat"><div><div class="l">{{ t('Debits') }} / {{ t('Credits') }}</div><div class="v num">{{ s.debit|money(cur) }} / {{ s.credit|money(cur) }}</div></div></div>
  <div class="stat"><div><div class="l">{{ t('Balance due') if side == 'customer' else t('Balance payable') }}</div><div class="v num">{{ s.closing|money(cur) }} <small class="muted">{{ cur }}</small></div></div>
    {% if s.overdue > 0 %}<div class="r"><span class="badge st-cancelled">{{ t('Overdue') }} {{ s.overdue|money(cur) }}</span></div>{% endif %}</div>
</div>
<div class="card flush">
  <table>
    <thead><tr><th>{{ t('Date') }}</th><th>{{ t('Document') }}</th><th>{{ t('Number') }}</th><th>{{ t('Details') }}</th><th>{{ t('Branch') }}</th>
      <th class="num">{{ t('Debit') }}</th><th class="num">{{ t('Credit') }}</th><th class="num">{{ t('Balance') }}</th></tr></thead>
    <tbody>
      <tr class="sub"><td class="num">{{ date_from }}</td><td colspan="6"><b>{{ t('Opening balance') }}</b></td><td class="num"><b>{{ s.opening|money(cur) }}</b></td></tr>
      {% for r in s.lines %}
      <tr><td class="num">{{ r.date }}</td><td>{{ t(r.doc) }}</td>
        <td>{% if r.invoice_id %}<a href="{{ url_for('invoices.view', inv_id=r.invoice_id) }}">{{ r.number }}</a>{% elif r.payment_id %}<a href="{{ url_for('payments.view', pid=r.payment_id) }}">{{ r.number }}</a>{% else %}<a href="{{ url_for('entries.view', move_id=r.move_id) }}">{{ r.number }}</a>{% endif %}</td>
        <td><small>{{ r.detail }}</small></td><td><span class="tag">{{ r.bcode }}</span></td>
        <td class="num">{{ r.debit|money(cur, true) }}</td><td class="num">{{ r.credit|money(cur, true) }}</td><td class="num">{{ r.balance|money(cur) }}</td></tr>
      {% endfor %}
    </tbody>
    <tfoot><tr><td class="num">{{ date_to }}</td><td colspan="4">{{ t('Closing balance') }}</td><td class="num">{{ s.debit|money(cur) }}</td>
      <td class="num">{{ s.credit|money(cur) }}</td><td class="num">{{ s.closing|money(cur) }}</td></tr></tfoot>
  </table>
</div>
<div class="card flush">
  <div class="card-h" style="padding:14px 16px 0"><h2>{{ t('Ageing') }} ({{ cur }})</h2></div>
  <table>
    <thead><tr>{% for k, lbl in buckets %}<th class="num">{{ t(lbl) }}</th>{% endfor %}<th class="num">{{ t('Unapplied') }}</th><th class="num">{{ t('Total') }}</th></tr></thead>
    <tbody><tr>{% for k, lbl in buckets %}<td class="num {{ 'neg' if k != 'current' and s.ageing[k] > 0 }}">{{ s.ageing[k]|money(cur) }}</td>{% endfor %}
      <td class="num">{{ s.unapplied|money(cur) }}</td><td class="num"><b>{{ s.closing|money(cur) }}</b></td></tr></tbody>
  </table>
</div>
{% else %}
<div class="card empty">{{ t('No transactions in this period.') }}</div>
{% endfor %}
{% if log %}
<div class="card flush">
  <div class="card-h" style="padding:14px 16px 0"><h2>{{ t('Sent by email') }}</h2></div>
  <table>
    <tbody>{% for e in log %}<tr><td class="num">{{ e.sent_at.replace('T', ' ')[:16] }}</td><td>{{ t(e.kind|capitalize) }}</td><td>{{ e.to_addr }}</td>
      <td>{{ e.subject }}</td><td>{{ e.username or '' }}</td><td>{% if e.state == 'sent' %}<span class="badge st-posted">{{ t('Sent') }}</span>{% else %}<span class="badge st-cancelled" title="{{ e.error }}">{{ t('Failed') }}</span>{% endif %}</td></tr>{% endfor %}</tbody>
  </table>
</div>
{% endif %}
{% endblock %}