From 5f0cb4bea881aeca9521032d6b0aa64a113f3e06 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 27 九月 2026 10:16:18 +0800
Subject: [PATCH] docs: 提交规范改为同事方式——过程日志(功能测试报告/工作日结)转本地不入库、HANDOFF 作为状态入口；109 个过程文档出库，状态矩阵移出日结目录

---
 HANDOFF.md |   65 ++++++++++++++++++++++++++++++++
 1 files changed, 65 insertions(+), 0 deletions(-)

diff --git a/HANDOFF.md b/HANDOFF.md
index 9f08756..c8616ac 100644
--- a/HANDOFF.md
+++ b/HANDOFF.md
@@ -4,6 +4,71 @@
 > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄��
 > **鍗忎綔绾﹀畾锛�2026-08-31锛�**锛氳銆屾彁浜ゃ��= 鏈湴 commit + 鎺ㄩ�佸埌杩滅 git锛坥rigin main锛孏itblit锛夛紝涓嶅啀鍙仛鏈湴 commit銆�
 
+## 鏈�鏂帮紙2026-09-23锛�
+
+- **宸插悓姝�**锛氭湰鍦� `main` 蹇繘鍚堝苟鍏徃 `origin/main` 鏈�鏂� `8b739ce`锛堝悓浜� 09-22 鍏虫満蹇収缁熶竴鐗堬級锛屽悎骞跺悗 `HEAD = 8b739ce = origin/main`锛屽伐浣滃尯骞插噣銆�
+- **鏈鏂板浜ゆ帴鏂囨。**锛歚docs/浜ゆ帴鏂囨。_2026-09-23.md`锛�09-23 澧為噺锛氱幇鐘跺揩鐓� + 鑵捐鏂囨。璇诲彇璋冪爺 + 褰撳墠寰呭姙 + 鏂囦欢绱㈠紩锛夈�傜郴缁熷叏鏅笌 P0/P1/P2 鍏ㄩ噺閬楃暀浠嶄互 `docs/浜ゆ帴鏂囨。_2026-09-21.md` 涓哄噯銆�
+- **浠婃棩宸ヤ綔**锛氳吘璁枃妗ｈ鍙栬皟鐮� + 娼滄睙鐗╂祦鎶曡祫鏈堟姤閲嶅淇锛涙棤涓氬姟浠ｇ爜鏀瑰姩锛堣 `docs/宸ヤ綔鏃ョ粨/宸ヤ綔鏃ョ粨_2026-09-23.md`锛夈��
+- **娼滄睙閲嶅锛堝凡瀹屾垚锛�**锛氭綔姹熺墿娴� 2026-06/07/08 鍦ㄥ簲鐢ㄥ疄闄呭簱 `3305` 鍧囨敼涓衡�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥� `11947.9 / 0 / 1135 / 0`锛涢噸澶嶉噸瀵间繚鎸佹瘡鏈� 1 鏉°�佹棤閲嶅悕椤圭洰锛�2026-08 瀵煎嚭绔埌绔牳瀵归�氳繃銆�09-22 鎶ュ憡璁板綍鐨勯獙璇佸簱鏄� `3308`锛屼笌褰撳墠搴旂敤杩炴帴搴撲笉涓�鑷达紝鏁呭綋鍓嶅簱 08 鏈堟棫鍊兼湰娆′竴骞朵慨姝ｃ�傛姤鍛� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_娼滄睙鎶曡祫鐗╂祦鏈堟姤閲嶅_2026-09-23.md`銆�
+- **鑵捐鏂囨。璇诲彇璋冪爺锛堟柊缁撹锛�**锛�
+  1. 鍙鍒嗕韩閾炬帴锛堛��2026骞村崄涓�鏁版嵁銆嬶紝10 椤电锛�**鑳借鏄剧ず鍊�** 鈥斺�� 娴忚鍣ㄣ�屾墦鍗� 鈫� 鏁翠釜宸ヤ綔绨� 鈫� 鎵撳嵃棰勮銆嶆覆鏌撴垚 SVG 娈碉紝璇� `<text>` 鍗冲緱鏁板��/鏃ユ湡/鐧惧垎姣�/`#DIV/0!`锛涗絾璇讳笉鍒板叕寮忋�侀殣钘忚鍒椼�佹墦鍗拌寖鍥村鍐呭锛屼笖涓嶆槗鎭㈠绮剧‘ A1 鍧愭爣銆�
+  2. **trafficAudit 鐩墠涓嶆敮鎸�**鍦ㄧ嚎鏂囨。瀵煎叆锛屽彧璧版湰鍦版枃浠朵笂浼狅紙`DataImport.vue:57/502` 鈫� `DataImportController.java:33` 鈫� Apache POI锛夈��
+  3. **鑵捐瀹樻柟 Open API V3 鍙**锛歚GET /openapi/spreadsheet/v3/files/{fileId}/{sheetId}/{range}`锛圓1 鑼冨洿锛岃繑鍥� `cellValue`锛夛紝浣嗛渶 OAuth 2.0 + 搴旂敤鍑瘉 + `scope.sheet(.readonly)`锛涗粎鍑垎浜摼鎺ヤ笉鑳藉尶鍚嶈皟鐢ㄣ�傝惤浜у搧寤鸿璧板畼鏂� API锛屼笉鐢ㄦ墦鍗伴瑙堛�傝瑙� `docs/浜ゆ帴鏂囨。_2026-09-23.md` 搂3銆�
+- **杩愯鐘舵�侊紙09-23 08:50 缁帴瀹炴祴锛�**锛歞ev 鍚庣 `8090`銆佸墠绔� `8080` 宸插惎鍔ㄥ苟灏辩华锛屽簲鐢ㄦ暟鎹簱 `localhost:3305/traffic_audit`銆傚惎鍔ㄥ懡浠わ細`powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1`锛堟矙绠卞锛夈��
+- **鎺ユ墜浼樺厛锛堟洿鏂帮級**锛氭姇璧勬槑缁嗚〃 L/D/E/F 瑕嗙洊鍙ｅ緞銆佹姹夌墿娴�/榛勫唸瀹㈣繍 8 鏈堟簮鏁版嵁銆佹湭瑕嗙洊娓呭崟钀芥枃浠讹紱姹囨�诲ぇ琛� 304 鏍笺��2025 绱鍒椼�嶏紱P0-2 浜垮厓琛ㄦ寜 Q7 杩藉垪銆丳0-3 瀵煎嚭鍓嶅熀鏁颁綋妫�銆丳0-4 2026-09 姣嶇増銆�
+
+## 鏈�鏂帮紙2026-09-22锛�
+
+- **宸插悓姝�**锛氭湰鍦� `main` 宸插悎骞跺叕鍙� `origin/main` 鏈�鏂� `db0ee92`锛堝惈鎶曡祫鏄庣粏鍙栨暟/瀵煎叆淇锛夛紱鍚堝苟鍚� `mvn -q -DskipTests compile` 閫氳繃銆�
+- **Codex 杈撳叆鍗￠】澶嶆牳锛堝凡瀹屾垚锛�**锛氱數鑴戜笌 Codex 浜� 09-22 12:54 閲嶅惎鍚庯紝`Codex++` 淇鑴氭湰浠嶅惎鐢紱涓绘覆鏌撹繘绋嬬┖闂� CPU 绾� 13.3%锛堝崟鏍革級锛岃皟璇曞畧鍗� `installed=true`銆佹湰娆′細璇� `dropped=16`銆傚姣斾慨澶嶅墠绾� 115%锛屽崱椤块棶棰樺凡瑙ｅ喅銆�
+- **浠婃棩宸插畬鎴愶紙杩滅鎻愪氦锛�**锛氭暟鎹煡鐪嬭ˉ榻愮綉绾﹁溅/涓綋瀹㈣繍銆佹寜甯傚窞姹囨�讳笌瀵煎嚭 Excel銆佹眹鎬诲ぇ琛ㄨ繘搴﹀脊绐椾笌缁撴灉钀界洏缂撳瓨銆�
+- **姹囨�诲ぇ琛ㄥ樊寮傚鏍革紙2026-09-22锛�**锛氳蒋浠惰緭鍑轰笌鎵嬪伐瀹氱缁� Excel 鍏ㄩ噺閲嶇畻鍚庨�愭牸姣斿锛�930 鏉″樊寮備腑瀹炶川鏁板�煎樊寮� 314 鏉★紱鍏朵腑 304 鏉′负 2025 绱鍒楀皯鍔� 7銆�8 鏈堬紙涓氬姟宸茬‘璁ゅ彲娓呯┖锛夛紝10 鏉� ` 璐ц繍` 鍘嗗彶鍚屾瘮涓氬姟宸茬‘璁よ蒋浠舵纭�傛姤鍛婅 `docs/闂姹囨��/姹囨�诲ぇ琛╛杞欢杈撳嚭涓庢墜宸ュ畾绋垮樊寮傛竻鍗昣2026-08_20260922.md`锛屾槑缁嗚鍚屽悕鐩綍 CSV銆�
+- **鏈畬鎴愰噸鐐逛笉鍙�**锛歅0-2銆婁嚎鍏冩姇璧勯」鐩�嬫寜 Q7 杩藉垪銆丳0-3 瀵煎嚭鍓嶅熀鏁颁綋妫�銆丳0-4 2026-09 姣嶇増锛涘叾浣欒 `docs/浜ゆ帴鏂囨。_2026-09-21.md` 绗� 4 绔犮��
+
+### 琛ュ厖锛�2026-09-22 涓嬪崍锛屾姇璧勫彇鏁颁慨澶嶇涓�杞級
+
+- **宸蹭慨锛堜唬鐮� + 閲嶅 + 鍥炲綊锛�**锛氣憼 瀵煎嚭鍘绘爣鐐瑰綊涓�鍖栧尮閰嶏紙鑽嗗窞锛夛紱鈶� 鍚屽悕鍙屾。浼樺厛鍙栧綋鏈堟湁鏁版嵁鐨勬。锛堝崄鍫板揩閫掍骇涓氬洯浜屾湡锛夛紱鈶� 鏈鐩栬閫愯 WARN 鐣欑棔锛涒懀 瀵煎叆琛ㄥご鍘绘崲琛岋紙澶╅棬 H/J/K 涓嶅啀涓級锛涒懁 瀵煎叆鎸夎〃鍐呮姤琛ㄦ湡閫� sheet锛�**娼滄睙涓嶅啀鎶� 2018 骞存暟鎹綋 2026-08**锛夈��
+- **缁撴灉**锛�2026-08 鐗╂祦/瀹㈣繍鏄庣粏閫愭牸宸紓 **156 鈫� 129**锛屾棤鏂板宸紓锛涙湭瑕嗙洊娓呭崟宸茶兘鑷姩鍒楀嚭锛堢墿娴佹姹� 6 琛岋紱瀹㈣繍榛勭煶1/榛勫唸9/鎭╂柦1/浠欐1锛夈��
+- **閬楃暀锛堜笅涓�杞級**锛歀/D/E/F 瑕嗙洊鍙ｅ緞锛堥渶銆婂缓璁鹃樁娈靛綊涓�琛ㄣ�嬶級銆佹姹夌墿娴佷笌榛勫唸瀹㈣繍 8 鏈堟簮鏁版嵁銆佹綔姹� 2026-06/07 鍘嗗彶閿欏�奸噸瀵笺�佹湭瑕嗙洊娓呭崟鍑烘枃浠�/椤甸潰鎻愮ず锛圥1-9锛夈��
+- **鎶ュ憡**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎶曡祫鏄庣粏琛ㄥ彇鏁颁慨澶峗2026-09-22.md`銆�
+
+### 琛ュ厖锛�2026-09-22 涓嬪崍锛屾姇璧勬槑缁嗚〃姣斿锛�
+
+- **宸插畬鎴�**锛氳蒋浠躲�婂杩愮珯鎶曡祫鏄庣粏琛ㄣ�嬨�婄墿娴佺珯鍦烘姇璧勬槑缁嗐�嬩笌浜哄伐鐗堥�愭牸姣斿锛�156 鏍煎樊寮傦級锛屾姤鍛� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鏁版嵁姣斿鎶ュ憡_鎶曡祫鏄庣粏琛ㄨ蒋浠剁敓鎴愪笌浜哄伐鐗坃2026-09-22.md`銆�
+- **鎹炲嚭 3 绫汇�屼細闈欓粯鍑烘暟銆嶇殑闂**锛堥兘鎸囧悜鍙栨暟鑰岄潪绠楁湳锛夛細
+  1. 瀵煎嚭鐢ㄥ簳绋挎ā鏉� + **鎸夐」鐩悕鍖归厤**搴撳唴褰撴湀鏁帮紝鍖归厤涓嶄笂/搴撳唴鏃犲綋鏈堟暟灏辨部鐢ㄤ笂鏈熷�� 鈥斺�� 姝︽眽鐗╂祦锛堝簱鍐� 0 鏉℃湀搴﹁褰曪級鏁存淇濈暀 7 鏈堝�硷紱鑽嗗窞銆屼腑鍥戒緵閿�鍏畨鍟嗚锤鐗╂祦鍥�嶅洜搴撳唴鍚嶅涓�涓偣鏈鐩栥��
+  2. 搴撳唴**鍚屽悕鍙屾。**锛氬崄鍫般�屽揩閫掔墿娴佷骇涓氬洯浜屾湡銆峘id=154`(绔ｅ伐2026)/`id=181`(绔ｅ伐2029) 骞跺瓨锛屽鍑哄彇鍒版棫妗ｃ��
+  3. **瀵煎叆涓㈡暟**锛氬ぉ闂ㄣ�屽ぉ闂ㄥ競鐗╂祦涓績寤鸿椤圭洰銆嶅簱鍐� 2026-08 绱/鑷勾鍒�/鏈湀鍏ㄤ负 0锛屾簮鏂囦欢鏄� 16677.7/16677.7/500锛�**P1-5 鍘熻褰曘�屾簮鏂囦欢 H/J/K 鍒椾负绌恒�嶄笌鐜版枃浠朵笉绗︼紝闇�鏇存**锛夈��
+- **鍙�**锛氬鍑轰笉瑕嗙洊 L锛堝缓璁鹃樁娈碉級鍒椼�佸崟娓犻亾甯傚窞鐨勫垎缁勫皬璁¤濉硶銆�0/绌虹櫧鍐欐硶宸紓锛屽潎宸插湪鎶ュ憡绗簲鑺傜粰鍑哄缃缓璁��
+
+### 琛ュ厖锛�2026-09-22 涓嬪崍锛屽彟涓�浼氳瘽鏀跺熬锛�
+
+- **鏈細璇濆凡瀹屾垚**锛堝凡鎺ㄩ�侊級锛氭眹鎬诲ぇ琛ㄨ繘搴﹀脊绐椾紭鍖栵紙瀹屾垚鍚庝笉鍐嶅嚭鐜伴噸澶嶄笅杞芥寜閽級锛涘鍑虹粨鏋�**钀界洏缂撳瓨**锛坄docs/鐢熸垚姹囨�诲ぇ琛�/_cache/`锛屽凡 gitignore锛夛紱
+  缂撳瓨瀹堝崼鍗囩骇涓�**鏁版嵁鎸囩汗**锛堜緷璧栨簮琛� `CHECKSUM TABLE` + 姣嶇増绛夋枃浠惰韩浠斤紝鎺掗櫎鎶曡祫/鑳借��/瀹℃牳/绯荤粺/瀵煎叆鏃ュ織锛夆�斺�旀棤鍏冲鍏ヤ笉鍐嶅け鏁堛��**鎹㈡瘝鐗堝繀瀹氬け鏁�**锛屽け鏁堟椂杩涘害寮圭獥缁欏嚭璇存槑銆�
+- **褰撳墠鐜**锛氬悗绔� 8090銆佸墠绔� 8080 杩愯涓紱瀵煎嚭缂撳瓨瀵� 2026-08 鏈夋晥锛堟枃浠跺悕甯︽寚绾癸級锛涙渶鏂版彁浜� `06b1cb7`銆�
+- **鍓╀綑寰呭姙锛堝凡閫愭潯鏍告煡锛屽悓浜嬫湭瑙︾锛�**锛歅0-2 浜垮厓琛ㄦ寜 Q7 杩藉垪锛坄ReportExportService.java:6251` 浠嶅啓鍚屼竴鏍硷級銆丳0-3 鍩烘暟浣撴锛坄getLastMidIssues()` 鏃犺皟鐢ㄦ柟锛夈��
+  P0-4 2026-06/09 姣嶇増缂哄け銆丳1-7 鎶曡祫璧勯噾娓犻亾瀛楁銆丳1-9 鎶曡祫瀵煎嚭鎸夋湀鍒嗙洰褰� + 杩愯鏃ュ織銆丳2-1 D 缁勫閫熸帓鍚嶆帾杈炪��
+- **寰呮牳瀹�**锛歚docs/浜ゆ帴鏂囨。_2026-09-21.md` 鐨� P2-2銆屽煄甯傚杩愰〉琛ㄥご浠嶆槸鏃ユ湡搴忓垪鍙枫�嶅彲鑳借繃鏃垛�斺�斾唬鐮佸凡鏈� `fixCityMonthHeaderText()`锛�09-03 鍔犲叆锛夛紝
+  寤鸿璺戜竴娆� 2026-08 瀵煎嚭鏍稿鍚庡啀鏀规枃妗ｃ��
+- **鍏ュ彛**锛歚HANDOFF.md`锛堟湰鏂囦欢锛夆啋 `AGENTS.md` 鈫� `docs/浜ゆ帴鏂囨。_2026-09-21.md` 绗� 4 绔狅紙P0/P1/P2 鍏ㄩ噺閬楃暀锛夈��
+
+### 鍏虫満浜ゆ帴蹇収锛�2026-09-22 鏅氾級
+
+- **浠婃棩浜や粯锛堜袱椤癸紝鍧囧凡鎺ㄩ�侊級**锛�
+  1. 銆婃姇璧勬槑缁嗚〃 杞欢鐢熸垚 vs 浜哄伐鐗堛�嬮�愭牸姣斿锛�156 鏍煎樊寮傦級+ 鏍瑰洜瀹氫綅 鈥斺�� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鏁版嵁姣斿鎶ュ憡_鎶曡祫鏄庣粏琛ㄨ蒋浠剁敓鎴愪笌浜哄伐鐗坃2026-09-22.md`锛�
+  2. 绗竴杞彇鏁颁慨澶嶏紙瀵煎嚭 3 澶� + 瀵煎叆 2 澶勶紝鍚柊鍙戠幇鐨�"娼滄睙瀵煎叆 2018 骞村巻鍙� sheet"锛夆�斺�� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎶曡祫鏄庣粏琛ㄥ彇鏁颁慨澶峗2026-09-22.md`锛涘洖褰掑悗閫愭牸宸紓 **156 鈫� 129**锛屾棤鏂板宸紓銆�
+- **git**锛歚main` = `db0ee92`锛屽凡鍚屾鍏徃 `origin/main`锛堝凡鍚堝苟鍚屼簨 `13c2d36` 姹囨�诲ぇ琛ㄥ樊寮傚鏍革級銆傚伐浣滃尯骞插噣锛涗粎鏈湴鏈窡韪殑涓存椂浜х墿锛坄_tmp_diff_tables_0922.md`銆乣_tmp/gen_new_0922/`銆乣_tmp_*_0922.*`锛夊拰鐢ㄦ埛鑷繁鐨� `docs/纭.docx` 鏈叆搴撱��
+- **杩愯鐘舵�侊紙17:2x 瀹炴祴锛�**锛歞ev 鍚庣 `8090`銆佸墠绔� `8080` **鍧囧湪杩愯**锛圚TTP 200锛涘悗绔负鏈淇鍚庣殑鏋勫缓锛�16:43 缁� `start-dev.ps1` 閲嶅惎锛夛紱鍏虫満鍚庤嚜鐒跺仠姝€�佷笉闇�鎵嬪伐澶勭悊銆傛暟鎹簱 `3308`锛堟湰椤圭洰锛変笌 `3305/3306` 鎸夋儻渚嬩繚鐣欙紝鏁版嵁宸叉寔涔呭寲銆�
+- **涓嬫鍚姩**锛氶」鐩牴鐩綍 `powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1`锛堣剼鏈細璺宠繃宸插湪璺戠殑绔彛锛涘墠鍚庣闇�鍦ㄦ矙绠卞杩愯锛夈��
+- **淇濈暀浜х墿锛堟湭缁忕‘璁や笉鍒狅級**锛氭眹鎬诲ぇ琛� 930 鏉″樊寮傛姤鍛�/CSV銆佹姇璧勬瘮瀵逛笌淇鎶ュ憡銆乣_tmp*_0922.*`銆乣_tmp/gen_new_0922/`銆�
+- **鏈疆鏁版嵁鍙樻洿**锛氫粎閲嶅淇 `investment_monthly` 澶╅棬銆佹綔姹� 2026-08 涓ゅ鏁板�硷紝鏈垹闄や换浣曢」鐩富妗ｃ�佹湭鍔ㄥ叾浠栧競宸�/鏈熼棿銆�
+- **鎺ユ墜浼樺厛锛堟槑鏃ワ級**锛�
+  1. L/D/E/F 鍒楄鐩栧彛寰勶紙闇�鍏堢‘璁ゃ�婂缓璁鹃樁娈靛綊涓�琛ㄣ�嬶細婧愯〃 涓讳綋鏂藉伐/绔ｅ伐鏀跺熬/鏈紑宸�/鏈勾姝ｅ紡鏂藉伐/鏆傚仠鏂藉伐/鍓嶆湡 鈫� 杈撳嚭鐢ㄨ瘝锛夛紱
+  2. 琛ユ簮鏁版嵁锛氭姹夌墿娴� 8 鏈堟棤鍗曡〃銆侀粍鍐堝杩� 8 鏈堟棤婧愭枃浠讹紙瀵煎嚭宸茶兘鑷姩鍛婅锛屽叡 15 琛屽彈褰卞搷锛夛紱
+  3. 娼滄睙 2026-06 / 2026-07 鏈堝害浠嶆槸 2018 鍘嗗彶 sheet 閿欏�硷紝**鐢� 6/7 鏈堟簮琛�**閲嶅锛堜笉瑕佺敤 8 鏈堟枃浠堕噸瀵硷級锛�
+  4. 銆屾湭瑕嗙洊琛屾竻鍗曘�嶇洰鍓嶅彧杩� `backend.log`锛屾寜 P1-9 鍙啀鍋氭垚銆婃牎楠屾姤閿檁<骞存湀>.xlsx銆嬫垨椤甸潰鎻愮ず锛�
+  5. 鏃㈡湁 P0/P1 涓嶅彉锛堜嚎鍏冭〃鎸� Q7 杩藉垪銆佸鍑哄墠鍩烘暟浣撴銆�2026-09 姣嶇増绛夛紝瑙� `docs/浜ゆ帴鏂囨。_2026-09-21.md` 绗� 4 绔狅級銆�
+
 ## 鏈�鏂帮紙2026-09-21锛�
 
 - **鏈�鏂版�诲叆鍙�**锛歚docs/浜ゆ帴鏂囨。_2026-09-21.md`锛堢郴缁熺幇鐘躲�丳0/P1/P2 閬楃暀銆佹搷浣滄墜鍐岋級锛涙眹鎬诲ぇ琛ㄤ笓椤硅 `docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`銆�

--
Gitblit v1.9.1