trafficAudit.git

			@@ -23,6 +23,26 @@
			-- ============================================================


			-- ============================================================
			-- â å°æ°ä½çº¦å®ï¼2026-09-19 è¡¥åï¼å¾éè¦ï¼â
			-- ------------------------------------------------------------
			-- 1) è¡¨éåçæ¯ãå¨ / å¨å¬éãçæ´æ°ï¼å¯¼åºæ¶ Ã·10000 åæãä¸å¨ / ä¸å¨å¬éãã
			-- 2) å¡æ¯ãè¦æ¿å»äºæ¬¡è®¡ç®ãçåï¼å°¤å¶æ¯ãå¨è½¬é Ã· è´§è¿é = å¹³åè¿è·ãï¼ï¼
			-- åä¸ä¸è½å¨ SQL éåªä¿ç 2 ä½å°æ°ï¼
			-- åå ï¼ä¿ç 2 ä½ = ç²¾åº¦å° 100 å¨ãå¯¹è´§è¿éåªæå åå¨çå°ä¼ä¸ï¼
			-- åæ¯ä¼è¢«ç ææå¤ 1%ï¼ç®åºæ¥çè¿è·è½å·®åºå¥½å å¬éã
			-- å®ä¾ï¼æ¹åå¼é·ç©æµæéå¬å¸ 2026 å¹´ 1-8 æè´§è¿é 4631 å¨
			-- â ä¸åæ´ 0.4631 ä¸å¨ï¼è¿è· 1267.05 å¬éï¼æ£ç¡®ï¼
			-- â å 2 ä½ 0.46 ä¸å¨ï¼è¿è· 1275.59 å¬éï¼èé« 8.53 å¬éï¼
			-- 3) æä»¥æ¬èæ¬çº¦å®ï¼
			-- Â· æç»ç±»æ¥è¯¢ï¼æ¥è¯¢ 2ãæ¥è¯¢ 7ï¼â å®å¨ä¸å¥ ROUNDï¼å¯¼åºå³åå§å¼
			-- ï¼è´§è¿é/å¨è½¬éçåå§å¼æå¤ 4 ä½å°æ°ï¼å°±æ¯å¨ç²¾åº¦ï¼åæ¯åå°æ°ä½è¾é¿ï¼
			-- å«é¿å¯èªè¡å¨å¤é¢å¥ ROUND(...,2)ï¼ï¼
			-- Â· æ±æ»å±ç¤ºç±»ï¼æ¥è¯¢ 1ã3ã5ã8ï¼â ä¿ç 2 ä½å°æ°ï¼ç»äººççï¼å¤ç¨ä¸å¥½çï¼ï¼
			-- Â· å¦æä½ è¦èªå·±ç®è¿è·/åæ¯ï¼å»ºè®®ç´æ¥ç¨æ¥è¯¢ 7ï¼ææ /10000 é£ä¸å±å»æï¼
			-- åå¨ Excel éæãå¨ãç®å®åé¤ã
			-- ============================================================

			-- =====================================================================
			-- æ¥è¯¢ 1ï¼æ±æ»ä¸è¡ ââ ååä¼ä¸å£å¾çä¸¤å¹´ç´¯è®¡æ° + åæ¯å¢é
			-- =====================================================================
			@@ -56,20 +76,20 @@
			-- æ¥è¯¢ 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 å¨è½¬éåæ¯_ç¾åæ¯
			SELECT e.enterprise_name AS ä¼ä¸åç§°,
			MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END) AS å°åºä»£ç ,
			SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END) / 10000 AS è´§è¿é2025_ä¸å¨,
			SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) / 10000 AS è´§è¿é2026_ä¸å¨,
			(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 AS è´§è¿éå¢å_ä¸å¨,
			(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 AS è´§è¿éåæ¯_ç¾åæ¯,
			SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000 AS å¨è½¬é2025_ä¸å¨å¬é,
			SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000 AS å¨è½¬é2026_ä¸å¨å¬é,
			(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 AS å¨è½¬éå¢å_ä¸å¨å¬é,
			(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 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
			@@ -207,12 +227,13 @@
			-- 2025-10 èµ·å«ãæ¹åé¿å³¡å¯ç¨ç»¿çµä¾åºé¾æéå¬å¸ãï¼ï¼
			-- æ¥è¯¢ 2 æåç§°å¹éä¼æè¿å®¶ä¸¤å¹´é½æ¼æï¼ä¸åæ¶è®¡å¥ä¸¤å¹´ãç¬æä¼ä¸ãååã
			-- è¾åºåå·²æå¯¼åºä¹ æ¯æå¥½ï¼å¯ç´æ¥ç²è¿ Excelï¼æ 2026 å¹´è´§è¿ééåºã
			-- æç¤ºï¼æç»è¡æ¯ãååèäºå¥åæ±åãï¼ä¸æ¥è¯¢ 8 çåè®¡æ 0.01~0.02 çå°¾å·®ï¼å±æ£å¸¸ã
			-- æç¤ºï¼æç»åä¸å¥ ROUNDï¼å¨ç²¾åº¦ï¼è´§è¿é/å¨è½¬éæå¤ 4 ä½å°æ°ï¼ï¼
			-- ä¸æ¥è¯¢ 8 ç 2 ä½åè®¡ä¼æ 0.01 çº§å°¾å·®ï¼å±æ£å¸¸ã
			-- =====================================================================
			SELECT d.credit_code AS ç»ä¸ç¤¾ä¼ä¿¡ç¨ä»£ç ,
			d.name_2026 AS ä¼ä¸åç§°,
			d.name_2025 AS åç§°2025,
			IF(d.name_2025 <> d.name_2026, 'æ¯', '') AS æ¯å¦æ¹å,
			SELECT d.credit_code AS ç»ä¸ç¤¾ä¼ä¿¡ç¨ä»£ç ,
			d.name_2026 AS ä¼ä¸åç§°,
			d.name_2025 AS åç§°2025,
			IF(d.name_2025 <> d.name_2026, 'æ¯', '') AS æ¯å¦æ¹å,
			CASE
			WHEN d.region_code LIKE '4201%' THEN 'æ¦æ±' WHEN d.region_code LIKE '4202%' THEN 'é»ç³'
			WHEN d.region_code LIKE '4203%' THEN 'åå °' WHEN d.region_code LIKE '4205%' THEN 'å®æ'
			@@ -222,16 +243,16 @@
			WHEN d.region_code LIKE '4212%' THEN 'å¸å®' WHEN d.region_code LIKE '4213%' THEN 'éå·'
			WHEN d.region_code LIKE '4228%' THEN 'æ©æ½' WHEN d.region_code LIKE '429004%' THEN 'ä»æ¡'
			WHEN d.region_code LIKE '429005%' THEN 'æ½æ±' WHEN d.region_code LIKE '429006%' THEN 'å¤©é¨'
			WHEN d.region_code LIKE '429021%' THEN 'æåº' ELSE 'å¶ä»' END AS å¸å·,
			d.region_code AS å°åºä»£ç ,
			ROUND(d.freight_2025 / 10000, 2) AS è´§è¿é2025_ä¸å¨,
			ROUND(d.freight_2026 / 10000, 2) AS è´§è¿é2026_ä¸å¨,
			ROUND((d.freight_2026 - d.freight_2025) / 10000, 2) AS è´§è¿éå¢å_ä¸å¨,
			ROUND((d.freight_2026 / NULLIF(d.freight_2025, 0) - 1) * 100, 2) AS è´§è¿éåæ¯_ç¾åæ¯,
			ROUND(d.turnover_2025 / 10000, 2) AS å¨è½¬é2025_ä¸å¨å¬é,
			ROUND(d.turnover_2026 / 10000, 2) AS å¨è½¬é2026_ä¸å¨å¬é,
			ROUND((d.turnover_2026 - d.turnover_2025) / 10000, 2) AS å¨è½¬éå¢å_ä¸å¨å¬é,
			ROUND((d.turnover_2026 / NULLIF(d.turnover_2025, 0) - 1) * 100, 2) AS å¨è½¬éåæ¯_ç¾åæ¯
			WHEN d.region_code LIKE '429021%' THEN 'æåº' ELSE 'å¶ä»' END AS å¸å·,
			d.region_code AS å°åºä»£ç ,
			d.freight_2025 / 10000 AS è´§è¿é2025_ä¸å¨,
			d.freight_2026 / 10000 AS è´§è¿é2026_ä¸å¨,
			(d.freight_2026 - d.freight_2025) / 10000 AS è´§è¿éå¢å_ä¸å¨,
			(d.freight_2026 / NULLIF(d.freight_2025, 0) - 1) * 100 AS è´§è¿éåæ¯_ç¾åæ¯,
			d.turnover_2025 / 10000 AS å¨è½¬é2025_ä¸å¨å¬é,
			d.turnover_2026 / 10000 AS å¨è½¬é2026_ä¸å¨å¬é,
			(d.turnover_2026 - d.turnover_2025) / 10000 AS å¨è½¬éå¢å_ä¸å¨å¬é,
			(d.turnover_2026 / NULLIF(d.turnover_2025, 0) - 1) * 100 AS å¨è½¬éåæ¯_ç¾åæ¯
			FROM (
			SELECT e.unified_credit_code AS credit_code,
			-- 2026 å¹´ç¨çååï¼æ¹åååæ°åï¼ã2025 å¹´ç¨çååï¼ç¨äºæ è®°æ¹å