moral.git - Gitblit

			@@ -1,13 +1,35 @@
			package com.moral.api.service.impl;

			import com.moral.api.entity.*;
			import com.moral.api.mapper.ServicesScopeDeviceMapper;
			import com.moral.api.mapper.ServicesScopeMapper;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.stereotype.Service;
			import org.springframework.util.ObjectUtils;

			import java.text.ParseException;
			import java.text.SimpleDateFormat;
			import java.util.ArrayList;
			import java.util.Calendar;
			import java.util.Collections;
			import java.util.Date;
			import java.util.HashMap;
			import java.util.List;
			import java.util.Map;
			import java.util.OptionalDouble;
			import java.util.function.Supplier;
			import java.util.stream.Collectors;
			import java.util.stream.DoubleStream;
			import java.util.stream.Stream;

			import com.alibaba.fastjson.JSONObject;
			import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
			import com.moral.api.config.mybatis.MybatisPlusConfig;
			import com.moral.api.entity.*;
			import com.moral.api.mapper.DeviceMapper;
			import com.moral.api.mapper.HistoryHourlyMapper;
			import com.moral.api.service.HistoryHourlyService;
			import com.moral.api.service.OrganizationService;
			import com.moral.api.service.SensorService;
			import com.moral.api.utils.GetCenterPointFromListOfCoordinates;
			import com.moral.constant.Constants;
			import com.moral.constant.SeparateTableType;
			@@ -16,15 +38,6 @@
			import com.moral.util.DateUtils;
			import com.moral.util.MybatisPLUSUtils;
			import com.moral.util.PollutantUtils;

			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.stereotype.Service;
			import org.springframework.util.ObjectUtils;

			import java.text.ParseException;
			import java.text.SimpleDateFormat;
			import java.util.*;
			import java.util.stream.Collectors;

			/**
			* <p>
			@@ -45,6 +58,12 @@

			@Autowired
			private OrganizationService organizationService;

			@Autowired
			private ServicesScopeMapper servicesScopeMapper;

			@Autowired
			private ServicesScopeDeviceMapper servicesScopeDeviceMapper;

			@Override
			public Map<String, Object> getHourlyAqiByMac(String mac) {
			@@ -403,6 +422,78 @@
			}

			@Override
			public Map<String, Object> getThermodynamicDiagramDataByOrgIdSensorCodeTimeV2(Map<String, Object> parameters) {
			Map<String, Object> resultMap = new HashMap<>();
			int servicesScopeId = Integer.parseInt(parameters.get("servicesScopeId").toString());
			QueryWrapper<ServicesScopeDevice> servicesScopeDeviceQueryWrapper = new QueryWrapper<>();
			servicesScopeDeviceQueryWrapper.eq("is_delete",Constants.NOT_DELETE);
			servicesScopeDeviceQueryWrapper.eq("services_scope_id",servicesScopeId);
			List<ServicesScopeDevice> servicesScopeDevices = servicesScopeDeviceMapper.selectList(servicesScopeDeviceQueryWrapper);
			List<Integer> deviceIds = servicesScopeDevices.stream().map(p -> p.getDeviceId()).collect(Collectors.toList());
			//声明一个list，存放设备mac
			List<String> deviceMacList = new ArrayList<>();
			//声明一个map，Mac作为key，device作为value
			Map<String, Device> deviceMap = new HashMap<>();
			//根据id查询所属设备
			QueryWrapper<Device> wrapper_device = new QueryWrapper<>();
			wrapper_device.eq("is_delete", Constants.NOT_DELETE);
			wrapper_device.in("id",deviceIds);
			List<Device> devices = new ArrayList<>();
			devices = deviceMapper.selectList(wrapper_device);
			if (devices.size() > 0) {
			for (Device device : devices) {
			String mac = device.getMac();
			deviceMacList.add(mac);
			deviceMap.put(mac, device);
			}
			}
			//获取时间
			String time = parameters.get("time").toString().substring(0, 13) + ":00:00";
			resultMap.put("time", time);
			String timeUnits = DateUtils.stringToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN, DateUtils.yyyyMM_EN);
			List<Map<String, Object>> historyHourlyDatas = new ArrayList<>();
			historyHourlyDatas = historyHourlyMapper.selectDataByMacsAndTime(timeUnits, deviceMacList, time);
			List<Object> list = new ArrayList<>();
			for (Map historyHourlyData : historyHourlyDatas) {
			List<Object> list1 = new ArrayList<>();
			String mac = historyHourlyData.get("mac").toString();
			Device device = deviceMap.get(mac);
			double longitude = device.getLongitude();
			double latitude = device.getLatitude();
			JSONObject value = JSONObject.parseObject(historyHourlyData.get("value").toString());
			double num = Double.parseDouble(value.get(parameters.get("sensor_code")).toString());
			int level = PollutantUtils.pollutantLevel(num, (parameters.get("sensor_code")).toString());
			list1.add(longitude);
			list1.add(latitude);
			list1.add(level);
			list.add(list1);
			}
			resultMap.put("list", list);
			ServicesScope servicesScope = servicesScopeMapper.selectById(servicesScopeId);
			String boundary = servicesScope.getBoundary();
			String[] boundary_points = boundary.split(";");
			List boundary_pointList = new ArrayList();
			List bound = new ArrayList();
			for (String boundary_point:boundary_points) {
			List boundary_point_one = new ArrayList();
			String[] boundary_point_one_array = boundary_point.split(",");
			boundary_point_one.add(Double.parseDouble(boundary_point_one_array[0]));
			boundary_point_one.add(Double.parseDouble(boundary_point_one_array[1]));
			boundary_pointList.add(boundary_point_one);
			}
			if (boundary_pointList.size()>0){
			boundary_pointList.add(boundary_pointList.get(0));
			}
			bound.add(boundary_pointList);
			resultMap.put("bound", bound);
			List centerPoint = new ArrayList();
			centerPoint.add(servicesScope.getCenterLongitude());
			centerPoint.add(servicesScope.getCenterLatitude());
			resultMap.put("centerPoint", centerPoint);
			return resultMap;
			}

			@Override
			public List<Map<String, Object>> getThermodynamicDiagramDataByOrgIdSensorCodeTimeslot(Map<String, Object> parameters) {
			int orgId = Integer.parseInt(parameters.get("organization_id").toString());
			//定义一个集合，存放所有id
			@@ -527,6 +618,138 @@
			return list;
			}

			@Override
			public List<Map<String, Object>> getThermodynamicDiagramDataByOrgIdSensorCodeTimeslotV2(Map<String, Object> parameters) {
			int servicesScopeId = Integer.parseInt(parameters.get("servicesScopeId").toString());
			QueryWrapper<ServicesScopeDevice> servicesScopeDeviceQueryWrapper = new QueryWrapper<>();
			servicesScopeDeviceQueryWrapper.eq("is_delete",Constants.NOT_DELETE);
			servicesScopeDeviceQueryWrapper.eq("services_scope_id",servicesScopeId);
			List<ServicesScopeDevice> servicesScopeDevices = servicesScopeDeviceMapper.selectList(servicesScopeDeviceQueryWrapper);
			List<Integer> deviceIds = servicesScopeDevices.stream().map(p -> p.getDeviceId()).collect(Collectors.toList());
			//声明一个list，存放设备mac
			List<String> deviceMacList = new ArrayList<>();
			//声明一个map，Mac作为key，device作为value
			Map<String, Device> deviceMap = new HashMap<>();
			//根据id查询所属设备
			QueryWrapper<Device> wrapper_device = new QueryWrapper<>();
			wrapper_device.eq("is_delete", Constants.NOT_DELETE);
			wrapper_device.in("id",deviceIds);
			List<Device> devices = new ArrayList<>();
			devices = deviceMapper.selectList(wrapper_device);
			if (devices.size() > 0) {
			for (Device device : devices) {
			String mac = device.getMac();
			deviceMacList.add(mac);
			deviceMap.put(mac, device);
			}
			}
			ServicesScope servicesScope = servicesScopeMapper.selectById(servicesScopeId);
			String boundary = servicesScope.getBoundary();
			String[] boundary_points = boundary.split(";");
			List boundary_pointList = new ArrayList();
			List bound = new ArrayList();
			for (String boundary_point:boundary_points) {
			List boundary_point_one = new ArrayList();
			String[] boundary_point_one_array = boundary_point.split(",");
			boundary_point_one.add(Double.parseDouble(boundary_point_one_array[0]));
			boundary_point_one.add(Double.parseDouble(boundary_point_one_array[1]));
			boundary_pointList.add(boundary_point_one);
			}
			if (boundary_pointList.size()>0){
			boundary_pointList.add(boundary_pointList.get(0));
			}
			bound.add(boundary_pointList);
			List centerPoint = new ArrayList();
			centerPoint.add(servicesScope.getCenterLongitude());
			centerPoint.add(servicesScope.getCenterLatitude());
			List<Map<String, Object>> list = new ArrayList<>();
			//获取时间
			SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH");
			String endTime = parameters.get("endTime").toString();
			int hour = Integer.parseInt(parameters.get("hour").toString());
			Date newEndTime = new Date();
			for (int i = hour; i >= 0; i--) {
			Map<String, Object> resultMap = new HashMap<>();
			//先存放中心点和边界点
			resultMap.put("centerPoint", centerPoint);
			resultMap.put("bound", bound);
			Calendar calendar = Calendar.getInstance();
			try {
			newEndTime = df.parse(endTime);
			} catch (ParseException e) {
			e.printStackTrace();
			}
			calendar.setTime(newEndTime);
			calendar.set(Calendar.HOUR_OF_DAY, calendar.get(Calendar.HOUR_OF_DAY) - i);
			String time = df.format(calendar.getTime()) + ":00:00";
			//存放时间
			resultMap.put("time", time);
			String timeUnits = DateUtils.dateToDateString(calendar.getTime(), DateUtils.yyyyMM_EN);
			List<Map<String, Object>> historyHourlyDatas = new ArrayList<>();
			historyHourlyDatas = historyHourlyMapper.selectDataByMacsAndTime(timeUnits, deviceMacList, time);
			List<Object> oneHourlyList = new ArrayList<>();
			for (Map historyHourlyData : historyHourlyDatas) {
			List<Object> list1 = new ArrayList<>();
			String mac = historyHourlyData.get("mac").toString();
			Device device = deviceMap.get(mac);
			double longitude = device.getLongitude();
			double latitude = device.getLatitude();
			JSONObject value = JSONObject.parseObject(historyHourlyData.get("value").toString());
			double num = Double.parseDouble(value.get(parameters.get("sensor_code")).toString());
			int level = PollutantUtils.pollutantLevel(num, (parameters.get("sensor_code")).toString());
			list1.add(longitude);
			list1.add(latitude);
			list1.add(level);
			oneHourlyList.add(list1);
			}
			resultMap.put("list", oneHourlyList);
			list.add(resultMap);
			}
			return list;
			}

			@Override
			public List<Map<String, Object>> getHourCompleteDataByMacSensorCodeDate(Map<String, Object> map) {
			String mac = map.get("mac").toString();
			String sensorCode = map.get("sensor_code").toString();
			String date = map.get("date").toString();
			String dateTime = date.replace("-", "");
			String timeUnits = dateTime.substring(0, 6) + "_complete";
			Map<String, Object> params = new HashMap<>();
			params.put("timeUnits", timeUnits);
			params.put("mac", mac);
			List resultList = new ArrayList();
			for (int i = 0; i < 24; i++) {
			Map<String, Object> oneHourDateMap = new HashMap<>();
			String j;
			if (i < 10) {
			j = " 0" + i + ":00:00";
			} else {
			j = " " + i + ":00:00";
			}
			String time = date + j;
			params.put("time", time);
			String resultTime = time.substring(0, 13);
			if (ObjectUtils.isEmpty(historyHourlyMapper.selectHourlyData(params))) {
			oneHourDateMap.put("time", resultTime);
			oneHourDateMap.put("values", new ArrayList<>());
			resultList.add(oneHourDateMap);
			continue;
			}
			String oneHourlyData = null;
			oneHourlyData = historyHourlyMapper.selectHourlyData(params);
			JSONObject js = JSONObject.parseObject(oneHourlyData);
			String sensorDate = js.get(sensorCode).toString();
			sensorDate = sensorDate.replace("[", "");
			sensorDate = sensorDate.replace("]", "");
			String[] split = sensorDate.split(",");
			oneHourDateMap.put("time", resultTime);
			oneHourDateMap.put("values", split);
			resultList.add(oneHourDateMap);
			}
			return resultList;
			}

			/**
			* @Description: 查询一段时间内某一mac的数据
			* @Param: [mac, startDate, endDate]
			@@ -555,6 +778,73 @@
			return multiTableQuery(queryWrapper, tableNames);
			}

			@Override
			public List<HistoryHourly> getHourlyDataByMacs(List<String> macs, String time) {
			QueryWrapper<HistoryHourly> queryWrapper = new QueryWrapper<>();
			queryWrapper.select("mac","time", "value")
			.likeRight("time", time)
			.in("mac", macs);
			Date date = DateUtils.getDate(time, DateUtils.yyyy_MM_dd_EN);
			List<String> tableNames = MybatisPLUSUtils.getTableNamesByWrapper(date, date, SeparateTableType.MONTH);
			return multiTableQuery(queryWrapper, tableNames);
			}

			@Override
			public Double calculatedValue(List<HistoryHourly> list, String sensorCode, String type, Double lower, Double upper) {
			Supplier<Stream<HistoryHourly>> supplier = list::stream;
			DoubleStream doubleStream = supplier.get()
			.flatMapToDouble(v -> {
			Map<String, Object> dataValue = JSONObject.parseObject(v.getValue(), Map.class);
			Object sensorValue = dataValue.get(sensorCode);

			if (ObjectUtils.isEmpty(sensorValue)) {
			return null;
			}

			//数据有效性判断
			Object flag = dataValue.get(sensorCode + "-" + Constants.MARKER_BIT_KEY);
			if (!Constants.MARKER_BIT_TRUE.equals(flag)) {
			return null;
			}

			double aDouble = Double.parseDouble(sensorValue.toString());

			//剔除超出上下限的数据
			if (!ObjectUtils.isEmpty(lower)) {
			if (aDouble < lower) {
			return null;
			}
			}
			if (!ObjectUtils.isEmpty(upper)) {
			if (aDouble > upper) {
			return null;
			}
			}

			return DoubleStream.of(aDouble);
			});
			Double result = null;
			OptionalDouble optionalDouble = null;
			if ("sum".equals(type)) {
			result = doubleStream.sum();
			} else {
			if ("min".equals(type)) {
			optionalDouble = doubleStream.min();

			} else if ("max".equals(type)) {
			optionalDouble = doubleStream.max();

			} else if ("avg".equals(type)) {
			optionalDouble = doubleStream.average();
			}

			if (optionalDouble.isPresent()) {
			result = optionalDouble.getAsDouble();
			}
			}
			return result;
			}

			/**
			* @Description: 多表查询，传入表名集合，以及条件wrapper，返回数据
			* @Param: [wrapper, tableNames]