{% extends 'base.html' %}
{% block content %}
<div class="page-header"><h2>首页总览</h2></div>

<div class="stat-cards">
    <div class="stat-card">
        <div class="num">{{ student_count }}</div>
        <div class="label">学生总数</div>
    </div>
    <div class="stat-card">
        <div class="num">{{ grade_count }}</div>
        <div class="label">成绩记录数</div>
    </div>
    <div class="stat-card">
        <div class="num">{{ total_avg }}</div>
        <div class="label">全校平均分</div>
    </div>
    <div class="stat-card">
        <div class="num">{{ excellent_count }}</div>
        <div class="label">优秀人次(>=90)</div>
    </div>
    <div class="stat-card">
        <div class="num">{{ fail_count }}</div>
        <div class="label">不及格人次(<60)</div>
    </div>
</div>

<div class="content-card">
    <h2>各科成绩统计</h2>
    {% if course_stats %}
    <table>
        <tr>
            <th>课程名称</th>
            <th>参与人次</th>
            <th>平均分</th>
            <th>最高分</th>
            <th>最低分</th>
        </tr>
        {% for c in course_stats %}
        <tr>
            <td>{{ c.name }}</td>
            <td>{{ c.count }}</td>
            <td>{{ c.avg }}</td>
            <td>{{ c.max }}</td>
            <td>{{ c.min }}</td>
        </tr>
        {% endfor %}
    </table>
    {% else %}
    <p>暂无成绩数据，请先添加学生和成绩。</p>
    {% endif %}
    <br>
    <a href="/students" class="btn btn-primary">进入学生管理</a>
    <a href="/add" class="btn btn-success">添加学生</a>
</div>
{% endblock %}