| | |
| | | import com.moral.common.exception.WebAuthException; |
| | | import com.moral.common.util.*; |
| | | import com.moral.common.webAnno.UserLoginToken; |
| | | import com.moral.entity.AreaNames; |
| | | import com.moral.entity.Device; |
| | | import com.moral.entity.MonitorPoint; |
| | | import com.moral.entity.Organization; |
| | | import com.moral.entity.*; |
| | | import com.moral.mapper.MapPathMapper; |
| | | import com.moral.service.*; |
| | | import com.moral.util.DateUtil; |
| | | import com.moral.util.LatLngTransformation; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import jdk.nashorn.internal.runtime.logging.Logger; |
| | | import org.springframework.util.ObjectUtils; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import javax.annotation.PostConstruct; |
| | | import javax.annotation.Resource; |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.text.ParseException; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | |
| | | @CrossOrigin(origins = "*", maxAge = 3600) |
| | | @SuppressWarnings({"rawtypes", "unchecked", "unused"}) |
| | | public class WebController { |
| | | |
| | | private static Map<String, Sensor> sensors; |
| | | |
| | | @PostConstruct |
| | | public void init() { |
| | | sensors = new HashMap<>(); |
| | | List<Sensor> allSensors = sensorService.getAllSensors(); |
| | | for (Sensor sensor : allSensors) { |
| | | sensors.put(sensor.getSensorKey(), sensor); |
| | | } |
| | | } |
| | | |
| | | @Resource |
| | | AccountService accountService; |
| | | @Resource |
| | | DictionaryDataService dictionaryDataService; |
| | | @Resource |
| | | OrganizationService organizationService; |
| | | @Resource |
| | | WebTokenService webTokenService; |
| | |
| | | MonitorPointService monitorPointService; |
| | | @Resource |
| | | DeviceService deviceService; |
| | | @Resource |
| | | HistoryFiveMinutelyService historyFiveMinutelyService; |
| | | @Resource |
| | | SensorService sensorService; |
| | | @Resource |
| | | OrganizationSensorsService organizationSensorsService; |
| | | @Resource |
| | | MapPathService mapPathService; |
| | | |
| | | |
| | | @UserLoginToken |
| | | @GetMapping("test") |
| | | public String add() { |
| | | return "test success!"; |
| | | public ResultBean<List<WebProvince>> add(HttpServletRequest request) { |
| | | String token = request.getHeader("token"); |
| | | List<WebProvince> mapPath = mapPathService.getMapPath(token); |
| | | if (ObjectUtils.isEmpty(mapPath)) |
| | | return new ResultBean<>("获取地图信息失败", ResultBean.FAIL); |
| | | return new ResultBean<>(mapPath); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 登陆接口 |
| | | * @Param: [parameters] |
| | | * @return: java.util.Map<java.lang.String,java.lang.Object> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | /** |
| | | * @Description: 登陆接口 |
| | | * @Param: [parameters] |
| | | * @return: java.util.Map<java.lang.String , java.lang.Object> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | @PostMapping("login") |
| | | public Map<String, Object> login(@RequestBody Map<String, Object> parameters) { |
| | | Map<String, Object> resultMap = new HashMap<String, Object>(); |
| | |
| | | resultMap.put("msg", "用户名及密码不允许为空!"); |
| | | resultMap.put("accountId", -1); |
| | | } else { |
| | | resultMap = accountService.webLogin(parameters); |
| | | resultMap = accountService.bsWebLogin(parameters); |
| | | String accountId = String.valueOf(resultMap.get("accountId")); |
| | | if (!accountId.equals("-1")) { |
| | | redisHashUtil.deleteMapVal("webToken",accountId); |
| | | redisHashUtil.deleteMapVal("webToken", accountId); |
| | | resultMap.put("token", webTokenService.getToken(accountId)); |
| | | } |
| | | } |
| | | return resultMap; |
| | | } |
| | | |
| | | /** |
| | | * @Description: 退出接口 |
| | | * @Param: [request] |
| | | * @return: java.util.Map<java.lang.String,java.lang.Object> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | /** |
| | | * @Description: 退出接口 |
| | | * @Param: [request] |
| | | * @return: java.util.Map<java.lang.String , java.lang.Object> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | @UserLoginToken |
| | | @PostMapping("logout") |
| | | public Map<String, Object> logout(HttpServletRequest request) { |
| | | Map<String, Object> resultMap = new HashMap<>(); |
| | | String token = request.getHeader("token"); |
| | | String id = WebTokenUtils.getIdBytoken(token); |
| | | redisHashUtil.addMapOne("webToken", String.valueOf(id),token); |
| | | String id = WebTokenUtils.getIdBytoken(token); |
| | | redisHashUtil.addMapOne("webToken", String.valueOf(id), token); |
| | | resultMap.put("msg", "退出成功!"); |
| | | return resultMap; |
| | | } |
| | | |
| | | /** |
| | | * @Description: |
| | | * @Param: [request] |
| | | * @return: java.util.Map<java.lang.String,java.lang.Object> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | public static void main(String[] args) { |
| | | |
| | | } |
| | | |
| | | @UserLoginToken |
| | | @GetMapping("getAccountInfo") |
| | | public Map<String, Object> getAccountInfo(HttpServletRequest request) { |
| | |
| | | throw new WebAuthException("401,token无效"); |
| | | } |
| | | Map<String, Object> resultMap = accountService.getAccountInfoById(id); |
| | | Object orgId = resultMap.get("orgId"); |
| | | if (resultMap.get("orgId") != null && resultMap.get("orgId") instanceof Integer) { |
| | | StringBuilder areaNamesBuilder = new StringBuilder("中国"); |
| | | //判断是否为本公司开发者 |
| | | if (!((Integer) orgId).equals(dictionaryDataService.querySupperOrgId())) { |
| | | //不是本公司开发者则获取用户所属地区 |
| | | Organization organization = organizationService.getOrganizationById((Integer) orgId); |
| | | if (organization.getAreaNames() != null) { |
| | | Map<String, String> areaNameMap = BeanUtils.beanToMap(organization.getAreaNames()); |
| | | List<String> names = areaNameMap.entrySet().stream().filter(item -> { |
| | | return item.getValue() != null; |
| | | }).map(item -> { |
| | | return item.getValue(); |
| | | }).collect(Collectors.toList()); |
| | | AreaNames areaNames = organization.getAreaNames(); |
| | | areaNamesBuilder.append("/"); |
| | | areaNamesBuilder.append(String.join("/", names)); |
| | | } |
| | | // 企业用户 |
| | | if (organization.getRank() != null && organization.getRank() == 0) { |
| | | resultMap.put("type", "enterprise"); |
| | | } else { |
| | | resultMap.put("type", "government"); |
| | | } |
| | | Number mapAreaCode = null; |
| | | if (organization.getVillageCode() != null) { |
| | | mapAreaCode = organization.getVillageCode(); |
| | | } else if (organization.getTownCode() != null) { |
| | | mapAreaCode = organization.getTownCode(); |
| | | } else if (organization.getAreaCode() != null) { |
| | | mapAreaCode = organization.getAreaCode(); |
| | | } else if (organization.getCityCode() != null) { |
| | | mapAreaCode = organization.getCityCode(); |
| | | } else if (organization.getProvinceCode() != null) { |
| | | mapAreaCode = organization.getProvinceCode(); |
| | | } |
| | | resultMap.put("mapAreaCode", mapAreaCode.toString()); |
| | | } |
| | | resultMap.put("mapPath", areaNamesBuilder.toString()); |
| | | String accountId = String.valueOf(resultMap.get("accountId")); |
| | | resultMap.put("token", webTokenService.getToken(accountId)); |
| | | } |
| | | String accountId = String.valueOf(resultMap.get("accountId")); |
| | | resultMap.put("token", webTokenService.getToken(accountId)); |
| | | |
| | | return resultMap; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 获取传感器平均值 |
| | | * @Param: [request] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.List<java.util.Map<java.lang.String,java.lang.Object>>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | /** |
| | | * @Description: 获取传感器平均值 |
| | | * @Param: [request] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.List < java.util.Map < java.lang.String , java.lang.Object>>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | @UserLoginToken |
| | | @GetMapping("report_avg_datas") |
| | | public ResultBean<List<Map<String, Object>>> getMonitorPointOrDeviceAvgData(HttpServletRequest request) |
| | |
| | | String time = map.get("time").toString(); |
| | | time = time.substring(time.length() - 2); |
| | | map.put("time", Integer.valueOf(time)); |
| | | if(parameters.get("type").equals("day")){ |
| | | map.put("time", Integer.valueOf(time)+1); |
| | | if (parameters.get("type").equals("day")) { |
| | | map.put("time", Integer.valueOf(time) + 1); |
| | | } |
| | | map.put("value", map.remove(sensorKey)); |
| | | } |
| | |
| | | } |
| | | |
| | | /** |
| | | * @Description: 获取某个站点设备信息 |
| | | * @Param: [request] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.List<com.moral.entity.MonitorPoint>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | * @Description: 获取某个站点设备信息 |
| | | * @Param: [request] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.List < com.moral.entity.MonitorPoint>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | @UserLoginToken |
| | | @GetMapping("monitorpoints-devices") |
| | | public ResultBean<List<MonitorPoint>> getMonitorPointsAndDevicesByRegion(HttpServletRequest request) |
| | |
| | | } |
| | | |
| | | /** |
| | | * @Description: 获取坐标接口,前端用于建点 |
| | | * @Param: [request] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.List<com.moral.entity.Device>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | /* @UserLoginToken*/ |
| | | * @Description: 获取坐标接口,前端用于建点 |
| | | * @Param: [request] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.List < com.moral.entity.Device>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | /* @UserLoginToken*/ |
| | | @GetMapping("coordinates") |
| | | public ResultBean<List<Device>> getDeviceCoordinatesAndState(HttpServletRequest request){ |
| | | public ResultBean<List<Device>> getDeviceCoordinatesAndState(HttpServletRequest request) { |
| | | Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null); |
| | | ParameterUtils.getRegionType4RegionCode(parameters); |
| | | return new ResultBean<List<Device>>(deviceService.queryDevice(parameters)); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 根据monitorId获取该站点下每一台设备具体传感器的五分钟平均值 |
| | | * @Param: [] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.Map<java.lang.String,java.lang.Object>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | * @Description: 根据monitorId获取该站点下每一台设备具体传感器的五分钟平均值 |
| | | * @Param: [] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.Map < java.lang.String , java.lang.Object>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | |
| | | @GetMapping("fiveMinuteAvgData") |
| | | public ResultBean<List<Map<String, Object>>> getSensorFiveMinuteAvgData(HttpServletRequest request){ |
| | | //获取参数,传感器和monitorpointId |
| | | @UserLoginToken |
| | | @GetMapping("fiveMinuteAvgDataNew") |
| | | public ResultBean<Map<String, Object>> getSensorFiveMinuteAvgDataNew(HttpServletRequest request) { |
| | | //获取参数,传感器和regionCode |
| | | Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null); |
| | | if((!parameters.containsKey("sensorKey"))||(!parameters.containsKey("monitorPointId"))) |
| | | return ResultBean.fail("参数为null"); |
| | | if ((!parameters.containsKey("sensorKey")) || (!parameters.containsKey("regionCode"))) |
| | | return ResultBean.fail("参数为null"); |
| | | String sensorKey = (String) parameters.get("sensorKey"); |
| | | Integer monitorPointId = Integer.parseInt((String) parameters.get("monitorPointId")); |
| | | String regionCode = (String) parameters.get("regionCode"); |
| | | String token = request.getHeader("token"); |
| | | |
| | | //根据monitorpointId获取该站点下所有设备mac集合 |
| | | List<Device> devices = deviceService.getDevicesByMonitorPointId(monitorPointId); |
| | | if(ObjectUtils.isEmpty(devices)) |
| | | return ResultBean.fail("站点下无设备或monitorPointId错误"); |
| | | //根据orgId获取该站点下所有设备mac集合 |
| | | String accountId = WebTokenUtils.getIdBytoken(token); |
| | | Account account = accountService.getAccountById(Integer.parseInt(accountId)); |
| | | parameters.put("organizationId", account.getOrganizationId()); |
| | | List<MonitorPoint> monitorPoints = monitorPointService.getMonitorPointsAndDevicesByRegionNew(parameters); |
| | | if (ObjectUtils.isEmpty(monitorPoints)) |
| | | return ResultBean.fail("该账号对应地区无站点"); |
| | | |
| | | List<Device> devices = new ArrayList<>(); |
| | | for (MonitorPoint monitorPoint : monitorPoints) { |
| | | if (!ObjectUtils.isEmpty(monitorPoint.getDevices())) |
| | | devices.addAll(monitorPoint.getDevices()); |
| | | } |
| | | if (ObjectUtils.isEmpty(devices)) |
| | | return ResultBean.fail("该账号对应地区无设备"); |
| | | |
| | | List<String> macs = new ArrayList<>(); |
| | | devices.forEach(p->{ |
| | | devices.forEach(p -> { |
| | | macs.add(p.getMac()); |
| | | }); |
| | | |
| | | //根据时间和mac号集合以及传感器参数查询五分钟平均数据 |
| | | Map<String, Object> timeAndYearMonth = getTimeAndYearMonthForFiveMinuteData(); |
| | | String time= (String) timeAndYearMonth.get("time"); |
| | | String time = (String) timeAndYearMonth.get("time"); |
| | | String yearAndMonth = (String) timeAndYearMonth.get("yearAndMonth"); |
| | | parameters.put("time",time); |
| | | parameters.put("yearAndMonth",yearAndMonth); |
| | | parameters.put("macs",macs); |
| | | List<Map<String, Object>> datas = historyMinutelyService.getFiveMinutesDataByMacsAndTime(parameters); |
| | | datas = insertDeviceInfo(datas,devices); |
| | | return new ResultBean<List<Map<String, Object>>>(datas); |
| | | parameters.put("time", time); |
| | | parameters.put("yearAndMonth", yearAndMonth); |
| | | parameters.put("macs", macs); |
| | | List<Map<String, Object>> datas = historyFiveMinutelyService.getFiveMinutesDataByMacsAndTime(parameters); |
| | | |
| | | //如果当前五分钟数据还没有插入,则提取前五分钟数据返回 |
| | | if (ObjectUtils.isEmpty(datas)) { |
| | | time = getFiveMinuteAgoTime(time); |
| | | parameters.put("time", time); |
| | | datas = historyFiveMinutelyService.getFiveMinutesDataByMacsAndTime(parameters); |
| | | } |
| | | datas = insertDeviceInfo(datas, devices); |
| | | |
| | | //根据monitorPointId获取国控站坐标 |
| | | List<Map<String, Object>> coordinate = new ArrayList<>(); |
| | | Integer orgId = account.getOrganizationId(); |
| | | monitorPoints.forEach(value -> { |
| | | if ("国控站".equals(value.getDescription())) { |
| | | List list = LatLngTransformation.Convert_BD09_To_GCJ02(value.getLatitude(), value.getLongitude()); |
| | | Map<String, Object> controlStation = new HashMap<>(); |
| | | controlStation.put("name", value.getName()); |
| | | controlStation.put("longitude", list.get(0)); |
| | | controlStation.put("latitude", list.get(1)); |
| | | coordinate.add(controlStation); |
| | | } |
| | | }); |
| | | |
| | | Map<String, Object> datasMap = new HashMap<>(); |
| | | datasMap.put("coordinate", coordinate); |
| | | datasMap.put("device", datas); |
| | | |
| | | return new ResultBean<Map<String, Object>>(datasMap); |
| | | } |
| | | |
| | | @GetMapping("fiveMinuteAvgData") |
| | | public ResultBean<Map<String, Object>> getSensorFiveMinuteAvgData(HttpServletRequest request) { |
| | | //获取参数,传感器和monitorpointId |
| | | Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null); |
| | | if ((!parameters.containsKey("sensorKey")) || (!parameters.containsKey("monitorPointId"))) |
| | | return ResultBean.fail("参数为null"); |
| | | String sensorKey = (String) parameters.get("sensorKey"); |
| | | Integer monitorPointId = Integer.parseInt((String) parameters.get("monitorPointId")); |
| | | |
| | | //根据monitorpointId获取该站点下所有设备mac集合 |
| | | List<Device> devices = deviceService.getDevicesByMonitorPointId(monitorPointId); |
| | | if (ObjectUtils.isEmpty(devices)) |
| | | return ResultBean.fail("站点下无设备或monitorPointId错误"); |
| | | List<String> macs = new ArrayList<>(); |
| | | devices.forEach(p -> { |
| | | macs.add(p.getMac()); |
| | | }); |
| | | |
| | | //根据时间和mac号集合以及传感器参数查询五分钟平均数据 |
| | | Map<String, Object> timeAndYearMonth = getTimeAndYearMonthForFiveMinuteData(); |
| | | String time = (String) timeAndYearMonth.get("time"); |
| | | String yearAndMonth = (String) timeAndYearMonth.get("yearAndMonth"); |
| | | parameters.put("time", time); |
| | | parameters.put("yearAndMonth", yearAndMonth); |
| | | parameters.put("macs", macs); |
| | | List<Map<String, Object>> datas = historyFiveMinutelyService.getFiveMinutesDataByMacsAndTime(parameters); |
| | | |
| | | //如果当前五分钟数据还没有插入,则提取前五分钟数据返回 |
| | | if (ObjectUtils.isEmpty(datas)) { |
| | | time = getFiveMinuteAgoTime(time); |
| | | parameters.put("time", time); |
| | | datas = historyFiveMinutelyService.getFiveMinutesDataByMacsAndTime(parameters); |
| | | } |
| | | datas = insertDeviceInfo(datas, devices); |
| | | |
| | | //根据monitorPointId获取国控站坐标 |
| | | List<Map<String, Object>> coordinate = new ArrayList<>(); |
| | | MonitorPoint monitorPoint = monitorPointService.queryMonitorPointById(monitorPointId); |
| | | Integer orgId = monitorPoint.getOrganizationId(); |
| | | List<MonitorPoint> monitorPoints = monitorPointService.getMonitorPointsByOrganizationId(orgId); |
| | | monitorPoints.forEach(value -> { |
| | | if ("国控站".equals(value.getDescription())) { |
| | | List list = LatLngTransformation.Convert_BD09_To_GCJ02(value.getLatitude(), value.getLongitude()); |
| | | Map<String, Object> controlStation = new HashMap<>(); |
| | | controlStation.put("name", value.getName()); |
| | | controlStation.put("longitude", list.get(0)); |
| | | controlStation.put("latitude", list.get(1)); |
| | | coordinate.add(controlStation); |
| | | } |
| | | }); |
| | | |
| | | Map<String, Object> datasMap = new HashMap<>(); |
| | | datasMap.put("coordinate", coordinate); |
| | | datasMap.put("device", datas); |
| | | |
| | | return new ResultBean<Map<String, Object>>(datasMap); |
| | | } |
| | | |
| | | @GetMapping("cangzhouMIdGetAllDevice") |
| | | public ResultBean<Map<String, Object>> cangzhouMIdGetAllDevice(HttpServletRequest request) { |
| | | //获取参数,传感器和monitorpointId |
| | | Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null); |
| | | if ((!parameters.containsKey("sensorKey")) || (!parameters.containsKey("monitorPointId"))) |
| | | return ResultBean.fail("参数为null"); |
| | | String sensorKey = (String) parameters.get("sensorKey"); |
| | | Integer monitorPointId = Integer.parseInt((String) parameters.get("monitorPointId")); |
| | | MonitorPoint mPoint = monitorPointService.queryMonitorPointById(monitorPointId); |
| | | Integer code = mPoint.getCityCode(); |
| | | List<Device> devices = null; |
| | | if (code == 130900) { |
| | | devices = deviceService.getDeviceByCode(); |
| | | } else { |
| | | devices = deviceService.getDevicesByMonitorPointId(monitorPointId); |
| | | } |
| | | //根据monitorpointId获取该站点下所有设备mac集合 |
| | | if (ObjectUtils.isEmpty(devices)) |
| | | return ResultBean.fail("站点下无设备或monitorPointId错误"); |
| | | List<String> macs = new ArrayList<>(); |
| | | devices.forEach(p -> { |
| | | macs.add(p.getMac()); |
| | | }); |
| | | |
| | | //根据时间和mac号集合以及传感器参数查询五分钟平均数据 |
| | | Map<String, Object> timeAndYearMonth = getTimeAndYearMonthForFiveMinuteData(); |
| | | String time = (String) timeAndYearMonth.get("time"); |
| | | String yearAndMonth = (String) timeAndYearMonth.get("yearAndMonth"); |
| | | parameters.put("time", time); |
| | | parameters.put("yearAndMonth", yearAndMonth); |
| | | parameters.put("macs", macs); |
| | | List<Map<String, Object>> datas = historyFiveMinutelyService.getFiveMinutesDataByMacsAndTime(parameters); |
| | | |
| | | //如果当前五分钟数据还没有插入,则提取前五分钟数据返回 |
| | | if (ObjectUtils.isEmpty(datas)) { |
| | | time = getFiveMinuteAgoTime(time); |
| | | parameters.put("time", time); |
| | | datas = historyFiveMinutelyService.getFiveMinutesDataByMacsAndTime(parameters); |
| | | } |
| | | datas = insertDeviceInfo(datas, devices); |
| | | |
| | | //根据monitorPointId获取国控站坐标 |
| | | List<Map<String, Object>> coordinate = new ArrayList<>(); |
| | | MonitorPoint monitorPoint = monitorPointService.queryMonitorPointById(monitorPointId); |
| | | Integer orgId = monitorPoint.getOrganizationId(); |
| | | List<MonitorPoint> monitorPoints = monitorPointService.getMonitorPointsByOrganizationId(orgId); |
| | | monitorPoints.forEach(value -> { |
| | | if ("国控站".equals(value.getDescription())) { |
| | | List list = LatLngTransformation.Convert_BD09_To_GCJ02(value.getLatitude(), value.getLongitude()); |
| | | Map<String, Object> controlStation = new HashMap<>(); |
| | | controlStation.put("name", value.getName()); |
| | | controlStation.put("longitude", list.get(0)); |
| | | controlStation.put("latitude", list.get(1)); |
| | | coordinate.add(controlStation); |
| | | } |
| | | }); |
| | | |
| | | Map<String, Object> datasMap = new HashMap<>(); |
| | | datasMap.put("coordinate", coordinate); |
| | | datasMap.put("device", datas); |
| | | |
| | | return new ResultBean<Map<String, Object>>(datasMap); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 返回结果添加设备经纬度以及state |
| | | * @Param: [datas, devices] |
| | | * @return: java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | public List<Map<String, Object>> insertDeviceInfo(List<Map<String, Object>> datas,List<Device> devices ){ |
| | | Map<String,Device> map = new HashMap<>(); |
| | | devices.forEach(p->{ |
| | | map.put(p.getMac(),p); |
| | | * @Description: 根据mac号获取单台设备信息,特殊客户只显示客户需要的传感器信息 |
| | | * @Param: [request] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.Map < java.lang.String , java.lang.Object>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/22 |
| | | */ |
| | | @GetMapping("fiveMinuteAvgDataByMac") |
| | | public ResultBean<Map<String, Object>> fiveMinuteAvgDataByMac(HttpServletRequest request) { |
| | | //获取参数,mac号 |
| | | Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null); |
| | | if ((!parameters.containsKey("mac"))) |
| | | return ResultBean.fail("参数为null"); |
| | | String mac = (String) parameters.get("mac"); |
| | | |
| | | //根据mac获取orgId |
| | | String orgId = monitorPointService.getOrgIdByMac(mac); |
| | | |
| | | //判断是否特殊定制客户,如果为特殊定制客户则选取特定参数 |
| | | Map<String, Object> specialSensors = organizationSensorsService.getSensorsByOrgId(orgId); |
| | | |
| | | if (ObjectUtils.isEmpty(specialSensors)) { |
| | | List<String> sensorKeys = sensorService.getSensorKeys(); |
| | | parameters.put("sensorKeys", sensorKeys); |
| | | } else { |
| | | String sensorKeys = (String) specialSensors.get("sensors"); |
| | | sensorKeys.trim(); |
| | | sensorKeys = sensorKeys.substring(1, sensorKeys.length() - 1); |
| | | parameters.put("sensorKeys", Arrays.asList(sensorKeys.split(","))); |
| | | } |
| | | |
| | | //设置查询参数 |
| | | Map<String, Object> timeAndYearMonth = getTimeAndYearMonthForFiveMinuteData(); |
| | | String time = (String) timeAndYearMonth.get("time"); |
| | | String yearAndMonth = (String) timeAndYearMonth.get("yearAndMonth"); |
| | | parameters.put("time", time); |
| | | parameters.put("yearAndMonth", yearAndMonth); |
| | | parameters.put("mac", mac); |
| | | |
| | | Map<String, Object> datas = historyFiveMinutelyService.getFiveMinutesDataByMac(parameters); |
| | | |
| | | //如果当前五分钟数据还没有插入,则提取前五分钟数据返回 |
| | | if (ObjectUtils.isEmpty(datas)) { |
| | | time = getFiveMinuteAgoTime(time); |
| | | parameters.put("time", time); |
| | | datas = historyFiveMinutelyService.getFiveMinutesDataByMac(parameters); |
| | | } |
| | | |
| | | |
| | | //去除无效参数 |
| | | datas.values().removeIf((value) -> { |
| | | return ObjectUtils.isEmpty(value) || value.equals("[0, 0, 0]"); |
| | | }); |
| | | |
| | | datas.forEach(p->{ |
| | | //添加设备名称 |
| | | Map<String, Object> sortDatas = new LinkedHashMap<>();//排序后的数据,用于发送前端 |
| | | Device device = deviceService.getDeviceByMac(mac, true); |
| | | sortDatas.put("名称", device.getName()); |
| | | |
| | | //参数转换中文 |
| | | datas.forEach((key, value) -> { |
| | | Sensor sensor = sensors.get(key); |
| | | if (!ObjectUtils.isEmpty(sensor)) { |
| | | String unit = ObjectUtils.isEmpty(sensor.getUnit()) ? "" : (String) sensor.getUnit(); |
| | | String str = (String) value; |
| | | str.trim(); |
| | | str = str.substring(1, str.length() - 1); |
| | | sortDatas.put(sensor.getName(), Arrays.asList(str.split(",")).get(0) + unit); |
| | | } |
| | | }); |
| | | |
| | | sortDatas.put("时间", time); |
| | | |
| | | return new ResultBean<Map<String, Object>>(sortDatas); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 根据token获取用户地图 |
| | | * @Param: [request] |
| | | * @return: com.moral.common.bean.ResultBean<java.util.List < com.moral.entity.WebProvince>> |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/11/27 |
| | | */ |
| | | |
| | | @UserLoginToken |
| | | @GetMapping("mapPath") |
| | | public ResultBean<List<WebProvince>> getMapPath(HttpServletRequest request) { |
| | | String token = request.getHeader("token"); |
| | | List<WebProvince> mapPath = mapPathService.getMapPath(token); |
| | | if (ObjectUtils.isEmpty(mapPath)) |
| | | return new ResultBean<>("获取地图信息失败", ResultBean.FAIL); |
| | | return new ResultBean<>(mapPath); |
| | | } |
| | | |
| | | @UserLoginToken |
| | | @GetMapping("monitor-points") |
| | | public ResultBean<List<MonitorPoint>> getmMnitorPoints(HttpServletRequest request) { |
| | | String accountId = WebTokenUtils.getIdBytoken(request.getHeader("token")); |
| | | Account account = accountService.getAccountById(Integer.parseInt(accountId)); |
| | | String regionCode = request.getParameter("regionCode"); |
| | | Map<String, Object> paramMap = new HashMap<>(); |
| | | paramMap.put("organizationId", account.getOrganizationId()); |
| | | paramMap.put("regionCode", regionCode); |
| | | List<MonitorPoint> monitorPoints = monitorPointService.getMonitorPointsAndDevicesByRegion(paramMap); |
| | | if (ObjectUtils.isEmpty(monitorPoints)) |
| | | return new ResultBean<>("无对应站点设备信息", ResultBean.FAIL); |
| | | return new ResultBean<List<MonitorPoint>>(monitorPoints); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 返回结果添加设备经纬度以及state |
| | | * @Param: [datas, devices] |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | private List<Map<String, Object>> insertDeviceInfo(List<Map<String, Object>> datas, List<Device> devices) { |
| | | Map<String, Device> map = new HashMap<>(); |
| | | devices.forEach(p -> { |
| | | map.put(p.getMac(), p); |
| | | }); |
| | | |
| | | datas.forEach(p -> { |
| | | String mac = (String) p.get("mac"); |
| | | Device device = map.get(mac); |
| | | p.put("longitude",device.getLongitude()); |
| | | p.put("latitude",device.getLatitude()); |
| | | p.put("state",device.getState()); |
| | | List list = LatLngTransformation.Convert_BD09_To_GCJ02(device.getLatitude(), device.getLongitude()); |
| | | p.put("longitude", list.get(0)); |
| | | p.put("latitude", list.get(1)); |
| | | p.put("state", device.getState()); |
| | | }); |
| | | return datas; |
| | | } |
| | | |
| | | /** |
| | | * @Description: 根据当前时间判断要获取五分钟平均数据在数据库中的时间 |
| | | * @Param: [] |
| | | * @return: java.lang.String |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | * @Description: 根据当前时间判断要获取五分钟平均数据在数据库中的时间 |
| | | * @Param: [] |
| | | * @return: java.lang.String |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/19 |
| | | */ |
| | | private Map<String, Object> getTimeAndYearMonthForFiveMinuteData() { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | |
| | | String yearAndMonth = ""; |
| | | String startTime = ""; |
| | | Integer endMinute = Integer.parseInt(String.valueOf(minute.charAt(minute.length() - 1))); |
| | | if (endMinute >= 5) { |
| | | StringBuilder time = new StringBuilder(sdf.format(date)); |
| | | startTime = time.replace(15, 19, "0:00").toString(); |
| | | } else { |
| | | date = DateUtil.rollMinute(date, -5); |
| | | if (endMinute >= 6 || endMinute == 0) {//分钟结尾如果是 6 7 8 9 0 比如12:16,12:20进入, 则获取12:10-12:15的数据 |
| | | date = DateUtil.rollMinute(date, -1); |
| | | StringBuilder time = new StringBuilder(sdf.format(date)); |
| | | startTime = time.replace(15, 19, "5:00").toString(); |
| | | } else {// 分钟结尾如果是1 2 3 4 5 则获取上个五分钟数据 比如12:11分钟进入 则获取12:05-12:10的数据 |
| | | StringBuilder time = new StringBuilder(sdf.format(date)); |
| | | startTime = time.replace(15, 19, "0:00").toString(); |
| | | } |
| | | |
| | | year = DateUtil.getYear(date); |
| | |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 根据传入时间获取五分钟前的数据并且格式化 |
| | | * @Param: [time] |
| | | * @return: java.lang.String |
| | | * @Author: 下雨听风 |
| | | * @Date: 2020/10/20 |
| | | */ |
| | | private String getFiveMinuteAgoTime(String time) { |
| | | try { |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | Date date = sdf.parse(time); |
| | | date = DateUtil.rollMinute(date, -5); |
| | | time = sdf.format(date); |
| | | return time; |
| | | } catch (ParseException e) { |
| | | return null; |
| | | } |
| | | } |
| | | |
| | | |
| | | } |