trafficAudit.git

			@@ -44,6 +44,8 @@
			private static final BigDecimal EPSILON = new BigDecimal("0.0000001");
			private static final int EXCEL_ONE_DECIMAL_PERCENT = 1;
			private static final int EXCEL_TWO_DECIMAL_PERCENT = 2;
			private static final int EXCEL_SEVEN_DECIMAL_YI = 7;
			private static final BigDecimal TEN_THOUSAND = new BigDecimal("10000");

			@Value("${holiday.bulletin-template:docs/专项统计/重要节假日/湖北省国庆假期综合运输客流快报模板.docx}")
			private String bulletinTemplatePath;
			@@ -63,7 +65,7 @@
			throw new IllegalArgumentException("所选日期不在已配置的节假日范围内");
			}
			DailyMetrics previousDay = current.getDayIndex() > 1
			? statService.dailyMetrics(current.getYear(), current.getHolidayType(), current.getDayIndex() - 1) : null;
			? statService.ringRatioBaseMetrics(current.getYear(), current.getHolidayType(), current.getDayIndex()) : null;
			HolidayCalendar previousDayConfig = configService.findPreviousDay(current.getYear(), current.getHolidayType());
			LocalDate previousDayDate = previousDayConfig == null \|\| previousDayConfig.getHolidayDate() == null
			? current.getDate().minusDays(1) : previousDayConfig.getHolidayDate();
			@@ -139,7 +141,7 @@
			EXCEL_ONE_DECIMAL_PERCENT),
			ratio(current.getNonBusinessPersonFlow(), twoYearsAgo == null ? null : twoYearsAgo.getNonBusinessPersonFlow(),
			EXCEL_ONE_DECIMAL_PERCENT),
			number(currentCumulative.getNonBusinessPersonFlow()),
			numberCumulative(currentCumulative.getNonBusinessPersonFlow()),
			ratio(currentCumulative.getNonBusinessPersonFlow(),
			previousYearCumulative == null ? null : previousYearCumulative.getNonBusinessPersonFlow(),
			EXCEL_TWO_DECIMAL_PERCENT),
			@@ -151,7 +153,7 @@
			number(current.getRoad()),
			ratio(current.getRoad(), previousDay == null ? null : previousDay.getRoad(), EXCEL_ONE_DECIMAL_PERCENT),
			ratio(current.getRoad(), previousYear == null ? null : previousYear.getRoad(), EXCEL_ONE_DECIMAL_PERCENT),
			ratio(current.getRoad(), twoYearsAgo == null ? null : twoYearsAgo.getRoad(), EXCEL_ONE_DECIMAL_PERCENT),
			ratio(current.getRoad(), twoYearsAgo == null ? null : twoYearsAgo.getRoad(), EXCEL_TWO_DECIMAL_PERCENT),
			number(currentCumulative.getRoad()),
			ratio(currentCumulative.getRoad(), previousYearCumulative == null ? null : previousYearCumulative.getRoad(),
			EXCEL_ONE_DECIMAL_PERCENT),
			@@ -166,7 +168,7 @@
			EXCEL_ONE_DECIMAL_PERCENT),
			ratio(current.getRoadPersonFlow(), twoYearsAgo == null ? null : twoYearsAgo.getRoadPersonFlow(),
			EXCEL_ONE_DECIMAL_PERCENT),
			number(currentCumulative.getRoadPersonFlow()),
			numberCumulative(currentCumulative.getRoadPersonFlow()),
			ratio(currentCumulative.getRoadPersonFlow(),
			previousYearCumulative == null ? null : previousYearCumulative.getRoadPersonFlow(),
			EXCEL_TWO_DECIMAL_PERCENT),
			@@ -206,7 +208,7 @@
			EXCEL_ONE_DECIMAL_PERCENT),
			ratio(current.getTotalPersonFlow(), twoYearsAgo == null ? null : twoYearsAgo.getTotalPersonFlow(),
			EXCEL_ONE_DECIMAL_PERCENT),
			number(currentCumulative.getTotalPersonFlow()),
			numberCumulative(currentCumulative.getTotalPersonFlow()),
			ratio(currentCumulative.getTotalPersonFlow(),
			previousYearCumulative == null ? null : previousYearCumulative.getTotalPersonFlow(),
			EXCEL_TWO_DECIMAL_PERCENT),
			@@ -376,7 +378,7 @@
			DailyMetrics twoYearsAgoCumulative) {
			BigDecimal total = currentCumulative == null ? null : currentCumulative.getTotalPersonFlow();
			return String.format("假期以来，全省全社会跨区域人员流动量累计%s万人次，比2025年同期%s，比2024年同期%s。",
			formatNumber(total),
			formatNumber(displayedCumulativeWan(total)),
			ratioPhrase(total, previousYearCumulative == null ? null : previousYearCumulative.getTotalPersonFlow(),
			EXCEL_TWO_DECIMAL_PERCENT),
			ratioPhrase(total, twoYearsAgoCumulative == null ? null : twoYearsAgoCumulative.getTotalPersonFlow(),
			@@ -407,6 +409,20 @@
			return value == null ? "—" : formatNumber(value);
			}

			private String numberCumulative(BigDecimal value) {
			return value == null ? "—" : formatNumber(displayedCumulativeWan(value));
			}

			/**
			* Source cumulative cells U5/X5/AA5 are stored in 100-million units and displayed with seven decimals.
			* Mirror that displayed precision before the bulletin converts the value to 10-thousand units.
			*/
			private BigDecimal displayedCumulativeWan(BigDecimal cumulativeWan) {
			if (cumulativeWan == null) return null;
			BigDecimal yi = cumulativeWan.divide(TEN_THOUSAND, EXCEL_SEVEN_DECIMAL_YI, RoundingMode.HALF_UP);
			return HolidayNumberUtils.normalize(yi.multiply(TEN_THOUSAND));
			}

			private String formatNumber(BigDecimal value) {
			if (value == null) return "";
			return HolidayNumberUtils.format2(value);