| | |
| | | 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.R; |
| | | import com.panzhihua.common.model.vos.community.ComActDynVO; |
| | | import com.panzhihua.common.model.vos.community.ComMngStructAreaVO; |
| | | import com.panzhihua.service_community.model.dos.ComMngStructAreaDO; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | |
| | | "create_at \n" + |
| | | "FROM\n" + |
| | | "com_mng_struct_area \n" + |
| | | "WHERE\n" + |
| | | "community_id = #{comMngStructAreaVO.communityId} \n" + |
| | | "WHERE 1=1 \n" + |
| | | "<if test='comMngStructAreaVO.communityId != null '>" + |
| | | "AND community_id=#{comMngStructAreaVO.communityId} \n" + |
| | | " </if> " + |
| | | "<if test='comMngStructAreaVO.areaName != null and comMngStructAreaVO.areaName.trim() != ""'>" + |
| | | "AND area_name = #{comMngStructAreaVO.areaName}" + |
| | | "AND area_name like concat( '%',#{comMngStructAreaVO.areaName}, '%' )" + |
| | | " </if> " + |
| | | "</script>") |
| | | IPage<ComMngStructAreaVO> pageArea(Page page, @Param("comMngStructAreaVO") ComMngStructAreaVO comMngStructAreaVO); |