From 8b739ce9e80fce73da0f36408aaeec85318b806b Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期二, 22 九月 2026 17:31:09 +0800 Subject: [PATCH] docs(交接): 统一 09-22 关机快照（合并同事版本，修正运行状态为实测：8090/8080 在运行） --- docs/功能测试报告/功能测试报告_数据查看按市州汇总与导出_2026-09-22.md | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 60 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\225\260\346\215\256\346\237\245\347\234\213\346\214\211\345\270\202\345\267\236\346\261\207\346\200\273\344\270\216\345\257\274\345\207\272_2026-09-22.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\225\260\346\215\256\346\237\245\347\234\213\346\214\211\345\270\202\345\267\236\346\261\207\346\200\273\344\270\216\345\257\274\345\207\272_2026-09-22.md" new file mode 100644 index 0000000..50e16ba --- /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\225\260\346\215\256\346\237\245\347\234\213\346\214\211\345\270\202\345\267\236\346\261\207\346\200\273\344\270\216\345\257\274\345\207\272_2026-09-22.md" @@ -0,0 +1,60 @@ +# 鍔熻兘娴嬭瘯鎶ュ憡锛氭暟鎹煡鐪嬨�屾寜甯傚窞姹囨�� + 瀵煎嚭 Excel銆嶏紙2026-09-22锛� + +> 鏃ユ湡锛�2026-09-22銆�妯″潡锛氭暟鎹煡鐪嬶紙鍚庣 CityRollupService/DataViewController + 鍓嶇 DataView.vue锛夈��娴嬭瘯浜猴細Codex +> 鍙ｅ緞渚濇嵁锛�2026-09-22 鐢ㄦ埛纭鈥斺�旇捣姝㈡湀浠绘剰閫夈�佺疮璁″悓姣斿甫涓婂勾鍚屾湡銆佹帓鍚嶅瓧娈靛彲閫夛紙鐣欑┖/鎸夌疮璁″�奸噸鎺掞級銆佷笉鏀炬椂鐐瑰垪銆� + +## 涓�銆佸姛鑳借鏄� + +1. **鍏ュ彛**锛氭暟鎹煡鐪嬪伐鍏锋爮鍔犮�岃鍥撅細鏄庣粏 / 鎸夊競宸炴眹鎬汇�嶅垏鎹紙浠呭鏈夊競宸炵淮搴︾殑绫诲瀷鍑虹幇锛夈�� +2. **姹囨�绘潯浠�**锛氳捣姝㈡湀锛堜换鎰忓尯闂达紝骞村垵鑷� N 鏈堝嵆 01~N锛夈�佹帓鍚嶅彛寰勶紙鐣欑┖ / 鎸夌疮璁″�奸噸鎺掞級銆佹眹鎬汇�佸鍑� Excel銆� +3. **缁撴灉**锛氥�屽叏鐪佸悎璁°�嶈鏀惧湪**鏈�鍓嶉潰**锛�2026-09-22 鐢ㄦ埛瑕佹眰锛屼綅浜庢姹夊競涔嬩笂锛夛紝鍏跺悗涓� 17 涓競宸烇紙RegionUtil 瑙勮寖鍚嶄笌椤哄簭锛夛紱瀵煎嚭 Excel 涓悎璁¤鍔犵矖銆� +4. **鍙ｅ緞瑙勫垯**锛� + - 娴侀噺绫伙紙瀹㈣繍閲�/鍛ㄨ浆閲�/璐ц繍閲�/璁㈠崟鏁帮級鈫� 璺ㄦ湡姹傚拰锛� + - **鏃剁偣绫伙紙杞﹁締鏁般�佷紒涓氭暟銆佺珯鐐规暟锛変笉鍙備笌姹囨�伙紝涓嶅嚭鐜板湪缁撴灉涓�**锛� + - 姣旂巼绫绘寜绱鍙ｅ緞閲嶇畻锛氱疮璁″悓姣� = 鏈湡绱 梅 涓婂勾鍚屾湡绱 鈭� 1锛涘钩鍧囪繍璺� = 绱鍛ㄨ浆閲� 梅 绱瀹㈣繍閲忥紱 + - 鎺掑悕榛樿鐣欑┖锛涢�夈�屾寜绱鍊奸噸鎺掋�嶆椂鎸夌疮璁″�奸檷搴忕粰鍚嶆锛屽叏鐪佸悎璁¤涓嶆帓鍚嶏紱 + - 鍚堣琛岀敱 17 甯傚窞鐩稿姞锛�"婀栧寳鐪�"绛夊悎璁¤涓嶈鍏ワ紝閬垮厤閲嶅锛夈�� +5. **鎺ュ彛**锛歚GET /api/data/rollupTypes`锛堟敮鎸佹眹鎬荤殑绫诲瀷锛夈�乣GET /api/data/summary`銆乣GET /api/data/export`锛坸lsx锛屾暟鍊煎叏绮惧害銆佹樉绀� 2 浣嶅皬鏁� / 鐧惧垎姣旓級銆� +6. **鏀寔绫诲瀷锛�7 绫伙級**锛歚cityBus`銆乣cityTaxi`銆乣h2032`銆乣h2031`銆乣passengerIndividual`銆乣wycOrder`锛堟媶鍒嗗彛寰勶級銆乣freightTurnover`銆� + +## 浜屻�佹祴璇曠幆澧� + +鍚庣 `mvn spring-boot:run`锛�8090锛宍Started TrafficAuditApplication`锛夛紱鍓嶇 8080锛汳ySQL `localhost:3308/traffic_audit`锛涜处鍙� admin/123456锛涙祻瑙堝櫒锛欳odex 鍐呯疆娴忚鍣ㄧ湡鏈恒�� + +## 涓夈�佺敤渚嬭〃 + +### 3.1 鎺ュ彛鐢ㄤ緥 + +| 缂栧彿 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | +| TC-1 | `rollupTypes` | 杩斿洖 7 涓被鍨� | cityBus/cityTaxi/h2032/h2031/passengerIndividual/wycOrder/freightTurnover | 閫氳繃 | +| TC-2 | 鍏氦 2026-01~08 | 涓庢墜宸ユ牳绠椾竴鑷� | 鍏ㄧ渷鍚堣瀹㈣繍閲� 110776.34 涓囦汉娆°�佸懆杞噺 738254.64 涓囦汉鍏噷銆佸钩鍧囪繍璺� 6.66 鍏噷銆佺疮璁″悓姣� 鈭�3.07%锛涙姹夊杩愰噺 36935.38锛堜笌 SQL 閫愭湀鐩稿姞涓�鑷达級 | 閫氳繃 | +| TC-3 | 鍏氦 2026-03~06 | 鍖洪棿绱 | 鍏ㄧ渷鍚堣 59060.71 涓囦汉娆★紙= 3~6 鏈堥�愭湀鐩稿姞锛� | 閫氳繃 | +| TC-4 | 璐ц繍浼佷笟 h2032 2026-01~08 | 涓� SQL 涓�鑷� | 鍏ㄧ渷鍚堣璐ц繍閲� 313,998,248 鍚ㄣ�佸懆杞噺 49,271,617,743 鍚ㄥ叕閲屻�佸钩鍧囪繍璺� 156.92 鍏噷銆佸悓姣� 鈭�17.37% | 閫氳繃 | +| TC-5 | 璐ц繍閲忓懆杞噺 2026-01~08 | 17 甯傚窞涔嬪拰锛堟帓闄�"婀栧寳鐪�"琛岋級 | 130,311.89 涓囧惃锛屼笌 SQL 鐩存煡 17 甯傚窞涔嬪拰瀹屽叏涓�鑷达紙淇鍓嶈鎶�"婀栧寳鐪�"琛屼笌鍖洪棿閲嶅鍙犲姞锛屾浘寰楀埌 1,149,579锛� | 閫氳繃 | +| TC-6 | 鍚屼笂 `to=2026-09`锛堣鏈堟棤鏁版嵁锛� | 鑷姩鍥為��鍒版渶鏂版湁鏁版湀浠� | 缁撴灉涓� 01~08 涓�鑷达紱鏈熼棿鏍囩浠嶆樉绀鸿姹傚尯闂� | 閫氳繃 | +| TC-7 | 鎺掑悕 `rankMode=blank` | 鎺掑悕鍒椾负绌� | 绌猴紙鏄剧ず `-`锛� | 閫氳繃 | +| TC-8 | 鎺掑悕 `rankMode=recompute` | 鎸夌疮璁″�奸檷搴� | 璐ц繍閲忥細姝︽眽 1銆佸疁鏄� 3銆侀粍鐭� 9銆佸崄鍫� 12锛涘叏鐪佸悎璁¤鐣欑┖ | 閫氳繃 | +| TC-9 | 缃戠害杞� 2026-01~08 | 鎷嗗垎鍙ｅ緞鍚堣 | 鍏ㄧ渷鍚堣璁㈠崟 208,229,132 鍗曘�佸杩愰噺 33864.94 涓囦汉娆� | 閫氳繃 | +| TC-10 | `export`锛堝叕浜� 2026-01~08锛� | 鐢熸垚 xlsx | 5,790 瀛楄妭锛屽彲姝ｅ父鎵撳紑銆佸惈琛ㄥご涓庡悎璁¤锛涘悎璁¤鍔犵矖銆佹暟鍊兼牸寮� `0.00`銆佸悓姣旀牸寮� `0.00%` | 閫氳繃 | +| TC-10b | 鍚堣琛屼綅缃� | 鍦ㄦ姹夊競涔嬩笂 | 绗� 1 琛�=鍏ㄧ渷鍚堣锛堝杩愰噺 110776.34锛夛紝绗� 2 琛�=姝︽眽甯傦紙鎺掑悕 1锛夛紱鍚堣琛屾帓鍚嶇暀绌� | 閫氳繃 | + +### 3.2 鐪熸満鐢ㄤ緥 + +| 缂栧彿 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | +| TC-11 | 鏁版嵁鏌ョ湅閫�"閬撹矾璐х墿杩愯緭鏈堝害鐢熶骇鎯呭喌" | 鍑虹幇銆岃鍥俱�嶅垏鎹� | 宸ュ叿鏍忥細鎶ヨ〃鏈� / 鏁版嵁绫诲瀷 / 瑙嗗浘 | 閫氳繃 | +| TC-12 | 鍒囧埌"鎸夊競宸炴眹鎬�" | 鍑虹幇璧锋鏈堛�佹帓鍚嶃�佹眹鎬汇�佸鍑� | 宸ュ叿鏍忥細鏁版嵁绫诲瀷 / 瑙嗗浘 / 璧锋鏈� / 鎺掑悕锛涙寜閽細姹囨�汇�佸鍑� Excel | 閫氳繃 | +| TC-13 | 鎵ц姹囨�� | 18 琛屻�佸競宸炲喕缁撱�佸彛寰勬彁绀� | 18 琛岋紱鍐荤粨鍒�=甯傚窞锛涙彁绀�"鍏� 18 鏉¤褰� | 閬撹矾璐х墿杩愯緭浼佷笟锛堟寜甯傚窞姹囨�伙級 2026-01 ~ 2026-09 绱锛涘悓姣斿熀鏁� 2025-01 ~ 2025-09锛涙帓鍚嶅彛寰勶細鐣欑┖"锛涘叏鐪佸悎璁� 313,998,248 鍚� / 49,271,617,743 鍚ㄥ叕閲� | 閫氳繃 | +| TC-14 | 鏁板�兼樉绀� | 鍗冨垎浣� + 2 浣嶅皬鏁� + 鍚屾瘮鐧惧垎姣� | 100,729,811 / 16,328,908,098 / 162.11 / 鈭�24.39% | 閫氳繃 | + +## 鍥涖�佸彂鐜扮殑闂涓庡缃� + +1. **璐ц繍閲忓懆杞噺琛ㄥ彛寰勫潙**锛氳琛ㄦ瘡琛屾槸"骞村垵鑷冲綋鏈�"鐨勮鍐呯疮璁★紙琛屽唴鍚悇鏈堝垪锛夛紝璺ㄦ湡鍐嶅彔鍔犱細閲嶅璁＄畻锛涗笖琛ㄥ唴"婀栧寳鐪�"琛岀瓑浜� 17 甯傚窞涔嬪拰銆傚凡鏀逛负鍙彇鍖洪棿鍐呮渶鏂颁竴鏈熼偅涓�琛屻�佸鍖洪棿鏈堜唤姹傚拰锛屽苟鏄惧紡鎺掗櫎闈炲競宸炶 鈫� 鐢� 1,149,579 淇涓� 130,311.89 涓囧惃锛堜笌鐩存煡涓�鑷达級銆� +2. 缁撴潫鏈堟棤鏁版嵁锛堝 2026-09锛夋椂鑷姩鍥為��鍒版渶鏂版湁鏁版湀浠斤紝閬垮厤鍑虹幇鍏� 0 琛屻�� +3. 姹囨�绘ā寮忎笅"鎶ヨ〃鏈�/鍏抽敭瀛�"杈撳叆妗嗛殣钘忥紙鐢辫捣姝㈡湀鎵挎媴鏈熼棿鏉′欢锛夛紝閬垮厤涓ゅ鏈熼棿鏉′欢骞跺瓨銆� +4. 鎺掑悕鍙ｅ緞榛樿"鐣欑┖"锛涘紑鍚噸鎺掑悗鎸夌疮璁″�奸檷搴忥紝鍏ㄧ渷鍚堣琛屼笉鍙備笌鎺掑悕銆� + +## 浜斻�佺粨璁� + +銆屾寜甯傚窞姹囨�� + 瀵煎嚭 Excel銆嶆寜鐢ㄦ埛纭鐨勫彛寰勫畬鎴愬苟閫氳繃 10 鏉℃帴鍙ｇ敤渚� + 4 鏉＄湡鏈虹敤渚嬶紱涓庢墜宸�/SQL 鏍哥畻閫愰」涓�鑷淬�傛椂鐐瑰垪涓嶅弬涓庢眹鎬汇�佹瘮鐜囨寜绱閲嶇畻銆佹帓鍚嶅彲閫夛紝瀵煎嚭淇濈暀鍏ㄧ簿搴︺�� -- Gitblit v1.9.1