From 47655cdeba92cc4414e41a806093af2cbdaa1ec4 Mon Sep 17 00:00:00 2001
From: tangxiaobao <303826152@qq.com>
Date: 星期五, 16 七月 2021 19:35:21 +0800
Subject: [PATCH] 社区后台基础数据库修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseUserDAO.java | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseUserDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseUserDAO.java
index 2bca9b2..d83ec1a 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseUserDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseUserDAO.java
@@ -27,6 +27,9 @@
@Select("select house_id from com_mng_population_house_user where popul_id = #{populationId}")
List<Long> getPopulationHouseIdByUserId(@Param("populationId") Long populationId);
+ @Select("select relation from com_mng_population_house_user where popul_id = #{populationId}")
+ List<Integer> getPopulationRelationByUserId(@Param("populationId") Long populationId);
+
@Select("select popul_id from com_mng_population_house_user where house_id = #{houseId}")
List<Long> getPopulationHouseIdByhHosueId(@Param("houseId") Long houseId);
--
Gitblit v1.7.1