From 9009798abd7abfd726bcda80267c7d53dd3b8da3 Mon Sep 17 00:00:00 2001 From: ZhuDongming <773644075@qq.com> Date: Wed, 12 Jun 2019 14:33:25 +0800 Subject: [PATCH] Merge branch 'master' of http://blit.7drlb.com:8888/r/screen_api_v2 --- src/main/java/com/moral/service/impl/SensorUnitServiceImpl.java | 28 +++++++++++++ src/main/resources/mapper/SensorUnitMapper.xml | 2 src/main/java/com/moral/controller/ScreenController.java | 44 ++++++++++++++++----- src/main/java/com/moral/service/SensorUnitService.java | 4 + 4 files changed, 64 insertions(+), 14 deletions(-) diff --git a/src/main/java/com/moral/controller/ScreenController.java b/src/main/java/com/moral/controller/ScreenController.java index 41ead21..5b7ffbc 100644 --- a/src/main/java/com/moral/controller/ScreenController.java +++ b/src/main/java/com/moral/controller/ScreenController.java @@ -906,7 +906,7 @@ return new ResultBean<Map<String, Object>>(map); }*/ - @GetMapping("getSensorByMonitorPointId") + /*@GetMapping("getSensorByMonitorPointId") @ApiOperation(value = "������������", notes = "������������") @ApiImplicitParams(value = { @ApiImplicitParam(name = "monitor_point_id", value = "������������id", required = true, paramType = "query", dataType = "String") @@ -918,7 +918,7 @@ Map<String, Object> map = sensorUnitService.getSensorsByMonitPointId(monitor_point_id); System.out.println("ScreenController-----getSensorByMonitorPointId-----map:"+map); return new ResultBean<Map<String, Object>>(map); - } + }*/ @GetMapping("AIForecast") @ApiOperation(value = "AI������", notes = "AI������") @@ -936,19 +936,41 @@ Object sensorKey = parameters.remove("sensorKey"); parameters.put("sensors", Arrays.asList(sensorKey)); List<Map<String, Object>> list = historyMinutelyService.getMonitorPointOrDeviceAvgData(parameters); + System.out.println("ScreenController-----AIForecast-----list:"+list); //������������������ - Map<String, Object> sensorMap = sensorUnitService.getSensorsByMonitPointId(monitor_point_id); + Map<String, Map<String, Object>> sensorMap = sensorUnitService.getSensorsByMonitPointId(monitor_point_id); - for (Map<String, Object> map : list) { - String time = map.get("time").toString(); - time = time.substring(time.length() - 2); - map.put("time", Integer.valueOf(time)); - map.put("value", map.remove(sensorKey)); + if(sensorMap!=null && !sensorMap.isEmpty()) { + for (Map<String, Object> map : list) { + String time = map.get("time").toString(); + time = time.substring(time.length() - 2); + map.put("time", Integer.valueOf(time)); + map.put("value", map.remove(sensorKey)); + String sensor = map.get("sensorKey").toString(); + if(sensorMap.get(sensor)!=null) { + map.put("unit", sensorMap.get("unit")); + map.put("name", sensorMap.get("name")); + map.put("rules", sensorMap.get("rules")); + }else { + map.put("unit", null); + map.put("name", null); + map.put("rules", null); + } + } + }else { + for (Map<String, Object> map : list) { + String time = map.get("time").toString(); + time = time.substring(time.length() - 2); + map.put("time", Integer.valueOf(time)); + map.put("value", map.remove(sensorKey)); + map.put("unit", null); + map.put("name", null); + map.put("rules", null); + } } - - return null; - //return new ResultBean<List<Map<String, Object>>>(result); + //return null; + return new ResultBean<List<Map<String, Object>>>(list); } } diff --git a/src/main/java/com/moral/service/SensorUnitService.java b/src/main/java/com/moral/service/SensorUnitService.java index 5032cdd..505b937 100644 --- a/src/main/java/com/moral/service/SensorUnitService.java +++ b/src/main/java/com/moral/service/SensorUnitService.java @@ -18,6 +18,8 @@ Map<String, Object> getSensorByMac(String mac); - Map<String, Object> getSensorsByMonitPointId(String id); + //Map<String, Object> getSensorsByMonitPointId(String id); + + Map<String, Map<String, Object>> getSensorsByMonitPointId(String id); } diff --git a/src/main/java/com/moral/service/impl/SensorUnitServiceImpl.java b/src/main/java/com/moral/service/impl/SensorUnitServiceImpl.java index fd61ddd..ceffa68 100644 --- a/src/main/java/com/moral/service/impl/SensorUnitServiceImpl.java +++ b/src/main/java/com/moral/service/impl/SensorUnitServiceImpl.java @@ -111,7 +111,7 @@ } } - @Override + /*@Override public Map<String, Object> getSensorsByMonitPointId(String id) { System.out.println("SensorUnitServiceImpl-----getSensorsByMonitPointId-----id:"+id); List<Map<String, Object>> list = sensorUnitMapper.getSensorsByMonitPointId(id); @@ -131,5 +131,31 @@ Map<String, Object> sensorUnitMap = null; return sensorUnitMap; } + }*/ + + @Override + public Map<String, Map<String, Object>> getSensorsByMonitPointId(String id) { + System.out.println("SensorUnitServiceImpl-----getSensorsByMonitPointId-----id:"+id); + List<Map<String, Object>> list = sensorUnitMapper.getSensorsByMonitPointId(id); + System.out.println("SensorUnitServiceImpl----getSensorsByMonitPointId----list:"+list); + if (list!=null && !list.isEmpty()) { + Map<String, Object> innerMap = new HashMap<>(); + Map<String, Map<String, Object>> sensorUnitMap = new HashMap<>(); + for(Map<String, Object> sensorMap : list) { + innerMap.put("unit", sensorMap.get("unit")); + innerMap.put("name", sensorMap.get("name")); + innerMap.put("rules", sensorMap.get("rules")); + String sensor_key = (String) sensorMap.get("sensor_key"); + System.out.println("SensorUnitServiceImpl----getSensorsByMonitPointId----sensor_key:"+sensor_key); + String name = (String) sensorMap.get("name"); + System.out.println("SensorUnitServiceImpl----getSensorsByMonitPointId----name:"+name); + sensorUnitMap.put(sensor_key, innerMap); + } + System.out.println(sensorUnitMap); + return sensorUnitMap; + } else { + Map<String, Map<String, Object>> sensorUnitMap = null; + return sensorUnitMap; + } } } diff --git a/src/main/resources/mapper/SensorUnitMapper.xml b/src/main/resources/mapper/SensorUnitMapper.xml index 2d661f4..a24a98f 100644 --- a/src/main/resources/mapper/SensorUnitMapper.xml +++ b/src/main/resources/mapper/SensorUnitMapper.xml @@ -26,7 +26,7 @@ </select> <select id="getSensorsByMonitPointId" resultType="java.util.Map"> - SELECT mp.id,s.sensor_key,su.id,su.sensor_id,su.name,su.rules + SELECT mp.id,s.sensor_key,s.unit,su.id,su.sensor_id,su.name,su.rules FROM monitor_point mp,organization org,organization_sensor_unit osu,sensor_unit su, sensor s WHERE mp.organization_id = org.id AND org.id = osu.organization_id -- Gitblit v1.8.0