From c67e3d0295858a61122354a15dec8835044bac0d Mon Sep 17 00:00:00 2001
From: chen.lin <1442464845@qq.com>
Date: 星期二, 24 二月 2026 15:54:53 +0800
Subject: [PATCH] 库位拣料出库数量调整
---
rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/LocItemMapper.java | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/LocItemMapper.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/LocItemMapper.java
index 574ebca..73fbada 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/LocItemMapper.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/mapper/LocItemMapper.java
@@ -9,10 +9,23 @@
import org.springframework.stereotype.Repository;
import java.util.List;
+import java.util.Map;
@Mapper
@Repository
public interface LocItemMapper extends BaseMapper<LocItem> {
List<LocItem> listByMatnr(@Param("type") String type, @Param("channel") String channel, @Param(Constants.WRAPPER) LambdaQueryWrapper<LocItem> matnr);
+
+ /**
+ * 鎸夌墿鏂橧D姹囨�诲簱浣嶅簱瀛樻暟閲忥紱鍙�夋寜搴撲綅鐘舵�佽繃婊ゃ��
+ * @param matnrIds 鐗╂枡ID鍒楄〃
+ * @param locUseStatus 搴撲綅鐘舵�侊紝涓虹┖鍒欎笉杩囨护
+ * @return 姣忚: matnrId, stockQty, locStatuses(閫楀彿鍒嗛殧鐨勫簱浣嶇姸鎬侊紝浠呭綋 locUseStatus 涓虹┖鏃惰繑鍥�)
+ */
+ /**
+ * 鎸夌墿鏂�+鐘舵��+搴撲綅鍒嗙粍锛氭瘡琛� (matnrId, useStatus, locCode, locQty)銆�
+ * 姹囨�� stockQty 涓庢嫾鎺� "搴撲綅(鏁伴噺)" 鍦� Java 涓畬鎴愶紝鍑忚交鏁版嵁搴撳帇鍔涖��
+ */
+ List<Map<String, Object>> listStockByMatnrIdsGroupByStatusAndLoc(@Param("matnrIds") List<Long> matnrIds, @Param("locUseStatus") String locUseStatus);
}
--
Gitblit v1.9.1