{% extends "base.html" %}
{% block content %}
<div class="container mt-4" 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-excel me-2"></i>Historical Loan Import</h4>
    <a class="btn btn-outline-primary"
       href="{{ url_for('loan.download_historical_loans_template') }}">
      <i class="bi bi-download me-1"></i> Download Template
    </a>
  </div>

  <div class="card shadow-sm">
    <div class="card-body">
      <form method="POST" enctype="multipart/form-data">
        <label class="form-label">Upload Excel (.xlsx)</label>
        <input type="file" name="file" class="form-control" accept=".xlsx,.xls" required>
        <div class="text-muted small mt-2">
          Sheet name should be <b>historical_loans</b>. Columns as per template.
        </div>
        <button class="btn btn-primary mt-3">
          <i class="bi bi-eye me-1"></i> Preview Import
        </button>
      </form>
    </div>
  </div>
</div>
{% endblock %}