{% extends "exams/base.html" %}
{% block content %}

<div class="container mt-4">
    
<section class="content">
<h2>{{ school.name }} - {{ exam.name }}</h2>





<div class="mb-3">
    <a href="{% url 'exams:download_school_results_excel' exam.id school.school_code %}" class="btn btn-success btn-sm">Export Excel</a>
    <a href="{% url 'exams:download_school_results_pdf' exam.id school.school_code %}" class="btn btn-danger btn-sm">Export PDF</a>
</div>

<table border="1" cellspacing="0" cellpadding="5">
    <thead>
        <tr>
            <th>SCHOOL CODE</th>
            <th>CAND. NO</th>
            <th>NAME</th>
            <th>SEX</th>
            {% for subj in subjects %}
                <th>{{ subj.subject_name_eng }} Numeric_score</th>
                <th>{{ subj.subject_name_eng }} Grade</th>
            {% endfor %}
            <th>POINT</th>
            <th>DIVISION</th>
            <th>AVERAGE</th>
            <th>AVERAGE GRADE</th>
            <th>POSITION</th>
        </tr>
    </thead>
    <tbody>
        {% for row in results %}
        <tr>
            <td>{{ row.school_code }}</td>
            <td>{{ row.cand_no }}</td>
            <td>{{ row.name }}</td>
            <td>{{ row.sex }}</td>
            {% for s in row.subjects %}
                <td>{{ s.numeric_score }}</td>
                <td>{{ s.grade }}</td>
            {% endfor %}
            <td>{{ row.points }}</td>
            <td>{{ row.division }}</td>
            <td>{{ row.average }}</td>
            <td>{{ row.avg_grade }}</td>
            <td>{{ row.position }}</td>
        </tr>
        {% endfor %}
    </tbody>
</table>
</section>
</div>
{% endblock %}