From b74c296ce3c58de5803b2cfea0f41efccb7b89cd Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Mon, 20 Dec 2021 14:06:50 +0800 Subject: [PATCH] 根据字典类型获取字典数据列表 --- screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java | 31 +++++++++++++++++++++---------- 1 files changed, 21 insertions(+), 10 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java index 98bffb3..3541861 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java @@ -22,6 +22,7 @@ import java.util.List; import java.util.Map; +import java.util.stream.Collectors; /** * <p> @@ -86,7 +87,6 @@ queryWrapper.select("mac", "name").in("mac", macs); List<Device> devices = deviceMapper.selectList(queryWrapper); - //������������ List<String> times = (List<String>) params.remove("times"); //������code @@ -100,7 +100,8 @@ for (String start : times) { if ("hour".equals(type)) { end = DateUtils.getDateAddDay(start, 1); - timeUnits = "hourly"; + String yearAndMonth = DateUtils.dateToDateString(DateUtils.getDate(start, DateUtils.yyyy_MM_dd_EN), DateUtils.yyyyMM_EN); + timeUnits = "hourly_" + yearAndMonth; dateFormat = "%Y-%m-%d %H"; } else if ("day".equals(type)) { end = DateUtils.getDateAddMonth(start, 1); @@ -146,26 +147,36 @@ @Override public Device getDeviceByMac(String mac) { - Map<String,Object> deviceMap = (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstants.DEVICE,mac); + Map<String, Object> deviceMap = (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstants.DEVICE, mac); Device device = JSON.parseObject(JSON.toJSONString(deviceMap), Device.class); //���map������organizationId���monitorPointId������versionId - Map<String,Object> organizationMap = (Map<String,Object>)deviceMap.get("organization"); - Map<String,Object> monitorPointMap = (Map<String,Object>)deviceMap.get("monitorPoint"); - Map<String,Object> versionMap = (Map<String,Object>)deviceMap.get("version"); + Map<String, Object> organizationMap = (Map<String, Object>) deviceMap.get("organization"); + Map<String, Object> monitorPointMap = (Map<String, Object>) deviceMap.get("monitorPoint"); + Map<String, Object> versionMap = (Map<String, Object>) deviceMap.get("version"); device.setDeviceVersionId((Integer) versionMap.get("id")); device.setOrganizationId((Integer) organizationMap.get("id")); device.setMonitorPointId((Integer) monitorPointMap.get("id")); //������������������������������������ - if(ObjectUtils.isEmpty(device)){ + if (ObjectUtils.isEmpty(device)) { return getDeviceByMacFromDB(mac); } return device; } - private Device getDeviceByMacFromDB(String mac){ + @Override + public List<Map<String, Object>> getDevicesByOrganizationId(Integer orgId) { + //������������������mac + QueryWrapper<Device> queryWrapper = new QueryWrapper<>(); + queryWrapper.select("mac").eq("organization_id", orgId).eq("is_delete", Constants.NOT_DELETE); + List<Device> devices = deviceMapper.selectList(queryWrapper); + //���redis������������������������ + return devices.stream().map(device -> (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstants.DEVICE, device.getMac())).collect(Collectors.toList()); + } + + private Device getDeviceByMacFromDB(String mac) { QueryWrapper<Device> wrapper = new QueryWrapper<>(); - wrapper.eq("mac",mac); - wrapper.eq("is_delete",Constants.NOT_DELETE); + wrapper.eq("mac", mac); + wrapper.eq("is_delete", Constants.NOT_DELETE); return deviceMapper.selectOne(wrapper); } -- Gitblit v1.8.0