{% extends "base.html" %}
{% block title %}{{ t('ex3') }} · {{ t('lvl2_name') }} · MockIRS{% endblock %}
{% block content %}
<h1>{{ t('ex3') }} · {{ t('lvl2_name') }}</h1>
<p class="goal"><b>{{ t('goal') }}:</b> {{ t('l2_goal') }}</p>

<h2>{{ t('l2_grades_h2') }}</h2>

<form method="get" class="course-picker">
  <label>{{ t('select_course') }}
    <select name="course" onchange="this.form.submit()">
      <option value="">{{ t('all_courses') }}</option>
      {% for c in courses %}
      <option value="{{ c.course_id }}" {{ 'selected' if selected_course and c.course_id == selected_course.course_id }}>
        {{ c.name }}（{{ c.course_id }}）
      </option>
      {% endfor %}
    </select>
  </label>
  <label>{{ t('overall_quiz') }}
    <select name="quiz" onchange="this.form.submit()">
      <option value="">{{ t('quiz_none') }}</option>
      {% for q in quiz_options %}
      <option value="{{ q.quiz_id }}" {{ 'selected' if selected_quiz and q.quiz_id == selected_quiz.quiz_id }}>
        {{ q.title }}
      </option>
      {% endfor %}
    </select>
  </label>
</form>

<table id="grades" class="data">
  <thead>
    <tr>
      <th>{{ t('col_id') }}</th><th>{{ t('col_name') }}</th>
      {% for tk in cols %}<th>{{ labels[tk] }}</th>{% endfor %}
      <th>{{ t('col_average') }}</th>
      {% if selected_quiz %}<th>{{ selected_quiz.title }}</th>{% endif %}
      <th>{{ t('col_overall') }}</th>
    </tr>
  </thead>
  <tbody>
    {% for r in grades %}
    <tr>
      <td>{{ r.student_id }}</td><td>{{ r.name }}</td>
      {% for tk in cols %}<td>{{ r[tk] }}</td>{% endfor %}
      <td>{{ r.average }}</td>
      {% if selected_quiz %}<td>{{ r.quiz_pct }}</td>{% endif %}
      <td>{{ r.overall }}</td>
    </tr>
    {% endfor %}
  </tbody>
</table>

<h2>{{ t('l2_quiz_h2') }}</h2>
{% for q in quizzes %}
<h3>{{ q.title }}（{{ q.quiz_id }}）</h3>
<table class="data">
  <thead><tr><th>{{ t('col_id') }}</th><th>{{ t('col_name') }}</th><th>{{ t('col_score') }}</th><th>{{ t('col_full') }}</th></tr></thead>
  <tbody>
    {% for r in q.rows %}
    <tr><td>{{ r.student_id }}</td><td>{{ r.name }}</td><td>{{ r.score }}</td><td>{{ r.total }}</td></tr>
    {% endfor %}
  </tbody>
</table>
{% endfor %}
{% endblock %}