1

zj

2025-03-17 3ed7b4b2c8cd28435e7cc2c1d3c5b091fafbf077

 src/main/java/com/nq/service/impl/UserWithdrawServiceImpl.java

@@ -1,8 +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.*;
@@ -17,15 +21,24 @@
import com.nq.utils.http.HttpClientUtil;
import com.nq.utils.stock.WithDrawUtils;

import java.io.IOException;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.math.BigDecimal;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
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;
@@ -84,9 +97,20 @@
    @Autowired
    SiteSettingServiceImpl siteSettingService;

    @Autowired
    IStockConfigServices iStockConfigServices;

    @Autowired
    UserAssetsMapper userAssetsMapper;

    @Resource
    StockTimeSettingMapper stockTimeSettingMapper;

    @Autowired
    TransferResponseService transferResponseService;

    @Transactional
    public ServerResponse outMoney(String amt, String with_Pwd,String accsetType,HttpServletRequest request) throws Exception {
    public ServerResponse outMoney(String amt, String with_Pwd,String accsetType,String bankId,HttpServletRequest request) throws Exception {
        if (StringUtils.isBlank(amt)) {
            return ServerResponse.createByErrorMsg("The parameter cannot be null");
        }
@@ -102,29 +126,26 @@
            if (user.getIsLogin().intValue() == 1) {
                return ServerResponse.createByErrorMsg("用户被锁定",request);
            }
            if (StringUtils.isBlank(user.getRealName()) || StringUtils.isBlank(user.getIdCard())) {
            if (user.getIsActive() != 2) {
                return ServerResponse.createByErrorMsg("未实名认证",request);
            }
            UserBank userBank = this.iUserBankService.findUserBankByUserId(user.getId());
            UserBank userBank = this.userBankMapper.selectById(bankId);
            if (userBank == null) {
                return ServerResponse.createByErrorMsg("未绑定银行卡",request);
                return ServerResponse.createByErrorMsg("银行卡不存在",request);
            }
            if (user.getAccountType().intValue() == 1) {
                return ServerResponse.createByErrorMsg("模拟用户无法提取资金",request);
            }
            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);
            }
            int with_time_begin = siteSetting.getWithTimeBegin().intValue();
            int with_time_end = siteSetting.getWithTimeEnd().intValue();
            SiteProduct siteProduct = iSiteProductService.getProductSetting();
            if(siteProduct.getHolidayDisplay()){
                return ServerResponse.createByErrorMsg("周末或节假日不允许提款!",request);

            boolean b = getServerResponse();
            if (!b) {
                return ServerResponse.createByErrorMsg("提现失败,当前时间已停止提现", request);
            }
            if (!WithDrawUtils.checkIsWithTime(with_time_begin, with_time_end)) {
                return ServerResponse.createByErrorMsg("撤销失败了。提现时间为" + with_time_begin + "点 - " + with_time_end + "点之间的",request);
            }

            BigDecimal useAmt =  iUserAssetsServices.getAvailableBalance(accsetType,user.getId());
            BigDecimal tAmt = new BigDecimal(amt);
            if(useAmt.compareTo(tAmt)<0){
@@ -158,6 +179,16 @@

    }

    private boolean getServerResponse() {
        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()))) {
            return false;
        }
        return TimeUtil.isTradingHour(stockTimeSetting.getAmStartTime(), stockTimeSetting.getAmEndTime(), stockTimeSetting.getPmStartTime(), stockTimeSetting.getPmEndTime());
    }

    public ServerResponse<PageInfo> findUserWithList(String withStatus, HttpServletRequest request, int pageNum, int pageSize) {

@@ -217,7 +248,13 @@
            User user = this.userMapper.selectById(userWithdraw.getUserId());


            int updateUserCount = this.userMapper.updateById(user);
            UserAssets userAssets = iUserAssetsServices.assetsByTypeAndUserId("IN", user.getId());
            if (userAssets == null) {
                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) {

@@ -305,7 +342,9 @@
    }


    public ServerResponse updateState(Integer withId, Integer state, String authMsg) throws Exception {
    @Transactional
    public ServerResponse updateState(Integer withId, Integer state, String authMsg,
                                      HttpServletRequest request, HttpServletResponse response) throws Exception {
        UserWithdraw userWithdraw = this.userWithdrawMapper.selectByPrimaryKey(withId);
        SiteSetting siteSetting = siteSettingService.getSiteSetting();
        if (userWithdraw == null) {
@@ -318,14 +357,30 @@
        if (state.intValue() == 3 &&
                StringUtils.isBlank(authMsg)) {
            return ServerResponse.createByErrorMsg("失败信息必填");

        }
        User user = this.userMapper.selectById(userWithdraw.getUserId());
        if (user == null) {
            return ServerResponse.createByErrorMsg("用户不存在");
        }
        UserAssets userAssets = iUserAssetsServices.assetsByTypeAndUserId("IN", user.getId());
        if (userAssets == null) {
            return ServerResponse.createByErrorMsg("用户资金账户不存在");
        }
        if (state == 3) {
            User user = this.userMapper.selectById(userWithdraw.getUserId());
            if (user == null) {
                return ServerResponse.createByErrorMsg("用户不存在");
            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 = this.userMapper.updateById(user);
            int updateCount = userAssetsMapper.updateById(userAssets);
            if (updateCount > 0) {
                log.info("提现失败，返还用户资金成功！");
            } else {
@@ -333,139 +388,121 @@
                throw new Exception("修改用户资金出错，抛出异常");
            }
            userWithdraw.setWithMsg(authMsg);
        }else if(state == 1){
            // 发起第三方提现
            BigDecimal bgAmount = userWithdraw.getWithAmt();
            if(siteSetting.getWithdraw().equals("Top1")){
                withdrawMethod1(userWithdraw.getId()+"",bgAmount.toString(), userMapper.selectById(userWithdraw.getUserId()));
            } else if (siteSetting.getWithdraw().equals("Top2")) {
                withdrawMethod2(userWithdraw.getId()+"",bgAmount.toString(), userMapper.selectById(userWithdraw.getUserId()));
            }else if(siteSetting.getWithdraw().equals("Top3")){
                withdrawMethod3(userWithdraw.getId()+"",bgAmount.toString(), userMapper.selectById(userWithdraw.getUserId()));
            }else{
                withdrawMethod4(userWithdraw.getId()+"",bgAmount.toString(), userMapper.selectById(userWithdraw.getUserId()));
            }


        }
        userWithdraw.setWithStatus(state);
        userWithdraw.setTransTime(new Date());
        int updateCount = this.userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
        if (updateCount > 0) {
            userWithdraw.setWithStatus(2);
            userWithdraw.setTransTime(new Date());
            userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
            return ServerResponse.createBySuccessMsg("操作成功！");
        }
        return ServerResponse.createByErrorMsg("操作失败！");
        }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){//走代付
            String result = payForAnOrder(request, response, userWithdraw);
            if(StringUtils.isEmpty(result)){
                return ServerResponse.createByErrorMsg("代付打款失败！");
            }
            ObjectMapper objectMapper = new ObjectMapper();

            // 将 JSON 字符串转换为实体类对象
            TransferResponseBo transferResponseBo = objectMapper.readValue(result, TransferResponseBo.class);
            if(transferResponseBo.getRespCode().equals("FAIL")){
                log.error("代付下单失败："+result);
                return ServerResponse.createByErrorMsg("代付下单失败：",request);
            }
            TransferResponse transferResponse = new TransferResponse();
            transferResponse.setRespCode(transferResponseBo.getRespCode());
            transferResponse.setSignType(transferResponseBo.getSignType());
            transferResponse.setSign(transferResponseBo.getSign());
            transferResponse.setMerTransferId(transferResponseBo.getMerTransferId());
            transferResponse.setTransferAmount(new BigDecimal(transferResponseBo.getTransferAmount()));
            transferResponse.setApplyDate(transferResponseBo.getApplyDate());
            transferResponse.setTradeNo(transferResponseBo.getTradeNo());
            transferResponse.setTradeResult(0);
            transferResponse.setCallbackState(0);
            transferResponse.setUserId(user.getId());
            transferResponse.setCreatedAt(new Date());
            transferResponse.setWithId(withId);
            transferResponseService.save(transferResponse);

            userAssets.setFreezeMoney(userAssets.getFreezeMoney().subtract(userWithdraw.getWithAmt()));
            userAssetsMapper.updateById(userAssets);
            userWithdraw.setWithStatus(4);
            userWithdraw.setTransTime(new Date());
            int updateCount = this.userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
            if (updateCount > 0) {
                return ServerResponse.createBySuccessMsg("操作成功！");
            }
        }
        return ServerResponse.createBySuccessMsg("操作失败！");
    }

    public String payForAnOrder(HttpServletRequest request, HttpServletResponse response,UserWithdraw userWithdraw) throws IOException {
        request.setCharacterEncoding("UTF-8");
        Map<String, String> reqMap = new HashMap<String, String>();
        //申请时间 时间格式：yyyy-MM-dd HH:mm:ss
        reqMap.put("apply_date", getOrderTime());
        //收款银行代码   详见附件银行编码或商户后台银行代码表
        reqMap.put("bank_code", "IDPT0001");
        //商户代码 平台分配唯一
        reqMap.put("mch_id", "100789033");
        // 商家转账订单号 保证每笔订单唯一
        reqMap.put("mch_transferId", generatePayOrderId());
        //收款银行账号   银行账号(巴西PIX代付填对应类型的PIX账号)
        reqMap.put("receive_account", userWithdraw.getBankNo());
        //收款银行户名
        reqMap.put("receive_name", userWithdraw.getBankName());
        //转账金额 整数，以元为单位
        reqMap.put("transfer_amount", userWithdraw.getWithAmt().toString());
        //备注
        reqMap.put("remark", userWithdraw.getBankAddress());
        //异步通知地址
        reqMap.put("back_url", "https://api.durocaspitall.com/user/noticePayment.do");
        String signStr = SignUtil.sortData(reqMap);
        //签名方式 固定值MD5，不参与签名
        reqMap.put("sign_type", "MD5");

        String reqUrl = "https://api.watchglbpay.com/pay/transfer";
        String merchant_key = "TKFMXNSNKDP0RUFEKV44SW411VUNDZLG";

    public int withdrawMethod1(String ordersn, String payAmt, User user ) {
        UserBank userBank =  userBankMapper.findUserBankByUserId(user.getId());
        Map<String,String> map = new HashedMap();
        map.put("mch_id",PayUtil.MCH_ID_TOP1);
        map.put("back_url","http://www.jumptalk.net:8091/api/pay/withdrawNotify.do");
        map.put("mch_transferId",ordersn);
        map.put("transfer_amount",payAmt);
        map.put("apply_date", DateTimeUtil.getCurrentDate(STANDARD_FORMAT));
        map.put("bank_code",userBank.getBankImg());
        map.put("receive_name",user.getRealName());
        map.put("receive_account",userBank.getBankNo());
        map.put("remark",userBank.getBankAddress());
        String signStr = SignUtil.sortData(map);
        map.put("sign_type","MD5");
        try {
            map.put("sign", SignAPI.sign(signStr,PayUtil.DF_TOKEN_TOP1));
            String reponse = HttpClientUtil.doPost(PayUtil.PAY_TRANSFER_ORDER_TOP1, map, "utf-8");
            com.alibaba.fastjson.JSONObject  object = com.alibaba.fastjson.JSONObject.parseObject(reponse);
        }catch (Exception e){
            e.printStackTrace();
        }
        return -1;
        String sign = SignAPI.sign(signStr, merchant_key);

        reqMap.put("sign", sign);

        System.out.println("reqMap：" + reqMap.toString().length() + " --> " + reqMap.toString());
        System.out.println("签名参数排序：" + signStr.length() + " --> " + signStr);
        System.out.println("sign值：" + sign.length() + " --> " + sign);

        String result = HttpClientUtil.doPost(reqUrl, reqMap, "utf-8");
        System.out.println("result值：" + result);
        return result;
    }

    public int withdrawMethod2(String ordersn, String payAmt, User user ) {
        UserBank userBank =  userBankMapper.findUserBankByUserId(user.getId());
        Map<String,String> map = new HashedMap();
        map.put("mch_id",PayUtil.MCH_ID_TOP2);
        map.put("back_url","http://www.jumptalk.net:8091/api/pay/withdrawNotify2.do");
        map.put("mch_transferId",ordersn);
        map.put("transfer_amount",payAmt);
        map.put("apply_date", DateTimeUtil.getCurrentDate(STANDARD_FORMAT));
        map.put("bank_code",userBank.getBankImg());
        map.put("receive_name",user.getRealName());
        map.put("receive_account",userBank.getBankNo());
        map.put("remark",userBank.getBankAddress());
        String signStr = SignUtil.sortData(map);
        log.error("加密前排序字符 {}", signStr);
        map.put("sign_type","MD5");
        try {
            map.put("sign", SignAPI.sign(signStr,PayUtil.DF_TOKEN_TOP2));
            log.info("支付通道2 代付的参数 {}",new Gson().toJson(map));
            String reponse = HttpClientUtil.doPost(PayUtil.PAY_TRANSFER_ORDER_TOP2, map, "utf-8");
            log.info("支付通道2 审核返回的 {}",reponse);
            com.alibaba.fastjson.JSONObject  object = com.alibaba.fastjson.JSONObject.parseObject(reponse);
        }catch (Exception e){
            e.printStackTrace();
        }
        return -1;
    public String generatePayOrderId() {
        // 获取当前时间戳（毫秒）
        long timestamp = System.currentTimeMillis();

        // 生成一个随机的UUID并截取前8位
        String randomUUID = UUID.randomUUID().toString().replace("-", "").substring(0, 8);

        // 将时间戳和随机UUID结合生成订单号
        return timestamp + randomUUID;
    }

    public static String getOrderTime() {
        // 获取当前时间
        LocalDateTime now = LocalDateTime.now();

    public int withdrawMethod3(String ordersn, String payAmt, User user ) {
        UserBank userBank =  userBankMapper.findUserBankByUserId(user.getId());
        Map<String,String> map = new HashedMap();
        map.put("mch_id",PayUtil.MCH_ID_TOP3);
        map.put("back_url","http://www.jumptalk.net:8091/api/pay/withdrawNotify3.do");
        map.put("mch_transferId",ordersn);
        map.put("transfer_amount",payAmt);
        map.put("apply_date", DateTimeUtil.getCurrentDate(STANDARD_FORMAT));
        map.put("bank_code",userBank.getBankImg());
        map.put("receive_name",user.getRealName());
        map.put("receive_account",userBank.getBankNo());
        map.put("remark",userBank.getBankAddress());
        String signStr = SignUtil.sortData(map);
        log.error("加密前排序字符 {}", signStr);
        map.put("sign_type","MD5");
        try {
            map.put("sign", SignAPI.sign(signStr,PayUtil.DF_TOKEN_TOP3));
            log.info("支付通道3 代付的参数 {}",new Gson().toJson(map));
            String reponse = HttpClientUtil.doPost(PayUtil.PAY_TRANSFER_ORDER_TOP3, map, "utf-8");
            log.info("支付通道3 审核返回的 {}",reponse);
        }catch (Exception e){
            e.printStackTrace();
        }
        return -1;
        // 定义输出格式
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");

        // 格式化当前时间
        return now.format(formatter);
    }


    public int withdrawMethod4(String ordersn, String payAmt, User user ) {
        UserBank userBank =  userBankMapper.findUserBankByUserId(user.getId());
        Map<String,String> map = new HashedMap();
        map.put("mch_id",PayUtil.MCH_ID_TOP4);
        map.put("back_url","http://www.jumptalk.net:8091/api/pay/withdrawNotify4.do");
        map.put("mch_transferId",ordersn);
        map.put("transfer_amount",payAmt);
        map.put("apply_date", DateTimeUtil.getCurrentDate(STANDARD_FORMAT));
        map.put("bank_code",userBank.getBankImg());
        map.put("receive_name",user.getRealName());
        map.put("receive_account",userBank.getBankNo());
        map.put("remark",userBank.getBankAddress());
        String signStr = SignUtil.sortData(map);
        map.put("sign_type","MD5");
        try {
            map.put("sign", SignAPI.sign(signStr,PayUtil.DF_TOKEN_TOP1));
            String reponse = HttpClientUtil.doPost(PayUtil.PAY_TRANSFER_ORDER_TOP1, map, "utf-8");
            log.info("支付通道4 审核返回的 {}",reponse);
        }catch (Exception e){
            e.printStackTrace();
        }
        return -1;
    }





    public int deleteByUserId(Integer userId) {
        return this.userWithdrawMapper.deleteByUserId(userId);
@@ -499,5 +536,80 @@

    }

    @Override
    public void noticePayment(TradeResultVO vo, HttpServletResponse response) throws IOException {
        log.info("代付回调信息："+vo.toString());
        synchronized (vo.getTradeNo()){
            TransferResponse transferResponse = transferResponseService.getOne(new LambdaQueryWrapper<>(TransferResponse.class)
                    .eq(TransferResponse::getMerTransferId, vo.getMerTransferId())
                    .eq(TransferResponse::getTradeNo, vo.getTradeNo())
                    .eq(TransferResponse::getTradeResult, 0)
                    .eq(TransferResponse::getCallbackState, 0)
            );

            if(ObjectUtils.isNotEmpty(transferResponse)){
                UserAssets userAssets = iUserAssetsServices.assetsByTypeAndUserId("IN", transferResponse.getUserId());
                UserWithdraw userWithdraw = this.userWithdrawMapper.selectByPrimaryKey(transferResponse.getWithId());


                if (transferResponse.getRespCode().equals("SUCCESS")) {
                    transferResponse.setTradeResult(1);
                    transferResponse.setCallbackState(1);
                    transferResponseService.updateById(transferResponse);

                    userWithdraw.setWithStatus(1);
                    userWithdraw.setTransTime(new Date());
                    userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);

                    log.info("代付回调----成功");
                    PrintWriter pw = response.getWriter();
                    pw.print("success");
                    pw.flush();
                    pw.close(); // 验签成功，响应SUCCESS
                    return;
                } else {
                    if (userAssets == null) {
                        log.error("用户资金账户不存在！");
                        PrintWriter pw = response.getWriter();
                        pw.print("Signature Error");
                        pw.flush();
                        pw.close();
                        return;
                    }
                    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("返还用户资金出错，抛出异常");
                    }
                    userWithdraw.setWithMsg("代付验证失败");
                    userWithdraw.setWithStatus(2);
                    userWithdraw.setTransTime(new Date());
                    userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw);
                    transferResponse.setTradeResult(2);
                    transferResponse.setCallbackState(2);
                    transferResponseService.updateById(transferResponse);
                    PrintWriter pw = response.getWriter();
                    pw.print("Signature Error");
                    pw.flush();
                    pw.close();
                }
            }
        }
    }

}