| | |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.math.RoundingMode; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | | |
| | | import com.ruoyi.common.enums.SystemDataNoEnum; |
| | | import com.ruoyi.common.exception.ServiceException; |
| | | import com.ruoyi.common.utils.DateUtils; |
| | | import javax.annotation.Resource; |
| | | |
| | |
| | | import com.ruoyi.cwgl.domain.vo.ReceivableFeeStatisticsVo; |
| | | import com.ruoyi.system.domain.SysConfig; |
| | | import com.ruoyi.system.mapper.SysConfigMapper; |
| | | import com.ruoyi.system.service.ISystemDataNoService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.stereotype.Service; |
| | |
| | | @Autowired |
| | | private IReceivableBillSettlementDetailService receivableBillSettlementDetailService; |
| | | |
| | | @Autowired |
| | | ISystemDataNoService systemDataNoService; |
| | | |
| | | /** |
| | | * 查询应收费用管理 |
| | |
| | | @Override |
| | | public ReceivableFeeManagement selectReceivableFeeManagementById(Integer id) |
| | | { |
| | | return receivableFeeManagementMapper.selectReceivableFeeManagementById(id); |
| | | ReceivableFeeManagement receivableFeeManagement = receivableFeeManagementMapper.selectReceivableFeeManagementById(id); |
| | | if (receivableFeeManagement != null) { |
| | | // 查询对应的费用明细 |
| | | ReceivableFeeDetail detail = new ReceivableFeeDetail(); |
| | | detail.setReceivableFeeId(id); |
| | | List<ReceivableFeeDetail> detailList = receivableFeeDetailService.selectReceivableFeeDetailList(detail); |
| | | receivableFeeManagement.setReceivableFeeDetailList(detailList); |
| | | } |
| | | return receivableFeeManagement; |
| | | } |
| | | |
| | | /** |
| | |
| | | public int insertReceivableFeeManagement(ReceivableFeeManagement receivableFeeManagement) |
| | | { |
| | | receivableFeeManagement.setCreateTime(DateUtils.getNowDate()); |
| | | |
| | | String noByKey = systemDataNoService.getNoByKey(SystemDataNoEnum.YS); |
| | | receivableFeeManagement.setSystemNo(noByKey); |
| | | |
| | | // 保存主表信息 |
| | | int result = receivableFeeManagementMapper.insertReceivableFeeManagement(receivableFeeManagement); |
| | | |
| | |
| | | public int updateReceivableFeeManagement(ReceivableFeeManagement receivableFeeManagement) |
| | | { |
| | | receivableFeeManagement.setUpdateTime(DateUtils.getNowDate()); |
| | | return receivableFeeManagementMapper.updateReceivableFeeManagement(receivableFeeManagement); |
| | | |
| | | // 1. 更新主表信息 |
| | | int result = receivableFeeManagementMapper.updateReceivableFeeManagement(receivableFeeManagement); |
| | | |
| | | // 2. 获取主表ID |
| | | Integer receivableFeeId = receivableFeeManagement.getId(); |
| | | |
| | | // 3. 删除该应收费用下的所有现有明细 |
| | | receivableFeeDetailService.deleteReceivableFeeDetailByReceivableFeeId(receivableFeeId); |
| | | |
| | | // 4. 批量保存新的明细列表 |
| | | if (receivableFeeManagement.getReceivableFeeDetailList() != null && !receivableFeeManagement.getReceivableFeeDetailList().isEmpty()) { |
| | | // 设置每个明细的应收费用管理ID |
| | | receivableFeeManagement.getReceivableFeeDetailList().forEach(detail -> { |
| | | detail.setReceivableFeeId(receivableFeeId); |
| | | detail.setUpdateTime(DateUtils.getNowDate()); // 设置更新时间 |
| | | }); |
| | | |
| | | // 调用批量插入方法 |
| | | receivableFeeDetailService.insertReceivableFeeDetailBatch(receivableFeeManagement.getReceivableFeeDetailList()); |
| | | } |
| | | |
| | | return result; |
| | | } |
| | | |
| | | /** |
| | |
| | | // 查询应收费用主表记录 |
| | | List<ReceivableFeeManagement> receivableFeeList = receivableFeeManagementMapper.selectReceivableFeeManagementByIds(ids); |
| | | |
| | | // 检查所有记录是否属于同一个客户 |
| | | if (!receivableFeeList.isEmpty()) { |
| | | Integer firstCustomerId = receivableFeeList.get(0).getCustomerId(); |
| | | boolean allSameCustomer = receivableFeeList.stream() |
| | | .allMatch(item -> Objects.equals(item.getCustomerId(), firstCustomerId)); |
| | | |
| | | if (!allSameCustomer) { |
| | | throw new ServiceException("所选记录包含不同客户的数据,无法进行统计"); |
| | | } |
| | | } |
| | | |
| | | // 计算单据数量 |
| | | int documentCount = receivableFeeList.size(); |
| | | SysConfig sysConfig = sysConfigMapper.selectConfig(new SysConfig() {{ |
| | |
| | | BigDecimal exchangeRate = new BigDecimal(sysConfig.getConfigValue()); |
| | | BigDecimal totalAmountHkd = totalReceivableAmount.divide(exchangeRate, 2, RoundingMode.HALF_UP); |
| | | |
| | | // 查询应收费用明细 |
| | | List<ReceivableFeeDetail> detailList = receivableFeeDetailService.selectReceivableFeeDetailByReceivableFeeIds(ids); |
| | | |
| | | |
| | | // 组装返回结果 |
| | | ReceivableFeeStatisticsVo result = new ReceivableFeeStatisticsVo(); |
| | | result.setDocumentCount(documentCount); |
| | |
| | | result.setTotalReceivableAmount(totalReceivableAmount); |
| | | result.setTotalAmountRmb(totalReceivableAmount); |
| | | result.setTotalAmountHkd(totalAmountHkd); |
| | | result.setDetailList(detailList); |
| | | result.setIds(ids); |
| | | |
| | | return result; |
| | | } |
| | |
| | | ReceivableBillManagement billManagement = new ReceivableBillManagement(); |
| | | billManagement.setDocumentCount(statisticsVo.getDocumentCount()); |
| | | billManagement.setExchangeRate(statisticsVo.getRate()); |
| | | billManagement.setStatus("DRAFT"); // 默认草稿状态 |
| | | billManagement.setStatus("0"); // 默认草稿状态 |
| | | billManagement.setCreateTime(DateUtils.getNowDate()); |
| | | |
| | | billManagement.setBillName(billCreateVo.getBillName()); |
| | | billManagement.setCustomerName(billCreateVo.getCustomerName()); |
| | | billManagement.setIsInternalSettlement(billCreateVo.getIsInternalSettlement()); |
| | | billManagement.setInternalSettlementUnit(billCreateVo.getInternalSettlementUnit()); |
| | | // 3. 根据账单类型设置币种和总金额 |
| | | if (billType == 0) { |
| | | // 人民币账单 |
| | |
| | | } else { |
| | | throw new IllegalArgumentException("无效的账单类型:" + billType); |
| | | } |
| | | |
| | | String noByKey = systemDataNoService.getNoByKey(SystemDataNoEnum.YSZD); |
| | | billManagement.setSystemNo(noByKey); |
| | | // 4. 保存主账单记录 |
| | | receivableBillManagementService.insertReceivableBillManagement(billManagement); |
| | | Integer billId = billManagement.getId(); |
| | | int i = receivableBillManagementService.insertReceivableBillManagement(billManagement); |
| | | |
| | | // 5. 创建应收账单结算明细 |
| | | List<ReceivableBillSettlementDetail> detailList = new java.util.ArrayList<>(); |
| | | for (ReceivableFeeDetail feeDetail : statisticsVo.getDetailList()) { |
| | | ReceivableBillSettlementDetail settlementDetail = new ReceivableBillSettlementDetail(); |
| | | settlementDetail.setBillId(billId); |
| | | // 5. 更新应收费用主表的关联账单编号 |
| | | if (statisticsVo.getIds() != null && statisticsVo.getIds().length > 0) { |
| | | // 获取生成的账单系统编号 |
| | | String billSystemNo = billManagement.getSystemNo(); |
| | | |
| | | // 根据账单类型设置明细金额 |
| | | if (billType == 0) { |
| | | // 人民币账单使用原金额 |
| | | settlementDetail.setReceiptAmount(feeDetail.getBillingAmount()); |
| | | } else { |
| | | // 港币账单转换金额 |
| | | settlementDetail.setReceiptAmount(feeDetail.getBillingAmount().divide(statisticsVo.getRate(), 2, RoundingMode.HALF_UP)); |
| | | // 批量更新应收费用主表的关联账单编号 |
| | | for (Integer feeId : statisticsVo.getIds()) { |
| | | ReceivableFeeManagement feeManagement = new ReceivableFeeManagement(); |
| | | feeManagement.setId(feeId); |
| | | feeManagement.setRelatedBillNo(billSystemNo); |
| | | feeManagement.setStatus("1"); |
| | | receivableFeeManagementMapper.updateReceivableFeeManagement(feeManagement); |
| | | } |
| | | |
| | | // 设置其他明细信息 |
| | | settlementDetail.setSettlementMethod("0"); // 默认为空,后续可以更新 |
| | | settlementDetail.setCreateTime(DateUtils.getNowDate()); |
| | | |
| | | detailList.add(settlementDetail); |
| | | // 调用批量更新方法 |
| | | |
| | | } |
| | | |
| | | // 6. 批量保存明细记录 |
| | | if (!detailList.isEmpty()) { |
| | | receivableBillSettlementDetailService.insertReceivableBillSettlementDetailBatch(detailList); |
| | | } |
| | | |
| | | return billId; |
| | | return i; |
| | | } |
| | | } |
| | | } |