电池告警参数设置列表查询

whyclxw

2021-12-15 809111afdd91e43f9aab288533a68e4da3881a1b

电池告警参数设置列表查询

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

@@ -12,17 +12,14 @@

import java.util.List;

@Api(tags = "电池告警参数设置")
@RestController
@RequestMapping("/Alarm_paramAction")
public class AlarmParamController {

    @Autowired
    private AlarmParamService service;


    @ApiOperation("电池告警参数设置--列表查询")
    @PostMapping("/serchByCondition")
    //@ApiOperation("电池告警参数设置--列表查询")
    //@PostMapping("/serchByCondition")
    private Response serchByCondition(@RequestBody List<Integer> AlarmIds){
        return  service.serchByCondition(AlarmIds);
    }

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

@@ -19,7 +19,7 @@

@Api(tags = "电池告警-实时告警")
@RestController
@RequestMapping("/Battalarm_dataAction")
@RequestMapping("Battalarm_dataAction")
public class BattalarmDataController {

    @Autowired

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

@@ -16,7 +16,7 @@

@Api(tags = "电池告警-历史告警")
@RestController
@RequestMapping("/BattalarmDataHistoryAction")
@RequestMapping("BattalarmDataHistoryAction")
public class BattalarmDataHistoryController {

    @Autowired

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

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

import com.whyc.dto.Response;
import com.whyc.service.DevParamService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
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;


@RestController
@Api(tags = "电池告警参数设置")
@RequestMapping("Dev_paramAction")
public class DevParamController {
    @Autowired
    private DevParamService service;

    @ApiOperation("电池告警参数设置--列表查询")
    @GetMapping("/serchByCondition")
    private Response serchByCondition(@RequestParam int devId,@RequestParam int almId){
        return service.serchByCondition(devId,almId);
    }
}

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

@@ -10,7 +10,7 @@

@Api(tags="设备告警-历史告警")
@RestController
@RequestMapping("/DevalarmDataHistoryAction")
@RequestMapping("DevalarmDataHistoryAction")
public class DevalarmDataHistoryController {

    @Autowired

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

@@ -12,7 +12,7 @@

@Api(tags = "电源告警-实时告警")
@RestController
@RequestMapping("/PowerAlarmAction")
@RequestMapping("PowerAlarmAction")
public class PwrdevAlarmController {

    @Autowired

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

@@ -13,7 +13,7 @@

@Api(tags = "电源告警-历史告警")
@RestController
@RequestMapping("/PwrdevAlarmHistoryAction")
@RequestMapping("PwrdevAlarmHistoryAction")
public class PwrdevAlarmHistoryController {

    @Autowired

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

@@ -13,7 +13,7 @@

@RestController
@Api(tags = "通信电源告警规则")
@RequestMapping("/PwrdevAlarmParamAction")
@RequestMapping("PwrdevAlarmParamAction")
public class PwrdevAlarmParamController {
    @Autowired
    private PwrdevAlarmParamService service;

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

@@ -9,7 +9,7 @@

@RestController
@Api(tags = "通讯电源超时告警")
@RequestMapping("/PowerAlarmAdjAction")
@RequestMapping("PowerAlarmAdjAction")
public class PwrdevTimeAdjAlarmController {
    @Autowired
    private PwrdevTimeAdjAlarmService service;

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

@@ -9,7 +9,7 @@

@Api(tags = "通讯电源超时告警")
@RestController
@RequestMapping("/PowerAlarmTimeoutAction")
@RequestMapping("PowerAlarmTimeoutAction")
public class PwrdevTimeOutAlarmController {
    @Autowired
    private PwrdevTimeOutAlarmService service;

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

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

import com.whyc.pojo.DevParam;

import java.util.List;

public interface DevParamMapper extends CustomMapper<DevParam>{
    //电池告警参数设置--列表查询
    List serchByCondition(int devId, int almId);
}

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

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

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.Value;
import lombok.experimental.Accessors;

import java.io.Serializable;

/**
 * <p>
 * 
 * </p>
 *
 * @author lxw
 * @since 2021-12-15
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(schema ="db_param",value = "tb_dev_param")
@ApiModel(value="DevParam对象", description="")
public class DevParam implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId(value = "num", type = IdType.AUTO)
    private Integer num;

    @TableField("dev_Id")
    private Integer devId;

    private Integer almId;

    private String almName;

    private Float almHighCoe;

    private Float almLowCoe;

    private Integer almHighLevel;

    private Integer almLowLevel;

    private Integer almHighEn;

    private Integer almLowEn;

    private String note;

    /**基准值*/
    @TableField(exist = false)
    private Integer monCount;
    @TableField(exist = false)
    private Float monCapStd;
    @TableField(exist = false)
    private Float monVolStd;
    @TableField(exist = false)
    private String baseValue;


}

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

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

import com.github.pagehelper.PageInfo;
import com.whyc.dto.AlarmDaoFactory;
import com.whyc.dto.Response;
import com.whyc.mapper.DevParamMapper;
import com.whyc.pojo.DevParam;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.List;

@Service
public class DevParamService {

    @Resource
    private DevParamMapper mapper;

    //电池告警参数设置--列表查询
    public Response serchByCondition(int devId, int almId) {
        List<DevParam> list=mapper.serchByCondition(devId,almId);
        list.stream().forEach(devParam->{
            switch (devParam.getAlmId()){
                case AlarmDaoFactory.Alarm_vol_Online :
                case AlarmDaoFactory.Alarm_vol_Group :
                    devParam.setBaseValue(String.valueOf(devParam.getMonVolStd()*devParam.getMonCount()));
                    break;
                case AlarmDaoFactory.Alarm_curr_Charge :
                case AlarmDaoFactory.Alarm_curr_Discharge :
                    devParam.setBaseValue(BigDecimal.valueOf(devParam.getMonCapStd()/10).setScale(2,BigDecimal.ROUND_HALF_UP).toString());
                    break;
                case AlarmDaoFactory.Alarm_vol_Monomer :
                case AlarmDaoFactory.ALM_TYPE_DisChargeMonVol_ID :
                    devParam.setBaseValue(String.valueOf(devParam.getMonVolStd()));
                    break;
                case AlarmDaoFactory.Alarm_tmp_Monomer :
                    devParam.setBaseValue("25");
                    break;
                case AlarmDaoFactory.Alarm_res_Monomer :
                    devParam.setBaseValue(BigDecimal.valueOf((1*(devParam.getMonVolStd()/2)/(devParam.getMonCapStd()/100))).setScale(2, RoundingMode.HALF_UP).toString());
                    break;
                case AlarmDaoFactory.Alarm_res_Conn :
                    devParam.setBaseValue("0.2");
                    break;
                case AlarmDaoFactory.ALM_TYPE_MONLYVOL_ID :
                    devParam.setBaseValue("1");
                    break;
            }
        });
        PageInfo pageInfo=new PageInfo(list);
        return  new Response().set(1,list);
    }
}

 src/main/resources/mapper/DevParamMapper.xml

New file
@@ -0,0 +1,27 @@
<?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.DevParamMapper">
    <select id="serchByCondition" resultType="DevParam">
        select distinct(db_param.tb_dev_param.num),dev_id,alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,
        alm_low_level,alm_high_en,alm_low_en,
        db_battinf.tb_battinf.stationname,MonCount,MonCapStd,MonVolStd
        from db_param.tb_dev_param,db_battinf.tb_battinf
        <where>
            db_param.tb_dev_param.dev_id=db_battinf.tb_battinf.FBSDeviceId
            <if test="devId != 0 ">
                and dev_id=#{devId}
            </if>
            <if test="devId == 0 ">
                and dev_id!=0
            </if>
            <if test="almId != 0 ">
                and alm_id=#{almId}
            </if>
            <if test="almId == 0 ">
                and alm_id!=0
            </if>
        </where>
            order by db_param.tb_dev_param.num asc
    </select>

</mapper>