From eba6f98d5b5bc4c7e004d6837f1000de04c40956 Mon Sep 17 00:00:00 2001
From: Fancy <Fancy.fx@outlook.com>
Date: 星期三, 31 七月 2024 13:31:16 +0800
Subject: [PATCH] disabled filter
---
pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml | 5 ++++-
pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml | 5 ++++-
2 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml
index 975b7eb..7df4e08 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml
@@ -86,7 +86,7 @@
</if>
<if test="disabled != null and disabled != ''">
t.disabled != 1 and
-<!-- -- FIND_IN_SET(t.disabled, #{disabled}) and-->
+ <!--FIND_IN_SET(t.disabled, #{disabled}) and-->
</if>
</trim>
order by sort desc
@@ -108,6 +108,9 @@
<if test="item != null and item != ''">
t.item like concat('%', #{item}, '%') and
</if>
+ <if test="disabled != null and disabled != ''">
+ t.disabled != 1 and
+ </if>
</trim>
</select>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml
index 454b8b8..dba3670 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml
@@ -40,7 +40,7 @@
</if>
<if test="disabled != null and disabled != ''">
t.disabled != 1 and
-<!-- FIND_IN_SET(t.disabled, #{disabled}) and-->
+ <!--FIND_IN_SET(t.disabled, #{disabled}) and-->
</if>
</trim>
</select>
@@ -57,6 +57,9 @@
<if test="item != null and item != ''">
t.item like concat('%', #{item}, '%') and
</if>
+ <if test="disabled != null and disabled != ''">
+ t.disabled != 1 and
+ </if>
</trim>
order by sort desc
<trim prefix="limit " >
--
Gitblit v1.8.0