| | |
| | | |
| | | //同步点位在线率到mongo(弃用) |
| | | public void siteOnline() { |
| | | // log.info("开始同步点位在线率到mongo"); |
| | | // List<TMonitorResult> tMonitorResults = monitorMapper.selectMonitorResult(null); |
| | | // if (!CollectionUtils.isEmpty(tMonitorResults)) { |
| | | // //如果存在之前的数据先删除 |
| | | // Query query = new Query(Criteria.where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); |
| | | // DeleteResult result = mongoTemplate.remove(query, TMonitorResult.class); |
| | | // //存放在mongo中 |
| | | // mongoTemplate.insertAll(tMonitorResults); |
| | | // log.info("结束同步点位在线率到mongo"); |
| | | // } |
| | | log.info("开始同步点位在线率到mongo"); |
| | | List<TMonitorResult> tMonitorResults = monitorMapper.selectMonitorResult(null); |
| | | if (!CollectionUtils.isEmpty(tMonitorResults)) { |
| | | //如果存在之前的数据先删除 |
| | | Query query = new Query(Criteria.where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); |
| | | DeleteResult result = mongoTemplate.remove(query, TMonitorResult.class); |
| | | //存放在mongo中 |
| | | mongoTemplate.insertAll(tMonitorResults); |
| | | log.info("结束同步点位在线率到mongo"); |
| | | } |
| | | } |
| | | |
| | | //同步mongodb一机一档到数据库 |
| | |
| | | List<TMonitor> monitorList = new ArrayList<>(); |
| | | //准备插入点位表的数据 |
| | | List<YwPoint> ywPointList = new ArrayList<>(); |
| | | //新的数据,原数据库中不存在的数据 |
| | | Set<TMonitor> newMonitorList = new HashSet<>(); |
| | | |
| | | |
| | | //全年留存 |
| | | for (MonitorQualifyResult result : oneMachineFileResults) { |
| | |
| | | YwPoint point = getPoint(result, pointMap, importantSite); |
| | | monitorList.add(monitor); |
| | | ywPointList.add(point); |
| | | //比对筛选出新的数据 |
| | | if (!CollectionUtils.isEmpty(monitorVOMap) && !monitorVOMap.containsKey(result.getSerialNumber().getValue())) { |
| | | newMonitorList.add(monitor); |
| | | } |
| | | } |
| | | //添加老数据 |
| | | List<String> numbers = CollectionUtils.isEmpty(monitorList) ? new ArrayList<>() : monitorList.stream().map(TMonitor::getSerialNumber).collect(Collectors.toList()); |
| | |
| | | }); |
| | | List<String> points = CollectionUtils.isEmpty(ywPointList) ? new ArrayList<>() : ywPointList.stream().map(YwPoint::getSerialNumber).collect(Collectors.toList()); |
| | | pointMap.forEach((key, value) -> { |
| | | //老设备状态改为不参与考核 |
| | | if (!points.contains(key)) { |
| | | value.setExamineStatus(Boolean.FALSE); |
| | | ywPointList.add(value); |
| | | } |
| | | }); |
| | |
| | | ywPoint.setCreateTime(new Date()); |
| | | ywPoint.setUpdateTime(new Date()); |
| | | } |
| | | //状态设置为考核设备 |
| | | ywPoint.setExamineStatus(Boolean.TRUE); |
| | | //比对是否是重点点位 |
| | | if (importantSite.contains(result.getSxjcjqy().getValue())) { |
| | | ywPoint.setImportantTag(Boolean.TRUE); |