添加事件描述

whyclxw

2024-09-04 f878d544e87dfa3396c4bac377cf14895e9de909

添加事件描述

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

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

import com.whyc.pojo.db_lithium_ram_db.WorkstateCfg;

public interface WorkstateCfgMapper extends CustomMapper<WorkstateCfg>{
}

 src/main/java/com/whyc/pojo/db_lithium_ram_db/WorkstateCfg.java

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

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

import java.io.Serializable;

/**
 * <p>
 * 设备工作切换描述配置表
 * </p>
 *
 * @author lxw
 * @since 2024-09-04
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(schema = "db_lithium_ram_db",value ="tb_workstate_cfg")
@ApiModel(value="WorkstateCfg对象", description="设备工作切换描述配置表")
public class WorkstateCfg implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "自增主键")
    @TableId(value = "num", type = IdType.AUTO)
    private Long num;

    @ApiModelProperty(value = "设备类型[1-A200充放电一体机  2-ACTM均衡仪]")
    private Integer devType;

    @ApiModelProperty(value = "上一次工作状态")
    private Integer lastWorkState;

    @ApiModelProperty(value = "当前设备工作状态")
    private Integer nowWorkState;

    @ApiModelProperty(value = "事件描述")
    private String eventStr;


}

 src/main/java/com/whyc/pojo/db_lithium_ram_db/WorkstateChangeevent.java

@@ -1,6 +1,7 @@
package com.whyc.pojo.db_lithium_ram_db;

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 com.fasterxml.jackson.annotation.JsonFormat;
@@ -50,5 +51,7 @@
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date recordTime;


    @ApiModelProperty(value = "事件描述")
    @TableField(exist = false)
    private String eventStr;
}

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

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

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.whyc.dto.Response;
import com.whyc.mapper.WorkstateCfgMapper;
import com.whyc.mapper.WorkstateChangeeventMapper;
import com.whyc.pojo.db_lithium_ram_db.WorkstateCfg;
import com.whyc.pojo.db_lithium_ram_db.WorkstateChangeevent;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -14,13 +16,30 @@
    @Autowired(required = false)
    private WorkstateChangeeventMapper mapper;

    @Autowired(required = false)
    private WorkstateCfgMapper cfgMapper;


    //读取设备工作状态的切换过程
    public Response getWorkEvent(int devId) {
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("dev_id",devId);
        wrapper.orderByDesc("record_time");
        int devType=devId/100000000;
        List<WorkstateChangeevent> list=mapper.selectList(wrapper);
        for (WorkstateChangeevent event:list) {
            QueryWrapper wrapper1=new QueryWrapper();
            wrapper1.eq("dev_type",devType);
            wrapper1.eq("last_work_state",event.getLastWorkState());
            wrapper1.eq("now_work_state",event.getNowWorkState());
            wrapper1.last("limit 1");
            WorkstateCfg cfg=cfgMapper.selectOne(wrapper1);
            if(cfg==null){
                event.setEventStr("---");
            }else{
                event.setEventStr(cfg.getEventStr());
            }
        }
        return new Response().setII(1,list!=null,list,"读取设备工作状态的切换过程");
    }
}