From 0f287f6dfd18b17ae22543f35025efc3bbec24a7 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期四, 23 十一月 2023 13:51:42 +0800
Subject: [PATCH] 优化花城数据查询太慢
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActServiceImpl.java | 63 ++++++++++++++++++++++++++++++-
1 files changed, 61 insertions(+), 2 deletions(-)
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 4652fc7..6e29422 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
@@ -3,11 +3,15 @@
import java.util.ArrayList;
import java.util.Comparator;
import java.util.List;
+import java.util.Map;
import java.util.stream.Collectors;
import javax.annotation.Resource;
import com.panzhihua.common.model.vos.community.ComActPasswordVo;
+import com.panzhihua.common.model.vos.community.ComBasicDataVo;
+import com.panzhihua.common.model.vos.partybuilding.ComPbMemberTypeVO;
+import com.panzhihua.service_community.dao.ComPbMemberDAO;
import com.panzhihua.service_community.util.MyAESUtil;
import org.springframework.beans.BeanUtils;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
@@ -41,6 +45,8 @@
private ComActDAO comActDAO;
@Resource
private ComStreetDAO comStreetDAO;
+ @Resource
+ private ComPbMemberDAO comPbMemberDAO;
/**
* 新增社区
@@ -60,7 +66,13 @@
}
ComActDO comActDO = new ComActDO();
Integer integer =
- comActDAO.selectCount(new QueryWrapper<ComActDO>().lambda().eq(ComActDO::getName, comActVO.getName()));
+ comActDAO.selectCount(new QueryWrapper<ComActDO>().lambda()
+ .eq(ComActDO::getName, comActVO.getName())
+ .eq(ComActDO::getCityCode,comActVO.getCityCode())
+ .eq(ComActDO::getAreaCode,comActVO.getAreaCode())
+ .eq(ComActDO::getProvinceCode,comActVO.getProvinceCode())
+ .eq(ComActDO::getAppId,comActVO.getAppId())
+ );
if (integer > 0) {
return R.fail("社区已经存在");
}
@@ -69,7 +81,9 @@
int insert = comActDAO.insert(comActDO);
if (insert > 0) {
ComActDO comActDO1 =
- comActDAO.selectOne(new QueryWrapper<ComActDO>().lambda().eq(ComActDO::getName, comActVO.getName()));
+ comActDAO.selectOne(new QueryWrapper<ComActDO>().lambda()
+ .eq(ComActDO::getCommunityId, comActVO.getCommunityId())
+ );
BeanUtils.copyProperties(comActDO1, comActVO);
return R.ok(comActVO);
}
@@ -291,5 +305,50 @@
}
return R.ok(comActPasswordVo);
}
+ @Override
+ public R selectIds(Long id){
+ return R.ok(this.comActDAO.selectIds(id));
+ }
+ @Override
+ public R selectBasicData(){
+ //社区数
+ Integer community = comActDAO.countCommunity();
+ //商家数
+ Integer merchants = comActDAO.countMerchants();
+ //党员数
+ Integer pbMember = comActDAO.countPbMember();
+ //报道单位
+ Integer pbUnit = comActDAO.countPbUnit();
+ //实有人口
+ Integer population = comActDAO.countPopulation();
+ //实有房屋
+ Integer populationHouse = comActDAO.countPopulationHouse();
+ //社会组织
+ Integer socialOrg = comActDAO.countSocialOrg();
+ //志愿者
+ Integer volunteer = comActDAO.countVolunteer();
+
+ ComBasicDataVo comBasicDataVo = new ComBasicDataVo();
+ comBasicDataVo.setCommunity(community);
+ comBasicDataVo.setMerchants(merchants);
+ comBasicDataVo.setPbMember(pbMember);
+ comBasicDataVo.setPbUnit(pbUnit);
+ comBasicDataVo.setPopulation(population);
+ comBasicDataVo.setPopulationHouse(populationHouse);
+ comBasicDataVo.setSocialOrg(socialOrg);
+ comBasicDataVo.setVolunteer(volunteer);
+ return R.ok(comBasicDataVo);
+ }
+
+ @Override
+ public R statisticsPbMemberType(){
+ List<ComPbMemberTypeVO> comPbMemberTypeVOS = comPbMemberDAO.statisticsPbMemberType();
+ return R.ok(comPbMemberTypeVOS);
+ }
+
+ public R selectUnitByNatureName(){
+ List<ComPbMemberTypeVO> comPbMemberTypeVOS = comPbMemberDAO.selectUnitByNatureName();
+ return R.ok(comPbMemberTypeVOS);
+ }
}
--
Gitblit v1.7.1