// ==UserScript==
// @name         第一师范学院缓考补考成绩自动填报助手
// @namespace    http://tampermonkey.net/
// @version      4.2
// @description  适配缓考补考成绩录入页面，支持灵活的Excel列顺序和行顺序，自动识别可编辑的成绩字段（兼容篡改猴/ScriptCat）
// @author       SoyaBean
// @match        https://jwgl.hnfnu.edu.cn:9080/eams/teach/grade/delaymakeup/teacher-manage!inputReady.action*
// @match        http://jwgl.hnfnu.edu.cn:9080/eams/teach/grade/delaymakeup/teacher-manage!inputReady.action*
// @require      https://cdn.jsdelivr.net/npm/xlsx@0.18.5/dist/xlsx.full.min.js
// @grant        GM_xmlhttpRequest
// @grant        unsafeWindow
// @connect      cdn.jsdelivr.net
// @connect      unpkg.com
// @connect      cdn.bootcdn.net
// ==/UserScript==

(function () {
    'use strict';

    /* ==================================================================
     *  XLSX 库多策略加载器（篡改猴 / ScriptCat 双平台兼容）
     * ================================================================== */

    let XLSXLib = null;

    const XLSX_CDN_LIST = [
        'https://cdn.jsdelivr.net/npm/xlsx@0.18.5/dist/xlsx.full.min.js',
        'https://unpkg.com/xlsx@0.18.5/dist/xlsx.full.min.js',
        'https://cdn.bootcdn.net/ajax/libs/xlsx/0.18.5/xlsx.full.min.js'
    ];

    function tryGetXLSXFromScope() {
        try {
            if (typeof XLSX !== 'undefined' && XLSX && XLSX.utils) return XLSX;
        } catch (e) { /* ignore */ }

        try {
            if (typeof unsafeWindow !== 'undefined' && unsafeWindow.XLSX && unsafeWindow.XLSX.utils) {
                return unsafeWindow.XLSX;
            }
        } catch (e) { /* ignore */ }

        try {
            if (window.XLSX && window.XLSX.utils) return window.XLSX;
        } catch (e) { /* ignore */ }

        return null;
    }

    function loadXLSXByGMXHR(cdnIndex) {
        return new Promise((resolve, reject) => {
            if (cdnIndex >= XLSX_CDN_LIST.length) {
                reject(new Error('所有 CDN 均加载失败'));
                return;
            }

            const url = XLSX_CDN_LIST[cdnIndex];
            console.log(`[缓考补考助手] 正在通过 GM_xmlhttpRequest 加载 XLSX：${url}`);

            if (typeof GM_xmlhttpRequest === 'undefined') {
                reject(new Error('GM_xmlhttpRequest 不可用'));
                return;
            }

            GM_xmlhttpRequest({
                method: 'GET',
                url: url,
                timeout: 20000,
                onload: function (response) {
                    if (response.status === 200 && response.responseText) {
                        try {
                            const module = { exports: {} };
                            const runner = new Function(
                                'module', 'exports',
                                response.responseText +
                                '\n;if (typeof XLSX !== "undefined") { module.exports = XLSX; }'
                            );
                            runner(module, module.exports);

                            const lib = module.exports;
                            if (lib && lib.utils && lib.utils.book_new) {
                                console.log('[缓考补考助手] XLSX 通过 GM_xmlhttpRequest 加载成功');
                                resolve(lib);
                            } else {
                                reject(new Error('XLSX 执行后未获取到有效对象'));
                            }
                        } catch (err) {
                            console.warn(`[缓考补考助手] CDN ${cdnIndex} 执行失败，尝试下一个`, err);
                            loadXLSXByGMXHR(cdnIndex + 1).then(resolve).catch(reject);
                        }
                    } else {
                        console.warn(`[缓考补考助手] CDN ${cdnIndex} 响应异常，尝试下一个`);
                        loadXLSXByGMXHR(cdnIndex + 1).then(resolve).catch(reject);
                    }
                },
                onerror: function () {
                    console.warn(`[缓考补考助手] CDN ${cdnIndex} 网络错误，尝试下一个`);
                    loadXLSXByGMXHR(cdnIndex + 1).then(resolve).catch(reject);
                },
                ontimeout: function () {
                    console.warn(`[缓考补考助手] CDN ${cdnIndex} 超时，尝试下一个`);
                    loadXLSXByGMXHR(cdnIndex + 1).then(resolve).catch(reject);
                }
            });
        });
    }

    async function ensureXLSX() {
        if (XLSXLib) return XLSXLib;

        XLSXLib = tryGetXLSXFromScope();
        if (XLSXLib) {
            console.log('[缓考补考助手] XLSX 从脚本作用域获取成功');
            return XLSXLib;
        }

        XLSXLib = await loadXLSXByGMXHR(0);
        return XLSXLib;
    }

    /* ==================================================================
     *  初始化入口
     * ================================================================== */

    function init() {
        createControlPanel();

        ensureXLSX()
            .then(() => {
                console.log('[缓考补考助手] XLSX 库准备就绪');
            })
            .catch((err) => {
                console.error('[缓考补考助手] XLSX 库预加载失败：', err);
                showStatus('⚠️ XLSX 库预加载失败，点击功能按钮时将自动重试。\n如持续失败请检查网络。', 'warning');
            });
    }

    if (document.readyState === 'complete') {
        setTimeout(init, 1000);
    } else {
        window.addEventListener('load', function () {
            setTimeout(init, 1000);
        });
    }

    /* ==================================================================
     *  控制面板
     * ================================================================== */

    function createControlPanel() {
        if (document.getElementById('grade-auto-fill-container')) return;

        const container = document.createElement('div');
        container.id = 'grade-auto-fill-container';
        container.style.cssText = `
            position: fixed;
            top: 60px;
            right: 20px;
            z-index: 10000;
        `;

        const toggleBtn = document.createElement('button');
        toggleBtn.id = 'grade-toggle-btn';
        toggleBtn.innerHTML = '📊';
        toggleBtn.style.cssText = `
            position: absolute;
            top: 0;
            right: 0;
            width: 40px;
            height: 40px;
            background: #1976d2;
            color: white;
            border: none;
            border-radius: 50%;
            cursor: move;
            font-size: 20px;
            box-shadow: 0 2px 5px rgba(0,0,0,0.3);
            display: none;
            z-index: 10001;
        `;

        const panel = document.createElement('div');
        panel.id = 'grade-auto-fill-panel';
        panel.style.cssText = `
            width: 320px;
            background: #fff;
            border: 2px solid #333;
            border-radius: 8px;
            box-shadow: 0 2px 10px rgba(0,0,0,0.3);
            transition: all 0.3s ease;
        `;

        const header = document.createElement('div');
        header.style.cssText = `
            padding: 10px 15px;
            background: #1976d2;
            color: white;
            border-radius: 6px 6px 0 0;
            cursor: move;
            user-select: none;
            display: flex;
            justify-content: space-between;
            align-items: center;
        `;
        header.innerHTML = `
            <h3 style="margin: 0; font-size: 16px;">📊 缓考补考成绩自动填报助手</h3>
            <div>
                <button id="minimize-btn" style="background: none; border: none; color: white; cursor: pointer; font-size: 20px; padding: 0 5px;">−</button>
                <button id="close-btn" style="background: none; border: none; color: white; cursor: pointer; font-size: 16px; padding: 0 5px;">✕</button>
            </div>
        `;

        const content = document.createElement('div');
        content.style.cssText = 'padding: 15px;';
        content.innerHTML = `
            <div style="margin-bottom: 15px; padding: 10px; background: #e3f2fd; border-radius: 4px;">
                <h4 style="margin: 0 0 8px 0; color: #1976d2;">第一步：导出成绩数据</h4>
                <button id="download-template-btn" style="width: 100%; padding: 8px; background: #1976d2; color: white; border: none; border-radius: 4px; cursor: pointer; font-size: 15px;">
                    📥 导出当前成绩Excel
                </button>
                <p style="margin: 5px 0 0 0; font-size: 11px; color: #666;">
                    包含所有学生信息和已填报的成绩
                </p>
            </div>

            <div style="margin-bottom: 15px; padding: 10px; background: #f3e5f5; border-radius: 4px;">
                <h4 style="margin: 0 0 8px 0; color: #7b1fa2;">第二步：上传修改后的成绩表</h4>
                <input type="file" id="excel-file-input" accept=".xlsx,.xls" style="width: 100%; margin-bottom: 8px;">
                <div style="display: flex; gap: 5px;">
                    <button id="preview-btn" style="flex: 1; padding: 8px; background: #7b1fa2; color: white; border: none; border-radius: 4px; cursor: pointer;">
                        👁️ 预览
                    </button>
                    <button id="fill-btn" style="flex: 1; padding: 8px; background: #ff5722; color: white; border: none; border-radius: 4px; cursor: pointer;">
                        ✍️ 自动填入
                    </button>
                </div>
                <p style="margin: 5px 0 0 0; font-size: 10px; color: #666; text-align: center;">
                    只会填入可编辑的成绩字段
                </p>
            </div>

            <div style="margin-bottom: 10px; padding: 8px; background: #fff3cd; border-radius: 4px;">
                <button id="clear-all-btn" style="width: 100%; padding: 6px; background: #f0ad4e; color: white; border: none; border-radius: 4px; cursor: pointer;">
                    🗑️ 清空所有可编辑成绩
                </button>
            </div>

            <div id="status-area" style="margin-top: 10px; padding: 10px; background: #f5f5f5; border-radius: 4px; display: none; max-height: 200px; overflow-y: auto;">
                <div id="status-text"></div>
            </div>

            <div style="margin-top: 10px; font-size: 12px; color: #666;">
                <details id="help-details">
                    <summary style="cursor: pointer; font-weight: bold;">📖 使用说明</summary>
                    <ol style="margin: 5px 0; padding-left: 20px;">
                        <li>点击"导出当前成绩Excel"下载表格</li>
                        <li>在Excel中修改需要录入的成绩</li>
                        <li>系统只会填入可编辑的成绩字段</li>
                        <li>灰色禁用的成绩字段会被自动跳过</li>
                        <li>空白成绩也会被填入为空</li>
                        <li>非数字内容将被跳过</li>
                    </ol>
                    <p style="color: #ff5722; margin: 5px 0;">
                        ⚠️ 注意：自动填入前会清空所有可编辑的原有成绩！
                    </p>
                </details>
            </div>

            <div style="margin-top: 10px; text-align: center; font-size: 11px; color: #999;">
                作者：舒宜彬 | v4.2 (缓考补考版)
            </div>
        `;

        panel.appendChild(header);
        panel.appendChild(content);
        container.appendChild(toggleBtn);
        container.appendChild(panel);
        document.body.appendChild(container);

        bindEvents();
        makeDraggable(container, header);
        makeDraggable(container, toggleBtn);
    }

    /* ==================================================================
     *  事件绑定
     * ================================================================== */

    function bindEvents() {
        document.getElementById('download-template-btn').addEventListener('click', downloadTemplate);
        document.getElementById('preview-btn').addEventListener('click', handlePreview);
        document.getElementById('fill-btn').addEventListener('click', handleFill);
        document.getElementById('clear-all-btn').addEventListener('click', handleClearAll);

        document.getElementById('minimize-btn').addEventListener('click', function () {
            document.getElementById('grade-auto-fill-panel').style.display = 'none';
            document.getElementById('grade-toggle-btn').style.display = 'block';
        });

        document.getElementById('close-btn').addEventListener('click', function () {
            if (confirm('确定要关闭成绩填报助手吗？')) {
                document.getElementById('grade-auto-fill-container').remove();
            }
        });

        document.getElementById('grade-toggle-btn').addEventListener('click', function (e) {
            if (e.target.dataset.dragging === 'true') {
                e.target.dataset.dragging = 'false';
                return;
            }
            document.getElementById('grade-auto-fill-panel').style.display = 'block';
            document.getElementById('grade-toggle-btn').style.display = 'none';
        });

        document.querySelectorAll('#grade-auto-fill-panel button').forEach(btn => {
            if (btn.id !== 'minimize-btn' && btn.id !== 'close-btn') {
                btn.addEventListener('mouseenter', function () { this.style.opacity = '0.9'; });
                btn.addEventListener('mouseleave', function () { this.style.opacity = '1'; });
            }
        });
    }

    /* ==================================================================
     *  拖动功能
     * ================================================================== */

    function makeDraggable(container, handle) {
        let pos1 = 0, pos2 = 0, pos3 = 0, pos4 = 0;
        let isDragging = false;

        handle.onmousedown = function (e) {
            e = e || window.event;
            e.preventDefault();
            pos3 = e.clientX;
            pos4 = e.clientY;
            isDragging = false;
            document.onmouseup = closeDragElement;
            document.onmousemove = elementDrag;
        };

        function elementDrag(e) {
            e = e || window.event;
            e.preventDefault();
            pos1 = pos3 - e.clientX;
            pos2 = pos4 - e.clientY;
            pos3 = e.clientX;
            pos4 = e.clientY;

            if (Math.abs(pos1) > 5 || Math.abs(pos2) > 5) {
                isDragging = true;
                if (handle.id === 'grade-toggle-btn') {
                    handle.dataset.dragging = 'true';
                }
            }

            container.style.top = (container.offsetTop - pos2) + 'px';
            container.style.left = (container.offsetLeft - pos1) + 'px';
            container.style.right = 'auto';
        }

        function closeDragElement() {
            document.onmouseup = null;
            document.onmousemove = null;
            if (handle.id === 'grade-toggle-btn' && !isDragging) {
                handle.dataset.dragging = 'false';
            }
        }
    }

    /* ==================================================================
     *  成绩清空
     * ================================================================== */

    function clearAllGrades() {
        let clearedCount = 0;
        const scoreInputs = document.querySelectorAll('input[name*="examGrade-"][name$=".score"]:not([disabled])');

        scoreInputs.forEach(input => {
            if (input.value !== '') {
                input.value = '';
                input.dispatchEvent(new Event('change', { bubbles: true }));
                input.dispatchEvent(new Event('blur', { bubbles: true }));
                clearedCount++;
            }
        });

        return { total: scoreInputs.length, cleared: clearedCount };
    }

    function handleClearAll() {
        if (confirm('确定要清空所有可编辑的成绩吗？\n此操作不可恢复！')) {
            const result = clearAllGrades();
            showStatus(`清空完成！\n共清空 ${result.cleared} 个成绩\n可编辑成绩框总计 ${result.total} 个`, 'warning');
        }
    }

    /* ==================================================================
     *  成绩类型识别
     * ================================================================== */

    function identifyGradeTypes() {
        const gradeTypes = [];
        const gradeMap = new Map();

        const secondHeaderRow = document.querySelector('table.gridtable thead tr:nth-child(2)');
        if (secondHeaderRow) {
            const headers = secondHeaderRow.querySelectorAll('th');
            let currentSection = '';
            let columnIndex = 3;

            for (let i = 3; i < headers.length - 1; i++) {
                const headerText = headers[i].textContent.trim();

                if (headerText === '成绩') {
                    const firstHeaderRow = document.querySelector('table.gridtable thead tr:first-child');
                    if (firstHeaderRow) {
                        const firstHeaders = firstHeaderRow.querySelectorAll('th');
                        let accumulatedCols = 0;
                        for (let j = 0; j < firstHeaders.length - 1; j++) {
                            const colspan = parseInt(firstHeaders[j].getAttribute('colspan') || '1');
                            accumulatedCols += colspan;
                            if (accumulatedCols > i) {
                                currentSection = firstHeaders[j].textContent.trim();
                                break;
                            }
                        }
                    }

                    const gradeTypeName = currentSection || `成绩${columnIndex - 2}`;
                    gradeTypes.push(gradeTypeName);
                    gradeMap.set(columnIndex, gradeTypeName);
                }
                columnIndex++;
            }
        }

        return { types: gradeTypes, map: gradeMap };
    }

    /* ==================================================================
     *  导出成绩模板（异步确保 XLSX 已加载）
     * ================================================================== */

    async function downloadTemplate() {
        let XLSX;
        try {
            showStatus('正在准备 XLSX 库...', 'info');
            XLSX = await ensureXLSX();
        } catch (err) {
            showStatus('❌ XLSX 库加载失败：' + err.message + '\n请检查网络后重试。', 'error');
            return;
        }

        const students = [];
        showStatus('正在导出数据...', 'info');

        const studentRows = document.querySelectorAll('#lessonTable tr');
        let exportedGradeCount = 0;

        studentRows.forEach(row => {
            const cells = row.querySelectorAll('td');
            if (cells.length > 2) {
                const studentId = cells[0].textContent.trim();
                const studentName = cells[1].textContent.trim();
                const className = cells[2].textContent.trim();

                const studentObj = {
                    '学号': studentId,
                    '姓名': studentName,
                    '行政班': className
                };

                // 期末成绩
                const finalGradeCell = cells[3];
                let finalGrade = finalGradeCell ? finalGradeCell.textContent.trim() : '';
                if (finalGrade.includes('缓考')) finalGrade = '缓考';
                studentObj['期末成绩'] = finalGrade;

                // 平时成绩 / 补缓考成绩
                const usualScoreInputs = row.querySelectorAll('input[name*="examGrade-"][name$=".score"]');
                let usualScore = '';
                let makeupScore = '';

                usualScoreInputs.forEach(input => {
                    if (input.disabled) {
                        usualScore = input.value || '';
                    } else {
                        makeupScore = input.value || '';
                    }
                });

                studentObj['平时成绩'] = usualScore;

                // 补缓考类型
                const makeupTypeCell = cells[7];
                studentObj['补缓考类型'] = makeupTypeCell ? makeupTypeCell.textContent.trim() : '';

                // 补缓考成绩
                studentObj['补缓考成绩'] = makeupScore;

                // 最终成绩
                const finalResultCell = cells[cells.length - 1];
                studentObj['最终成绩'] = finalResultCell ? finalResultCell.textContent.trim() : '';

                if (usualScore) exportedGradeCount++;
                if (makeupScore) exportedGradeCount++;

                students.push(studentObj);
            }
        });

        if (students.length === 0) {
            showStatus('未能从页面提取到学生信息！', 'error');
            return;
        }

        const wb = XLSX.utils.book_new();
        const ws = XLSX.utils.json_to_sheet(students);

        ws['!cols'] = [
            { wch: 15 }, // 学号
            { wch: 12 }, // 姓名
            { wch: 15 }, // 行政班
            { wch: 12 }, // 期末成绩
            { wch: 12 }, // 平时成绩
            { wch: 15 }, // 补缓考类型
            { wch: 12 }, // 补缓考成绩
            { wch: 12 }  // 最终成绩
        ];

        XLSX.utils.book_append_sheet(wb, ws, '缓考补考成绩数据');

        const courseInfo = document.querySelector('.grade-input-lesson-info');
        let courseName = '缓考补考成绩';
        if (courseInfo) {
            const match = courseInfo.textContent.match(/课程名称:([^课程类别]+)/);
            if (match) courseName = match[1].trim();
        }

        XLSX.writeFile(wb, `${courseName}_缓考补考成绩_${new Date().toLocaleDateString().replace(/\//g, '-')}.xlsx`);
        showStatus(
            `导出成功！\n共${students.length}名学生\n已填报成绩：${exportedGradeCount}个\n\n请在Excel中修改"补缓考成绩"列的数据`,
            'success'
        );
    }

    /* ==================================================================
     *  Excel 读取与预览
     * ================================================================== */

    let excelData = null;
    let skippedRecords = [];

    async function handlePreview() {
        const file = document.getElementById('excel-file-input').files[0];
        if (!file) { showStatus('请先选择Excel文件！', 'error'); return; }

        try {
            showStatus('正在读取Excel文件...', 'info');
            excelData = await parseExcelFile(file);

            let validCount = 0, emptyCount = 0, invalidCount = 0;

            excelData.forEach(row => {
                const makeupScore = String(row['补缓考成绩'] === undefined || row['补缓考成绩'] === null
                    ? '' : row['补缓考成绩']).trim();
                if (makeupScore === '') { emptyCount++; }
                else if (!isNaN(makeupScore)) { validCount++; }
                else { invalidCount++; }
            });

            let preview = `成功读取 ${excelData.length} 条数据\n`;
            preview += `有效补缓考成绩：${validCount} 个\n`;
            preview += `空白成绩：${emptyCount} 个\n`;
            if (invalidCount > 0) preview += `非数字成绩：${invalidCount} 处（将被跳过）\n`;
            preview += '\n数据预览（前3条）：\n';

            excelData.slice(0, 3).forEach((row, i) => {
                preview += `${i + 1}. ${row['学号']} ${row['姓名']}\n`;
                const s = row['补缓考成绩'];
                preview += `   补缓考成绩: ${s === '' || s === undefined || s === null ? '(空)' : s}\n`;
            });

            showStatus(preview, 'info');
        } catch (error) {
            showStatus('读取文件失败：' + error.message, 'error');
        }
    }

    /* ==================================================================
     *  自动填入
     * ================================================================== */

    async function handleFill() {
        const file = document.getElementById('excel-file-input').files[0];
        if (!file) { showStatus('请先选择Excel文件！', 'error'); return; }

        excelData = null;
        try {
            showStatus('正在读取Excel文件...', 'info');
            excelData = await parseExcelFile(file);
        } catch (error) {
            showStatus('读取文件失败：' + error.message, 'error');
            return;
        }

        if (confirm('确定要自动填入补缓考成绩吗？\n注意：填入前会先清空所有可编辑的原有成绩！')) {
            showStatus('正在清空原有成绩...', 'info');
            const clearResult = clearAllGrades();
            setTimeout(() => {
                showStatus('正在填入新成绩...', 'info');
                const result = fillGrades(excelData);
                showDetailedReport(result, clearResult);
            }, 500);
        }
    }

    /* ==================================================================
     *  Excel 解析（异步确保 XLSX 已加载）
     * ================================================================== */

    function parseExcelFile(file) {
        return new Promise((resolve, reject) => {
            ensureXLSX().then((XLSX) => {
                const reader = new FileReader();
                reader.onload = function (e) {
                    try {
                        const workbook = XLSX.read(e.target.result, { type: 'binary' });
                        const worksheet = workbook.Sheets[workbook.SheetNames[0]];
                        resolve(XLSX.utils.sheet_to_json(worksheet));
                    } catch (err) {
                        reject(err);
                    }
                };
                reader.onerror = function () {
                    reject(new Error('文件读取失败'));
                };
                reader.readAsBinaryString(file);
            }).catch((err) => {
                reject(new Error('XLSX 库加载失败：' + err.message));
            });
        });
    }

    /* ==================================================================
     *  成绩填入核心逻辑
     * ================================================================== */

    function fillGrades(data) {
        let filledCount = 0, emptyFills = 0;
        let notFoundStudents = [], successfulFills = [];
        skippedRecords = [];

        const pageStudentMap = new Map();
        document.querySelectorAll('#lessonTable tr').forEach(row => {
            const cells = row.querySelectorAll('td');
            if (cells.length > 2) {
                const studentId = cells[0].textContent.trim();
                const studentName = cells[1].textContent.trim();
                pageStudentMap.set(`${studentId}_${studentName}`, row);
            }
        });

        data.forEach(student => {
            const studentId = String(student['学号'] || '').trim();
            const studentName = String(student['姓名'] || '').trim();
            const makeupScore = String(
                student['补缓考成绩'] === undefined || student['补缓考成绩'] === null
                    ? '' : student['补缓考成绩']
            ).trim();

            if (!studentId || !studentName) return;

            const studentRow = pageStudentMap.get(`${studentId}_${studentName}`);

            if (studentRow) {
                const editableInputs = studentRow.querySelectorAll(
                    'input[name*="examGrade-"][name$=".score"]:not([disabled])'
                );

                if (editableInputs.length > 0) {
                    const scoreInput = editableInputs[0];

                    if (makeupScore === '') {
                        scoreInput.value = '';
                        scoreInput.dispatchEvent(new Event('change', { bubbles: true }));
                        scoreInput.dispatchEvent(new Event('blur', { bubbles: true }));
                        emptyFills++;
                        filledCount++;
                        successfulFills.push({ 学号: studentId, 姓名: studentName, 成绩: '(空)' });
                    } else if (!isNaN(makeupScore)) {
                        scoreInput.value = makeupScore;
                        scoreInput.dispatchEvent(new Event('change', { bubbles: true }));
                        scoreInput.dispatchEvent(new Event('blur', { bubbles: true }));
                        filledCount++;
                        successfulFills.push({ 学号: studentId, 姓名: studentName, 成绩: makeupScore });
                    } else {
                        skippedRecords.push({
                            学号: studentId,
                            姓名: studentName,
                            原因: `"${makeupScore}"不是有效数字`
                        });
                    }
                }
            } else if (makeupScore !== '') {
                notFoundStudents.push({ 学号: studentId, 姓名: studentName });
            }
        });

        return { total: data.length, filledCount, emptyFills, skippedRecords, notFoundStudents, successfulFills };
    }

    /* ==================================================================
     *  状态显示
     * ================================================================== */

    function showStatus(message, type = 'info') {
        const statusArea = document.getElementById('status-area');
        const statusText = document.getElementById('status-text');
        if (!statusArea || !statusText) {
            console.log('[缓考补考助手] ' + message);
            return;
        }
        statusArea.style.display = 'block';
        statusText.textContent = message;
        statusText.style.whiteSpace = 'pre-wrap';

        const styles = {
            success: { bg: '#d4edda', color: '#155724' },
            error:   { bg: '#f8d7da', color: '#721c24' },
            warning: { bg: '#fff3cd', color: '#856404' },
            info:    { bg: '#f5f5f5', color: '#333' }
        };
        const s = styles[type] || styles.info;
        statusArea.style.background = s.bg;
        statusArea.style.color = s.color;
    }

    /* ==================================================================
     *  详细报告
     * ================================================================== */

    function showDetailedReport(result, clearResult) {
        let message = `=== 填报完成 ===\n\n`;
        if (clearResult) message += `🗑️ 已清空 ${clearResult.cleared} 个原有成绩\n\n`;

        message += `✅ 成功填报：${result.filledCount} 条`;
        if (result.emptyFills > 0) message += `（含${result.emptyFills}处空值）`;
        message += '\n';

        if (result.successfulFills.length > 0 && result.successfulFills.length <= 5) {
            message += '\n成功填报的学生：\n';
            result.successfulFills.forEach(s => {
                message += `  ${s.学号} ${s.姓名} - 补缓考成绩: ${s.成绩}\n`;
            });
        } else if (result.successfulFills.length > 5) {
            message += '\n成功填报的学生（显示前5条）：\n';
            result.successfulFills.slice(0, 5).forEach(s => {
                message += `  ${s.学号} ${s.姓名} - 补缓考成绩: ${s.成绩}\n`;
            });
            message += `  ...还有${result.successfulFills.length - 5}条\n`;
        }

        if (result.notFoundStudents.length > 0) {
            message += `\n❌ 未找到的学生（${result.notFoundStudents.length}人）：\n`;
            result.notFoundStudents.slice(0, 5).forEach(s => {
                message += `  ${s.学号} ${s.姓名}\n`;
            });
            if (result.notFoundStudents.length > 5) {
                message += `  ...还有${result.notFoundStudents.length - 5}人\n`;
            }
        }

        if (result.skippedRecords.length > 0) {
            message += `\n⚠️ 跳过的非数字记录（${result.skippedRecords.length}条）：\n`;
            result.skippedRecords.slice(0, 5).forEach(s => {
                message += `  ${s.学号} ${s.姓名}：${s.原因}\n`;
            });
            if (result.skippedRecords.length > 5) {
                message += `  ...还有${result.skippedRecords.length - 5}条\n`;
            }
        }

        showStatus(message, result.filledCount > 0 ? 'success' : 'warning');
        if (skippedRecords.length > 0) addDownloadButton();
    }

    /* ==================================================================
     *  跳过记录下载
     * ================================================================== */

    function addDownloadButton() {
        if (document.getElementById('download-skipped-btn')) return;
        const btnContainer = document.createElement('div');
        btnContainer.style.marginTop = '10px';
        const downloadBtn = document.createElement('button');
        downloadBtn.id = 'download-skipped-btn';
        downloadBtn.textContent = '📊 下载跳过记录';
        downloadBtn.style.cssText = `
            width: 100%;
            padding: 8px;
            background: #ff9800;
            color: white;
            border: none;
            border-radius: 4px;
            cursor: pointer;
        `;
        downloadBtn.addEventListener('click', downloadSkippedRecords);
        btnContainer.appendChild(downloadBtn);
        document.getElementById('status-area').appendChild(btnContainer);
    }

    async function downloadSkippedRecords() {
        if (skippedRecords.length === 0) {
            showStatus('没有跳过的记录！', 'info');
            return;
        }

        let XLSX;
        try {
            XLSX = await ensureXLSX();
        } catch (err) {
            showStatus('❌ XLSX 库加载失败：' + err.message, 'error');
            return;
        }

        const wb = XLSX.utils.book_new();
        const ws = XLSX.utils.json_to_sheet(skippedRecords);
        ws['!cols'] = [{ wch: 15 }, { wch: 12 }, { wch: 40 }];
        XLSX.utils.book_append_sheet(wb, ws, '跳过记录');
        XLSX.writeFile(wb, `跳过记录_${new Date().toLocaleDateString().replace(/\//g, '-')}.xlsx`);
        showStatus(`已下载 ${skippedRecords.length} 条跳过记录`, 'success');
    }

})();