{% extends "admin/base_site.html" %}

{% block content %}
<h1>{{ title }}</h1>
<p>
  Upload a CSV or Excel (.xlsx) file. Only verified + active questions are used in live exams —
  leave <code>is_verified</code> false unless you check “Mark imported as verified”.
</p>
<p>
  <a href="{% url 'admin:courses_coursequestion_import_template' %}">Download CSV template</a>
</p>

<form method="post" enctype="multipart/form-data" style="max-width:640px;">
  {% csrf_token %}
  <fieldset class="module aligned">
    <div class="form-row">
      <label for="id_course">Course / exam track:</label>
      <select name="course_id" id="id_course" required>
        <option value="">— select —</option>
        {% for c in courses %}
        <option value="{{ c.pk }}">{{ c.title }}</option>
        {% endfor %}
      </select>
    </div>
    <div class="form-row">
      <label for="id_file">File:</label>
      <input type="file" name="file" id="id_file" accept=".csv,.xlsx,.xlsm" required>
    </div>
    <div class="form-row">
      <label>
        <input type="checkbox" name="mark_verified">
        Mark imported rows as verified (skip SME review)
      </label>
    </div>
    <div class="form-row">
      <label>
        <input type="checkbox" name="replace_bank">
        <strong>Replace bank</strong> — delete/deactivate existing questions for this course before import
      </label>
      <p class="help" style="margin:.25rem 0 0;">
        Questions already used in a live exam attempt are only deactivated (kept for audit), not permanently deleted.
      </p>
    </div>
  </fieldset>
  <div class="submit-row">
    <input type="submit" value="Import questions" class="default">
    <a href="{% url 'admin:courses_coursequestion_changelist' %}" class="button cancel-link">Cancel</a>
  </div>
</form>

<hr>
<h2>CSV / Excel columns</h2>
<pre style="background:#f8f8f8;padding:1rem;overflow:auto;">
question_text,option_a,option_b,option_c,option_d,correct_option,difficulty,topic_tag,is_active,is_verified
</pre>
<ul>
  <li><strong>correct_option</strong>: A, B, C, or D</li>
  <li><strong>difficulty</strong>: easy | medium | hard (default medium)</li>
  <li><strong>topic_tag</strong>: e.g. on-page, technical-seo (used for balanced exams)</li>
  <li><strong>is_active</strong> / <strong>is_verified</strong>: true/false (optional)</li>
</ul>
{% endblock %}