package com.whyc.service; 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; import java.util.List; @Service public class WorkStateChangeEventService { @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"); wrapper.last("limit 100"); int devType=devId/100000000; List 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,"读取设备工作状态的切换过程"); } }