| | |
| | | "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() != ""'>" + |
| | | "and o.name = #{pagePartyOrganizationVO.orgName}"+ |
| | | "and o.name like concat(#{pagePartyOrganizationVO.orgName},'%') "+ |
| | | " </if> " + |
| | | "<if test='pagePartyOrganizationVO.account != null and pagePartyOrganizationVO.account.trim() != ""'>" + |
| | | "and u.phone like concat (#{pagePartyOrganizationVO.account},'%')"+ |