From 0671b22545b660cae46568ba7f6a14f52cad8ad8 Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期一, 02 九月 2024 16:35:17 +0800
Subject: [PATCH] 查询在库时长
---
src/main/java/com/zy/asrs/entity/InLocTimeDto.java | 20 ++++++++++
src/main/java/com/zy/asrs/mapper/LocDetlMapper.java | 6 +++
src/main/java/com/zy/asrs/controller/OpenController.java | 9 ++++
src/main/resources/mapper/LocDetlMapper.xml | 14 +++++++
src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java | 15 +++++++
src/main/java/com/zy/asrs/service/OpenService.java | 5 ++
6 files changed, 69 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/OpenController.java b/src/main/java/com/zy/asrs/controller/OpenController.java
index 7dcd4a7..d3bef2b 100644
--- a/src/main/java/com/zy/asrs/controller/OpenController.java
+++ b/src/main/java/com/zy/asrs/controller/OpenController.java
@@ -95,6 +95,15 @@
return openService.zwmsOutLocWork(param);
}
+ @PostMapping("/cxzk")
+ @AppAuth(memo = "鏍规嵁鍖呰缁勫彿鏌ヨ鍦ㄥ簱鏃堕棿-MES璋冪敤")
+ public synchronized R queryInLocTime(@RequestHeader(required = false) String appkey,
+ @RequestBody List<String> param,
+ HttpServletRequest request) {
+ auth(appkey, param, request);
+ return openService.queryInLocTime(param);
+ }
+
@PostMapping("/ckjgsb")
@AppAuth(memo = "璐х墿鍒拌揪鍑哄簱鍙ｄ互鍚庯紝涓婃姤鍑哄簱缁撴灉")
public synchronized R outLocResultReport(@RequestHeader(required = false) String appkey,
diff --git a/src/main/java/com/zy/asrs/entity/InLocTimeDto.java b/src/main/java/com/zy/asrs/entity/InLocTimeDto.java
new file mode 100644
index 0000000..76af217
--- /dev/null
+++ b/src/main/java/com/zy/asrs/entity/InLocTimeDto.java
@@ -0,0 +1,20 @@
+package com.zy.asrs.entity;
+
+import lombok.Data;
+
+/**
+ * @author pang.jiabao
+ * @description 鏌ヨ鍖呰缁勫彿鍦ㄥ簱鏃堕棿鍙嶅弬
+ * @createDate 2024/9/2 15:58
+ */
+@Data
+public class InLocTimeDto {
+ /**
+ * 鍖呰缁勫彿
+ */
+ private String packageGroupNo;
+ /**
+ * 鐩稿樊澶╂暟
+ */
+ private int diffDay;
+}
diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
index aa12bf6..51be533 100644
--- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
@@ -1,6 +1,7 @@
package com.zy.asrs.mapper;
import com.baomidou.mybatisplus.mapper.BaseMapper;
+import com.zy.asrs.entity.InLocTimeDto;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.result.StockVo;
import org.apache.ibatis.annotations.Mapper;
@@ -80,4 +81,9 @@
* 鎵归噺鎻掑叆搴撳瓨鏄庣粏
*/
int batchDetls(@Param("locDetls") List<LocDetl> locDetls);
+
+ /**
+ * 鏌ヨ鍖呰缁勫彿鍦ㄥ簱鏃堕棿
+ */
+ List<InLocTimeDto> queryInLocTime(@Param("param") List<String> param);
}
diff --git a/src/main/java/com/zy/asrs/service/OpenService.java b/src/main/java/com/zy/asrs/service/OpenService.java
index bf1a4a2..3b7fe2e 100644
--- a/src/main/java/com/zy/asrs/service/OpenService.java
+++ b/src/main/java/com/zy/asrs/service/OpenService.java
@@ -51,6 +51,11 @@
R zwmsOutLocWork(ZwmsOutLocWorkDto param);
/**
+ * 鏍规嵁鍖呰缁勫彿鏌ヨ鍦ㄥ簱鏃堕棿-MES璋冪敤
+ */
+ R queryInLocTime(List<String> param);
+
+ /**
* 璐х墿鍒拌揪鍑哄簱鍙ｄ互鍚庯紝涓婃姤鍑哄簱缁撴灉
*/
String outLocResultReport(GhjtApiParam param);
diff --git a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
index 350a9e3..2e72a50 100644
--- a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
@@ -13,6 +13,7 @@
import com.zy.asrs.entity.result.StockVo;
import com.zy.asrs.entity.result.ZphjcdgzVo;
import com.zy.asrs.entity.result.ZphjcdwcVo;
+import com.zy.asrs.mapper.LocDetlMapper;
import com.zy.asrs.mapper.MatMapper;
import com.zy.asrs.mapper.TagMapper;
import com.zy.asrs.service.*;
@@ -96,6 +97,9 @@
@Resource
private MatMapper matMapper;
+
+ @Resource
+ private LocDetlMapper locDetlMapper;
@Override
@Transactional
@@ -1421,6 +1425,17 @@
}
@Override
+ public R queryInLocTime(List<String> param) {
+ if (Cools.isEmpty(param)) {
+ return R.parse("鍙傛暟涓嶈兘涓虹┖");
+ }
+
+ List<InLocTimeDto> inLocTimeDtos = locDetlMapper.queryInLocTime(param);
+
+ return R.ok(inLocTimeDtos);
+ }
+
+ @Override
@Transactional
public String outLocResultReport(GhjtApiParam param) {
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index fd62acb..da73127 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -374,6 +374,20 @@
from asr_loc_detl
where loc_no=#{locNo}
</select>
+ <select id="queryInLocTime" resultType="com.zy.asrs.entity.InLocTimeDto">
+ select
+ brand packageGroupNo,
+ DATEDIFF(day, appe_time , getdate()) diffDay
+ from
+ asr_loc_detl
+ where brand in
+ <foreach collection="param" index="index" item="item" separator="," open="(" close=")">
+ #{item}
+ </foreach>
+ group by
+ brand,
+ appe_time
+ </select>
<update id="updateMatTurn">
UPDATE a
--
Gitblit v1.9.1