From 378c3936c402732a6c8dd84d018e48fe69ba7a03 Mon Sep 17 00:00:00 2001 From: kaiyu <404897439@qq.com> Date: Fri, 24 Sep 2021 11:50:00 +0800 Subject: [PATCH] screen-api 修改获取五分钟数据代码 --- screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java | 53 +++++++++++++++++++++++++++++++++++++---------------- 1 files changed, 37 insertions(+), 16 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 fd19d65..0a0e66c 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 @@ -2,10 +2,11 @@ import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; -import com.moral.api.entity.HistorySecondSpecial; + import com.moral.api.entity.Organization; import com.moral.api.entity.SpecialDevice; import com.moral.api.entity.SpecialDeviceHistory; +import com.moral.api.mapper.HistorySecondCruiserMapper; import com.moral.api.mapper.HistorySecondSpecialMapper; import com.moral.api.mapper.SpecialDeviceMapper; import com.moral.api.service.OrganizationService; @@ -13,7 +14,8 @@ import com.moral.api.service.SpecialDeviceService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.moral.constant.Constants; -import com.moral.constant.RedisConstants; + +import com.moral.util.DateUtils; import com.moral.util.GeodesyUtils; import com.moral.util.TokenUtils; @@ -23,8 +25,11 @@ import org.springframework.util.ObjectUtils; import java.util.ArrayList; +import java.util.Date; +import java.util.HashMap; import java.util.List; import java.util.Map; +import java.util.stream.Collectors; /** * <p> @@ -48,22 +53,30 @@ @Autowired SpecialDeviceMapper specialDeviceMapper; + + @Autowired + private HistorySecondCruiserMapper historySecondCruiserMapper; + @Autowired RedisTemplate redisTemplate; private final static Double dis = 50d; @Override - public List<Map<String, Object>> getCarsInfo() { + public List<Map<String, Object>> selectCruisers() { //������������������������ 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"); + //��������������������� + List<Organization> organizations = organizationService.getChildrenOrganizationsById(orgId); + List<Integer> orgIds = organizations.stream().map(Organization::getId).collect(Collectors.toList()); + orgIds.add(orgId); QueryWrapper<SpecialDeviceHistory> queryWrapper = new QueryWrapper<>(); queryWrapper.select("mac", "name") - .eq("organization_id", orgId) - .eq("special_type", Constants.SPECIAL_DEVICE_CAR) - .eq("is_delete", Constants.NOT_DELETE); + .eq("special_type", Constants.SPECIAL_DEVICE_CRUISER) + .eq("is_delete", Constants.NOT_DELETE) + .in("organization_id", orgIds); return specialDeviceHistoryService.listMaps(queryWrapper); } @@ -98,22 +111,30 @@ } @Override - public Map<String,Object> getSpecialDeviceMapByMac(String mac) { - //������������������ - Map<String,Object> specialDeviceMap = (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstants.DEVICE,mac); - return specialDeviceMap; - } - - @Override - public SpecialDevice getSpecialDeviceByMac(String mac) { + public SpecialDevice getSpecialDeviceMapByMac(String mac) { QueryWrapper<SpecialDevice> queryWrapper = new QueryWrapper(); - queryWrapper.eq("mac",mac); - queryWrapper.eq("is_delete",Constants.NOT_DELETE); + queryWrapper.eq("mac", mac); + queryWrapper.eq("is_delete", Constants.NOT_DELETE); SpecialDevice specialDevice = specialDeviceMapper.selectOne(queryWrapper); return specialDevice; } + @Override + public List<String> getDatesByMac(String mac) { + Map<String, Object> userInfo = (Map) TokenUtils.getUserInfo(); + Map<String, Object> orgInfo = (Map) userInfo.get("organization"); + Integer orgId = (Integer) orgInfo.get("id"); + + Map<String, Object> params = new HashMap<>(); + params.put("orgId", orgId); + params.put("mac", mac); + Date start = DateUtils.addMonths(new Date(), -6); + params.put("start", DateUtils.dateToDateString(start)); + return historySecondCruiserMapper.getDates(params); + } + + //������������������������ private List<Map<String, Object>> filterData(List<Map<String, Object>> data) { List<Map<String, Object>> result = new ArrayList<>(); -- Gitblit v1.8.0