From 9a6ec0530076fff4fa7fd2a6b4c36ed729b23120 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期五, 09 十月 2026 08:53:52 +0800 Subject: [PATCH] docs(汇总大表): M0 规格补第十二节（存储/展示分层与红线）+ 2025 数据现状核验（已在库，遗留口径差异） --- HANDOFF.md | 11 +++++ docs/汇总大表M0版式重建器规格_2026-10-06.md | 62 ++++++++++++++++++++++++++++++ 2 files changed, 72 insertions(+), 1 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index 8061552..1931110 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -4,6 +4,17 @@ > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄�� > **鍗忎綔绾﹀畾锛�2026-08-31锛�**锛氳銆屾彁浜ゃ��= 鏈湴 commit + 鎺ㄩ�佸埌杩滅 git锛坥rigin main锛孏itblit锛夛紝涓嶅啀鍙仛鏈湴 commit銆� +## 鏈�鏂帮紙2026-10-09锛寊yj 绾匡級 + +### 10-09锛�2025 鏁版嵁鐜扮姸鏍搁獙锛堢粨璁猴細宸插湪搴擄紝鏃犻渶琛ュ綍锛�+ M0 瑙勬牸琛ョ鍗佷簩鑺� + +- **鏍搁獙鏂瑰紡**锛氬彧璇绘煡璇㈠簱 `127.0.0.1:3308/traffic_audit`锛圡ySQL 8.0.29锛夛紝鏈鍏ャ�佹湭淇敼浠讳綍鏁版嵁銆� +- **2025-01~12 鍚� 12 涓湀榻愬叏**锛歚city_bus_monthly`銆乣city_taxi_monthly`銆乣wyc_order_monthly`銆乣wyc_total_monthly`銆乣h2031_enterprise_monthly`銆乣h2032_enterprise_monthly`銆乣passenger_individual_monthly`銆� +- **涓ゅ紶"涓嶄互涓虹己鍙�"鐨勮〃**锛歚freight_turnover_import` 浠� 2025-12锛屼絾琛ㄥ甫 `last_freight_m01..m12` / `last_turnover_m01..m12`锛�2026 鍚勬湡鏂囦欢鑷甫鍘诲勾鍚屾湀鍊硷紱`scale_split_transport` 鏃� 2025锛屼絾琛ㄥ甫 `above/below/total_yoy`锛屽悓姣斿凡闅� 2026 鍚勬湡鍏ュ簱銆� +- **淇鏃╁墠鍒ゆ柇**锛�09-07 鏂规鏂囨。"2025 鏈叆搴�"鐨勮娉曞凡杩囨湡锛�09-16 鍚庤ˉ褰曡繃澶氬勾搴︽暟鎹級锛沗ReportExportService.java:499 / 558 / 561` 涓夊"寰� 2025 骞村畾绋挎暟鎹鍏ュ悗鑷姩鍑虹幇"鐨勬彁绀烘潯浠跺凡涓嶆垚绔嬨�傚悓姣斿彇鏁拌蛋搴撳唴鍘诲勾鍚屾湡锛坄aggOf(data, year-1, m, "婀栧寳鐪�")`锛岀害 540 琛岋級銆� +- **閬楃暀鐨勬槸鍙ｅ緞闂锛屼笉鏄己鏁版嵁**锛氫腑鍙ｅ緞鎺掑悕/鏄庣粏鐨� 2025 鍒椾粛浠ユ瘝鐗堥潤鎬佸畾绋垮�间负鍑嗭紙`readMidDetailLastYearCumulative`锛宍ReportExportService.java:2745` 璧凤級锛屾敞閲婏紙2686-2689 琛岋級璇存槑鍘熷洜鏄�"鎺掑悕椤靛師鍏堟煡搴撶幇绠楋紝涓よ�呭湪 2025-03/04 缃戠害杞︽媶鍒嗕笂涓嶅悓"銆傗啋 闇�鍏堝仛銆屽簱鍐� 2025 vs 姣嶇増 2025銆嶉�愰」 diff锛屼氦涓氬姟纭鍩哄噯鍚庡啀鍐冲畾鏄惁鍒囨崲璇诲簱锛堝垏鎹㈠繀椤昏繃 diff=0 鍥炲綊锛夈�� +- **瑙勬牸鏇存柊**锛歚docs/姹囨�诲ぇ琛∕0鐗堝紡閲嶅缓鍣ㄨ鏍糭2026-10-06.md` 鏂板绗崄浜岃妭锛堜笁灞傝亴璐� / 涓�琛ㄤ竴绮掑害 / 璋冩暣鍊艰鐩栧眰 / 2025 瀹炴祴鏍搁獙 / 缁撴灉灞傚彲閫� / 銆屾瘝鐗堜笉鐣欐暟鎹�嶇孩绾� / 涓� M0 鐨勪緷璧栭『搴忥級銆� +- **鐘舵��**锛氭湰鑺備笌瑙勬牸绗崄浜岃妭鍧囦负銆愬緟楠屾敹銆戯紱鏈敼鍔ㄤ唬鐮併�佹湭瀵煎叆鏁版嵁銆� ## 鏈�鏂帮紙2026-10-06锛寊yj 绾匡級 ### 10-06锛氭媺鍙栧悎骞� + 楠屾敹闂ㄧ鍒嗙骇 + 姹囨�诲ぇ琛� M0 绔嬮」 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 d01a127..b5ed494 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" @@ -141,4 +141,64 @@ - 3 涓殣钘忓叕寮忛〉渚濊禆姣嶇増鐜版垚鍏紡锛岄樁娈� 1鈥�2 蹇呴』鍘熸牱淇濈暀锛岄樁娈� 4 鎵嶈皥閲嶅缓銆� - 鎵撳嵃鍖恒�侀〉鐪夐〉鑴氥�佹潯浠舵牸寮忋�佸垪瀹藉繀椤婚�愰〉鏍稿锛屾槸"鑲夌溂鐗堝紡"鏈�鏄撴紡鐨勭偣銆� - 涓氬姟鏀规寚鏍囪/椤电/杈规灞炰簬闇�姹傚彉鏇达紝浠讳綍鏂规閮借涓�娆￠�傞厤锛涙湰鏂规鎶婇鐜囦粠銆屾瘡鏈堜竴娆°�嶉檷鍒般�屽伓灏斾竴娆°�嶃�� -- 姣嶇増鏀逛负鍙锛屽彲椤哄甫瑙勯伩 WPS/openpyxl 閲嶅瓨甯︽潵鐨勯珮鍘嬬缉涓庢畫鐣� `<is>` 闈炴硶鏍间袱绫诲巻鍙插潙銆� \ No newline at end of file +- 姣嶇増鏀逛负鍙锛屽彲椤哄甫瑙勯伩 WPS/openpyxl 閲嶅瓨甯︽潵鐨勯珮鍘嬬缉涓庢畫鐣� `<is>` 闈炴硶鏍间袱绫诲巻鍙插潙銆� +## 鍗佷簩銆佸瓨鍌ㄥ眰/灞曠ず灞傜害瀹氾細鍙傜収鍚屼簨銆屼簩缁磋〃銆嶆ā寮忥紙2026-10-09锛� + +### 12.1 涓夊眰鑱岃矗 + +- **瀛樺偍灞傦紙DB锛�**锛氫竴寮犲紶浜岀淮琛紝閿笌鍊兼槑纭紱瀛樹笁绫诲唴瀹光�斺�斿師濮嬪�笺�侀厤缃�笺�佷汉宸ヨ皟鏁村�笺�� +- **璁＄畻灞�**锛氬鍑烘椂鎸夊彛寰勮绠楋紙绱銆佸悓姣斻�佺幆姣斻�佸崰姣斻�佹帓鍚嶏級銆� +- **灞曠ず灞傦紙Excel锛�**锛氬彧鎶婂�煎拰鍏紡鎸夌増寮忔憜鍑烘潵锛屼笉鎵挎媴瀛樺偍鑱岃矗銆� + +### 12.2 銆屼竴琛ㄤ竴绮掑害銆嶇害瀹氾紙绀轰緥鍙栬嚜鍚屼簨鐨勪笓椤圭粺璁★級 + +| 琛� | 涓婚敭锛堢矑搴︼級 | 鍊� | 绫诲埆 | +|---|---|---|---| +| holiday_passenger_flow | 骞� + 鏃ユ湡 + 杩愯緭鏂瑰紡 | 瀹㈣繍閲� | 鍘熷鍊� | +| holiday_vehicle_flow | 骞� + 鏃ユ湡 + 閬撹矾绫诲埆 + 杞﹀瀷 | 杞︽祦閲忋�佺幆姣斿熀鏈� | 鍘熷鍊� | +| holiday_calendar | 骞� + 鑺傚亣鏃ョ被鍨� + 绗嚑鏃� | 鏃ユ湡 | 閰嶇疆鍊� | +| holiday_passenger_coefficient | 骞� + 鏃ユ湡绫诲埆 | 瀹㈣繍绯绘暟 | 閰嶇疆鍊� | +| holiday_vehicle_adjustment | 骞� + 鏃ユ湡 | 璋冩暣鍚庡�� + 鍘熷洜 | 浜哄伐璋冩暣鍊� | + +鎴戜滑鐜版湁瀵煎叆琛ㄥ悓鏍锋弧瓒宠绾﹀畾锛歚city_bus_monthly`锛堟姤琛ㄦ湡 + 鍦板尯 + 浼佷笟锛夈�乣city_taxi_monthly`锛堟姤琛ㄦ湡 + 鍦板尯锛夈�乣freight_turnover_import`锛堟姤琛ㄦ湡 + 鍦板尯锛夈�乣scale_split_transport`锛堟姤琛ㄦ湡 + 鍦板尯 + 鏈�/绱锛夈�乣h2031_enterprise_monthly`锛堟姤琛ㄦ湡 + 浼佷笟锛夈�乣h2032_enterprise_monthly`銆乣wyc_order_monthly` / `wyc_total_monthly`銆乣passenger_individual_monthly`銆傚瓨鍌ㄥ眰褰㈡�佹槸瀵圭殑銆� + +### 12.3 浜哄伐璋冩暣鍊间竴寰嬪崟鐙缓琛紙瑕嗙洊灞傦級 + +- 妯″紡锛�**鍘熷璁板綍涓嶅姩**锛屽彟琛ㄥ瓨銆岃鐩栧�� + 鍘熷洜 + 鏃堕棿銆嶏紝鍞竴閿笌鎵�瑕嗙洊瀵硅薄涓�鑷达紙鍙傜収鍚屼簨鐨� `holiday_vehicle_adjustment`锛夈�� +- 鎴戜滑鐨勯�傜敤瀵硅薄锛�2025 鍙傜収鍊间慨姝ｃ�佸紓甯哥珯鍓旈櫎銆佷笟鍔′复鏃舵敼鏁扮瓑銆� + +### 12.4 鐜扮姸鏍搁獙锛�2026-10-09 瀹炴祴锛屼慨姝ｆ棭鏈熷垽鏂級 + +瀹炴祴搴� `127.0.0.1:3308 / traffic_audit`锛圡ySQL 8.0.29锛夛細 + +| 琛� | 2025 鏈堜唤鏁� | 缁撹 | +|---|---|---| +| city_bus_monthly | 12/12 | 榻愬叏 | +| city_taxi_monthly | 12/12 | 榻愬叏 | +| wyc_order_monthly / wyc_total_monthly | 12/12 | 榻愬叏 | +| h2031_enterprise_monthly / h2032_enterprise_monthly | 12/12 | 榻愬叏 | +| passenger_individual_monthly | 12/12 | 榻愬叏 | +| freight_turnover_import | 1/12锛堜粎 2025-12锛� | **涓嶆瀯鎴愮己鍙�**锛氳〃甯� `last_freight_m01..m12` / `last_turnover_m01..m12`锛�2026 鍚勬湡鏂囦欢鑷甫鍘诲勾鍚屾湀鍊� | +| scale_split_transport | 0/12 | **涓嶆瀯鎴愮己鍙�**锛氳〃甯� `above/below/total_yoy`锛屽悓姣斿凡闅� 2026 鍚勬湡鍏ュ簱 | + +- 鏃╂湡"搴撻噷娌℃湁 2025 骞村煄甯傚杩愭暟鎹�"鐨勬敞閲婁笌鎻愮ず鏂囨锛坄ReportExportService.java:499 / 558 / 561`锛�**宸茶繃鏈�**锛岃Е鍙戞潯浠朵笉鍐嶆垚绔嬶紱鍚屾瘮鍙栨暟璧扮殑鏄簱鍐呭幓骞村悓鏈燂紙`aggOf(data, year-1, m, "婀栧寳鐪�")`锛岀害 540 琛岋級銆� +- **鐪熸閬楃暀鐨勬槸鍙ｅ緞闂锛屼笉鏄己鏁版嵁**锛氫腑鍙ｅ緞鎺掑悕/鏄庣粏鐨� 2025 鍒椾粛浠�**姣嶇増闈欐�佸畾绋垮��**涓哄噯锛坄readMidDetailLastYearCumulative`锛宍ReportExportService.java:2745` 璧凤級锛屼唬鐮佹敞閲婏紙2686-2689 琛岋級璇存槑鍘熷洜鈥斺��"鎺掑悕椤靛師鍏堟煡搴撶幇绠楋紝涓よ�呭湪 **2025-03/04 缃戠害杞︽媶鍒�**涓婁笉鍚�"銆� +- 澶勭疆锛氬厛鍋氥�屽簱鍐� 2025 vs 姣嶇増 2025銆嶉�愰」 diff锛堜腑鍙ｅ緞 4 缁勪欢 脳 17 甯傚窞 脳 12 鏈� + 绱锛夛紝浜や笟鍔＄‘璁や互鍝竟涓哄噯锛屽啀鍐冲畾鏄惁鍒囨崲璇诲簱銆� + +### 12.5 缁撴灉灞傦紙姣斿悓浜嬫洿杩涗竴姝ワ紝鍙�夛級 + +- 鍚屼簨搴撻噷**涓嶅瓨璁＄畻缁撴灉**锛氱疮璁°�佸悓姣斻�佸崰姣斻�佺幆姣斿潎瀵煎嚭鏃剁畻锛孍xcel 鍐呰〃鐜颁负鍏紡銆� +- 鎴戜滑鍙�夊鍔犱竴寮犵粨鏋滆〃锛岀矑搴� = 鏈熼棿 + 椤� + 鎸囨爣 + 甯傚窞 + 褰撴湀/绱锛汣alc 鍐欏叆銆丗iller 璇诲彇銆� +- 鏀剁泭锛氬皬琛ㄤ笌璺ㄩ〉鍚堟垚椤靛叡鐢ㄤ竴濂楃粨鏋滐紱閫愭牸 diff 鏃惰兘鐩存帴鍖哄垎銆岀畻閿欍�嶈繕鏄�屽～閿欍�嶃�� +- 绾﹀畾锛氭寜鏈熼棿**骞傜瓑閲嶇畻**锛堝厛鍒犺鏈熼棿鍐嶆彃锛夛紱鏄剧ず鍙栨暣涓嶄笅娌夊埌搴擄紝鍙湪灞曠ず灞傝垗鍏ャ�� + +### 12.6 鑷绾緥锛堢孩绾匡級 + +> **姣嶇増閲屼笉鍏佽瀛樺湪銆屽彧鏈夊畠鎵嶆湁鐨勬暟鎹�嶃��** + +鍒ゅ畾鏂规硶锛氭妸姣嶇増鎵�鏈夊�兼竻绌哄悗锛岀▼搴忚兘鍚﹂噸鏂扮敓鎴愪竴寮犲畬鍏ㄤ竴鑷寸殑琛紵鑳� 鈫� 鏁版嵁閮藉湪搴擄紱涓嶈兘 鈫� 杩樻湁鏁版嵁钘忓湪 Excel 閲岋紝缁х画寰�搴撻噷鎼�� + +### 12.7 涓� M0 鐨勫叧绯伙紙渚濊禆椤哄簭锛� + +- 12.4 鐨勫彛寰勬牳瀵逛笉闃诲 M0 闃舵 1锛堢増寮忛噸寤猴級銆� +- M0 闃舵 2銆屽仠鐢� `_澶囦唤_` donor 杩樺師銆嶇殑鏁版嵁鍓嶆彁**宸插熀鏈弧瓒�**锛�2025 宸插湪搴擄級锛涗絾浠嶉渶鍏堝叧闂� 12.4 鐨勫樊寮傦紝鍚﹀垯鍒囨崲鍙栨暟鏉ユ簮浼氳鏁板瓧鍙樺姩銆佹棤娉曢�氳繃 diff=0 鍥炲綊銆� \ No newline at end of file -- Gitblit v1.9.1