From 8898f00c2150048a03ca561b7ed98dbf9c80732b Mon Sep 17 00:00:00 2001
From: wenminjie <1036699586@qq.com>
Date: 星期四, 06 八月 2026 16:18:51 +0800
Subject: [PATCH] flyway、对接小程序
---
talent-card-server/src/main/java/com/talentcard/server/mapper/TicketPackageCodeMapper.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/talent-card-server/src/main/java/com/talentcard/server/mapper/TicketPackageCodeMapper.java b/talent-card-server/src/main/java/com/talentcard/server/mapper/TicketPackageCodeMapper.java
index 1354569..f5be65e 100644
--- a/talent-card-server/src/main/java/com/talentcard/server/mapper/TicketPackageCodeMapper.java
+++ b/talent-card-server/src/main/java/com/talentcard/server/mapper/TicketPackageCodeMapper.java
@@ -47,6 +47,21 @@
""")
TicketPackageCode selectAvailableCodeForUpdate(@Param("packageId") Long packageId);
+ @Select("""
+ select c.*
+ from ticket_package_code c
+ join ticket_package p on p.id = c.package_id and p.deleted = 0 and p.status = 1
+ where c.deleted = 0
+ and c.status = 'AVAILABLE'
+ and p.merchant_id = #{merchantId}
+ and (p.valid_start is null or p.valid_start <= current_date)
+ and (p.valid_end is null or p.valid_end >= current_date)
+ order by c.id asc
+ limit 1
+ for update
+ """)
+ TicketPackageCode selectAvailableByMerchantForUpdate(@Param("merchantId") Long merchantId);
+
@Update("""
update ticket_package_code
set status = 'LOCKED',
--
Gitblit v1.7.1