From f08a5ea16b9fd30d7832ac33d9c0ae3fae122102 Mon Sep 17 00:00:00 2001
From: cl <1442464845@qq.com>
Date: 星期日, 05 四月 2026 19:13:45 +0800
Subject: [PATCH] 重量1
---
src/main/java/com/zy/asrs/mapper/LocDetlMapper.java | 13 ++++++++++++-
1 files changed, 12 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
index a8b4dc9..72ed623 100644
--- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
@@ -2,6 +2,7 @@
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.LocDetl;
+import com.zy.asrs.entity.param.ExportParam;
import com.zy.asrs.entity.result.LocDetlAll;
import com.zy.asrs.entity.result.LocDetlDTO;
import com.zy.asrs.entity.result.StockVo;
@@ -11,6 +12,7 @@
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;
+import java.math.BigDecimal;
import java.util.List;
import java.util.Map;
import java.util.Set;
@@ -39,6 +41,10 @@
@Param("brand")String brand,@Param("standby1")String standby1,@Param("standby2")String standby2,
@Param("standby3")String standby3,@Param("boxType1")String boxType1,@Param("boxType2")String boxType2,@Param("boxType3")String boxType3 );
+ int updateWeight(@Param("weight") BigDecimal weight, @Param("locNo") String locNo, @Param("matnr") String matnr, @Param("batch") String batch,
+ @Param("brand") String brand, @Param("standby1") String standby1, @Param("standby2") String standby2,
+ @Param("standby3") String standby3, @Param("boxType1") String boxType1, @Param("boxType2") String boxType2, @Param("boxType3") String boxType3);
+
List<LocDetl> getStockOutPage(Map<String, Object> map);
Integer getStockOutPageCount(Map<String, Object> map);
@@ -52,7 +58,8 @@
List<String> selectSameDetlTodayBatch(@Param("matnr") String matnr,@Param("batch") String batch, @Param("start") Integer start, @Param("end") Integer end);
List<LocDetl> getStockStatis(Map<String, Object> map);
-
+ List<LocDetl> selectStatisForExport(ExportParam param);
+ List<LocDetl> selectStockStatisExport( ExportParam param);
Integer getStockStatisCount(Map<String, Object> map);
List<LocDetl> getStockStatis2(Map<String, Object> map);
@@ -77,8 +84,12 @@
List<LocDetl> queryStockAll(@Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos, @Param("matnr")String matnr, @Param("batch")String batch,
@Param("brand")String brand,@Param("standby1")String standby1,@Param("standby2")String standby2,
@Param("standby3")String standby3,@Param("boxType1")String boxType1,@Param("boxType2")String boxType2);
+ List<LocDetl> queryStockAll7(@Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos, @Param("matnr")String matnr, @Param("standby1")String standby1,@Param("standby2")String standby2,
+ @Param("standby3")String standby3,@Param("boxType1")String boxType1,@Param("boxType2")String boxType2,@Param("boxType3")String boxType3);
+ List<LocDetl> queryStockAll123(@Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos, @Param("matnr")String matnr, @Param("boxType3")String boxType3);
Double queryStockAnfme(String matnr, String batch);
+ List<LocDetl> queryStockMatnr(@Param("matnr")String matnr);
List<StockVo> queryStockTotal();
--
Gitblit v1.9.1