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 | 69 ++++++++++++++++++++++++++++++++++ 1 files changed, 69 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_\345\237\216\345\270\202\345\256\242\350\277\220\346\234\210\345\272\246\344\270\216\347\264\257\350\256\241\345\220\214\346\257\224_2026-09-20.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_\345\237\216\345\270\202\345\256\242\350\277\220\346\234\210\345\272\246\344\270\216\347\264\257\350\256\241\345\220\214\346\257\224_2026-09-20.md" new file mode 100644 index 0000000..c52a3b4 --- /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_\345\237\216\345\270\202\345\256\242\350\277\220\346\234\210\345\272\246\344\270\216\347\264\257\350\256\241\345\220\214\346\257\224_2026-09-20.md" @@ -0,0 +1,69 @@ +# 鍔熻兘娴嬭瘯鎶ュ憡_鍩庡競瀹㈣繍鏈堝害涓庣疮璁″悓姣擾2026-09-20 + +## 涓�銆佸姛鑳借鏄� + +鐢ㄦ埛涓婃姤锛氭眹鎬诲ぇ琛ㄣ�婂煄甯傚杩愩�嬮〉 8 鏈堝悓姣斻�佺疮璁″悓姣旀槑鏄句笉瀵癸紙鍏ㄧ渷瀹㈣繍閲� 8 鏈堝悓姣� 鈭�86.5%銆佺疮璁″悓姣� 鈭�43.5%锛夛紝 +涓斻��2025骞�1-7鏈堢疮璁°�嶈繖涓�杈呭姪鍒楁槑鏄庡凡鍦ㄦ瘝鐗堝垹闄ゅ嵈浠嶅嚭鐜板湪鐢熸垚琛ㄩ噷銆� + +鏈淇涓変欢浜嬶細 + +1. **姣嶇増缁撴瀯褰掍竴**锛氭妸銆�2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬪煄甯傚杩愰〉澶氬嚭鐨� AJ 鍒楋紙`2025骞�1-7鏈堢疮璁 杈呭姪鍒楋級鐪熸鍒犻櫎锛� + 浣� 2025 鍚勬湀鍒楁仮澶嶇瓑璺濓紙2025骞�8鏈堝洖鍒� AJ锛夛紝涓庣増寮忓弬鐓т欢銆婄敓鎴恄閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx銆嬩竴鑷淬�� +2. **绋嬪簭渚ф寜琛ㄥご瀹氫綅鏈堜唤鍒�**锛歚SummaryWorkbookFiller.ensureMonthYoyFormulas()` 涓嶅啀鏃犺剳銆屽叕寮忔暣浣撳彸绉� 2 鍒椼�嶏紝 + 鏀逛负鎸夎〃澶� (骞�,鏈�) 鎶婂叕寮忛噷鐨勬湀浠藉垪寮曠敤椤哄欢涓�涓湀銆佸叾浣欏紩鐢ㄥ彸绉� 2 鍒楋紱骞舵柊澧� + `repairCumulativeYoyFormulas()` 鍏滃簳閲嶅啓鍧忔帀鐨勭疮璁″悓姣斿垎姣嶏紙鍒嗘瘝=鍘诲勾 1..褰撴湀鍚勬湀鍊煎垪涔嬪拰锛夈�� +3. **鎶ヨ〃鐢熸垚椤甸瑙堣ˉ榻愬叏鎸囨爣鍚屾瘮**锛歚ReportExport.vue` 鐨勯瑙堣瀹氫箟鍙槧灏勪簡鍛ㄨ浆閲忎袱椤瑰悓姣旓紝琛ヤ笂璐ц繍閲�/鍩庡競瀹㈣繍/涓彛寰勫叡 8 椤癸紝 + 骞朵慨姝ｃ�屽綋鏈堣揣鐗╁懆杞噺(涓囧惃)銆嶅崟浣嶇瑪璇�� + +## 浜屻�佹祴璇曠幆澧� + +- 鍚庣 Spring Boot 8090锛坄Started TrafficAuditApplication`锛夈�佸墠绔� Vue 8080锛坄Compiled successfully`锛� +- 鏁版嵁搴� MySQL localhost:3308/traffic_audit +- 鎶ヨ〃鏈燂細2026-08锛堟湀鎶ワ級 +- 姣嶇増锛歚docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛圗xcel 16.0 COM 鍒犲垪鍚庝繚瀛橈級 +- 姣嶇増澶囦唤锛歚docs/鐢熸垚姹囨�诲ぇ琛�/_bak_202608姣嶇増鍒犻櫎AJ鍒楀墠_20260920.xlsx` +- 瀵规瘮鍩哄噯浠讹細`_before_citypaxfix_2026-08.xlsx`锛堟敼鍔ㄥ墠 11:37 鐗堬級銆乣_after_ajdel_2026-08.xlsx`锛堟湰娆′慨澶嶅悗锛� + +## 涓夈�佺敤渚嬭〃 + +| 缂栧彿 | 鐢ㄤ緥 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | --- | +| T01 | 8 鏈堝悓姣斿垎瀛愬垎姣� | 瀵煎嚭 2026-08 姹囨�诲ぇ琛紝璇� 鍩庡競瀹㈣繍!R4 鍏紡 | `=Q4/AJ4-1`锛圦=2026骞�8鏈堛�丄J=2025骞�8鏈堬級 | `=Q4/AJ4-1` | 閫氳繃 | +| T02 | 鍏ㄧ渷瀹㈣繍閲� 8 鏈堝悓姣旂紦瀛樺�� | 鍚屼笂锛岃缂撳瓨 | 绾� +4.44%锛�32215.74 / 30846.31 鈭� 1锛� | +4.4395% | 閫氳繃 | +| T03 | 绱鍚屾瘮鍒嗘瘝 | 璇� 鍩庡競瀹㈣繍!T4 鍏紡 | `=S4/(V4+X4+Z4+AB4+AD4+AF4+AH4+AJ4)-1` | 鍚屽乏锛屼笖涓嶅啀鏄� `#REF!` | 閫氳繃 | +| T04 | 鍏ㄧ渷瀹㈣繍閲忕疮璁″悓姣旂紦瀛樺�� | 璇荤紦瀛� | 绾� +0.117%锛�269628.07 / 269312.48 鈭� 1锛� | +0.1172% | 閫氳繃 | +| T05 | 杈呭姪鍒楁槸鍚﹀交搴曟秷澶� | 鍏ㄨ〃鎼滅储 `2025骞�1-7鏈堢疮璁 | 0 澶� | 0 澶勶紱鍩庡競瀹㈣繍缁村害鐢� A1:BV40 鏀朵负 A1:BU40 | 閫氳繃 | +| T06 | 姣嶇増鍒犲垪鍚庡紩鐢ㄨ嚜鍔ㄨ皟鏁� | 璇绘瘝鐗� 鍩庡競瀹㈣繍!W4锛�2025骞�1鏈堝悓姣旓級 | `=V4/AW4-1`锛�2024 鍖哄潡闅忓垹鍒楀乏绉讳竴鍒楋級 | `=V4/AW4-1` | 閫氳繃 | +| T07 | 姣嶇増娈嬬暀閿欒鍏紡 | 鎵弿姣嶇増 鍩庡競瀹㈣繍椤靛惈 `#REF!` 鐨勫叕寮� | 0 澶勶紙鍒犲垪浜х敓鐨� 36 澶� `#REF!` 宸茶繕鍘熶负 AJ锛� | 0 澶� | 閫氳繃 | +| T08 | 鍏ㄨ〃寰幆寮曠敤 | 鎵弿鐢熸垚琛ㄧ紦瀛樺�� `~CIRCULAR~REF~` | 0 澶� | 0 澶勶紙淇鍓� 360 澶勶級 | 閫氳繃 | +| T09 | 鍏跺畠鍙拌处椤� 8 鏈堝悓姣� | 璇� 璐ц繍/缃戠害杞�/涓彛寰勬槑缁� R5 | `=Q5/AJ5-1` 涓旂紦瀛樹负鐧惧垎姣� | 涓夐〉鍧囦负 `=Q5/AJ5-1`锛涜揣杩� +5.16%銆佺綉绾﹁溅 +63.72%銆佷腑鍙ｅ緞鏄庣粏 鈭�0.67% | 閫氳繃 | +| T10 | 闈炲煄甯傚杩愰〉鍥炲綊 | 閫愭牸瀵规瘮鏀瑰姩鍓嶅悗闄ゅ煄甯傚杩愬鐨� 18 涓〉绛� | 闄� T09 鐨勪慨澶嶅涓嶅簲鏈夊樊寮� | 浠� 璐ц繍/缃戠害杞�/涓彛寰勬槑缁� 鐨� R 鍒楃敱寰幆寮曠敤鍙樹负姝ｇ‘鍏紡锛涘叾瀹冮〉涓�鑷� | 閫氳繃 | +| T11 | 鍩烘暟缂烘牸鐨勮竟鐣� | 涓彛寰勬槑缁� R13/R14/R107/R108锛堝煄闄呭煄涔″贰娓稿嚭绉�/缃戠害杞︼紝2025骞�8鏈堝熀鏁�=0锛� | 鏄剧ず `#DIV/0!`锛堜笉鍙瘮锛� | `#DIV/0!`锛堜慨澶嶅墠鏄棤鎰忎箟鐨勫惊鐜紩鐢級 | 閫氳繃锛堥鏈燂級 | +| T12 | 棰勮鎺ュ彛鍚屾瘮鎸囨爣 | `GET /api/report/preview?period=2026-08&mode=month&types=summaryWorkbook` | 24 椤规寚鏍囷紝鍚� 8 椤瑰悓姣� | 24 椤癸紝鍏朵腑鍚屾瘮 8 椤癸紙璐ц繍閲� +5.2/+1.9銆佸懆杞噺 +4.8/+0.0銆佸煄甯傚杩愰噺 鈭�1.5/鈭�3.1銆佸煄甯傚杩愬懆杞噺 鈭�0.6/鈭�3.5銆佷腑鍙ｅ緞瀹㈣繍閲� 鈭�7.1/鈭�7.6銆佷腑鍙ｅ緞鍛ㄨ浆閲� +0.9/鈭�1.1锛夛紝鑰楁椂 1.03 绉� | 閫氳繃 | +| T13 | 鍓嶇棰勮娓叉煋 | 鎶ヨ〃鐢熸垚椤甸瑙堝脊绐� | 8 琛岄兘鏈夊悓姣斿垪鏁板�硷紝鍗曚綅姝ｇ‘ | 鏄犲皠宸茶ˉ榻愶紙`ReportExport.vue`锛夛紝鍓嶇 `Compiled successfully` | 閫氳繃 | +| T14 | 璐熷悜锛氭瘝鐗堢己鍒�/鍒楀簭寮傚父 | 浠ｇ爜鍏滃簳锛坄usableMonthCols` 鍒ゅ畾琛ㄥご涓嶅叏鏃堕��鍥炴暣浣撳彸绉� 2 鍒楋級 | 涓嶅簲鎶涘紓甯搞�佷笉搴旀敼鍧忓叾瀹冮〉 | 鍏跺畠 8 涓彴璐﹂〉鍏紡涓庢棫鐗堜竴鑷� | 閫氳繃 | +| T15 | 瀵煎嚭鑰楁椂 | 涓嬭浇 2026-08 姹囨�诲ぇ琛� | 鍙帴鍙楋紙褰撳墠 10~20 绉掔骇锛� | 14 绉掞紙姣嶇増璇诲彇+鍥炲～ 6.5s銆佸叕寮忛噸绠� 4.1s銆佸啓鐩樹笌浼犺緭绾� 3.4s锛� | 閫氳繃锛堣閬楃暀椤癸級 | + +## 鍥涖�佸彂鐜扮殑闂涓庡缃� + +1. **姣嶇増涓ゆ湰娣锋穯**锛氱敤鎴蜂箣鍓嶅湪銆�2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬮噷鍒犱簡 AJ 鍒楋紝鑰� 8 鏈堝鍑虹敤鐨勬槸 + 銆�2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬶紝鍚庤�呬粛甯﹁杈呭姪鍒椼�� + 鈫� 宸茬敤 Excel 16.0 COM 鍦� 8 鏈堟瘝鐗堟暣鍒楀垹闄� AJ锛堝紩鐢ㄧ敱 Excel 鑷姩璋冩暣锛夛紝骞舵妸鍒犲垪瀵艰嚧鐨� 36 澶� `#REF!` 绱鍚屾瘮鍏紡杩樺師涓� `AJ`銆� +2. **鍒楀彿鍩哄噯閿欎綅锛堟湰娆� 8 鏈堝悓姣旂畻閿欑殑鐩存帴鍘熷洜锛�**锛氭柊鍐欑殑 `colIndexOf()` 杩斿洖 1 鍩哄垪鍙凤紝鑰� POI 鐨� + `Cell.getColumnIndex()` 鏄� 0 鍩猴紝瀵艰嚧銆屾湀浠藉垪鏌ヨ〃銆嶅叏閮ㄨ惤绌恒�侀��鍖栨垚 `鍒楀彿+2`锛屼簬鏄� + `=O5/AH5-1` 琚畻鎴� `=R5/AK5-1`锛堣嚜寮曠敤鈫掑惊鐜紩鐢級銆傗啋 宸叉敼涓鸿繑鍥� 0 鍩哄垪鍙凤紝 + 鍚屾椂淇帀 璐ц繍/缃戠害杞�/涓彛寰勬槑缁� 涓夐〉鐨� 360 鏍煎惊鐜紩鐢ㄣ�� +3. **POI `setCellFormula` 涓嶆帴鍙楀甫 `=` 鍓嶇紑鐨勫叕寮忎覆**锛氭姏 `FormulaParseException`锛岃�岃寮傚父鍘熷厛琚� + `catch (Exception ignore)` 闈欓粯鍚炴帀锛屽鑷淬�岀疮璁″悓姣斿垎姣嶄慨姝ｆ牸鏁�=0銆嶈�岀湅涓嶅嚭鍘熷洜銆� + 鈫� 鍘绘帀鍏紡涓插墠缂� `=`锛屽苟鎶� catch 鏀逛负鍐� WARN 鏃ュ織锛堜繚鐣欎笉闃诲瀵煎嚭鐨勭瓥鐣ワ級銆� +4. **琛ㄥご璇嗗埆婕忓垽**锛氭瘝鐗堝煄甯傚杩愰〉 3~8 鏈堣〃澶存槸 `46235` 杩欑被瑁告棩鏈熷簭鍒椾笖鍗曞厓鏍兼牸寮忎负 General锛� + 鍘熸寜 `isCellDateFormatted` 鍒ゅ畾浼氭紡鎺夈�傗啋 鏀逛负銆屾暟鍊煎湪 1..200000 涓旀崲绠楀悗鏄綋鏈� 1 鍙枫�嶅垽瀹氥�� +5. **棰勮鍚屾瘮鍒楃己澶憋紙鍓嶇瀹氫箟闂锛岄潪鏁版嵁闂锛�**锛氬悗绔竴鐩磋繑鍥� 8 椤瑰悓姣旓紝 + 浣� `ReportExport.vue` 鐨勯瑙堣瀹氫箟鍙粰涓ら」鍛ㄨ浆閲忛厤浜嗗悓姣斿垪銆傗啋 宸茶ˉ榻� 8 椤瑰苟鏀规帀 `涓囧惃` 绗旇銆� + +## 浜斻�佺粨璁� + +15 鏉＄敤渚嬪叏閮ㄩ�氳繃锛堝叾涓� T11 涓洪鏈熷唴鐨� `#DIV/0!`銆乀15 涓烘�ц兘鐜扮姸璇存槑锛夈�� +鍩庡競瀹㈣繍 8 鏈堝悓姣斾笌绱鍚屾瘮宸叉仮澶嶆纭彛寰勶紝杈呭姪鍒楀湪姣嶇増涓庣敓鎴愯〃涓潎宸叉秷澶憋紝 +鍚屾椂淇浜嗗彟涓夊紶鍙拌处椤甸暱鏈熷瓨鍦ㄧ殑寰幆寮曠敤閿欒锛屾姤琛ㄧ敓鎴愰〉棰勮鍙樉绀哄叏閮� 8 椤瑰悓姣斻�� +閬楃暀锛氬鍑轰负鍚屾璇锋眰銆佸綋鍓嶇害 14 绉掞紙璇﹁宸ヤ綔鏃ョ粨寰呭姙锛夈�� -- Gitblit v1.9.1