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