From de7203bde97e80ec0b845f29c158c4b30d876caf Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期三, 15 二月 2023 09:12:19 +0800
Subject: [PATCH] #
---
src/main/resources/mapper/LocMastMapper.xml | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index c6e2029..8f6edd7 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -62,6 +62,7 @@
<foreach item="item" collection="rows" index="index" separator="," open="(" close=")">
#{item}
</foreach>
+ and loc_no not in ('0100101', '0200101', '0300101', '0400101')
and loc_sts = 'O'
group by ctn_no
) a
--
Gitblit v1.9.1