From bc2efbdb52190fe2e7be9920bbed6902d4ee28aa Mon Sep 17 00:00:00 2001
From: shinnosuke <tantao@1hoper.com>
Date: 星期五, 21 八月 2026 11:53:37 +0800
Subject: [PATCH] fix: centralize merchant type integration

---
 talent-card-server/src/main/java/com/talentcard/server/business/portal/SpouseEmploymentPortalService.java |    3 +--
 1 files changed, 1 insertions(+), 2 deletions(-)

diff --git a/talent-card-server/src/main/java/com/talentcard/server/business/portal/SpouseEmploymentPortalService.java b/talent-card-server/src/main/java/com/talentcard/server/business/portal/SpouseEmploymentPortalService.java
index b31f21b..2ab4eba 100644
--- a/talent-card-server/src/main/java/com/talentcard/server/business/portal/SpouseEmploymentPortalService.java
+++ b/talent-card-server/src/main/java/com/talentcard/server/business/portal/SpouseEmploymentPortalService.java
@@ -114,8 +114,7 @@
                        m.merchant_rights_config
                 from merchant m
                 left join spouse_employment_benefit b on b.merchant_id = m.id and b.deleted = 0
-                join premium_topic_merchant mapping on mapping.merchant_id = m.id and mapping.category_key = 'employment' and mapping.deleted = 0
-                where m.id = ? and m.deleted = 0
+                where m.id = ? and m.deleted = 0 and m.merchant_type_code = 'employment'
                 """, merchantId);
         if (rows.isEmpty()) throw new BusinessException(ErrorCode.NOT_FOUND, "配偶推荐就业权益不存在");
         return rows.get(0);

--
Gitblit v1.7.1