From 369454bcdbdd0c6fb0fa7ac6ec19112b9b6a179e Mon Sep 17 00:00:00 2001 From: fengxiang <110431245@qq.com> Date: Mon, 26 Mar 2018 14:03:12 +0800 Subject: [PATCH] 数据查询 sql查询优化，一次带出 多项数据 --- src/main/java/com/moral/service/HistoryMinutelyService.java | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/moral/service/HistoryMinutelyService.java b/src/main/java/com/moral/service/HistoryMinutelyService.java index b5a38c3..f1dacc2 100644 --- a/src/main/java/com/moral/service/HistoryMinutelyService.java +++ b/src/main/java/com/moral/service/HistoryMinutelyService.java @@ -1,5 +1,8 @@ package com.moral.service; +import com.moral.entity.charts.LineChartCriteria; +import com.moral.entity.charts.PairData; + import java.util.List; import java.util.Map; @@ -9,7 +12,10 @@ Map<String, List<Object>> getCompareReport(Map<String, Object> parameters) throws Exception; - List<Map<String, Object>> getMonitorPointOrDeviceAvgData4Excel(Map<String, Object> parameters) throws Exception; + List<Map<String, Object>> getMonitorPointOrDeviceAvgData(Map<String, Object> parameters) throws Exception; + + Map<String, Object> getMonthAverageBySensor(Map<String, Object> parameters); + Map<String, List<List<Double>>> queryLineChartDateByCrieria(LineChartCriteria lineChartCriteria); } -- Gitblit v1.8.0