| | |
|---|
| | | @Mapper |
|---|
| | | public interface ComMngPopulationHouseDAO extends BaseMapper<ComMngPopulationHouseDO> { |
|---|
| | | |
|---|
| | | @Select("select cmphu.house_id,cmph.address,cmph.status,cmphu.popul_id,cmphu.residence,cmphu.relation_id,cmphu.relation from com_mng_population_house_user cmphu " |
|---|
| | | @Select("select cmphu.id, cmphu.house_id,cmph.address,cmph.status,cmph.purpose,cmph.control_status,cmphu.popul_id,cmphu.residence,cmphu.relation_id,cmphu.relation 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); |
|---|
