| | |
| | | @Select("select popul_id from com_mng_population_house_user where house_id = #{houseId}") |
| | | List<Long> getPopulationHouseIdByhHosueId(@Param("houseId") Long houseId); |
| | | |
| | | @Select("select cmp.name,cmp.card_no,cmp.phone from com_mng_population_house_user as cmphu " + |
| | | @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}") |
| | | List<ComMngPopulationHouseUserAdminVO> getHouseUserByHouseId(@Param("houseId") Long houseId); |
| | | |