党员管理搜索使用模糊查询

huanghongfa

2021-01-13 a3feb2cf14ccd885be490a27f57da063df7f5dad

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberDAO.java

@@ -57,13 +57,13 @@
            "LEFT JOIN com_pb_org o ON m.org_id = o.id"+
            " where m.community_id=#{pagePartyOrganizationVO.communityId} " +
            "<if test='pagePartyOrganizationVO.orgName != null and pagePartyOrganizationVO.orgName.trim() != &quot;&quot;'>" +
            "and o.name=#{pagePartyOrganizationVO.orgName}"+
            "and o.name = #{pagePartyOrganizationVO.orgName}"+
            " </if> " +
            "<if test='pagePartyOrganizationVO.account != null and pagePartyOrganizationVO.account.trim() != &quot;&quot;'>" +
            "and u.phone=#{pagePartyOrganizationVO.account}"+
            "and u.phone like concat (#{pagePartyOrganizationVO.account},'%')"+
            " </if> " +
            "<if test='pagePartyOrganizationVO.name != null and pagePartyOrganizationVO.name.trim() != &quot;&quot;'>" +
            "and m.name=#{pagePartyOrganizationVO.name}"+
            "and m.name like concat (#{pagePartyOrganizationVO.name},'%')"+
            " </if> " +

            "order by m.join_time desc "+