From ade4387f72c876f779b0956295922003464434f0 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期六, 19 九月 2026 23:26:59 +0800 Subject: [PATCH] fix(汇总表): 中口径排名周转量口径统一为「总量-城市内」差额法 --- docs/功能测试报告/功能测试报告_同名企业1-8月累计货运量与周转量SQL_2026-09-19.md | 206 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 206 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..e13ec4e --- /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,206 @@ +# 鍔熻兘娴嬭瘯鎶ュ憡_鍚屽悕浼佷笟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 骞村綊灞炵粺璁★紝瀹炴祴鏈彂鐜板奖鍝嶏紙鍚屽悕浼佷笟涓ゅ湴骞跺瓨鐨勬儏鍐垫棤锛夈�� + +## 浜斻�佽ˉ鍏咃細浼佷笟鏄庣粏瀵煎嚭锛�2026-09-19 杩藉姞锛� + +鐢ㄦ埛瑕佹眰鎶婁紒涓氭槑缁嗕篃瀵煎嚭鏉ワ紝鑴氭湰杩藉姞涓ゆ潯鏌ヨ锛� + +- **鏌ヨ 7 浼佷笟鏄庣粏瀵煎嚭**锛氬尮閰嶉敭鏀圭敤 `unified_credit_code`锛堢粺涓�绀句細淇＄敤浠ｇ爜锛夛紝鍏� **546 瀹�**锛� + 姣旀煡璇� 2 澶氳鐩� 1 瀹舵敼鍚嶄紒涓氾紙`91420112558443820B`锛�2025-01~2025-09 鍙� + 銆屾箹鍖椾笁宄″瘜鐑ㄧ豢鐢典緵搴旈摼鏈夐檺鍏徃銆嶏紝2025-10 璧峰彨銆屾箹鍖楅暱宄″瘜鐑ㄧ豢鐢典緵搴旈摼鏈夐檺鍏徃銆嶏級銆� + 杈撳嚭 14 鍒楋細缁熶竴绀句細淇＄敤浠ｇ爜銆佷紒涓氬悕绉帮紙2026 骞村悕绉帮級銆佸悕绉�2025銆佹槸鍚︽敼鍚嶃�佸競宸炪�佸湴鍖轰唬鐮併�� + 璐ц繍閲忎袱骞村��/澧炲噺/鍚屾瘮銆佸懆杞噺涓ゅ勾鍊�/澧炲噺/鍚屾瘮锛屾寜 2026 骞磋揣杩愰噺闄嶅簭銆� +- **鏌ヨ 8 鍚堣瀵规�绘暟**锛�546 瀹跺彛寰� 2025 骞� 1-8 鏈堣揣杩愰噺 30162.99 涓囧惃 / 鍛ㄨ浆閲� 4637038.58 涓囧惃鍏噷锛� + 2026 骞� 1-8 鏈堣揣杩愰噺 27764.88 涓囧惃 / 鍛ㄨ浆閲� 4392984.81 涓囧惃鍏噷銆� +- 鑴氭湰鍐呴檮涓夌瀵煎嚭鏂瑰紡锛氬懡浠よ `--batch --raw` 瀵� tsv銆丯avicat/Workbench 瀵� xlsx銆乣SELECT ... INTO OUTFILE`銆� + +琛ュ厖娴嬭瘯锛� + +| 缂栧彿 | 绫诲瀷 | 鐢ㄤ緥 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | --- | +| T13 | 姝ｅ悜 | 鏌ヨ 7 鏄庣粏琛屾暟 | 546 琛� | 546 琛岋紝鍏朵腑 1 琛� `鏄惁鏀瑰悕='鏄�'` | 閫氳繃 | +| T14 | 姝ｅ悜 | 鏌ヨ 7 鏄庣粏姹傚拰 = 鏌ヨ 8 鍚堣 | 涓�鑷达紙鍏佽鍥涜垗浜斿叆灏惧樊锛� | 鏄庣粏閫愯鍥涜垗浜斿叆鍚庢眰鍜� 30163.10 / 27764.86 / 4637038.56 / 4392984.78锛屼笌鍚堣宸� 0.01~0.02锛屽睘姝ｅ父灏惧樊 | 閫氳繃 | +| T15 | 姝ｅ悜 | 鍛戒护琛屽鍑猴紙鏂瑰紡涓�锛� | 鐢熸垚 UTF-8 鐨� tsv锛屽惈 546 琛屾暟鎹� | 89046 瀛楄妭銆�546 琛屾暟鎹�佷腑鏂囧垪鍚嶄笌浼佷笟鍚嶆甯� | 閫氳繃 | +| T16 | 杈圭晫 | Excel 鐩存帴鍙屽嚮 tsv | 瀛樺湪涓枃涔辩爜椋庨櫓 | 鏂囦欢涓� UTF-8 鏃� BOM锛屽凡鍦ㄨ剼鏈唴娉ㄦ槑鏀圭敤銆屾暟鎹� 鈫� 浠庢枃鏈�/CSV銆嶅鍏ユ垨鐩存帴瀵� xlsx | 閫氳繃 | +| T17 | 杈圭晫 | 鏄庣粏涓悓姣旈櫎闆� | 鍩烘湡涓� 0 鏃朵笉鎶ラ敊 | `NULLIF(...,0)` 淇濇姢锛岃繑鍥炵┖鍊� | 閫氳繃 | +## 鍏�佽ˉ鍏咃細鏄庣粏灏忔暟浣嶇己闄蜂慨澶嶏紙2026-09-19 杩藉姞锛� + +**闂**锛氳剼鏈師鍏堝湪鏄庣粏绫绘煡璇紙鏌ヨ 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 鏇寸ǔ銆� +## 涔濄�佽ˉ鍏咃細姹囨�荤被鏌ヨ鍚屾鏀逛负 4 浣嶅皬鏁帮紙2026-09-19 杩藉姞锛� + +**鑳屾櫙**锛氱‘璁ゃ��4 浣嶅皬鏁般�嶅鍝簺鍒楃瓑浜庡叏绮惧害鍚庯紝鍐冲畾鎶婃眹鎬荤被鏌ヨ涔熺粺涓�涓� 4 浣嶃�� + +**鍏堝帢娓�"4 浣� = 鍏ㄧ簿搴�"鐨勯�傜敤鑼冨洿**锛堝疄娴� 754 涓紒涓�/淇＄敤浠ｇ爜锛夛細 + +| 鍒� | `ROUND(v,4) <> v` 鐨勫鏁� | 缁撹 | +| --- | --- | --- | +| 璐ц繍閲� 2025 / 2026 | **0 瀹�** | 4 浣嶅嵆鍏ㄧ簿搴︼紙鏁村惃 梅 10000锛屾渶澶� 4 浣嶅皬鏁帮級 | +| 鍛ㄨ浆閲� 2025 / 2026 | **0 瀹�** | 鍚屼笂 | +| 骞冲潎杩愯窛 | 628 / 631 瀹� | **涓嶇瓑浜�**鍏ㄧ簿搴︼紝鏄櫎鍑烘潵鐨勫晢锛岄渶鍗曠嫭瀹氫綅鏁� | +| 鍚屾瘮鐧惧垎姣� | 541 / 754 瀹� | **涓嶇瓑浜�**鍏ㄧ簿搴︼紝鍚屼笂 | + +**澶勭疆**锛� + +- 鏄庣粏绫伙紙鏌ヨ 2銆�7锛夊凡涓嶅 ROUND = 鍏ㄧ簿搴︼紝鏃犻渶鏀瑰姩锛� +- 姹囨�荤被锛堟煡璇� 1銆�3銆�5銆�8锛夌殑 14 澶� `/ 10000, 2)` 鍏ㄩ儴鏀逛负 4 浣嶏紱 +- 椤堕儴銆屸槄 灏忔暟浣嶇害瀹氥�嶅悓姝ユ洿鏂颁负"姹囨�荤被鍚屾牱淇濈暀 4 浣�"锛� +- 椤堕儴涓庢煡璇� 8 娉ㄩ噴閲岀殑瀹炴祴鍊间竴骞舵洿鏂颁负 4 浣嶃�� + +**鍥炲綊楠岃瘉**锛� + +| 缂栧彿 | 绫诲瀷 | 鐢ㄤ緥 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | --- | +| T27 | 姝ｅ悜 | 鏁磋剼鏈噸璺� | 鏃犳姤閿欍�佽鏁颁笉鍙� | 1352 琛岃緭鍑猴紝鏃� ERROR | 閫氳繃 | +| T28 | 姝ｅ悜 | 鏌ヨ 1 姹囨�伙紙545 瀹讹級 | 4 浣嶅皬鏁� | 30153.1392 / 27752.6820 / 4635340.4627 / 4389882.0468 | 閫氳繃 | +| T29 | 姝ｅ悜 | 鏌ヨ 8 鍚堣锛�546 瀹讹級 | 4 浣嶅皬鏁� | 30162.9872 / 27764.8812 / 4637038.5803 / 4392984.8116 | 閫氳繃 | +| T30 | 姝ｅ悜 | 鏌ヨ 5 鍒嗗競宸炰笌浜や粯浠跺榻� | 涓庝氦浠樹欢甯傚窞姹囨�讳竴鑷� | 姝︽眽 9405.2643 / 1501661.4035銆佸疁鏄� 5247.5232 / 449997.1831锛屼笌浜や粯浠跺畬鍏ㄤ竴鑷� | 閫氳繃 | + +**鍓綔鐢ㄤ负闆�**锛氬璐ц繍閲�/鍛ㄨ浆閲忚�岃█ 4 浣嶅氨鏄叏绮惧害锛屽洜姝よ繖娆℃敼鍔ㄦ病鏈変涪澶变换浣曟暟鎹紱 +浣嗚剼鏈緭鍑虹幇鍦ㄤ笌 545 瀹朵氦浠樹欢鐨勫競宸炴眹鎬�**閫愬垪瀵归綈**锛屼袱涓彛寰勪箣闂村彲浠ヤ簰鐩搁獙璇併�� +## 鍗併�佺粨璁� + +8 鏉℃煡璇㈡暣鑴氭湰鎵ц閫氳繃锛�30 鏉＄敤渚嬶紙21 姝ｅ悜 / 2 璐熷悜 / 7 杈圭晫锛夊叏閮ㄩ�氳繃銆� + +**鍚屽悕浼佷笟鍙ｅ緞锛�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 -- Gitblit v1.9.1