| | |
|---|
| | | List<Long> getPopulationHouseIdByhHosueId(@Param("houseId") Long houseId); |
|---|
| | | |
|---|
| | | @Select("select cmp.id,cmp.name,cmp.card_no,cmp.phone from com_mng_population_house_user as cmphu " |
|---|
| | | + "left join com_mng_population as cmp on cmp.id = cmphu.popul_id where cmphu.house_id = #{houseId}") |
|---|
| | | + "inner join com_mng_population as cmp on cmp.id = cmphu.popul_id where cmphu.house_id = #{houseId}") |
|---|
| | | List<ComMngPopulationHouseUserAdminVO> getHouseUserByHouseId(@Param("houseId") Long houseId); |
|---|
| | | |
|---|
| | | @Select("update com_mng_population_house_user set relation = null where id = #{id}") |
|---|
