{% extends "base.html" %}
{% block body %}
<h1 class="page">统计</h1>
<div class="card">
  <h2>按状态</h2>
  <table class="grid">
    <tr><th>状态</th><th class="num">订单数</th><th class="num">金额合计（元）</th></tr>
    {% for st, cnt, amt in by_status %}
    <tr>
      <td>{{ status_text.get(st, st) }}</td>
      <td class="num">{{ cnt }}</td>
      <td class="num">{{ '%.2f'|format(amt or 0) }}</td>
    </tr>
    {% endfor %}
  </table>
</div>

<div class="card">
  <h2>按供应商（仅审批通过）</h2>
  <table class="grid">
    <tr><th>供应商</th><th class="num">订单数</th><th class="num">金额合计（元）</th></tr>
    {% for name, cnt, amt in by_supplier %}
    <tr><td>{{ name }}</td><td class="num">{{ cnt }}</td><td class="num">{{ '%.2f'|format(amt or 0) }}</td></tr>
    {% else %}<tr><td colspan="3" class="center muted">暂无数据</td></tr>{% endfor %}
  </table>
</div>

<div class="card">
  <h2>按月份</h2>
  <table class="grid">
    <tr><th>月份</th><th class="num">订单数</th><th class="num">金额合计（元）</th></tr>
    {% for m, cnt, amt in by_month %}
    <tr><td>{{ m }}</td><td class="num">{{ cnt }}</td><td class="num">{{ '%.2f'|format(amt or 0) }}</td></tr>
    {% endfor %}
  </table>
  <div style="margin-top:12px;">
    <a class="btn" href="{{ url_for('export_ledger') }}">导出 Excel 台账</a>
  </div>
</div>
{% endblock %}