{% extends "pdf_templates/pdf_base_financial.html" %}

{% load custom_filters %}
{% load humanize %}

{% block title %}
TRIAL BALANCE
{% endblock %}

{% block period %}
<table style="border:none; width:auto;">
    <tr>
        <td style="border:none; padding:0; width:65px;">Currency</td>
        <td style="border:none; padding:0; width:10px;">:</td>
        <td style="border:none; padding:0;">{{ currency }}</td>
    </tr>
    <tr>
        <td style="border:none; padding:0;">Period</td>
        <td style="border:none; padding:0;">:</td>
        <td style="border:none; padding:0;">
            {{ from_date|date:"d M Y" }} - {{ to_date|date:"d M Y" }}
        </td>
    </tr>
</table>
{% endblock %}

{% block content %}

<table>

    <thead>
        <tr>
            <th>Account</th>
            <th style="width:120px;" class="text-end">Opening</th>
            <th style="width:120px;" class="text-end">Debit</th>
            <th style="width:120px;" class="text-end">Credit</th>
            <th style="width:120px;" class="text-end">Ending</th>
        </tr>
    </thead>
    <tbody>

        {% for row in trial_data %}

        <tr>

            <td>{{ row.acct_no|format_acct_no }} - {{ row.acct_name }}</td>

            <td class="text-end {% if row.opening < 0 %}negative{% endif %}">
                {{ row.opening|floatformat:2|intcomma }}
            </td>
            <td class="text-end {% if row.debit < 0 %}negative{% endif %}">
                {{ row.debit|floatformat:2|intcomma }}
            </td>

            <td class="text-end {% if row.credit < 0 %}negative{% endif %}">
                {{ row.credit|floatformat:2|intcomma }}
            </td>
            <td class="text-end {% if row.ending < 0 %}negative{% endif %}">
                {{ row.ending|floatformat:2|intcomma }}
            </td>

        </tr>

        {% endfor %}

        <tr class="total-row">

            <td>TOTAL</td>

            <td></td>

            <td class="text-end">
                {{ total_debit|floatformat:2|intcomma }}
            </td>

            <td class="text-end">
                {{ total_credit|floatformat:2|intcomma }}
            </td>

            <td></td>

        </tr>

        <tr class="grand-total">

            <td colspan="2">
                Difference (Must Be 0)
            </td>

            <td colspan="3" class="text-end {% if difference != 0 %}negative{% endif %}">

                {{ difference|floatformat:2|intcomma }}

            </td>

        </tr>

    </tbody>

</table>

{% endblock %}