From 2e6830bcf59c01f29f040652b3e5209a7f21238e Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期一, 21 九月 2026 10:23:50 +0800
Subject: [PATCH] feat(投资): 投资系统导出新模板按表头解析 + 审核基准缺失保护 + 十堰源文件清理

---
 docs/交接文档_2026-09-21.md |   13 +++++++++----
 1 files changed, 9 insertions(+), 4 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"
index 9dcd74f..03533e3 100644
--- "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"
@@ -11,8 +11,10 @@
 ## 0. 鍏堣杩欎竴椤碉紙鎺ユ墜鐨勭 1 灏忔椂锛�
 
 1. **鍏堟妸绯荤粺璺戣捣鏉�**锛屽啀璋堟敼浠g爜銆傝 搂7.1锛堜竴閿剼鏈紝蹇呴』鍦ㄦ矙绠卞鎵ц锛夈��
-2. **褰撳墠鏈�绱ф�ョ殑 4 浠朵簨**锛堣瑙� 搂4 P0锛夛細鈶� 8 鏈堝崄鍫扮墿娴佹簮鏂囦欢閲岀殑銆岄潪鍗佸牥娈点�嶄細鍙嶅鎶� 31 涓」鐩甫鍥炲簱锛涒憽 銆婁嚎鍏冩姇璧勯」鐩�嬫湀浠藉垪姣忔湀瑕嗙洊涓婃湀锛�
-   鈶� 瀵煎嚭鍓嶃�屽熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉銆嶅彧鍋氫簡涓�鍗婏紱鈶� 缂� 2026-06 / 2026-09 姣嶇増锛岄偅涓ゆ湡鍑轰笉浜嗚〃銆�
+2. **褰撳墠鏈�绱ф�ョ殑 4 浠朵簨**锛堣瑙� 搂4 P0锛夛細鈶� 銆婁嚎鍏冩姇璧勯」鐩�嬫湀浠藉垪姣忔湀瑕嗙洊涓婃湀锛堢敤鎴� Q7 瑕佺殑銆屽姞涓�鍒椼�嶆湭鍋氾級锛�
+   鈶� 瀵煎嚭鍓嶃�屽熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉銆嶅彧鍋氫簡涓�鍗婏紱鈶� 缂� 2026-06 / 2026-09 姣嶇増锛岄偅涓ゆ湡鍑轰笉浜嗚〃锛�
+   鈶� 姹囨�诲ぇ琛ㄣ�屼腑鍙e緞鎺掑悕 vs 涓彛寰勬槑缁嗐�嶅巻鍙插悓姣斿熀鏁板弻杞ㄥ埗锛�16 涓競宸炴湁宸級銆�
+   > 鍘熴��8 鏈堝崄鍫扮墿娴佹簮鏂囦欢鍚潪鍗佸牥娈点�嶅凡浜� 2026-09-21 闂幆锛岃 搂4 P0-1銆�
 3. **鍒嚜宸辨媿鏉夸笟鍔″彛寰�**锛岀 5 绔犲垪鐨勬槸蹇呴』涓氬姟纭鐨勪簨銆�
 4. 鏀瑰畬蹇呴』锛氬啓銆婂姛鑳芥祴璇曟姤鍛娿�嬧啋 鏇存柊銆婂伐浣滄棩缁撱�嬧啋 鍙屼粨搴撴帹閫侊紙搂7.4锛夈�傝繖鏄湰椤圭洰鐨勭‖瑙勭煩銆�
 
@@ -41,6 +43,7 @@
 | `freight_turnover_import` | **234** | 18 琛�/鏈� 脳 13 鏈燂紙2021-12 ~ 2026-08锛� |
 | `h2031_enterprise_monthly` | 15811 | 鍏矾鏃呭锛堜腑鍙e緞缁村害 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锛夈��
@@ -55,7 +58,7 @@
 | 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`锛堥殢鏈浜ゆ帴涓�骞舵彁浜わ級 |
+| 宸ヤ綔鍖虹姸鎬� | 骞插噣锛堜氦鎺ユ枃妗c�佹眹鎬诲ぇ琛ㄩ棶棰樹氦鎺ャ�佹棩缁撱�佹姇璧勭郴缁熸柊妯℃澘鏀寔鍧囧凡鎻愪氦骞舵帹閫佷袱绔級 |
 
 ### 1.4 鍏抽敭鐩綍
 
@@ -182,7 +185,7 @@
 
 | # | 浜嬮」 | 鐜拌薄 / 褰卞搷 | 鐜扮姸涓庤瘉鎹� | 涓嬩竴姝� | 鐘舵�� |
 | --- | --- | --- | --- | --- | --- |
-| P0-1 | **8 鏈堝崄鍫扮墿娴佹眹鎬昏〃鍚�岄潪鍗佸牥娈点��** | 璇ユ枃浠朵竴涓〉绛炬敹浜嗗叏鐪侊細8 鏈堣繖浠� 38 琛岄噷鍙湁 **7 琛屾槸鍗佸牥**锛屽彟 **27 琛屾姹� + 4 琛岄粍鐭�**銆傜▼搴忕壒鎰忔敮鎸併�屾寜灏忚妭琛屽垏甯傚窞銆嶏紝鎵�浠ユ瘡娆¢噸瀵� 8 鏈堢墿娴侀兘浼氭妸杩� 31 涓」鐩缓鍒版姹�/榛勭煶鍚嶄笅锛�09-20 宸插疄娴嬪鐜� +31 椤圭洰锛岀敓鎴愯〃姝︽眽鐗╂祦娈典細澶� 27 琛岋級 | 搴撳凡娓呭共鍑�锛�152 椤圭洰 / 284 鏈堝害鏁帮紝2026-08 鏈堝害鏁� 136 琛屼笌閲嶅鍓嶉�愬�间竴鑷达級锛�**婧愭枃浠舵湭娓�** | 鐢ㄦ埛纭鍚庣敱鎺ユ墜浜哄垹娈碉紙鍏堝浠藉埌 `docs/鎶曡祫/杈撳嚭/`锛夛紝鎴栫敤鎴疯嚜琛屽湪 Excel 鍒犻櫎璇ヤ袱娈� | 鉂� |
+| 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 | **銆婁嚎鍏冩姇璧勯」鐩�嬭涓婇」鐩〃鏈堜唤鍒椾細琚鐩�** | 浠g爜鍙噸鍐欒〃澶存枃瀛楋紙`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鏈�/绗簩瀛e害锛夊悓鏍疯涓�璧风湅 | 鉂� |
 | 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锛� | 鈴� |
@@ -203,6 +206,7 @@
 | P1-10 | 杩愯緭閲� 2026-01~07 鐨� `last_*` 涓虹┖ / H203-1 2026-01~07 鐨� `unified_credit_code`銆乣report_unit` 涓虹┖ | 鍓嶈�呮槸鏀瑰姩鍓嶅氨涓虹┖锛屽悗鑰呮槸鏂板垪鏈湡鎵嶈鍙栵紱鏄惁琛�/閲嶅寰呯‘璁� | 鈴� |
 | P1-11 | 璐ц繍銆屾寔缁湪瑙� 545 瀹躲�峷s銆屽畼鏂瑰叏鍙e緞銆嶄袱鐗堝悓姣旓紙+2.90% vs +4.54%锛� | 鍙e緞涓嶅悓锛屽凡鍒嗗埆娉ㄦ槑锛涜嫢瑕侀殢銆婂樊寮傜巼姹囨�昏〃銆嬩笂鎶ワ紝寤鸿鍔犳敞宸紓鍘熷洜 | 鈴� |
 | P1-12 | 楂橀�熻繍璺濆悓姣旓紙鐢ㄦ埛琛ㄦ牸 O 鍒楋級鐨勬潵婧�/鏈熼棿寰呯‘璁� | 纭鍚庢柟鍙畻銆岃繍璺濆閫熷樊銆� | 馃敀 绛夌敤鎴� |
+| P1-13 | 鎶曡祫绯荤粺瀵煎嚭鐨�**鏂版ā鏉�**锛坄2026骞碭鏈堟姇璧勭郴缁熼」鐩槑缁哷锛� | 宸叉敮鎸佹寜琛ㄥご瀹氫綅瑙f瀽锛�09-21锛�129 鏉″叆搴擄級銆�**寰呭畾**锛氣憼 鏂版ā鏉垮鍑虹殑銆岄」鐩墍澶勯樁娈点�嶆湭钀藉簱锛屽闇�姣斿寤鸿闃舵瑕佸姞鍒楀苟鍚屾 `docs/init.sql`/`docs/database.md`锛涒憽 鏂版ā鏉�**娌℃湁銆岃嚜骞村垵绱銆嶅垪**锛岃缁村害瀹℃牳宸叉敼涓恒�屽熀鍑嗙己澶卞嵆璺宠繃 + WARN 鏃ュ織銆嶏紙RULE_I002 瀹炴祴 0 鏉★級锛岃嫢涓氬姟浠嶈姣斿闇�妯℃澘琛ュ洖璇ュ垪 | 馃敹 |
 
 ### P2 鈥斺�� 宸ョ▼涓庢暣娲�
 
@@ -316,3 +320,4 @@
 | 鏃ユ湡 | 鍙樻洿 |
 | --- | --- |
 | 2026-09-21 | 棣栨鎴愭枃锛氭暣鍚堟眹鎬诲ぇ琛ㄤ氦鎺ワ紙`docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`锛変笌鎶曡祫/璐ц繍/瀹㈣繍鍚勭嚎閬楃暀 |
+| 2026-09-21锛堜笅鍗堬級 | P0-1 闂幆锛堝崄鍫版簮鏂囦欢宸插垹娈� + 閲嶅楠岃瘉锛夛紱鏂板 P1-13锛堟姇璧勭郴缁熸柊妯℃澘鏀寔锛夛紱鏁版嵁蹇収琛� `investment_system` 琛� |

--
Gitblit v1.9.1