trafficAudit.git

			@@ -16,10 +16,11 @@
			-- 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%
			-- å®æµç»æï¼ååä¼ä¸å£å¾ 545 å®¶ï¼4 ä½å°æ°ï¼ï¼
			-- 2025 å¹´ 1-8 æï¼è´§è¿é 30153.1392 ä¸å¨ï¼å¨è½¬é 4635340.4627 ä¸å¨å¬é
			-- 2026 å¹´ 1-8 æï¼è´§è¿é 27752.6820 ä¸å¨ï¼å¨è½¬é 4389882.0468 ä¸å¨å¬é
			-- åæ¯ï¼è´§è¿é -7.9609%ï¼å¨è½¬é -5.2954%
			-- ï¼2026 å¹´è¿ä¸¤ä¸ªæ°ä¸ãæç»å¨è§ä¼ä¸545å®¶_åå¸å·1-8æç´¯è®¡è¿è·ååæ¯ãäº¤ä»ä»¶çå¨çè¡å®å¨ä¸è´ï¼
			-- ============================================================


			@@ -38,7 +39,8 @@
			-- Â· æç»ç±»æ¥è¯¢ï¼æ¥è¯¢ 2ãæ¥è¯¢ 7ï¼â å®å¨ä¸å¥ ROUNDï¼å¯¼åºå³åå§å¼
			-- ï¼è´§è¿é/å¨è½¬éçåå§å¼æå¤ 4 ä½å°æ°ï¼å°±æ¯å¨ç²¾åº¦ï¼åæ¯åå°æ°ä½è¾é¿ï¼
			-- å«é¿å¯èªè¡å¨å¤é¢å¥ ROUND(...,2)ï¼ï¼
			-- Â· æ±æ»å±ç¤ºç±»ï¼æ¥è¯¢ 1ã3ã5ã8ï¼â ä¿ç 2 ä½å°æ°ï¼ç»äººççï¼å¤ç¨ä¸å¥½çï¼ï¼
			-- Â· æ±æ»ç±»ï¼æ¥è¯¢ 1ã3ã5ã8ï¼â åæ ·ä¿ç 4 ä½å°æ°ï¼å¯¹æ¬è¡¨æ°æ®æ¥è¯´ 4 ä½å°±æ¯å¨ç²¾åº¦ï¼
			-- ä¿ç 2 ä½æ²¡æä»»ä½å¥½å¤ï¼åèä¼è®©äººè¯¯ä»¥ä¸ºæ°æ®å°±åªæ 2 ä½ç²¾åº¦ï¼ï¼
			-- Â· å¦æä½ è¦èªå·±ç®è¿è·/åæ¯ï¼å»ºè®®ç´æ¥ç¨æ¥è¯¢ 7ï¼ææ /10000 é£ä¸å±å»æï¼
			-- åå¨ Excel éæãå¨ãç®å®åé¤ã
			-- ============================================================
			@@ -48,16 +50,16 @@
			-- =====================================================================
			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_ä¸å¨,
			THEN e.freight_total ELSE 0 END) / 10000, 4) AS è´§è¿é2025_ä¸å¨,
			ROUND(SUM(CASE WHEN e.report_period >= '2026-01'
			THEN e.freight_total ELSE 0 END) / 10000, 2) AS è´§è¿é2026_ä¸å¨,
			THEN e.freight_total ELSE 0 END) / 10000, 4) 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_ä¸å¨å¬é,
			THEN e.turnover_total ELSE 0 END) / 10000, 4) AS å¨è½¬é2025_ä¸å¨å¬é,
			ROUND(SUM(CASE WHEN e.report_period >= '2026-01'
			THEN e.turnover_total ELSE 0 END) / 10000, 2) AS å¨è½¬é2026_ä¸å¨å¬é,
			THEN e.turnover_total ELSE 0 END) / 10000, 4) 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 å¨è½¬éåæ¯_ç¾åæ¯
			@@ -109,8 +111,8 @@
			-- =====================================================================
			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 å¨è½¬é_ä¸å¨å¬é
			ROUND(SUM(t.freight_total) / 10000, 4) AS è´§è¿é_ä¸å¨,
			ROUND(SUM(t.turnover_total) / 10000, 4) 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'
			@@ -180,10 +182,10 @@
			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_ä¸å¨å¬é
			ROUND(SUM(d.freight_2025) / 10000, 4) AS è´§è¿é2025_ä¸å¨,
			ROUND(SUM(d.freight_2026) / 10000, 4) AS è´§è¿é2026_ä¸å¨,
			ROUND(SUM(d.turnover_2025) / 10000, 4) AS å¨è½¬é2025_ä¸å¨å¬é,
			ROUND(SUM(d.turnover_2026) / 10000, 4) AS å¨è½¬é2026_ä¸å¨å¬é
			FROM (
			SELECT e.enterprise_name,
			MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END) AS region_code,
			@@ -276,14 +278,14 @@

			-- =====================================================================
			-- æ¥è¯¢ 8ï¼æ¥è¯¢ 7 çåè®¡è¡ï¼å¯¼åºæç»åç¨æ¥å¯¹æ»æ°ï¼546 å®¶å£å¾ï¼
			-- 2025 å¹´ 1-8 æï¼è´§è¿é 30162.99 ä¸å¨ãå¨è½¬é 4637038.58 ä¸å¨å¬é
			-- 2026 å¹´ 1-8 æï¼è´§è¿é 27764.88 ä¸å¨ãå¨è½¬é 4392984.81 ä¸å¨å¬é
			-- 2025 å¹´ 1-8 æï¼è´§è¿é 30162.9872 ä¸å¨ãå¨è½¬é 4637038.5803 ä¸å¨å¬é
			-- 2026 å¹´ 1-8 æï¼è´§è¿é 27764.8812 ä¸å¨ãå¨è½¬é 4392984.8116 ä¸å¨å¬é
			-- =====================================================================
			SELECT COUNT(DISTINCT e.unified_credit_code) 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 <= '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 <= '2025-08' THEN e.freight_total ELSE 0 END) / 10000, 4) AS è´§è¿é2025_ä¸å¨,
			ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) / 10000, 4) AS è´§è¿é2026_ä¸å¨,
			ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000, 4) AS å¨è½¬é2025_ä¸å¨å¬é,
			ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000, 4) AS å¨è½¬é2026_ä¸å¨å¬é
			FROM h2032_enterprise_monthly e
			JOIN (SELECT DISTINCT unified_credit_code c FROM h2032_enterprise_monthly
			WHERE report_period BETWEEN '2025-01' AND '2025-08') a ON a.c = e.unified_credit_code