From 58dc66a9d999c7d350e1ee4bf32b8d85b6e20e00 Mon Sep 17 00:00:00 2001
From: ZY <zc857179121@qq.com>
Date: 星期六, 21 九月 2024 10:32:42 +0800
Subject: [PATCH] 逻辑调整

---
 src/main/java/asr_show_diff.sql |   31 ++++++++++++++++---------------
 1 files changed, 16 insertions(+), 15 deletions(-)

diff --git a/src/main/java/asr_show_diff.sql b/src/main/java/asr_show_diff.sql
index 35e983a..4282ce4 100644
--- a/src/main/java/asr_show_diff.sql
+++ b/src/main/java/asr_show_diff.sql
@@ -3,21 +3,23 @@
 	SUM ( erpQty ) erpQty,
 	matnr,
 	maktx,
-	pgNo,
-	outOrderNo,
-	batch,
-	model ,specs
+	MIN ( pgNo ) pgNo,
+	MIN ( outOrderNo ) outOrderNo,
+	MIN ( batch ) batch,
+	model,
+	MIN ( specs ) specs
 FROM
 	(
 	SELECT CAST
 		( SUM ( anfme ) AS INT ) asrsQty,
-		0 AS erpQty,
-		matnr,
+		0 AS erpQty,	matnr,
 		model,
+
 		maktx,
 		pg_no AS pgNo,
 		out_order_no AS outOrderNo,
-		batch ,specs
+		batch,
+		specs
 	FROM
 		asr_loc_detl
 	GROUP BY
@@ -26,7 +28,8 @@
 		pg_no,
 		out_order_no,
 		batch,
-		model,specs UNION ALL
+		model,
+		specs UNION ALL
 	SELECT
 		0,
 		CAST ( SUM ( numis ) AS INT ),
@@ -35,15 +38,16 @@
 		itemname,
 		'' AS pgNo,
 		'' AS outOrderNo,
-		itembatch AS batch
-		,itemSpc specs
+		itembatch AS batch,
+		itemSpc specs
 	FROM
 		( SELECT * FROM OPENROWSET ( 'SQLOLEDB', '192.168.1.147,1800'; 'XGMLK'; 'xunda0413', XDLinkLK.dbo.vwErpLKStorage ) WHERE LKName = '涓壃浜屾湡' ) a
 	GROUP BY
 		itemid,
 		itemcode,
 		itemname,
-		itembatch ,itemSpc
+		itembatch,
+		itemSpc
 	) b
 WHERE
 	1 = 1
@@ -51,7 +55,4 @@
 GROUP BY
 	matnr,
 	model,
-	maktx,
-	pgNo,
-	outOrderNo,
-	batch,specs
\ No newline at end of file
+	maktx
\ No newline at end of file

--
Gitblit v1.9.1