From df67fe187fae9ce9f486ea2f14c95a14d843e4a1 Mon Sep 17 00:00:00 2001 From: cjl <276999030@qq.com> Date: Wed, 15 Nov 2023 14:23:56 +0800 Subject: [PATCH] fix:增加导出功能 --- screen-api/src/main/java/com/moral/api/controller/HistoryHourlyController.java | 32 ++++++++++++++++++++++++++++++++ 1 files changed, 32 insertions(+), 0 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/controller/HistoryHourlyController.java b/screen-api/src/main/java/com/moral/api/controller/HistoryHourlyController.java index ed5ad5b..85c1ad0 100644 --- a/screen-api/src/main/java/com/moral/api/controller/HistoryHourlyController.java +++ b/screen-api/src/main/java/com/moral/api/controller/HistoryHourlyController.java @@ -8,6 +8,7 @@ import com.moral.api.mapper.OrganizationMapper; import com.moral.api.service.AlarmInfoService; import com.moral.api.service.HistoryHourlyService; +import com.moral.api.vo.HistoryHourlyVo; import com.moral.constant.Constants; import com.moral.constant.ResponseCodeEnum; import com.moral.constant.ResultMessage; @@ -100,4 +101,35 @@ return ResultMessage.ok(resultList); } + @RequestMapping(value = "test2", method = RequestMethod.GET) + @ResponseBody + public ResultMessage test2(HttpServletRequest request){ + Map<String, Object> parameters = WebUtils.getParametersStartingWith(request,null); + Object mac = parameters.get("mac"); + Object sensorCode = parameters.get("sensor_code"); +// Object date = parameters.get("date"); + Object startTime = parameters.get("startTime"); + Object endTime = parameters.get("endTime"); + if (ObjectUtils.isEmpty(mac) || ObjectUtils.isEmpty(sensorCode) || ObjectUtils.isEmpty(startTime)|| ObjectUtils.isEmpty(endTime)){ + return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg()); + } + QueryWrapper<Device> deviceQueryWrapper = new QueryWrapper<>(); + deviceQueryWrapper.eq("is_delete",Constants.NOT_DELETE); + deviceQueryWrapper.eq("mac",mac); + Device device = deviceMapper.selectOne(deviceQueryWrapper); + if (ObjectUtils.isEmpty(device)){ + return ResultMessage.fail(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode(), ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg()); + } + List<Map<String, Object>> resultList = historyHourlyService.getHourCompleteDataByMacSensorCodeDate(parameters); + return ResultMessage.ok(resultList); + } + + + @RequestMapping(value = "historyHourlyTest", method = RequestMethod.POST) + public ResultMessage historyHourlyTest(HistoryHourlyVo historyHourlyVo){ + historyHourlyService.historyHourly(historyHourlyVo); + return ResultMessage.ok(); + } + + } -- Gitblit v1.8.0