From ecf2b3c4ca25709aff8aae6f5969f0595d55206f Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期三, 23 九月 2026 09:28:48 +0800
Subject: [PATCH] Merge remote-tracking branch 'gitea/main'

---
 HANDOFF.md                                  |   13 ++
 docs/功能测试报告/功能测试报告_投资明细表取数修复_2026-09-22.md  |    2 
 docs/功能测试报告/功能测试报告_潜江投资物流月报重导_2026-09-23.md |   67 +++++++++++
 docs/工作日结/工作日结_2026-09-23.md                |   69 +++++++++++
 docs/交接文档_2026-09-23.md                     |  197 ++++++++++++++++++++++++++++++++
 5 files changed, 348 insertions(+), 0 deletions(-)

diff --git a/HANDOFF.md b/HANDOFF.md
index 83812a3..c8616ac 100644
--- a/HANDOFF.md
+++ b/HANDOFF.md
@@ -4,6 +4,19 @@
 > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄��
 > **鍗忎綔绾﹀畾锛�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` 閫氳繃銆�
diff --git "a/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-23.md" "b/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-23.md"
new file mode 100644
index 0000000..7d00109
--- /dev/null
+++ "b/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-23.md"
@@ -0,0 +1,197 @@
+# 浜ら�氳揣杩愮粺璁″鏍哥郴缁� 鈥斺�� 浜ゆ帴鏂囨。锛�2026-09-23锛�
+
+> **鐢ㄩ��**锛氭柊瀵硅瘽/鎺ユ墜浜哄厛璇� `HANDOFF.md` + 椤圭洰鏍� `AGENTS.md`锛屽啀璇绘湰鏂囷紝鍗冲彲鏃犵紳鎺ュ姏銆�
+> **涓庡叾瀹冩枃妗ｇ殑鍏崇郴**锛氭湰鏂囧彧鍐� 09-23 鐨勫閲忥紙鐜扮姸蹇収 + 鏈瀵硅瘽鏂板鐨勮吘璁枃妗ｈ鍙栬皟鐮� + 褰撳墠寰呭姙鍏ュ彛锛夛紱
+> 绯荤粺缁撴瀯銆丳0/P1/P2 鍏ㄩ噺閬楃暀浠嶄互 `docs/浜ゆ帴鏂囨。_2026-09-21.md` 涓哄噯锛屼笉閲嶅銆�
+
+---
+
+## 0. 鍏堣杩欎竴椤碉紙鎺ユ墜绗� 1 灏忔椂锛�
+
+1. **鍏堟妸绯荤粺璺戣捣鏉�**锛堣 搂1.3锛夛紝鍐嶈皥鏀逛唬鐮併�傝剼鏈繀椤诲湪**娌欑澶�**杩愯銆�
+2. **鏈瀵硅瘽鏂板缁撹**锛氳吘璁枃妗ｅ湪绾胯〃鏍笺�岃兘涓嶈兘璇汇�佹�庝箞璇汇�乼rafficAudit 鑳戒笉鑳借嚜宸辫銆佸畼鏂� API 琛屼笉琛屻�嶅叏閮ㄨ皟鐮斿畬锛岃 搂3銆�
+3. **P0 涓変欢浜嬩笉鍙�**锛氣憼銆婁嚎鍏冩姇璧勯」鐩�嬫寜 Q7 杩藉垪锛涒憽 瀵煎嚭鍓嶃�屽熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉銆嶅彧鍋氫簡涓�鍗婏紱鈶� 缂� 2026-06 / 2026-09 姣嶇増銆傝瑙� `docs/浜ゆ帴鏂囨。_2026-09-21.md` 搂4銆�
+4. **纭鐭╀笉鍙�**锛氭敼瀹屽繀椤诲啓銆婂姛鑳芥祴璇曟姤鍛娿�嬧啋 鏇存柊銆婂伐浣滄棩缁撱�嬧啋 鎺ㄩ�佸叕鍙� gitea锛坄origin`锛屄�1.4锛夈�備笉瑕佸己鎺ㄣ�佷笉瑕佽鐩栧悓浜嬩唬鐮併��
+
+---
+
+## 1. 鐜扮姸蹇収锛�2026-09-23 08:50 缁帴瀹炴祴锛�
+
+### 1.1 git
+
+| 椤� | 鍊� |
+| --- | --- |
+| 鍒嗘敮 | `main` |
+| 鏈疆璧风偣 HEAD | `8b739ce docs(浜ゆ帴): 缁熶竴 09-22 鍏虫満蹇収锛堝悎骞跺悓浜嬬増鏈紝淇杩愯鐘舵�佷负瀹炴祴锛�8090/8080 鍦ㄨ繍琛岋級` |
+| 杩滅 | 鏈疆寮�濮嬪墠宸插悓姝ュ叕鍙� `origin/main`锛涙湰娆＄画鎺ユ柊澧炵殑鏂囨。鎻愪氦瑙� `git log` |
+| 杩滅鍦板潃 | `origin` 鈫� `http://61.183.254.94:3000/r/trafficAudit.git`锛堝垎鏀� `main`锛夆�斺��**鍙敤鍏徃 gitea 鍗曚粨搴�**锛屼釜浜� gitee 宸插純鐢� |
+
+### 1.2 鏈嶅姟涓庤繘绋�
+
+| 椤� | 鍊� |
+| --- | --- |
+| dev 鍚庣 8090 | **杩愯涓�**锛�09-23 08:48 鍚姩锛屾棩蹇楀嚭鐜� `Started TrafficAuditApplication`锛� |
+| dev 鍓嶇 8080 | **杩愯涓�**锛�09-23 08:48 鍚姩锛屾棩蹇楀嚭鐜� `App running at`锛� |
+| 鏁版嵁搴� | MySQL锛屽簱 `traffic_audit`锛岄厤缃� `jdbc:mysql://localhost:3305/traffic_audit`锛宍root/root`锛涙湰鏈� `MySQL57`銆乣MySQL80` 鏈嶅姟鍧� **Running** |
+| 鍏跺畠 node 杩涚▼ | 瀛樺湪鑻ュ共 `node`/`cmd`锛�08:42 璧凤級锛屼负 Codex 鑷韩缁勪欢锛�**鍕垮姩** |
+
+> 鍒ゆ柇鏈嶅姟鏄惁璧锋潵锛�**鍙湅鏃ュ織**锛堝悗绔� `Started TrafficAuditApplication` + `Tomcat started on port(s): 8090`锛涘墠绔� `App running at`锛夈��
+> 娌欑鍐� `Get-NetTCPConnection` 浼氶潤榛樺け璐�/鎶ユ棤鍖归厤锛屾嵁姝ゅ垽鏂細璇垽銆�
+
+### 1.3 鍚姩 / 鍋滄
+
+```powershell
+# 椤圭洰鏍圭洰褰曪紝蹇呴』鍦ㄦ矙绠卞锛堟彁鏉冿級杩愯
+powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1
+# 鍋滄锛�
+powershell -NoProfile -ExecutionPolicy Bypass -File stop-dev.ps1
+```
+
+鑴氭湰浼氳嚜鍔ㄨ烦杩囧凡鍦ㄧ洃鍚殑绔彛锛涘叧鏈哄悗鏈嶅姟鑷劧鍋滄锛屾棤闇�鎵嬪伐澶勭悊銆�
+
+### 1.4 git 宸ヤ綔娴侊紙纭鐭╋級
+
+```powershell
+git fetch origin
+# 鍏堝悎骞惰繙绔� main锛堟湁蹇呰灏辫В鍐茬獊锛岀姝㈠己鎺級
+git add -- <鏀瑰姩鏂囦欢>
+git commit -m "docs: ..."
+git push origin main
+```
+
+---
+
+## 2. 09-22 宸插畬鎴愶紙鎵夸笂锛屽凡鍦ㄨ繙绔級
+
+- **鎶曡祫鏄庣粏琛ㄣ�岃蒋浠剁敓鎴� vs 浜哄伐鐗堛�嶉�愭牸姣斿锛�2026-08锛�**锛�156 鏍煎樊寮傦紝瀹氫綅鍒� 3 绫汇�屼細闈欓粯鍑烘暟銆嶇殑鍙栨暟闂锛堝鍑烘寜椤圭洰鍚嶅尮閰�/搴撳唴鏃犲綋鏈堟暟娌跨敤涓婃湡鍊笺�佸簱鍐呭悓鍚嶅弻妗ｅ彇鍒版棫妗ｃ�佸鍏ヤ涪鏁帮級銆傛姤鍛� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鏁版嵁姣斿鎶ュ憡_鎶曡祫鏄庣粏琛ㄨ蒋浠剁敓鎴愪笌浜哄伐鐗坃2026-09-22.md`銆�
+- **鎶曡祫鍙栨暟淇绗竴杞�**锛氬鍑� 3 澶� + 瀵煎叆 2 澶勶紙鍚柊鍙戠幇鐨勩�屾綔姹熷鍏� 2018 骞村巻鍙� sheet銆嶏級锛屽洖褰掑悗閫愭牸宸紓 **156 鈫� 129**锛屾棤鏂板宸紓锛屾湭瑕嗙洊琛岃兘鑷姩鍛婅銆傛姤鍛� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎶曡祫鏄庣粏琛ㄥ彇鏁颁慨澶峗2026-09-22.md`銆�
+- **姹囨�诲ぇ琛ㄨ蒋浠惰緭鍑� vs 鎵嬪伐瀹氱澶嶆牳锛�2026-08锛�**锛欵xcel 鍏ㄩ噺閲嶇畻鍚庨�愭牸姣斿锛�930 鏉″樊寮備腑瀹炶川鏁板�煎樊寮� 314 鏉★紱鎭� 304 鏉′负銆�2025 绱鍒楀皯鍔� 7銆�8 鏈堛�嶏紙涓氬姟宸茬‘璁よ鍒楀彲娓呯┖锛夛紝10 鏉� `璐ц繍` 鍘嗗彶鍚屾瘮涓氬姟宸茬‘璁よ蒋浠舵纭�傛姤鍛� `docs/闂姹囨��/姹囨�诲ぇ琛╛杞欢杈撳嚭涓庢墜宸ュ畾绋垮樊寮傛竻鍗昣2026-08_20260922.md`锛屾槑缁� CSV 鍚岀洰褰曘��
+- **鏁版嵁鏌ョ湅椤�**锛氳ˉ榻愮綉绾﹁溅鎬绘暟/缃戠害杞﹁鍗�/涓綋瀹㈣繍涓夌被鏌ョ湅鍏ュ彛锛屾柊澧炪�屾寜甯傚窞姹囨�� + 瀵煎嚭 Excel銆嶏紝鍙ｅ緞涓婄Щ绛涢�夈�佺┖鍒楅殣钘忋�佽〃澶磋ˉ鍗曚綅銆�
+- **姹囨�诲ぇ琛ㄥ鍑虹紦瀛�**锛氬鍑虹粨鏋滆惤鐩樼紦瀛橈紙`docs/鐢熸垚姹囨�诲ぇ琛�/_cache/`锛実itignore锛�+ 鏁版嵁鎸囩汗瀹堝崼锛堜緷璧栨簮琛� `CHECKSUM TABLE` + 姣嶇増鏂囦欢韬唤锛屾崲姣嶇増蹇呭け鏁堬級锛屽け鏁堟椂寮圭獥缁欒鏄庛��
+- **Codex 杈撳叆鍗￠】淇澶嶆牳閫氳繃**锛�09-22 閲嶅惎鍚� `Codex++` 瀹堝崼鑴氭湰浠嶅惎鐢紝涓绘覆鏌撹繘绋嬬┖闂� CPU 绾� 13.3%锛堝崟鏍革級锛岃緝淇鍓嶇害 115% 宸茶В鍐炽��
+
+### 2.1 09-23 缁帴锛氭綔姹熸姇璧勭墿娴佹湀鎶ラ噸瀵硷紙鏈鏂板锛�
+
+- 鎸夐仐鐣欓噸瀵兼綔姹熺墿娴� 2026-06銆�2026-07锛涙牳瀵瑰綋鍓嶅簲鐢ㄩ厤缃椂鍙戠幇瀹為檯杩炴帴搴撴槸 `localhost:3305`锛岃�� 09-22 鍔熻兘娴嬭瘯鎶ュ憡璁板綍鐨勯獙璇佸簱鏄� `localhost:3308`銆�
+- 褰撳墠 `3305` 搴撲腑锛屾綔姹� 2026-08 浠嶆寕鏃ч」鐩�滄綔姹熶紶鍖栧叕璺腐椤圭洰鈥濆苟淇濈暀 `5173/12000/5173/1440`锛岃鏄庝笂涓�杞� 08 鏈堜慨姝ｆ湭钀藉埌鏈杩愯搴擄紱`3308` 褰撳墠鏃犳硶杩炴帴銆�
+- 鏈鍙笂浼犳綔姹熷崟鏂囦欢閲嶅 6/7/8 涓変釜鏈堬紝鍧囦负 `success=1`锛涗笁涓湀鍧囨敼涓衡�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥� `11947.9 / 0 / 1135 / 0`銆�
+- 閲嶅閲嶅骞傜瓑锛堟瘡鏈� 1 鏉°��1 涓」鐩�佹棤閲嶅悕涓绘。锛夛紝2026-08 鐗╂祦鏄庣粏瀵煎嚭绗� 180 琛岀鍒扮鏍稿閫氳繃銆�
+- 鎶ュ憡锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_娼滄睙鎶曡祫鐗╂祦鏈堟姤閲嶅_2026-09-23.md`銆�
+
+---
+
+## 3. 鑵捐鏂囨。鍦ㄧ嚎琛ㄦ牸璇诲彇璋冪爺锛堟湰娆″璇濇柊澧烇級
+
+### 3.1 鑳屾櫙
+
+鐢ㄦ埛缁欏畾鍦ㄧ嚎琛ㄦ牸锛堝彧璇诲垎浜摼鎺ワ級锛�
+
+`https://docs.qq.com/sheet/DQ2ZLR09Kcm9ZcUpI?nlc=1&tab=000004`
+
+鏂囨。鍚� **銆�2026骞村崄涓�鏁版嵁銆�**锛屾潈闄�**鍙兘鏌ョ湅**锛屽叡 **10 涓〉绛�**锛氶搧璺�佹皯鑸�侀亾璺�佹按璺�侀珮閫熷叕璺�佹櫘閫氬浗鐪侀亾銆佽惀涓氭�у杩愰噺銆佷汉鍛樻祦鍔ㄩ噺姹囨�汇�佹姤鍘呭姙1銆佹姤鍘呭姙2銆�
+
+### 3.2 瀹炴祴缁撹涓�锛氬垎浜摼鎺ョ殑鍐呭**鍙互璇�**锛堟樉绀哄�煎眰闈級
+
+鍋氭硶锛圕odex 鍐呯疆娴忚鍣� + CUA/Playwright锛屾棤闇�浠讳綍鑵捐璐﹀彿/API锛夛細
+
+1. 鎵撳紑鏂囨。 鈫� 瑙﹀彂銆屾墦鍗般�嶁啋 閫夋嫨銆�**鏁翠釜宸ヤ綔绨�**銆嶁啋 杩涘叆**鎵撳嵃棰勮**锛�
+2. 棰勮鎶婃瘡涓〉绛炬覆鏌撴垚 SVG 鎵撳嵃椤垫锛堟湰娆″疄娴嬪叡 **15 娈�**锛夛紱
+3. 璇诲彇 SVG 涓� `<text>` 鑺傜偣鍗冲彲寰楀埌**褰撳墠鏄剧ず鍊�**锛氳〃澶淬�佹棩鏈熴�佹暟鍊笺�佺櫨鍒嗘瘮锛岃繛 `#DIV/0!` 杩欑閿欒鏂囨湰涔熻兘鎷垮埌銆�
+
+**鑳藉姏杈圭晫锛堝緢閲嶈锛�**锛�
+
+- 鉁� 鑳借锛氬綋鍓�**鏄剧ず鍊�**锛堝惈鎵撳嵃鑼冨洿鍐呯殑琛ㄥご/鏃ユ湡/鏁板��/鐧惧垎姣�/閿欒鏂囨湰锛夈��
+- 鉂� 涓嶈兘璇伙細鍘熷**鍏紡**锛堟嬁鍒扮殑鏄粨鏋滀笉鏄� `=鈥锛夈��
+- 鉂� 涓嶈兘璇伙細**闅愯棌琛屽垪**锛堟墦鍗伴瑙堜笉鍚殣钘忓唴瀹癸級銆�
+- 鉂� 涓嶈兘璇伙細**鎵撳嵃鑼冨洿澶�**鐨勫唴瀹广��
+- 鉂� 涓嶆槗鎭㈠锛氱簿纭� **A1 鍗曞厓鏍煎潗鏍�**锛堟寜鏄剧ず甯冨眬鍒囧垎锛屼笉淇濊瘉涓庡崟鍏冩牸涓�涓�瀵瑰簲锛夈��
+
+### 3.3 瀹炴祴缁撹浜岋細**trafficAudit 鐩墠璇讳笉浜嗗湪绾挎枃妗�**
+
+浠ｇ爜璋冪爺锛堝叏浠撴棤鑵捐鏂囨。/鍒嗕韩閾炬帴/鑵捐 Open API 浠讳綍闆嗘垚锛夛細
+
+- 鍓嶇鍙敮鎸�**鏈湴鏂囦欢涓婁紶**锛歚el-upload`锛屾帴鍙� `.xlsx/.xls/.et`锛堢綉绾﹁溅鎶ュ憡鍙︽湁 `.docx`锛夆�斺�擿traffic-audit-web/src/views/DataImport.vue:57`銆乣DataImport.vue:502`锛�
+- 鍚庣鎺ュ彛鏀� `MultipartFile`鈥斺�擿DataImportController.java:33`锛�
+- 鏈嶅姟灞傜敤 Apache POI `WorkbookFactory.create(file.getInputStream())`鈥斺�擿DataImportService.java:192`锛�
+- 銆岀洰褰曞鍏ャ�嶅彧鎵弿**鏈嶅姟鍣ㄦ湰鍦扮洰褰�**锛屼笉璁块棶澶栫綉銆�
+
+> 缁撹锛氳闈犺蒋浠惰嚜宸辫鍦ㄧ嚎琛ㄦ牸锛�**蹇呴』鏂板闆嗘垚**锛堜笅杩板畼鏂� API 鏄敮涓�姝ｈ璺緞锛夛紱鍚﹀垯鍙兘鍍忔湰娆′竴鏍峰�熷姪娴忚鍣ㄣ�屾墦鍗伴瑙堛�嶄汉宸�/鑴氭湰鎶撴樉绀哄�笺��
+
+### 3.4 瀹炴祴缁撹涓夛細**鑵捐鏂囨。瀹樻柟 API 鍙互鎸夊崟鍏冩牸璇诲彇**锛堟棤闇�澶фā鍨�/OCR锛�
+
+瀹樻柟 Open API锛圴3锛孷2 宸插簾寮冿級鎻愪緵**璇绘寚瀹氳寖鍥�**鎺ュ彛锛�
+
+```http
+GET https://docs.qq.com/openapi/spreadsheet/v3/files/{fileId}/{sheetId}/{range}
+# 渚嬶細/files/ABCDE123abcde/BB08J2/A10:D11
+```
+
+璇锋眰澶达細
+
+```http
+Access-Token: {ACCESS_TOKEN}
+Open-Id: {OPEN_ID}
+Client-Id: {CLIENT_ID}
+Accept: application/json
+```
+
+瑕佺偣锛�
+
+- `range` 鐢� **A1 琛ㄧず娉�**锛岃繑鍥� `gridData.rows[].values[].cellValue`锛�
+- 鏉冮檺闇� `scope.sheet` 鎴� `scope.sheet.readonly`锛�
+- 蹇呴』璧�**鑵捐鏂囨。 OAuth 2.0 鐢ㄦ埛鎺堟潈**鎷垮埌 `Access-Token`/`Open-Id`锛�
+- 鍗曟闄愬埗锛氳 鈮� 1000銆佸垪 鈮� 200銆佹�诲崟鍏冩牸 鈮� 10000锛�
+- **浠呭嚟鍏紑鍒嗕韩閾炬帴銆佹病鏈夊簲鐢ㄥ嚟璇�/OAuth锛屼笉鑳藉尶鍚嶈皟鐢�**锛�
+- 瀹樻柟鏂囨。锛歨ttps://docs.qq.com/open/document/app/openapi/v3/sheet/get/get_range.html
+
+### 3.5 寤鸿锛堣嫢鍚庣画瑕佽惤鍦帮級
+
+- 鍙灏戞暟**宸茬煡鑼冨洿**鐨勬暟鍊� 鈫� 鐩存帴璧�**瀹樻柟 Open API V3**锛堟寜 A1 鑼冨洿璇伙紝绋冲畾銆佸彲鍐欒繘浠ｇ爜锛夈��
+- 娴忚鍣ㄣ�屾墦鍗伴瑙堛�嶅彧浣�**涓存椂/涓�娆℃��**鍙栬瘉鎵嬫锛屼笉瑕佸啓杩涗骇鍝侀�昏緫銆�
+- 鐪熸寮�鍙戝墠闇�鍏堝噯澶囷細鑵捐鏂囨。**寮�鏀惧钩鍙板簲鐢�**锛坄Client-Id`锛�+ **OAuth 鍥炶皟** + 鐢ㄦ埛鎺堟潈锛屽苟纭鐩爣鏂囨。鎵�鍦ㄨ处鍙疯兘鎺堟潈璇ュ簲鐢ㄣ��
+
+---
+
+## 4. 褰撳墠寰呭姙
+
+### 4.1 鎶曡祫鏄庣粏琛紙涓嬩竴杞級
+
+1. **L/D/E/F 鍒楄鐩栧彛寰�**锛氶渶鍏堢‘璁ゃ�婂缓璁鹃樁娈靛綊涓�琛ㄣ�嬶紙婧愯〃銆屼富浣撴柦宸�/绔ｅ伐鏀跺熬/鏈紑宸�/鏈勾姝ｅ紡鏂藉伐/鏆傚仠鏂藉伐/鍓嶆湡銆嶁啋 杈撳嚭鐢ㄨ瘝锛夛紱
+2. **琛ユ簮鏁版嵁**锛氭姹夌墿娴� 8 鏈堟棤鍗曡〃銆侀粍鍐堝杩� 8 鏈堟棤婧愭枃浠讹紙瀵煎嚭宸茶兘鑷姩鍛婅锛屽叡 15 琛屽彈褰卞搷锛夛紱
+3. **娼滄睙 2026-06 / 2026-07 / 2026-08** 鉁� 宸蹭簬 2026-09-23 鍦ㄥ綋鍓嶅簲鐢ㄥ簱 `3305` 鐢ㄥ搴旀湀浠芥簮琛ㄩ噸瀵煎苟瀹屾垚骞傜瓑/瀵煎嚭楠岃瘉锛涘悗缁笉瑕佸啀娌跨敤 09-22 鎶ュ憡鐨� `3308` 楠岃瘉缁撹銆�
+4. 銆屾湭瑕嗙洊琛屾竻鍗曘�嶇洰鍓嶅彧杩� `backend.log` 鈫� 鎸� P1-9 鍋氭垚銆婃牎楠屾姤閿檁<骞存湀>.xlsx銆嬫垨椤甸潰鎻愮ず銆�
+
+### 4.2 姹囨�诲ぇ琛�
+
+- 304 鏍笺��2025 绱鍒楀皯鍔� 7銆�8 鏈堛�嶏細涓氬姟宸茬‘璁よ鍒�**鍙竻绌�**锛岀瓑钀藉疄鐜帮紙娓呯┖/淇瑙勫垯浠ヤ笟鍔℃渶缁堟剰瑙佷负鍑嗭級銆�
+
+### 4.3 鏃㈡湁 P0/P1/P2锛堜笉鍙橈紝瑙� `docs/浜ゆ帴鏂囨。_2026-09-21.md` 搂4锛�
+
+- P0-2銆婁嚎鍏冩姇璧勯」鐩�嬫寜 Q7 杩藉垪锛坄ReportExportService.java:6251` 浠嶅啓鍚屼竴鏍硷級锛�
+- P0-3 瀵煎嚭鍓嶅熀鏁颁綋妫�锛坄getLastMidIssues()` 鏃犺皟鐢ㄦ柟锛夛紱
+- P0-4 2026-06/09 姣嶇増缂哄け锛�
+- P2-2銆屽煄甯傚杩愰〉琛ㄥご浠嶆槸鏃ユ湡搴忓垪鍙枫�嶅彲鑳借繃鏃讹紙浠ｇ爜 09-03 宸插姞 `fixCityMonthHeaderText()`锛夛紝寰呰窇涓�娆� 2026-08 瀵煎嚭鏍稿鍚庡啀鏀癸紱
+- 鍏朵綑 P1/P2 瑙� 09-21 鎬讳氦鎺ユ枃妗ｃ��
+
+---
+
+## 5. 鍏抽敭鏂囦欢涓庡懡浠ょ储寮�
+
+| 鐢ㄩ�� | 璺緞 / 鍛戒护 |
+| --- | --- |
+| 姣忔棩鎬诲叆鍙� | `HANDOFF.md`锛堟湰浠撳簱鏍癸級 |
+| 椤圭洰瑙勭害 | `AGENTS.md`锛堜粨搴撴牴锛� |
+| 绯荤粺鎬讳氦鎺� + P0/P1/P2 | `docs/浜ゆ帴鏂囨。_2026-09-21.md` |
+| 姹囨�诲ぇ琛ㄤ笓椤逛氦鎺� | `docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md` |
+| 姹囨�诲ぇ琛ㄥ樊寮傛竻鍗�/鏄庣粏 | `docs/闂姹囨��/姹囨�诲ぇ琛╛杞欢杈撳嚭涓庢墜宸ュ畾绋垮樊寮傛竻鍗昣2026-08_20260922.md` + 鍚屽悕 CSV |
+| 鎶曡祫姣斿/淇鎶ュ憡 | `docs/鍔熻兘娴嬭瘯鎶ュ憡/鏁版嵁姣斿鎶ュ憡_鎶曡祫鏄庣粏琛ㄨ蒋浠剁敓鎴愪笌浜哄伐鐗坃2026-09-22.md`銆乣docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎶曡祫鏄庣粏琛ㄥ彇鏁颁慨澶峗2026-09-22.md` |
+| 娼滄睙閲嶅楠岃瘉鎶ュ憡 | `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_娼滄睙鎶曡祫鐗╂祦鏈堟姤閲嶅_2026-09-23.md` |
+| 鍘嗗彶闂鍧戠储寮� | `docs/闂姹囨��/闂涓庢敞鎰忎簨椤规眹鎬籣2026-09-16.md` |
+| 姹囨�诲ぇ琛ㄦ瘝鐗� | `docs/鐢熸垚姹囨�诲ぇ琛�/`锛坄{yyyy}骞磠M}鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛� |
+| 鎶曡祫妯℃澘/杈撳叆/杈撳嚭 | `docs/鎶曡祫/妯℃澘/`銆乣docs/鎶曡祫/杈撳叆/鈥銆乣docs/鎶曡祫/杈撳嚭/` |
+| 鍚仠 | `start-dev.ps1` / `stop-dev.ps1`锛堟矙绠卞锛� |
+| 鍚庣/鍓嶇鏃ュ織 | `backend.log`銆乣traffic-audit-web/frontend.log` |
+
+---
+
+*鏈枃鐢� 2026-09-23 浼氳瘽鐢熸垚锛岀敤浜庢柊瀵硅瘽缁帴銆傜郴缁熷叏鏅粛浠� `docs/浜ゆ帴鏂囨。_2026-09-21.md` 涓哄噯銆�*
diff --git "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\212\225\350\265\204\346\230\216\347\273\206\350\241\250\345\217\226\346\225\260\344\277\256\345\244\215_2026-09-22.md" "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\212\225\350\265\204\346\230\216\347\273\206\350\241\250\345\217\226\346\225\260\344\277\256\345\244\215_2026-09-22.md"
index abc52ff..61e54c3 100644
--- "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\212\225\350\265\204\346\230\216\347\273\206\350\241\250\345\217\226\346\225\260\344\277\256\345\244\215_2026-09-22.md"
+++ "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\212\225\350\265\204\346\230\216\347\273\206\350\241\250\345\217\226\346\225\260\344\277\256\345\244\215_2026-09-22.md"
@@ -26,6 +26,8 @@
 - 淇鍚庤蒋浠剁増锛歚_tmp/gen_new_0922/鈥锛堟湰娆￠噸璺戝鍑猴級
 - 姣斿鑴氭湰锛歚_tmp_diff_invest_0922.py`锛堜慨澶嶅墠锛夈�乣_tmp_diff_after_fix_0922.py`锛堜慨澶嶅悗锛�
 
+> **2026-09-23 缁帴鏍稿疄**锛氭湰鎶ュ憡璁板綍鐨勯獙璇佸簱 `localhost:3308` 涓嶆槸褰撳墠搴旂敤瀹為檯杩炴帴搴擄紱褰撳墠 `application.yml` 涓庤繍琛屼腑鍚庣鍧囦娇鐢� `localhost:3305`銆傚湪 `3305` 涓婂鏍告椂锛屾綔姹� 2026-08 浠嶆槸鏃ч」鐩敊鍊硷紝璇存槑鏈姤鍛婂綋鏃剁殑 08 鏈堥噸瀵肩粨鏋滄湭钀藉埌褰撳墠杩愯搴撱�傚凡鍦� 2026-09-23 閲嶅娼滄睙 2026-06/07/08 骞跺畬鎴愬簱鍐�/瀵煎嚭楠岃瘉锛岃瑙� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_娼滄睙鎶曡祫鐗╂祦鏈堟姤閲嶅_2026-09-23.md`銆�
+
 ## 涓夈�佹祴璇曠敤渚嬩笌缁撴灉
 
 | # | 鐢ㄤ緥 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
diff --git "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\275\234\346\261\237\346\212\225\350\265\204\347\211\251\346\265\201\346\234\210\346\212\245\351\207\215\345\257\274_2026-09-23.md" "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\275\234\346\261\237\346\212\225\350\265\204\347\211\251\346\265\201\346\234\210\346\212\245\351\207\215\345\257\274_2026-09-23.md"
new file mode 100644
index 0000000..fef2752
--- /dev/null
+++ "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\275\234\346\261\237\346\212\225\350\265\204\347\211\251\346\265\201\346\234\210\346\212\245\351\207\215\345\257\274_2026-09-23.md"
@@ -0,0 +1,67 @@
+# 鍔熻兘娴嬭瘯鎶ュ憡 鈥� 娼滄睙鐗╂祦鎶曡祫鏈堟姤 2026-06/07/08 閲嶅淇
+
+> 娴嬭瘯鏃ユ湡锛�2026-09-23
+> 琚祴瀵硅薄锛氭姇璧勫競宸炲崟琛ㄥ鍏ワ紙`POST /api/import/batch`锛宍type=investmentLogistics`锛�+ 鐗╂祦绔欏満鎶曡祫鏄庣粏瀵煎嚭
+> 鑳屾櫙锛�09-22 宸蹭慨澶嶁�滄綔姹熷鍘嗗彶 sheet 閫夐敊椤电鈥濓紝浣嗕氦鎺ラ仐鐣欐槑纭姹傞噸瀵� 2026-06/07銆傚鏍稿綋鍓嶅簲鐢ㄥ疄闄呰繛鎺ュ簱鏃跺張鍙戠幇 2026-08 浠嶆槸鏃ч」鐩敊鍊笺��
+
+## 涓�銆佸姛鑳借鏄庝笌鏁版嵁淇
+
+鏈娌℃湁鏀逛笟鍔′唬鐮侊紝浣跨敤鐜版湁閲嶅/骞傜瓑閫昏緫淇褰撳墠搴旂敤搴� `3305/traffic_audit` 鐨勬綔姹熺墿娴� 2026-06銆�2026-07銆�2026-08 鏈堝害鏁版嵁锛�
+
+| 鏈熼棿 | 婧愭枃浠� | 婧愯〃褰撴湡椤电 | 婧愯〃鍏抽敭鍊硷紙H/J/K锛� |
+| --- | --- | --- | --- |
+| 2026-06 | `docs/鎶曡祫/杈撳叆/鐗╂祦锛堢墿娴佸洯鍖猴級/6鏈�/娼滄睙2026.06.xlsx` | `娼滄睙浼犲寲2022.3`锛岃〃鍐呮姤琛ㄦ湡 `2026.06.22` | `11947.9 / 1135 / 0` |
+| 2026-07 | `docs/鎶曡祫/杈撳叆/鐗╂祦锛堢墿娴佸洯鍖猴級/7鏈�/娼滄睙2026.07.xlsx` | `娼滄睙浼犲寲2022.3`锛岃〃鍐呮姤琛ㄦ湡 `2026.07.22` | `11947.9 / 1135 / 0` |
+| 2026-08 | `docs/鎶曡祫/杈撳叆/鐗╂祦锛堢墿娴佸洯鍖猴級/8鏈�/娼滄睙2026.08.xlsx` | `娼滄睙浼犲寲2022.3`锛岃〃鍐呮姤琛ㄦ湡 `2026.08.24` | `11947.9 / 1135 / 0` |
+
+淇鍓嶅綋鍓嶅簲鐢ㄥ簱涓変釜鏈堝潎鎸傛棫椤圭洰鈥滄綔姹熶紶鍖栧叕璺腐椤圭洰鈥濓紝2026-08 涓� `5173 / 12000 / 5173 / 1440`锛涗慨姝ｅ悗涓変釜鏈堝潎鎸傗�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝鏈堝害鍊间负 `start_cum=11947.9 / year_plan=0 / year_cum=1135 / month_done=0 / progress_stage=鍦ㄥ缓`銆�
+
+## 浜屻�佹祴璇曠幆澧�
+
+- 鍚庣锛歚start-dev.ps1` 鍚姩锛�8090 鏃ュ織鍑虹幇 `Started TrafficAuditApplication`銆�
+- 鏁版嵁搴擄細`jdbc:mysql://localhost:3305/traffic_audit`锛宍root/root`銆�
+- 鐧诲綍锛歚admin/123456`锛岄獙璇佺爜閰嶇疆 `required=false`銆�
+- 瀵煎叆鏂瑰紡锛氬彧涓婁紶瀵瑰簲鏈堜唤鐨勬綔姹熷崟鏂囦欢锛岄伩鍏嶅叏鐩綍瀵煎叆鏀瑰姩鍏朵粬甯傚窞銆�
+- 瀵煎嚭楠岃瘉锛歚GET /api/report/export/investLogisticsDetail?period=2026-08&mode=month`銆�
+
+## 涓夈�佹祴璇曠敤渚嬩笌缁撴灉
+
+| # | 鐢ㄤ緥 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- | --- |
+| 1 | 2026-06 姝ｅ悜閲嶅 | `娼滄睙2026.06.xlsx` | 閫夊綋鏈熼〉锛屾垚鍔� 1 鏉� | 鎺ュ彛 `success=1`锛涘簱鍐呴」鐩�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝鍊� `11947.9 / 0 / 1135 / 0` | 鉁� |
+| 2 | 2026-07 姝ｅ悜閲嶅 | `娼滄睙2026.07.xlsx` | 閫夊綋鏈熼〉锛屾垚鍔� 1 鏉� | 鎺ュ彛 `success=1`锛涘簱鍐呴」鐩�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝鍊� `11947.9 / 0 / 1135 / 0` | 鉁� |
+| 3 | 2026-08 涓�鑷存�т慨姝� | `娼滄睙2026.08.xlsx` | 褰撳墠搴旂敤搴撲笉鍐嶄繚鐣欐棫椤圭洰閿欏�� | 鎺ュ彛 `success=1`锛涘簱鍐呮敼涓衡�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝鍊� `11947.9 / 0 / 1135 / 0` | 鉁� |
+| 4 | 璐熷悜-鍘嗗彶椤电涓嶆硠婕� | 涓変唤鏂囦欢鍧囧惈 2018/2019 绛夊巻鍙� sheet | 涓嶅緱瀵煎叆鈥滄綔姹熶紶鍖栧叕璺腐椤圭洰鈥濈殑鍘嗗彶琛� | 涓変釜鏈堝簱鍐呭潎鏃犺椤圭洰鏈堝害璁板綍锛涢�変腑椤靛潎浠ヨ〃鍐� `2026.xx.xx` 鎶ヨ〃鏈熷懡涓� | 鉁� |
+| 5 | 鍏ュ簱鎶芥煡 | 涓変唤婧愯〃褰撳墠椤� H/J/K | 搴撳唴閫愰」涓�鑷� | 6/7/8 鏈堝潎涓� `11947.9 / 1135 / 0`锛岄」鐩悕銆佸缓璁鹃樁娈典竴鑷� | 鉁� |
+| 6 | 骞傜瓑-閲嶅閲嶅 | 涓変唤鏂囦欢鍚勫啀瀵煎叆涓�娆� | 涓嶆柊澧為噸澶嶆湀搴﹁鎴栭噸澶嶉」鐩� | 6/7/8 鏈堝悇淇濇寔 `monthly_rows=1`銆乣projects=1`锛涙綔姹熼噸鍚嶉」鐩暟 `0` | 鉁� |
+| 7 | 绔埌绔鍑� | 2026-08 鐗╂祦绔欏満鎶曡祫鏄庣粏 | 娼滄睙琛屽彇鏂板�硷紝涓嶇粨杞棫鍊� | 杈撳嚭 `_tmp/qa_qianjiang_20260923/鐢熸垚_鐗╂祦绔欏満鎶曡祫鏄庣粏_2026-08.xls`锛宍鍒嗛」鐩姇璧勫畬鎴愭儏鍐礰 绗� 180 琛屼负鈥滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝閲戦 `11947.9 / 1135 / 0` | 鉁� |
+
+## 鍥涖�佸叧閿彂鐜帮細楠岃瘉搴撲笌搴旂敤瀹為檯杩炴帴搴撲笉涓�鑷�
+
+- 褰撳墠杩愯閰嶇疆 `traffic-audit-server/src/main/resources/application.yml` 鎸囧悜 `localhost:3305/traffic_audit`銆�
+- 09-22銆婂姛鑳芥祴璇曟姤鍛奯鎶曡祫鏄庣粏琛ㄥ彇鏁颁慨澶嶃�嬭褰曠殑楠岃瘉鐜鏄� `localhost:3308/traffic_audit`銆�
+- 鏈鐩存帴鏌ヨ褰撳墠搴旂敤搴� `3305` 鏃讹紝娼滄睙 2026-08 浠嶆槸鏃ч」鐩� `5173/12000/5173/1440`锛岃鏄� 09-22 鐨� 08 鏈堜慨姝ｆ病鏈夊弽鏄犲埌鏈瀹為檯杩愯搴撱�俙3308` 褰撳墠鏃犳硶杩炴帴锛圚TTP/MySQL 杩炴帴琚嫆缁濓級锛屽洜姝や笉鑳界户缁互璇ュ簱浣滀负浜や粯楠屾敹渚濇嵁銆�
+- 澶勭悊锛氭湰娆″湪鍚屼竴鍚庣浼氳瘽涓噸瀵� 6/7/8 涓変釜鏈堬紝骞跺湪 `3305` 涓婂畬鎴愬簱鍐呮娊鏌ュ拰 2026-08 绔埌绔鍑洪獙璇併��
+
+## 浜斻�佹暟鎹彉鏇磋鏄�
+
+| 琛� | 鏈熼棿 | 淇鍓� | 淇鍚� |
+| --- | --- | --- | --- |
+| `investment_monthly` | 2026-06 | 娼滄睙浼犲寲鍏矾娓」鐩� `3685/12000/3685/1520` | 涓浗铏捐胺鍐烽摼浠撳偍鐗╂祦鍥� `11947.9/0/1135/0` |
+| `investment_monthly` | 2026-07 | 娼滄睙浼犲寲鍏矾娓」鐩� `3733/12000/3733/48` | 涓浗铏捐胺鍐烽摼浠撳偍鐗╂祦鍥� `11947.9/0/1135/0` |
+| `investment_monthly` | 2026-08 | 娼滄睙浼犲寲鍏矾娓」鐩� `5173/12000/5173/1440` | 涓浗铏捐胺鍐烽摼浠撳偍鐗╂祦鍥� `11947.9/0/1135/0` |
+
+- 鏈垹闄や换浣� `investment_project` 涓绘。锛涙棫椤圭洰涓绘。 `id=108` 淇濈暀锛屼絾鍏� 6/7/8 鏈堟棫鏈堝害璁板綍宸叉寜甯傚窞+绫诲埆+鏈熼棿娓呯悊銆�
+- 鏂板椤圭洰涓绘。 `id=276`锛岀被鍒� `鐗╂祦鍥尯`锛屽悗缁笁涓湀澶嶇敤鍚屼竴鏉′富妗ｃ��
+- 鏈敼鍔ㄥ叾浠栧競宸炪�佸叾浠栨湡闂淬�佸叾浠栨姇璧勭被鍒��
+
+## 鍏�侀仐鐣欓棶棰樹笌涓嬩竴姝�
+
+1. 鎶曡祫鏄庣粏琛� L/D/E/F 鍒楄鐩栧彛寰勪粛闇�銆婂缓璁鹃樁娈靛綊涓�琛ㄣ�嬪悗纭銆�
+2. 姝︽眽鐗╂祦 8 鏈堛�侀粍鍐堝杩� 8 鏈堟簮鏁版嵁浠嶆湭琛ラ綈銆�
+3. P0 椤逛笉鍙橈細浜垮厓鎶曡祫椤圭洰鎸� Q7 杩藉垪銆佸鍑哄墠鍩烘暟浣撴銆�2026-09 姣嶇増銆�
+4. 鍚庣画鍐欐祴璇�/浜ゆ帴鏂囨。鏃讹紝蹇呴』鍏堣鍙栧綋鍓� `application.yml` 鎴栬繍琛屼腑杩涚▼閰嶇疆锛屼笉鑳芥部鐢ㄤ笂涓�杞姤鍛婄殑鏁版嵁搴撶鍙ｄ綔涓洪獙鏀剁幆澧冦��
+
+## 涓冦�佺粨璁�
+
+娼滄睙鐗╂祦鎶曡祫 2026-06銆�2026-07 鍘嗗彶閿欏�煎凡淇锛涘悓鏃跺彂鐜板苟淇浜嗗綋鍓嶅簲鐢ㄥ簱閬楁紡鐨� 2026-08 閿欏�笺�備笁涓湀閲嶅鍧囨垚鍔燂紝鍘嗗彶椤电鏈硠婕忥紝閲嶅瀵煎叆淇濇寔骞傜瓑锛�2026-08 瀵煎嚭绔埌绔彇鍊兼纭��
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-23.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-23.md"
new file mode 100644
index 0000000..1c37b22
--- /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-23.md"
@@ -0,0 +1,69 @@
+# 宸ヤ綔鏃ョ粨_2026-09-23
+
+## 涓�銆佷粖澶╁仛浜嗕粈涔�
+
+### 1. 鎷夊彇骞跺悓姝ュ叕鍙镐粨搴撴渶鏂帮紙鏈敼涓氬姟浠ｇ爜锛�
+
+- `git fetch origin` 鍚庡彂鐜拌繙绔湁鏂版彁浜わ紝宸�**蹇繘鍚堝苟** `origin/main` 鍒版湰鍦帮細
+  - `8b739ce docs(浜ゆ帴): 缁熶竴 09-22 鍏虫満蹇収锛堝悎骞跺悓浜嬬増鏈紝淇杩愯鐘舵�佷负瀹炴祴锛�8090/8080 鍦ㄨ繍琛岋級`
+  - `23f2d2c Merge remote-tracking branch 'origin/main'`
+  - `48350f7 docs(浜ゆ帴): 09-22 鍏虫満浜ゆ帴蹇収锛堟姇璧勬瘮瀵逛笌鍙栨暟淇浜や粯銆佽繍琛岀姸鎬併�佹帴鎵嬩紭鍏堥」锛塦
+- 鍚堝苟鍚� `HEAD = 8b739ce = origin/main`锛屽伐浣滃尯骞插噣銆佹棤鏈窡韪枃浠躲��
+
+### 2. 鏍稿褰撴棩杩愯鐘舵��
+
+- dev 鍚庣 8090锛�**鏈繍琛�**锛堟棤 java 杩涚▼锛沗backend.log` 鏈�鍚庡啓鍏� 09-21 17:29锛夈��
+- dev 鍓嶇 8080锛�**鏈繍琛�**锛坄frontend.log` 鏈�鍚庡啓鍏� 09-21 17:36锛夈��
+- MySQL锛氭湰鏈� `MySQL57`銆乣MySQL80` 鏈嶅姟鍧� **Running**锛堝簱 `traffic_audit`锛宍localhost:3305`锛宍root/root`锛夈��
+- 鍏跺畠 node/cmd 杩涚▼涓� Codex 鑷韩缁勪欢锛屾湭瑙︾銆�
+
+### 3. 鑵捐鏂囨。鍦ㄧ嚎琛ㄦ牸璇诲彇璋冪爺锛堟湰娆″璇濅富瑕佷骇鍑猴級
+
+鐢ㄦ埛缁欏畾鍙鍒嗕韩閾炬帴 `https://docs.qq.com/sheet/DQ2ZLR09Kcm9ZcUpI?nlc=1&tab=000004`锛岄棶棰橀摼锛氳兘涓嶈兘璇� 鈫� 鑳戒笉鑳借鍏ㄩ儴椤电 鈫� 鑳戒笉鑳藉彧璇绘煇浜涘崟鍏冩牸 鈫� 涓嶅�熷姪澶фā鍨� trafficAudit 鑳戒笉鑳借 鈫� 鑵捐瀹樻柟 API 琛屼笉琛屻�傞�愭潯璋冪爺缁撹锛�
+
+- **鑳借**锛氭枃妗ｅ悕銆�2026骞村崄涓�鏁版嵁銆嬶紝鍙锛屽叡 10 椤电锛堥搧璺�/姘戣埅/閬撹矾/姘磋矾/楂橀�熷叕璺�/鏅�氬浗鐪侀亾/钀ヤ笟鎬у杩愰噺/浜哄憳娴佸姩閲忔眹鎬�/鎶ュ巺鍔�1/鎶ュ巺鍔�2锛夈�傛柟寮忎负鎵撳紑鏂囨。 鈫� 鎵撳嵃 鈫� 銆屾暣涓伐浣滅翱銆嶁啋 鎵撳嵃棰勮锛岄瑙堟覆鏌撳嚭 15 涓� SVG 椤垫锛岃鍙栧叾涓� `<text>` 鑺傜偣鍗冲緱**鏄剧ず鍊�**锛堝惈琛ㄥご/鏃ユ湡/鏁板��/鐧惧垎姣�/`#DIV/0!`锛夈��
+- **鑳藉姏杈圭晫**锛氳鐨勬槸鏄剧ず鍊硷紱璇讳笉鍒板師濮嬪叕寮忋�侀殣钘忚鍒椼�佹墦鍗拌寖鍥村鍐呭锛涗笉鏄撴仮澶嶇簿纭� A1 鍧愭爣銆�
+- **trafficAudit 鐩墠涓嶆敮鎸�**锛氬叏浠撴棤鑵捐鏂囨。/鍒嗕韩閾炬帴/Open API 闆嗘垚锛涘鍏ュ彧璧版湰鍦版枃浠朵笂浼狅紙`el-upload`锛宍.xlsx/.xls/.et`锛夛紝鍚庣 `MultipartFile` + Apache POI `WorkbookFactory.create`锛涚洰褰曞鍏ュ彧鎵湇鍔″櫒鏈湴鐩綍銆�
+- **鑵捐瀹樻柟 API 鍙**锛歄pen API V3 鏀寔鎸� A1 鑼冨洿璇诲崟鍏冩牸锛坄GET /openapi/spreadsheet/v3/files/{fileId}/{sheetId}/{range}`锛岃繑鍥� `gridData.rows[].values[].cellValue`锛夛紝浣嗛渶 OAuth 2.0 鐢ㄦ埛鎺堟潈 + 搴旂敤鍑瘉锛坄Client-Id`/`Access-Token`/`Open-Id`锛�+ `scope.sheet(.readonly)`锛涘崟娆¤ 鈮�1000銆佸垪 鈮�200銆佹�诲崟鍏冩牸 鈮�10000锛涗粎鍑垎浜摼鎺ヤ笉鑳藉尶鍚嶈皟鐢ㄣ��
+- **寤鸿**锛氳惤浜у搧璧板畼鏂� Open API V3锛涙祻瑙堝櫒鎵撳嵃棰勮鍙綔涓�娆℃�у彇璇併��
+
+### 4. 鍐欏嚭 09-23 浜ゆ帴鏂囨。锛堜緵鏂板璇濈画鎺ワ級
+
+- 鏂板 `docs/浜ゆ帴鏂囨。_2026-09-23.md`锛氱幇鐘跺揩鐓э紙git/杩涚▼/鍚姩鍛戒护/git 宸ヤ綔娴侊級銆�09-22 宸插畬鎴愭憳瑕併�佽吘璁枃妗ｈ鍙栬皟鐮斿叏缁撹銆佸綋鍓嶅緟鍔炪�佸叧閿枃浠朵笌鍛戒护绱㈠紩銆�
+- 鏇存柊 `HANDOFF.md` 椤堕儴銆屾渶鏂般�嶈妭锛屽姞 09-23 鍏ュ彛锛屾寚鍚戞柊浜ゆ帴鏂囨。銆�
+
+### 5. 娼滄睙鐗╂祦鎶曡祫鏈堟姤閲嶅淇锛堟柊澧烇級
+
+- 鎸変氦鎺ラ仐鐣欓噸瀵兼綔姹熺墿娴� 2026-06銆�2026-07锛涙牳瀵瑰綋鍓嶈繍琛岄厤缃椂鍙戠幇搴旂敤瀹為檯杩炴帴 `3305/traffic_audit`锛岃�� 09-22 鎶ュ憡楠屾敹璁板綍鍐欑殑鏄� `3308`锛屽綋鍓� `3305` 搴撶殑 2026-08 浠嶆槸鏃ч」鐩敊鍊笺��
+- 鍙笂浼犲悇鏈堟綔姹熷崟鏂囦欢閲嶅 6/7/8 涓変釜鏈堬紝鎺ュ彛鍧囦负 `success=1`锛涗笁涓湀鍧囨敼涓衡�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝鏈堝害鍊� `11947.9 / 0 / 1135 / 0`銆�
+- 閲嶅瀵煎叆涓�娆￠獙璇佸箓绛夛細6/7/8 鏈堝悇淇濇寔 1 鏉℃湀搴︽暟鎹��1 涓」鐩紝娼滄睙閲嶅悕椤圭洰鏁� 0锛�2026-08 鐗╂祦鏄庣粏瀵煎嚭绗� 180 琛屽彇鍊兼纭��
+- 鎶ュ憡锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_娼滄睙鎶曡祫鐗╂祦鏈堟姤閲嶅_2026-09-23.md`銆�
+
+## 浜屻�佹祴璇曠粨鏋滄憳瑕�
+
+- 浠婃棩**鏃犱笟鍔′唬鐮佹敼鍔�**锛涙柊澧炰竴娆℃暟鎹噸瀵煎姛鑳芥祴璇曪紝姝ｅ悜銆佸巻鍙查〉绛捐礋鍚戙�佸叆搴撴娊鏌ャ�佸箓绛変笌瀵煎嚭楠岃瘉鍏ㄩ儴閫氳繃銆�
+- 鏂囨。/璋冪爺绫讳骇鍑猴細`git fetch` 鍚堝苟缁撴灉銆佽繍琛岀姸鎬佸疄娴嬨�佽吘璁枃妗ｈ鍙栦笁缁勭粨璁哄潎缁忓疄闄呴獙璇侊紙娴忚鍣ㄥ疄娴嬭鍊� + 鍏ㄤ粨浠ｇ爜妫�绱� + 瀹樻柟鏂囨。鏍稿锛夈��
+- 娼滄睙鐗╂祦鎶曡祫 2026-06/07/08 涓変釜鏈堝凡涓庢簮琛ㄩ�愰」瀵归綈锛�2026-08 瀵煎嚭绔埌绔彇鍊兼纭�傛祴璇曟姤鍛婅 `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_娼滄睙鎶曡祫鐗╂祦鏈堟姤閲嶅_2026-09-23.md`銆�
+- 鍚堝苟鍚庡伐浣滃尯骞插噣锛涙棤缂栬瘧/鍥炲綊椋庨櫓锛堟湭瑙︾ Java/Vue 婧愮爜锛夈��
+
+## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙
+
+1. **鎶曡祫鏄庣粏琛ㄤ笅涓�杞�**锛氭綔姹� 2026-06/07/08 閲嶅宸查棴鐜紱鍓╀綑 L/D/E/F 瑕嗙洊鍙ｅ緞锛堥渶銆婂缓璁鹃樁娈靛綊涓�琛ㄣ�嬶級銆佽ˉ姝︽眽鐗╂祦 8 鏈堝崟琛ㄣ�侀粍鍐堝杩� 8 鏈堟簮鏂囦欢銆佹湭瑕嗙洊琛屾竻鍗曞嚭鏂囦欢/椤甸潰鎻愮ず锛圥1-9锛夈��
+2. **姹囨�诲ぇ琛�**锛�304 鏍笺��2025 绱鍒楀皯鍔� 7銆�8 鏈堛�嶄笟鍔″凡纭鍙竻绌猴紝寰呰惤瀹炪��
+3. **P0 涓嶅彉**锛氫嚎鍏冩姇璧勯」鐩寜 Q7 杩藉垪锛圥0-2锛夛紱瀵煎嚭鍓嶅熀鏁颁綋妫�锛圥0-3锛夛紱2026-06/09 姣嶇増缂哄け锛圥0-4锛夈��
+4. **P2-2 寰呮牳瀹�**锛氬煄甯傚杩愰〉琛ㄥご鏃ユ湡搴忓垪鍙峰彲鑳藉凡鐢� `fixCityMonthHeaderText()` 淇ソ锛岃窇涓�娆� 2026-08 瀵煎嚭纭鍚庡啀鏀规枃妗ｃ��
+5. **娼滃湪鏂伴渶姹傦紙鏈珛椤癸級**锛氳吘璁枃妗ｅ湪绾胯〃鏍煎鍏ワ紙瀹樻柟 Open API V3 + OAuth锛夛紝濡傞渶寮�鍙戦渶鍏堝噯澶囧紑鏀惧钩鍙板簲鐢ㄤ笌鎺堟潈銆�
+
+## 鍥涖�佹槑澶╄鍒�
+
+1. 鎸夌敤鎴蜂紭鍏堢骇鎺ㄨ繘鎶曡祫鏄庣粏琛ㄤ笅涓�杞紙鍏堝悜鐢ㄦ埛/涓氬姟纭銆婂缓璁鹃樁娈靛綊涓�琛ㄣ�嬪彛寰勶紝鍐嶅姩瑕嗙洊閫昏緫锛夈��
+2. 琛ユ姹夌墿娴� 8 鏈堛�侀粍鍐堝杩� 8 鏈堟簮鏁版嵁锛涚户缁帹杩� L/D/E/F 鍙ｅ緞涓庢湭瑕嗙洊娓呭崟钀芥枃浠躲��
+3. 璺戜竴娆� 2026-08 姹囨�诲ぇ琛ㄥ鍑猴紝鏍稿 P2-2 鍩庡競瀹㈣繍琛ㄥご鍚庡啀鏇存柊鏂囨。銆�
+4. 瑙嗙敤鎴烽渶瑕侊紝璇勪及鑵捐鏂囨。 Open API 璇诲彇鐨勬渶灏忓彲鐢ㄥ疄鐜帮紙浠呰鎸囧畾鍗曞厓鏍艰寖鍥达級銆�
+
+## 浜斻�佸叧鏈�/浜ゆ帴蹇収锛�2026-09-23 08:52 缁帴鏇存柊锛�
+
+- **git**锛氬熀绾� `main = 8b739ce`锛屽凡鍚屾 `origin/main`锛涙湰娆＄画鎺ユ柊澧炴綔姹熼噸瀵兼祴璇曟姤鍛婂苟鏇存柊鏃ョ粨銆丠ANDOFF銆�09-23 浜ゆ帴鏂囨。銆�
+- **杩愯鐘舵�侊紙09-23 08:50 瀹炴祴锛�**锛歞ev 鍚庣 8090銆佸墠绔� 8080 宸插惎鍔ㄥ苟灏辩华锛涘簲鐢ㄥ疄闄呮暟鎹簱涓� `localhost:3305/traffic_audit`銆�
+- **涓嬫鍚姩**锛氶」鐩牴 `powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1`锛堟矙绠卞锛夈��
+- **鏂板璇濆叆鍙�**锛氳銆岃 HANDOFF.md 缁х画銆嶁啋 HANDOFF.md 鈫� AGENTS.md 鈫� `docs/浜ゆ帴鏂囨。_2026-09-23.md`锛堟湰娆″閲忥級鈫� `docs/浜ゆ帴鏂囨。_2026-09-21.md`锛堢郴缁熷叏鏅� + P0/P1/P2锛夈��

--
Gitblit v1.9.1