| | |
|---|
| | | |
|---|
| | | 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; |
|---|
| | |
|---|
| | | @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<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,"读取设备工作状态的切换过程"); |
|---|
| | | } |
|---|
| | | } |
|---|
