package com.panzhihua.service_community.dao;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.panzhihua.common.model.vos.community.ComMngCascadeHouseVO;
|
import com.panzhihua.common.model.vos.user.ComMngHouseVo;
|
import com.panzhihua.service_community.model.dos.ComMngPopulationHouseDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* @auther lyq
|
* @create 2021-05-18 09:26:31
|
* @describe 社区管理》小区管理》实有房屋mapper类
|
*/
|
@Mapper
|
public interface ComMngPopulationHouseDAO extends BaseMapper<ComMngPopulationHouseDO> {
|
|
@Select("select cmphu.house_id,cmph.address,cmph.status from com_mng_population_house_user cmphu " +
|
" left join com_mng_population_house as cmph on cmph.id = cmphu.house_id " +
|
" where cmphu.popul_id = #{populId}")
|
List<ComMngHouseVo> getPopulHouseListByPopulId(@Param("populId")Long populId);
|
|
@Select("<script> " +
|
"select id,alley from com_mng_population_house" +
|
"<if test='name != null and name != ""'>" +
|
"and c.alley = #{name}" +
|
" </if> " +
|
" </script>")
|
List<ComMngCascadeHouseVO> getHouseLevelByAlley(@Param("name") String name);
|
|
|
|
}
|
