From 6f4481ecb7292de5f781ab85f5892ab8175cfc55 Mon Sep 17 00:00:00 2001
From: 王佳豪 <g675230687@126.com>
Date: 星期一, 31 五月 2021 13:34:34 +0800
Subject: [PATCH] 库存统计排序按商品名称
---
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