From 8690b9d77634c1789e410479f94e7111f67126c3 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 07 九月 2026 20:28:27 +0800 Subject: [PATCH] docs: 汇总大表数据驱动改造——业务拍板回执汇总与改造方案 v1（映射清单/12月满版列版式/里程碑M0-M4） --- docs/汇总大表数据驱动改造方案_2026-09-07.md | 93 ++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 93 insertions(+), 0 deletions(-) diff --git "a/docs/\346\261\207\346\200\273\345\244\247\350\241\250\346\225\260\346\215\256\351\251\261\345\212\250\346\224\271\351\200\240\346\226\271\346\241\210_2026-09-07.md" "b/docs/\346\261\207\346\200\273\345\244\247\350\241\250\346\225\260\346\215\256\351\251\261\345\212\250\346\224\271\351\200\240\346\226\271\346\241\210_2026-09-07.md" new file mode 100644 index 0000000..a8295ef --- /dev/null +++ "b/docs/\346\261\207\346\200\273\345\244\247\350\241\250\346\225\260\346\215\256\351\251\261\345\212\250\346\224\271\351\200\240\346\226\271\346\241\210_2026-09-07.md" @@ -0,0 +1,93 @@ +# 姹囨�诲ぇ琛ㄢ�滄暟鎹┍鍔ㄨ嚜鍔ㄥ～琛ㄢ�濇敼閫犳柟妗� v1锛�2026-09-07锛� + +鍓嶇疆鎷嶆澘锛氳 `docs/纭鍥炴墽姹囨�讳笌鍓╀綑鐤戦棶_姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫燺2026-09-07.md`锛圓1鈥揈3銆丵1鈥換3 宸插叏閮ㄧ‘璁わ級銆傛湰鏂规鎹缂栧啓銆� + +## 涓�銆佺洰鏍� +- 璁┿�婇亾璺繍杈撻噺姹囨�昏〃銆嬩粠鈥滃鍒舵瘝鐗�+澶囦唤杩樺師鈥濆彉涓猴細**鐢ㄦ埛鐐光�滅敓鎴愨�� 鈫� 绋嬪簭璇诲鍏ュ簱鏁版嵁 鈫� 鎸夌‘璁ゅ彛寰勮绠� 鈫� 濉叆姣嶇増鐗堝紡 鈫� 杈撳嚭褰撴湀/绱/鍚屾瘮/鎺掑悕/鍗犳瘮鍏ㄩ儴姝ｇ‘鐨勬暣鏈�**銆� +- 楠屾敹闂ㄦ锛圗1/E2锛夛細 + 1. 鍥炲綊锛歚鐢熸垚 2026-07 == 宸蹭慨姝ｆ瘝鐗坄锛堣濉尯鍩熼�愭牸 diff=0锛夛紱 + 2. 瀹炲脊锛歚鐢熸垚 2026-08`锛岄�愬競宸炲姞鎬�=鍏ㄧ渷銆佷笌婧愭湀鎶ラ�愰」瀵归綈銆佸悓姣斿尯闂村悎鐞嗐�� + +## 浜屻�佺幇鐘朵笌宸窛 +- 鐜扮姸锛歚exportSummaryWorkbook` = 澶嶅埗姣嶇増 鈫� `restoreSummaryMonthlyBlocks` 鐢ㄥ浠借繕鍘� 鈫� 骞翠唤鍔ㄦ�佸寲 鈫� 杈撳嚭銆傛湀搴﹀潡鍏ㄩ儴鏉ヨ嚜姣嶇増闈欐�佸唴瀹癸紝**涓嶈搴撱�佷笉璁＄畻**锛圓4 鍐冲畾鏀规帀锛夈�� +- 宸窛锛氶渶瑕佹柊澧炩�滆搴撹绠楀眰鈥濆苟鎶婄粨鏋滃啓鍒版瘝鐗堝搴旀牸锛涘浠借繕鍘熸満鍒朵繚鐣欏埌鍥炲綊閫氳繃鍚庡垹闄わ紙A3锛夈�� +- 鏈夊埄鏉′欢锛氳〃缁撴瀯/鏈熼棿宸叉牳瀹烇紙瑙佺浜旇妭锛夛紱鐜版湁 export 灏忚〃鐢熸垚鍣ㄥ凡瀹炵幇澶ч儴鍒嗗彇鏁颁笌鐗堝紡锛坋xportCityBusDetail / exportCityTaxiDetail / exportCityRailFerryDetail / exportCityPassengerSummary / exportPassengerMidDetail / exportFreightRank / exportTurnoverRank / exportWycSplit / exportPassengerCityDetail 绛夛級锛屽彲鎶藉彇澶嶇敤锛圖5 鍙ｅ緞涓�鑷达級銆� + +## 涓夈�佹�讳綋鏋舵瀯 +``` +鏁版嵁婧愶紙瀵煎叆琛紝report_period=YYYY-MM锛� + 鈹溾攢 city_bus_monthly锛圲203锛氬叕浜�+杞ㄩ亾+杞浮锛屽惈鍩庡競鍐�/鍩庨檯鍩庝埂锛� + 鈹溾攢 city_taxi_monthly锛堝贰娓稿嚭绉� 17 甯傚窞锛� + 鈹溾攢 wyc_order_monthly / wyc_total_monthly锛堢綉绾﹁溅璁㈠崟+鍏ㄧ渷pin锛� + 鈹溾攢 freight_turnover_import锛堣揣杩愰噺鍛ㄨ浆閲忔湀鎶ワ細鍚幓骞村悓鏈堝垪锛� + 鈹溾攢 scale_split_transport锛堣涓婅涓嬫媶鍒嗘湀鎶ワ級 + 鈹溾攢 h2031_enterprise_monthly锛堝叕璺梾瀹紒涓� H203-1锛� + 鈹斺攢 passenger_individual_monthly锛堜釜浣撳杩愶級 + 鈫� 鑱氬悎/璁＄畻鏈嶅姟锛堟娊鍙栬嚜鐜版湁 export 閫昏緫锛屼緵澶ц〃涓庡皬琛ㄥ叡鐢級 + [PaxCalc] 鍏氦/鍑虹/缃戠害/杞ㄩ亾/杞浮 鍚勫彛寰�(鎬�/鍩庡競鍐�/鍩庨檯鍩庝埂) 脳 甯傚窞 脳 鏈� + [FreightCalc] 瑙勪笂/瑙勪笅/鍚堣 璐ц繍閲忎笌鍛ㄨ浆閲� 脳 甯傚窞 脳 鏈� + [MidCalc] 涓彛寰勯摼璺細鏄庣粏鈫掑杩愰噺椤碘啋鎺掑悕/鍒嗘瀽锛圔3/B6/C5锛� + 鈫� SummaryFiller锛堟寜椤电/琛屽垪鏄犲皠鍐欏洖姣嶇増鐗堝紡锛� + 閬撹矾杩愯緭閲忔眹鎬昏〃_YYYY-MM.xlsx +``` +- 鎶藉彇鐨� `XxxCalc` 璁＄畻鏈嶅姟杩斿洖鈥滄寚鏍嚸楀競宸灻楁湡闂疵楀綋鏈�/绱鈥濈煩闃碉紱鐙珛灏忚〃涓庢眹鎬诲ぇ琛�**鍏辩敤鍚屼竴濂楃煩闃�**锛堟秷闄や袱濂楀彛寰勪笉涓�鑷达紝鍥炲簲鈥滃悓浜嬭〃涓庣郴缁熻〃瀵逛笉涓娾�濓級銆� + +## 鍥涖�侀〉绛炬槧灏勬竻鍗曪紙瀹炵幇鍩哄噯锛�7 鏈堟暟鍊煎洖绠楀璐﹀悗鍐嶅畾绋跨粏鑺傦級 +閫氱敤鍒椾綅锛堝彴璐︾被椤碉級锛�2026 褰撴湀鍊� m 鈫� 鍒� `2m+1`銆佸綋鏈堝悓姣� 鈫� `2m+2`銆�2026 绱 Q/R锛�2025 鍙傜収缁勪粠 2025-01 璧凤紙鏁村勾 12 鏈堝�间笌鍚屾瘮 + 绱锛夈��**鍩庡競瀹㈣繍椤靛弬鐓х粍涓哄帇缂╃粨鏋勶紙鍚屾瘮+1-X鏈堢疮璁★級锛屽崟鐙畾涔夈��** + +| 椤电 | 鏁版嵁鍧�/琛� | 鏉ユ簮锛圖B 鑱氬悎/璁＄畻锛� | 鍏抽敭鍙ｅ緞锛堟媿鏉跨紪鍙凤級 | +|---|---|---|---| +| ` 璐ц繍` | R7 瑙勪笂 / R9 瑙勪笅 / R5 鍚堣锛汻8/R10/R6 鍛ㄨ浆锛涘煄甯傚潡 R11-16锛�2026 褰撴湀鍒� + 绱 | scale_split_transport锛坅bove_scale_freight/turnover銆乥elow_scale_*銆乼otal_*锛夛紱freight_turnover_import锛堝悎璁�=freight_mXX/turnover_mXX锛屽幓骞�=last_*_mXX锛� | B1锛氬悎璁�=涓よ〃涓�鑷达紱瑙勪笅=鍚堣鈭掕涓婏紱2025 鍙婁互鍓嶄繚鐣欐瘝鐗� | +| `鍏氦` | 姣忓競宸� 4 琛岋細瀹㈣繍閲�/鍛ㄨ浆閲�/鍩庡競鍐呭杩�/鍩庡競鍐呭懆杞� | city_bus_monthly 鎸� region_code 姹囨�诲叕鍏辨苯鐢佃溅瀛楁 | 鍩庡競鍐�=passenger_city/turnover_city | +| `杞ㄩ亾銆佽疆娓 | 杞ㄩ亾锛氭姹�/榛勭煶 瀹㈣繍+鍛ㄨ浆锛涜疆娓★細姝︽眽 | city_bus_monthly 鎸� region 姹囨�� rail_*/ferry_* | B4锛氳建閬撹疆娓″湪 U203 鍚屼竴琛� | +| `鍑虹` | 宸℃父鍑虹 17 甯傚窞 瀹㈣繍/鍛ㄨ浆/鍩庡競鍐� | city_taxi_monthly 鎸� region 姹囨�� | B5锛氬嚭绉�=宸℃父鍑虹鏈堟姤 | +| `缃戠害杞 | 鍏ㄧ渷 + 17 甯傚窞 瀹㈣繍/鍛ㄨ浆 | exportWycSplit 缁撴灉锛坵yc_order_monthly + wyc_total_monthly + 宸℃父鎷嗗垎锛� | B5锛氳鍗�+pin+宸℃父鎷嗗垎 | +| `鐝嚎鍖呰溅` | 鍏ㄧ渷/鍩庡競瀹㈣繍琛� | h2031_enterprise_monthly + passenger_individual_monthly | B2锛氫互 `docs/鍏矾鏃呭/` 妯℃澘涓庣畝鍖栬鏄庢槧灏勶紙Q3锛� | +| `鍏矾鎬诲杩恅 | 姹囨�昏 | 鐝嚎/涓綋鑱氬悎 | B2/B6 | +| `涓彛寰勬槑缁�/涓彛寰勫杩愰噺` | 4 绫荤粍浠睹楀競宸� | PaxCalc 鍩庨檯鍩庝埂 + 鐝嚎锛氱彮绾垮寘杞︺�佸煄闄呭煄涔″叕浜ゃ�佸煄闄呭煄涔″嚭绉熴�佸煄闄呭煄涔＄綉绾� | B3 鍏紡閲嶇畻锛汢6 鍩庡競闂村畾涔� | +| `涓彛寰勬帓鍚�/涓彛寰勫垎鏋恅 | 褰撴湀/绱鍧� | **鍙彇鈥滀腑鍙ｅ緞瀹㈣繍閲忊�濋〉**鐢熸垚锛圕5锛� | C1 鍏ㄧ渷涓嶆帓鍚嶏紱C4 鎸夊垪鍒嗘瘝 | +| `鍩庡競姹囨�籤 | 鎬�/鍏氦/鍑虹杞�(宸℃父+缃戠害)/宸℃父/缃戠害/杞ㄩ亾/杞浮 | PaxCalc 鍩庡競鍐呭悎璁� | C7锛氭�昏=鍏氦+鍑虹杞�+杞ㄩ亾+杞浮锛岃建閬撹疆娓″叏绠楀煄甯傚唴 | +| `鍩庡競鍒嗗競宸瀈 | 瀹㈣繍褰撴湀/绱鍧椼�佸懆杞綋鏈�/绱鍧楋紙B/G/L/Q/V/X + 鎺掑悕/鍗犳瘮/澧為�燂級 | PaxCalc 鍩庡競鍐呭垎甯傚窞 + RANK/鍗犳瘮 | C1-C4 | +| `閬撹矾杩愯緭鍛ㄨ浆閲廯 | 褰撴湀/绱鍧� G/L/Q + B | FreightCalc 鍛ㄨ浆銆佸煄甯傚唴瀹㈣繍銆佷腑鍙ｅ緞瀹㈣繍鍛ㄨ浆 | C6锛欱=G+L/2+Q/10 绯绘暟鏆傚浐瀹� | +| 闅愯棌椤碉紙2025 鍩庡競瀹㈣繍閲�/涓彛寰勮绠楄繃绋�/鍏矾鎬诲杩愶級 | 淇濈暀姣嶇増鐗堝紡 | 浠呬綔涓棿鍙傝�冿紝瑙嗛渶瑕佺敱 Calc 鍥炲～ | 涓嶄笌鍔ㄦ�佸～琛ㄥ啿绐� | + +## 浜斻�佹暟鎹幇鐘讹紙宸插疄娴嬪簱锛� +- 宸插叆搴撴湡闂达細city_bus/city_taxi/freight_turnover/scale_split/h2031 涓綋/wyc 鍧� **2026-01 ~ 2026-07**锛沨2031_enterprise_monthly 鍙︽湁 **2026-08锛�767 琛岋級**銆� +- 绮掑害锛歝ity_bus 浼佷笟绾�(142 琛�/鏈�)锛沜ity_taxi 17 甯傚窞/鏈燂紱freight_turnover_import 18 琛�/鏈燂紙鍏ㄧ渷+17锛夛紱scale_split 36 琛�/鏈燂紙18脳鏈堥〉锛夛紱h2031 浼佷笟绾�(~780)锛涗釜浣� 7 琛�/鏈燂紱wyc 鍏ㄧ渷 1 琛�/鏈燂紙order 鍚垎甯傚窞璁㈠崟鍒楋級銆� +- 2025 鍙傜収锛氭瘝鐗堝悇椤靛煄甯傝 2025-01~12 鏁板�奸綈鍏紙鍏ㄧ渷琛屼负姹傚拰鍏紡锛岀▼搴忓嬁渚濊禆鏃犵紦瀛樺叕寮忓�硷紝闇�鑷鎸夊煄甯傝姹傚拰鎴栬姣嶇増缂撳瓨鍒楋級銆� + +## 鍏�侀�愭湀鎵╁垪绛栫暐锛圖1/D2/D3 钀藉湴寤鸿锛� +鐜扮姸 7 鏈堟瘝鐗堝垪缁撴瀯锛�2026 缁勫綋鏈堝�� m鈫掑垪 2m+1/2m+2锛岀疮璁″湪 17/18锛�**2025 鍙傜収缁勪粠绗� 20 鍒楄捣**锛涙瘡鎵╀竴涓湀闇�鎶� 2025+ 鍙傜収缁勬暣浣撳彸绉� 2 鍒楋紙POI 鍒楁彃鍏�=澶嶆潅鎿嶄綔锛夈�� +**寤鸿锛圡0 涓�娆℃�цВ鍐筹級**锛氭妸褰撳墠姣嶇増鐨� 2026 缁勭洿鎺ユ墿鍒� **12 鏈堟弧鐗堝紡**锛�2025 鍙傜収缁勫彸绉昏嚦鍏ㄥ勾 12 鏈堢増缁堜綅锛夛紝鍚庣画姣忔湀鐢熸垚**涓嶅啀鎻掑叆鍒�**锛屽彧鍋氫笁浠朵簨锛� +1. 闅愯棌/缃伆 M+1..12 鐨勫綋鏈堝��+鍚屾瘮鍒楋紙鎴栫暀绌猴紝鏈埌鏈堜唤涓嶅～锛夛紱 +2. 绱鍒楁寜 1..M 閲嶇畻锛堝叕寮�/鍊硷級锛� +3. 濉� M 褰撴湀鍊煎苟绠楀悓姣旓紙鍒嗘瘝鍙� 2025-M 鍙傜収锛孮1锛氭瘝鐗堢紦瀛樹紭鍏堛�佸簱鏍￠獙鎻愮ず锛夈�� +- 涓� D3 濂戝悎锛�2027 骞存柊寮�涓�鏈椂锛�2026 缁勬暣浣撹浆涓衡�滀笂涓�骞村弬鐓х粍鈥濓紙鍥哄畾 12 鏈堢増寮忥級锛�2027 缁勬柊澧炲埌 12 鏈堟弧鐗堛�� +- 12 鏈堟弧鐗堟瘝鐗堢敱涓�娆¤剼鏈敓鎴愬苟璇蜂笟鍔℃牳瀵圭増寮忓悗浣滀负鏂版瘝鐗堬紙鏇夸唬鐜� 7 鏈堟瘝鐗堬級銆�7 鏈堝洖褰掍粛浠モ�滃凡淇 7 鏈堟瘝鐗堚�濇暟鍊间负鍩哄噯锛屼笉鍥犵増寮忓彉鍖栨敼鍙樻暟鍊笺�� + +## 涓冦�侀噷绋嬬涓庨獙璇侊紙姣忔鎸� AGENTS 鍑烘祴璇曟姤鍛婏級 +| 閲岀▼纰� | 鍐呭 | 楠岃瘉/鍑哄彛 | +|---|---|---| +| M0 | 12 鏈堟弧鐗堟瘝鐗� + 鍒楃増寮忕敓鎴愬櫒锛圥OI 瀹炵幇鈥滃弬鐓х粍瀹氱増寮忊�濋噸寤烘垨涓�娆℃�у垪鎵╁睍鑴氭湰锛� | 7 鏈堟瘝鐗堟暟鍊煎湪鏂扮増寮忎笂涓嶅彉锛堟暟鍊� diff=0锛屼粎鍒椾綅鍙樺寲锛夛紝涓氬姟纭鐗堝紡 | +| M1 | 鎶藉彇 PaxCalc/FreightCalc/MidCalc + 鍗曟祴 | 7 鏈堝悇椤电▼搴忚绠楀�� vs 宸蹭慨姝ｆ瘝鐗堝搴旀牸 diff=0锛涢�愰」瀵硅处锛堝 鍏氦姝︽眽 鍩庡競鍐� 2026-07=4198.33銆佽建閬撳叏鐪�=11731.83銆佽涓�=3754.7823鈥︼級 | +| M2 | SummaryFiller v1锛氭寜鏄犲皠鍐欏洖 鍙拌处+鎴愬搧椤� 2026 褰撴湀/绱/鍚屾瘮/鎺掑悕/鍗犳瘮 | `鐢熸垚 2026-07` 涓庡凡淇姣嶇増閫愭牸 diff=0锛圗1锛� | +| M3 | 8 鏈堝疄寮癸細瀵奸綈 8 鏈堟暟鎹� 鈫� `鐢熸垚 2026-08` | E2锛氶�愬競宸炲姞鎬�=鍏ㄧ渷銆佹簮鏈堟姤閫愰」瀵归綈銆佺己鏁版竻鍗曠敓鏁� | +| M4 | 鍓嶇鈥滅偣鐢熸垚鈥濆叆鍙�/鎻愮ず銆佸垹闄ゅ浠借繕鍘熸満鍒讹紙A3锛夈�佺嫭绔嬪皬琛ㄤ笅绾匡紙D5 鍐呴儴涓棿琛ㄤ繚鐣欙級 | 鍥炲綊 7/8 鏈堜笉鍥炲綊锛涘皬琛ㄥ叆鍙ｉ殣钘忥紝涓棿琛ㄤ粎鍐呴儴 | + +## 鍏�佹敼鍔ㄦ枃浠堕浼� +- 鍚庣鏂板锛歚calc/`锛圥axCalc銆丗reightCalc銆丮idCalc銆乄yCSplitCalc锛夈�乣summary/SummaryFiller`銆乣SummaryLayout`锛堥〉绛�/琛屽垪/鍒楃増寮忓畾涔夛級銆佹瘝鐗堝垪鎵╁睍鑴氭湰锛堟垨鐗堝紡鐢熸垚鍣級銆� +- 鍚庣鏀归�狅細`ReportExportService.exportSummaryWorkbook` 鐢扁�滃鍒�+杩樺師鈥濇敼涓衡�滃鍒� 鈫� Calc 鍙栨暟 鈫� Filler 鍐欏�� 鈫� 杈撳嚭鈥濓紱鍒犻櫎/鍐荤粨 `restoreSummaryMonthlyBlocks`锛圡4锛夈�� +- 鍓嶇锛氭姤琛ㄧ敓鎴愮晫闈⑩�滄眹鎬诲ぇ琛ㄢ�濇寜閽蛋鏂伴�昏緫锛汳4 澶勭悊灏忚〃鍏ュ彛銆� +- 鏂囨。锛氭瘝鐗堬紙12 鏈堟弧鐗堬級銆佹槧灏勫畾绋胯〃銆佹祴璇曟姤鍛娿�佸伐浣滄棩缁撱�� + +## 涔濄�佷笉鍋�/寰呭閮ㄦ竻鍗� +- 2025 瀹氱鏁版嵁鈥滃墠鍙板鍏ユ牎楠屸�濇湰韬彟绔嬩换鍔★紙Q1 鍙厛鍋氭彁绀轰綅锛夛紱鏈湡鍚屾瘮涓�寰嬩互姣嶇増缂撳瓨涓哄熀鍑嗐�� +- 杞ㄨ抗娴嬬畻/瀹℃牳绫诲垎鏋愭暟鎹笉杩涘ぇ琛紙E3锛夈�� +- 鎶曡祫銆佽兘鑰椼�佸勾鎶ョ瓑椤电涓嶅湪鏈湡鑷姩濉〃鑼冨洿锛堜繚鐣欐瘝鐗堢幇鐘讹級銆� +- 鐙珛灏忚〃瀵瑰浜や粯涓嬬嚎锛圡4锛夛紝鍐呴儴涓棿琛ㄤ繚鐣欎笉灞曠ず銆� + +## 鍗併�侀闄� +1. 鍙拌处鍒楃Щ鍔�/12 鏈堟弧鐗堝紡鏀瑰姩闈㈠ぇ锛堝悎骞跺崟鍏冩牸銆佸叕寮忓紩鐢ㄣ�佹墦鍗板尯锛夆啋 M0 鍏堝嚭鈥滅増寮忓姣斾骇鐗┾�濊涓氬姟纭鍐嶅線涓嬨�� +2. U203 鐨勫煄闄呭煄涔�(chengxiang)瀛楁涓庝腑鍙ｅ緞鏄庣粏缁勪欢鍏紡鐨勫搴旈渶閫愭牸瀵硅处锛�7 鏈堝洖绠楋級锛屽彲鑳芥湁鍙ｅ緞宸�� +3. 缃戠害鎷嗗垎鍘嗗彶鍙ｅ緞锛圔5锛夐渶浠� 7 鏈堝凡鎷嗗垎缁撴灉閿佸畾杈撳叆杈撳嚭锛岄伩鍏嶅崌绾у悗鏁板�兼紓绉汇�� +4. 鍩庡競瀹㈣繍椤靛弬鐓х粍涓哄帇缂╃粨鏋勶紝涓庡叾瀹冨彴璐﹂〉涓嶅悓锛屽崟鐙疄鐜帮紝7 鏈堝璐﹁鐩栥�� -- Gitblit v1.9.1