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/ComActDAO.java |    8 ++++++--
 1 files changed, 6 insertions(+), 2 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java
index 7117797..d0a2fc9 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java
@@ -2,6 +2,7 @@
 
 import java.util.List;
 
+import com.panzhihua.common.model.vos.community.ComActPasswordVo;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 import org.apache.ibatis.annotations.Select;
@@ -62,7 +63,7 @@
     void updateAccountPassword(@Param("password") String password, @Param("account") String account,
         @Param("communityId") Long communityId);
 
-    @Select("select community_id,`name` from com_act where state = 0")
+    @Select("select community_id,`name`,lng,lat from com_act where state = 0")
     List<EventGridCommunityAdminVO> getCommunityLists();
 
     @Select("select ca.`name`,cmsap.province_name,cmsac.city_name,cmsad.district_name,ca.street_id,ca.community_id,cs.`name` as streetName from com_act as ca \n"
@@ -91,6 +92,9 @@
             "HAVING distance >= 0 and distance <= #{communityDTO.distance}   ORDER BY    distance ASC")
     List<CommunitySwitchAllAppletsVO> getCommunityListByNearby(@Param("communityDTO") SearchCommunityDTO communityDTO);
 
-    @Select("select community_id,name from com_act  where state = 0 and area_code = '510423' ")
+    @Select("select community_id,name,lng,lat from com_act  where state = 0 and area_code = '510423' ")
     List<EventGridCommunityAdminVO> getWestCommunityLists();
+
+    @Select("select account,plaintext_password as password from com_act where community_id = #{communityId}")
+    ComActPasswordVo getCommunityPassword(@Param("communityId") Long communityId);
 }

--
Gitblit v1.7.1