{% extends "base.html" %}
{% load humanize portal_extras %}
{% block title %}Results{% endblock %}
{% block nav_admin_results %}active{% endblock %}

{% block content %}
<div class="page-header">
    <div>
        <h2><i class="fa-solid fa-graduation-cap me-2"></i>Results</h2>
        <p class="text-muted mb-0">All recorded student grades</p>
    </div>
    <a href="{% export_url %}" class="btn btn-success">
        <i class="fa-solid fa-file-excel me-1"></i> Export Excel
    </a>
</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-3">
                <label class="form-label small fw-semibold">Search</label>
                <input type="text" name="q" class="form-control form-control-sm"
                       placeholder="Student name, ID or course…" value="{{ search_query }}">
            </div>
            <div class="col-md-2">
                <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">Term</label>
                <select name="term" class="form-select form-select-sm">
                    <option value="">All Terms</option>
                    {% for val, label in term_choices %}
                    <option value="{{ val }}" {% if current_term == val %}selected{% endif %}>{{ label }}</option>
                    {% endfor %}
                </select>
            </div>
            <div class="col-md-2">
                <label class="form-label small fw-semibold">Grade Type</label>
                <select name="grade_type" class="form-select form-select-sm">
                    <option value="">All Types</option>
                    {% for val, label in grade_type_choices %}
                    <option value="{{ val }}" {% if current_grade_type == val %}selected{% endif %}>{{ label }}</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. 2025/2026" value="{{ current_year }}">
            </div>
            <div class="col-md-1 d-flex gap-1 align-items-end">
                <button type="submit" class="btn btn-primary btn-sm flex-grow-1">
                    <i class="fa-solid fa-filter"></i>
                </button>
                {% if search_query or current_term or current_year or current_program or current_grade_type %}
                <a href="{% url 'grades:admin_results' %}" 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(10,61,98,0.1);color:var(--color-primary);">
                <i class="fa-solid fa-graduation-cap"></i>
            </div>
            <div>
                <div class="stat-value">{{ total_count }}</div>
                <div class="stat-label">Grade Records</div>
            </div>
        </div>
    </div>
</div>

<div class="portal-card">
    <div class="portal-card-body p-0">
        {% if results %}
        <div class="table-responsive">
            <table class="table table-hover mb-0 small">
                <thead class="table-light">
                    <tr>
                        <th>Student</th>
                        <th>Program</th>
                        <th>Course</th>
                        <th>Type</th>
                        <th>Term</th>
                        <th>Year</th>
                        <th class="text-center">Grade</th>
                        <th class="text-center">Marks</th>
                        <th>Recorded By</th>
                        <th>Notes</th>
                    </tr>
                </thead>
                <tbody>
                    {% for result in results %}
                    <tr>
                        <td>
                            <div class="fw-semibold">{{ result.enrollment.student.get_full_name }}</div>
                            <div class="text-muted font-monospace" style="font-size:0.75rem;">{{ result.enrollment.student_number }}</div>
                        </td>
                        <td>{{ result.enrollment.program.name }}</td>
                        <td>{{ result.course.name }}</td>
                        <td>{{ result.get_grade_type_display }}</td>
                        <td>{{ result.get_term_display }}</td>
                        <td>{{ result.academic_year }}</td>
                        <td class="text-center">
                            <span class="badge bg-{{ result.grade_color }}">{{ result.grade }}</span>
                        </td>
                        <td class="text-center">
                            {% if result.marks is not None %}{{ result.marks }}/100{% else %}—{% endif %}
                        </td>
                        <td class="text-muted">{{ result.recorded_by.get_full_name|default:"—" }}</td>
                        <td class="text-muted">{{ result.notes|default:"—"|truncatechars:40 }}</td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
        {% else %}
        <div class="text-center py-5 text-muted">
            <i class="fa-solid fa-graduation-cap fa-2x mb-3 d-block" style="opacity:0.3;"></i>
            <p class="mb-1">No results found{% if search_query or current_term or current_year or current_program %} matching your filters{% endif %}.</p>
            {% if search_query or current_term or current_year or current_program %}
            <a href="{% url 'grades:admin_results' %}" class="btn btn-sm btn-outline-secondary mt-2">Clear filters</a>
            {% endif %}
        </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 }}&term={{ current_term }}&year={{ current_year }}&program={{ current_program }}&grade_type={{ current_grade_type }}">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 }}&term={{ current_term }}&year={{ current_year }}&program={{ current_program }}&grade_type={{ current_grade_type }}">Next</a>
        </li>
        {% endif %}
    </ul>
</nav>
{% endif %}
{% endblock %}