package com.panzhihua.service_community.dao;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
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);
|
|
}
|
