巡检备忘录

whycxzp

2025-06-11 1442b7f8e471343d86f7989e6916f01fe5cad132

巡检备忘录

 src/main/java/com/whyc/controller/AlarmInspectionController.java

New file
@@ -0,0 +1,36 @@
package com.whyc.controller;

import com.whyc.dto.Response;
import com.whyc.service.AlarmInspectionService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

/**
 * 要实现告警巡检单,创建巡检工单表.
 * 在发生告警的情况下,加入到实时巡检工单表中
 * 在点击某个站点的时候,能列出所有未处理过的实时巡检工单
 * 进行巡检结果提交的时候,选中已处理的巡检工单,对选中的告警进行是否已经消失的校验(还存在则无法提交巡检处理结果),将实时巡检工单的相关记录移入到巡检工单处理表,并删除实时工单内相关内容
 * TODO 有两个定时任务:1.告警产生,加入到巡检实时表,2.告警是否消失,同步到巡检实时表
 */

@RestController
@Api(tags = "告警巡检实时表")
@RequestMapping("alarmInspection")
public class AlarmInspectionController {

    @Autowired
    private AlarmInspectionService service;

    @ApiOperation("查询站点对应的巡检单")
    @GetMapping("")
    public Response getList(@RequestParam Integer stationId){
        return service.getList(stationId);
    }


}

 src/main/java/com/whyc/mapper/AlarmInspectionMapper.java

New file
@@ -0,0 +1,10 @@
package com.whyc.mapper;

import com.whyc.pojo.web_site.AlarmInspection;

import java.util.List;

public interface AlarmInspectionMapper extends CustomMapper<AlarmInspection>{
    List<AlarmInspection> getList(Integer stationId);

}

 src/main/java/com/whyc/pojo/web_site/AlarmInspection.java

New file
@@ -0,0 +1,60 @@
package com.whyc.pojo.web_site;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.whyc.pojo.db_user.Baojigroup;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.ToString;

import java.util.Date;

@ToString
@Data
@TableName(schema = "web_site",value ="tb_alarm_inspection")
@ApiModel("告警巡检实时表")
public class AlarmInspection {

    private Long id;

    private Integer stationId;

    private String stationName;

    private Integer powerId;

    private String powerName;

    private Integer devId;

    private String devName;

    private Integer battGroupId;

    private String battGroupName;
    @ApiModelProperty("告警属于哪种设备.1-电源,2-设备,3-电池")
    private Integer type;

    @ApiModelProperty("告警表内主键id")
    private Long almNum;
    @ApiModelProperty("告警id,其中电池告警中代表alm_signal_id")
    private int almId;

    @ApiModelProperty("电池告警的告警id字段,保留")
    private Integer almIdOrigin;

    private Integer almLevel;
    private Date almStartTime;
    @ApiModelProperty("是否还存在.1-存在,0-不存在")
    private Integer isExist;

    private Date createTime;

    @TableField(exist = false)
    private Baojigroup baoJiGroup;

    @TableField(exist = false)
    private AlarmDiagnosis diagnosis;

}

 src/main/java/com/whyc/service/AlarmInspectionService.java

New file
@@ -0,0 +1,22 @@
package com.whyc.service;

import com.whyc.dto.Response;
import com.whyc.mapper.AlarmInspectionMapper;
import com.whyc.pojo.web_site.AlarmInspection;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service
public class AlarmInspectionService {

    @Resource
    private AlarmInspectionMapper mapper;

    public Response getList(Integer stationId) {
        //需要附加填充 负责班组信息 及 告警诊断信息
        List<AlarmInspection> list = mapper.getList(stationId);
        return new Response().set(1,list);
    }
}

 src/main/resources/mapper/AlarmInspectionMapper.xml

New file
@@ -0,0 +1,72 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.AlarmInspectionMapper" >

    <resultMap id="ResultMap_AlarmInspection" type="com.whyc.pojo.web_site.AlarmInspection">
        <id column="id" property="id" />
        <result column="station_id" property="stationId" />
        <result column="station_name" property="stationName" />
        <result column="power_id" property="powerId" />
        <result column="power_name" property="powerName" />
        <result column="dev_id" property="devId" />
        <result column="dev_name" property="devName" />
        <result column="batt_group_id" property="battGroupId" />
        <result column="batt_group_name" property="battGroupName" />
        <result column="type" property="type" />
        <result column="alm_num" property="almNum" />
        <result column="alm_id" property="almId" />
        <result column="alm_id_origin" property="almIdOrigin" />
        <result column="alm_level" property="almLevel" />
        <result column="is_exist" property="isExist" />
        <result column="alm_start_time" property="almStartTime" />
        <result column="create_time" property="createTime" />
        <association property="baoJiGroup" javaType="com.whyc.pojo.db_user.Baojigroup">
                <id column="baoji_group_id" property="baojiGroupId" />
                <result column="baoji_group_name" property="baojiGroupName" />
        </association>
        <association property="diagnosis" javaType="com.whyc.pojo.web_site.AlarmDiagnosis">
                <result column="alm_name" property="almName" />
                <result column="alm_reason" property="almReason" />
                <result column="alm_solution" property="almSolution" />
                <result column="device_spare_ids" property="deviceSpareIds" />
                <result column="device_spare_names" property="deviceSpareNames" />
        </association>

    </resultMap>

    <select id="getList" resultMap="ResultMap_AlarmInspection">
        select
        ai.id,
        ai.station_id,
        ai.station_name,
        ai.power_id,
        ai.power_name,
        ai.dev_id,
        ai.dev_name,
        ai.batt_group_id,
        ai.batt_group_name,
        ai.type,
        ai.alm_num,
        ai.alm_id,
        ai.alm_id_origin,
        ai.alm_level,
        ai.is_exist,
        ai.alm_start_time,
        ai.create_time,
        bg.baoji_group_id,
        bg.baoji_group_name,
        ad.alm_name,
        ad.alm_reason,
        ad.alm_solution,
        ad.device_spare_ids,
        ad.device_spare_names
        from web_site.tb_alarm_inspection ai,
        web_site.tb_alarm_diagnosis ad,
        db_user.tb_baojigroup bg,
        db_user.tb_baojigroup_power bgp
        where ai.alm_id = ad.alm_id
        and ai.station_id = bgp.station_id
        and bg.baoji_group_id = bgp.baoji_group_id
        and ai.station_id = #{stationId}
    </select>
</mapper>