From 2b5a2bb0525cc70d7f44d18b8bcf44f46db8a35e Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Thu, 31 Aug 2023 16:01:55 +0800 Subject: [PATCH] chore:测试提交 --- screen-api/src/main/java/com/moral/api/service/impl/DustldServiceImpl.java | 69 ++++++++++++++++++++++++++++++++-- screen-api/src/main/java/com/moral/api/mapper/MaxRoadMapper.java | 7 +++ screen-api/src/main/java/com/moral/api/entity/MaxRoad.java | 25 ++++++++++++ 3 files changed, 96 insertions(+), 5 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/entity/MaxRoad.java b/screen-api/src/main/java/com/moral/api/entity/MaxRoad.java new file mode 100644 index 0000000..1e2bebe --- /dev/null +++ b/screen-api/src/main/java/com/moral/api/entity/MaxRoad.java @@ -0,0 +1,25 @@ +package com.moral.api.entity; + +import lombok.Data; +import lombok.EqualsAndHashCode; + +import java.util.Date; + +import com.baomidou.mybatisplus.extension.activerecord.Model; + +@Data +@EqualsAndHashCode(callSuper = false) +public class MaxRoad extends Model<MaxRoad> { + + private static final long serialVersionUID = 1L; + + + + private Integer id; + + private String name; + + private Date time; + + private Double data; +} diff --git a/screen-api/src/main/java/com/moral/api/mapper/MaxRoadMapper.java b/screen-api/src/main/java/com/moral/api/mapper/MaxRoadMapper.java new file mode 100644 index 0000000..67b062b --- /dev/null +++ b/screen-api/src/main/java/com/moral/api/mapper/MaxRoadMapper.java @@ -0,0 +1,7 @@ +package com.moral.api.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.moral.api.entity.MaxRoad; + +public interface MaxRoadMapper extends BaseMapper<MaxRoad> { +} diff --git a/screen-api/src/main/java/com/moral/api/service/impl/DustldServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/DustldServiceImpl.java index ec8164a..85a16fa 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/DustldServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/DustldServiceImpl.java @@ -34,9 +34,11 @@ import com.moral.api.entity.Dustld; import com.moral.api.entity.ManageCoordinate; +import com.moral.api.entity.MaxRoad; import com.moral.api.mapper.DustldMapper; import com.moral.api.mapper.HistorySecondCruiserMapper; import com.moral.api.mapper.ManageCoordinateMapper; +import com.moral.api.mapper.MaxRoadMapper; import com.moral.api.pojo.dto.historySecondCruiser.DustldDTO; import com.moral.api.pojo.dust.DustForm; import com.moral.api.pojo.dust.TimeForm; @@ -269,16 +271,21 @@ @Autowired private ManageCoordinateMapper manageCoordinateMapper; + @Autowired + private MaxRoadMapper maxRoadMapper; @Override public Map<String, Object> dailyDustlds(List<MultipartFile> file,Map<String, Object> params) { + 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"); String time1 = params.get("time1").toString(); - String substring1 = time1.substring(5, 14); + String dateString1 = DateUtils.stringToDateString(time1, DateUtils.yyyy_MM_dd_HH_mm_ss_EN, DateUtils.yyyy_MM_dd_HH_mm_CN); + String rsTime1 = dateString1.substring(5, 14); String time2 = params.get("time2").toString(); - String substring2 = time2.substring(5, 14); + String dateString2 = DateUtils.stringToDateString(time2, DateUtils.yyyy_MM_dd_HH_mm_ss_EN, DateUtils.yyyy_MM_dd_HH_mm_CN); + String rsTime2 = dateString2.substring(5, 14); HashMap<String, Object> rsMap = new HashMap<>(); List<Map<String, Object>> dusts = historySecondCruiserMapper.getDusts(params); Map<String, List<DustldDTO>> collect = manageCoordinateMapper.CompareTo(orgId).stream().collect(Collectors.groupingBy(o -> o.getName())); @@ -288,6 +295,7 @@ StringBuilder builder = new StringBuilder(); int i = 1; + long timestamp = System.currentTimeMillis(); for (String string : strings) { DustForm dustForm = new DustForm(); ArrayList<Double> doubleArrayList = new ArrayList<>(); @@ -295,6 +303,9 @@ for (DustldDTO dustldDTO : dustldDTOS) { String flyLat = dustldDTO.getFlyLat(); String flyLon = dustldDTO.getFlyLon(); +// if (flyLon==null && flyLat==null){ +// continue; +// } for (Map<String, Object> dust : dusts) { String flyLat1 = Objects.nonNull(dust.get("flyLat")) ? dust.get("flyLat").toString() :"0"; String flyLon1 = Objects.nonNull(dust.get("flyLon")) ? dust.get("flyLon").toString() :"0"; @@ -322,26 +333,74 @@ } } } + if (ObjectUtils.isEmpty(doubleArrayList)){ + continue; + } Double ListAva = doubleArrayList.stream() .collect(Collectors.averagingDouble(Double::doubleValue)); double rsAvg = new BigDecimal(ListAva/1000).setScale(3, BigDecimal.ROUND_HALF_UP).doubleValue(); dustForm.setRoad(string); dustForm.setValue(rsAvg); if (rsAvg>=0.3){ builder.append("("+i+")"+string); - list1.add(dustForm); + //������������������ + QueryWrapper<MaxRoad> wrapper = new QueryWrapper<>(); + wrapper.eq("name",string); + wrapper.eq("time",DateUtils.getDate(time1,DateUtils.yyyy_MM_dd_EN)); + Integer integer = maxRoadMapper.selectCount(wrapper); + if (integer==0){ + MaxRoad maxRoad = new MaxRoad(); + maxRoad.setData(rsAvg); + maxRoad.setName(string); + maxRoad.setTime(DateUtils.getDate(time1,DateUtils.yyyy_MM_dd_EN)); + maxRoadMapper.insert(maxRoad); + } + }else { list2.add(dustForm); } } + long timestamp2 = System.currentTimeMillis(); + log.info(timestamp2-timestamp+""); //������ list1.sort(Comparator.comparing(DustForm::getValue).reversed()); list2.sort(Comparator.comparing(DustForm::getValue).reversed()); rsMap.put("list1",list1); rsMap.put("list2",list2); + + //������������������������������ + ArrayList<Map<String, Object>> list3 = new ArrayList<>(); + QueryWrapper<MaxRoad> wrapper = new QueryWrapper<>(); + wrapper.lt("time",DateUtils.getDate(time1,DateUtils.yyyy_MM_dd_EN)); + wrapper.orderByDesc("time"); + + MaxRoad maxRoad = maxRoadMapper.selectOne(wrapper); + String dateString3 = DateUtils.dateToDateString(maxRoad.getTime(), DateUtils.yyyy_MM_dd_CN); + QueryWrapper<MaxRoad> wrapper2 = new QueryWrapper<>(); + wrapper2.eq("time",maxRoad.getTime()); + List<MaxRoad> maxRoads = maxRoadMapper.selectList(wrapper2); + + //������������ + ArrayList<DustForm> dustForms = new ArrayList<>(); + dustForms.addAll(list1); + dustForms.addAll(list2); + for (MaxRoad road : maxRoads) { + for (DustForm dustForm : dustForms) { + if (road.getName().equals(dustForm.getRoad())){ + HashMap<String, Object> map = new HashMap<>(); + map.put("road",road.getName()); + map.put("value1",road.getData()); + map.put("value2",dustForm.getValue()); + map.put("value3",road.getData()-dustForm.getValue()); + list3.add(map); + } + } + } rsMap.put("data",builder); - rsMap.put("list3",""); - rsMap.put("time",substring1+"-"+substring2); + rsMap.put("list3",list3); + rsMap.put("time",rsTime1+"-"+rsTime2); + rsMap.put("date1",dateString3.substring(5,10)); + rsMap.put("date2",dateString1.substring(5,10)); return rsMap; } -- Gitblit v1.8.0