zj
2026-01-05 a20da8817adb2342bd60f79e47487186a586f93a
src/main/java/com/nq/service/impl/UserWithdrawServiceImpl.java
@@ -1,12 +1,12 @@
package com.nq.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.google.gson.Gson;
import com.nq.dao.*;
import com.nq.enums.EConfigKey;
import com.nq.enums.EUserAssets;
import com.nq.pay.PayUtil;
import com.nq.pojo.*;
import com.nq.service.*;
import com.github.pagehelper.PageHelper;
@@ -17,19 +17,23 @@
import com.nq.utils.*;
import com.nq.utils.http.HttpClientUtil;
import com.nq.utils.stock.WithDrawUtils;
import java.io.IOException;
import java.io.PrintWriter;
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.text.SimpleDateFormat;
import java.util.*;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.nq.utils.timeutil.DateTimeUtil;
import com.nq.utils.timeutil.TimeUtil;
import org.apache.commons.collections.map.HashedMap;
import org.apache.commons.lang3.ObjectUtils;
import org.apache.commons.lang3.StringUtils;
import org.slf4j.Logger;
@@ -39,8 +43,6 @@
import org.springframework.transaction.annotation.Transactional;
import org.springframework.stereotype.Service;
import static com.nq.utils.timeutil.DateTimeUtil.STANDARD_FORMAT;
@Service("iUserWithdrawService")
@@ -97,6 +99,9 @@
    @Resource
    StockTimeSettingMapper stockTimeSettingMapper;
    @Autowired
    TransferResponseService transferResponseService;
    @Transactional
    public ServerResponse outMoney(String amt, String with_Pwd,String accsetType,String bankId,HttpServletRequest request) throws Exception {
        if (StringUtils.isBlank(amt)) {
@@ -126,7 +131,7 @@
            }
            SiteSetting siteSetting = this.iSiteSettingService.getSiteSetting();
            if ((new BigDecimal(amt)).compareTo(new BigDecimal(siteSetting.getWithMinAmt().intValue())) == -1) {
                return ServerResponse.createByErrorMsg("Analog users cannot withdraw funds" + siteSetting.getWithMinAmt(),request);
                return ServerResponse.createByErrorMsg("最小提现金额:" + siteSetting.getWithMinAmt(),request);
            }
            boolean b = getServerResponse();
@@ -168,11 +173,11 @@
    }
    private boolean getServerResponse() {
        StockTimeSetting stockTimeSetting = stockTimeSettingMapper.selectOne(new QueryWrapper<StockTimeSetting>().eq("accets_type","IN"));
        if(stockTimeSetting == null){
        StockTimeSetting stockTimeSetting = stockTimeSettingMapper.selectOne(new QueryWrapper<StockTimeSetting>().eq("accets_type", "IN"));
        if (stockTimeSetting == null) {
            return false;
        }
        if(!stockTimeSetting.getWeekDay().contains(String.valueOf(LocalDate.now().getDayOfWeek().getValue()))){
        if (!stockTimeSetting.getWeekDay().contains(String.valueOf(LocalDate.now().getDayOfWeek().getValue()))) {
            return false;
        }
        return TimeUtil.isTradingHour(stockTimeSetting.getAmStartTime(), stockTimeSetting.getAmEndTime(), stockTimeSetting.getPmStartTime(), stockTimeSetting.getPmEndTime());
@@ -241,6 +246,7 @@
                return ServerResponse.createByErrorMsg("用户资金账户不存在");
            }
            userAssets.setAvailableBalance(userAssets.getAvailableBalance().add(userWithdraw.getWithAmt()));
            userAssets.setFreezeMoney(userAssets.getFreezeMoney().subtract(userWithdraw.getWithAmt()));
            int updateUserCount = userAssetsMapper.updateById(userAssets);
            if (updateUserCount > 0) {
@@ -329,22 +335,22 @@
    }
    public ServerResponse updateState(Integer withId, Integer state, String authMsg) throws Exception {
        UserWithdraw userWithdraw = this.userWithdrawMapper.selectByPrimaryKey(withId);
        SiteSetting siteSetting = siteSettingService.getSiteSetting();
        if (userWithdraw == null) {
            return ServerResponse.createByErrorMsg("提现订单不存在");
        }
        log.info("当前系统设置  {}", new Gson().toJson(siteSetting));
        if (userWithdraw.getWithStatus().intValue() != 0) {
            return ServerResponse.createByErrorMsg("提现订单已处理,不要重复操作");
        }
        if (state.intValue() == 3 &&
                StringUtils.isBlank(authMsg)) {
            return ServerResponse.createByErrorMsg("失败信息必填");
        }
        if (state == 3) {
    @Transactional
    public ServerResponse updateState(Integer withId, Integer state, String authMsg, HttpServletRequest request, HttpServletResponse response) throws Exception {
        try {
            UserWithdraw userWithdraw = this.userWithdrawMapper.selectByPrimaryKey(withId);
            SiteSetting siteSetting = siteSettingService.getSiteSetting();
            if (userWithdraw == null) {
                return ServerResponse.createByErrorMsg("提现订单不存在");
            }
            log.info("当前系统设置  {}", new Gson().toJson(siteSetting));
            if (userWithdraw.getWithStatus().intValue() != 0) {
                return ServerResponse.createByErrorMsg("提现订单已处理,不要重复操作");
            }
            if (state.intValue() == 3 &&
                    StringUtils.isBlank(authMsg)) {
                return ServerResponse.createByErrorMsg("失败信息必填");
            }
            User user = this.userMapper.selectById(userWithdraw.getUserId());
            if (user == null) {
                return ServerResponse.createByErrorMsg("用户不存在");
@@ -353,25 +359,54 @@
            if (userAssets == null) {
                return ServerResponse.createByErrorMsg("用户资金账户不存在");
            }
            userAssets.setAvailableBalance(userAssets.getAvailableBalance().add(userWithdraw.getWithAmt()));
            int updateCount = userAssetsMapper.updateById(userAssets);
            if (updateCount > 0) {
                log.info("提现失败,返还用户资金成功!");
            } else {
                log.error("返还用户资金出错,抛出异常");
                throw new Exception("修改用户资金出错,抛出异常");
            if (state == 3) {
                if(userAssets.getAmountToBeCovered().compareTo(BigDecimal.ZERO) > 0){
                    BigDecimal subtract = userWithdraw.getWithAmt().subtract(userAssets.getAmountToBeCovered());
                    if(subtract.compareTo(BigDecimal.ZERO) > 0){
                        userAssets.setAvailableBalance(userAssets.getAvailableBalance().add(subtract));
                        userAssets.setFreezeMoney(userAssets.getFreezeMoney().subtract(subtract));
                        userAssets.setAmountToBeCovered(BigDecimal.ZERO);
                    }else{
                        userAssets.setAmountToBeCovered(userAssets.getAmountToBeCovered().subtract(userWithdraw.getWithAmt()));
                    }
                }else{
                    userAssets.setAvailableBalance(userAssets.getAvailableBalance().add(userWithdraw.getWithAmt()));
                    userAssets.setFreezeMoney(userAssets.getFreezeMoney().subtract(userWithdraw.getWithAmt()));
                }
                int updateCount = userAssetsMapper.updateById(userAssets);
                if (updateCount > 0) {
                    log.info("提现失败,返还用户资金成功!");
                } else {
                    log.error("返还用户资金出错,抛出异常");
                    throw new Exception("修改用户资金出错,抛出异常");
                }
                userWithdraw.setWithMsg(authMsg);
                userWithdraw.setWithStatus(2);
                userWithdraw.setTransTime(new Date());
                userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
                return ServerResponse.createBySuccessMsg("操作成功!");
            }else if(state == 2){//手动打款
                userAssets.setFreezeMoney(userAssets.getFreezeMoney().subtract(userWithdraw.getWithAmt()));
                userAssetsMapper.updateById(userAssets);
                userWithdraw.setWithStatus(1);
                userWithdraw.setTransTime(new Date());
                int updateCount = this.userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
                if (updateCount > 0) {
                    return ServerResponse.createBySuccessMsg("操作成功!");
                }
            }else if(state == 1){//走代付
                return getObjectServerResponseOne(withId, request, response, userWithdraw, user, userAssets);
            }else{
                return ServerResponse.createByErrorMsg("请选择对应的操作!");
            }
            userWithdraw.setWithMsg(authMsg);
        }catch (Exception e){
            log.info("提现失败:"+e.getMessage());
            throw e;
        }
        userWithdraw.setWithStatus(state);
        userWithdraw.setTransTime(new Date());
        int updateCount = this.userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
        if (updateCount > 0) {
            return ServerResponse.createBySuccessMsg("操作成功!");
        }
        return ServerResponse.createByErrorMsg("操作失败!");
        return ServerResponse.createBySuccessMsg("操作失败!");
    }
    public int deleteByUserId(Integer userId) {
        return this.userWithdrawMapper.deleteByUserId(userId);
@@ -405,5 +440,118 @@
    }
    /**
     * 代付接口调用
     */
    private ServerResponse getObjectServerResponseOne(Integer withId, HttpServletRequest request,
                                                       HttpServletResponse response, UserWithdraw userWithdraw,
                                                       User user, UserAssets userAssets) throws Exception {
        try {
            // 配置参数(建议放到配置文件中)
            String appId = "db270b73dc384c89ae7241d6465cee03"; // 从商户后台获取
            String key = "PAXkm5ptBhvzNYBSpdm3p7ipwGUQOF8Fm3tYp0"; // 商户密钥
            String payoutUrl = "https://www.copays.net/open-api/create-payout-order"; // 代付接口地址
            // 生成商户订单号
            String merchantOrderId = generatePayoutOrderId(withId);
            // 处理金额,保留两位小数
            BigDecimal amount = userWithdraw.getWithAmt();
            amount = amount.setScale(2, BigDecimal.ROUND_HALF_UP);
            // 构建请求参数
            Map<String, String> params = new HashMap<>();
            params.put("app_id", appId);
            params.put("merchant_order_id", merchantOrderId);
            params.put("amount", amount.toString());
            params.put("payout_mode", "INDIA_IMPS"); // 代付模式,根据实际情况选择
            params.put("customer_account_type", userWithdraw.getBankAddress()); // 账号类型
            params.put("customer_account_no", userWithdraw.getBankNo()); // 收款人账号(银行卡号或UPI ID)
            params.put("notify_url", "https://api.durocaspitall.com/user/payoutCallback.do"); // 异步通知地址
            // 生成签名
            String sign = PaymentSignUtil.generateSign(params, key);
            params.put("sign", sign);
            log.info("代付请求参数:{}", params);
            log.info("生成的签名:{}", sign);
            // 发送请求
            String result = HttpClientUtil.doPost(payoutUrl, params, "utf-8");
            log.info("代付返回参数:{}", result);
            // 解析响应
            ObjectMapper objectMapper = new ObjectMapper();
            PayoutOrderResponseVo payoutResponse = objectMapper.readValue(result, PayoutOrderResponseVo.class);
            // 检查响应
            if (!Integer.valueOf(200).equals(payoutResponse.getCode())) {
                log.error("代付下单失败,返回码:{},消息:{},请求参数:{}",
                        payoutResponse.getCode(), payoutResponse.getMessage(), params);
                // 代付失败,返还用户资金
                userAssets.setAvailableBalance(userAssets.getAvailableBalance().add(userWithdraw.getWithAmt()));
                userAssets.setFreezeMoney(userAssets.getFreezeMoney().subtract(userWithdraw.getWithAmt()));
                userAssetsMapper.updateById(userAssets);
                userWithdraw.setWithStatus(2); // 失败
                userWithdraw.setWithMsg("代付下单失败:" + payoutResponse.getMessage());
                userWithdraw.setTransTime(new Date());
                userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
                return ServerResponse.createByErrorMsg("代付下单失败:" + payoutResponse.getMessage());
            }
            // 保存代付记录
            PayoutOrderResponseVo.PayoutOrderData responseData = payoutResponse.getData();
            TransferResponse transferResponse = new TransferResponse();
            transferResponse.setMerTransferId(merchantOrderId); // 商户订单号
            transferResponse.setTradeNo(responseData.getSystemOrderId()); // 系统订单号
            transferResponse.setTransferAmount(amount);
            transferResponse.setTradeResult(0); // 0:已下单
            transferResponse.setCallbackState(0); // 0:未处理
            transferResponse.setRespCode("SUCCESS"); // 响应状态:下单成功
            transferResponse.setSignType("MD5"); // 签名方式
            transferResponse.setSign(responseData.getSign()); // 签名
            transferResponse.setApplyDate(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date())); // 订单时间
            transferResponse.setUserId(user.getId());
            transferResponse.setWithId(withId);
            transferResponse.setCreatedAt(new Date());
            transferResponse.setUpdatedAt(new Date());
            transferResponseService.save(transferResponse);
            // 更新提现记录状态为已提交(4)
            userWithdraw.setWithStatus(4); // 已提交
            userWithdraw.setTransTime(new Date());
            userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
            log.info("代付下单成功,订单号:{}", merchantOrderId);
            return ServerResponse.createBySuccessMsg("代付申请已提交,请等待处理");
        } catch (Exception e) {
            log.error("代付下单异常:", e);
            // 异常时返还用户资金
            userAssets.setAvailableBalance(userAssets.getAvailableBalance().add(userWithdraw.getWithAmt()));
            userAssets.setFreezeMoney(userAssets.getFreezeMoney().subtract(userWithdraw.getWithAmt()));
            userAssetsMapper.updateById(userAssets);
            userWithdraw.setWithStatus(2); // 失败
            userWithdraw.setWithMsg("代付下单异常:" + e.getMessage());
            userWithdraw.setTransTime(new Date());
            userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
            throw e;
        }
    }
    /**
     * 生成代付订单号
     */
    private String generatePayoutOrderId(Integer withId) {
        // 使用提现ID + 时间戳生成唯一订单号
        long timestamp = System.currentTimeMillis();
        return "PAYOUT_" + withId + "_" + timestamp;
    }
}