更新告警是否允许消失设置

whycxzp

2023-08-11 edf5ff84c8e93f234cc7f360c123fd70848bc32f

更新告警是否允许消失设置

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

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

import com.whyc.dto.Response;
import com.whyc.pojo.AppAlmParam;
import com.whyc.pojo.PageParam;
import com.whyc.service.AppAlmParamService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;
import java.util.Map;

@RestController
@RequestMapping("appAlmParam")
@Api(tags = "告警消失参数设置")
public class AppAlmParamController {

    @Autowired
    private AppAlmParamService service;

    @GetMapping("allList")
    @ApiOperation(value = "查询待添加和已添加参数列表")
    public Response<Map<Integer, List<AppAlmParam>>> getAllList(@RequestParam int categoryId){
        Map<Integer, List<AppAlmParam>> map = service.getAllList(categoryId);
        return new Response<Map<Integer, List<AppAlmParam>>>().set(1,map);
    }

    @PutMapping("list")
    @ApiOperation(value = "添加或者移除参数配置")
    public Response updateList(@RequestParam int operationFlag,@RequestBody List<AppAlmParam> paramList){
        service.updateList(paramList,operationFlag);
        return new Response().setII(1,"更新成功");
    }


}

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

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

import com.whyc.pojo.AppAlmParam;

import java.util.List;

public interface AppAlmParamMapper extends CustomMapper<AppAlmParam>{
    void updateList(List<AppAlmParam> paramList, int operationFlag);

}

 src/main/java/com/whyc/pojo/AppAlmParam.java

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

import com.baomidou.mybatisplus.annotation.TableName;

/**
 * 告警是否允许自动消失参数设置
 */

@TableName(schema = "db_param",value = "tb_appalm_param")
public class AppAlmParam {

    private Integer num;
    private Integer almId;
    private String almName;
    private Integer almCategory;
    private Integer almAutoClearEn;

    public Integer getNum() {
        return num;
    }

    public void setNum(Integer num) {
        this.num = num;
    }

    public Integer getAlmId() {
        return almId;
    }

    public void setAlmId(Integer almId) {
        this.almId = almId;
    }

    public String getAlmName() {
        return almName;
    }

    public void setAlmName(String almName) {
        this.almName = almName;
    }

    public Integer getAlmCategory() {
        return almCategory;
    }

    public void setAlmCategory(Integer almCategory) {
        this.almCategory = almCategory;
    }

    public Integer getAlmAutoClearEn() {
        return almAutoClearEn;
    }

    public void setAlmAutoClearEn(Integer almAutoClearEn) {
        this.almAutoClearEn = almAutoClearEn;
    }
}

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

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

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.whyc.mapper.AppAlmParamMapper;
import com.whyc.pojo.AppAlmParam;
import com.whyc.pojo.PageParam;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

@Service

public class AppAlmParamService {

    @Resource
    private AppAlmParamMapper mapper;


    public Map<Integer, List<AppAlmParam>> getAllList(int categoryId) {
        QueryWrapper<AppAlmParam> wrapper = Wrappers.query();
        wrapper.eq("alm_category",categoryId);
        List<AppAlmParam> pageParamList = mapper.selectList(wrapper);
        return pageParamList.stream().collect(Collectors.groupingBy(AppAlmParam::getAlmAutoClearEn));
    }

    public void updateList(List<AppAlmParam> paramList, int operationFlag) {
        //添加
        mapper.updateList(paramList,operationFlag);
    }
}

 src/main/resources/mapper/AppAlmParamMapper.xml

New file
@@ -0,0 +1,21 @@
<?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.AppAlmParamMapper" >


    <update id="updateList">
        <choose>
            <when test="operationFlag==1">
                <foreach collection="paramList" item="item" separator=";">
                    update db_param.tb_appalm_param set alm_auto_clear_en = 1 where num = #{item.num}
                </foreach>
            </when>
            <otherwise>
                <foreach collection="paramList" item="item" separator=";">
                    update db_param.tb_appalm_param set alm_auto_clear_en = 0 where num = #{item.num}
                </foreach>
            </otherwise>
        </choose>

    </update>
</mapper>

 src/main/resources/mapper/Fbs9100StateMapper.xml

@@ -41,7 +41,7 @@
        GROUP BY tb_fbs9100_state.dev_id
    </select>
    <select id="getList" resultType="com.whyc.pojo.Fbs9100State">
        SELECT distinct 
        SELECT distinct
            dev_id,
            dev_alarmstate,
            dev_workstate,