{% extends "base.html" %}
{% block title %}{{ t('Data Import') }}{% endblock %}
{% block content %}
<div class="page-head"><div><h1>{{ t('Data Import') }}</h1>
  <small>{{ t('Bring data from your old system with Excel or CSV files. Download a template, or use the export of the old system as it is and match its columns.') }}</small></div></div>

{% set ns = namespace(step=0) %}
{% for gkey, glabel in groups %}
  {% set items = types.items()|selectattr('1.group', 'equalto', gkey)|list %}
  {% if items %}
  <div class="group-head"><h2>{{ t(glabel) }}</h2>
    <small>{% if gkey == 'master' %}{{ t('Import these first.') }}{% elif gkey == 'fresh' %}{{ t('Balances on the go-live date. The usual way to start.') }}{% else %}{{ t('Optional: past transactions, for reports on earlier periods.') }}{% endif %}</small></div>
  <div class="import-grid">
    {% for key, m in items %}{% set ns.step = ns.step + 1 %}
    <div class="import-card">
      <h3><span class="step">{{ ns.step }}</span>{{ t(m.title) }}</h3>
      <p>{{ t(m.desc) }}</p>
      <div class="links">
        <a class="btn small" href="{{ url_for('imports.upload', kind=key) }}">{{ t('Import') }}</a>
        <a class="btn ghost small" href="{{ url_for('imports.template', kind=key, fmt='xlsx') }}">{{ t('Excel template') }}</a>
        <a class="btn ghost small" href="{{ url_for('imports.template', kind=key, fmt='csv') }}">CSV</a>
      </div>
    </div>
    {% endfor %}
  </div>
  {% endif %}
{% endfor %}

{% if clearing %}
<div class="card">
  <h2>{{ t('Opening Balance Clearing') }} <small>(3990)</small></h2>
  <p class="muted" style="margin-top:0"><small>{{ t('Open invoices, opening stock and fixed assets post against this account, and the opening trial balance moves the same control accounts to it. When everything is imported it is zero in every branch; a balance means the detail does not add up to the trial balance.') }}</small></p>
  <table>
    <thead><tr><th>{{ t('Branch') }}</th><th class="num">{{ t('Balance') }}</th><th></th></tr></thead>
    <tbody>{% for b in clearing %}<tr><td><span class="tag">{{ b.code }}</span></td><td class="num {{ 'neg' if b.balance }}">{{ b.balance|money(b.currency) }}</td>
      <td>{% if b.balance %}<span class="badge st-warn">{{ t('Check') }}</span>{% else %}<span class="badge st-posted">OK</span>{% endif %}</td></tr>{% endfor %}</tbody>
  </table>
</div>
{% endif %}

<h2>{{ t('Import History') }}</h2>
<div class="card flush">
  <table>
    <thead><tr><th>#</th><th>{{ t('Date') }}</th><th>{{ t('Type') }}</th><th>{{ t('File') }}</th><th class="num">{{ t('Rows') }}</th>
      <th class="num">{{ t('Created') }}</th><th class="num">{{ t('Updated') }}</th><th>{{ t('Notes') }}</th><th>{{ t('User') }}</th><th>{{ t('Status') }}</th><th></th></tr></thead>
    <tbody>
    {% for b in batches %}
      <tr><td>{{ b.id }}</td><td class="num">{{ b.created_at[:16].replace('T', ' ') }}</td><td>{{ t(types[b.kind].title) if b.kind in types else b.kind }}</td>
        <td>{{ b.filename or '' }}</td><td class="num">{{ b.rows }}</td><td class="num">{{ b.created }}</td><td class="num">{{ b.updated }}</td>
        <td><small>{{ b.summary or '' }}</small></td><td>{{ b.username or '' }}</td>
        <td>{% if b.state == 'undone' %}<span class="badge st-cancelled">{{ t('Undone') }}</span>{% else %}<span class="badge st-posted">{{ t('Done') }}</span>{% endif %}</td>
        <td>{% if b.state == 'done' and b.created %}<form method="post" action="{{ url_for('imports.undo_batch', bid=b.id) }}" data-confirm="{{ t('Remove everything this import created?') }}"><button class="btn ghost small">{{ t('Undo') }}</button></form>{% endif %}</td></tr>
    {% else %}<tr><td class="empty" colspan="11">{{ t('Nothing yet.') }}</td></tr>{% endfor %}
    </tbody>
  </table>
</div>
{% endblock %}