From 080dd1f1de81758b946c01e6db71938c008e9427 Mon Sep 17 00:00:00 2001
From: zj <1772600164@qq.com>
Date: Fri, 10 Oct 2025 02:00:02 +0800
Subject: [PATCH] 1
---
ruoyi-admin/src/main/java/com/ruoyi/web/controller/product/UserPolicyController.java | 322 ++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 300 insertions(+), 22 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/product/UserPolicyController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/product/UserPolicyController.java
index 193c723..09d15b3 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/product/UserPolicyController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/product/UserPolicyController.java
@@ -2,6 +2,7 @@
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.util.ObjectUtil;
+import com.alibaba.fastjson2.JSON;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
@@ -9,29 +10,39 @@
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.im.comm.Result;
+import com.ruoyi.im.service.InsuranceProductService;
import com.ruoyi.im.service.MedicalInsuranceAccountService;
-import com.ruoyi.system.domain.InsuranceProduct;
-import com.ruoyi.system.domain.MedicalInsuranceAccount;
-import com.ruoyi.system.domain.UserAccount;
-import com.ruoyi.system.domain.UserPolicy;
+import com.ruoyi.im.service.impl.InsurancePositionServiceImpl;
+import com.ruoyi.im.util.PayService;
+import com.ruoyi.im.util.RedisDistributedLock;
+import com.ruoyi.im.util.UserPolicyUtils;
+import com.ruoyi.system.domain.*;
+import com.ruoyi.system.domain.dto.PayCallbackDTO;
import com.ruoyi.system.domain.dto.UserPolicyDto;
import com.ruoyi.im.service.UserPolicyService;
import com.ruoyi.system.service.UserAccountService;
+import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.beans.factory.annotation.Value;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.interceptor.TransactionAspectSupport;
+import org.springframework.util.CollectionUtils;
import org.springframework.web.bind.annotation.*;
import javax.validation.Valid;
import java.math.BigDecimal;
+import java.math.RoundingMode;
+import java.nio.charset.StandardCharsets;
+import java.security.MessageDigest;
+import java.security.NoSuchAlgorithmException;
import java.time.LocalDate;
import java.time.LocalDateTime;
-import java.util.Calendar;
-import java.util.Date;
-import java.util.List;
+import java.util.*;
+import java.util.stream.Collectors;
@RestController
@RequestMapping("/userPolicy")
+@Slf4j
public class UserPolicyController extends BaseController {
@Autowired
@@ -43,18 +54,52 @@
@Autowired
UserAccountService userAccountService;
+ @Autowired
+ InsurancePositionServiceImpl insurancePositionService;
+
+ @Autowired
+ private RedisDistributedLock redisDistributedLock;
+
+ @Autowired
+ InsuranceProductService insuranceProductService;
+ @Autowired
+ private PayService payService;
+
+ @Value("${pay.key}")
+ private String key;
+
/**
* 保险购买申请
*/
@PostMapping("/purchaseApplication")
public Result purchaseApplication(UserPolicyDto dto) {
+ // 生成锁的key：基于用户ID和产品ID，防止同一用户同时购买同一产品
+ String lockKey = redisDistributedLock.generateLockKey(dto.getAccount(), dto.getProductId());
+
+ boolean lockAcquired = false;
try {
+ // 尝试获取分布式锁：等待10秒，锁过期30秒
+ lockAcquired = redisDistributedLock.tryLock(lockKey, 30L, 10L);
+
+ if (!lockAcquired) {
+ return Result.error("操作过于频繁，请稍后重试");
+ }
+
+ // 执行购买逻辑
return userPolicyService.purchaseApplication(dto);
- }catch (Exception e){
+
+ } catch (Exception e) {
e.printStackTrace();
return Result.error("购买失败");
+ } finally {
+ // 释放锁
+ if (lockAcquired) {
+ redisDistributedLock.releaseLock(lockKey);
+ }
}
}
+
+
/**
* 根据用户id查询保单
@@ -64,7 +109,10 @@
try {
UserAccount userAccount = userAccountService.getOne(new LambdaQueryWrapper<UserAccount>()
.eq(UserAccount::getAccount,account));
- List<UserPolicy> list = userPolicyService.list(new LambdaQueryWrapper<UserPolicy>().eq(UserPolicy::getUserId, userAccount.getId()));
+ List<UserPolicy> list = userPolicyService.list(new LambdaQueryWrapper<UserPolicy>()
+ .eq(UserPolicy::getUserId, userAccount.getId())
+ .eq(UserPolicy::getPayStatus,2)
+ );
return Result.success(list);
}catch (Exception e){
e.printStackTrace();
@@ -77,16 +125,15 @@
*/
@GetMapping("/list")
public TableDataInfo list(@RequestParam(value = "account",required = false) String account,
- @RequestParam(value = "approvalStatus",required = false) Integer approvalStatus,
- @RequestParam(value = "productName",required = false) String productName,
- @RequestParam(value = "policyStatus",required = false) String policyStatus) {
+ @RequestParam(value = "state",defaultValue = "0") Integer state,
+ @RequestParam(value = "productName",required = false) String productName) {
startPage();
LambdaQueryWrapper<UserPolicy> wrapper = new LambdaQueryWrapper<>();
// 产品名称模糊查询
if (org.apache.commons.lang3.StringUtils.isNotBlank(account)) {
- wrapper.like(UserPolicy::getUserId, account);
+ wrapper.like(UserPolicy::getAccount, account);
}
// 产品代码模糊查询
@@ -95,13 +142,11 @@
}
// 审批状态
- if (approvalStatus != null) {
- wrapper.eq(UserPolicy::getApprovalStatus, approvalStatus);
- }
-
- // 保单状态
- if (StringUtils.isNotEmpty(policyStatus)) {
- wrapper.eq(UserPolicy::getPolicyStatus, policyStatus);
+ if (state != null && state == 3) {
+ wrapper.ne(UserPolicy::getApprovalStatus, 0);
+ }else{
+ wrapper.eq(UserPolicy::getApprovalStatus, 0);
+ wrapper.eq(UserPolicy::getPayStatus,2);
}
// 按创建时间倒序排列
@@ -131,9 +176,23 @@
if(approvalStatus == 2 && StringUtils.isEmpty(message)){
return AjaxResult.error("驳回理由不能为空！");
}
+ if(userPolicy.getPayStatus() != 3 && userPolicy.getPayStatus() != 2){
+ return AjaxResult.error("保单未支付完成，不能进行审批！");
+ }
+ UserAccount userAccount = userAccountService.getById(userPolicy.getUserId());
+ if(approvalStatus == 2){
+ userPolicy.setApprovalStatus(approvalStatus);
+ userPolicy.setMessage(message);
+ userPolicy.setUpdatedAt(new Date());
+ userPolicyService.updateById(userPolicy);
+
+ userAccount.setBalance(userAccount.getBalance().add(userPolicy.getPremium()));
+ userAccountService.updateById(userAccount);
+ return AjaxResult.success("审批成功");
+ }
//计算到期时间
- LocalDate expirationTime = calculateInsuranceEndDate(LocalDate.now(), userPolicy.getTerm());
+ LocalDate expirationTime = calculateInsuranceEndDateToDay(LocalDate.now(), userPolicy.getTerm());
userPolicy.setApprovalStatus(approvalStatus);
userPolicy.setMessage(message);
@@ -143,13 +202,18 @@
userPolicy.setUpdatedAt(new Date());
userPolicyService.updateById(userPolicy);
+
+ //每天可领
+ BigDecimal amountClaimed = userPolicy.getCoverageAmount()
+ .divide(new BigDecimal(userPolicy.getTerm()), 4, RoundingMode.HALF_UP);
+
MedicalInsuranceAccount medicalInsuranceAccount = new MedicalInsuranceAccount();
medicalInsuranceAccount.setUserId(userPolicy.getUserId());
medicalInsuranceAccount.setPolicyId(userPolicy.getId());
medicalInsuranceAccount.setProductId(userPolicy.getProductId());
medicalInsuranceAccount.setTotalQuota(userPolicy.getCoverageAmount());
medicalInsuranceAccount.setRemainingBalance(BigDecimal.ZERO);
- medicalInsuranceAccount.setAmountClaimed(userPolicy.getCoverageAmount());
+ medicalInsuranceAccount.setAmountClaimed(amountClaimed);
medicalInsuranceAccount.setAlreadyReceived(BigDecimal.ZERO);
medicalInsuranceAccount.setAmountAlreadyUsed(BigDecimal.ZERO);
medicalInsuranceAccount.setEffectiveDate(userPolicy.getStartDate());
@@ -158,6 +222,47 @@
medicalInsuranceAccount.setCreatedAt(new Date());
medicalInsuranceAccount.setUpdatedAt(new Date());
medicalInsuranceAccountService.save(medicalInsuranceAccount);
+
+ //判断上级用户职位达成
+ if(approvalStatus == 1){
+ if(StringUtils.isNotEmpty(userAccount.getInvitationAccount())){
+ //上级
+ UserAccount superiorUser = userAccountService.getOne(new LambdaQueryWrapper<UserAccount>()
+ .eq(UserAccount::getAccount, userAccount.getInvitationAccount())
+ );
+ //查询上级的所有下级
+ List<UserAccount> userAccountList = userAccountService.list(new LambdaQueryWrapper<UserAccount>()
+ .eq(UserAccount::getInvitationAccount, superiorUser.getAccount())
+ );
+ if(userAccountList.size() == 0){
+ return AjaxResult.success("审批成功");
+ }
+ List<Integer> idList = userAccountList.stream()
+ .map(UserAccount::getId)
+ .collect(Collectors.toList());
+ //查询下级的保单
+ List<UserPolicy> userPolicyList = userPolicyService.list(new LambdaQueryWrapper<>(UserPolicy.class)
+ .in(UserPolicy::getUserId, idList)
+ );
+ // 手动将当前审批的保单加入到列表中（因为事务隔离可能查不到）
+ userPolicyList.add(userPolicy);
+ if(userPolicyList.size() == 0){
+ return AjaxResult.success("审批成功");
+ }
+ //生效保单数量
+ long activePolicies = UserPolicyUtils.countActivePolicies(userPolicyList);
+ //查询所有职位
+ List<InsurancePosition> positions = insurancePositionService.list();
+ positions.forEach(f->{
+ if(activePolicies >= f.getNumberPeople()){
+ superiorUser.setPosition(f.getPosition());
+ superiorUser.setAgreedTime(LocalDate.now());
+ }
+ });
+ userAccountService.updateById(superiorUser);
+ }
+ return AjaxResult.success("审批成功");
+ }
return AjaxResult.success("审批成功");
}catch (Exception e){
e.printStackTrace();
@@ -165,6 +270,29 @@
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
return AjaxResult.error("审批失败！");
}
+ }
+
+ /**
+ * 计算保险到期日
+ * @param startDate 保险开始日期
+ * @param termDays 保险天数
+ * @return 保险到期日期
+ */
+ public static LocalDate calculateInsuranceEndDateToDay(LocalDate startDate, int termDays) {
+ return calculateDateAfterDays(startDate, termDays);
+ }
+
+ /**
+ * 计算指定天数后的日期
+ * @param startDate 开始日期
+ * @param daysToAdd 要添加的天数
+ * @return 计算后的日期
+ */
+ public static LocalDate calculateDateAfterDays(LocalDate startDate, int daysToAdd) {
+ if (startDate == null) {
+ throw new IllegalArgumentException("开始日期不能为空");
+ }
+ return startDate.plusDays(daysToAdd);
}
/**
@@ -193,4 +321,154 @@
throw new IllegalArgumentException("基准日期不能为null");
}
}
+
+
+
+ @PostMapping("/notify")
+ public String payNotify(@RequestBody PayCallbackDTO callbackDTO) {
+ try {
+ log.info("收到支付回调通知: {}", JSON.toJSONString(callbackDTO));
+
+ // 1. 验证签名
+ if (!verifySign(callbackDTO)) {
+ log.error("签名验证失败: {}", callbackDTO.getOrderId());
+ return "签名验证失败";
+ }
+
+ // 2. 根据订单号查询保单
+ UserPolicy userPolicy = userPolicyService.getOne(new LambdaQueryWrapper<UserPolicy>()
+ .eq(UserPolicy::getOrderNo, callbackDTO.getOrderId()));
+ if (userPolicy == null) {
+ log.error("订单不存在: {}", callbackDTO.getOrderId());
+ return "订单不存在";
+ }
+ if(userPolicy.getPayStatus() == 2){
+ log.error("订单已支付完成: {}", callbackDTO.getOrderId());
+ return "订单已支付完成";
+ }
+ // 3. 根据订单状态处理业务逻辑
+ boolean processResult = processPayResult(callbackDTO, userPolicy);
+
+ return processResult ? "success" : "fail";
+
+ } catch (Exception e) {
+ log.error("支付回调处理异常: {}", e.getMessage(), e);
+ return "FAIL";
+ }
+ }
+
+ private boolean verifySign(PayCallbackDTO callbackDTO) {
+ try {
+ Map<String, Object> params = new HashMap<>();
+ params.put("channelCode", callbackDTO.getChannelCode());
+ params.put("orderId", callbackDTO.getOrderId());
+ params.put("orderMoney", callbackDTO.getOrderMoney());
+ params.put("orderStatus", callbackDTO.getOrderStatus());
+ params.put("userCode", callbackDTO.getUserCode());
+
+ String generatedSign = generateCallbackSign(params);
+ return generatedSign.equalsIgnoreCase(callbackDTO.getSign());
+ } catch (Exception e) {
+ log.error("签名验证异常: {}", e.getMessage(), e);
+ return false;
+ }
+ }
+
+ private String generateCallbackSign(Map<String, Object> params) {
+ try {
+ List<String> keys = new ArrayList<>(params.keySet());
+ Collections.sort(keys);
+
+ StringBuilder stringA = new StringBuilder();
+ for (String key : keys) {
+ Object value = params.get(key);
+ if (value != null && !"".equals(value.toString().trim()) && !"sign".equals(key)) {
+ if (stringA.length() > 0) {
+ stringA.append("&");
+ }
+ stringA.append(key).append("=").append(value.toString());
+ }
+ }
+
+ String stringSignTemp = stringA.toString() + "&key=" + key;
+ String md5Result = md5(stringSignTemp);
+ return md5Result.toLowerCase();
+
+ } catch (Exception e) {
+ throw new RuntimeException("生成回调签名失败: " + e.getMessage());
+ }
+ }
+
+ private boolean processPayResult(PayCallbackDTO callbackDTO, UserPolicy userPolicy) {
+ try {
+ switch (callbackDTO.getOrderStatus()) {
+ case 2: // 已支付
+ return handlePaySuccess(callbackDTO, userPolicy);
+ case 3: // 超时/过期
+ return handlePayTimeout(callbackDTO, userPolicy);
+ default:
+ log.info("订单状态未完成: {}, 状态: {}", callbackDTO.getOrderId(), callbackDTO.getOrderStatus());
+ return true;
+ }
+ } catch (Exception e) {
+ log.error("处理支付结果异常: {}", e.getMessage(), e);
+ return false;
+ }
+ }
+
+ private boolean handlePaySuccess(PayCallbackDTO callbackDTO, UserPolicy userPolicy) {
+ if (userPolicy.getPayStatus() == 2) {
+ log.info("订单已支付，无需重复处理: {}", callbackDTO.getOrderId());
+ return true;
+ }
+
+ userPolicy.setPayStatus(2); // 2-支付成功
+ userPolicy.setPolicyStatus(UserPolicy.PolicyStatus.ACTIVE);
+ userPolicy.setUpdatedAt(new Date());
+
+ boolean updateResult = userPolicyService.updateById(userPolicy);
+
+ if (updateResult) {
+ log.info("支付成功处理完成: {}", callbackDTO.getOrderId());
+ return true;
+ } else {
+ log.error("更新保单状态失败: {}", callbackDTO.getOrderId());
+ return false;
+ }
+ }
+
+ private boolean handlePayTimeout(PayCallbackDTO callbackDTO, UserPolicy userPolicy) {
+ userPolicy.setPayStatus(3); // 3-支付超时/过期
+ userPolicy.setPolicyStatus(UserPolicy.PolicyStatus.EXPIRED);
+ userPolicy.setUpdatedAt(new Date());
+
+ boolean updateResult = userPolicyService.updateById(userPolicy);
+
+ if (updateResult) {
+ log.info("支付超时处理完成: {}", callbackDTO.getOrderId());
+ return true;
+ } else {
+ log.error("更新保单超时状态失败: {}", callbackDTO.getOrderId());
+ return false;
+ }
+ }
+
+ private String md5(String input) {
+ try {
+ MessageDigest md = MessageDigest.getInstance("MD5");
+ byte[] messageDigest = md.digest(input.getBytes(StandardCharsets.UTF_8));
+
+ StringBuilder hexString = new StringBuilder();
+ for (byte b : messageDigest) {
+ String hex = Integer.toHexString(0xff & b);
+ if (hex.length() == 1) {
+ hexString.append('0');
+ }
+ hexString.append(hex);
+ }
+ return hexString.toString();
+ } catch (NoSuchAlgorithmException e) {
+ throw new RuntimeException("MD5加密失败", e);
+ }
+ }
}
--
Gitblit v1.9.3