package com.ruoyi.tms.service.impl;
|
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.util.Arrays;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
|
import com.ruoyi.common.core.domain.AjaxResult;
|
import com.ruoyi.common.enums.SystemDataNoEnum;
|
import com.ruoyi.common.utils.DateUtils;
|
import javax.annotation.Resource;
|
|
import com.ruoyi.common.utils.SecurityUtils;
|
import com.ruoyi.system.service.ISysConfigService;
|
import com.ruoyi.system.service.ISystemDataNoService;
|
import com.ruoyi.tms.domain.*;
|
import com.ruoyi.tms.mapper.*;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.core.task.AsyncTaskExecutor;
|
import org.springframework.core.task.SimpleAsyncTaskExecutor;
|
import org.springframework.http.HttpEntity;
|
import org.springframework.http.HttpHeaders;
|
import org.springframework.http.HttpMethod;
|
import org.springframework.http.MediaType;
|
import org.springframework.http.ResponseEntity;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.scheduling.annotation.Async;
|
import org.springframework.web.client.RestTemplate;
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import com.alibaba.fastjson2.JSON;
|
import com.alibaba.fastjson2.JSONObject;
|
import com.ruoyi.common.utils.PageUtils;
|
import com.ruoyi.common.constant.Constants;
|
import com.ruoyi.common.annotation.DataSource;
|
import com.ruoyi.common.enums.DataSourceType;
|
import com.ruoyi.common.core.service.BaseService;
|
|
import com.ruoyi.tms.service.ITmsPayableFeeService;
|
import com.ruoyi.common.core.text.Convert;
|
|
/**
|
* 应付费用Service业务层处理
|
*
|
* @author ruoyi
|
* @date 2026-01-12
|
*/
|
@Service
|
@Transactional(rollbackFor = Exception.class)
|
public class TmsPayableFeeServiceImpl extends BaseService<TmsPayableFeeMapper, TmsPayableFee> implements ITmsPayableFeeService
|
{
|
protected final Logger logger = LoggerFactory.getLogger(getClass());
|
@Resource
|
private TmsPayableFeeMapper tmsPayableFeeMapper;
|
@Resource
|
private TmsDispatchOrderMapper tmsDispatchOrderMapper;
|
|
@Resource
|
private TmsPayableFeeItemMapper tmsPayableFeeItemMapper;
|
@Resource
|
private TmsApBillMapper tmsApBillMapper;
|
@Resource
|
private TmsApBillItemMapper tmsApBillItemMapper;
|
|
|
@Resource
|
ISysConfigService sysConfigService;
|
@Autowired
|
ISystemDataNoService systemDataNoService;
|
@Autowired
|
private RestTemplate restTemplate;
|
@Value("${custom.cwxtApi.url}")
|
private String url;
|
/**
|
* 查询应付费用
|
*
|
* @param id 应付费用ID
|
* @return 应付费用
|
*/
|
@DataSource(DataSourceType.SLAVE)
|
@Override
|
public TmsPayableFee selectTmsPayableFeeById(Integer id)
|
{
|
TmsPayableFee tmsPayableFee = tmsPayableFeeMapper.selectTmsPayableFeeById(id);
|
List<TmsPayableFeeItem> tmsPayableFeeItems = tmsPayableFeeItemMapper.selectTmsPayableFeeItemList(
|
new TmsPayableFeeItem() {{
|
setHeadId(id);
|
}}
|
);
|
tmsPayableFee.setPayableFeeItems(tmsPayableFeeItems);
|
return tmsPayableFee;
|
}
|
|
@DataSource(DataSourceType.SLAVE)
|
@Override
|
public List<TmsPayableFee> selectTmsPayableFeeByDispatchNo(String dispatchNo)
|
{
|
List<TmsPayableFee> tmsPayableFeeList = tmsPayableFeeMapper.selectList(new LambdaQueryWrapper<TmsPayableFee>()
|
.eq(TmsPayableFee::getDispatchNo, dispatchNo)
|
.ne(TmsPayableFee::getStatus, 2)
|
);
|
|
if (tmsPayableFeeList != null && !tmsPayableFeeList.isEmpty()){
|
tmsPayableFeeList.forEach(tmsPayableFee -> {
|
List<TmsPayableFeeItem> tmsPayableFeeItems = tmsPayableFeeItemMapper.selectTmsPayableFeeItemList(
|
new TmsPayableFeeItem() {{
|
setHeadId(tmsPayableFee.getId());
|
}}
|
);
|
tmsPayableFee.setPayableFeeItems(tmsPayableFeeItems);
|
});
|
}
|
return tmsPayableFeeList;
|
}
|
|
/**
|
* 查询应付费用 记录数
|
*
|
* @param tmsPayableFee 应付费用
|
* @return 应付费用集合
|
*/
|
@DataSource(DataSourceType.SLAVE)
|
@Override
|
public int selectTmsPayableFeeCount(TmsPayableFee tmsPayableFee)
|
{
|
return tmsPayableFeeMapper.selectTmsPayableFeeCount(tmsPayableFee);
|
}
|
|
/**
|
* 查询应付费用列表
|
*
|
* @param tmsPayableFee 应付费用
|
* @return 应付费用
|
*/
|
@DataSource(DataSourceType.SLAVE)
|
@Override
|
public List<TmsPayableFee> selectTmsPayableFeeList(TmsPayableFee tmsPayableFee)
|
{
|
return tmsPayableFeeMapper.selectTmsPayableFeeList(tmsPayableFee);
|
}
|
|
/**
|
* 查询应付费用列表 异步 导出
|
*
|
* @param tmsPayableFee 应付费用
|
* @param exportKey 导出功能的唯一标识
|
* @return 应付费用集合
|
*/
|
@DataSource(DataSourceType.SLAVE)
|
@Async
|
@Override
|
public void export(TmsPayableFee tmsPayableFee,String exportKey) {
|
|
super.export(TmsPayableFee.class,exportKey,"tmsPayableFeeData",(pageNum)->{
|
PageUtils.startPage(pageNum, Constants.EXPORT_PATE_SIZE);
|
return selectTmsPayableFeeList(tmsPayableFee);
|
});
|
}
|
|
|
/**
|
* 新增应付费用
|
*
|
* @param tmsPayableFee 应付费用
|
* @return 结果
|
*/
|
@Override
|
public int insertTmsPayableFee(TmsPayableFee tmsPayableFee)
|
{
|
tmsPayableFee.setCreateTime(DateUtils.getNowDate());
|
return tmsPayableFeeMapper.insertTmsPayableFee(tmsPayableFee);
|
}
|
|
/**
|
* 新增应付费用[批量]
|
*
|
* @param tmsPayableFees 应付费用
|
* @return 结果
|
*/
|
@Override
|
public int insertTmsPayableFeeBatch(List<TmsPayableFee> tmsPayableFees)
|
{
|
int rows = tmsPayableFeeMapper.insertTmsPayableFeeBatch(tmsPayableFees);
|
return rows;
|
}
|
|
/**
|
* 修改应付费用
|
*
|
* @param tmsPayableFee 应付费用
|
* @return 结果
|
*/
|
@Override
|
public int updateTmsPayableFee(TmsPayableFee tmsPayableFee)
|
{
|
tmsPayableFee.setUpdateTime(DateUtils.getNowDate());
|
return tmsPayableFeeMapper.updateTmsPayableFee(tmsPayableFee);
|
}
|
|
/**
|
* 修改应付费用[批量]
|
*
|
* @param tmsPayableFees 应付费用
|
* @return 结果
|
*/
|
@Override
|
public int updateTmsPayableFeeBatch(List<TmsPayableFee> tmsPayableFees){
|
return tmsPayableFeeMapper.updateTmsPayableFeeBatch(tmsPayableFees);
|
}
|
|
@Override
|
public int closeTmsPayableFeeById(Integer id) {
|
TmsPayableFee tmsPayableFee = selectTmsPayableFeeById(id);
|
if(tmsPayableFee != null){
|
tmsPayableFee.setStatus(2);
|
updateTmsPayableFee(tmsPayableFee);
|
tmsDispatchOrderMapper.update(new LambdaUpdateWrapper<TmsDispatchOrder>()
|
.eq(TmsDispatchOrder::getId,tmsPayableFee.getDispatchId())
|
.set(TmsDispatchOrder::getAccountsPayableStatus,0)
|
);
|
}else{
|
throw new RuntimeException("数据不存在");
|
}
|
|
return 1;
|
}
|
|
/**
|
* 删除应付费用对象
|
*
|
* @param ids 需要删除的数据ID
|
* @return 结果
|
*/
|
@Override
|
public int deleteTmsPayableFeeByIds(String ids)
|
{
|
return deleteTmsPayableFeeByIds(Convert.toIntArray(ids));
|
}
|
|
/**
|
* 删除应付费用对象
|
*
|
*
|
* @param ids 需要删除的数据ID
|
* @return 结果
|
*/
|
@Override
|
public int deleteTmsPayableFeeByIds(Integer[] ids)
|
{
|
return tmsPayableFeeMapper.deleteTmsPayableFeeByIds(ids);
|
}
|
|
@Override
|
public TmsApBill initApGenerate(Integer[] ids) {
|
List<TmsPayableFee> tmsPayableFeeList = tmsPayableFeeMapper.selectBatchIds(Arrays.asList(ids));
|
boolean hasDifferentCustomers = tmsPayableFeeList.stream()
|
.map(item-> item.getServiceProviderType()+"_"+ item.getServiceProviderId())
|
.distinct()
|
.count() > 1;
|
if (hasDifferentCustomers) {
|
throw new RuntimeException("所选费用包含不同供应商，无法合并生成应收账单");
|
}
|
|
TmsApBill tmsApBill = new TmsApBill();
|
tmsApBill.setDispatchCount(tmsPayableFeeList.size());
|
String s = sysConfigService.selectConfigByKey("sys.hk.rmb.rate");
|
BigDecimal exchangeRate = new BigDecimal(s);
|
tmsApBill.setSettleRate(exchangeRate);
|
TmsPayableFee tmsPayableFee = tmsPayableFeeList.get(0);
|
tmsApBill.setServiceProviderId(tmsPayableFee.getServiceProviderId());
|
tmsApBill.setServiceProviderName(tmsPayableFee.getServiceProviderName());
|
tmsApBill.setServiceProviderType(tmsPayableFee.getServiceProviderType());
|
tmsApBill.setBillName(DateUtils.dateTime()+tmsApBill.getServiceProviderName()+"账单");
|
|
tmsApBill.setSettleAmount(BigDecimal.ZERO);
|
tmsPayableFeeList.forEach(item ->{
|
List<TmsPayableFeeItem> tmsPayableFeeItems = tmsPayableFeeItemMapper.selectTmsPayableFeeItemList(new TmsPayableFeeItem() {{
|
setHeadId(item.getId());
|
}});
|
item.setPayableFeeItems(tmsPayableFeeItems);
|
BigDecimal rmbAmount = item.getPayableHkbAmount()
|
.multiply(exchangeRate)
|
.setScale(2, RoundingMode.HALF_UP);
|
item.setPayableRmbSumAmount( item.getPayableRmbAmount().add(rmbAmount));
|
tmsApBill.setSettleAmount(tmsApBill.getSettleAmount().add(item.getPayableRmbSumAmount()));
|
|
});
|
tmsApBill.setTmsPayableFeeList(tmsPayableFeeList);
|
tmsApBill.setActualSettlementAmount(tmsApBill.getSettleAmount());
|
return tmsApBill;
|
}
|
|
@Override
|
public AjaxResult apGenerate(Integer[] ids) {
|
|
TmsApBill tmsApBill = initApGenerate(ids);
|
tmsApBill.setSystemNo(systemDataNoService.getNoByKey(SystemDataNoEnum.YFZD));
|
tmsApBill.setSettledAmount(BigDecimal.ZERO);
|
tmsApBill.setInvoiceStatus(0);
|
tmsApBill.setStatus(0);
|
tmsApBill.setPushStatus(0); // 初始推送状态：未推送
|
tmsApBill.setCreateBy(SecurityUtils.getUsername());
|
tmsApBillMapper.insertTmsApBill(tmsApBill);
|
|
tmsPayableFeeMapper.update(new LambdaUpdateWrapper<TmsPayableFee>()
|
.set(TmsPayableFee::getBillPayableId,tmsApBill.getId())
|
.set(TmsPayableFee::getBillPayableNo,tmsApBill.getSystemNo())
|
.set(TmsPayableFee::getStatus,1)
|
.in(TmsPayableFee::getId, ids)
|
);
|
List<TmsPayableFee> tmsPayableFeeList = tmsApBill.getTmsPayableFeeList();
|
List<TmsApBillItem> rmb = tmsPayableFeeList.stream().map(item -> {
|
TmsApBillItem billItem = new TmsApBillItem();
|
billItem.setBillId(tmsApBill.getId());
|
billItem.setProjectName(item.getProjectName());
|
billItem.setDispatchNo(item.getDispatchNo());
|
billItem.setOrderTime(item.getCreateTime());
|
billItem.setEstimateAmount(item.
|
getPayableRmbSumAmount());
|
billItem.setCurrency("RMB");
|
billItem.setApFeeId(item.getId());
|
billItem.setStatus(0);
|
return billItem;
|
}).collect(Collectors.toList());
|
if (!rmb.isEmpty()){
|
tmsApBillItemMapper.insertTmsApBillItemBatch(rmb);
|
}
|
|
//向外部系统推送数据
|
AsyncTaskExecutor executor = new SimpleAsyncTaskExecutor();
|
executor.execute(() -> pushPayableToExternalSystem(tmsApBill, tmsPayableFeeList));
|
|
return AjaxResult.success();
|
}
|
|
/**
|
* 向外部系统推送应付数据
|
* @param tmsApBill 应付账单
|
* @param tmsPayableFeeList 应付费用列表
|
*/
|
@Async
|
protected void pushPayableToExternalSystem(TmsApBill tmsApBill, List<TmsPayableFee> tmsPayableFeeList) {
|
java.util.Map<String, Object> requestBody = new java.util.HashMap<>();
|
try {
|
// 构建请求体
|
String apiUrl = url+"/addPayableBill";
|
|
// 构建bill部分
|
java.util.Map<String, Object> billMap = new java.util.HashMap<>();
|
billMap.put("billName", tmsApBill.getBillName());
|
billMap.put("supplierName", tmsApBill.getServiceProviderName());
|
billMap.put("totalAmount", tmsApBill.getSettleAmount());
|
billMap.put("currency", "RMB");
|
billMap.put("status", "0");
|
billMap.put("isInternalSettlement", "0");
|
billMap.put("internalSettlementUnit", tmsApBill.getServiceProviderName());
|
billMap.put("documentCount", tmsPayableFeeList.size());
|
billMap.put("discountAmount", 0.00);
|
billMap.put("paidAmount", 0.00);
|
billMap.put("pendingAmount", tmsApBill.getSettleAmount());
|
billMap.put("exchangeRate", tmsApBill.getSettleRate());
|
billMap.put("cnyAmount", tmsApBill.getSettleAmount());
|
billMap.put("periodType", "");
|
billMap.put("businessStartDate", "");
|
billMap.put("businessEndDate", "");
|
billMap.put("billingStartDate", "");
|
billMap.put("billingEndDate", "");
|
billMap.put("billGenerateDate", "");
|
billMap.put("billSendDate", "");
|
billMap.put("billDueDate", "");
|
billMap.put("remark", "");
|
|
// 构建fees部分
|
List<java.util.Map<String, Object>> feesList = new java.util.ArrayList<>();
|
for (int i = 0; i < tmsPayableFeeList.size(); i++) {
|
TmsPayableFee fee = tmsPayableFeeList.get(i);
|
java.util.Map<String, Object> feeMap = new java.util.HashMap<>();
|
feeMap.put("sourceSystem", "TMS");
|
feeMap.put("documentNo", fee.getDispatchNo() != null ? fee.getDispatchNo() : "");
|
feeMap.put("supplierName", tmsApBill.getServiceProviderName());
|
feeMap.put("payableAmount", fee.getPayableRmbAmount().add(fee.getPayableHkbAmount()));
|
BigDecimal rmbAmount = fee.getPayableRmbAmount();
|
BigDecimal hkbAmount = fee.getPayableHkbAmount();
|
StringBuilder amountStr = new StringBuilder();
|
if (rmbAmount.compareTo(BigDecimal.ZERO) > 0) {
|
amountStr.append(rmbAmount).append("人民币");
|
}
|
if (hkbAmount.compareTo(BigDecimal.ZERO) > 0) {
|
if (amountStr.length() > 0) {
|
amountStr.append(" ");
|
}
|
amountStr.append(hkbAmount).append("港币");
|
}
|
feeMap.put("payableAmountStr", amountStr.toString());
|
feeMap.put("serialNumber", String.format("%03d", i + 1));
|
feeMap.put("relatedBillNo", "");
|
feeMap.put("businessSector", "0");
|
feeMap.put("documentType", "0");
|
feeMap.put("isInternalSettlement", "0");
|
feeMap.put("internalSettlementUnit", "");
|
feeMap.put("projectName", fee.getProjectName() != null ? fee.getProjectName() : "");
|
feeMap.put("businessTime", fee.getDispatchConfirmTime());
|
feeMap.put("payableConfirmTime", fee.getDispatchConfirmTime());
|
feeMap.put("status", "1");
|
feeMap.put("remark", "");
|
|
// 构建feeDetails部分
|
List<java.util.Map<String, Object>> feeDetailsList = new java.util.ArrayList<>();
|
List<TmsPayableFeeItem> payableFeeItems = fee.getPayableFeeItems();
|
for (TmsPayableFeeItem payableFeeItem : payableFeeItems) {
|
java.util.Map<String, Object> feeDetailMap = new java.util.HashMap<>();
|
feeDetailMap.put("feeType", payableFeeItem.getFeeType());
|
feeDetailMap.put("feeName", payableFeeItem.getFeeName());
|
feeDetailMap.put("unitPrice", payableFeeItem.getRegisterAmount());
|
feeDetailMap.put("billingQuantity", payableFeeItem.getRegisterAmount());
|
feeDetailMap.put("billingAmount", payableFeeItem.getRegisterAmount());
|
feeDetailMap.put("billingUnit", "次");
|
feeDetailMap.put("actualAmount", payableFeeItem.getRegisterAmount());
|
feeDetailMap.put("currency", payableFeeItem.getCurrency());
|
feeDetailMap.put("feeRegTime",payableFeeItem.getRegisterTime());
|
feeDetailMap.put("remark", "");
|
feeDetailsList.add(feeDetailMap);
|
}
|
|
|
feeMap.put("feeDetails", feeDetailsList);
|
feesList.add(feeMap);
|
}
|
|
// 构建完整请求体
|
requestBody.put("bill", billMap);
|
requestBody.put("fees", feesList);
|
|
// 设置HTTP头
|
HttpHeaders headers = new HttpHeaders();
|
headers.setContentType(MediaType.APPLICATION_JSON);
|
HttpEntity<String> entity = new HttpEntity<>(JSON.toJSONString(requestBody), headers);
|
|
// 发送API请求
|
ResponseEntity<String> response = restTemplate.exchange(apiUrl, HttpMethod.POST, entity, String.class);
|
logger.info("推送应付数据到外部系统成功，响应: {}", response.getBody());
|
|
|
// 解析响应，获取sourceSystemId
|
try {
|
JSONObject result = JSONObject.parseObject(response.getBody());
|
String sourceSystemId = result.getString("sourceSystemId");
|
if (sourceSystemId != null) {
|
tmsApBill.setSourceSystemId(Integer.parseInt(sourceSystemId));
|
}
|
} catch (Exception e) {
|
logger.error("解析外部系统响应失败: {}", e.getMessage());
|
}
|
// 更新推送状态为成功
|
tmsApBill.setPushStatus(2);
|
tmsApBill.setPushTime(DateUtils.getNowDate());
|
tmsApBillMapper.updateTmsApBill(tmsApBill);
|
} catch (Exception e) {
|
logger.error("推送应付数据到外部系统失败，账单ID: {}, 供应商: {}",
|
tmsApBill.getId(), tmsApBill.getServiceProviderName(), e);
|
logger.debug("推送失败的请求数据: {}", JSON.toJSONString(requestBody));
|
|
// 更新推送状态为失败
|
tmsApBill.setPushStatus(3);
|
tmsApBill.setPushTime(DateUtils.getNowDate());
|
tmsApBillMapper.updateTmsApBill(tmsApBill);
|
}
|
}
|
|
/**
|
* 删除应付费用信息
|
*
|
* @param id 应付费用ID
|
* @return 结果
|
*/
|
@Override
|
public int deleteTmsPayableFeeById(Integer id)
|
{
|
return tmsPayableFeeMapper.deleteTmsPayableFeeById(id);
|
}
|
}
|
