trafficAudit.git

			@@ -44,6 +44,7 @@
			import org.apache.poi.hssf.usermodel.HSSFSheet;
			import org.apache.poi.hssf.usermodel.HSSFWorkbook;
			import org.apache.poi.ss.util.CellRangeAddress;
			import org.apache.poi.openxml4j.util.ZipSecureFile;
			import org.openxmlformats.schemas.spreadsheetml.x2006.main.STCellType;
			import org.springframework.beans.factory.annotation.Value;
			import org.springframework.stereotype.Service;
			@@ -3213,6 +3214,8 @@
			if (template == null) {
			throw new RuntimeException("未找到汇总表母版《" + year + "年" + month + "月道路运输量汇总表.xlsx》（docs/生成汇总大表）");
			}
			double savedZipRatio = ZipSecureFile.getMinInflateRatio();
			ZipSecureFile.setMinInflateRatio(0.0001); // 新版母版 styles.xml 由 openpyxl 高压缩（0.0099<0.01）触发 POI Zip-bomb 误报，读取后还原
			try (InputStream in = new FileInputStream(template);
			XSSFWorkbook wb = new XSSFWorkbook(in)) {
			File donor = resolveSummaryDonor(year, month);
			@@ -3229,10 +3232,14 @@
			log.info("汇总工作簿裁剪至 {} 月完成，清空/改写单元格数={}", toMonth, trimmed);
			}
			dynamicSummaryYear(wb, year);
			applyTwoDecimalFormat(wb); // 汇总大表保留人工母版列宽/版式：不做 autoFit（长公式会把列宽顶爆）
			cleanSummarySheetPresentation(wb); // 取消各页筛选、还原隐藏行（否则“班线包车”等页看起来像缺数据）
			applyTwoDecimalFormat(wb); // 数值显示两位小数（保留全精度）；% / 日期等既有样式不改变
			autoFitContentColumns(wb); // 按数据自动加宽列宽（只加宽不缩窄，跳过合并标题格，防长文本把单列撑爆）
			if (!wb.getCTWorkbook().isSetCalcPr()) wb.getCTWorkbook().addNewCalcPr();
			wb.getCTWorkbook().getCalcPr().setFullCalcOnLoad(true); // 还原/改写公式后打开即重算
			return toBytes(wb);
			} finally {
			ZipSecureFile.setMinInflateRatio(savedZipRatio);
			}
			}

			@@ -3526,12 +3533,15 @@
			if (ds == null) continue;
			Sheet bs = wb.getSheet(ds.getSheetName());
			if (bs == null) continue;
			// 中口径排名页 A..H 陈旧左块已于 2026-09-09 拍板整块删除：该区域永不从备份母版回填，避免“生成又复活”
			boolean skipMidRankLeftBlock = "中口径排名".equals(ds.getSheetName());
			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;
			if (skipMidRankLeftBlock && dc.getColumnIndex() < 8) continue;
			CellType t = dc.getCellType();
			if (t == CellType.BLANK) continue;
			String dtx = summaryCellText(dc);
			@@ -3543,6 +3553,7 @@
			Cell tc = (bc != null) ? bc : tr.getCell(dc.getColumnIndex());
			if (tc == null) tc = tr.createCell(dc.getColumnIndex());
			tc.setBlank();
			applyDonorNumberFormat(wb, tc, dc);
			if (t == CellType.FORMULA) {
			String f = dc.getCellFormula();
			if (f != null) tc.setCellFormula(f);
			@@ -3560,6 +3571,24 @@
			return restored;
			}

			/** 还原回填时同步 donor（已做版式统一）的数字格式，保证同比/数值/排名格显示格式与母版一致 */
			private void applyDonorNumberFormat(XSSFWorkbook wb, Cell dst, Cell src) {
			if (wb == null \|\| dst == null \|\| src == null) return;
			try {
			String fmt = src.getCellStyle().getDataFormatString();
			if (fmt == null \|\| fmt.isEmpty() \|\| "General".equalsIgnoreCase(fmt)) return;
			org.apache.poi.ss.usermodel.DataFormat df = wb.createDataFormat();
			short idx = df.getFormat(fmt);
			CellStyle cur = dst.getCellStyle();
			if (cur != null && idx == cur.getDataFormat()) return;
			CellStyle ns = wb.createCellStyle();
			if (cur != null) ns.cloneStyleFrom(cur);
			ns.setDataFormat(idx);
			dst.setCellStyle(ns);
			} catch (Exception ignore) {
			// 个别格式异常不阻塞还原
			}
			}
			/** 单元格内容文本化（公式带 = 前缀），用于跨簿比对 */
			private String summaryCellText(Cell c) {
			if (c == null) return null;
			@@ -4773,6 +4802,26 @@
			}

			/** 汇总表导出后按内容自动加宽列宽（只加宽不缩窄；跳过合并单元格标题，防长标题把单列撑爆） */
			/** 汇总大表输出前清理母版残留下来的筛选与行隐藏：筛选箭头/隐藏行会让整页看起来“缺数据” */
			private void cleanSummarySheetPresentation(org.apache.poi.ss.usermodel.Workbook wb) {
			if (wb == null) return;
			for (int s = 0; s < wb.getNumberOfSheets(); s++) {
			org.apache.poi.ss.usermodel.Sheet sh = wb.getSheetAt(s);
			if (sh == null) continue;
			if (sh instanceof org.apache.poi.xssf.usermodel.XSSFSheet) {
			org.apache.poi.xssf.usermodel.XSSFSheet xs = (org.apache.poi.xssf.usermodel.XSSFSheet) sh;
			if (xs.getCTWorksheet().isSetAutoFilter()) xs.getCTWorksheet().unsetAutoFilter();
			for (org.apache.poi.ss.usermodel.Row row : xs) {
			if (row == null) continue;
			org.apache.poi.xssf.usermodel.XSSFRow xr = (org.apache.poi.xssf.usermodel.XSSFRow) row;
			if (xr.getCTRow().isSetHidden()) xr.getCTRow().unsetHidden();
			}
			} else {
			sh.setAutoFilter(null);
			}
			}
			}

			private void autoFitContentColumns(org.apache.poi.ss.usermodel.Workbook wb) {
			if (wb == null) return;
			org.apache.poi.ss.usermodel.DataFormatter dfmt = new org.apache.poi.ss.usermodel.DataFormatter();