{% 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:4px; text-align:center; }
.header { background:#CFEAFB; font-weight:bold; font-size:14px; text-align:center; }
.subheader { background:#E2F7FD; font-weight:bold; }
.left { text-align:left; }
.small { font-size:11px; color:#333; }
</style>

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

    <tr class="subheader">
        <th>No</th>
        <th style="text-align:left">CODE</th>
        <th style="text-align:left">NAME</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">STD</th>
        <th colspan="3">Pass (F/M/T)</th>
        <th rowspan="2">% Pass</th>
        <th rowspan="2">Avg Score</th>
    </tr>

    <tr class="subheader">
        <th></th>
        <th></th>
        <th></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 s in schools %}
    <tr>
        <td>{{ s.rank }}</td>
        <td style="text-align:left">{{ s.school_code }}</td>
        <td style="text-align:left">{{ s.name }}</td>

        <td>{{ s.af }}</td><td>{{ s.am }}</td><td>{{ s.a }}</td>
        <td>{{ s.bf }}</td><td>{{ s.bm }}</td><td>{{ s.b }}</td>
        <td>{{ s.cf }}</td><td>{{ s.cm }}</td><td>{{ s.c }}</td>
        <td>{{ s.df }}</td><td>{{ s.dm }}</td><td>{{ s.d }}</td>
        <td>{{ s.ef }}</td><td>{{ s.em }}</td><td>{{ s.e }}</td>

        <td>{{ s.total_std }}</td>

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

        <td>{{ s.pass_pct }}</td>
        <td>{{ s.avg_score }}</td>
    </tr>
    {% endfor %}

    <tr class="subheader">
        <td colspan="3" class="left">TOTAL</td>

        <td>{{ totals.af }}</td><td>{{ totals.am }}</td><td>{{ totals.a }}</td>
        <td>{{ totals.bf }}</td><td>{{ totals.bm }}</td><td>{{ totals.b }}</td>
        <td>{{ totals.cf }}</td><td>{{ totals.cm }}</td><td>{{ totals.c }}</td>
        <td>{{ totals.df }}</td><td>{{ totals.dm }}</td><td>{{ totals.d }}</td>
        <td>{{ totals.ef }}</td><td>{{ totals.em }}</td><td>{{ totals.e }}</td>

        <td>{{ totals.total_std }}</td>

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

        <td>-</td>
        <td>{{ totals.avg_score }}</td>
    </tr>
</table>