| | |
|---|
| | | @Select("update com_mng_population_house_user set relation_id = null where id = #{id}") |
|---|
| | | Integer delBuildingHousePopulationRelationId(@Param("id") Long id); |
|---|
| | | |
|---|
| | | @Select("SELECT " + " cmv.`name` AS villageName, " + " cmph.id, " + " cmv.address, " + " cmph.floor, " |
|---|
| | | @Select("SELECT " + " cmv.`name` AS villageName, " + " cmph.id, " + " cmv.address, " + " cmph.floor,cmphu.relation, " |
|---|
| | | + " cmph.unit_no, " + " cmph.house_no " + "FROM " + " com_mng_population_house_user AS cmphu " |
|---|
| | | + " LEFT JOIN com_mng_population_house AS cmph ON cmph.id = cmphu.house_id " |
|---|
| | | + " LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmph.village_id " + "WHERE " |
|---|
| | |
|---|
| | | + " left join com_mng_population_house as cmph on cmph.id = cmphu.house_id " |
|---|
| | | + " where cmphu.id = #{id}") |
|---|
| | | ComMngHouseVo detail(Long id); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询指定人员是否存在租住的数量 |
|---|
| | | * @param ids 指定实有人口 |
|---|
| | | * @return 存在租住的数量 |
|---|
| | | */ |
|---|
| | | Integer getHouseUserIsRent(@Param("ids") List<Long> ids); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 索引查询 |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | List<ComMngPopulationHouseUserDO> selectListIndex(Long communityId); |
|---|
| | | } |
|---|
