{% extends "core/base.html" %}{% load fmt %}
{% block title %}CSV import{% endblock %}
{% block content %}
<h1>CSV import</h1>
{% if stage == "upload" %}
<section class="card"><form method="post" enctype="multipart/form-data" class="form">{% csrf_token %}<input type="hidden" name="action" value="upload">
<p><label>Data type <select name="kind"><option value="invoices">Invoices (AR)</option><option value="bills">Bills (AP)</option><option value="payments">Payments (receipts and vendor payments)</option></select></label></p>
<p><label>CSV file <input type="file" name="file" accept=".csv,text/csv" required></label></p>
<button class="btn">Upload and map columns</button></form>
<p class="hint">Dates accept 2026-10-31, 31/10/2026, 31-10-2026 or 31-Oct-2026. Unknown customers and vendors are created. Samples are in <code>examples/</code>.</p></section>
{% else %}
<p class="sub">Importing <strong>{{ kind }}</strong>{% if count %} &middot; {{ count }} rows{% endif %}. Map your columns to CashPilot fields.</p>
<form method="post" class="card form">{% csrf_token %}<input type="hidden" name="action" value="preview">
<div class="mapgrid">{% for f in fields %}<label>{{ f.name }}{% if f.required %} *{% endif %}
<select name="map_{{ f.name }}"><option value="">- not mapped -</option>{% for h in headers %}<option value="{{ h }}" {% if h == f.selected %}selected{% endif %}>{{ h }}</option>{% endfor %}</select></label>{% endfor %}</div>
<button class="btn">Validate</button></form>
{% if sample %}<section class="card"><h2>Sample rows</h2><div class="scroll"><table class="t"><thead><tr>{% for h in headers %}<th>{{ h }}</th>{% endfor %}</tr></thead><tbody>
{% for row in sample %}<tr>{% for v in row.values %}<td>{{ v }}</td>{% endfor %}</tr>{% endfor %}</tbody></table></div></section>{% endif %}
{% if result %}<section class="card"><h2>Validation</h2>
<p><span class="pill ok">{{ result.valid|length }} valid</span> <span class="pill {% if result.errors %}bad{% endif %}">{{ result.errors|length }} error(s)</span></p>
{% if errors %}<table class="t"><thead><tr><th>Row</th><th>Problem</th></tr></thead><tbody>{% for n, msg in errors %}<tr><td>{{ n }}</td><td>{{ msg }}</td></tr>{% endfor %}</tbody></table>{% endif %}
{% if result.valid %}<form method="post">{% csrf_token %}<input type="hidden" name="action" value="commit">
{% for k, v in mapping.items %}<input type="hidden" name="map_{{ k }}" value="{{ v }}">{% endfor %}
<button class="btn">Import {{ result.valid|length }} valid row(s){% if result.errors %} and skip errors{% endif %}</button></form>{% endif %}</section>{% endif %}
{% endif %}
{% endblock %}