From 49fea21571a4060aa8570cbf220088352e2ccf15 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期三, 16 九月 2026 17:33:01 +0800 Subject: [PATCH] docs(工作日结): 补记 2026-09-16 收工记录（origin 已推 80e0879、gitea 仍不通、未提交项与明日计划） --- docs/功能测试报告/功能测试报告_2026-07母版补齐与导出件打不开修复_2026-09-16.md | 86 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 86 insertions(+), 0 deletions(-) diff --git "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_2026-07\346\257\215\347\211\210\350\241\245\351\275\220\344\270\216\345\257\274\345\207\272\344\273\266\346\211\223\344\270\215\345\274\200\344\277\256\345\244\215_2026-09-16.md" "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_2026-07\346\257\215\347\211\210\350\241\245\351\275\220\344\270\216\345\257\274\345\207\272\344\273\266\346\211\223\344\270\215\345\274\200\344\277\256\345\244\215_2026-09-16.md" new file mode 100644 index 0000000..1c5da10 --- /dev/null +++ "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_2026-07\346\257\215\347\211\210\350\241\245\351\275\220\344\270\216\345\257\274\345\207\272\344\273\266\346\211\223\344\270\215\345\274\200\344\277\256\345\244\215_2026-09-16.md" @@ -0,0 +1,86 @@ +# 鍔熻兘娴嬭瘯鎶ュ憡 鈥� 2026-07 姣嶇増琛ラ綈 & 瀵煎嚭浠躲�孍xcel 鎵撲笉寮�銆嶄慨澶� + +- 鏃ユ湡锛�2026-09-16 +- 鑼冨洿锛氭眹鎬诲ぇ琛紙`/api/report/export/summaryWorkbook`锛�2026-07 / 2026-08 瀵煎嚭锛沗docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` 姣嶇増琛ラ綈 +- 鍏宠仈锛歚docs/闂姹囨��/闂涓庢敞鎰忎簨椤规眹鎬籣2026-09-16.md` 绗崄涓夎妭 + +## 涓�銆佽儗鏅� + +銆� 璐ц繍銆嬮〉銆岀疮璁°�嶅垪鍙ｅ緞鍦� 2026-09-16 宸插湪 **8 鏈堟瘝鐗�** 钀藉湴锛堣绗崄浜岃妭锛夈�傜敤鎴风‘璁ゃ�屽彲浠ヨˉ榻愩�嶏紝瑕佹眰鎶婂悓涓�鍙ｅ緞琛ュ埌 **7 鏈堟瘝鐗�**锛屽苟瑙ｅ喅 7 鏈堝鍑轰欢鏃犳硶鐢� Excel 鎵撳紑鐨勯棶棰樸�� + +## 浜屻�佹祴璇曠幆澧� + +| 椤� | 鍊� | +|---|---| +| 鍚庣 | Spring Boot锛�8090锛堜慨澶嶅悗宸查噸鍚級 | +| 鍓嶇 | Vue锛�8080 | +| 鏁版嵁搴� | MySQL 127.0.0.1:3308 / traffic_audit | +| Excel 鍒ゆ嵁 | Excel COM `Workbooks.Open`锛堟瘡渚嬬嫭绔嬪疄渚嬶紝娴嬪悗寮烘潃瀛ゅ効杩涚▼锛� | +| 缁撴瀯鍒ゆ嵁 | Python `zipfile` + `xml.etree` 閫愰儴浠舵牎楠屻�侀�愭牸 `<c>` 瑙ｆ瀽 | + +## 涓夈�佸彂鐜扮殑鏍瑰洜锛堜袱澶勶紝鍧囦负鏈淇瀵硅薄锛� + +### 3.1 瀵煎嚭浠舵墦涓嶅紑锛氭畫鐣� `<is>` 鐨勯潪娉曞崟鍏冩牸 + +鍧忎欢閲屽瓨鍦� 19 涓�**妯″紡闈炴硶**鐨勬牸瀛愶細 + +``` +<c r="E15" s="111" t="n"><v>67.0</v><is><t>67.00</t></is></c> +``` + +`<is>`锛坕nlineStr锛夊彧鍏佽鍑虹幇鍦� `t="inlineStr"` 鐨勬牸閲岋紱`t="n"` 鍗村甫 `<is>` 灞炰簬闈炴硶锛孍xcel 鐩存帴鍒ゅ畾銆屾棤娉曡鍙栫殑鍐呭銆嶆嫆缁濇墦寮�锛圕OM 琛ㄧ幇涓恒�屼笉鑳藉彇寰楃被 Workbooks 鐨� Open 灞炴�с�嶏紝杩炰慨澶嶆ā寮� `CorruptLoad=1` 涔熸墦涓嶅紑锛夈�� + +**鎴愬洜**锛�7 鏈堟瘝鐗堢敱 **openpyxl** 鍐欏嚭锛坄docProps/app.xml` = `Microsoft Excel Compatible / Openpyxl 3.1.5`锛屾枃鏈敤 `<is>` 瀛樺偍锛夈�傚鍑烘椂鍒殑鍐欏叆璺緞鍙敼 `t`/`<v>`锛�**涓嶆竻鏃� `<is>`**锛涜�� 8 鏈堟瘝鐗堟槸 Excel 鍘熺敓锛堟枃鏈蛋 sharedStrings锛夛紝鎵�浠ュ悓鏍蜂唬鐮佷笅 8 鏈堜欢姝ｅ父銆�7 鏈堜欢鍧忋�� + +**涓轰粈涔堝彧鏈� 7 鏈堝潖**锛�7 鏈堝瓨鍦ㄥ悓鏈熷浠芥瘝鐗� `_澶囦唤_2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃_娓呯悊鍓峗20260904.xlsx`锛宍restoreSummaryMonthlyBlocks` 浼氭暣鏍煎洖濉紱鍥炲～鍐欏叆 inlineStr 姣嶇増鏍兼椂鐣欎笅鏃� `<is>`銆�8 鏈堟病鏈夎 `_澶囦唤_*` 鏂囦欢锛屼笉璧板洖濉紝鍥犳涓嶈Е鍙戙�� + +**瀹氫綅鏂规硶**锛堝彲澶嶇敤锛夛細鍧忎欢涓庡ソ浠堕櫎 worksheets/styles/sharedStrings 澶�**鍏ㄩ儴閮ㄤ欢閫愬瓧鑺傜浉鍚�** 鈫� 鐢� zip 鏉備氦 + Excel 閫愪竴寮�妗ｅ仛 leave-one-out锛屽畾浣嶅埌 **sheet9銆婂叕浜ゃ��(17 鏍�) + sheet12銆婅建閬撱�佽疆娓°��(2 鏍�)**銆� + +### 3.2 姣嶇増琛ラ綈琚浠芥瘝鐗堛�岀敓鎴愬張澶嶆椿銆� + +琛ュソ 7 鏈堟瘝鐗堝悗瀵煎嚭锛宍璐ц繍` 椤� 2022/2021 绱**鍙堝彉鍥炴棫鍐欐甯搁噺** 鈥斺�� 鍥犱负 `restoreSummaryMonthlyBlocks` 鎶婂浠芥瘝鐗堬紙娓呯悊鍓嶃�佷粛鏄棫甯搁噺锛夋暣鏍煎洖濉鐩栦簡姣嶇増鐨勬柊鍏紡銆� + +## 鍥涖�佷慨澶嶅唴瀹� + +| # | 浣嶇疆 | 鏀瑰姩 | +|---|---|---| +| 1 | `ReportExportService.exportSummaryWorkbook` | 钀界洏鍓嶆柊澧� `normalizeStaleInlineStrings(wb)`锛氭妸鎵�鏈夈�岄潪 inlineStr 鍗存畫鐣� `<is>`銆嶇殑鏍煎瓙娓呮帀锛堝箓绛夛級锛屽苟鎵� warn 鏃ュ織 | +| 2 | `ReportExportService.restoreSummaryMonthlyBlocks` | 鏂板 `skipFreightHistoryBlocks`锛氥�� 璐ц繍銆嬮〉 **T 鍒楀強浠ュ悗**锛�2025/2024/2023/2022/2021 骞村害鍧� + 鍚勫勾绱/绱鍚屾瘮鍒楋級姘镐笉浠庡浠芥瘝鐗堝洖濉紝閬垮厤鈥滅敓鎴愬張澶嶆椿鈥濓紙涓庢棦鏈夈�屼腑鍙ｅ緞鎺掑悕銆嶅乏鍧椾繚鎶ゅ悓涓�鎬濊矾锛� | +| 3 | `docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` | Excel COM 琛ラ綈锛�2025/2024/2023/2022/2021 浜斾釜骞村害鍧楀叡 **360** 涓潡鍐呮牸锛坄r7/r9/r8/r10 = SUM(17 甯傚窞)`銆乣r5=r7+r9`銆乣r6=r8+r10`锛�+ **324** 涓疮璁℃牸锛坄DX=SUM(DK:DV)`銆乣EM=SUM(EA:EL)`銆乣DY=IFERROR(DX/SUM(EA:EL)-1,"")`锛夛紝`CalculateFullRebuild` 鍚庝繚瀛� | + +> 澶囦唤锛歚docs/鐢熸垚姹囨�诲ぇ琛�/_bak_2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃_琛ラ綈鍓峗20260916.xlsx`锛�**鏁呮剰涓嶇敤 `_澶囦唤_` 鍓嶇紑**锛屽惁鍒欎細琚� `resolveSummaryDonor` 褰撴垚 donor 鍥炲～锛夈�� + +## 浜斻�佺敤渚嬭〃 + +| # | 鐢ㄤ緥 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +|---|---|---|---|---|---| +| 1 | 鍧忎欢澶嶇幇 | 2026-07 瀵煎嚭锛堜慨澶嶅墠锛� | 鍙墦寮� | Excel 鎶ャ�屼笉鑳藉彇寰楃被 Workbooks 鐨� Open 灞炴�с�嶏紝閲嶈瘯 2 娆′粛澶辫触 | 澶嶇幇 | +| 2 | 鐜鎺掗櫎 | 10KB 灏忎欢 / 8 鏈堟瘝鐗� / 7 鏈堟瘝鐗� / 09-08 鏃� 7 鏈堝鍑� | 鈥� | 鍏ㄩ儴鍙墦寮�锛涗粎鏂� 7 鏈堝鍑哄け璐� | 纭闈炵幆澧冮棶棰� | +| 3 | 璺緞鎺掗櫎 | 鍧忎欢澶嶅埗鍒板彟涓�鐩綍鏀瑰悕 | 浠嶅け璐� | 浠嶅け璐� | 纭鏄枃浠跺唴瀹归棶棰� | +| 4 | 閮ㄤ欢绾ф潅浜� | 鍧忎欢 + 濂戒欢鐨� styles/sharedStrings/worksheets | 瀹氫綅鍧忛儴浠� | 鍧忎欢 styles + 鍧忎欢 sst + **濂戒欢鍏ㄩ儴 sheets** 鈫� 鍙墦寮� | 瀹氫綅鍒� worksheets | +| 5 | leave-one-out | 19 涓� sheet 閫愪釜鎹㈡垚鍧忎欢鐗� | 鎵惧嚭鍧� sheet | 浠� **sheet9銆婂叕浜ゃ��/ sheet12銆婅建閬撱�佽疆娓°��** 澶辫触 | 瀹氫綅鍒� 2 椤� | +| 6 | 璐熷悜锛氶潪娉曟牸璁℃暟 | 淇鍓嶅鍑轰欢 | 鈥� | 19 涓� `t="n"` 甯� `<is>` | 鍛戒腑鏍瑰洜 | +| 7 | 姝ｅ悜锛氫慨澶嶅悗 2026-07 | 閲嶅惎鍚庣鍚庡鍑� | 鍙墦寮�銆�19 椤点�佺疮璁″ | OK sheets=19锛沗DX5=144979.2825`锛坄=SUM(DK5:DV5)`锛夈�乣DY5=-0.101235487797891`銆乣EM5=161309.53162`銆乣CU5=173045.296428512` | 閫氳繃 | +| 8 | 姝ｅ悜锛氫慨澶嶅悗 2026-08 | 鍚屼笂 | 鍙墦寮�銆佺疮璁′笉鍙� | OK sheets=19锛沗DZ5=144979.2825`銆乣EO5=161309.53162`銆乣CW5=173045.296428512`銆乣S5=130311.892698249` | 閫氳繃 | +| 9 | 璺ㄦ湀涓�鑷存�� | 7 鏈� vs 8 鏈堝悓鍙ｅ緞鏍煎瓙 | 瀹屽叏鐩哥瓑 | 2022 绱 / 2021 绱 / 2023 绱 涓変釜鏈堝害 鈫� 涓変釜鍊�**瀹屽叏鐩哥瓑** | 閫氳繃 | +| 10 | 闈炴硶鏍煎鎵� | 淇鍚� 7 鏈堝鍑� | 0 涓� | 0 涓� | 閫氳繃 | +| 11 | 姣嶇増鍙墦寮� | 琛ラ綈鍚庣敤 Excel 鎵撳紑 7 鏈堟瘝鐗� | 鍙墦寮� | 鍙墦寮� | 閫氳繃 | +| 12 | 娈嬬暀鏁版嵁澶嶆牳 | `2026-09` 浜斿紶琛ㄨ鏁� | 鍏� 0 | 鍏� 0锛坔204 / investment_monthly / h2032 / audit_result / import_batch锛� | 閫氳繃 | + +## 鍏�佸彂鐜扮殑闂涓庡缃� + +1. **7 鏈堝鍑轰欢鎵撲笉寮�**锛圥0锛夛細`normalizeStaleInlineStrings` 鏍规不锛涘鍑轰欢浠� 941,960 瀛楄妭锛堝潖锛夆啋 1,310,693 瀛楄妭锛堝ソ锛夈�� +2. **澶囦唤姣嶇増鍥炲～璁╄ˉ榻愬け鏁�**锛圥0锛夛細`skipFreightHistoryBlocks` 淇濇姢 `璐ц繍` T 鍒楀強浠ュ悗銆� +3. **Excel COM 浼氱暀瀛ゅ効杩涚▼**锛氭瘡渚嬫祴瀹屽繀椤诲己鏉�鏈鏂板缓鐨� `EXCEL` 杩涚▼锛屽惁鍒欏悗缁� `Workbooks.Open` 浼�**闂存瓏鎬у亣鎶�**鍚屾牱鐨勯敊锛堟湰娆℃帓鏌ュ垵鏈熻姝ゅ共鎵拌繃锛夈�傚睘鎺掓煡宸ュ叿鍧戯紝宸茶鍏ラ棶棰樻眹鎬汇�� +4. **娉ㄦ剰**锛氭湰娆�**鏈�**鏀瑰姩 8 鏈堟瘝鐗堜笌浠讳綍鍏ュ簱鏁版嵁銆� + +## 涓冦�佺粨璁� + +- 2026-07 / 2026-08 涓や釜瀵煎嚭浠跺潎鍙 Excel 姝ｅ父鎵撳紑锛堝悇 19 椤碉級锛屼笖銆� 璐ц繍銆嬮〉 2021/2022/2023 绱鍒楀彛寰�**瀹屽叏涓�鑷�**銆� +- 7 鏈堟瘝鐗堝凡鎸� 8 鏈堟瘝鐗堝彛寰勮ˉ榻愶紙骞村害鍧� 360 鏍� + 绱 324 鏍硷級锛屽苟浠� openpyxl 琛�缂樿浆涓� Excel 鍘熺敓銆� +- 鐢ㄦ埛瑕佹眰鐨勩�屾畫鐣欐暟鎹叏閮ㄦ竻闄ゃ�嶇粡澶嶆牳涓� 0 娈嬬暀銆� + +## 鍏�侀仐鐣� + +- 2026-06 / 2026-09 鏃犳瘝鐗� 鈫� 棰勮杩斿洖 `ready=False`銆屾湭鎵惧埌妯℃澘鏂囦欢銆嶏紝闇�鏂板缓姣嶇増鎵嶈兘鍑烘暟锛堢敤鎴风 5 闂殑寤朵几锛夈�� +- 浠撳簱鏍圭洰褰� `_*.*` 涓存椂鎺掓煡鏂囦欢锛堝惈鏈 `_hyb_*` / `_loo_*` / `_v2_*` / `_final_*`锛夋湭鍒狅紝寰呯敤鎴峰悓鎰忋�� -- Gitblit v1.9.1