From 02c7bf03fa071325c201d29353330152d35ac71a Mon Sep 17 00:00:00 2001
From: wenminjie <1036699586@qq.com>
Date: 星期四, 06 八月 2026 18:16:02 +0800
Subject: [PATCH] 小程序对接
---
talent-card-server/src/main/java/com/talentcard/server/mapper/TransportCarWashCredentialMapper.java | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/talent-card-server/src/main/java/com/talentcard/server/mapper/TransportCarWashCredentialMapper.java b/talent-card-server/src/main/java/com/talentcard/server/mapper/TransportCarWashCredentialMapper.java
index b8cc419..8831bce 100644
--- a/talent-card-server/src/main/java/com/talentcard/server/mapper/TransportCarWashCredentialMapper.java
+++ b/talent-card-server/src/main/java/com/talentcard/server/mapper/TransportCarWashCredentialMapper.java
@@ -81,9 +81,9 @@
u.name as talentName, u.mobile as talentMobile
from talent_card c join talent_user u on u.id = c.talent_id and u.deleted = 0
where c.id = #{cardId} and c.talent_id = #{talentId} and c.deleted = 0 and c.status = 1
- and (c.valid_start is null or c.valid_start <= current_date)
- and (c.valid_end is null or c.valid_end >= current_date)
- and (c.expire_time is null or c.expire_time > now())
+ and (c.valid_start is null or c.valid_start <= current_date)
+ and (c.valid_end is null or c.valid_end >= current_date)
+ and (c.expire_time is null or c.expire_time > now())
limit 1
""")
Map<String, Object> selectActiveCard(@Param("talentId") Long talentId, @Param("cardId") Long cardId);
--
Gitblit v1.7.1