41 lines
1.4 KiB
HTML
41 lines
1.4 KiB
HTML
{% 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 %}
|