From 6dc62990c5f356ce8c1dc810e28cd638d30ae1a5 Mon Sep 17 00:00:00 2001
From: cl <1442464845@qq.com>
Date: 星期三, 15 四月 2026 14:40:59 +0800
Subject: [PATCH] 严格使用delete=0
---
rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/LocItemController.java | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/LocItemController.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/LocItemController.java
index ccbde80..5712e0a 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/LocItemController.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/LocItemController.java
@@ -51,7 +51,7 @@
QueryWrapper<LocItem> wrapper = pageParam.buildWrapper(true);
if (useStatus != null && StringUtils.isNotBlank(useStatus.toString())) {
String status = useStatus.toString().replace("'", "''");
- wrapper.apply("EXISTS (SELECT 1 FROM man_loc ml WHERE ml.id = man_loc_item.loc_id AND ml.use_status = '" + status + "')");
+ wrapper.apply("EXISTS (SELECT 1 FROM man_loc ml WHERE ml.id = man_loc_item.loc_id AND ml.use_status = '" + status + "' AND ml.deleted = 0)");
}
FieldsUtils.setFieldsFilters(wrapper, pageParam, LocItem.class);
@@ -72,6 +72,7 @@
}
}
}
+ locItemService.fillSpecModelFromMatnrForRecords(records);
page.setRecords(records);
return R.ok().add(page);
@@ -87,6 +88,7 @@
"EXISTS (SELECT 1 FROM man_loc ml " +
"WHERE ml.use_status = '%s'" +
"AND ml.id = man_loc_item.loc_id " +
+ "AND ml.deleted = 0" +
")",
LocStsType.LOC_STS_TYPE_F.type
);
@@ -107,6 +109,7 @@
}
}
}
+ locItemService.fillSpecModelFromMatnrForRecords(records);
page.setRecords(records);
return R.ok().add(page);
--
Gitblit v1.9.1