From 677d0ee49b04a0a158bcbaae51a677f5cfaf77cb Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期六, 19 九月 2026 12:18:42 +0800
Subject: [PATCH] fix(货运): 明细查询去掉ROUND改为全精度导出 + 小数位约定说明 + 两查询等价性验证
---
docs/工作日结/工作日结_2026-09-19.md | 17 +++++
docs/生成汇总大表/同名企业_1-8月累计对比_2026-09-19.sql | 79 ++++++++++++++++---------
docs/功能测试报告/功能测试报告_同名企业1-8月累计货运量与周转量SQL_2026-09-19.md | 83 +++++++++++++++++++++++++++
3 files changed, 148 insertions(+), 31 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"
index 26ecb6f..1d8dbd2 100644
--- "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"
@@ -81,9 +81,88 @@
| T15 | 姝ｅ悜 | 鍛戒护琛屽鍑猴紙鏂瑰紡涓�锛� | 鐢熸垚 UTF-8 鐨� tsv锛屽惈 546 琛屾暟鎹� | 89046 瀛楄妭銆�546 琛屾暟鎹�佷腑鏂囧垪鍚嶄笌浼佷笟鍚嶆甯� | 閫氳繃 |
| T16 | 杈圭晫 | Excel 鐩存帴鍙屽嚮 tsv | 瀛樺湪涓枃涔辩爜椋庨櫓 | 鏂囦欢涓� UTF-8 鏃� BOM锛屽凡鍦ㄨ剼鏈唴娉ㄦ槑鏀圭敤銆屾暟鎹� 鈫� 浠庢枃鏈�/CSV銆嶅鍏ユ垨鐩存帴瀵� xlsx | 閫氳繃 |
| T17 | 杈圭晫 | 鏄庣粏涓悓姣旈櫎闆� | 鍩烘湡涓� 0 鏃朵笉鎶ラ敊 | `NULLIF(...,0)` 淇濇姢锛岃繑鍥炵┖鍊� | 閫氳繃 |
-## 鍏�佺粨璁�
+## 鍏�佽ˉ鍏咃細鏄庣粏灏忔暟浣嶇己闄蜂慨澶嶏紙2026-09-19 杩藉姞锛�
-8 鏉℃煡璇㈡暣鑴氭湰鎵ц閫氳繃锛�17 鏉＄敤渚嬶紙11 姝ｅ悜 / 2 璐熷悜 / 4 杈圭晫锛夊叏閮ㄩ�氳繃銆�
+**闂**锛氳剼鏈師鍏堝湪鏄庣粏绫绘煡璇紙鏌ヨ 2銆佹煡璇� 7锛夐噷鎶娿�屼竾鍚� / 涓囧惃鍏噷銆嶅垪鍐欐垚 `ROUND(..., 2)`銆�
+淇濈暀 2 浣嶅皬鏁� = 绮惧害鍙埌 100 鍚ㄣ�傜敤鎴锋寜杩欎袱鍒楀湪 Excel 閲岀畻銆屽钩鍧囪繍璺� = 鍛ㄨ浆閲� 梅 璐ц繍閲忋�嶆椂锛�
+璐ц繍閲忓皬鐨勪紒涓氬垎姣嶈鐮嶅皬锛岃繍璺濊鏄庢樉鏀惧ぇ銆�
+
+**瀹炰緥**锛�2026 骞� 1-8 鏈堬紝婀栧寳寮橀浄鐗╂祦鏈夐檺鍏徃锛屾簮鏁版嵁 4631 鍚� / 5867730 鍚ㄥ叕閲岋級锛�
+
+| 璐ц繍閲忥紙涓囧惃锛� | 绠楀緱鐨勫钩鍧囪繍璺� | 缁撹 |
+| --- | --- | --- |
+| 0.4631锛堜笉鍙栨暣锛� | 1267.05 鍏噷 | 姝ｇ‘锛堜笌鏁版嵁搴撳叏绮惧害涓�鑷达級 |
+| 0.46锛堝彇 2 浣嶏級 | 1275.59 鍏噷 | 铏氶珮 8.53 鍏噷 |
+
+**澶勭疆**锛�
+
+- 鏌ヨ 2銆佹煡璇� 7 鐨� 6 涓揣杩愰噺/鍛ㄨ浆閲忓垪锛堜袱骞村�� + 澧炲噺棰濓級鏀逛负 `ROUND(..., 4)`锛�
+- 姹囨�诲睍绀虹被锛堟煡璇� 1銆�3銆�5銆�8锛変繚鐣� 2 浣嶅皬鏁帮紝澶熺敤涓旂編瑙傦紱
+- 鑴氭湰椤堕儴鏂板銆屸槄 灏忔暟浣嶇害瀹氥�嶈鏄庢锛屽啓鏄�"瑕佸弬涓庝簩娆¤绠楃殑鍒椾笉鑳藉彧鐣� 2 浣�"锛屽苟闄勪笂杩板疄渚嬨��
+
+**鍥炲綊楠岃瘉**锛�
+
+| 缂栧彿 | 鐢ㄤ緥 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- |
+| T18 | 鏁磋剼鏈噸璺� | 鏃犳姤閿欍�佽鏁颁笉鍙� | 1352 琛岃緭鍑恒�佹棤 ERROR | 閫氳繃 |
+| T19 | 鏌ヨ 7 鏄庣粏鍒楃簿搴� | 璐ц繍閲�/鍛ㄨ浆閲� 4 浣嶅皬鏁� | 婀栧寳寮橀浄 2026 骞磋揣杩愰噺 0.4631锛堝師 0.46锛夈�佸懆杞噺 586.773 | 閫氳繃 |
+| T20 | 鐢ㄦ槑缁嗗垪澶嶇畻杩愯窛 | 涓庢暟鎹簱鍏ㄧ簿搴︿竴鑷� | 586.773 梅 0.4631 = 1267.05 鍏噷锛屼笌搴撳唴 1267.0546 涓�鑷� | 閫氳繃 |
+| T21 | 姹囨�诲垪鏈鏀瑰姩 | 鏌ヨ 1/3/5/8 浠嶄负 2 浣� | 鏌ヨ 8 浠嶈緭鍑� 546 / 30162.99 / 27764.88 / 4637038.58 / 4392984.81 | 閫氳繃 |
+## 涓冦�佽ˉ鍏咃細鏄庣粏绫绘煡璇㈡敼涓恒�屽畬鍏ㄤ笉濂� ROUND銆嶏紙2026-09-19 杩藉姞锛�
+
+鐢ㄦ埛纭鎸夈�屽叏绮惧害銆嶅鍑猴紝鏄庣粏绫绘煡璇紙鏌ヨ 2銆佹煡璇� 7锛夌殑 ROUND 鍏ㄩ儴鍘绘帀锛屽鍑哄嵆鍘熷鍊笺��
+
+**鏀瑰姩**锛�
+
+- 鏌ヨ 2銆佹煡璇� 7 鐨勬墍鏈夋暟鍊煎垪锛堣揣杩愰噺/鍛ㄨ浆閲忕殑涓ゅ勾鍊笺�佸鍑忛銆佸悓姣旂櫨鍒嗘瘮锛変竴寰嬩笉濂� `ROUND`锛�
+- 姹囨�诲睍绀虹被锛堟煡璇� 1銆�3銆�5銆�8锛変粛淇濈暀 2 浣嶅皬鏁帮紝缁欎汉鐪嬬殑锛�
+- 椤堕儴銆屸槄 灏忔暟浣嶇害瀹氥�嶅悓姝ユ洿鏂颁负"鏄庣粏涓嶅 ROUND"銆�
+
+**绮惧害璇存槑锛堝疄娴嬶級**锛氳揣杩愰噺銆佸懆杞噺鐨勫師濮嬪�兼槸鏁村惃 梅 10000锛屽皬鏁颁綅**鏈�澶� 4 浣�**锛�
+鍙� 4 浣嶅嵆绛変簬鍏ㄧ簿搴︼紱瀹炴祴 2026 骞� 1-8 鏈堢殑 636 瀹朵紒涓氫腑锛�"4 浣嶅皬鏁颁互澶栬繕鏈夊熬鏁�"鐨勪负 **0 瀹�**銆�
+鍚屾瘮鐧惧垎姣旀槸闄ゅ嚭鏉ョ殑锛屽皬鏁颁綅浼氳緝闀匡紙濡� 鈭�2.5389920113927933锛夛紝浠嬫剰鍙湪澶栭潰鍐嶅 `ROUND(...,2)`銆�
+
+**鍥炲綊楠岃瘉**锛�
+
+| 缂栧彿 | 鐢ㄤ緥 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- |
+| T22 | 鏁磋剼鏈噸璺� | 鏃犳姤閿欍�佽鏁颁笉鍙� | 1352 琛岃緭鍑恒�佹棤 ERROR | 閫氳繃 |
+| T23 | 鏌ヨ 7 瀵煎嚭涓嶅惈 ROUND | 杈撳嚭鍘熷鍊� | 姝﹂挗鐗╂祦 738.1512 / 719.4096锛涙箹鍖楀紭闆� 0.6863 / 0.4631锛涘懆杞噺 889.1465 / 586.773 | 閫氳繃 |
+| T24 | 瀵煎嚭缁撴灉浠嶄负 546 琛� | 546 琛� | 546 琛屾暟鎹紙tsv 546 琛� + 琛ㄥご锛� | 閫氳繃 |
+| T25 | 鐢ㄥ鍑哄�煎绠楄繍璺� | 涓庡簱涓�鑷� | 586.773 梅 0.4631 = 1267.05 鍏噷锛屼笌搴撳唴 1267.0546 涓�鑷� | 閫氳繃 |
+## 鍏�佽ˉ鍏咃細鏌ヨ 2 涓庢煡璇� 7 鐨勭瓑浠锋�ч獙璇侊紙2026-09-19 杩藉姞锛�
+
+鐢ㄦ埛鎻愰棶锛�"濡傛灉娌℃湁鏀瑰悕閭ｅ锛屾煡璇� 2 鍜屾煡璇� 7 鑳藉畬鍏ㄥ涓婂悧锛�"鈥斺�斿疄娴嬬瓟妗堬細**閫愭瘮鐗瑰畬鍏ㄧ浉绛�**銆�
+
+**楠岃瘉鏂规硶**锛氭妸鏀瑰悕浼佷笟 `91420112558443820B` 浠庢煡璇� 7 鐨勭粨鏋滀腑鍓旈櫎锛屼笌鏌ヨ 2 鐨勭粨鏋滈�愯閫愬垪姣斿銆�
+
+| 姣斿椤� | 缁撴灉 |
+| --- | --- |
+| 鏁版嵁琛屾暟 | 鏌ヨ 2 = 545 琛岋紱鏌ヨ 7 鍓旈櫎閭ｅ = 545 琛� |
+| 浼佷笟鍚嶅崟 | 瀹屽叏涓�鑷达紙鍙屽悜宸泦鍧囦负绌猴級 |
+| 璐ц繍閲� 2025 / 2026 / 澧炲噺 / 鍚屾瘮 | 涓嶄竴鑷� 0 瀹讹紝鏈�澶у樊 0 |
+| 鍛ㄨ浆閲� 2025 / 2026 / 澧炲噺 / 鍚屾瘮 | 涓嶄竴鑷� 0 瀹讹紝鏈�澶у樊 0 |
+| 鍦板尯浠ｇ爜 | 涓嶄竴鑷� 0 瀹� |
+
+**鍘熷洜锛堜袱鏉★級**锛�
+
+1. **鍖归厤閿竴涓�瀵瑰簲**锛氶櫎鏀瑰悕閭ｅ澶栵紝涓�涓俊鐢ㄤ唬鐮佸彧瀵瑰簲涓�涓紒涓氬悕绉般�佷竴涓悕绉板彧瀵瑰簲涓�涓俊鐢ㄤ唬鐮�
+ 锛堝墠鏂囧凡楠岃瘉锛氬悓涓�浠ｇ爜澶氬悕绉� = 1 渚嬶紙鍗虫敼鍚嶉偅瀹讹級銆佸悓涓�鍚嶇О澶氫唬鐮� = 0 渚嬨�佸悓鏈堥噸澶嶈褰� = 0 鏉★級銆�
+ 鏁呮寜鍚嶇О鍒嗙粍涓庢寜淇＄敤浠ｇ爜鍒嗙粍锛屽緱鍒扮殑鏄悓涓�鎵� 545 瀹躲�佸悓鏍风殑琛屻��
+2. **绠楁湳绮剧‘**锛氫袱涓煡璇㈤兘鏄�"鏁村惃姹傚拰 鈫� 闄や互 10000"銆傚惃鏁颁负鏁存暟涓旇繙灏忎簬 2鈦德筹紝
+ double 瀵规暣鏁版眰鍜屾槸绮剧‘鐨勶紝鏁呬袱渚у畬鍏ㄤ竴鑷达紙杩炴诞鐐瑰熬宸兘娌℃湁锛夈��
+
+**琛ュ厖鐢ㄤ緥**锛�
+
+| 缂栧彿 | 绫诲瀷 | 鐢ㄤ緥 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- | --- |
+| T26 | 姝ｅ悜 | 鏌ヨ 2 涓庢煡璇� 7 绛変环鎬� | 鍓旈櫎鏀瑰悕浼佷笟鍚庝袱鑰呭畬鍏ㄤ竴鑷� | 545 琛屼紒涓氬悕鍗曚竴鑷达紱8 涓暟鍊煎垪 + 鍦板尯浠ｇ爜鍏ㄩ儴 0 瀹朵笉涓�鑷淬�佹渶澶у樊 0 | 閫氳繃 |
+
+**瀹炶返鍚箟**锛氭煡璇� 7 = 鏌ヨ 2 + 鏀瑰悕浼佷笟锛堜俊鐢ㄤ唬鐮佸彛寰勬槸鍚嶇О鍙ｅ緞鐨勮秴闆嗭級锛屼袱鑰呭叡鍚岄儴鍒嗘暟鍊煎畬鍏ㄧ浉鍚屻��
+瑕佽窡 545 瀹朵氦浠樹欢瀵硅处鐢ㄦ煡璇� 2锛涜闃插皢鏉ュ啀鍑虹幇鏀瑰悕浼佷笟锛岀敤鏌ヨ 7 鏇寸ǔ銆�
+## 涔濄�佺粨璁�
+
+8 鏉℃煡璇㈡暣鑴氭湰鎵ц閫氳繃锛�26 鏉＄敤渚嬶紙17 姝ｅ悜 / 2 璐熷悜 / 7 杈圭晫锛夊叏閮ㄩ�氳繃銆�
**鍚屽悕浼佷笟鍙ｅ緞锛�545 瀹讹級1-8 鏈堢疮璁＄粨鏋滐細**
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"
index 6546f6b..9b45777 100644
--- "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"
@@ -62,6 +62,23 @@
- 546 瀹跺彛寰勫悎璁★細2025 骞� 1-8 鏈� 30162.99 涓囧惃 / 4637038.58 涓囧惃鍏噷锛�2026 骞� 27764.88 涓囧惃 / 4392984.81 涓囧惃鍏噷銆�
- 鑴氭湰鍐呴檮涓夌瀵煎嚭鏂瑰紡锛堝懡浠よ tsv / Navicat 瀵� xlsx / INTO OUTFILE锛夛紝鍛戒护琛屾柟寮忓凡瀹炴祴瀵煎嚭 546 琛屻�佷腑鏂囨甯搞��
- 寰呯敤鎴风‘璁わ細瀵瑰鎶ラ�佺敤 545 瀹讹紙鍚嶇О浜ら泦锛夎繕鏄� 546 瀹讹紙浠ｇ爜浜ら泦锛夛紝纭鍚庡啀瀹氱浠躲��
+杩藉姞锛堝綋鏃ョ浜岃疆锛夛細鏍稿妗岄潰銆婅涓婃寔缁湪瑙勪紒涓�1-8鏈堣繍璺濆悓姣�.xlsx銆嬩笌浠婃棩浜や粯浠讹紝
+骞朵慨澶� SQL 鑴氭湰鐨勬槑缁嗙簿搴︾己闄枫��
+
+- 鏍稿缁撹锛氫袱鏂囦欢浼佷笟鍚嶇О**545 瀹堕�愬瓧绗︿竴鑷�**锛堝敮涓�澶氬嚭鐨勬槸鏀瑰悕浼佷笟 婀栧寳闀垮场瀵岀儴缁跨數鈥︼級锛�
+ 浣嗛櫎鍚嶇О澶栧叾浣欏垪瀵逛笉涓娾�斺�旇繍璺� 540/545 瀹朵笉涓�鑷达紙鏈�澶� 8.53 鍏噷锛夈��2025 杩愯窛 544/545 涓嶄竴鑷淬��
+ 鍚屾瘮 540/545 涓嶄竴鑷达紱鏍瑰洜鏄鏂规枃浠剁敤銆屼竾鍚ㄤ繚鐣� 2 浣嶃�嶅啀绠楄繍璺濓紝浜や粯浠惰蛋鍏ㄧ簿搴︼紙涓庢暟鎹簱 0 鍋忓樊锛夈��
+ 鍙﹀彂鐜板競宸炲啓娉曞樊寮傦細瀵规柟鍐�"鎭╂柦"锛屼氦浠樹欢鍐�"鎭╂柦宸�"锛�3 瀹讹級銆�
+- 缂洪櫡淇锛氬師 SQL 鐨勬槑缁嗘煡璇紙鏌ヨ 2銆佹煡璇� 7锛夋妸涓囧惃鍒� `ROUND(...,2)`锛岀簿搴﹀彧鍒� 100 鍚紝
+ 鐢ㄦ埛鎷垮幓绠楄繍璺濅細琚斁澶э紙婀栧寳寮橀浄 4631 鍚� 鈫� 0.46 涓囧惃 鈫� 杩愯窛铏氶珮 8.53 鍏噷锛夈��
+ 宸叉敼涓� 4 浣嶅皬鏁帮紝骞跺湪鑴氭湰椤堕儴鏂板銆屸槄 灏忔暟浣嶇害瀹氥�嶈鏄庢锛涙暣鑴氭湰鍥炲綊閫氳繃锛�21 鏉＄敤渚嬶級銆�
+- 寰呯‘璁わ細瀵瑰鎶ラ�佺敤 545 瀹惰繕鏄� 546 瀹跺彛寰勶紱浠ュ強鏄惁鎶婁氦浠樹欢涓庡鏂规枃浠剁殑灏忔暟浣嶃�佹仼鏂藉啓娉曠粺涓�銆�
+- 杩藉姞锛氭寜鐢ㄦ埛瑕佹眰鎶婃槑缁嗙被鏌ヨ锛堟煡璇� 2銆佹煡璇� 7锛夌殑 `ROUND` 鍏ㄩ儴鍘绘帀锛屽鍑哄嵆鍘熷鍊硷紱
+ 瀹炴祴璐ц繍閲�/鍛ㄨ浆閲忕殑鍘熷鍊兼渶澶� 4 浣嶅皬鏁帮紙636 瀹朵紒涓氫腑 4 浣嶄互澶栬繕鏈夊熬鏁扮殑涓� 0 瀹讹級锛�
+ 4 浣嶅嵆鍏ㄧ簿搴︺�傛眹鎬荤被浠嶄繚鐣� 2 浣嶃�傛暣鑴氭湰鍥炲綊閫氳繃锛�25 鏉＄敤渚嬶級銆�
+- 杩藉姞楠岃瘉锛氭煡璇� 2锛�545 瀹跺悕绉板彛寰勶級涓庢煡璇� 7锛�546 瀹朵唬鐮佸彛寰勶級**鍓旈櫎鏀瑰悕浼佷笟鍚庨�愭瘮鐗瑰畬鍏ㄧ浉绛�**
+ 锛�545 琛屼紒涓氬悕鍗曚竴鑷达紝8 涓暟鍊煎垪 + 鍦板尯浠ｇ爜鏈�澶у樊鍧囦负 0锛夈�傚師鍥犳槸鍖归厤閿竴涓�瀵瑰簲 + 鏁存暟姹傚拰绮剧‘銆�
+ 宸茶涓烘祴璇曟姤鍛� T26锛堢疮璁� 26 鏉＄敤渚嬶級銆�
## 浜屻�佹祴璇曠粨鏋滄憳瑕�
瑙併�婂姛鑳芥祴璇曟姤鍛奯鎸佺画鍦ㄨ浼佷笟545瀹跺垎甯傚窞绱杩愯窛鍚屾瘮_2026-09-19.md銆嬶細11 鏉＄敤渚嬶紙7 姝ｅ悜 / 3 杈圭晫 / 1 璐熷悜锛夊叏閮ㄩ�氳繃銆�
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"
index 7fd1adc..777d8a7 100644
--- "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"
@@ -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 骞寸敤鐨勫悕瀛楋紝鐢ㄤ簬鏍囪鏀瑰悕
--
Gitblit v1.9.1