{% extends "exams/base.html" %}
{% load static %}
{% load math_tags %}

{% block title %}Region Summary – {{ region.name }} – {{ year }}{% endblock %}

{% block content %}

<style>
    body { font-family: Arial, Helvetica, sans-serif; font-size: 11px; color:#111; }
    table { width: 100%; border-collapse: collapse; margin-bottom: 10px; }
    th, td { border: 1px solid #222; padding: 4px 3px; }

    .header { background:#cfeefc; text-align:center; font-weight:700; font-size:16px; }
    .permision { background:#BEFEF6; font-weight:700; }
    .c_colour { background:#FEFBCC; font-weight:700; }
    .a_colour { background:#FEFB96; font-weight:700; }
    .fail_colour { color:#c00; font-weight:700; }
    .pass_color { background:#BEFEF6; font-weight:700; }

    .center { text-align:center; }
    .bold { font-weight:700; }
</style>


<div class="container mt-4">

  <div class="d-flex justify-content-between mb-3">
    <h3><i class="fas fa-users-cog"></i> General Region Reports</h3>
  </div>


<!-- HEADER -->
<table>
    <tr><th colspan="18" class="header">OFISI YA RAIS - TAMISEMI</th></tr>
    <tr><th colspan="18" class="header">MATOKEO YA DARASA LA SABA - {{ year }}</th></tr>
    <tr><td colspan="18"></td></tr>

    <tr>
        <th colspan="3" style="font-size:15px;">MKOA:</th>
        <th colspan="15" style="font-size:15px;">{{ region.name }}</th>
    </tr>
</table>


<!-- =======================================================
     WANAFUNZI SECTION
======================================================= -->
<table>

<tr><th colspan="18" class="permision">WANAFUNZI</th></tr>

<tr>
    <th colspan="4" rowspan="2">-</th>
    <th colspan="4">WASICHANA</th>
    <th colspan="4">WAVULANA</th>
    <th colspan="6">JUMLA</th>
</tr>

<tr>
    <th colspan="2">NA</th><th colspan="2">%</th>
    <th colspan="2">NA</th><th colspan="2">%</th>
    <th colspan="3">NA</th><th colspan="3">%</th>
</tr>


<!-- REGISTERED -->
<tr>
    <td colspan="4" class="bold">WALIOSAJILIWA</td>

    <td colspan="2" class="center">{{ totals.reg_f }}</td>
    <td colspan="2" class="center">{{ totals.reg_f|safe_pct:totals.reg }}</td>

    <td colspan="2" class="center">{{ totals.reg_m }}</td>
    <td colspan="2" class="center">{{ totals.reg_m|safe_pct:totals.reg }}</td>

    <td colspan="3" class="center">{{ totals.reg }}</td>
    <td colspan="3" class="center">100</td>
</tr>


<!-- WITH RESULTS -->
<tr>
    <td colspan="4" class="bold">WENYE MATOKEO</td>

    <td colspan="2" class="center a_colour">{{ totals.sat_f }}</td>
    <td colspan="2" class="center">{{ totals.sat_f|safe_pct:totals.reg }}</td>

    <td colspan="2" class="center a_colour">{{ totals.sat_m }}</td>
    <td colspan="2" class="center">{{ totals.sat_m|safe_pct:totals.reg }}</td>

    <td colspan="3" class="center a_colour">{{ totals.sat }}</td>
    <td colspan="3" class="center">{{ totals.sat|safe_pct:totals.reg }}</td>
</tr>


<!-- ABSENT -->
<tr>
    <td colspan="4" class="bold">WASIOFANYA</td>

    <td colspan="2" class="center">{{ totals.abs_f }}</td>
    <td colspan="2" class="center">{{ totals.abs_f|safe_pct:totals.reg }}</td>

    <td colspan="2" class="center">{{ totals.abs_m }}</td>
    <td colspan="2" class="center">{{ totals.abs_m|safe_pct:totals.reg }}</td>

    <td colspan="3" class="center">{{ totals.abs }}</td>
    <td colspan="3" class="center">{{ totals.abs|safe_pct:totals.reg }}</td>
</tr>


<!-- AVERAGE -->
<tr class="permision">
    <td colspan="4" class="bold">WASTANI WA JML</td>
    <td colspan="4" class="center">{{ totals.avg }}</td>
    <td colspan="5" class="center">{{ totals.grade }}</td>
    <td colspan="5" class="center">{{ totals.status }}</td>
</tr>


<!-- SCHOOL COUNT -->
<tr>
    <td colspan="4" class="bold">JUMLA YA SHULE</td>
    <td colspan="14" class="center">{{ totals.school_count }}</td>
</tr>

</table>



<!-- =======================================================
     UFAULU WA MADARAJA - GENERAL (A–E)
======================================================= -->
<table>

<tr><th colspan="18" class="c_colour">UFAULU WA MADARAJA – JUMLA</th></tr>

<tr>
    <th colspan="2" rowspan="2">DARAJA | JINSI</th>
    <th colspan="2">A</th><th colspan="2">B</th><th colspan="2">C</th>
    <th colspan="2">D</th><th colspan="2">E</th>
    <th colspan="4">PASS A–C</th>
    <th colspan="2">FAIL D–E</th>
</tr>

<tr>
    <th>NO</th><th>%</th>
    <th>NO</th><th>%</th>
    <th>NO</th><th>%</th>
    <th>NO</th><th>%</th>
    <th>NO</th><th>%</th>
    <th colspan="3">NO</th><th>%</th>
    <th>NO</th><th>%</th>
</tr>


<!-- WASICHANA -->
<tr>
    <td colspan="2" class="bold">WAS</td>

    <td class="center">{{ grades.af }}</td>
    <td class="center">{{ grades.af|safe_pct:totals.sat_f }}</td>

    <td class="center">{{ grades.bf }}</td>
    <td class="center">{{ grades.bf|safe_pct:totals.sat_f }}</td>

    <td class="center">{{ grades.cf }}</td>
    <td class="center">{{ grades.cf|safe_pct:totals.sat_f }}</td>

    <td class="center">{{ grades.df }}</td>
    <td class="center">{{ grades.df|safe_pct:totals.sat_f }}</td>

    <td class="center">{{ grades.ef }}</td>
    <td class="center">{{ grades.ef|safe_pct:totals.sat_f }}</td>

    <td colspan="3" class="center">{{ a_c_f }}</td>
    <td class="center">{{ a_c_f|safe_pct:totals.sat_f }}</td>

    <td class="center">{{ grades.df|add:grades.ef }}</td>
    <td class="center fail_colour">
        {% with sum=grades.df|add:grades.ef %}
            {{ sum|safe_pct:totals.sat_f }}
        {% endwith %}
    </td>
</tr>


<!-- WAVULANA -->
<tr>
    <td colspan="2" class="bold">WAV</td>

    <td class="center">{{ grades.am }}</td>
    <td class="center">{{ grades.am|safe_pct:totals.sat_m }}</td>

    <td class="center">{{ grades.bm }}</td>
    <td class="center">{{ grades.bm|safe_pct:totals.sat_m }}</td>

    <td class="center">{{ grades.cm }}</td>
    <td class="center">{{ grades.cm|safe_pct:totals.sat_m }}</td>

    <td class="center">{{ grades.dm }}</td>
    <td class="center">{{ grades.dm|safe_pct:totals.sat_m }}</td>

    <td class="center">{{ grades.em }}</td>
    <td class="center">{{ grades.em|safe_pct:totals.sat_m }}</td>

    <td colspan="3" class="center">{{ a_c_m }}</td>
    <td class="center">{{ a_c_m|safe_pct:totals.sat_m }}</td>

    <td class="center">{{ grades.dm|add:grades.em }}</td>
    <td class="center fail_colour">
        {% with sum=grades.dm|add:grades.em %}
            {{ sum|safe_pct:totals.sat_m }}
        {% endwith %}
    </td>
</tr>


<!-- TOTAL -->
<tr>
    <td colspan="2" class="bold">JUMLA</td>

    <td class="center">{{ grades.a }}</td>
    <td class="center">{{ grades.a|safe_pct:totals.sat }}</td>

    <td class="center">{{ grades.b }}</td>
    <td class="center">{{ grades.b|safe_pct:totals.sat }}</td>

    <td class="center">{{ grades.c }}</td>
    <td class="center">{{ grades.c|safe_pct:totals.sat }}</td>

    <td class="center">{{ grades.d }}</td>
    <td class="center">{{ grades.d|safe_pct:totals.sat }}</td>

    <td class="center">{{ grades.e }}</td>
    <td class="center">{{ grades.e|safe_pct:totals.sat }}</td>

    <td colspan="3" class="center">{{ a_c_total }}</td>
    <td class="center pass_color">{{ a_c_total|safe_pct:totals.sat }}</td>

    <td class="center">{{ grades.d|add:grades.e }}</td>
    <td class="center fail_colour">
        {% with sum=grades.d|add:grades.e %}
            {{ sum|safe_pct:totals.sat }}
        {% endwith %}
    </td>
</tr>

</table>



<!-- =======================================================
     OWNERSHIP (GOVT vs NON-GOVT)
======================================================= -->
{% for o in ownership %}
<table>

<tr><th colspan="18" class="permision">
    UFAULU WA MADARAJA – {{ o.owner }} – SHULE {{ o.total_school }} – WALIOFANYA {{ o.sat }}
</th></tr>

<tr>
    <th colspan="2" rowspan="2">DARAJA | JINSI</th>
    <th colspan="2">A</th><th colspan="2">B</th><th colspan="2">C</th>
    <th colspan="2">D</th><th colspan="2">E</th>
    <th colspan="4">PASS A–C</th>
    <th colspan="2">FAIL D–E</th>
</tr>

<tr>
    <th>NO</th><th>%</th>
    <th>NO</th><th>%</th>
    <th>NO</th><th>%</th>
    <th>NO</th><th>%</th>
    <th>NO</th><th>%</th>
    <th colspan="3">NO</th><th>%</th>
    <th>NO</th><th>%</th>
</tr>


<!-- WAS -->
<tr>
    <td colspan="2" class="bold">WAS</td>

    <td class="center">{{ o.af }}</td>
    <td class="center">{{ o.af|safe_pct:o.sat_f }}</td>

    <td class="center">{{ o.bf }}</td>
    <td class="center">{{ o.bf|safe_pct:o.sat_f }}</td>

    <td class="center">{{ o.cf }}</td>
    <td class="center">{{ o.cf|safe_pct:o.sat_f }}</td>

    <td class="center">{{ o.df }}</td>
    <td class="center">{{ o.df|safe_pct:o.sat_f }}</td>

    <td class="center">{{ o.ef }}</td>
    <td class="center">{{ o.ef|safe_pct:o.sat_f }}</td>

    <td colspan="3" class="center">
        {% with pass_sum=o.af|add:o.bf|add:o.cf %}
            {{ pass_sum }}
        {% endwith %}
    </td>
    <td class="center">
        {% with pass_sum=o.af|add:o.bf|add:o.cf %}
            {{ pass_sum|safe_pct:o.sat_f }}
        {% endwith %}
    </td>

    <td class="center">{{ o.df|add:o.ef }}</td>
    <td class="center fail_colour">
        {% with fail_sum=o.df|add:o.ef %}
            {{ fail_sum|safe_pct:o.sat_f }}
        {% endwith %}
    </td>
</tr>


<!-- WAV -->
<tr>
    <td colspan="2" class="bold">WAV</td>

    <td class="center">{{ o.am }}</td>
    <td class="center">{{ o.am|safe_pct:o.sat_m }}</td>

    <td class="center">{{ o.bm }}</td>
    <td class="center">{{ o.bm|safe_pct:o.sat_m }}</td>

    <td class="center">{{ o.cm }}</td>
    <td class="center">{{ o.cm|safe_pct:o.sat_m }}</td>

    <td class="center">{{ o.dm }}</td>
    <td class="center">{{ o.dm|safe_pct:o.sat_m }}</td>

    <td class="center">{{ o.em }}</td>
    <td class="center">{{ o.em|safe_pct:o.sat_m }}</td>

    <td colspan="3" class="center">
        {% with pass_sum=o.am|add:o.bm|add:o.cm %}
            {{ pass_sum }}
        {% endwith %}
    </td>
    <td class="center">
        {% with pass_sum=o.am|add:o.bm|add:o.cm %}
            {{ pass_sum|safe_pct:o.sat_m }}
        {% endwith %}
    </td>

    <td class="center">{{ o.dm|add:o.em }}</td>
    <td class="center fail_colour">
        {% with fail_sum=o.dm|add:o.em %}
            {{ fail_sum|safe_pct:o.sat_m }}
        {% endwith %}
    </td>
</tr>


<!-- JUMLA -->
<tr>
    <td colspan="2" class="bold">JUMLA</td>

    <td class="center bold">
        {% with sum=o.af|add:o.am %}
            {{ sum }}
        {% endwith %}
    </td>
    <td class="center">
        {% with sum=o.af|add:o.am %}
            {{ sum|safe_pct:o.sat }}
        {% endwith %}
    </td>

    <td class="center bold">
        {% with sum=o.bf|add:o.bm %}
            {{ sum }}
        {% endwith %}
    </td>
    <td class="center">
        {% with sum=o.bf|add:o.bm %}
            {{ sum|safe_pct:o.sat }}
        {% endwith %}
    </td>

    <td class="center bold">
        {% with sum=o.cf|add:o.cm %}
            {{ sum }}
        {% endwith %}
    </td>
    <td class="center">
        {% with sum=o.cf|add:o.cm %}
            {{ sum|safe_pct:o.sat }}
        {% endwith %}
    </td>

    <td class="center bold">
        {% with sum=o.df|add:o.dm %}
            {{ sum }}
        {% endwith %}
    </td>
    <td class="center">
        {% with sum=o.df|add:o.dm %}
            {{ sum|safe_pct:o.sat }}
        {% endwith %}
    </td>

    <td class="center bold">
        {% with sum=o.ef|add:o.em %}
            {{ sum }}
        {% endwith %}
    </td>
    <td class="center">
        {% with sum=o.ef|add:o.em %}
            {{ sum|safe_pct:o.sat }}
        {% endwith %}
    </td>

    <td colspan="3" class="center bold">
        {% with pass_sum=o.af|add:o.bf|add:o.cf|add:o.am|add:o.bm|add:o.cm %}
            {{ pass_sum }}
        {% endwith %}
    </td>
    <td class="center pass_color">
        {% with pass_sum=o.af|add:o.bf|add:o.cf|add:o.am|add:o.bm|add:o.cm %}
            {{ pass_sum|safe_pct:o.sat }}
        {% endwith %}
    </td>

    <td class="center">
        {% with fail_sum=o.df|add:o.ef|add:o.dm|add:o.em %}
            {{ fail_sum }}
        {% endwith %}
    </td>
    <td class="center fail_colour">
        {% with fail_sum=o.df|add:o.ef|add:o.dm|add:o.em %}
            {{ fail_sum|safe_pct:o.sat }}
        {% endwith %}
    </td>

</tr>

</table>

{% endfor %}


<!-- =======================================================
     DISTRICT SUMMARY TABLE
======================================================= -->
<table>
    <tr>
        <th>District</th>
        <th>Total</th>
        <th>Pass</th>
        <th>Fail</th>
        <th>Pass %</th>
        <th>Male</th>
        <th>Female</th>
    </tr>

    {% for d in districts %}
    <tr>
        <td>{{ d.district_name }}</td>
        <td class="center">{{ d.total }}</td>
        <td class="center">{{ d.pass }}</td>
        <td class="center">{{ d.fail }}</td>
        <td class="center">{{ d.pass_pct }}</td>
        <td class="center">{{ d.male }}</td>
        <td class="center">{{ d.female }}</td>
    </tr>
    {% endfor %}

    <tr class="bold">
        <td>TOTAL</td>
        <td class="center">{{ districts_totals.total }}</td>
        <td class="center">{{ districts_totals.pass }}</td>
        <td class="center">{{ districts_totals.fail }}</td>
        <td class="center">{{ districts_totals.pass_pct }}</td>
        <td class="center">{{ districts_totals.male }}</td>
        <td class="center">{{ districts_totals.female }}</td>
    </tr>
</table>

<!-- 🔵 EXPORT BUTTONS -->
<div style="margin-bottom:15px; text-align:right;">
    <a href="{% url 'exams:region_summary_pdf_redesigned' %}?region={{ region.id }}&year={{ year }}" 
       target="_blank"
       class="btn btn-danger"
       style="padding:6px 12px; font-weight:bold; background:#c62828; color:white; text-decoration:none;">
        OPEN PDF
    </a>

    <a href="{% url 'exams:region_summary_excel' %}?region={{ region.id }}&year={{ year }}" 
       target="_blank"
       class="btn btn-success"
       style="padding:6px 12px; font-weight:bold; background:#2e7d32; color:white; text-decoration:none;">
        OPEN EXCEL
    </a>
</div>

{% endblock %}