DataQueryController.java 3.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
  1. package com.usky.backend.controller;
  2. import com.usky.backend.domain.StatusVO;
  3. import com.usky.backend.domain.request.HistoryQueryVo;
  4. import com.usky.backend.domain.request.LastQueryVo;
  5. import com.usky.backend.domain.response.HistoryResultVo;
  6. import com.usky.backend.domain.response.LastResultVo;
  7. import com.usky.backend.domain.DataAverageExportVO;
  8. import com.usky.backend.domain.DataAverageRequestVO;
  9. import com.usky.backend.domain.DataAverageResponseVO;
  10. import com.usky.backend.domain.DataTotalRequestVO;
  11. import com.usky.backend.service.DataQueryService;
  12. import com.usky.common.core.bean.ApiResult;
  13. import com.usky.common.core.utils.poi.ExcelUtil;
  14. import io.swagger.annotations.Api;
  15. import io.swagger.annotations.ApiOperation;
  16. import org.springframework.beans.factory.annotation.Autowired;
  17. import org.springframework.web.bind.annotation.*;
  18. import javax.servlet.http.HttpServletResponse;
  19. import java.io.IOException;
  20. import java.util.List;
  21. import java.util.Map;
  22. /**
  23. * <p>
  24. * 数据统一查询 前端控制器
  25. * </p>
  26. *
  27. */
  28. @RestController
  29. @Api(tags = "数据统一查询")
  30. @RequestMapping("/dataQuery")
  31. public class DataQueryController {
  32. @Autowired
  33. private DataQueryService dataQueryService;
  34. /**
  35. * 获取单个设备单属性历史数据
  36. *
  37. * @param startTime 开始时间
  38. * @param endTime 结束时间
  39. * @param deviceId 设备Id
  40. * @param metric 属性
  41. * @param typeAbbrevia 设备类型简称
  42. * @return
  43. */
  44. @GetMapping("/historyMetric")
  45. @ApiOperation("获取单个设备单属性历史数据")
  46. public ApiResult<HistoryResultVo> historyMetric(@RequestParam("startTime") String startTime,
  47. @RequestParam("endTime") String endTime,
  48. @RequestParam("deviceId") String deviceId,
  49. @RequestParam("metric") String metric,
  50. @RequestParam("typeAbbrevia") String typeAbbrevia) {
  51. return ApiResult.success(dataQueryService.historyMetric(deviceId,metric,startTime,endTime,typeAbbrevia));
  52. }
  53. @PostMapping("/historyMetrics")
  54. @ApiOperation("获取单个设备多属性历史数据")
  55. public ApiResult<List<HistoryResultVo>> historyMetrics(@RequestBody HistoryQueryVo historyQueryVo) {
  56. return ApiResult.success(dataQueryService.historyMetrics(historyQueryVo));
  57. }
  58. /**
  59. * 获取单个设备多指标实时数据
  60. * @param lastQueryVo
  61. * @return
  62. */
  63. @PostMapping("/last")
  64. @ApiOperation("获取单个设备多指标实时数据")
  65. public ApiResult<List<LastResultVo>> last(@RequestBody LastQueryVo lastQueryVo) {
  66. return ApiResult.success(dataQueryService.last(lastQueryVo));
  67. }
  68. /**
  69. * 查询设备状态
  70. * @return
  71. */
  72. @GetMapping("status")
  73. @ApiOperation(value = "查询设备状态",response = List.class)
  74. public ApiResult<List<StatusVO>> status(){
  75. return ApiResult.success(dataQueryService.status());
  76. }
  77. }