四长四员搜索优化

101captain

2021-10-08 c91666b7cb2d6e7c0b3b95e03043dda9420c2164

四长四员搜索优化

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActFourMemberMapper.xml

@@ -29,7 +29,7 @@
                and t.community_id =#{commonPage.paramId}
            </if>
            <if test="commonPage.position !=null and commonPage.position !=''">
                and t.position like concat(#{commonPage.position},'%')
                and t.position like concat('%',#{commonPage.position},'%')
            </if>
            <if test="commonPage.keyword !=null and commonPage.keyword !=''">
                and (t1.name like concat(#{commonPage.keyword},'%') or t1.phone like concat(#{commonPage.keyword},'%') or t.jurisdiction_content like concat('%',#{commonPage.keyword},'%'))