{% extends 'pos/base.html' %}
{% block content %}
<div class="container-fluid">
  <div class="row mb-3 align-items-center">
    <div class="col"><h4>Trial Balance</h4></div>
    <div class="col-auto">
      <form class="d-flex gap-2" method="get">
        <input type="date" name="as_of_date" value="{{ as_of_date }}" class="form-control form-control-sm">
        <button class="btn btn-primary btn-sm">Go</button>
      </form>
    </div>
  </div>
 
  {% if not balanced %}
  <div class="alert alert-danger">
    ⚠ Trial Balance does not balance! Difference: {{ difference|floatformat:2 }}
    Check for missing opening balances or unmapped GL rules.
  </div>
  {% else %}
  <div class="alert alert-success">✓ Trial Balance balanced as of {{ as_of_date }}</div>
  {% endif %}
 
  <table class="table table-sm table-bordered">
    <thead class="table-dark">
      <tr>
        <th>Code</th><th>Account Name</th><th>Type</th>
        <th class="text-end">Debit</th>
        <th class="text-end">Credit</th>
        <th class="text-end">Net Balance</th>
        <th>Side</th>
      </tr>
    </thead>
    <tbody>
      {% for row in rows %}
      <tr>
        <td>{{ row.code }}</td>
        <td>{{ row.name }}</td>
        <td><small class="text-muted">{{ row.account_type }}</small></td>
        <td class="text-end">{% if row.debit %}{{ row.debit|floatformat:2 }}{% endif %}</td>
        <td class="text-end">{% if row.credit %}{{ row.credit|floatformat:2 }}{% endif %}</td>
        <td class="text-end fw-bold">{{ row.net_balance|floatformat:2 }}</td>
        <td><span class="badge {% if row.net_side == 'Dr' %}bg-primary{% else %}bg-warning text-dark{% endif %}">{{ row.net_side }}</span></td>
      </tr>
      {% endfor %}
    </tbody>
    <tfoot class="table-secondary fw-bold">
      <tr>
        <td colspan="3">TOTALS</td>
        <td class="text-end">{{ grand_dr|floatformat:2 }}</td>
        <td class="text-end">{{ grand_cr|floatformat:2 }}</td>
        <td colspan="2"></td>
      </tr>
    </tfoot>
  </table>
</div>
{% endblock %}