From 6a9b23334a99483ffdab9bbcf3a29eb830b3d77a Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期五, 26 五月 2023 08:46:02 +0800
Subject: [PATCH] 库位地图
---
src/main/java/com/zy/asrs/service/LocDetlService.java | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java
index a068386..81aca94 100644
--- a/src/main/java/com/zy/asrs/service/LocDetlService.java
+++ b/src/main/java/com/zy/asrs/service/LocDetlService.java
@@ -6,6 +6,7 @@
import com.zy.asrs.entity.result.StockVo;
import java.util.List;
+import java.util.Map;
import java.util.Set;
public interface LocDetlService extends IService<LocDetl> {
@@ -19,7 +20,16 @@
*/
boolean updateAnfme(Double anfme, String locNo, String matnr, String batch);
+ boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String manu, String memo);
+
boolean updateLocNo(String newLocNo, String oldLocNo);
+
+ /**
+ * 鑾峰彇鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙�
+ * @param matnr 浜у搧鍙�
+ * @return locNo 搴撲綅鍙�
+ */
+ List<String> getSameDetl(String matnr);
/**
* 鑾峰彇褰撳ぉ鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙�
@@ -29,6 +39,7 @@
List<String> getSameDetlToday(String matnr, Integer start, Integer end);
Page<LocDetl> getStockStatis(Page<LocDetl> page);
+ Page<LocDetl> getStockStatis2(Page<LocDetl> page);
Double getSumAnfme(String matnr);
@@ -48,4 +59,12 @@
Integer sum();
+
+ List<LocDetl> unreason();
+
+ Double selectSumByMatnr(String matnr);
+
+ List<LocDetl> selectGroupPage(Map<String, Object> param, Integer curr, Integer limit);
+
+ List<LocDetl> selectByLocNo(String locNo);
}
--
Gitblit v1.9.1