From 639b53a3caae5c338a7735f34485dcfc590d5d24 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期五, 09 十月 2026 08:58:56 +0800 Subject: [PATCH] docs(汇总大表): 查证既有拍板——同比以母版缓存为准(F8/Q1)、扩列按月按需(F10)，并修正 M0 规格相冲表述 --- docs/汇总大表M0版式重建器规格_2026-10-06.md | 97 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 96 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 d01a127..fdb293d 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,99 @@ - 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 缃戠害杞︽媶鍒�**涓婁笉鍚�"銆� +- 澶勭疆锛�**2026-10-09 淇**锛夛細璇�"寰呯‘璁�"鍒ゆ柇鏈夎鈥斺�斿悓姣斿熀鍑嗗凡鍦� 2026-09-07 鎷嶆澘涓恒��**姣嶇増缂撳瓨浼樺厛锛屽簱浠呬綔鏍￠獙**銆嶏紙`docs/瑕佹眰涓庨獙鏀跺熀绾挎竻鍗�.md` F8銆佺‘璁ゅ洖鎵� Q1锛夛紱搴撳唴 2025 鐜扮畻鍊�**涓嶅緱**鐩存帴鏇夸唬姣嶇増闈欐�佸畾绋垮�硷紝浠呭綋浜哄伐鏍稿骞堕噸瀵间竴鑷村悗鎵嶅垏搴撳�笺�傝瑙佺鍗佷笁鑺傘�� + +### 12.5 缁撴灉灞傦紙姣斿悓浜嬫洿杩涗竴姝ワ紝鍙�夛級 + +- 鍚屼簨搴撻噷**涓嶅瓨璁＄畻缁撴灉**锛氱疮璁°�佸悓姣斻�佸崰姣斻�佺幆姣斿潎瀵煎嚭鏃剁畻锛孍xcel 鍐呰〃鐜颁负鍏紡銆� +- 鎴戜滑鍙�夊鍔犱竴寮犵粨鏋滆〃锛岀矑搴� = 鏈熼棿 + 椤� + 鎸囨爣 + 甯傚窞 + 褰撴湀/绱锛汣alc 鍐欏叆銆丗iller 璇诲彇銆� +- 鏀剁泭锛氬皬琛ㄤ笌璺ㄩ〉鍚堟垚椤靛叡鐢ㄤ竴濂楃粨鏋滐紱閫愭牸 diff 鏃惰兘鐩存帴鍖哄垎銆岀畻閿欍�嶈繕鏄�屽～閿欍�嶃�� +- 绾﹀畾锛氭寜鏈熼棿**骞傜瓑閲嶇畻**锛堝厛鍒犺鏈熼棿鍐嶆彃锛夛紱鏄剧ず鍙栨暣涓嶄笅娌夊埌搴擄紝鍙湪灞曠ず灞傝垗鍏ャ�� + +### 12.6 鑷绾緥锛堢孩绾匡級 + +> **姣嶇増閲屼笉鍏佽瀛樺湪銆屽彧鏈夊畠鎵嶆湁鐨勬暟鎹�嶃��** + +鍒ゅ畾鏂规硶锛氭妸姣嶇増鎵�鏈夊�兼竻绌哄悗锛岀▼搴忚兘鍚﹂噸鏂扮敓鎴愪竴寮犲畬鍏ㄤ竴鑷寸殑琛紵鑳� 鈫� 鏁版嵁閮藉湪搴擄紱涓嶈兘 鈫� 杩樻湁鏁版嵁钘忓湪 Excel 閲岋紝缁х画寰�搴撻噷鎼�� + +### 12.7 涓� M0 鐨勫叧绯伙紙渚濊禆椤哄簭锛� + +- 12.4 鐨勫彛寰勬牳瀵逛笉闃诲 M0 闃舵 1锛堢増寮忛噸寤猴級銆� +- M0 闃舵 2銆屽仠鐢� `_澶囦唤_` donor 杩樺師銆嶇殑鏁版嵁鍓嶆彁**宸插熀鏈弧瓒�**锛�2025 宸插湪搴擄級锛涗絾浠嶉渶鍏堝叧闂� 12.4 鐨勫樊寮傦紝鍚﹀垯鍒囨崲鍙栨暟鏉ユ簮浼氳鏁板瓧鍙樺姩銆佹棤娉曢�氳繃 diff=0 鍥炲綊銆� +## 鍗佷笁銆佹棦鏈夋媿鏉挎牳楠岋紙2026-10-09 鏌ヨ瘉锛夆�斺�旀湰鑺備紭鍏堢骇楂樹簬鍓嶈堪鍚勮妭锛屽啿绐佷互鏈妭涓哄噯 + +### 13.1 鍚屾瘮鍩哄噯锛氫互姣嶇増缂撳瓨涓哄噯锛堝凡纭锛屼笉鏄緟瀹氶」锛� + +| 鍑哄 | 鍘熸枃瑕佺偣 | 鐘舵�� | +|---|---|---| +| `docs/瑕佹眰涓庨獙鏀跺熀绾挎竻鍗�.md` F8 | 2025 骞村墠鏁版嵁浠ユ瘝鐗堢紦瀛樹负鍑嗭紱**姣嶇増缂撳瓨浼樺厛浣滃悓姣斿熀鍑嗭紝搴撳彧鍋氭牎楠�**锛屼汉宸ユ牳瀵归噸瀵间竴鑷村悗鎵嶅垏搴撳�硷紙Q1锛� | 鉁� 鍙ｅ緞纭 | +| `docs/纭鍥炴墽姹囨�讳笌鍓╀綑鐤戦棶_姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫燺2026-09-07.md` Q1 | 浠ユ瘝鐗堢紦瀛樹负鍚屾瘮鍩哄噯骞朵粎鎻愮ず锛涘緟浜哄伐鏍稿鍚庨噸瀵间竴鑷村啀鍒囨崲涓哄簱鍊硷紙"姣嶇増缂撳瓨浼樺厛锛屽簱浠呬綔鏍￠獙鍙傝��"锛� | 宸茬‘璁� | +| `docs/姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犳柟妗坃2026-09-07.md` 绗節鑺� | 2025 瀹氱鏁版嵁"鍓嶅彴瀵煎叆鏍￠獙"鍙︾珛浠诲姟锛�**鏈湡鍚屾瘮涓�寰嬩互姣嶇増缂撳瓨涓哄熀鍑�** | 鈥� | +| `docs/寰呯‘璁姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犻棶棰樻竻鍗昣2026-09-07.md` A1 | 2025 鍙婁互鍓嶅巻鍙插垪涓�寰�**淇濈暀姣嶇増缂撳瓨銆佷笉閲嶇畻** | 鈥� | +| `docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md` 鏂规 A | 涓彛寰勬帓鍚嶅彇鍘诲勾鍚屾湡绱鏀圭敤姣嶇増 2025 闈欐�佸垪锛堜笌涓彛寰勬槑缁嗗悓婧愶級锛屽凡瀹炴柦 | 宸插疄鏂� | + +缁撹锛�**搴撳唴 2025 鐜扮畻鍊间笉鑳界洿鎺ユ浛浠ｆ瘝鐗� 2025 闈欐�佸畾绋垮��**锛涘垏鎹㈢殑鍞竴鍓嶆彁鏄�"浜哄伐鏍稿骞堕噸瀵间竴鑷�"銆傜鍗佷簩鑺� 12.4 涓�"浜や笟鍔＄‘璁や互鍝竟涓哄噯"鐨勮〃杩版嵁姝や慨姝ｏ紙瑙佽鑺� 2026-10-09 淇琛岋級銆� + +### 13.2 鎵╁垪鏂瑰紡锛氭寜鏈堟寜闇�锛堝凡鎷嶆澘锛夆�斺�斾笌鏈枃妗�"婊＄増寮�"寤鸿鍐茬獊 + +| 鍑哄 | 鍘熸枃瑕佺偣 | 鐘舵�� | +|---|---|---| +| `docs/瑕佹眰涓庨獙鏀跺熀绾挎竻鍗�.md` F10 | **鎵╁垪鎸夋湀鎸夐渶锛堝姞鏈堜唤鎵嶆墿鍒楋紝涓嶉鍋� 12 鏈堟弧鐗堬級**锛涙柊澧炲垪"褰撴湀/鍚屾瘮"鏍囬涓轰袱琛屽悎骞跺崟鍏冩牸锛屾墿鍒楅』淇濈暀 | 鉁� M0 v4 | +| `docs/姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犳柟妗坃2026-09-07.md` v1.1 淇锛�2026-09-08 鐢ㄦ埛鎷嶆澘锛� | 姝ｆ枃"12 鏈堟弧鐗堝垪鐗堝紡"寤鸿**浣滃簾**锛涙墿鍒楁寜"姣忔湀闇�澧炴湀浠芥椂鍐嶆墿鍒�"鎵ц锛�=D1 鍘熷彛寰勶級 | 宸叉媿鏉� | + +鈫� 鏈枃妗ｇ涔濊妭 / 绗崄涓�鑺備腑"涓�娆″缓鎴� 12 鏈堟弧鐗堝紡"鐨勫缓璁笌 F10 鍐茬獊锛�**寰呯敤鎴疯瀹�**銆傝嫢娌跨敤鏃㈡湁鍙ｅ緞锛岄樁娈� 1 搴旀敼涓�"鎵╁垪鍣ㄦ寜鏈堟寜闇�"瀹炵幇锛岃�岄潪婊＄増寮忋�� + +### 13.3 宸叉湁鐨� 09-29 鎵╁垪宸ヤ綔浜х墿锛堟湰鍦版湭鍏ュ簱锛沗docs/闂姹囨��/_*.md` 宸茶 gitignore 鍛戒腑锛� + +- `docs/闂姹囨��/_鎵╁垪瑙勬牸琛╛2026-09-29.md` / `.csv`锛�19 椤甸�愰〉瑙勬牸鈥斺�旂被鍨嬶紙A 鏈堜唤瀵�+绱 / B 閮ㄥ垎鏈堜唤瀵� / C 鏈瘑鍒湀浠藉锛夈�佸悇椤垫湀浠藉鍒椾綅銆佺疮璁″垪銆佸缓璁彃鍏ヤ綅缃�佹暟鎹鑼冨洿銆佹爣棰樺啓娉曘�� +- `docs/闂姹囨��/_鎵╁垪閰嶇疆鍒濈_20260929.md` / `.csv`銆乣_鎵╁垪璁″垝_v3..v10.json`锛氶厤缃笌璁″垝杩唬锛坴10 浠呭墿 `杞ㄩ亾銆佽疆娓 涓�椤碉級銆� +- `docs/闂姹囨��/_鎵╁垪杩涘害_20260929.md`锛�8 鏈堚啋9 鏈堟墿鍒楄繘搴︹�斺��8 椤靛凡鎻掑垪锛�6 椤瑰緟淇紙琛ㄥご鏄剧ず/鍚堝苟鍖�/绱鍙埌 8 鏈堜笖澶氬啓 +Q/绱鍚屾瘮鍘诲勾鍩烘暟鍙埌 8 鏈�/鏍囬鏈堜唤鏈� +1/杞ㄩ亾杞浮闇�鎸夊潡鍒嗗埆鎻掑垪锛夛紱鑻ュ共椤垫彃鍏ヤ綅缃緟纭銆� +- 璇曞仛浠� `docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�9鏈堥亾璺繍杈撻噺姹囨�昏〃_璇曞仛_20260929.xlsx`锛堢粨鏋勫彲鐪嬨�佹暟鍊兼湭淇畬锛屽嬁鐢ㄤ簬鍑鸿〃锛夈�� + +鈫� 鏈鏍煎簲涓庝笂杩颁骇鐗╁榻愭帹杩涳紝涓嶅啀鍙﹁璁捐銆� + +### 13.4 姣嶇増缁存姢鐩爣锛堟棦鏈夊彛寰勶級 + +- `docs/寰呯‘璁姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犻棶棰樻竻鍗昣2026-09-07.md` A4锛�**"绋冲畾鍚庢瘝鐗堝彧褰撶増寮忔ā鏉匡紝鏈堝害鏁版嵁涓�寰嬬▼搴忓～"**鈥斺�斾笌鏈枃妗ｇ洰鏍囦竴鑷淬�� \ No newline at end of file -- Gitblit v1.9.1