| | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.panzhihua.common.model.vos.community.ComMngStructOtherBuildVO; |
| | | import com.panzhihua.common.model.vos.community.ComMngVolunteerMngVO; |
| | | import com.panzhihua.service_community.model.dos.ComMngVolunteerMngDO; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | |
| | | "`name`,\n" + |
| | | "photo_path,\n" + |
| | | "phone,\n" + |
| | | "integral,\n" + |
| | | "create_at \n" + |
| | | "FROM\n" + |
| | | "com_mng_volunteer_mng \n" + |
| | | " where state=2 " + |
| | | " where state=2 and community_id=#{comMngVolunteerMngVO.communityId}" + |
| | | "<if test='comMngVolunteerMngVO.name != null and comMngVolunteerMngVO.name.trim() != ""'>" + |
| | | " and name = #{comMngVolunteerMngVO.name} \n" + |
| | | " </if> " + |
| | | "<if test='comMngVolunteerMngVO.phone != null and comMngVolunteerMngVO.phone.trim() != ""'>" + |
| | | "AND phone = #{comMngVolunteerMngVO.phone}" + |
| | | " </if> " + |
| | | " order by integral desc,create_at desc"+ |
| | | "</script>") |
| | | IPage<ComMngVolunteerMngVO> pageVolunteer(Page page, @Param("comMngVolunteerMngVO") ComMngVolunteerMngVO comMngVolunteerMngVO); |
| | | |