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.dto.UserDTO; import com.platform.model.entity.*; import com.platform.model.vo.*; import com.platform.service.*; import com.platform.utils.StringUtils; import org.apache.commons.compress.utils.Lists; import org.springframework.stereotype.Service; import org.springframework.util.ObjectUtils; import javax.annotation.Resource; import java.util.*; @Service public class CaseServiceImpl extends ServiceImpl implements CasesService { @Resource private UserService userService; @Resource private NodeService nodeService; @Resource private EdgeService edgeService; @Resource private WhiteService whiteService; @Resource private ExcelDataService excelDataService; @Resource private GroupService groupService; @Resource private CaseRuleConfigService caseRuleConfigService; @Resource private UserRelationService userRelationService; @Override public List queryDataList(CaseDTO caseDTO) { //查看案件关联的用户 List userList = userService.queryListByCaseId(caseDTO.getId()); //查看案件所有的excelData List excelDataEntityList = excelDataService.queryByCaseId(caseDTO); excelDataEntityList.forEach(excelDataEntity -> { if (StringUtils.isNull(excelDataEntity.getPayUserName())) { excelDataEntity.setPayUserName("无对应人员的数据"); } }); Map> groupedMap = new HashMap<>(); // 调用分组方法 userList.forEach(userName -> groupedMap.put(userName, Lists.newArrayList())); groupByPayUserName(groupedMap, excelDataEntityList); //初始化集合 List caseVOList = Lists.newArrayList(); //遍历groupedMap for (Map.Entry> entry : groupedMap.entrySet()) { List excelDataEntityListNew = entry.getValue(); boolean userFlag = false; if (CollUtil.isNotEmpty(excelDataEntityListNew)) { userFlag = excelDataEntityListNew.get(0).getUserFlag(); } caseVOList.add(CaseVO.builder().excelDataList(excelDataEntityListNew) .payUserName(entry.getKey()) .userFlag(userFlag) .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(); CasesEntity caseEntity = baseMapper.getInfoById(caseDTO.getId()); if (caseEntity == null) { return graph; } if (caseEntity.getDrawFlag()) { //查询数据库数据 List nodeVOList = nodeService.queryByCaseId(caseDTO.getId()); List edgeVOList = edgeService.queryByCaseId(caseDTO.getId()); List groupVOList = groupService.queryByCaseId(caseDTO.getId()); graph.setNodes(nodeVOList); graph.setEdges(edgeVOList); graph.setGroups(groupVOList); } else { // 使用并查集管理团体关系 UnionFindVO uf = new UnionFindVO(); Set uniqueUserName = new HashSet<>(); // 存储边信息,键为payer-payee组合 Map edgeMap = new HashMap<>(); //查看案件是否有配置的规则 CaseRuleConfigEntity caseRuleConfigEntity = caseRuleConfigService.getByCaseId(caseDTO.getId()); if (caseRuleConfigEntity != null) { caseDTO.setMinTransaction(caseRuleConfigEntity.getMinTransaction()); caseDTO.setMaxTransaction(caseRuleConfigEntity.getMaxTransaction()); caseDTO.setMinAmount(caseRuleConfigEntity.getMinAmount()); caseDTO.setMaxAmount(caseRuleConfigEntity.getMaxAmount()); caseDTO.setStartTime(caseRuleConfigEntity.getStartTime()); caseDTO.setEndTime(caseRuleConfigEntity.getEndTime()); caseDTO.setPrincipal(caseRuleConfigEntity.getPrincipal()); caseDTO.setWhiteFlag(caseRuleConfigEntity.isWhiteFlag()); } // 查询案件数据 List excelDataEntityList = excelDataService.queryList(caseDTO); Iterator iterator = excelDataEntityList.iterator(); while (iterator.hasNext()) { ExcelDataEntity excelDataEntity = iterator.next(); if (caseDTO.getPrincipal() != null) { if (caseDTO.getPrincipal() == 1 && excelDataEntity.getPayeeName().contains("公司")) { //移除被付款人是公司 iterator.remove(); // 安全移除元素 } if (caseDTO.getPrincipal() == 2 && !excelDataEntity.getPayeeName().contains("公司")) { //移除被付款人是公司 iterator.remove(); // 安全移除元素 } } } if (caseDTO.getWhiteFlag() != null && caseDTO.getWhiteFlag()) { //过滤白名单 filterWhite(excelDataEntityList); } 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(); uniqueUserName.add(payee); uniqueUserName.add(payer); // 添加到并查集 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 { // 创建新边 EdgeVO newEdge = new EdgeVO(payer, payee, 1, amount, uf.find(payer), ip, mac, account); edgeMap.put(edgeKey, newEdge); } } List userNameList = new ArrayList<>(uniqueUserName); List excelDataEntityListNew = userService.queryUserLabel(userNameList, caseDTO.getId()); Map userAndLabel = new HashMap<>(); excelDataEntityListNew.forEach(excelDataVO -> userAndLabel.put(excelDataVO.getPayUserName(), excelDataVO.getLabel())); // 第二步:过滤节点 Set validNodes = new HashSet<>(); for (String node : uf.getParent().keySet()) { validNodes.add(node); String label = userAndLabel.get(node); graph.addNode(new NodeVO(node, label)); } // 第三步:过滤边 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 )); } //处理付款人与收款人的关系 disposeUserRelation(caseDTO.getId(), validNodes, graph.getEdges()); //保存节点、边数据 nodeService.saveData(caseDTO.getId(), graph.getNodes()); edgeService.saveData(caseDTO.getId(), graph.getEdges()); //保存团体数据 groupService.saveGroup(caseDTO.getId(), graph.getGroups()); } return graph; } private void disposeUserRelation(int caseId, Set validNodes, List edges) { //查看用户关系表 List nodeList = new ArrayList<>(validNodes); List userRelationEntityList = userRelationService.queryListByUserNameList(caseId, nodeList); //查看与节点用户相关的用户关系 edges.forEach(edgeVO -> userRelationEntityList.forEach(userRelationEntity -> { String source = edgeVO.getSource(); String target = edgeVO.getTarget(); String relationSource = userRelationEntity.getUserName(); String relationTarget = userRelationEntity.getOtherName(); if (source.equals(relationSource) && target.equals(relationTarget)) { edgeVO.setRelation(userRelationEntity.getRelationShip()); } })); } private void filterWhite(List excelDataEntityList) { //查看白名单 List whiteUser = whiteService.queryList(); // 如果 name 属性值存在于白名单中,则移除该元素 excelDataEntityList.removeIf(entity -> whiteUser.contains(entity.getPayUserName()) || whiteUser.contains(entity.getPayeeName())); } @Override public Boolean removeBatchCase(List ids) { return baseMapper.removeBatchCase(ids); } @Override public boolean updateUserUse(ExcelDataDTO excelDataDTO) { //查看excelData List excelDataEntityList = excelDataService.queryListByPayUserName(excelDataDTO); excelDataEntityList.forEach(excelDataEntity -> excelDataEntity.setUserFlag(excelDataDTO.getUserFlag())); return excelDataService.updateBatchById(excelDataEntityList); } @Override public boolean updateMerchantToPerson(UserDTO userDTO) { List excelDataEntityList = excelDataService.queryListByPayeeName(userDTO.getOldName(), userDTO.getCaseId()); if (CollUtil.isNotEmpty(excelDataEntityList)) { excelDataEntityList.forEach(excelDataEntity -> excelDataEntity.setPayeeName(userDTO.getNewName())); excelDataService.updateBatchById(excelDataEntityList); } //格局新名查看用户数据 UserEntity userEntity = userService.getByUserName(userDTO.getOldName(), userDTO.getCaseId()); if (userEntity == null) { //新增用户 userEntity = new UserEntity(); userEntity.setUserName(userDTO.getNewName()); userEntity.setSex(userDTO.getSex()); userEntity.setIdCard(userDTO.getIdCard()); userEntity.setBasicInfo(userDTO.getBasicInfo()); userEntity.setAge(userDTO.getAge()); userEntity.setCaseId(userDTO.getCaseId()); userEntity.setType("1"); userService.save(userEntity); }else { userEntity.setType("1"); userService.updateById(userEntity); } return false; } @Override public boolean updateNode(CaseDTO caseDTO) { //查看案例信息 CasesEntity casesEntity = getById((caseDTO.getId())); if (casesEntity == null) { return false; } nodeService.updateBatchById(caseDTO.getNodeList()); //更新案例画布 casesEntity.setDrawFlag(true); return updateById(casesEntity); } @Override public List info(CaseDTO caseDTO) { // 使用Set去重 Set uniqueNodes = new HashSet<>(); // 使用Map来统计每个人关联的节点数量 Map nodeDegreeMap = new HashMap<>(); Map nodeAndUser = new HashMap<>(); List excelDataEntityList = excelDataService.queryInfoList(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); // 更新每个人关联的节点数量 String key = payer + payee; if (nodeAndUser.get(key) == null) { nodeDegreeMap.put(payer, nodeDegreeMap.getOrDefault(payer, 0) + 1); nodeDegreeMap.put(payee, nodeDegreeMap.getOrDefault(payee, 0) + 1); nodeAndUser.put(key, key); } } //查看每个人的账号类型 List userNameList = new ArrayList<>(uniqueNodes); //查看每个人的账号标签 List excelDataEntityListNew = userService.queryUserLabel(userNameList, caseDTO.getId()); //查看是否存在白名单 List whiteEntityList = whiteService.queryByNameList(userNameList); Map whiteMap = new HashMap<>(); whiteEntityList.forEach(whiteEntity -> whiteMap.put(whiteEntity.getName(), whiteEntity.getId())); for (ExcelDataVO dataVO : excelDataEntityListNew) { for (Map.Entry entry : nodeDegreeMap.entrySet()) { String key = entry.getKey(); Integer value = entry.getValue(); if (dataVO.getPayUserName().equals(key)) { if (key.contains("公司")) { dataVO.setAccountType("银联"); } else { dataVO.setAccountType("个人"); } dataVO.setNodeNum(value); } } Integer whiteId = whiteMap.getOrDefault(dataVO.getPayUserName(), null); dataVO.setWhiteId(whiteId); } Iterator iterator = excelDataEntityListNew.iterator(); while (iterator.hasNext()) { ExcelDataVO excelDataVO = iterator.next(); if (caseDTO.getMinTransaction() != null && caseDTO.getMaxTransaction() != null) { if (excelDataVO.getNodeNum() < caseDTO.getMinTransaction() || excelDataVO.getNodeNum() > caseDTO.getMaxTransaction()) { iterator.remove(); // 安全移除元素 } } if (StringUtils.isNotEmpty(caseDTO.getNodeType())) { if (!excelDataVO.getAccountType().equals(caseDTO.getNodeType())) { iterator.remove(); // 安全移除元素 } } } List result = Lists.newArrayList(); excelDataEntityListNew.forEach(excelDataVO -> { NodeVO org = new NodeVO(); if (excelDataVO.getAccountType().equals("银联")) { org.setNode(excelDataVO.getPayUserName()); org.setNodeNum(excelDataVO.getNodeNum()); org.setBankCode(excelDataVO.getPayeeBankCard()); org.setWhiteId(excelDataVO.getWhiteId()); org.setNodeType("银联"); result.add(org); } else { NodeVO person = new NodeVO(); person.setNode(excelDataVO.getPayUserName()); person.setNodeNum(excelDataVO.getNodeNum()); person.setLabel(excelDataVO.getLabel()); person.setWhiteId(excelDataVO.getWhiteId()); person.setNodeType("个人"); result.add(person); } }); return result; } // 检查团体是否有实际连接(非孤立节点) private boolean hasConnections(Set members, GraphVO graph) { return graph.getEdges().stream() .anyMatch(edge -> members.contains(edge.getSource()) && members.contains(edge.getTarget())); } private Map> groupByPayUserName(Map> groupedMap, List excelDataVOList) { 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); } @Override public Boolean saveOrUpdateCase(CaseDTO caseDTO) { if (ObjectUtils.isEmpty(caseDTO.getId())) { caseDTO.setCreateTime(new Date()); caseDTO.setLastUpdateTime(new Date()); caseDTO.setStatus("1"); save(caseDTO); //新增默认增加规则 CaseRuleConfigEntity caseRuleConfig = new CaseRuleConfigEntity(); caseRuleConfig.setCaseId(caseDTO.getId()); caseRuleConfig.setWhiteFlag(true); return caseRuleConfigService.save(caseRuleConfig); } else { caseDTO.setLastUpdateTime(new Date()); return baseMapper.updateCase(caseDTO); } } }