| | |
|---|
| | | @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); |
|---|
| | |
|---|
| | | + " LEFT JOIN com_mng_population AS cmp ON cmp.id = cmphu.popul_id " |
|---|
| | | + " left join com_mng_population_community_tags AS cmpct on cmp.id = cmpct.population_id " + "WHERE " |
|---|
| | | + " cmphu.house_id = #{houseId} " + "<if test='relation != null '>" + " AND cmphu.relation = #{relation} " |
|---|
| | | + " </if> " + "<if test='relationId != null '>" + " AND cmphu.relation_id = #{relationId} " + " group by id </if> " |
|---|
| | | + " </if> " + "<if test='relationId != null '>" + " AND cmphu.relation_id = #{relationId} " + "</if> group by id " |
|---|
| | | + " </script>") |
|---|
| | | List<PopulationListVO> getGridVillageBuildingPopulationList(@Param("houseId") Long houseId, |
|---|
| | | @Param("relation") Integer relation, @Param("relationId") Integer relationId); |
|---|
| | |
|---|
| | | + ",#{item.purpose},#{item.controlStatus},#{item.isEmpty},#{item.constructPurpose}" |
|---|
| | | + ",#{item.constructArea},#{item.path},now())" + " </foreach>" + " </script>") |
|---|
| | | void insertAll(@Param("houseList") List<ComMngPopulationHouseDO> houseList); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 修改房屋关联单元号 |
|---|
| | | * @param villageId 小区id |
|---|
| | | * @param floor 楼栋号 |
|---|
| | | * @param oldUnitNo 原单元号 |
|---|
| | | * @param newUnitNo 新单元号 |
|---|
| | | */ |
|---|
| | | void updateHouseUnit(@Param("villageId") Long villageId, @Param("floor") String floor,@Param("oldUnitNo") String oldUnitNo,@Param("newUnitNo") String newUnitNo); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 修改房屋关联单元号 |
|---|
| | | * @param houseList 需要修改的数据 |
|---|
| | | */ |
|---|
| | | void updateUnitAll(@Param("houseList") List<ComMngPopulationHouseDO> houseList); |
|---|
| | | } |
|---|
