From d5e01405a50c89966ae06363b09fd385b47f99f0 Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期五, 24 十月 2025 16:47:55 +0800
Subject: [PATCH] 问题修改

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkCabinetGridServiceImpl.java |  393 +++++++++++++++++++++++++++++++++++++++----------------
 1 files changed, 278 insertions(+), 115 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkCabinetGridServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkCabinetGridServiceImpl.java
index 28633c9..d8c35ca 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkCabinetGridServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkCabinetGridServiceImpl.java
@@ -1,15 +1,19 @@
 package com.doumee.service.business.impl;
 
+import com.alibaba.fastjson.JSONObject;
 import com.doumee.core.constants.ResponseStatus;
+import com.doumee.core.dingTalk.DingTalk;
+import com.doumee.core.dingTalk.DingTalkStream;
 import com.doumee.core.exception.BusinessException;
+import com.doumee.core.haikang.model.HKConstants;
 import com.doumee.core.utils.Constants;
 import com.doumee.core.utils.DateUtil;
 import com.doumee.dao.business.*;
-import com.doumee.dao.business.dto.OptGridDTO;
-import com.doumee.dao.business.dto.CloseGridDTO;
-import com.doumee.dao.business.dto.GetDriverGridDTO;
-import com.doumee.dao.business.dto.OpenGridDriverDTO;
+import com.doumee.dao.business.dao.MemberMapper;
+import com.doumee.dao.business.dto.*;
 import com.doumee.dao.business.model.*;
+import com.doumee.dao.system.SystemUserMapper;
+import com.doumee.dao.system.model.SystemUser;
 import com.doumee.service.business.third.model.LoginUserInfo;
 import com.doumee.service.business.third.model.PageData;
 import com.doumee.core.utils.Utils;
@@ -20,6 +24,8 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.doumee.service.business.third.model.PageWrap;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import com.hikvision.artemis.sdk.config.ArtemisConfig;
+import lombok.extern.slf4j.Slf4j;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
@@ -35,6 +41,7 @@
  * @date 2025/09/28 09:01
  */
 @Service
+@Slf4j
 public class JkCabinetGridServiceImpl implements JkCabinetGridService {
 
     @Autowired
@@ -44,11 +51,24 @@
     private JkKeysMapper jkKeysMapper;
 
     @Autowired
+    private SystemUserMapper systemUserMapper;
+
+    @Autowired
     private JkCabinetMapper jkCabinetMapper;
     @Autowired
     private JkCabinetLogMapper jkCabinetLogMapper;
 
+    @Autowired
+    private WarningMapper warningMapper;
 
+    @Autowired
+    private MemberMapper memberMapper;
+
+    @Autowired
+    private WarningRuleMapper warningRuleMapper;
+
+    @Autowired
+    private DingTalk dingTalk;
 
     @Override
     public Integer create(JkCabinetGrid jkCabinetGrid) {
@@ -250,23 +270,24 @@
         if(Objects.isNull(dto)
                 || Objects.isNull(dto.getCabinetId())
                 || CollectionUtils.isEmpty(dto.getGridIdList())){
-            throw new BusinessException(ResponseStatus.BAD_REQUEST);
-        }
-        List<JkCabinetGrid> jkCabinetGridList = jkCabinetGridMapper.selectList(new QueryWrapper<JkCabinetGrid>().lambda().eq(JkCabinetGrid::getIsdeleted,Constants.ZERO)
-                .eq(JkCabinetGrid::getWorkingStatus,Constants.ZERO)
-                .eq(JkCabinetGrid::getCabinetId,dto.getCabinetId())
-                .in(JkCabinetGrid::getId,dto.getGridIdList())
-        );
-        if(CollectionUtils.isEmpty(jkCabinetGridList)){
             return;
+        }else{
+            List<JkCabinetGrid> jkCabinetGridList = jkCabinetGridMapper.selectList(new QueryWrapper<JkCabinetGrid>().lambda().eq(JkCabinetGrid::getIsdeleted,Constants.ZERO)
+                    .eq(JkCabinetGrid::getWorkingStatus,Constants.ZERO)
+                    .eq(JkCabinetGrid::getCabinetId,dto.getCabinetId())
+                    .in(JkCabinetGrid::getId,dto.getGridIdList())
+            );
+            if(CollectionUtils.isNotEmpty(jkCabinetGridList)){
+                LoginUserInfo loginUserInfo = dto.getLoginUserInfo();
+                for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) {
+                    jkCabinetGrid.setEditor(loginUserInfo.getId());
+                    jkCabinetGrid.setEditDate(new Date());
+                    jkCabinetGrid.setWorkingStatus(Constants.ONE);
+                    jkCabinetGridMapper.updateById(jkCabinetGrid);
+                }
+            }
         }
-        LoginUserInfo loginUserInfo = dto.getLoginUserInfo();
-        for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) {
-            jkCabinetGrid.setEditor(loginUserInfo.getId());
-            jkCabinetGrid.setEditDate(new Date());
-            jkCabinetGrid.setWorkingStatus(Constants.ONE);
-            jkCabinetGridMapper.updateById(jkCabinetGrid);
-        }
+
     }
 
     /**
@@ -287,22 +308,22 @@
                         .selectAs(JkKeys::getCarId,JkCabinetGrid::getCarId)
                 .leftJoin(JkKeys.class,JkKeys::getId,JkCabinetGrid::getKeyId)
                 .eq(JkCabinetGrid::getIsdeleted,Constants.ZERO)
-                .eq(JkKeys::getStatus,Constants.ONE)
+                .eq(JkKeys::getStatus,Constants.TWO)
                 .eq(JkCabinetGrid::getWorkingStatus,Constants.ZERO)
                 .eq(JkCabinetGrid::getCabinetId,dto.getCabinetId())
                 .isNotNull(JkCabinetGrid::getKeyId)
                 .in(JkCabinetGrid::getId,dto.getGridIdList())
         );
-        if(CollectionUtils.isEmpty(jkCabinetGridList)){
-            return;
+        if(CollectionUtils.isNotEmpty(jkCabinetGridList)){
+            for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) {
+                jkKeysMapper.update(null,new UpdateWrapper<JkKeys>().lambda()
+                        .set(JkKeys::getEditDate,DateUtil.getCurrDateTime())
+                        .set(JkKeys::getStatus,Constants.THREE)
+                        .eq(JkKeys::getId,jkCabinetGrid.getKeyId())
+                );
+            }
         }
-        for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) {
-            jkKeysMapper.update(null,new UpdateWrapper<JkKeys>().lambda()
-                    .set(JkKeys::getEditDate,DateUtil.getCurrDateTime())
-                    .set(JkKeys::getStatus,Constants.TWO)
-                    .eq(JkKeys::getId,jkCabinetGrid.getKeyId())
-            );
-        }
+
     }
 
 
@@ -315,23 +336,23 @@
         if(Objects.isNull(dto)
                 || Objects.isNull(dto.getCabinetId())
                 || CollectionUtils.isEmpty(dto.getGridIdList())){
-            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+            return;
         }
         List<JkCabinetGrid> jkCabinetGridList = jkCabinetGridMapper.selectList(new QueryWrapper<JkCabinetGrid>().lambda().eq(JkCabinetGrid::getIsdeleted,Constants.ZERO)
                 .eq(JkCabinetGrid::getWorkingStatus,Constants.ONE)
                 .eq(JkCabinetGrid::getCabinetId,dto.getCabinetId())
                 .in(JkCabinetGrid::getId,dto.getGridIdList())
         );
-        if(CollectionUtils.isEmpty(jkCabinetGridList)){
-            return;
+        if(CollectionUtils.isNotEmpty(jkCabinetGridList)){
+            LoginUserInfo loginUserInfo = dto.getLoginUserInfo();
+            for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) {
+                jkCabinetGrid.setEditor(loginUserInfo.getId());
+                jkCabinetGrid.setEditDate(new Date());
+                jkCabinetGrid.setWorkingStatus(Constants.ZERO);
+                jkCabinetGridMapper.updateById(jkCabinetGrid);
+            }
         }
-        LoginUserInfo loginUserInfo = dto.getLoginUserInfo();
-        for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) {
-            jkCabinetGrid.setEditor(loginUserInfo.getId());
-            jkCabinetGrid.setEditDate(new Date());
-            jkCabinetGrid.setWorkingStatus(Constants.ZERO);
-            jkCabinetGridMapper.updateById(jkCabinetGrid);
-        }
+
     }
 
 
@@ -344,42 +365,42 @@
         if(Objects.isNull(dto)
         || Objects.isNull(dto.getCabinetId())
         || CollectionUtils.isEmpty(dto.getGridIdList())){
-            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+           return;
         }
         List<JkCabinetGrid> jkCabinetGridList = jkCabinetGridMapper.selectList(new QueryWrapper<JkCabinetGrid>().lambda().eq(JkCabinetGrid::getIsdeleted,Constants.ZERO)
                 .eq(JkCabinetGrid::getCabinetId,dto.getCabinetId())
                 .in(JkCabinetGrid::getId,dto.getGridIdList())
         );
-        if(CollectionUtils.isEmpty(jkCabinetGridList)){
-            return;
-        }
-        LoginUserInfo loginUserInfo = dto.getLoginUserInfo();
-        if(org.apache.commons.collections.CollectionUtils.isNotEmpty(jkCabinetGridList)){
-            List<JkCabinetLog> jkCabinetLogs = new ArrayList<>();
-            for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) {
-                JkCabinetLog jkCabinetLog = new JkCabinetLog();
-                jkCabinetLog.setCreateDate(new Date());
-                jkCabinetLog.setCreator(loginUserInfo.getId());
-                jkCabinetLog.setIsdeleted(Constants.ZERO);
-                jkCabinetLog.setCabinetId(dto.getCabinetId());
-                jkCabinetLog.setGridId(jkCabinetGrid.getId());
-                jkCabinetLog.setAuthType(Constants.TWO);
-                jkCabinetLog.setMemberId(loginUserInfo.getMemberId());
-                if(Objects.nonNull(jkCabinetGrid.getKeyId())){
-                    JkKeys jkKeys = jkKeysMapper.selectById(jkCabinetGrid.getKeyId());
-                    if(Objects.nonNull(jkKeys)){
-                        if(!Constants.equalsInteger(jkKeys.getStatus(),Constants.ZERO)){
-                            jkCabinetLog.setCarId(jkKeys.getCarId());
-                            jkCabinetLog.setKeyInfo(jkKeys.getCarCode() + "_" + jkKeys.getCode() );
+        if(CollectionUtils.isNotEmpty(jkCabinetGridList)){
+            LoginUserInfo loginUserInfo = dto.getLoginUserInfo();
+            if(org.apache.commons.collections.CollectionUtils.isNotEmpty(jkCabinetGridList)){
+                List<JkCabinetLog> jkCabinetLogs = new ArrayList<>();
+                for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) {
+                    JkCabinetLog jkCabinetLog = new JkCabinetLog();
+                    jkCabinetLog.setCreateDate(new Date());
+                    jkCabinetLog.setCreator(loginUserInfo.getId());
+                    jkCabinetLog.setIsdeleted(Constants.ZERO);
+                    jkCabinetLog.setCabinetId(dto.getCabinetId());
+                    jkCabinetLog.setGridId(jkCabinetGrid.getId());
+                    jkCabinetLog.setAuthType(Constants.TWO);
+                    jkCabinetLog.setMemberId(loginUserInfo.getMemberId());
+                    if(Objects.nonNull(jkCabinetGrid.getKeyId())){
+                        JkKeys jkKeys = jkKeysMapper.selectById(jkCabinetGrid.getKeyId());
+                        if(Objects.nonNull(jkKeys)){
+                            if(!Constants.equalsInteger(jkKeys.getStatus(),Constants.ZERO)){
+                                jkCabinetLog.setCarId(jkKeys.getCarId());
+                                jkCabinetLog.setKeyInfo(jkKeys.getCarCode() + "_" + jkKeys.getCode() );
+                            }
+                            jkCabinetLog.setRoleType(jkKeys.getRoleType());
                         }
-                        jkCabinetLog.setRoleType(jkKeys.getRoleType());
                     }
+                    jkCabinetLog.setType(Constants.ZERO);
+                    jkCabinetLogs.add(jkCabinetLog);
                 }
-                jkCabinetLog.setType(Constants.ZERO);
-                jkCabinetLogs.add(jkCabinetLog);
+                jkCabinetLogMapper.insert(jkCabinetLogs);
             }
-            jkCabinetLogMapper.insert(jkCabinetLogs);
         }
+
     }
 
 
@@ -394,7 +415,6 @@
             || Objects.isNull(dto.getCabinetId())
             || Objects.isNull(dto.getKeyStatus())
             || Objects.isNull(dto.getAuthType())
-            || Objects.isNull(dto.getMemberId())
         ){
             throw new BusinessException(ResponseStatus.BAD_REQUEST);
         }
@@ -403,38 +423,53 @@
                 .eq(JkCabinetGrid::getId,dto.getGridId())
                 .last(" limit 1 ")
         );
-        if(Objects.isNull(jkCabinetGrid)){
-            return;
-        }
-        JkCabinetLog jkCabinetLog = new JkCabinetLog();
-        jkCabinetLog.setCreateDate(new Date());
-        jkCabinetLog.setIsdeleted(Constants.ZERO);
-        jkCabinetLog.setCabinetId(dto.getCabinetId());
-        jkCabinetLog.setGridId(jkCabinetGrid.getId());
-        jkCabinetLog.setAuthType(dto.getAuthType());
-        jkCabinetLog.setMemberId(dto.getMemberId());
-        if(Objects.nonNull(jkCabinetGrid.getKeyId())){
-            //鍙湁閽ュ寵鏌滅粦瀹氫簡閽ュ寵淇℃伅 鎵嶄細鏇存柊閽ュ寵鐨勪俊鎭�
-            JkKeys jkKeys = jkKeysMapper.selectById(jkCabinetGrid.getKeyId());
-            if(Objects.nonNull(jkKeys)){
-                if(!Constants.equalsInteger(jkKeys.getStatus(),Constants.ZERO)){
-                    jkCabinetLog.setCarId(jkKeys.getCarId());
-                    jkCabinetLog.setKeyInfo(jkKeys.getCarCode() + "_" + jkKeys.getCode() );
-                }
-                jkCabinetLog.setRoleType(jkKeys.getRoleType());
-                //閽ュ寵鐘舵�佷笌褰撳墠鎿嶄綔鐘舵�佷笉涓�鑷达紝鍒欒繘琛屾洿鏂伴挜鍖欑姸鎬�
-                if(!Constants.equalsInteger(jkKeys.getStatus(),dto.getKeyStatus())){
-                    jkKeysMapper.update(null,new UpdateWrapper<JkKeys>().lambda()
-                            .set(JkKeys::getEditDate,DateUtil.getCurrDateTime())
-                            .set(JkKeys::getStatus,dto.getKeyStatus())
-                            .eq(JkKeys::getId,jkKeys.getId())
-                    );
+        if(Objects.nonNull(jkCabinetGrid)){
+            JkCabinetLog jkCabinetLog = new JkCabinetLog();
+            jkCabinetLog.setCreateDate(new Date());
+            jkCabinetLog.setIsdeleted(Constants.ZERO);
+            jkCabinetLog.setCabinetId(dto.getCabinetId());
+            jkCabinetLog.setGridId(jkCabinetGrid.getId());
+            jkCabinetLog.setAuthType(dto.getAuthType());
+            jkCabinetLog.setMemberId(dto.getMemberId());
+            jkCabinetLog.setKeyStatus(Constants.ZERO);
+            Boolean isChange = false;
+            if(Objects.nonNull(jkCabinetGrid.getKeyId())){
+                //鍙湁閽ュ寵鏌滅粦瀹氫簡閽ュ寵淇℃伅 鎵嶄細鏇存柊閽ュ寵鐨勪俊鎭�
+                JkKeys jkKeys = jkKeysMapper.selectById(jkCabinetGrid.getKeyId());
+                if(Objects.nonNull(jkKeys)){
+                    if(!Constants.equalsInteger(jkKeys.getStatus(),Constants.ZERO)){
+                        jkCabinetLog.setCarId(jkKeys.getCarId());
+                        jkCabinetLog.setKeyInfo(jkKeys.getCarCode() + "_" + jkKeys.getCode() );
+                    }
+                    jkCabinetLog.setRoleType(jkKeys.getRoleType());
+                    jkCabinetLog.setKeyStatus(dto.getKeyStatus());
+                    //閽ュ寵鐘舵�佷笌褰撳墠鎿嶄綔鐘舵�佷笉涓�鑷达紝鍒欒繘琛屾洿鏂伴挜鍖欑姸鎬�
+                    if(!Constants.equalsInteger(jkKeys.getStatus(),dto.getKeyStatus())
+                    && (Constants.equalsInteger(dto.getKeyStatus(),Constants.ONE)||Constants.equalsInteger(dto.getKeyStatus(),Constants.TWO))){
+                        jkKeysMapper.update(null,new UpdateWrapper<JkKeys>().lambda()
+                                .set(JkKeys::getEditDate,DateUtil.getCurrDateTime())
+                                .set(JkKeys::getStatus,dto.getKeyStatus())
+                                .eq(JkKeys::getId,jkKeys.getId())
+                        );
+                        isChange = true;
+                    }
                 }
             }
+            jkCabinetLog.setType(Constants.ONE);
+            jkCabinetLogMapper.insert(jkCabinetLog);
+            //鏌ヨ閽ュ寵瀵瑰簲鐨勫�熷嚭浜嗛挜鍖欑殑寮�闂ㄨ褰� 杩涜娣诲姞鍏抽棬璁板綍涓婚敭
+            if(isChange && Constants.equalsInteger(dto.getKeyStatus(),Constants.ONE)){
+                jkCabinetLogMapper.update(null,new UpdateWrapper<JkCabinetLog>().lambda()
+                        .set(JkCabinetLog::getCloseLogId,jkCabinetLog.getId())
+                        .eq(JkCabinetLog::getKeyId,jkCabinetLog.getKeyId())
+                        .eq(JkCabinetLog::getType,Constants.ZERO)
+                        .eq(JkCabinetLog::getKeyStatus,Constants.TWO)
+                        .isNotNull(JkCabinetLog::getCloseLogId));
+            }
         }
-        jkCabinetLog.setType(Constants.ONE);
-        jkCabinetLogMapper.insert(jkCabinetLog);
     }
+
+
 
 
     /**
@@ -442,26 +477,55 @@
      */
     @Override
     public List<JkCabinetGrid> getDriverGrid(GetDriverGridDTO dto){
+        List<JkCabinetGrid> jkCabinetGridList = new ArrayList<>();
         if(Objects.isNull(dto.getCabinetId())
             || Objects.isNull(dto.getCabinetId())
             || Objects.isNull(dto.getMemberId())
             || Objects.isNull(dto.getType())){
-            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+            return jkCabinetGridList;
+        }else{
+            JkCabinet jkCabinet = jkCabinetMapper.selectById(dto.getCabinetId());
+            if(Objects.isNull(jkCabinet)){
+                return jkCabinetGridList;
+            }
+            if(Constants.equalsInteger(jkCabinet.getDoubleAuth(),Constants.ONE)){
+                if(StringUtils.isBlank(jkCabinet.getAuthMemberId())){
+                    return jkCabinetGridList;
+                }
+                List<String> authMemberList =  Arrays.asList(jkCabinet.getAuthMemberId().split(","));
+                Boolean flag = true;
+                for (String id:authMemberList) {
+                    if(id.equals(jkCabinet.getAuthMemberId())){
+                        flag = false;
+                        break;
+                    }
+                }
+                if(flag){
+                    return jkCabinetGridList;
+                }
+            }
+            jkCabinetGridList = jkCabinetGridMapper.selectJoinList(JkCabinetGrid.class,
+                    new MPJLambdaWrapper<JkCabinetGrid>().selectAll(JkCabinetGrid.class)
+                            .selectAs(JkKeys::getCode,JkCabinetGrid::getKeyCode)
+                            .selectAs(JkKeys::getCarCode,JkCabinetGrid::getCarCode)
+                            .selectAs(JkKeys::getCarId,JkCabinetGrid::getCarId)
+                            .selectAs(JkKeys::getStatus,JkCabinetGrid::getKeyStatus)
+                            .leftJoin(JkKeys.class,JkKeys::getId,JkCabinetGrid::getKeyId)
+                            .eq(JkCabinetGrid::getIsdeleted,Constants.ZERO)
+                            .eq(JkCabinetGrid::getWorkingStatus,Constants.ZERO)
+                            .eq(JkCabinetGrid::getCabinetId,dto.getCabinetId())
+                            .in(Constants.equalsInteger(dto.getType(),Constants.ONE),JkKeys::getStatus,Constants.TWO,Constants.THREE)
+                            .in(Constants.equalsInteger(dto.getType(),Constants.ZERO),JkKeys::getStatus,Constants.ONE)
+                            .isNotNull(JkCabinetGrid::getKeyId)
+                            .apply(" t1.car_id in ( select c.id from  cars c  where c.ISDELETED = 0 and  c.MEMBER_ID = "+dto.getMemberId()+" ) ")
+                            .orderByAsc(JkCabinetGrid::getCode)
+            );
+            for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) {
+                jkCabinetGrid.setBindStatus(Objects.isNull(jkCabinetGrid.getKeyId())?Constants.ZERO:Constants.ONE);
+                jkCabinetGrid.setKeyStatus(Objects.isNull(jkCabinetGrid.getKeyStatus())?Constants.ZERO:jkCabinetGrid.getKeyStatus());
+            }
+
         }
-        List<JkCabinetGrid> jkCabinetGridList = jkCabinetGridMapper.selectJoinList(JkCabinetGrid.class,
-                new MPJLambdaWrapper<JkCabinetGrid>().selectAll(JkCabinetGrid.class)
-                        .selectAs(JkKeys::getCode,JkCabinetGrid::getKeyCode)
-                        .selectAs(JkKeys::getCarCode,JkCabinetGrid::getCarCode)
-                        .selectAs(JkKeys::getCarId,JkCabinetGrid::getCarId)
-                        .leftJoin(JkKeys.class,JkKeys::getId,JkCabinetGrid::getKeyId)
-                        .eq(JkCabinetGrid::getIsdeleted,Constants.ZERO)
-                        .eq(JkCabinetGrid::getWorkingStatus,Constants.ZERO)
-                        .eq(JkCabinetGrid::getCabinetId,dto.getCabinetId())
-                        .in(Constants.equalsInteger(dto.getType(),Constants.ONE),JkKeys::getStatus,Constants.TWO,Constants.THREE)
-                        .in(Constants.equalsInteger(dto.getType(),Constants.ZERO),JkKeys::getStatus,Constants.ONE)
-                        .isNotNull(JkCabinetGrid::getKeyId)
-                        .apply(" t1.car_id in ( select c.CAR_ID from car_driver c left join cars c1 on c.car_id = c1.id  where c.ISDELETED = 0 and c.TYPE != 0 and   c.MEMBER_ID = "+dto.getMemberId()+" ) ")
-        );
         return jkCabinetGridList;
     }
 
@@ -478,18 +542,17 @@
                 .last(" limit 1 ")
         );
         if(Objects.isNull(jkCabinetGrid)){
-            return;
+            return ;
         }
-        LoginUserInfo loginUserInfo = openGridDriverDTO.getLoginUserInfo();
-        List<JkCabinetLog> jkCabinetLogs = new ArrayList<>();
+//        LoginUserInfo loginUserInfo = openGridDriverDTO.getLoginUserInfo();
         JkCabinetLog jkCabinetLog = new JkCabinetLog();
         jkCabinetLog.setCreateDate(new Date());
-        jkCabinetLog.setCreator(loginUserInfo.getId());
+//        jkCabinetLog.setCreator(loginUserInfo.getId());
         jkCabinetLog.setIsdeleted(Constants.ZERO);
         jkCabinetLog.setCabinetId(openGridDriverDTO.getCabinetId());
         jkCabinetLog.setGridId(jkCabinetGrid.getId());
         jkCabinetLog.setAuthType(openGridDriverDTO.getAuthType());
-        jkCabinetLog.setMemberId(loginUserInfo.getMemberId());
+        jkCabinetLog.setMemberId(openGridDriverDTO.getMemberId());
         jkCabinetLog.setType(Constants.ZERO);
         if(Objects.nonNull(jkCabinetGrid.getKeyId())){
             JkKeys jkKeys = jkKeysMapper.selectById(jkCabinetGrid.getKeyId());
@@ -501,7 +564,107 @@
                 jkCabinetLog.setRoleType(jkKeys.getRoleType());
             }
         }
-        jkCabinetLogMapper.insert(jkCabinetLogs);
+        jkCabinetLogMapper.insert(jkCabinetLog);
     }
 
+
+
+    @Override
+    public void timeOutUnCloseAlarm(TimeOutCloseGridDTO dto){
+        if(Objects.nonNull(dto)
+            && Objects.nonNull(dto.getGridId())){
+            JkCabinetGrid jkCabinetGrid = jkCabinetGridMapper.selectJoinOne(JkCabinetGrid.class,
+                    new MPJLambdaWrapper<JkCabinetGrid>().selectAll(JkCabinetGrid.class)
+                            .selectAs(JkCabinet::getName,JkCabinetGrid::getCabinetName)
+                            .leftJoin(JkCabinet.class,JkCabinet::getId,JkCabinetGrid::getCabinetId)
+                            .eq(JkCabinetGrid::getIsdeleted,Constants.ZERO)
+                            .eq(JkCabinetGrid::getId,dto.getGridId())
+                            .last(" limit 1 ")
+            );
+
+//            if(Objects.nonNull(jkCabinetGrid)){
+//                log.error("鏌滄牸寮�闂ㄨ秴鏃舵湭鍏抽棴鍛婅淇℃伅锛歿}"+JSONObject.toJSONString(jkCabinetGrid));
+//                Warning warning = warningMapper.selectOne(new QueryWrapper<Warning>().lambda()
+//                        .eq(Warning::getType,Constants.THREE).eq(Warning::getCode,Constants.WarningConfig.GRID_TIME_OUT_INFO.getKey()).eq(Warning::getIsdeleted,Constants.ZERO).last("limt 1"));
+//                if(Objects.isNull(warning)){
+//                    return;
+//                }
+//                List<Member> memberList = this.getWarningList(warning);
+//                if(CollectionUtils.isEmpty(memberList)){
+//                    return;
+//                }
+//                //瀛樺偍寮傚父鏃ュ織
+//
+//
+//            }else{
+//
+//            }
+        }
+    }
+
+
+    public List<Member> getWarningList(Warning warning){
+        if(Constants.equalsInteger(warning.getStatus(),Constants.ZERO)){
+            return null;
+        }
+        //鏌ヨ閫氱煡浜哄憳
+        List<WarningRule> warningRuleList = warningRuleMapper.selectList(new QueryWrapper<WarningRule>().lambda()
+                .eq(WarningRule::getIsdeleted,Constants.ZERO)
+                .apply(" id in ( select w.RULE_ID from warning_rule_detail w where w.WARNING_ID = '"+warning.getId()+"' and w.ISDELETED = 0  ) ")
+        );
+        List<Member> memberList = new ArrayList<>();
+        if(org.apache.commons.collections.CollectionUtils.isNotEmpty(warningRuleList)){
+            List<String> memberIdStr =  warningRuleList.stream().map(i->i.getMemberIds()).collect(Collectors.toList());
+            if(org.apache.commons.collections.CollectionUtils.isNotEmpty(memberIdStr)){
+                List<String> memberIdList = new ArrayList<>();
+                for (String s:memberIdStr) {
+                    memberIdList.addAll(
+                            Arrays.asList(s.split(","))
+                    );
+                }
+                memberList = memberMapper.selectList(new QueryWrapper<Member>().lambda().eq(Member::getIsdeleted,Constants.ZERO)
+                        .notIn(Member::getErpId)
+                        .in(Member::getId,memberIdList)
+                );
+            }
+        }
+        return memberList;
+
+
+
+    }
+
+
+
+    @Override
+    public void alcoholTestAlarm(AlcoholTestAlarmDTO dto){
+        if(Objects.nonNull(dto)
+                && Objects.nonNull(dto.getMemberId())){
+
+
+
+            SystemUser systemUser =
+                    systemUserMapper.selectOne(new QueryWrapper<SystemUser>().lambda()
+                            .eq(SystemUser::getMemberId,dto.getMemberId())
+                            .eq(SystemUser::getDeleted,Constants.ZERO)
+                            .last(" limit 1 ")
+                    );
+
+//            Warning warning = warningMapper.selectOne(new QueryWrapper<Warning>().lambda()
+//                    .eq(Warning::getType,Constants.THREE).eq(Warning::getCode,Constants.WarningConfig.GRID_TIME_OUT_INFO.getKey()).eq(Warning::getIsdeleted,Constants.ZERO).last("limt 1"));
+//            if(Objects.isNull(warning)){
+//                return;
+//            }
+//            List<Member> memberList = this.getWarningList(warning);
+//
+//
+//
+//            //瀛樺偍寮傚父鏃ュ織
+//            if(Objects.nonNull(systemUser)){
+//                log.error("鍙告満閰掔簿妫�娴嬶紝瓒呭嚭閰掔簿鍊煎憡璀︿俊鎭細{}"+JSONObject.toJSONString(systemUser));
+//            }
+        }
+    }
+
+
 }

--
Gitblit v1.9.3