From f89b6e35d179e7d994fde4eb8dce70706ea00824 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期一, 21 九月 2026 10:11:25 +0800
Subject: [PATCH] docs(交接): 新增总交接文档 + 日结补充 + 汇总大表问题交接归档

---
 docs/投资/输入/2026年8月投资系统项目明细.xls   |    0 
 docs/交接文档_2026-09-21.md          |  318 ++++++++++++++++++++++++++++
 docs/工作日结/工作日结_2026-09-21.md     |   81 +++++++
 docs/问题汇总/汇总大表问题交接_2026-09-21.md |  250 ++++++++++++++++++++++
 4 files changed, 649 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..9dcd74f
--- /dev/null
+++ "b/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-21.md"
@@ -0,0 +1,318 @@
+# 浜ら�氳揣杩愮粺璁″鏍哥郴缁� 鈥斺�� 鎬讳氦鎺ユ枃妗ｏ紙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锛夛細鈶� 8 鏈堝崄鍫扮墿娴佹簮鏂囦欢閲岀殑銆岄潪鍗佸牥娈点�嶄細鍙嶅鎶� 31 涓」鐩甫鍥炲簱锛涒憽 銆婁嚎鍏冩姇璧勯」鐩�嬫湀浠藉垪姣忔湀瑕嗙洊涓婃湀锛�
+   鈶� 瀵煎嚭鍓嶃�屽熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉銆嶅彧鍋氫簡涓�鍗婏紱鈶� 缂� 2026-06 / 2026-09 姣嶇増锛岄偅涓ゆ湡鍑轰笉浜嗚〃銆�
+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 | 璐ц繍浼佷笟鏈堟姤 |
+| `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锛� |
+| 鏈彁浜ゆ枃浠� | 鏈氦鎺ュ綋鏃剁殑鏈窡韪枃浠讹細`docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`銆乣docs/宸ヤ綔鏃ョ粨/宸ヤ綔鏃ョ粨_2026-09-21.md`銆乣docs/鎶曡祫/杈撳叆/2026骞�8鏈堟姇璧勭郴缁熼」鐩槑缁�.xls`銆乣docs/浜ゆ帴鏂囨。_2026-09-21.md`锛堥殢鏈浜ゆ帴涓�骞舵彁浜わ級 |
+
+### 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 鏈堝崄鍫扮墿娴佹眹鎬昏〃鍚�岄潪鍗佸牥娈点��** | 璇ユ枃浠朵竴涓〉绛炬敹浜嗗叏鐪侊細8 鏈堣繖浠� 38 琛岄噷鍙湁 **7 琛屾槸鍗佸牥**锛屽彟 **27 琛屾姹� + 4 琛岄粍鐭�**銆傜▼搴忕壒鎰忔敮鎸併�屾寜灏忚妭琛屽垏甯傚窞銆嶏紝鎵�浠ユ瘡娆￠噸瀵� 8 鏈堢墿娴侀兘浼氭妸杩� 31 涓」鐩缓鍒版姹�/榛勭煶鍚嶄笅锛�09-20 宸插疄娴嬪鐜� +31 椤圭洰锛岀敓鎴愯〃姝︽眽鐗╂祦娈典細澶� 27 琛岋級 | 搴撳凡娓呭共鍑�锛�152 椤圭洰 / 284 鏈堝害鏁帮紝2026-08 鏈堝害鏁� 136 琛屼笌閲嶅鍓嶉�愬�间竴鑷达級锛�**婧愭枃浠舵湭娓�** | 鐢ㄦ埛纭鍚庣敱鎺ユ墜浜哄垹娈碉紙鍏堝浠藉埌 `docs/鎶曡祫/杈撳嚭/`锛夛紝鎴栫敤鎴疯嚜琛屽湪 Excel 鍒犻櫎璇ヤ袱娈� | 鉂� |
+| 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/B锛�**寤鸿 A**锛堟帓鍚嶉〉鏀圭敤姣嶇増 2025 闈欐�佸垪锛� | 鉂岋紙璇﹁姹囨�诲ぇ琛ㄤ氦鎺ョ 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 鍒楋級鐨勬潵婧�/鏈熼棿寰呯‘璁� | 纭鍚庢柟鍙畻銆岃繍璺濆閫熷樊銆� | 馃敀 绛夌敤鎴� |
+
+### 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 杩樻槸 B锛燂紙寤鸿 A锛�
+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`锛変笌鎶曡祫/璐ц繍/瀹㈣繍鍚勭嚎閬楃暀 |
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-21.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-21.md"
new file mode 100644
index 0000000..3c1445c
--- /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-21.md"
@@ -0,0 +1,81 @@
+# 宸ヤ綔鏃ョ粨_2026-09-21
+
+## 涓�銆佷粖澶╁仛浜嗕粈涔�
+
+### 1. 瀹氫綅銆屾眹鎬诲ぇ琛ㄤ腑鍙ｅ緞鎺掑悕绱鍚屾瘮 7.74% vs 涓彛寰勬槑缁� 7.64%銆嶆牴鍥狅紙鐢ㄦ埛 09-21 鎻愰棶锛�
+
+**鐜拌薄**锛歚D:\妗岄潰\鐢熸垚鏁版嵁\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃 (3).xlsx` 涓紝
+銆屼腑鍙ｅ緞鎺掑悕銆峂13 榛勫唸 1-8 鏈堢疮璁″悓姣� 7.744917%锛屻�屼腑鍙ｅ緞鏄庣粏銆峊55 鍚屼竴鏍� 7.641733%锛�
+涓ら〉褰撴湀绱鍊肩浉鍚岋紙3480.930066022锛夛紝宸殑鍙槸鍘诲勾鍚屾湡鍩烘暟锛�3230.713965 vs 3233.810859锛屽樊 3.096894锛夈��
+
+**鎺掓煡杩囩▼涓庣粨璁�**锛堝叏閮ㄧ敤搴撳唴鏁版嵁 + 7 浠芥瘝鐗堝巻鍙茬増鏈�愭牸楠岃瘉锛夛細
+
+1. 鍥涗釜涓彛寰勭淮搴﹀垎鍒绠� 2025 骞� 1-8 鏈堬細鐝嚎+涓綋銆佸煄闄呭煄涔″叕浜ゃ�佸煄闄呭煄涔″贰娓稿嚭绉�**閫愪綅涓�鑷�**锛�
+   鍙湁**鍩庨檯鍩庝埂缃戠害杞�**涓�缁翠笉鍚岋紝涓斿彧鏈� **2025 骞� 3銆�4 鏈�**涓嶅悓锛堝叾浣� 6 涓湀閫愪綅涓�鑷达級锛�
+   - 2025-03 榛勫唸锛氭瘝鐗� 5.203089147 / 搴撶幇绠� 3.938965484锛堝樊 1.264123663锛�
+   - 2025-04 榛勫唸锛氭瘝鐗� 6.585331252 / 搴撶幇绠� 4.752560757锛堝樊 1.832770495锛�
+   - 鍚堣宸� 3.096894158锛屼笌涓ら〉鍩烘暟宸畬鍏ㄥ惢鍚堛��
+2. 鐢�**姣嶇増鑷繁鐨勫嚭绉熷垪**锛堜笌搴撻�愭牸涓�鑷达紝17 甯傚窞 脳 8 鏈堝叏瀵癸級+ 璁㈠崟 + pin 濂楃幇绠楁硶澶嶇畻锛�
+   1/2/5/6/7/8 鏈�**閫愪綅澶嶇幇锛堝亸宸� 0.000000000锛�**锛�3/4 鏈堝鐜颁笉鍑烘潵 鈫� 绠楁硶鏃犺锛屾槸閭ｄ袱鏍煎彟鏈夋潵婧愩��
+3. **鍚﹀畾銆�9/16 鍑虹琛ュ綍瀵艰嚧銆�**锛�9/8 绋嬪簭鏀瑰姩鍓嶇殑鍘熷姣嶇増
+   锛坄docs/鐢熸垚姹囨�诲ぇ琛�/_bak_202608姣嶇増淇敼鍓峗20260916/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛�
+   杩欎袱鏍�**鏈潵灏辨槸** 5.203089147 / 6.585331252锛屽悓鏈堝嚭绉熷垪涔熷凡涓庣幇搴撲竴鑷� 鈫� 鐭涚浘鍦� 9/8 涔嬪墠灏卞瓨鍦ㄣ��
+4. 鍙嶆帹閭ｄ袱鏍奸殣鍚緭鍏ワ紙鍓嶆彁宸查獙璇侊細姣嶇増 17 甯傚窞鍩庡競鍐呭姞鎬� = 2504.28 = 鍏ㄧ渷 pin 鍩庡競鍐咃紝鍒嗘涓嶅樊锛屾姹夎嚜鐣�
+   鈫� 鍒嗘憡瑙勫垯涓庣幇绠楁硶瀹屽叏鐩稿悓锛夛細闅愬惈鐨勩�屽贰娓稿嚭绉熷煄甯傚唴瀹㈣繍閲忋��16 涓競宸為噷 15 涓兘姣旂幇鍦ㄤ綆
+   锛堣崋宸� -41.38銆佹仼鏂� -34.65銆侀粍鍐� -26.13銆佸崄鍫� -20.31锛屼粎瀹滄槍 +2.27锛夈��
+5. **鏈�缁堢粨璁�**锛氭瘝鐗� 2025 骞� 3銆�4 鏈堢殑缃戠害杞︽媶鍒嗭紝鏄敤**鍙︿竴浠藉嚭绉熷煄甯傚唴鍙ｅ緞**绠楀嚭鏉ョ殑锛屼笌姣嶇増鑷甫鐨勫嚭绉熷垪鑷浉鐭涚浘锛�
+   9/16 鍑虹鍏ュ簱鍚庯紝鎺掑悕椤典竴鐜扮畻鎵嶆妸鐭涚浘鏄炬�у寲銆傚睘**銆屾帓琛岄〉鎸夊簱鐜扮畻 vs 鏄庣粏椤电敤姣嶇増闈欐�佸巻鍙层�嶇殑鍙岃建鍒�**闂銆�
+6. **褰卞搷闈�**锛氶櫎姝︽眽澶� 16 涓競宸炲叏鏈夊樊锛堝疁鏄� +0.55pp銆佸崄鍫� -0.35pp銆佽崋宸� -0.32pp銆侀剛宸� -0.30pp銆佽崋闂� -0.25pp銆�
+   鎭╂柦 -0.13pp銆侀粍鍐� -0.10pp鈥︼級锛�**鍏ㄧ渷琛屼袱椤靛畬鍏ㄤ竴鑷�**锛屽洜涓鸿繖鏄競宸炰箣闂寸殑鍒嗘憡宸紓锛屽姞鎬绘姷娑堛��
+
+### 2. 浜у嚭銆婃眹鎬诲ぇ琛ㄩ棶棰樹氦鎺ヨ鏄庛�嬶紙闈㈠悜鎺ユ墜鍚屼簨锛�
+
+- 浠撳簱锛歚docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`锛�250 琛岋級
+- 妗岄潰鍓湰锛歚D:\妗岄潰\姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`
+- 鍐呭锛氱幇鐘朵竴鍙ヨ瘽 / 鍓嶇疆闃呰 5 绡� / 鐢熸垚鍘熺悊 6 姝� / 闂鎬昏琛紙P0~P2锛�/ P0-1 鍘嗗彶鍩烘暟鍙岃建鍒跺畬鏁存牴鍥犱笌鏂规 A銆丅 /
+  P0-2 姣嶇増渚濊禆涓庛�屾瘡鏈堟崲姣嶇増銆嶄笁澶勫繀鏀圭偣鍙婃柟妗� / 宸蹭慨澶嶇殑 6 涓巻鍙插潙锛堥伩鍏嶆敼鍥炲幓锛�/ P2 寰呭姙 /
+  鍏抽敭浠ｇ爜鍦板浘锛堟枃浠�:琛屽彿锛�/ 鏁版嵁涓庣幆澧� / 璇佹嵁鏂囦欢娓呭崟 / 寰呬笟鍔＄‘璁ゆ竻鍗� / 寤鸿鎺ユ墜椤哄簭銆�
+
+### 3. 涓存椂璇佹嵁鏂囦欢锛堥」鐩牴鐩綍锛屾湭娓呯悊锛�
+
+`_chk_wyc4~7.txt`锛堢綉绾﹁溅閫愬競閫愭湀澶嶇畻锛夈�乣_chk_backsolve.txt`锛堝弽鎺ㄥ嚭绉熻緭鍏ワ級銆乣_chk_lineage*.txt`锛堟瘝鐗堣缂橈級銆�
+`_chk_rule.txt`锛堝�欓�夊叕寮忔帓闄わ級銆乣_chk_all_pref.txt`锛�17 甯傚窞宸紓娓呭崟锛夈�乣_chk_orig.txt`锛�9/8 鍘熷姣嶇増锛夌瓑銆�
+
+### 4. 浜у嚭銆婃�讳氦鎺ユ枃妗ｃ�嬶紙鐢ㄦ埛瑕佹眰銆屾妸瀛樺湪鐨勯棶棰樺拰娌″仛瀹岀殑宸ヤ綔閮藉啓杩涘幓锛岃秺璇︾粏瓒婂ソ銆嶏級
+
+- 浠撳簱锛歚docs/浜ゆ帴鏂囨。_2026-09-21.md`锛堢害 14.6 KB锛夈��
+- 瀹氫綅锛�**鍏ㄧ郴缁熷敮涓�鍏ュ彛**銆傛眹鎬诲ぇ琛ㄩ偅鏉＄嚎涓嶉噸鎶勶紝鍙仛鎽樿 + 鎸囧悜宸叉湁
+  `docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`锛岄伩鍏嶄袱浠芥枃妗ｅ啓鍚屼竴浠藉唴瀹瑰悗浜掔浉鎵撴灦锛堢敤鎴烽棶銆屾眹鎬讳篃鍦ㄥ啓瑕佷笉瑕佸啓涓�鍧椼�嶆椂纭鐨勫彛寰勶級銆�
+- 鍐呭锛氭帴鎵嬬 1 灏忔椂娓呭崟 / 鐜扮姸蹇収锛堟湇鍔÷锋暟鎹簱路浠撳簱锛屽潎涓� 09-21 涓婂崍瀹炴祴锛�/ 绯荤粺缁撴瀯涓庝唬鐮佸湴鍥� /
+  浜旀潯鏁版嵁閾撅紙璐ц繍鍛ㄨ浆閲忋�丠203-1銆佸煄甯傚杩愩�佹眹鎬诲ぇ琛ㄣ�佹姇璧� 5 寮犺〃锛�/ **鏈畬鎴愬伐浣� P0路P1路P2 鍏� 27 鏉�**锛堢幇璞÷峰奖鍝嵚疯瘉鎹蜂笅涓�姝ヂ风姸鎬侊級/
+  寰呬笟鍔＄‘璁ゆ竻鍗� 10 鏉� / 鍘嗗彶鍧戠储寮曚笌銆屾渶瀹规槗琚敼鍥炲幓鐨� 6 涓偣銆�/ 鎿嶄綔鎵嬪唽锛堝惎鍋溌稤B路鏈満鐗规湁鐨勫潙路浜や粯瑙勭煩锛�/ 鎺ユ墜绗竴灏忔椂 checklist銆�
+- 鏈鏍稿疄骞跺啓鍏ユ枃妗ｇ殑鍏抽敭浜嬪疄锛�
+  1. 鍚庣 8090銆佸墠绔� 8080 **褰撳墠鍧囧湪杩愯**锛堟帴鍙ｆ帰娲� 200锛夛紱
+  2. 搴撳唴 `investment_project` 152 / `investment_monthly` 284锛�2026-08 = 136锛夛紱
+  3. **2026-09 鑴忔湡宸叉竻鐞嗗共鍑�**锛堟鍓� 09-16 璁板綍鐨� 1284/31/2061/3 琛屽凡涓嶅瓨鍦級锛�
+  4. 姣嶇増鍙湁 2026骞�7鏈� / 2026骞�8鏈� 涓ゆ湰锛堢己 2026-06 / 2026-09锛夛紱
+  5. 鎶曡祫涓ゅ鏈疄鐜帮細**銆婁嚎鍏冩姇璧勯」鐩�嬫湀浠藉垪姣忔湀瑕嗙洊涓婃湀**锛圦7 瑕佹眰鐨勩�屾柊澧炰竴鍒椼�嶆湭鍋氾級銆�
+     **瀵煎嚭銆屾寜鏈堝垎鐩綍 + 鑷姩澶囦唤 + 杩愯鏃ュ織/鏍￠獙鎶ラ敊銆嶆湭瀹炵幇**锛圦10 宸茬瓟鍚屾剰锛夛紱
+  6. 瀵煎嚭鍓嶅熀鏁颁綋妫�锛圔4锛夊彧鍋氫簡涓�鍗婏細鍚庣 `getLastMidIssues()` **鏃犱换浣曡皟鐢ㄦ柟**锛屽墠绔湭娑堣垂銆佹棤銆婃暟鎹己澶辨竻鍗曘�嬮〉銆�
+
+## 浜屻�佹祴璇曠粨鏋滄憳瑕�
+
+- 鏈**鏃犱唬鐮佹敼鍔�**锛屾棤銆婂姛鑳芥祴璇曟姤鍛娿�嬶紙浠呮湁鏁版嵁鏍告煡锛夈��
+- 鏁版嵁鏍告煡鍙ｅ緞锛氬叏閮ㄧ粨鏋滀笌搴撳唴 `h2031_enterprise_monthly` / `passenger_individual_monthly` /
+  `city_bus_monthly` / `city_taxi_monthly` / `wyc_order_monthly` 鐜扮畻鍊奸�愪綅姣斿锛�17 甯傚窞 脳 8 涓湀锛�
+  涓�鑷存�ц揪 1e-9锛涘鐜拌剼鏈笌涓棿杈撳嚭宸茬暀妗ｏ紙瑙佷笂锛夈��
+
+## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙
+
+1. **P0-1**锛氬巻鍙插悓姣斿熀鏁板弻杞ㄥ埗 鈥斺�� 鏂规 A锛堟帓鍚嶉〉鏀圭敤姣嶇増 2025 闈欐�佸垪锛屾帹鑽愶級/ 鏂规 B锛堟槑缁嗛〉鏀圭幇绠楋級
+   寰呯敤鎴锋媿鏉匡紝**鏈疄鏂�**銆�
+2. **P0-2**锛氭瘝鐗堜緷璧� 鈥斺�� 9 鏈堝嚭琛ㄩ渶鍏堟湁鏂版瘝鐗堬紱鏂规 A锛堢▼搴忚嚜鍔ㄦ墿鍒楋紝2-3 澶╋級/ 鏂规 B锛圗xcel 灏忓伐鍏凤紝1 澶╋級寰呮媿鏉裤��
+3. P2锛欱4 瀵煎嚭鍓嶅熀鏁颁綋妫� + 銆婃暟鎹己澶辨竻鍗曘�嬮〉銆丏 缁勫閫熸帓鍚嶆帾杈炪�佷腑鍙ｅ緞鏄庣粏 4 鏍� `#DIV/0!`銆�
+   缂烘瘝鐗堟彁绀哄疄娴嬨�侀儴缃插寘鏃ф瘝鐗堬紙鐢ㄦ埛鏄庣‘鏆備笉澶勭悊锛夈��
+4. 鏈浜у嚭鐨勪氦鎺ユ枃妗ｆ槸鍚﹀綊妗ｈ繘 gitea / 鏄惁鎺ㄩ�佹湰鍦版湭鎺ㄦ彁浜わ紙09-18 璧风殑鏈湴鎻愪氦灏氭湭鎺ㄥ叕鍙� gitea锛夛紝寰呯敤鎴风‘璁ゃ��
+
+## 鍥涖�佹槑鏃ヨ鍒�
+
+1. 鎸夌敤鎴锋媿鏉跨殑鏂规瀹炴柦 P0-1锛堟柟妗� A锛夊苟鍑恒�婂姛鑳芥祴璇曟姤鍛娿��+ 鍙岄〉鍚屾瘮涓�鑷存�у洖褰掋��
+2. P0-2 鍏堝嚭 9 鏈堟瘝鐗堬紙鏂规 B 搴旀�ワ級锛屽啀鎺掓柟妗� A 鐨勬墿鍒楀櫒涓庛��7 鏈堟瘝鐗堟墿 8 鏈堛�嶉�愭牸 diff 楠岃瘉銆�
+3. 閰嶅悎鎺ユ墜鍚屼簨杩囦竴閬嶃�婃眹鎬诲ぇ琛ㄩ棶棰樹氦鎺ヨ鏄庛�嬶紝绛旂枒骞惰ˉ鍏呴仐婕忋��
diff --git "a/docs/\346\212\225\350\265\204/\350\276\223\345\205\245/2026\345\271\2648\346\234\210\346\212\225\350\265\204\347\263\273\347\273\237\351\241\271\347\233\256\346\230\216\347\273\206.xls" "b/docs/\346\212\225\350\265\204/\350\276\223\345\205\245/2026\345\271\2648\346\234\210\346\212\225\350\265\204\347\263\273\347\273\237\351\241\271\347\233\256\346\230\216\347\273\206.xls"
new file mode 100644
index 0000000..525e367
--- /dev/null
+++ "b/docs/\346\212\225\350\265\204/\350\276\223\345\205\245/2026\345\271\2648\346\234\210\346\212\225\350\265\204\347\263\273\347\273\237\351\241\271\347\233\256\346\230\216\347\273\206.xls"
Binary files differ
diff --git "a/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\346\261\207\346\200\273\345\244\247\350\241\250\351\227\256\351\242\230\344\272\244\346\216\245_2026-09-21.md" "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\346\261\207\346\200\273\345\244\247\350\241\250\351\227\256\351\242\230\344\272\244\346\216\245_2026-09-21.md"
new file mode 100644
index 0000000..1e9b8b9
--- /dev/null
+++ "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\346\261\207\346\200\273\345\244\247\350\241\250\351\227\256\351\242\230\344\272\244\346\216\245_2026-09-21.md"
@@ -0,0 +1,250 @@
+# 姹囨�诲ぇ琛紙閬撹矾杩愯緭閲忔眹鎬昏〃锛夐棶棰樹氦鎺ヨ鏄�
+
+> 浜ゆ帴鏃ユ湡锛�2026-09-21銆�浜ゆ帴浜猴細閮戠帀娲併��鎺ユ墜浜猴細寰呭畾
+> 鑼冨洿锛氭姤琛ㄧ敓鎴� 鈫� 姹囨�诲ぇ琛紙`鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx`锛�19 涓〉绛撅級涓�閿敓鎴愬姛鑳藉強鍏跺叏閮ㄩ仐鐣欓棶棰�
+> 鏈枃鍙啓銆屾帴鎵嬩汉鍔ㄦ墜鍓嶅繀椤荤煡閬撶殑浜嬨�嶏紝鍔熻兘鍏ㄨ矊瑙佺 1 鑺傚垪鐨勫墠缃枃妗ｃ��
+
+## 0. 涓�鍙ヨ瘽鐜扮姸
+
+8 鏈堟眹鎬诲ぇ琛ㄥ凡鑳藉仛鍒般�屽鍏ュ熀纭�鏁版嵁 鈫� 涓�閿敓鎴愩�嶏紝涓庝汉宸ユ瘝鐗堥�愭牸姣斿鍩烘湰涓�鑷淬�備絾鏈変袱涓珮鍗遍仐鐣欙細
+
+1. **鍘嗗彶鍚屾湡锛�2025 骞达級鍒楀湪涓ゅ鍙ｅ緞涔嬮棿娌℃湁缁熶竴** 鈥斺�� 銆屼腑鍙ｅ緞鎺掑悕銆嶉〉涓庛�屼腑鍙ｅ緞鏄庣粏銆嶉〉鐨勭疮璁″悓姣斿涓嶄笂锛堥粍鍐� 7.74% vs 7.64%锛夛紝**杩欐槸绗竴浼樺厛闂**銆�
+2. **姣忔湀瑕佷汉宸ュ噯澶囦竴浠芥柊姣嶇増**锛岀▼搴忎笉浼氳嚜宸辨墿鍒楋紝9 鏈堝強浠ュ悗涓嶈В鍐冲氨浼氬崱浣忓嚭琛ㄣ��
+
+## 1. 鍓嶇疆闃呰锛堝厛鐪嬭繖 5 浠斤紝绾� 30 鍒嗛挓寤虹珛姒傚康锛�
+
+| 鏂囨。 | 浣滅敤 |
+| --- | --- |
+| `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳叆杈撳嚭涓庨�昏緫鍏崇郴鎬昏〃_2026-09-03.md` | 姣忎釜椤电鐨勮緭鍏ャ�佽緭鍑恒�佸彇鏁版潵婧� |
+| `docs/鐢熸垚姹囨�诲ぇ琛�/椤电閫昏緫鍏崇郴璇存槑.md` | 椤电涔嬮棿鐨勫叕寮忎緷璧栧叧绯� |
+| `docs/姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犳柟妗坃2026-09-07.md` | 鏁版嵁椹卞姩鏀归�犵殑鏁翠綋璁捐 |
+| `docs/闂姹囨��/姹囨�昏〃闂姹囨�籣2026-09-17.md` | 绗竴鎵癸紙8 鏈堢┖鐧�/鎺掑悕涓嶅锛夌殑闂涓庢牴鍥� |
+| `docs/闂姹囨��/姹囨�昏〃涓夋潯涓荤嚎淇鏂规_2026-09-18.md` | 銆屽叕寮忎笉閲嶇畻銆嶄富绾跨殑淇鏂规 |
+
+瀵瑰/瀵瑰悓浜嬭В閲婄敤锛歚D:\妗岄潰\鎶ヨ〃鐢熸垚鍘熺悊璇存槑_2026-09-20.md`銆乣D:\妗岄潰\绯荤粺瀹炵幇姹囨�昏鏄巁2026-09-20.md`銆�
+
+## 2. 鐢熸垚鍘熺悊閫熻锛�6 姝ワ級
+
+鍏ュ彛锛氬墠绔� `traffic-audit-web/src/views/ReportExport.vue`锛堟姤琛ㄧ敓鎴愰〉鍕鹃�夈�屾眹鎬诲ぇ琛ㄣ�嶏級鈫� 鍚庣 `ReportExportController` 鈫� `ReportExportTaskService`锛堝紓姝ヤ换鍔� + 杩涘害 + 10 鍒嗛挓鍐呭瓨缂撳瓨锛夆啋 `ReportExportService.exportSummaryWorkbook()`锛坄ReportExportService.java:3522`锛夈��
+
+1. **鎵炬瘝鐗�**锛歚resolveSummaryMother()`锛�:4464锛夊湪 `docs/鐢熸垚姹囨�诲ぇ琛�/` 涓嬫寜鏂囦欢鍚� `{yyyy}骞磠M}鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` **绮剧‘鏌ユ壘**锛屾壘涓嶅埌鐩存帴鎶ャ�屾湭鎵惧埌妯℃澘鏂囦欢銆嶃�傛瘝鐗�**涓嶅叆搴撱�佷笉闅忕▼搴忓垎鍙�**銆�
+2. **鍥炲～鍙拌处椤靛綋鏈堝��**锛歚SummaryWorkbookFiller.fillMonthlyLedger()`锛坄SummaryWorkbookFiller.java:54`锛夊洖濉� 6 寮犲彴璐﹂〉 鈥斺�� 鐝嚎鍖呰溅/鍏氦/鍑虹锛坄fillCityRows()`锛屽啓 1~褰撴湀鍏ㄦ湀锛夈�佽建閬撹疆娓°�佽揣杩愩�佺綉绾﹁溅锛堝悗涓よ��**鍙啓褰撴湀**锛屽巻鍙叉湀娌跨敤姣嶇増锛夈��
+3. **琛ラ綈鍏紡**锛歚ensureMonthFormulas()`锛�:432锛�+ `ensureMonthYoyFormulas()`锛�:549锛夋寜鏈堟妸銆屽綋鏈堝��/鍚屾瘮/绱銆嶅叕寮忓彸绉伙紱`repairCumulativeYoyFormulas()`锛�:777锛変慨绱鍚屾瘮鍒嗘瘝銆�
+4. **鐜扮畻鎴愬搧椤�**锛歚refreshSummaryCumulativeSheets()`锛�:3984锛夐噸绠� 鍩庡競姹囨�� / 鍩庡競鍒嗗競宸� / 涓彛寰勫垎鏋� / 閬撹矾杩愯緭鍛ㄨ浆閲� 鍥涢〉銆�
+5. **鎼�兼帓鍚嶉〉**锛歚refreshSummaryRankSheets()`锛�:3753锛夆啋 `copyRankValues()`锛�:3766锛夋妸 `exportFreightRank / exportTurnoverRank / exportPassengerMidRank` 涓変釜鐙珛鐢熸垚鍣ㄧ殑缁撴灉鎷疯繘 璐ц繍閲忔帓鍚� / 璐ц繍鍛ㄨ浆閲忔帓鍚� / 涓彛寰勬帓鍚嶃��
+6. **鏀跺熬**锛歚applyTwoDecimalFormat()`锛堝叏绮惧害瀛樺偍 + 鏄剧ず涓や綅灏忔暟锛夆啋 `recalcWorkbookFormulas()`锛�:3601锛宍evaluateAll` 鍐欏洖缂撳瓨鍊硷級鈫� `fullCalcOnLoad=true` 鈫� 杈撳嚭銆�
+
+> **鍏抽敭璁ょ煡**锛氭瘝鐗堟湰韬氨鏄叕寮忛┍鍔ㄧ殑銆傚叏鐪佽 = 危17 甯傚窞锛涘煄甯傚杩� / 涓彛寰勬槑缁� = 璺ㄨ〃寮曠敤锛堝 `鍩庡競瀹㈣繍!C9 = =鍏氦!C16+鍑虹!C16+缃戠害杞�!C16+'杞ㄩ亾銆佽疆娓�'!C9`锛夈�傛墍浠ヨ繖涓ら〉**涓嶉渶瑕佸崟鐙啓鏁�**锛屽彧瑕佸叕寮忔寜鏈堣ˉ榻� + 閲嶇畻鍗冲彲銆�
+
+## 3. 闂鎬昏
+
+| 缂栧彿 | 闂 | 鐘舵�� | 浼樺厛绾� |
+| --- | --- | --- | --- |
+| P0-1 | 鍘嗗彶鍚屾瘮鍩烘暟銆屽弻杞ㄥ埗銆嶏細涓彛寰勬帓鍚� vs 涓彛寰勬槑缁� 绱鍚屾瘮鍏ㄥ競宸炰笉涓�鑷� | **鏈В鍐�** | 楂� |
+| P0-2 | 姣嶇増渚濊禆锛氭瘡鏈堣浜哄伐鍑嗗鏂版瘝鐗堬紝绋嬪簭涓嶄細鑷繁鎵╁垪 | **鏈В鍐�** | 楂� |
+| P1-1 | 鍩庡競瀹㈣繍椤� AJ 鍒楋紙2025骞�1-7鏈堢疮璁★級娈嬬暀鍦ㄧ敓鎴愯〃 | 宸蹭慨澶� 09-20 | - |
+| P1-2 | 涓彛寰勬帓鍚嶅懆杞噺鍙ｅ緞涓庝汉宸ュ垪涓嶄竴鑷� | 宸蹭慨澶� 09-19 | - |
+| P1-3 | 涓彛寰勬帓鍚嶅悓姣斾笌鍩庡競瀹㈣繍鍒楅敊浣� | 宸蹭慨澶� 09-18 | - |
+| P1-4 | 鍏紡鍐欎簡浣嗘棤缂撳瓨鍊硷紝棰勮/浜屾澶勭悊鐪嬪埌鏃у�� | 宸蹭慨澶� 09-18 | - |
+| P2-1 | 瀵煎嚭鍓嶅熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉锛圔4锛� | 寰呮帓鏈� | 涓� |
+| P2-2 | 澧為�熸帓鍚嶆帾杈烇紙D 缁勶級 | 寰呮帓鏈� | 浣� |
+| P2-3 | 涓彛寰勬槑缁� 4 鏍� `#DIV/0!`锛�2025 骞� 8 鏈堝熀鏁颁负 0锛� | 寰呬笟鍔＄‘璁� | 浣� |
+| P2-4 | 缂烘瘝鐗堟彁绀烘湭瀹炴祴锛涢儴缃插寘鍐呮槸甯� AJ 鍒楃殑鏃ф瘝鐗� | 寰呭鐞� | 浣� |
+
+## 4. P0-1 鍘嗗彶鍚屾瘮鍩烘暟銆屽弻杞ㄥ埗銆嶏紙鏈浜ゆ帴閲嶇偣锛�
+
+### 4.1 鐜拌薄
+
+`D:\妗岄潰\鐢熸垚鏁版嵁\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃 (3).xlsx`锛�2026-09-20 14:42 鐢熸垚锛夛細
+
+- 銆屼腑鍙ｅ緞鎺掑悕銆峂13 榛勫唸 1-8 鏈堢疮璁″悓姣� = **7.744917%**
+- 銆屼腑鍙ｅ緞鏄庣粏銆峊55 鍚屼竴鏍� = **7.641733%**
+- 涓ら〉褰撴湀绱鍊煎畬鍏ㄧ浉鍚岋紙`3480.930066022`锛夛紝宸殑鍙槸**鍘诲勾鍚屾湡鍩烘暟**锛氭帓鍚嶉〉 `3230.713965` vs 鏄庣粏椤� `3233.810859`锛屽樊 `3.096894`銆�
+
+### 4.2 鏍瑰洜锛氫袱椤电殑鍘诲勾鍚屾湡鍩烘暟鏉ユ簮涓嶅悓
+
+| 椤电 | 鍘诲勾鍚屾湡锛�2025锛夋�庝箞鏉ョ殑 | 浠ｇ爜浣嶇疆 |
+| --- | --- | --- |
+| 涓彛寰勬帓鍚� | **鏌ュ簱鐜扮畻**锛屽洓涓淮搴﹀叏閮ㄧ幇绠楋紙鍚綉绾﹁溅鎷嗗垎锛� | `loadMidClassMap()` `ReportExportService.java:2441`锛涚綉绾﹁溅缁村害 :2531锛涘悓姣� `midCumYoy()` :2404 |
+| 涓彛寰勬槑缁� | 2025 鍒楀湪姣嶇増閲屾槸**鍐欐鐨勯潤鎬佹暟鍊硷紙鏃犲叕寮忥級**锛岀▼搴忎笉閲嶇畻 | 鐢熸垚浠躲�屼腑鍙ｅ緞鏄庣粏銆峍/X/Z鈥J 鍒楋紱`fillMonthlyLedger()` 涓嶅啓 2025 鍒� |
+
+### 4.3 宸紓瀹氫綅锛堝凡閫愬眰楠岃瘉鍒板崟鍏冩牸锛�
+
+1. 鍥涗釜缁村害鍒嗗埆姣斿 2025 骞� 1-8 鏈堬細鐝嚎+涓綋銆佸煄闄呭煄涔″叕浜ゃ�佸煄闄呭煄涔″贰娓稿嚭绉� **鍏ㄩ儴閫愪綅涓�鑷�**锛涘彧鏈�**鍩庨檯鍩庝埂缃戠害杞�**涓�缁翠笉鍚屻��
+2. 璇ョ淮鍙湁 **2025 骞� 3銆�4 鏈�**涓嶅悓锛堝叾浣� 6 涓湀閫愪綅涓�鑷达級锛�
+
+| | 姣嶇増闈欐�佸�� | 搴撶幇绠� | 宸� |
+| --- | --- | --- | --- |
+| 2025-03 榛勫唸 | 5.203089147 | 3.938965484 | 1.264123663 |
+| 2025-04 榛勫唸 | 6.585331252 | 4.752560757 | 1.832770495 |
+| 鍚堣 | 56.317159454 | 53.220265295 | **3.096894158** |
+
+   涓庝袱椤靛熀鏁板樊 `3.096894` 瀹屽叏鍚诲悎銆�
+
+3. 鐢�**姣嶇増鑷繁鐨勫嚭绉熷垪**锛堜笌搴撻�愭牸涓�鑷达級+ 璁㈠崟 + pin 濂楃幇绠楁硶澶嶇畻锛�**1/2/5/6/7/8 鏈堥�愪綅澶嶇幇锛堝亸宸� 0.000000000锛�**锛�3/4 鏈堝鐜颁笉鍑烘潵 鈫� 绠楁硶娌￠棶棰橈紝鏄偅涓ゆ牸鍙︽湁鏉ユ簮銆�
+
+### 4.4 閭ｄ袱鏍煎埌搴曟槸浠�涔堬紙閲嶈锛岄伩鍏嶆帴鎵嬪悗璧板集璺級
+
+- 姣嶇増锛堝惈 **9/8 绋嬪簭灏氭湭鏀瑰姩鍓嶇殑鍘熷姣嶇増** `docs/鐢熸垚姹囨�诲ぇ琛�/_bak_202608姣嶇増淇敼鍓峗20260916/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛夐噷锛岃繖涓ゆ牸**鏈潵灏辨槸** `5.203089147` / `6.585331252` 鈥斺�� 涓嶆槸绋嬪簭绠楀嚭鏉ョ殑锛屾槸鐪侀噷鎻愪緵鐨勬ā鏉胯嚜甯︾殑銆�
+- **涓嶆槸 9/16 鍑虹琛ュ綍瀵艰嚧鐨�**锛�9/8 鍘熷姣嶇増鐨勫嚭绉熷垪锛�417.01/404.51銆�410.7/398.38锛夊氨宸茬粡鍜岀幇鍦ㄥ簱閲屼竴妯′竴鏍枫��
+- 鍙嶆帹杩欎袱鏍奸殣鍚殑杈撳叆锛堝墠鎻愬凡楠岃瘉锛氭瘝鐗� 17 甯傚窞銆屽煄甯傚唴銆嶅姞鎬� = `2504.28` = 鍏ㄧ渷 pin 鍩庡競鍐咃紝鍒嗘涓嶅樊锛屾姹夎嚜鐣� 鈫� **鍒嗘憡瑙勫垯涓庣幇绠楁硶瀹屽叏鐩稿悓**锛夛細
+
+| 甯傚窞 | 鐜板簱鍑虹鍩庡競鍐� | 鍙嶆帹褰撴椂鍊� | 宸� |
+| --- | --- | --- | --- |
+| 鑽嗗窞 | 755.90 | 714.52 | -41.38 |
+| 鎭╂柦 | 496.19 | 461.54 | -34.65 |
+| **榛勫唸** | **404.51** | **378.38** | **-26.13** |
+| 鍗佸牥 | 339.59 | 319.28 | -20.31 |
+| 瀹滄槍 | 649.59 | 651.86 | +2.27 |
+
+   锛�2025-04 鍚岄噺绾э細鑽嗗窞 -43.71銆侀粍鍐� -28.11銆佹仼鏂� -27.20鈥︼級
+
+- **缁撹**锛氭瘝鐗� 2025 骞� 3銆�4 鏈堢殑缃戠害杞︽媶鍒嗭紝鏄敤**鍙︿竴浠姐�屽贰娓稿嚭绉熷煄甯傚唴瀹㈣繍閲忋��**锛�16 涓競宸為噷 15 涓兘姣旂幇鍦ㄤ綆锛夌畻鍑烘潵鐨勶紝鑰屾瘝鐗�/搴撻噷鍚屼竴寮犺〃鐨勫嚭绉熷垪鍗存槸璋冩暣鍚庣殑鍊� 鈥斺�� **姣嶇増杩欎袱鍒楄嚜鐩哥煕鐩�**銆�9/16 鍑虹鍏ュ簱鍚庯紝鎺掑悕椤典竴鐜扮畻锛岀煕鐩炬墠绗竴娆℃樉鎬у寲銆�
+
+### 4.5 褰卞搷闈�
+
+- **涓嶅彧榛勫唸**锛氶櫎姝︽眽锛堢綉绾﹁溅鍩庡競鍐呭崰姣� = 100%锛屼笉鍙備笌鍒嗘憡锛夊锛�**16 涓競宸炲叏閮芥湁宸�**銆�
+
+| 甯傚窞 | 鍚屾瘮宸�(鐧惧垎鐐�) | 甯傚窞 | 鍚屾瘮宸�(鐧惧垎鐐�) |
+| --- | --- | --- | --- |
+| 瀹滄槍 | +0.5476 | 鑽嗗窞 | -0.3187 |
+| 鍗佸牥 | -0.3529 | 閯傚窞 | -0.2986 |
+| 榛勫唸 | -0.1032 | 鑽嗛棬 | -0.2524 |
+| 鎭╂柦 | -0.1342 | 榛勭煶 | +0.0914 |
+| 瀛濇劅 | -0.0662 | 鍜稿畞 | -0.0526 |
+| 闅忓窞 | -0.0349 | 瑗勯槼 | -0.0352 |
+| 浠欐 | -0.0020 | 娼滄睙 | -0.0174 |
+| 澶╅棬 | -0.0236 | 绁炲啘鏋� | -0.0031 |
+
+- **鍏ㄧ渷琛屼袱椤靛畬鍏ㄤ竴鑷�**锛�31528.0607 / 5.810558%锛夛紝鍥犱负杩欐槸**甯傚窞涔嬮棿鐨勫垎鎽婂樊寮�**锛屽叏鐪佸姞鎬荤浉浜掓姷娑堛��
+
+### 4.6 澶勭疆鏂规锛堝緟鎷嶆澘锛屽皻鏈疄鏂斤級
+
+- **鏂规 A锛堟帹鑽愶紝鏀瑰姩灏忥級**锛氳 `exportPassengerMidRank()` 鍙栥�屽幓骞村悓鏈熺疮璁°�嶆椂锛屾敼鐢ㄦ瘝鐗堥偅浠� 2025 闈欐�佸垪锛堜笌涓彛寰勬槑缁嗗悓婧愶級銆�
+  - 鐞嗙敱锛氬澶栧彂甯冪殑鍚屾瘮锛屽熀鏁版湰璇ョ敤鍘诲勾瀹氱鍊硷紱鍙姩鎺掑悕椤� `midCumYoy/midCumClass` 鐨勫彇鏁版潵婧愶紝2026 褰撴湀鍊间笉鍙楀奖鍝嶃��
+  - 瑕佺偣锛氭妸姣嶇増 2025 鍒楄鎴愬唴瀛樻槧灏勶紙鎸夈�屽競宸�+鎸囨爣+鏈堛�嶏級渚涙帓鍚嶉〉鍙栫敤锛涙垨鐩存帴璁╂帓鍚嶉〉鍚屾瘮鏍兼敼鎴愬紩鐢ㄤ腑鍙ｅ緞鏄庣粏椤电殑鍏紡銆�
+- **鏂规 B**锛氭妸涓彛寰勬槑缁� 2025 鍒椾篃鏀规垚搴撳唴鐜扮畻锛屼袱椤甸兘鐢ㄥ簱銆�
+  - 浠ｄ环锛氫細鏀瑰姩**鎵�鏈夊凡瀹氱鐨� 2025 鍩烘暟**锛屽繀椤荤渷灞�纭銆�
+- **闄勫甫寤鸿**锛氬姞涓�鏉″鍑烘牎楠� 鈥斺�� 涓ら〉鍚屽煄鍚屾湀鍩烘暟涓嶄竴鑷村氨鍐欒繘 `problems`锛圔4 浣撴宸叉湁妗嗘灦锛岃 P2-1锛夈��
+
+### 4.7 鍥炲綊楠岃瘉鏂规硶锛堟敼瀹屽繀椤昏窇锛�
+
+1. 鐢熸垚 2026-08 姹囨�昏〃锛�
+2. 瀵� 17 甯傚窞 脳 瀹㈣繍閲�/鍛ㄨ浆閲忥紝閫愭牸姣斿銆屼腑鍙ｅ緞鎺掑悕銆嶄笌銆屼腑鍙ｅ緞鏄庣粏銆嶇殑绱鍚屾瘮锛岃姹�**鍏ㄩ儴涓�鑷�**锛�
+3. 鍙嶅悜鏍￠獙鍏ㄧ渷琛屼粛绛変簬 危17 甯傚窞銆佷笖鍏ㄧ渷鍚屾瘮涓ら〉涓�鑷达紱
+4. 椤哄甫纭 2026 骞� 1-8 鏈堝悇鏈堝綋鏈堝悓姣斾袱椤典粛涓�鑷达紙褰撳墠鏄竴鑷寸殑锛屽埆鏀瑰潖锛夈��
+
+## 5. P0-2 姣嶇増渚濊禆涓庛�屾瘡鏈堟崲姣嶇増銆�
+
+### 5.1 鐜扮姸鏈哄埗
+
+- 姣嶇増鐩綍 `docs/鐢熸垚姹囨�诲ぇ琛�/`锛屽悎娉曟枃浠跺悕鍙湁 `{yyyy}骞磠M}鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` 涓�绉嶏紙`resolveSummaryMother()` :4464锛夈��
+- 绋嬪簭**鍙寜鏂囦欢鍚嶇簿纭尮閰�**锛屾壘涓嶅埌鍗虫姤銆屾湭鎵惧埌妯℃澘鏂囦欢銆嶏紝**涓嶄細鑷繁寤烘ā鏉�**銆�
+- 鍙︽湁 `_澶囦唤_` 鍓嶇紑鐨勫巻鍙插悓鏈熸瘝鐗堣繕鍘熼�昏緫锛坄resolveSummaryDonor`锛夊拰涓�鎵� `_bak_` 澶囦唤鏂囦欢锛�**鍒贡鍒�**銆�
+
+### 5.2 鐥涚偣
+
+- 瑕佸嚭 9 鏈堣〃锛屽氨蹇呴』浜哄伐鍏堝仛涓�浠姐��2026骞�9鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬫斁杩涙瘝鐗堢洰褰曪紱鐢ㄦ埛鏄庣‘琛ㄧず銆岃繖鏍峰緢楹荤儲銆嶃��
+- 姣忓姞涓�涓湀瑕佸姩鐨勫湴鏂癸紙缁忔牳瀹炲彧鏈� 3 澶勶級锛�
+  1. 鏂版湀浠藉垪鐨勫悓姣斿叕寮忥紙`=Q{row}/AJ{row}-1` 杩欑被锛屽彸绉� 2 鍒楋級锛�
+  2. 绱鍒楃殑鏋氫妇瑕佽ˉ褰撴湀锛堝 `SUM(V,X,Z,AB,AD,AF,AH,AJ)` 鈫� 鍐嶈ˉ AL锛夛紱
+  3. **鎻掑垪鍙充晶鐨� 2025/2024/2023 涓夊潡鍘嗗彶鍖哄強鍏跺嚑鍗冩潯鍏紡寮曠敤闇�瑕� +2** 鈥斺�� POI 涓嶄細鍍� Excel 閭ｆ牱鑷姩鏀瑰啓寮曠敤锛屽繀椤荤▼搴忔樉寮忓钩绉汇��
+
+### 5.3 鏂规锛堝緟鎷嶆澘锛�
+
+- **鏂规 A锛堢▼搴忚嚜鍔ㄦ墿鍒楋級**锛氶璁� 2-3 澶┿�傜涓�姝ュ彧鍋氥�屾墿鍒楀櫒 + 鐢� 7 鏈堟瘝鐗堟墿鍑� 8 鏈堛�佷笌鐪熷疄 8 鏈堟瘝鐗堥�愭牸 diff銆嶇殑楠岃瘉鎶ュ憡锛岃瘉鏄庢墿鍒楀櫒鍙潬鍚庡啀鍋氭暣閾俱��
+- **鏂规 B锛堟湰鏈� Excel 灏忓伐鍏蜂竴閿墿鍒楋級**锛氶璁� 1 澶┿�傜敤 Excel COM 鎻掑垪锛堝紩鐢ㄧ敱 Excel 鑷姩璋冩暣锛岀渷鎺夌 3 澶勫钩绉伙級锛岀敓鎴愭柊姣嶇増銆�
+- 寤鸿锛氬厛 B 搴旀�ワ紙淇濊瘉 9 鏈堝嚭琛級锛屽啀 A 鍋氶暱鏁堛��
+
+### 5.4 楠岃瘉鏂规硶
+
+鐢� 7 鏈堟瘝鐗堟墿鍒楀嚭 8 鏈堢粨鏋勶紝涓� `docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛堝凡浜哄伐鍒犺繃 AJ 鍒楋級閫愭牸 diff锛屽樊寮傚繀椤讳负 0 鎴栧叏閮ㄥ彲瑙ｉ噴銆�
+
+## 6. 宸蹭慨澶嶄絾蹇呴』鐭ユ倝鐨勫巻鍙插潙锛堥伩鍏嶆敼鍥炲幓锛�
+
+1. **鍩庡競瀹㈣繍椤� AJ 鍒�**锛�09-20锛夛細8 鏈堟瘝鐗堝煄甯傚杩愰〉澶氫簡涓�鍒椼��2025骞�1-7鏈堢疮璁°�嶏紝鎶� 2025 骞� 8 鏈堝垪鎸ゅ埌 AK锛屽鑷� 8 鏈堝悓姣斿彉鎴愩��8鏈� 梅 1-7鏈堢疮璁°�嶃�佺疮璁″悓姣旀紡璁°�傚凡鐢� Excel COM 鏁村垪鍒犻櫎 AJ 骞惰繕鍘� 36 澶勮 `#REF!` 鐨勫叕寮忥紱澶囦唤 `_bak_202608姣嶇増鍒犻櫎AJ鍒楀墠_20260920.xlsx`銆�**娉ㄦ剰锛氱敤鎴峰綋鏃跺垹鐨勬槸 7 鏈堟瘝鐗堬紝鑰� 8 鏈堝鍑虹敤鐨勬槸 8 鏈堟瘝鐗� 鈥斺�� 姣嶇増鏈変袱鏈紝鏀逛箣鍓嶅厛纭鏀瑰鍝湰銆�**
+2. **鍒楀彿 0 鍩�/1 鍩�**锛�09-20锛夛細`colIndexOf()` 鏇捐繑鍥� 1 鍩哄垪鍙凤紝POI 瑕� 0 鍩猴紝瀵艰嚧鍏紡鍙崇Щ 2 鍒楀彉鎴愯嚜寮曠敤銆�360 鏍煎惊鐜紩鐢ㄣ�傚凡淇紝鏂板啓鍒楀彿鎹㈢畻鏃跺姟蹇呭娴嬨��
+3. **`setCellFormula` 涓嶆帴鍙楀甫 `=` 鍓嶇紑**锛�09-20锛夛細寮傚父鍙堣 `catch (Exception ignore)` 鍚炴帀锛屽鑷寸疮璁″悓姣斿垎姣嶄慨姝ｉ潤榛樺け鏁堛�傚凡鏀规垚 WARN 鏃ュ織锛�**鎺ユ墜鍚庢柊鍐欏叕寮忔椂涓嶈鍐嶅悶寮傚父**銆�
+4. **鍏紡蹇呴』閲嶇畻鍐欑紦瀛樺��**锛�09-18锛夛細POI 鍐欐枃浠朵笉绠楀叕寮忥紝Excel 鎵撳紑闈� `fullCalcOnLoad` 浼氱畻锛屼絾绯荤粺棰勮銆佷簩娆″鐞嗐�侀儴鍒� WPS 鐪嬩笉鍒般�傜幇宸插湪鏀跺熬缁熶竴 `evaluateAll`锛坄recalcWorkbookFormulas()` :3601锛夈��
+5. **涓彛寰勬帓鍚嶅懆杞噺鍙ｅ緞缁熶竴**锛�09-19锛夛細鍩庨檯鍩庝埂涓�寰嬬敤銆屾�婚噺 - 鍩庡競鍐呫�嶇幇绠楋紙`ReportExportService.java:2504` 闄勮繎娉ㄩ噴锛夛紝鍘熴�屽瓧娈靛�间紭鍏堛�嶄細鍦ㄤ釜鍒紒涓氳宸� 卤0.01銆�
+6. **`setValOrBlank()` 閬囧埌鍏紡鍗曞厓鏍肩洿鎺� return**锛坄ReportExportService.java:2740`锛夛細鎵�浠ヤ腑鍙ｅ緞鎺掑悕鍏ㄧ渷琛岀殑 `SUM` 鍏紡涓嶄細琚鐩栵紝鍒瘯鍥剧敤鍐欏�煎幓鏀瑰畠銆�
+
+## 7. P2 鍏朵粬寰呭姙
+
+- **B4 瀵煎嚭鍓嶅熀鏁颁綋妫�**锛氬鍑哄墠妫�鏌ュ悇椤电鍩烘暟/鏈熸鏄惁榻愬锛岀己澶卞氨寮圭獥 + 鐢熸垚銆婃暟鎹己澶辨竻鍗曘�嬮〉銆傚凡鏈� `midIssues`锛�:2435锛夊拰 `dbProblems` 涓や釜闂娓呭崟鍙寕銆�
+- **D 缁� 澧為�熸帓鍚嶆帾杈�**锛氬緟鎺掓湡銆�
+- **涓彛寰勬槑缁� 4 鏍� `#DIV/0!`**锛�2025 骞� 8 鏈堝熀鏁颁负 0锛屼笉鍙瘮锛屾槸鍚︽敼绌虹櫧寰呬笟鍔″彛寰勭‘璁ゃ��
+- **缂烘瘝鐗堟彁绀猴紙T08锛夋湭瀹炴祴**銆�
+- **閮ㄧ讲鍖呮瘝鐗堟槸鏃х増**锛坄deploy/traffic-audit-deploy-20260913/backend/docs/鐢熸垚姹囨�诲ぇ琛�/`銆乣_deploytest/`锛夛細鐢ㄦ埛 09-20 鏄庣‘銆岄儴缃插寘鍏堜笉绠°�嶏紝鍙戝寘鍓嶉渶鍚屾銆�
+- 鍚屾湡瀛樺湪鐨勫叾浠栫嚎锛氬ぉ闂ㄧ墿娴佹簮鏂囦欢缂哄け銆佽崋宸�/榛勭煶銆岃鍒掑唴/瑙勫垝澶栥�嶅彛寰勫緟纭銆�
+
+## 8. 鍏抽敭浠ｇ爜鍦板浘
+
+| 鏂囦欢 | 浣嶇疆 | 鑱岃矗 |
+| --- | --- | --- |
+| `reportexport/service/ReportExportService.java` | :139 | `checkExportReady()` 瀵煎嚭灏辩华鏍￠獙 |
+| | :285 | `reportPreview()` 棰勮 |
+| | :2209 | `exportPassengerMidDetail()` 涓彛寰勬槑缁嗙嫭绔嬬敓鎴愬櫒 |
+| | :2441 | `loadMidClassMap()` 涓彛寰勪簲缁达紙0 鎬婚噺 / 1 鐝嚎+涓綋 / 2 鍩庨檯鍩庝埂鍏氦 / 3 鍩庨檯鍩庝埂宸℃父鍑虹 / 4 鍩庨檯鍩庝埂缃戠害杞︼級鈥斺�� **鍏ㄩ儴鏌ュ簱鐜扮畻** |
+| | :2531 | 缁村害 4 缃戠害杞� = `WycSplitCalc.calc()` |
+| | :2683 | `exportPassengerMidRank()` 涓彛寰勬帓鍚嶇嫭绔嬬敓鎴愬櫒 |
+| | :3522 | `exportSummaryWorkbook()` 姹囨�诲ぇ琛ㄤ富鍏ュ彛 |
+| | :3753 / :3766 | `refreshSummaryRankSheets()` / `copyRankValues()` 鎺掑悕椤垫惉鍊� |
+| | :3984 | `refreshSummaryCumulativeSheets()` 鍥涢〉鎴愬搧椤电幇绠� |
+| | :4464 | `resolveSummaryMother()` 姣嶇増瀹氫綅 |
+| | :4476 | `exportWycSplit()` 缃戠害杞︽媶鍒� |
+| `reportexport/calc/SummaryWorkbookFiller.java` | :54 | `fillMonthlyLedger()` 鍏紶鍙拌处椤靛洖濉� |
+| | :432 / :549 / :777 | `ensureMonthFormulas()` / `ensureMonthYoyFormulas()` / `repairCumulativeYoyFormulas()` 鍏紡鎸夋湀琛ラ綈涓庝慨鍒嗘瘝 |
+| | :586 / :589 | `isMonthLedgerSheet()` / `isFilledLedgerSheet()` **椤佃寖鍥村垽鏂紝鏇惧洜涓よ�呬笉涓�鑷村嚭 bug** |
+| | :864 | `monthColumnCapacity()` 姣嶇増鑳藉绾崇殑鏈堜唤鍒楁暟 |
+| `reportexport/calc/WycSplitCalc.java` | :93 | `calc()` 缃戠害杞︽媶鍒嗭紙璁㈠崟鍗犳瘮 脳 鍏ㄧ渷 pin锛涘煄甯傚唴鐢ㄥ贰娓稿嚭绉熴�屽煄甯傚唴鍗犳瘮銆嶄唬鐞嗭紝姝︽眽鑷暀銆佸叾浣欐寜鍓╀綑鍗犳瘮閲嶅垎鎽婏級 |
+| | :201 / :241 | `loadMonthlyInput()` 鍙栨暟锛�**鍏堟煡搴� `wyc_order_monthly`锛屽簱閲屾病鏈夋墠鍥炶惤鍒� `docs/鍩庡競瀹㈣繍/缃戠害杞﹁鍗曞強鍏ㄧ渷鎬婚噺.xlsx`** |
+| `reportexport/service/ReportExportTaskService.java` | - | 寮傛瀵煎嚭浠诲姟 + 杩涘害 + 10 鍒嗛挓鍐呭瓨缂撳瓨 + 鏁版嵁鐗堟湰瀹堝崼锛坄import_batch.id` 鍙樺寲鍗冲け鏁堬級 |
+| `traffic-audit-web/src/views/ReportExport.vue` | - | 鎶ヨ〃鐢熸垚椤碉紙棰勮/涓嬭浇/杩涘害寮圭獥/缂撳瓨鎻愮ず锛� |
+
+## 9. 鏁版嵁涓庣幆澧�
+
+- 鍚庣 Spring Boot 绔彛 `8090`锛涘墠绔� Vue2 + ElementUI 绔彛 `8080`锛坄/api` 浠ｇ悊鍒� 8090锛夈��
+- 涓�閿惎鍋滐細`start-dev.ps1`锛堥」鐩牴鐩綍锛夛紝**蹇呴』鍦ㄦ矙绠卞杩愯**銆�
+- 鏁版嵁搴擄細MySQL 8.0 `127.0.0.1:3308/traffic_audit`锛坮oot/123456锛夛紱瀹㈡埛绔� `D:\mysql\mysql-5.7.41-winx64\bin\mysql.exe`銆�
+- 姹囨�诲ぇ琛ㄧ敤鍒扮殑琛細
+
+| 琛� | 鐢ㄩ�� |
+| --- | --- |
+| `h2031_enterprise_monthly` | 鍏矾瀹㈣繍浼佷笟鏈堟姤锛堢彮绾�/鍖呰溅锛屼腑鍙ｅ緞缁村害 1锛� |
+| `passenger_individual_monthly` | 涓綋瀹㈣繍锛堝苟鍏ョ淮搴� 1锛� |
+| `city_bus_monthly` | 鍩庡競鍏氦锛堢淮搴� 2 = 鎬婚噺 - 鍩庡競鍐咃級 |
+| `city_taxi_monthly` | 宸℃父鍑虹锛堢淮搴� 3 = 鎬婚噺 - 鍩庡競鍐咃紱涔熸槸缃戠害杞︽媶鍒嗙殑浠ｇ悊杈撳叆锛� |
+| `wyc_order_monthly` / `wyc_total_monthly` | 缃戠害杞﹁鍗曞崰姣斾笌鍏ㄧ渷 pin锛堢淮搴� 4锛� |
+| `h2032_enterprise_monthly` | 璐ц繍閲忎笌鍛ㄨ浆閲� |
+
+- 姣嶇増鐩綍锛歚docs/鐢熸垚姹囨�诲ぇ琛�/`锛堝惈 `_bak_`/`_澶囦唤_` 鍘嗗彶浠讹紝**鏈粡鍚屾剰涓嶈鍒�**锛夈��
+- 鍗曚綅绾﹀畾锛氬簱鍐呬负鍘熷鍗曚綅锛屽啓鍏ヨ〃鏍兼椂 梅10000 寰椼�屼竾浜� / 涓囧惃 / 涓囦汉鍏噷銆嶏紱**鍏ㄧ簿搴﹀啓鍏ワ紝鏄剧ず涓や綅灏忔暟**锛坄applyTwoDecimalFormat()`锛夈��
+
+## 10. 鏈鎺掓煡浜х敓鐨勮瘉鎹枃浠讹紙鍦ㄩ」鐩牴鐩綍锛屽皻鏈竻鐞嗭級
+
+| 鏂囦欢 | 鍐呭 |
+| --- | --- |
+| `_chk_mid.txt`銆乣_chk_hg*.txt` | 涓彛寰勬槑缁�/鎺掑悕椤甸粍鍐堟暟鎹笌鍏紡 dump |
+| `_chk_wyc.txt` ~ `_chk_wyc7.txt` | 缃戠害杞︽媶鍒嗛�愬競閫愭湀澶嶇畻涓庢瘝鐗堟瘮瀵� |
+| `_chk_taxidiff.txt` | 鍑虹椤� vs 搴撳嚭绉熼�愭牸姣斿 |
+| `_chk_lineage.txt`銆乣_chk_lineage2.txt` | 姣嶇増鍘嗗彶鐗堟湰琛�缂橈紙7 浠芥瘝鐗堢殑 2025-03/04 鍊硷級 |
+| `_chk_backsolve.txt` | 鐢辨瘝鐗堢綉绾﹁溅鍙嶆帹褰撴椂鐨勫嚭绉熻緭鍏� |
+| `_chk_rule.txt` | 鍊欓�夊垎鎽婂叕寮忔嫙鍚堢粨鏋滐紙鎺掗櫎娉曪級 |
+| `_chk_orig.txt` | 9/8 鍘熷姣嶇増鍏抽敭鏍� |
+| `_chk_all_pref.txt` | 17 甯傚窞涓ら〉鍚屾瘮宸紓娓呭崟 |
+| `_chk_code*.txt`銆乣_chk_wyccalc.txt`銆乣_chk_wycdb.txt`銆乣_chk_filler.txt`銆乣_chk_freight.txt` | 鐩稿叧浠ｇ爜娈垫憳褰� |
+
+## 11. 寰呯敤鎴�/涓氬姟纭娓呭崟锛堟帴鎵嬩汉鍏堝埆鑷繁鎷嶏級
+
+1. P0-1 璧版柟妗� A 杩樻槸 B锛燂紙寤鸿 A锛�
+2. P0-2 璧版柟妗� A锛堢▼搴忚嚜鍔ㄦ墿鍒楋級杩樻槸 B锛圗xcel 灏忓伐鍏凤級锛�9 鏈堟槸鍚﹀厛鐢� B 搴旀�ワ紵
+3. 涓彛寰勬槑缁� 4 鏍� `#DIV/0!` 鏄惁鏀圭┖鐧斤紵
+4. B4 鍩烘暟浣撴鐨勮Е鍙戞椂鏈轰笌寮圭獥鏂囨銆�
+
+## 12. 寤鸿鐨勬帴鎵嬮『搴�
+
+1. 璺戦�氱幆澧� + 鐢熸垚涓�娆� 2026-08 姹囨�诲ぇ琛紝纭鑳藉鐜版湰鏂囨墍鏈夌幇璞★紙鍗婂ぉ锛夈��
+2. 澶勭悊 P0-1 鏂规 A锛�1 澶╋紝鍚洖褰掞級銆�
+3. 澶勭悊 P0-2 鏂规 B 鍑� 9 鏈堟瘝鐗堬紙1 澶╋級锛岄殢鍚庢帓 A銆�
+4. 琛� B4 鍩烘暟浣撴锛�1-2 澶╋級銆�

--
Gitblit v1.9.1