From ef9692dd7a43e0620632e48ef295da738da50f90 Mon Sep 17 00:00:00 2001 From: riku <risaku@163.com> Date: 星期三, 27 十月 2021 16:10:15 +0800 Subject: [PATCH] 1. 监测数据根据设备类型不同分别存储不同数据表 2. 车载数据部分监测因子进行量级调整 3. 无人机监测数据部分监测因子由于偏差较大采用车载数据填充 4. 监测数据存储之前先进行平滑预处理,矫正异常值 --- src/main/kotlin/com/flightfeather/uav/lightshare/service/RealTimeDataService.kt | 13 +++++++++++++ 1 files changed, 13 insertions(+), 0 deletions(-) diff --git a/src/main/kotlin/com/flightfeather/uav/lightshare/service/RealTimeDataService.kt b/src/main/kotlin/com/flightfeather/uav/lightshare/service/RealTimeDataService.kt index a1314d8..de198db 100644 --- a/src/main/kotlin/com/flightfeather/uav/lightshare/service/RealTimeDataService.kt +++ b/src/main/kotlin/com/flightfeather/uav/lightshare/service/RealTimeDataService.kt @@ -3,7 +3,10 @@ import com.flightfeather.uav.lightshare.bean.BaseResponse import com.flightfeather.uav.lightshare.bean.DataImportResult import com.flightfeather.uav.lightshare.bean.DataVo +import org.apache.poi.hssf.usermodel.HSSFWorkbook +import org.apache.poi.xssf.streaming.SXSSFWorkbook import org.springframework.web.multipart.MultipartFile +import javax.servlet.http.HttpServletResponse interface RealTimeDataService { @@ -12,4 +15,14 @@ fun getNextData(deviceCode: String, updateTime: String, page: Int?, perPage: Int?): BaseResponse<List<DataVo>> fun importData(file: MultipartFile): BaseResponse<DataImportResult> + + fun outToWorkbook(deviceCode: String, startTime: String, endTime: String): SXSSFWorkbook + + fun outToExcel(deviceCode: String, startTime: String, endTime: String, response: HttpServletResponse): HttpServletResponse + + /** + * 鏁版嵁澶勭悊 + * 鍘婚櫎鍘熷鏁版嵁涓殑寮傚父娉㈠姩鍊� + */ + fun dataPreprocessing(): BaseResponse<String> } \ No newline at end of file -- Gitblit v1.9.3