From c5a29b860b1488cccd64d688a6da57e4102af3bc Mon Sep 17 00:00:00 2001
From: Junjie <540245094@qq.com>
Date: 星期四, 30 十一月 2023 18:58:03 +0800
Subject: [PATCH] #盘点逻辑修改
---
src/main/resources/mapper/LocMastMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index 2df399a..d26a4e3 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -89,7 +89,7 @@
<foreach item="loc" collection="locNos" index="index" separator="," open="(" close=")">
#{loc}
</foreach>
- and loc_sts != 'O'
+ and loc_sts not in ('O','P')
order by row1
</select>
</mapper>
--
Gitblit v1.9.1