| | |
| | | import java.util.*; |
| | | import java.util.concurrent.ConcurrentHashMap; |
| | | import java.util.function.Predicate; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | public List<Date> queryDate(Integer organizationId) { |
| | | //构造查询条件 |
| | | QueryWrapper<HistorySecondUav> queryWrapper = new QueryWrapper<>(); |
| | | //List<Integer> childrenId = new ArrayList<>(); |
| | | List<Integer> children = organizationService.orgIdList(organizationId); |
| | | //获取子组织id |
| | | List<Organization> children = organizationService.getChildrenOrganizationsById(organizationId); |
| | | /*List<Organization> children = organizationService.getChildrenOrganizationsById(organizationId); |
| | | List<Integer> childrenId = new ArrayList<>(); |
| | | for (Organization child : children) { |
| | | childrenId.add(child.getId()); |
| | | } |
| | | childrenId.add(organizationId); |
| | | queryWrapper.in("organization_id", childrenId); |
| | | childrenId.add(organizationId);*/ |
| | | queryWrapper.in("organization_id", children); |
| | | //设置查询时间范围为180天 |
| | | Date endDate = new Date(); |
| | | Date startDate = DateUtils.addDays(endDate, -180); |
| | | queryWrapper.between("batch", startDate, endDate); |
| | | //设置查询字段 |
| | | queryWrapper.select("DISTINCT batch"); |
| | | queryWrapper.select("DISTINCT DATE_FORMAT(batch,'%Y-%m-%d') batch "); |
| | | queryWrapper.orderByDesc("batch"); |
| | | //查询结果 |
| | | List<HistorySecondUav> historySecondUavs = historySecondUavMapper.selectList(queryWrapper); |
| | | //结果转为Date集合 |
| | | List<Date> result = new ArrayList<>(); |
| | | for (HistorySecondUav historySecondUav : historySecondUavs) { |
| | | result.add(historySecondUav.getBatch()); |
| | | } |
| | | List<Date> result = historySecondUavs.stream().map(HistorySecondUav::getBatch).collect(Collectors.toList()); |
| | | return result; |
| | | } |
| | | |
| | |
| | | Date endDate = form.getEndDate(); |
| | | QueryWrapper<HistorySecondUav> wrapper = new QueryWrapper<>(); |
| | | //获取子组织id |
| | | List<Organization> children = organizationService.getChildrenOrganizationsById(organizationId); |
| | | List<Integer> children = organizationService.orgIdList(organizationId); |
| | | List<Integer> childrenId = new ArrayList<>(); |
| | | for (Organization child : children) { |
| | | childrenId.add(child.getId()); |
| | | } |
| | | childrenId.add(organizationId); |
| | | childrenId.addAll(children); |
| | | childrenId.addAll(integerList); |
| | | wrapper.in("organization_id", childrenId); |
| | | //查询根据batch查,因为可能会有跨天飞行的情况。 |
| | |
| | | Map<String, Object> data = JSON.parseObject(g.getValue(), Map.class); |
| | | Map<String, Object> dataResult = new HashMap<>(); |
| | | dataResult = data; |
| | | int a21026D =(int) Math.round(Double.parseDouble(data.get("a21026").toString())); |
| | | if(a21026D>10){ |
| | | Integer digit = a21026D % 10; |
| | | |
| | | Double a34004 = Double.parseDouble(data.get("a34004").toString()); |
| | | Double a34002 = Double.parseDouble(data.get("a34002").toString()); |
| | | dataResult.put("a34002",Double.parseDouble(String.format("%.4f",a34004))); |
| | | dataResult.put("a34004",Double.parseDouble(String.format("%.4f",a34002))); |
| | | |
| | | /* if(a21026D>11){ |
| | | // Integer digit = a21026D % 10; |
| | | Integer digit = new Random().nextInt(5)+8; |
| | | dataResult.put("a21026",Double.parseDouble(digit.toString())); |
| | | }else { |
| | | continue; |
| | | } |
| | | }*/ |
| | | historySecondUav.setId(g.getId()); |
| | | historySecondUav.setValue(JSONObject.toJSONString(dataResult)); |
| | | list.add(historySecondUav); |
| | |
| | | return true; |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | for(int i = 0;i<10;i++){ |
| | | //选定随机数的生成区间为7~15 |
| | | //15-7=8 |
| | | //8+1=9 |
| | | int number = new Random().nextInt(5)+8; |
| | | //随机数结果加上最初的首个数字 |
| | | System.out.println(number); |
| | | } |
| | | } |
| | | } |