| | |
|---|
| | | @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 " |
|---|
