moral.git - Gitblit

			@@ -1,8 +1,10 @@
			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;
			import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
			import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
			import com.googlecode.aviator.AviatorEvaluator;
			import com.googlecode.aviator.Expression;
			@@ -12,7 +14,7 @@
			import com.moral.api.service.DeviceService;
			import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

			import com.moral.api.service.GovMonitorPointService;
			import com.moral.api.service.OrganizationService;
			import com.moral.api.service.SysDictDataService;
			import com.moral.api.util.CacheUtils;
			import com.moral.api.util.AdjustDataUtils;
			@@ -21,7 +23,6 @@
			import com.moral.constant.RedisConstants;
			import com.moral.util.ConvertUtils;
			import com.moral.util.DateUtils;

			import lombok.extern.slf4j.Slf4j;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.data.redis.core.RedisTemplate;
			@@ -35,11 +36,10 @@
			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;

			@@ -76,8 +76,6 @@
			@Autowired
			private SysDictDataService sysDictDataService;

			@Autowired
			private LogUtils logUtils;

			@Autowired
			private RedisTemplate redisTemplate;
			@@ -93,6 +91,9 @@

			@Autowired
			private AdjustDataUtils adjustDataUtils;

			@Autowired
			private OrganizationService organizationService;

			/*
			* 从redis获取设备信息
			@@ -136,7 +137,7 @@
			HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
			StringBuilder content = new StringBuilder();
			content.append("添加了设备：").append(device.getName()).append(":").append("mac：").append(mac);
			logUtils.saveOperationForManage(request, content.toString(), Constants.INSERT_OPERATE_TYPE);
			LogUtils.saveOperationForManage(request, content.toString(), Constants.INSERT_OPERATE_TYPE);
			}

			@Override
			@@ -159,7 +160,7 @@
			HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
			StringBuilder content = new StringBuilder();
			content.append("删除了设备：").append(device.getName()).append(";").append("mac：").append(mac);
			logUtils.saveOperationForManage(request, content.toString(), Constants.DELETE_OPERATE_TYPE);
			LogUtils.saveOperationForManage(request, content.toString(), Constants.DELETE_OPERATE_TYPE);
			}

			@Override
			@@ -190,7 +191,7 @@
			//设备信息存入redis
			setDeviceInfoToRedis(mac, deviceInfo);
			//刷新deviceInfo缓存
			CacheUtils.refreshDeviceAlarmInfo();
			CacheUtils.refreshDeviceAlarmInfo(mac);
			//操作日志记录
			HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
			StringBuilder content = new StringBuilder();
			@@ -219,7 +220,7 @@
			}

			}
			logUtils.saveOperationForManage(request, content.toString(), Constants.UPDATE_OPERATE_TYPE);
			LogUtils.saveOperationForManage(request, content.toString(), Constants.UPDATE_OPERATE_TYPE);
			}

			@Override
			@@ -243,8 +244,14 @@

			@Override
			public List<Map<String, Object>> selectMonitorsByOrgId(Integer orgId) {
			//获取所有子组织
			List<Organization> organizations = organizationService.getAllChildrenOrganization(orgId);
			List<Integer> orgIds = organizations.stream().map(Organization::getId).collect(Collectors.toList());
			orgIds.add(orgId);
			QueryWrapper<MonitorPoint> queryWrapper = new QueryWrapper<>();
			queryWrapper.select("id", "name").eq("organization_id", orgId).eq("is_delete", Constants.NOT_DELETE);
			queryWrapper.select("id", "name")
			.eq("is_delete", Constants.NOT_DELETE)
			.in("organization_id", orgIds);
			return monitorPointMapper.selectMaps(queryWrapper);
			}

			@@ -270,9 +277,13 @@
			Object orgId = parameters.get("organizationId");
			Object mpId = parameters.get("monitorPointId");

			//查询某组织下所有设备
			//查询某组织下所有设备,包括子组织
			if (orgId != null) {
			queryWrapper.eq("organization_id", orgId);
			//查询所有子组织
			List<Organization> organizations = organizationService.getAllChildrenOrganization(Integer.parseInt(orgId.toString()));
			List<Integer> orgIds = organizations.stream().map(Organization::getId).collect(Collectors.toList());
			orgIds.add(Integer.parseInt(orgId.toString()));
			queryWrapper.in("organization_id", orgIds);
			}

			//查询某站点下所有设备
			@@ -280,14 +291,10 @@
			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.eq("is_delete", Constants.NOT_DELETE).like("name", name).or().like("mac", mac);
			}

			//排序参数,默认create_time降序
			@@ -300,7 +307,9 @@
			} else {
			queryWrapper.orderByDesc("create_time");
			}
			//过滤已删除的数据
			queryWrapper.eq("is_delete", Constants.NOT_DELETE);

			Page<Device> devicePage = new Page<>(page, size);
			deviceMapper.selectPage(devicePage, queryWrapper);
			List<Device> devices = devicePage.getRecords();
			@@ -341,9 +350,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());
			@@ -436,21 +447,20 @@
			}

			@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)) {
			Map<String, Object> deviceInfo = getDeviceByMac(mac);
			Map<String, Object> monitorPoint = (Map<String, Object>) deviceInfo.get("monitorPoint");
			String areaCode = monitorPoint.get("areaCode").toString();
			String cityCode = monitorPoint.get("cityCode").toString();

			Map<String, Object> aqiMap = (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstants.AQI_DATA, areaCode);
			if (ObjectUtils.isEmpty(aqiMap)) {
			aqiMap = (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstants.AQI_DATA, cityCode);
			//获取设备绑定的国控站信息
			Map<String, Object> govMpInfo = (Map<String, Object>) deviceInfo.get("govMonitorPoint");
			Map<String, Object> aqiMap = null;
			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;
			@@ -458,7 +468,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)) {
			@@ -469,14 +480,13 @@
			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;
			}

			@Override
			@Transactional
			public void judgeDeviceState(Map<String, Object> deviceData) {
			String mac = deviceData.remove("mac").toString();
			Device device = (Device) redisTemplate.opsForHash().get(RedisConstants.DEVICE_INFO, mac);
			@@ -494,25 +504,50 @@
			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;
			}
			}
			}
			//修改设备状态
			UpdateWrapper<Device> updateWrapper = new UpdateWrapper<>();
			updateWrapper.eq("id", device.getId()).set("state", String.valueOf(state));
			deviceMapper.update(null, updateWrapper);
			Device device1 = new Device();
			device1.setId(device.getId());
			device1.setState(String.valueOf(state));
			deviceMapper.updateById(device1);
			}

			@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;
			}

			//根据因子值判断状态
			@@ -521,7 +556,7 @@
			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;
			}
			}
			@@ -529,12 +564,12 @@
			}

			/**
			* @Description: 判断组织是否含有该设备的型号，如果没有则添加到组织型号关系表中
			* @Param: [orgId, versionId]
			* @return: void
			* @Author: 陈凯裕
			* @Date: 2021/9/6
			*/
			* @Description: 判断组织是否含有该设备的型号，如果没有则添加到组织型号关系表中
			* @Param: [orgId, versionId]
			* @return: void
			* @Author: 陈凯裕
			* @Date: 2021/9/6
			*/
			private void insertOrganizationUnitAlarm(Integer orgId, Integer versionId) {
			//查询是否含有该型号
			QueryWrapper<OrganizationUnitAlarm> queryOrganizationVersionWrapper = new QueryWrapper<>();
			@@ -557,7 +592,7 @@
			String sensorCode = versionSensorUnit.getSensorCode();
			//设置默认报警值
			SysDictData alarm = sensorAlarms.get(sensorCode);
			if(alarm!=null)
			if (alarm != null)
			organizationUnitAlarm.setAlarmLevel(alarm.getDataValue());
			organizationUnitAlarm.setOrganizationId(orgId);
			organizationUnitAlarm.setVersionId(versionId);
			@@ -571,12 +606,12 @@
			}

			/**
			* @Description: 删除设备后，如果该组织没有这个设备型号其他的设备了，则删除组织型号关系表中该型号的信息。
			* @Param: [orgId, versionId]
			* @return: void
			* @Author: 陈凯裕
			* @Date: 2021/9/6
			*/
			* @Description: 删除设备后，如果该组织没有这个设备型号其他的设备了，则删除组织型号关系表中该型号的信息。
			* @Param: [orgId, versionId]
			* @return: void
			* @Author: 陈凯裕
			* @Date: 2021/9/6
			*/
			private void deleteOrganizationUnitAlarm(Integer orgId, Integer versionId) {
			QueryWrapper<Device> queryOrganizationVersionWrapper = new QueryWrapper<>();
			queryOrganizationVersionWrapper.eq("organization_id", orgId);
			@@ -592,4 +627,14 @@
			organizationUnitAlarmMapper.update(null, deleteWrapper);
			}
			}

			@Override
			public void setRedisDevice() {
			List<Device> list = lambdaQuery().eq(Device::getIsDelete,0).list();
			for(Device d : list){
			redisTemplate.opsForHash().delete(RedisConstants.DEVICE, d.getMac());
			Map<String, Object> deviceInfo = selectDeviceInfoById(d.getId());
			setDeviceInfoToRedis(d.getMac(), deviceInfo);
			}
			}
			}