@PostMapping("/make/report/target/performance/first")
public AjaxResult makeTargetReportFirst(@RequestBody MakeReportDTO makeReportDTO) {Map<String, String> textReplaceMap = new HashMap<>();// 替換日期LocalDateTime nowData = LocalDateTime.now();DateTimeFormatter dateFormatter = DateTimeFormatter.ofPattern("yyyy年MM月dd日");textReplaceMap.put("${nowDate}", nowData.format(dateFormatter));String templatePath = uploadPklExcelPath + "template1.docx";String directoryPath = fileUploadDir;try {if (!Files.exists(Paths.get(directoryPath))) {Files.createDirectories(Paths.get(directoryPath));}try (InputStream is = new FileInputStream(templatePath);XWPFDocument doc = new XWPFDocument(is)) {// 替換普通文本占位符（段落和表格內文本）replaceTextPlaceholders(doc, textReplaceMap);List<List<String>> excelData = makeReportDTO.getExcelData();if (excelData == null || excelData.isEmpty()) {return AjaxResult.error("excelData不能為空");}// 替換表格內容，按列替換，且新增行replaceTableDataByColumns(doc, excelData);// 生成唯一文件名String fileName = generateUniqueFileName();String outPath = directoryPath + fileName;try (OutputStream os = new FileOutputStream(outPath)) {doc.write(os);}return AjaxResult.success(outPath);}} catch (FileNotFoundException e) {return AjaxResult.error("文件未找到：" + e.getMessage());} catch (Exception e) {e.printStackTrace();return AjaxResult.error("報告生成失敗：" + e.getMessage());}
}private void replaceTextPlaceholders(XWPFDocument doc, Map<String, String> replaceMap) {// 替換段落中的占位符doc.getParagraphs().forEach(paragraph -> {paragraph.getRuns().forEach(run -> {String text = run.getText(0);if (text != null) {for (Map.Entry<String, String> entry : replaceMap.entrySet()) {if (text.contains(entry.getKey())) {run.setText(text.replace(entry.getKey(), entry.getValue()), 0);}}}});});// 替換表格中的占位符doc.getTables().forEach(table -> {table.getRows().forEach(row -> {row.getTableCells().forEach(cell -> {cell.getParagraphs().forEach(paragraph -> {paragraph.getRuns().forEach(run -> {String text = run.getText(0);if (text != null) {for (Map.Entry<String, String> entry : replaceMap.entrySet()) {if (text.contains(entry.getKey())) {run.setText(text.replace(entry.getKey(), entry.getValue()), 0);}}}});});});});});}private void replaceTableDataByColumns(XWPFDocument doc, List<List<String>> excelData) {if (doc.getTables().isEmpty()) {throw new IllegalArgumentException("模板中沒有表格");}XWPFTable table = doc.getTables().get(0);// 求最大行數int maxRowCount = excelData.stream().mapToInt(List::size).max().orElse(0);int templateRowCount = table.getNumberOfRows();// 不夠行就新增for (int i = templateRowCount; i < maxRowCount; i++) {table.createRow();}for (int col = 0; col < excelData.size(); col++) {List<String> colData = excelData.get(col);for (int row = 0; row < maxRowCount; row++) {XWPFTableRow tableRow = table.getRow(row);// 設置固定高度為 5mm（約 284 Twips）tableRow.setHeight(284);tableRow.setHeightRule(TableRowHeightRule.EXACT);// 確保當前行有對應列單元格while (tableRow.getTableCells().size() <= col) {tableRow.createCell();}XWPFTableCell cell = tableRow.getCell(col);// 清空舊內容cell.removeParagraph(0);// 寫入新文本并設置字體樣式為小四宋體（12pt）XWPFParagraph paragraph = cell.addParagraph();XWPFRun run = paragraph.createRun();String text = row < colData.size() ? colData.get(row) : "";run.setText(text);run.setFontFamily("宋體");run.setFontSize(10); // 小四：12pt}}}private String generateUniqueFileName() {long timestamp = System.currentTimeMillis();int randomNum = new Random().nextInt(10000);return timestamp + "_" + randomNum + ".docx";}

{"excelData": [["水用量","水泥用量","水泥-種類","水泥-細度","水泥-28天抗壓強度","礦粉用量","礦粉-細度","礦粉-28天活性指數","粉煤灰用量","粉煤灰-細度","粉煤灰-28天活性指數","砂用量","砂-細度","砂-石粉含量","石用量","石-含泥量","石-壓碎指標值","減水劑用量","減水劑-含固量","減水劑-水泥凈漿流動度","增效劑用量","坍落度","3天抗壓強度","7天抗壓強度","28天抗壓強度"],["150","145","0","1.6","57.7","50","3.9","106","90","32.4","73","895","2.84","9.40","1010","0.92","0","10","11.5","190","1.43","205","22.5","31.8","47.6"]]
}