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

{% block page_title %}
{{ title }}
{% endblock %}

{% block content %}

<style>
@media print {
  body {
    zoom: 90%;
  }
  button, .btn, .no-print {
    display: none !important;
  }
  .card {
    border: none !important;
  }
}
</style>

<div class="container-fluid mt-3">
  <!-- ================= HEADER ================= -->
  <div class="card">
    <div class="card-header bg-success text-white fw-bold text-center">
      {{ title }} – {{ year }}
      
      <span class="ms-3 no-print">
        <a href="{% url 'exams:project_school_ranking_print' project.id %}?{% if district_id %}district={{ district_id }}{% elif region_id %}region={{ region_id }}{% endif %}"
           class="btn btn-sm btn-light fw-bold" target="_blank">
           PRINT
        </a>
        
        <a href="{% url 'exams:project_school_ranking_excel' project.id %}?{% if district_id %}district={{ district_id }}{% elif region_id %}region={{ region_id }}{% endif %}"
           class="btn btn-sm btn-warning fw-bold">
           EXCEL
        </a>
        
        <a href="{% url 'exams:project_school_ranking_pdf' project.id %}?{% if district_id %}district={{ district_id }}{% elif region_id %}region={{ region_id }}{% endif %}"
           class="btn btn-sm btn-danger fw-bold">
           PDF
        </a>
      </span>
    </div>
    
    <div class="card-body p-0">
      <div class="table-responsive">
        <table class="table table-bordered table-striped table-hover mb-0">
          <thead class="table-dark text-center">
            <tr>
              <th>#</th>
              <th>CODE</th>
              <th>SCHOOL NAME</th>
              <th>DISTRICT</th>
              <th>REGION</th>
              <th>OWN</th>
              <th>I</th>
              <th>II</th>
              <th>III</th>
              <th>IV</th>
              <th>0</th>
              <th>#I-IV</th>
              <th>%I-IV</th>
              <th>GPA</th>
              <th>GRADE</th>
              <th>STATUS</th>
            </tr>
          </thead>
          <tbody class="text-center">
            {% for r in rows %}
            <tr>
              <td><strong>{{ r.rank }}</strong></td>
              <td>{{ r.code }}</td>
              <td class="text-start">{{ r.name }}</td>
              <td>{{ r.district }}</td>
              <td>{{ r.region }}</td>
              <td>{{ r.ownership|slice:":3" }}</td>
              <td>{{ r.d1 }}</td>
              <td>{{ r.d2 }}</td>
              <td>{{ r.d3 }}</td>
              <td>{{ r.d4 }}</td>
              <td class="text-danger fw-bold">{{ r.d0 }}</td>
              <td class="text-success fw-bold">{{ r.pass }}</td>
              <td>{{ r.pass_pct }}%</td>
              <td class="fw-bold">{{ r.gpa|floatformat:4 }}</td>
              <td>{{ r.sch_gpa_grade }}</td>
              <td>{{ r.sch_gpa_status }}</td>
            </tr>
            {% empty %}
            <tr>
              <td colspan="16" class="text-center text-danger py-3">
                No school ranking data available for this project.
              </td>
            </tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
    </div>
    
    <div class="card-footer text-muted small">
      Total Schools: {{ rows|length }} | 
      GPA: Grade Point Average (lower is better) |
      Generated: {% now "Y-m-d H:i" %}
    </div>
  </div>
</div>

{% endblock %}