{% extends "exams/base.html" %}
{% load static %}
 
{% block content %}
<div class="container mt-4">
  <div class="d-flex justify-content-between align-items-center mb-3">
    <h3>Region Summary — {{ region.name }} ({{ year }})</h3>
    <div>
      <a class="btn btn-outline-secondary" href="{% url 'exams:region_summary_pdf' %}?region={{ region.id }}&year={{ year }}">Export PDF</a>
      <a class="btn btn-outline-success" href="{% url 'exams:region_summary_excel' %}?region={{ region.id }}&year={{ year }}">Export Excel</a>
    </div>
  </div>

  <div class="card mb-3 p-3">
    <div class="row">
      <div class="col-md-3"><strong>Total Candidates:</strong> {{ totals.total }}</div>
      <div class="col-md-3"><strong>Total Pass:</strong> {{ totals.pass }} ({{ totals.pass_pct }}%)</div>
      <div class="col-md-3"><strong>Male:</strong> {{ totals.male }}</div>
      <div class="col-md-3"><strong>Female:</strong> {{ totals.female }}</div>
    </div>
  </div>

  <div class="table-responsive">
    <table class="table table-striped table-bordered">
      <thead class="table-dark">
        <tr>
          <th>#</th>
          <th>District</th>
          <th>Total</th>
          <th>Pass</th>
          <th>Fail</th>
          <th>Pass %</th>
          <th>Male</th>
          <th>Male Pass</th>
          <th>Female</th>
          <th>Female Pass</th>
        </tr>
      </thead>
      <tbody>
        {% for d in districts %}
        <tr>
          <td>{{ forloop.counter }}</td>
          <td>{{ d.district_name }}</td>
          <td>{{ d.total }}</td>
          <td>{{ d.pass }}</td>
          <td>{{ d.fail }}</td>
          <td>{{ d.pass_pct }}%</td>
          <td>{{ d.male }}</td>
          <td>{{ d.male_pass|default:0 }}</td>
          <td>{{ d.female }}</td>
          <td>{{ d.female_pass|default:0 }}</td>
        </tr>
        {% endfor %}
      </tbody>
    </table>
  </div>
</div>
{% endblock %}