| | |
| | | "and o.name=#{pagePartyOrganizationVO.orgName}"+ |
| | | " </if> " + |
| | | "<if test='pagePartyOrganizationVO.account != null and pagePartyOrganizationVO.account.trim() != ""'>" + |
| | | "and u.phone=#{pagePartyOrganizationVO.account}"+ |
| | | "and u.phone like concat (#{pagePartyOrganizationVO.account},'%')"+ |
| | | " </if> " + |
| | | "<if test='pagePartyOrganizationVO.name != null and pagePartyOrganizationVO.name.trim() != ""'>" + |
| | | "and m.name=#{pagePartyOrganizationVO.name}"+ |
| | | "and m.name like concat (#{pagePartyOrganizationVO.name},'%')"+ |
| | | " </if> " + |
| | | |
| | | "order by m.join_time desc "+ |