From 1442b7f8e471343d86f7989e6916f01fe5cad132 Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期三, 11 六月 2025 19:39:23 +0800
Subject: [PATCH] 巡检备忘录
---
src/main/java/com/whyc/pojo/web_site/AlarmInspection.java | 60 +++++++++++++++
src/main/java/com/whyc/service/AlarmInspectionService.java | 22 +++++
src/main/java/com/whyc/controller/AlarmInspectionController.java | 36 +++++++++
src/main/java/com/whyc/mapper/AlarmInspectionMapper.java | 10 ++
src/main/resources/mapper/AlarmInspectionMapper.xml | 72 ++++++++++++++++++
5 files changed, 200 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/controller/AlarmInspectionController.java b/src/main/java/com/whyc/controller/AlarmInspectionController.java
new file mode 100644
index 0000000..4419b94
--- /dev/null
+++ b/src/main/java/com/whyc/controller/AlarmInspectionController.java
@@ -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);
+ }
+
+
+}
diff --git a/src/main/java/com/whyc/mapper/AlarmInspectionMapper.java b/src/main/java/com/whyc/mapper/AlarmInspectionMapper.java
new file mode 100644
index 0000000..9fa5b5d
--- /dev/null
+++ b/src/main/java/com/whyc/mapper/AlarmInspectionMapper.java
@@ -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);
+
+}
diff --git a/src/main/java/com/whyc/pojo/web_site/AlarmInspection.java b/src/main/java/com/whyc/pojo/web_site/AlarmInspection.java
new file mode 100644
index 0000000..f9edee0
--- /dev/null
+++ b/src/main/java/com/whyc/pojo/web_site/AlarmInspection.java
@@ -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,鍏朵腑鐢垫睜鍛婅涓唬琛╝lm_signal_id")
+ private int almId;
+
+ @ApiModelProperty("鐢垫睜鍛婅鐨勫憡璀d瀛楁,淇濈暀")
+ 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;
+
+}
diff --git a/src/main/java/com/whyc/service/AlarmInspectionService.java b/src/main/java/com/whyc/service/AlarmInspectionService.java
new file mode 100644
index 0000000..3d0c805
--- /dev/null
+++ b/src/main/java/com/whyc/service/AlarmInspectionService.java
@@ -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);
+ }
+}
diff --git a/src/main/resources/mapper/AlarmInspectionMapper.xml b/src/main/resources/mapper/AlarmInspectionMapper.xml
new file mode 100644
index 0000000..55790d4
--- /dev/null
+++ b/src/main/resources/mapper/AlarmInspectionMapper.xml
@@ -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>
\ No newline at end of file
--
Gitblit v1.9.1