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.DevInfDto;
|
import com.whyc.dto.Response;
|
import com.whyc.mapper.A200RealStateMapper;
|
import com.whyc.mapper.ActmRealStateMapper;
|
import com.whyc.mapper.BattGroupBaojiGroupMapper;
|
import com.whyc.mapper.DevInfMapper;
|
import com.whyc.pojo.db_lithium_ram_db.A200Realstate;
|
import com.whyc.pojo.db_lithium_ram_db.ActmRealstate;
|
import com.whyc.pojo.db_lithium_ram_db.DevInf;
|
import com.whyc.pojo.db_user.BattGroupBaojiGroup;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import java.util.*;
|
import java.util.stream.Collectors;
|
|
@Service
|
public class DevInfService {
|
@Autowired(required = false)
|
private DevInfMapper mapper;
|
|
@Autowired(required = false)
|
private A200RealStateMapper a200Mapper;
|
|
@Autowired(required = false)
|
private ActmRealStateMapper actmMapper;
|
|
@Autowired(required = false)
|
private BattGroupBaojiGroupMapper battBjmapper;
|
|
//添加设备
|
@Transactional
|
public Response addDev(DevInf devInf) {
|
QueryWrapper wrapper=new QueryWrapper();
|
//判断设备类型生成devId
|
int devId=getDevId(devInf.getDevType());
|
devInf.setDevId(devId);
|
devInf.setCreateTime(new Date());
|
int bl=mapper.insert(devInf);
|
if(bl>0){
|
if(devInf.getBaojiIdList()!=null){
|
List<BattGroupBaojiGroup> listBj=new ArrayList<>();
|
for (int baojiId:devInf.getBaojiIdList()) {
|
BattGroupBaojiGroup baojigroup=new BattGroupBaojiGroup();
|
baojigroup.setDevId(devId);
|
baojigroup.setBaojiGroupId(baojiId);
|
listBj.add(baojigroup);
|
}
|
//将设备添加进指定的包机组
|
battBjmapper.insertBatchSomeColumn(listBj);
|
}
|
}
|
return new Response().set(1,bl>0);
|
}
|
//判断设备类型生成devId
|
private int getDevId(Integer devType) {
|
//查询该类型最大设备编号
|
Integer devId=mapper.getMaxDevId(devType);
|
if(devId==null){
|
switch (devType){
|
case 1:devId=100000000;break;
|
case 2:devId=200000000;break;
|
}
|
}
|
return devId+1;
|
}
|
|
//获取所有的设备信息
|
public Response getAllInf(Integer uid, DevInfDto devInfDto) {
|
Map<String, Object> allMap = new HashMap<>();
|
PageHelper.startPage(devInfDto.getPageNum(), devInfDto.getPageSize());
|
devInfDto.setUid(uid);
|
List<DevInf> listype=mapper.getAllInf(devInfDto);
|
PageInfo pageInfo=new PageInfo(listype);
|
|
List<DevInf> list=mapper.getLine(uid);
|
Map<Integer, List<DevInf>> typeDevMap = list.stream().collect(Collectors.groupingBy(DevInf::getDevType));
|
Map<Integer, List<DevInf>> onlineDevMap = list.stream().collect(Collectors.groupingBy(DevInf::getDevOnline));
|
Map<Integer, Object> typeMap = new HashMap<>();
|
typeMap.put(1,0);
|
typeMap.put(2,0);
|
Map<Integer, Object> onlineMap = new HashMap<>();
|
onlineMap.put(0,0);
|
onlineMap.put(1,0);
|
int devSum = list.size();
|
for (Integer type : typeDevMap.keySet()) {
|
typeMap.put(type, typeDevMap.get(type).size());
|
}
|
for (Integer online : onlineDevMap.keySet()) {
|
onlineMap.put(online, onlineDevMap.get(online).size());
|
}
|
allMap.put("type",typeMap);
|
allMap.put("onlineMap",onlineMap);
|
allMap.put("devSum",devSum);
|
allMap.put("pageInfo",pageInfo);
|
|
return new Response().setII(1,listype!=null,allMap,"获取所有的设备信息");
|
}
|
|
//获取左侧列表
|
public Response getDevBytype(Integer devType) {
|
QueryWrapper wrapper=new QueryWrapper();
|
if (devType!=null){
|
wrapper.eq("dev_type",devType);
|
}
|
wrapper.orderByAsc("dev_id");
|
List<DevInf> list=mapper.selectList(wrapper);
|
return new Response().setII(1,list!=null,list,"获取左侧列表");
|
}
|
//获取左侧泪飙
|
public Response getDevType(int uid) {
|
Map<String, Object> allMap = new HashMap<>();
|
List<DevInf> a200List=mapper.getDevType(uid,1);
|
for (DevInf a200:a200List) {
|
QueryWrapper a200wrapper= Wrappers.query();
|
a200wrapper.eq("dev_id",a200.getDevId());
|
a200wrapper.last("limit 1");
|
A200Realstate a200state=a200Mapper.selectOne(a200wrapper);
|
//a200.setA200sTate(a200state);
|
a200.setState(a200state!=null?a200state:null);
|
}
|
List<DevInf> actmList=mapper.getDevType(uid,2);
|
for (DevInf actm:actmList) {
|
QueryWrapper actmwrapper= Wrappers.query();
|
actmwrapper.eq("dev_id",actm.getDevId());
|
List<ActmRealstate> actmstates=actmMapper.selectList(actmwrapper);
|
//actm.setActmsTate(actmstate);
|
actm.setActmstates(actmstates!=null?actmstates:null);
|
}
|
allMap.put("a200List",a200List);
|
allMap.put("actmList",actmList);
|
return new Response().setII(1,allMap.size()>0,allMap,"获取左侧列表");
|
}
|
//编辑设备信息
|
public Response updateInf(DevInf dinf) {
|
//编辑设备就重置加载
|
dinf.setReloadEn(1);
|
UpdateWrapper wrapper=new UpdateWrapper();
|
wrapper.eq("dev_id",dinf.getDevId());
|
int flag=mapper.update(dinf,wrapper);
|
return new Response().set(1,flag>0,"编辑设备信息");
|
}
|
//获取设备信息(不分页用于包机组)
|
public Response getDinf() {
|
QueryWrapper wrapper=new QueryWrapper();
|
wrapper.orderByAsc("dev_id");
|
List<DevInf> list=mapper.selectList(wrapper);
|
return new Response().setII(1,list!=null,list,"获取设备信息(不分页用于包机组)");
|
}
|
|
//根据设备id获取设备信息
|
public Response getDinfById(Integer devId) {
|
QueryWrapper wrapper=new QueryWrapper();
|
wrapper.eq("dev_id",devId);
|
wrapper.last("limit 1");
|
DevInf dinf=mapper.selectOne(wrapper);
|
return new Response().setII(1,dinf!=null,dinf,"根据设备id获取设备信息");
|
}
|
//删除设备(同时删除实时和包机组信息)
|
@Transactional
|
public Response delDinf(Integer devId) {
|
//先删除包机组信息
|
UpdateWrapper baojiWrapper=new UpdateWrapper();
|
baojiWrapper.eq("dev_id",devId);
|
battBjmapper.delete(baojiWrapper);
|
//再删除实时信息
|
if(devId/100000000==1){
|
UpdateWrapper a200Wrapper=new UpdateWrapper();
|
a200Wrapper.eq("dev_id",devId);
|
a200Mapper.delete(a200Wrapper);
|
}else{
|
UpdateWrapper actmWrapper=new UpdateWrapper();
|
actmWrapper.eq("dev_id",devId);
|
actmMapper.delete(actmWrapper);
|
}
|
//最后删除设备信息
|
UpdateWrapper dinfWrapper=new UpdateWrapper();
|
dinfWrapper.eq("dev_id",devId);
|
mapper.delete(dinfWrapper);
|
return new Response().set(1,true,"删除设备(同时删除实时和包机组信息)");
|
}
|
//强制移除批量设备
|
@Transactional
|
public Response cancelContPl(List<Integer> devIds) {
|
for (Integer devId:devIds) {
|
UpdateWrapper wrapper=new UpdateWrapper();
|
wrapper.eq("dev_id",devId);
|
wrapper.set("batch_state",0);
|
mapper.update(null,wrapper);
|
}
|
return new Response().set(1,true,"强制移除批量设备");
|
}
|
//设备分类总数统计
|
public Map<String,Object> getDevStaticByType(int userId) {
|
Map<String,Object> map=new HashMap<>();
|
Map<Integer,Integer> staticTypeMap=new HashMap<>();
|
staticTypeMap.put(1,0);
|
staticTypeMap.put(2,0);
|
|
Map<Integer,Integer> a200staticStateMap=new HashMap<>();
|
a200staticStateMap.put(0,0);
|
a200staticStateMap.put(1,0);
|
Map<Integer,Integer> actmstaticStateMap=new HashMap<>();
|
actmstaticStateMap.put(0,0);
|
actmstaticStateMap.put(1,0);
|
Map<String,Object> typestateMap=new HashMap<>();
|
typestateMap.put("a200",a200staticStateMap);
|
typestateMap.put("actm",actmstaticStateMap);
|
List<DevInf> list=mapper.getDevStaticByType(userId);
|
Map<Integer, List<DevInf>> typeMap = list.stream().collect(Collectors.groupingBy(DevInf::getDevType));
|
for (Integer type : typeMap.keySet()) {
|
staticTypeMap.put(type, typeMap.get(type).size());
|
List<DevInf> typeList= typeMap.get(type);
|
Map<Integer, List<DevInf>> stateMap = typeList.stream().collect(Collectors.groupingBy(DevInf::getDevOnline));
|
if(type==1){
|
for (Integer state : stateMap.keySet()) {
|
a200staticStateMap.put(state, stateMap.get(state).size());
|
}
|
typestateMap.put("a200", a200staticStateMap);
|
}
|
if(type==2){
|
for (Integer state : stateMap.keySet()) {
|
actmstaticStateMap.put(state, stateMap.get(state).size());
|
}
|
typestateMap.put("actm", actmstaticStateMap);
|
}
|
}
|
map.put("dinf",list!=null?list:null);
|
map.put("type",staticTypeMap);
|
map.put("state",typestateMap);
|
return map;
|
}
|
|
//根据devId获取设备信息
|
public DevInf getDinfByDevId(int devId){
|
QueryWrapper wrapper=new QueryWrapper();
|
wrapper.eq("dev_id",devId);
|
wrapper.last("limit 1");
|
DevInf dinf=mapper.selectOne(wrapper);
|
return dinf;
|
}
|
|
}
|
