{% extends "base.html" %}
{% load portal_extras %}
{% block title %}Certificates{% endblock %}
{% block nav_certificates %}active{% endblock %}

{% block content %}
<div class="page-header">
    <div>
        <h2><i class="fa-solid fa-certificate me-2"></i>Certificates</h2>
        <p class="text-muted mb-0">UVTAB certificate issuance records</p>
    </div>
    <div class="d-flex gap-2">
        <a href="{% export_url %}" class="btn btn-success">
            <i class="fa-solid fa-file-excel me-1"></i> Export Excel
        </a>
        <a href="{% url 'portal:certificate_add' %}" class="btn btn-primary">
            <i class="fa-solid fa-plus me-1"></i> Record Certificate
        </a>
    </div>
</div>

<!-- Filters -->
<form method="get" class="portal-card mb-4">
    <div class="portal-card-body">
        <div class="row g-3 align-items-end">
            <div class="col-md-5">
                <label class="form-label small fw-semibold">Search</label>
                <input type="text" name="q" class="form-control form-control-sm"
                       placeholder="Student name or certificate number…" value="{{ search_query }}">
            </div>
            <div class="col-md-3">
                <label class="form-label small fw-semibold">Program</label>
                <select name="program" class="form-select form-select-sm">
                    <option value="">All Programs</option>
                    {% for prog in programs %}
                    <option value="{{ prog.pk }}"
                        {% if current_program == prog.pk|stringformat:"s" %}selected{% endif %}>
                        {{ prog.name }}
                    </option>
                    {% endfor %}
                </select>
            </div>
            <div class="col-md-2">
                <label class="form-label small fw-semibold">Academic Year</label>
                <input type="text" name="year" class="form-control form-control-sm"
                       placeholder="e.g. 2024/2025" value="{{ current_year }}">
            </div>
            <div class="col-md-2 d-flex gap-1">
                <button type="submit" class="btn btn-primary btn-sm flex-grow-1">
                    <i class="fa-solid fa-filter me-1"></i> Filter
                </button>
                {% if search_query or current_program or current_year %}
                <a href="{% url 'portal:certificate_list' %}" class="btn btn-outline-secondary btn-sm" title="Clear">
                    <i class="fa-solid fa-xmark"></i>
                </a>
                {% endif %}
            </div>
        </div>
    </div>
</form>

<!-- Summary -->
<div class="row g-3 mb-4">
    <div class="col-sm-6 col-lg-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">{{ certificates.count }}</div>
                <div class="stat-label">Certificates Issued</div>
            </div>
        </div>
    </div>
</div>

<div class="portal-card">
    <div class="portal-card-body p-0">
        {% if certificates %}
        <div class="table-responsive">
            <table class="table table-hover mb-0">
                <thead class="table-light">
                    <tr>
                        <th>Student</th>
                        <th>Program</th>
                        <th>Level</th>
                        <th>Certificate No.</th>
                        <th>Issue Date</th>
                        <th>Year</th>
                        <th>File</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    {% for cert in certificates %}
                    <tr>
                        <td>
                            <a href="{% url 'portal:student_detail' cert.enrollment.pk %}"
                               class="fw-semibold text-decoration-none">
                                {{ cert.enrollment.student.get_full_name }}
                            </a>
                            <div class="text-muted small">{{ cert.enrollment.student_number }}</div>
                        </td>
                        <td class="small">{{ cert.enrollment.program.name }}</td>
                        <td>
                            <span class="badge bg-warning text-dark">
                                {{ cert.enrollment.program.get_level_display }}
                            </span>
                        </td>
                        <td class="small">{{ cert.certificate_number|default:"—" }}</td>
                        <td class="small text-nowrap">{{ cert.issue_date|date:"d M Y" }}</td>
                        <td class="small">{{ cert.academic_year }}</td>
                        <td>
                            {% if cert.certificate_file %}
                            <a href="{{ cert.certificate_file.url }}" target="_blank"
                               class="btn btn-xs btn-outline-success" title="Download file">
                                <i class="fa-solid fa-paperclip me-1"></i> View
                            </a>
                            {% else %}
                            <span class="text-muted small">—</span>
                            {% endif %}
                        </td>
                        <td>
                            <div class="d-flex gap-1">
                                <a href="{% url 'portal:certificate_edit' cert.pk %}"
                                   class="btn btn-xs btn-outline-secondary" title="Edit">
                                    <i class="fa-solid fa-pen"></i>
                                </a>
                                <a href="{% url 'portal:certificate_delete' cert.pk %}"
                                   class="btn btn-xs btn-outline-danger" title="Delete">
                                    <i class="fa-solid fa-trash"></i>
                                </a>
                            </div>
                        </td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
        {% else %}
        <div class="text-center py-5 text-muted">
            <i class="fa-solid fa-certificate fa-2x mb-3 d-block" style="color:var(--color-secondary);opacity:0.5;"></i>
            <p class="mb-2">No certificates recorded yet.</p>
            <a href="{% url 'portal:certificate_add' %}" class="btn btn-sm btn-primary">
                <i class="fa-solid fa-plus me-1"></i> Record First Certificate
            </a>
        </div>
        {% endif %}
    </div>
</div>

{% 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 }}&q={{ search_query }}&program={{ current_program }}&year={{ current_year }}">Previous</a>
        </li>
        {% endif %}
        <li class="page-item disabled">
            <span class="page-link">Page {{ page_obj.number }} of {{ page_obj.paginator.num_pages }}</span>
        </li>
        {% if page_obj.has_next %}
        <li class="page-item">
            <a class="page-link" href="?page={{ page_obj.next_page_number }}&q={{ search_query }}&program={{ current_program }}&year={{ current_year }}">Next</a>
        </li>
        {% endif %}
    </ul>
</nav>
{% endif %}
{% endblock %}