{% extends "rentals/base.html" %}
{% load rentals_extras %}
{% block title %}Ledger{% endblock %}
{% block content %}
<div class="head"><h1>{{ lease.tenant }} <small>{{ lease.unit }}</small></h1>
<div>{% if not lease.moved_out %}<a class="btn" href="{% url 'payment_new' lease.pk %}">Record payment</a> <a class="btn secondary" href="{% url 'move_out' lease.pk %}">Move out</a>{% endif %}
<a class="btn secondary" href="{% url 'lease_edit' lease.pk %}">Edit lease</a> <a class="btn secondary" href="{% url 'ledger_csv' lease.pk %}">CSV</a></div></div>
<p class="muted">Rent {{ lease.monthly_rent|inr }} +{{ lease.escalation_pct }}% yearly, due on the {{ lease.due_day }}th, deposit {{ lease.deposit|inr }}, notice {{ lease.notice_days }} days.
{% if lease.maintenance_included %}Maintenance included.{% else %}Maintenance {{ lease.maintenance_charge|inr }} billed extra.{% endif %}</p>
<div class="stats">
  <div class="stat"><span>Billed</span><b>{{ ledger.billed|inr }}</b></div>
  <div class="stat"><span>Paid</span><b>{{ ledger.paid|inr }}</b></div>
  <div class="stat {% if ledger.arrears %}bad{% endif %}"><span>Arrears</span><b>{{ ledger.arrears|inr }}</b></div>
  <div class="stat"><span>Late fees accrued</span><b>{{ ledger.late_fees|inr }}</b></div>
</div>
<section class="card"><h2>Arrears ageing</h2>
<table class="aging"><tr>{% for bucket, amount in ledger.aging.items %}<th>{{ bucket }}</th>{% endfor %}</tr><tr>{% for bucket, amount in ledger.aging.items %}<td>{{ amount|inr }}</td>{% endfor %}</tr></table>
{% if ledger.advance %}<p class="muted">Advance credit {{ ledger.advance|inr }}</p>{% endif %}</section>
{% if settlement %}<section class="card"><h2>Deposit settlement ({{ settlement.move_out_date|date:"j M Y" }})</h2>
<table><tr><td>Deposit held</td><td class="num">{{ settlement.deposit_held|inr:2 }}</td></tr>
{% for d in settlement.deductions.all %}<tr><td>less {{ d.label }}</td><td class="num">{{ d.amount|inr:2 }}</td></tr>{% endfor %}
<tr><th>Refunded to tenant</th><th class="num">{{ settlement.refund|inr:2 }}</th></tr>
{% if settlement.tenant_owes %}<tr><th>Tenant still owes</th><th class="num">{{ settlement.tenant_owes|inr:2 }}</th></tr>{% endif %}</table></section>{% endif %}
<section class="card"><h2>Invoices</h2>
<table><thead><tr><th>Month</th><th>Due</th><th class="num">Billed</th><th class="num">Paid</th><th class="num">Outstanding</th><th>Settled</th><th class="num">Late fee</th></tr></thead>
{% for r in ledger.rows %}<tr class="{% if r.outstanding and r.due_date < ledger.as_of %}overdue{% endif %}"><td>{{ r.period|date:"M Y" }}</td><td>{{ r.due_date|date:"j M Y" }}</td>
<td class="num">{{ r.amount|inr:2 }}</td><td class="num">{{ r.paid|inr:2 }}</td><td class="num">{{ r.outstanding|inr:2 }}</td><td>{{ r.settled_on|date:"j M Y" }}</td><td class="num">{{ r.late_fee|inr }}</td></tr>{% endfor %}</table></section>
<section class="card"><h2>Payments</h2>
<table>{% for p in payments %}<tr><td>{{ p.date|date:"j M Y" }}</td><td class="num">{{ p.amount|inr:2 }}</td><td>{{ p.get_mode_display }}</td><td>{{ p.reference }}</td></tr>{% empty %}<tr><td class="muted">No payments yet.</td></tr>{% endfor %}</table></section>
{% endblock %}