| | |
| | | import com.moral.api.mapper.HistorySecondCruiserMapper; |
| | | import com.moral.api.mapper.SpecialDeviceMapper; |
| | | import com.moral.api.pojo.bo.ExcelBO; |
| | | import com.moral.api.pojo.dto.historySecondCruiser.HistorySecondCruiserListDTO; |
| | | import com.moral.api.pojo.dto.historySecondCruiser.HistorySecondCruiserResultCountDTO; |
| | | import com.moral.api.pojo.dto.historySecondCruiser.HistorySecondCruiserResultDTO; |
| | | import com.moral.api.pojo.vo.excel.DailyVo; |
| | | import com.moral.api.service.OrganizationService; |
| | | import com.moral.api.service.SpecialDeviceHistoryService; |
| | |
| | | import com.moral.util.GeodesyUtils; |
| | | import com.moral.util.TokenUtils; |
| | | |
| | | import org.apache.commons.collections4.CollectionUtils; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.boot.system.ApplicationHome; |
| | |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import java.io.File; |
| | | import java.math.BigDecimal; |
| | | import java.text.ParseException; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.Collections; |
| | | import java.util.Date; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.UUID; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | |
| | | RedisTemplate redisTemplate; |
| | | |
| | | private final static Double dis = 50d; |
| | | |
| | | |
| | | private final static Double DIS_NEW = 100d; |
| | | |
| | | @Override |
| | | public List<Map<String, Object>> selectCruisers() { |
| | |
| | | map.put("a21004",String.valueOf(Double.parseDouble(a21004) / 10)); |
| | | }*/ |
| | | return filterData(data); |
| | | } |
| | | |
| | | @Override |
| | | public List<HistorySecondCruiserResultDTO> carTrajectoryNewAvg(Map<String, Object> params) { |
| | | params.put("dateFormat", "%Y-%m-%d %H:%i:%s"); |
| | | Map<String, Object> userInfo = (Map<String, Object>) TokenUtils.getUserInfo(); |
| | | Map<String, Object> orgInfo = (Map<String, Object>) userInfo.get("organization"); |
| | | Integer orgId = (Integer) orgInfo.get("id"); |
| | | params.put("orgId", orgId); |
| | | params.put("type","$."+params.get("type")); |
| | | //从秒数据表获取走航车数据 |
| | | List<HistorySecondCruiserListDTO> data = HistorySecondCruiserMapper.getCruiserDataNewAvg(params); |
| | | data.removeIf(o->{ |
| | | if (ObjectUtils.isEmpty(o.getFlyLon()) || ObjectUtils.isEmpty(o.getFlyLat())) { |
| | | return true; |
| | | } |
| | | double lon = o.getFlyLon(); |
| | | double lat = o.getFlyLat(); |
| | | if (lon < 70 || lon > 150 || lat < 20 || lat > 60) { |
| | | return true; |
| | | } |
| | | return false; |
| | | }); |
| | | if(CollectionUtils.isEmpty(data)){ |
| | | return null; |
| | | } |
| | | return filterDataNew(data); |
| | | } |
| | | @Override |
| | | public SpecialDevice getSpecialDeviceMapByMac(String mac) { |
| | |
| | | |
| | | return list; |
| | | } |
| | | //根据距离筛选数据 |
| | | private List<HistorySecondCruiserResultDTO> filterDataNew(List<HistorySecondCruiserListDTO> data) { |
| | | List<HistorySecondCruiserListDTO> list = new ArrayList<>(); |
| | | Map<Integer, HistorySecondCruiserResultCountDTO> map = new HashMap<>(); |
| | | Map<String, BigDecimal> mapTest = new HashMap<>(); |
| | | Integer integer = 1; |
| | | HistorySecondCruiserResultCountDTO countDTO = new HistorySecondCruiserResultCountDTO(); |
| | | countDTO.setSumNum(data.get(0).getNum()); |
| | | countDTO.setContNum(1); |
| | | map.put(integer,countDTO); |
| | | list.add(0,data.remove(0)); |
| | | mapTest.put(data.get(0).getFlyLon()+"_"+data.get(0).getFlyLat(),data.get(0).getNum()); |
| | | int k =1; |
| | | for (HistorySecondCruiserListDTO d : data) { |
| | | boolean flag = true; |
| | | for (HistorySecondCruiserListDTO l : list) { |
| | | double distance = GeodesyUtils.getDistance(d.getFlyLat(), d.getFlyLon(), l.getFlyLat(), l.getFlyLon()); |
| | | if (distance < DIS_NEW) { |
| | | flag = false; |
| | | if(integer.equals(list.size())&& !mapTest.containsKey(d.getFlyLon()+"_"+d.getFlyLat())){ |
| | | HistorySecondCruiserResultCountDTO countResultDTO = Objects.isNull(map.get(integer))?new HistorySecondCruiserResultCountDTO():map.get(integer); |
| | | countResultDTO.setContNum(countResultDTO.getContNum()+1); |
| | | countResultDTO.setSumNum(countResultDTO.getSumNum().add(d.getNum())); |
| | | map.put(integer,countResultDTO); |
| | | mapTest.put(d.getFlyLon()+"_"+d.getFlyLat(),d.getNum()); |
| | | k++; |
| | | } |
| | | } |
| | | } |
| | | if (flag) { |
| | | if(!list.contains(d)){ |
| | | list.add(d); |
| | | integer++; |
| | | } |
| | | } |
| | | } |
| | | if(!list.contains(data.get(data.size()-1))){ |
| | | HistorySecondCruiserListDTO result = data.get(data.size()-1); |
| | | list.add(result); |
| | | integer++; |
| | | HistorySecondCruiserResultCountDTO countResultDTO = new HistorySecondCruiserResultCountDTO(); |
| | | countResultDTO.setContNum(1); |
| | | countResultDTO.setSumNum(result.getNum()); |
| | | map.put(integer,countResultDTO); |
| | | } |
| | | return filterDataNe(list,map); |
| | | } |
| | | private List<HistorySecondCruiserResultDTO> filterDataNe(List<HistorySecondCruiserListDTO> list,Map<Integer, HistorySecondCruiserResultCountDTO> map){ |
| | | List<HistorySecondCruiserResultDTO> listResult = new ArrayList<>(); |
| | | for(Map.Entry<Integer, HistorySecondCruiserResultCountDTO> entry : map.entrySet()){ |
| | | Integer mapKey = entry.getKey(); |
| | | HistorySecondCruiserResultCountDTO mapValue = entry.getValue(); |
| | | BigDecimal avgNum = mapValue.getSumNum().divide(BigDecimal.valueOf(mapValue.getContNum()),2,BigDecimal.ROUND_HALF_UP); |
| | | HistorySecondCruiserResultDTO resultDTO = new HistorySecondCruiserResultDTO(); |
| | | resultDTO.setTime(list.get(mapKey-1).getTime()); |
| | | resultDTO.setAvgNum(avgNum); |
| | | resultDTO.setFlyLon(list.get(mapKey-1).getFlyLon()); |
| | | resultDTO.setFlyLat(list.get(mapKey-1).getFlyLat()); |
| | | listResult.add(resultDTO); |
| | | } |
| | | return listResult; |
| | | |
| | | |
| | | } |
| | | |
| | | private List<HistorySecondCruiserResultDTO> filterDataNew(List<HistorySecondCruiserListDTO> data, List<HistorySecondCruiserListDTO> list) { |
| | | List<HistorySecondCruiserResultDTO> listResult = new ArrayList<>(); |
| | | List<HistorySecondCruiserListDTO> filter = new ArrayList<>(); |
| | | for (HistorySecondCruiserListDTO d : data) { |
| | | for (HistorySecondCruiserListDTO l : list) { |
| | | double distance = GeodesyUtils.getDistance(d.getFlyLat(), d.getFlyLon(), l.getFlyLat(), l.getFlyLon()); |
| | | if (filter.contains(d)) { |
| | | break; |
| | | } |
| | | if (distance < DIS_NEW ) { |
| | | List<BigDecimal> numList = new ArrayList<>(CollectionUtils.isEmpty(l.getNumList()) ? Arrays.asList(l.getNum()) : l.getNumList()); |
| | | numList.add(d.getNum()); |
| | | l.setNumList(numList); |
| | | filter.add(d); |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | int k = 0; |
| | | for(int j =0;j<list.size(); j++){ |
| | | HistorySecondCruiserListDTO l = list.get(j); |
| | | HistorySecondCruiserResultDTO resultDTO = new HistorySecondCruiserResultDTO(); |
| | | resultDTO.setFlyLat(l.getFlyLat()); |
| | | resultDTO.setTime(l.getTime()); |
| | | resultDTO.setFlyLon(l.getFlyLon()); |
| | | BigDecimal num = BigDecimal.ZERO; |
| | | int count = l.getNumList().size(); |
| | | for(int i = 0;i < count; i++) { |
| | | num = num.add(l.getNumList().get(i)); |
| | | } |
| | | k = k+count; |
| | | resultDTO.setAvgNum(num.divide(BigDecimal.valueOf(count),2,BigDecimal.ROUND_HALF_UP)); |
| | | listResult.add(resultDTO); |
| | | } |
| | | System.out.println("sss>>>>:"+ (k++)); |
| | | System.out.println("sss>>>>:"+ (filter.size())+">>>>:"+data.size()); |
| | | int z = 0 ; |
| | | return listResult; |
| | | |
| | | |
| | | } |
| | | } |