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

{% block page_title %}
School Subject Summary – {{ school.name }} ({{ year }})
{% endblock %}

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

  <!-- HEADER CARD -->
  <div class="card mb-3">
    <div class="card-body text-center">
      <h4 class="fw-bold text-primary">{{ school.name }}</h4>
      <p>
        Ward: <strong>{{ school.ward.name }}</strong> |
        District: <strong>{{ school.district.name }}</strong> |
        Region: <strong>{{ school.district.region.name }}</strong>
      </p>
      <p class="fw-bold">
        Subject: {{ subject_name }} | Year: {{ year }}
      </p>

      <!-- ACTION BUTTONS -->
      <div class="btn-group mt-2">
        <a href="{% url 'exams:school_subject_summary_pdf' %}?school={{ school.school_code }}&year={{ year }}&subject={{ subject_code }}"
           class="btn btn-danger btn-sm">
          PDF
        </a>
        <a href="{% url 'exams:school_subject_summary_excel' %}?school={{ school.school_code }}&year={{ year }}&subject={{ subject_code }}"
           class="btn btn-success btn-sm">
          EXCEL
        </a>
      </div>
    </div>
  </div>

  <!-- TABLE -->
  <div class="card">
    <div class="card-header bg-warning fw-bold">
      Subject Performance Summary
    </div>

    <div class="card-body p-0">
      <table class="table table-bordered table-striped mb-0">
        <thead class="table-dark">
          <tr>
            <th>Subject</th>
            <th>A</th>
            <th>B</th>
            <th>C</th>
            <th>D</th>
            <th>E</th>
            <th>Total</th>
            <th>Pass (A–C)</th>
            <th>Fail (D–E)</th>
            <th>Pass %</th>
            <th>Average</th>
          </tr>
        </thead>

 <tbody>
  {% for r in rows %}
  <tr>
    <td>{{ r.subject }}</td>   {# SUBJECT NAME #}
    <td class="text-center">{{ r.a }}</td>
    <td class="text-center">{{ r.b }}</td>
    <td class="text-center">{{ r.c }}</td>
    <td class="text-center">{{ r.d }}</td>
    <td class="text-center">{{ r.e }}</td>
    <td class="text-center">{{ r.total }}</td>
    <td class="text-center">{{ r.pass }}</td>
    <td class="text-center">{{ r.fail }}</td>
    <td class="text-center">{{ r.pass_pct }}%</td>
    <td class="text-center">{{ r.avg }}</td>
  </tr>
  {% endfor %}

  <!-- GRAND TOTAL -->
  <tr class="table-secondary fw-bold">
    <td>TOTAL</td>
    <td class="text-center">{{ totals.a }}</td>
    <td class="text-center">{{ totals.b }}</td>
    <td class="text-center">{{ totals.c }}</td>
    <td class="text-center">{{ totals.d }}</td>
    <td class="text-center">{{ totals.e }}</td>
    <td class="text-center">{{ totals.total }}</td>
    <td class="text-center">{{ totals.pass }}</td>
    <td class="text-center">{{ totals.fail }}</td>
    <td class="text-center">{{ totals.pass_pct }}%</td>
    <td class="text-center">—</td>
  </tr>
</tbody>

      </table>
    </div>
  </div>

  <div class="mt-3 text-end">
    <a href="javascript:window.history.back()" class="btn btn-secondary">
      ← Back
    </a>
  </div>

</div>
{% endblock %}