From 35d098a89613c96179391178b7f8143dec393ada Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 20 九月 2026 15:52:36 +0800
Subject: [PATCH] feat(报表): 汇总大表导出异步化 + 结果缓存 + 进度弹窗
---
docs/工作日结/工作日结_2026-09-20.md | 39 ++++++++++++++++++++++++++++++++++-----
1 files changed, 34 insertions(+), 5 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"
index 484d9d4..14124c7 100644
--- "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"
@@ -68,6 +68,20 @@
骞舵柊澧炪�屽鍑烘槑缁嗐�嶆寜閽紙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()` 鐩存帴鎶涢敊銆�**鏁撮〉鐧藉睆**銆傛帴鍙ｆ祴璇曞彂鐜颁笉浜嗭紝鏄祻瑙堝櫒瀹炴祴鎵嶆毚闇茬殑锛堣瑙佹祴璇曟姤鍛婄鍥涜妭锛夈��
+
## 浜屻�佹祴璇曠粨鏋滄憳瑕�
銆婂姛鑳芥祴璇曟姤鍛奯鎶曡祫鏄庣粏琛ㄥ氨缁笌棰勮绫诲瀷琛ラ綈_2026-09-20.md銆嬶細**7 鏉＄敤渚嬮�氳繃锛�1 鏉℃湭瀹炴祴**锛堢己姣嶇増鎻愮ず锛屾湭涓存椂绉诲姩鐢ㄦ埛姣嶇増鏂囦欢锛夈��
@@ -109,6 +123,22 @@
| 鍏跺畠鎶曡祫鎶ヨ〃鍥炲綊 | 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`锛岄潪缂洪櫡 |
+
## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙
1. 姝︽眽鐗╂祦椤圭洰娓呭崟鍙ｅ緞锛堝凡纭蹇界暐锛夈��
@@ -117,10 +147,9 @@
4. ~~C 缁勶紙鍩庡競瀹㈣繍椤电粨鏋勫綊涓�锛岄渶鐢ㄦ埛鍏堝湪 WPS 鏁村垪鍒犻櫎 AJ 鍒楋級~~ **宸插畬鎴�**锛堟敼鐢� Excel COM 鏁村垪鍒犻櫎 + 鍏紡杩樺師锛夛紱
D 缁勶紙澧為�熸帓鍚嶆帾杈烇級锛廈4锛堝鍑哄墠鍩烘暟浣撴 + 寮圭獥 + 銆婃暟鎹己澶辨竻鍗曘�嬮〉锛夊緟鎺掓湡銆�
5. 缂烘瘝鐗堟彁绀猴紙T08锛夋湭瀹炴祴锛屽彲鍦ㄦ湁娴嬭瘯鍓湰鏃惰ˉ娴嬨��
-6. 姹囨�诲ぇ琛ㄥ鍑烘槸**鍚屾璇锋眰**锛屽綋鍓嶇害 14 绉掞紙姣忔閮借閲嶇畻鏁存湰绾� 4 涓囨牸鍏紡锛夛細鏁版嵁閲忓啀娑ㄤ富瑕佹槸 SQL 鑱氬悎鍙樻參锛�
- 涓嶄細銆屽崱姝汇�嶏紝浣嗗缓璁悗缁仛鎴愬紓姝ヤ换鍔� + 杩涘害鎻愮ず銆�
-7. 閮ㄧ讲鍖� `deploy/traffic-audit-deploy-20260913/backend/docs/鐢熸垚姹囨�诲ぇ琛�/` 涓� `_deploytest/` 涓嬩粛鏄�**甯� AJ 鍒楃殑鏃ф瘝鐗�**锛�
- 涓嬫鎵撳寘鏃堕渶鍚屾锛堟湭缁忕敤鎴风‘璁や笉鎿呰嚜鏀归儴缃蹭骇鐗╋級銆�
+6. ~~姹囨�诲ぇ琛ㄥ鍑烘槸鍚屾璇锋眰锛屽缓璁仛鎴愬紓姝ヤ换鍔� + 杩涘害鎻愮ず~~ **宸插畬鎴�**锛堣 1.7锛夈�傜紦瀛樻槸鍐呭瓨鎬侊紝杩涚▼閲嶅惎鍗冲け鏁堬紱濡傞渶璺ㄩ噸鍚�/澶氫汉鍏辩敤鐨勩�屽鍑鸿褰曘�嶉〉鍙悗琛ャ��
+7. 閮ㄧ讲鍖� `deploy/traffic-audit-deploy-20260913/backend/docs/鐢熸垚姹囨�诲ぇ琛�/` 涓� `_deploytest/` 涓嬩粛鏄�**甯� AJ 鍒楃殑鏃ф瘝鐗�** 鈥斺��
+ 鐢ㄦ埛 2026-09-20 鏄庣‘銆岄儴缃插寘鍏堜笉绠°�嶏紝**鏆備笉澶勭悊**锛堝緟瑕佸彂鍖呮椂鍐嶅悓姝ワ級銆�
8. 涓彛寰勬槑缁� 4 鏍硷紙鍩庨檯鍩庝埂宸℃父鍑虹/缃戠害杞︼級鍥� 2025骞�8鏈堝熀鏁颁负 0锛屽悓姣旀樉绀� `#DIV/0!`锛堜笉鍙瘮锛夛紝濡傞渶鏀圭┖鐧介渶鐢ㄦ埛纭鍙ｅ緞銆�
## 鍥涖�佹槑鏃ヨ鍒�
@@ -128,7 +157,7 @@
1. 绛夊ぉ闂ㄦ簮鏁版嵁 / 鑽嗗窞榛勭煶鍙ｅ緞纭鍚庤ˉ瀵煎苟澶嶉獙銆�
2. 鎺ㄨ繘 C/D 缁勪笌 B4銆�
3. 涓庣敤鎴风‘璁ゆ槸鍚︽妸 09-18 澶滈棿璧风殑鏈湴鎻愪氦涓�骞舵帹閫佸埌鍏徃 gitea锛堢敤鎴� 09-19 鏇捐姹傘�屼粖澶╁厛涓嶆帹鍏徃銆嶏級銆�
-4. 璇勪及姹囨�诲ぇ琛ㄥ鍑哄紓姝ュ寲锛堥暱浠诲姟杩涘害鏉� / 缁撴灉缂撳瓨锛夛紝骞剁‘璁ら儴缃插寘姣嶇増鍚屾鏂瑰紡銆�
+4. ~~璇勪及姹囨�诲ぇ琛ㄥ鍑哄紓姝ュ寲~~ **宸插畬鎴�**锛堣 1.7锛氬紓姝ヤ换鍔� + 杩涘害寮圭獥 + 10 鍒嗛挓缁撴灉缂撳瓨 + 鏁版嵁鐗堟湰瀹堝崼锛夛紱閮ㄧ讲鍖呮瘝鐗堟寜鐢ㄦ埛瑕佹眰鏆備笉澶勭悊銆�
9. **8 鏈堢増鍗佸牥姹囨�昏〃鏈竻鐞�**锛氱敤鎴峰彧娓呬簡 7 鏈堢増锛�108032鈫�90112 瀛楄妭锛夛紝8 鏈堢増锛坢time 2026-08-20锛変粛鍚姹� 27 + 榛勭煶 4 娈碉紱
鑻ラ噸瀵� 8 鏈堢墿娴侊紝宸插垹闄ょ殑 31 涓」鐩細閲嶆柊寤烘。 鈫� 閲嶅鍓嶉渶鍚屾牱娓呯悊锛堟垨鐢辨垜浠ｅ仛锛屽緟鐢ㄦ埛纭锛夈��
--
Gitblit v1.9.1