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