From 2848d4f884e973df73df2d70bdca0b0f2743e205 Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期二, 04 六月 2024 18:22:56 +0800
Subject: [PATCH] 代码初始化

---
 server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java    |    2 
 server/visits/dmvisit_service/src/main/java/com/doumee/dao/web/response/InternalHomeVO.java               |   11 ++
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java      |   72 ++++++++++++++++++
 server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingListResponse.java         |    2 
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java       |    2 
 server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java                  |    7 +
 server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java       |    9 ++
 server/system_service/src/main/java/com/doumee/dao/system/model/Notices.java                              |    6 
 server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/StagingCloudController.java              |   16 ++++
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/HiddenDangerServiceImpl.java |   84 +++++++++++++++++++++
 10 files changed, 203 insertions(+), 8 deletions(-)

diff --git a/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java b/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java
index e8e58bc..c5f169e 100644
--- a/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java
+++ b/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java
@@ -22,9 +22,10 @@
 
 
 
-    @Select(" select a.id , b.`NAME` as roomName , a.`NAME` as meetingName  ,date_format(a.START_TIME,'%Y-%m-%d') as meetingDate , a.START_TIME as startTime, a.status ," +
+    @Select(" select a.id , a.START_TIME , a.END_TIME , b.`NAME` as roomName , a.`NAME` as meetingName  ,date_format(a.START_TIME,'%Y-%m-%d') as meetingDate , a.START_TIME as startTime, a.status ," +
             " CONCAT(date_format(a.START_TIME,'%H:%i') , ' ~ ',date_format(a.END_TIME,'%H:%i')) as meetingTime,  c.REALNAME as bookingUser ," +
-            " CASE  WHEN a.START_TIME > now() and a.`STATUS` = 0  THEN 1  WHEN a.END_TIME < now()  or a.`STATUS` = 1  THEN 3 ELSE 2  END meetingStatus , b.IMGURL as imgUrl " +
+            " CASE  WHEN a.START_TIME > now() and a.`STATUS` = 0  THEN 1  WHEN a.END_TIME < now()  or a.`STATUS` = 1  THEN 3 ELSE 2  END meetingStatus , b.IMGURL as imgUrl ," +
+            " a.remark  " +
             " from meeting_book a inner join meeting_rooms b  on a.ROOM_ID = b.ID  " +
             " inner join system_user c on a.CREATOR = c.id  " +
             " ${ew.customSqlSegment} ")
@@ -32,7 +33,7 @@
 
 
 
-    @Select(" select a.id , b.id as roomId,  b.`NAME` as roomName , a.`NAME` as meetingName  ,date_format(a.START_TIME,'%Y骞�%m鏈�%d鏃�') as meetingDate ," +
+    @Select(" select a.id , a.START_TIME , a.END_TIME , b.id as roomId,  b.`NAME` as roomName , a.`NAME` as meetingName  ,date_format(a.START_TIME,'%Y骞�%m鏈�%d鏃�') as meetingDate ," +
             " CONCAT(date_format(a.START_TIME,'%H:%i') , ' ~ ',date_format(a.END_TIME,'%H:%i')) as meetingTime,  c.REALNAME as bookingUserName ," +
             " CASE  WHEN a.START_TIME > now() and a.`STATUS` = 0  THEN 1  WHEN a.END_TIME < now()  or a.`STATUS` = 1  THEN 3 ELSE 2  END meetingStatus ," +
             " a.CONTENT as meetingContent, c.MOBILE as bookingUserMobile , e.`NAME` as bookingUserDepartment , a.CREATOR as bookingUserId  , a.remark  " +
diff --git a/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java b/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java
index 46178bd..401eae4 100644
--- a/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java
+++ b/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java
@@ -8,6 +8,7 @@
 import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
 
+import java.util.Date;
 import java.util.List;
 
 /**
@@ -35,6 +36,14 @@
     @ApiModelProperty(value = "浼氳鏃ユ湡")
     private String meetingDate;
 
+
+    @ApiModelProperty(value = "寮�濮嬫椂闂�")
+    private Date startTime;
+
+    @ApiModelProperty(value = "缁撴潫鏃堕棿")
+    private Date endTime;
+
+
     @ApiModelProperty(value = "浼氳鏃堕棿 ( a ~ b)")
     private String meetingTime;
 
diff --git a/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingListResponse.java b/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingListResponse.java
index 4c21bae..01d666c 100644
--- a/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingListResponse.java
+++ b/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingListResponse.java
@@ -33,6 +33,8 @@
     @ApiModelProperty(value = "浼氳鏃堕棿 ( a ~ b)")
     private String meetingTime;
 
+    @ApiModelProperty(value = "澶囨敞")
+    private String remark;
 
     @ApiModelProperty(value = "浼氳寮�濮嬫椂闂�",hidden = true)
     private Date startTime;
diff --git a/server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java b/server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java
index 08a1744..021421e 100644
--- a/server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java
+++ b/server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java
@@ -745,7 +745,7 @@
                 .apply(" id in ( select u.OBJ_ID from meeting_user_rel u where u.USER_ID = '" + userId + "' and u.ISDELETED = 0 and OBJ_TYPE = 1  ) ")
                 .eq("ISDELETED",MeetConstants.ZERO)
 //                .eq("STATUS",MeetConstants.ZERO)
-                .apply(" ROOM_ID in ( select r.id from rooms r where r.ISDELETED = 0 and r.STATUS = 0  )")
+                .apply(" ROOM_ID in ( select r.id from meeting_rooms r where r.ISDELETED = 0 and r.STATUS = 0  )")
                 .like(StringUtils.isNotBlank(dateMsg), "START_TIME", dateMsg));
     }
 
diff --git a/server/system_service/src/main/java/com/doumee/dao/system/model/Notices.java b/server/system_service/src/main/java/com/doumee/dao/system/model/Notices.java
index 2b76c44..d591321 100644
--- a/server/system_service/src/main/java/com/doumee/dao/system/model/Notices.java
+++ b/server/system_service/src/main/java/com/doumee/dao/system/model/Notices.java
@@ -79,8 +79,8 @@
     @ExcelColumn(name="鍏宠仈瀵硅薄鍚嶇О")
     private String objName;
 
-    @ApiModelProperty(value = "绫诲瀷")
-    @ExcelColumn(name="绫诲瀷")
+    @ApiModelProperty(value = "绫诲瀷 0璁垮瀹℃壒 1璁垮鎶ュ 2鐢ㄨ溅瀹℃壒 3闅愭偅澶勭悊 4鐗╂祦杞﹀鎵� 5绯荤粺绯荤粺")
+    @ExcelColumn(name="绫诲瀷 0璁垮瀹℃壒 1璁垮鎶ュ 2鐢ㄨ溅瀹℃壒 3闅愭偅澶勭悊 4鐗╂祦杞﹀鎵� 5绯荤粺绯荤粺")
     private Integer type;
 
     @ApiModelProperty(value = "绫诲瀷鎻忚堪")
@@ -96,7 +96,7 @@
     @ExcelColumn(name="鍏宠仈鍙傛暟2")
     private String param2;
 
-    @ApiModelProperty(value = "鍏宠仈鍙傛暟3")
+    @ApiModelProperty(value = "鍏宠仈鍙傛暟3",notes = "鍙戣捣浜�")
     @ExcelColumn(name="鍏宠仈鍙傛暟3")
     private String param3;
 
diff --git a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/StagingCloudController.java b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/StagingCloudController.java
index 4141bb9..6e7e202 100644
--- a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/StagingCloudController.java
+++ b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/StagingCloudController.java
@@ -7,10 +7,13 @@
 import com.doumee.core.utils.Constants;
 import com.doumee.dao.admin.response.StagingDataVO;
 import com.doumee.dao.business.model.Visits;
+import com.doumee.dao.system.model.Notices;
 import com.doumee.service.business.MemberService;
 import com.doumee.service.business.VisitsService;
+import com.doumee.service.system.NoticesService;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
+import org.apache.shiro.authz.annotation.RequiresPermissions;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;
 
@@ -31,6 +34,9 @@
 
     @Autowired
     private VisitsService visitsService;
+
+    @Autowired
+    private NoticesService noticesService;
 
 
 
@@ -63,4 +69,14 @@
         return ApiResponse.success("鎿嶄綔鎴愬姛");
     }
 
+
+    @ApiOperation("浠诲姟涓績鍒嗛〉")
+    @PostMapping("/taskPage")
+    @RequiresPermissions("business:notices:query")
+    public ApiResponse<PageData<Notices>> taskPage (@RequestBody PageWrap<Notices> pageWrap) {
+        pageWrap.getModel().setPalt(Constants.ZERO);
+        return ApiResponse.success(noticesService.findPage(pageWrap));
+    }
+
+
 }
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/web/response/InternalHomeVO.java b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/web/response/InternalHomeVO.java
index fac3cd2..086bb3c 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/web/response/InternalHomeVO.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/web/response/InternalHomeVO.java
@@ -13,4 +13,15 @@
     private Integer taskNum;
 
 
+    @ApiModelProperty(value = "寰呭鐞嗗緟鍔炴暟閲�")
+    private Long noticeWaitNum;
+
+    @ApiModelProperty(value = "宸插鐞嗗緟鍔炴暟閲�")
+    private Long noticeDealNum;
+
+    @ApiModelProperty(value = "鎴戝彂璧风殑寰呭姙鏁伴噺")
+    private Integer noticeCreateNum;
+
+    @ApiModelProperty(value = "鎶勯�佺殑寰呭姙鏁伴噺")
+    private Long noticeCopyNum;
 }
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java
index 77940c7..af762bd 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java
@@ -243,6 +243,36 @@
         InternalHomeVO internalHomeVO = new InternalHomeVO();
         internalHomeVO.setHomeImg(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.HOME_IMAGE).getCode());
         internalHomeVO.setTaskNum(approveMapper.selectCount(new QueryWrapper<Approve>().lambda().eq(Approve::getChekorId,memberId).eq(Approve::getStatus,Constants.ZERO)));
+        //浠诲姟鏁版嵁
+        List<Notices> noticesList = noticesJoinMapper.selectList(new QueryWrapper<Notices>().lambda().eq(Notices::getUserId,memberId).orderByDesc(Notices::getCreateDate));
+        if(CollectionUtils.isNotEmpty(noticesList)){
+            //寰呮垜澶勭悊鐨勬暟鎹�
+            internalHomeVO.setNoticeWaitNum(
+                noticesList.stream().filter(i->Constants.equalsInteger(i.getUserId(),memberId)
+                        &&Constants.equalsInteger(i.getStatus(),Constants.ZERO)
+                        &&Constants.equalsInteger(i.getSendacopy(),Constants.ZERO)
+                ).count()
+            );
+            internalHomeVO.setNoticeDealNum(
+                noticesList.stream().filter(i->Constants.equalsInteger(i.getUserId(),memberId)
+                        &&Constants.equalsInteger(i.getStatus(),Constants.ONE)
+                        &&Constants.equalsInteger(i.getSendacopy(),Constants.ZERO)
+                ).count()
+            );
+
+            internalHomeVO.setNoticeCreateNum(
+                    noticesJoinMapper.selectCount(new QueryWrapper<Notices>().lambda().eq(Notices::getParam3,memberId))
+            );
+
+            internalHomeVO.setNoticeCopyNum(
+                noticesList.stream().filter(i->Constants.equalsInteger(i.getUserId(),memberId) 
+                        &&Constants.equalsInteger(i.getSendacopy(),Constants.ONE)
+                ).count()
+            );
+        }
+
+
+
         return internalHomeVO;
     }
 
@@ -312,6 +342,27 @@
      * @param approveList
      */
     public void organizeApproveData(ApproveTempl approveTempl,List<ApproveParam> approveParamList,Member createMember,Integer businessId,List<Approve> approveList){
+
+        //鍒涘缓榛樿浜轰俊鎭�
+        Approve createUserApprove = new Approve();
+        createUserApprove.setRemark("鍙戣捣鐢宠");
+        createUserApprove.setCreateDate(new Date());
+        createUserApprove.setIsdeleted(Constants.ZERO);
+        createUserApprove.setTemplatId(approveTempl.getId());
+        createUserApprove.setChekorId(createMember.getId());
+        createUserApprove.setStatus(Constants.approveStatus.pass);
+        createUserApprove.setTitle("鍙戣捣鐢宠");
+        createUserApprove.setStatusInfo("");
+        createUserApprove.setIsEndCheck(Constants.ZERO);
+        createUserApprove.setObjId(businessId);
+        createUserApprove.setLevel(-1);
+        createUserApprove.setObjType(approveTempl.getType());
+        createUserApprove.setApproveType(Constants.TWO);
+        createUserApprove.setDriverParam(Constants.ZERO);
+        createUserApprove.setAddrParam(Constants.ZERO);
+        createUserApprove.setType(Constants.ZERO);
+        approveList.add(createUserApprove);
+
         //瀹℃壒涓氬姟鏁版嵁
         for (int i = 0; i < approveParamList.size(); i++) {
             ApproveParam approveParam = approveParamList.get(i);
@@ -325,6 +376,24 @@
                 if(i==0){
                     if(jsonMap.isEmpty()){
                         title = this.createNoticesData(noticeType,businessId,title,jsonMap);
+                    }
+                    if(j==0){
+                        //榛樿鐢熸垚涓�鏉� 鐢宠浜虹殑鏁版嵁 鏍囪鍒犻櫎鐘舵�佺敤浜庡鐞嗗埌 浠诲姟涓績锛堟垜鍙戣捣锛変娇鐢�
+                        Notices notices = new Notices();
+                        notices.setCreateDate(new Date());
+                        notices.setIsdeleted(Constants.ONE);
+                        notices.setObjId(businessId);
+                        notices.setObjType(noticeType);
+                        notices.setType(noticeType);
+                        notices.setTitle(title);
+                        notices.setParam1(JSONObject.toJSONString(jsonMap));
+                        notices.setStatus(Constants.ZERO);
+                        notices.setReaded(Constants.ZERO);
+                        notices.setSendacopy(Constants.ZERO);
+                        notices.setParam2("0");
+                        notices.setParam3(createMember.getId().toString());
+                        notices.setInfo("澶勭悊涓�");
+                        noticesJoinMapper.insert(notices);
                     }
                     Notices notices = new Notices();
                     notices.setCreateDate(new Date());
@@ -340,6 +409,7 @@
                     notices.setReaded(Constants.ZERO);
                     notices.setSendacopy(Constants.ZERO);
                     notices.setParam2("0");
+                    notices.setParam3("");
                     notices.setInfo("寰呭鐞�");
                     noticesJoinMapper.insert(notices);
                 }
@@ -1053,6 +1123,7 @@
                         notices.setCreateDate(new Date());
                         notices.setEditDate(new Date());
                         notices.setParam2("2");
+                        notices.setParam3("");
                         notices.setUserId(copyApprove.getChekorId());
                         notices.setStatus(Constants.ZERO);
                         notices.setSendacopy(Constants.ONE);
@@ -1089,6 +1160,7 @@
                 notices.setId(null);
                 notices.setCreateDate(new Date());
                 notices.setParam2("0");
+                notices.setParam3("");
                 notices.setEditDate(new Date());
                 notices.setUserId(nextDealApprove.getChekorId());
                 notices.setStatus(Constants.ZERO);
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 7b8bb07..63afab9 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
@@ -1,5 +1,6 @@
 package com.doumee.service.business.impl;
 
+import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
@@ -10,6 +11,7 @@
 import com.doumee.core.model.PageData;
 import com.doumee.core.model.PageWrap;
 import com.doumee.core.utils.Constants;
+import com.doumee.core.utils.DateUtil;
 import com.doumee.core.utils.Utils;
 import com.doumee.dao.business.HiddenDangerLogMapper;
 import com.doumee.dao.business.HiddenDangerMapper;
@@ -17,13 +19,17 @@
 import com.doumee.dao.business.MemberMapper;
 import com.doumee.dao.business.model.*;
 import com.doumee.dao.system.MultifileMapper;
+import com.doumee.dao.system.join.NoticesJoinMapper;
 import com.doumee.dao.system.model.Multifile;
+import com.doumee.dao.system.model.Notices;
 import com.doumee.service.business.HiddenDangerLogService;
 import com.doumee.service.business.HiddenDangerService;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
 import org.apache.commons.lang3.StringUtils;
 import org.checkerframework.checker.units.qual.C;
+import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.context.annotation.Bean;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.CollectionUtils;
@@ -54,6 +60,9 @@
     private HiddenDangerLogMapper hiddenDangerLogMapper;
 
 
+    @Autowired
+    private NoticesJoinMapper noticesJoinMapper;
+
     @Override
     public Integer create(HiddenDanger hiddenDanger) {
         if(Objects.isNull(hiddenDanger)
@@ -73,6 +82,10 @@
         HiddenDangerParam hiddenDangerParam = hiddenDangerParamMapper.selectById(hiddenDanger.getAreaId());
         if(Objects.isNull(hiddenDangerParam)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌闅愭偅鍖哄煙");
+        }
+        HiddenDangerParam hiddenDangerCate = hiddenDangerParamMapper.selectById(hiddenDanger.getCateId());
+        if(Objects.isNull(hiddenDangerCate)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌闅愭偅绫诲瀷");
         }
         hiddenDanger.setCreator(hiddenDanger.getLoginUserInfo().getId());
         hiddenDanger.setAreaName(hiddenDangerParam.getName());
@@ -109,6 +122,46 @@
                 multifileMapper.insert(multifile);
             }
         }
+        String title = "[闅愭偅闅忔墜鎷峕鎻愭姤浜�-"+hiddenDanger.getLoginUserInfo().getRealname();
+        //json鏁版嵁
+        Map<String,Object> jsonMap = new HashMap<>();
+        jsonMap.put("name", "鍙戠幇鍖哄煙:" + hiddenDangerParam.getName());
+        jsonMap.put("name", "闅愭偅绫诲瀷:" + hiddenDangerCate.getName());
+        jsonMap.put("sTime", "鍙戠幇鏃堕棿:" + DateUtil.DateToStr(hiddenDanger.getSubmitTime() , "yyyy-MM-dd HH:mm"));
+        //榛樿鐢熸垚涓�鏉� 鐢宠浜虹殑鏁版嵁 鏍囪鍒犻櫎鐘舵�佺敤浜庡鐞嗗埌 浠诲姟涓績锛堟垜鍙戣捣锛変娇鐢�
+        Notices createNotices = new Notices();
+        createNotices.setCreateDate(new Date());
+        createNotices.setIsdeleted(Constants.ONE);
+        createNotices.setObjId(hiddenDanger.getId());
+        createNotices.setObjType(Constants.THREE);
+        createNotices.setType(Constants.THREE);
+        createNotices.setTitle(title);
+        createNotices.setParam1(JSONObject.toJSONString(jsonMap));
+        createNotices.setStatus(Constants.ZERO);
+        createNotices.setReaded(Constants.ZERO);
+        createNotices.setSendacopy(Constants.ZERO);
+        createNotices.setParam2("0");
+        createNotices.setParam3(hiddenDanger.getLoginUserInfo().getMemberId().toString());
+        createNotices.setInfo("澶勭悊涓�");
+        noticesJoinMapper.insert(createNotices);
+
+        //瀛樺偍澶勭悊浜虹殑閫氱煡娑堟伅
+        Notices notices = new Notices();
+        notices.setId(null);
+        notices.setCreateDate(new Date());
+        notices.setIsdeleted(Constants.ZERO);
+        notices.setTitle(title);
+        notices.setParam1(JSONObject.toJSONString(jsonMap));
+        notices.setParam2("0");
+        notices.setObjId(hiddenDanger.getId());
+        notices.setObjType(Constants.THREE);
+        notices.setType(Constants.THREE);
+        notices.setEditDate(new Date());
+        notices.setUserId(hiddenDanger.getCheckUserId());
+        notices.setStatus(Constants.ZERO);
+        notices.setSendacopy(Constants.ZERO);
+        notices.setReaded(Constants.ZERO);
+        noticesJoinMapper.insert(notices);
 
 
         return hiddenDanger.getId();
@@ -307,6 +360,17 @@
         hiddenDangerLog.setTitle(hiddenDanger.getStatus().equals(Constants.ONE)?"闅愭偅澶勭悊":"闅愭偅閫�鍥�");
         hiddenDangerLog.setObjType(hiddenDanger.getStatus().equals(Constants.ONE)?Constants.FOUR:Constants.TWO);
         hiddenDangerLogMapper.insert(hiddenDangerLog);
+        //澶勭悊寰呭姙淇℃伅
+        noticesJoinMapper.update(null,new UpdateWrapper<Notices>()
+                .lambda()
+                .set(Notices::getReaded,Constants.ONE)
+                .set(Notices::getStatus,Constants.ONE)
+                .set(Notices::getParam2,hiddenDanger.getStatus())
+                .eq(Notices::getObjId,hiddenDanger.getId())
+                .eq(Notices::getObjType,Constants.THREE)
+                .eq(Notices::getUserId,hiddenDanger.getLoginUserInfo().getMemberId())
+        );
+
     }
 
     private void isParamValid(HiddenDanger hiddenDanger) {
@@ -432,6 +496,26 @@
         hiddenDangerLog.setHiddenDangerId(hiddenDanger.getId());
         hiddenDangerLog.setObjType(Constants.ONE);
         hiddenDangerLogMapper.insert(hiddenDangerLog);
+        Notices notices = noticesJoinMapper.selectOne(new QueryWrapper<Notices>()
+                .lambda()
+                .eq(Notices::getObjId,hiddenDanger.getId())
+                .eq(Notices::getObjType,Constants.THREE)
+                .eq(Notices::getUserId,hiddenDanger.getLoginUserInfo().getMemberId())
+                .last(" limit  1 ")
+        );
+        if(Objects.nonNull(notices)){
+            Notices newNotices = new Notices();
+            BeanUtils.copyProperties(notices,newNotices);
+            newNotices.setId(null);
+            newNotices.setCreateDate(new Date());
+            newNotices.setParam2("3");
+            newNotices.setUserId(hiddenDanger.getCheckUserId());
+            noticesJoinMapper.insert(newNotices);
+            notices.setStatus(Constants.ONE);
+            notices.setEditDate(new Date());
+            notices.setReaded(Constants.ONE);
+            noticesJoinMapper.updateById(notices);
+        }
     }
 
 
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
index c17b755..82ee127 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
@@ -1112,7 +1112,7 @@
         queryWrapper.selectAll(Member.class)
                 .selectAs(Company::getName,Member::getCompanyName)
                 .eq(Member::getType,Constants.TWO)
-                .exists("select d.id from car_driver b where b.isdeleted=0 and b.member_id=t.id");
+                .exists("select b.id from car_driver b where b.isdeleted=0 and b.member_id=t.id");
 
         if(null != member.getType()) {
             queryWrapper.eq(Member::getType,member.getType());

--
Gitblit v1.9.3