{% extends "inventory/base.html" %}
{% block title %}Import{% endblock %}
{% block content %}
<h1>Import movements (CSV)</h1>
<section class="card">
<p>Required columns: <code>date, sku, warehouse, kind, qty</code>. Optional: <code>unit_cost, reference, to_warehouse, expiry_date</code>. Kinds: receipt (needs unit_cost), issue, transfer (needs to_warehouse), adjustment (signed qty), return. The whole file is rejected if any row is invalid, or if it would drive any warehouse stock negative.</p>
<form method="post" enctype="multipart/form-data" class="inline">{% csrf_token %}<input type="file" name="file" accept=".csv" required>
<button>Validate</button> <button name="commit" value="1" class="secondary">Validate and import</button></form></section>
{% if result %}
<section class="card">{% if result.errors %}<h2>{{ result.errors|length }} problem{{ result.errors|length|pluralize }} found - nothing imported</h2>
<table class="data compact"><thead><tr><th>Line</th><th>Problem</th></tr></thead><tbody>{% for line, msg in result.errors %}<tr><td>{{ line }}</td><td>{{ msg }}</td></tr>{% endfor %}</tbody></table>
{% else %}<h2>{{ result.rows|length }} valid rows</h2><p class="alert info">File is valid. Use "Validate and import" to load it.</p>
<table class="data compact"><thead><tr><th>Line</th><th>Date</th><th>SKU</th><th>Warehouse</th><th>Kind</th><th>Qty</th><th>Unit cost</th></tr></thead><tbody>{% for r in result.rows|slice:":15" %}<tr><td>{{ r.line }}</td><td>{{ r.date }}</td><td>{{ r.sku }}</td><td>{{ r.warehouse }}</td><td>{{ r.kind }}</td><td>{{ r.qty }}</td><td>{{ r.unit_cost|default_if_none:"" }}</td></tr>{% endfor %}</tbody></table>{% endif %}</section>
{% endif %}
{% endblock %}