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 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 tmsPayableFeeItems = tmsPayableFeeItemMapper.selectTmsPayableFeeItemList( new TmsPayableFeeItem() {{ setHeadId(id); }} ); tmsPayableFee.setPayableFeeItems(tmsPayableFeeItems); return tmsPayableFee; } @DataSource(DataSourceType.SLAVE) @Override public List selectTmsPayableFeeByDispatchNo(String dispatchNo) { List tmsPayableFeeList = tmsPayableFeeMapper.selectList(new LambdaQueryWrapper() .eq(TmsPayableFee::getDispatchNo, dispatchNo) .ne(TmsPayableFee::getStatus, 2) ); if (tmsPayableFeeList != null && !tmsPayableFeeList.isEmpty()){ tmsPayableFeeList.forEach(tmsPayableFee -> { List 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 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 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 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() .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 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 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() .set(TmsPayableFee::getBillPayableId,tmsApBill.getId()) .set(TmsPayableFee::getBillPayableNo,tmsApBill.getSystemNo()) .set(TmsPayableFee::getStatus,1) .in(TmsPayableFee::getId, ids) ); List tmsPayableFeeList = tmsApBill.getTmsPayableFeeList(); List 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 tmsPayableFeeList) { java.util.Map requestBody = new java.util.HashMap<>(); try { // 构建请求体 String apiUrl = url+"/addPayableBill"; // 构建bill部分 java.util.Map 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> feesList = new java.util.ArrayList<>(); for (int i = 0; i < tmsPayableFeeList.size(); i++) { TmsPayableFee fee = tmsPayableFeeList.get(i); java.util.Map 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> feeDetailsList = new java.util.ArrayList<>(); List payableFeeItems = fee.getPayableFeeItems(); for (TmsPayableFeeItem payableFeeItem : payableFeeItems) { java.util.Map 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 entity = new HttpEntity<>(JSON.toJSONString(requestBody), headers); // 发送API请求 ResponseEntity 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); } }