From 7658be06a4f6ed1ed24c41d7c5a2f0602ffbe660 Mon Sep 17 00:00:00 2001 From: lsh <lsh@163.com> Date: 星期六, 21 十二月 2024 14:59:14 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/service/LocDetlService.java | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 52 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 80a64a6..26a2b1d 100644 --- a/src/main/java/com/zy/asrs/service/LocDetlService.java +++ b/src/main/java/com/zy/asrs/service/LocDetlService.java @@ -2,18 +2,36 @@ import com.baomidou.mybatisplus.plugins.Page; import com.baomidou.mybatisplus.service.IService; +import com.core.common.R; +import com.zy.asrs.entity.FrozenParam; import com.zy.asrs.entity.LocDetl; +import com.zy.asrs.entity.result.LocDetlAll; +import com.zy.asrs.entity.result.LocDetlDTO; +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); + + List<LocDetlAll> selectAllOwner(LocDetlDTO locDetlDTO); + + int selectAllCount(LocDetlDTO locDetlDTO); + + + LocDetl selectItem(String locNo, String matnr, String batch); + Page<LocDetl> getStockOut(Page<LocDetl> page); + + Page<LocDetl> getStockStatis2(Page<LocDetl> page); /** * 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏋滄暟閲忎负0锛屽垯鍒犻櫎璁板綍 */ - boolean updateAnfme(Double anfme, String locNo, String matnr); + boolean updateAnfme(Double anfme, String locNo, String matnr, String batch); boolean updateLocNo(String newLocNo, String oldLocNo); @@ -23,6 +41,14 @@ * @return locNo 搴撲綅鍙� */ 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); @@ -36,8 +62,32 @@ // -------------------------------------------------- - List<LocDetl> queryStock(String matnr, String batch, String orderNo); + List<LocDetl> queryStock(String matnr, String batch, String orderNo, Set<String> locNos); Double queryStockAnfme(String matnr, String batch); + List<StockVo> queryStockTotal(); + + + Integer 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); + + /** + * 鍐荤粨搴撳瓨 + */ + R frozenInventory(List<FrozenParam> param); + + /** + * 搴撳瓨瑙e喕 + */ + R unfreezeInventory(List<FrozenParam> param); } -- Gitblit v1.9.1