{% extends "base.html" %}
{% block title %}Income & expenses{% endblock %}
{% block content %}
<header class="page-head">
  <div><h1>Income &amp; expenses</h1>
  <p class="muted">Month by month, by category. Filter to one property to see how it's doing.</p></div>
  <div class="actions no-print">
    <a class="btn" href="{{ url_for('main.report_pnl', format='csv', **request.args) }}">CSV</a>
    <button class="btn" onclick="window.print()">Print</button>
  </div>
</header>
<form method="get" class="filters card no-print">
  <label>From <input type="date" name="start" value="{{ start }}"></label>
  <label>To <input type="date" name="end" value="{{ end }}"></label>
  <label>Property <select name="property"><option value="">All</option><option value="none" {{ 'selected' if prop == 'none' }}>Not property-related</option>
    {% for p in properties %}<option value="{{ p.id }}" {{ 'selected' if prop == p.id|string }}>{{ p.name }}</option>{% endfor %}</select></label>
  <label>Account <select name="account"><option value="">All</option>
    {% for a in accounts %}<option value="{{ a.id }}" {{ 'selected' if acct == a.id }}>{{ a.name }}</option>{% endfor %}</select></label>
  <div class="filter-buttons"><button class="btn btn-primary">Show</button></div>
</form>

<section class="card flush scroll-x">
<table class="table pnl">
  <thead><tr><th>Category</th>{% for m in rep.months %}<th class="num">{{ m[5:] }}/{{ m[2:4] }}</th>{% endfor %}<th class="num">Total</th></tr></thead>
  {% for kind, title in [('income', 'Income'), ('expense', 'Expenses'), ('capital', 'Capital improvements (depreciated, not expensed)')] %}
    {% if rep.data[kind] %}{% set sg = 1 if kind == 'income' else -1 %}
    <tbody>
      <tr class="section"><th colspan="{{ rep.months|length + 2 }}">{{ title }}</th></tr>
      {% for cat, vals in rep.data[kind]|dictsort %}
        <tr><td>{{ cat }}</td>{% for m in rep.months %}{% set v = vals.get(m, 0) * sg %}<td class="num {{ 'neg' if v < 0 }}">{{ v|money(true) }}</td>{% endfor %}
          <td class="num strong {{ 'neg' if vals.total * sg < 0 }}">{{ (vals.total * sg)|money }}</td></tr>
      {% endfor %}
      <tr class="total"><td>Total {{ title|lower }}</td>{% for m in rep.months %}<td class="num">{{ (rep.totals[kind][m] * sg)|money(true) }}</td>{% endfor %}<td class="num">{{ (rep.totals[kind].total * sg)|money }}</td></tr>
    </tbody>
    {% endif %}
  {% endfor %}
  <tfoot><tr class="net"><th>Net (income − expenses)</th>{% for m in rep.months %}<th class="num {{ 'neg' if rep.totals.net[m] < 0 }}">{{ rep.totals.net[m]|money(true) }}</th>{% endfor %}
    <th class="num {{ 'neg' if rep.totals.net.total < 0 }}">{{ rep.totals.net.total|money }}</th></tr></tfoot>
</table>
</section>
<p class="muted small">Transfers, loan principal, personal spending and stock purchases are left out. Depreciation isn't included here — see the <a href="{{ url_for('main.tax_center') }}">Tax center</a>.</p>
{% endblock %}