From 6d67e37ab96516f127e1635e92518109fd1c926c Mon Sep 17 00:00:00 2001
From: cl <1442464845@qq.com>
Date: 星期二, 21 四月 2026 14:06:11 +0800
Subject: [PATCH] 料箱码查询优化
---
rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java
index e6d89f7..c45f662 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/MatnrServiceImpl.java
@@ -295,8 +295,9 @@
queryWrapper.in(!longs.isEmpty(),"group_id", longs);
// 鍑哄簱閫夌墿鏂欙細鎸夊簱浣嶇姸鎬佺瓫閫夛紙浠呭睍绀哄湪璇ュ簱浣嶇姸鎬佷笅鏈夋湁鏁堝簱瀛樼殑鐗╂枡锛屼笌 listStockByMatnrIds 鍙ｅ緞涓�鑷达細鎺掗櫎宸插垹鏄庣粏涓庡凡鍒犲簱浣嶏級
if (locUseStatus != null && StringUtils.isNotBlank(locUseStatus.toString())) {
- String useStatus = locUseStatus.toString().replace("'", "''");
- queryWrapper.apply("EXISTS (SELECT 1 FROM man_loc_item li INNER JOIN man_loc l ON li.loc_id = l.id AND (l.deleted = 0 OR l.deleted IS NULL) WHERE li.matnr_id = man_matnr.id AND li.deleted = 0 AND l.use_status = '" + useStatus + "')");
+ queryWrapper.apply(
+ "EXISTS (SELECT 1 FROM man_loc_item li INNER JOIN man_loc l ON li.loc_id = l.id AND l.deleted = 0 WHERE li.matnr_id = man_matnr.id AND li.deleted = 0 AND l.use_status = {0})",
+ locUseStatus.toString().trim());
}
FieldsUtils.setFieldsFilters(queryWrapper,pageParam,Matnr.class);
--
Gitblit v1.9.1