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 | 46 ++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 46 insertions(+), 0 deletions(-) diff --git "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-07.md" "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-07.md" new file mode 100644 index 0000000..3f14c57 --- /dev/null +++ "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-07.md" @@ -0,0 +1,46 @@ +# 宸ヤ綔鏃ョ粨_2026-09-07 + +## 浠婃棩宸ヤ綔锛堟棭闂达級 +1. 鍚姩绯荤粺锛氬悗绔� 8090 / 鍓嶇 8080 灏辩华锛坰tart-dev.ps1锛夈�� +2. 鎺掓煡 `D:\_wyc_ddl.sql` 娈嬬暀锛氱郴 09-04 鐢熸垚缃戠害杞﹀缓琛� SQL 鏃跺啓鍏ュ綋鏃跺伐浣滅洰褰曪紙D 鐩樻牴鐩綍锛夛紝鍚屾棩宸叉寮忓綊妗ｄ负 `docs/sql_wyc.sql`锛屽睘涓存椂娈嬬暀锛堝緟鐢ㄦ埛纭鍚庡垹闄わ級銆� +3. 纭骞惰褰� git 鍙屼粨搴撶害瀹氾紙2026-09-07锛岀敤鎴风瓟澶嶏級锛� + - 涓汉浠撳簱 `origin`锛坓itee.com/zhizhijie/traffic-audit锛夛細鐢ㄦ埛鏈夋敼鍔ㄦ椂鍏� `git fetch origin` 鏌ョ湅鍚堝苟锛堝綋鍓嶈繙绔垎鏀� master锛屾湰娆℃鏌ユ棤鏂版彁浜わ級锛� + - 鍏徃浠撳簱鎺ㄩ�佷竴寰嬫寜 AGENTS.md 绗� 3 鏉℃祦绋嬫墽琛岋紙fetch gitea 鈫� 鍚堝苟 main 鈫� commit 鈫� push锛夛紝涓嶅啀閫愭璇㈤棶銆� + - 宸叉妸绾﹀畾鍐欏叆 `AGENTS.md` 宸ヤ綔瑙勮寖绗� 4 鏉°�� + +## 娴嬭瘯缁撴灉鎽樿 +- 鏃犱唬鐮佹敼鍔紱鏂囨。绾﹀畾鏇存柊锛実it fetch gitea 涓庤繙绔� main 涓�鑷达紙鏃犲悓浜嬫柊鎻愪氦锛夈�� + +## 閬楃暀闂涓庡緟鍔� +- `D:\_wyc_ddl.sql` 鍒犻櫎寰呯敤鎴风‘璁ゃ�� +- 浠撳簱宸ヤ綔鍖鸿剰锛歞ocs/鐢熸垚姹囨�诲ぇ琛� xlsx 鍙樻洿涓庡垹闄わ紙楠ㄦ灦姣嶇増鎻愪氦 P1锛夈�佸ぇ閲� _*.sql/_*.ps1 涓存椂鏂囦欢寰呮竻鐞嗐�� +- 寰呭姙寤剁画锛氭眹鎬昏〃姣嶇増淇鎻愪氦楠ㄦ灦銆佽繍璺濆悕鍗曞彛寰勫畾绋垮嚭姝ｅ紡鐗堛�佸悓浜嬬増鍏氦/鍑虹妯℃澘鍏煎绛夈�� + +## 浠婃棩宸ヤ綔锛堜笅鍗堬細姹囨�诲ぇ琛ㄦ瘝鐗堜慨姝ｏ級 +1. 鎸夌敤鎴疯姹傝ˉ ` 璐ц繍` 椤� 瑙勪笂+瑙勪笅璐ц繍閲�(R11)/瑙勪笅璐ц繍閲�(R13) 2021-2026 鍏ㄩ儴鏈堝害鏁版嵁锛堟簮 D:\05_鏁版嵁鍒嗙被\璐ц繍\7鏈� 瀹氱琛紝瑙勪笅=鍚堣鈭掕涓婏級锛屾瘝鐗堜笌澶囦唤姣嶇増鍚屾淇敼骞堕�愭牸鏍稿銆� +2. 淇鏁存湰 6 涓垚鍝侀〉锛堣揣杩愰噺鎺掑悕/璐ц繍鍛ㄨ浆閲忔帓鍚�/涓彛寰勬帓鍚�/涓彛寰勫垎鏋�/鍩庡競姹囨��/鍩庡競鍒嗗競宸烇級鈥滃綋鏈堝潡=绱鍧椻�濋棶棰橈細褰撴湀鎺掑悕銆佸崰姣斻�佸悓姣斻�佸綋鏈堝�煎叏閮ㄦ寜 2026-07 閲嶇畻锛涗慨澶嶉杞剼鏈笁澶勮鐢� bug锛堝懆杞璇婚敊銆佸煄甯傛眹鎬诲贰娓歌閿欎綅銆佸悎璁＄被鍒楄鍏紡涓插彉绌猴級銆� +3. 绋嬪簭 HTTP 鐢熸垚 2026-07 鏁存湰楠岃瘉閫氳繃锛岃緭鍑哄埛鏂颁负 `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/閬撹矾杩愯緭閲忔眹鎬昏〃_2026-07.xlsx`銆� +4. 娴嬭瘯鎶ュ憡锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_姹囨�诲ぇ琛ㄨ揣杩愯涓婅涓嬭ˉ鏁颁笌鎴愬搧椤靛綋鏈堝潡淇_2026-09-07.md`銆� + +## 娴嬭瘯缁撴灉鎽樿锛堜笅鍗堬級 +- 姣嶇増涓庡浠芥瘝鐗堣鏀瑰尯鍩熼�愭牸 diff=0锛� +- 鍙拌处鍘熷鏁板�兼牳瀵癸細鍩庡競鍐呭杩愬綋鏈堝叏鐪� 33068.03銆佸懆杞� 206194.82锛涜揣杩愯涓�/瑙勪笅/鍚堣涓庢簮琛ㄤ竴鑷达紱 +- 6 涓垚鍝侀〉褰撴湀鍧楁湀鈮犵疮璁★紙鍚堟硶绌哄垪闄ゅ锛夛紱绋嬪簭浜х墿鎶芥煡鍏ㄩ儴閫氳繃銆� + +## 閬楃暀闂涓庡緟鍔烇紙涓嬪崍澧炶ˉ锛� +- 鏁版嵁椹卞姩濉厖锛圥2+锛夎窡杩涳細鎴愬搧椤靛綋鏈堝潡鐩墠璧颁汉宸ヤ慨姣嶇増锛屽悗缁帴鍏ヨ嚜鍔ㄨ绠楋紱 +- 杈撳嚭鐩綍鐣欐湁鏈細璇濅复鏃堕獙璇佸壇鏈� `鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-07_楠岃瘉.xlsx`锛堟湭鍏ュ簱锛屽緟纭鍚庡彲鍒狅級锛� +- 浠撳簱宸ヤ綔鍖轰粛鏈夊巻鍙插垹闄わ紙2 涓� 7鏈堟竻绌烘祴璇曠増 xlsx锛変笌澶ч噺 _*.sql/_*.ps1 涓存椂鏂囦欢锛屾湭闅忔湰娆℃彁浜ゃ�� + +## 浠婃棩宸ヤ綔锛堟櫄闂达細鏁版嵁椹卞姩鏀归�犲紑宸モ�斺�旀柟妗� v1锛� +1. 璇诲彇妗岄潰銆婄‘璁�.docx銆嬪苟褰掓。鎷嶆澘缁撴灉鑷� `docs/纭鍥炴墽姹囨�讳笌鍓╀綑鐤戦棶_姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫燺2026-09-07.md`锛圦1-Q3 宸茬‘璁わ細姣嶇増缂撳瓨浼樺厛浣滃悓姣斿熀鍑�/鍐呴儴涓棿琛ㄤ笉瀵瑰/鐝嚎鎸� docs/鍏矾鏃呭 鏄犲皠锛夈�� +2. 澶嶆牳 A2锛�2025 鍙傜収鍏ㄥ勾姣嶇増鍧囨湁鍊硷紝姝ゅ墠涓虹┖绯诲叏鐪佽鍏紡鏈紦瀛樻墍鑷达級涓� B4锛堣建閬撹疆娓″湪 U203 鍏氦鏈堟姤鍚屼竴琛紝importCityBus 宸茶惤搴擄級銆� +3. 瀹炴祴鏁版嵁搴撹〃缁撴瀯涓庢湡闂磋鐩栵紙city_bus/taxi/freight/scale_split/h2031/涓綋/wyc 鍧� 2026-01~07锛宧2031 鍙︽湁 2026-08锛夈�� +4. 浜у嚭銆婃眹鎬诲ぇ琛ㄦ暟鎹┍鍔ㄨ嚜鍔ㄥ～琛ㄦ敼閫犳柟妗� v1銆嬶細docs/姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犳柟妗坃2026-09-07.md锛堟灦鏋�=鍙栨暟灞� Calc + SummaryFiller锛涙槧灏勬竻鍗曪紱12 鏈堟弧鐗堝垪鐗堝紡绛栫暐锛涢噷绋嬬 M0-M4锛涢闄╋級銆� + +## 娴嬭瘯缁撴灉鎽樿 +- 鏃犱唬鐮佹敼鍔紙鏈棩鏂规/鍥炴墽鏂囨。闃舵锛夛紱DB 瀹炴祴缁撴灉涓� 7 鏈堟瘝鐗堟暟鍊间竴鑷达紙2025 鍙傜収榻愬叏锛夈�� + +## 閬楃暀闂涓庡緟鍔烇紙鏅氶棿澧炶ˉ锛� +- 寰呯敤鎴风‘璁ゆ柟妗� v1 鍚庤繘鍏� M0/M1锛�12 鏈堟弧鐗堟瘝鐗� + 鍙栨暟璁＄畻鏈嶅姟鎶藉彇锛夈�� +- 浠婃棩涓存椂鑴氭湰锛歘probe*.py/_recheckA2*.py/_q_probe*.sql 绛変笉鍏ュ簱銆� -- Gitblit v1.9.1