| | |
| | | wrapper.between("time", startDate, endDate); |
| | | List<HistoryHourly> historyHourlies = multiTableQuery(wrapper, tableNames); |
| | | historyHourlies = historyHourlies.stream().distinct().collect(Collectors.toList()); |
| | | List<HistoryHourly> distinctHistoryHourlies = new ArrayList<>(); |
| | | Map<String, Object> disMap = new HashMap<>(); |
| | | for (HistoryHourly historyHourly:historyHourlies) { |
| | | Date time = historyHourly.getTime(); |
| | | String timeStr = DateUtils.dateToDateString(time,DateUtils.yyyy_MM_dd_HH_mm_ss_EN); |
| | | if (!disMap.containsKey(timeStr)){ |
| | | distinctHistoryHourlies.add(historyHourly); |
| | | disMap.put(timeStr,true); |
| | | } |
| | | } |
| | | for (HistoryHourly historyHourly:distinctHistoryHourlies) { |
| | | Map<String,Object> historyHourlyMap = new HashMap<>(); |
| | | historyHourlyMap.put("mac",mac); |
| | | JSONObject value = JSONObject.parseObject(historyHourly.getValue()); |
| | |
| | | List<Map<String,Object>> deviceData = new ArrayList<>(); |
| | | deviceData = (List<Map<String,Object>>)resultMap.get("deviceData"); |
| | | deviceData.add(deviceMap); |
| | | Collections.sort(deviceData, (map1,map2) -> { |
| | | String name1 = map1.get("name").toString();//name1是从你list里面拿出来的一个 |
| | | String name2 = map2.get("name").toString(); //name1是从你list里面拿出来的第二个name |
| | | return name1.compareTo(name2); |
| | | }); |
| | | resultMap.put("deviceData",deviceData); |
| | | //result.add(resultMap); |
| | | flag = false; |
| | |
| | | if (flag){ |
| | | List<Map<String,Object>> deviceData = new ArrayList<>(); |
| | | deviceData.add(deviceMap); |
| | | Collections.sort(deviceData, (map1,map2) -> { |
| | | String name1 = map1.get("name").toString();//name1是从你list里面拿出来的一个 |
| | | String name2 = map2.get("name").toString(); //name1是从你list里面拿出来的第二个name |
| | | return name1.compareTo(name2); |
| | | }); |
| | | Map<String,Object> resultMap = new HashMap<>(); |
| | | resultMap.put("deviceData",deviceData); |
| | | resultMap.put("time",time); |
| | |
| | | }else { |
| | | List<Map<String,Object>> deviceData = new ArrayList<>(); |
| | | deviceData.add(deviceMap); |
| | | Collections.sort(deviceData, (map1,map2) -> { |
| | | String name1 = map1.get("name").toString();//name1是从你list里面拿出来的一个 |
| | | String name2 = map2.get("name").toString(); //name1是从你list里面拿出来的第二个name |
| | | return name1.compareTo(name2); |
| | | }); |
| | | Map<String,Object> resultMap = new HashMap<>(); |
| | | resultMap.put("deviceData",deviceData); |
| | | resultMap.put("time",time); |