From 5a8a90c095280fbd2106869ecd2bad10e01a57a6 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期四, 23 十二月 2021 18:10:22 +0800
Subject: [PATCH] 12/23 大屏修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java | 19 +++++++++++++++++--
1 files changed, 17 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
index 2896bac..b37d708 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
@@ -28,7 +28,7 @@
@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);
@@ -164,7 +164,7 @@
+ " 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} " + " </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);
@@ -189,4 +189,19 @@
+ ",#{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);
}
--
Gitblit v1.7.1