From 15c8035c5b9d490fad685f0665fbfaeec3220e5d Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期二, 22 九月 2026 10:49:13 +0800 Subject: [PATCH] docs: 数据查看展示优化与网约车竖排功能测试报告 + 日结补充 --- docs/交接文档_2026-09-21.md | 18 ++++++++++++------ 1 files changed, 12 insertions(+), 6 deletions(-) diff --git "a/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-21.md" "b/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-21.md" index 9dcd74f..f04d309 100644 --- "a/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-21.md" +++ "b/docs/\344\272\244\346\216\245\346\226\207\346\241\243_2026-09-21.md" @@ -11,8 +11,10 @@ ## 0. 鍏堣杩欎竴椤碉紙鎺ユ墜鐨勭 1 灏忔椂锛� 1. **鍏堟妸绯荤粺璺戣捣鏉�**锛屽啀璋堟敼浠ｇ爜銆傝 搂7.1锛堜竴閿剼鏈紝蹇呴』鍦ㄦ矙绠卞鎵ц锛夈�� -2. **褰撳墠鏈�绱ф�ョ殑 4 浠朵簨**锛堣瑙� 搂4 P0锛夛細鈶� 8 鏈堝崄鍫扮墿娴佹簮鏂囦欢閲岀殑銆岄潪鍗佸牥娈点�嶄細鍙嶅鎶� 31 涓」鐩甫鍥炲簱锛涒憽 銆婁嚎鍏冩姇璧勯」鐩�嬫湀浠藉垪姣忔湀瑕嗙洊涓婃湀锛� - 鈶� 瀵煎嚭鍓嶃�屽熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉銆嶅彧鍋氫簡涓�鍗婏紱鈶� 缂� 2026-06 / 2026-09 姣嶇増锛岄偅涓ゆ湡鍑轰笉浜嗚〃銆� +2. **褰撳墠鏈�绱ф�ョ殑 4 浠朵簨**锛堣瑙� 搂4 P0锛夛細鈶� 銆婁嚎鍏冩姇璧勯」鐩�嬫湀浠藉垪姣忔湀瑕嗙洊涓婃湀锛堢敤鎴� Q7 瑕佺殑銆屽姞涓�鍒椼�嶆湭鍋氾級锛� + 鈶� 瀵煎嚭鍓嶃�屽熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉銆嶅彧鍋氫簡涓�鍗婏紱鈶� 缂� 2026-06 / 2026-09 姣嶇増锛岄偅涓ゆ湡鍑轰笉浜嗚〃锛� + 鈶� 姹囨�诲ぇ琛ㄣ�屼腑鍙ｅ緞鎺掑悕 vs 涓彛寰勬槑缁嗐�嶅巻鍙插悓姣斿熀鏁板弻杞ㄥ埗锛�16 涓競宸炴湁宸級銆� + > 鍘熴��8 鏈堝崄鍫扮墿娴佹簮鏂囦欢鍚潪鍗佸牥娈点�嶅凡浜� 2026-09-21 闂幆锛岃 搂4 P0-1銆� 3. **鍒嚜宸辨媿鏉夸笟鍔″彛寰�**锛岀 5 绔犲垪鐨勬槸蹇呴』涓氬姟纭鐨勪簨銆� 4. 鏀瑰畬蹇呴』锛氬啓銆婂姛鑳芥祴璇曟姤鍛娿�嬧啋 鏇存柊銆婂伐浣滄棩缁撱�嬧啋 鍙屼粨搴撴帹閫侊紙搂7.4锛夈�傝繖鏄湰椤圭洰鐨勭‖瑙勭煩銆� @@ -41,6 +43,7 @@ | `freight_turnover_import` | **234** | 18 琛�/鏈� 脳 13 鏈燂紙2021-12 ~ 2026-08锛� | | `h2031_enterprise_monthly` | 15811 | 鍏矾鏃呭锛堜腑鍙ｅ緞缁村害 1 鐨勬潵婧愪箣涓�锛� | | `h2032_enterprise_monthly` | 13056 | 璐ц繍浼佷笟鏈堟姤 | +| `investment_system` | 2026-07: 148 / **2026-08: 129** | 鎶曡祫绯荤粺瀵煎嚭锛堟姇璧勫鏍哥殑姣斿鍩哄噯锛夛紱08 鏈熺敤**鏂版ā鏉�**瀵煎叆 | | `import_batch` | 417 | 瀵煎叆鎵规鍙拌处锛堝紓姝ュ鍑虹殑銆屾暟鎹増鏈畧鍗�嶇敤瀹冿級 | - **2026-09 鑴忔湡宸叉竻鐞嗗共鍑�**锛堟湰娆℃牳瀹烇細`h204_vehicle_quarterly` 鍙湁 2026-07/08锛沗audit_run`/`audit_result` 鍙湁 2026-05~08锛沗investment_monthly` 鍙湁 06~08锛夈�� @@ -55,7 +58,7 @@ | HEAD | `a08c70d feat(鎶曡祫): 甯傚窞鏈堟姤缁熶竴濉姤妯℃澘 + 鍘�(甯傘�佸尯)鍒楄В鏋� + 琛ㄥご琛屽垽瀹氭敹绱 | | 涓汉杩滅 | `origin` 鈫� `https://gitee.com/zhizhijie/traffic-audit.git`锛堝垎鏀� `master`锛� | | 鍏徃杩滅 | `gitea` 鈫� `http://61.183.254.94:3000/r/trafficAudit.git`锛堝垎鏀� `main`锛岃处鍙� zyj锛� | -| 鏈彁浜ゆ枃浠� | 鏈氦鎺ュ綋鏃剁殑鏈窡韪枃浠讹細`docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`銆乣docs/宸ヤ綔鏃ョ粨/宸ヤ綔鏃ョ粨_2026-09-21.md`銆乣docs/鎶曡祫/杈撳叆/2026骞�8鏈堟姇璧勭郴缁熼」鐩槑缁�.xls`銆乣docs/浜ゆ帴鏂囨。_2026-09-21.md`锛堥殢鏈浜ゆ帴涓�骞舵彁浜わ級 | +| 宸ヤ綔鍖虹姸鎬� | 骞插噣锛堜氦鎺ユ枃妗ｃ�佹眹鎬诲ぇ琛ㄩ棶棰樹氦鎺ャ�佹棩缁撱�佹姇璧勭郴缁熸柊妯℃澘鏀寔鍧囧凡鎻愪氦骞舵帹閫佷袱绔級 | ### 1.4 鍏抽敭鐩綍 @@ -182,7 +185,7 @@ | # | 浜嬮」 | 鐜拌薄 / 褰卞搷 | 鐜扮姸涓庤瘉鎹� | 涓嬩竴姝� | 鐘舵�� | | --- | --- | --- | --- | --- | --- | -| P0-1 | **8 鏈堝崄鍫扮墿娴佹眹鎬昏〃鍚�岄潪鍗佸牥娈点��** | 璇ユ枃浠朵竴涓〉绛炬敹浜嗗叏鐪侊細8 鏈堣繖浠� 38 琛岄噷鍙湁 **7 琛屾槸鍗佸牥**锛屽彟 **27 琛屾姹� + 4 琛岄粍鐭�**銆傜▼搴忕壒鎰忔敮鎸併�屾寜灏忚妭琛屽垏甯傚窞銆嶏紝鎵�浠ユ瘡娆￠噸瀵� 8 鏈堢墿娴侀兘浼氭妸杩� 31 涓」鐩缓鍒版姹�/榛勭煶鍚嶄笅锛�09-20 宸插疄娴嬪鐜� +31 椤圭洰锛岀敓鎴愯〃姝︽眽鐗╂祦娈典細澶� 27 琛岋級 | 搴撳凡娓呭共鍑�锛�152 椤圭洰 / 284 鏈堝害鏁帮紝2026-08 鏈堝害鏁� 136 琛屼笌閲嶅鍓嶉�愬�间竴鑷达級锛�**婧愭枃浠舵湭娓�** | 鐢ㄦ埛纭鍚庣敱鎺ユ墜浜哄垹娈碉紙鍏堝浠藉埌 `docs/鎶曡祫/杈撳嚭/`锛夛紝鎴栫敤鎴疯嚜琛屽湪 Excel 鍒犻櫎璇ヤ袱娈� | 鉂� | +| P0-1 | ~~8 鏈堝崄鍫扮墿娴佹眹鎬昏〃鍚�岄潪鍗佸牥娈点�崀~ | 鈥斺�� | **宸查棴鐜紙2026-09-21锛�**锛氱敤鎴风‘璁ゃ�屾竻闄ゆ帀銆嶁啋 鐢� Excel COM 鍒犻櫎婧愭枃浠剁 11~63 琛岋紙姝︽眽 27 + 榛勭煶 4锛夛紝鍘熶欢澶囦唤 `docs/鎶曡祫/杈撳嚭/婧愭枃浠跺浠�/鈥鍘熷鍚姹夐粍鐭砡20260921.xls`锛涢噸瀵奸獙璇佽鏂囦欢 38 鈫� **7 鏉�**锛�8 鏈堢墿娴� 128 鈫� 97锛屽簱鍐呬粛 152 椤圭洰 / 136 鏉� 2026-08 鏈堝害鏁� | 鏃犻渶鍐嶅鐞嗭紙鍚庣画鑻ュ啀鍔犲洖闈炴湰鏂囦欢甯傚窞娈碉紝闇�閲嶆柊娓呯悊锛� | 鉁� | | P0-2 | **銆婁嚎鍏冩姇璧勯」鐩�嬭涓婇」鐩〃鏈堜唤鍒椾細琚鐩�** | 浠ｇ爜鍙噸鍐欒〃澶存枃瀛楋紙`ReportExportService.java:6128-6139` 鍐� `col5`/`col23`锛夛紝妯℃澘 row2 绗� 24 鍒楀師鏈槸銆�2026骞�7鏈堝疄闄呭畬鎴愭姇璧勩�嶃��8 鏈堝鍑烘妸瀹冩敼鎴愩��2026骞�8鏈堚�︺�嶅苟鍐� 8 鏈堟暟 鈫� **7 鏈堥偅涓�鍒楃殑鏁版嵁娑堝け** | 鐢ㄦ埛宸插湪銆婂緟纭娓呭崟銆婹7 鏄庣‘锛氥�屽彧鏇存柊 F 鍒� + 鍦� 2026骞碭鏈堝疄闄呭畬鎴愭姇璧勫悗**鍔犱竴鍒�** 2026骞碭+1鏈堝疄闄呭畬鎴愭姇璧勩�嶁啋 鏈疄鐜� | 鎸� Q7 鏀逛负銆屾寜鏈堣拷鍔犱竴鍒椼�嶏紱鍚岃〃鍏跺畠鍐欐鏈堜唤鍒楋紙1-3鏈�/4鏈�/5鏈�/6鏈�/绗簩瀛ｅ害锛夊悓鏍疯涓�璧风湅 | 鉂� | | P0-3 | **瀵煎嚭鍓嶃�屽熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉銆嶏紙B4锛�** | 鍘诲勾鍚屾湀鍩烘暟娈嬬己鏃剁▼搴忕収绠楋紝鏇炬妸涓彛寰勬帓鍚嶅叏鐪佺疮璁″悓姣旂畻鎴� **+73.89%**锛堢湡鍊� +5.81%锛夈�傚姞浣撴鍚庡彲鏍规不澶嶅彂 | 鍚庣宸叉敹闆嗛棶棰樻竻鍗� `midIssues`锛坄ReportExportService.java:2436`锛変笌 `dbProblems`锛屼絾 **`getLastMidIssues()` 娌℃湁浠讳綍璋冪敤鏂�**锛屽墠绔篃鏃犳秷璐癸紝娌℃湁銆婃暟鎹己澶辨竻鍗曘�嬮〉 鈫� 鍙仛浜� B5锛堟棩蹇楋級涓� B3锛堝畬澶囨�ф牎楠岋級 | 鈶� 灏辩华/棰勮鎺ュ彛杩斿洖 issues锛涒憽 瀵煎嚭鍓嶅脊绐楋紱鈶� 鐢熸垚浠惰拷鍔犮�婃暟鎹己澶辨竻鍗曘�嬮〉 | 馃敹 | | P0-4 | **缂� 2026-06 / 2026-09 姣嶇増** | 杩欎袱鏈熼瑙� `ready=false`銆屾湭鎵惧埌妯℃澘鏂囦欢銆嶏紝鍑轰笉浜嗚〃 | `docs/鐢熸垚姹囨�诲ぇ琛�/` 涓嬪彧鏈� 2026骞�7鏈� / 2026骞�8鏈� + 鐗堝紡鍘熷瀷锛涚▼搴�**鍙寜鏂囦欢鍚嶇簿纭尮閰�**銆佷笉浼氳嚜寤� | 鐢ㄦ埛 Q13 宸叉殏缂擄紙瑕侀棶鍚屼簨銆岃兘涓嶈兘鐢ㄦ瘝鐗堣嚜鍔ㄧ敓鎴愬悗缁瘡鏈堟ā鏉裤�嶏級銆傜煭鏈燂細浜哄伐鏀句竴浠� 9 鏈堟瘝鐗堬紱闀挎湡锛氭墿鍒楀櫒锛堣瑙佹眹鎬诲ぇ琛ㄤ氦鎺� P0-2锛� | 鈴� | @@ -191,7 +194,7 @@ | # | 浜嬮」 | 璇存槑 | 鐘舵�� | | --- | --- | --- | --- | -| P1-1 | 涓彛寰勬帓鍚� vs 涓彛寰勬槑缁嗐�屽巻鍙插悓鏈熷熀鏁板弻杞ㄥ埗銆� | 闄ゆ姹夊 16 涓競宸炵疮璁″悓姣旈兘鏈夊樊锛堥粍鍐� 7.74% vs 7.64%锛夛紱鏍瑰洜鏄瘝鐗� 2025 骞� 3銆�4 鏈堢綉绾﹁溅鎷嗗垎鐢ㄤ簡涓�濂椾笌鍑虹鍒楄嚜鐩哥煕鐩剧殑鏃ц緭鍏ャ�傛湁鏂规 A/B锛�**寤鸿 A**锛堟帓鍚嶉〉鏀圭敤姣嶇増 2025 闈欐�佸垪锛� | 鉂岋紙璇﹁姹囨�诲ぇ琛ㄤ氦鎺ョ 4 绔狅級 | +| P1-1 | 涓彛寰勬帓鍚� vs 涓彛寰勬槑缁嗐�屽巻鍙插悓鏈熷熀鏁板弻杞ㄥ埗銆� | 闄ゆ姹夊 16 涓競宸炵疮璁″悓姣旈兘鏈夊樊锛堥粍鍐� 7.74% vs 7.64%锛夛紱鏍瑰洜鏄瘝鐗� 2025 骞� 3銆�4 鏈堢綉绾﹁溅鎷嗗垎鐢ㄤ簡涓�濂椾笌鍑虹鍒楄嚜鐩哥煕鐩剧殑鏃ц緭鍏ャ��**鏂规 A 宸插疄鏂藉苟鍥炲綊锛氭帓鍚嶉〉鏀圭敤姣嶇増 2025 闈欐�佸垪**锛涢粍鍐� 1-8 鏈堢疮璁″悓姣斾慨姝ｄ负 `7.641733%`锛�17 甯傚窞 脳 涓ゆ寚鏍囧叡 68 涓悓姣�/绱鏍煎叏閮ㄤ竴鑷达紙鏈�澶у樊 `2.91e-11`锛夛紝褰撴湀鍚屾瘮鏃犲洖褰� | 鉁咃紙2026-09-21锛岃瑙佹眹鎬诲ぇ琛ㄤ氦鎺ョ 4 绔狅級 | | P1-2 | 涓彛寰勬帓鍚嶅叏鐪佽宸� 0.0002 涓囦汉鍏噷 | 姣嶇増鍏紡 `=SUM(O4:O20)` 鍏堝洓鑸嶄簲鍏ュ啀姹傚拰鐨勭粨鏋勬�у樊寮傦紝鏄惁鏀瑰叏绮惧害鍐欏�奸渶鎷嶆澘 | 鈴� | | P1-3 | 涓彛寰勬槑缁� 4 鏍� `#DIV/0!` | 2025 骞� 8 鏈堝熀鏁颁负 0锛堜笉鍙瘮锛夛紝鏄惁鏀圭┖鐧介渶涓氬姟纭 | 鈴� | | P1-4 | 鍏ㄧ渷 h2031 1-8 鏈� 27524.49 vs 危17 甯傚窞 24481.74 | 宸� **3042.75**锛堜紒涓氫笂鎶ョ殑銆屽叏鐪併�嶅惈甯傚窞鏄庣粏澶栫殑鏁版嵁锛屾垨鏌愬競宸炴紡鎶ワ級銆傜▼搴忎竴寰嬫寜姣嶇増鍙ｅ緞锛埼ｅ競宸烇級璧� 鈫� 寤鸿涓氬姟渚ф牳涓�娆� | 鈴� | @@ -203,6 +206,7 @@ | P1-10 | 杩愯緭閲� 2026-01~07 鐨� `last_*` 涓虹┖ / H203-1 2026-01~07 鐨� `unified_credit_code`銆乣report_unit` 涓虹┖ | 鍓嶈�呮槸鏀瑰姩鍓嶅氨涓虹┖锛屽悗鑰呮槸鏂板垪鏈湡鎵嶈鍙栵紱鏄惁琛�/閲嶅寰呯‘璁� | 鈴� | | P1-11 | 璐ц繍銆屾寔缁湪瑙� 545 瀹躲�峷s銆屽畼鏂瑰叏鍙ｅ緞銆嶄袱鐗堝悓姣旓紙+2.90% vs +4.54%锛� | 鍙ｅ緞涓嶅悓锛屽凡鍒嗗埆娉ㄦ槑锛涜嫢瑕侀殢銆婂樊寮傜巼姹囨�昏〃銆嬩笂鎶ワ紝寤鸿鍔犳敞宸紓鍘熷洜 | 鈴� | | P1-12 | 楂橀�熻繍璺濆悓姣旓紙鐢ㄦ埛琛ㄦ牸 O 鍒楋級鐨勬潵婧�/鏈熼棿寰呯‘璁� | 纭鍚庢柟鍙畻銆岃繍璺濆閫熷樊銆� | 馃敀 绛夌敤鎴� | +| P1-13 | 鎶曡祫绯荤粺瀵煎嚭鐨�**鏂版ā鏉�**锛坄2026骞碭鏈堟姇璧勭郴缁熼」鐩槑缁哷锛� | 宸叉敮鎸佹寜琛ㄥご瀹氫綅瑙ｆ瀽锛�09-21锛�129 鏉″叆搴擄級銆�**寰呭畾**锛氣憼 鏂版ā鏉垮鍑虹殑銆岄」鐩墍澶勯樁娈点�嶆湭钀藉簱锛屽闇�姣斿寤鸿闃舵瑕佸姞鍒楀苟鍚屾 `docs/init.sql`/`docs/database.md`锛涒憽 鏂版ā鏉�**娌℃湁銆岃嚜骞村垵绱銆嶅垪**锛岃缁村害瀹℃牳宸叉敼涓恒�屽熀鍑嗙己澶卞嵆璺宠繃 + WARN 鏃ュ織銆嶏紙RULE_I002 瀹炴祴 0 鏉★級锛岃嫢涓氬姟浠嶈姣斿闇�妯℃澘琛ュ洖璇ュ垪 | 馃敹 | ### P2 鈥斺�� 宸ョ▼涓庢暣娲� @@ -227,7 +231,7 @@ 1. **P0-1**锛�8 鏈堝崄鍫扮墿娴佹簮鏂囦欢鐨勩�岄潪鍗佸牥娈点�嶇敱璋佹竻銆佷粈涔堟椂鍊欐竻锛燂紙寤鸿锛氭帴鎵嬩汉鍒犳骞跺浠斤級 2. **P0-2**锛氥�婁嚎鍏冩姇璧勯」鐩�嬫寜鏈堣拷鍔犲垪鐨勫仛娉曠‘璁わ紙鐢ㄦ埛 Q7 宸茬粰瑙勫垯锛屽疄鏂藉墠鍐嶇‘璁や竴娆″垪浣嶏級銆� 3. **P0-4**锛�2026-09 姣嶇増鎬庝箞鍔� 鈥斺�� 鐩存帴鏀句竴浠戒汉宸ユ瘝鐗堬紝杩樻槸鍏堝仛鎵╁垪鍣紵锛堢敤鎴锋鍦ㄩ棶鍚屼簨锛� -4. **P1-1**锛氫腑鍙ｅ緞鎺掑悕鍘嗗彶鍩烘暟璧版柟妗� A 杩樻槸 B锛燂紙寤鸿 A锛� +4. **P1-1**锛氫腑鍙ｅ緞鎺掑悕鍘嗗彶鍩烘暟鈥斺�旂敤鎴峰凡鎷嶆澘骞跺畬鎴愭柟妗� A锛堟帓鍚嶉〉鏀圭敤姣嶇増 2025 闈欐�佸垪锛夛紝鏃犻渶鍐嶇‘璁ゃ�� 5. **P1-2 / P1-3**锛�0.0002 涓囦汉鍏噷鏄惁鏀瑰叏绮惧害鍐欏�硷紱`#DIV/0!` 鏄惁鏀圭┖鐧姐�� 6. **P1-4**锛歨2031 鍏ㄧ渷琛屼笌 危17 甯傚窞宸� 3042.75 鐨勪笟鍔¤В閲娿�� 7. **P1-6**锛氳崋宸� / 榛勭煶銆岃鍒掑唴 / 瑙勫垝澶栥�嶅彛寰勩�� @@ -316,3 +320,5 @@ | 鏃ユ湡 | 鍙樻洿 | | --- | --- | | 2026-09-21 | 棣栨鎴愭枃锛氭暣鍚堟眹鎬诲ぇ琛ㄤ氦鎺ワ紙`docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`锛変笌鎶曡祫/璐ц繍/瀹㈣繍鍚勭嚎閬楃暀 | +| 2026-09-21锛堜笅鍗堬級 | P0-1 闂幆锛堝崄鍫版簮鏂囦欢宸插垹娈� + 閲嶅楠岃瘉锛夛紱鏂板 P1-13锛堟姇璧勭郴缁熸柊妯℃澘鏀寔锛夛紱鏁版嵁蹇収琛� `investment_system` 琛� | +| 2026-09-21锛堜笅鍗堬級 | P1-1 闂幆锛氱敤鎴烽噰鐢ㄦ柟妗� A锛屼腑鍙ｅ緞鎺掑悕鐨� 2025 绱鍩烘暟鏀硅姣嶇増銆婁腑鍙ｅ緞鏄庣粏銆嬮潤鎬佸垪锛涢粍鍐堢疮璁″悓姣旂敱 7.74% 淇涓� 7.641733%锛屽弻椤典竴鑷存�у洖褰掗�氳繃 | -- Gitblit v1.9.1