<dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi-ooxml</artifactId>
		    <version>4.1.2</version>
		</dependency>
		<dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi-scratchpad</artifactId>
		    <version>4.1.2</version>
		</dependency>
		<dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi-excelant</artifactId>
		    <version>4.1.2</version>
		</dependency>
		<dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi-ooxml-schemas</artifactId>
		    <version>4.1.2</version>
		</dependency>
		<dependency>
			<groupId>org.jfree</groupId>
			<artifactId>jfreechart</artifactId>
			<version>1.5.3</version>
		</dependency>
		<dependency>
			<groupId>com.deepoove</groupId>
			<artifactId>poi-tl</artifactId>
			<version>1.10.0</version>
		</dependency>

    private static final String TEMPLATE_PATH = "classpath:template/report.docx";
    private static final String OUTPUT_DIR = "D:/data/upload/analysis/";
    private static final String PIC_DIR = OUTPUT_DIR + "pic/";

    public void getWord(String curDistCode) {
        try {
            // 獲取模板文件
            File file = ResourceUtils.getFile(TEMPLATE_PATH);

            // 構(gòu)建模板替換的數(shù)據(jù)
            Map<String, Object> dataMap = buildTemplateData(curDistCode);

            // 生成最終文件路徑
            String fileName = UUIDUtil.genUUID32() + ".docx";
            String filePath = OUTPUT_DIR + fileName;

            // 使用 POI-TL 渲染模板并保存
            try (XWPFTemplate template = XWPFTemplate.compile(file, Configure.newBuilder().buildGramer("${", "}").build())
                    .render(dataMap)) {
                template.writeToFile(filePath);
            }
            //上傳文件返回附件id
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private Map<String, Object> buildTemplateData(String curDistCode) throws IOException {
        Map<String, Object> dataMap = new HashMap<>();

        // 設(shè)置日期和在線總數(shù)
        dataMap.put("date", LocalDate.now());
        // 查詢設(shè)備數(shù)據(jù)
        dataMap.put("onlineTotal", 100);
        // 生成每日在線圖表
        DefaultCategoryDataset dailyData = buildDailyDataset(stationByTime);
        String dailyPicFile = generateChart(dailyData, "監(jiān)測站總在線數(shù)", "小時(shí)", "數(shù)量", dailyOnlineTxtEnum);
        dataMap.put("dailyOnlinePic", Pictures.ofStream(new FileInputStream(dailyPicFile), PictureType.JPEG).size(600, 200).create());
        return dataMap;
    }
    // 構(gòu)建每日在線圖表的數(shù)據(jù)集
    private DefaultCategoryDataset buildDailyDataset(List<FireStationByTimeDTO> stationByTime) {
        DefaultCategoryDataset dataset = new DefaultCategoryDataset();
        stationByTime.forEach(t -> dataset.addValue(t.getOnlineNum(), "", t.getTime()));
        return dataset;
    }
    // 生成圖表并保存為圖片
    private String generateChart(DefaultCategoryDataset dataset, String title, String xAxisLabel, String yAxisLabel, DailyOnlineTxtEnum style) throws IOException {
        // 設(shè)置全局字體（支持中文）
        StandardChartTheme chartTheme = new StandardChartTheme("CN");
        chartTheme.setExtraLargeFont(new Font("宋體", Font.PLAIN, 14)); // 標(biāo)題字體
        chartTheme.setLargeFont(new Font("宋體", Font.PLAIN, 14));     // 圖例字體
        chartTheme.setRegularFont(new Font("宋體", Font.PLAIN, 12));   // 軸標(biāo)簽字體
        ChartFactory.setChartTheme(chartTheme);

        // 創(chuàng)建圖表
        JFreeChart chart = ChartFactory.createLineChart(title, xAxisLabel, yAxisLabel, dataset);
        setChartStyle(chart, style);

        // 保存圖表為圖片
        String picFile = PIC_DIR + UUIDUtil.genUUID32() + ".png";
        //int numberOfCategories = dataset.getColumnCount();
        //int width = Math.max(800, numberOfCategories * 50); // 每個(gè)類別寬度為50，最小寬度為800
        ChartUtils.saveChartAsPNG(new File(picFile), chart, 1200, 400);
        return picFile;
    }

    // 設(shè)置圖表樣式
    private void setChartStyle(JFreeChart chart) {
        CategoryPlot plot = chart.getCategoryPlot();
        chart.setBackgroundPaint(Color.WHITE);
        plot.setBackgroundPaint(Color.WHITE);
        plot.setDomainGridlinePaint(Color.LIGHT_GRAY);
        plot.setRangeGridlinePaint(Color.LIGHT_GRAY);
        // 設(shè)置第一條折線的粗細(xì)
        plot.getRenderer().setSeriesStroke(0, new BasicStroke(5.0f));
         // 根據(jù)樣式設(shè)置折線顏色
        plot.getRenderer().setSeriesPaint(0, Color.RED);
    }

       // 設(shè)置全局字體（支持中文）
        StandardChartTheme chartTheme = new StandardChartTheme("CN");
        chartTheme.setExtraLargeFont(new Font("宋體", Font.PLAIN, 14)); // 標(biāo)題字體
        chartTheme.setLargeFont(new Font("宋體", Font.PLAIN, 14));     // 圖例字體
        chartTheme.setRegularFont(new Font("宋體", Font.PLAIN, 12));   // 軸標(biāo)簽字體
        ChartFactory.setChartTheme(chartTheme);

ChartUtils.saveChartAsPNG(new File(picFile), chart, 1200, 400);

dataMap.put("dailyOnlinePic", 
Pictures.ofStream(new FileInputStream(dailyPicFile), PictureType.JPEG).size(600, 200).create());

int numberOfCategories = dataset.getColumnCount();
int width = Math.max(800, numberOfCategories * 50); // 每個(gè)類別寬度為50，最小寬度為800