From 8dcc757d17dd3bed804167a0aa640a978f10022c Mon Sep 17 00:00:00 2001
From: dd <gitluke@outlook.com>
Date: Tue, 21 Oct 2025 01:23:43 +0800
Subject: [PATCH] 1
---
ruoyi-admin/src/main/java/com/ruoyi/web/controller/product/UserPolicyController.java | 357 +++++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 295 insertions(+), 62 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 68c2e52..a825d9f 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;
@@ -16,10 +17,18 @@
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.SubordinateInformationDto;
import com.ruoyi.system.domain.dto.UserPolicyDto;
import com.ruoyi.im.service.UserPolicyService;
+import com.ruoyi.system.domain.out.UserTeamAndPositionOut;
+import com.ruoyi.system.service.FundsLogService;
+import com.ruoyi.system.service.PaymentRecordService;
import com.ruoyi.system.service.UserAccountService;
+import lombok.extern.slf4j.Slf4j;
+import org.apache.catalina.User;
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;
@@ -28,6 +37,9 @@
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.*;
@@ -35,6 +47,7 @@
@RestController
@RequestMapping("/userPolicy")
+@Slf4j
public class UserPolicyController extends BaseController {
@Autowired
@@ -54,41 +67,69 @@
@Autowired
InsuranceProductService insuranceProductService;
+
@Autowired
- private PayService payService;
+ PaymentRecordService paymentRecordService;
+
+ @Autowired
+ FundsLogService fundsLogService;
+
+ @Value("${pay.key}")
+ private String key;
/**
* 保险购买申请
*/
@PostMapping("/purchaseApplication")
public Result purchaseApplication(UserPolicyDto dto) {
- // 生成锁的key：基于用户ID和产品ID，防止同一用户同时购买同一产品
- String lockKey = redisDistributedLock.generateLockKey(dto.getAccount(), dto.getProductId());
+ synchronized (dto.getAccount()) {
+ // 生成锁的key：基于用户ID和产品ID，防止同一用户同时购买同一产品
+ String lockKey = redisDistributedLock.generateLockKey(dto.getAccount(), dto.getProductId());
- boolean lockAcquired = false;
- try {
- // 尝试获取分布式锁：等待10秒，锁过期30秒
- lockAcquired = redisDistributedLock.tryLock(lockKey, 30L, 10L);
+ boolean lockAcquired = false;
+ try {
+ // 尝试获取分布式锁：等待10秒，锁过期30秒
+ lockAcquired = redisDistributedLock.tryLock(lockKey, 30L, 10L);
- if (!lockAcquired) {
- return Result.error("操作过于频繁，请稍后重试");
- }
+ if (!lockAcquired) {
+ return Result.error("操作过于频繁，请稍后重试");
+ }
- // 执行购买逻辑
- return userPolicyService.purchaseApplication(dto);
+ // 执行购买逻辑
+ return userPolicyService.purchaseApplication(dto);
- } catch (Exception e) {
- e.printStackTrace();
- return Result.error("购买失败");
- } finally {
- // 释放锁
- if (lockAcquired) {
- redisDistributedLock.releaseLock(lockKey);
+ } catch (Exception e) {
+ e.printStackTrace();
+ return Result.error("购买失败");
+ } finally {
+ // 释放锁
+ if (lockAcquired) {
+ redisDistributedLock.releaseLock(lockKey);
+ }
}
}
}
+
+ /**
+ * 根据用户id查询保单
+ */
+ @GetMapping("/updateGender")
+ public AjaxResult updateGender(@RequestParam(value = "id") Integer id,@RequestParam(value = "gender") UserPolicy.Gender gender) {
+ try {
+ UserPolicy userPolicy = userPolicyService.getById(id);
+ if(ObjectUtil.isEmpty(userPolicy)){
+ AjaxResult.error("保单不存在！");
+ }
+ userPolicy.setGender(gender);
+ userPolicyService.updateById(userPolicy);
+ return AjaxResult.success("修改成功");
+ }catch (Exception e){
+ e.printStackTrace();
+ return AjaxResult.error("修改失败！");
+ }
+ }
/**
* 根据用户id查询保单
@@ -101,6 +142,7 @@
List<UserPolicy> list = userPolicyService.list(new LambdaQueryWrapper<UserPolicy>()
.eq(UserPolicy::getUserId, userAccount.getId())
.eq(UserPolicy::getPayStatus,2)
+ .eq(UserPolicy::getApprovalStatus,1)
);
return Result.success(list);
}catch (Exception e){
@@ -135,9 +177,7 @@
wrapper.ne(UserPolicy::getApprovalStatus, 0);
}else{
wrapper.eq(UserPolicy::getApprovalStatus, 0);
- wrapper.eq(UserPolicy::getPayStatus,3)
- .or()
- .eq(UserPolicy::getPayStatus,2);
+ wrapper.eq(UserPolicy::getPayStatus,2);
}
// 按创建时间倒序排列
@@ -147,6 +187,34 @@
return getDataTable(list);
}
+
+ /**
+ * 支付记录列表
+ */
+ @GetMapping("/PaymentRecordList")
+ public TableDataInfo PaymentRecordList( @RequestParam(value = "account",required = false) String account,
+ @RequestParam(value = "payOrdeNo",required = false) String payOrdeNo,
+ @RequestParam(value = "paymentStatus",required = false) Integer paymentStatus) {
+ startPage();
+
+ LambdaQueryWrapper<PaymentRecord> wrapper = new LambdaQueryWrapper<>();
+
+ if (StringUtils.isNotEmpty(account)) {
+ wrapper.eq(PaymentRecord::getAccount, account);
+ }
+ // 产品名称模糊查询
+ if (StringUtils.isNotEmpty(payOrdeNo)) {
+ wrapper.eq(PaymentRecord::getPayOrdeNo, payOrdeNo);
+ }
+ if (paymentStatus != null) {
+ wrapper.eq(PaymentRecord::getPaymentStatus, paymentStatus);
+ }
+ // 按创建时间倒序排列
+ wrapper.orderByDesc(PaymentRecord::getCreateTime);
+
+ List<PaymentRecord> list = paymentRecordService.list(wrapper);
+ return getDataTable(list);
+ }
/**
* 保单审批
@@ -179,16 +247,21 @@
userAccount.setBalance(userAccount.getBalance().add(userPolicy.getPremium()));
userAccountService.updateById(userAccount);
+ fundsLogService.addLog(userAccount.getId(), userAccount.getAccount(), userPolicy.getPremium(), OperationType.REFUND);
+
return AjaxResult.success("审批成功");
}
//计算到期时间
- LocalDate expirationTime = calculateInsuranceEndDateToDay(LocalDate.now(), userPolicy.getTerm());
+ LocalDate expirationTime = calculateInsuranceEndDate(LocalDate.now(), userPolicy.getTerm());
+ //保险金领取到期时间
+ LocalDate insuranceBenefitExpiryDate = calculateInsuranceEndDateToDay(LocalDate.now(), userPolicy.getNumberDays());
userPolicy.setApprovalStatus(approvalStatus);
userPolicy.setMessage(message);
userPolicy.setStartDate(LocalDate.now());
- userPolicy.setEndDate(expirationTime);
+ userPolicy.setEndDate(expirationTime.minusDays(1));
+ userPolicy.setInsuranceBenefitExpiryDate(insuranceBenefitExpiryDate);
userPolicy.setPolicyStatus(UserPolicy.PolicyStatus.ACTIVE);
userPolicy.setUpdatedAt(new Date());
userPolicyService.updateById(userPolicy);
@@ -196,7 +269,7 @@
//每天可领
BigDecimal amountClaimed = userPolicy.getCoverageAmount()
- .divide(new BigDecimal(userPolicy.getTerm()), 4, RoundingMode.HALF_UP);
+ .divide(new BigDecimal(userPolicy.getNumberDays()), 4, RoundingMode.HALF_UP);
MedicalInsuranceAccount medicalInsuranceAccount = new MedicalInsuranceAccount();
medicalInsuranceAccount.setUserId(userPolicy.getUserId());
@@ -208,6 +281,7 @@
medicalInsuranceAccount.setAlreadyReceived(BigDecimal.ZERO);
medicalInsuranceAccount.setAmountAlreadyUsed(BigDecimal.ZERO);
medicalInsuranceAccount.setEffectiveDate(userPolicy.getStartDate());
+ medicalInsuranceAccount.setInsuranceBenefitExpiryDate(userPolicy.getInsuranceBenefitExpiryDate());
medicalInsuranceAccount.setExpiryDate(userPolicy.getEndDate());
medicalInsuranceAccount.setAccountStatus(MedicalInsuranceAccount.AccountStatus.ACTIVE);
medicalInsuranceAccount.setCreatedAt(new Date());
@@ -264,7 +338,7 @@
}
/**
- * 计算保险到期日
+ * 计算保险到期日按天
* @param startDate 保险开始日期
* @param termDays 保险天数
* @return 保险到期日期
@@ -315,50 +389,209 @@
- /**
- * 支付回调接口 - 支付平台会调用这个接口
- */
@PostMapping("/notify")
- public String payNotify(@RequestParam Map<String, String> params) {
- System.out.println("收到支付回调: " + params);
+ public String payNotify(@RequestBody PayCallbackDTO callbackDTO) {
+ try {
+ log.info("收到支付回调通知: {}", JSON.toJSONString(callbackDTO));
- // 验证签名
- if (!payService.verifySign(params)) {
- System.out.println("签名验证失败");
- return "fail";
+ // 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";
}
-
- // 获取关键参数
- String orderNo = params.get("mchOrderNo");
- String status = params.get("status");
- String amount = params.get("amount");
-
- System.out.println("订单号: " + orderNo + ", 状态: " + status + ", 金额: " + amount);
-
- // 这里调用您的业务处理逻辑
- handlePayResult(orderNo, Integer.valueOf(status), params);
-
- return "success";
}
+ 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);
+ PaymentRecord paymentRecord = paymentRecordService.getOne(new LambdaQueryWrapper<PaymentRecord>()
+ .eq(PaymentRecord::getPayOrdeNo, callbackDTO.getOrderId())
+ );
+ if(ObjectUtil.isNotEmpty(paymentRecord)){
+ paymentRecord.setPaymentStatus(PaymentRecord.PaymentStatus.PAID.getCode());
+ paymentRecordService.updateById(paymentRecord);
+ }
+ 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);
+ PaymentRecord paymentRecord = paymentRecordService.getOne(new LambdaQueryWrapper<PaymentRecord>()
+ .eq(PaymentRecord::getPayOrdeNo, callbackDTO.getOrderId())
+ );
+ if(ObjectUtil.isNotEmpty(paymentRecord)){
+ paymentRecord.setPaymentStatus(PaymentRecord.PaymentStatus.EXPIRED.getCode());
+ paymentRecordService.updateById(paymentRecord);
+ }
+ 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);
+ }
+ }
/**
- * 处理支付结果 - 这里您自己实现业务逻辑
+ * 保单列表
*/
- private void handlePayResult(String orderNo, Integer status, Map<String, String> params) {
- UserPolicy userPolicy = userPolicyService.getOne(new LambdaQueryWrapper<UserPolicy>()
- .eq(UserPolicy::getOrderNo,orderNo));
- if(ObjectUtil.isNotEmpty(userPolicy)){
- if (status == 2) {
- userPolicy.setPayStatus(status);
- } else if (status == 3) {
- userPolicy.setPayStatus(status);
- } else if (0010 == status) {
- userPolicy.setPayMsg("系统超时或异常");
- } else if (0014 == status) {
- userPolicy.setPayMsg("mchId是系统分配的商户号，不能自己生成");
- }
- userPolicyService.updateById(userPolicy);
+ @GetMapping("/deleteRecordById")
+ public AjaxResult PaymentRecordList(@RequestParam(value = "id",required = false) Integer id) {
+ // 查询所有创建时间超过5分钟且状态为待支付的订单
+ PaymentRecord byId = paymentRecordService.getById(id);
+ if(ObjectUtil.isEmpty(byId)){
+ return AjaxResult.error("订单不存在！");
}
+ if(byId.getPaymentStatus() == 2){
+ return AjaxResult.error("订单已支付，禁止删除");
+ }
+ UserPolicy userPolicy = userPolicyService.getById(byId.getOrderId());
+ if(ObjectUtil.isEmpty(userPolicy)){
+ return AjaxResult.error("保单不存在！");
+ }
+ if(userPolicy.getPayStatus() == 2){
+ return AjaxResult.error("订单已支付，禁止删除");
+ }
+
+ paymentRecordService.removeById(byId);
+ userPolicyService.removeById(userPolicy);
+ return AjaxResult.success("删除成功");
+ }
+
+ /**
+ * 保单列表
+ */
+ @GetMapping("/getFundsLogList")
+ public TableDataInfo getFundsLogList(@RequestParam(value = "account",required = false) String account,@RequestParam(value = "operationType",required = false) Integer operationType) {
+ startPage();
+
+ LambdaQueryWrapper<FundsLog> wrapper = new LambdaQueryWrapper<>();
+
+ if(StringUtils.isNotEmpty(account)){
+ wrapper.eq(FundsLog::getAccount,account);
+ }
+ if (ObjectUtil.isNotEmpty(operationType)){
+ wrapper.eq(FundsLog::getOperationType,operationType);
+ }
+ wrapper.orderByDesc(FundsLog::getCreateTime);
+ List<FundsLog> list = fundsLogService.list(wrapper);
+ return getDataTable(list);
}
}
--
Gitblit v1.9.3