From 09e612af50beb200027317d6d4ccf7ad7092838e Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期五, 11 九月 2026 17:53:07 +0800 Subject: [PATCH] docs: 补充「数据导入」白屏修复的发布与二次独立验证记录 --- docs/功能测试报告/功能测试报告_汇总表排名页刷新与同比百分数_2026-09-11.md | 80 ++++++++++++++++++++++++++++++++++++++++ 1 files changed, 80 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_\346\261\207\346\200\273\350\241\250\346\216\222\345\220\215\351\241\265\345\210\267\346\226\260\344\270\216\345\220\214\346\257\224\347\231\276\345\210\206\346\225\260_2026-09-11.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_\346\261\207\346\200\273\350\241\250\346\216\222\345\220\215\351\241\265\345\210\267\346\226\260\344\270\216\345\220\214\346\257\224\347\231\276\345\210\206\346\225\260_2026-09-11.md" new file mode 100644 index 0000000..a3fbccd --- /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_\346\261\207\346\200\273\350\241\250\346\216\222\345\220\215\351\241\265\345\210\267\346\226\260\344\270\216\345\220\214\346\257\224\347\231\276\345\210\206\346\225\260_2026-09-11.md" @@ -0,0 +1,80 @@ +# 鍔熻兘娴嬭瘯鎶ュ憡_姹囨�昏〃鎺掑悕椤靛埛鏂颁笌鍚屾瘮鐧惧垎鏁癬2026-09-11 + +## 涓�銆佸姛鑳借鏄� + +鐢ㄦ埛鍙嶉銆婇亾璺繍杈撻噺姹囨�昏〃銆嬩袱涓棶棰橈細**1. 鎵�鏈夋帓鍚嶈〃閲岄潰鐨勬暟鎹病鏈夋洿鏂帮紱2. 鍚屾瘮搴旇鏄櫨鍒嗘暟鑰屼笉鏄皬鏁�**銆傛湰杞畾浣嶅苟淇锛� + +### 1. 鎺掑悕椤垫暟鎹埛鏂帮紙闂 1锛� + +- 鐜拌薄锛氭眹鎬诲ぇ琛ㄦ瘝鐗� `2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` 閲岀殑 `璐ц繍閲忔帓鍚峘 / `璐ц繍鍛ㄨ浆閲忔帓鍚峘 / `涓彛寰勬帓鍚峘 涓夐〉鏄�**涓婁竴鎶ヨ〃鏈熺殑闈欐�佸��**锛堟爣棰樺啓銆�2026骞�1-7鏈� / 2026骞�7鏈堛�嶏紝鏁板�间篃鏄� 7 鏈堬級锛屽鍑� 8 鏈堟椂鏁撮〉涓嶉殢鏁版嵁鍙樺寲銆� +- 澶勭疆锛氬鍑洪摼璺柊澧� `refreshSummaryRankSheets`锛岀敤绋嬪簭鑷繁鐨勭嫭绔嬫帓鍚嶈〃锛坄鐢熸垚_璐ц繍閲忔帓鍚�.xlsx` / `鐢熸垚_鍛ㄨ浆閲忔帓鍚�.xlsx` / `鐢熸垚_涓彛寰勬帓鍚�.xlsx`锛屼笌鐢ㄦ埛鏃ュ父鏍稿鍙ｅ緞涓�鑷达級鍒锋柊杩欎笁椤碉細 + - 鏁板�兼牸鎼暟鍊硷紱婧愪晶鏄叕寮忕殑锛圧ANK/鍗犳瘮绛夛級鎸夌洰鏍囧潡鍋忕Щ鏁翠綋骞崇Щ鍚庡啓鎴愬叕寮忥紙鎵撳紑鏃舵寜姹囨�昏〃鑷韩鏁版嵁閲嶇畻锛夛紱鐩爣鏍兼湰韬凡鏄叕寮忕殑锛堟瘝鐗� SUM/RANK/鍗犳瘮锛変繚鐣欎笉鍔紱 + - 鍧楁爣棰橀殢鎶ヨ〃鏈熷悓姝ワ紙`2026骞�1-7鏈堚� 鈫� `2026骞�1-8鏈堚�銆乣2026骞�7鏈堚� 鈫� `2026骞�8鏈堚�锛夈�� + +### 2. 鍚屾瘮鍒楁樉绀烘垚灏忔暟锛堥棶棰� 2锛� + +- 鐜拌薄锛氭瘝鐗堟妸鏂版湀浠斤紙8 鏈堬級鐨勫悓姣斿垪鍋氭垚浜嗐�屾櫘閫氭暟鍊� `0.00`銆嶆牸寮忥紝鑰� 7 鏈堝強浠ュ墠鐨勫悓姣斿垪鏄� `0.00%`锛涘洖濉叕寮忓悗 8 鏈堝悓姣旀樉绀烘垚 `-0.0294` 杩欐牱鐨勫皬鏁般�� +- 澶勭疆锛歚SummaryWorkbookFiller.ensureMonthYoyFormulas` 鍘熸潵鍙湪鐩爣鏍间负绌烘椂濂楃敤涓婃湀鍚屾瘮鍒楁牱寮忥紝鏀逛负**鏃犳潯浠舵部鐢ㄤ笂鏈堝悓姣斿垪鏍峰紡**锛坄0.00%`锛夈�� + +### 鏀瑰姩鏂囦欢 + +- `traffic-audit-server/src/main/java/com/trafficaudit/reportexport/service/ReportExportService.java`锛氭柊澧� `refreshSummaryRankSheets` / `copyRankValues` / `rankCell` / `shiftFormula`锛屽湪 `ensureMonthFormulas` 涔嬪悗銆乣applySummaryReferenceLayout` 涔嬪墠璋冪敤銆� +- `traffic-audit-server/src/main/java/com/trafficaudit/reportexport/calc/SummaryWorkbookFiller.java`锛歚ensureMonthYoyFormulas` 鏍峰紡娌跨敤銆� + +## 浜屻�佹祴璇曠幆澧� + +- 鍚庣 `http://localhost:8090`锛坄start-dev.ps1` 鍚姩锛夛紝瀵煎嚭鎺ュ彛 `GET /api/report/export/summaryWorkbook?period=YYYY-MM`銆� +- 姣嶇増锛歚docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛涚増寮忓弬鐓э細`docs/鐢熸垚姹囨�诲ぇ琛�/鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx`銆� +- 鐙珛鎺掑悕琛ㄥ簳绋匡細`docs/璐ц繍/鐢熸垚_璐ц繍閲忔帓鍚�.xlsx`銆乣docs/璐ц繍/鐢熸垚_鍛ㄨ浆閲忔帓鍚�.xlsx`銆乣docs/鍏矾鏃呭/鐢熸垚_涓彛寰勬帓鍚�.xlsx`銆� +- 娴嬭瘯鏃堕棿锛�2026-09-11锛涙祴璇曚骇鐗╋細`_gen2_2026-08.xlsx`銆乣_gen2_2026-07.xlsx`銆乣_v2_freight_rank.xlsx`銆乣_v2_turnover_rank.xlsx`銆乣_v2_mid_rank.xlsx`銆� + +## 涓夈�佺敤渚嬭〃 + +### 3.1 姝ｅ悜鐢ㄤ緥 + +| 缂栧彿 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | +| TC-1 | 瀵煎嚭 `period=2026-08` | HTTP 200锛屾甯镐骇鍑烘枃浠� | 949,956 瀛楄妭锛�23.8 绉掕繑鍥� | 閫氳繃 | +| TC-2 | 鍚庣鍥炲～鏃ュ織 | 鏈夋帓鍚嶉〉鍒锋柊缁熻銆佹棤缂烘暟鎻愮ず | 鍐欏叆褰撴湀鍊兼牸鏁�=1659锛岃ˉ鍐欏綋鏈堝悓姣斿叕寮忔牸鏁�=600锛岃ˉ鍐欏綋鏈堝悎璁″叕寮忔牸鏁�=43锛�**鍒锋柊鎺掑悕椤垫暟鍊兼牸鏁�=711**锛屽榻愬垪瀹藉垪鏁�=422锛岀己鏁版彁绀�=[] | 閫氳繃 | +| TC-3 | 璐ц繍閲忔帓鍚嶅潡鏍囬 | 闅忔姤琛ㄦ湡鏀逛负 1-8 鏈�/8 鏈� | `A1=2026骞�1-8鏈堝叏鐪佸垎甯傚窞绱瀹屾垚鍏矾璐ц繍閲忔儏鍐礰锛沗A22=2026骞�8鏈堝叏鐪佸垎甯傚窞瀹屾垚鍏矾璐ц繍閲忔儏鍐礰 | 閫氳繃 | +| TC-4 | 璐ц繍鍛ㄨ浆閲忔帓鍚嶅潡鏍囬 | 鍚屼笂 | `A2=鈥�2026骞�1-8鏈堚�锛沗A24=鈥�2026骞�8鏈堚� | 閫氳繃 | +| TC-5 | 涓彛寰勬帓鍚嶅潡鏍囬 | 鍚屼笂 | `J1=2026骞�1-8鏈堝叏鐪佸垎甯傚窞绱瀹屾垚閬撹矾瀹㈣繍鐢熶骇鎯呭喌`锛沗J22=2026骞�8鏈堚� | 閫氳繃 | +| TC-6 | 鏍囬钀界洏鏂瑰紡锛堝師濮� XML 鏍￠獙锛� | `<is><t>` 涓庢樉绀轰竴鑷达紙涓嶈兘鍐嶅嚭鐜� `<v>` 鏂板�� + `<is>` 鏃у�硷級 | `xl/worksheets/sheet2.xml`锛歚<c r="A1" s="776" t="s"><v>0</v></c>`锛屽叡浜覆 0 = `2026骞�1-8鏈堚�锛堟棫鏂囦欢鏄� inlineStr锛宍<v>`=8鏈堛�乣<is><t>`=7鏈堬級 | 閫氳繃 | +| TC-7 | 璐ц繍閲忔帓鍚嶉�愭牸鍏ュ簱鎶芥煡锛堜笌鐙珛鎺掑悕琛ㄦ瘮瀵癸級 | 鍏ㄥ潡涓�鑷� | 绱鍧� + 褰撴湀鍧楀叡 **454 鏍奸�愪釜姣斿锛�0 澶勪笉涓�鑷�** | 閫氳繃 | +| TC-8 | 璐ц繍鍛ㄨ浆閲忔帓鍚嶅綋鏈堝潡鎶芥煡 | 涓庣嫭绔嬭〃涓�鑷� | 姝︽眽 B28=192320.5226锛堟簮 B27锛夈�丟28=504369.61288609065锛堟簮 G27锛夈�丒28=0.3334642531154999锛堟簮 E27锛夈�丣28=-0.021161120884320206锛堟簮 J27锛� | 閫氳繃 | +| TC-9 | 璐ц繍鍛ㄨ浆閲忔帓鍚嶆瘝鐗堝叕寮忎繚鐣� | 涓嶅啓姝诲�硷紝淇濈暀 SUM/RANK/鍗犳瘮 | 鍏ㄧ渷 B27=`=SUM(B28:B44)`锛涙姹� C28=`=RANK(B28,B$28:B$44)`銆丏28=`=B28/B$27` | 閫氳繃 | +| TC-10 | 涓彛寰勬帓鍚嶆暟鍊兼娊鏌� | 涓庣嫭绔嬭〃涓�鑷� | K4=2759.8855锛堟簮 B4锛夈�丱4=152330.9312锛堟簮 F4锛夈�並25=349.536锛堟簮 L4锛夈�丱25=18917.1637锛堟簮 P4锛� | 閫氳繃 | +| TC-11 | 涓彛寰勬帓鍚嶃�屽閫熸帓鍚嶃�嶅垪 | 涓嶅啀鏄潤鎬佹��硷紝涓斾笌椤靛唴鍚屾瘮鑷唇 | 鐢遍潤鎬佸�硷紙澶氳鍚屼负 1.0锛夋敼涓� `=RANK(M4,M$4:M$20)`銆乣=RANK(M25,M$25:M$41)` 绛夎嚜娲藉叕寮忥紱缂撳瓨鍊间笌姣嶇増鍘熷�间竴鑷达紙L25=5銆丯25=10銆丳25=2銆丷25=5锛� | 閫氳繃 | +| TC-12 | 8 鏈堝悓姣斿垪鏍煎紡锛堥棶棰� 2锛� | 鐧惧垎鏁� `0.00%` | 璐ц繍 R5=`=Q5/AJ5-1` / `0.00%`锛涚彮绾垮寘杞︺�佸煄甯傚杩愩�佸叕浜ゃ�佸嚭绉熴�佺綉绾﹁溅銆佽建閬撹疆娓°�佷腑鍙ｅ緞鏄庣粏 8 鏈堝悓姣斿垪锛圧 鍒楋級**鍏ㄩ儴 `0.00%`** | 閫氳繃 | +| TC-13 | 鎺掑悕椤靛悓姣斿垪鏍煎紡 | 鐧惧垎鏁� `0.00%` | 璐ц繍閲忔帓鍚� E4=-0.0763 / `0.00%`銆丏5=0.3207鈥� / `0.00%`锛涜揣杩愬懆杞噺鎺掑悕銆佷腑鍙ｅ緞鎺掑悕鍚屾瘮鍒楀悓涓� `0.00%` | 閫氳繃 | +| TC-14 | 鎵撳紑鍗抽噸绠� | 浠嶅甫鍏ㄩ噺閲嶇畻鏍囪 | `<calcPr 鈥� fullCalcOnLoad="true"/>` 淇濈暀 | 閫氳繃 | + +### 3.2 璐熷悜鐢ㄤ緥 + +| 缂栧彿 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | +| TC-N1 | 鍏ㄨ〃鎵弿銆岃〃澶村惈鍚屾瘮 + 鏁板��/鍏紡 + 鏍煎紡闈炵櫨鍒嗘暟銆嶇殑鏍� | 涓嶅簲鏈夋柊寮曞叆鐨勫皬鏁板悓姣� | 8 鏈堜欢鍛戒腑 3 鏍硷紝鍏ㄩ儴鍦ㄩ殣钘忛〉锛坄2025骞村煄甯傚杩愰噺!E13`銆乣涓彛寰勮绠楄繃绋�!G85/G86`锛夛紝姣嶇増鍚屼綅缃悓鏍峰姝� | 閫氳繃锛堥潪鏈疆寮曞叆锛� | +| TC-N2 | 鐙珛鎺掑悕琛ㄦ簮渚у悓姣斾负绌烘椂锛堝簱涓棤 2025 骞翠腑鍙ｅ緞鏁版嵁锛� | 涓嶅簲鎶� POI 瀵圭┖鍊肩殑姹傚�肩粨鏋滐紙鍏ㄤ负 1锛夋惉杩涙眹鎬昏〃 | 鏀逛负鍐欏叕寮忓悗锛岃鍒椾负 `=RANK(鈥�)` 鍏紡锛屾寜椤靛唴鍚屾瘮鍙栧�硷紝涓嶅啀鏄� 17 琛屽叏 1 | 閫氳繃 | +| TC-N3 | 璋冭瘯鏃ュ織娓呯悊 | 瀵煎嚭鏃ュ織涓嶅簲娈嬬暀 `RANKDBG` | `backend.log` 涓� `RANKDBG` 璁℃暟 = 0 | 閫氳繃 | + +### 3.3 鍘嗗彶鏈堝洖褰掞紙2026-07锛� + +| 缂栧彿 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | +| TC-R1 | 瀵煎嚭 `period=2026-07` | 姝ｅ父浜у嚭銆佸綋鏈堝悓姣斾粛鎸囧悜 2025 骞� 7 鏈� | 941,903 瀛楄妭锛涜揣杩� P5=`=O5/AF5-1` / `0.00%` | 閫氳繃 | +| TC-R2 | 涓庢敼鍔ㄥ墠 7 鏈堜骇鐗╋紙`_gen_2026-07.xlsx`锛夐�愭牸 diff | 宸紓浠呴檺琚埛鏂扮殑鎺掑悕椤� | 浠� `璐ц繍閲忔帓鍚峘 51 鏍笺�乣涓彛寰勬帓鍚峘 133 鏍兼湁宸紓锛堟帓鍚嶉〉鐢遍潤鎬佸�兼敼涓烘寜鏁版嵁鍒锋柊锛屽睘棰勬湡锛夛紱鍏朵綑 16 椤� 0 宸紓 | 閫氳繃 | +| TC-R3 | 7 鏈堟帓鍚嶉〉鏍囬 | 浠嶄负 1-7 鏈�/7 鏈堬紙鎸夋姤琛ㄦ湡锛� | `A1=2026骞�1-7鏈堚�銆乣A22=2026骞�7鏈堚�锛涗腑鍙ｅ緞 `J22=2026骞�7鏈堚� | 閫氳繃 | +| TC-R4 | 7 鏈堝悓姣旀牸寮� | 鏃犳柊澧炲皬鏁板悓姣� | 鍏ㄨ〃鍛戒腑 3 鏍硷紝鍧囦负闅愯棌椤垫瘝鐗堝師鏈夋牸 | 閫氳繃 | + +## 鍥涖�佸彂鐜扮殑闂涓庡缃� + +1. **鎺掑悕椤垫爣棰樻敼浜嗕絾 Excel 浠嶆樉绀烘棫鏈堜唤**锛氭瘝鐗堟爣棰樺崟鍏冩牸鏄� `inlineStr`锛孭OI 鍦� `t="inlineStr"` 鍗曞厓鏍间笂 `setCellValue(String)` 鍙啓 `<v>`銆佷笉鍔� `<is><t>`锛岃�� Excel/WPS 浼樺厛璇� `<is><t>`銆傚缃細鍐欏�煎墠鍏� `setBlank()` 娓呮帀鍘熷崟鍏冩牸鍐嶅啓锛堣惤鐩樹负鍏变韩涓诧紝`<is>` 涓嶅啀娈嬬暀鏃ф枃妗堬級銆� +2. **POI 姹傚�煎彛寰勫亸宸�**锛氭簮鐙珛鎺掑悕琛ㄩ噷鎵嬪伐鐣欑┖鐨勫悓姣斾細璁� `RANK` 鍑芥暟姹傚�间竴寰嬭繑鍥� 1锛岀洿鎺ユ惉鍊间細鎶� 17 琛屻�屽閫熸帓鍚嶃�嶅啓鎴愬叏 1銆傚缃細婧愪晶鍏紡涓嶅啀鎼眰鍊肩粨鏋滐紝鑰屾槸鎸夌洰鏍囧潡鍋忕Щ骞崇Щ鎴愬叕寮忓啓鍏ワ紝鍐嶇敤姹囨�昏〃鑷韩鏁版嵁姹傚�肩紦瀛樸�� +3. **涓彛寰勬帓鍚嶅悓姣斿垪浠嶄负姣嶇増鏃у��**锛氬簱涓彧鏈� 2026-01~08 鐨勫杩愭暟鎹紙`h2031_enterprise_monthly` / `city_bus_monthly`锛夛紝娌℃湁 2025 瀹氱鏁版嵁锛岀嫭绔嬫帓鍚嶈〃绠椾笉鍑轰腑鍙ｅ緞鍚屾瘮 鈫� 璇ュ垪鎸夎璁′繚鐣欐瘝鐗堝�硷紱绛� 2025 鏁版嵁鍏ュ簱鍚庨殢瀵煎嚭鑷姩鍒锋柊銆� +4. **闈欐�侀〉寰呭姙**锛歚鍩庡競姹囨�籤銆乣鍩庡競鍒嗗競宸瀈銆乣涓彛寰勫垎鏋恅銆乣閬撹矾杩愯緭鍛ㄨ浆閲廯 鍥涢〉鍦ㄦ瘝鐗堥噷鏄暣椤甸潤鎬侊紙鏈疆瀵煎嚭涓庢瘝鐗堥�愭牸 0 宸紓锛夛紝椤垫爣棰樹粛鍐欍��1-7 鏈� / 7 鏈堛�嶃�傚洜鏁撮〉鏁版嵁鏈暟鎹┍鍔紝鏈疆**鏈�**鍙敼鏍囬锛堥伩鍏嶆爣棰� 8 鏈堛�佹暟鎹� 7 鏈堬級锛岀暀寰呭悗缁仛鎴愭暟鎹┍鍔ㄦ椂涓�骞跺鐞嗐�� + +## 浜斻�佺粨璁� + +- 鐢ㄦ埛鍙嶉鐨勪袱涓棶棰樺潎宸蹭慨澶嶅苟楠岃瘉锛氫笁寮犳帓鍚嶉〉鐨勬爣棰樹笌鏁板�奸殢鎶ヨ〃鏈熷埛鏂帮紙璐ц繍閲忔帓鍚� 454 鏍奸�愭牸姣斿 0 宸紓锛夛紝8 鏈堝悓姣斿垪缁熶竴涓虹櫨鍒嗘暟鏄剧ず銆� +- 2026-08 / 2026-07 鍙屾湡瀵煎嚭閫氳繃锛�7 鏈堝巻鍙叉湀鍥炲綊宸紓浠呴檺琚埛鏂扮殑鎺掑悕椤碉紝鏃犲壇浣滅敤銆� +- 閬楃暀锛氫腑鍙ｅ緞鍚屾瘮寰� 2025 骞存暟鎹叆搴擄紱鍥涘紶闈欐�佹垚鍝侀〉寰呮暟鎹┍鍔ㄦ敼閫犮�� -- Gitblit v1.9.1