trafficAudit.git

			@@ -3207,9 +3207,20 @@
			}
			try (InputStream in = new FileInputStream(template);
			XSSFWorkbook wb = new XSSFWorkbook(in)) {
			File donor = resolveSummaryDonor(year, month);
			if (donor != null) {
			try (InputStream din = new FileInputStream(donor); XSSFWorkbook dwb = new XSSFWorkbook(din)) {
			int restored = restoreSummaryMonthlyBlocks(wb, dwb);
			log.info("汇总工作簿月度块还原完成，补齐/覆盖单元格数={}（母版：{}，备份母版：{}）", restored, template.getName(), donor.getName());
			}
			} else {
			log.warn("汇总工作簿未找到同期备份母版（_备份_{}年{}月…），输出将保持母版现状（可能为 1-4 月骨架）", year, month);
			}
			dynamicSummaryYear(wb, year);
			applyTwoDecimalFormat(wb);
			autoFitContentColumns(wb); // 汇总表导出后按内容加宽列宽（只加宽不缩窄）
			if (!wb.getCTWorkbook().isSetCalcPr()) wb.getCTWorkbook().addNewCalcPr();
			wb.getCTWorkbook().getCalcPr().setFullCalcOnLoad(true); // 还原/改写公式后打开即重算
			return toBytes(wb);
			}
			}
			@@ -3476,6 +3487,86 @@
			return map;
			}

			/** 定位同期备份母版（清理前的完整月母版），用于把骨架母版缺失的 5-7 月月度块按备份还原；
			* 与 resolveAnyTemplate 相同策略：在配置目录、user.dir 相对目录、上级目录三个候选根中扫描 */
			private File resolveSummaryDonor(int year, int month) {
			String rel = summaryTemplateDir;
			while (rel.startsWith("./")) rel = rel.substring(2);
			String[] roots = {
			summaryTemplateDir,
			System.getProperty("user.dir") + "/" + rel,
			System.getProperty("user.dir") + "/../" + rel
			};
			for (String root : roots) {
			if (root == null \|\| root.trim().isEmpty()) continue;
			File dir = new File(root);
			File[] files = dir.listFiles((d, name) ->
			name.startsWith("_备份_") && name.contains(year + "年" + month + "月") && name.contains("道路运输量汇总表"));
			if (files != null && files.length > 0) return files[0];
			}
			return null;
			}

			/** 按同期备份母版还原月度块：凡备份有内容而母版同格缺失/内容不同（清理时被裁掉的 5-7 月值与累计公式）的单元格，整格回填并覆盖 */
			private int restoreSummaryMonthlyBlocks(XSSFWorkbook wb, XSSFWorkbook donor) {
			int restored = 0;
			for (int i = 0; i < donor.getNumberOfSheets(); i++) {
			Sheet ds = donor.getSheetAt(i);
			if (ds == null) continue;
			Sheet bs = wb.getSheet(ds.getSheetName());
			if (bs == null) continue;
			for (int r = ds.getFirstRowNum(); r <= ds.getLastRowNum(); r++) {
			Row dr = ds.getRow(r);
			if (dr == null) continue;
			Row br = bs.getRow(r);
			for (Cell dc : dr) {
			if (dc == null) continue;
			CellType t = dc.getCellType();
			if (t == CellType.BLANK) continue;
			String dtx = summaryCellText(dc);
			if (dtx == null \|\| dtx.isEmpty()) continue;
			Cell bc = (br == null) ? null : br.getCell(dc.getColumnIndex());
			if (bc != null && dtx.equals(summaryCellText(bc))) continue;
			Row tr = (bc != null) ? br : bs.getRow(r);
			if (tr == null) tr = bs.createRow(r);
			Cell tc = (bc != null) ? bc : tr.getCell(dc.getColumnIndex());
			if (tc == null) tc = tr.createCell(dc.getColumnIndex());
			tc.setBlank();
			if (t == CellType.FORMULA) {
			String f = dc.getCellFormula();
			if (f != null) tc.setCellFormula(f);
			} else if (t == CellType.STRING) {
			tc.setCellValue(dc.getStringCellValue());
			} else if (t == CellType.NUMERIC) {
			tc.setCellValue(dc.getNumericCellValue());
			} else if (t == CellType.BOOLEAN) {
			tc.setCellValue(dc.getBooleanCellValue());
			}
			restored++;
			}
			}
			}
			return restored;
			}

			/** 单元格内容文本化（公式带 = 前缀），用于跨簿比对 */
			private String summaryCellText(Cell c) {
			if (c == null) return null;
			switch (c.getCellType()) {
			case FORMULA: {
			String f = c.getCellFormula();
			return f == null ? "" : "=" + f;
			}
			case STRING:
			return c.getStringCellValue();
			case NUMERIC:
			return Double.toString(c.getNumericCellValue());
			case BOOLEAN:
			return Boolean.toString(c.getBooleanCellValue());
			default:
			return "";
			}
			}
			/** 汇总工作簿年份动态化：仅把 2026年前缀替换为目标年（2025/2024 参考列不动） */
			private void dynamicSummaryYear(XSSFWorkbook wb, int year) {
			String oldPrefix = "2026年";