{% extends "base.html" %}

{% block title %}Audit-Log (GoBD){% endblock %}
{% block heading %}Audit-Log · GoBD-Nachweis{% endblock %}

{% block content %}
<div class="card">
  <div class="card-header">
    <div>
      <h2>Audit-Log</h2>
      <p class="sub">
        GoBD-Tz. 30 ff. — vollständige, nachvollziehbare Aufzeichnung aller
        sicherheits- und buchungs-relevanten Aktionen.
        Aufbewahrung: 10 Jahre.
      </p>
    </div>
  </div>

  <form method="get" action="/audit"
        style="padding:12px 16px;display:flex;gap:12px;align-items:end;flex-wrap:wrap;
               border-bottom:1px solid var(--card-border-2);">
    <div style="flex:1 1 240px;min-width:200px;">
      <label class="text-[10px] uppercase tracking-wider font-semibold"
             style="color:var(--card-text-muted);">Suche (User, Notiz, Werte)</label>
      <input type="text" name="q" value="{{ filter_q or '' }}"
             placeholder="z.B. Müller, Storno, Rechnung 2026-…"
             class="input mt-1" style="width:100%;">
    </div>
    <div>
      <label class="text-[10px] uppercase tracking-wider font-semibold"
             style="color:var(--card-text-muted);">Beleg-Typ</label>
      <select name="entity_type" class="select mt-1">
        <option value="">— alle —</option>
        {% for t in entity_types %}
        <option value="{{ t }}" {% if t == filter_entity_type %}selected{% endif %}>{{ t }}</option>
        {% endfor %}
      </select>
    </div>
    <div>
      <label class="text-[10px] uppercase tracking-wider font-semibold"
             style="color:var(--card-text-muted);">Aktion</label>
      <select name="action" class="select mt-1">
        <option value="">— alle —</option>
        {% for a in ['create','update','delete','issue','storno','payment','login','export','backup_created'] %}
        <option value="{{ a }}" {% if a == filter_action %}selected{% endif %}>{{ a }}</option>
        {% endfor %}
      </select>
    </div>
    <div>
      <label class="text-[10px] uppercase tracking-wider font-semibold"
             style="color:var(--card-text-muted);">Von</label>
      <input type="date" name="date_from" value="{{ filter_date_from or '' }}" class="input mt-1">
    </div>
    <div>
      <label class="text-[10px] uppercase tracking-wider font-semibold"
             style="color:var(--card-text-muted);">Bis</label>
      <input type="date" name="date_to" value="{{ filter_date_to or '' }}" class="input mt-1">
    </div>
    <div>
      <label class="text-[10px] uppercase tracking-wider font-semibold"
             style="color:var(--card-text-muted);">Anzahl</label>
      <select name="limit" class="select mt-1">
        {% for n in [50, 200, 500, 1000] %}
        <option value="{{ n }}" {% if n == limit %}selected{% endif %}>{{ n }}</option>
        {% endfor %}
      </select>
    </div>
    <div style="display:flex;gap:6px;">
      <button type="submit" class="btn btn-primary">Filtern</button>
      <a href="/audit" class="btn btn-secondary">Zurücksetzen</a>
      <a class="btn btn-secondary"
         href="/audit/export.csv?q={{ filter_q or '' }}&entity_type={{ filter_entity_type or '' }}&action={{ filter_action or '' }}&date_from={{ filter_date_from or '' }}&date_to={{ filter_date_to or '' }}&limit=10000"
         title="Aktuelle Filter als CSV (UTF-8, Semikolon) exportieren — Excel-DE-kompatibel">
        CSV-Export
      </a>
    </div>
  </form>

  <div class="card-body" style="padding:0;">
    <table class="data-table" style="width:100%;font-size:12px;">
      <thead>
        <tr>
          <th>Zeit</th>
          <th>Beleg-Typ</th>
          <th>Beleg-ID</th>
          <th>Aktion</th>
          <th>User</th>
          <th>Notiz</th>
          <th>Vorher → Nachher</th>
        </tr>
      </thead>
      <tbody>
        {% for r in rows %}
        <tr>
          <td style="white-space:nowrap;font-family:monospace;font-size:11px;">{{ r.created_at }}</td>
          <td><span class="badge">{{ r.entity_type }}</span></td>
          <td style="font-family:monospace;">{{ r.entity_id }}</td>
          <td><span class="badge"
                    style="background:{% if r.action in ['delete','storno'] %}rgba(239,68,68,0.2){% elif r.action == 'issue' %}rgba(16,185,129,0.2){% else %}rgba(53,102,146,0.2){% endif %};">
            {{ r.action }}
          </span></td>
          <td>{{ r.user_name or '—' }}</td>
          <td style="max-width:200px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;">
            {{ r.note or '' }}
          </td>
          <td style="font-family:monospace;font-size:10px;color:var(--card-text-muted);
                     max-width:400px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;">
            {% if r.old_value or r.new_value %}
              <span title="{{ (r.old_value or '') }} → {{ (r.new_value or '') }}">
                {{ (r.new_value or r.old_value or '')[:80] }}
              </span>
            {% endif %}
          </td>
        </tr>
        {% else %}
        <tr><td colspan="7" style="padding:32px;text-align:center;color:var(--card-text-muted);">
          Keine Audit-Einträge gefunden
        </td></tr>
        {% endfor %}
      </tbody>
    </table>
  </div>

  <div class="card-footer" style="padding:12px 16px;font-size:11px;color:var(--card-text-muted);">
    <strong>{{ rows|length }}</strong> Einträge angezeigt ·
    Audit-Log dient als GoBD-Nachweis bei Außenprüfungen ·
    direkter SQL-Zugriff: <code>SELECT * FROM audit_log ORDER BY id DESC;</code>
  </div>
</div>
{% endblock %}