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

{% block page_title %}{{ subject.code }} - Schools Performance{% endblock %}

{% block content %}
<div class="container-fluid mt-4">
    <div class="row mb-3">
        <div class="col">
            <h4 class="fw-bold text-primary">
                <i class="fas fa-school"></i>
                {{ subject.code }} - {{ subject.name }} - Schools Performance
            </h4>
            <p class="text-muted">Project: {{ project.name }} ({{ project.year }})</p>
        </div>
        <div class="col-auto">
            <a href="{% url 'exams:subject_standardization_list' project.id %}" class="btn btn-secondary">
                <i class="fas fa-arrow-left"></i> Back to Subjects
            </a>
        </div>
    </div>

    <div class="card shadow-sm">
        <div class="card-header bg-info text-white">
            <h5 class="mb-0"><i class="fas fa-list"></i> Schools List</h5>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-bordered table-striped table-hover">
                    <thead class="table-dark">
                        <tr>
                            <th>#</th>
                            <th>School Code</th>
                            <th>School Name</th>
                            <th>Sat</th>
                            <th>A</th>
                            <th>B</th>
                            <th>C</th>
                            <th>D</th>
                            <th>E</th>
                            <th>S</th>
                            <th>F</th>
                            <th>#A-E</th>
                            <th>%A-E</th>
                            <th>GPA</th>
                            <th>Min</th>
                            <th>Max</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for school in schools %}
                        <tr>
                            <td>{{ forloop.counter }}</td>
                            <td><strong>{{ school.code }}</strong></td>
                            <td>{{ school.name }}</td>
                            <td>{{ school.total }}</td>
                            <td class="text-success fw-bold">{{ school.A }}</td>
                            <td class="text-primary fw-bold">{{ school.B }}</td>
                            <td class="text-info fw-bold">{{ school.C }}</td>
                            <td class="text-warning fw-bold">{{ school.D }}</td>
                            <td class="text-secondary fw-bold">{{ school.E }}</td>
                            <td class="text-danger fw-bold">{{ school.S }}</td>
                            <td class="text-danger fw-bold">{{ school.F }}</td>
                            <td class="fw-bold">{{ school.a_e_total }}</td>
                            <td>{{ school.a_e_percent }}%</td>
                            <td class="fw-bold bg-light">{{ school.gpa }}</td>
                            <td>{{ school.min_score|default:"-" }}</td>
                            <td>{{ school.max_score|default:"-" }}</td>
                            <td>
                                <a href="{% url 'exams:school_subject_standardization' project.id subject.id school.id %}" 
                                   class="btn btn-sm btn-success">
                                    <i class="fas fa-balance-scale"></i> Standardize
                                </a>
                            </td>
                        </tr>
                        {% empty %}
                        <tr>
                            <td colspan="17" class="text-center py-4">
                                <i class="fas fa-info-circle"></i> No schools found for this subject
                            </td>
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
{% endblock %}