| | |
| | | + "create_at \n" + "FROM\n" + "com_mng_volunteer_mng \n" |
| | | + " where state=2 and community_id=#{comMngVolunteerMngVO.communityId}" |
| | | + "<if test='comMngVolunteerMngVO.name != null and comMngVolunteerMngVO.name.trim() != ""'>" |
| | | + " and name like concat(#{comMngVolunteerMngVO.name},'%') \n" + " </if> " |
| | | + " and (name like concat(#{comMngVolunteerMngVO.name},'%') or phone like concat(#{comMngVolunteerMngVO.name},'%') ) \n" + " </if> " |
| | | + "<if test='comMngVolunteerMngVO.phone != null and comMngVolunteerMngVO.phone.trim() != ""'>" |
| | | + "AND phone like concat(#{comMngVolunteerMngVO.phone},'%') " + " </if> " |
| | | + " order by integral desc,create_at desc" + "</script>") |