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<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) {
|
|
PageHelper.startPage(pageNum, pageSize);
|
|
|
User user = this.iUserService.getCurrentUser(request);
|
|
|
List<UserWithdraw> 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<UserWithdraw> userWithdraws = this.userWithdrawMapper.listByAgent(searchId, realName, state);
|
|
|
PageInfo pageInfo = new PageInfo(userWithdraws);
|
|
|
return ServerResponse.createBySuccess(pageInfo);
|
|
}
|
|
|
public ServerResponse<PageInfo> listByAdmin(Integer agentId, Integer userId, String realName, Integer state, String beginTime, String endTime, HttpServletRequest request, int pageNum, int pageSize) {
|
|
PageHelper.startPage(pageNum, pageSize);
|
|
|
List<UserWithdraw> userWithdraws = this.userWithdrawMapper.listByAdmin(agentId, userId, realName, state, beginTime, endTime);
|
for (int i = 0; i <userWithdraws.size() ; i++) {
|
UserWithdraw userRecharge = userWithdraws.get(i);
|
User user = userMapper.selectById(userRecharge.getUserId());
|
if(user != null){
|
userRecharge.setUserPhone(user.getPhone());
|
}
|
}
|
|
|
PageInfo pageInfo = new PageInfo(userWithdraws);
|
|
|
return ServerResponse.createBySuccess(pageInfo);
|
|
}
|
|
|
@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("用户不存在");
|
}
|
UserAssets userAssets = iUserAssetsServices.assetsByTypeAndUserId("IN", user.getId());
|
if (userAssets == null) {
|
return ServerResponse.createByErrorMsg("用户资金账户不存在");
|
}
|
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("请选择对应的操作！");
|
}
|
}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<UserWithdraw> 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<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("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;
|
}
|
}
|
