{% extends "base.html" %}

{% block title %}KPI-Dashboard{% endblock %}
{% block heading %}KPI-Dashboard für Geschäftsführung{% endblock %}

{% block content %}
<style>
  .kpi-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(220px, 1fr));
    gap: 16px;
    margin-bottom: 24px;
  }
  .kpi-card {
    background: var(--card-bg);
    color: var(--card-text);
    border: 1px solid var(--card-border-2);
    border-radius: 12px;
    padding: 20px;
  }
  .kpi-card.warn { border-left: 4px solid #f59e0b; }
  .kpi-card.danger { border-left: 4px solid #ef4444; }
  .kpi-card.good { border-left: 4px solid #10b981; }
  .kpi-label {
    font-size: 11px;
    text-transform: uppercase;
    letter-spacing: 0.05em;
    color: var(--card-text-muted);
    margin-bottom: 6px;
    font-weight: 600;
  }
  .kpi-value {
    font-size: 28px;
    font-weight: 800;
    line-height: 1.1;
  }
  .kpi-sub {
    font-size: 12px;
    color: var(--card-text-muted);
    margin-top: 4px;
  }

  .chart-card {
    background: var(--card-bg);
    color: var(--card-text);
    border: 1px solid var(--card-border-2);
    border-radius: 12px;
    padding: 24px;
    margin-bottom: 16px;
  }
  .chart-card h3 {
    font-size: 14px;
    font-weight: 700;
    margin-bottom: 16px;
    text-transform: uppercase;
    letter-spacing: 0.05em;
  }

  /* Bar Chart */
  .bar-chart {
    display: flex;
    align-items: flex-end;
    gap: 8px;
    height: 200px;
    padding-bottom: 30px;
    position: relative;
    overflow-x: auto;
  }
  .bar-chart .bar-col {
    flex: 1; min-width: 40px;
    display: flex; flex-direction: column;
    align-items: center; gap: 6px;
    height: 100%; justify-content: flex-end;
    position: relative;
  }
  .bar-chart .bar {
    width: 80%;
    background: linear-gradient(180deg, #f2581b 0%, #c44a20 100%);
    border-radius: 4px 4px 0 0;
    transition: height 0.5s ease;
    min-height: 2px;
    position: relative;
  }
  .bar-chart .bar:hover::after {
    content: attr(data-value);
    position: absolute;
    bottom: 100%;
    left: 50%;
    transform: translateX(-50%);
    background: #18181b;
    color: white;
    font-size: 11px;
    padding: 4px 8px;
    border-radius: 4px;
    white-space: nowrap;
  }
  .bar-chart .bar-label {
    font-size: 10px;
    color: var(--card-text-muted);
    white-space: nowrap;
    transform: rotate(-45deg);
    transform-origin: top left;
    position: absolute;
    bottom: -25px;
    left: 50%;
  }

  /* Top customers */
  .top-list {
    list-style: none; padding: 0; margin: 0;
  }
  .top-list li {
    display: flex; align-items: center; gap: 12px;
    padding: 10px 0;
    border-bottom: 1px solid var(--card-border-2);
  }
  .top-list li:last-child { border-bottom: 0; }
  .top-list .rank {
    width: 24px; height: 24px; border-radius: 50%;
    background: rgba(242, 88, 27, 0.15);
    color: #f2581b;
    display: flex; align-items: center; justify-content: center;
    font-weight: 700; font-size: 11px;
  }
  .top-list .name { flex: 1; font-weight: 600; }
  .top-list .count {
    color: var(--card-text-muted);
    font-size: 12px;
  }
  .top-list .amount {
    font-weight: 700;
    font-family: 'Monaco','Menlo',monospace;
    font-size: 13px;
  }

  /* Utilization meter */
  .meter {
    height: 12px;
    background: rgba(0,0,0,0.2);
    border-radius: 6px;
    overflow: hidden;
    margin-top: 8px;
  }
  .meter-bar {
    height: 100%;
    transition: width 0.5s ease;
  }
</style>

<!-- KPI-Karten oben -->
<div class="kpi-grid">

  <div class="kpi-card good">
    <div class="kpi-label">Umsatz YTD</div>
    <div class="kpi-value">{{ "%.0f"|format(kpis.ytd_revenue) }} €</div>
    <div class="kpi-sub">Brutto, alle nicht-stornierten Rechnungen {{ now.year if now else '' }}</div>
  </div>

  <div class="kpi-card {% if kpis.inv_overdue > 0 %}danger{% else %}good{% endif %}">
    <div class="kpi-label">Offene Rechnungen</div>
    <div class="kpi-value">{{ "%.0f"|format(kpis.inv_open_amount) }} €</div>
    <div class="kpi-sub">{{ kpis.inv_open_count }} Rechnungen · davon <strong style="color:#ef4444;">{{ kpis.inv_overdue }} überfällig</strong></div>
  </div>

  <div class="kpi-card {% if kpis.machine_utilization > 90 %}danger{% elif kpis.machine_utilization > 70 %}warn{% else %}good{% endif %}">
    <div class="kpi-label">Maschinen-Auslastung 4 Wochen</div>
    <div class="kpi-value">{{ kpis.machine_utilization }} %</div>
    <div class="kpi-sub">Job-Stunden / verfügbare Stunden</div>
    <div class="meter">
      <div class="meter-bar" style="width: {{ [kpis.machine_utilization, 100]|min }}%; background: {% if kpis.machine_utilization > 90 %}#ef4444{% elif kpis.machine_utilization > 70 %}#f59e0b{% else %}#10b981{% endif %};"></div>
    </div>
  </div>

  <div class="kpi-card">
    <div class="kpi-label">Pipeline</div>
    <div class="kpi-value">{{ kpis.inq_open + kpis.quote_open + kpis.order_active }}</div>
    <div class="kpi-sub">
      {{ kpis.inq_open }} Anfragen ·
      {{ kpis.quote_open }} Angebote ·
      {{ kpis.order_active }} Aufträge
    </div>
  </div>

</div>

<!-- Umsatz-Chart -->
<div class="chart-card">
  <h3>📈 Umsatz pro Monat (letzte 12 Monate)</h3>
  {% set max_rev = (revenue_per_month|map(attribute='value')|max) or 1 %}
  <div class="bar-chart">
    {% for r in revenue_per_month %}
    <div class="bar-col">
      <div class="bar"
           data-value="{{ '%.0f'|format(r.value) }} € im {{ r.month }}"
           style="height: {{ ((r.value / max_rev) * 100)|round(1) }}%;"></div>
      <div class="bar-label">{{ r.month[5:] }}/{{ r.month[:4] }}</div>
    </div>
    {% endfor %}
  </div>
  <p style="text-align:right; color:var(--card-text-muted); font-size:11px; margin-top:30px;">
    Höchster Monatswert: <strong>{{ '%.0f'|format(max_rev) }} €</strong>
  </p>
</div>

<!-- Top-Kunden -->
<div class="chart-card">
  <h3>🏆 Top-Kunden nach Umsatz (alle Zeit)</h3>
  <ol class="top-list">
    {% for c in top_customers %}
    <li>
      <span class="rank">{{ loop.index }}</span>
      <span class="name">{{ c.name or '— ohne Namen —' }}</span>
      <span class="count">{{ c.count }} Rechnungen</span>
      <span class="amount">{{ '%.0f'|format(c.total) }} €</span>
    </li>
    {% else %}
    <li style="justify-content:center; color:var(--card-text-muted); padding:24px;">
      Noch keine Rechnungsdaten
    </li>
    {% endfor %}
  </ol>
</div>

<p style="text-align:center; color:var(--card-text-muted); font-size:11px; margin-top:24px;">
  Aktualisierung bei jedem Seitenaufruf · Daten direkt aus der Live-Datenbank ·
  GoBD-konform: alle Beträge basieren auf nicht-stornierten festgeschriebenen Rechnungen
</p>
{% endblock %}