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.EUserAssets; import com.nq.pojo.*; import com.nq.service.*; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.nq.common.ServerResponse; import com.nq.utils.*; import com.nq.utils.http.HttpClientUtil; 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.TimeUtil; import org.apache.commons.lang3.ObjectUtils; import org.apache.commons.lang3.StringUtils; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import org.springframework.stereotype.Service; @Service("iUserWithdrawService") public class UserWithdrawServiceImpl implements IUserWithdrawService { private static final Logger log = LoggerFactory.getLogger(UserWithdrawServiceImpl.class); @Autowired UserWithdrawMapper userWithdrawMapper; @Autowired IUserService iUserService; @Resource UserMapper userMapper; @Resource IUserAssetsServices iUserAssetsServices; @Autowired IAgentUserService iAgentUserService; @Autowired AgentUserMapper agentUserMapper; @Autowired IUserPositionService iUserPositionService; @Autowired IUserBankService iUserBankService; @Autowired ISiteSettingService iSiteSettingService; @Autowired ISiteProductService iSiteProductService; @Autowired UserBankMapper userBankMapper; @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,String bankId,HttpServletRequest request) throws Exception { if (StringUtils.isBlank(amt)) { return ServerResponse.createByErrorMsg("The parameter cannot be null"); } User user = this.iUserService.getCurrentRefreshUser(request); String w = user.getWithPwd(); if (w == null) { w = ""; } if (with_Pwd == null) { with_Pwd = ""; } if (w.equals(with_Pwd)) { if (user.getIsLogin().intValue() == 1) { return ServerResponse.createByErrorMsg("用户被锁定",request); } if (user.getIsActive() != 2) { return ServerResponse.createByErrorMsg("未实名认证",request); } UserBank userBank = this.userBankMapper.selectById(bankId); if (userBank == null) { 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("最小提现金额:" + siteSetting.getWithMinAmt(),request); } boolean b = getServerResponse(); if (!b) { return ServerResponse.createByErrorMsg("提现失败,当前时间已停止提现", request); } BigDecimal useAmt = iUserAssetsServices.getAvailableBalance(accsetType,user.getId()); BigDecimal tAmt = new BigDecimal(amt); if(useAmt.compareTo(tAmt)<0){ return ServerResponse.createByErrorMsg("余额不足",request); } iUserAssetsServices.availablebalanceChange(accsetType,user.getId(), EUserAssets.WITHDRAW,tAmt.negate(),"",""); UserWithdraw userWithdraw = new UserWithdraw(); userWithdraw.setUserId(user.getId()); userWithdraw.setNickName(user.getRealName()); userWithdraw.setAgentId(user.getAgentId()); userWithdraw.setWithAmt(new BigDecimal(amt)); userWithdraw.setApplyTime(new Date()); userWithdraw.setWithName(user.getRealName()); userWithdraw.setBankNo(userBank.getBankNo()); userWithdraw.setBankName(userBank.getBankName()); userWithdraw.setBankAddress(userBank.getBankAddress()); userWithdraw.setWithStatus(Integer.valueOf(0)); BigDecimal withfee = siteSetting.getWithFeePercent().multiply(new BigDecimal(amt)).add(new BigDecimal(siteSetting.getWithFeeSingle().intValue())); userWithdraw.setWithFee(withfee); int insertCount = this.userWithdrawMapper.insert(userWithdraw); if (insertCount > 0) { return ServerResponse.createBySuccessMsg("提现成功",request); } log.error("保存提现记录失败"); throw new Exception("用户提现,保存提现记录失败"); } else { return ServerResponse.createByErrorMsg("提现密码不正确!",request); } } private boolean getServerResponse() { StockTimeSetting stockTimeSetting = stockTimeSettingMapper.selectOne(new QueryWrapper().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 findUserWithList(String withStatus, HttpServletRequest request, int pageNum, int pageSize) { PageHelper.startPage(pageNum, pageSize); User user = this.iUserService.getCurrentUser(request); List userWithdraws = this.userWithdrawMapper.findUserWithList(user.getId(), withStatus); PageInfo pageInfo = new PageInfo(userWithdraws); return ServerResponse.createBySuccess(pageInfo); } public ServerResponse userCancel(Integer withId) { if (withId == null) { return ServerResponse.createByErrorMsg("id不能为空"); } UserWithdraw userWithdraw = this.userWithdrawMapper.selectByPrimaryKey(withId); if (userWithdraw == null) { return ServerResponse.createByErrorMsg("订单不存在"); } if (0 != userWithdraw.getWithStatus().intValue()) { return ServerResponse.createByErrorMsg("当前订单不能取消"); } userWithdraw.setWithStatus(Integer.valueOf(3)); userWithdraw.setWithMsg("The user cancels the withdrawal"); int updateCount = this.userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw); if (updateCount > 0) { log.info("修改用户提现订单 {} 状态成功", withId); User user = this.userMapper.selectById(userWithdraw.getUserId()); 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) { return ServerResponse.createBySuccessMsg("Cancel Success"); } return ServerResponse.createByErrorMsg("取消失败"); } log.info("修改用户提现订单 {} 状态失败", withId); return ServerResponse.createByErrorMsg("取消失败"); } public ServerResponse listByAgent(Integer agentId, String realName, Integer state, HttpServletRequest request, int pageNum, int pageSize) { AgentUser currentAgent = this.iAgentUserService.getCurrentAgent(request); if (agentId != null) { AgentUser agentUser = this.agentUserMapper.selectByPrimaryKey(agentId); if (agentUser.getParentId() != currentAgent.getId()) { return ServerResponse.createByErrorMsg("不能查询非下级代理记录"); } } Integer searchId = null; if (agentId == null) { searchId = currentAgent.getId(); } else { searchId = agentId; } PageHelper.startPage(pageNum, pageSize); List userWithdraws = this.userWithdrawMapper.listByAgent(searchId, realName, state); PageInfo pageInfo = new PageInfo(userWithdraws); return ServerResponse.createBySuccess(pageInfo); } public ServerResponse listByAdmin(Integer agentId, Integer userId, String realName, Integer state, String beginTime, String endTime, HttpServletRequest request, int pageNum, int pageSize) { PageHelper.startPage(pageNum, pageSize); List userWithdraws = this.userWithdrawMapper.listByAdmin(agentId, userId, realName, state, beginTime, endTime); for (int i = 0; i 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("请选择对应的操作!"); } }catch (Exception e){ log.info("提现失败:"+e.getMessage()); throw e; } return ServerResponse.createBySuccessMsg("操作失败!"); } public int deleteByUserId(Integer userId) { return this.userWithdrawMapper.deleteByUserId(userId); } public BigDecimal CountSpWithSumAmtByState(Integer withState) { return this.userWithdrawMapper.CountSpWithSumAmtByState(withState); } public BigDecimal CountSpWithSumAmTodaytByState(Integer withState) { return this.userWithdrawMapper.CountSpWithSumAmTodaytByState(withState); } public ServerResponse deleteWithdraw(Integer withdrawId) { if (withdrawId == null) { return ServerResponse.createByErrorMsg("删除id不能为空"); } int updateCount = this.userWithdrawMapper.deleteByPrimaryKey(withdrawId); if (updateCount > 0) { return ServerResponse.createBySuccessMsg("删除成功"); } return ServerResponse.createByErrorMsg("删除失败"); } //导出用户提现 @Override public List exportByAdmin(Integer agentId, Integer userId, String realName, Integer state, String beginTime, String endTime, HttpServletRequest request) { return this.userWithdrawMapper.listByAdmin(agentId, userId, realName, state, beginTime, endTime); } /** * 代付接口调用 */ 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 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("fail:" + payoutResponse.getMessage()); userWithdraw.setTransTime(new Date()); userWithdrawMapper.updateByPrimaryKeySelective(userWithdraw); return ServerResponse.createByErrorMsg("fail:" + payoutResponse.getMessage(),request); } // 保存代付记录 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; } }