From 4468db4c5566239e63c826066949752b552b7938 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期四, 08 十月 2026 17:21:31 +0800 Subject: [PATCH] docs(汇总大表): M0 规格补充——参照专项统计的设计映射与四阶段路线(含不照搬项与底线) --- docs/汇总大表M0版式重建器规格_2026-10-06.md | 40 +++++++++++++++++++++++++++++++++++++++- 1 files changed, 39 insertions(+), 1 deletions(-) diff --git "a/docs/\346\261\207\346\200\273\345\244\247\350\241\250M0\347\211\210\345\274\217\351\207\215\345\273\272\345\231\250\350\247\204\346\240\274_2026-10-06.md" "b/docs/\346\261\207\346\200\273\345\244\247\350\241\250M0\347\211\210\345\274\217\351\207\215\345\273\272\345\231\250\350\247\204\346\240\274_2026-10-06.md" index 6e4a14f..d01a127 100644 --- "a/docs/\346\261\207\346\200\273\345\244\247\350\241\250M0\347\211\210\345\274\217\351\207\215\345\273\272\345\231\250\350\247\204\346\240\274_2026-10-06.md" +++ "b/docs/\346\261\207\346\200\273\345\244\247\350\241\250M0\347\211\210\345\274\217\351\207\215\345\273\272\345\231\250\350\247\204\346\240\274_2026-10-06.md" @@ -103,4 +103,42 @@ 3. **姣嶇増鍘嗗彶鍧戣涓�骞惰鐩�**锛氭瘝鐗堢敱 openpyxl 鍐欏嚭锛屽瓨鍦ㄩ珮鍘嬬缉锛堝凡鐢� `ZipSecureFile.setMinInflateRatio` 缁曡繃锛変笌娈嬬暀 `<is>` 闈炴硶鏍硷紙`normalizeStaleInlineStrings` 娓呯悊锛変袱绫婚棶棰橈紝閫愬垪鍏嬮殕鏃堕渶淇濇寔杩欎袱澶勫鐞嗐�� 4. **鍩庡競瀹㈣繍椤靛弬鐓х粍鏄帇缂╃粨鏋�**锛堝悓姣� + 1-X 鏈堢疮璁★級锛屼笌鍏跺畠闀胯〃椤典笉鍚岋紝闇�鍗曠嫭瑙勫垯銆� 5. **璺ㄥ勾寮�鏂版湰锛�2027锛変笉鍦� M0 鑼冨洿**锛岄渶鍙﹀畾"鏂板勾鍧�"瑙勫垯銆� -6. **鏈鐩栭〉**锛氫腑鍙e緞鍒嗘瀽绛� 3 涓潤鎬侀〉浠嶆部鐢ㄦ瘝鐗堥潤鎬佸唴瀹癸紝鏈樁娈典笉鏀广�� \ No newline at end of file +6. **鏈鐩栭〉**锛氫腑鍙e緞鍒嗘瀽绛� 3 涓潤鎬侀〉浠嶆部鐢ㄦ瘝鐗堥潤鎬佸唴瀹癸紝鏈樁娈典笉鏀广�� +## 鍗佷竴銆佸弬鐓у悓浜嬨�屼笓椤圭粺璁°�嶇殑璁捐鏄犲皠涓庤惤鍦拌矾绾匡紙2026-10-08锛� + +### 11.1 瀵归綈琛細浠栦负浠�涔堣兘涓�涓瘝鐗堬紝鎴戜滑瀵瑰簲鎬庝箞鍋� + +| 鍚屼簨涓撻」缁熻鐨勫仛娉� | 浠栦负浠�涔堣兘鎴愮珛 | 姹囨�诲ぇ琛ㄧ殑瀵瑰簲鍋氭硶 | +|---|---|---| +| 涓�浠芥瘝鐗堬紙`2026骞村崄涓�鏁版嵁.xlsx`锛夛紝**澶╀负琛屻�佸勾涓哄垪** | 澧為暱缁村害鏄�屽勾銆嶏紝涓�骞村姞涓�缁勫垪锛涘ぉ鏁板浐瀹� 8 | 鍐荤粨銆婇亾璺繍杈撻噺姹囨�昏〃_鏍囧噯姣嶇増.xlsx銆嬶細**12 涓湀婊$増寮忎竴娆″埌浣�**锛屽彧璇� | +| 姣嶇増鍚屾椂鏄暟鎹鍣紙鍘嗗彶骞翠唤鐨勫�煎氨鍦ㄥ苟鎺掑勾鍒楅噷锛� | 鍘嗗彶鍊奸殢妯℃澘涓�璧疯蛋 | **鍙嶈繃鏉ュ仛**锛氬巻鍙插弬鐓у�煎叆搴擄紝姣嶇増鍙暀鐗堝紡锛屽弬鐓х粍鐢� DB 鍥炲~ | +| 琛ㄥご/琛屾爣绛捐涔夊畾浣嶏紙`findYearColumn` / `parseDayIndex`锛� | 鍒楀簭鍙樹簡涔熻兘瀵� | 鏂板椤佃鍒欒〃 `SummarySheetRule`锛氭寜琛ㄥご璁ゆ湀浠界粍銆佹寜琛屾爣绛捐甯傚窞/鎸囨爣锛屼笉鐢ㄧ‖缂栫爜鍒楅敋鐐� | +| 鏄撴紓绉诲彛寰勫缃垚琛紙`holiday_calendar` / `passenger_coefficient` / `vehicle_adjustment`锛� | 瑙勫垯涓嶆暎鍦ㄤ唬鐮佷笌鍗曞厓鏍奸噷 | 鍙傜収骞翠繚鐣欑粍鏁般�佹帓鍚嶅彛寰勶紙鍏ㄧ渷涓嶆帓鍚嶏級銆佸懆杞噺绯绘暟 B=G+L/2+Q/10銆佺己鏁扮疆绌鸿鍒� 澶栫疆 | +| `DECIMAL(30,15)` + `BigDecimal` + 鎸� Excel 鏄剧ず绮惧害鍙栧�� | 绮惧害鍙e緞缁熶竴锛屾棤娴偣灏惧樊 | 鎵挎帴闀挎湡寰呭姙銆�16 寮犺〃 228 涓� double 鍒楁敼 DECIMAL + BigDecimal銆� | +| 瀵煎叆涓ら樁娈电‘璁� + 鍏ㄧ▼鍙鏍稿 | 鍘嗗彶鏁版嵁涓嶈璇鐩� | 鐢熸垚鍓嶅厛鍑虹己鏁�/宸紓娓呭崟锛屼汉宸ョ‘璁ゅ悗鍐嶅嚭琛紙鐜版湁 B4 鍩烘暟浣撴琛ラ綈锛� | +| 杈撳嚭璧版ā鏉挎枃浠讹紙docx / PNG锛� | 鐗堝紡鏉ユ簮鍗曚竴 | 淇濈暀鐜版湁鍋氭硶锛堝揩鎶ユ敼 `word/document.xml`銆丣FreeChart 鍑� PNG锛� | + +### 11.2 钀藉湴璺嚎锛堝洓闃舵锛� + +- **闃舵 1锛�= M0锛�3.5鈥�5 澶╋級**锛氭爣鍑嗘瘝鐗堝喕缁� + 婊$増寮� + 璺ㄥ勾閲嶅缓 + 椤佃鍒欒〃銆� + 鏂板 `SummaryLayoutRebuilder` / `SummarySheetRule` / 鍗曟祴銆� + 鍑哄彛锛�7 鏈堝洖褰� diff=0锛�9 鏈堝鐓ф墜宸ョ増 diff=0锛�10 鏈堣捣鍙洿鎺ュ嚭琛ㄣ�� +- **闃舵 2锛�+1鈥�2 澶╋級**锛氭妸鐜版湁涓変唤鏂囦欢渚濊禆鍚堝苟涓轰竴浠姐�� + 鐜扮姸渚濊禆锛氭湀搴︽瘝鐗堬紙`resolveSummaryMother`锛�+ `_澶囦唤_` donor锛坄resolveSummaryDonor` / `restoreSummaryMonthlyBlocks`锛�+ 鐗堝紡鍙傜収浠讹紙`resolveSummaryLayoutRef`锛夈�� + 鐩爣锛氬彧鐣欍�婇亾璺繍杈撻噺姹囨�昏〃_鏍囧噯姣嶇増.xlsx銆嬶紝鍙傜収鍊间粠搴撳洖濉紝鍋滅敤 donor 涓庤繕鍘熸満鍒躲�� + 鍑哄彛锛歚docs/鐢熸垚姹囨�诲ぇ琛�/` 涓嬪彧鍓� 1 涓ā鏉挎枃浠� + 杈撳嚭鐩綍锛坄_bak_*` 绛夋湰鍦扮暀瀛樸�佷笉鍏ュ簱锛夈�� +- **闃舵 3锛堝彲閫夛紝+2鈥�3 澶╋級**锛氭瘝鐗堝唴鐢ㄥ懡鍚嶅尯鍩�/鍗犱綅绗︽爣娉ㄩ渶濉牸锛岀▼搴忔寜鍚嶅~鍐欙紱姣嶇増琚尓鍒�/鎻掕鏃舵槑纭姤閿欍�� +- **闃舵 4锛堝彲閫夛紝+5鈥�10 澶╋級**锛氭妸 10 涓暱琛ㄩ〉鐨勭増寮忓弬鏁板寲锛堝垪缁勮鍒� + 鍚堝苟鍖� + 鍒楀 + 鏁板瓧鏍煎紡 + 鎵撳嵃鍖猴級锛岀▼搴忎粠鐗堝紡瀹氫箟娓叉煋锛屾瘝鐗堟枃浠堕檷绾т负涓�娆℃�ф牱寮忔彁鍙栨簮锛� + 3 涓殣钘忓叕寮忛〉锛堜腑鍙e緞璁$畻杩囩▼ / 2025骞村煄甯傚杩愰噺 / 涓彛寰勫垎鏋愶級淇濈暀鏂囦欢褰㈡�併�� + +### 11.3 涓ゆ潯涓嶇収鎼� + +1. **涓嶆妸 Excel 褰撴暟鎹簮**锛氬悓浜嬮偅杈逛笟鍔℃瘡澶╁~鍚屼竴褰㈢姸鐨� Excel 鏂囦欢锛涙眹鎬诲ぇ琛ㄦ暟鎹繀椤昏蛋 DB 瀵煎叆 + 涓ら樁娈电‘璁わ紝涓嶈兘閫�鍥�"鎵嬪伐濉瘝鐗�"銆� +2. **蹇呴』鏈夈�屾柊骞寸粍銆嶉�昏緫**锛氫粬鐨勫ぉ鏁版槸甯告暟锛�8 澶╋級锛岃法骞村彧鏄姞涓�缁勫勾鍒楋紱鎴戜滑璺ㄥ勾瑕佹柊澧炰笅涓�骞村害鍒楃粍骞舵妸褰撳勾缁勯檷绾т负鍙傜収缁勶紝杩欎竴姝ヤ粬娌℃湁瀵瑰簲瀹炵幇銆� + +### 11.4 搴曠嚎涓庨闄� + +- 3 涓殣钘忓叕寮忛〉渚濊禆姣嶇増鐜版垚鍏紡锛岄樁娈� 1鈥�2 蹇呴』鍘熸牱淇濈暀锛岄樁娈� 4 鎵嶈皥閲嶅缓銆� +- 鎵撳嵃鍖恒�侀〉鐪夐〉鑴氥�佹潯浠舵牸寮忋�佸垪瀹藉繀椤婚�愰〉鏍稿锛屾槸"鑲夌溂鐗堝紡"鏈�鏄撴紡鐨勭偣銆� +- 涓氬姟鏀规寚鏍囪/椤电/杈规灞炰簬闇�姹傚彉鏇达紝浠讳綍鏂规閮借涓�娆¢�傞厤锛涙湰鏂规鎶婇鐜囦粠銆屾瘡鏈堜竴娆°�嶉檷鍒般�屽伓灏斾竴娆°�嶃�� +- 姣嶇増鏀逛负鍙锛屽彲椤哄甫瑙勯伩 WPS/openpyxl 閲嶅瓨甯︽潵鐨勯珮鍘嬬缉涓庢畫鐣� `<is>` 闈炴硶鏍间袱绫诲巻鍙插潙銆� \ No newline at end of file -- Gitblit v1.9.1