From ad1cb1a11e642ce600d8480b8d3aa6a27f6732f9 Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Wed, 14 Dec 2022 14:06:35 +0800 Subject: [PATCH] 国控站数据维护问题 --- screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java | 91 ++++++++++++++++++++++++++++----------------- 1 files changed, 57 insertions(+), 34 deletions(-) diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java index 973e952..1cd516c 100644 --- a/screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java +++ b/screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java @@ -1,5 +1,6 @@ package com.moral.api.service.impl; +import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; @@ -21,6 +22,7 @@ import com.moral.constant.RedisConstants; import com.moral.util.ConvertUtils; import com.moral.util.DateUtils; +import com.sun.javafx.collections.MappingChange; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; @@ -35,11 +37,9 @@ import java.beans.PropertyDescriptor; import java.lang.reflect.Field; import java.lang.reflect.Method; -import java.util.ArrayList; -import java.util.LinkedHashMap; -import java.util.List; -import java.util.Map; -import java.util.Objects; +import java.lang.reflect.Type; +import java.text.SimpleDateFormat; +import java.util.*; import java.util.stream.Collectors; import javax.servlet.http.HttpServletRequest; @@ -292,14 +292,9 @@ queryWrapper.eq("monitor_point_id", mpId); } - //��������������������� - if (name != null) { - queryWrapper.like("name", name); - } - - //mac������������ - if (mac != null) { - queryWrapper.like("mac", mac); + //���������������mac������������ + if (name != null && mac != null) { + queryWrapper.like("name", name).or().like("mac", mac); } //������������,������create_time������ @@ -353,9 +348,11 @@ //������������ deviceInfo.put("extend", device.getExtend()); + //������������������ + deviceInfo.put("town", device.getTown()); + //������ - deviceInfo.put("profession", device.getProfession()); - deviceInfo.put("professionName", device.getProfessionName()); + deviceInfo.put("professions", device.getProfessions()); //������ deviceInfo.put("tech", device.getTech()); @@ -448,8 +445,9 @@ } @Override - public Map<String, Object> adjustDeviceData(Map<String, Object> deviceData) { - String mac = deviceData.remove("mac").toString(); + public Map<String, Object> adjustDeviceData(Map<String, Object> deviceData,String code) { +// String mac = deviceData.remove("mac").toString(); + String mac = deviceData.get("mac").toString(); //���redis������������������ Map<String, Object> adjustFormula = redisTemplate.opsForHash().entries(RedisConstants.ADJUST + "_" + mac); if (!ObjectUtils.isEmpty(adjustFormula)) { @@ -460,7 +458,7 @@ if (govMpInfo.get("guid") != null) { aqiMap = (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstants.AQI_DATA, govMpInfo.get("guid").toString()); } - return adjustDataUtils.adjust(deviceData, adjustFormula, ObjectUtils.isEmpty(aqiMap) ? null : aqiMap); + return adjustDataUtils.adjust(deviceData, adjustFormula, ObjectUtils.isEmpty(aqiMap) ? null : aqiMap,code); } deviceData.remove("DataTime"); return deviceData; @@ -468,7 +466,8 @@ @Override public Map<String, Object> adjustSpecialDeviceData(Map<String, Object> deviceData) { - String mac = deviceData.remove("mac").toString(); +// String mac = deviceData.remove("mac").toString(); + String mac = deviceData.get("mac").toString(); //���redis������������������ Map<String, Object> adjustFormula = redisTemplate.opsForHash().entries(RedisConstants.ADJUST + "_" + mac); if (!ObjectUtils.isEmpty(adjustFormula)) { @@ -479,7 +478,7 @@ if (ObjectUtils.isEmpty(aqiMap)) { aqiMap = (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstants.AQI_DATA, cityCode); } - return adjustDataUtils.adjust(deviceData, adjustFormula, ObjectUtils.isEmpty(aqiMap) ? null : aqiMap); + return adjustDataUtils.adjust(deviceData, adjustFormula, ObjectUtils.isEmpty(aqiMap) ? null : aqiMap,"0"); } deviceData.remove("DataTime"); return deviceData; @@ -504,19 +503,21 @@ String sensorCode = sensor.getCode(); //������������ String formula = sensor.getFormula(); - //������������������������ - String sensorValue = (String) deviceData.get(sensorCode); - double value = Double.parseDouble(sensorValue); - //������������ - if (formula != null) { - //������������������ - sensorValue = formula.replace("{0}", sensorValue); - expression = AviatorEvaluator.compile(sensorValue); - value = Double.parseDouble(expression.execute().toString()); - } - int sensorState = judgeState(list, value); - if (sensorState > state) { - state = sensorState; + + //��������������������������������������������������������������� + if (deviceData.get(sensorCode) != null) { + String sensorValue = String.valueOf(deviceData.get(sensorCode)); + double value = Double.parseDouble(sensorValue); + if (formula != null) { + //������������������ + sensorValue = formula.replace("{0}", sensorValue); + expression = AviatorEvaluator.compile(sensorValue); + value = Double.parseDouble(expression.execute().toString()); + } + int sensorState = judgeState(list, value); + if (sensorState > state) { + state = sensorState; + } } } //������������������ @@ -525,13 +526,35 @@ deviceMapper.update(null, updateWrapper); } + @Override + public List<Map<String, Object>> selectMonitorPiontAndDeviceByOrgId(int orgId) { + QueryWrapper<MonitorPoint> monitorPointQueryWrapper = new QueryWrapper<>(); + monitorPointQueryWrapper.eq("is_delete", Constants.NOT_DELETE); + monitorPointQueryWrapper.eq("organization_id", orgId); + List<MonitorPoint> monitorPointList = monitorPointMapper.selectList(monitorPointQueryWrapper); + List<Map<String, Object>> resultList = new ArrayList<>(); + for (MonitorPoint monitorPoint : monitorPointList) { + Map<String, Object> resultMap = new HashMap<>(); + resultMap = JSON.parseObject(JSON.toJSONString(monitorPoint), Map.class); + int mp_id = monitorPoint.getId(); + QueryWrapper<Device> deviceQueryWrapper = new QueryWrapper<>(); + deviceQueryWrapper.eq("is_delete", Constants.NOT_DELETE); + deviceQueryWrapper.eq("monitor_point_id", mp_id); + List<Device> devices = new ArrayList<>(); + devices = deviceMapper.selectList(deviceQueryWrapper); + resultMap.put("devices", devices); + resultList.add(resultMap); + } + return resultList; + } + //��������������������������� private int judgeState(List<Object> levels, Double data) { int state = 1; for (int i = levels.size() - 1; i >= 0; i--) { Double level = Double.parseDouble(levels.get(i).toString()); if (data >= level) { - state = i + 1; + state = i + 2; break; } } -- Gitblit v1.8.0