From 2f58ff05571e4d6cb6c0d3977d29119f296f6ec7 Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Wed, 20 Dec 2023 09:23:32 +0800
Subject: [PATCH] 业委会接口模糊查询
---
src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMapper.xml | 2 +-
src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMemberMapper.xml | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMapper.xml b/src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMapper.xml
index 18c88fa..98be200 100644
--- a/src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMapper.xml
+++ b/src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMapper.xml
@@ -19,7 +19,7 @@
<if test="ownersCommittee.longitude != null and ownersCommittee.longitude != ''"> and longitude = #{ownersCommittee.longitude}</if>
<if test="ownersCommittee.location != null and ownersCommittee.location != ''"> and location = #{ownersCommittee.location}</if>
<if test="ownersCommittee.mobile != null and ownersCommittee.mobile != ''"> and mobile = #{ownersCommittee.mobile}</if>
- <if test="ownersCommittee.name != null and ownersCommittee.name != ''"> and name = #{ownersCommittee.name}</if>
+ <if test="ownersCommittee.name != null and ownersCommittee.name != ''"> and name like concat('%',#{ownersCommittee.name},'%') </if>
<if test="ownersCommittee.peopleTotal != null and ownersCommittee.peopleTotal != ''"> and people_total = #{ownersCommittee.peopleTotal}</if>
<if test="ownersCommittee.principalId != null "> and principal_id = #{ownersCommittee.principalId}</if>
<if test="ownersCommittee.principalName != null and ownersCommittee.principalName != ''"> and principal_name = #{ownersCommittee.principalName}</if>
diff --git a/src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMemberMapper.xml b/src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMemberMapper.xml
index 4ad9c23..097e7d6 100644
--- a/src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMemberMapper.xml
+++ b/src/main/java/org/springblade/modules/ownersCommittee/mapper/OwnersCommitteeMemberMapper.xml
@@ -20,7 +20,7 @@
<if test="ownersCommittee.imageUrl != null and ownersCommittee.imageUrl != ''">and image_url = #{ownersCommittee.imageUrl}</if>
<if test="ownersCommittee.joinTime != null ">and join_time = #{ownersCommittee.joinTime}</if>
<if test="ownersCommittee.mobile != null and ownersCommittee.mobile != ''">and mobile = #{ownersCommittee.mobile}</if>
- <if test="ownersCommittee.name != null and ownersCommittee.name != ''">and name = #{ownersCommittee.name}</if>
+ <if test="ownersCommittee.name != null and ownersCommittee.name != ''">and name like concat('%',#{ownersCommittee.name},'%') </if>
<if test="ownersCommittee.ownersCommitteeName != null and ownersCommittee.ownersCommitteeName != ''">and owners_committee_name =
#{ownersCommittee.ownersCommitteeName}
</if>
--
Gitblit v1.9.3