From 6aeb5730b008eda9f9b6797f457f7a257ec5ed14 Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期五, 18 六月 2021 15:44:47 +0800 Subject: [PATCH] # pda入库时自动查找推荐货位 --- src/main/java/zy/cloud/wms/manager/mapper/LocDetlMapper.java | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/src/main/java/zy/cloud/wms/manager/mapper/LocDetlMapper.java b/src/main/java/zy/cloud/wms/manager/mapper/LocDetlMapper.java index 3446b58..66ca4ee 100644 --- a/src/main/java/zy/cloud/wms/manager/mapper/LocDetlMapper.java +++ b/src/main/java/zy/cloud/wms/manager/mapper/LocDetlMapper.java @@ -23,8 +23,22 @@ Integer reduceStock(@Param("nodeId") Long nodeId, @Param("matnr") String matnr, @Param("anfme") Double anfme); + Integer incrementStock(@Param("nodeId") Long nodeId, @Param("matnr") String matnr, @Param("anfme") Double anfme); + Integer removeStock(@Param("nodeId") Long nodeId, @Param("matnr") String matnr); List<LocDetl> selectByPrior(@Param("matnr") String matnr, @Param("nodeId") Long nodeId); + List<LocDetl> getLocDetlStatis(); + + List<LocDetl> selectByNodeUuid(String uuid); + + List<LocDetl> getStockStatis(Map<String, Object> map); + + Integer getStockStatisCount(Map<String, Object> map); + + List<LocDetl> getStockStatisExcel(); + + Double getStockByDocType34(String matnr); + } -- Gitblit v1.9.1