package com.mzl.flower.service.impl.wallet;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.mzl.flower.config.PyamentV3Configurer;
import com.mzl.flower.config.exception.ValidationException;
import com.mzl.flower.config.security.SecurityUtils;
import com.mzl.flower.constant.Constants;
import com.mzl.flower.constant.LockConstants;
import com.mzl.flower.dto.request.payment.TransferDetailReqDTO;
import com.mzl.flower.dto.request.payment.TransferReqDTO;
import com.mzl.flower.dto.request.wallet.CreateWalletWithdrawRecordDTO;
import com.mzl.flower.dto.request.wallet.QueryWalletWithdrawDTO;
import com.mzl.flower.dto.request.wallet.WalletWithdrawRecordDTO;
import com.mzl.flower.dto.response.supplier.SupplierDTO;
import com.mzl.flower.dto.response.wallet.WalletWithdrawRecordVO;
import com.mzl.flower.entity.supplier.Supplier;
import com.mzl.flower.entity.system.UserWechat;
import com.mzl.flower.entity.wallet.WalletBillRecordDO;
import com.mzl.flower.entity.wallet.WalletDO;
import com.mzl.flower.entity.wallet.WalletWithdrawRecordDO;
import com.mzl.flower.mapper.supplier.SupplierMapper;
import com.mzl.flower.mapper.system.UserWechatMapper;
import com.mzl.flower.mapper.wallet.WalletBillRecordMapper;
import com.mzl.flower.mapper.wallet.WalletMapper;
import com.mzl.flower.mapper.wallet.WalletWithdrawRecordMapper;
import com.mzl.flower.service.payment.UserPaymentV3Service;
import com.mzl.flower.service.supplier.SupplierService;
import com.mzl.flower.service.wallet.WalletBillRecordService;
import com.mzl.flower.service.wallet.WalletService;
import com.mzl.flower.service.wallet.WalletWithdrawRecordService;
import com.mzl.flower.utils.UUIDGenerator;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.redisson.api.RLock;
import org.redisson.api.RedissonClient;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.ObjectUtils;
import org.springframework.util.StringUtils;
import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.TimeUnit;
/**
*
* 服务实现类
*
*
* @author @TaoJie
* @since 2024-10-22
*/
@Slf4j
@Service
@Transactional
@RequiredArgsConstructor
public class WalletWithdrawRecordServiceImpl extends ServiceImpl implements WalletWithdrawRecordService {
private final WalletWithdrawRecordMapper walletWithdrawRecordMapper;
private final WalletService walletService;
private final SupplierService supplierService;
private final SupplierMapper supplierMapper;
private final UserWechatMapper wechatMapper;
private final UserPaymentV3Service paymentV3Service;
private final WalletBillRecordMapper walletBillRecordMapper;
private final WalletBillRecordService walletBillRecordService;
private final WalletMapper walletMapper;
@Autowired
RedissonClient redissonClient;
@Transactional
@Override
public boolean create(CreateWalletWithdrawRecordDTO dto) {
SupplierDTO supplierDTO = supplierService.getCurrentSupplier();
if (null == supplierDTO) {
throw new ValidationException("供应商不能为空");
}
WalletDO walletDO = walletService.getCurrentSupplier();
if (null == walletDO) {
throw new ValidationException("钱包不能为空");
}
// 查看钱包的金额是不是大于要提现的金额
if (null != walletDO.getWithdrawableAmount() && null != dto.getAmount() && walletDO.getWithdrawableAmount().compareTo(dto.getAmount()) < 0) {
throw new ValidationException("钱包金额不足");
}
RLock lock = redissonClient.getLock(String.format(LockConstants.WALLET_ID_KEY, walletDO.getId()));
// 获取锁,最多等待 10 秒,锁自动释放时间 30 秒
try {
if (lock.tryLock(10, 30, TimeUnit.SECONDS)) {
try {
// 加锁了之后需要二次查询,防止未加锁之前 someone else 已经修改了
walletDO = walletService.getCurrentSupplier();
if (null == walletDO) {
throw new ValidationException("钱包不能为空");
}
// 查看钱包的金额是不是大于要提现的金额
if (null != walletDO.getWithdrawableAmount() && null != dto.getAmount() && walletDO.getWithdrawableAmount().compareTo(dto.getAmount()) < 0) {
throw new ValidationException("钱包金额不足");
}
// 1.新增一条余额提现记录
WalletWithdrawRecordDO withdrawRecordDO = new WalletWithdrawRecordDO();
//原金额
withdrawRecordDO.setOriginalAmount(walletDO.getWithdrawableAmount());
// 变动金额
withdrawRecordDO.setChangeAmount(dto.getAmount());
// 余额
withdrawRecordDO.setBalance(walletDO.getWithdrawableAmount().subtract(dto.getAmount()));
withdrawRecordDO.setAmount(dto.getAmount());
withdrawRecordDO.setSupplierId(supplierDTO.getId());
withdrawRecordDO.setWithdrawState(Constants.BILL_WITHDRAW_TYPE.start.name());
withdrawRecordDO.setMethod(Constants.WALLET_WITHDRAW_METHOD.WEIXIN.name());
withdrawRecordDO.setWithdrawType(Constants.WALLET_WITHDRAW_TYPE.BALANCE.name());
// 待审核状态
withdrawRecordDO.setApproveState(Constants.WALLET_APPROVE_STATE.WAITING.name());
withdrawRecordDO.create(SecurityUtils.getUserId());
// 保存余额提现记录
save(withdrawRecordDO);
// 2.新增一条账单明细
WalletBillRecordDO walletBillRecordDO=new WalletBillRecordDO();
walletBillRecordDO.setId(UUIDGenerator.getUUID());
walletBillRecordDO.setSupplierId(supplierDTO.getId());
walletBillRecordDO.setWalletId(walletDO.getId());
walletBillRecordDO.setType(Constants.BILL_CHANGE_TYPE.withdraw.name());
// 发起提现
walletBillRecordDO.setWithdrawType(Constants.BILL_WITHDRAW_TYPE.start.name());
walletBillRecordDO.setMethod(Constants.BILL_CHANGE_METHOD.reduce.name());
walletBillRecordDO.setOriginalAmount(walletDO.getWithdrawableAmount());
walletBillRecordDO.setChangeAmount(dto.getAmount());
walletBillRecordDO.setBalance(walletDO.getWithdrawableAmount().subtract(dto.getAmount()));
walletBillRecordDO.create(SecurityUtils.getUserId());
walletBillRecordDO.setWithdrawRecordId(withdrawRecordDO.getId());
walletBillRecordDO.setRemark("提现中");
// 保存账单明细
walletBillRecordService.save(walletBillRecordDO);
// 3. 钱包更新
// 钱包可提现的钱等于当前钱包可提现的钱-提现的钱
walletDO.setWithdrawableAmount(walletDO.getWithdrawableAmount().subtract(dto.getAmount()));
// 提现中的钱等于原有可提现的钱+提现的钱
walletDO.setWithdrawingAmount(walletDO.getWithdrawingAmount().add(dto.getAmount()));
walletDO.update(SecurityUtils.getUserId());
// 更新钱包
return walletService.updateById(walletDO);
} finally {
lock.unlock();
}
}
} catch (InterruptedException e) {
throw new RuntimeException(e);
}
return false;
}
@Override
public Page queryPage(QueryWalletWithdrawDTO queryWalletDTO, Page page) {
try {
if (!StringUtils.isEmpty(queryWalletDTO.getSupplierId())) {
Long supplierId = Long.parseLong(queryWalletDTO.getSupplierId());
}
} catch (Exception e) {
throw new ValidationException("供应商ID格式不正确");
}
List list = walletWithdrawRecordMapper.queryPage(queryWalletDTO, page);
page.setRecords(list);
return page;
}
@Override
public void updateWallet(WalletWithdrawRecordDTO walletWithdrawRecordDTO) {
WalletWithdrawRecordDO withdrawRecordDO = walletWithdrawRecordMapper.selectById(walletWithdrawRecordDTO.getId());
final String approveState = withdrawRecordDO.getApproveState();
if (withdrawRecordDO == null) {
throw new ValidationException("提现记录信息不存在");
}
if (StringUtils.isEmpty(walletWithdrawRecordDTO.getApproveState())) {
throw new ValidationException("审批状态不能为空");
}
if (Constants.WALLET_APPROVE_STATE.REJECT.name().equals(walletWithdrawRecordDTO.getApproveState())) {
if (StringUtils.isEmpty(walletWithdrawRecordDTO.getRejectReason())) {
throw new ValidationException("不通过理由不能为空");
}
}
BeanUtils.copyProperties(walletWithdrawRecordDTO, withdrawRecordDO);
withdrawRecordDO.update(SecurityUtils.getUserId());
withdrawRecordDO.setApproveState(walletWithdrawRecordDTO.getApproveState());
withdrawRecordDO.setApproveBy(withdrawRecordDO.getUpdateBy());
withdrawRecordDO.setApproveTime(LocalDateTime.now());
if(Constants.WALLET_APPROVE_STATE.REJECT.name().equals(walletWithdrawRecordDTO.getApproveState())){
//如果拒绝直接提现失败
withdrawRecordDO.setWithdrawState(Constants.BILL_WITHDRAW_TYPE.fail.name());
}
walletWithdrawRecordMapper.updateById(withdrawRecordDO);
//审批通过之后写转账信息
if (Constants.WALLET_APPROVE_STATE.APPROVE.name().equals(walletWithdrawRecordDTO.getApproveState())) {
RLock recordLock = redissonClient.getLock(String.format(LockConstants.WALLET_WITHDRAW_RECORD_KEY, walletWithdrawRecordDTO.getId()));
try {
if (recordLock.tryLock(10, 30, TimeUnit.SECONDS)) {
try {
if(!approveState.equals(Constants.WALLET_APPROVE_STATE.WAITING.name())){
String msg = "重复通过";
throw new ValidationException(msg);
}
Supplier s = supplierMapper.selectById(withdrawRecordDO.getSupplierId());
WalletDO walletDO = walletService.getOrCreateBySupplierId(s.getId());
RLock lock = redissonClient.getLock(String.format(LockConstants.WALLET_ID_KEY, walletDO.getId()));
try {
if (lock.tryLock(10, 30, TimeUnit.SECONDS)) {
try {
if (!ObjectUtils.isEmpty(walletDO)) {
String name = "";
name = "供应商" + s.getName();
UserWechat wechat = wechatMapper.selectOne(new QueryWrapper().eq("user_id", s.getUserId()));
if (wechat == null) {
String msg = name + "未绑定账号无法提现";
log.error(msg);
throw new ValidationException(msg);
}
LocalDateTime now = LocalDateTime.now();
String day = format(now, "yyyy-MM-dd");
String remarks = name + "钱包提现";
String appId = PyamentV3Configurer.supplier_app_id;
TransferReqDTO transferReqDTO = new TransferReqDTO();
transferReqDTO.setId(UUIDGenerator.getUUID());
transferReqDTO.setAppId(appId);
transferReqDTO.setName(day + "日" + remarks);
transferReqDTO.setRemarks(remarks);
//保存账单信息
// WalletBillRecordDO walletBillRecordDO = new WalletBillRecordDO();
// walletBillRecordDO.setSupplierId(s.getId());
// walletBillRecordDO.setType(Constants.BILL_CHANGE_TYPE.withdraw.name());
// walletBillRecordDO.setWithdrawType(Constants.BILL_WITHDRAW_TYPE.success.name());
// walletBillRecordDO.setMethod(Constants.BILL_CHANGE_METHOD.reduce.name());
// walletBillRecordDO.setTransferId(transferReqDTO.getId());
// walletBillRecordDO.setWithdrawRecordId(withdrawRecordDO.getId());
// walletBillRecordDO.create();
// walletBillRecordDO.setOriginalAmount(walletDO.getWithdrawableAmount());
// walletBillRecordDO.setChangeAmount(BigDecimal.ZERO);
// walletBillRecordDO.setBalance(walletDO.getWithdrawableAmount());
WalletBillRecordDO walletBillRecordDO = walletBillRecordService.getBillRecordByWithdrawRecordId(withdrawRecordDO.getId());
if(ObjectUtils.isEmpty(walletBillRecordDO)){
throw new ValidationException("提现没有对应的账单信息");
}
walletBillRecordDO.setTransferId(transferReqDTO.getId());
//提现金额
BigDecimal withdrawAmount = withdrawRecordDO.getAmount();
if (withdrawAmount.doubleValue() > 0) {//结算金额>0时才去转账
TransferDetailReqDTO dr = new TransferDetailReqDTO();
dr.setId(UUIDGenerator.getUUID());
dr.setAmount(withdrawAmount.multiply(new BigDecimal(100)).longValue());
dr.setOpenId(wechat.getOpenId());
dr.setRemarks(remarks);
if (withdrawAmount.doubleValue() >= 2000) {
dr.setUserName(wechat.getRealName());
}
List details = new ArrayList<>();
details.add(dr);
walletBillRecordDO.setTransferDetailId(dr.getId());
log.info("发起转账");
transferReqDTO.setDetails(details);
try {
//发起转账
paymentV3Service.doBatchTransfer(transferReqDTO, SecurityUtils.getUserId());
} catch (Exception e) {
throw new ValidationException(e.getMessage());
}
}
//记录转账状态,定时任务定时获取状态并更新钱包交易记录表信息
walletBillRecordDO.setRemark("微信商户转账中");
walletBillRecordDO.setActualTransferAmount(withdrawAmount);
walletBillRecordDO.setApproveBy(SecurityUtils.getUserId());
walletBillRecordDO.setApproveTime(LocalDateTime.now());
walletBillRecordMapper.updateById(walletBillRecordDO);
//不需要更新结算单了,此时提现的金额和计算单上的金额不一致
}
} finally {
lock.unlock();
}
}
} catch (InterruptedException e) {
throw new RuntimeException(e);
}
} finally {
recordLock.unlock();
}
}
} catch (InterruptedException e) {
throw new RuntimeException(e);
}
}
if (Constants.WALLET_APPROVE_STATE.REJECT.name().equals(walletWithdrawRecordDTO.getApproveState())) {
//更新钱包
Supplier s = supplierMapper.selectById(withdrawRecordDO.getSupplierId());
WalletDO walletDO = walletService.getOrCreateBySupplierId(s.getId());
RLock lock = redissonClient.getLock(String.format(LockConstants.WALLET_ID_KEY, walletDO.getId()));
try {
if (lock.tryLock(10, 30, TimeUnit.SECONDS)) {
try {
if (!ObjectUtils.isEmpty(walletDO)) {
// 2.新增一条账单明细
WalletBillRecordDO walletBillRecordDO = new WalletBillRecordDO();
walletBillRecordDO.setId(UUIDGenerator.getUUID());
walletBillRecordDO.setSupplierId(walletDO.getSupplierId());
walletBillRecordDO.setWalletId(walletDO.getId());
walletBillRecordDO.setType(Constants.BILL_CHANGE_TYPE.withdraw.name());
// 发起提现
walletBillRecordDO.setWithdrawType(Constants.BILL_WITHDRAW_TYPE.fail.name());
walletBillRecordDO.setMethod(Constants.BILL_CHANGE_METHOD.add.name());
walletBillRecordDO.setOriginalAmount(walletDO.getWithdrawableAmount());
walletBillRecordDO.setChangeAmount(withdrawRecordDO.getAmount());
walletBillRecordDO.setBalance(walletDO.getWithdrawableAmount().add(withdrawRecordDO.getAmount()));
walletBillRecordDO.create(SecurityUtils.getUserId());
walletBillRecordDO.setId(UUIDGenerator.getUUID());
walletBillRecordDO.setRemark("平台审核拒绝,余额返还钱包");
walletBillRecordDO.setApproveBy("sys");
walletBillRecordDO.setApproveTime(LocalDateTime.now());
// 保存账单明细
walletBillRecordService.save(walletBillRecordDO);
//提现中金额:审核失败体现中金额扣减
walletDO.setWithdrawingAmount(walletDO.getWithdrawingAmount().subtract(withdrawRecordDO.getAmount()));
//可提现金额:审核失败可提现金额增加
walletDO.setWithdrawableAmount(walletDO.getWithdrawableAmount().add(withdrawRecordDO.getAmount()));
walletMapper.updateById(walletDO);
}
} finally {
lock.unlock();
}
}
} catch (InterruptedException e) {
throw new RuntimeException(e);
}
}
}
public String format(LocalDateTime dateTime, String format) {
if (dateTime == null || format == null) {
return null;
}
DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern(format).withZone(ZoneId.of("Asia/Shanghai"));
return dateTimeFormatter.format(dateTime);
}
}