| | |
|---|
| | | IPage<ComMngVolunteerMngVO> pageVolunteer(Page page, |
|---|
| | | @Param("comMngVolunteerMngVO") ComMngVolunteerMngVO comMngVolunteerMngVO); |
|---|
| | | |
|---|
| | | @Select("<script> " + "SELECT\n" + "t.id,\n" + "t.`name`,\n" + "t.state,\n" + "t.phone,\n" + "t.apply_reson,\n" |
|---|
| | | + "t.create_at, " + "t.submit_user_id \n" + "FROM\n" + "com_mng_volunteer_mng t\n" + " RIGHT JOIN \n" |
|---|
| | | + "(select submit_user_id, MAX(create_at)create_at from com_mng_volunteer_mng where state IN ( 1, 3 ) GROUP BY submit_user_id ) tmp \n" |
|---|
| | | + "on t.create_at = tmp.create_at and t.submit_user_id=tmp.submit_user_id " + "WHERE\n" |
|---|
| | | + "state in (1,3) and community_id = ${comMngVolunteerMngVO.communityId} \n" |
|---|
| | | + "<if test='comMngVolunteerMngVO.name != null and comMngVolunteerMngVO.name.trim() != ""'>" |
|---|
| | | + "and t.name like concat(#{comMngVolunteerMngVO.name},'%') \n" + " </if> " |
|---|
| | | + "<if test='comMngVolunteerMngVO.phone != null and comMngVolunteerMngVO.phone.trim() != ""'>" |
|---|
| | | + "AND t.phone like concat(#{comMngVolunteerMngVO.phone},'%')\n" + " </if> " |
|---|
| | | + "<if test='comMngVolunteerMngVO.state != null and comMngVolunteerMngVO.state != 0'>" |
|---|
| | | + "and t.state=#{comMngVolunteerMngVO.state}\n" + " </if> " + " \tORDER BY t.state asc " + "</script>") |
|---|
| | | IPage<ComMngVolunteerMngVO> pageVolunteerExamine(Page page, |
|---|
| | | @Param("comMngVolunteerMngVO") ComMngVolunteerMngVO comMngVolunteerMngVO); |
|---|
| | | |
|---|
| | |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | List<ComMngVolunteerMngVO> selectVolunteerByCommunityId(@Param("communityId") Long communityId); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 志愿者审核详情 |
|---|
| | | * @param id |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | ComMngVolunteerMngVO detailVolunteerExamine(@Param("communityId") Long id); |
|---|
| | | } |
|---|
