package com.talentcard.server.business.portal;
|
|
import java.util.LinkedHashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import com.talentcard.server.business.DatabaseRows;
|
import com.talentcard.server.common.BusinessException;
|
import com.talentcard.server.common.ErrorCode;
|
import org.springframework.jdbc.core.JdbcTemplate;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
@Service
|
public class ShoppingMerchantPortalService {
|
private final JdbcTemplate jdbc;
|
private final PortalService portalService;
|
|
public ShoppingMerchantPortalService(JdbcTemplate jdbc, PortalService portalService) {
|
this.jdbc = jdbc;
|
this.portalService = portalService;
|
}
|
|
@Transactional(readOnly = true)
|
public Map<String, Object> detail(Long merchantId) {
|
return detail(merchantId, null);
|
}
|
|
@Transactional(readOnly = true)
|
public Map<String, Object> detail(Long merchantId, Long talentId) {
|
Map<String, Object> row = one("""
|
select m.id, m.merchant_name, m.cover_url, m.service_label, m.address, m.contact_mobile, m.contact_name, m.rights_text,
|
m.longitude, m.latitude, m.status as merchant_status,
|
case m.merchant_type_code
|
when 'housing' then 'housing' when 'car' then 'car'
|
when 'appliance' then 'appliance' when 'digital' then 'digital'
|
when 'culture' then 'book' when 'telecom' then 'telecom' end as category_key,
|
detail_config.talent_levels, detail_config.benefit_detail, detail_config.advisor_id,
|
detail_config.advisor_name, detail_config.advisor_department, detail_config.advisor_mobile,
|
detail_config.advisor_service_time, detail_config.advisor_available,
|
detail_config.unavailable_reason, detail_config.status as detail_status
|
from merchant m
|
left join shopping_service_detail detail_config on detail_config.merchant_id = m.id and detail_config.deleted = 0
|
where m.id = ? and m.merchant_type_code in ('shopping', 'housing', 'car', 'appliance', 'digital', 'culture', 'telecom') and m.deleted = 0
|
order by detail_config.id asc limit 1
|
""", merchantId);
|
Map<String, Object> configuredMerchant = portalService.merchantDetail(merchantId, talentId);
|
String rightsStatus = text(configuredMerchant.get("rightsStatus"), "UNCONFIGURED");
|
boolean rightsAvailable = !"DISABLED".equals(rightsStatus) && !"MISSING".equals(rightsStatus);
|
boolean available = number(row.get("merchantStatus")) == 1
|
&& (row.get("detailStatus") == null || number(row.get("detailStatus")) == 1)
|
&& rightsAvailable;
|
Map<String, Object> result = new LinkedHashMap<>();
|
result.put("merchantId", row.get("id"));
|
result.put("categoryId", row.get("categoryKey"));
|
result.put("merchantName", row.get("merchantName"));
|
result.put("coverUrl", row.get("coverUrl"));
|
result.put("discountText", text(row.get("serviceLabel"), ""));
|
result.put("applicableCards", text(configuredMerchant.get("rightsTag"), text(row.get("talentLevels"), "")));
|
result.put("address", text(row.get("address"), ""));
|
result.put("contactMobile", text(row.get("contactMobile"), ""));
|
result.put("longitude", row.get("longitude"));
|
result.put("latitude", row.get("latitude"));
|
result.put("benefitDetail", text(configuredMerchant.get("rightsText"), text(row.get("benefitDetail"), text(row.get("rightsText"), ""))));
|
result.put("rightsStatus", rightsStatus);
|
result.put("available", available);
|
String unavailableReason = switch (rightsStatus) {
|
case "DISABLED" -> "当前人才卡暂未开通该权益";
|
case "MISSING" -> "当前人才卡暂未配置该权益";
|
default -> text(row.get("unavailableReason"), "该购物服务当前不可用");
|
};
|
result.put("unavailableReason", available ? "" : unavailableReason);
|
Map<String, Object> advisor = new LinkedHashMap<>();
|
advisor.put("advisorId", row.get("advisorId"));
|
advisor.put("name", text(row.get("advisorName"), text(row.get("contactName"), "")));
|
advisor.put("department", text(row.get("advisorDepartment"), ""));
|
advisor.put("mobile", text(row.get("advisorMobile"), text(row.get("contactMobile"), "")));
|
advisor.put("serviceTime", text(row.get("advisorServiceTime"), ""));
|
advisor.put("available", (row.get("advisorAvailable") == null || number(row.get("advisorAvailable")) == 1) && !text(row.get("advisorMobile"), text(row.get("contactMobile"), "")).isEmpty());
|
result.put("advisor", advisor);
|
return result;
|
}
|
|
private Map<String, Object> one(String sql, Object... args) {
|
List<Map<String, Object>> rows = jdbc.queryForList(sql, args).stream().map(DatabaseRows::normalize).toList();
|
if (rows.isEmpty()) throw new BusinessException(ErrorCode.NOT_FOUND, "购物服务详情不存在");
|
return rows.get(0);
|
}
|
|
private int number(Object value) {
|
return value instanceof Number number ? number.intValue() : 0;
|
}
|
|
private String text(Object value, String fallback) {
|
if (value == null) return fallback;
|
String text = String.valueOf(value).trim();
|
return text.isEmpty() ? fallback : text;
|
}
|
}
|
