From 47ebcea682a84322b303ad1bc64eb7c30dbb5ff4 Mon Sep 17 00:00:00 2001 From: fengxiang <110431245@qq.com> Date: Fri, 23 Mar 2018 16:50:31 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java | 49 ++++++++++++++++++++++++++++--------------------- 1 files changed, 28 insertions(+), 21 deletions(-) diff --git a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java index 43104c6..f29602a 100644 --- a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java +++ b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java @@ -144,9 +144,11 @@ Map<String, List<Object>> resultMap = new HashMap<String, List<Object>>(); List<Map<String, Object>> list = JSON.parseObject((String)parameters.get("items"), new TypeReference<List<Map<String, Object>>>() {}); parameters.remove("items"); - Map<String, Object> timeType = JSON.parseObject((String)parameters.get("timeType"), new TypeReference<Map<String, Object>>() {}); - parameters.remove("timeType"); + Map<String, Object> timeType = JSON.parseObject((String)parameters.get("timeTypes"), new TypeReference<Map<String, Object>>() {}); + parameters.remove("timeTypes"); parameters.putAll(timeType); + parameters.put("type", parameters.get("value")); + parameters.remove("value"); ExecutorService threadPool = Executors.newCachedThreadPool(); CompletionService<Map<String, List<Object>>> cs = new ExecutorCompletionService<Map<String, List<Object>>>(threadPool); @@ -225,23 +227,13 @@ List<Object> timeList = (List<Object>) parameters.get("timeList"); List<Object> dataList = new ArrayList<Object>(); - Set<String> sensors ; - if (parameters.containsKey("sensorKey")) { - String sensorKey = (String) parameters.get("sensorKey"); - Sensor sensor = new Sensor(); - sensor.setSensorKey(sensorKey); - sensor = sensorMapper.selectOne(sensor ); - sensors = new HashSet<String>(); - sensors.add(sensorKey + "-" + sensor.getName() + "-" + sensor.getUnit()); - } else { - sensors = new TreeSet<String>(new Comparator<String>() { - @Override - public int compare(String o1, String o2) { - return Integer.compare(Integer.valueOf(o1.split("-")[0].replace("e", "")), Integer.valueOf(o2.split("-")[0].replace("e", ""))); - } - }); - sensors.addAll((Set<String>)parameters.get("sensors")); - } + Set<String> sensors = new TreeSet<String>(new Comparator<String>() { + @Override + public int compare(String o1, String o2) { + return Integer.compare(Integer.valueOf(o1.split("-")[0].replace("e", "")), Integer.valueOf(o2.split("-")[0].replace("e", ""))); + } + }); + sensors.addAll((Set<String>)parameters.get("sensors")); Map<String, Double[]> doubleMap = new LinkedHashMap<String, Double[]>(); for (Map<String, Object> map : resultList) { String time = map.get("time").toString(); @@ -301,8 +293,23 @@ parameters.put("end", end); if (parameters.containsKey("sensorKey")) { - String sensorKey = (String) parameters.get("sensorKey"); - String sensorKeyColumn = "AVG(json -> '$." + sensorKey + "[0]') " + sensorKey; + List<String> sensors; + try { + sensors = JSON.parseObject((String)parameters.get("sensors"), new TypeReference<List<String>>() {}); + parameters.put("sensors", new HashSet<String>(sensors)); + } catch (Exception e) { + sensors = new ArrayList<String>(); + sensors.add((String)parameters.get("sensorKey")); + } + String sensorKeyColumn = ""; + for (int i = 0; i < sensors.size(); i++) { + String sensorKey = sensors.get(i).split("-")[0]; + sensorKeyColumn += "AVG(json -> '$." + sensorKey + "[0]') " + sensorKey; + if (i != sensors.size() - 1) { + sensorKeyColumn += " ,"; + } + + } parameters.put("sensorKeyColumn", sensorKeyColumn); } -- Gitblit v1.8.0