| | |
| | | package com.panzhihua.service_community.dao; |
| | | |
| | | 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.dtos.community.PageComActDTO; |
| | | import com.panzhihua.common.model.vos.community.ComActVO; |
| | | import com.panzhihua.service_community.model.dos.ComActDO; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | | |
| | | import java.util.List; |
| | |
| | | " </if> " + |
| | | "</script>") |
| | | List<ComActVO> listCommunity(ComActVO comActVO); |
| | | @Select("select district_name from com_mng_struct_area_district where district_adcode=#{areaCode}") |
| | | String selectAreaName(String areaCode); |
| | | |
| | | @Select("<script> " + |
| | | "select id,"+ |
| | | " <where>" + |
| | | "<if test='nameCn != null and nameCn.trim() != ""'>" + |
| | | " </if> " + |
| | | "<if test='nameCn != null and nameCn.trim() != ""'>" + |
| | | " </if> " + |
| | | "<if test='nameCn != null and nameCn.trim() != ""'>" + |
| | | " </if> " + |
| | | " </where>" + |
| | | "</script>") |
| | | IPage<ComActVO> pageCommunity(Page page, @Param("pageComActDTO") PageComActDTO pageComActDTO); |
| | | } |