{% extends 'base.html' %}
{% load static %}

{% block title %}Invoices - Rapha-Bethel BNPS{% endblock %}

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

    <!-- Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1 class="h3 mb-0 text-gray-800">Fee Invoices</h1>
        <div class="btn-group">
            <a href="{% url 'finance:bulk_invoice' %}" class="btn btn-success">
                <i class="fas fa-bolt"></i> Generate for All Students
            </a>
            <a href="{% url 'finance:invoice_create' %}" class="btn btn-primary">
                <i class="fas fa-plus"></i> Create Invoice
            </a>
            <a href="{% url 'finance:export_invoices' %}" class="btn btn-outline-secondary">
                <i class="fas fa-download"></i> Export CSV
            </a>
        </div>
    </div>

    <!-- Stats Cards -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card border-left-primary shadow h-100 py-2">
                <div class="card-body">
                    <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Total Invoiced</div>
                    <div class="h5 mb-0 font-weight-bold text-gray-800">{{ total_amount|floatformat:0 }} XAF</div>
                    <small class="text-muted">{{ total_invoices }} invoice{{ total_invoices|pluralize }}</small>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card border-left-success shadow h-100 py-2">
                <div class="card-body">
                    <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Total Paid</div>
                    <div class="h5 mb-0 font-weight-bold text-gray-800">{{ total_paid|floatformat:0 }} XAF</div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card border-left-warning shadow h-100 py-2">
                <div class="card-body">
                    <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">Outstanding Balance</div>
                    <div class="h5 mb-0 font-weight-bold text-gray-800">{{ total_balance|floatformat:0 }} XAF</div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card border-left-danger shadow h-100 py-2">
                <div class="card-body">
                    <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">Overdue</div>
                    <div class="h5 mb-0 font-weight-bold text-gray-800">
                        {{ invoices|length }} shown
                    </div>
                    <a href="?status=overdue" class="small text-danger">View overdue</a>
                </div>
            </div>
        </div>
    </div>

    <!-- Search & Filter -->
    <div class="card shadow mb-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-primary">Search & Filter</h6>
        </div>
        <div class="card-body">
            <form method="get" class="row g-3">
                <div class="col-md-4">
                    <div class="input-group">
                        <input type="text" class="form-control" name="q"
                               placeholder="Search by invoice #, student name…"
                               value="{{ request.GET.q }}">
                        <button class="btn btn-primary" type="submit">
                            <i class="fas fa-search"></i>
                        </button>
                    </div>
                </div>
                <div class="col-md-2">
                    <select class="form-control" name="status">
                        <option value="">All Statuses</option>
                        {% for val, label in status_choices %}
                        <option value="{{ val }}" {% if request.GET.status == val %}selected{% endif %}>
                            {{ label }}
                        </option>
                        {% endfor %}
                    </select>
                </div>
                <div class="col-md-2">
                    <select class="form-control" name="academic_year">
                        <option value="">All Years</option>
                        {% for year in academic_years %}
                        <option value="{{ year }}" {% if request.GET.academic_year == year %}selected{% endif %}>
                            {{ year }}
                        </option>
                        {% endfor %}
                    </select>
                </div>
                <div class="col-md-2">
                    <select class="form-control" name="term">
                        <option value="">All Terms</option>
                        <option value="1" {% if request.GET.term == "1" %}selected{% endif %}>Term 1</option>
                        <option value="2" {% if request.GET.term == "2" %}selected{% endif %}>Term 2</option>
                        <option value="3" {% if request.GET.term == "3" %}selected{% endif %}>Term 3</option>
                    </select>
                </div>
                <div class="col-md-2 d-flex gap-2">
                    <button type="submit" class="btn btn-primary flex-fill">
                        <i class="fas fa-filter"></i> Filter
                    </button>
                    <a href="{% url 'finance:invoice_list' %}" class="btn btn-outline-secondary">
                        <i class="fas fa-times"></i>
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Invoices Table -->
    <div class="card shadow">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-primary">
                All Invoices
                {% if request.GET.q or request.GET.status or request.GET.academic_year %}
                <span class="badge bg-info ms-2">Filtered</span>
                {% endif %}
            </h6>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>Invoice #</th>
                            <th>Student</th>
                            <th>Academic Year</th>
                            <th>Term</th>
                            <th>Total (XAF)</th>
                            <th>Paid (XAF)</th>
                            <th>Balance (XAF)</th>
                            <th>Due Date</th>
                            <th>Status</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for invoice in invoices %}
                        <tr>
                            <td><a href="{% url 'finance:invoice_detail' invoice.pk %}">{{ invoice.invoice_number }}</a></td>
                            <td>
                                <a href="{% url 'students:student_detail' invoice.student.pk %}">
                                    {{ invoice.student.get_full_name }}
                                </a>
                            </td>
                            <td>{{ invoice.academic_year }}</td>
                            <td>{{ invoice.get_term_display }}</td>
                            <td>{{ invoice.total_amount|floatformat:0 }}</td>
                            <td class="text-success">{{ invoice.amount_paid|floatformat:0 }}</td>
                            <td class="{% if invoice.balance > 0 %}text-danger fw-bold{% else %}text-success{% endif %}">
                                {{ invoice.balance|floatformat:0 }}
                            </td>
                            <td>
                                <span class="{% if invoice.due_date < today and invoice.status != 'paid' %}text-danger fw-bold{% endif %}">
                                    {{ invoice.due_date|date:"d M Y" }}
                                </span>
                            </td>
                            <td>
                                <span class="badge bg-{% if invoice.status == 'paid' %}success{% elif invoice.status == 'overdue' %}danger{% elif invoice.status == 'partial' %}warning{% elif invoice.status == 'sent' %}info{% else %}secondary{% endif %}">
                                    {{ invoice.get_status_display }}
                                </span>
                            </td>
                            <td>
                                <a href="{% url 'finance:invoice_detail' invoice.pk %}" class="btn btn-sm btn-outline-primary" title="View">
                                    <i class="fas fa-eye"></i>
                                </a>
                                <a href="{% url 'finance:invoice_edit' invoice.pk %}" class="btn btn-sm btn-outline-warning" title="Edit">
                                    <i class="fas fa-edit"></i>
                                </a>
                                <a href="{% url 'finance:payment_add' %}?invoice={{ invoice.pk }}" class="btn btn-sm btn-outline-success" title="Record Payment">
                                    <i class="fas fa-money-bill"></i>
                                </a>
                            </td>
                        </tr>
                        {% empty %}
                        <tr>
                            <td colspan="10" class="text-center py-5 text-muted">
                                <i class="fas fa-file-invoice fa-3x mb-3 d-block"></i>
                                No invoices found.
                                {% if not request.GET.q and not request.GET.status %}
                                <a href="{% url 'finance:invoice_create' %}">Create the first invoice</a>
                                {% endif %}
                            </td>
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- Pagination -->
    {% if is_paginated %}
    <nav class="mt-4">
        <ul class="pagination justify-content-center">
            {% if page_obj.has_previous %}
            <li class="page-item">
                <a class="page-link" href="?page={{ page_obj.previous_page_number }}{% if request.GET.q %}&q={{ request.GET.q }}{% endif %}{% if request.GET.status %}&status={{ request.GET.status }}{% endif %}">
                    &laquo; Previous
                </a>
            </li>
            {% endif %}
            {% for num in page_obj.paginator.page_range %}
            {% if page_obj.number == num %}
            <li class="page-item active"><a class="page-link" href="#">{{ num }}</a></li>
            {% elif num > page_obj.number|add:'-3' and num < page_obj.number|add:'3' %}
            <li class="page-item">
                <a class="page-link" href="?page={{ num }}{% if request.GET.q %}&q={{ request.GET.q }}{% endif %}{% if request.GET.status %}&status={{ request.GET.status }}{% endif %}">
                    {{ num }}
                </a>
            </li>
            {% endif %}
            {% endfor %}
            {% if page_obj.has_next %}
            <li class="page-item">
                <a class="page-link" href="?page={{ page_obj.next_page_number }}{% if request.GET.q %}&q={{ request.GET.q }}{% endif %}{% if request.GET.status %}&status={{ request.GET.status }}{% endif %}">
                    Next &raquo;
                </a>
            </li>
            {% endif %}
        </ul>
    </nav>
    {% endif %}

</div>
{% endblock %}