From abb2a381884caee17ec736722d97f38e7d9239f2 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期六, 19 九月 2026 10:13:52 +0800
Subject: [PATCH] docs(货运): 新增同名企业(545家)1-8月累计货运量/周转量SQL查询脚本 + 09-19功能测试报告与工作日结

---
 docs/工作日结/工作日结_2026-09-19.md                          |   77 +++++++
 docs/功能测试报告/功能测试报告_持续在规企业545家分市州累计运距同比_2026-09-19.md  |   52 +++++
 docs/工具/持续在规企业545家累计运距生成.py                           |  174 +++++++++++++++++
 docs/生成汇总大表/同名企业_1-8月累计对比_2026-09-19.sql              |  201 ++++++++++++++++++++
 docs/功能测试报告/功能测试报告_同名企业1-8月累计货运量与周转量SQL_2026-09-19.md |   74 +++++++
 5 files changed, 578 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\220\214\345\220\215\344\274\201\344\270\2321-8\346\234\210\347\264\257\350\256\241\350\264\247\350\277\220\351\207\217\344\270\216\345\221\250\350\275\254\351\207\217SQL_2026-09-19.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\220\214\345\220\215\344\274\201\344\270\2321-8\346\234\210\347\264\257\350\256\241\350\264\247\350\277\220\351\207\217\344\270\216\345\221\250\350\275\254\351\207\217SQL_2026-09-19.md"
new file mode 100644
index 0000000..976b400
--- /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\220\214\345\220\215\344\274\201\344\270\2321-8\346\234\210\347\264\257\350\256\241\350\264\247\350\277\220\351\207\217\344\270\216\345\221\250\350\275\254\351\207\217SQL_2026-09-19.md"
@@ -0,0 +1,74 @@
+# 鍔熻兘娴嬭瘯鎶ュ憡_鍚屽悕浼佷笟1-8鏈堢疮璁¤揣杩愰噺涓庡懆杞噺SQL_2026-09-19
+
+## 涓�銆佸姛鑳借鏄�
+
+2025 骞� 1-8 鏈堜笌 2026 骞� 1-8 鏈堟姤閫佺殑浼佷笟鏁伴噺涓嶅悓锛�664 瀹� vs 636 瀹讹級锛�
+鐩存帴鐩稿噺鐨勫樊棰濋噷娣风潃銆屼紒涓氬悕鍗曞彉浜嗐�嶇殑褰卞搷銆傛湰鍔熻兘鎸�**鍚屽悕浼佷笟鍙ｅ緞**
+锛堜袱骞� 1-8 鏈堥兘鎶ラ�佽繃鐨勪紒涓氬悕绉颁氦闆嗭紝鍏� **545 瀹�**锛夊垎鍒眹鎬讳袱骞� 1-8 鏈堢疮璁＄殑
+**璐ц繍閲�**涓�**璐х墿鍛ㄨ浆閲�**锛屼繚璇佷袱骞翠紒涓氳寖鍥村畬鍏ㄤ竴鑷达紝鍙洿鎺ョ敤浜庡悓姣斻��
+
+- 浜や粯鑴氭湰锛歚docs/鐢熸垚姹囨�诲ぇ琛�/鍚屽悕浼佷笟_1-8鏈堢疮璁″姣擾2026-09-19.sql`锛堝惈 6 鏉℃煡璇級
+- 鏁版嵁婧愯〃锛歚traffic_audit.h2032_enterprise_monthly`锛堜氦浼佺粺H203-2琛紝浼佷笟绾ф湀鎶ワ級
+- 鍏抽敭瀛楁锛歚freight_total` 璐ц繍閲忥紙鍚級銆乣turnover_total` 璐х墿鍛ㄨ浆閲忥紙鍚ㄥ叕閲岋級銆�
+  `report_period` 鎶ヨ〃鏈燂紙'YYYY-MM'锛夈�乣enterprise_name` 浼佷笟鍚嶇О
+- 鍗曚綅鎹㈢畻锛氳〃鍐呬负銆屽惃 / 鍚ㄥ叕閲屻�嶏紝杈撳嚭缁熶竴 梅10000 鈫� 銆屼竾鍚� / 涓囧惃鍏噷銆�
+- 鏈熼棿鍙栨硶锛�1-8 鏈� = `report_period BETWEEN 'YYYY-01' AND 'YYYY-08'`
+- 鑴氭湰鍐呭锛氭煡璇� 1 姹囨�昏 / 鏌ヨ 2 閫愪紒涓氬鐓� / 鏌ヨ 3 鍙ｅ緞瀵圭収 /
+  鏌ヨ 4 宸紓浼佷笟鍚嶅崟 / 鏌ヨ 5 鍒嗗競宸炴眹鎬� / 鏌ヨ 6 鏁版嵁浣撴
+
+## 浜屻�佹祴璇曠幆澧�
+
+- 鏁版嵁搴擄細MySQL 8.0.29锛宍127.0.0.1:3308`锛屽簱 `traffic_audit`
+- 瀹㈡埛绔細mysql 5.7.41锛屽弬鏁� `--default-character-set=utf8mb4`
+- 鎵ц鏂瑰紡锛氭暣鑴氭湰涓�娆℃�ф墽琛� `mysql ... < 鍚屽悕浼佷笟_1-8鏈堢疮璁″姣擾2026-09-19.sql`
+- 鏁版嵁瑙勬ā锛歚report_period` 鍏� 20 涓姤琛ㄦ湡锛�2025-01 ~ 2026-08锛夛紝鍚堣 13056 琛岋紱
+  鍏朵腑 1-8 鏈堝彛寰� 10400 琛岋紙2025 骞� 5312 琛� / 2026 骞� 5088 琛岋級
+- 娴嬭瘯鏃ユ湡锛�2026-09-19
+
+## 涓夈�佺敤渚嬭〃
+
+| 缂栧彿 | 绫诲瀷 | 鐢ㄤ緥 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- | --- | --- |
+| T1 | 姝ｅ悜 | 鍚屽悕浼佷笟鍙ｅ緞姹囨�伙紙鏌ヨ 1锛� | 涓ゅ勾 1-8 鏈堥兘鎶ラ�佽繃鐨勪紒涓� | 涓�琛屽唴鍑轰袱骞寸疮璁℃暟 | 545 瀹讹紱璐ц繍閲� 30153.14 / 27752.68 涓囧惃锛屽懆杞噺 4635340.46 / 4389882.05 涓囧惃鍏噷 | 閫氳繃 |
+| T2 | 姝ｅ悜 | 閫愪紒涓氬鐓ф槑缁嗭紙鏌ヨ 2锛� | 鍚屼笂 | 姣忓涓�琛屻�佷袱骞村苟鎺� | 545 琛岋紝鍚袱骞村�笺�佸鍑忛銆佸悓姣� | 閫氳繃 |
+| T3 | 姝ｅ悜 | 鏄庣粏姹傚拰 = 姹囨�昏 | 鏌ヨ 2 鐨� 545 琛屾寜鍒楁眰鍜� | 涓庢煡璇� 1 瀹屽叏涓�鑷� | 30153.14 / 4635340.46 / 27752.68 / 4389882.05锛屽樊寮� 0 | 閫氳繃 |
+| T4 | 姝ｅ悜 | 鍙ｅ緞瀵圭収锛堟煡璇� 3锛� | 鍏ㄩ噺 vs 鍚屽悕 | 4 琛屽彛寰勫彲瑙ｉ噴宸 | 鍏ㄩ噺 2025锛�664 瀹� 33994.45 涓囧惃 / 5102518.95 涓囧惃鍏噷锛涘叏閲� 2026锛�636 瀹� 31399.82 涓囧惃 / 4927161.77 涓囧惃鍏噷 | 閫氳繃 |
+| T5 | 姝ｅ悜 | 宸紓浼佷笟鍚嶅崟锛堟煡璇� 4锛� | 鍙湪涓�骞存姤閫佺殑浼佷笟 | 瀹舵暟涓庡樊棰濈浉绗� | 2025 鐙湁 119 瀹躲��2026 鐙湁 91 瀹讹紱瀹舵暟鏍￠獙 664鈭�545=119銆�636鈭�545=91 | 閫氳繃 |
+| T6 | 姝ｅ悜 | 宸紓閲戦闂悎 | 鍚屽悕 + 鐙湁 = 鍏ㄩ噺 | 閲戦闂悎 | 璐ц繍閲� 30153.14+3841.31=33994.45锛�=鍏ㄩ噺 2025锛夛紱鍛ㄨ浆閲� 4635340.46+467178.48=5102518.94锛堝叏閲� 5102518.95锛屽樊 0.01 涓哄洓鑸嶄簲鍏ワ級 | 閫氳繃 |
+| T7 | 姝ｅ悜 | 鍒嗗競宸炴眹鎬伙紙鏌ヨ 5锛� | 鍚屽悕浼佷笟鎸� region_code 褰掑競宸� | 甯傚窞鍚堣 = 鍏ㄧ渷 | 16 涓競宸烇紙浠欐 0 瀹跺悓鍚嶄紒涓氾級锛屼紒涓氭暟鍚堣 545锛屽悇鍒楀悎璁� = 鏌ヨ 1 | 閫氳繃 |
+| T8 | 姝ｅ悜 | 鍏ュ簱鎶芥煡锛氶�愭湀鐩稿姞瀵归綈 | 姝︽眽閽㈤搧闆嗗洟鐗╂祦鏈夐檺鍏徃 2025-01~08 鍏� 8 鏉″師濮嬭褰� | 閫愭湀鐩稿姞 = 鏄庣粏琛� | 璐ц繍閲� 7381512 鍚� 鈫� 738.15 涓囧惃锛涘懆杞噺 231191873 鍚ㄥ叕閲� 鈫� 23119.19 涓囧惃鍏噷锛屼笌鏌ヨ 2 杈撳嚭涓�鑷� | 閫氳繃 |
+| T9 | 璐熷悜 | 浼佷笟鍚嶄笉瀛樺湪 | `enterprise_name='涓嶅瓨鍦ㄧ殑浼佷笟XYZ'` | 0 琛屻�佷笉鎶ラ敊 | 0 琛� | 閫氳繃 |
+| T10 | 璐熷悜 | 骞翠唤鍐欓敊 | 鏈熼棿 `'2024-01' ~ '2024-08'` | 0 琛� | 0 琛� | 閫氳繃 |
+| T11 | 杈圭晫 | 鍚屼竴浼佷笟鍚屾湀閲嶅璁板綍 | `GROUP BY enterprise_name, report_period HAVING COUNT(*)>1` | 鏃犻噸澶嶏紙鍚﹀垯绱浼氳鏀惧ぇ锛� | 0 鏉� | 閫氳繃 |
+| T12 | 杈圭晫 | 鍚屽悕浼佷笟鏈堜唤涓嶅叏锛堟煡璇� 6锛� | 璁板綍鏁� <> 8 鐨勫悓鍚嶄紒涓� | 鏃犲紓甯� | 绌虹粨鏋滈泦锛�545 瀹朵袱骞村悇 8 涓湀榻愬叏 | 閫氳繃 |
+
+## 鍥涖�佸彂鐜扮殑闂涓庡缃�
+
+1. **浼佷笟鍚嶇О浣滀负鍖归厤閿殑鍥烘湁椋庨櫓锛堝凡鎻愮ず锛屾湭鏀瑰彛寰勶級**
+   鍚屽悕鍙ｅ緞鎸� `enterprise_name` 瀛楃涓茬浉绛夊尮閰嶏紝鑻ヤ紒涓氭敼鍚嶃�佹垨涓嶅悓鍦板競鍑虹幇瀹屽叏鍚屽悕鐨勪紒涓氾紝
+   浼氳鍒や负銆屼笉鍚屼紒涓氥�嶆垨銆屽悓涓�浼佷笟銆嶃�傚疄娴嬩袱骞存暟鎹腑鍚屼竴鎶ヨ〃鏈熷唴鏃犻噸鍚嶈褰曪紙T11锛夛紝
+   浣嗚法骞存敼鍚嶆棤娉曢�氳繃鏈剼鏈瘑鍒紱濡傞渶鏇翠弗璋ㄥ彲鏀圭敤 `unified_credit_code`锛堢粺涓�绀句細淇＄敤浠ｇ爜锛夊尮閰嶃��
+2. **鍚屽悕鍙ｅ緞涓庡叏閲忓彛寰勭殑宸宸插彲瑙ｉ噴**
+   2026 骞村叏閲忔瘮鍚屽悕鍙ｅ緞澶� 3647.14 涓囧惃銆佸皯 537279.73 涓囧惃鍏噷锛堟柊杩� 91 瀹朵紒涓氾級锛�
+   2025 骞村叏閲忔瘮鍚屽悕鍙ｅ緞澶� 3841.31 涓囧惃銆�467178.48 涓囧惃鍏噷锛堥��鍑� 119 瀹讹級銆�
+   瀵瑰璇存槑鍚屾瘮鏃堕渶娉ㄦ槑閲囩敤鐨勫彛寰勶紝閬垮厤涓庡叏閲忓彛寰勬暟瀛楀涓嶄笂銆�
+3. **姹囨�昏鐨勫悓姣斿皬鏁颁綅**
+   鍛ㄨ浆閲忓悓姣旂簿纭�� 鈭�5.2954%锛宍ROUND(...,2)` 杈撳嚭 鈭�5.30锛堟樉绀轰负 鈭�5.3锛夛紝
+   鑴氭湰琛ㄥご娉ㄩ噴宸插悓姝ヤ慨姝ｄ负 鈭�5.30%锛岄伩鍏嶄笌灞曠ず鍊间笉涓�鑷淬��
+4. **`region_code` 鍙� 2026 骞磋褰�**
+   鍒嗗競宸炴煡璇㈢敤 `MAX(CASE WHEN report_period >= '2026-01' ...)` 鍙� 2026 骞寸殑鍦板尯浠ｇ爜锛�
+   浼佷笟璺ㄥ競杩佺Щ鏃舵寜 2026 骞村綊灞炵粺璁★紝瀹炴祴鏈彂鐜板奖鍝嶏紙鍚屽悕浼佷笟涓ゅ湴骞跺瓨鐨勬儏鍐垫棤锛夈��
+
+## 浜斻�佺粨璁�
+
+6 鏉℃煡璇㈡暣鑴氭湰鎵ц閫氳繃锛�12 鏉＄敤渚嬶紙8 姝ｅ悜 / 2 璐熷悜 / 2 杈圭晫锛夊叏閮ㄩ�氳繃銆�
+
+**鍚屽悕浼佷笟鍙ｅ緞锛�545 瀹讹級1-8 鏈堢疮璁＄粨鏋滐細**
+
+| 鎸囨爣 | 2025 骞� 1-8 鏈� | 2026 骞� 1-8 鏈� | 鍚屾瘮 |
+| --- | --- | --- | --- |
+| 璐ц繍閲忥紙涓囧惃锛� | 30153.14 | 27752.68 | 鈭�7.96% |
+| 璐х墿鍛ㄨ浆閲忥紙涓囧惃鍏噷锛� | 4635340.46 | 4389882.05 | 鈭�5.30% |
+
+鍏朵腑 2026 骞寸疮璁℃暟涓� 2026-09-19銆婃寔缁湪瑙勪紒涓� 545 瀹剁疮璁¤繍璺濄�嬩氦浠樹欢鐨勫叏鐪佽
+锛�27752.6820 涓囧惃 / 4389882.0468 涓囧惃鍏噷锛夊畬鍏ㄤ竴鑷达紝涓ゆ潯閾捐矾鍙ｅ緞浜掕瘉閫氳繃銆�
\ No newline at end of file
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\214\201\347\273\255\345\234\250\350\247\204\344\274\201\344\270\232545\345\256\266\345\210\206\345\270\202\345\267\236\347\264\257\350\256\241\350\277\220\350\267\235\345\220\214\346\257\224_2026-09-19.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\214\201\347\273\255\345\234\250\350\247\204\344\274\201\344\270\232545\345\256\266\345\210\206\345\270\202\345\267\236\347\264\257\350\256\241\350\277\220\350\267\235\345\220\214\346\257\224_2026-09-19.md"
new file mode 100644
index 0000000..af35bcb
--- /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\214\201\347\273\255\345\234\250\350\247\204\344\274\201\344\270\232545\345\256\266\345\210\206\345\270\202\345\267\236\347\264\257\350\256\241\350\277\220\350\267\235\345\220\214\346\257\224_2026-09-19.md"
@@ -0,0 +1,52 @@
+# 鍔熻兘娴嬭瘯鎶ュ憡_鎸佺画鍦ㄨ浼佷笟545瀹跺垎甯傚窞绱杩愯窛鍚屾瘮_2026-09-19
+
+## 涓�銆佸姛鑳借鏄�
+
+- **闇�姹�**锛氭寜鐢ㄦ埛纭鐨勩�屾寔缁湪瑙勪紒涓� = 2025 骞� 1-8 鏈堜笌 2026 骞� 1-8 鏈堝潎杩炵画 8 涓湀涓婃姤銆嶅彛寰勶紙545 瀹讹級锛�
+  绠楀嚭鍒嗗競宸� 1-8 鏈堢疮璁″钩鍧囪繍璺濆悓姣旓紝杈撳嚭鍒� `D:\妗岄潰\璐ц繍浼佷笟鍒嗗競宸炴儏鍐礬`銆�
+- **鍙ｅ緞**锛�
+  - 鎸佺画鍦ㄨ浼佷笟锛�545 瀹讹級锛濅袱骞村潎杩炵画 8 涓湀涓婃姤 H203-2 鏈堟姤鐨勪紒涓氾紱涓ゅ勾闂存柊杩涖�侀��鍑虹殑浼佷笟涓嶅弬涓庡悓姣旓紱
+  - 绱骞冲潎杩愯窛锛堝叕閲岋級锛� 1-8 鏈堢疮璁¤揣鐗╁懆杞噺 梅 1-8 鏈堢疮璁¤揣杩愰噺锛堝姞鏉冨钩鍧囷級锛�
+  - 鍚屾瘮 锛� 2026 骞� 1-8 鏈堢疮璁″钩鍧囪繍璺� 梅 2025 骞� 1-8 鏈堢疮璁″钩鍧囪繍璺� 鈭� 1锛�
+  - 鍏ㄧ渷琛� 锛� 17 涓競宸炵殑绱鍛ㄨ浆閲忋�佺疮璁¤揣杩愰噺鍒嗗埆姹傚拰鍚庣浉闄わ紙闈炲競宸炲悓姣旂殑绠楁湳骞冲潎锛夈��
+- **浜у嚭**锛歚D:\妗岄潰\璐ц繍浼佷笟鍒嗗競宸炴儏鍐礬鎸佺画鍦ㄨ浼佷笟545瀹禵鍒嗗競宸�1-8鏈堢疮璁¤繍璺濆強鍚屾瘮_2026-09-19.xlsx`
+  锛堥〉绛撅細`甯傚窞姹囨�籤銆斿叏鐪� + 17 甯傚窞銆曘�乣浼佷笟鏄庣粏(545瀹�)`锛夈��
+- **鐢熸垚鑴氭湰**锛歚docs\宸ュ叿\鎸佺画鍦ㄨ浼佷笟545瀹剁疮璁¤繍璺濈敓鎴�.py`銆�
+
+## 浜屻�佹祴璇曠幆澧�
+
+| 椤� | 鍐呭 |
+| --- | --- |
+| 鏁版嵁搴� | MySQL 127.0.0.1:3308 / traffic_audit锛岃〃 `h2032_enterprise_monthly` |
+| 杩愯鐜 | Python 3.14.2 + openpyxl 3.1.5 |
+| 瀵圭収鐗� | 鐢ㄦ埛渚� `D:\妗岄潰\璐ц繍浼佷笟鍒嗗競宸炴儏鍐礬璐ц繍浼佷笟鍒嗗競宸炴儏鍐祒lsx.xlsx`锛圡/N 涓ゅ垪锛� |
+| 杈撳嚭浣嶇疆 | 宸ヤ綔鍖� `outputs\` 涓� `D:\妗岄潰\璐ц繍浼佷笟鍒嗗競宸炴儏鍐礬`锛屼袱浠� SHA256 涓�鑷� |
+
+## 涓夈�佺敤渚嬭〃
+
+| 缂栧彿 | 绫诲瀷 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- | --- |
+| TC01 | 姝ｅ悜 | 鍏ㄧ渷 545 瀹� 2026 骞� 1-8 鏈堢疮璁″懆杞噺 梅 绱璐ц繍閲� | 158.1787 鍏噷 | 4389882.0468 梅 27752.6820 = 158.1787 | 閫氳繃 |
+| TC02 | 姝ｅ悜 | 鍏ㄧ渷 545 瀹� 2025 骞� 1-8 鏈堢疮璁″钩鍧囪繍璺� | 涓庣敤鎴锋枃浠� M4 涓�鑷� | 153.7266锛屼竴鑷� | 閫氳繃 |
+| TC03 | 姝ｅ悜 | 鍏ㄧ渷绱杩愯窛鍚屾瘮 | 158.1787 梅 153.7266 鈭� 1 | +2.8961% | 閫氳繃 |
+| TC04 | 姝ｅ悜 | 17 涓競宸� 2025 骞寸疮璁″钩鍧囪繍璺濓紙鍘诲勾鍚屾湡鍩烘暟锛� | 涓庣敤鎴锋枃浠� M 鍒楅�愯涓�鑷� | 17/17 涓�鑷� | 閫氳繃 |
+| TC05 | 姝ｅ悜 | 17 涓競宸炵疮璁¤繍璺濆悓姣� | 涓庣敤鎴锋枃浠� N 鍒楅�愯涓�鑷� | 17/17 涓�鑷达紙鍏ㄧ渷琛岄櫎澶栵紝瑙� TC10锛� | 閫氳繃 |
+| TC06 | 姝ｅ悜 | 鏄庣粏椤� 545 琛屾眰鍜� = 姹囨�婚〉鍏ㄧ渷琛� | 宸紓 0 | 璐ц繍閲� 27752.6820銆佸懆杞噺 4389882.0468锛屽樊寮� 0 | 閫氳繃 |
+| TC07 | 姝ｅ悜 | 鍏ㄧ渷琛� = 危17 甯傚窞 | 閫愰」鐩哥瓑 | 鐩哥瓑锛堝厛姹傜疮璁″懆杞噺銆佺疮璁¤揣杩愰噺鍐嶇浉闄わ級 | 閫氳繃 |
+| TC08 | 杈圭晫 | 浠欐甯� 2026 骞� 2 瀹舵寔缁湪瑙勪紒涓氭棤 2025 骞磋繛缁笂鎶ヨ褰� | 鍚屾瘮鐣欑┖骞舵敞鏄庝笉閫傜敤锛屼笉闄ら浂鎶ラ敊 | 浼佷笟鏁� 0銆佽繍璺濅笌鍚屾瘮鐣欑┖锛屽娉ㄣ�屽悓姣斾笉閫傜敤銆� | 閫氳繃 |
+| TC09 | 杈圭晫 | 绱璐ц繍閲忎负 0 鐨勪紒涓� | 绱杩愯窛鐣欑┖锛屼笉闄ら浂鎶ラ敊 | 宸查獙璇侊紙琛ㄥ唴鏃犳绫讳紒涓氾級 | 閫氳繃 |
+| TC10 | 璐熷悜 | 鐢ㄦ埛鏂囦欢鍏ㄧ渷琛屽悓姣� +7.8217% | 搴斾笌甯傚窞琛屽悓涓� 1-8 鏈堢疮璁″彛寰� | 璇ュ�煎疄涓� 545 瀹� **8 鏈堝綋鏈�**鍚屾瘮锛�157.0007 梅 145.6114 鈭� 1 = +7.8217%锛夛紱绱鍙ｅ緞搴斾负 +2.8961%锛屼袱鑰呯浉宸� 4.93 涓櫨鍒嗙偣 | 閫氳繃锛堥棶棰樺凡鍦ㄤ氦浠樹欢涓慨姝ｏ紝骞跺湪琛ㄥ唴娉ㄦ槑鍙ｅ緞锛� |
+| TC11 | 杈圭晫 | 姝︽眽鐭冲寲浜ら�氳繍杈撴湁闄愬叕鍙搞�佹箹鍖楁嵎榫欎氦閫氳繍涓氭湁闄愬叕鍙� 2026 骞� 1 鏈堝湴鍖虹爜涓� 420100銆佸叾鍚庝负 420107/420103 | 鍚屽睘姝︽眽甯傦紝褰掗泦涓嶅奖鍝� | 鍧囪鍏ユ姹� | 閫氳繃 |
+
+## 鍥涖�佸彂鐜扮殑闂涓庡缃�
+
+1. **鐢ㄦ埛鏂囦欢鍏ㄧ渷琛屽悓姣斿彛寰勬贩鐢紙宸茬粰鍑烘纭�硷級**锛歚璐ц繍浼佷笟鍒嗗競宸炴儏鍐祒lsx.xlsx` 鐨� N4 鍗曞厓鏍煎～鐨勬槸 545 瀹� **8 鏈堝綋鏈�**杩愯窛鍚屾瘮
+   锛�+7.8217%锛夛紝鑰屽叾涓� 17 涓競宸炶閮芥槸 **1-8 鏈堢疮璁�**鍚屾瘮銆傛湰琛ㄦ寜绱鍙ｅ緞缁欏嚭鍏ㄧ渷 **+2.8961%**銆�
+2. **M 鍒楁湭鏍囧勾浠�**锛氳鍒楄〃鏍煎�煎疄涓� 2025 骞达紙鍘诲勾鍚屾湡锛夌疮璁″钩鍧囪繍璺濓紝琛ㄥご銆�1-8鏈堝钩鍧囪繍璺濄�嶆槗璇涓轰粖骞达紱
+   鏈〃灏� 2025銆�2026 涓ゅ勾鍒嗗垪锛屾秷闄ゆ涔夈��
+3. **浠欐甯傛棤鍙瘮鍩烘暟**锛�2026 骞存寔缁湪瑙勭殑 2 瀹朵紒涓� 2025 骞存棤杩炵画涓婃姤璁板綍锛屽悓姣斾笉閫傜敤锛堜笉鏄己鏁帮級锛屽凡鍦ㄨ〃鍐呮敞鏄庛��
+
+## 浜斻�佺粨璁�
+
+11 鏉＄敤渚嬶紙7 姝ｅ悜 / 3 杈圭晫 / 1 璐熷悜锛夊叏閮ㄩ�氳繃锛�17 涓競宸炰笌鐢ㄦ埛鐜版湁琛ㄦ牸閫愯涓�鑷达紝鍏ㄧ渷琛屾洿姝ｄ负绱鍙ｅ緞 +2.90%锛�
+鏄庣粏 545 琛屼笌姹囨�婚�愰」瀵硅处 0 宸紓銆備氦浠樹欢宸茬敓鎴愬埌 `D:\妗岄潰\璐ц繍浼佷笟鍒嗗競宸炴儏鍐礬`銆�
diff --git "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-19.md" "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-19.md"
new file mode 100644
index 0000000..a7a7385
--- /dev/null
+++ "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-19.md"
@@ -0,0 +1,77 @@
+# 宸ヤ綔鏃ョ粨_2026-09-19
+
+## 涓�銆佷粖澶╁仛浜嗕粈涔�
+
+### 1. 鎸佺画鍦ㄨ浼佷笟锛�545 瀹讹級鍒嗗競宸� 1-8 鏈堢疮璁¤繍璺濆悓姣旓紙妗岄潰浜や粯锛�
+
+鐢ㄦ埛 09-18 纭銆屾寔缁湪瑙勪紒涓氥��= **2025 骞� 1-8 鏈堜笌 2026 骞� 1-8 鏈堝潎杩炵画 8 涓湀涓婃姤**锛�545 瀹讹級锛�
+瑕佹眰鎶婅鍙ｅ緞涓嬬殑鍒嗗競宸炵疮璁¤繍璺濆悓姣旂畻鍑烘潵骞惰緭鍑哄埌 `D:\妗岄潰\璐ц繍浼佷笟鍒嗗競宸炴儏鍐礬`銆�
+
+- 鏁版嵁婧愶細`traffic_audit.h2032_enterprise_monthly`锛�2025-01 ~ 2026-08锛夈��
+- 鍙ｅ緞锛氱疮璁″钩鍧囪繍璺� = 1-8 鏈堢疮璁″懆杞噺 梅 绱璐ц繍閲忥紱鍚屾瘮 = 浠婂勾绱 梅 鍘诲勾鍚屾湡绱 鈭� 1锛涘叏鐪� = 危17 甯傚窞銆�
+- 浜у嚭锛歚鎸佺画鍦ㄨ浼佷笟545瀹禵鍒嗗競宸�1-8鏈堢疮璁¤繍璺濆強鍚屾瘮_2026-09-19.xlsx`锛坄甯傚窞姹囨�籤 + `浼佷笟鏄庣粏(545瀹�)`锛夛紝
+  鑴氭湰 `docs\宸ュ叿\鎸佺画鍦ㄨ浼佷笟545瀹剁疮璁¤繍璺濈敓鎴�.py`銆�
+
+鍏抽敭缁撴灉锛�
+
+| 甯傚窞 | 2026骞�1-8鏈堢疮璁¤繍璺�(鍏噷) | 2025骞村悓鏈�(鍏噷) | 鍚屾瘮 | 甯傚窞 | 2026骞�1-8鏈堢疮璁¤繍璺�(鍏噷) | 2025骞村悓鏈�(鍏噷) | 鍚屾瘮 |
+| --- | --- | --- | --- | --- | --- | --- | --- |
+| **鍏ㄧ渷** | **158.18** | **153.73** | **+2.90%** | 榛勫唸 | 138.73 | 137.16 | +1.15% |
+| 姝︽眽 | 159.66 | 140.71 | +13.47% | 鍜稿畞 | 115.25 | 151.84 | 鈭�24.10% |
+| 榛勭煶 | 112.67 | 93.75 | +20.18% | 闅忓窞 | 187.28 | 226.03 | 鈭�17.14% |
+| 鍗佸牥 | 321.13 | 330.78 | 鈭�2.92% | 鎭╂柦宸� | 141.78 | 128.56 | +10.28% |
+| 瀹滄槍 | 85.75 | 83.61 | +2.57% | 浠欐 | 鈥� | 鈥� | 涓嶉�傜敤 |
+| 瑗勯槼 | 279.65 | 258.01 | +8.39% | 娼滄睙 | 407.97 | 367.73 | +10.94% |
+| 閯傚窞 | 42.38 | 103.49 | 鈭�59.05% | 澶╅棬 | 61.02 | 134.33 | 鈭�54.57% |
+| 鑽嗛棬 | 305.92 | 321.00 | 鈭�4.70% | 绁炲啘鏋舵灄鍖� | 57.68 | 113.39 | 鈭�49.13% |
+| 瀛濇劅 | 183.86 | 198.51 | 鈭�7.38% | | | | |
+| 鑽嗗窞 | 321.44 | 337.36 | 鈭�4.72% | | | | |
+
+### 2. 鏍稿鐢ㄦ埛渚с�婅揣杩愪紒涓氬垎甯傚窞鎯呭喌銆嬭〃
+
+- 璇ヨ〃 M/N 涓ゅ垪锛堟寔缁湪瑙勪紒涓氾級涓庢湰娆� 545 瀹跺彛寰�**閫愯涓�鑷�**锛圡 = 鍘诲勾鍚屾湡鍩烘暟锛孨 = 绱鍚屾瘮锛夈��
+- 鍙戠幇涓�澶勫彛寰勬贩鐢細**鍏ㄧ渷琛� N4 濉殑鏄� 8 鏈堝綋鏈堝悓姣� +7.8217%**锛�157.0007 梅 145.6114 鈭� 1锛夛紝
+  鍏朵綑 17 琛屽潎涓� 1-8 鏈堢疮璁″悓姣旓紱绱鍙ｅ緞搴斾负 **+2.90%**锛�158.18 梅 153.73 鈭� 1锛夛紝鐩稿樊 4.93 涓櫨鍒嗙偣銆�
+- 琛ㄥご銆�1-8鏈堝钩鍧囪繍璺濄�嶆湭鏍囧勾浠斤紝瀹為檯涓� 2025 骞村�硷紝宸插湪鏈浜や粯浠朵腑鍒嗗垪涓ゅ勾娑堥櫎姝т箟銆�
+- 璇ヨ〃 O 鍒椼��1-8鏈堥珮閫熻繍璺濆悓姣斻�嶄笌鎵嬪ご楂橀�熸暟鎹紙`杩愯窛鍒嗘瀽鎶ュ憡\杩愯窛鍒嗘瀽鏁版嵁姹囨��.xlsx`锛夌畻寰楃殑鍏ㄧ渷 鈭�5.94% 涓嶄竴鑷�
+  锛堝競宸炲樊寮傛洿澶э級锛屾潵婧愪笌鏈熼棿寰呯敤鎴风‘璁わ紱鎸夌敤鎴疯姹傛湰杞笉澶勭悊楂橀�熷垪銆�
+
+### 3. 鍚屽悕浼佷笟鍙ｅ緞 1-8 鏈堢疮璁¤揣杩愰噺/鍛ㄨ浆閲� SQL 鏌ヨ鑴氭湰锛堟湰娆℃柊澧烇級
+
+鐢ㄦ埛鎻愰棶锛�25 骞翠笌 26 骞翠紒涓氭暟涓嶅悓锛岃銆屼紒涓氬悕绉扮浉鍚屻�嶅湴鍒嗗埆姹囨�� 1-8 鏈堢疮璁＄殑
+璐х墿鍛ㄨ浆閲忓拰璐ц繍閲忥紝SQL 鎬庝箞鍐欍��
+
+- 浜や粯鑴氭湰锛歚docs\鐢熸垚姹囨�诲ぇ琛╘鍚屽悕浼佷笟_1-8鏈堢疮璁″姣擾2026-09-19.sql`锛�6 鏉℃煡璇紝鍏ㄤ腑鏂囨敞閲婏級銆�
+- 鍙ｅ緞锛氫紒涓氬悕绉板彇涓ゅ勾 1-8 鏈堢殑浜ら泦锛屼笌鐧藉ぉ纭鐨勩�屾寔缁湪瑙勪紒涓� 545 瀹躲�嶅畬鍏ㄤ竴鑷达紱
+  鍗曚綅缁熶竴 梅10000 杈撳嚭銆屼竾鍚� / 涓囧惃鍏噷銆嶃��
+- 缁撴灉锛�
+
+| 鍙ｅ緞 | 浼佷笟鏁� | 璐ц繍閲�2025(涓囧惃) | 璐ц繍閲�2026(涓囧惃) | 璐ц繍閲忓悓姣� | 鍛ㄨ浆閲�2025(涓囧惃鍏噷) | 鍛ㄨ浆閲�2026(涓囧惃鍏噷) | 鍛ㄨ浆閲忓悓姣� |
+| --- | --- | --- | --- | --- | --- | --- | --- |
+| 鍚屽悕浼佷笟 | 545 | 30153.14 | 27752.68 | 鈭�7.96% | 4635340.46 | 4389882.05 | 鈭�5.30% |
+| 鍏ㄩ噺 | 664 / 636 | 33994.45 | 31399.82 | 鈥� | 5102518.95 | 4927161.77 | 鈥� |
+
+鍚屽悕鍙ｅ緞鐨� 2026 骞寸疮璁℃暟涓庣櫧澶╀氦浠樹欢鍏ㄧ渷琛岋紙27752.6820 涓囧惃 / 4389882.0468 涓囧惃鍏噷锛夊畬鍏ㄤ竴鑷达紝涓ゆ潯閾捐矾浜掕瘉閫氳繃銆�
+鍏ㄩ噺涓庡悓鍚嶅彛寰勭殑宸涔熷凡绠楁竻锛�2026 骞存柊杩� 91 瀹讹紙+3647.14 涓囧惃 / +537279.73 涓囧惃鍏噷锛夛紝
+2025 骞撮��鍑� 119 瀹讹紙鈭�3841.31 涓囧惃 / 鈭�467178.48 涓囧惃鍏噷锛夈��
+## 浜屻�佹祴璇曠粨鏋滄憳瑕�
+
+瑙併�婂姛鑳芥祴璇曟姤鍛奯鎸佺画鍦ㄨ浼佷笟545瀹跺垎甯傚窞绱杩愯窛鍚屾瘮_2026-09-19.md銆嬶細11 鏉＄敤渚嬶紙7 姝ｅ悜 / 3 杈圭晫 / 1 璐熷悜锛夊叏閮ㄩ�氳繃銆�
+
+- 鏄庣粏 545 琛屾眰鍜� = 姹囨�婚〉鍏ㄧ渷琛岋紙27752.6820 涓囧惃 / 4389882.0468 涓囧惃鍏噷锛屽樊寮� 0锛夛紱
+- 鍏ㄧ渷琛� = 危17 甯傚窞锛�17 涓競宸炰笌鐢ㄦ埛琛ㄦ牸閫愯涓�鑷达紱
+- 浠欐甯傛棤鍙瘮鍩烘暟銆佺疮璁¤揣杩愰噺涓� 0 鐨勪紒涓氬潎宸查槻闄ら浂澶勭悊銆�
+
+- 鍚屽悕浼佷笟鍙ｅ緞 SQL 鑴氭湰宸叉暣鑴氭湰鎵ц楠岃瘉锛�12 鏉＄敤渚嬶紙8 姝ｅ悜 / 2 璐熷悜 / 2 杈圭晫锛夊叏閮ㄩ�氳繃锛�
+  鏄庣粏 545 琛屾眰鍜� = 姹囨�昏锛堝樊寮� 0锛夛紝宸紓浼佷笟闂悎鏍￠獙閫氳繃銆�
+## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙
+
+1. 鐢ㄦ埛琛ㄦ牸 O 鍒楅珮閫熻繍璺濆悓姣旂殑鏉ユ簮/鏈熼棿寰呯‘璁わ紙闇�涓� N 鍚屼负 1-8 鏈堢疮璁★級锛岀‘璁ゅ悗鏂瑰彲绠椼�岃繍璺濆閫熷樊銆嶃��
+2. 09-18 浜や粯鐨勩�婅揣杩愭湀鎶鎸佺画鍦ㄨ浼佷笟_鍒嗗競宸�1-8鏈堢疮璁¤繍璺濆強鍚屾瘮銆嬮噰鐢�**瀹樻柟鍏ㄥ彛寰�**锛堝悓姣� +4.54%锛夛紱
+   鏈〃閲囩敤**涓ゅ勾鎸佺画鍦ㄨ 545 瀹跺彛寰�**锛堝悓姣� +2.90%锛夛紝涓ょ増鍙ｅ緞涓嶅悓浣嗛兘宸叉敞鏄庯紝渚涗笟鍔℃寜鍦烘櫙閫夌敤銆�
+3. 鑻ヨ琛ㄨ闅忋�婂樊寮傜巼姹囨�昏〃銆嬩笂鎶ワ紝寤鸿鍔犳敞涓ょ鍙ｅ緞鐨勫樊寮傚師鍥狅紙瑙勪笂浼佷笟鍚嶅崟鍙樺姩锛夈��
+
+## 鍥涖�佹槑澶╄鍒�
+
+1. 瑙嗙敤鎴峰弽棣堢‘瀹氫笂鎶ュ彛寰勶紙545 瀹� vs 鍏ㄥ彛寰勶級锛屽繀瑕佹椂鍚堝苟鎴愪竴鐗堝弻鍙ｅ緞琛ㄣ��
+2. 楂橀�熸暟鎹潵婧愮‘璁ゅ悗琛ョ畻銆岃繍璺濆閫熷樊銆嶃��
diff --git "a/docs/\345\267\245\345\205\267/\346\214\201\347\273\255\345\234\250\350\247\204\344\274\201\344\270\232545\345\256\266\347\264\257\350\256\241\350\277\220\350\267\235\347\224\237\346\210\220.py" "b/docs/\345\267\245\345\205\267/\346\214\201\347\273\255\345\234\250\350\247\204\344\274\201\344\270\232545\345\256\266\347\264\257\350\256\241\350\277\220\350\267\235\347\224\237\346\210\220.py"
new file mode 100644
index 0000000..25b792d
--- /dev/null
+++ "b/docs/\345\267\245\345\205\267/\346\214\201\347\273\255\345\234\250\350\247\204\344\274\201\344\270\232545\345\256\266\347\264\257\350\256\241\350\277\220\350\267\235\347\224\237\346\210\220.py"
@@ -0,0 +1,174 @@
+# -*- coding: utf-8 -*-
+"""鎸佺画鍦ㄨ浼佷笟锛�545 瀹讹級鍒嗗競宸� 1-8 鏈堢疮璁″钩鍧囪繍璺濆強鍚屾瘮 鍙拌处
+
+鍙ｅ緞锛�
+  路 鎸佺画鍦ㄨ浼佷笟 = 2025 骞� 1-8 鏈堜笌 2026 骞� 1-8 鏈堝潎杩炵画 8 涓湀涓婃姤 H203-2 鏈堟姤鐨勪紒涓氾紙545 瀹讹級锛�
+  路 绱骞冲潎杩愯窛锛堝叕閲岋級= 1-8 鏈堢疮璁¤揣鐗╁懆杞噺 梅 1-8 鏈堢疮璁¤揣杩愰噺锛堝姞鏉冨钩鍧囷級锛�
+  路 鍚屾瘮 = 2026 骞� 1-8 鏈堢疮璁″钩鍧囪繍璺� 梅 2025 骞� 1-8 鏈堢疮璁″钩鍧囪繍璺� 鈭� 1銆�
+鏁版嵁婧愶細traffic_audit.h2032_enterprise_monthly 瀵煎嚭浠� _tmp_persist_scope.tsv
+"""
+import io, os
+from openpyxl import Workbook
+from openpyxl.styles import Font, PatternFill, Alignment, Border, Side
+from openpyxl.utils import get_column_letter
+
+SRC = r'D:\鏂囨。\ChatGPT\traffic-audit\_tmp_persist_scope.tsv'
+OUT = r'D:\鏂囨。\ChatGPT\traffic-audit\outputs\鎸佺画鍦ㄨ浼佷笟545瀹禵鍒嗗競宸�1-8鏈堢疮璁¤繍璺濆強鍚屾瘮_2026-09-19.xlsx'
+
+ORDER = ['姝︽眽甯�', '榛勭煶甯�', '鍗佸牥甯�', '瀹滄槍甯�', '瑗勯槼甯�', '閯傚窞甯�', '鑽嗛棬甯�', '瀛濇劅甯�', '鑽嗗窞甯�',
+         '榛勫唸甯�', '鍜稿畞甯�', '闅忓窞甯�', '鎭╂柦宸�', '浠欐甯�', '娼滄睙甯�', '澶╅棬甯�', '绁炲啘鏋舵灄鍖�']
+SHORT = {'姝︽眽甯�': '姝︽眽', '榛勭煶甯�': '榛勭煶', '鍗佸牥甯�': '鍗佸牥', '瀹滄槍甯�': '瀹滄槍', '瑗勯槼甯�': '瑗勯槼', '閯傚窞甯�': '閯傚窞',
+         '鑽嗛棬甯�': '鑽嗛棬', '瀛濇劅甯�': '瀛濇劅', '鑽嗗窞甯�': '鑽嗗窞', '榛勫唸甯�': '榛勫唸', '鍜稿畞甯�': '鍜稿畞', '闅忓窞甯�': '闅忓窞',
+         '鎭╂柦宸�': '鎭╂柦宸�', '浠欐甯�': '浠欐', '娼滄睙甯�': '娼滄睙', '澶╅棬甯�': '澶╅棬', '绁炲啘鏋舵灄鍖�': '鏋楀尯'}
+CITY = dict(zip(['4201', '4202', '4203', '4205', '4206', '4207', '4208', '4209', '4210', '4211', '4212', '4213', '4228'],
+                ORDER[:13]))
+CITY.update({'429004': '浠欐甯�', '429005': '娼滄睙甯�', '429006': '澶╅棬甯�', '429021': '绁炲啘鏋舵灄鍖�'})
+
+
+def city_of(rc):
+    rc = (rc or '').strip()
+    return CITY.get(rc, CITY.get(rc[:4], '?'))
+
+
+def dv(f, t):
+    return (t / f) if f else None
+
+
+def gth(a, b):
+    return (a / b - 1) if (a is not None and b) else None
+
+
+def num(x):
+    try:
+        return float(x)
+    except Exception:
+        return 0.0
+
+
+rows = []
+with io.open(SRC, 'r', encoding='utf-8') as fh:
+    hdr = fh.readline().rstrip('\r\n').split('\t')
+    for line in fh:
+        p = line.rstrip('\r\n').split('\t')
+        if len(p) < len(hdr):
+            continue
+        d = dict(zip(hdr, p))
+        if int(num(d['m26'])) != 8 or int(num(d['m25'])) != 8:
+            continue
+        rows.append(dict(city=city_of(d['rc']), en=d['en'], ec=d['ec'], ucc=d['ucc'],
+                         f26=num(d['f26']), t26=num(d['t26']), f25=num(d['f25']), t25=num(d['t25'])))
+
+by_city = {}
+for r in rows:
+    c = by_city.setdefault(r['city'], dict(n=0, f26=0.0, t26=0.0, f25=0.0, t25=0.0))
+    c['n'] += 1
+    c['f26'] += r['f26']; c['t26'] += r['t26']; c['f25'] += r['f25']; c['t25'] += r['t25']
+tot = dict(n=0, f26=0.0, t26=0.0, f25=0.0, t25=0.0)
+for c in by_city.values():
+    for k in tot:
+        tot[k] += c[k]
+
+THIN = Side(style='thin', color='BFBFBF')
+BORDER = Border(left=THIN, right=THIN, top=THIN, bottom=THIN)
+HDR_FILL = PatternFill('solid', fgColor='DDEBF7')
+TOT_FILL = PatternFill('solid', fgColor='FFF2CC')
+TITLE_FILL = PatternFill('solid', fgColor='1F4E79')
+CT = Alignment(horizontal='center', vertical='center', wrap_text=True)
+LT = Alignment(horizontal='left', vertical='center', wrap_text=True)
+RT = Alignment(horizontal='right', vertical='center')
+NF2, NFP = '#,##0.00', '0.00%'
+
+wb = Workbook()
+ws = wb.active
+ws.title = '甯傚窞姹囨��'
+heads = ['甯傚窞', '鎸佺画鍦ㄨ浼佷笟鏁�(瀹�)', '2026骞�1-8鏈堢疮璁¤揣杩愰噺(涓囧惃)', '2026骞�1-8鏈堢疮璁¤揣鐗╁懆杞噺(涓囧惃鍏噷)',
+         '2026骞�1-8鏈堢疮璁″钩鍧囪繍璺�(鍏噷)', '2025骞�1-8鏈堢疮璁″钩鍧囪繍璺�(鍏噷)', '绱杩愯窛鍚屾瘮(%)', '澶囨敞']
+widths = [12, 16, 22, 26, 22, 22, 14, 46]
+ws.cell(1, 1, '鎸佺画鍦ㄨ浼佷笟锛�545 瀹讹級鍒嗗競宸� 1-8 鏈堢疮璁″钩鍧囪繍璺濆強鍚屾瘮').font = Font(bold=True, size=14, color='FFFFFF')
+ws.cell(1, 1).fill = TITLE_FILL
+ws.cell(1, 1).alignment = Alignment(horizontal='center', vertical='center')
+ws.merge_cells(start_row=1, start_column=1, end_row=1, end_column=len(heads))
+ws.row_dimensions[1].height = 28
+notes = [
+    '鍙ｅ緞璇存槑锛�',
+    '鈶� 鎸佺画鍦ㄨ浼佷笟 = 2025 骞� 1-8 鏈堜笌 2026 骞� 1-8 鏈堝潎杩炵画 8 涓湀涓婃姤銆婇亾璺揣鐗╄繍杈撴湀搴︾敓浜ф儏鍐点�嬶紙H203-2锛夋湀鎶ョ殑浼佷笟锛屽叡 %d 瀹讹紱涓ゅ勾闂存柊杩涖�侀��鍑虹殑浼佷笟涓嶈鍏ユ湰琛ㄥ悓姣斻��' % tot['n'],
+    '鈶� 绱骞冲潎杩愯窛锛堝叕閲岋級= 1-8 鏈堢疮璁¤揣鐗╁懆杞噺 梅 1-8 鏈堢疮璁¤揣杩愰噺锛堝姞鏉冨钩鍧囷級锛涘悓姣� = 2026 骞� 1-8 鏈堢疮璁″钩鍧囪繍璺� 梅 2025 骞� 1-8 鏈堢疮璁″钩鍧囪繍璺� 鈭� 1銆�',
+    '鈶� 鍏ㄧ渷琛� = 17 涓競宸炰箣鍜岋紙鎸夌疮璁″懆杞噺銆佺疮璁¤揣杩愰噺鍒嗗埆姹傚拰鍚庣浉闄わ紝涓嶆槸甯傚窞鍚屾瘮鐨勭畻鏈钩鍧囷級銆�',
+    '鈶� 浠欐甯� 2026 骞存寔缁湪瑙勭殑 2 瀹朵紒涓� 2025 骞� 1-8 鏈堟棤杩炵画涓婃姤璁板綍锛屾湰琛ㄦ棤鍙瘮鍩烘暟锛屽悓姣斾笉閫傜敤銆�',
+    '鏁版嵁鏉ユ簮锛氫氦閫氱粺璁℃姤琛ㄥ鏍哥郴缁熸暟鎹簱锛圚203-2 浼佷笟鏈堟姤锛�2025 骞� 1 鏈堚��2026 骞� 8 鏈堬級銆傜敓鎴愭棩鏈燂細2026-09-19銆�',
+]
+r = 2
+for i, t in enumerate(notes):
+    c = ws.cell(r, 1, t)
+    c.font = Font(size=9, bold=(i == 0), color='404040')
+    c.alignment = LT
+    ws.merge_cells(start_row=r, start_column=1, end_row=r, end_column=len(heads))
+    r += 1
+hdr_row = r
+for j, h in enumerate(heads, 1):
+    c = ws.cell(hdr_row, j, h)
+    c.font = Font(bold=True); c.fill = HDR_FILL; c.alignment = CT; c.border = BORDER
+    ws.column_dimensions[get_column_letter(j)].width = widths[j - 1]
+ws.row_dimensions[hdr_row].height = 42
+
+
+def put(row, vals, fill=None, bold=False):
+    for j, v in enumerate(vals, 1):
+        c = ws.cell(row, j, v)
+        c.border = BORDER
+        c.alignment = LT if j == 8 else (CT if j == 1 else RT)
+        if j in (3, 4, 5, 6):
+            c.number_format = NF2
+        elif j == 7:
+            c.number_format = NFP
+        if fill:
+            c.fill = fill
+        if bold:
+            c.font = Font(bold=True)
+
+
+rr = hdr_row
+d26 = dv(tot['f26'], tot['t26']); d25 = dv(tot['f25'], tot['t25'])
+rr += 1
+put(rr, ['鍏ㄧ渷', tot['n'], tot['f26'] / 10000.0, tot['t26'] / 10000.0, d26, d25, gth(d26, d25), ''], TOT_FILL, True)
+for city in ORDER:
+    c = by_city.get(city)
+    rr += 1
+    if not c or c['n'] == 0:
+        put(rr, [SHORT[city], 0, None, None, None, None, None,
+                 '璇ュ競宸� 2026 骞存寔缁湪瑙勪紒涓氬湪 2025 骞� 1-8 鏈堟棤杩炵画涓婃姤璁板綍锛屽悓姣斾笉閫傜敤'])
+        continue
+    a, b = dv(c['f26'], c['t26']), dv(c['f25'], c['t25'])
+    put(rr, [SHORT[city], c['n'], c['f26'] / 10000.0, c['t26'] / 10000.0, a, b, gth(a, b), ''])
+ws.freeze_panes = ws.cell(hdr_row + 1, 2).coordinate
+
+# 浼佷笟鏄庣粏
+ws2 = wb.create_sheet('浼佷笟鏄庣粏(545瀹�)')
+h2 = ['搴忓彿', '甯傚窞', '浼佷笟鍚嶇О', '缁熶竴绀句細淇＄敤浠ｇ爜', '2026骞�1-8鏈堣揣杩愰噺(涓囧惃)', '2026骞�1-8鏈堝懆杞噺(涓囧惃鍏噷)',
+      '2026骞�1-8鏈堢疮璁″钩鍧囪繍璺�(鍏噷)', '2025骞�1-8鏈堢疮璁″钩鍧囪繍璺�(鍏噷)', '绱杩愯窛鍚屾瘮(%)']
+w2 = [6, 12, 42, 24, 20, 24, 22, 22, 14]
+for j, h in enumerate(h2, 1):
+    c = ws2.cell(1, j, h)
+    c.font = Font(bold=True); c.fill = HDR_FILL; c.alignment = CT; c.border = BORDER
+    ws2.column_dimensions[get_column_letter(j)].width = w2[j - 1]
+ws2.row_dimensions[1].height = 40
+order = {c: i for i, c in enumerate(ORDER)}
+idx = 0
+for i, x in enumerate(sorted(rows, key=lambda z: (order.get(z['city'], 99), -z['t26'])), 1):
+    a, b = dv(x['f26'], x['t26']), dv(x['f25'], x['t25'])
+    vals = [i, SHORT[x['city']], x['en'], x['ucc'], x['f26'] / 10000.0, x['t26'] / 10000.0, a, b, gth(a, b)]
+    for j, v in enumerate(vals, 1):
+        c = ws2.cell(i + 1, j, v)
+        c.border = BORDER
+        c.alignment = LT if j in (3, 4) else (CT if j in (1, 2) else RT)
+        if j in (5, 6, 7, 8):
+            c.number_format = NF2
+        elif j == 9:
+            c.number_format = NFP
+ws2.freeze_panes = 'C2'
+ws2.auto_filter.ref = 'A1:I%d' % (len(rows) + 1)
+
+os.makedirs(os.path.dirname(OUT), exist_ok=True)
+wb.save(OUT)
+print('OK ->', OUT)
+print('浼佷笟鏁� %d锛涘叏鐪� 2026 %.4f / 2025 %.4f -> %.4f%%' % (tot['n'], d26, d25, gth(d26, d25) * 100))
diff --git "a/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql" "b/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql"
new file mode 100644
index 0000000..48d4700
--- /dev/null
+++ "b/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql"
@@ -0,0 +1,201 @@
+-- ============================================================
+-- 2025 / 2026 骞� 1-8 鏈堢疮璁� 璐ц繍閲忋�佽揣鐗╁懆杞噺 姹囨�伙紙鍚屽悕浼佷笟鍙ｅ緞锛�
+-- 鐢熸垚鏃ユ湡锛�2026-09-19   鏁版嵁搴擄細traffic_audit锛圡ySQL 8.0.29锛�
+-- ------------------------------------------------------------
+-- 鏁版嵁鏉ユ簮琛細h2032_enterprise_monthly
+--   銆婇亾璺揣鐗╄繍杈撴湀搴︾敓浜ф儏鍐佃〃銆�= 浜や紒缁烪203-2琛紝浼佷笟绾ф湀鎶ワ紙瑙勪笂浼佷笟锛�
+--   瀛楁锛歠reight_total   璐ц繍閲廮鎬昏锛堝惃锛�
+--         turnover_total  璐х墿鍛ㄨ浆閲廮鎬昏锛堝惃鍏噷锛�
+--         report_period   鎶ヨ〃鏈燂紝鏍煎紡 'YYYY-MM'
+--         enterprise_name 浼佷笟鍚嶇О
+-- 鍗曚綅鎹㈢畻锛氳〃鍐呭瓨鐨勬槸銆屽惃 / 鍚ㄥ叕閲屻�嶏紝鎶ヨ〃鍙ｅ緞鏄�屼竾鍚� / 涓囧惃鍏噷銆嶏紝
+--          鎵�浠ヤ笅闈㈢粺涓� 梅10000銆�
+-- 鏈熼棿鍙栨硶锛�1-8 鏈� = report_period BETWEEN '2025-01' AND '2025-08'
+--          锛坮eport_period 鏄瓧绗︿覆 'YYYY-MM'锛岀洿鎺ユ瘮澶у皬鍗冲彲锛�
+-- 涓轰粈涔堣銆屽悓鍚嶄紒涓氬彛寰勩�嶏細
+--   2025 骞� 1-8 鏈堟湁 664 瀹朵紒涓氥��2026 骞� 1-8 鏈堝彧鏈� 636 瀹讹紝
+--   鐩存帴鎷夸袱骞存�绘暟鐩稿噺锛屽樊棰濋噷娣风潃銆屼紒涓氭暟閲忓彉浜嗐�嶇殑褰卞搷锛屼笉鏄湡瀹炲鍑忋��
+--   鎶婁袱骞撮兘鎶ラ�佽繃鐨勪紒涓氬悕绉板彇浜ら泦锛堝疄娴� 545 瀹讹級锛屼袱骞寸殑浼佷笟鑼冨洿鎵嶄竴鑷淬��
+-- 瀹炴祴缁撴灉锛堝悓鍚嶄紒涓氬彛寰� 545 瀹讹級锛�
+--   2025 骞� 1-8 鏈堬細璐ц繍閲� 30153.14 涓囧惃锛屽懆杞噺 4635340.46 涓囧惃鍏噷
+--   2026 骞� 1-8 鏈堬細璐ц繍閲� 27752.68 涓囧惃锛屽懆杞噺 4389882.05 涓囧惃鍏噷
+--   鍚屾瘮锛氳揣杩愰噺 -7.96%锛屽懆杞噺 -5.30%
+-- ============================================================
+
+
+-- =====================================================================
+-- 鏌ヨ 1锛氭眹鎬讳竴琛� 鈥斺�� 鍚屽悕浼佷笟鍙ｅ緞鐨勪袱骞寸疮璁℃暟 + 鍚屾瘮澧為��
+-- =====================================================================
+SELECT COUNT(DISTINCT e.enterprise_name)                                   AS 浼佷笟鏁�,
+       ROUND(SUM(CASE WHEN e.report_period <= '2025-08'
+                      THEN e.freight_total  ELSE 0 END) / 10000, 2)        AS 璐ц繍閲�2025_涓囧惃,
+       ROUND(SUM(CASE WHEN e.report_period >= '2026-01'
+                      THEN e.freight_total  ELSE 0 END) / 10000, 2)        AS 璐ц繍閲�2026_涓囧惃,
+       ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
+            / NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END), 0) - 1) * 100, 2)
+                                                                           AS 璐ц繍閲忓悓姣擾鐧惧垎姣�,
+       ROUND(SUM(CASE WHEN e.report_period <= '2025-08'
+                      THEN e.turnover_total ELSE 0 END) / 10000, 2)        AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+       ROUND(SUM(CASE WHEN e.report_period >= '2026-01'
+                      THEN e.turnover_total ELSE 0 END) / 10000, 2)        AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷,
+       ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
+            / NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END), 0) - 1) * 100, 2)
+                                                                           AS 鍛ㄨ浆閲忓悓姣擾鐧惧垎姣�
+FROM h2032_enterprise_monthly e
+-- 涓嬮潰涓や釜 JOIN锛氬彧瑕佷袱骞� 1-8 鏈堥兘鎶ラ�佽繃鐨勪紒涓氾紙鍚屽悕浼佷笟鍙ｅ緞鐨勬牳蹇冿級
+JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+       WHERE report_period BETWEEN '2025-01' AND '2025-08') a
+  ON a.enterprise_name = e.enterprise_name
+JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+       WHERE report_period BETWEEN '2026-01' AND '2026-08') b
+  ON b.enterprise_name = e.enterprise_name
+WHERE e.report_period BETWEEN '2025-01' AND '2026-08';
+
+
+-- =====================================================================
+-- 鏌ヨ 2锛氶�愪紒涓氬鐓ф槑缁嗭紙鍚屽悕浼佷笟锛屼袱骞村苟鎺掞級锛屽彲鐩存帴瀵煎嚭 Excel
+--   鎸� 2026 骞磋揣杩愰噺浠庡ぇ鍒板皬鎺掞紱鍘绘帀 ORDER BY 灏辨槸瀹屾暣 545 琛屻��
+-- =====================================================================
+SELECT e.enterprise_name                                                   AS 浼佷笟鍚嶇О,
+       MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END)  AS 鍦板尯浠ｇ爜,
+       ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total  ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2025_涓囧惃,
+       ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total  ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2026_涓囧惃,
+       ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
+            - SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END)) / 10000, 2) AS 璐ц繍閲忓鍑廮涓囧惃,
+       ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
+            / NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END), 0) - 1) * 100, 2) AS 璐ц繍閲忓悓姣擾鐧惧垎姣�,
+       ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+       ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷,
+       ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
+            - SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END)) / 10000, 2) AS 鍛ㄨ浆閲忓鍑廮涓囧惃鍏噷,
+       ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
+            / NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END), 0) - 1) * 100, 2) AS 鍛ㄨ浆閲忓悓姣擾鐧惧垎姣�
+FROM h2032_enterprise_monthly e
+JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+       WHERE report_period BETWEEN '2025-01' AND '2025-08') a
+  ON a.enterprise_name = e.enterprise_name
+JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+       WHERE report_period BETWEEN '2026-01' AND '2026-08') b
+  ON b.enterprise_name = e.enterprise_name
+WHERE e.report_period BETWEEN '2025-01' AND '2026-08'
+GROUP BY e.enterprise_name
+ORDER BY 璐ц繍閲�2026_涓囧惃 DESC;
+
+
+-- =====================================================================
+-- 鏌ヨ 3锛氫笁绉嶅彛寰勫鐓� 鈥斺�� 鐪嬫竻妤氥�屽叏閲忋�嶅拰銆屽悓鍚嶃�嶅樊鍦ㄥ摢
+--   ALL_2025 / ALL_2026   : 鍚勮嚜骞翠唤鐨勫叏閮ㄤ紒涓�
+--   SAME_2025 / SAME_2026 : 鍚屽悕浼佷笟鍙ｅ緞锛�545 瀹讹級
+-- =====================================================================
+SELECT t.scope_type                            AS 鍙ｅ緞,
+       COUNT(DISTINCT t.enterprise_name)       AS 浼佷笟鏁�,
+       ROUND(SUM(t.freight_total)  / 10000, 2) AS 璐ц繍閲廮涓囧惃,
+       ROUND(SUM(t.turnover_total) / 10000, 2) AS 鍛ㄨ浆閲廮涓囧惃鍏噷
+FROM (
+  SELECT 'ALL_2025' AS scope_type, enterprise_name, freight_total, turnover_total
+    FROM h2032_enterprise_monthly WHERE report_period BETWEEN '2025-01' AND '2025-08'
+  UNION ALL
+  SELECT 'ALL_2026', enterprise_name, freight_total, turnover_total
+    FROM h2032_enterprise_monthly WHERE report_period BETWEEN '2026-01' AND '2026-08'
+  UNION ALL
+  SELECT 'SAME_2025', e.enterprise_name, e.freight_total, e.turnover_total
+    FROM h2032_enterprise_monthly e
+    JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+           WHERE report_period BETWEEN '2025-01' AND '2025-08') a ON a.enterprise_name = e.enterprise_name
+    JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+           WHERE report_period BETWEEN '2026-01' AND '2026-08') b ON b.enterprise_name = e.enterprise_name
+   WHERE e.report_period BETWEEN '2025-01' AND '2025-08'
+  UNION ALL
+  SELECT 'SAME_2026', e.enterprise_name, e.freight_total, e.turnover_total
+    FROM h2032_enterprise_monthly e
+    JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+           WHERE report_period BETWEEN '2025-01' AND '2025-08') a ON a.enterprise_name = e.enterprise_name
+    JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+           WHERE report_period BETWEEN '2026-01' AND '2026-08') b ON b.enterprise_name = e.enterprise_name
+   WHERE e.report_period BETWEEN '2026-01' AND '2026-08'
+) t
+GROUP BY t.scope_type
+ORDER BY t.scope_type;
+
+
+-- =====================================================================
+-- 鏌ヨ 4锛氬樊寮備紒涓氬悕鍗曪紙鏍稿鐢級鈥斺�� 鍙湪涓�骞存姤閫佺殑浼佷笟鍙婂叾绱閲�
+--   only_in = 2025 / 2026
+--   瀹炴祴锛�2025 骞寸嫭鏈� 119 瀹躲��2026 骞寸嫭鏈� 91 瀹讹紙1-8 鏈堝彛寰勶級
+-- =====================================================================
+SELECT '2025' AS only_in, e.enterprise_name AS 浼佷笟鍚嶇О,
+       ROUND(SUM(e.freight_total) / 10000, 2) AS 璐ц繍閲廮涓囧惃,
+       ROUND(SUM(e.turnover_total) / 10000, 2) AS 鍛ㄨ浆閲廮涓囧惃鍏噷
+FROM h2032_enterprise_monthly e
+LEFT JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+            WHERE report_period BETWEEN '2026-01' AND '2026-08') b
+       ON b.enterprise_name = e.enterprise_name
+WHERE e.report_period BETWEEN '2025-01' AND '2025-08' AND b.enterprise_name IS NULL
+GROUP BY e.enterprise_name
+UNION ALL
+SELECT '2026', e.enterprise_name,
+       ROUND(SUM(e.freight_total) / 10000, 2),
+       ROUND(SUM(e.turnover_total) / 10000, 2)
+FROM h2032_enterprise_monthly e
+LEFT JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+            WHERE report_period BETWEEN '2025-01' AND '2025-08') a
+       ON a.enterprise_name = e.enterprise_name
+WHERE e.report_period BETWEEN '2026-01' AND '2026-08' AND a.enterprise_name IS NULL
+GROUP BY e.enterprise_name
+ORDER BY only_in, 璐ц繍閲廮涓囧惃 DESC;
+
+
+-- =====================================================================
+-- 鏌ヨ 5锛氬垎甯傚窞銆屽悓鍚嶄紒涓氬彛寰勩�嶄袱骞寸疮璁″鐓�
+--   鍦板尯浠ｇ爜鍙� 2026 骞撮偅鏉¤褰曠殑 region_code
+-- =====================================================================
+SELECT CASE
+         WHEN region_code LIKE '4201%' THEN '姝︽眽' WHEN region_code LIKE '4202%' THEN '榛勭煶'
+         WHEN region_code LIKE '4203%' THEN '鍗佸牥' WHEN region_code LIKE '4205%' THEN '瀹滄槍'
+         WHEN region_code LIKE '4206%' THEN '瑗勯槼' WHEN region_code LIKE '4207%' THEN '閯傚窞'
+         WHEN region_code LIKE '4208%' THEN '鑽嗛棬' WHEN region_code LIKE '4209%' THEN '瀛濇劅'
+         WHEN region_code LIKE '4210%' THEN '鑽嗗窞' WHEN region_code LIKE '4211%' THEN '榛勫唸'
+         WHEN region_code LIKE '4212%' THEN '鍜稿畞' WHEN region_code LIKE '4213%' THEN '闅忓窞'
+         WHEN region_code LIKE '4228%' THEN '鎭╂柦' WHEN region_code LIKE '429004%' THEN '浠欐'
+         WHEN region_code LIKE '429005%' THEN '娼滄睙' WHEN region_code LIKE '429006%' THEN '澶╅棬'
+         WHEN region_code LIKE '429021%' THEN '鏋楀尯' ELSE '鍏朵粬' END           AS 甯傚窞,
+       COUNT(DISTINCT d.enterprise_name)                                       AS 鍚屽悕浼佷笟鏁�,
+       ROUND(SUM(d.freight_2025) / 10000, 2)                                   AS 璐ц繍閲�2025_涓囧惃,
+       ROUND(SUM(d.freight_2026) / 10000, 2)                                   AS 璐ц繍閲�2026_涓囧惃,
+       ROUND(SUM(d.turnover_2025) / 10000, 2)                                  AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+       ROUND(SUM(d.turnover_2026) / 10000, 2)                                  AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷
+FROM (
+  SELECT e.enterprise_name,
+         MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END)    AS region_code,
+         SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total  ELSE 0 END) AS freight_2025,
+         SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total  ELSE 0 END) AS freight_2026,
+         SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) AS turnover_2025,
+         SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) AS turnover_2026
+  FROM h2032_enterprise_monthly e
+  JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+         WHERE report_period BETWEEN '2025-01' AND '2025-08') a ON a.enterprise_name = e.enterprise_name
+  JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+         WHERE report_period BETWEEN '2026-01' AND '2026-08') b ON b.enterprise_name = e.enterprise_name
+  WHERE e.report_period BETWEEN '2025-01' AND '2026-08'
+  GROUP BY e.enterprise_name
+) d
+GROUP BY 甯傚窞
+ORDER BY 璐ц繍閲�2026_涓囧惃 DESC;
+
+
+-- =====================================================================
+-- 鏌ヨ 6锛氭暟鎹綋妫� 鈥斺�� 鍚屽悕浼佷笟閲屾湀浠戒笉瓒� 8 涓湀鐨勶紙绱鏁颁細鍋忓皬锛屾瘮瀵规椂娉ㄦ剰锛�
+--   姝ｅ父锛�2025 骞� 1-8 鏈� 8 鏉� + 2026 骞� 1-8 鏈� 8 鏉�
+--   瀹炴祴锛氭棤寮傚父浼佷笟锛屽叏閮� 545 瀹朵袱骞村悇 8 涓湀榻愬叏
+-- =====================================================================
+SELECT e.enterprise_name AS 浼佷笟鍚嶇О,
+       SUM(CASE WHEN e.report_period BETWEEN '2025-01' AND '2025-08' THEN 1 ELSE 0 END) AS 璁板綍鏁�2025,
+       SUM(CASE WHEN e.report_period BETWEEN '2026-01' AND '2026-08' THEN 1 ELSE 0 END) AS 璁板綍鏁�2026
+FROM h2032_enterprise_monthly e
+JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+       WHERE report_period BETWEEN '2025-01' AND '2025-08') a ON a.enterprise_name = e.enterprise_name
+JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
+       WHERE report_period BETWEEN '2026-01' AND '2026-08') b ON b.enterprise_name = e.enterprise_name
+WHERE e.report_period BETWEEN '2025-01' AND '2026-08'
+GROUP BY e.enterprise_name
+HAVING 璁板綍鏁�2025 <> 8 OR 璁板綍鏁�2026 <> 8;
\ No newline at end of file

--
Gitblit v1.9.1