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

<div class="container mt-4">

<h4>Subject Performance – {{ project.name }}</h4>

<form method="get" class="mb-3 d-flex" style="max-width:300px;">
  <input type="text" name="q" value="{{ search_query }}"
         class="form-control form-control-sm"
         placeholder="Search subject or school">
</form>

<div class="card">
<div class="card-body table-responsive p-0">

<table class="table table-sm table-bordered">
<thead class="table-dark">
<tr>
  <th>School</th>
  <th>Subject</th>
  <th>Students</th>
  <th>Avg</th>
  <th>Grade</th>
  <th>GPA</th>
  <th>GPA Grade</th>
</tr>
</thead>

<tbody>
{% for r in page_obj %}
<tr>
  <td>{{ r.school.school_code }}</td>
  <td>{{ r.subject.subject_code }} – {{ r.subject.subject_name_eng }}</td>
  <td>{{ r.with_results }}</td>
  <td>{{ r.subj_avg }}</td>
  <td>{{ r.subj_avg_grd }}</td>
  <td>{{ r.subj_gpa }}</td>
  <td>{{ r.subj_gpa_grade }}</td>
</tr>
{% empty %}
<tr><td colspan="7" class="text-center text-muted">No data</td></tr>
{% endfor %}
</tbody>
</table>

</div>
</div>

<nav class="mt-3">
<ul class="pagination pagination-sm">
{% if page_obj.has_previous %}
<li class="page-item">
<a class="page-link" href="?q={{ search_query }}&page={{ page_obj.previous_page_number }}">Prev</a>
</li>
{% endif %}

<li class="page-item active">
<span class="page-link">{{ page_obj.number }}/{{ page_obj.paginator.num_pages }}</span>
</li>

{% if page_obj.has_next %}
<li class="page-item">
<a class="page-link" href="?q={{ search_query }}&page={{ page_obj.next_page_number }}">Next</a>
</li>
{% endif %}
</ul>
</nav>

</div>

{% endblock %}