From 52ee6ca100d1fb7aa4108e588d9125f942d1a624 Mon Sep 17 00:00:00 2001
From: shinnosuke <tantao@1hoper.com>
Date: 星期三, 19 八月 2026 09:28:41 +0800
Subject: [PATCH] fix: update portal and merchant detail displays
---
talent-card-server/src/main/java/com/talentcard/server/mapper/ServiceApplicationMapper.java | 13 +++++++++----
1 files changed, 9 insertions(+), 4 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 bf191b6..1420830 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
@@ -69,14 +69,19 @@
@Select("""
select p.id as packageId,
p.merchant_id as merchantId,
- p.package_name as packageName,
+ p.product_name as packageName,
p.stock,
p.status,
- p.unavailable_reason as unavailableReason
- from medical_package p
+ case
+ when p.status != 1 then '套餐已停用'
+ when p.stock = 0 then '当前库存不足'
+ else ''
+ end as unavailableReason
+ from merchant_product p
where p.id = #{packageId}
and (#{merchantId} is null or p.merchant_id = #{merchantId})
and p.deleted = 0
+ and p.audit_status = 2
limit 1
""")
Map<String, Object> selectMedicalPackage(@Param("packageId") Long packageId, @Param("merchantId") Long merchantId);
@@ -117,4 +122,4 @@
for update
""")
ServiceApplication selectByIdForUpdate(@Param("id") Long id);
-}
\ No newline at end of file
+}
--
Gitblit v1.7.1