From 568e38a95cb6fb20fe16b53d17f610aefc6f744f Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期四, 09 十月 2025 18:29:29 +0800
Subject: [PATCH] 钉钉通知 与钥匙柜开发

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/HiddenDangerServiceImpl.java |   96 ++++++++++++++++++++++++++++++++++--------------
 1 files changed, 68 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..bc8fae7 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
@@ -7,6 +7,7 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.doumee.biz.system.SystemDictDataBiz;
 import com.doumee.core.constants.ResponseStatus;
+import com.doumee.core.dingTalk.DingTalk;
 import com.doumee.core.exception.BusinessException;
 import com.doumee.dao.business.dao.*;
 import com.doumee.dao.business.vo.GeneralDataVO;
@@ -98,6 +99,9 @@
 
     @Autowired
     private ApproveMapper approveMapper;
+
+    @Autowired
+    private DingTalk dingTalk;
 
 
     @Override
@@ -247,6 +251,13 @@
                     systemDictDataBiz.queryByCode(Constants.WX_PLATFORM,Constants.WX_PLATFORM_ACCESS_TOKEN).getCode(),
                     Arrays.asList(checkUser.getOpenid().split(",")));
         }
+
+        if(StringUtils.isNotBlank(member.getDdId())){
+            dingTalk.workInfoOANotice(Long.valueOf(systemDictDataBiz.queryByCode(Constants.DD_TALK,Constants.AGENT_ID).getCode()),
+                    member.getDdId(),
+                    dingTalk.getHiddenDangerNoticeMsg(hiddenDanger));
+        }
+
         return hiddenDanger.getId();
     }
 
@@ -794,6 +805,13 @@
                     systemDictDataBiz.queryByCode(Constants.WX_PLATFORM,Constants.WX_PLATFORM_ACCESS_TOKEN).getCode(),
                     Arrays.asList(checkUser.getOpenid().split(",")));
         }
+
+        if(StringUtils.isNotBlank(member.getDdId())){
+            dingTalk.workInfoOANotice(Long.valueOf(systemDictDataBiz.queryByCode(Constants.DD_TALK,Constants.AGENT_ID).getCode()),
+                    member.getDdId(),
+                    dingTalk.getHiddenDangerNoticeMsg(hiddenDanger));
+        }
+
     }
 
 
@@ -869,35 +887,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 +932,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