From cfbba7b9028dbc5871acd5481a319c82fbf1bde1 Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期六, 03 六月 2023 10:57:29 +0800 Subject: [PATCH] 库位地图优化 --- src/main/java/com/zy/asrs/service/LocDetlService.java | 23 +++++++++++++++++++++-- 1 files changed, 21 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 ef6ee1f..2a0111c 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.Set; public interface LocDetlService extends IService<LocDetl> { @@ -20,9 +21,18 @@ boolean updateLocNo(String newLocNo, String oldLocNo); + int updateStockFreeze(String matnr, String locNo, Integer stockFreeze); + + /** + * 鑾峰彇鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙� + * @param matnr 浜у搧鍙� + * @return locNo 搴撲綅鍙� + */ + List<String> getSameDetl(String matnr); + /** * 鑾峰彇褰撳ぉ鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙� - * @param matnr 鍟嗗搧缂栧彿 + * @param matnr 鐗╂枡鍙� * @return locNo 搴撲綅鍙� */ List<String> getSameDetlToday(String matnr, Integer start, Integer end); @@ -39,10 +49,19 @@ // -------------------------------------------------- - 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(); + + List<LocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo);//閫氳繃璁㈠崟鍙枫�佺墿鏂欏彿銆佺墿鏂欏悕绉般�佽鏍笺�佸簱浣嶅彿杩涜妯$硦鎼滅储 + + List<LocDetl> selectByLocNo(String locNo); + } -- Gitblit v1.9.1