package com.ruoyi.util;

import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.TemplateExceptionHandler;

import java.io.*;
import java.nio.charset.StandardCharsets;
import java.util.*;

public class TestReportDocGenerator {

    public static void main(String[] args) throws Exception {
        generateTestReportDoc();
    }

    public static void generateTestReportDoc() throws Exception {
        Configuration cfg = new Configuration(Configuration.VERSION_2_3_32);
        cfg.setClassForTemplateLoading(TestReportDocGenerator.class, "/static");
        cfg.setDefaultEncoding("UTF-8");
        cfg.setTemplateExceptionHandler(TemplateExceptionHandler.RETHROW_HANDLER);

        Map<String, Object> data = new HashMap<>();

        // 项目基本信息
        data.put("projectName", "产品库存管理系统");
        data.put("projectVersion", "V1.0");
        data.put("docDate", "2026年6月");

        // 测试计划概述
        data.put("testScope", "覆盖库存管理、采购销售、质检设备、人事协同、AI智能化等全部功能模块");
        data.put("testMethodology", "黑盒测试 + 白盒测试 + 自动化测试 + 性能测试");
        data.put("testCycle", "2026年5月20日 - 2026年6月30日");
        data.put("testEnv", "测试环境：Windows Server 2022 / JDK 25 / MySQL 8.0 / Redis 7.0");

        // 测试用例
        List<Map<String, String>> testCases = new ArrayList<>();
        testCases.add(createTestCase("TC-001", "登录模块", "用户名密码正确登录", "登录成功跳转主页", "登录成功", "通过", "王XX"));
        testCases.add(createTestCase("TC-002", "登录模块", "用户名错误登录", "提示用户不存在", "提示正确", "通过", "刘XX"));
        testCases.add(createTestCase("TC-003", "登录模块", "密码错误连续5次", "账号锁定30分钟", "锁定成功", "通过", "刘XX"));
        testCases.add(createTestCase("TC-004", "登录模块", "空用户名登录", "提示用户名为空", "提示正确", "通过", "刘XX"));
        testCases.add(createTestCase("TC-005", "库存管理", "采购入库-正常数据", "入库成功，库存增加", "入库成功", "通过", "王XX"));
        testCases.add(createTestCase("TC-006", "库存管理", "采购入库-缺少必填项", "提示必填字段", "提示正确", "通过", "刘XX"));
        testCases.add(createTestCase("TC-007", "库存管理", "销售出库-正常数据", "出库成功，库存减少", "出库成功", "通过", "王XX"));
        testCases.add(createTestCase("TC-008", "库存管理", "销售出库-库存不足", "提示库存不足", "提示正确", "通过", "刘XX"));
        testCases.add(createTestCase("TC-009", "库存管理", "库存盘点-差异报告", "生成差异报告", "报告正确", "通过", "王XX"));
        testCases.add(createTestCase("TC-010", "库存管理", "库存预警-下限触发", "自动生成预警通知", "通知已发送", "通过", "王XX"));
        testCases.add(createTestCase("TC-011", "采购管理", "创建采购订单", "订单创建成功", "创建成功", "通过", "赵XX"));
        testCases.add(createTestCase("TC-012", "采购管理", "采购审批流程", "逐级审批通过", "审批正常", "通过", "赵XX"));
        testCases.add(createTestCase("TC-013", "采购管理", "供应商信息维护", "信息更新成功", "更新成功", "通过", "赵XX"));
        testCases.add(createTestCase("TC-014", "销售管理", "创建销售订单", "订单创建成功", "创建成功", "通过", "赵XX"));
        testCases.add(createTestCase("TC-015", "销售管理", "销售报价单生成", "报价单生成PDF", "生成成功", "通过", "赵XX"));
        testCases.add(createTestCase("TC-016", "质检管理", "来料检验-合格品", "检验通过入库", "检验正确", "通过", "刘XX"));
        testCases.add(createTestCase("TC-017", "质检管理", "不合格品处理流程", "触发不合格处理流程", "流程正确", "通过", "刘XX"));
        testCases.add(createTestCase("TC-018", "设备管理", "设备台账录入", "设备信息保存成功", "保存成功", "通过", "王XX"));
        testCases.add(createTestCase("TC-019", "设备管理", "保养计划创建", "计划创建成功", "创建成功", "通过", "王XX"));
        testCases.add(createTestCase("TC-020", "设备管理", "保养验收确认", "验收通过记录归档", "验收成功", "进行中", "王XX"));
        testCases.add(createTestCase("TC-021", "人事管理", "员工入职登记", "员工信息入库", "登记成功", "通过", "赵XX"));
        testCases.add(createTestCase("TC-022", "人事管理", "合同到期提醒", "自动发送提醒通知", "通知已发送", "通过", "赵XX"));
        testCases.add(createTestCase("TC-023", "AI模块", "智能问答-库存查询", "返回正确库存信息", "返回正确", "通过", "孙XX"));
        testCases.add(createTestCase("TC-024", "AI模块", "库存预测准确性", "预测误差小于15%", "误差12%", "通过", "孙XX"));
        testCases.add(createTestCase("TC-025", "AI模块", "OCR文档识别", "识别准确率&gt;95%", "准确率96.5%", "通过", "孙XX"));
        testCases.add(createTestCase("TC-026", "AI模块", "语音录入功能", "识别准确率&gt;90%", "准确率88%", "进行中", "孙XX"));
        testCases.add(createTestCase("TC-027", "系统管理", "用户权限配置", "权限生效且隔离", "权限正确", "通过", "刘XX"));
        testCases.add(createTestCase("TC-028", "系统管理", "操作日志审计", "关键操作全记录", "记录完整", "通过", "刘XX"));
        testCases.add(createTestCase("TC-029", "性能测试", "100并发用户登录", "响应时间&lt;3秒", "平均1.8秒", "通过", "刘XX"));
        testCases.add(createTestCase("TC-030", "性能测试", "百万级数据查询", "查询时间&lt;2秒", "0.9秒", "通过", "刘XX"));
        data.put("testCases", testCases);

        // 测试进度跟踪
        List<Map<String, String>> progress = new ArrayList<>();
        progress.add(createProgress("2026-05-20", "登录模块、库存入库", "8", "8", "100%", "已完成第一轮"));
        progress.add(createProgress("2026-05-21", "库存出库、库存盘点", "10", "9", "90%", "库存盘点待回归"));
        progress.add(createProgress("2026-05-22", "库存预警、采购订单", "8", "8", "100%", ""));
        progress.add(createProgress("2026-05-23", "销售管理、供应商管理", "10", "8", "80%", "供应商审批流程待测"));
        progress.add(createProgress("2026-05-24", "质检管理全流程", "6", "6", "100%", ""));
        progress.add(createProgress("2026-05-25", "设备台账、保养计划", "6", "4", "67%", "保养验收功能开发中"));
        progress.add(createProgress("2026-05-26", "人事管理、合同管理", "8", "6", "75%", "合同到期提醒待验证"));
        progress.add(createProgress("2026-05-27", "AI智能问答、OCR识别", "6", "5", "83%", "语音录入准确率待优化"));
        progress.add(createProgress("2026-05-28", "系统管理、性能测试", "8", "6", "75%", "性能测试进行中"));
        progress.add(createProgress("2026-05-29", "全模块回归测试", "30", "25", "83%", "3个用例待修复后重测"));
        progress.add(createProgress("2026-05-30", "缺陷修复验证", "12", "10", "83%", "2个低优先级缺陷延后处理"));
        data.put("progress", progress);

        // 缺陷跟踪
        List<Map<String, String>> defects = new ArrayList<>();
        defects.add(createDefect("BUG-001", "库存查询响应时间超过5秒", "严重", "王XX", "已修复", "2026-05-22"));
        defects.add(createDefect("BUG-002", "入库批号重复校验失效", "严重", "王XX", "已修复", "2026-05-22"));
        defects.add(createDefect("BUG-003", "采购订单金额精度丢失", "一般", "赵XX", "已修复", "2026-05-23"));
        defects.add(createDefect("BUG-004", "前端分页组件显示异常", "轻微", "陈XX", "已修复", "2026-05-24"));
        defects.add(createDefect("BUG-005", "AI智能问答接口超时", "严重", "孙XX", "修复中", "2026-05-27"));
        defects.add(createDefect("BUG-006", "设备保养提醒定时任务未触发", "一般", "王XX", "待处理", "2026-05-28"));
        defects.add(createDefect("BUG-007", "Excel导出大数据量内存溢出", "一般", "王XX", "修复中", "2026-05-29"));
        defects.add(createDefect("BUG-008", "语音录入方言识别率低", "轻微", "孙XX", "待处理", "2026-05-30"));
        defects.add(createDefect("BUG-009", "多用户同时盘点导致数据不一致", "严重", "王XX", "待处理", "2026-05-30"));
        defects.add(createDefect("BUG-010", "移动端页面适配异常", "轻微", "陈XX", "待处理", "2026-05-30"));
        data.put("defects", defects);

        // 测试统计
        data.put("totalCases", "80");
        data.put("passedCases", "68");
        data.put("failedCases", "3");
        data.put("inProgressCases", "5");
        data.put("blockedCases", "4");
        data.put("passRate", "85.0%");
        data.put("totalDefects", "10");
        data.put("fixedDefects", "4");
        data.put("openDefects", "4");
        data.put("inProgressDefects", "2");
        data.put("criticalDefects", "3");
        data.put("majorDefects", "3");
        data.put("minorDefects", "4");

        // 测试结论
        data.put("testConclusion", "系统整体功能完整，核心业务流程通过测试。存在3个严重缺陷待修复：AI接口超时、盘点并发数据不一致、Excel导出内存溢出。建议修复严重缺陷后安排第二轮回归测试，再进入上线流程。");
        data.put("releaseSuggestion", "有条件通过，修复严重缺陷后可上线");

        // 待办事项
        List<Map<String, String>> actionItems = new ArrayList<>();
        actionItems.add(createActionItem("1", "修复AI智能问答接口超时问题", "孙XX", "2026-06-02"));
        actionItems.add(createActionItem("2", "修复盘点并发数据一致性问题", "王XX", "2026-06-03"));
        actionItems.add(createActionItem("3", "修复Excel大数据量导出内存溢出", "王XX", "2026-06-03"));
        actionItems.add(createActionItem("4", "完成语音录入方言识别优化", "孙XX", "2026-06-05"));
        actionItems.add(createActionItem("5", "完成第二轮全量回归测试", "刘XX", "2026-06-08"));
        actionItems.add(createActionItem("6", "输出最终测试报告", "刘XX", "2026-06-10"));
        data.put("actionItems", actionItems);

        // 加载模板并生成
        Template template = cfg.getTemplate("测试报告.xml");
        StringWriter out = new StringWriter();
        template.process(data, out);

        // 保存为docx
        String outputPath = "D:/牛马/文档/测试报告.docx";
        File outputFile = new File(outputPath);
        outputFile.getParentFile().mkdirs();
        try (FileOutputStream fos = new FileOutputStream(outputFile);
             OutputStreamWriter osw = new OutputStreamWriter(fos, StandardCharsets.UTF_8)) {
            osw.write(out.toString());
        }

        System.out.println("测试报告生成成功: " + outputPath);
    }

    private static Map<String, String> createTestCase(String no, String module, String content,
                                                       String expected, String actual, String status, String tester) {
        Map<String, String> map = new HashMap<>();
        map.put("no", no);
        map.put("module", module);
        map.put("content", content);
        map.put("expected", expected);
        map.put("actual", actual);
        map.put("status", status);
        map.put("tester", tester);
        return map;
    }

    private static Map<String, String> createProgress(String date, String content, String total,
                                                       String completed, String rate, String remark) {
        Map<String, String> map = new HashMap<>();
        map.put("date", date);
        map.put("content", content);
        map.put("total", total);
        map.put("completed", completed);
        map.put("rate", rate);
        map.put("remark", remark);
        return map;
    }

    private static Map<String, String> createDefect(String no, String desc, String severity,
                                                     String owner, String status, String deadline) {
        Map<String, String> map = new HashMap<>();
        map.put("no", no);
        map.put("desc", desc);
        map.put("severity", severity);
        map.put("owner", owner);
        map.put("status", status);
        map.put("deadline", deadline);
        return map;
    }

    private static Map<String, String> createActionItem(String no, String content, String owner, String deadline) {
        Map<String, String> map = new HashMap<>();
        map.put("no", no);
        map.put("content", content);
        map.put("owner", owner);
        map.put("deadline", deadline);
        return map;
    }
}