From 1a4b45c6109d0b5b30ee96cc76d744b54069aa2e Mon Sep 17 00:00:00 2001 From: huanghongfa <huanghongfa123456> Date: 星期六, 18 十二月 2021 13:52:09 +0800 Subject: [PATCH] 添加通过社区id获取社区登录账号密码接口 --- springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/BigScreenStatisticsApi.java | 9 ++++ springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java | 8 ++++ springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActPasswordVo.java | 20 ++++++++++ springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java | 4 ++ springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActServiceImpl.java | 8 +++ springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/BigScreenStatisticsApi.java | 8 ++++ springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActService.java | 2 + springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActDO.java | 5 ++ 8 files changed, 63 insertions(+), 1 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActPasswordVo.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActPasswordVo.java new file mode 100644 index 0000000..320a576 --- /dev/null +++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActPasswordVo.java @@ -0,0 +1,20 @@ +package com.panzhihua.common.model.vos.community; + +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +/** + * @author lyq + * 社区账号密码返回参数 + */ +@Data +@ApiModel("社区账号密码返回参数") +public class ComActPasswordVo { + + @ApiModelProperty("账号") + private String account; + + @ApiModelProperty("密码") + private String password; +} diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java index 92bfaa4..eb53135 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java +++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java @@ -7438,4 +7438,12 @@ @GetMapping("/screen/getComprehensiveStreetList") R getComprehensiveStreetList(); + + /** + * 通过社区id查询社区账号密码 + * @param communityId 社区id + * @return 查询社区账号密码 + */ + @GetMapping("/screen/getCommunityPassword") + R getCommunityPassword(@RequestParam("communityId") Long communityId); } diff --git a/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/BigScreenStatisticsApi.java b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/BigScreenStatisticsApi.java index 6f193c7..a925393 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/BigScreenStatisticsApi.java +++ b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/BigScreenStatisticsApi.java @@ -231,4 +231,13 @@ comActDynVO.setStatus(1); return communityService.pageDynamic(comActDynVO); } + + @ApiOperation(value = "通过社区id查询社区账号密码") + @PostMapping("/get/community/password") + public R getCommunityPassword(@RequestParam("communityId") Long communityId) { + if(communityId == null){ + return R.fail("参数错误"); + } + return communityService.getCommunityPassword(communityId); + } } diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/BigScreenStatisticsApi.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/BigScreenStatisticsApi.java index 7104796..a117c42 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/BigScreenStatisticsApi.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/BigScreenStatisticsApi.java @@ -2,6 +2,7 @@ import javax.annotation.Resource; +import com.panzhihua.service_community.service.ComActService; import org.springframework.web.bind.annotation.*; import com.panzhihua.common.model.dtos.community.bigscreen.BigScreenEventDTO; @@ -18,6 +19,8 @@ @Resource private ComMngPopulationService comMngPopulationService; + @Resource + private ComActService comActService; /** * 首页大屏统计接口 @@ -97,4 +100,9 @@ return comMngPopulationService.getComprehensiveStreetList(); } + + @GetMapping("/getCommunityPassword") + public R getCommunityPassword(@RequestParam("communityId") Long communityId){ + return comActService.getCommunityPassword(communityId); + } } 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 90afe3b..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; @@ -93,4 +94,7 @@ @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); } diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActDO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActDO.java index f8ba627..1d5b424 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActDO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActDO.java @@ -110,4 +110,9 @@ */ private Long streetId; + /** + * 明文密码 + */ + private String plaintextPassword; + } diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActService.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActService.java index 7fcc3ae..49d7a86 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActService.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComActService.java @@ -111,4 +111,6 @@ * @return 社区列表 */ R communitySwitchSearchDistanceList(SearchCommunityDTO communityDTO); + + R getCommunityPassword(Long communityId); } diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActServiceImpl.java index efc18c1..e80ef41 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActServiceImpl.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActServiceImpl.java @@ -63,6 +63,7 @@ return R.fail("社区已经存在"); } BeanUtils.copyProperties(comActVO, comActDO); + comActDO.setPlaintextPassword(password); int insert = comActDAO.insert(comActDO); if (insert > 0) { ComActDO comActDO1 = @@ -91,6 +92,7 @@ if (!ObjectUtils.isEmpty(password)) { String encode = new BCryptPasswordEncoder().encode(password); comActVO.setPassword(encode); + comActDO.setPlaintextPassword(password); a = 1; } ComStreetDO comStreetDO = comStreetDAO.selectById(comActVO.getStreetId()); @@ -101,7 +103,6 @@ // a=1; // } BeanUtils.copyProperties(comActVO, comActDO); - // ComActDO selectOne = comActDAO.selectOne(new QueryWrapper<ComActDO>().lambda().eq(ComActDO::getAccount, account)); // if (null != selectOne && selectOne.getAccount().equals(comActVO.getAccount())) { // return R.fail("该登录账号重复,请重新修改"); @@ -271,4 +272,9 @@ return R.ok(this.comActDAO.getCommunityListByNearby(communityDTO)); } + @Override + public R getCommunityPassword(Long communityId){ + return R.ok(comActDAO.getCommunityPassword(communityId)); + } + } -- Gitblit v1.7.1