| | |
| | | **/ |
| | | @Mapper |
| | | public interface ComActWorkGuideDAO extends BaseMapper<ComActWorkGuideDO> { |
| | | @Select("<script> " + "select id ,title,content,time_at,address,phone,create_at from com_act_work_guide " |
| | | @Select("<script> " + "select id ,title,content,classify,time_at,address,phone,create_at from com_act_work_guide " |
| | | + " <where>" |
| | | + "<if test='pageActWorkGuideDTO.classify != null'>" |
| | | + "and classify = #{pageActWorkGuideDTO.classify} " + " </if> " |
| | | + "<if test='pageActWorkGuideDTO.title != null and pageActWorkGuideDTO.title.trim() != ""'>" |
| | | + "title like concat('%',#{pageActWorkGuideDTO.title},'%')" + " </if> " + " </where>" + "order by update_at asc" |
| | | + "and title like concat('%',#{pageActWorkGuideDTO.title},'%')" + " </if> " + " </where>" + "order by update_at asc" |
| | | + "</script>") |
| | | IPage<ComActWorkGuideVO> pageWorkGuide(Page page, |
| | | @Param("pageActWorkGuideDTO") PageActWorkGuideDTO pageActWorkGuideDTO); |