{% extends "base.html" %}
{% load humanize %}

{% block title %}Reports | Admin Portal{% endblock %}
{% block nav_reports %}active{% endblock %}

{% block content %}
<div class="page-header">
    <div>
        <h2><i class="fa-solid fa-chart-bar me-2"></i>Reports</h2>
        <p class="text-muted mb-0">Overview of enrollment, payments, and certificates</p>
    </div>
</div>

<!-- Summary stat cards -->
<div class="row g-3 mb-4">
    <div class="col-sm-6 col-xl-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:rgba(10,61,98,0.12);color:var(--color-primary);">
                <i class="fa-solid fa-users"></i>
            </div>
            <div>
                <div class="stat-value">{{ total_active_students }}</div>
                <div class="stat-label">Active Students</div>
            </div>
        </div>
    </div>
    <div class="col-sm-6 col-xl-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:rgba(13,202,240,0.12);color:#0dcaf0;">
                <i class="fa-solid fa-layer-group"></i>
            </div>
            <div>
                <div class="stat-value">{{ total_active_programs }}</div>
                <div class="stat-label">Active Programs</div>
            </div>
        </div>
    </div>
    <div class="col-sm-6 col-xl-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:rgba(25,135,84,0.12);color:#198754;">
                <i class="fa-solid fa-money-bill-wave"></i>
            </div>
            <div>
                <div class="stat-value">{{ total_payments|intcomma }}</div>
                <div class="stat-label">Total Paid (UGX)</div>
            </div>
        </div>
    </div>
    <div class="col-sm-6 col-xl-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:rgba(244,180,0,0.15);color:var(--color-secondary);">
                <i class="fa-solid fa-certificate"></i>
            </div>
            <div>
                <div class="stat-value">{{ total_certificates }}</div>
                <div class="stat-label">Certificates Issued</div>
            </div>
        </div>
    </div>
</div>

<div class="row g-4">

    <!-- Enrollment by program -->
    <div class="col-lg-6">
        <div class="portal-card h-100">
            <div class="portal-card-header">
                <h6 class="mb-0"><i class="fa-solid fa-users me-2"></i>Enrollment by Program</h6>
            </div>
            <div class="portal-card-body p-0">
                {% if enrollment_by_program %}
                <table class="table table-sm mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>Program</th>
                            <th>Level</th>
                            <th class="text-end">Students</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for row in enrollment_by_program %}
                        <tr>
                            <td>{{ row.program__name }}</td>
                            <td class="text-muted small">{{ row.program__level }}</td>
                            <td class="text-end"><span class="badge bg-primary">{{ row.count }}</span></td>
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
                {% else %}
                <p class="text-muted text-center py-4 mb-0 small">No enrollment data yet.</p>
                {% endif %}
            </div>
        </div>
    </div>

    <!-- Payments by program -->
    <div class="col-lg-6">
        <div class="portal-card h-100">
            <div class="portal-card-header">
                <h6 class="mb-0"><i class="fa-solid fa-money-bill-wave me-2"></i>Payments by Program</h6>
            </div>
            <div class="portal-card-body p-0">
                {% if payments_by_program %}
                <table class="table table-sm mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>Program</th>
                            <th class="text-end">Transactions</th>
                            <th class="text-end">Total (UGX)</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for row in payments_by_program %}
                        <tr>
                            <td>{{ row.enrollment__program__name|default:"Unknown" }}</td>
                            <td class="text-end text-muted small">{{ row.count }}</td>
                            <td class="text-end fw-semibold">{{ row.total|intcomma }}</td>
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
                {% else %}
                <p class="text-muted text-center py-4 mb-0 small">No payment data yet.</p>
                {% endif %}
            </div>
        </div>
    </div>

    <!-- Payments by term -->
    <div class="col-lg-6">
        <div class="portal-card h-100">
            <div class="portal-card-header">
                <h6 class="mb-0"><i class="fa-solid fa-calendar me-2"></i>Payments by Term</h6>
            </div>
            <div class="portal-card-body p-0">
                {% if payments_by_term %}
                <table class="table table-sm mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>Academic Year</th>
                            <th>Term</th>
                            <th class="text-end">Count</th>
                            <th class="text-end">Total (UGX)</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for row in payments_by_term %}
                        <tr>
                            <td>{{ row.academic_year }}</td>
                            <td>{{ row.term_display }}</td>
                            <td class="text-end text-muted small">{{ row.count }}</td>
                            <td class="text-end fw-semibold">{{ row.total|intcomma }}</td>
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
                {% else %}
                <p class="text-muted text-center py-4 mb-0 small">No payment data yet.</p>
                {% endif %}
            </div>
        </div>
    </div>

    <!-- Certificates by program -->
    <div class="col-lg-6">
        <div class="portal-card h-100">
            <div class="portal-card-header">
                <h6 class="mb-0"><i class="fa-solid fa-certificate me-2"></i>Certificates by Program</h6>
            </div>
            <div class="portal-card-body p-0">
                {% if certificates_by_program %}
                <table class="table table-sm mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>Program</th>
                            <th class="text-end">Issued</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for row in certificates_by_program %}
                        <tr>
                            <td>{{ row.enrollment__program__name|default:"Unknown" }}</td>
                            <td class="text-end">
                                <span class="badge bg-warning text-dark">{{ row.count }}</span>
                            </td>
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
                {% else %}
                <p class="text-muted text-center py-4 mb-0 small">No certificates issued yet.</p>
                {% endif %}
            </div>
        </div>
    </div>

</div>
{% endblock %}