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 | 280 ++++++++++++++++++++++++++++++++++++++++++++++---------
1 files changed, 233 insertions(+), 47 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 d01cdb1..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,15 +10,20 @@
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.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;
@@ -25,16 +31,18 @@
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.UUID;
+import java.util.*;
import java.util.stream.Collectors;
@RestController
@RequestMapping("/userPolicy")
+@Slf4j
public class UserPolicyController extends BaseController {
@Autowired
@@ -51,6 +59,14 @@
@Autowired
private RedisDistributedLock redisDistributedLock;
+
+ @Autowired
+ InsuranceProductService insuranceProductService;
+ @Autowired
+ private PayService payService;
+
+ @Value("${pay.key}")
+ private String key;
/**
* 保险购买申请
@@ -93,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();
@@ -106,7 +125,7 @@
*/
@GetMapping("/list")
public TableDataInfo list(@RequestParam(value = "account",required = false) String account,
- @RequestParam(value = "status",defaultValue = "0") Integer status,
+ @RequestParam(value = "state",defaultValue = "0") Integer state,
@RequestParam(value = "productName",required = false) String productName) {
startPage();
@@ -114,7 +133,7 @@
// 产品名称模糊查询
if (org.apache.commons.lang3.StringUtils.isNotBlank(account)) {
- wrapper.like(UserPolicy::getUserId, account);
+ wrapper.like(UserPolicy::getAccount, account);
}
// 产品代码模糊查询
@@ -123,10 +142,11 @@
}
// 审批状态
- if (status != null && status != 3) {
+ if (state != null && state == 3) {
wrapper.ne(UserPolicy::getApprovalStatus, 0);
}else{
wrapper.eq(UserPolicy::getApprovalStatus, 0);
+ wrapper.eq(UserPolicy::getPayStatus,2);
}
// 按创建时间倒序排列
@@ -156,6 +176,20 @@
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 = calculateInsuranceEndDateToDay(LocalDate.now(), userPolicy.getTerm());
@@ -168,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());
@@ -184,47 +223,44 @@
medicalInsuranceAccount.setUpdatedAt(new Date());
medicalInsuranceAccountService.save(medicalInsuranceAccount);
-
//判断上级用户职位达成
if(approvalStatus == 1){
- //查询当前用户
- UserAccount userAccount = userAccountService.getOne(new LambdaQueryWrapper<UserAccount>()
- .eq(UserAccount::getId, userPolicy.getUserId())
- );
- //上级
- 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());
+ 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("审批成功");
}
- });
- userAccountService.updateById(superiorUser);
+ 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("审批成功");
@@ -285,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