From 2c1f34d284e66e5973aa6817cda2856fbb06789e Mon Sep 17 00:00:00 2001
From: ZY <zc857179121@qq.com>
Date: 星期二, 13 八月 2024 14:56:37 +0800
Subject: [PATCH] 出库逻辑调整
---
src/main/resources/mapper/LocDetlMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 2e3491f..d45615b 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -256,7 +256,7 @@
<!-- </if>-->
<if test="model != null and model != ''">
and a.model = #{model}
- and (a.pg_no is null or LENGTH(TRIM(pg_no)) = 0)
+ and (a.pg_no is null or LEN(LTRIM(RTRIM(pg_no))) = 0)
</if>
<if test="locNos != null and locNos.size > 0">
--
Gitblit v1.9.1