From 58cafffe66056a31e962409f6fd6ce34e4c3a9ff Mon Sep 17 00:00:00 2001
From: whycq <you@example.com>
Date: 星期日, 08 一月 2023 23:52:55 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/entity/ViewStayTimeBean.java | 8 ++++++++
src/main/resources/mapper/ViewStayTimeMapper.xml | 5 +++++
2 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/entity/ViewStayTimeBean.java b/src/main/java/com/zy/asrs/entity/ViewStayTimeBean.java
index 93815de..840dc02 100644
--- a/src/main/java/com/zy/asrs/entity/ViewStayTimeBean.java
+++ b/src/main/java/com/zy/asrs/entity/ViewStayTimeBean.java
@@ -29,6 +29,14 @@
private Integer row;
+ private Double store_max;
+
+ private Double store_min;
+
+ private Integer store_max_date;
+
+ private Integer sum_qty;
+
@ApiModelProperty(value= "搴撲綅鍙�")
private String loc_no;
diff --git a/src/main/resources/mapper/ViewStayTimeMapper.xml b/src/main/resources/mapper/ViewStayTimeMapper.xml
index 2b01a4f..8a23b69 100644
--- a/src/main/resources/mapper/ViewStayTimeMapper.xml
+++ b/src/main/resources/mapper/ViewStayTimeMapper.xml
@@ -58,6 +58,11 @@
where 1=1
<include refid="viewStayTimeConditionSql"></include>
) t
+ left join (select matnr as c ,store_max_date,store_max,store_min from man_mat) b
+ on t.matnr = b.c
+ left join (select matnr as f,sum(asr_loc_detl.anfme) as sum_qty from asr_loc_detl group by asr_loc_detl.matnr ) as z
+ on z.f= b.c
+
) a where a.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
</select>
--
Gitblit v1.9.1