{% extends 'grades/base.html' %}
{% block title %}批量导入成绩{% endblock %}
{% block breadcrumb %}
<li class="breadcrumb-item"><a href="{% url 'grade_list' %}">成绩管理</a></li>
<li class="breadcrumb-item active">批量导入</li>
{% endblock %}

{% block content %}
<div class="row justify-content-center">
    <div class="col-md-7">
        <div class="card">
            <div class="card-header"><i class="bi bi-upload"></i> 批量导入成绩</div>
            <div class="card-body">
                <div class="alert alert-info">
                    <h6><i class="bi bi-info-circle"></i> Excel 文件格式要求</h6>
                    <p class="mb-2">文件必须包含以下列名（第一行为表头）：</p>
                    <table class="table table-bordered table-sm mb-2">
                        <thead class="table-light">
                            <tr><th>学号</th><th>姓名</th><th>课程号</th><th>课程名</th><th>成绩</th><th>学期</th></tr>
                        </thead>
                        <tbody>
                            <tr><td>2023001</td><td>张三</td><td>C001</td><td>高等数学</td><td>85.5</td><td>2024-1</td></tr>
                        </tbody>
                    </table>
                    <small class="text-muted">
                        - 支持 .xlsx 和 .xls 格式<br>
                        - 已存在的成绩会自动更新<br>
                        - 新学号/课程号会自动创建对应记录
                    </small>
                </div>

                <form method="post" enctype="multipart/form-data" novalidate>
                    {% csrf_token %}
                    <div class="mb-3">
                        <label class="form-label">{{ form.excel_file.label }}</label>
                        {{ form.excel_file }}
                        {% if form.excel_file.errors %}
                        <div class="text-danger small mt-1">{% for e in form.excel_file.errors %}{{ e }}{% endfor %}</div>
                        {% endif %}
                        <small class="form-text text-muted">{{ form.excel_file.help_text }}</small>
                    </div>
                    <div class="d-flex justify-content-between">
                        <a href="{% url 'grade_list' %}" class="btn btn-outline-secondary">取消</a>
                        <button type="submit" class="btn btn-primary"><i class="bi bi-cloud-upload"></i> 上传导入</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
{% endblock %}