From d6dcba598b79f39aeea515f5121e8ec40830e13b Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期四, 03 十一月 2022 13:56:26 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/mapper/LocDetlMapper.java | 2 +-
src/main/resources/mapper/LocDetlMapper.xml | 11 ++++++++++-
src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java | 2 +-
src/main/java/com/zy/common/model/QueryStockPreDo.java | 2 ++
4 files changed, 14 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
index b848faa..ab04539 100644
--- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
@@ -56,7 +56,7 @@
List<QueryStockPreDo> queryStockPre(@Param("matnr")String matnr);
- List<LocDetl> queryStock(@Param("matnr")String matnr, @Param("no") Integer no, @Param("bay") Integer bay);
+ List<LocDetl> queryStock(@Param("matnr")String matnr, @Param("no") Integer no, @Param("orderBy") String orderBy, @Param("bay") Integer bay);
Double queryStockAnfme(String matnr, String batch);
diff --git a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
index 5c33af8..2488944 100644
--- a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
@@ -87,7 +87,7 @@
List<LocDetl> result = new ArrayList<>();
List<QueryStockPreDo> preDos = this.baseMapper.queryStockPre(matnr);
for (QueryStockPreDo preDo : preDos) {
- List<LocDetl> locDetls = this.baseMapper.queryStock(matnr, preDo.getNo(), preDo.getBay());
+ List<LocDetl> locDetls = this.baseMapper.queryStock(matnr, preDo.getNo(), preDo.getOrderBy(), preDo.getBay());
result.addAll(locDetls);
}
return result;
diff --git a/src/main/java/com/zy/common/model/QueryStockPreDo.java b/src/main/java/com/zy/common/model/QueryStockPreDo.java
index f959804..28df782 100644
--- a/src/main/java/com/zy/common/model/QueryStockPreDo.java
+++ b/src/main/java/com/zy/common/model/QueryStockPreDo.java
@@ -14,4 +14,6 @@
private Double count;
+ private String orderBy;
+
}
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 56989cd..4965f71 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -231,6 +231,7 @@
(
select
no = 1,
+ orderBy = 'false',
b.bay1 as bay,
sum(anfme) as count
from asr_loc_detl a
@@ -244,6 +245,7 @@
union
select
no = 2,
+ orderBy = 'true',
b.bay1,
sum(anfme) as count
from asr_loc_detl a
@@ -257,6 +259,7 @@
union
select
no = 3,
+ orderBy = 'false',
b.bay1,
sum(anfme) as count
from asr_loc_detl a
@@ -270,6 +273,7 @@
union
select
no = 4,
+ orderBy = 'true',
b.bay1,
sum(anfme) as count
from asr_loc_detl a
@@ -283,6 +287,7 @@
union
select
no = 5,
+ orderBy = 'false',
b.bay1,
sum(anfme) as count
from asr_loc_detl a
@@ -296,6 +301,7 @@
union
select
no = 6,
+ orderBy = 'true',
b.bay1,
sum(anfme) as count
from asr_loc_detl a
@@ -365,7 +371,10 @@
and a.matnr = #{matnr}
and b.bay1 = #{bay}
and b.loc_sts = 'F'
- order by b.row1 asc
+ order by b.row1
+ <if test="orderBy != null and orderBy != '' and orderBy == 'false'">
+ desc
+ </if>
</select>
<select id="queryStockAnfme" resultType="java.lang.Double">
--
Gitblit v1.9.1