package cn.iocoder.yudao.module.mes.service.dv.repair; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.mes.controller.admin.dv.repair.vo.MesDvRepairDiagnosisRespVO; import cn.iocoder.yudao.module.mes.dal.dataobject.collect.MesCollectAlarmDO; import cn.iocoder.yudao.module.mes.dal.dataobject.collect.MesCollectRealtimeDO; import cn.iocoder.yudao.module.mes.dal.dataobject.collect.MesCollectRealtimeHistoryDO; import cn.iocoder.yudao.module.mes.dal.dataobject.dv.machinery.MesDvMachineryDO; import cn.iocoder.yudao.module.mes.dal.mysql.collect.MesCollectAlarmMapper; import cn.iocoder.yudao.module.mes.dal.mysql.collect.MesCollectRealtimeHistoryMapper; import cn.iocoder.yudao.module.mes.dal.mysql.collect.MesCollectRealtimeMapper; import cn.iocoder.yudao.module.mes.service.dv.machinery.MesDvMachineryService; import cn.iocoder.yudao.framework.common.util.json.JsonUtils; import jakarta.annotation.Resource; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; import java.math.BigDecimal; import java.time.Duration; import java.time.LocalDateTime; import java.util.*; import java.util.stream.Collectors; import tools.jackson.core.type.TypeReference; /** * 设备远程诊断。 * *

口径说明:本服务只读取现有数采数据(实时表、状态历史、告警), * 通过采集超时、告警密集度、运行状态异常等信号给出诊断建议; * 结论用于维修工单参考,不替代现场确认,也不推断机械故障原因。 */ @Slf4j @Service public class MesDvRepairDiagnosisService { /** 采集超时阈值(分钟):超过该时长无上报视为通信中断。 */ private static final long COLLECT_TIMEOUT_MINUTES = 5; /** 诊断回看天数。 */ private static final int LOOKBACK_DAYS = 7; /** 密集告警阈值。 */ private static final long ALARM_DENSE_THRESHOLD = 3; @Resource private MesDvMachineryService machineryService; @Resource private MesCollectRealtimeMapper realtimeMapper; @Resource private MesCollectRealtimeHistoryMapper historyMapper; @Resource private MesCollectAlarmMapper alarmMapper; public MesDvRepairDiagnosisRespVO diagnose(Long machineryId) { MesDvMachineryDO machinery = machineryService.getMachinery(machineryId); if (machinery == null) throw cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil .invalidParamException("设备不存在"); var resp = new MesDvRepairDiagnosisRespVO(); resp.setMachineryId(machineryId); resp.setMachineryCode(machinery.getCode()); resp.setMachineryName(machinery.getName()); List evidence = new ArrayList<>(); resp.setEvidence(evidence); // 1. 实时采集状态 MesCollectRealtimeDO realtime = realtimeMapper.selectOne(new LambdaQueryWrapperX() .eq(MesCollectRealtimeDO::getMachineryId, machineryId) .orderByDesc(MesCollectRealtimeDO::getCollectTime) .last("LIMIT 1")); boolean hasData = realtime != null; resp.setHasCollectData(hasData); if (hasData) { resp.setLastCollectTime(realtime.getCollectTime()); resp.setRunStatus(realtime.getSts()); resp.setOperateMode(realtime.getOpm()); resp.setRunTime(realtime.getOt()); resp.setMetrics(parseMetrics(realtime.getDataJson())); boolean timeout = realtime.getCollectTime() == null || Duration.between(realtime.getCollectTime(), LocalDateTime.now()).toMinutes() >= COLLECT_TIMEOUT_MINUTES; resp.setCollectTimeout(timeout); evidence.add(String.format("实时采集:最近上报 %s,状态码 %s,运行模式 %s%s", realtime.getCollectTime(), realtime.getSts(), realtime.getOpm(), timeout ? String.format("(已超过 %d 分钟无更新,判定通信中断)", COLLECT_TIMEOUT_MINUTES) : "")); } else { resp.setCollectTimeout(true); evidence.add("实时采集:该设备无任何采集记录,无法远程判断运行状态"); } // 2. 最近告警 LocalDateTime from = LocalDateTime.now().minusDays(LOOKBACK_DAYS); List alarms = alarmMapper.selectList(new LambdaQueryWrapperX() .eq(MesCollectAlarmDO::getMachineryId, machineryId) .ge(MesCollectAlarmDO::getWmTime, from) .orderByDesc(MesCollectAlarmDO::getWmTime) .last("LIMIT 20")); resp.setRecentAlarmCount((long) alarms.size()); long active = alarms.stream().filter(a -> a.getClearTime() == null).count(); resp.setActiveAlarmCount(active); resp.setRecentAlarms(alarms.stream().map(a -> { var item = new MesDvRepairDiagnosisRespVO.AlarmItem(); item.setId(a.getId()); item.setMessage(a.getWmMsg()); item.setAlarmTime(a.getWmTime()); item.setCleared(a.getClearTime() != null); return item; }).collect(Collectors.toList())); if (!alarms.isEmpty()) { evidence.add(String.format("告警:近 %d 天 %d 条,其中未清除 %d 条", LOOKBACK_DAYS, alarms.size(), active)); } else { evidence.add(String.format("告警:近 %d 天无告警记录", LOOKBACK_DAYS)); } // 3. 状态历史(判断是否频繁启停) List history = historyMapper.selectList( new LambdaQueryWrapperX() .eq(MesCollectRealtimeHistoryDO::getMachineryId, machineryId) .ge(MesCollectRealtimeHistoryDO::getCollectTime, from)); if (!history.isEmpty()) { long distinctStatus = history.stream().map(MesCollectRealtimeHistoryDO::getSts) .filter(Objects::nonNull).distinct().count(); evidence.add(String.format("状态历史:近 %d 天 %d 条采样,出现 %d 种运行状态", LOOKBACK_DAYS, history.size(), distinctStatus)); if (distinctStatus >= 3) evidence.add("状态频繁切换,建议检查启停控制与工艺稳定性"); } // 4. 综合判定 String level; String diagnosis; if (!hasData) { level = "UNKNOWN"; diagnosis = "无采集数据,无法远程诊断。建议现场核查数采网关供电与通讯链路。"; } else if (Boolean.TRUE.equals(resp.getCollectTimeout())) { level = "CRITICAL"; diagnosis = "采集数据已超时,设备可能停机或通讯中断。建议先确认设备是否运行、网关是否在线,再判断是否需要报修。"; } else if (active > 0) { level = "CRITICAL"; diagnosis = String.format("存在 %d 条未清除告警,设备处于异常运行状态。建议按告警信息排查后,再决定维修方案。", active); } else if (alarms.size() >= ALARM_DENSE_THRESHOLD) { level = "WARNING"; diagnosis = String.format("近 %d 天告警 %d 条,虽已清除但发生频繁。建议安排预防性保养,重点检查告警关联部件。", LOOKBACK_DAYS, alarms.size()); } else { level = "NORMAL"; diagnosis = "采集正常且无明显告警,设备运行状态平稳。如现场仍反馈异常,请补充具体现象后再次诊断。"; } resp.setRiskLevel(level); resp.setDiagnosis(diagnosis); return resp; } /** 解析 data_json 中的数值型指标,最多保留 20 项,避免响应过大。 */ Map parseMetrics(String dataJson) { if (dataJson == null || dataJson.isBlank()) return Map.of(); try { Map raw = JsonUtils.parseObjectQuietly(dataJson, new TypeReference>() {}); if (raw == null) return Map.of(); Map result = new LinkedHashMap<>(); for (var e : raw.entrySet()) { if (result.size() >= 20) break; Object v = e.getValue(); if (v instanceof Number n) result.put(e.getKey(), new BigDecimal(n.toString())); else if (v instanceof String s && s.matches("-?\\d+(\\.\\d+)?")) result.put(e.getKey(), new BigDecimal(s)); } return result; } catch (Exception e) { log.debug("解析设备指标失败:{}", e.getMessage()); return Map.of(); } } }