package com.moral.api.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.moral.api.entity.Device; import com.moral.api.entity.Sensor; import com.moral.api.mapper.DeviceMapper; import com.moral.api.service.DeviceService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.moral.constant.Constants; import com.moral.constant.RedisConstants; import com.moral.util.DateUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; /** *

* 设备表 服务实现类 *

* * @author moral * @since 2021-06-28 */ @Service public class DeviceServiceImpl extends ServiceImpl implements DeviceService { @Autowired private DeviceMapper deviceMapper; @Autowired private RedisTemplate redisTemplate; @Override public List getDevicesByMonitorPointId(Integer monitorPointId) { QueryWrapper wrapper = new QueryWrapper(); wrapper.eq("monitor_point_id", monitorPointId); wrapper.eq("is_delete", Constants.NOT_DELETE); return deviceMapper.selectList(wrapper); } @Override public Map getSensorsByMac(Map params) { //设备mac List macs = (List) params.remove("macs"); List> elementLists = new ArrayList<>(); for (String mac : macs) { //从redis中获取设备因子信息 Device device = (Device) redisTemplate.opsForHash().get(RedisConstants.DEVICE_INFO, mac); List sensors = device.getVersion().getSensors(); Map map = new HashMap<>(); for (Sensor sensor : sensors) { String sensorCode = sensor.getCode(); String name = sensor.getName(); map.put(sensorCode, name); } elementLists.add(map); } Map map = elementLists.parallelStream() .filter(elementList -> elementList.size() != 0) .reduce((a, b) -> { a.keySet().retainAll(b.keySet()); return a; }).orElse(new HashMap<>()); return map; } @Override public List> getTrendChartData(Map params) { Object type = params.get("type"); //设备mac List macs = (List) params.remove("macs"); QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.select("mac", "name").in("mac", macs); List devices = deviceMapper.selectList(queryWrapper); //所选时间 List times = (List) params.remove("times"); //因子code String sensorCode = params.get("sensorCode").toString(); String end; String timeUnits; //返回结果集,time=data List> result = new ArrayList<>(); for (String start : times) { if ("day".equals(type)) { end = DateUtils.getDateAddDay(start, 1); timeUnits = "hourly"; } else if ("month".equals(type)) { end = DateUtils.getDateAddMonth(start, 1); timeUnits = "daily"; } else { end = DateUtils.getDateAddYear(start, 1); timeUnits = "monthly"; } params.put("timeUnits", timeUnits); params.put("start", start); params.put("end", end); params.put("macs", macs); params.put("dateFormat", "%Y-%m-%d %H:%i:%s"); //获取多设备指定因子数据 List> list = deviceMapper.getTrendChartData(params); for (String s : DateUtils.getTimeLag(start)) { Map resultMap = new HashMap<>(); resultMap.put("time", s); List> deviceData = new ArrayList<>(); for (Device device : devices) { Map valueMap = new HashMap<>(); valueMap.put("name", device.getName()); valueMap.put("sensorValue", ""); for (Map map : list) { Object time = map.get("time"); Object sensorValue = map.get(sensorCode); Object mac = map.get("mac"); if (s.equals(time) && device.getMac().equals(mac)) { valueMap.put("sensorValue", sensorValue); } } deviceData.add(valueMap); } resultMap.put("deviceData", deviceData); result.add(resultMap); } } return result; } }