huanghongfa
2020-12-06 22c0fa7dfd9d558ac09b4239101b6ae47b085573
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberRoleDAO.java
@@ -29,12 +29,12 @@
            "JOIN com_pb_member m ON mr.member_id = m.id\n" +
            "JOIN sys_role r ON mr.role_id = r.role_id \n" +
            "WHERE\n" +
            "mr.community_id = #{communityId} \n" +
            "<if test='communityId != null and communityId.trim() != &quot;&quot;'>" +
            "AND m.`name` = #{name} \n" +
            "mr.community_id = #{partyCommitteeVO.communityId} \n" +
            "<if test='partyCommitteeVO.name != null and partyCommitteeVO.name.trim() != &quot;&quot;'>" +
            "AND m.`name` = #{partyCommitteeVO.name} \n" +
            " </if> " +
            "<if test='roleId != null and roleId.trim() != &quot;&quot;'>" +
            "AND r.role_id =#{roleId}" +
            "<if test='partyCommitteeVO.roleId != null and partyCommitteeVO.roleId != 0'>" +
            "AND r.role_id =#{partyCommitteeVO.roleId}" +
            " </if> " +
            "</script>")
    IPage<PartyCommitteeVO> pagePartyOrganization(Page page, @Param("partyCommitteeVO") PartyCommitteeVO partyCommitteeVO);