From d8c6b9f7dac473ca1684eff210e29f2c83bff8e7 Mon Sep 17 00:00:00 2001
From: doum <doum>
Date: 星期五, 19 九月 2025 09:19:54 +0800
Subject: [PATCH] 最新版本541200007
---
server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/HiddenDangerServiceImpl.java | 78 +++++++++++++++++++++++++--------------
1 files changed, 50 insertions(+), 28 deletions(-)
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/HiddenDangerServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/HiddenDangerServiceImpl.java
index dae7e3b..7db1430 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/HiddenDangerServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/HiddenDangerServiceImpl.java
@@ -869,35 +869,36 @@
}
hiddenDangerDataVO.setCateList(cateGeneralDataList);
}
+
//鍏ㄩ儴闅愭偅鍖哄煙閮ㄩ棬鏁版嵁
- List<HiddenDangerCompanyVO> hiddenDangerCompanyVOList = hiddenDangerAllList.stream().
- filter(i->DateUtil.formatDate(i.getCreateDate(),"yyyy-MM").equals(nowDate.substring(0,7)))
- .map(i->new HiddenDangerCompanyVO(i.getAreaName(),i.getAreaCompanyId())).collect(Collectors.toList());
- if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(hiddenDangerCompanyVOList)){
- List<GeneralDataVO> companyGeneralDataList = new ArrayList<>();
- Set<HiddenDangerCompanyVO> companyIdSetList = new HashSet<>(hiddenDangerCompanyVOList);
- List<Company> companyList = companyMapper.selectList(new QueryWrapper<Company>()
- .lambda().eq(Company::getIsdeleted,Constants.ZERO));
- for (HiddenDangerCompanyVO hiddenDangerCompanyVO:companyIdSetList) {
- if(Objects.isNull(hiddenDangerCompanyVO)
- || Objects.isNull(hiddenDangerCompanyVO.getId())
- || StringUtils.isBlank(hiddenDangerCompanyVO.getCategoryName())){
- continue;
- }
- Optional<Company> optionalCompany = companyList.stream().filter(i->Constants.equalsInteger(i.getId(),hiddenDangerCompanyVO.getId())).findAny();
- if(optionalCompany.isPresent()){
- GeneralDataVO generalDataVO = new GeneralDataVO();
- Company company = optionalCompany.get();
- Integer total = hiddenDangerAllList.stream().filter(i->DateUtil.formatDate(i.getCreateDate(),"yyyy-MM").
- equals(nowDate.substring(0,7))&&Constants.equalsInteger(i.getAreaCompanyId(),company.getId())).collect(Collectors.toList()).size();
- generalDataVO.setName(company.getName());
- generalDataVO.setTotal(total);
- generalDataVO.setCategoryName(hiddenDangerCompanyVO.getCategoryName());
- companyGeneralDataList.add(generalDataVO);
- }
- }
- hiddenDangerDataVO.setDepartmentList(companyGeneralDataList);
- }
+// List<HiddenDangerCompanyVO> hiddenDangerCompanyVOList = hiddenDangerAllList.stream().
+// filter(i->DateUtil.formatDate(i.getCreateDate(),"yyyy-MM").equals(nowDate.substring(0,7)))
+// .map(i->new HiddenDangerCompanyVO(i.getAreaName(),i.getAreaCompanyId())).collect(Collectors.toList());
+// if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(hiddenDangerCompanyVOList)){
+// List<GeneralDataVO> companyGeneralDataList = new ArrayList<>();
+// Set<HiddenDangerCompanyVO> companyIdSetList = new HashSet<>(hiddenDangerCompanyVOList);
+// List<Company> companyList = companyMapper.selectList(new QueryWrapper<Company>()
+// .lambda().eq(Company::getIsdeleted,Constants.ZERO));
+// for (HiddenDangerCompanyVO hiddenDangerCompanyVO:companyIdSetList) {
+// if(Objects.isNull(hiddenDangerCompanyVO)
+// || Objects.isNull(hiddenDangerCompanyVO.getId())
+// || StringUtils.isBlank(hiddenDangerCompanyVO.getCategoryName())){
+// continue;
+// }
+// Optional<Company> optionalCompany = companyList.stream().filter(i->Constants.equalsInteger(i.getId(),hiddenDangerCompanyVO.getId())).findAny();
+// if(optionalCompany.isPresent()){
+// GeneralDataVO generalDataVO = new GeneralDataVO();
+// Company company = optionalCompany.get();
+// Integer total = hiddenDangerAllList.stream().filter(i->DateUtil.formatDate(i.getCreateDate(),"yyyy-MM").
+// equals(nowDate.substring(0,7))&&Constants.equalsInteger(i.getAreaCompanyId(),company.getId())).collect(Collectors.toList()).size();
+// generalDataVO.setName(company.getName());
+// generalDataVO.setTotal(total);
+// generalDataVO.setCategoryName(hiddenDangerCompanyVO.getCategoryName());
+// companyGeneralDataList.add(generalDataVO);
+// }
+// }
+// hiddenDangerDataVO.setDepartmentList(companyGeneralDataList);
+// }
// if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(hiddenDangerDataVO.getDepartmentList())){
// List<GeneralDataVO> topList = hiddenDangerDataVO.getDepartmentList();
// Collections.sort(topList, new Comparator<GeneralDataVO>() {
@@ -913,6 +914,27 @@
}
+ List<Map<String,Object>> companyMapList = hiddenDangerMapper.selectJoinMaps(new MPJLambdaWrapper<HiddenDanger>()
+ .select(" t2.name as companyName , count(1) total ")
+ .leftJoin(HiddenDangerParam.class,HiddenDangerParam::getId,HiddenDanger::getAreaId)
+ .leftJoin(Company.class,Company::getId,HiddenDangerParam::getCompanyId)
+ .eq(HiddenDanger::getIsdeleted,Constants.ZERO)
+ .apply(" DATE_FORMAT(t.CREATE_DATE, '%Y%M') = DATE_FORMAT(now(), '%Y%M') ")
+ .groupBy(" t2.name")
+ );
+ if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(companyMapList)){
+ List<GeneralDataVO> list = new ArrayList<>();
+ for (Map<String,Object> map:companyMapList) {
+ GeneralDataVO generalDataVO = new GeneralDataVO();
+ generalDataVO.setTotal(Integer.valueOf(map.get("total").toString()));
+ generalDataVO.setName(map.get("companyName").toString());
+ list.add(generalDataVO);
+ }
+ hiddenDangerDataVO.setDepartmentList(list);
+ }
+
+
+
List<Map<String,Object>> mapList = hiddenDangerMapper.selectJoinMaps(new MPJLambdaWrapper<HiddenDanger>()
.select(" t1.name as cateName,t2.name as companyName , count(1) total ")
.leftJoin(HiddenDangerParam.class,HiddenDangerParam::getId,HiddenDanger::getAreaId)
--
Gitblit v1.9.3