From 668e40d51e654104287a3f63c7fd856657a35a11 Mon Sep 17 00:00:00 2001
From: zyx <zyx123456>
Date: 星期四, 19 十月 2023 11:39:46 +0800
Subject: [PATCH] Merge branch 'tzskasrs' of http://47.97.1.152:5880/r/zy-asrs into tzskasrs
---
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