From 82bcd0328dddbaad65933e2fada22bc68e82b3d5 Mon Sep 17 00:00:00 2001 From: whycq <913841844@qq.com> Date: 星期六, 26 八月 2023 10:07:46 +0800 Subject: [PATCH] # 导入订单增加单据类型 --- src/main/java/com/zy/asrs/service/LocDetlService.java | 27 +++++++++++++++++++++++++++ 1 files changed, 27 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java index 7473a64..dd8f8d1 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.Map; import java.util.Set; public interface LocDetlService extends IService<LocDetl> { @@ -19,7 +20,16 @@ */ boolean updateAnfme(Double anfme, String locNo, String matnr, String batch); + boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String manu, String memo); + boolean updateLocNo(String newLocNo, String oldLocNo); + + /** + * 鑾峰彇鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙� + * @param matnr 浜у搧鍙� + * @return locNo 搴撲綅鍙� + */ + List<String> getSameDetl(String matnr); /** * 鑾峰彇褰撳ぉ鐩稿悓瑙勬牸璐х墿鐨勬繁搴撲綅鍙� @@ -29,6 +39,8 @@ List<String> getSameDetlToday(String matnr, Integer start, Integer end); Page<LocDetl> getStockStatis(Page<LocDetl> page); + Page<LocDetl> getStockStatis2(Page<LocDetl> page); + Page<LocDetl> getStockStatisOut(Page<LocDetl> page); Double getSumAnfme(String matnr); @@ -51,4 +63,19 @@ List<LocDetl> unreason(); + Double selectSumByMatnr(String matnr); + + List<LocDetl> selectGroupPage(Map<String, Object> param, Integer curr, Integer limit); + + List<LocDetl> selectByLocNo(String locNo); + + List<LocDetl> selectByLocNosAndMatnr(List<String> locNos, String matnr); + + List<LocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo);//閫氳繃璁㈠崟鍙枫�佺墿鏂欏彿銆佺墿鏂欏悕绉般�佽鏍笺�佸簱浣嶅彿杩涜妯$硦鎼滅储 + + List<LocDetl> findHighAreaByMatnr(String matnr);//閫氳繃鐗╂枡鍙锋煡璇㈤珮棰戝尯鍩� + + List<LocDetl> findSingleAreaByMatnr(String matnr);//閫氳繃鐗╂枡鍙锋煡璇㈠崟鍝佸尯鍩� + + List<LocDetl> findLowAreaByMatnr(String matnr);//閫氳繃鐗╂枡鍙锋煡璇綆棰戞贩鏀惧尯 } -- Gitblit v1.9.1