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