package com.by4cloud.platformx.business.service.impl;
|
|
import cn.hutool.core.collection.CollUtil;
|
import cn.hutool.core.date.DatePattern;
|
import cn.hutool.core.date.DateUtil;
|
import cn.hutool.core.util.ObjUtil;
|
import cn.hutool.core.util.StrUtil;
|
import cn.hutool.http.HttpUtil;
|
import com.alibaba.fastjson.JSON;
|
import com.alibaba.fastjson.JSONArray;
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.by4cloud.platformx.admin.api.entity.SysDept;
|
import com.by4cloud.platformx.admin.api.feign.RemoteDeptService;
|
import com.by4cloud.platformx.business.dto.BankStatementUpdateDTO;
|
import com.by4cloud.platformx.business.dto.PaymentConfirmAddDTO;
|
import com.by4cloud.platformx.business.entity.*;
|
import com.by4cloud.platformx.business.mapper.BankStatementItemMapper;
|
import com.by4cloud.platformx.business.mapper.BankStatementMapper;
|
import com.by4cloud.platformx.business.mapper.BusinessCustomerMapper;
|
import com.by4cloud.platformx.business.mapper.ContractMapper;
|
import com.by4cloud.platformx.business.service.BankStatementService;
|
import com.by4cloud.platformx.business.service.PaymentConfirmService;
|
import com.by4cloud.platformx.business.vo.StatementContractVo;
|
import com.by4cloud.platformx.common.core.util.R;
|
import com.by4cloud.platformx.common.security.util.SecurityUtils;
|
import com.github.yulichang.wrapper.MPJLambdaWrapper;
|
import lombok.RequiredArgsConstructor;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.data.redis.core.StringRedisTemplate;
|
import org.springframework.stereotype.Service;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
|
/**
|
* 银行流水
|
*
|
* @author syt
|
* @date 2026-08-07 16:10:36
|
*/
|
@Slf4j
|
@Service
|
@RequiredArgsConstructor
|
public class BankStatementServiceImpl extends ServiceImpl<BankStatementMapper, BankStatement> implements BankStatementService {
|
|
private final PaymentConfirmService paymentConfirmService;
|
private final ContractMapper contractMapper;
|
private final BusinessCustomerMapper businessCustomerMapper;
|
private final StringRedisTemplate redisTemplate;
|
private final RemoteDeptService remoteDeptService;
|
private final BankStatementItemMapper bankStatementItemMapper;
|
|
@Value("${bip.url}")
|
private String url;
|
|
@Value("${bip.flag}")
|
private Boolean bipFlag;
|
|
@Override
|
public R edit(BankStatementUpdateDTO updateDTO) {
|
BankStatement statement = baseMapper.selectById(updateDTO.getId());
|
if (CollUtil.isEmpty(updateDTO.getContractCollectionList())){
|
return R.failed("请选择收款合同后在提交");
|
}
|
BigDecimal toPaidTotal = updateDTO.getContractCollectionList().stream() .map(StatementContractDTO::getToPaidAmount)
|
.reduce(BigDecimal.ZERO, BigDecimal::add);
|
if (toPaidTotal.compareTo(statement.getTranAmount().subtract(statement.getConfirmAmount()))>0){
|
return R.failed("确认收款总额不能超过交易流水金额");
|
}
|
|
//bip推送
|
if (bipFlag) {
|
R r = pushSaveCollection(statement, updateDTO.getContractCollectionList());
|
if (!r.isOk()){
|
return r;
|
}
|
}
|
|
statement.setConfirmAmount(statement.getConfirmAmount().add(toPaidTotal));
|
baseMapper.updateById(statement);
|
|
updateDTO.getContractCollectionList().stream().forEach(statementContractDTO -> {
|
BankStatementItem item = new BankStatementItem();
|
item.setStatetId(statement.getId());
|
item.setBankSeqNo(statement.getBankSeqNo());
|
item.setConfirmAmount(statementContractDTO.getToPaidAmount());
|
item.setContractId(statementContractDTO.getId());
|
bankStatementItemMapper.insert(item);
|
|
Contract contract = contractMapper.selectById(statementContractDTO.getId());
|
PaymentConfirmAddDTO addDTO = new PaymentConfirmAddDTO();
|
addDTO.setBusGuestId(statement.getBusGuestId()+"");
|
addDTO.setConfirmTime(statement.getTranDate());
|
addDTO.setContractNo(contract.getContractNo());
|
addDTO.setInOrOut("1");
|
addDTO.setTransationAmount(statementContractDTO.getToPaidAmount());
|
addDTO.setBankSeqNo(statement.getBankSeqNo());
|
paymentConfirmService.add(addDTO);
|
});
|
|
return R.ok();
|
}
|
|
private R pushSaveCollection(BankStatement statement, List<StatementContractDTO> contractDTOList) {
|
String accessToken = "";
|
if (redisTemplate.hasKey("BIP_TOKEN")) {
|
accessToken = (String) redisTemplate.opsForValue().get("BIP_TOKEN");
|
} else {
|
accessToken = paymentConfirmService.getAccessToken(accessToken);
|
}
|
if (StrUtil.isEmpty(accessToken)) {
|
log.error("bip accessToken 获取异常");
|
return R.failed("bip accessToken 获取异常");
|
}
|
String finalAccessToken = accessToken;
|
|
BusinessCustomer customer = businessCustomerMapper.selectById(statement.getBusGuestId());
|
if (ObjUtil.isNull(customer)||StrUtil.isEmpty(customer.getBipCode())){
|
log.error("查询客户信息异常");
|
return R.failed("查询客户信息异常");
|
}
|
R<SysDept> r = remoteDeptService.getById(SecurityUtils.getUser().getCompId());
|
log.info("查询单位信息:{}",JSONObject.toJSONString(r.getData()));
|
if (!r.isOk()){
|
log.error("查询单位信息异常");
|
return R.failed("查询单位信息异常");
|
}
|
SysDept dept = r.getData();
|
JSONObject params = genRequestParam(statement,dept,customer,contractDTOList);
|
|
log.info("收款单集成 Request:{}", params.toJSONString());
|
String result = HttpUtil.post(url + "/yonbip/EFI/collection/saveandsubmit?access_token=" + finalAccessToken, params.toJSONString());
|
log.info("收款单集成 Response:{}", result);
|
|
JSONObject resultJson = JSONObject.parseObject(result);
|
if (!resultJson.getString("code").equals("200")) {
|
return R.failed(resultJson.getString("message"));
|
}
|
return R.ok();
|
}
|
|
private JSONObject genRequestParam(BankStatement statement,SysDept dept,BusinessCustomer customer,List<StatementContractDTO> contractDTOList) {
|
JSONObject jsonObject = new JSONObject();
|
JSONObject data = new JSONObject();
|
data.put("billDate",DateUtil.format(statement.getTranDate(), DatePattern.NORM_DATETIME_FORMAT));
|
data.put("exchangeRate","1");//汇率
|
data.put("exchangeRateDate",DateUtil.now());//汇率时间
|
data.put("objectType","1");
|
data.put("customerCode",customer.getBipCode());//客户编码
|
data.put("financeOrgCode",dept.getBipCode());//开票组织编码
|
data.put("orgCode",dept.getBipCode());//业务组织编码
|
data.put("bustypeCode","ar_colsale");// TODO 交易类型编码 暂估默认ZGYSFP，装备默认ZBYXGLXT暂时不能用
|
data.put("oriCurrencyCode","CNY");//币种
|
data.put("srcBillType","38");
|
data.put("srcBillNo",statement.getBankSeqNo());
|
data.put("_status","Insert");
|
JSONArray bodyItem = new JSONArray();
|
for (StatementContractDTO statementContractDTO:contractDTOList) {
|
Contract contract = contractMapper.selectById(statementContractDTO.getId());
|
JSONObject item = new JSONObject();
|
item.put("oriTaxIncludedAmount", statementContractDTO.getToPaidAmount());
|
item.put("contractNo", contract.getContractNo());
|
item.put("quickTypeCode", "1");
|
item.put("_status", "Insert");
|
bodyItem.add(item);
|
}
|
data.put("bodyItem",bodyItem);
|
jsonObject.put("data",data);
|
return jsonObject;
|
}
|
|
@Override
|
public R getHistoryById(Long id) {
|
MPJLambdaWrapper<BankStatementItem> wrapper = new MPJLambdaWrapper<BankStatementItem>()
|
.selectAll(BankStatementItem.class)
|
.select(Contract::getContractNo)
|
.select(Contract::getPartyA)
|
.select(Contract::getAmount)
|
.leftJoin(Contract.class,Contract::getId,BankStatementItem::getContractId)
|
.eq(BankStatementItem::getCompId,SecurityUtils.getUser().getCompId())
|
.orderByDesc(BankStatementItem::getCreateTime);
|
return R.ok(bankStatementItemMapper.selectJoinList(StatementContractVo.class, wrapper));
|
}
|
|
@Override
|
public R delHistoryById(Long id) {
|
|
BankStatementItem statement = bankStatementItemMapper.selectById(id);
|
BankStatement bankStatement = baseMapper.selectById(statement.getStatetId());
|
Contract contract = contractMapper.selectById(statement.getContractId());
|
if (ObjUtil.isNull(contract)){
|
return R.failed("合同信息异常");
|
}
|
BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
|
if (ObjUtil.isNull(customer)){
|
return R.failed("客户信息信息异常");
|
}
|
R<SysDept> r = remoteDeptService.getById(contract.getPartyBId());
|
if (!r.isOk()){
|
return r;
|
}
|
//bip推送
|
if (bipFlag) {
|
String accessToken = "";
|
if (redisTemplate.hasKey("BIP_TOKEN")) {
|
accessToken = (String) redisTemplate.opsForValue().get("BIP_TOKEN");
|
} else {
|
accessToken = paymentConfirmService.getAccessToken(accessToken);
|
}
|
if (StrUtil.isEmpty(accessToken)) {
|
log.error("bip accessToken 获取异常");
|
return R.failed("bip accessToken 获取异常");
|
}
|
String finalAccessToken = accessToken;
|
JSONObject request = genRefundParam(bankStatement,statement, contract, customer, r.getData());
|
log.info("收款退款单-退款单一历史确认请求入参：{}", request.toJSONString());
|
String result = HttpUtil.post(url + "/yonbip/EFI/arRefund/saveandsubmit?access_token=" + finalAccessToken, request.toJSONString());
|
log.info("收款退款单-退款单一历史确认请求回参:{}", result);
|
JSONObject resultJson = JSONObject.parseObject(result);
|
if (!resultJson.getString("code").equals("200")) {
|
return R.failed(resultJson.getString("message"));
|
}
|
}
|
bankStatementItemMapper.deleteById(id);
|
|
bankStatement.setConfirmAmount(bankStatement.getConfirmAmount().subtract(statement.getConfirmAmount()));
|
baseMapper.updateById(bankStatement);
|
return R.ok();
|
}
|
|
private JSONObject genRefundParam(BankStatement bankStatement,BankStatementItem statement, Contract contract,BusinessCustomer customer, SysDept dept) {
|
JSONObject jsonObject = new JSONObject();
|
JSONObject data = new JSONObject();
|
data.put("billDate",DateUtil.now());
|
data.put("exchangeRate","1");//汇率
|
data.put("exchangeRateDate",DateUtil.now());//汇率时间
|
data.put("objectType","1");
|
data.put("customerCode",customer.getBipCode());//客户编码
|
data.put("financeOrgCode",dept.getBipCode());//开票组织编码
|
data.put("orgCode",dept.getBipCode());//业务组织编码
|
data.put("bustypeCode","ar_refsale");//交易类型编码 暂估默认ZGYSFP，销售默认MJHYXGLXT
|
data.put("oriCurrencyCode","CNY");//币种
|
data.put("srcBillType","38");
|
data.put("srcBillNo",bankStatement.getBankSeqNo());
|
data.put("_status","Insert");
|
JSONArray bodyItem = new JSONArray();
|
JSONObject item = new JSONObject();
|
item.put("oriTaxIncludedAmount", statement.getConfirmAmount());
|
item.put("contractNo", contract.getContractNo());
|
item.put("quickTypeCode", "1");
|
item.put("_status", "Insert");
|
bodyItem.add(item);
|
data.put("bodyItem",bodyItem);
|
jsonObject.put("data",data);
|
return jsonObject;
|
}
|
|
@Override
|
public R backBal(Long id) {
|
BankStatement bankStatement = baseMapper.selectById(id);
|
BusinessCustomer customer = businessCustomerMapper.selectById(bankStatement.getBusGuestId());
|
if (ObjUtil.isNull(customer)||StrUtil.isEmpty(customer.getBipCode())){
|
log.error("查询客户信息异常");
|
return R.failed("查询客户信息异常");
|
}
|
R<SysDept> r = remoteDeptService.getById(SecurityUtils.getUser().getCompId());
|
if (!r.isOk()){
|
log.error("查询单位信息异常");
|
return R.failed("查询单位信息异常");
|
}
|
SysDept dept = r.getData();
|
List<BankStatementItem> items = bankStatementItemMapper.selectList(Wrappers.<BankStatementItem>lambdaQuery()
|
.eq(BankStatementItem::getStatetId,id));
|
if (bipFlag){
|
String accessToken = "";
|
if (redisTemplate.hasKey("BIP_TOKEN")) {
|
accessToken = (String) redisTemplate.opsForValue().get("BIP_TOKEN");
|
} else {
|
accessToken = paymentConfirmService.getAccessToken(accessToken);
|
}
|
if (StrUtil.isEmpty(accessToken)) {
|
log.error("bip accessToken 获取异常");
|
return R.failed("bip accessToken 获取异常");
|
}
|
String finalAccessToken = accessToken;
|
JSONObject request = genBackBalParam(bankStatement,customer,dept,items);
|
log.info("收款退款单-退款余额请求入参：{}", request.toJSONString());
|
String result = HttpUtil.post(url + "/yonbip/EFI/arRefund/saveandsubmit?access_token=" + finalAccessToken, request.toJSONString());
|
log.info("收款退款单-退款余额请求回参:{}", result);
|
JSONObject resultJson = JSONObject.parseObject(result);
|
if (!resultJson.getString("code").equals("200")) {
|
return R.failed(resultJson.getString("message"));
|
}
|
}
|
bankStatement.setTranAmount(bankStatement.getConfirmAmount());
|
baseMapper.updateById(bankStatement);
|
return R.ok();
|
}
|
|
private JSONObject genBackBalParam(BankStatement bankStatement, BusinessCustomer customer, SysDept dept, List<BankStatementItem> items) {
|
JSONObject jsonObject = new JSONObject();
|
JSONObject data = new JSONObject();
|
data.put("billDate",DateUtil.now());
|
data.put("exchangeRate","1");//汇率
|
data.put("exchangeRateDate",DateUtil.now());//汇率时间
|
data.put("objectType","1");
|
data.put("customerCode",customer.getBipCode());//客户编码
|
data.put("financeOrgCode",dept.getBipCode());//开票组织编码
|
data.put("orgCode",dept.getBipCode());//业务组织编码
|
data.put("bustypeCode","ar_refsale");//交易类型编码 暂估默认ZGYSFP，销售默认MJHYXGLXT
|
data.put("oriCurrencyCode","CNY");//币种
|
data.put("srcBillType","38");
|
data.put("srcBillNo",bankStatement.getBankSeqNo());
|
data.put("_status","Insert");
|
JSONArray bodyItem = new JSONArray();
|
JSONObject item = new JSONObject();
|
item.put("oriTaxIncludedAmount", bankStatement.getTranAmount().subtract(bankStatement.getConfirmAmount()));
|
item.put("quickTypeCode", "1");
|
item.put("_status", "Insert");
|
bodyItem.add(item);
|
data.put("bodyItem",bodyItem);
|
jsonObject.put("data",data);
|
return jsonObject;
|
}
|
|
@Override
|
public R backAll(Long id) {
|
BankStatement bankStatement = baseMapper.selectById(id);
|
BusinessCustomer customer = businessCustomerMapper.selectById(bankStatement.getBusGuestId());
|
if (ObjUtil.isNull(customer)||StrUtil.isEmpty(customer.getBipCode())){
|
log.error("查询客户信息异常");
|
return R.failed("查询客户信息异常");
|
}
|
R<SysDept> r = remoteDeptService.getById(SecurityUtils.getUser().getCompId());
|
if (!r.isOk()){
|
log.error("查询单位信息异常");
|
return R.failed("查询单位信息异常");
|
}
|
SysDept dept = r.getData();
|
List<BankStatementItem> items = bankStatementItemMapper.selectList(Wrappers.<BankStatementItem>lambdaQuery()
|
.eq(BankStatementItem::getStatetId,id));
|
if (bipFlag){
|
String accessToken = "";
|
if (redisTemplate.hasKey("BIP_TOKEN")) {
|
accessToken = (String) redisTemplate.opsForValue().get("BIP_TOKEN");
|
} else {
|
accessToken = paymentConfirmService.getAccessToken(accessToken);
|
}
|
if (StrUtil.isEmpty(accessToken)) {
|
log.error("bip accessToken 获取异常");
|
return R.failed("bip accessToken 获取异常");
|
}
|
String finalAccessToken = accessToken;
|
JSONObject request = genBackAllParam(bankStatement,customer,dept,items);
|
log.info("收款退款单-退款所有请求入参：{}", request.toJSONString());
|
String result = HttpUtil.post(url + "/yonbip/EFI/arRefund/saveandsubmit?access_token=" + finalAccessToken, request.toJSONString());
|
log.info("收款退款单-退款所有请求回参:{}", result);
|
JSONObject resultJson = JSONObject.parseObject(result);
|
if (!resultJson.getString("code").equals("200")) {
|
return R.failed(resultJson.getString("message"));
|
}
|
}
|
bankStatement.setConfirmAmount(new BigDecimal("0"));
|
baseMapper.updateById(bankStatement);
|
return R.ok();
|
}
|
|
private JSONObject genBackAllParam(BankStatement bankStatement, BusinessCustomer customer, SysDept dept, List<BankStatementItem> items) {
|
JSONObject jsonObject = new JSONObject();
|
JSONObject data = new JSONObject();
|
data.put("billDate",DateUtil.now());
|
data.put("exchangeRate","1");//汇率
|
data.put("exchangeRateDate",DateUtil.now());//汇率时间
|
data.put("objectType","1");
|
data.put("customerCode",customer.getBipCode());//客户编码
|
data.put("financeOrgCode",dept.getBipCode());//开票组织编码
|
data.put("orgCode",dept.getBipCode());//业务组织编码
|
data.put("bustypeCode","ar_refsale");//交易类型编码 暂估默认ZGYSFP，销售默认MJHYXGLXT
|
data.put("oriCurrencyCode","CNY");//币种
|
data.put("srcBillType","38");
|
data.put("srcBillNo",bankStatement.getBankSeqNo());
|
data.put("_status","Insert");
|
JSONArray bodyItem = new JSONArray();
|
JSONObject item = new JSONObject();
|
item.put("oriTaxIncludedAmount", bankStatement.getTranAmount());
|
item.put("quickTypeCode", "1");
|
item.put("_status", "Insert");
|
bodyItem.add(item);
|
data.put("bodyItem",bodyItem);
|
jsonObject.put("data",data);
|
return jsonObject;
|
}
|
|
@Override
|
public R backHis(Long id) {
|
BankStatement bankStatement = baseMapper.selectById(id);
|
BusinessCustomer customer = businessCustomerMapper.selectById(bankStatement.getBusGuestId());
|
if (ObjUtil.isNull(customer)||StrUtil.isEmpty(customer.getBipCode())){
|
log.error("查询客户信息异常");
|
return R.failed("查询客户信息异常");
|
}
|
R<SysDept> r = remoteDeptService.getById(SecurityUtils.getUser().getCompId());
|
if (!r.isOk()){
|
log.error("查询单位信息异常");
|
return R.failed("查询单位信息异常");
|
}
|
SysDept dept = r.getData();
|
List<BankStatementItem> items = bankStatementItemMapper.selectList(Wrappers.<BankStatementItem>lambdaQuery()
|
.eq(BankStatementItem::getStatetId,id));
|
if (bipFlag){
|
String accessToken = "";
|
if (redisTemplate.hasKey("BIP_TOKEN")) {
|
accessToken = (String) redisTemplate.opsForValue().get("BIP_TOKEN");
|
} else {
|
accessToken = paymentConfirmService.getAccessToken(accessToken);
|
}
|
if (StrUtil.isEmpty(accessToken)) {
|
log.error("bip accessToken 获取异常");
|
return R.failed("bip accessToken 获取异常");
|
}
|
String finalAccessToken = accessToken;
|
JSONObject request = genBackHisParam(bankStatement,customer,dept,items);
|
log.info("收款退款单-退款历史确认请求入参：{}", request.toJSONString());
|
String result = HttpUtil.post(url + "/yonbip/EFI/arRefund/saveandsubmit?access_token=" + finalAccessToken, request.toJSONString());
|
log.info("收款退款单-退款历史确认请求回参:{}", result);
|
JSONObject resultJson = JSONObject.parseObject(result);
|
if (!resultJson.getString("code").equals("200")) {
|
return R.failed(resultJson.getString("message"));
|
}
|
}
|
|
bankStatement.setConfirmAmount(new BigDecimal("0"));
|
baseMapper.updateById(bankStatement);
|
bankStatementItemMapper.deleteByIds(items.stream().map(item->item.getId()).collect(Collectors.toList()));
|
return R.ok();
|
}
|
|
private JSONObject genBackHisParam(BankStatement bankStatement, BusinessCustomer customer, SysDept dept,List<BankStatementItem> items) {
|
JSONObject jsonObject = new JSONObject();
|
JSONObject data = new JSONObject();
|
data.put("billDate",DateUtil.now());
|
data.put("exchangeRate","1");//汇率
|
data.put("exchangeRateDate",DateUtil.now());//汇率时间
|
data.put("objectType","1");
|
data.put("customerCode",customer.getBipCode());//客户编码
|
data.put("financeOrgCode",dept.getBipCode());//开票组织编码
|
data.put("orgCode",dept.getBipCode());//业务组织编码
|
data.put("bustypeCode","ar_refsale");//交易类型编码 暂估默认ZGYSFP，销售默认MJHYXGLXT
|
data.put("oriCurrencyCode","CNY");//币种
|
data.put("srcBillType","38");
|
data.put("srcBillNo",bankStatement.getBankSeqNo());
|
data.put("_status","Insert");
|
JSONArray bodyItem = new JSONArray();
|
for (BankStatementItem statementItem:items) {
|
Contract contract = contractMapper.selectById(statementItem.getContractId());
|
JSONObject item = new JSONObject();
|
item.put("oriTaxIncludedAmount", statementItem.getConfirmAmount());
|
item.put("contractNo", contract.getContractNo());
|
item.put("quickTypeCode", "1");
|
item.put("_status", "Insert");
|
bodyItem.add(item);
|
}
|
data.put("bodyItem",bodyItem);
|
jsonObject.put("data",data);
|
return jsonObject;
|
}
|
}
|
