wujianwei
2025-12-23 9f41c41fc1c60e572c137cd93a6b45b0e05f34e2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
package com.ruoyi.cwgl.service.impl;
 
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.*;
 
import com.ruoyi.common.enums.SystemDataNoEnum;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.cwgl.domain.ReceivableFeeDetail;
import com.ruoyi.cwgl.domain.ReceivableFeeManagementLog;
import com.ruoyi.cwgl.domain.vo.ReceivableFeeStatisticsVo;
import com.ruoyi.cwgl.service.*;
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;
import org.springframework.scheduling.annotation.Async;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
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.cwgl.mapper.ReceivableFeeManagementMapper;
import com.ruoyi.cwgl.domain.ReceivableFeeManagement;
import com.ruoyi.cwgl.domain.ReceivableBillManagement;
import com.ruoyi.cwgl.domain.ReceivableBillSettlementDetail;
import com.ruoyi.cwgl.domain.vo.ReceivableBillCreateVo;
import com.ruoyi.common.core.text.Convert;
 
import javax.annotation.Resource;
 
/**
 * 应收费用管理Service业务层处理
 *
 * @author ruoyi
 * @date 2025-12-17
 */
@Service
@Transactional(rollbackFor = Exception.class)
public class ReceivableFeeManagementServiceImpl  extends BaseService<ReceivableFeeManagementMapper, ReceivableFeeManagement> implements IReceivableFeeManagementService
{
    protected final Logger logger = LoggerFactory.getLogger(getClass());
    @Resource
    private ReceivableFeeManagementMapper receivableFeeManagementMapper;
    
    @Autowired
    private IReceivableFeeDetailService receivableFeeDetailService;
 
    @Resource
    private SysConfigMapper sysConfigMapper;
 
    @Autowired
    private IReceivableBillManagementService receivableBillManagementService;
 
 
 
    @Autowired
    ISystemDataNoService systemDataNoService;
 
    @Autowired
    private IReceivableFeeManagementLogService logService;
 
    /**
     * 查询应收费用管理
     *
     * @param id 应收费用管理ID
     * @return 应收费用管理
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public ReceivableFeeManagement selectReceivableFeeManagementById(Integer 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;
    }
 
    /**
     * 查询应收费用管理 记录数
     *
     * @param receivableFeeManagement 应收费用管理
     * @return 应收费用管理集合
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public int selectReceivableFeeManagementCount(ReceivableFeeManagement receivableFeeManagement)
    {
        return receivableFeeManagementMapper.selectReceivableFeeManagementCount(receivableFeeManagement);
    }
 
    /**
     * 查询应收费用管理列表
     *
     * @param receivableFeeManagement 应收费用管理
     * @return 应收费用管理
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public List<ReceivableFeeManagement> selectReceivableFeeManagementList(ReceivableFeeManagement receivableFeeManagement)
    {
        return receivableFeeManagementMapper.selectReceivableFeeManagementList(receivableFeeManagement);
    }
 
    /**
     * 查询应收费用管理列表 异步 导出
     *
     * @param receivableFeeManagement 应收费用管理
     * @param exportKey 导出功能的唯一标识
     * @return 应收费用管理集合
     */
    @DataSource(DataSourceType.SLAVE)
    @Async
    @Override
    public void export(ReceivableFeeManagement receivableFeeManagement,String exportKey) {
 
        super.export(ReceivableFeeManagement.class,exportKey,"receivableFeeManagementData",(pageNum)->{
            PageUtils.startPage(pageNum, Constants.EXPORT_PATE_SIZE);
            return selectReceivableFeeManagementList(receivableFeeManagement);
        });
    }
 
 
    /**
     * 新增应收费用管理
     *
     * @param receivableFeeManagement 应收费用管理
     * @return 结果
     */
    @Override
    public int insertReceivableFeeManagement(ReceivableFeeManagement receivableFeeManagement)
    {
        receivableFeeManagement.setCreateTime(DateUtils.getNowDate());
        String noByKey = systemDataNoService.getNoByKey(SystemDataNoEnum.YS);
        receivableFeeManagement.setSystemNo(noByKey);
 
        // 计算应收金额字符串描述
        if (receivableFeeManagement.getReceivableFeeDetailList() != null && !receivableFeeManagement.getReceivableFeeDetailList().isEmpty()) {
            String receivableAmountStr = calculateReceivableAmountStr(receivableFeeManagement.getReceivableFeeDetailList());
            receivableFeeManagement.setReceivableAmountStr(receivableAmountStr);
        }
 
        // 保存主表信息
        int result = receivableFeeManagementMapper.insertReceivableFeeManagement(receivableFeeManagement);
        
        // 获取主表ID
        Integer receivableFeeId = receivableFeeManagement.getId();
        
        // 批量保存明细列表
        if (receivableFeeManagement.getReceivableFeeDetailList() != null && !receivableFeeManagement.getReceivableFeeDetailList().isEmpty()) {
            // 设置每个明细的应收费用管理ID
            receivableFeeManagement.getReceivableFeeDetailList().forEach(detail -> {
                detail.setReceivableFeeId(receivableFeeId);
                detail.setCreateTime(DateUtils.getNowDate()); // 设置创建时间
            });
            
            // 调用批量插入方法
            receivableFeeDetailService.insertReceivableFeeDetailBatch(receivableFeeManagement.getReceivableFeeDetailList());
        }
        
        // 记录操作日志
        if (result > 0) {
            ReceivableFeeManagementLog log = new ReceivableFeeManagementLog();
            log.setReceivableFeeId(receivableFeeId);
            log.setOperator(SecurityUtils.getUsername());
            log.setOperationTime(DateUtils.getNowDate());
            log.setOperationDesc("新增应收费用管理记录,系统编号:" + receivableFeeManagement.getSystemNo());
            log.setCreateTime(DateUtils.getNowDate());
            logService.insertReceivableFeeManagementLog(log);
        }
        
        return result;
    }
 
    /**
     * 修改应收费用管理
     *
     * @param receivableFeeManagement 应收费用管理
     * @return 结果
     */
    @Override
    public int updateReceivableFeeManagement(ReceivableFeeManagement receivableFeeManagement)
    {
        receivableFeeManagement.setUpdateTime(DateUtils.getNowDate());
        
        // 计算应收金额字符串描述
        if (receivableFeeManagement.getReceivableFeeDetailList() != null && !receivableFeeManagement.getReceivableFeeDetailList().isEmpty()) {
            String receivableAmountStr = calculateReceivableAmountStr(receivableFeeManagement.getReceivableFeeDetailList());
            receivableFeeManagement.setReceivableAmountStr(receivableAmountStr);
        }
        
        // 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());
        }
        
        // 记录操作日志
        if (result > 0) {
            ReceivableFeeManagementLog log = new ReceivableFeeManagementLog();
            log.setReceivableFeeId(receivableFeeId);
            log.setOperator(SecurityUtils.getUsername());
            log.setOperationTime(DateUtils.getNowDate());
            log.setOperationDesc("修改应收费用管理记录,系统编号:" + receivableFeeManagement.getSystemNo());
            log.setCreateTime(DateUtils.getNowDate());
            logService.insertReceivableFeeManagementLog(log);
        }
        
        return result;
    }
 
    /**
     * 作废应收费用管理记录
     *
     * @param id 应收费用管理ID
     * @return 结果
     */
    @Override
    public int voidReceivableFeeManagement(Integer id) {
        // 查询费用管理记录
        ReceivableFeeManagement feeManagement = receivableFeeManagementMapper.selectReceivableFeeManagementById(id);
        if (feeManagement == null) {
            throw new ServiceException("费用管理记录不存在");
        }
        
        // 判断状态是否为0(待生成账单),只有状态为0才能作废
        if (!"0".equals(feeManagement.getStatus())) {
            throw new ServiceException("只有状态为待生成账单的记录才能作废");
        }
        
        // 设置状态为作废(假设用"2"表示作废状态)
        feeManagement.setStatus("2");
        feeManagement.setUpdateTime(DateUtils.getNowDate());
        
        // 更新记录
        int result = receivableFeeManagementMapper.updateReceivableFeeManagement(feeManagement);
        
        // 记录操作日志
        if (result > 0) {
            ReceivableFeeManagementLog log = new ReceivableFeeManagementLog();
            log.setReceivableFeeId(id);
            log.setOperator(SecurityUtils.getUsername());
            log.setOperationTime(DateUtils.getNowDate());
            log.setOperationDesc("作废应收费用管理记录,系统编号:" + feeManagement.getSystemNo());
            log.setCreateTime(DateUtils.getNowDate());
            logService.insertReceivableFeeManagementLog(log);
        }
        
        return result;
    }
 
 
 
    /**
     * 新增应收费用管理[批量]
     *
     * @param receivableFeeManagements 应收费用管理
     * @return 结果
     */
    @Override
    public int insertReceivableFeeManagementBatch(List<ReceivableFeeManagement> receivableFeeManagements)
    {
        int rows = receivableFeeManagementMapper.insertReceivableFeeManagementBatch(receivableFeeManagements);
        return rows;
    }
 
    /**
     * 修改应收费用管理[批量]
     *
     * @param receivableFeeManagements 应收费用管理
     * @return 结果
     */
    @Override
    public int updateReceivableFeeManagementBatch(List<ReceivableFeeManagement> receivableFeeManagements){
        return receivableFeeManagementMapper.updateReceivableFeeManagementBatch(receivableFeeManagements);
    }
 
    /**
     * 删除应收费用管理对象
     *
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    @Override
    public int deleteReceivableFeeManagementByIds(String ids)
    {
        return deleteReceivableFeeManagementByIds(Convert.toIntArray(ids));
    }
 
    /**
     * 删除应收费用管理对象
     *
     *
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    @Override
    public int deleteReceivableFeeManagementByIds(Integer[] ids)
    {
        return receivableFeeManagementMapper.deleteReceivableFeeManagementByIds(ids);
    }
 
    /**
     * 删除应收费用管理信息
     *
     * @param id 应收费用管理ID
     * @return 结果
     */
    @Override
    public int deleteReceivableFeeManagementById(Integer id)
    {
        return receivableFeeManagementMapper.deleteReceivableFeeManagementById(id);
    }
 
    /**
     * 根据应收费用ID数组查询统计信息和明细
     *
     * @param ids 应收费用ID数组
     * @return 包含统计信息和明细的结果
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public ReceivableFeeStatisticsVo getReceivableFeeStatistics(Integer[] ids)
    {
        // 查询应收费用主表记录
        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() {{
            setConfigKey("sys.hk.rmb.rate");
        }});
        // 计算总应收金额
        BigDecimal totalReceivableAmount = receivableFeeList.stream()
                .map(ReceivableFeeManagement::getReceivableAmount)
                .reduce(BigDecimal.ZERO, BigDecimal::add);
        
 
        BigDecimal exchangeRate = new BigDecimal(sysConfig.getConfigValue());
        BigDecimal totalAmountHkd = totalReceivableAmount.divide(exchangeRate, 2, RoundingMode.HALF_UP);
        
 
        // 组装返回结果
        ReceivableFeeStatisticsVo result = new ReceivableFeeStatisticsVo();
        result.setDocumentCount(documentCount);
        result.setRate(exchangeRate);
        result.setTotalReceivableAmount(totalReceivableAmount);
        result.setTotalAmountRmb(totalReceivableAmount);
        result.setTotalAmountHkd(totalAmountHkd);
        result.setIds(ids);
        
        return result;
    }
 
    /**
     * 根据统计数据创建应收账单
     *
     * @param billCreateVo 包含统计数据和账单类型的请求对象
     * @return 创建的应收账单ID
     */
    @Override
    public Integer createReceivableBill(ReceivableBillCreateVo billCreateVo) {
        // 1. 准备数据
        ReceivableFeeStatisticsVo statisticsVo = billCreateVo.getStatisticsData();
        
        // 检查费用管理表的状态,只有状态为0才能创建账单
        Integer[] feeIds = statisticsVo.getIds();
        if (feeIds != null && feeIds.length > 0) {
            for (Integer feeId : feeIds) {
                ReceivableFeeManagement feeManagement = receivableFeeManagementMapper.selectReceivableFeeManagementById(feeId);
                if (feeManagement != null && !"0".equals(feeManagement.getStatus())) {
                    throw new ServiceException("费用记录ID为" + feeId + "的状态不是待生成账单,无法创建账单");
                }
            }
        }
        
        Integer billType = billCreateVo.getBillType();
 
        // 2. 创建应收账单主记录
        ReceivableBillManagement billManagement = new ReceivableBillManagement();
        billManagement.setDocumentCount(statisticsVo.getDocumentCount());
        billManagement.setExchangeRate(statisticsVo.getRate());
        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) {
            // 人民币账单
            billManagement.setCurrency("CNY");
            billManagement.setTotalAmount(statisticsVo.getTotalAmountRmb());
        } else if (billType == 1) {
            // 港币账单
            billManagement.setCurrency("HKD");
            billManagement.setTotalAmount(statisticsVo.getTotalAmountHkd());
        } else {
            throw new IllegalArgumentException("无效的账单类型:" + billType);
        }
        String noByKey = systemDataNoService.getNoByKey(SystemDataNoEnum.YSZD);
        billManagement.setSystemNo(noByKey);
        // 4. 保存主账单记录
        int i = receivableBillManagementService.insertReceivableBillManagement(billManagement);
 
        // 5. 更新应收费用主表的关联账单编号
        if (statisticsVo.getIds() != null && statisticsVo.getIds().length > 0) {
            // 获取生成的账单系统编号
            String billSystemNo = billManagement.getSystemNo();
            
            // 批量更新应收费用主表的关联账单编号
            for (Integer feeId : statisticsVo.getIds()) {
                ReceivableFeeManagement feeManagement = new ReceivableFeeManagement();
                feeManagement.setId(feeId);
                feeManagement.setRelatedBillNo(billSystemNo);
                feeManagement.setStatus("1");
                receivableFeeManagementMapper.updateReceivableFeeManagement(feeManagement);
                
                // 记录操作日志
                ReceivableFeeManagementLog log = new ReceivableFeeManagementLog();
                log.setReceivableFeeId(feeId);
                log.setOperator(SecurityUtils.getUsername());
                log.setOperationTime(DateUtils.getNowDate());
                log.setOperationDesc("生成应收账单,账单编号:" + billSystemNo);
                log.setCreateTime(DateUtils.getNowDate());
                logService.insertReceivableFeeManagementLog(log);
            }
            
            // 调用批量更新方法
 
        }
 
        return i;
    }
 
 
    
    /**
     * 根据关联账单编号批量更新应收费用管理记录
     * 清除关联账单编号并将状态改为0(待生成账单)
     * 
     * @param relatedBillNo 关联账单编号
     * @return 结果
     */
    @Override
    public int updateReceivableFeeManagementByRelatedBillNo(String relatedBillNo) {
        return receivableFeeManagementMapper.updateReceivableFeeManagementByRelatedBillNo(relatedBillNo);
    }
 
    /**
     * 计算应收金额字符串描述
     * 根据明细列表按币种汇总金额,格式如:"200港币100人民币"
     * 
     * @param detailList 应收费用明细列表
     * @return 应收金额字符串描述
     */
    private String calculateReceivableAmountStr(List<ReceivableFeeDetail> detailList) {
        if (detailList == null || detailList.isEmpty()) {
            return "";
        }
        
        // 按币种汇总金额
        Map<String, BigDecimal> currencyAmountMap = new HashMap<>();
        for (ReceivableFeeDetail detail : detailList) {
            String currency = detail.getCurrency();
            BigDecimal billingAmount = detail.getBillingAmount();
            
            if (currency != null && billingAmount != null) {
                currencyAmountMap.merge(currency, billingAmount, BigDecimal::add);
            }
        }
        
        // 构建字符串描述
        StringBuilder sb = new StringBuilder();
        for (Map.Entry<String, BigDecimal> entry : currencyAmountMap.entrySet()) {
            if (sb.length() > 0) {
                sb.append(" ");
            }
            sb.append(entry.getValue().stripTrailingZeros().toPlainString());
            
            // 根据币种显示对应的货币名称
            String currency = entry.getKey();
            if ("CNY".equals(currency)) {
                sb.append("人民币");
            } else if ("HKD".equals(currency)) {
                sb.append("港币");
            } else if ("USD".equals(currency)) {
                sb.append("美元");
            } else {
                sb.append(currency);
            }
        }
        
        return sb.toString();
    }
}