From 00e1f09d1ce3ed8ab3a9976d7b7af7ef558625af Mon Sep 17 00:00:00 2001
From: zyx <zyx123456>
Date: 星期日, 15 十月 2023 16:41:21 +0800
Subject: [PATCH] AGV工作档取消和完成
---
src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java | 7 +++++--
1 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java
index e2e6631..80232bd 100644
--- a/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java
@@ -24,8 +24,11 @@
"\t\tROW_NUMBER() over (order by sum(a.anfme) desc) as row\n" +
"\t\t, a.matnr\n" +
"\t\t, sum(a.anfme) as anfme\n" +
- "\t\tfrom agv_loc_detl a\n" +
- "\t\twhere 1=1\n" +
+// "\t\tfrom agv_loc_detl a\n" +
+// "\t\twhere 1=1\n" +
+// "\t\t<when #{matnr} != '>" +
+// "\t\tAND matnr = #{matnr}" +
+ "\t\t</when>" +
"\t\tgroup by a.matnr\n" +
" ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})")
List<AgvLocDetl> getStockStatis(Map<String, Object> map);
--
Gitblit v1.9.1