From 56a6e23e02f33d851a4882a20a0739081f308a23 Mon Sep 17 00:00:00 2001 From: LSH Date: 星期五, 02 十二月 2022 08:10:15 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/service/LocDetlService.java | 51 ++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 50 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java index f9d29c7..e4d53c5 100644 --- a/src/main/java/com/zy/asrs/service/LocDetlService.java +++ b/src/main/java/com/zy/asrs/service/LocDetlService.java @@ -3,11 +3,60 @@ import com.baomidou.mybatisplus.plugins.Page; import com.baomidou.mybatisplus.service.IService; import com.zy.asrs.entity.LocDetl; +import com.zy.asrs.entity.result.StockVo; +import org.apache.ibatis.annotations.Param; + +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); + Page<LocDetl> getStockOut(Page<LocDetl> page); - boolean updateAnfme(Double anfme, String locNo, String matnr); + /** + * 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏋滄暟閲忎负0锛屽垯鍒犻櫎璁板綍 + */ + boolean updateAnfme(Double anfme, String locNo, String matnr, String batch); + boolean updateLocNo(String newLocNo, String oldLocNo); + + /** + * 鑾峰彇褰撳ぉ鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙� + * @param matnr 鍟嗗搧缂栧彿 + * @return locNo 搴撲綅鍙� + */ + List<String> getSameDetlToday(String matnr, Integer start, Integer end); + + Page<LocDetl> getStockStatis(Page<LocDetl> page); + + Double getSumAnfme(String matnr); + + List<LocDetl> selectPakoutByRule(String matnr); + + List<LocDetl> getAsrsLocDetl(String matnr); + + Integer countLocNoNum(String locNo); + + // -------------------------------------------------- + + List<LocDetl> queryStock(String matnr, String batch, String orderNo, Set<String> locNos); + + List<LocDetl> queryStockOther(String matnr, String batch, String orderNo, Set<String> locNos,String locNo); + + + Double queryStockAnfme(String matnr, String batch); + + List<StockVo> queryStockTotal(); + + + Integer sum(); + + List<LocDetl> unreason(); + + Double getLocDetlSumQty(String locNo); } -- Gitblit v1.9.1