| | |
| | | |
| | | QueryWrapper<Device> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.select("mac", "name").in("mac", macs); |
| | | queryWrapper.orderByAsc("dev_num","name","id"); |
| | | List<Device> devices = deviceMapper.selectList(queryWrapper); |
| | | Map<String,Object> devicesInfo = new HashMap<>(); |
| | | for (Device device:devices) { |
| | |
| | | for (HistoryHourly historyHourly:distinctHistoryHourlies) { |
| | | Map<String,Object> historyHourlyMap = new HashMap<>(); |
| | | historyHourlyMap.put("mac",mac); |
| | | JSONObject value = JSONObject.parseObject(historyHourly.getValue()); |
| | | Double sensorValue = Double.parseDouble(value.get(sensorCode).toString()); |
| | | JSONObject value= JSONObject.parseObject(historyHourly.getValue()); |
| | | Double sensorValue = Objects.nonNull(value)&&Objects.nonNull(value.get(sensorCode))?Double.parseDouble(value.get(sensorCode).toString()):0d; |
| | | historyHourlyMap.put(sensorCode,sensorValue); |
| | | Date time = historyHourly.getTime(); |
| | | String timeStr = DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_EN); |