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.entity.GroupDetailEntity; import com.platform.model.vo.*; import com.platform.service.CaseService; import com.platform.service.ExcelDataService; import com.platform.service.GroupService; import com.platform.utils.StringUtils; import org.apache.commons.compress.utils.Lists; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.*; import java.util.stream.Collectors; @Service public class CaseServiceImpl extends ServiceImpl implements CaseService { @Resource private ExcelDataService excelDataService; @Resource private GroupService groupService; @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(); // 存储边信息,键为payer-payee组合 Map edgeMap = new HashMap<>(); // 查询案件数据 List excelDataEntityList = excelDataService.queryList(caseDTO); if (CollUtil.isEmpty(excelDataEntityList)) { return graph; // 无数据直接返回空图 } // 第一步:处理原始数据 for (ExcelDataEntity excelDataEntity : excelDataEntityList) { if (StringUtils.isEmpty(excelDataEntity.getPayUserName()) || StringUtils.isEmpty(excelDataEntity.getPayeeName())) { continue; // 跳过无效记录 } String payer = excelDataEntity.getPayUserName(); String payee = excelDataEntity.getPayeeName(); double amount = excelDataEntity.getAmount(); String ip = excelDataEntity.getIp(); String mac = excelDataEntity.getMac(); String account = excelDataEntity.getPaymentBankName(); // 添加到并查集 uf.makeSet(payer); uf.makeSet(payee); uf.union(payer, payee); // 处理边信息 String edgeKey = payer + "-" + payee; EdgeVO existingEdge = edgeMap.get(edgeKey); if (existingEdge != null) { // 更新现有边 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), ip, mac, account); edgeMap.put(edgeKey, newEdge); } } // 第二步:过滤节点 Set validNodes = new HashSet<>(); for (String node : uf.getParent().keySet()) { if (shouldIncludeNode(node, caseDTO)) { validNodes.add(node); graph.addNode(new NodeVO(node)); } } // 第三步:过滤边 List validEdges = new ArrayList<>(); for (EdgeVO edge : edgeMap.values()) { // 检查两端节点是否有效 if (!validNodes.contains(edge.getSource()) || !validNodes.contains(edge.getTarget())) { continue; } // 检查金额过滤条件 if (caseDTO.getMinAmount() != null && caseDTO.getMaxAmount() != null) { if (edge.getTotalAmount() < caseDTO.getMinAmount() || edge.getTotalAmount() > caseDTO.getMaxAmount()) { continue; } } // 检查交易次数过滤条件 if (caseDTO.getMinTransaction() != null && caseDTO.getMaxTransaction() != null) { if (edge.getTotalTransactions() < caseDTO.getMinTransaction() || edge.getTotalTransactions() > caseDTO.getMaxTransaction()) { continue; } } // 添加到有效边集合 validEdges.add(edge); graph.addEdge(edge); } // 第四步:重建过滤后的团体关系 // 创建新的并查集用于过滤后的数据 UnionFindVO filteredUf = new UnionFindVO(); validNodes.forEach(filteredUf::makeSet); // 用于按团体分组统计 Map> groupMembers = new HashMap<>(); Map groupTotalAmount = new HashMap<>(); Map groupTotalTransactions = new HashMap<>(); // 初始化每个节点的团体 for (String node : validNodes) { String root = uf.find(node); groupMembers.computeIfAbsent(root, k -> new HashSet<>()).add(node); } // 处理有效边,更新团体关系 for (EdgeVO edge : validEdges) { // 更新过滤后的并查集 filteredUf.union(edge.getSource(), edge.getTarget()); // 更新团体统计 String originalRoot = uf.find(edge.getSource()); groupTotalAmount.merge(originalRoot, edge.getTotalAmount(), Double::sum); groupTotalTransactions.merge(originalRoot, edge.getTotalTransactions(), Integer::sum); } // 第五步:计算成员明细 Map memberDetailMap = new HashMap<>(); // 初始化所有有效节点的成员明细 for (String node : validNodes) { memberDetailMap.put(node, new GroupDetailEntity(node)); } // 更新成员明细 for (EdgeVO edge : validEdges) { String payer = edge.getSource(); String payee = edge.getTarget(); double amount = edge.getTotalAmount(); String ip = edge.getIp(); String mac = edge.getMac(); String account = edge.getAccount(); // 更新付款人(转出) GroupDetailEntity payerDetail = memberDetailMap.get(payer); if (payerDetail != null) { payerDetail.setIp(ip); payerDetail.setMac(mac); payerDetail.setAccount(account); payerDetail.addOutgoingTransaction(amount); payerDetail.incrementTransactionCount(edge.getTotalTransactions()); } // 更新收款人(转入) GroupDetailEntity payeeDetail = memberDetailMap.get(payee); if (payeeDetail != null) { payeeDetail.setIp(ip); payeeDetail.setMac(mac); payeeDetail.setAccount(account); payeeDetail.addIncomingTransaction(amount); payeeDetail.incrementTransactionCount(edge.getTotalTransactions()); } } // 第六步:处理团体合并(因过滤可能改变团体结构) for (String node : validNodes) { String originalRoot = uf.find(node); String newRoot = filteredUf.find(node); if (!originalRoot.equals(newRoot)) { // 合并团体 Set members = groupMembers.remove(originalRoot); if (members != null) { groupMembers.computeIfAbsent(newRoot, k -> new HashSet<>()).addAll(members); // 合并统计信息 if (groupTotalAmount.containsKey(originalRoot)) { groupTotalAmount.merge(newRoot, groupTotalAmount.get(originalRoot), Double::sum); groupTotalAmount.remove(originalRoot); } if (groupTotalTransactions.containsKey(originalRoot)) { groupTotalTransactions.merge(newRoot, groupTotalTransactions.get(originalRoot), Integer::sum); groupTotalTransactions.remove(originalRoot); } } } } // 第七步:生成团体对象 for (Map.Entry> entry : groupMembers.entrySet()) { String groupId = entry.getKey(); Set members = entry.getValue(); // 跳过孤立节点 if (members.size() == 1 && !hasConnections(members, graph)) { continue; } // 收集成员明细 List memberDetails = new ArrayList<>(); for (String member : members) { GroupDetailEntity detail = memberDetailMap.get(member); if (detail != null) { memberDetails.add(detail); } } // 按用户名排序 memberDetails.sort(Comparator.comparing(GroupDetailEntity::getUserName)); // 添加团体对象 graph.addGroup(new GroupVO( groupId, members.size(), groupTotalAmount.getOrDefault(groupId, 0.0), groupTotalTransactions.getOrDefault(groupId, 0), memberDetails )); } //保存团体数据 groupService.saveGroup(caseDTO.getId(), graph.getGroups()); return graph; } @Override public List info(int caseId) { // 使用Set去重 Set uniqueNodes = new HashSet<>(); // 使用Map来统计每个人关联的节点数量 Map nodeDegreeMap = new HashMap<>(); CaseDTO caseDTO = new CaseDTO(); caseDTO.setId(caseId); List excelDataEntityList = excelDataService.queryList(caseDTO); // 遍历结果集 for (ExcelDataEntity excelDataEntity : excelDataEntityList) { String payer = excelDataEntity.getPayUserName(); String payee = excelDataEntity.getPayeeName(); if (StringUtils.isEmpty(payee) || StringUtils.isEmpty(payer)) { continue; } // 添加节点 uniqueNodes.add(payer); uniqueNodes.add(payee); // 更新每个人关联的节点数量 nodeDegreeMap.put(payer, nodeDegreeMap.getOrDefault(payer, 0) + 1); nodeDegreeMap.put(payee, nodeDegreeMap.getOrDefault(payee, 0) + 1); } //查看每个人的账号类型 List userNameList = new ArrayList<>(uniqueNodes); List excelDataEntityListNew = excelDataService.queryListByPayUserList(userNameList, caseId); //根据用户名分组 List groupedObjects = excelDataEntityListNew.stream() .collect(Collectors.groupingBy(ExcelDataVO::getPayUserName)) .values().stream() .map(list -> list.get(0)) // 保留每组的第一个对象 .collect(Collectors.toList()); groupedObjects.forEach(excelDataVO -> { //获取节点数量 int nodeNum = nodeDegreeMap.get(excelDataVO.getPayUserName()); excelDataVO.setNodeNum(nodeNum); if (excelDataVO.getRemark().contains("微信")) { excelDataVO.setAccountType("微信"); } else if (StringUtils.isNotEmpty(excelDataVO.getExternalChannel())) { excelDataVO.setAccountType("银联"); } }); return groupedObjects; } // 节点过滤逻辑 private boolean shouldIncludeNode(String node, CaseDTO caseDTO) { if (caseDTO.getPrincipal() == null) { return true; // 无过滤条件时包含所有节点 } if (caseDTO.getPrincipal() == 1) { // 过滤掉收款人名称中带有公司的数据 return !(node.contains("公司") || node.length() > 4); } else { // 过滤掉收款人名称中不含公司的数据 return node.contains("公司") || node.length() > 4; } } // 检查团体是否有实际连接(非孤立节点) 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); } }