{% extends "ledger/base.html" %}
{% load ledger_tags %}
{% block title %}Import mapping{% endblock %}
{% block content %}
<div class="pagehead"><h1>Check the mapping</h1><span class="muted">Step 2 of 2 &middot; {{ filename }} &rarr; {{ account.name }} ({{ format|upper }})</span></div>
{% if error %}<div class="flash error">{{ error }}</div>{% endif %}
<form method="post" class="card stack">{% csrf_token %}
  {% if mapping %}
  <div class="mapgrid">
    <label>Delimiter <input name="delimiter" value="{{ mapping.delimiter }}" size="2"></label>
    <label>Header row index <input name="header_row" value="{{ mapping.header_row|default_if_none:'' }}" size="3" placeholder="none"></label>
    <label>Date <select name="date">{% for i, h in headers %}<option value="{{ i }}" {% if mapping.date == i %}selected{% endif %}>{{ h }}</option>{% endfor %}</select></label>
    <label>Date format <select name="date_format">{% for f in date_formats %}<option value="{{ f }}" {% if mapping.date_format == f %}selected{% endif %}>{{ f }}</option>{% endfor %}</select></label>
    <label>Description <select name="description">{% for i, h in headers %}<option value="{{ i }}" {% if mapping.description == i %}selected{% endif %}>{{ h }}</option>{% endfor %}</select></label>
    <label>Signed amount <select name="amount"><option value="">- not used -</option>{% for i, h in headers %}<option value="{{ i }}" {% if mapping.amount == i %}selected{% endif %}>{{ h }}</option>{% endfor %}</select></label>
    <label>Debit column <select name="debit"><option value="">- not used -</option>{% for i, h in headers %}<option value="{{ i }}" {% if mapping.debit == i %}selected{% endif %}>{{ h }}</option>{% endfor %}</select></label>
    <label>Credit column <select name="credit"><option value="">- not used -</option>{% for i, h in headers %}<option value="{{ i }}" {% if mapping.credit == i %}selected{% endif %}>{{ h }}</option>{% endfor %}</select></label>
    <label>Dr/Cr marker column <select name="type"><option value="">- not used -</option>{% for i, h in headers %}<option value="{{ i }}" {% if mapping.type == i %}selected{% endif %}>{{ h }}</option>{% endfor %}</select></label>
    <label class="inline"><input type="checkbox" name="invert" {% if mapping.invert %}checked{% endif %}> flip signs (purchases are positive in this file)</label>
  </div>
  {% else %}<p>OFX/QFX files carry their own structure, no mapping needed.</p>{% endif %}
  <h2>Preview ({{ total }} rows parsed{% if skipped %}, {{ skipped }} skipped{% endif %})</h2>
  <table class="table"><thead><tr><th>Date</th><th>Description</th><th class="num">Amount</th></tr></thead><tbody>
    {% for r in preview %}<tr><td>{{ r.date }}</td><td>{{ r.description|truncatechars:80 }}</td><td class="num {% if r.amount > 0 %}pos{% endif %}">{{ r.amount|money }}</td></tr>{% empty %}<tr><td colspan="3" class="muted">Nothing parsed yet.</td></tr>{% endfor %}
  </tbody></table>
  <p class="muted small">Money leaving the account should show as negative. Rows already imported (same amount, date within 2 days, similar description) are skipped automatically.</p>
  <div class="row wrap">
    {% if mapping %}<button class="btn ghost" name="action" value="preview">Update preview</button>
    <input name="profile_name" placeholder="Save mapping as profile (optional)">{% endif %}
    <button class="btn" name="action" value="confirm" {% if not total %}disabled{% endif %}>Import {{ total }} rows</button>
  </div>
</form>
{% endblock %}