package com.platform.service.impl; import cn.hutool.core.collection.CollUtil; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.platform.mapper.CaseMapper; import com.platform.model.dto.CaseDTO; import com.platform.model.dto.ExcelDataDTO; import com.platform.model.entity.CaseEntity; import com.platform.model.entity.ExcelDataEntity; import com.platform.model.vo.*; import com.platform.service.CaseService; import com.platform.service.ExcelDataService; import com.platform.utils.StringUtils; import org.apache.commons.compress.utils.Lists; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.*; @Service public class CaseServiceImpl extends ServiceImpl implements CaseService { @Resource private ExcelDataService excelDataService; @Override public List queryDataList(String id) { //查看案件所有的excelData List excelDataEntityList = excelDataService.queryByCaseId(id); excelDataEntityList.forEach(excelDataEntity -> { if (StringUtils.isNull(excelDataEntity.getPayUserName())) { excelDataEntity.setPayUserName("无对应人员的数据"); } }); // 调用分组方法 Map> groupedMap = groupByPayUserName(excelDataEntityList); //初始化集合 List caseVOList = Lists.newArrayList(); //遍历groupedMap for (Map.Entry> entry : groupedMap.entrySet()) { System.out.println("Key: " + entry.getKey() + ", Values: " + entry.getValue()); caseVOList.add(CaseVO.builder().excelDataList(entry.getValue()) .payUserName(entry.getKey()) .build()); } return caseVOList; } @Override public boolean updatePayUser(ExcelDataDTO excelDataDTO) { //查看fileId线管的excelData数据 List excelDataEntityList = excelDataService.queryListByFileId(excelDataDTO.getFileId(), excelDataDTO.getCaseId()); if (CollUtil.isNotEmpty(excelDataEntityList)) { excelDataEntityList.forEach(excelDataEntity -> excelDataEntity.setPayUserName(excelDataDTO.getPayUserName())); } return excelDataService.updateBatchById(excelDataEntityList); } @Override public boolean deleteExcel(String fileId) { return excelDataService.deleteByFileId(fileId); } @Override public boolean updateExcelUse(ExcelDataDTO excelDataDTO) { //查看数据 List excelDataEntityList = excelDataService.queryListByFileId(excelDataDTO.getFileId(), excelDataDTO.getCaseId()); if (CollUtil.isNotEmpty(excelDataEntityList)) { excelDataEntityList.forEach(excelDataEntity -> excelDataEntity.setUseFlag(excelDataDTO.getUseFlag())); } return excelDataService.updateBatchById(excelDataEntityList); } @Override public boolean mergeUser(ExcelDataDTO excelDataDTO) { //查看合并之前的人员数据 //初始化合并后的集合 List mergeList = Lists.newArrayList(); excelDataDTO.getOldPayUserName().forEach(payUserName -> { List excelDataEntityList = excelDataService.queryListByCaseIdAndPayUserName(excelDataDTO.getCaseId(), payUserName); if (CollUtil.isNotEmpty(excelDataEntityList)) { mergeList.addAll(excelDataEntityList); } }); if (CollUtil.isNotEmpty(mergeList)) { mergeList.forEach(excelDataEntity -> excelDataEntity.setPayUserName(excelDataDTO.getNewPayUserName())); excelDataService.updateBatchById(mergeList); } return Boolean.TRUE; } @Override public GraphVO draw(CaseDTO caseDTO) { // 初始化画布 GraphVO graph = new GraphVO(); // 使用并查集来管理团体 UnionFindVO uf = new UnionFindVO(); // 使用Map来存储边的信息,键为payer-payee组合,值为Edge对象 Map edgeMap = new HashMap<>(); // 查看案件所有的人员 List excelDataEntityList = excelDataService.queryList(caseDTO); if (CollUtil.isNotEmpty(excelDataEntityList)) { excelDataEntityList.forEach(excelDataEntity -> { if (StringUtils.isNotEmpty(excelDataEntity.getPayUserName()) && StringUtils.isNotEmpty(excelDataEntity.getPayeeName())) { String payer = excelDataEntity.getPayUserName(); String payee = excelDataEntity.getPayeeName(); double amount = excelDataEntity.getAmount(); // 添加节点到并查集 uf.makeSet(payer); uf.makeSet(payee); // 合并团体 uf.union(payer, payee); // 生成边的唯一标识 String edgeKey = payer + "-" + payee; // 检查是否已经存在这条边 if (edgeMap.containsKey(edgeKey)) { // 如果存在,更新总笔数和总金额 EdgeVO existingEdge = edgeMap.get(edgeKey); existingEdge.setTotalTransactions(existingEdge.getTotalTransactions() + 1); existingEdge.setTotalAmount(existingEdge.getTotalAmount() + amount); } else { // 如果不存在,创建新的边 String edgeId = "line-" + payer + "-" + payee; EdgeVO newEdge = new EdgeVO(edgeId, payer, payee, 1, amount, uf.find(payer)); edgeMap.put(edgeKey, newEdge); } } }); // === 修复1:先完成所有过滤 === Set validNodes = new HashSet<>(); // 有效节点集合 // 节点过滤 for (String node : uf.getParent().keySet()) { if (caseDTO.getPrincipal() != null) { if (caseDTO.getPrincipal() == 1) { if (node.contains("公司") || node.length() > 4) continue; } else { if (!node.contains("公司") || node.length() > 4) continue; } } validNodes.add(node); graph.addNode(new NodeVO(node)); } // 边过滤(同时检查两端节点有效性) for (EdgeVO edge : edgeMap.values()) { // 检查两端节点是否有效 if (!validNodes.contains(edge.getSource()) || !validNodes.contains(edge.getTarget())) { continue; } // 金额/笔数过滤 boolean amountValid = true; if (caseDTO.getMinAmount() != null && caseDTO.getMaxAmount() != null) { amountValid = edge.getTotalAmount() >= caseDTO.getMinAmount() && edge.getTotalAmount() <= caseDTO.getMaxAmount(); } boolean transValid = true; if (caseDTO.getMinTransaction() != null && caseDTO.getMaxTransaction() != null) { transValid = edge.getTotalTransactions() >= caseDTO.getMinTransaction() && edge.getTotalTransactions() <= caseDTO.getMaxTransaction(); } if (amountValid || transValid) { graph.addEdge(edge); } } // === 修复2:基于过滤后数据重建团体 === Map> groupMembers = new HashMap<>(); Map groupTotalAmount = new HashMap<>(); Map groupTotalTransactions = new HashMap<>(); // 步骤1:为每个有效节点创建独立团体 for (String node : validNodes) { String root = uf.find(node); groupMembers.computeIfAbsent(root, k -> new HashSet<>()).add(node); } // 步骤2:仅用有效边更新团体关系 UnionFindVO filteredUf = new UnionFindVO(); // 新建过滤后的并查集 validNodes.forEach(filteredUf::makeSet); for (EdgeVO edge : graph.getEdges()) { filteredUf.union(edge.getSource(), edge.getTarget()); // 更新团体统计 String root = filteredUf.find(edge.getSource()); groupTotalAmount.merge(root, edge.getTotalAmount(), Double::sum); groupTotalTransactions.merge(root, edge.getTotalTransactions(), Integer::sum); } // 步骤3:合并最终团体 for (String node : validNodes) { String newRoot = filteredUf.find(node); String oldRoot = uf.find(node); if (!newRoot.equals(oldRoot)) { // 合并团体 Set members = groupMembers.remove(oldRoot); if (members != null) { groupMembers.computeIfAbsent(newRoot, k -> new HashSet<>()).addAll(members); } } } // === 修复3:生成最终团体对象 === for (Map.Entry> entry : groupMembers.entrySet()) { String groupId = entry.getKey(); Set members = entry.getValue(); // 跳过孤立节点(可选) if (members.size() == 1 && !hasConnections(members, graph)) { continue; } graph.addGroup(new GroupVO( groupId, members.size(), groupTotalAmount.getOrDefault(groupId, 0.0), groupTotalTransactions.getOrDefault(groupId, 0) )); } } return graph; } // 检查团体是否有实际连接(非孤立节点) private boolean hasConnections(Set members, GraphVO graph) { return graph.getEdges().stream() .anyMatch(edge -> members.contains(edge.getSource()) && members.contains(edge.getTarget())); } private Map> groupByPayUserName(List excelDataVOList) { Map> groupedMap = new HashMap<>(); for (ExcelDataVO obj : excelDataVOList) { String key = obj.getPayUserName(); // 获取A字段的值作为键 if (!groupedMap.containsKey(key)) { groupedMap.put(key, new ArrayList<>()); // 如果键不存在,创建一个新的List } groupedMap.get(key).add(obj); // 将对象添加到对应的List中 } return groupedMap; } @Override public List pageCase(CaseDTO caseDTO) { return baseMapper.pageCase(caseDTO); } }