From ceaa5f2895b71b9dedfe543ae3a0927f912556ab Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期一, 21 九月 2026 17:28:35 +0800
Subject: [PATCH] docs: 仓库约定改为只用公司 gitea 单仓库（AGENTS 第3/4条）

---
 docs/交接文档_2026-09-21.md |  324 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 324 insertions(+), 0 deletions(-)

diff --git "a/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-21.md" "b/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-21.md"
new file mode 100644
index 0000000..f04d309
--- /dev/null
+++ "b/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-21.md"
@@ -0,0 +1,324 @@
+# 浜ら�氳揣杩愮粺璁″鏍哥郴缁� 鈥斺�� 鎬讳氦鎺ユ枃妗ｏ紙2026-09-21锛�
+
+> **鐢ㄩ��**锛氭帴鎵嬩汉锛堝紑鍙�/杩愮淮/涓氬姟瀵规帴锛夊湪涓嶉棶浜虹殑鍓嶆彁涓嬶紝鑳界嫭绔嬭窇璧锋潵銆佺湅鎳傛灦鏋勩�佺煡閬撳摢浜涙椿娌″共瀹屻�佸摢浜涘潙涓嶈兘鍐嶈俯銆�
+> **璇昏��**锛氭帴鎵嬫湰绯荤粺鐨勫悓浜� / 鍚庣画鎺ユ墜鐨� AI 浼氳瘽銆�
+> **缁存姢绾﹀畾**锛氭瘡瀹屾垚涓�椤瑰氨鎶婄 4 绔犲搴旀潯鐩殑銆岀姸鎬併�嶆敼鎴� 鉁� 骞舵敞鏄庢棩鏈燂紱鏂伴棶棰樼洿鎺ヨ拷鍔狅紝鍒彟璧锋柊鏂囦欢銆�
+> **鏈枃涓庡叾瀹冩枃妗ｇ殑鍏崇郴**锛氭湰鏂囨槸**鍞竴鍏ュ彛**锛涙眹鎬诲ぇ琛ㄩ偅鏉＄嚎鐨勭粏鑺傚湪 `docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`锛堟湰鏂囩 4 绔犲彧鍋氭憳瑕侊紝涓嶉噸澶嶆鏂囷級锛�
+> 鍘嗗彶鍧戠储寮曞湪 `docs/闂姹囨��/闂涓庢敞鎰忎簨椤规眹鎬籣2026-09-16.md`銆�
+
+---
+
+## 0. 鍏堣杩欎竴椤碉紙鎺ユ墜鐨勭 1 灏忔椂锛�
+
+1. **鍏堟妸绯荤粺璺戣捣鏉�**锛屽啀璋堟敼浠ｇ爜銆傝 搂7.1锛堜竴閿剼鏈紝蹇呴』鍦ㄦ矙绠卞鎵ц锛夈��
+2. **褰撳墠鏈�绱ф�ョ殑 4 浠朵簨**锛堣瑙� 搂4 P0锛夛細鈶� 銆婁嚎鍏冩姇璧勯」鐩�嬫湀浠藉垪姣忔湀瑕嗙洊涓婃湀锛堢敤鎴� Q7 瑕佺殑銆屽姞涓�鍒椼�嶆湭鍋氾級锛�
+   鈶� 瀵煎嚭鍓嶃�屽熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉銆嶅彧鍋氫簡涓�鍗婏紱鈶� 缂� 2026-06 / 2026-09 姣嶇増锛岄偅涓ゆ湡鍑轰笉浜嗚〃锛�
+   鈶� 姹囨�诲ぇ琛ㄣ�屼腑鍙ｅ緞鎺掑悕 vs 涓彛寰勬槑缁嗐�嶅巻鍙插悓姣斿熀鏁板弻杞ㄥ埗锛�16 涓競宸炴湁宸級銆�
+   > 鍘熴��8 鏈堝崄鍫扮墿娴佹簮鏂囦欢鍚潪鍗佸牥娈点�嶅凡浜� 2026-09-21 闂幆锛岃 搂4 P0-1銆�
+3. **鍒嚜宸辨媿鏉夸笟鍔″彛寰�**锛岀 5 绔犲垪鐨勬槸蹇呴』涓氬姟纭鐨勪簨銆�
+4. 鏀瑰畬蹇呴』锛氬啓銆婂姛鑳芥祴璇曟姤鍛娿�嬧啋 鏇存柊銆婂伐浣滄棩缁撱�嬧啋 鍙屼粨搴撴帹閫侊紙搂7.4锛夈�傝繖鏄湰椤圭洰鐨勭‖瑙勭煩銆�
+
+---
+
+## 1. 鐜扮姸蹇収锛�2026-09-21 涓婂崍瀹炴祴锛�
+
+### 1.1 鏈嶅姟涓庤繘绋�
+
+| 椤� | 鍊� |
+| --- | --- |
+| 鍚庣 | Spring Boot锛岀鍙� **8090**锛屾棩蹇� `backend.log`锛堜粨搴撴牴锛夛紱浠婃櫒鏈夊鍑哄姩浣滐紙PID 31328锛�09:17锛� |
+| 鍓嶇 | Vue2 + Element UI锛岀鍙� **8080**锛屾棩蹇� `traffic-audit-web/frontend.log`锛堜粖鏅� 08:30锛� |
+| 鏁版嵁搴� | MySQL `127.0.0.1:3308`锛屽簱 `traffic_audit`锛岃处鍙� `root/123456`锛涘鎴风 `D:\mysql\mysql-5.7.41-winx64\bin\mysql.exe` |
+| 鍚仠 | `powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1` / `stop-dev.ps1`锛�**蹇呴』娌欑澶栵紙鎻愭潈锛夎繍琛�** |
+
+> 鍒ゆ柇鏈嶅姟鏄惁璧锋潵锛�**鍙湅鏃ュ織**锛堝悗绔� `Started TrafficAuditApplication` + `Tomcat started on port(s): 8090`锛涘墠绔� `App running at`锛夈��
+> 娌欑鍐� `Get-NetTCPConnection` 浼氶潤榛樺け璐ワ紝鎹鍒ゆ柇浼氳鍒ゃ��
+
+### 1.2 鏁版嵁搴撶幇鐘讹紙`SELECT COUNT(*)`锛�
+
+| 琛� | 琛屾暟 | 璇存槑 |
+| --- | --- | --- |
+| `investment_project` | **152** | 鎶曡祫涓绘。锛堝杩愮珯鍦� + 鐗╂祦鍥尯锛� |
+| `investment_monthly` | **284** | 2026-06: 76 / 2026-07: 72 / **2026-08: 136** |
+| `freight_turnover_import` | **234** | 18 琛�/鏈� 脳 13 鏈燂紙2021-12 ~ 2026-08锛� |
+| `h2031_enterprise_monthly` | 15811 | 鍏矾鏃呭锛堜腑鍙ｅ緞缁村害 1 鐨勬潵婧愪箣涓�锛� |
+| `h2032_enterprise_monthly` | 13056 | 璐ц繍浼佷笟鏈堟姤 |
+| `investment_system` | 2026-07: 148 / **2026-08: 129** | 鎶曡祫绯荤粺瀵煎嚭锛堟姇璧勫鏍哥殑姣斿鍩哄噯锛夛紱08 鏈熺敤**鏂版ā鏉�**瀵煎叆 |
+| `import_batch` | 417 | 瀵煎叆鎵规鍙拌处锛堝紓姝ュ鍑虹殑銆屾暟鎹増鏈畧鍗�嶇敤瀹冿級 |
+
+- **2026-09 鑴忔湡宸叉竻鐞嗗共鍑�**锛堟湰娆℃牳瀹烇細`h204_vehicle_quarterly` 鍙湁 2026-07/08锛沗audit_run`/`audit_result` 鍙湁 2026-05~08锛沗investment_monthly` 鍙湁 06~08锛夈��
+  姝ゅ墠 09-16 璁板綍鐨勩��2026-09 鏈� 1284/31/2061/3 琛岃剰鏁版嵁銆�**宸茶В鍐�**銆�
+- 鎶ヨ〃鏈熷垎甯冩槸銆�**2021-12 杩欑被鏈熷瓨鍏ㄥ勾 1-12 鏈�**銆嶇殑璇箟锛堜笉鏄� 12 鏈堝崟鏈堬級锛岃 搂3.1銆�
+
+### 1.3 浠ｇ爜浠撳簱
+
+| 椤� | 鍊� |
+| --- | --- |
+| 宸ヤ綔鍖� | `D:\鏂囨。\ChatGPT\traffic-audit`锛屽垎鏀� `main` |
+| HEAD | `a08c70d feat(鎶曡祫): 甯傚窞鏈堟姤缁熶竴濉姤妯℃澘 + 鍘�(甯傘�佸尯)鍒楄В鏋� + 琛ㄥご琛屽垽瀹氭敹绱 |
+| 涓汉杩滅 | `origin` 鈫� `https://gitee.com/zhizhijie/traffic-audit.git`锛堝垎鏀� `master`锛� |
+| 鍏徃杩滅 | `gitea` 鈫� `http://61.183.254.94:3000/r/trafficAudit.git`锛堝垎鏀� `main`锛岃处鍙� zyj锛� |
+| 宸ヤ綔鍖虹姸鎬� | 骞插噣锛堜氦鎺ユ枃妗ｃ�佹眹鎬诲ぇ琛ㄩ棶棰樹氦鎺ャ�佹棩缁撱�佹姇璧勭郴缁熸柊妯℃澘鏀寔鍧囧凡鎻愪氦骞舵帹閫佷袱绔級 |
+
+### 1.4 鍏抽敭鐩綍
+
+| 璺緞 | 鍐呭 |
+| --- | --- |
+| `docs/鐢熸垚姹囨�诲ぇ琛�/` | **姹囨�诲ぇ琛ㄦ瘝鐗�**锛坄{yyyy}骞磠M}鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛�+ `_bak_`/`_澶囦唤_` 鍘嗗彶浠讹紙**鏈粡鍚屾剰涓嶈鍒�**锛� |
+| `docs/鎶曡祫/妯℃澘/` | 鎶曡祫 5 寮犺〃鐨勬瘝鐗� + 2 浠芥柊甯傚窞濉姤妯℃澘 |
+| `docs/鎶曡祫/杈撳叆/{瀹㈣繍锛堝杩愮珯锛�,鐗╂祦锛堢墿娴佸洯鍖猴級}/{N}鏈�/` | 甯傚窞鏈堟姤婧愭枃浠讹紙绋嬪簭鎸夈�屾姤琛ㄦ湡 鈫� `{N}鏈坄銆嶇洰褰曡嚜鍔ㄦ壂鎻忥級 |
+| `docs/鎶曡祫/杈撳嚭/` | 瑙ｆ瀽/鏍￠獙/娓呯悊鎶ュ憡銆佸浠� |
+| `docs/鍔熻兘娴嬭瘯鎶ュ憡/`銆乣docs/宸ヤ綔鏃ョ粨/`銆乣docs/闂姹囨��/` | 浜や粯鐗╀笌闂鍙拌处锛堢‖瑙勭煩锛岃 搂7.4锛� |
+| `_tmp/_qa_out/`銆乣_tmp/qa_wh/` | 鎺掓煡鑴氭湰涓庤瘉鎹紙gitignore锛屼笉鍏ュ簱锛夛紱`_pylibs/` 鏀� openpyxl / xlrd |
+
+---
+
+## 2. 绯荤粺缁撴瀯
+
+### 2.1 鎶�鏈爤
+
+- 鍚庣锛歋pring Boot锛坄traffic-audit-server`锛孧aven锛夛紝MySQL 8.0锛孉pache POI锛圚SSF 澶勭悊 .xls / XSSF 澶勭悊 .xlsx锛夈��
+- 鍓嶇锛歏ue 2 + Element UI锛坄traffic-audit-web`锛寁ue-cli锛夛紝`/api` 浠ｇ悊鍒� 8090銆�
+- 鎶ヨ〃涓ょ褰㈡�侊細**鏁版嵁婧愯〃**锛堝鍏ュ簱锛変笌**鐢熸垚浠�**锛圥OI 寰�姣嶇増閲屽～鍊硷紝姣嶇増涓嶅叆搴撱�佷笉闅忕▼搴忓垎鍙戯級銆�
+
+### 2.2 鍚庣鍏抽敭绫�
+
+| 绫� | 鑱岃矗 |
+| --- | --- |
+| `dataimport/service/DataImportService.java` | 鎵�鏈夊鍏ヨВ鏋愶紙璐ц繍鍛ㄨ浆閲忋�丠203-1銆佸煄甯傚杩愩�佹姇璧勫競宸炲崟琛�/鎶曡祫绯荤粺瀵煎嚭銆佺綉绾﹁溅鎶ュ憡鈥︼級 |
+| `dataimport/controller/DataImportController.java` | 瀵煎叆涓庢竻鐞嗘帴鍙ｏ紙`/api/import/*`锛� |
+| `reportexport/service/ReportExportService.java` | 鎵�鏈夌敓鎴愪欢锛堟眹鎬诲ぇ琛ㄣ�佹姇璧� 5 寮犺〃銆佸悇绫荤嫭绔嬫姤琛ㄣ�侀瑙堛�佸氨缁牎楠岋級 |
+| `reportexport/service/ReportExportTaskService.java` | 姹囨�诲ぇ琛ㄥ紓姝ュ鍑轰换鍔� + 杩涘害 + 10 鍒嗛挓鍐呭瓨缂撳瓨 + 鏁版嵁鐗堟湰瀹堝崼 |
+| `reportexport/calc/SummaryWorkbookFiller.java` | 姹囨�诲ぇ琛ㄥ彴璐﹂〉鍥炲～ + 鍏紡鎸夋湀琛ラ綈 |
+| `reportexport/calc/WycSplitCalc.java` | 缃戠害杞︽媶鍒嗭紙璁㈠崟鍗犳瘮 脳 鍏ㄧ渷 pin锛涘煄甯傚唴鐢ㄥ贰娓稿嚭绉熷煄甯傚唴鍗犳瘮浠ｇ悊锛� |
+| `dataimport/service/AuditService`锛堝強 `audit/*`锛� | 瀹℃牳瑙勫垯锛圧ULE001鈥︼級涓庡鏍哥粨鏋滆惤搴� |
+
+> 閫愯浠ｇ爜鍦板浘瑙� `docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md` 绗� 8 鑺傦紙鍚鍙凤紝鍔″繀鐢ㄥ畠锛屼笉瑕侀噸鏂版弧浠撳簱鎵撅級銆�
+
+### 2.3 鍓嶇椤甸潰
+
+| 椤甸潰 | 鏂囦欢 | 璇存槑 |
+| --- | --- | --- |
+| 鏁版嵁瀵煎叆 | `views/DataImport.vue` | 鎸夌被鍨嬪鍏ワ紱缁撴灉寮圭獥鍙嫋鍔ㄣ�佸唴瀹瑰彲婊氬姩銆佸彲瀵煎嚭鏄庣粏 CSV锛涖�岀綉绾﹁溅璁㈠崟鍙婂叏鐪佹�婚噺銆嶅凡闅愯棌 |
+| 鏁版嵁鏌ョ湅 | `views/DataView.vue` | 銆屾姤琛ㄦ湡銆嶅湪銆屾暟鎹被鍨嬨�嶄箣鍓嶏紱宸插惈**鎶曡祫**锛堟姇璧勯」鐩熀纭�琛� / 鎶曡祫绯荤粺姣忔湀瀵煎叆椤圭洰琛級涓�**鑳借��**鍒嗙粍 |
+| 鎶ヨ〃鐢熸垚 | `views/ReportExport.vue` | 棰勮锛堝崟琛ㄦ寚鏍囷細鍒嗙被/鎸囨爣/鏁版嵁/鍚屾瘮锛屽凡鍒犻櫎銆屼腑鍙ｅ緞銆嶄箣鍚庣殑鎵�鏈夎〃锛�+ 涓嬭浇锛涘惈涓ゅ紶鎶曡祫鏄庣粏琛ㄣ�佽繘搴﹀脊绐� |
+| 瀹℃牳缁撴灉 / 瑙勫垯绠＄悊 / 鐢ㄦ埛绠＄悊 / 鐧诲綍 | `views/AuditResult.vue`銆乣RuleManage.vue`銆乣UserManage.vue`銆乣Login.vue` | 楠岃瘉鐮侀粯璁�**涓嶆樉绀�**锛坄captchaRequired` fail-safe 涓� false锛� |
+
+### 2.4 甯哥敤鎺ュ彛锛堟帓鏌ユ椂缁曡繃鍓嶇鐢級
+
+| 鐢ㄩ�� | 鎺ュ彛 |
+| --- | --- |
+| 鏌愭湡鏌愭姤琛ㄦ槸鍚﹀彲鍑� | `GET /api/report/ready?period=2026-08` |
+| 棰勮 | `GET /api/report/preview?period=2026-08&mode=month&types=summaryWorkbook` |
+| 姹囨�诲ぇ琛ㄥ鍑猴紙鍚屾/寮傛锛� | `GET /api/report/export/summaryWorkbook?...`銆乣POST /api/report/exportTask/summaryWorkbook` + `GET /api/report/exportTask/{id}` |
+| 鎶曡祫甯傚窞鍗曡〃鎵归噺瀵煎叆 | `POST /api/import/investCityBatch?period=2026-08&category=瀹㈣繍绔欏満`锛堝彟涓�绫� `鐗╂祦鍥尯`锛� |
+| 瀵煎叆鎵规鏌ヨ | `GET /api/import/batches?type=...` |
+| 娓呮煇鏈熸暟鎹� | `POST /api/import/clear?period=...` |
+
+> 鏈湴璋冭瘯鑷 JWT锛歚_tmp/_qa_out/mktoken.py`锛坰ecret 鍦ㄥ悗绔� `application.yml` 鐨� `jwt.secret`锛�2 灏忔椂杩囨湡锛�401 灏遍噸绛撅級銆�
+
+---
+
+## 3. 鏁版嵁閾撅紙婧� 鈫� 搴� 鈫� 鐢熸垚浠讹級
+
+### 3.1 璐ц繍閲� / 鍛ㄨ浆閲�
+
+| 椤� | 鍐呭 |
+| --- | --- |
+| 婧� | `D:\05_鏁版嵁鍒嗙被\楂橀�焅瀹氱-婀栧寳鐪佸悇甯傚窞杩愯緭閲忔暟鎹紙2026骞�1-8鏈堬級.xlsx`锛�**鏃� 2023 骞� Sheet**锛夛紱2023 骞存潵鑷� 7 鏈堥偅浠斤紙澶氫竴涓� `2023` Sheet锛� |
+| 鎺ュ彛 | `POST /api/import/freightTurnover` |
+| 搴� | `freight_turnover_import`锛坄freight_m01..m12` / `turnover_m01..m12` / `last_*`锛� |
+| 鏈熸璇箟 | **`2021-12` 鏀剧殑鏄骞� 1-12 鏈堝叏骞存暟鎹�**锛涜骞存渶鍚庝竴涓湁鏁版嵁鐨勬湀浠藉喅瀹氭湡鍙凤紙2026 鍙湁 1-8 鏈� 鈫� `2026-08`锛� |
+| 鐢熸垚浠� | 姹囨�诲ぇ琛ㄣ�婅揣杩愩�嬨�婇亾璺繍杈撳懆杞噺銆嬨�婅揣杩愰噺鎺掑悕銆嬨�婅揣杩愬懆杞噺鎺掑悕銆嬮〉 |
+
+- 澶氬勾搴﹀伐浣滅翱璇嗗埆瑙勫垯锛坄detectYearSheets`锛夛細鈮�2 涓� Sheet + Sheet 鍚嶅尮閰� `^\d{4}\s*骞�?$` + 棣栬 A1 鍚�岃揣杩愰噺銆岯1 鍚�屾湀銆嶏紱浠讳竴涓嶆弧瓒冲垯鍥為��鑰佺殑鏈堝害妯℃澘瑙ｆ瀽銆�
+- 涓�涓� Sheet 閲屻�岃揣杩愰噺銆嶅潡鍦ㄤ笂銆併�屽懆杞噺銆嶅潡鍦ㄤ笅锛�**鍚屼竴甯傚窞鍚嶇浜屾鍑虹幇鍗宠涓哄懆杞噺鍧�**銆�
+
+### 3.2 鍏矾鏃呭 H203-1锛堜腑鍙ｅ緞鐨勬潵婧愶級
+
+| 椤� | 鍐呭 |
+| --- | --- |
+| 婧� | `docs/鍏矾鏃呭/妯℃澘_浜や紒缁烪203-1琛╛鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌.xlsx`锛堟ā鏉垮凡鎸夌敤鎴疯姹傛敼杩囷紝鏂板 `缁熶竴绀句細淇＄敤浠ｇ爜`銆乣濉姤鍗曚綅` 涓ゅ垪锛� |
+| 鎺ュ彛 | `POST /api/import/passengerMonthly` |
+| 搴� | `h2031_enterprise_monthly`锛�+ `passenger_individual_monthly` 涓綋锛� |
+| 瑕佺偣 | 瑙ｆ瀽**鎸夎〃澶村悕鍙栧��**锛屾墍浠ユā鏉挎彃鍒�/鍙崇Щ涓嶄細绠楅敊锛涚己蹇呴渶鍒椾細鎶ャ�岃〃澶寸己灏戝繀闇�鍒椼�愪紒涓氬悕绉般�戙�愬杩愰噺_鎬昏銆戙�� |
+
+### 3.3 鍩庡競瀹㈣繍
+
+| 椤� | 琛� | 澶囨敞 |
+| --- | --- | --- |
+| 鍩庡競鍏氦 | `city_bus_monthly` | 涓彛寰勭淮搴� 2 = 銆屾�婚噺 鈭� 鍩庡競鍐呫��**鐜扮畻** |
+| 宸℃父鍑虹 | `city_taxi_monthly` | 缁村害 3 = 銆屾�婚噺 鈭� 鍩庡競鍐呫�嶏紱鍚屾椂鏄綉绾﹁溅鎷嗗垎鐨勪唬鐞嗚緭鍏� |
+| 缃戠害杞� | `wyc_order_monthly` / `wyc_total_monthly` | 缁村害 4锛氳鍗曞崰姣� 脳 鍏ㄧ渷 pin锛涘厛鏌ュ簱锛屽簱閲屾病鏈夋墠鍥炶惤 `docs/鍩庡競瀹㈣繍/缃戠害杞﹁鍗曞強鍏ㄧ渷鎬婚噺.xlsx` |
+| 缃戠害杞﹀垎鏋愭姤鍛� | `POST /api/import/wycOrderReport` | 瑙ｆ瀽 `.docx` 鎶ュ憡閲岀殑甯傚窞璁㈠崟琛紱**杩欐槸瀵煎叆杩� `婀栧寳缃戠粶棰勭害鍑虹姹借溅2025骞�09鏈堝垎鏋愭姤鍛奰 閭ｄ釜鍏ュ彛** |
+
+### 3.4 姹囨�诲ぇ琛紙19 涓〉绛撅級
+
+- 鍏ュ彛锛氭姤琛ㄧ敓鎴愰〉鍕俱�屾眹鎬诲ぇ琛ㄣ�嶁啋 `ReportExportTaskService`锛堝紓姝ワ級鈫� `ReportExportService.exportSummaryWorkbook()`銆�
+- 鍏锛氭壘姣嶇増 鈫� 鍥炲～ 6 寮犲彴璐﹂〉 鈫� 鍏紡鎸夋湀鍙崇Щ 鈫� 鐜扮畻 4 寮犳垚鍝侀〉 鈫� 鎼� 3 寮犳帓鍚嶉〉鐨勫�� 鈫� 涓や綅灏忔暟鏍煎紡 + `evaluateAll` 閲嶇畻 + `fullCalcOnLoad`銆�
+- **鍏抽敭璁ょ煡**锛氭瘝鐗堟槸鍏紡椹卞姩鐨勩�傚叏鐪佽 = 危17 甯傚窞锛涘煄甯傚杩� / 涓彛寰勬槑缁嗘槸璺ㄨ〃寮曠敤锛屼笉闇�瑕佸崟鐙啓鏁帮紝鍙鍏紡鎸夋湀琛ラ綈 + 閲嶇畻銆�
+- 姣嶇増锛歚docs/鐢熸垚姹囨�诲ぇ琛�/{yyyy}骞磠M}鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛�**绋嬪簭涓嶄細鑷繁寤�**锛堣 P0-4锛夈��
+
+### 3.5 鎶曡祫锛�5 寮犺〃锛�
+
+| 姝ラ | 鐩爣琛紙姣嶇増锛� | 瑙勫垯 |
+| --- | --- | --- |
+| Step1 鏈堟姤 鈫� 鏄庣粏琛� | `妯℃澘_X鏈堝杩愮珯鎶曡祫鏄庣粏琛�.xlsx`銆乣妯℃澘_X鏈堢墿娴佺珯鍦烘姇璧勬槑缁�.xls` | 浠�**椤圭洰鍚嶇О**涓洪敭锛氬凡鏈夆啋鏇存柊 H/I/J/K/L/M锛涙病鏈夆啋**鏂板鏁磋**锛堝凡瀹炵幇鍔ㄦ�佹彃琛岋級 |
+| Step2 鏄庣粏 鈫� 姹囨�� | `妯℃澘_鍏ㄧ渷棰勫畨鎺掕鍒掕繘搴︽儏鍐垫眹鎬�.xls` | 鍚屽悕鏇存柊 4 椤癸紱娌℃湁鐨勬柊澧烇紱妯℃澘鏈夎�屾湀鎶ユ病鏈夌殑**淇濇寔鍘熷��**锛堝凡瀹炵幇鍔ㄦ�佹彃琛� + 銆屾湁鎬绘姇璧勬棤鏈堝害鏁般�嶈ˉ璁★級 |
+| Step3 鏄庣粏 鈫� 3 寮犲浐瀹氳〃 | `妯℃澘_鍗佷簲浜旇鍒掔墿娴侀」鐩繘灞曟儏鍐�.xls`銆乣妯℃澘_浜垮厓鎶曡祫椤圭洰.xls`銆乣妯℃澘_缁忔祹寮哄幙鎶曡祫缁熻鎶ヨ〃.xls` | 椤圭洰娓呭崟鍥哄畾锛屽彧鏇存柊鎸囧畾鎸囨爣锛堜笁寮犺〃閮藉凡瀹炵幇鍔ㄦ�佹彃琛岄�昏緫锛屽叾涓嚎鍏冭〃瑙� P0-2锛� |
+
+- 鍏ュ簱锛歚investment_project`锛堜富妗ｏ級+ `investment_monthly`锛堝綋鏈熸湀搴︽暟锛屾寜銆屽競宸� + 绫诲埆銆嶅箓绛夋竻鐞嗗悗閲嶅缓锛夈��
+- 甯傚窞濉姤锛�**缁熶竴妯℃澘宸茬敓鎴�** `docs/鎶曡祫/妯℃澘/妯℃澘_甯傚窞鏈堟姤_瀹㈣繍绔欏満.xlsx` / `妯℃澘_甯傚窞鏈堟姤_鐗╂祦鍥尯.xlsx`锛屽彛寰勮鏄庤 `docs/鎶曡祫/濉姤鍙ｅ緞涓庣粺涓�妯℃澘_2026-09-20.md`銆�
+
+### 3.6 鑳借�� / 骞存姤 / 瀹℃牳
+
+- 鑳借�楋細`POST /api/import/energyMonthly`銆乣/api/import/energyAuth`锛涘彴璐﹀湪鏁版嵁鏌ョ湅銆岃兘鑰椼�嶇粍銆�
+- 瀹℃牳锛氳鍒欏湪 `RuleManage`锛岀粨鏋滃湪 `audit_result` / `audit_run`锛堟寜鎶ヨ〃鏈燂級銆�
+
+---
+
+## 4. 鏈畬鎴愮殑宸ヤ綔锛堟寜浼樺厛绾э級
+
+> 鐘舵�佸垪锛氣潓 鏈仛 / 馃敹 閮ㄥ垎瀹屾垚 / 鈴� 寰呬笟鍔＄‘璁� / 馃敀 琚閮ㄩ樆濉�
+
+### P0 鈥斺�� 浼氱洿鎺ュ奖鍝嶅嚭鏁版纭�ф垨浼氬弽澶嶅彂鐢�
+
+| # | 浜嬮」 | 鐜拌薄 / 褰卞搷 | 鐜扮姸涓庤瘉鎹� | 涓嬩竴姝� | 鐘舵�� |
+| --- | --- | --- | --- | --- | --- |
+| P0-1 | ~~8 鏈堝崄鍫扮墿娴佹眹鎬昏〃鍚�岄潪鍗佸牥娈点�崀~ | 鈥斺�� | **宸查棴鐜紙2026-09-21锛�**锛氱敤鎴风‘璁ゃ�屾竻闄ゆ帀銆嶁啋 鐢� Excel COM 鍒犻櫎婧愭枃浠剁 11~63 琛岋紙姝︽眽 27 + 榛勭煶 4锛夛紝鍘熶欢澶囦唤 `docs/鎶曡祫/杈撳嚭/婧愭枃浠跺浠�/鈥鍘熷鍚姹夐粍鐭砡20260921.xls`锛涢噸瀵奸獙璇佽鏂囦欢 38 鈫� **7 鏉�**锛�8 鏈堢墿娴� 128 鈫� 97锛屽簱鍐呬粛 152 椤圭洰 / 136 鏉� 2026-08 鏈堝害鏁� | 鏃犻渶鍐嶅鐞嗭紙鍚庣画鑻ュ啀鍔犲洖闈炴湰鏂囦欢甯傚窞娈碉紝闇�閲嶆柊娓呯悊锛� | 鉁� |
+| P0-2 | **銆婁嚎鍏冩姇璧勯」鐩�嬭涓婇」鐩〃鏈堜唤鍒椾細琚鐩�** | 浠ｇ爜鍙噸鍐欒〃澶存枃瀛楋紙`ReportExportService.java:6128-6139` 鍐� `col5`/`col23`锛夛紝妯℃澘 row2 绗� 24 鍒楀師鏈槸銆�2026骞�7鏈堝疄闄呭畬鎴愭姇璧勩�嶃��8 鏈堝鍑烘妸瀹冩敼鎴愩��2026骞�8鏈堚�︺�嶅苟鍐� 8 鏈堟暟 鈫� **7 鏈堥偅涓�鍒楃殑鏁版嵁娑堝け** | 鐢ㄦ埛宸插湪銆婂緟纭娓呭崟銆婹7 鏄庣‘锛氥�屽彧鏇存柊 F 鍒� + 鍦� 2026骞碭鏈堝疄闄呭畬鎴愭姇璧勫悗**鍔犱竴鍒�** 2026骞碭+1鏈堝疄闄呭畬鎴愭姇璧勩�嶁啋 鏈疄鐜� | 鎸� Q7 鏀逛负銆屾寜鏈堣拷鍔犱竴鍒椼�嶏紱鍚岃〃鍏跺畠鍐欐鏈堜唤鍒楋紙1-3鏈�/4鏈�/5鏈�/6鏈�/绗簩瀛ｅ害锛夊悓鏍疯涓�璧风湅 | 鉂� |
+| P0-3 | **瀵煎嚭鍓嶃�屽熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉銆嶏紙B4锛�** | 鍘诲勾鍚屾湀鍩烘暟娈嬬己鏃剁▼搴忕収绠楋紝鏇炬妸涓彛寰勬帓鍚嶅叏鐪佺疮璁″悓姣旂畻鎴� **+73.89%**锛堢湡鍊� +5.81%锛夈�傚姞浣撴鍚庡彲鏍规不澶嶅彂 | 鍚庣宸叉敹闆嗛棶棰樻竻鍗� `midIssues`锛坄ReportExportService.java:2436`锛変笌 `dbProblems`锛屼絾 **`getLastMidIssues()` 娌℃湁浠讳綍璋冪敤鏂�**锛屽墠绔篃鏃犳秷璐癸紝娌℃湁銆婃暟鎹己澶辨竻鍗曘�嬮〉 鈫� 鍙仛浜� B5锛堟棩蹇楋級涓� B3锛堝畬澶囨�ф牎楠岋級 | 鈶� 灏辩华/棰勮鎺ュ彛杩斿洖 issues锛涒憽 瀵煎嚭鍓嶅脊绐楋紱鈶� 鐢熸垚浠惰拷鍔犮�婃暟鎹己澶辨竻鍗曘�嬮〉 | 馃敹 |
+| P0-4 | **缂� 2026-06 / 2026-09 姣嶇増** | 杩欎袱鏈熼瑙� `ready=false`銆屾湭鎵惧埌妯℃澘鏂囦欢銆嶏紝鍑轰笉浜嗚〃 | `docs/鐢熸垚姹囨�诲ぇ琛�/` 涓嬪彧鏈� 2026骞�7鏈� / 2026骞�8鏈� + 鐗堝紡鍘熷瀷锛涚▼搴�**鍙寜鏂囦欢鍚嶇簿纭尮閰�**銆佷笉浼氳嚜寤� | 鐢ㄦ埛 Q13 宸叉殏缂擄紙瑕侀棶鍚屼簨銆岃兘涓嶈兘鐢ㄦ瘝鐗堣嚜鍔ㄧ敓鎴愬悗缁瘡鏈堟ā鏉裤�嶏級銆傜煭鏈燂細浜哄伐鏀句竴浠� 9 鏈堟瘝鐗堬紱闀挎湡锛氭墿鍒楀櫒锛堣瑙佹眹鎬诲ぇ琛ㄤ氦鎺� P0-2锛� | 鈴� |
+
+### P1 鈥斺�� 鍙ｅ緞绫� / 闇�瑕佷笟鍔＄‘璁わ紙涓嶉樆濉炴棩甯革紝浣嗕細褰卞搷瀹氱锛�
+
+| # | 浜嬮」 | 璇存槑 | 鐘舵�� |
+| --- | --- | --- | --- |
+| P1-1 | 涓彛寰勬帓鍚� vs 涓彛寰勬槑缁嗐�屽巻鍙插悓鏈熷熀鏁板弻杞ㄥ埗銆� | 闄ゆ姹夊 16 涓競宸炵疮璁″悓姣旈兘鏈夊樊锛堥粍鍐� 7.74% vs 7.64%锛夛紱鏍瑰洜鏄瘝鐗� 2025 骞� 3銆�4 鏈堢綉绾﹁溅鎷嗗垎鐢ㄤ簡涓�濂椾笌鍑虹鍒楄嚜鐩哥煕鐩剧殑鏃ц緭鍏ャ��**鏂规 A 宸插疄鏂藉苟鍥炲綊锛氭帓鍚嶉〉鏀圭敤姣嶇増 2025 闈欐�佸垪**锛涢粍鍐� 1-8 鏈堢疮璁″悓姣斾慨姝ｄ负 `7.641733%`锛�17 甯傚窞 脳 涓ゆ寚鏍囧叡 68 涓悓姣�/绱鏍煎叏閮ㄤ竴鑷达紙鏈�澶у樊 `2.91e-11`锛夛紝褰撴湀鍚屾瘮鏃犲洖褰� | 鉁咃紙2026-09-21锛岃瑙佹眹鎬诲ぇ琛ㄤ氦鎺ョ 4 绔狅級 |
+| P1-2 | 涓彛寰勬帓鍚嶅叏鐪佽宸� 0.0002 涓囦汉鍏噷 | 姣嶇増鍏紡 `=SUM(O4:O20)` 鍏堝洓鑸嶄簲鍏ュ啀姹傚拰鐨勭粨鏋勬�у樊寮傦紝鏄惁鏀瑰叏绮惧害鍐欏�奸渶鎷嶆澘 | 鈴� |
+| P1-3 | 涓彛寰勬槑缁� 4 鏍� `#DIV/0!` | 2025 骞� 8 鏈堝熀鏁颁负 0锛堜笉鍙瘮锛夛紝鏄惁鏀圭┖鐧介渶涓氬姟纭 | 鈴� |
+| P1-4 | 鍏ㄧ渷 h2031 1-8 鏈� 27524.49 vs 危17 甯傚窞 24481.74 | 宸� **3042.75**锛堜紒涓氫笂鎶ョ殑銆屽叏鐪併�嶅惈甯傚窞鏄庣粏澶栫殑鏁版嵁锛屾垨鏌愬競宸炴紡鎶ワ級銆傜▼搴忎竴寰嬫寜姣嶇増鍙ｅ緞锛埼ｅ競宸烇級璧� 鈫� 寤鸿涓氬姟渚ф牳涓�娆� | 鈴� |
+| P1-5 | 澶╅棬鐗╂祦婧愭枃浠� `8鏈堜唤鐗╂祦鍥腑蹇冨缓璁鹃」鐩�(澶╅棬).xlsx` 鐨� H/J/K 鍒椾负绌� | 璇ュ競宸炴湰鏈熺疮璁�/璁″垝/鏈堝畬鎴愬彇涓嶅埌 | 馃敀 绛夊悓浜嬬粰鏁� |
+| P1-6 | 鑽嗗窞 / 榛勭煶銆岃鍒掑唴 / 瑙勫垝澶栥�嶆媶鍒嗗彛寰� | 褰卞搷鏄庣粏琛ㄥ垎鍧楀綊浣� | 鈴� 绛夊悓浜� |
+| P1-7 | 鎶曡祫銆岃祫閲戞笭閬撱�嶅垎缁勬湭鍏ュ簱 | 鏄庣粏琛ㄩ噷銆屼竴銆佽溅璐◣ / 浜屻�佺渷鐕冩补绋� / 涓夈�佸啘鏉戠患鍚堣繍杈撴湇鍔＄珯 / 鍥涖�佸�欒溅浜�嶅垎缁勮鍦ㄥ鍏ユ椂琚� `^[涓�浜屼笁鍥涗簲鍏竷鍏節鍗乚+銆�.*` 瑙勫垯璺宠繃 鈫� 椤圭洰钀戒笉鍒板叿浣撴笭閬撳潡銆傞渶缁� `investment_project` 鍔� `fund_channel` 骞堕噸瀵� 7/8 鏈� | 鉂� |
+| P1-8 | 姝︽眽 8 鏈堢墿娴佹棤鍗曡〃 | 璇ュ競宸炲皬璁＄幇鍦ㄥ彧鏈夈�屾�绘姇璧勩�嶏紝缂鸿嚜寮�濮嬬疮璁�/鏈勾璁″垝/鏈堝畬鎴愶紙宸叉寜銆屾湁鎬绘姇璧勬棤鏈湡鏈堝害鏁般�嶈ˉ璁★紝涓嶆薄鏌撶疮璁″垪锛� | 馃敀 闇�姝︽眽鍗曡〃鎴栫渷鍘呭彛寰� |
+| P1-9 | 鎶曡祫瀵煎嚭杈撳嚭鐩綍绾﹀畾锛圦10 宸茬瓟銆屽悓鎰忋�嶏級 | 绾﹀畾锛歚docs/鎶曡祫/杈撳嚭/<YYYY-MM>/` 鎸夋湀鍒嗙洰褰曘�佸師鏍煎紡鍘熸牱杈撳嚭銆佽繍琛屽墠鑷姩澶囦唤 `_bak_<鏂囦欢鍚�>_<鏃堕棿鎴�>`銆佸彟鍑� `杩愯鏃ュ織_<骞存湀>.md` 涓� `鏍￠獙鎶ラ敊_<骞存湀>.xlsx` 鈫� **浠ｇ爜閲屾病鏈夊疄鐜�**锛堟棤浠讳綍銆岃緭鍑恒�嶇洰褰曞啓鍏ラ�昏緫锛� | 鉂� |
+| P1-10 | 杩愯緭閲� 2026-01~07 鐨� `last_*` 涓虹┖ / H203-1 2026-01~07 鐨� `unified_credit_code`銆乣report_unit` 涓虹┖ | 鍓嶈�呮槸鏀瑰姩鍓嶅氨涓虹┖锛屽悗鑰呮槸鏂板垪鏈湡鎵嶈鍙栵紱鏄惁琛�/閲嶅寰呯‘璁� | 鈴� |
+| P1-11 | 璐ц繍銆屾寔缁湪瑙� 545 瀹躲�峷s銆屽畼鏂瑰叏鍙ｅ緞銆嶄袱鐗堝悓姣旓紙+2.90% vs +4.54%锛� | 鍙ｅ緞涓嶅悓锛屽凡鍒嗗埆娉ㄦ槑锛涜嫢瑕侀殢銆婂樊寮傜巼姹囨�昏〃銆嬩笂鎶ワ紝寤鸿鍔犳敞宸紓鍘熷洜 | 鈴� |
+| P1-12 | 楂橀�熻繍璺濆悓姣旓紙鐢ㄦ埛琛ㄦ牸 O 鍒楋級鐨勬潵婧�/鏈熼棿寰呯‘璁� | 纭鍚庢柟鍙畻銆岃繍璺濆閫熷樊銆� | 馃敀 绛夌敤鎴� |
+| P1-13 | 鎶曡祫绯荤粺瀵煎嚭鐨�**鏂版ā鏉�**锛坄2026骞碭鏈堟姇璧勭郴缁熼」鐩槑缁哷锛� | 宸叉敮鎸佹寜琛ㄥご瀹氫綅瑙ｆ瀽锛�09-21锛�129 鏉″叆搴擄級銆�**寰呭畾**锛氣憼 鏂版ā鏉垮鍑虹殑銆岄」鐩墍澶勯樁娈点�嶆湭钀藉簱锛屽闇�姣斿寤鸿闃舵瑕佸姞鍒楀苟鍚屾 `docs/init.sql`/`docs/database.md`锛涒憽 鏂版ā鏉�**娌℃湁銆岃嚜骞村垵绱銆嶅垪**锛岃缁村害瀹℃牳宸叉敼涓恒�屽熀鍑嗙己澶卞嵆璺宠繃 + WARN 鏃ュ織銆嶏紙RULE_I002 瀹炴祴 0 鏉★級锛岃嫢涓氬姟浠嶈姣斿闇�妯℃澘琛ュ洖璇ュ垪 | 馃敹 |
+
+### P2 鈥斺�� 宸ョ▼涓庢暣娲�
+
+| # | 浜嬮」 | 璇存槑 | 鐘舵�� |
+| --- | --- | --- | --- |
+| P2-1 | 銆屽閫熸帓鍚嶃�嶆帾杈烇紙D 缁勶級 | 鍙湪鍚屾瘮榻愬叏鏃舵帓鍚嶏紝鍚﹀垯鏍囨敞銆屽幓骞村悓鏈熷熀鏁扮己澶憋紝鏆備笉鎺掑悕銆� | 鉂� |
+| P2-2 | 鍩庡競瀹㈣繍椤佃〃澶翠粛鏄�**鏃ユ湡搴忓垪鍙�** | 浠讳綍銆屾寜琛ㄥご鏂囧瓧鍖归厤鍒椼�嶇殑闀挎晥鏂规鍦ㄨ椤典細澶辨晥锛岄渶鍏堟妸 G/I/K/M/O/Q銆丄D/AF/AH/AK 鏀规垚鏂囧瓧琛ㄥご | 鉂� |
+| P2-3 | `applySummaryReferenceLayout()` 鎸�**鍒楀簭鍙�**濂楀垪瀹�/闅愯棌 | 鍙傜収浠朵竴鍔犲噺鍒楀氨鏁翠綋閿欎綅锛屽簲鏀逛负鎸夎〃澶存枃瀛楀尮閰� | 鉂� |
+| P2-4 | 缂烘瘝鐗堟彁绀猴紙T08锛夋湭瀹炴祴 | 鏈夋祴璇曞壇鏈椂琛ユ祴 | 鉂� |
+| P2-5 | 閮ㄧ讲鍖呭唴鏄�**甯� AJ 鍒楃殑鏃ф瘝鐗�** | `deploy/traffic-audit-deploy-20260913/backend/docs/鐢熸垚姹囨�诲ぇ琛�/`銆乣_deploytest/`锛涚敤鎴� 09-20 鏄庣‘銆岄儴缃插寘鍏堜笉绠°�嶏紝鍙戝寘鍓嶅繀椤诲悓姝� | 鈴� |
+| P2-6 | 瀵煎嚭缂撳瓨鏄�**鍐呭瓨鎬�** | 杩涚▼閲嶅惎鍗冲け鏁堬紱濡傞渶璺ㄩ噸鍚�/澶氫汉鍏辩敤鐨勩�屽鍑鸿褰曘�嶉〉闇�鍙﹀仛 | 鉂� |
+| P2-7 | 甯傚窞鍗曡〃銆屽甯傚窞鍧椼�嶅厹搴曟彁绀� | 鏄惁鍦ㄨ瘑鍒埌涓�浠芥枃浠跺惈澶氫釜甯傚窞鍧楁椂寮圭獥鎻愮ず/璺宠繃锛屽緟纭锛堜笌 P0-1 鍚屼竴鏍瑰洜锛� | 鈴� |
+| P2-8 | 浠撳簱鏍圭洰褰� `_*.*` 涓存椂鏂囦欢澧炲 | `_chk_*`锛堟湰娆℃眹鎬诲ぇ琛ㄦ帓鏌ヤ骇鐢燂紝瑙佹眹鎬诲ぇ琛ㄤ氦鎺ョ 10 鑺傦級銆乣_hyb_*`銆乣_loo_*` 绛夛紝**缁忕敤鎴峰悓鎰忓悗鍐嶆竻** | 鈴� |
+| P2-9 | `2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx` 鍘荤暀 | 杩愯鏃舵湭琚紩鐢� | 鈴� |
+| P2-10 | 銆岀彮绾垮寘杞︺�嶉〉 2020 骞村巻鍙插垪 `#VALUE!` | 鏃㈡湁鐜拌薄锛孍xcel 鎵撳紑鎸� `fullCalcOnLoad` 浼氶噸绠� | 璁板綍 |
+| P2-11 | 鎶ヨ〃鐢熸垚椤点�屼腑鍙ｅ緞銆嶄箣鍚庤〃鏍煎凡鍒犮�佸脊绐楀彲鎷栧姩 + 鍦嗚 | 宸插疄鐜帮紙09-16/09-20锛夛紝鍒啀鏀瑰洖鍘� | 鉁� |
+
+---
+
+## 5. 寰呯敤鎴� / 涓氬姟纭娓呭崟锛堟帴鎵嬩汉鍏堝埆鑷繁鎷嶏級
+
+1. **P0-1**锛�8 鏈堝崄鍫扮墿娴佹簮鏂囦欢鐨勩�岄潪鍗佸牥娈点�嶇敱璋佹竻銆佷粈涔堟椂鍊欐竻锛燂紙寤鸿锛氭帴鎵嬩汉鍒犳骞跺浠斤級
+2. **P0-2**锛氥�婁嚎鍏冩姇璧勯」鐩�嬫寜鏈堣拷鍔犲垪鐨勫仛娉曠‘璁わ紙鐢ㄦ埛 Q7 宸茬粰瑙勫垯锛屽疄鏂藉墠鍐嶇‘璁や竴娆″垪浣嶏級銆�
+3. **P0-4**锛�2026-09 姣嶇増鎬庝箞鍔� 鈥斺�� 鐩存帴鏀句竴浠戒汉宸ユ瘝鐗堬紝杩樻槸鍏堝仛鎵╁垪鍣紵锛堢敤鎴锋鍦ㄩ棶鍚屼簨锛�
+4. **P1-1**锛氫腑鍙ｅ緞鎺掑悕鍘嗗彶鍩烘暟鈥斺�旂敤鎴峰凡鎷嶆澘骞跺畬鎴愭柟妗� A锛堟帓鍚嶉〉鏀圭敤姣嶇増 2025 闈欐�佸垪锛夛紝鏃犻渶鍐嶇‘璁ゃ��
+5. **P1-2 / P1-3**锛�0.0002 涓囦汉鍏噷鏄惁鏀瑰叏绮惧害鍐欏�硷紱`#DIV/0!` 鏄惁鏀圭┖鐧姐��
+6. **P1-4**锛歨2031 鍏ㄧ渷琛屼笌 危17 甯傚窞宸� 3042.75 鐨勪笟鍔¤В閲娿��
+7. **P1-6**锛氳崋宸� / 榛勭煶銆岃鍒掑唴 / 瑙勫垝澶栥�嶅彛寰勩��
+8. **P1-7**:鎶曡祫璧勯噾娓犻亾鍒嗙粍鏄惁瑕佸叆搴擄紙瑕佺殑璇濋渶瑕佸姞瀛楁 + 閲嶅 7/8 鏈堬級銆�
+9. **P1-9**锛氭姇璧勫鍑恒�屾寜鏈堝垎鐩綍 + 鑷姩澶囦唤 + 杩愯鏃ュ織/鏍￠獙鎶ラ敊銆嶆槸鍚︽寜绾﹀畾瀹炴柦銆�
+10. **P2-1 / P2-7 / P2-8**锛氬閫熸帓鍚嶆帾杈炪�佸甯傚窞鍧楁彁绀恒�佷复鏃舵枃浠舵竻鐞嗐��
+
+---
+
+## 6. 鍘嗗彶鍧戠储寮曪紙鍒噸韪╋級
+
+| 鏂囨。 | 瑕嗙洊鍐呭 |
+| --- | --- |
+| `docs/闂姹囨��/闂涓庢敞鎰忎簨椤规眹鎬籣2026-09-16.md` | 鍚姩/杩涚▼銆丏B銆佸鍏ヨ矾寰勭害瀹氥�佹姤琛ㄧ敓鎴愩�佺櫥褰曢獙璇佺爜銆佹枃浠跺啓鍏ワ紙鎹㈣/BOM锛夈�佹祻瑙堝櫒鍙栬瘉銆丟it 鍙屼粨搴撱�佽揣杩愮疮璁″垪鍙ｅ緞銆丒xcel銆屾墦涓嶅紑銆嶆牴鍥狅紙inlineStr 娈嬬暀锛� |
+| `docs/闂姹囨��/姹囨�昏〃闂姹囨�籣2026-09-17.md` | 8 鏈堢┖鐧�/鎺掑悕涓嶅銆佹姇璧勯瀹夋帓瀵煎嚭涓虹┖锛堟湀浠介�夐敊锛夈�佹姤琛ㄧ敓鎴愰〉涓ゅ紶鎶曡祫鏄庣粏琛� |
+| `docs/闂姹囨��/姹囨�昏〃涓夋潯涓荤嚎淇鏂规_2026-09-18.md` | 銆屽叕寮忎笉閲嶇畻銆嶇粺涓�鏍瑰洜 + 椤佃寖鍥存紡椤� + 鍙ｅ緞缂哄彛 |
+| `docs/闂姹囨��/涓彛寰勬帓鍚嶅悓姣斾笌鍩庡競瀹㈣繍鍒楅敊浣峗鏍瑰洜涓庨暱鏁堟柟妗坃2026-09-18.md` | 2025 鍩烘暟涓夊缂洪櫡锛堝叕浜ゅ煄闄呭煄涔�=0銆佺綉绾﹁溅 pin 缂哄け銆佸嚭绉� 6 鏈堥噸澶嶏級涓� A/B/C/D 鍥涚粍鏂规 |
+| `docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md` | 姹囨�诲ぇ琛�**閫愯浠ｇ爜鍦板浘**涓� P0-1/P0-2 璇︾粏璁鸿瘉锛堟帴鎵嬪繀璇伙級 |
+
+**鏈�瀹规槗琚敼鍥炲幓鐨� 6 涓偣**锛堝彇鑷眹鎬诲ぇ琛ㄤ氦鎺ョ 6 鑺傦級锛�
+
+1. 鍩庡競瀹㈣繍椤� AJ 鍒楀凡鍒狅紙姣嶇増鏈�**涓ゆ湰**锛屾敼涔嬪墠鍏堢‘璁ゆ敼瀵瑰摢鏈級銆�
+2. `colIndexOf()` 蹇呴』杩斿洖 **0 鍩�**鍒楀彿锛堟浘鍥� 1 鍩哄鑷� 360 鏍煎惊鐜紩鐢級銆�
+3. `setCellFormula` **涓嶆帴鍙�**甯� `=` 鍓嶇紑鐨勫叕寮忎覆銆�
+4. 鍏紡蹇呴』 `evaluateAll` 閲嶇畻鍐欑紦瀛樺�硷紝鍚﹀垯棰勮/浜屾澶勭悊鐪嬪埌鏃у�笺��
+5. 涓彛寰勩�屽煄闄呭煄涔°�嶄竴寰嬬敤銆屾�婚噺 鈭� 鍩庡競鍐呫�嶇幇绠椼��
+6. `setValOrBlank()` 閬囧埌鍏紡鏍肩洿鎺� return 鈥斺�� 鍒兂鐢ㄥ啓鍊兼敼鎺掑悕椤靛叏鐪佽銆�
+
+---
+
+## 7. 鎿嶄綔鎵嬪唽
+
+### 7.1 鍚姩 / 鍋滄
+
+```powershell
+powershell -NoProfile -ExecutionPolicy Bypass -File D:\鏂囨。\ChatGPT\traffic-audit\start-dev.ps1
+powershell -NoProfile -ExecutionPolicy Bypass -File D:\鏂囨。\ChatGPT\traffic-audit\stop-dev.ps1
+```
+
+- 鑴氭湰鑷姩璺宠繃宸插湪鐩戝惉鐨勭鍙ｏ紱灏辩华鍒ゆ嵁鐪� `backend.log` / `traffic-audit-web/frontend.log`銆�
+- 閲嶅惎瑕�**鎸� PID 绮剧‘鍋�**锛堝悗绔摼 `cmd 鈫� java(maven) 鈫� java(app)`锛涘墠绔摼 `cmd 鈫� node(npm) 鈫� cmd 鈫� node(vue-cli-service)`锛夛紝**涓嶈**鎸夊悕瀛楁潃 `node.exe`锛堜細鏉�鎺� Codex 鑷繁鐨� `node_repl`锛夈��
+
+### 7.2 鏁版嵁搴�
+
+```powershell
+& 'D:\mysql\mysql-5.7.41-winx64\bin\mysql.exe' '--host=127.0.0.1' '--port=3308' '--user=root' '--password=123456' '--default-character-set=utf8mb4' 'traffic_audit' '-e' "SQL"
+```
+
+- **蹇呴』鍐� `--host=127.0.0.1`**锛堝啓鎴� `-h127.0.0.1` 浼氳瑙ｆ瀽鎴� host `127`锛夈��
+- 琛ㄧ粨鏋勫彉鏇磋**鍚屾涓夊**锛氬疄闄呭簱 DDL銆乣docs/init.sql`銆乣docs/database.md`銆�
+
+### 7.3 鏈満鐗规湁鐨勫潙
+
+| 鍧� | 瀵圭瓥 |
+| --- | --- |
+| 鍚屾椂瀛樺湪 `Path` 涓� `PATH` 鈫� `Start-Process` 鎶ャ�屽凡娣诲姞浜嗗叿鏈夌浉鍚岄敭鐨勯」銆� | 涓�寰� `cmd.exe /c ... > log 2>&1`锛�**涓ョ `Start-Process`** |
+| 娌欑鍐� node 璁块棶鐢ㄦ埛鐩綍琚嫆锛坄EPERM: lstat`锛� | 鍚姩/缂栬瘧/鎺ㄩ�佷竴寰嬪湪**娌欑澶�**鎵ц |
+| 娌欑鍐� `Get-NetTCPConnection` 闈欓粯澶辫触 | 鍙敤鏃ュ織鍒ゆ柇鏈嶅姟鐘舵�� |
+| 涓枃鎺у埗鍙颁贡鐮� | 鍐欐枃浠跺悗鐢� `Get-Content -Encoding UTF8` 鐪嬶紝鍒潬鎺у埗鍙拌緭鍑哄垽鏂� |
+| 鎹㈣绗︿笉缁熶竴锛坄.vue` CRLF銆乣.java`/`.md` LF锛沗main.js` 甯� BOM锛� | 鏀规枃浠跺墠鍏堢‘璁わ紱`git checkout -- <file>` 浼氭妸 LF 杞� CRLF |
+| `apply_patch` 鍦ㄦ湰鏈轰笉鍙敤 | 鍐� `.py` 鑴氭湰鐢� `python` 鎵ц鏇挎崲 |
+| python 缂哄簱 | `sys.path.insert(0, r"D:\鏂囨。\ChatGPT\traffic-audit\_pylibs")` 鍚庢墠鏈� openpyxl / xlrd |
+
+### 7.4 浜や粯瑙勭煩锛堢‖鎬э級
+
+1. 姣忓仛瀹屼竴涓姛鑳斤細**鍏堟祴璇� 鈫� 鍐欍�婂姛鑳芥祴璇曟姤鍛娿��**锛坄docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_<鍔熻兘鍚�>_<鏃ユ湡>.md`锛屽惈姝ｅ悜/璐熷悜/鍏ュ簱鎶芥煡锛夆啋 **鏇存柊銆婂伐浣滄棩缁撱��**锛坄docs/宸ヤ綔鏃ョ粨/宸ヤ綔鏃ョ粨_<鏃ユ湡>.md`锛夈��
+2. 鐒跺悗 `git fetch origin`锛堜釜浜� gitee锛屽垎鏀� `master`锛変笌 `git fetch gitea`锛堝叕鍙革紝鍒嗘敮 `main`锛夋瘮瀵瑰悎骞讹紝**绂佹寮烘帹**锛屽啀 commit + push銆�
+3. 鍏徃璐﹀彿瀵嗙爜鍙蛋鏈満 git 鍑嵁锛�**绂佹鍐欒繘浠撳簱浠讳綍鏂囦欢**銆�
+
+---
+
+## 8. 鎺ユ墜绗竴灏忔椂 checklist
+
+- [ ] 搂7.1 璧锋湇鍔★紝鐪嬩袱涓棩蹇楃‘璁ゅ氨缁紙娉ㄦ剰锛�**鏈浜ゆ帴鏃舵湇鍔℃鍦ㄨ繍琛岋紝鍒噸澶嶈捣**锛夈��
+- [ ] `GET http://127.0.0.1:8090/api/auth/captcha-config` 閫� 鈫� 鍚庣 OK锛涙墦寮� `http://localhost:8080/#/login` 鑳界櫥褰曘��
+- [ ] 鐢� 搂1.2 鐨� SQL 鏍稿搴撳唴琛屾暟锛�152 / 284 / 136锛夋槸鍚︿笌鏈枃涓�鑷淬��
+- [ ] 鐢熸垚涓�娆� 2026-08 姹囨�诲ぇ琛紙鎶ヨ〃鐢熸垚椤垫垨 搂2.4 鎺ュ彛锛夛紝纭鑳戒骇鍑恒�佽兘鎵撳紑銆�
+- [ ] 璇� `docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`锛堥噸鐐圭 3銆�4銆�5 绔狅級銆�
+- [ ] 璇绘湰鏂� 搂4锛屾寜 P0 椤哄簭鍜岀敤鎴风‘璁ゅ墠 4 浠朵簨鎬庝箞鎺ㄨ繘銆�
+- [ ] 纭鑷繁鐭ラ亾銆屾敼瀹岃鍐欐祴璇曟姤鍛� + 宸ヤ綔鏃ョ粨 + 鍙屼粨搴撴帹閫併�嶃��
+
+---
+
+**浜ゆ帴浜�**锛氶儜鐜夋磥銆�**浜ゆ帴鏃ユ湡**锛�2026-09-21銆�**涓嬫鏇存柊鏃惰鏀规枃棣栨棩鏈熷苟鍦ㄦ杩藉姞涓�琛屽彉鏇磋褰�**
+
+| 鏃ユ湡 | 鍙樻洿 |
+| --- | --- |
+| 2026-09-21 | 棣栨鎴愭枃锛氭暣鍚堟眹鎬诲ぇ琛ㄤ氦鎺ワ紙`docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`锛変笌鎶曡祫/璐ц繍/瀹㈣繍鍚勭嚎閬楃暀 |
+| 2026-09-21锛堜笅鍗堬級 | P0-1 闂幆锛堝崄鍫版簮鏂囦欢宸插垹娈� + 閲嶅楠岃瘉锛夛紱鏂板 P1-13锛堟姇璧勭郴缁熸柊妯℃澘鏀寔锛夛紱鏁版嵁蹇収琛� `investment_system` 琛� |
+| 2026-09-21锛堜笅鍗堬級 | P1-1 闂幆锛氱敤鎴烽噰鐢ㄦ柟妗� A锛屼腑鍙ｅ緞鎺掑悕鐨� 2025 绱鍩烘暟鏀硅姣嶇増銆婁腑鍙ｅ緞鏄庣粏銆嬮潤鎬佸垪锛涢粍鍐堢疮璁″悓姣旂敱 7.74% 淇涓� 7.641733%锛屽弻椤典竴鑷存�у洖褰掗�氳繃 |

--
Gitblit v1.9.1