From a08c70db67e49bf6cd125df04ebaf68c26f0d8dd Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 20 九月 2026 16:19:16 +0800
Subject: [PATCH] feat(投资): 市州月报统一填报模板 + 县(市、区)列解析 + 表头行判定收紧

---
 docs/工作日结/工作日结_2026-09-20.md |  195 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 195 insertions(+), 0 deletions(-)

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-20.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-20.md"
new file mode 100644
index 0000000..37afff5
--- /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-20.md"
@@ -0,0 +1,195 @@
+# 宸ヤ綔鏃ョ粨_2026-09-20
+
+## 涓�銆佷粖澶╁仛浜嗕粈涔�
+
+### 1.1 淇锛氭姤琛ㄧ敓鎴愰〉涓ゅ紶鎶曡祫鏄庣粏琛ㄦ姤銆屾湭鐭ユ姤琛ㄧ被鍨嬨��
+
+- **鐜拌薄**锛氭姤琛ㄧ敓鎴愰〉銆屽杩愮珯鎶曡祫鏄庣粏琛ㄣ�嶃�岀墿娴佺珯鍦烘姇璧勬槑缁嗐�嶆樉绀�
+  `鏈煡鎶ヨ〃绫诲瀷锛歩nvestPassengerDetail / investLogisticsDetail`锛屾棤娉曢瑙�/瀵煎嚭銆�
+- **瀹氫綅**锛氭姤閿欐潵鑷� `ReportExportService.checkExportReady()` 鐨� `switch (t)` 鍏滃簳鍒嗘敮锛坄ReportExportService.java:231`锛夈��
+  鍓嶄竴鏅氬彧鎶婅繖涓や釜绫诲瀷鎺ヨ繘**瀵煎嚭**閾捐矾锛坄exportSelected` switch銆乣REPORT_FILE_NAMES`銆乣ReportExportController` 涓や釜鎺ュ彛銆乣ReportExport.vue` 涓ら」锛夛紝
+  婕忎簡**灏辩华鏍￠獙涓庨瑙�**閾捐矾锛宍isInvestType()` 涔熸病鏀跺綍杩欎袱涓被鍨嬨��
+- **涓庢暟鎹棤鍏�**锛�8 鏈堟姇璧勬湀鎶ヤ竴鐩村湪搴擄紙瀹㈣繍绔欏満 39 琛屻�佺墿娴佸洯鍖� 128 琛岋級銆�
+- **淇**锛�
+  1. `checkExportReady()` 鏂板涓や釜 case锛氭寜绫诲埆缁熻 `investment_monthly` 璇ユ湡琛屾暟 + 鏍￠獙 `docs/鎶曡祫/妯℃澘/` 姣嶇増鏄惁瀛樺湪锛堢己姣嶇増缁欐彁绀猴級锛�
+  2. `isInvestType()` 鏀跺綍涓や釜绫诲瀷锛堢撼鍏ユ姇璧勫垎鏀殑鏈堝害瑕嗙洊涓庨棶棰樻竻鍗曪級锛�
+  3. `investPreview()` 澧炲姞鎸夌被鍒繃婊ら噸杞� `(period, mode, category, summary, problems)`锛屽師鏃犲弬閲嶈浇淇濈暀锛�
+  4. 棰勮寰幆鎸夌被鍨嬪垎娲惧埌瀵瑰簲绫诲埆锛涙湭鐭ョ被鍨嬪厹搴曟姤閿欎繚鎸佷笉鍙樸��
+
+### 1.2 鍏跺畠
+
+- 閲嶅惎鍓嶅悗绔姞杞芥柊浠ｇ爜锛堝悗绔� `Started TrafficAuditApplication` 10:49:51锛夈��
+- 椤烘墜鏍稿锛氬墠涓�鏅氥�屽悎璁¤琚綋椤圭洰銆嶄慨澶嶅悗锛屽杩愭湰鏈堝畬鎴愭姇璧勭敱鍚悎璁¤鐨� 2130.1 鏀舵暃涓� **2048.1**锛屼笌 SQL 閫愰」涓�鑷达紱搴撳唴宸叉棤鍚�岃銆嶇殑浼」鐩銆�
+
+### 1.3 淇锛氭眹鎬诲ぇ琛ㄣ�婂煄甯傚杩愩��8 鏈堝悓姣� / 绱鍚屾瘮绠楅敊锛堟瘝鐗堝垹 AJ 杈呭姪鍒� + 绋嬪簭鎸夎〃澶村彇鏁帮級
+
+- **鐜拌薄**锛氱敤鎴蜂笂鎶ョ敓鎴愯〃鍩庡競瀹㈣繍 8 鏈堝悓姣� 鈭�86.5%銆佺疮璁″悓姣� 鈭�43.5%锛涗笖銆�2025骞�1-7鏈堢疮璁°�嶅垪鍦ㄦ瘝鐗堝垹杩囧嵈浠嶅湪鐢熸垚琛ㄩ噷銆�
+- **鏍瑰洜锛�3 涓級**锛�
+  1. 姣嶇増鏈�**涓ゆ湰**鈥斺�旂敤鎴峰垹鐨勬槸銆�2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬶紝鑰� 8 鏈堝鍑虹敤鐨勬槸銆�2026骞�8鏈堚�︺�嬶紝
+     鍚庤�呭煄甯傚杩愰〉 2025 骞存鎻掍簡 AJ 鍒椼��2025骞�1-7鏈堢疮璁°�嶏紝鎶� 2025骞�8鏈堝垪鎸ゅ埌 AK锛�
+     8 鏈堝悓姣� `=Q4/AJ4-1` 瀹為檯鏄��8鏈堝�� 梅 2025骞�1-7鏈堢疮璁°�嶏紱绱鍚屾瘮鍒嗘瘝鍙堟妸 1-6 鏈堥噸澶嶈銆�8 鏈堟紡璁°��
+  2. 鏂板啓鐨勫垪鍙锋崲绠� `colIndexOf()` 杩斿洖 1 鍩哄垪鍙凤紝鑰� POI 鍒楀彿鏄� 0 鍩� 鈫� 鏈堜唤鍒楁煡琛ㄥ叏钀界┖銆侀��鍖栨垚銆�+2 鍒椼�嶏紝
+     `=O5/AH5-1` 琚畻鎴� `=R5/AK5-1`锛堣嚜寮曠敤锛夆啋 璐ц繍/缃戠害杞�/涓彛寰勬槑缁� 鍏� 360 鏍煎惊鐜紩鐢ㄣ��
+  3. POI `setCellFormula` 涓嶆帴鍙楀甫 `=` 鍓嶇紑鐨勫叕寮忎覆锛屽紓甯稿張琚� `catch (Exception ignore)` 鍚炴帀锛�
+     绱鍚屾瘮鍒嗘瘝淇涓�鐩撮潤榛樺け璐ワ紙鏃ュ織鍙樉绀恒�屼慨姝ｆ牸鏁�=0銆嶏級锛涘彟姣嶇増 3~8 鏈堣〃澶存槸 46235 杩欑被瑁稿簭鍒� + General 鏍煎紡锛�
+     鍘熸寜 `isCellDateFormatted` 鍒ゅ畾浼氭紡鍒ゃ��
+- **澶勭疆**锛�
+  1. 姣嶇増锛氱敤 Excel 16.0 COM 鍦ㄣ��2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬪煄甯傚杩愰〉鏁村垪鍒犻櫎 AJ锛堝紩鐢ㄧ敱 Excel 鑷姩璋冩暣锛�
+     濡� `W4` 鈫� `=V4/AW4-1`锛夛紝鍐嶆妸鍒犲垪浜х敓鐨� 36 澶� `#REF!` 绱鍚屾瘮鍏紡杩樺師涓� `AJ`锛�
+     澶囦唤 `_bak_202608姣嶇増鍒犻櫎AJ鍒楀墠_20260920.xlsx`锛涘垹鍒楀悗姣嶇増涓庣増寮忓弬鐓т欢銆婄敓鎴恄閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx銆嬪垪缁撴瀯涓�鑷淬��
+  2. 浠ｇ爜锛歚colIndexOf` 鏀� 0 鍩猴紱`setCellFormula` 鍘绘帀 `=` 鍓嶇紑骞舵妸 catch 鏀规垚 WARN 鏃ュ織锛�
+     `yearMonthOf` 鏀寔瑁告棩鏈熷簭鍒楋紱`repairCumulativeYoyFormulas()` 淇濈暀浣滄瘝鐗堝厹搴曘��
+  3. 鍓嶇锛歚ReportExport.vue` 棰勮琛ラ綈璐ц繍閲�/鍩庡競瀹㈣繍/涓彛寰勫叡 8 椤瑰悓姣旀槧灏勶紝淇銆屽綋鏈堣揣鐗╁懆杞噺(涓囧惃)銆嶅崟浣嶃��
+
+### 1.4 娓呴櫎銆屽崄鍫版眹鎬昏〃銆嶅甫鍑虹殑闈炲崄鍫版畫鐣欙紙鐢ㄦ埛瑕佹眰锛�
+
+- **鑳屾櫙**锛氱敤鎴锋牳瀵� `D:\妗岄潰\鐢熸垚鏁版嵁\鐢熸垚_鍏ㄧ渷棰勫畨鎺掕鍒掕繘搴︽儏鍐垫眹鎬� (2).xls` 鍙戠幇姝︽眽鐗╂祦娈靛鍑� 27 涓」鐩紙楂樻ˉ璐ц繍绔欌�﹁秺娴峰崕涓緵搴旈摼鎬婚儴鍩哄湴锛屽紑宸ュ勾 2006-2016锛夈��
+- **婧簮**锛氳繖 27 涓紙+榛勭煶 4 涓級鏉ヨ嚜銆婃箹鍖楃渷鍗佸牥浜ら�氱墿娴佸熀纭�璁炬柦鎶曡祫缁熻姹囨�昏〃锛堟湀鎶ワ級銆嬧�斺�旀枃浠跺悕/濉姤鍗曚綅鏄崄鍫帮紝
+  浣嗕竴涓〉绛鹃噷鏀朵簡鍏ㄧ渷鍚勫競宸烇紱2026-08-26 11:57 闅忋�屽競宸炲崟琛ㄦ壒閲忓鍏ワ紙鐗╂祦锛堢墿娴佸洯鍖猴級/7鏈堬級銆嶆寜甯傚窞鍧楀叆搴擄紙batch 17/25锛夈��
+  浜ゅ弶鏍稿锛氳繖 31 涓」鐩悕绉板湪鍏跺畠浠讳綍甯傚窞婧愭枃浠堕噷閮�**鏌ヤ笉鍒�**锛岀‘璁や负璇ユ枃浠跺甫鍑虹殑娈嬬暀銆�
+- **瀵煎嚭涓轰綍浼氭樉绀�**锛歚investPlan` 鏄�屾瘝鐗堝師浣嶆浛鎹� + 鍔ㄦ�佹彃琛屻�嶁�斺�旀瘝鐗堟姹夌墿娴佸彧棰勭暀 7 琛岋紝搴撻噷澶氬嚭鐨勯」鐩寜銆屽競宸�+绫诲埆銆嶈嚜鍔ㄨˉ鎻掑埌灏忚妭鏈熬
+  锛坄ReportExportService.java` 鍔ㄦ�佹彃琛屾锛夈�傛墍浠ュ簱閲屾湁澶氬皯椤圭洰锛岀敓鎴愯〃灏卞嚭澶氬皯琛屻��
+- **澶勭疆**锛氬叏閲忓浠藉埌 `docs/鎶曡祫/杈撳嚭/娓呯悊娈嬬暀_鍗佸牥姹囨�昏〃甯﹀嚭鐨勯潪鍗佸牥椤圭洰_2026-09-20.tsv`锛�31 涓」鐩� + 39 鏉℃湀搴︽暟锛夊悗鍒犻櫎锛�
+  椤哄甫鍙戠幇骞舵竻闄よВ鏋愩�屽悎璁°�嶈璇缓鐨勪吉椤圭洰锛坕d=229 鍜稿畞甯傚杩愮珯鍦恒�屽悎銆�銆�銆�璁°�嶏紝13727 涓囧厓锛夈��
+  缁撴灉锛氱墿娴佸洯鍖洪」鐩� 135 鈫� 104锛�2026-08 鏈堝害鏁� 167 鈫� 136锛屽杩愮珯鍦洪」鐩� 49 鈫� 48銆�
+
+### 1.5 棰勫畨鎺掓眹鎬昏〃锛氬皬璁�/鍚堣琛ヨ銆屾湁鎬绘姇璧勩�佹棤鏈湡鏈堝害鏁般�嶇殑椤圭洰锛堢敤鎴风‘璁ゃ�屽彲浠ャ�嶏級
+
+- 鍦烘櫙锛氭姹� 8 鏈堢墿娴佹病鏈夊崟琛ㄦ姤閫侊紙`docs/鎶曡祫/杈撳叆/鐗╂祦锛堢墿娴佸洯鍖猴級/8鏈坄 閲屾病鏈夋姹夋枃浠讹級锛�6 涓柊椤圭洰鍦ㄥ簱閲屾病鏈� 2026-08 鏈堝害鏁帮紝
+  鍘熸潵灏忚鍙疮鍔犳湀搴︽暟鎹� 鈫� 姝︽眽鐗╂祦鏁村潡鍙樉绀洪」鐩銆佸皬璁＄┖鐧姐��
+- 鏀瑰姩锛歚ReportExportService.investPlan()` 鏂板 `addProjectsWithoutMonthly(...)`锛屽湪**甯傚窞灏忚妭/鍧楀悎璁�/鍏ㄧ渷鍚堣**涓夊绱姞鍚庯紝
+  鎶娿�屾湰鏈熸棤鏈堝害璁板綍浣嗕富妗ｆ湁鎬绘姇璧勩�嶇殑椤圭洰鎸夌被鍒�/甯傚窞琛ヨ繘 **鎬绘姇璧�** 涓�鍒楋紙鍏朵綑鍒楁棤涓绘。鏁版嵁婧愶紝淇濇寔绌虹櫧锛夈��
+- 鏁堟灉锛氭姹夌墿娴佸皬璁� = 272476锛�6 涓」鐩�绘姇璧勫拰锛夛紱鍧楀悎璁�/鍏ㄧ渷鍚堣 = 搴撳唴鍚岀被椤圭洰鎬绘姇璧勪箣鍜岋紙鍙�愰」瀵� SQL 鏍稿锛夈��
+
+### 1.6 瀵煎叆缁撴灉寮圭獥鏀归�狅紙鐢ㄦ埛锛氬脊绐楀お闀裤�佺偣涓嶅埌纭銆佷笉鑳界Щ鍔級
+
+- 鍘熸潵鐢ㄧ殑鏄� Element `$alert`锛圡essageBox锛夋壙杞藉鍏ョ粨鏋� HTML锛屽唴瀹逛竴闀垮氨鎶娿�岀‘璁ゃ�嶆尋鍑哄睆骞曪紝涓斾笉鑳芥嫋鍔ㄣ��
+- 鏀逛负鑷畾涔� `el-dialog`锛歚v-dialog-drag` 鏍囬鏍忔嫋鍔ㄣ�乣custom-class="import-result-dialog"`锛堝叏灞�鏍峰紡锛屽渾瑙� + 鍐呭鍖� `max-height` 婊氬姩 + 搴曢儴鎸夐挳鍥哄畾锛夛紝
+  骞舵柊澧炪�屽鍑烘槑缁嗐�嶆寜閽紙CSV锛屽甫 BOM锛屽彲鐩存帴 Excel 鎵撳紑锛夛紝鐢ㄤ簬鐢ㄦ埛鑷鏍稿/淇敼涓嶄竴鑷村唴瀹广��
+- 瑕嗙洊 4 澶勶細鎵归噺瀵煎叆缁撴灉銆佸競宸炲崟琛ㄦ壒閲忓鍏ョ粨鏋溿�佸崟鏂囦欢瀵煎叆澶辫触銆佹姇璧勪笌鎶曡祫绯荤粺涓嶄竴鑷存竻鍗曘��
+
+### 1.7 姹囨�诲ぇ琛ㄥ鍑哄紓姝ュ寲 + 缁撴灉缂撳瓨锛堢敤鎴锋彁闂�岀偣涓嬭浇瑕佺瓑涓�浼氾紝鏁版嵁澶氫簡浼氫笉浼氬崱姝汇�嶏級
+
+- **鐜拌薄**锛氭眹鎬诲ぇ琛ㄧ偣銆屽鍑恒�嶅悗瑕佺瓑 10~20 绉掓墠瑙﹀彂涓嬭浇锛屾湡闂撮〉闈㈡棤浠讳綍鍙嶉锛涘悓姝ヨ姹備竴鐩村崰鐫� Web 绾跨▼銆�
+- **瀹氫綅**锛�14 绉掗噷姣嶇増璇诲彇+鍥炲～ 6.5s銆佹暣鏈害 4 涓囨牸鍏紡閲嶇畻 4.1s銆佸啓鐩樹紶杈� 3.4s鈥斺�旇�楁椂鏉ヨ嚜 Excel 澶勭悊锛�**涓庢暟鎹簱琛屾暟鍏崇郴涓嶅ぇ**锛屾暟鎹浜嗕富瑕佹槸 SQL 鑱氬悎鍙樻參锛屼笉浼氥�屽崱姝汇�嶃��
+- **鏀瑰姩**锛�
+  1. 鏂板 `ReportExportTaskService`锛堝浐瀹� 1 绾跨▼姹� daemon锛夛細鎻愪氦鍗宠繑鍥� taskId锛屽墠绔� 700ms 杞銆屾楠� + 鐧惧垎姣� + 宸茬敤鏃堕暱銆嶏紱缁撴灉淇濈暀 30 鍒嗛挓锛堝唴瀛樻�侊紝杩涚▼閲嶅惎澶辨晥锛夈��
+  2. **缁撴灉缂撳瓨 10 鍒嗛挓 + 鏁版嵁鐗堟湰瀹堝崼**锛氱増鏈彇 `SELECT IFNULL(MAX(id),0) FROM import_batch`锛屾湡闂村彧瑕佹湁鏂板鍏ュ氨鑷姩澶辨晥锛堝彇涓嶅埌鐗堟湰鏃剁鐢ㄧ紦瀛橈級锛涘悓涓�鎶ヨ〃鏈熷苟鍙戞彁浜よ嚜鍔ㄥ幓閲嶃�佸鐢ㄥ悓涓�浠诲姟銆�
+  3. `ReportExportService` 鏂板甯﹁繘搴﹀洖璋冪殑 `exportSummaryWorkbook(period, mode, toMonth, progress)` 閲嶈浇锛堝師涓や釜閲嶈浇濮旀墭瀹冿級锛岃繘搴︾偣 2%/6%/12%/22%/45%/70%/95%銆�
+  4. `ReportExportController` 鏂板 3 涓帴鍙ｏ細`/exportTask/summaryWorkbook`锛堟彁浜わ級銆乣/exportTask/{taskId}`锛堣繘搴︼級銆乣/exportTask/{taskId}/file`锛堜笅杞斤級锛涘師鍚屾鎺ュ彛淇濈暀鍏煎銆�
+  5. 鍓嶇 `ReportExport.vue` 杩涘害寮圭獥锛氳繘搴︽潯 + 姝ラ + 鐢ㄦ椂 + 缂撳瓨鏉ユ簮鏃堕棿 + 澶辫触鍘熷洜锛屼互鍙娿�屼繚瀛樻枃浠� / 閲嶆柊鐢熸垚 / 鍚庡彴杩愯 / 鍏抽棴銆嶃��
+- **瀹炴祴**锛氭彁浜� 0.07s锛涜繘搴� 6鈫�22鈫�45鈫�70鈫�95鈫�100銆�14.4s 瀹屾垚锛涚紦瀛樺懡涓� 0.01s锛沗refresh=true` 鐪熷疄閲嶇畻锛涗复鏃舵彃涓�鏉″鍏ュ悗缂撳瓨鑷姩澶辨晥銆�
+- **鍚屾椂淇帀涓�涓弗閲嶅洖褰�**锛氭湰娆℃柊澧炵殑 `computed` 涓庢枃浠朵腑宸叉湁 `computed` **鍚屽悕閲嶅**锛孞S 瀵硅薄鍚庤�呰鐩栧墠鑰� 鈫� `username/myModules/visibleModules` 鍏ㄩ儴涓㈠け锛�
+  銆屾姤琛ㄧ敓鎴愩�嶉〉 `created()` 鐩存帴鎶涢敊銆�**鏁撮〉鐧藉睆**銆傛帴鍙ｆ祴璇曞彂鐜颁笉浜嗭紝鏄祻瑙堝櫒瀹炴祴鎵嶆毚闇茬殑锛堣瑙佹祴璇曟姤鍛婄鍥涜妭锛夈��
+
+### 1.8 甯傚窞缁熶竴濉姤妯℃澘锛堢敤鎴锋彁闂�屾寜鍝釜鏍煎紡鏉ユ渶濂斤紵瑕佷笉瑕佺敓鎴愪袱涓ā鏉裤�嶏級
+
+- **鑳屾櫙**锛氱敤鎴锋彁鍑恒�岃繖鍑犱釜琛ㄧ殑鏇存柊鍏跺疄寰堢畝鍗曗�斺�旀寜椤圭洰鍚嶇О鏇存柊姹囨�昏〃鎸囨爣銆佹柊澧為」鐩氨鏂板鍒版槑缁嗚〃锛�
+  棰勫畨鎺掓眹鎬昏〃鍜屾槑缁嗚〃鏂瑰紡涓�鏍凤紝鍓╀笅涓夊紶琛ㄩ」鐩浐瀹氬彧鏇存柊鎸囨爣鈥斺�斾负浠�涔堢幇鍦ㄥ紕寰楁湁鐐瑰鏉傘�嶃��
+- **鏍稿**锛氶渶姹傛枃妗ｃ�婃姇璧勬湀鎶ユ暟鎹鐞嗕笌澶氳〃鏇存柊闇�姹傝鏄庛�婼tep1/2/3 涓庣敤鎴锋弿杩板畬鍏ㄤ竴鑷达紝绋嬪簭閫昏緫涔熸槸杩欎箞瀹炵幇鐨勩��
+- **缁撹**锛氬鏉備笉鍦ㄣ�岃〃銆嶏紝鍦ㄣ�屾簮銆嶁�斺�旂増寮忎笉缁熶竴锛�27 浠介噷 7 浠芥湁宸紓锛夈�佷竴涓枃浠舵贩澶氫釜甯傚窞銆佹病鏈夊幙鍖哄垪銆佸垪浣嶇疆闈犲厹搴曘��
+- **浜у嚭**锛�
+  1. 鏂板涓や唤甯傚窞濉姤妯℃澘 `妯℃澘_甯傚窞鏈堟姤_瀹㈣繍绔欏満.xlsx` / `妯℃澘_甯傚窞鏈堟姤_鐗╂祦鍥尯.xlsx`
+     锛堛�屾湀鎶ャ�嶉〉 17 鍒楀崟琛岃〃澶� + 寤鸿鎬ц川涓嬫媺 + 銆屽～鎶ヨ鏄庛�嶉〉 11 鏉¤姹傦級锛�
+  2. 鍙ｅ緞璇存槑鏂囨。 `docs/鎶曡祫/濉姤鍙ｅ緞涓庣粺涓�妯℃澘_2026-09-20.md`锛堟ā鏉垮瓧娈靛幓鍚戙�佸鏉傚害鏉ユ簮銆佸緟瀹氭鐨� 3 浠朵簨銆佽繃娓″畨鎺掞級銆�
+- **閰嶅瑙ｆ瀽鏀瑰姩**锛氭柊澧炪�屽幙锛堝競銆佸尯锛夈�嶅垪瑙ｆ瀽锛堝啓鍏ヤ富妗� `county`锛夛紱琛ㄥご琛屽垽瀹氭敹绱т负
+  銆屽惈椤圭洰鍚嶇О + 鑷冲皯 2 涓煭琛ㄥご瀛楁銆嶏紝閬垮厤鎶婃ā鏉胯嚜甯︾殑銆屽～鎶ヨ鏄庛�嶉〉褰撴暟鎹〃銆�
+
+## 浜屻�佹祴璇曠粨鏋滄憳瑕�
+
+銆婂姛鑳芥祴璇曟姤鍛奯鎶曡祫鏄庣粏琛ㄥ氨缁笌棰勮绫诲瀷琛ラ綈_2026-09-20.md銆嬶細**7 鏉＄敤渚嬮�氳繃锛�1 鏉℃湭瀹炴祴**锛堢己姣嶇増鎻愮ず锛屾湭涓存椂绉诲姩鐢ㄦ埛姣嶇増鏂囦欢锛夈��
+
+| 鏍￠獙椤� | 缁撴灉 |
+| --- | --- |
+| `/api/report/ready`锛堜袱鏂扮被鍨嬶級 | ready=true锛宺ows=39 / 128锛宯ote 涓虹┖ |
+| `/api/report/preview`锛堜袱鏂扮被鍨嬶級 | 瑕嗙洊 [8]锛宲roblems 涓虹┖ |
+| 鎽樿 vs SQL 閫愰」瀵归綈 | 瀹㈣繍 `2048.1 / 38648.16 / 550929.76`銆佺墿娴� `90185.9 / 704107.7 / 2656354.31`锛�**涓�鑷�** |
+| 鍒嗙被鍒繃婊� | 瀹㈣繍 39 + 鐗╂祦 128 = 167锛屽叏绫诲埆绫诲瀷浠� 167锛堟湭涓茬被锛� |
+| 瀵煎嚭鍥炲綊 | 涓ゅ紶鏄庣粏琛ㄤ粛鍙鍑猴紙29462 / 134144 瀛楄妭锛� |
+| 鍘熸湁鎶曡祫绫诲瀷鍥炲綊 | investPlan / investBillion / investCounty / investFiveYearLogistics 鍧� ready=true锛宺ows=167 |
+| 鏈煡绫诲瀷璐熷悜 | `foo` 鈫� ready=false銆乶ote=鏈煡鎶ヨ〃绫诲瀷锛歠oo锛堝厹搴曚粛鏈夋晥锛� |
+
+銆婂姛鑳芥祴璇曟姤鍛奯鍩庡競瀹㈣繍鏈堝害涓庣疮璁″悓姣擾2026-09-20.md銆嬶細**15 鏉＄敤渚嬮�氳繃**銆�
+
+| 鏍￠獙椤� | 缁撴灉 |
+| --- | --- |
+| 鍩庡競瀹㈣繍 R4 / T4 鍏紡 | `=Q4/AJ4-1`銆乣=S4/(V4+X4+Z4+AB4+AD4+AF4+AH4+AJ4)-1`锛堜笉鍐嶆槸 `#REF!`锛� |
+| 鍏ㄧ渷瀹㈣繍閲� 8 鏈堝悓姣� / 绱鍚屾瘮 | **+4.44% / +0.117%**锛堜慨澶嶅墠 鈭�86.5% / 鈭�43.5%锛� |
+| 杈呭姪鍒� | 鐢熸垚琛ㄤ笌姣嶇増鍧囨棤銆�2025骞�1-7鏈堢疮璁°�嶏紝鍩庡競瀹㈣繍椤� BV鈫払U |
+| 寰幆寮曠敤 | 鍏ㄨ〃 0 澶勶紙淇鍓� 360 澶勶紝鍚揣杩�/缃戠害杞�/涓彛寰勬槑缁� R 鍒楋級 |
+| 鍏跺畠 18 涓〉绛惧洖褰� | 闄や笂杩� R 鍒椾慨澶嶅閫愭牸涓�鑷� |
+| 棰勮鎺ュ彛 | 24 椤规寚鏍囧惈 8 椤瑰悓姣旓紝1.03 绉� |
+| 瀵煎嚭鑰楁椂 | 14 绉掞紙姣嶇増璇诲彇+鍥炲～ 6.5s銆佸叕寮忛噸绠� 4.1s銆佸啓鐩樹紶杈� 3.4s锛� |
+
+銆婂姛鑳芥祴璇曟姤鍛奯鎶曡祫棰勫畨鎺掓眹鎬昏ˉ璁′笌瀵煎叆寮圭獥_2026-09-20.md銆嬶細**14 鏉＄敤渚嬮�氳繃锛�1 鏉′负闈欐��/缂栬瘧绾ч獙璇侊紝鐐瑰嚮绾ч獙鏀跺緟鐢ㄦ埛瀹炴祴锛�**銆�
+
+| 鏍￠獙椤� | 缁撴灉 |
+| --- | --- |
+| 娈嬬暀鍑哄簱 | 鐗╂祦椤圭洰 135鈫�104銆佹湀搴︽暟 167鈫�136锛涘浠� TSV 77 琛� |
+| 鐢熸垚琛ㄦ姹夌墿娴佹 | 33 琛� 鈫� 6 琛岋紙鑸彂/涓��/闃抽�绘腐/鏋佸厰/鍗庝腑鍖栧鍝�/杩堢澘杈撅級 |
+| 姝︽眽鐗╂祦灏忚锛堣ˉ璁★級 | c8=272476锛�6 涓」鐩�绘姇璧勫拰锛夛紝鍏朵綑鍒楃┖ |
+| 榛勭煶鐗╂祦灏忚 | 729375.69 鈫� 614991.69 |
+| 鍧楀悎璁�/鍏ㄧ渷鍚堣 | 鐗╂祦 5889737.36銆佸杩� 763632.2銆佸叏鐪� 6653369.56锛屼笌 SQL 涓�鑷� |
+| 1-8鏈堢疮璁★紙c23锛� | 744262.86 鈫� 733956.06锛屽樊棰� = 琚垹椤圭洰 year_cum 涔嬪拰锛岃ˉ璁℃湭姹℃煋璇ュ垪 |
+| 浼」鐩竻闄� | 鍜稿畞瀹㈣繍灏忚 27454 鈫� 13727 |
+| 鐢熸垚琛ㄨ鏁� | 313 鈫� 281 |
+| 鍏跺畠鎶曡祫鎶ヨ〃鍥炲綊 | investBillion/County/FiveYearLogistics 鍚� 136 琛屻�佷袱寮犳槑缁嗚〃 39/97 琛岋紝ready=true锛屽潎鍙鍑� |
+| 璐熷悜 | `types=foo` 鈫� ready=false锛宯ote銆屾湭鐭ユ姤琛ㄧ被鍨嬶細foo銆� |
+
+銆婂姛鑳芥祴璇曟姤鍛奯姹囨�诲ぇ琛ㄥ紓姝ュ鍑轰笌缂撳瓨_2026-09-20.md銆嬶細**17 鏉＄敤渚嬮�氳繃锛堟帴鍙� 8 + 娴忚鍣ㄥ疄娴� 7 + 澶嶉獙 2锛�**銆�
+
+| 鏍￠獙椤� | 缁撴灉 |
+| --- | --- |
+| 鎻愪氦寮傛浠诲姟 | 0.07s 杩斿洖 taskId锛涜繘搴� 6鈫�22鈫�45鈫�70鈫�95鈫�100锛�14.4s 瀹屾垚 |
+| 浠诲姟鏂囦欢涓嬭浇 | 1,325,109 瀛楄妭锛�1.27s |
+| 10 鍒嗛挓鍐呯紦瀛樺鐢� | fromCache=true銆佸悓 taskId銆�0.01s |
+| refresh=true 寮哄埗閲嶇畻 | 鏂颁换鍔″彿锛岀湡瀹為噸绠� 14.2s |
+| 杩愯涓苟鍙戝幓閲� | 涓ゆ鎻愪氦杩斿洖鍚屼竴 taskId锛�11.1s锛� |
+| 鏂板瀵煎叆浣跨紦瀛樺け鏁� | import_batch id 533鈫�534 鍚� fromCache=false锛堟祴璇曞悗宸� DELETE 娓呭洖 533锛� |
+| 璐熷悜锛氫笉瀛樺湪 / 鏈畬鎴� taskId | 銆屽鍑轰换鍔′笉瀛樺湪鎴栧凡杩囨湡銆嶃�屽皻鏈畬鎴愶紙褰撳墠鐘舵�侊細RUNNING锛夈�� |
+| 娴忚鍣ㄥ疄娴� | 杩涘害寮圭獥閲囨牱銆佽嚜鍔ㄤ笅杞姐�佺紦瀛樻彁绀恒�侀噸鏂扮敓鎴愩�佸悗鍙拌繍琛屻�佸け璐ユ彁绀� 6 椤瑰叏閫氳繃 |
+| 浜х墿涓�鑷存�� | 缂撳瓨浠朵笌閲嶇畻浠惰В鍖呭悗閫愭潯鐩竴鑷达紱涓変唤缂撳瓨浠� SHA256 鐩稿悓 |
+| 闄勫甫淇 | `computed` 閲嶅閿鑷存姤琛ㄧ敓鎴愰〉鏁撮〉鐧藉睆锛堝凡淇骞舵祻瑙堝櫒澶嶉獙锛� |
+| 澶嶉獙锛堢敤鎴烽棶棰� 2锛� | 棰勮鍚屾瘮 12 琛岄綈鍏紱銆岀疮璁¤揣鐗╁懆杞噺 0%銆嶇粡鏌ュ簱涓哄彇鏁版簮鏈韩 `total_yoy=0.00000346`锛岄潪缂洪櫡 |
+
+銆婂姛鑳芥祴璇曟姤鍛奯甯傚窞缁熶竴濉姤妯℃澘涓庡幙甯傚尯瑙ｆ瀽_2026-09-20.md銆嬶細**10 鏉＄敤渚嬮�氳繃锛堟鍚� 5 + 璐熷悜 3 + 鍥炲綊 2锛�**銆�
+
+| 鏍￠獙椤� | 缁撴灉 |
+| --- | --- |
+| 妯℃澘缁撴瀯 | 涓や唤妯℃澘鍧囦负銆屾湀鎶ャ��17 鍒楄〃澶� + 寤鸿鎬ц川涓嬫媺 + 濉姤璇存槑 11 鏉� |
+| 姝ｅ悜瀵煎叆锛堟ā鏉垮～鎶ワ級 | total=2銆乻uccess=2銆乧ity=姝︽眽甯� |
+| 涓绘。閫愬瓧娈� | 鍘垮尯锛堟睙宀稿尯/娲北鍖猴級銆佸缓璁惧崟浣嶃�佹�ц川銆佸紑宸�/绔ｅ伐骞淬�佹�绘姇璧勩�佸伐鍙�/鍒濊鍏ㄩ儴瀵归綈 |
+| 鏈堝害鏁伴�愬瓧娈� | 鑷紑濮嬬疮璁�/鏈勾璁″垝/鑷勾鍒濈疮璁�/鏈湀瀹屾垚/寤鸿闃舵/褰㈣薄杩涘害鍏ㄩ儴瀵归綈锛屾姤琛ㄦ湡 2026-09 |
+| 璐熷悜锛氳鏄庨〉琚綋鏁版嵁琛� | 淇鍓� 8 鏉¤瑙ｆ瀽锛坕d 233~240锛夆啋 淇鍚� 0 鏉� |
+| 璐熷悜锛氬幙鍖哄垪鍐欐硶鍙樹綋 | 銆屽幙锛堝競銆佸尯锛�/鍘�(甯傘�佸尯)/鍘垮競鍖恒�嶅綊涓�鍖栧悗鍧囧懡涓� |
+| 鍥炲綊锛�8 鏈堢湡瀹炲競宸為噸瀵� | 瀹㈣繍 39銆佺墿娴� 128锛屼笌 09-19 鎵规涓�鑷达紝fail=0 |
+| 鍥炲綊锛�8 鏈堟湀搴︽暟姣斿 | 閲嶅鍓嶅悗 136 琛岄�愬�� **IDENTICAL** |
+| 鏁版嵁娓呯悊 | 娴嬭瘯椤圭洰 A/B銆�2026-09 鎵规銆佹祴璇曟枃浠跺潎宸插垹闄� |
+
+## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙
+
+1. 姝︽眽鐗╂祦椤圭洰娓呭崟鍙ｅ緞锛堝凡纭蹇界暐锛夈��
+2. 澶╅棬鐗╂祦婧愭枃浠� H/J/K 涓虹┖ 鈫� 寰呯敤鎴锋壘鍚屼簨瑕佹暟鎹悗瀵煎叆銆�
+3. 鑽嗗窞/榛勭煶銆岃鍒掑唴/瑙勫垝澶栥�嶆媶鍒嗗彛寰� 鈫� 寰呯敤鎴峰悜鍚屼簨纭銆�
+4. ~~C 缁勶紙鍩庡競瀹㈣繍椤电粨鏋勫綊涓�锛岄渶鐢ㄦ埛鍏堝湪 WPS 鏁村垪鍒犻櫎 AJ 鍒楋級~~ **宸插畬鎴�**锛堟敼鐢� Excel COM 鏁村垪鍒犻櫎 + 鍏紡杩樺師锛夛紱
+   D 缁勶紙澧為�熸帓鍚嶆帾杈烇級锛廈4锛堝鍑哄墠鍩烘暟浣撴 + 寮圭獥 + 銆婃暟鎹己澶辨竻鍗曘�嬮〉锛夊緟鎺掓湡銆�
+5. 缂烘瘝鐗堟彁绀猴紙T08锛夋湭瀹炴祴锛屽彲鍦ㄦ湁娴嬭瘯鍓湰鏃惰ˉ娴嬨��
+6. ~~姹囨�诲ぇ琛ㄥ鍑烘槸鍚屾璇锋眰锛屽缓璁仛鎴愬紓姝ヤ换鍔� + 杩涘害鎻愮ず~~ **宸插畬鎴�**锛堣 1.7锛夈�傜紦瀛樻槸鍐呭瓨鎬侊紝杩涚▼閲嶅惎鍗冲け鏁堬紱濡傞渶璺ㄩ噸鍚�/澶氫汉鍏辩敤鐨勩�屽鍑鸿褰曘�嶉〉鍙悗琛ャ��
+7. 閮ㄧ讲鍖� `deploy/traffic-audit-deploy-20260913/backend/docs/鐢熸垚姹囨�诲ぇ琛�/` 涓� `_deploytest/` 涓嬩粛鏄�**甯� AJ 鍒楃殑鏃ф瘝鐗�** 鈥斺��
+   鐢ㄦ埛 2026-09-20 鏄庣‘銆岄儴缃插寘鍏堜笉绠°�嶏紝**鏆備笉澶勭悊**锛堝緟瑕佸彂鍖呮椂鍐嶅悓姝ワ級銆�
+8. 涓彛寰勬槑缁� 4 鏍硷紙鍩庨檯鍩庝埂宸℃父鍑虹/缃戠害杞︼級鍥� 2025骞�8鏈堝熀鏁颁负 0锛屽悓姣旀樉绀� `#DIV/0!`锛堜笉鍙瘮锛夛紝濡傞渶鏀圭┖鐧介渶鐢ㄦ埛纭鍙ｅ緞銆�
+
+## 鍥涖�佹槑鏃ヨ鍒�
+
+1. 绛夊ぉ闂ㄦ簮鏁版嵁 / 鑽嗗窞榛勭煶鍙ｅ緞纭鍚庤ˉ瀵煎苟澶嶉獙銆�
+2. 鎺ㄨ繘 C/D 缁勪笌 B4銆�
+3. 涓庣敤鎴风‘璁ゆ槸鍚︽妸 09-18 澶滈棿璧风殑鏈湴鎻愪氦涓�骞舵帹閫佸埌鍏徃 gitea锛堢敤鎴� 09-19 鏇捐姹傘�屼粖澶╁厛涓嶆帹鍏徃銆嶏級銆�
+4. ~~璇勪及姹囨�诲ぇ琛ㄥ鍑哄紓姝ュ寲~~ **宸插畬鎴�**锛堣 1.7锛氬紓姝ヤ换鍔� + 杩涘害寮圭獥 + 10 鍒嗛挓缁撴灉缂撳瓨 + 鏁版嵁鐗堟湰瀹堝崼锛夛紱閮ㄧ讲鍖呮瘝鐗堟寜鐢ㄦ埛瑕佹眰鏆備笉澶勭悊銆�
+
+9. **8 鏈堢増鍗佸牥姹囨�昏〃鏈竻鐞�**锛氱敤鎴峰彧娓呬簡 7 鏈堢増锛�108032鈫�90112 瀛楄妭锛夛紝8 鏈堢増锛坢time 2026-08-20锛変粛鍚姹� 27 + 榛勭煶 4 娈碉紱
+   鑻ラ噸瀵� 8 鏈堢墿娴侊紝宸插垹闄ょ殑 31 涓」鐩細閲嶆柊寤烘。 鈫� 閲嶅鍓嶉渶鍚屾牱娓呯悊锛堟垨鐢辨垜浠ｅ仛锛屽緟鐢ㄦ埛纭锛夈��
+    **2026-09-20 涓嬪崍鍋氬洖褰掗噸瀵兼椂宸插疄娴嬪鐜�**锛�8 鏈堢墿娴侀噸瀵煎悗 +31 涓」鐩� / +31 鏉℃湀搴︽暟锛夛紝宸插啀娆℃竻闄わ紝搴撳洖鍒� 152 涓」鐩� / 284 鏉℃湀搴︽暟锛�2026-08 鏈堝害鏁伴�愬�间笌閲嶅鍓嶄竴鑷淬��
+10. 甯傚窞鍗曡〃瀵煎叆鐨�**澶氬競宸炲潡鍏滃簳鎻愮ず**锛堣瘑鍒竴浠芥枃浠跺惈澶氫釜甯傚窞鍧楀苟鎻愮ず/璺宠繃锛夊緟鐢ㄦ埛纭鏄惁瑕佸仛銆�
+11. 鐢熸垚琛ㄦ姹夌墿娴佸皬璁＄幇鍦ㄥ彧鏈夈�屾�绘姇璧勩�嶏紝缂� 8 鏈堢殑鑷紑濮嬬疮璁�/鏈勾璁″垝/鏈堝畬鎴� 鈫� 闇�姝︽眽 8 鏈堢墿娴佸崟琛紙鎴栫渷鍘呭彛寰勶級鎵嶈兘琛ラ綈銆�
+12. 涓や唤甯傚窞濉姤妯℃澘寰呯敤鎴疯繃鐩悗涓嬪彂甯傚窞锛堝缓璁� 9 鏈堣捣鎵ц锛夛紱濡傞渶銆屾ā鏉夸綋妫� + 琛ㄥご涓嶇寮圭獥銆嶏紝寰呯敤鎴风‘璁ゅ悗鎺掓湡銆�
+13. 8 鏈堝崄鍫扮墿娴佹眹鎬昏〃婧愭枃浠讹紙鍚姹� 27 + 榛勭煶 4锛夋槸鍚︾敱鎴戜唬鍋氭竻鐞嗭紝寰呯敤鎴风‘璁わ紙瑙� 1.8 / 娴嬭瘯鎶ュ憡 P3锛夈��

--
Gitblit v1.9.1