From 9f4c9d49cfd16c61bf00641b1af18cff840985d5 Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期四, 11 十二月 2025 09:53:43 +0800
Subject: [PATCH] 钥匙柜开门添加 指纹方式

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

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkCabinetServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkCabinetServiceImpl.java
index 9c2b9b0..96552cc 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkCabinetServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkCabinetServiceImpl.java
@@ -545,7 +545,7 @@
                     .eq(CarUseBook::getIsdeleted,Constants.ZERO)
                             .isNotNull(CarUseBook::getDriverId)
                             .apply(" car_id in ( SELECT k.CAR_ID FROM  jk_cabinet_grid j inner join jk_keys k on j.KEY_ID = k.ID where j.isdeleted = 0 and k.isdeleted = 0  ) ")
-                    .apply("  NOW() > DATE_SUB(START_TIME, INTERVAL "+earlyConfig+" MINUTE) and now() < end_time    ")
+                    .apply(" ( ( NOW() > DATE_SUB(START_TIME, INTERVAL "+earlyConfig+" MINUTE) and now() < end_time   )  or KEY_STATUS = 1 ) ")
             );
             if(CollectionUtils.isNotEmpty(carUseBookList)){
                 driverList.addAll(memberMapper.selectList(new QueryWrapper<Member>().lambda()

--
Gitblit v1.9.3