From 56678dd52e0e25afa36612f1be4a1d3ef0f4a82c Mon Sep 17 00:00:00 2001
From: zjj <3272660260@qq.com>
Date: 星期五, 20 十二月 2024 13:39:39 +0800
Subject: [PATCH] #明细统计总计修改可查看当前查询物料总计
---
src/main/java/com/zy/asrs/service/LocDetlService.java | 24 ++++++++++++++++++++++--
1 files changed, 22 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java
index dcc7369..47cdf55 100644
--- a/src/main/java/com/zy/asrs/service/LocDetlService.java
+++ b/src/main/java/com/zy/asrs/service/LocDetlService.java
@@ -6,9 +6,12 @@
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> {
+
+ Page<LocDetl> getPage(Page<LocDetl> page);
LocDetl selectItem(String locNo, String matnr, String batch);
@@ -28,6 +31,14 @@
*/
List<String> getSameDetlToday(String matnr, Integer start, Integer end);
+ /**
+ * 鑾峰彇褰撳ぉ鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙�
+ * @param matnr 鍟嗗搧缂栧彿
+ * @param batch 鎵规鍙�
+ * @return locNo 搴撲綅鍙�
+ */
+ List<String> getSameDetlToday(String matnr, String batch, Integer start, Integer end);
+
Page<LocDetl> getStockStatis(Page<LocDetl> page);
Double getSumAnfme(String matnr);
@@ -40,16 +51,25 @@
// --------------------------------------------------
- List<LocDetl> queryStock(String matnr, String batch, String orderNo, Set<String> locNos);
+ List<LocDetl> queryStock(String matnr, String batch, String orderNo, Set<String> locNos,String supp);
+ List<LocDetl> queryStockCrn(String matnr, String batch, String orderNo, Set<String> locNos,String supp);
+ List<LocDetl> queryStockFour(String matnr, String batch, String orderNo, Set<String> locNos,String supp);
+ List<LocDetl> queryStockMinAnfme(String matnr, String batch, String orderNo, Set<String> locNos,String supp);
Double queryStockAnfme(String matnr, String batch);
List<StockVo> queryStockTotal();
- Integer sum();
+ Double sum();
List<LocDetl> unreason();
Double getLocDetlSumQty(String locNo);
+
+ void updateMatTurn(String matnrOld,String matnr);
+
+ List<Map<String, Object>> selectLocDetlUnilateralMoveShuttleMap(Integer crnNo);
+
+ List<LocDetl> selectLocDetlUnilateralMoveShuttle(String matnr,String batch,String grade,Integer crnNo);
}
--
Gitblit v1.9.1