{% extends "base.html" %}
{% block title %}{{ _("Import") }} · {{ account.name }}{% endblock %}
{% block heading %}{{ _f("Import into {name}", name=account.name) }}{% endblock %}
{% block lede %}
<p class="lede">{{ _("Drop in a CSV your broker exported, or the statement PDFs from your bank's mailbox — as many as you like, or a ZIP of them. Each file is recognised by what is in it, so there is nothing to choose — and re-importing what you already loaded is harmless, because every row carries an id.") }}</p>
{% endblock %}
{% block content %}

<form method="post" enctype="multipart/form-data" class="card form">
  <label for="file">{{ _("CSV or PDF files") }}</label>
  <input id="file" name="file" type="file" accept=".csv,text/csv,.pdf,application/pdf,.zip,application/zip" multiple required>
  <button type="submit">{{ _("Import") }}</button>
</form>

{% if report %}
<div class="card">
  <h2>{{ report.label }}</h2>
  <table class="grid">
    <tbody>
      {% if report.files > 1 %}
      <tr><td>{{ _("Files") }}</td><td class="num">{{ report.files }}</td></tr>
      {% endif %}
      <tr><td>{{ _("Rows read") }}</td><td class="num">{{ report.parsed }}</td></tr>
      <tr><td>{{ _("Imported") }}</td><td class="num pos">{{ report.inserted }}</td></tr>
      <tr><td>{{ _("Already had") }}</td><td class="num sub">{{ report.duplicates }}</td></tr>
      {% if report.skipped %}
      <tr><td>{{ _("No cash movement, skipped") }}</td><td class="num sub">{{ report.skipped }}</td></tr>
      {% endif %}
    </tbody>
  </table>
  {% if report.problems %}
  <div class="flash flash-warn">
    <strong>{{ _n(report.problems|length, "{n} line could not be read.", "{n} lines could not be read.") }}</strong>
    {{ _("Everything else was imported. These are listed rather than counted so you can see whether they matter:") }}
    <ul>
      {% for p in report.problems[:10] %}<li>{{ p }}</li>{% endfor %}
      {% if report.problems|length > 10 %}
      <li class="sub">{{ _f("…and {n} more.", n=report.problems|length - 10) }}</li>
      {% endif %}
    </ul>
  </div>
  {% endif %}
  <p><a class="btn" href="{{ url_for('account_detail', account_id=account.id) }}">{{ _("See the account") }}</a></p>
</div>
{% endif %}

<div class="card">
  <h2>{{ _("Where to get the file") }}</h2>
  <ul class="steps">
    <li><strong>Degiro</strong> — {{ _("Inbox → Account statement → choose the period → export CSV. That is the cash ledger: deposits, trades, dividends and fees. Set the start date back to when you opened the account and you get the whole history in one go.") }}</li>
    <li><strong>Trade Republic</strong> — {{ _("Profile → Transactions → export.") }}</li>
    <li><strong>DKB</strong> — {{ _("Open the account or the Visa card → Umsätze → choose the period → CSV-Export. Girokonto, Tagesgeld and Visa all work, and so do files from the old portal. Pending (vorgemerkt) rows are left out until they are booked.") }}</li>
    <li><strong>DKB Depot</strong> — {{ _("Postfach → filter by the Depot → download the Wertpapierabrechnungen as PDF and drop them all in here at once. The Depot's CSV says only what money moved; the PDFs say how many units, at what price, with what fee. Orders, fund purchases, dividends, interest, the Vorabpauschale and the half-year Sparplan overview are all read. A Storno is skipped and named.") }}</li>
    <li><strong>{{ _("Any other bank") }}</strong> — {{ _("Export the transactions as CSV and drop the file in. If no importer knows it you are asked, once, which column is the date, the amount and so on; the mapping is remembered under the file's header, so the next export from that bank goes straight in.") }}</li>
  </ul>
  <p class="sub">{{ _("Export a period that overlaps what you already imported. Overlap costs nothing and a gap costs you transactions.") }}</p>
</div>
{% endblock %}