{% extends "base.html" %}

{% block title %}成绩分析 - FlashExam{% endblock %}

{% block content %}
<div class="row mb-4">
    <div class="col-12">
        <h1 class="h3 mb-0">
            <i class="bi bi-graph-up"></i>
            成绩分析
        </h1>
        <p class="text-muted">查看考试成绩，导出分析数据</p>
    </div>
</div>

<!-- 快速导航 -->
<div class="row mb-4">
    <div class="col-12">
        <div class="card">
            <div class="card-header bg-primary text-white">
                <h6 class="mb-0">
                    <i class="bi bi-lightning-fill"></i>
                    快速导航
                </h6>
            </div>
            <div class="card-body py-2">
                <div class="row">
                    <div class="col-auto">
                        <a href="{{ url_for('teacher.dashboard') }}" class="btn btn-outline-secondary btn-sm me-2">
                            <i class="bi bi-speedometer2"></i> 仪表板
                        </a>
                    </div>
                    <div class="col-auto">
                        <a href="{{ url_for('teacher.students') }}" class="btn btn-outline-primary btn-sm me-2">
                            <i class="bi bi-people-fill"></i> 学生管理
                        </a>
                    </div>
                    <div class="col-auto">
                        <a href="{{ url_for('teacher.questions') }}" class="btn btn-outline-success btn-sm me-2">
                            <i class="bi bi-question-circle-fill"></i> 题目管理
                        </a>
                    </div>
                    <div class="col-auto">
                        <a href="{{ url_for('teacher.exams') }}" class="btn btn-outline-info btn-sm me-2">
                            <i class="bi bi-journal-text"></i> 考试管理
                        </a>
                    </div>
                    <div class="col-auto">
                        <a href="{{ url_for('teacher.grading') }}" class="btn btn-outline-warning btn-sm me-2">
                            <i class="bi bi-pencil-square"></i> 主观题评分
                        </a>
                    </div>
                    <div class="col-auto">
                        <span class="btn btn-danger btn-sm disabled">
                            <i class="bi bi-graph-up"></i> 成绩分析
                        </span>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- 统计信息 -->
<div class="row mb-4">
    <div class="col-md-3 mb-3">
        <div class="card text-center" style="background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white;">
            <div class="card-body">
                <i class="bi bi-clipboard-data display-4 mb-2"></i>
                <h3>{{ exam_results|length }}</h3>
                <p class="mb-0">考试记录</p>
            </div>
        </div>
    </div>
    
    <div class="col-md-3 mb-3">
        <div class="card text-center" style="background: linear-gradient(135deg, #f093fb 0%, #f5576c 100%); color: white;">
            <div class="card-body">
                <i class="bi bi-check-circle display-4 mb-2"></i>
                <h3>
                    {% set completed_results = [] %}
                    {% for result in exam_results %}
                        {% if result.get('is_completed') %}
                            {% set _ = completed_results.append(result) %}
                        {% endif %}
                    {% endfor %}
                    {{ completed_results|length }}
                </h3>
                <p class="mb-0">已完成</p>
            </div>
        </div>
    </div>
    
    <div class="col-md-3 mb-3">
        <div class="card text-center" style="background: linear-gradient(135deg, #4facfe 0%, #00f2fe 100%); color: white;">
            <div class="card-body">
                <i class="bi bi-star display-4 mb-2"></i>
                <h3>
                    {% set completed_results = [] %}
                    {% set total_score = 0 %}
                    {% for result in exam_results %}
                        {% if result.get('is_completed') %}
                            {% set _ = completed_results.append(result) %}
                            {% set total_score = total_score + (result.get('score', 0) or 0) %}
                        {% endif %}
                    {% endfor %}
                    {% if completed_results|length > 0 %}
                        {{ "%.1f"|format(total_score / completed_results|length) }}
                    {% else %}
                        0.0
                    {% endif %}
                </h3>
                <p class="mb-0">平均分</p>
            </div>
        </div>
    </div>
    
    <div class="col-md-3 mb-3">
        <div class="card text-center" style="background: linear-gradient(135deg, #fa709a 0%, #fee140 100%); color: white;">
            <div class="card-body">
                <i class="bi bi-trophy display-4 mb-2"></i>
                <h3>
                    {% set completed_results = [] %}
                    {% set passing_results = [] %}
                    {% for result in exam_results %}
                        {% if result.get('is_completed') %}
                            {% set _ = completed_results.append(result) %}
                            {% if (result.get('score', 0) or 0) >= 60 %}
                                {% set _ = passing_results.append(result) %}
                            {% endif %}
                        {% endif %}
                    {% endfor %}
                    {% if completed_results|length > 0 %}
                        {{ "%.1f"|format((passing_results|length / completed_results|length) * 100) }}%
                    {% else %}
                        0.0%
                    {% endif %}
                </h3>
                <p class="mb-0">及格率</p>
            </div>
        </div>
    </div>
</div>

<!-- 操作按钮 -->
<div class="row mb-4">
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-3 mb-2">
                        <select class="form-select" id="examFilter" title="选择考试进行筛选">
                            <option value="">选择考试</option>
                            {% for exam in exams %}
                                <option value="{{ exam.id }}">{{ exam.title }}</option>
                            {% endfor %}
                        </select>
                    </div>
                    <div class="col-md-3 mb-2">
                        <button class="btn btn-primary w-100" onclick="filterResults()">
                            <i class="bi bi-search"></i> 筛选结果
                        </button>
                    </div>
                    <div class="col-md-3 mb-2">
                        <button class="btn btn-success w-100" onclick="exportResults()">
                            <i class="bi bi-download"></i> 导出成绩
                        </button>
                    </div>
                    <div class="col-md-3 mb-2">
                        <button class="btn btn-warning w-100" onclick="showStatistics()">
                            <i class="bi bi-graph-up"></i> 统计图表
                        </button>
                    </div>
                    <div class="col-md-3 mb-2">
                        <button class="btn btn-outline-success w-100" onclick="batchGradeObjective()" id="batch-grade-btn">
                            <i class="bi bi-check-circle"></i> 批量客观题评分
                        </button>
                    </div>
                    <div class="col-md-3 mb-2">
                        <button class="btn btn-outline-primary w-100" onclick="batchGradeSubjective()" id="batch-grade-subjective-btn">
                            <i class="bi bi-robot"></i> 批量主观题AI评分
                        </button>
                    </div>
                    <div class="col-md-3 mb-2">
                        <button class="btn btn-outline-danger w-100" onclick="cleanupDuplicates()" id="cleanup-btn">
                            <i class="bi bi-trash"></i> 清理重复记录
                        </button>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- 统计图表模态框 -->
<div class="modal fade" id="statisticsModal" tabindex="-1">
    <div class="modal-dialog modal-xl">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">
                    <i class="bi bi-graph-up"></i> 成绩统计图表
                </h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="关闭"></button>
            </div>
            <div class="modal-body">
                <div class="row">
                    <div class="col-md-6 mb-4">
                        <h6>分数分布</h6>
                        <canvas id="scoreDistributionChart" width="400" height="300"></canvas>
                    </div>
                    <div class="col-md-6 mb-4">
                        <h6>考试完成率</h6>
                        <canvas id="completionRateChart" width="400" height="300"></canvas>
                    </div>
                </div>
                <div class="row">
                    <div class="col-12">
                        <h6>各考试平均分对比</h6>
                        <canvas id="examComparisonChart" width="800" height="400"></canvas>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- 导出选项弹窗 -->
<div class="modal fade" id="exportModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header bg-success text-white">
                <h5 class="modal-title">
                    <i class="bi bi-download"></i> 导出成绩选项
                </h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" title="关闭导出选项弹窗"></button>
            </div>
            <div class="modal-body">
                <form id="exportForm">
                    <!-- 导出格式选择 -->
                    <div class="mb-3">
                        <label class="form-label"><strong>导出内容：</strong></label>
                        <div class="form-check">
                            <input class="form-check-input" type="radio" name="export_type" id="exportBasic" value="basic" checked>
                            <label class="form-check-label" for="exportBasic">
                                <strong>基础成绩表</strong>
                                <small class="text-muted d-block">包含学生基本信息和总成绩</small>
                            </label>
                        </div>
                        <div class="form-check">
                            <input class="form-check-input" type="radio" name="export_type" id="exportDetailed" value="detailed">
                            <label class="form-check-label" for="exportDetailed">
                                <strong>详细成绩表</strong>
                                <small class="text-muted d-block">包含每个学生每道题目的得分详情</small>
                            </label>
                        </div>
                        <div class="form-check">
                            <input class="form-check-input" type="radio" name="export_type" id="exportByType" value="by_question_type">
                            <label class="form-check-label" for="exportByType">
                                <strong>按题型分组成绩表</strong>
                                <small class="text-muted d-block">各题型（选择题、判断题、简答题等）分列显示得分/满分</small>
                            </label>
                        </div>
                    </div>
                    
                    <!-- 编码选择 -->
                    <div class="mb-3">
                        <label class="form-label"><strong>文件编码：</strong></label>
                        <select class="form-select" name="encoding" id="encodingSelect" title="选择文件编码格式">
                            <option value="utf-8">UTF-8（推荐，支持所有字符）</option>
                            <option value="gbk">GBK（适用于旧版Excel）</option>
                        </select>
                        <small class="text-muted">
                            如果Excel打开中文乱码，请选择GBK编码
                        </small>
                    </div>
                    
                    <!-- 筛选选项 -->
                    <div class="mb-3">
                        <label class="form-label"><strong>筛选条件：</strong></label>
                        <div class="row">
                            <div class="col-md-6">
                                <select class="form-select" name="exam_filter" id="exportExamFilter" title="选择要导出的考试">
                                    <option value="">所有考试</option>
                                    {% for exam in exams %}
                                        <option value="{{ exam.id }}">{{ exam.title }}</option>
                                    {% endfor %}
                                </select>
                            </div>
                            <div class="col-md-6">
                                <select class="form-select" name="status_filter" id="exportStatusFilter" title="选择要导出的状态">
                                    <option value="">所有状态</option>
                                    <option value="completed">仅已完成</option>
                                    <option value="incomplete">仅进行中</option>
                                </select>
                            </div>
                        </div>
                    </div>
                    
                    <!-- 预览信息 -->
                    <div class="alert alert-info">
                        <small>
                            <i class="bi bi-info-circle"></i>
                            <strong>预览：</strong>将导出当前筛选条件下的 <span id="exportPreviewCount">{{ exam_results|length }}</span> 条记录
                        </small>
                    </div>
                </form>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">取消</button>
                <button type="button" class="btn btn-success" onclick="confirmExport()">
                    <i class="bi bi-download"></i> 开始导出
                </button>
            </div>
        </div>
    </div>
</div>

<!-- 成绩列表 -->
<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-header bg-success text-white">
                <h5 class="mb-0">
                    <i class="bi bi-list"></i>
                    考试成绩
                    <span id="resultsCount" class="badge bg-light text-dark ms-2">{{ exam_results|length }} 条记录</span>
                </h5>
            </div>
            <div class="card-body">
                <div id="resultsContainer">
                    {% if exam_results %}
                        <div class="table-responsive">
                            <table class="table table-hover" id="resultsTable">
                                <thead>
                                    <tr>
                                        <th>考试名称</th>
                                        <th>学生信息</th>
                                        <th>成绩</th>
                                        <th>开始时间</th>
                                        <th>结束时间</th>
                                        <th>用时</th>
                                        <th>状态</th>
                                        <th>操作</th>
                                    </tr>
                                </thead>
                                <tbody id="resultsTableBody">
                                    {% for result in exam_results %}
                                    <tr>
                                        <td>
                                            <strong>{{ result.get('exam_title', 'N/A') }}</strong>
                                            <br><small class="text-muted">ID: {{ result.get('exam_id', 'N/A') }}</small>
                                        </td>
                                        <td>
                                            {{ result.get('student_name', 'N/A') }}
                                            <br><small class="text-muted">{{ result.get('student_number', 'N/A') }}</small>
                                        </td>
                                        <td>
                                            <span class="badge bg-{{ 'success' if (result.get('score', 0) or 0) >= 60 else 'warning' if (result.get('score', 0) or 0) >= 40 else 'danger' }} fs-6">
                                                {{ "%.1f"|format(result.get('score', 0) or 0) }}分
                                            </span>
                                        </td>
                                        <td>
                                            {% if result.get('start_time') %}
                                                <small>{{ result.get('start_time')[:16] }}</small>
                                            {% else %}
                                                <small class="text-muted">未知</small>
                                            {% endif %}
                                        </td>
                                        <td>
                                            {% if result.get('end_time') %}
                                                <small>{{ result.get('end_time')[:16] }}</small>
                                            {% else %}
                                                <small class="text-muted">未完成</small>
                                            {% endif %}
                                        </td>
                                        <td>
                                            {% if result.get('start_time') and result.get('end_time') %}
                                                <small class="text-muted">
                                                    <i class="bi bi-clock"></i>
                                                    计算中...
                                                </small>
                                            {% else %}
                                                <small class="text-muted">-</small>
                                            {% endif %}
                                        </td>
                                        <td>
                                            {% if result.get('is_completed') %}
                                                <span class="badge bg-success">已完成</span>
                                            {% else %}
                                                <span class="badge bg-warning">进行中</span>
                                            {% endif %}
                                        </td>
                                        <td>
                                            <a href="{{ url_for('teacher.student_exam_details', result_id=result.get('id')) }}" 
                                               class="btn btn-sm btn-outline-primary" title="查看详情">
                                                <i class="bi bi-eye"></i>
                                            </a>
                                            <button class="btn btn-sm btn-outline-info" title="重新评分">
                                                <i class="bi bi-arrow-clockwise"></i>
                                            </button>
                                        </td>
                                    </tr>
                                    {% endfor %}
                                </tbody>
                            </table>
                        </div>
                    {% else %}
                        <div class="text-center py-5">
                            <i class="bi bi-clipboard-x display-1 text-muted"></i>
                            <h4 class="mt-3 text-muted">暂无考试成绩</h4>
                            <p class="text-muted">学生完成考试后，成绩将显示在这里</p>
                            <a href="{{ url_for('teacher.exams') }}" class="btn btn-primary">
                                <i class="bi bi-plus-circle"></i> 创建考试
                            </a>
                        </div>
                    {% endif %}
                </div>
            </div>
        </div>
    </div>
</div>

<script src="/static/js/libs/chart/chart.min.js"></script>
<script id="resultsData" type="application/json">{{ exam_results|tojson }}</script>
<script>
// 全局变量
let allResults = JSON.parse(document.getElementById('resultsData').textContent);
let currentResults = allResults;

// 导出成绩功能
function exportResults() {
    // 显示导出选项弹窗
    const modal = new bootstrap.Modal(document.getElementById('exportModal'));
    modal.show();
    
    // 更新预览计数
    updateExportPreview();
}

// 更新导出预览计数
function updateExportPreview() {
    const examFilter = document.getElementById('exportExamFilter').value;
    const statusFilter = document.getElementById('exportStatusFilter').value;
    
    let filteredCount = allResults.length;
    
    if (examFilter || statusFilter) {
        const filtered = allResults.filter(result => {
            let include = true;
            
            if (examFilter && result.exam_id != examFilter) {
                include = false;
            }
            
            if (statusFilter === 'completed' && !result.is_completed) {
                include = false;
            } else if (statusFilter === 'incomplete' && result.is_completed) {
                include = false;
            }
            
            return include;
        });
        
        filteredCount = filtered.length;
    }
    
    document.getElementById('exportPreviewCount').textContent = filteredCount;
}

// 确认导出
function confirmExport() {
    const exportType = document.querySelector('input[name="export_type"]:checked').value;
    const encoding = document.getElementById('encodingSelect').value;
    const examFilter = document.getElementById('exportExamFilter').value;
    const statusFilter = document.getElementById('exportStatusFilter').value;
    
    // 构建导出URL
    let exportUrl = '/teacher/results/export';
    const params = new URLSearchParams();
    
    params.append('export_type', exportType);
    params.append('encoding', encoding);
    
    if (examFilter) {
        params.append('exam_id', examFilter);
    }
    
    if (statusFilter) {
        params.append('status', statusFilter);
    }
    
    if (params.toString()) {
        exportUrl += '?' + params.toString();
    }
    
    // 根据导出类型显示不同的提示信息
    let typeText = '基础';
    if (exportType === 'detailed') {
        typeText = '详细';
    } else if (exportType === 'by_question_type') {
        typeText = '按题型分组';
    }
    
    // 显示导出进度
    showAlert(`正在生成${typeText}成绩表（${encoding.toUpperCase()}编码）...`, 'info');
    
    // 关闭弹窗
    bootstrap.Modal.getInstance(document.getElementById('exportModal')).hide();
    
    // 打开导出链接
    window.open(exportUrl, '_blank');
}

// 批量客观题评分
function batchGradeObjective() {
    const examId = document.getElementById('examFilter').value;
    
    if (!examId) {
        showAlert('请先选择一个考试', 'warning');
        return;
    }
    
    if (!confirm('确定要对当前选中考试的所有已提交学生进行客观题评分吗？\n\n这将重新计算所有客观题（选择/判断）的得分。')) {
        return;
    }
    
    const btn = document.getElementById('batch-grade-btn');
    const originalText = btn.innerHTML;
    btn.disabled = true;
    btn.innerHTML = '<span class="spinner-border spinner-border-sm"></span> 处理中...';
    
    fetch(`/teacher/exams/${examId}/batch-grade-objective`, {
        method: 'POST',
        headers: {
            'Content-Type': 'application/json'
        }
    })
    .then(response => response.json())
    .then(data => {
        if (data.success) {
            showAlert(data.message, 'success');
            // 刷新结果
            filterResults();
        } else {
            showAlert('评分失败: ' + data.message, 'error');
        }
    })
    .catch(error => {
        console.error('Error:', error);
        showAlert('操作失败，请重试', 'error');
    })
    .finally(() => {
        btn.disabled = false;
        btn.innerHTML = originalText;
    });
}

// 批量主观题AI评分
function batchGradeSubjective() {
    const examId = document.getElementById('examFilter').value;
    
    if (!examId) {
        showAlert('请先选择一个考试', 'warning');
        return;
    }
    
    if (!confirm('确定要对当前选中考试的所有已提交学生进行主观题AI评分吗？\n\n这将调用AI模型重新计算所有主观题（简答/填空）的得分。这可能需要几分钟时间。')) {
        return;
    }
    
    const btn = document.getElementById('batch-grade-subjective-btn');
    const originalText = btn.innerHTML;
    btn.disabled = true;
    btn.innerHTML = '<span class="spinner-border spinner-border-sm"></span> AI处理中...';
    
    fetch(`/teacher/exams/${examId}/batch-grade-subjective`, {
        method: 'POST',
        headers: {
            'Content-Type': 'application/json'
        }
    })
    .then(response => response.json())
    .then(data => {
        if (data.success) {
            showAlert(data.message, 'success');
            // 刷新结果
            filterResults();
        } else {
            showAlert('评分失败: ' + data.message, 'error');
        }
    })
    .catch(error => {
        console.error('Error:', error);
        showAlert('操作失败，请重试', 'error');
    })
    .finally(() => {
        btn.disabled = false;
        btn.innerHTML = originalText;
    });
}

// 清理重复记录
function cleanupDuplicates() {
    const examId = document.getElementById('examFilter').value;
    
    if (!examId) {
        showAlert('请先选择一个考试', 'warning');
        return;
    }
    
    if (!confirm('确定要清理当前考试的重复提交记录吗？\n\n如果有学生存在多条记录，系统将只保留分数最高的一条，其余将被永久删除！此操作不可恢复。')) {
        return;
    }
    
    const btn = document.getElementById('cleanup-btn');
    const originalText = btn.innerHTML;
    btn.disabled = true;
    btn.innerHTML = '<span class="spinner-border spinner-border-sm"></span> 处理中...';
    
    fetch(`/teacher/exams/${examId}/cleanup-duplicates`, {
        method: 'POST',
        headers: {
            'Content-Type': 'application/json'
        }
    })
    .then(response => response.json())
    .then(data => {
        if (data.success) {
            showAlert(data.message, 'success');
            // 刷新结果
            filterResults();
        } else {
            showAlert('清理失败: ' + data.message, 'error');
        }
    })
    .catch(error => {
        console.error('Error:', error);
        showAlert('操作失败，请重试', 'error');
    })
    .finally(() => {
        btn.disabled = false;
        btn.innerHTML = originalText;
    });
}

// 筛选结果功能
function filterResults() {
    const examId = document.getElementById('examFilter').value;
    
    if (!examId) {
        // 重置显示所有结果
        currentResults = allResults;
        updateResultsTable();
        return;
    }
    
    // 发送筛选请求
    fetch(`/teacher/results/filter?exam_id=${examId}`)
        .then(response => response.json())
        .then(data => {
            if (data.success) {
                currentResults = data.results;
                updateResultsTable();
                showAlert(`筛选完成，找到 ${data.total} 条记录`, 'success');
            } else {
                showAlert(data.message || '筛选失败', 'error');
            }
        })
        .catch(error => {
            console.error('Filter error:', error);
            showAlert('筛选时发生错误', 'error');
        });
}

// 更新结果表格
function updateResultsTable() {
    const tbody = document.getElementById('resultsTableBody');
    const countBadge = document.getElementById('resultsCount');
    
    if (!tbody) return;
    
    // 更新计数
    countBadge.textContent = `${currentResults.length} 条记录`;
    
    // 清空表格
    tbody.innerHTML = '';
    
    if (currentResults.length === 0) {
        tbody.innerHTML = `
            <tr>
                <td colspan="8" class="text-center py-4">
                    <i class="bi bi-search text-muted"></i>
                    <p class="text-muted mb-0">没有找到符合条件的成绩记录</p>
                </td>
            </tr>
        `;
        return;
    }
    
    // 生成表格行
    currentResults.forEach(result => {
        const score = result.score || 0;
        let scoreBadgeClass = 'danger';
        if (score >= 60) scoreBadgeClass = 'success';
        else if (score >= 40) scoreBadgeClass = 'warning';
        
        // 安全获取学生信息，优先使用API返回的完整信息
        const studentName = result.student_name || 'N/A';
        const studentNumber = result.student_number || result.student_id || 'N/A';
        const examTitle = result.exam_title || 'N/A';
        
        const row = `
            <tr>
                <td>
                    <strong>${examTitle}</strong>
                    <br><small class="text-muted">ID: ${result.exam_id || 'N/A'}</small>
                </td>
                <td>
                    ${studentName}
                    <br><small class="text-muted">${studentNumber}</small>
                </td>
                <td>
                    <span class="badge bg-${scoreBadgeClass} fs-6">
                        ${score.toFixed(1)}分
                    </span>
                </td>
                <td>
                    ${result.start_time ? `<small>${result.start_time.substring(0, 16)}</small>` : '<small class="text-muted">未知</small>'}
                </td>
                <td>
                    ${result.end_time ? `<small>${result.end_time.substring(0, 16)}</small>` : '<small class="text-muted">未完成</small>'}
                </td>
                <td>
                    <small class="text-muted">-</small>
                </td>
                <td>
                    <span class="badge bg-${result.is_completed ? 'success' : 'warning'}">
                        ${result.is_completed ? '已完成' : '进行中'}
                    </span>
                </td>
                <td>
                    <a href="/teacher/result/${result.id}" 
                       class="btn btn-sm btn-outline-primary" title="查看详情">
                        <i class="bi bi-eye"></i>
                    </a>
                    <button class="btn btn-sm btn-outline-info" title="重新评分">
                        <i class="bi bi-arrow-clockwise"></i>
                    </button>
                </td>
            </tr>
        `;
        tbody.innerHTML += row;
    });
}

// 显示统计图表
function showStatistics() {
    fetch('/teacher/results/statistics')
        .then(response => response.json())
        .then(data => {
            if (data.success) {
                createCharts(data.statistics);
                const modal = new bootstrap.Modal(document.getElementById('statisticsModal'));
                modal.show();
            } else {
                showAlert(data.message || '获取统计数据失败', 'error');
            }
        })
        .catch(error => {
            console.error('Statistics error:', error);
            showAlert('获取统计数据时发生错误', 'error');
        });
}

// 创建图表
function createCharts(statistics) {
    // 分数分布饼图
    const scoreCtx = document.getElementById('scoreDistributionChart').getContext('2d');
    new Chart(scoreCtx, {
        type: 'pie',
        data: {
            labels: ['优秀(90-100)', '良好(80-89)', '中等(70-79)', '及格(60-69)', '不及格(50-59)', '很差(0-49)'],
            datasets: [{
                data: [
                    statistics.score_distribution['90-100'],
                    statistics.score_distribution['80-89'],
                    statistics.score_distribution['70-79'],
                    statistics.score_distribution['60-69'],
                    statistics.score_distribution['50-59'],
                    statistics.score_distribution['0-49']
                ],
                backgroundColor: [
                    '#28a745', '#20c997', '#17a2b8', '#ffc107', '#fd7e14', '#dc3545'
                ]
            }]
        },
        options: {
            responsive: true,
            plugins: {
                legend: {
                    position: 'bottom'
                }
            }
        }
    });
    
    // 完成率环形图
    const completionCtx = document.getElementById('completionRateChart').getContext('2d');
    new Chart(completionCtx, {
        type: 'doughnut',
        data: {
            labels: ['已完成', '未完成'],
            datasets: [{
                data: [statistics.total_completed, statistics.total_students - statistics.total_completed],
                backgroundColor: ['#28a745', '#6c757d']
            }]
        },
        options: {
            responsive: true,
            plugins: {
                legend: {
                    position: 'bottom'
                }
            }
        }
    });
    
    // 各考试平均分对比条形图
    const examCtx = document.getElementById('examComparisonChart').getContext('2d');
    const examNames = Object.keys(statistics.exam_statistics);
    const examScores = examNames.map(name => statistics.exam_statistics[name].average_score);
    
    new Chart(examCtx, {
        type: 'bar',
        data: {
            labels: examNames,
            datasets: [{
                label: '平均分',
                data: examScores,
                backgroundColor: 'rgba(54, 162, 235, 0.8)',
                borderColor: 'rgba(54, 162, 235, 1)',
                borderWidth: 1
            }]
        },
        options: {
            responsive: true,
            scales: {
                y: {
                    beginAtZero: true,
                    max: 100
                }
            }
        }
    });
}

// 显示提示消息
function showAlert(message, type = 'info') {
    const alertDiv = document.createElement('div');
    alertDiv.className = `alert alert-${type === 'error' ? 'danger' : type} alert-dismissible fade show position-fixed`;
    alertDiv.style.cssText = 'top: 20px; right: 20px; z-index: 9999; min-width: 300px;';
    alertDiv.innerHTML = `
        ${message}
        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
    `;
    
    document.body.appendChild(alertDiv);
    
    // 3秒后自动消失
    setTimeout(() => {
        if (alertDiv.parentNode) {
            alertDiv.parentNode.removeChild(alertDiv);
        }
    }, 3000);
}

// 页面加载完成后初始化
document.addEventListener('DOMContentLoaded', function() {
    // 初始化数据
    updateResultsTable();
    
    // 添加导出选项变化监听器
    const exportExamFilter = document.getElementById('exportExamFilter');
    const exportStatusFilter = document.getElementById('exportStatusFilter');
    
    if (exportExamFilter) {
        exportExamFilter.addEventListener('change', updateExportPreview);
    }
    
    if (exportStatusFilter) {
        exportStatusFilter.addEventListener('change', updateExportPreview);
    }
});
</script>
{% endblock %}