From e235d483194ab95bf62d1cfd343a172ff12781e8 Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期六, 13 四月 2024 14:58:24 +0800
Subject: [PATCH] 聚乳酸库存明细 1.批号与包号排序需同步，增加水分，挥发段，分解段搜索，按照最大最小范围，包装类型跟托盘类型增加删选功能。 2.已经出库的物料，在明细表里面隐藏掉，但是数据保留。 3.增加二个跟聚乳酸一样的明细表，分改性树脂，纯树脂库存明细表，所有功能跟总的聚乳酸库存明细表一样 4.明细表整体框架调整一下，相对压缩一下，搜索功能框看看能否弄成二行 5.表里面的包装类型与托盘类型这些不主要的信息放到指标后面 6.关于分包再处理，举例原有系统里面销售选定的10包物料，再二次重新弄后，车间打印新标签，使用新的包号，在明细表里面体现原有所有指标信息及批号，包号，牌号跟新的关联 7.出库时候时间可选历史，不要就只能出现4天 8.提取库存里面需要有最大包号跟最小包号选择
---
src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java | 33 ++++++++++++++++++++++++++++++---
1 files changed, 30 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java
index 03dc5a3..2c6b748 100644
--- a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java
@@ -1,6 +1,9 @@
package com.zy.asrs.mapper;
import com.baomidou.mybatisplus.mapper.BaseMapper;
+import com.zy.asrs.entity.LocDetl;
+import com.zy.asrs.entity.LocDetlWarningDTO;
+import com.zy.asrs.entity.LocMast;
import com.zy.asrs.entity.ManLocDetl;
import com.zy.asrs.entity.result.StockVo;
import org.apache.ibatis.annotations.Mapper;
@@ -11,7 +14,6 @@
import java.util.List;
import java.util.Map;
-import java.util.Set;
@Mapper
@Repository
@@ -53,7 +55,7 @@
// -------------------------------------------------
- List<ManLocDetl> queryStock(@Param("matnr")String matnr, @Param("batch")String batch, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos);
+ List<ManLocDetl> queryStock(@Param("matnr") String matnr,@Param("batch") String batch);
Double queryStockAnfme(String matnr, String batch);
@@ -68,6 +70,31 @@
int updateLocNo0(Long nodeId, String locNo);
- List<ManLocDetl> selectLocNo0(String locNo, String matnr);
+ ManLocDetl selectLocNo0(String locNo, String matnr);
+
+ List<ManLocDetl> selectItem0(String locNo, String matnr);
+
int deleteLocNo0(String locNo, String matnr);
+
+ int updateAnfme0(double anfme, Long nodeId);
+
+ List<ManLocDetl> listByOutPage(Map<String, Object> condition);
+
+ long listByOutPageCount(Map<String, Object> condition);
+
+ List<ManLocDetl> selectAllPage(Map<String, Object> condition);
+
+ long selectAllPageSize(Map<String, Object> condition);
+
+ ManLocDetl selectInventory(@Param("LocNo") String LocNo,@Param("matnr") String Matnr,@Param("batch") String batch);
+
+ int deleteDatailed (String locNo, String matnr,String batch);
+
+ int increase(Double anfme,String locNo, String matnr,String batch,Double weight);
+
+ List<LocDetlWarningDTO> selectAllWarning();
+
+ int updateStockFreeze(String matnr, String locNo, Integer stockFreeze);
+
+ List<LocDetl> selectByLocNo(String locNo);;
}
--
Gitblit v1.9.1