From b14fec1599277629e10b2bc686f02fd0c2e0bec1 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期五, 18 九月 2026 16:46:30 +0800 Subject: [PATCH] fix(货运月报): 订正持续在规企业累计运距同比基期口径（v2） --- docs/功能测试报告/功能测试报告_货运月报持续在规企业分市州累计运距_2026-09-18.md | 104 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 104 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_\350\264\247\350\277\220\346\234\210\346\212\245\346\214\201\347\273\255\345\234\250\350\247\204\344\274\201\344\270\232\345\210\206\345\270\202\345\267\236\347\264\257\350\256\241\350\277\220\350\267\235_2026-09-18.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_\350\264\247\350\277\220\346\234\210\346\212\245\346\214\201\347\273\255\345\234\250\350\247\204\344\274\201\344\270\232\345\210\206\345\270\202\345\267\236\347\264\257\350\256\241\350\277\220\350\267\235_2026-09-18.md" new file mode 100644 index 0000000..d9188ed --- /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_\350\264\247\350\277\220\346\234\210\346\212\245\346\214\201\347\273\255\345\234\250\350\247\204\344\274\201\344\270\232\345\210\206\345\270\202\345\267\236\347\264\257\350\256\241\350\277\220\350\267\235_2026-09-18.md" @@ -0,0 +1,104 @@ +# 鍔熻兘娴嬭瘯鎶ュ憡_璐ц繍鏈堟姤鎸佺画鍦ㄨ浼佷笟鍒嗗競宸炵疮璁¤繍璺漘2026-09-18 + +## 涓�銆佸姛鑳借鏄� + +- **闇�姹�**锛氬皢璐ц繍鏈堟姤銆屾寔缁湪瑙勪紒涓氥�嶅垎甯傚窞 1-8 鏈堢疮璁¤繍璺濆強鍚屾瘮鎯呭喌鏁寸悊鎴� Excel 琛ㄦ牸锛岀敓鎴愬埌妗岄潰銆� +- **鍙ｅ緞**锛� + - 鎸佺画鍦ㄨ浼佷笟 = 2026 骞� 1-8 鏈堣繛缁� 8 涓湀鍧囦笂鎶ャ�婇亾璺揣鐗╄繍杈撴湀搴︾敓浜ф儏鍐点�嬶紙H203-2锛夋湀鎶ョ殑浼佷笟锛屽叡 **636 瀹�**锛� + - 绱骞冲潎杩愯窛锛堝叕閲岋級= 1-8 鏈堢疮璁¤揣鐗╁懆杞噺 梅 1-8 鏈堢疮璁¤揣杩愰噺锛堝姞鏉冨钩鍧囷級锛� + - 鍚屾瘮 = 2026 骞� 1-8 鏈堢疮璁″�� 梅 2025 骞� 1-8 鏈堢疮璁″�� 鈭� 1锛�**鍩烘湡涓� 2025 骞� 1-8 鏈堝叏閮ㄨ涓婁紒涓氫笂鎶ユ暟**锛堝叏鐪� 664 瀹讹級锛屼笌姹囨�昏〃銆岃揣杩愩�嶉〉 T 鍒楀叕寮� `=S/SUM(V7,X7,鈥�,AJ7)-1` 鍚屼竴鍙ｅ緞锛坴1 鏇捐鐢ㄣ�屼袱骞村潎鎸佺画鍦ㄨ鐨� 545 瀹躲�嶄綔鍩烘湡锛屽凡璁㈡锛岃绗叚鑺傦級銆� +- **鏁版嵁鏉ユ簮**锛歚traffic_audit.h2032_enterprise_monthly`锛�2025-01 ~ 2026-08 浼佷笟绾ф湀鎶ワ級銆� +- **浜у嚭**锛歚C:\Users\閮戠帀娲乗Desktop\璐ц繍鏈堟姤_鎸佺画鍦ㄨ浼佷笟_鍒嗗競宸�1-8鏈堢疮璁¤繍璺濆強鍚屾瘮_2026-09-18.xlsx`锛屽惈 5 涓〉绛撅細 + `璇存槑涓庡彛寰刞銆乣鍒嗗競宸炴眹鎬籤銆乣鍒嗗競宸炲垎鏈坄銆乣浼佷笟鏄庣粏`锛�636 琛岋級銆乣鍙ｅ緞瀵规瘮`銆乣鍙ｅ緞鏍￠獙`銆� +- **鐢熸垚鑴氭湰**锛歚docs\宸ュ叿\鎸佺画鍦ㄨ浼佷笟绱杩愯窛鐢熸垚.py`锛堝璺戦渶鍏堢敓鎴愪袱浠� TSV 瀵煎嚭浠讹紝SQL 瑙侀檮褰曪級銆� + +## 浜屻�佹祴璇曠幆澧� + +| 椤� | 鍐呭 | +| --- | --- | +| 鏁版嵁搴� | MySQL 127.0.0.1:3308 / traffic_audit锛岃〃 `h2032_enterprise_monthly` | +| 杩愯鐜 | Python 3.14.2 + openpyxl 3.1.5 | +| 瀵圭収鐗� 1 | 銆�2026骞�8鏈堣涓婅揣鐗╁懆杞噺涓庡钩鍧囪繍璺濆垎鏋愭姤鍛婏紙鑽夌锛夈�嬪叏鐪佸綋鏈�/绱鍙ｅ緞 | +| 瀵圭収鐗� 2 | `docs\鐢熸垚姹囨�诲ぇ琛╘2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`銆� 璐ц繍銆嶉〉銆屽叾涓涓婅揣杩愰噺/瑙勪笂璐х墿鍛ㄨ浆閲忋�� | +| 杈撳嚭鐩綍 | 宸ヤ綔鍖� `outputs\`锛堢敓鎴愶級+ 妗岄潰锛堜氦浠橈級锛屼袱浠� SHA256 涓�鑷� | + +## 涓夈�佺敤渚嬭〃 + +| 缂栧彿 | 绫诲瀷 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | --- | +| TC01 | 姝ｅ悜 | 2026-08 鍏ㄧ渷瑙勪笂璐ц繍閲� | 3665.36 涓囧惃 | 3665.36 涓囧惃 | 閫氳繃 | +| TC02 | 姝ｅ悜 | 2026-08 鍏ㄧ渷瑙勪笂璐х墿鍛ㄨ浆閲� | 570004.44 涓囧惃鍏噷 | 570004.44 涓囧惃鍏噷 | 閫氳繃 | +| TC03 | 姝ｅ悜 | 2026 骞� 1-8 鏈堢疮璁¤揣杩愰噺/鍛ㄨ浆閲� | 31399.82 / 4927161.77 | 31399.82 / 4927161.77 | 閫氳繃 | +| TC04 | 姝ｅ悜 | 2026-01~07 閫愭湀瑙勪笂璐ц繍閲忋�佸懆杞噺涓庢眹鎬昏〃銆� 璐ц繍銆嶉〉姣斿锛�14 椤癸級 | 鍏ㄩ儴涓�鑷� | 14/14 涓�鑷达紙4 浣嶅皬鏁帮級 | 閫氳繃 | +| TC05 | 姝ｅ悜 | 17 甯傚窞瑕嗙洊闈� | 鍏ㄨ鐩栥�佹棤鏈瘑鍒湴鍖虹爜 | 17/17锛屾湭璇嗗埆 0 鏉� | 閫氳繃 | +| TC06 | 姝ｅ悜 | 浼佷笟鏄庣粏 636 琛屾眰鍜� | = 鍒嗗競宸炴眹鎬诲悎璁� | 31399.8248 / 4927161.7743锛屽樊寮� 0 | 閫氳繃 | +| TC07 | 姝ｅ悜 | 鍒嗗競宸炲垎鏈堥〉 | 8 鏈堝叏鐪� = 鍙戝竷鍙ｅ緞 155.51 鍏噷锛涘悇甯傚窞绱鍒� = 姹囨�婚〉绱鍒� | 155.51锛�17 涓競宸為�愰」 0 宸紓 | 閫氳繃 | +| TC08 | 姝ｅ悜 | 鍏ㄧ渷 1-8 鏈堢疮璁″钩鍧囪繍璺� | = 绱鍛ㄨ浆閲� 梅 绱璐ц繍閲� | 156.92 = 4927161.77 梅 31399.82 | 閫氳繃 | +| TC09 | 杈圭晫 | 2026 鍚勬湀涓婃姤浼佷笟鏁� | 鍚勬湀涓�鑷达紝鏀拺銆屾寔缁湪瑙勩�嶅垽瀹� | 鍚勬湀鍧囦负 636 瀹讹紝鍏ㄦ湡涓�鑷� | 閫氳繃 | +| TC10 | 杈圭晫 | 5 瀹� 1-8 鏈堣揣杩愰噺銆佸懆杞噺鍏ㄤ负 0 鐨勪紒涓� | 璁″叆浼佷笟鏁帮紝涓嶅奖鍝嶅競宸炶繍璺� | 杩愯窛姹囨�绘湭鍙楀奖鍝� | 閫氳繃 | +| TC11 | 杈圭晫 | 姝︽眽鐭冲寲浜ら�氳繍杈撴湁闄愬叕鍙搞�佹箹鍖楁嵎榫欎氦閫氳繍涓氭湁闄愬叕鍙� 1 鏈堝湴鍖虹爜 420100銆佸叾鍚� 420107/420103 | 鍚屽睘姝︽眽甯傦紝褰掗泦涓嶅彉 | 鍧囧綊鍏ユ姹夊競 | 閫氳繃 | +| TC12 | 璐熷悜 | 浠欐甯傘�屼袱骞村潎鎸佺画鍦ㄨ銆嶄紒涓氭暟 = 0 | 鍚屾瘮鐣欑┖ + 鏄庣‘澶囨敞锛屼笉闄ら浂鎶ラ敊 | 鍚屾瘮鍒楃┖锛屽娉ㄣ�屽悓姣斾笉閫傜敤锛�2025 骞� 1-8 鏈堟棤杩炵画涓婃姤璁板綍銆� | 閫氳繃 | +| TC13 | 璐熷悜 | 绱璐ц繍閲忎负 0 鐨勪紒涓� | 绱杩愯窛鐣欑┖锛屼笉闄ら浂鎶ラ敊 | 閫昏緫宸查槻闄ら浂锛堟湰琛� 636 瀹舵棤姝ょ被浼佷笟锛� | 閫氳繃 | +| TC14 | 璐熷悜 | 鍦板尯鐮佷笉鍦� 17 甯傚窞鏄犲皠鍐� | 褰掑叆銆屾湭璇嗗埆銆嶅苟鍦ㄦ牎楠岄〉鏆撮湶 | 瀹為檯 0 鏉� | 閫氳繃 | + +## 鍥涖�佸彂鐜扮殑闂涓庡缃� + +1. **鐢熸垚鑴氭湰琛屽彿閿欎綅锛堝凡淇級**锛氶娆＄敓鎴愭椂姹囨�婚〉琛ㄥご琚暟鎹鐩栥�佹湯琛屻�岀鍐滄灦鏋楀尯銆嶈鍚堣琛岃鐩栵紝鏍瑰洜鏄� `rr` 鑷娆℃暟涓庡啓琛屼綅缃笉鍖归厤銆備慨姝ｅ悗閲嶈窇锛宍鍒嗗競宸炴眹鎬籤 涓鸿〃澶� + 17 甯傚窞 + 鍚堣鍏� 18 琛岋紝閫愯鏍稿鏃犺銆� +2. **妗岄潰鍓湰涓�搴︿负淇鍓嶇増鏈紙宸蹭慨锛�**锛氶噸鏂板悓姝ュ苟鏍￠獙宸ヤ綔鍖轰笌妗岄潰鏂囦欢 SHA256 涓�鑷达紙94869 瀛楄妭锛夈�� +3. **鍙ｅ緞寰呬笟鍔＄‘璁わ紙2 椤癸級**锛� + - 銆屾寔缁湪瑙勪紒涓氥�嶆寜銆�2026 骞� 1-8 鏈堣繛缁� 8 涓湀涓婃姤銆嶅畾涔変负 636 瀹讹紝**鐢ㄦ埛 2026-09-18 宸茬‘璁ゆ鍙ｅ緞**锛堝師鍒楀嚭銆岃繛缁袱骞村湪瑙勩�嶃�岃繛缁� 12 涓湀鍦ㄨ銆嶄袱绉嶅閫夛紝鍧囦笉閲囩敤锛夈�� + - 鍚屾瘮閲囩敤 545 瀹跺彲姣斿彛寰勶紙鍓旈櫎 91 瀹� 2025 骞存棤鍚屾湡杩炵画涓婃姤鐨勪紒涓氾級锛屼粰妗冨競鍥犳棤鍙瘮浼佷笟鍚屾瘮鐣欑┖銆� + +## 浜斻�佺粨璁� + +14 鏉＄敤渚嬶紙8 姝ｅ悜 / 3 杈圭晫 / 3 璐熷悜锛夊叏閮ㄩ�氳繃锛涜姝ｅ悗鍙﹁ˉ TC15鈥揟C18 鍏� 4 鏉★紝浜﹀叏閮ㄩ�氳繃锛涘叏鐪佸綋鏈堛�佺疮璁°�佸垎甯傚窞涓変釜灞傜骇涓庡凡鍙戝竷鍙ｅ緞**闆跺樊寮�**锛屾槑缁嗕笌姹囨�婚�愰」瀵硅处涓�鑷达紝浜や粯浠跺凡鐢熸垚鍒版闈€�傚彛寰勫凡浜� 2026-09-18 鐢辩敤鎴风‘璁わ紙636 瀹讹級锛屽悓姣斿熀鏈熷彛寰勫凡鎸夋眹鎬昏〃鍏紡璁㈡涓哄叏鍙ｅ緞銆� + +## 闄勫綍锛氬璺戠敤 SQL + +```sql +-- 浼佷笟绾х疮璁★紙瀵煎嚭涓� _tmp_persist_scope.tsv锛� +SELECT MAX(region_code) rc, enterprise_name en, IFNULL(MAX(enterprise_code),'') ec, + IFNULL(MAX(unified_credit_code),'') ucc, + SUM(CASE WHEN report_period BETWEEN '2026-01' AND '2026-08' THEN IFNULL(freight_total,0) ELSE 0 END) f26, + SUM(CASE WHEN report_period BETWEEN '2026-01' AND '2026-08' THEN IFNULL(turnover_total,0) ELSE 0 END) t26, + COUNT(DISTINCT CASE WHEN report_period BETWEEN '2026-01' AND '2026-08' THEN report_period END) m26, + SUM(CASE WHEN report_period BETWEEN '2025-01' AND '2025-08' THEN IFNULL(freight_total,0) ELSE 0 END) f25, + SUM(CASE WHEN report_period BETWEEN '2025-01' AND '2025-08' THEN IFNULL(turnover_total,0) ELSE 0 END) t25, + COUNT(DISTINCT CASE WHEN report_period BETWEEN '2025-01' AND '2025-08' THEN report_period END) m25 +FROM h2032_enterprise_monthly +WHERE report_period BETWEEN '2025-01' AND '2026-08' +GROUP BY enterprise_name HAVING m26 = 8; + +-- 浼佷笟绾у垎鏈堬紙瀵煎嚭涓� _tmp_persist_scope_monthly.tsv锛� +SELECT report_period, region_code, enterprise_name, IFNULL(freight_total,0), IFNULL(turnover_total,0) +FROM h2032_enterprise_monthly WHERE report_period BETWEEN '2025-01' AND '2026-08'; +``` + +## 鍏�佽姝ｈ褰曪紙2026-09-18锛寁2锛� + +**闂**锛氱敤鎴峰弽棣� 1-8 鏈堢疮璁¤繍璺濆悓姣斾笉瀵广�傛牳鏌ュ彂鐜� v1 鐨勫悓姣斿熀鏈熷彇銆屼袱骞村潎鎸佺画鍦ㄨ鐨� 545 瀹朵紒涓氥�嶏紝 +鑰屾眹鎬昏〃銆岃揣杩愩�嶉〉 T 鍒楋紙绱鍚屾瘮锛夌殑鍏紡鏄� `=S7/SUM(V7,X7,Z7,AB7,AD7,AF7,AH7,AJ7)-1`锛� +鍩烘湡涓� **2025 骞� 1-8 鏈堝叏閮ㄨ涓婁紒涓�**锛堝叏鐪� 664 瀹讹級銆備袱濂楀熀鏈熷鑷村悓姣旂郴缁熸�у亸灏忋�� + +**璇佹嵁**锛� + +| 椤圭洰 | v1锛�545 瀹跺彲姣斿彛寰勶級 | v2锛堝畼鏂瑰叏鍙ｅ緞锛屼慨姝ｅ悗锛� | 宸插彂甯冩姤鍛� | +| --- | --- | --- | --- | +| 2025 骞� 1-8 鏈堣揣杩愰噺鍩烘湡(涓囧惃) | 鈥� | 33994.4483 | 姹囨�昏〃 V7..AJ7 缂撳瓨鍊煎悎璁′竴鑷� | +| 2025 骞� 1-8 鏈堝懆杞噺鍩烘湡(涓囧惃鍏噷) | 鈥� | 5102518.9463 | 姹囨�昏〃 V8..AJ8 缂撳瓨鍊煎悎璁′竴鑷� | +| 绱璐ц繍閲忓悓姣� | 鈭�7.96% | **鈭�7.63%** | 鈭�7.63% | +| 绱鍛ㄨ浆閲忓悓姣� | 鈭�5.30% | **鈭�3.44%** | 鈭�3.44% | +| 鍏ㄧ渷 1-8 鏈堢疮璁″钩鍧囪繍璺濆悓姣� | +2.90% | **+4.54%** | 鈥旓紙= 156.92 梅 150.10 鈭� 1锛� | + +**澶勭疆**锛氶噸绠楀叏琛紝`鍒嗗競宸炴眹鎬籤 鏀逛负銆�2026 鍏ㄥ彛寰� / 2025 鍏ㄥ彛寰� / 鍚屾瘮銆嶄笁娈靛垪锛屾柊澧� `鍙ｅ緞瀵规瘮` 椤靛苟鍒楀畼鏂瑰彛寰勪笌鍚屼紒涓氬彛寰勶紝 +渚涗笟鍔″垽鏂競宸炶惤宸潵婧愶紱鎵�鏈夋牎楠岄」 0 宸紓銆� + +| 缂栧彿 | 绫诲瀷 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | --- | +| TC15 | 姝ｅ悜 | 2025 骞� 1-8 鏈堝熀鏈熻揣杩愰噺銆佸懆杞噺 | = 姹囨�昏〃銆岃揣杩愩�嶉〉 V7..AJ7 / V8..AJ8 | 33994.45 / 5102518.95锛�0 宸紓 | 閫氳繃 | +| TC16 | 姝ｅ悜 | 绱鍚屾瘮锛堣揣杩愰噺銆佸懆杞噺锛� | = 鍙戝竷鎶ュ憡 鈭�7.63% / 鈭�3.44% | 瀹屽叏涓�鑷� | 閫氳繃 | +| TC17 | 姝ｅ悜 | 鍏ㄧ渷绱骞冲潎杩愯窛鍚屾瘮 | = 156.92 梅 150.10 鈭� 1 = +4.54% | +4.54% | 閫氳繃 | +| TC18 | 璐熷悜 | v1 鐨� 545 瀹跺彛寰� | 宸紓鍙噺鍖栥�佷笉娈嬬暀浜庝氦浠樹欢 | 宸紓 +1.64 涓櫨鍒嗙偣锛屽凡鏀逛负骞跺垪灞曠ず骞舵爣娉ㄤ负鍙傝�冨彛寰� | 閫氳繃 | + +**閬楃暀鎻愮ず**锛氫粰妗冨競瀹樻柟鍙ｅ緞鍚屾瘮 鈭�89.1%锛�2025 骞� 2 瀹朵负瓒呴暱閫斿皬杩愰噺浼佷笟銆�2026 骞存崲涓虹煭閫斿ぇ杩愰噺浼佷笟锛夈�� +榛勭煶 +35.3%銆佽闃� +21.0% 绛夛紝澶氫负涓ゅ勾瑙勪笂浼佷笟鍚嶅崟鍙樺姩鎵�鑷达紝寤鸿涓氬姟渚ф寜 `鍙ｅ緞瀵规瘮` 椤垫牳瀵广�� -- Gitblit v1.9.1