From d0b261f701c86f55dd04365c620fb6f79cbe5c62 Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Thu, 20 Jun 2024 13:11:12 +0800 Subject: [PATCH] fix:盐城热力图接口修改提交 --- screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java | 98 +++++++++++++++++++++++++++++++++++------------- 1 files changed, 71 insertions(+), 27 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java index 2930b9a..36e4685 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java @@ -3,13 +3,11 @@ import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; - import com.moral.api.config.Interceptor.UserHelper; import com.moral.api.entity.*; import com.moral.api.mapper.DailyMapper; import com.moral.api.mapper.HistorySecondCruiserMapper; import com.moral.api.mapper.SpecialDeviceMapper; -import com.moral.api.mapper.SysDictTypeMapper; import com.moral.api.pojo.bo.ExcelBO; import com.moral.api.pojo.dto.historySecondCruiser.HistorySecondCruiserListDTO; import com.moral.api.pojo.dto.historySecondCruiser.HistorySecondCruiserResultCountDTO; @@ -22,6 +20,7 @@ import com.moral.api.service.SpecialDeviceHistoryService; import com.moral.api.service.SpecialDeviceService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.moral.api.service.SysAreaService; import com.moral.api.service.SysDictTypeService; import com.moral.constant.Constants; @@ -30,7 +29,6 @@ import com.moral.util.FileUtils; 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; @@ -38,9 +36,7 @@ import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import org.springframework.util.ObjectUtils; -import org.springframework.util.StringUtils; import org.springframework.web.multipart.MultipartFile; - import java.io.File; import java.math.BigDecimal; import java.text.ParseException; @@ -85,6 +81,9 @@ @Autowired RedisTemplate redisTemplate; + + @Autowired + private SysAreaService sysAreaService; private final static Double dis = 50d; @@ -327,10 +326,11 @@ String type = params.get("type").toString(); String code = params.get("code").toString(); String area = params.get("area").toString(); + String mac = params.get("mac").toString(); rsMap.put("area",area); + rsMap.put("mac",mac.substring(9)); String value = JSON.toJSONString(rsMap); - String mac = params.get("mac").toString(); QueryWrapper<TbDaily> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("mac",mac); queryWrapper.likeRight("time",time1.substring(0,10)); @@ -446,29 +446,40 @@ /** * ��������������������� - * @param id + * @param ids * @return */ @Override - public DailyVo loadDaily(Integer id) { - ArrayList<String> rsList = new ArrayList<>(); - DailyVo dailyVo = new DailyVo(); - TbDaily tbDaily = dailyMapper.selectById(id); - if (tbDaily==null){ - return null; + public List<DailyVo> loadDaily(List<Integer> ids) { + ArrayList<DailyVo> dailyVos = new ArrayList<>(); + for (Integer id : ids) { + ArrayList<String> rsList = new ArrayList<>(); + DailyVo dailyVo = new DailyVo(); + TbDaily tbDaily = dailyMapper.selectById(id); + + SysArea areaByCode = sysAreaService.getAreaByCode(Integer.parseInt(tbDaily.getCode())); + if (tbDaily==null){ + continue; + } + String images = tbDaily.getImages(); + if (!ObjectUtils.isEmpty(images)){ + String[] split = images.split(","); + List<String> list1 = Arrays.asList(split); + dailyVo.setImages(list1); + }else { + dailyVo.setImages(rsList); + } + String value = tbDaily.getValue(); + Map map = JSON.parseObject(value, Map.class); + List<String> list = (List<String>) map.get("time"); + String join = String.join("-", list); + map.put("time",join); + dailyVo.setCode(map); + dailyVo.setName(areaByCode.getAreaName()); + dailyVo.setType(tbDaily.getType().equals("car")?"������":"���������"); + dailyVos.add(dailyVo); } - String images = tbDaily.getImages(); - if (!ObjectUtils.isEmpty(images)){ - String[] split = images.split(","); - List<String> list1 = Arrays.asList(split); - dailyVo.setImages(list1); - }else { - dailyVo.setImages(rsList); - } - String value = tbDaily.getValue(); - Map map = JSON.parseObject(value, Map.class); - dailyVo.setCode(map); - return dailyVo; + return dailyVos; } /** @@ -486,9 +497,11 @@ Object mac = params.get("mac"); if (!ObjectUtils.isEmpty(mac)){ - String MAC = mac.toString(); + String[] split = mac.toString().split(","); + List<String> list = Arrays.asList(split); + List<String> macList = new ArrayList<>(new TreeSet<>(list)); QueryWrapper<TbDaily> queryWrapper = new QueryWrapper<>(); - queryWrapper.eq("type",type).eq("code",code).eq("mac",MAC); + queryWrapper.eq("type",type).eq("code",code).in("mac",macList); queryWrapper.between("time",startTime,endTime); List<TbDaily> dailies = dailyMapper.selectList(queryWrapper); for (TbDaily daily : dailies) { @@ -750,4 +763,35 @@ } + + /** + * + */ + private double getDivisor(String code,double num){ + double rs = 0.0; + if (code.contains("-")){ + String data = code.substring(1); + rs = num - Double.parseDouble(data); + } else if (code.contains("*")){ + String data = code.substring(1); + rs = num * Double.parseDouble(data); + } else if (code.contains("/")){ + String data = code.substring(1); + rs = num / Double.parseDouble(data); + } else if (code.contains(",")){ + String[] split = code.split(","); + for (String s : split) { + String[] split1 = s.split("<"); + double sp1 = Double.parseDouble(split1[0]); + double sp2 = Double.parseDouble(split1[1]); + double sp3 = Double.parseDouble(split1[2]); + if (num>=sp1 && num<=sp2){ + rs = num + sp3; + } + } + }else { + rs = num + Double.parseDouble(code); + } + return rs; + } } -- Gitblit v1.8.0