{% extends "base.html" %}
{% block content %}
<div class="container-fluid mt-3" style="max-width: 900px;">
  <div class="d-flex justify-content-between align-items-center mb-3">
    <h4 class="mb-0">
      <i class="bi bi-file-earmark-arrow-up me-1"></i>
      Import Recruitment Template (Excel)
    </h4>
    <a href="{{ url_for('recruitment.template_list') }}" class="btn btn-outline-secondary btn-sm">
      <i class="bi bi-arrow-left-short"></i> Back to Templates
    </a>
  </div>

  <div class="card shadow-sm">
    <div class="card-body">
      <form method="POST" enctype="multipart/form-data">
        {{ csrf_token() if csrf_token is defined }}

        <div class="row g-3">
          <div class="col-md-4">
            <label class="form-label fw-semibold">Designation</label>
            <select name="designation_id" class="form-select" required>
              <option value="">-- Select --</option>
              {% for d in designations %}
                <option value="{{ d.id }}">{{ d.title or d.name }}</option>
              {% endfor %}
            </select>
          </div>

          <div class="col-md-8">
            <label class="form-label fw-semibold">Template Excel File</label>
            <input type="file"
                   name="excel_file"
                   class="form-control"
                   accept=".xlsx,.xls"
                   required>
            <div class="form-text">
              Use the same column layout as your <strong>Requisition.xlsx (BDE)</strong>:
              row 1 headers, row 2+ for KRA / KPI and skill-wise questions.
            </div>
          </div>
        </div>

        <hr>

        <div class="d-flex justify-content-end">
          <button type="submit" class="btn btn-primary">
            <i class="bi bi-upload me-1"></i> Import Template
          </button>
        </div>
      </form>
    </div>
  </div>

  <div class="alert alert-info mt-3 small mb-0">
    <strong>Expected Excel format:</strong><br>
    Row&nbsp;1: headers like
    <em>MINIMUM EDUCATIONAL QUALIFICATION, MINIMUM YEARS OF EXPERIENCE &amp; CORE SKILLS,
    JOB PURPOSE &amp; ROLE SUMMARY, Age Bracket, KRA, KRA Description, KPI / Metric,
    KPI Target, Weightage (%), Basic Skill(s), Skill Evaluation Questions</em>.<br>
    Row&nbsp;2+: each row adds a KRA/KPI and a Skill with 2–3 questions (separated by newlines).
  </div>
</div>
{% endblock %}