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.math.BigDecimal; import java.math.RoundingMode; import java.util.*; import java.util.stream.Collectors; @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; @Resource private PublicAccountService publicAccountService; @Override public List queryDataList(CaseDTO caseDTO) { //查看案件关联的用户 List userList = userService.queryListByCaseId(caseDTO.getId()); //查看案件所有的excelData List excelDataEntityList = excelDataService.queryByCaseId(caseDTO); //过滤掉payeeName和payUserName一样的数据 List excelDataEntityList1 = Lists.newArrayList(); for (ExcelDataVO excelDataVO : excelDataEntityList) { if (StringUtils.isNotEmpty(excelDataVO.getPayUserName()) && StringUtils.isNotEmpty(excelDataVO.getPayeeName()) && excelDataVO.getPayUserName().equals(excelDataVO.getPayeeName()) || StringUtils.isEmpty(excelDataVO.getFileId())) { } else { excelDataEntityList1.add(excelDataVO); } } excelDataEntityList1.forEach(excelDataEntity -> { if (StringUtils.isNull(excelDataEntity.getPayUserName())) { excelDataEntity.setPayUserName("无对应人员的数据"); } }); Map> groupedMap = new HashMap<>(); // 调用分组方法 userList.forEach(userName -> groupedMap.put(userName, Lists.newArrayList())); groupByPayUserName(groupedMap, excelDataEntityList1); //初始化集合 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 (Boolean.TRUE.equals(caseEntity.getDrawFlag())) { return loadExistingGraphData(caseDTO.getId()); } else { return processNewGraphData(caseDTO, graph); } } private GraphVO loadExistingGraphData(int caseId) { GraphVO graph = new GraphVO(); graph.setNodes(nodeService.queryByCaseId(caseId)); graph.setEdges(edgeService.queryByCaseId(caseId)); graph.setGroups(groupService.queryByCaseId(caseId)); return graph; } private GraphVO processNewGraphData(CaseDTO caseDTO, GraphVO graph) { // 初始化数据结构 UnionFindVO uf = new UnionFindVO(); Set uniqueUserName = new HashSet<>(); Map edgeMap = new HashMap<>(); Map publicAccountMap = new HashMap<>(); // 配置规则 applyCaseRules(caseDTO); // 查询并过滤数据 List excelDataEntityList = filterExcelData(caseDTO); if (CollUtil.isEmpty(excelDataEntityList)) { return graph; } // 处理原始数据 processRawData(excelDataEntityList, uf, uniqueUserName, edgeMap, publicAccountMap, caseDTO.getId()); // 获取用户标签 Map userAndLabel = getUserLabels(uniqueUserName, caseDTO.getId()); // 添加节点 addNodesToGraph(graph, uniqueUserName, userAndLabel, publicAccountMap); // 过滤有效边 List validEdges = filterValidEdges(edgeMap, uf); graph.setEdges(validEdges); // 计算成员明细 Map memberDetailMap = calculateMemberDetails(validEdges); // 生成团体 generateGroups(graph, uf, memberDetailMap); // 保存数据 saveGraphData(caseDTO.getId(), graph); return graph; } private void applyCaseRules(CaseDTO caseDTO) { 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()); } } private List filterExcelData(CaseDTO caseDTO) { List excelDataEntityList = excelDataService.queryList(caseDTO); if (CollUtil.isEmpty(excelDataEntityList)) { return excelDataEntityList; } // 使用迭代器安全删除 Iterator iterator = excelDataEntityList.iterator(); while (iterator.hasNext()) { ExcelDataEntity excelDataEntity = iterator.next(); // 过滤付款人类型 if (caseDTO.getPrincipal() != null) { if (caseDTO.getPrincipal() == 1 && excelDataEntity.getPayeeName().contains("公司")) { iterator.remove(); continue; } if (caseDTO.getPrincipal() == 2 && !excelDataEntity.getPayeeName().contains("公司")) { iterator.remove(); continue; } } // 过滤金额范围 if (!isWithinAmountRange(excelDataEntity, caseDTO.getMinAmount(), caseDTO.getMaxAmount())) { iterator.remove(); continue; } // 过滤交易次数 if (!isWithinTransactionRange(excelDataEntity, caseDTO.getMinTransaction(), caseDTO.getMaxTransaction())) { iterator.remove(); } } // 白名单过滤 if (caseDTO.getWhiteFlag() != null && caseDTO.getWhiteFlag()) { filterWhite(excelDataEntityList); } return excelDataEntityList; } private boolean isWithinAmountRange(ExcelDataEntity entity, Double min, Double max) { double amount = entity.getAmount(); if (min != null && amount < min) return false; if (max != null && amount > max) return false; return true; } private boolean isWithinTransactionRange(ExcelDataEntity entity, Integer min, Integer max) { int count = entity.getTransactionCount(); if (min != null && count < min) return false; if (max != null && count > max) return false; return true; } private void processRawData(List dataList, UnionFindVO uf, Set uniqueUserName, Map edgeMap, Map publicAccountMap, int caseId) { //查看公共账号的数据 List publicAccountEntityList = publicAccountService.queryByCaseId(caseId); for (ExcelDataEntity excelDataEntity : dataList) { if (StringUtils.isEmpty(excelDataEntity.getPayUserName()) || StringUtils.isEmpty(excelDataEntity.getPayeeName())) { continue; } String payer = excelDataEntity.getPayUserName(); String payee = excelDataEntity.getPayeeName(); double amount = formatAmount(excelDataEntity.getAmount()); uniqueUserName.add(payer); uniqueUserName.add(payee); // 跳过公共账户中的中号 if (isPublicAccount(payer, publicAccountEntityList, publicAccountMap) || isPublicAccount(payee, publicAccountEntityList, publicAccountMap)) { continue; } // 使用UnionFindVO的接口正确添加节点 if (!uf.getParent().containsKey(payer)) { uf.makeSet(payer); } if (!uf.getParent().containsKey(payee)) { uf.makeSet(payee); } // 执行并查集合并 uf.union(payer, payee); // 处理边信息 updateEdgeMap(edgeMap, payer, payee, amount, excelDataEntity, uf); } } private boolean isPublicAccount(String accountName, List publicAccountEntityList, Map publicAccountMap) { boolean result = false; publicAccountMap.put(accountName, result); // 实现您的公共账户识别逻辑 for (PublicAccountEntity publicAccountEntity : publicAccountEntityList) { if (publicAccountEntity.getAccountName().equals(accountName)) { result = true; publicAccountMap.put(accountName, result); } } return result; } private double formatAmount(double amount) { return BigDecimal.valueOf(amount) .setScale(2, RoundingMode.HALF_UP) .doubleValue(); } private void updateEdgeMap(Map edgeMap, String payer, String payee, double amount, ExcelDataEntity entity, UnionFindVO uf) { String edgeKey = payer + "-" + payee; EdgeVO existingEdge = edgeMap.get(edgeKey); // 使用uf.find()获取根节点 String root = uf.find(payer); if (existingEdge != null) { existingEdge.setTotalTransactions(existingEdge.getTotalTransactions() + 1); existingEdge.setTotalAmount(existingEdge.getTotalAmount() + amount); } else { EdgeVO newEdge = new EdgeVO( payer, payee, 1, amount, root, entity.getIp(), entity.getMac(), entity.getPaymentBankName() ); edgeMap.put(edgeKey, newEdge); } } private Map getUserLabels(Set userNameList, int caseId) { List excelDataVOList = userService.queryUserLabel(new ArrayList<>(userNameList), caseId); Map userAndLabel = new HashMap<>(); for (ExcelDataVO vo : excelDataVOList) { userAndLabel.put(vo.getPayUserName(), vo.getLabel()); } return userAndLabel; } private void addNodesToGraph(GraphVO graph, Set uniqueUserName, Map userAndLabel, Map publicAccountMap) { for (String userName : uniqueUserName) { String label = userAndLabel.getOrDefault(userName, ""); boolean publicAccount = publicAccountMap.getOrDefault(userName, false); graph.addNode(new NodeVO(userName, label, publicAccount)); } } private List filterValidEdges(Map edgeMap, UnionFindVO uf) { List validEdges = new ArrayList<>(); Map parent = uf.getParent(); for (EdgeVO edge : edgeMap.values()) { // 检查节点是否在并查集中 if (parent.containsKey(edge.getSource()) && parent.containsKey(edge.getTarget())) { validEdges.add(edge); } } return validEdges; } private Map calculateMemberDetails(List edges) { Map memberDetailMap = new HashMap<>(); for (EdgeVO edge : edges) { String payer = edge.getSource(); String payee = edge.getTarget(); double amount = edge.getTotalAmount(); int transactions = edge.getTotalTransactions(); String ip = edge.getIp(); String mac = edge.getMac(); String account = edge.getAccount(); // 更新付款人明细 GroupDetailEntity payerDetail = memberDetailMap.computeIfAbsent(payer, k -> new GroupDetailEntity(payer)); payerDetail.setIp(ip); payerDetail.setMac(mac); payerDetail.setAccount(account); payerDetail.addOutgoingTransaction(amount); payerDetail.incrementTransactionCount(transactions); // 更新收款人明细 GroupDetailEntity payeeDetail = memberDetailMap.computeIfAbsent(payee, k -> new GroupDetailEntity(payee)); payeeDetail.setIp(ip); payeeDetail.setMac(mac); payeeDetail.setAccount(account); payeeDetail.addIncomingTransaction(amount); payeeDetail.incrementTransactionCount(transactions); } return memberDetailMap; } private void generateGroups(GraphVO graph, UnionFindVO uf, Map memberDetailMap) { // 收集团体成员 Map> groupMembers = new HashMap<>(); Map parent = uf.getParent(); // 遍历所有节点 for (String node : parent.keySet()) { String root = uf.find(node); groupMembers.computeIfAbsent(root, k -> new HashSet<>()).add(node); } // 计算团体统计数据 Map groupTotalAmount = new HashMap<>(); Map groupTotalTransactions = new HashMap<>(); for (Map.Entry> entry : groupMembers.entrySet()) { String groupId = entry.getKey(); for (String member : entry.getValue()) { GroupDetailEntity detail = memberDetailMap.get(member); if (detail != null) { groupTotalAmount.merge(groupId, detail.getTotalAmount(), Double::sum); groupTotalTransactions.merge(groupId, detail.getTransactionCount(), Integer::sum); } } } // 生成团体对象 for (Map.Entry> entry : groupMembers.entrySet()) { String groupId = entry.getKey(); Set members = entry.getValue(); // 团体人数小于3不生成团体 if (members.size() < 3) { 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 )); } } private void saveGraphData(int caseId, GraphVO graph) { disposeUserRelation(caseId, graph.getNodes().stream() .map(NodeVO::getNode) .collect(Collectors.toSet()), graph.getEdges()); nodeService.saveData(caseId, graph.getNodes()); edgeService.saveData(caseId, graph.getEdges()); groupService.saveGroup(caseId, graph.getGroups()); } 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"); userEntity.setUserName(userDTO.getNewName()); userEntity.setSex(userDTO.getSex()); userEntity.setIdCard(userDTO.getIdCard()); userEntity.setBasicInfo(userDTO.getBasicInfo()); userEntity.setAge(userDTO.getAge()); 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) { // 使用Map来统计每个人关联的节点数量 Map nodeDegreeMap = new HashMap<>(); Map nodeAndUser = new HashMap<>(); List excelDataVOList = userService.queryList(caseDTO); List userNameList = new ArrayList<>(); excelDataVOList.forEach(excelDataVO -> userNameList.add(excelDataVO.getPayUserName())); List excelDataEntityList = filterInfoExcelData(caseDTO); // 遍历结果集 for (ExcelDataEntity excelDataEntity : excelDataEntityList) { String payer = excelDataEntity.getPayUserName(); String payee = excelDataEntity.getPayeeName(); if (StringUtils.isEmpty(payee) || StringUtils.isEmpty(payer)) { continue; } // 更新每个人关联的节点数量 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 whiteEntityList = whiteService.queryByNameList(userNameList); Map whiteMap = new HashMap<>(); whiteEntityList.forEach(whiteEntity -> whiteMap.put(whiteEntity.getName(), whiteEntity.getId())); for (ExcelDataVO dataVO : excelDataVOList) { 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 = excelDataVOList.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(); excelDataVOList.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 List filterInfoExcelData(CaseDTO caseDTO) { List excelDataEntityList = excelDataService.queryList(caseDTO); if (CollUtil.isEmpty(excelDataEntityList)) { return excelDataEntityList; } // 使用迭代器安全删除 Iterator iterator = excelDataEntityList.iterator(); while (iterator.hasNext()) { ExcelDataEntity excelDataEntity = iterator.next(); // 过滤付款人类型 if (caseDTO.getNodeType() != null) { if (caseDTO.getNodeType().equals("银联") && excelDataEntity.getPayeeName().contains("公司")) { iterator.remove(); continue; } if (caseDTO.getNodeType().equals("个人") && !excelDataEntity.getPayeeName().contains("公司")) { iterator.remove(); continue; } } // 过滤金额范围 if (!isWithinAmountRange(excelDataEntity, caseDTO.getMinAmount(), caseDTO.getMaxAmount())) { iterator.remove(); continue; } // 过滤交易次数 if (!isWithinTransactionRange(excelDataEntity, caseDTO.getMinTransaction(), caseDTO.getMaxTransaction())) { iterator.remove(); } } // 白名单过滤 if (caseDTO.getWhiteFlag() != null && caseDTO.getWhiteFlag()) { filterWhite(excelDataEntityList); } return excelDataEntityList; } // 检查团体是否有实际连接(非孤立节点) 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); caseRuleConfig.setDirectionFlag(true); return caseRuleConfigService.save(caseRuleConfig); } else { caseDTO.setLastUpdateTime(new Date()); return baseMapper.updateCase(caseDTO); } } }