| | |
| | | import java.util.concurrent.CountDownLatch; |
| | | import java.util.concurrent.atomic.AtomicInteger; |
| | | |
| | | import com.yssh.config.InitConfig; |
| | | import com.yssh.entity.*; |
| | | import com.yssh.mapper.*; |
| | | import com.yssh.utils.CalculateUtils; |
| | |
| | | //@Transactional |
| | | @Async("threadPoolTaskExecutor") |
| | | public void insertSuYuanDatasAsync(List<SuYuan> lists, String time) throws Exception { |
| | | //插入数据 |
| | | List<List<SuYuan>> list = Lists.partition(lists, AsyncService.BATCH_INSERT_NUMBER); |
| | | CountDownLatch countDownLatch = new CountDownLatch(list.size()); |
| | | for (List<SuYuan> corpReserveList : list) { |
| | |
| | | } |
| | | if (suYuanMapper.isTableExists(dictRecord.getTableName()) == 0) return null; |
| | | |
| | | List<DistanceSuYuan> list = suYuanMapper.getDistanceSuYuan(dictRecord.getTableName(), ids3d); |
| | | List<DistanceSuYuan> source = suYuanMapper.getDistanceSuYuan(dictRecord.getTableName(), ids3d); |
| | | List<DistanceSuYuan> list = getList(ids3d, source); |
| | | AtomicInteger i = new AtomicInteger(0); |
| | | list.stream().forEach(s -> { |
| | | s.setName(checkPoint.getName()); |
| | |
| | | Collections.sort(list); |
| | | DistanceSuYuan max = list.get(0); |
| | | FeedbackDetail feedbackDetail = new FeedbackDetail(null, dictRecord.getTableName(), |
| | | max.getName(), max.getId(), max.getVocsName(), max.getVocsValue(), null, null, null, DateUtils.getNowDate()); |
| | | max.getName(), max.getId(), max.getVocsName(), max.getVocsValue(), null, null, null, InitConfig.getDate()); |
| | | feedbackMapper.insert(feedbackDetail); |
| | | result.put("feedbackId", feedbackDetail.getId()); |
| | | } |
| | | result.put("data", list); |
| | | return result; |
| | | } |
| | | |
| | | private List<DistanceSuYuan> getList(List<String> ids3d, List<DistanceSuYuan> source) { |
| | | List<DistanceSuYuan> list = new ArrayList<>(); |
| | | for (String id : ids3d) { |
| | | DistanceSuYuan suYuan = source.stream().filter(db -> id.equals(db.getId())).findFirst().orElse(null); |
| | | if (null == suYuan) { |
| | | String[] strs = id.split("_"); |
| | | suYuan = new DistanceSuYuan(null, null, 0.0, id, Integer.parseInt(strs[0]), Integer.parseInt(strs[1]), 0, 0, null, 0.0, 0.0, 0.0, 0.0); |
| | | } |
| | | list.add(suYuan); |
| | | } |
| | | |
| | | return list; |
| | | } |
| | | |
| | | public Map<String, Object> selectSuYuan200(String name, Date date) { |
| | |
| | | } |
| | | if (suYuanMapper.isTableExists(dictRecord.getTableName()) == 0) return null; |
| | | |
| | | List<DistanceSuYuan> list = suYuanMapper.getDistanceSuYuan(dictRecord.getTableName(), ids3d); |
| | | List<DistanceSuYuan> source = suYuanMapper.getDistanceSuYuan(dictRecord.getTableName(), ids3d); |
| | | List<DistanceSuYuan> list = getList(ids3d, source); |
| | | AtomicInteger i = new AtomicInteger(0); |
| | | list.stream().forEach(s -> { |
| | | s.setName(checkPoint.getName()); |
| | |
| | | Collections.sort(list); |
| | | DistanceSuYuan max = list.get(0); |
| | | FeedbackDetail feedbackDetail = new FeedbackDetail(null, dictRecord.getTableName(), |
| | | max.getName(), max.getId(), max.getVocsName(), max.getVocsValue(), null, null, null, DateUtils.getNowDate()); |
| | | max.getName(), max.getId(), max.getVocsName(), max.getVocsValue(), null, null, null, InitConfig.getDate()); |
| | | feedbackMapper.insert(feedbackDetail); |
| | | result.put("feedbackId", feedbackDetail.getId()); |
| | | } |
| | |
| | | } |
| | | if (suYuanMapper.isTableExists(dictRecord.getTableName()) == 0) return null; |
| | | |
| | | List<DistanceSuYuan> list = suYuanMapper.getDistanceSuYuan(dictRecord.getTableName(), ids3d); |
| | | List<DistanceSuYuan> source = suYuanMapper.getDistanceSuYuan(dictRecord.getTableName(), ids3d); |
| | | List<DistanceSuYuan> list = getList(ids3d, source); |
| | | AtomicInteger i = new AtomicInteger(0); |
| | | list.stream().forEach(s -> { |
| | | s.setName(checkPoint.getName()); |
| | |
| | | Collections.sort(list); |
| | | DistanceSuYuan max = list.get(0); |
| | | FeedbackDetail feedbackDetail = new FeedbackDetail(null, dictRecord.getTableName(), |
| | | max.getName(), max.getId(), max.getVocsName(), max.getVocsValue(), null, null, null, DateUtils.getNowDate()); |
| | | max.getName(), max.getId(), max.getVocsName(), max.getVocsValue(), null, null, null, InitConfig.getDate()); |
| | | feedbackMapper.insert(feedbackDetail); |
| | | result.put("feedbackId", feedbackDetail.getId()); |
| | | } |
| | |
| | | } |
| | | if (suYuanMapper.isTableExists(dictRecord.getTableName()) == 0) return null; |
| | | |
| | | List<DistanceSuYuan> list = suYuanMapper.getDistanceSuYuan(dictRecord.getTableName(), ids3d); |
| | | List<DistanceSuYuan> source = suYuanMapper.getDistanceSuYuan(dictRecord.getTableName(), ids3d); |
| | | List<DistanceSuYuan> list = getList(ids3d, source); |
| | | AtomicInteger i = new AtomicInteger(0); |
| | | list.stream().forEach(s -> { |
| | | s.setName(checkPoint.getName()); |
| | |
| | | Collections.sort(list); |
| | | DistanceSuYuan max = list.get(0); |
| | | FeedbackDetail feedbackDetail = new FeedbackDetail(null, dictRecord.getTableName(), |
| | | max.getName(), max.getId(), max.getVocsName(), max.getVocsValue(), null, null, null, DateUtils.getNowDate()); |
| | | max.getName(), max.getId(), max.getVocsName(), max.getVocsValue(), null, null, null, InitConfig.getDate()); |
| | | feedbackMapper.insert(feedbackDetail); |
| | | result.put("feedbackId", feedbackDetail.getId()); |
| | | } |
| | |
| | | calendar.add(Calendar.DATE, -7); |
| | | String start = DateUtils.getYyyyMmDdHh(calendar.getTime()); |
| | | |
| | | return suYuanMapper.getNewMonitorData(checkPoint.getName(), start, end); |
| | | return qxshMapper.getNewMonitorData(checkPoint.getName(), start, end); |
| | | } |
| | | |
| | | public int updateVocsName(Date date, String id, String vocsName) { |
| | | String table = "su_yuan_" + DateUtils.getYyyyMmDdHh(date); // new Date() |
| | | String table = "su_yuan_" + DateUtils.getYyyyMmDdHh(date); |
| | | if (isTableExists(table) == 0) { |
| | | return 0; |
| | | } |
| | |
| | | return suYuanId; |
| | | } |
| | | |
| | | /** |
| | | * 根据ID查询快速溯源 |
| | | */ |
| | | public List<SuYuanFast> selectFastById(String id, Date date) { |
| | | String time = DateUtils.getYyyyMmDdHhMmSs(date); |
| | | |