党建接口测试ok

huanghongfa

2020-12-06 22c0fa7dfd9d558ac09b4239101b6ae47b085573

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

@@ -33,6 +33,7 @@
    @Select("<script> " +
            "SELECT\n" +
            "o.`name` orgName,\n" +
            "m.id_card,\n"+
            "m.`id`,\n" +
            "u.phone,\n" +
            "m.`name`,\n" +
@@ -52,14 +53,14 @@
            "LEFT JOIN sys_user u ON m.id_card = u.id_card\n" +
            "LEFT JOIN com_pb_org o ON m.org_id = o.id"+
            " <where>" +
            "<if test='orgName != null and orgName.trim() != &quot;&quot;'>" +
            "o.name=#{orgName}"+
            "<if test='pagePartyOrganizationVO.orgName != null and pagePartyOrganizationVO.orgName.trim() != &quot;&quot;'>" +
            "and o.name=#{pagePartyOrganizationVO.orgName}"+
            " </if> " +
            "<if test='account != null and account.trim() != &quot;&quot;'>" +
            "u.phone=#{account}"+
            "<if test='pagePartyOrganizationVO.account != null and pagePartyOrganizationVO.account.trim() != &quot;&quot;'>" +
            "and u.phone=#{pagePartyOrganizationVO.account}"+
            " </if> " +
            "<if test='name != null and name.trim() != &quot;&quot;'>" +
            "m.name=#{name}"+
            "<if test='pagePartyOrganizationVO.name != null and pagePartyOrganizationVO.name.trim() != &quot;&quot;'>" +
            "and m.name=#{pagePartyOrganizationVO.name}"+
            " </if> " +
            " </where>" +
            "</script>")