From bacaa6e8f87ba4167901095ddb82c4a2ac2e74ca Mon Sep 17 00:00:00 2001
From: shinnosuke <tantao@1hoper.com>
Date: 星期四, 20 八月 2026 13:45:17 +0800
Subject: [PATCH] fix: repair benefit submissions and parking review flow
---
talent-card-server/src/main/java/com/talentcard/server/mapper/ServiceApplicationMapper.java | 7 +++++--
1 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/talent-card-server/src/main/java/com/talentcard/server/mapper/ServiceApplicationMapper.java b/talent-card-server/src/main/java/com/talentcard/server/mapper/ServiceApplicationMapper.java
index 1420830..1ac90ab 100644
--- a/talent-card-server/src/main/java/com/talentcard/server/mapper/ServiceApplicationMapper.java
+++ b/talent-card-server/src/main/java/com/talentcard/server/mapper/ServiceApplicationMapper.java
@@ -57,11 +57,14 @@
m.longitude,
m.latitude
from merchant m
- join premium_topic_merchant mapping on mapping.merchant_id = m.id and mapping.deleted = 0
where m.id = #{merchantId}
- and mapping.category_key = #{categoryKey}
and m.deleted = 0
and m.status = 1
+ and (exists (select 1 from premium_topic_merchant mapping
+ where mapping.merchant_id = m.id
+ and mapping.category_key = #{categoryKey}
+ and mapping.deleted = 0)
+ or (#{categoryKey} = 'medical' and m.merchant_type in ('medical', '免费体检', 'healthCheck')))
limit 1
""")
Map<String, Object> selectPremiumMerchantSnapshot(@Param("merchantId") Long merchantId, @Param("categoryKey") String categoryKey);
--
Gitblit v1.7.1