| | |
|---|
| | | int dbFilled = summaryWorkbookFiller.fillMonthlyLedger(wb, effPeriod, year, effMonth, dbProblems); |
|---|
| | | int yoyFilled = summaryWorkbookFiller.ensureMonthYoyFormulas(wb, year, effMonth); |
|---|
| | | int monthFormulaFilled = summaryWorkbookFiller.ensureMonthFormulas(wb, year, effMonth); |
|---|
| | | // 累计同比分母修正：母版把「去年各月」与「去年1-M月累计」辅助列同时计入（重复计/漏当月） |
|---|
| | | int cumYoyFixed = summaryWorkbookFiller.repairCumulativeYoyFormulas(wb, year, effMonth); |
|---|
| | | int rankRefreshed = refreshSummaryRankSheets(wb, effPeriod, "month"); |
|---|
| | | int cumulativeRefreshed = refreshSummaryCumulativeSheets(wb, year, effMonth); // 四张跨页合成页随报表期刷新 |
|---|
| | | int widthApplied = applySummaryReferenceLayout(wb); |
|---|
| | | log.info("汇总工作簿数据驱动回填完成：写入当月值格数={}，补写当月同比公式格数={}，补写当月合计公式格数={}，" |
|---|
| | | + "刷新排名页数值格数={}，刷新四页（城市汇总/城市分市州/中口径分析/道路运输周转量）数值格数={}，" |
|---|
| | | + "修正累计同比分母格数={}，刷新排名页数值格数={}，刷新四页（城市汇总/城市分市州/中口径分析/道路运输周转量）数值格数={}，" |
|---|
| | | + "按《生成_道路运输量汇总表》对齐列宽列数={}，缺数提示={}", |
|---|
| | | dbFilled, yoyFilled, monthFormulaFilled, rankRefreshed, cumulativeRefreshed, widthApplied, dbProblems); |
|---|
| | | dbFilled, yoyFilled, monthFormulaFilled, cumYoyFixed, rankRefreshed, cumulativeRefreshed, widthApplied, dbProblems); |
|---|
| | | applyTwoDecimalFormat(wb); // 数值显示两位小数（保留全精度）；% / 日期等既有样式不改变 |
|---|
| | | int inlineFixed = normalizeStaleInlineStrings(wb); // 清掉「非 inlineStr 却残留 <is>」的非法格，否则 Excel 拒绝打开 |
|---|
| | | if (inlineFixed > 0) log.warn("汇总工作簿清掉残留 inlineStr 非法格 {} 个（母版由 openpyxl 写出时的典型问题）", inlineFixed); |
|---|
| | |
|---|
| | | hssfText(row, 0, "合计"); |
|---|
| | | InvestAgg prov = new InvestAgg(); |
|---|
| | | for (InvestmentMonthly m : monthlies) prov.add(m, pmap.get(m.getProjectId())); |
|---|
| | | addProjectsWithoutMonthly(prov, projects, mByProject, null, null); |
|---|
| | | writeInvestAggHssf(row, prov); |
|---|
| | | continue; |
|---|
| | | } |
|---|
| | |
|---|
| | | InvestmentProject p = pmap.get(m.getProjectId()); |
|---|
| | | if (p != null && blockCategory.equals(p.getCategory())) agg.add(m, p); |
|---|
| | | } |
|---|
| | | addProjectsWithoutMonthly(agg, projects, mByProject, blockCategory, null); |
|---|
| | | writeInvestAggHssf(row, agg); |
|---|
| | | seq = 0; |
|---|
| | | continue; |
|---|
| | |
|---|
| | | if (p != null && city.equals(p.getCity()) |
|---|
| | | && (blockCategory == null || blockCategory.equals(p.getCategory()))) agg.add(m, p); |
|---|
| | | } |
|---|
| | | addProjectsWithoutMonthly(agg, projects, mByProject, blockCategory, city); |
|---|
| | | writeInvestAggHssf(row, agg); |
|---|
| | | continue; |
|---|
| | | } |
|---|
| | |
|---|
| | | if (agg.yearPlan > 0) hssfNum(row, 23, agg.yearCum / agg.yearPlan); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 补计「本期没有月度记录、但项目主档有总投资」的项目（只计总投资这一列）。 |
|---|
| | | * 场景：某市州本月未报送单表（如武汉 8 月物流），主档里项目仍在，若不补计，该市州小计/合计会整块为空。 |
|---|
| | | * |
|---|
| | | * @param category 块类别（客运站场/物流园区）；null 表示不限 |
|---|
| | | * @param city 市州全称（如 武汉市）；null 表示不限 |
|---|
| | | */ |
|---|
| | | private void addProjectsWithoutMonthly(InvestAgg agg, List<InvestmentProject> projects, |
|---|
| | | Map<Long, InvestmentMonthly> mByProject, |
|---|
| | | String category, String city) { |
|---|
| | | for (InvestmentProject p : projects) { |
|---|
| | | if (p == null || mByProject.containsKey(p.getId())) continue; |
|---|
| | | if (category != null && !category.equals(p.getCategory())) continue; |
|---|
| | | if (city != null && !city.equals(p.getCity())) continue; |
|---|
| | | if (p.getTotalInvestment() != null) agg.total += p.getTotalInvestment(); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | // ==================== 投资模块：客运站投资明细表 / 物流站场投资明细（模板底稿原位替换） ==================== |
|---|
