liding
16 小时以前 2656ae9bce8544d81da66c07aaede5386d6fbebb
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
package com.ruoyi.business.service.impl;
 
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.business.dto.EquipmentUsageDetailDto;
import com.ruoyi.business.entity.EquipmentManagement;
import com.ruoyi.business.entity.EquipmentUsageDetail;
import com.ruoyi.business.entity.EquipmentUsageRecord;
import com.ruoyi.business.mapper.EquipmentManagementMapper;
import com.ruoyi.business.mapper.EquipmentUsageDetailMapper;
import com.ruoyi.business.mapper.EquipmentUsageRecordMapper;
import com.ruoyi.business.service.EquipmentUsageDetailService;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.common.utils.bean.BeanUtils;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Service;
 
import java.util.Collections;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.function.Function;
import java.util.stream.Collectors;
 
/**
 * <p>
 * 设备使用明细表 服务实现类
 * </p>
 *
 * @author ld
 * @since 2025-07-23
 */
@Service
@RequiredArgsConstructor
public class EquipmentUsageDetailServiceImpl extends ServiceImpl<EquipmentUsageDetailMapper, EquipmentUsageDetail> implements EquipmentUsageDetailService {
 
    private final EquipmentUsageDetailMapper equipmentUsageDetailMapper;
 
    private final EquipmentUsageRecordMapper equipmentUsageRecordMapper;
 
    private final EquipmentManagementMapper equipmentManagementMapper;
 
 
    @Override
    public List<EquipmentUsageDetailDto> selectEquipmentUsageDetailList(EquipmentUsageDetailDto equipmentUsageDetailDto) {
        // 必须传递 usageId 参数
        if (equipmentUsageDetailDto.getUsageId() == null) {
            throw new BaseException("请选择使用记录");
        }
 
        // 查询明细列表(不分页)
        LambdaQueryWrapper<EquipmentUsageDetail> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(EquipmentUsageDetail::getUsageId, equipmentUsageDetailDto.getUsageId());
        List<EquipmentUsageDetail> details = equipmentUsageDetailMapper.selectList(queryWrapper);
 
        // 如果没有数据,直接返回空列表
        if (details.isEmpty()) {
            return Collections.emptyList();
        }
 
        // 获取所有关联的 usageId
        List<Long> usageIds = details.stream()
                .map(EquipmentUsageDetail::getUsageId)
                .distinct()
                .collect(Collectors.toList());
 
        // 查询关联的使用记录
        List<EquipmentUsageRecord> usageRecords = equipmentUsageRecordMapper.selectList(
                new LambdaQueryWrapper<EquipmentUsageRecord>()
                        .in(EquipmentUsageRecord::getId, usageIds)
        );
 
        // 获取所有设备ID
        List<Long> equipmentIds = usageRecords.stream()
                .map(EquipmentUsageRecord::getEquipmentId)
                .distinct()
                .collect(Collectors.toList());
 
        // 查询设备信息
        Map<Long, EquipmentManagement> equipmentMap;
        if (!equipmentIds.isEmpty()) {
            equipmentMap = equipmentManagementMapper.selectList(
                    new LambdaQueryWrapper<EquipmentManagement>()
                            .in(EquipmentManagement::getId, equipmentIds)
            ).stream().collect(Collectors.toMap(EquipmentManagement::getId, Function.identity()));
        } else {
            equipmentMap = new HashMap<>();
        }
 
        // 构建 usageId → equipmentId 的映射
        Map<Long, Long> usageIdToEquipmentIdMap = usageRecords.stream()
                .collect(Collectors.toMap(EquipmentUsageRecord::getId, EquipmentUsageRecord::getEquipmentId));
 
        // 转换为 DTO 并填充设备信息
        return details.stream().map(detail -> {
            EquipmentUsageDetailDto detailDto = new EquipmentUsageDetailDto();
            BeanUtils.copyProperties(detail, detailDto);
 
            // 获取关联的设备信息
            Long equipmentId = usageIdToEquipmentIdMap.get(detail.getUsageId());
            if (equipmentId != null && equipmentMap.containsKey(equipmentId)) {
                EquipmentManagement equipment = equipmentMap.get(equipmentId);
                detailDto.setEquipmentNo(equipment.getEquipmentNo());
                detailDto.setEquipmentName(equipment.getEquipmentName());
                detailDto.setSpecification(equipment.getSpecification());
            }
 
            return detailDto;
        }).collect(Collectors.toList());
    }
}