{% extends "finance/base.html" %}
{% load humanize %}
{% load custom_filters %}

{% block content %}
<div class="container mt-4">

    <div class="d-flex justify-content-between align-items-center mb-3">
        <h3 class="mb-0">Profit & Loss Statement</h3>
        <span class="badge bg-secondary">{{ currency }}</span>
    </div>

    <p class="text-muted">
        Period: {{ from_date|date:"d M Y" }} - {{ to_date|date:"d M Y" }}
    </p>

    <!-- ================= FILTER ================= -->
    <form method="get" class="row g-2 mb-4">

        <div class="col-auto">
            <input type="date" name="from" value="{{ from_date|date:'Y-m-d' }}" required class="form-control">
        </div>

        <div class="col-auto">
            <input type="date" name="to" value="{{ to_date|date:'Y-m-d' }}" required class="form-control">
        </div>

        <div class="col-auto">
            <select name="currency" class="form-select">
                <option value="IDR" {% if currency == "IDR" %}selected{% endif %}>IDR</option>
                <option value="USD" {% if currency == "USD" %}selected{% endif %}>USD</option>
            </select>
        </div>

        <div class="col-auto">
            <button class="btn btn-primary">
                Search
            </button>

        <a href="{% url 'profit_loss_pdf' %}?from={{ from_date|date:'Y-m-d' }}&to={{ to_date|date:'Y-m-d' }}&currency={{ currency }}"
            target="_blank" class="btn btn-danger">
            PDF
        </a>

        <a href="{% url 'profit_loss_excel' %}?from={{ from_date|date:'Y-m-d' }}&to={{ to_date|date:'Y-m-d' }}&currency={{ currency }}"
            class="btn btn-success">
            Export to Excel
        </a>
        </div>
    </form>
    <!-- ========================================== -->

    {% if revenue_list or expense_list %}

    <!-- ================= REVENUE ================= -->
    <h5 class="mt-4">REVENUE</h5>

    <table class="table table-sm table-bordered">
        <thead class="table-light">
            <tr>
                <th>Description</th>
                <th class="text-end">This Period</th>
                <th class="text-end">Last Month</th>
                <th class="text-end">YTD</th>
            </tr>
        </thead>
        <tbody>

            {% for row in revenue_list %}
            <tr>
                <td>{{ row.acct_no|format_acct_no }} - {{ row.acct_name }}</td>
                <td class="text-end">{{ row.this|floatformat:0|intcomma }}</td>
                <td class="text-end">{{ row.last|floatformat:0|intcomma }}</td>
                <td class="text-end">{{ row.ytd|floatformat:0|intcomma }}</td>
            </tr>
            {% endfor %}

            <tr class="fw-bold border-top">
                <td>Total Revenue</td>
                <td class="text-end">{{ total_rev_this|floatformat:0|intcomma }}</td>
                <td class="text-end">{{ total_rev_last|floatformat:0|intcomma }}</td>
                <td class="text-end">{{ total_rev_ytd|floatformat:0|intcomma }}</td>
            </tr>

        </tbody>
    </table>


    <!-- ================= EXPENSE ================= -->
    <h5 class="mt-4">EXPENSE</h5>

    <table class="table table-sm table-bordered">
        <thead class="table-light">
            <tr>
                <th>Description</th>
                <th class="text-end">This Period</th>
                <th class="text-end">Last Month</th>
                <th class="text-end">YTD</th>
            </tr>
        </thead>
        <tbody>

            {% for row in expense_list %}
            <tr>
                <td>{{ row.acct_no|format_acct_no }} - {{ row.acct_name }}</td>
                <td class="text-end">{{ row.this|floatformat:0|intcomma }}</td>
                <td class="text-end">{{ row.last|floatformat:0|intcomma }}</td>
                <td class="text-end">{{ row.ytd|floatformat:0|intcomma }}</td>
            </tr>
            {% endfor %}

            <tr class="fw-bold border-top">
                <td>Total Expense</td>
                <td class="text-end">{{ total_exp_this|floatformat:0|intcomma }}</td>
                <td class="text-end">{{ total_exp_last|floatformat:0|intcomma }}</td>
                <td class="text-end">{{ total_exp_ytd|floatformat:0|intcomma }}</td>
            </tr>

        </tbody>
    </table>


    <!-- ================= NET PROFIT ================= -->
    <hr>

    <table class="table table-bordered">
        <tr class="fw-bold">
            <td>Net Profit / (Loss)</td>
            <td class="text-end {% if net_this < 0 %}text-danger{% else %}text-success{% endif %}">
                {{ net_this|floatformat:0|intcomma }}
            </td>
            <td class="text-end {% if net_last < 0 %}text-danger{% else %}text-success{% endif %}">
                {{ net_last|floatformat:0|intcomma }}
            </td>
            <td class="text-end {% if net_ytd < 0 %}text-danger{% else %}text-success{% endif %}">
                {{ net_ytd|floatformat:0|intcomma }}
            </td>
        </tr>
    </table>

    {% endif %}

</div>
{% endblock %}