{% extends 'grades/base.html' %}
{% block title %}数据管理{% endblock %}
{% block breadcrumb %}<li class="breadcrumb-item active">数据管理</li>{% endblock %}

{% block content %}
<h4 class="mb-4"><i class="bi bi-database"></i> 数据管理</h4>

<!-- 基础数据统计 -->
<div class="row g-3 mb-4">
    <div class="col-md-2">
        <div class="stat-card">
            <div class="stat-value">{{ user_count }}</div>
            <div class="stat-label"><i class="bi bi-people"></i> 用户</div>
        </div>
    </div>
    <div class="col-md-2">
        <div class="stat-card green">
            <div class="stat-value">{{ student_count }}</div>
            <div class="stat-label"><i class="bi bi-person-badge"></i> 学生</div>
        </div>
    </div>
    <div class="col-md-2">
        <div class="stat-card cyan">
            <div class="stat-value">{{ course_count }}</div>
            <div class="stat-label"><i class="bi bi-book"></i> 课程</div>
        </div>
    </div>
    <div class="col-md-2">
        <div class="stat-card yellow">
            <div class="stat-value">{{ grade_count }}</div>
            <div class="stat-label"><i class="bi bi-clipboard-data"></i> 成绩</div>
        </div>
    </div>
    <div class="col-md-2">
        <div class="stat-card">
            <div class="stat-value">{{ notice_count }}</div>
            <div class="stat-label"><i class="bi bi-megaphone"></i> 公告</div>
        </div>
    </div>
    <div class="col-md-2">
        <div class="stat-card red">
            <div class="stat-value">{{ log_count }}</div>
            <div class="stat-label"><i class="bi bi-journal-text"></i> 日志</div>
        </div>
    </div>
</div>

<div class="row g-3">
    <!-- 备份 -->
    <div class="col-md-6">
        <div class="card">
            <div class="card-header d-flex justify-content-between align-items-center">
                <span><i class="bi bi-cloud-download"></i> 数据备份</span>
                <form method="post" action="{% url 'db_backup' %}" class="d-inline">
                    {% csrf_token %}
                    <button type="submit" class="btn btn-sm btn-primary"
                            onclick="return confirm('确定执行数据备份？')">
                        <i class="bi bi-download"></i> 立即备份
                    </button>
                </form>
            </div>
            <div class="card-body p-0">
                <table class="table table-hover mb-0">
                    <thead><tr><th>备份文件</th><th>大小(KB)</th><th>操作</th></tr></thead>
                    <tbody>
                        {% for b in backups %}
                        <tr>
                            <td><small>{{ b.name }}</small></td>
                            <td>{{ b.size }}</td>
                            <td><span class="badge bg-success">可用</span></td>
                        </tr>
                        {% empty %}
                        <tr><td colspan="3" class="text-center text-muted py-3">暂无备份文件</td></tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- 恢复 -->
    <div class="col-md-6">
        <div class="card">
            <div class="card-header"><i class="bi bi-cloud-upload"></i> 数据恢复</div>
            <div class="card-body">
                <div class="alert alert-warning py-2 mb-3">
                    <small><i class="bi bi-exclamation-triangle"></i> 恢复操作会将备份数据合并到当前数据库（已有记录按主键更新），请谨慎操作。</small>
                </div>
                <form method="post" action="{% url 'db_restore' %}" enctype="multipart/form-data"
                      onsubmit="return confirm('确定恢复数据？此操作会更新已有记录。')">
                    {% csrf_token %}
                    <div class="mb-3">
                        <label class="form-label">选择备份文件 (.json)</label>
                        <input type="file" name="backup_file" class="form-control" accept=".json" required>
                    </div>
                    <button type="submit" class="btn btn-warning">
                        <i class="bi bi-arrow-counterclockwise"></i> 开始恢复
                    </button>
                </form>
            </div>
        </div>
    </div>
</div>
{% endblock %}