| | |
| | | "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() != ""'>" + |
| | | "AND m.`name` = #{name} \n" + |
| | | "mr.community_id = #{partyCommitteeVO.communityId} \n" + |
| | | "<if test='partyCommitteeVO.name != null and partyCommitteeVO.name.trim() != ""'>" + |
| | | "AND m.`name` = #{partyCommitteeVO.name} \n" + |
| | | " </if> " + |
| | | "<if test='roleId != null and roleId.trim() != ""'>" + |
| | | "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); |