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.whyc.dto.ProcessServerDao; import com.whyc.dto.Response; import com.whyc.mapper.ProcessSurveyMapper; import com.whyc.pojo.db_param.ProcessSurvey; import com.whyc.util.ActionUtil; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; @Service public class ProcessSurveyService { @Resource private ProcessSurveyMapper mapper; /* @Autowired private PageParamService pageParamService;*/ public Response getAll(){ QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.orderByAsc("num"); List list = mapper.selectList(queryWrapper); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); for (ProcessSurvey survey:list) { survey.setProcessName_CN(survey.getNote()); survey.setNote(sdf.format(new Date())); } return new Response().set(1,list,"查询成功"); } public Response updateById(ProcessSurvey survey){ // UpdateWrapper updateWrapper = new UpdateWrapper<>(); // updateWrapper.set("note",survey.getNote()); // updateWrapper.set("outtime",survey.getOutTime()); // updateWrapper.eq("num",survey.getNum()); mapper.updateById(survey); return new Response().set(1,true,"更新成功"); } public Response updateServerFlagOff(ProcessSurvey survey){ UpdateWrapper updateWrapper = new UpdateWrapper<>(); updateWrapper.set("serverflag", ProcessServerDao.PROCESS_OFF); updateWrapper.eq("processName",survey.getProcessName()); updateWrapper.eq("serverflag",ProcessServerDao.PROCESS_TEMP); mapper.update(survey,updateWrapper); return new Response().set(1,true,"更新成功"); } public Response updateServerFlagByName(ProcessSurvey survey){ UpdateWrapper updateWrapper = new UpdateWrapper<>(); updateWrapper.eq("serverName",survey.getServerName()); mapper.update(survey,updateWrapper); return new Response().set(1,true,"更新成功"); } /**更新web平台的运行时间,每5秒更新一次*/ public void updateWebTime() { Date date = new Date(); UpdateWrapper update = Wrappers.update(); update.set("ProcessTime",date).eq("ProcessId",11024); mapper.update((ProcessSurvey) ActionUtil.objeNull,update); } /* public void updateWebStartTimeAndVersion() { PageParam versionParam = pageParamService.getParam(32); Date date = new Date(); UpdateWrapper update = Wrappers.update(); update.set("Process_starttime",date).set("ProcessTime",date).set("ProcessVersion",versionParam.getParam()).eq("ProcessId",11024); mapper.update((ProcessSurvey) ActionUtil.objeNull,update); }*/ public void setUpThreadRestart() { //重启告警线程 --->11002 threadRestart(11002); //重启消峰填谷计划线程--->11019 threadRestart(11019); } private void threadRestart(int processId) { UpdateWrapper update = Wrappers.update(); update.set("ServerFlag",0).eq("ProcessId",processId).ne("ServerFlag",2); mapper.update((ProcessSurvey) ActionUtil.objeNull,update); } //修改告警阈值重启线程 public void setAlmThreadRestart() { //重启告警线程 --->11002 threadRestart(11002); } }