业委会接口模糊查询

linwe

2023-12-20 2f58ff05571e4d6cb6c0d3977d29119f296f6ec7

业委会接口模糊查询

 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>

 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>