From e4ea838c20e94dff4fdbb4f82b542a8b5790fa9d Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期五, 18 六月 2021 09:22:06 +0800 Subject: [PATCH] # 库存跳转上报erp --- src/main/java/zy/cloud/wms/manager/mapper/LocDetlMapper.java | 20 ++++++++++++++++++-- 1 files changed, 18 insertions(+), 2 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 8571c54..66ca4ee 100644 --- a/src/main/java/zy/cloud/wms/manager/mapper/LocDetlMapper.java +++ b/src/main/java/zy/cloud/wms/manager/mapper/LocDetlMapper.java @@ -1,19 +1,21 @@ package zy.cloud.wms.manager.mapper; import com.baomidou.mybatisplus.mapper.BaseMapper; -import com.baomidou.mybatisplus.plugins.Page; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; import zy.cloud.wms.manager.entity.LocDetl; import java.util.List; +import java.util.Map; @Mapper @Repository public interface LocDetlMapper extends BaseMapper<LocDetl> { - List<LocDetl> listByPage(Page page, @Param("nodeId") String nodeId, @Param("locNo") Object locNo, @Param("matnr") Object matnr, @Param("maktx") Object maktx); + List<LocDetl> listByPage(Map<String, Object> map); + + Integer listByPageCount(Map<String, Object> map); LocDetl selectByLocNoAndMatnr(@Param("nodeId")Long nodeId, @Param("matnr")String martnr); @@ -21,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