package com.whyc.service; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.whyc.dto.Response; import com.whyc.mapper.CentralMonitorSysRTHistoryMapper; import com.whyc.mapper.CentralMonitorSysRTMapper; import com.whyc.mapper.CommonMapper; import com.whyc.pojo.AFERectifierState; import com.whyc.pojo.CentralMonitorSysRT; import org.springframework.stereotype.Service; import org.springframework.web.bind.annotation.RequestParam; import javax.annotation.Resource; import java.util.HashMap; import java.util.LinkedList; import java.util.List; import java.util.Map; @Service public class CentralMonitorSysRTService { @Resource private CentralMonitorSysRTMapper mapper; @Resource private CentralMonitorSysRTHistoryMapper historyMapper; @Resource private CommonMapper commonMapper; public Response getInfoByDevId(int devId) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("dev_id",devId); try{ CentralMonitorSysRT centralMonitorSysRT = mapper.selectOne(queryWrapper); return new Response().set(1,centralMonitorSysRT); }catch (Exception e){ e.printStackTrace(); return new Response().setCode(0); } } public Response> getAll(){ List centralMonitorSysRTS = mapper.selectList(null); return new Response>().set(1,centralMonitorSysRTS); } public Response> getInField() { Map fieldMap = new HashMap(); List fieldNames = new LinkedList(); fieldNames.add("进线屏电压"); fieldNames.add("进线屏电流"); List fieldValues = new LinkedList(); fieldValues.add("panel_vol"); fieldValues.add("panel_curr"); fieldMap.put("fieldNames",fieldNames); fieldMap.put("fieldValues",fieldValues); return new Response>().set(1,fieldMap); } public Response> getOutField() { Map fieldMap = new HashMap(); List fieldNames = new LinkedList(); fieldNames.add("出线屏电流"); List fieldValues = new LinkedList(); fieldValues.add("panel_curr"); fieldMap.put("fieldNames",fieldNames); fieldMap.put("fieldValues",fieldValues); return new Response>().set(1,fieldMap); } /*======History======*/ public Response> getHistory(int pageNum, int pageSize, int devId) { List tableNames = commonMapper.getTableName("db_3.5mw_motor_history", "tb_central_monitor_sys_rt_" + devId); PageHelper.startPage(pageNum,pageSize); List centralMonitorSysRTs = historyMapper.getHistory(tableNames); PageInfo centralMonitorSysRTPageInfo = new PageInfo<>(centralMonitorSysRTs); return new Response>().set(1,centralMonitorSysRTPageInfo); } public Response updateState(int devId, int switchClose) { UpdateWrapper wrapper = Wrappers.update(); wrapper.set("switch_close",switchClose).eq("dev_id",devId); mapper.update(null,wrapper); return new Response().setMsg(1,"更新成功"); } }