{% extends "base.html" %}
{% block title %}{{ t(m.title) }} — {{ t('Data Import') }}{% endblock %}
{% block content %}
<div class="page-head"><div><small><a href="{{ url_for('imports.index') }}">{{ t('Data Import') }}</a> · <a href="{{ url_for('imports.upload', kind=kind) }}">{{ t(m.title) }}</a></small>
  <h1>{{ t('Match columns') }}</h1><small>{{ meta.filename }} · {{ rows|length }} {{ t('rows') }} · {{ header|length }} {{ t('columns') }}</small></div></div>

{% if result %}
  {% set ok = not result.errors %}
  <div class="card {{ 'result-ok' if ok else 'result-bad' }}">
    {% if ok %}
      <h2>{{ t('Ready to import') }}</h2>
      <p style="margin:0">{{ result.created }} {{ t('to create') }}{% if result.updated %}, {{ result.updated }} {{ t('to update') }}{% endif %}{% if result.skipped %}, {{ result.skipped }} {{ t('skipped (already imported or empty)') }}{% endif %}.</p>
    {% else %}
      <h2>{{ t('Problems to fix') }}: {{ result.errors|length }}{% if result.errors|length >= 300 %}+{% endif %}</h2>
      <p style="margin:0 0 10px"><small>{{ t('Nothing has been saved. Correct the file (or the column matching) and check again.') }}</small></p>
      <div class="card flush" style="margin:0;max-height:340px;overflow:auto">
        <table><thead><tr><th style="width:90px">{{ t('Row') }}</th><th>{{ t('Problem') }}</th></tr></thead>
          <tbody>{% for row_no, msg in result.errors[:300] %}<tr><td class="num">{{ row_no }}</td><td>{{ msg }}</td></tr>{% endfor %}</tbody></table>
      </div>
    {% endif %}
    {% if result.notes %}<ul style="margin:10px 0 0">{% for n, c in result.notes.items() %}<li>{{ t(n) }}{% if c > 1 %}: {{ c }}{% endif %}</li>{% endfor %}</ul>{% endif %}
  </div>
  {% if result.preview and ok %}
  <div class="card flush">
    <table><thead><tr>{% for c in preview_cols %}<th>{{ t(c) }}</th>{% endfor %}</tr></thead>
      <tbody>{% for r in result.preview %}<tr>{% for v in r %}<td {{ 'class=num' if v is number else 'dir=auto' }}>{{ '{:,.2f}'.format(v) if v is float else (v if v is not none else '') }}</td>{% endfor %}</tr>{% endfor %}</tbody></table>
    {% if result.created + result.updated > result.preview|length %}<div class="notes">{{ t('First') }} {{ result.preview|length }} {{ t('of') }} {{ result.created + result.updated }}</div>{% endif %}
  </div>
  {% endif %}
{% endif %}

<form method="post" id="mapform">
  <div class="card">
    <h2>{{ t('Options') }}</h2>
    <div class="grid">
      {% if cutoff %}<div class="field"><label>{{ t('Cut-off date') }} *</label><input type="date" name="cutoff" value="{{ options.cutoff }}" required>
        <div class="help">{{ t('The last day in the old system. Balances are posted on this date.') }}</div></div>{% endif %}
      {% if branched %}<div class="field"><label>{{ t('Default branch') }}</label>
        <select name="branch_id"><option value="">—</option>{% for b in branches %}<option value="{{ b.id }}" {{ 'selected' if b.id|string == options.branch_id|string }}>{{ b.code }} — {{ nm(b) }}</option>{% endfor %}</select>
        <div class="help">{{ t('Used for rows without a branch.') }}</div></div>{% endif %}
      {% if dated %}<div class="field"><label>{{ t('Date format in the file') }}</label>
        <select name="date_format">{% for f in formats %}<option {{ 'selected' if f == options.date_format }}>{{ f }}</option>{% endfor %}</select>
        <div class="help">{{ t('Real Excel dates and YYYY-MM-DD are always recognised.') }}</div></div>{% endif %}
      {% if kind in ('open_items', 'invoices') %}<div class="field"><label>{{ t('Document type when not in the file') }}</label>
        <select name="doc_kind">{% for k, l in doc_kinds %}<option value="{{ k }}" {{ 'selected' if k == options.doc_kind }}>{{ t(l) }}</option>{% endfor %}</select></div>{% endif %}
      {% if kind in ('partners', 'payments') %}<div class="field"><label>{{ t('When the type is not in the file') }}</label>
        <select name="role"><option value="customer" {{ 'selected' if options.role == 'customer' }}>{{ t('Customer') if kind == 'partners' else t('Receipt from a customer') }}</option>
          <option value="vendor" {{ 'selected' if options.role == 'vendor' }}>{{ t('Vendor') if kind == 'partners' else t('Payment to a vendor') }}</option>
          {% if kind == 'partners' %}<option value="both" {{ 'selected' if options.role == 'both' }}>{{ t('Customer and vendor') }}</option>{% endif %}</select></div>{% endif %}
      {% if kind == 'opening' %}<div class="field"><label>{{ t('Post an unbalanced difference to') }}</label>
        <select name="difference_account"><option value="">{{ t('Do not import unbalanced branches') }}</option>{% for v, l in accounts %}<option value="{{ v }}" {{ 'selected' if v|string == options.difference_account|string }}>{{ l }}</option>{% endfor %}</select></div>{% endif %}
      {% if sheets|length > 1 %}<div class="field"><label>{{ t('Sheet') }}</label>
        <select name="sheet" onchange="document.getElementById('remap').value='1';this.form.submit()">{% for s in sheets %}<option {{ 'selected' if s == options.sheet }}>{{ s }}</option>{% endfor %}</select></div>{% endif %}
      <div class="field"><label>{{ t('Column names are in row') }}</label><input type="number" name="header_row" value="{{ options.header_row }}" min="1" max="50" class="num" onchange="document.getElementById('remap').value='1'"></div>
    </div>
    <div class="grid" style="margin-top:12px">
      {% if master %}<div class="field check"><input type="checkbox" id="o_up" name="update_existing" value="1" {{ 'checked' if options.update_existing }}><label for="o_up">{{ t('Update records that already exist') }}</label></div>{% endif %}
      {% if kind in ('opening', 'open_items', 'entries', 'invoices', 'payments') %}<div class="field check"><input type="checkbox" id="o_cp" name="create_partners" value="1" {{ 'checked' if options.create_partners }}><label for="o_cp">{{ t('Create customers and vendors that do not exist') }}</label></div>{% endif %}
      {% if documents %}<div class="field check"><input type="checkbox" id="o_sk" name="skip_existing" value="1" {{ 'checked' if options.skip_existing }}><label for="o_sk">{{ t('Skip documents imported before') }}</label></div>{% endif %}
    </div>
    {% if kind == 'opening' %}
    <div style="margin-top:14px"><b>{{ t('Detail imported separately') }}</b>
      <div class="help muted"><small>{{ t('The balances of these control accounts go to Opening Balance Clearing (3990); the detail imports post the other side.') }}</small></div>
      <div class="grid" style="margin-top:4px">
        <div class="field check"><input type="checkbox" id="r_ar" name="redirect_ar" value="1" {{ 'checked' if options.redirect_ar }}><label for="r_ar">{{ t('Receivable and payable (open invoices and bills)') }}</label></div>
        {% if has('inventory') %}<div class="field check"><input type="checkbox" id="r_st" name="redirect_stock" value="1" {{ 'checked' if options.redirect_stock }}><label for="r_st">{{ t('Inventory (opening stock)') }}</label></div>{% endif %}
        {% if has('assets') %}<div class="field check"><input type="checkbox" id="r_as" name="redirect_assets" value="1" {{ 'checked' if options.redirect_assets }}><label for="r_as">{{ t('Fixed assets and accumulated depreciation (asset register)') }}</label></div>{% endif %}
      </div>
    </div>
    {% endif %}
  </div>

  <div class="card flush">
    <table class="map-table">
      <thead><tr><th style="width:30%">{{ t('Lubwise field') }}</th><th>{{ t('Column in your file') }}</th><th>{{ t('First value') }}</th></tr></thead>
      <tbody>
      {% for f in m.fields %}{% set col = mapping.get(f.key) %}
        <tr><td><b>{{ t(f.label) }}</b>{% if f.required %} <span class="req">*</span>{% endif %}{% if f.help %}<div class="help">{{ t(f.help) }}</div>{% endif %}</td>
          <td><select name="map_{{ f.key }}"><option value="">— {{ t('not in the file') }} —</option>
            {% for h in header %}<option value="{{ loop.index0 }}" {{ 'selected' if col == loop.index0 }}>{{ h }}</option>{% endfor %}</select></td>
          <td class="muted" dir="auto">{% if col is not none and rows %}{{ rows[0][col] }}{% endif %}</td></tr>
      {% endfor %}
      </tbody>
    </table>
  </div>
  <input type="hidden" name="remap" id="remap" value="0">
  <div class="form-actions" style="margin-bottom:18px">
    <button class="btn ghost" name="action" value="check">{{ t('Check') }}</button>
    <button class="btn" name="action" value="import" {{ 'disabled' if not result or result.errors }}>{{ t('Import') }}</button>
    <a class="btn ghost" href="{{ url_for('imports.index') }}">{{ t('Cancel') }}</a>
    <small class="muted" style="align-self:center">{{ t('Check runs the whole import and then discards it, so you see every problem first.') }}</small>
  </div>
</form>

<h2>{{ t('File preview') }}</h2>
<div class="card flush">
  <table class="sample"><thead><tr><th>{{ t('Row') }}</th>{% for h in header %}<th>{{ h }}</th>{% endfor %}</tr></thead>
    <tbody>{% for r in rows[:8] %}<tr><td class="num">{{ r.line }}</td>{% for c in r %}<td dir="auto">{{ c }}</td>{% endfor %}</tr>{% endfor %}</tbody></table>
  {% if rows|length > 8 %}<div class="notes">{{ t('First') }} 8 {{ t('of') }} {{ rows|length }}</div>{% endif %}
</div>
{% endblock %}
{% block scripts %}
<script>
(function () {
  // changing the matching or options means the last check no longer applies
  var form = document.getElementById('mapform'), imp = form.querySelector('button[value=import]');
  form.addEventListener('change', function () { imp.disabled = true; });
})();
</script>
{% endblock %}