| | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.panzhihua.common.model.dtos.community.PageActWorkGuideDTO; |
| | | import com.panzhihua.common.model.vos.community.ComActWorkGuideVO; |
| | | import com.panzhihua.common.model.vos.community.ComCvtServeVO; |
| | | import com.panzhihua.service_community.model.dos.ComActWorkGuideDO; |
| | | import com.panzhihua.service_community.model.dos.ComMngFamilyDO; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | | import org.springframework.web.bind.annotation.RequestParam; |
| | | |
| | | |
| | | /** |
| | |
| | | @Mapper |
| | | public interface ComActWorkGuideDAO extends BaseMapper<ComActWorkGuideDO> { |
| | | @Select("<script> " + |
| | | "select id ,title,content,time_at,address,phone from com_act_work_guide " + |
| | | "select id ,title,content,time_at,address,phone,create_at from com_act_work_guide " + |
| | | " <where>" + |
| | | "<if test='pageActWorkGuideDTO.title != null and pageActWorkGuideDTO.title.trim() != ""'>" + |
| | | "title like concat('%',#{pageActWorkGuideDTO.title},'%')"+ |
| | | " </if> " + |
| | | " </where>" + |
| | | "order by create_at desc"+ |
| | | "order by update_at asc"+ |
| | | "</script>") |
| | | IPage<ComActWorkGuideVO> pageWorkGuide(Page page, @Param("pageActWorkGuideDTO") PageActWorkGuideDTO pageActWorkGuideDTO); |
| | | } |