{% load math_tags %}

<style>
    table.rank-table {
        width: 100%;
        border-collapse: collapse;
        font-size: 10px;
    }
    table.rank-table th,
    table.rank-table td {
        border: 1px solid #222;
        padding: 3px;
        text-align: center;
    }
    .header {
        background: #CFEAFB;
        font-weight: bold;
        font-size: 15px;
        text-align: center;
    }
    .subheader {
        background: #E2F7FD;
        font-weight: bold;
    }
    .bold { font-weight: bold; }
</style>


<table class="rank-table">
    <tr>
        <th colspan="30" class="header">
            WARD RANKING – {{ region.name }} – {{ year }}
        </th>
    </tr>

    <tr class="subheader">
        <th rowspan="2">NO</th>
        <th rowspan="2" style="text-align:left;">WARD NAME</th>
        <th rowspan="2" style="text-align:left;">DISTRICT</th>
        <th colspan="3">A</th>
        <th colspan="3">B</th>
        <th colspan="3">C</th>
        <th colspan="3">D</th>
        <th colspan="3">E</th>

        <th rowspan="2">TOTAL</th>
        <th rowspan="2">SCH</th>

        <th colspan="3">PASS A–C</th>
        <th colspan="3">% PASS</th>

        <th rowspan="2">AVG</th>
    </tr>

    <tr class="subheader">
        <th>F</th><th>M</th><th>T</th>
        <th>F</th><th>M</th><th>T</th>
        <th>F</th><th>M</th><th>T</th>
        <th>F</th><th>M</th><th>T</th>
        <th>F</th><th>M</th><th>T</th>

        <th>F</th><th>M</th><th>T</th>
        <th>F%</th><th>M%</th><th>T%</th>
    </tr>

    {% for w in wards %}
    <tr>
        <td>{{ w.rank }}</td>
        <td style="text-align:left;">{{ w.name }}</td>
        <td style="text-align:left;">{{ w.district }}</td>
        <td>{{ w.af }}</td><td>{{ w.am }}</td><td>{{ w.a }}</td>
        <td>{{ w.bf }}</td><td>{{ w.bm }}</td><td>{{ w.b }}</td>
        <td>{{ w.cf }}</td><td>{{ w.cm }}</td><td>{{ w.c }}</td>
        <td>{{ w.df }}</td><td>{{ w.dm }}</td><td>{{ w.d }}</td>
        <td>{{ w.ef }}</td><td>{{ w.em }}</td><td>{{ w.e }}</td>

        <td>{{ w.total_std }}</td>
        <td>{{ w.total_schools }}</td>

        <td>{{ w.pass_f }}</td>
        <td>{{ w.pass_m }}</td>
        <td>{{ w.pass_t }}</td>

        <td>{{ w.pass_f|safe_pct:w.total_std }}</td>
        <td>{{ w.pass_m|safe_pct:w.total_std }}</td>
        <td>{{ w.pass_t|safe_pct:w.total_std }}</td>

        <td>{{ w.avg_score }}</td>
    </tr>
    {% endfor %}
</table>