From 7c32c8a9ec7943112360adc839e5292be40db74d Mon Sep 17 00:00:00 2001 From: 于紫祥_1901 <email@yuzixiang_1910> Date: Mon, 24 Aug 2020 16:07:48 +0800 Subject: [PATCH] 风场图update --- src/main/java/com/moral/service/HistoryService.java | 2 ++ src/main/java/com/moral/service/impl/HistoryServiceImpl.java | 6 ++++++ src/main/java/com/moral/mapper/HistoryMapper.java | 3 +++ src/main/resources/mapper/HistoryMapper.xml | 5 +++++ src/main/java/com/moral/controller/ScreenController.java | 7 ++++--- 5 files changed, 20 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/moral/controller/ScreenController.java b/src/main/java/com/moral/controller/ScreenController.java index af81612..867b4ec 100644 --- a/src/main/java/com/moral/controller/ScreenController.java +++ b/src/main/java/com/moral/controller/ScreenController.java @@ -1959,6 +1959,9 @@ if (mac!=null){ Device device=deviceService.byMacGetDevice(mac); List list1= LatLngTransformation.Convert_BD09_To_GCJ02(device.getLatitude(),device.getLongitude()); + if (device.getState()!=4+""){ + devMap.put("state",device.getState()); + } devMap.put("lat",list1.get(1)); devMap.put("lng",list1.get(0)); devMap.put("monitorPointId",device.getMonitorPointId()); @@ -1990,8 +1993,6 @@ mon=""+month; } String table="history_minutely_"+year+mon; - log.info(table); - log.info(time); List list=deviceService.byMonitorIdGetDeviceAndWind(monitorPointId,time,table); return list; } @@ -2021,7 +2022,7 @@ @ApiOperation(value = "���������������������������", notes = "���������������������������") @ApiImplicitParams(value = { @ApiImplicitParam(name = "monitorPointId", defaultValue = "1", value = "���������id", required = true, paramType = "query", dataType = "String"), - @ApiImplicitParam(name = "time", value = "������(���������2020-03-19)", required = true, paramType = "query", dataType = "String")}) + @ApiImplicitParam(name = "time", value = "���6���(���������2020-03-19)", required = true, paramType = "query", dataType = "String")}) public ResultBean<List<Map<String, Object>>> getWeatherNextDayDataByRegion(HttpServletRequest request) throws Exception { Map<String, Object> parameters = getParametersStartingWith(request, null); List<Map<String, Object>> resultList = weatherService.getForecastAndReal(parameters); diff --git a/src/main/java/com/moral/mapper/HistoryMapper.java b/src/main/java/com/moral/mapper/HistoryMapper.java index fdfc45b..3b6d2ea 100644 --- a/src/main/java/com/moral/mapper/HistoryMapper.java +++ b/src/main/java/com/moral/mapper/HistoryMapper.java @@ -39,4 +39,7 @@ int getNum(@Param("timef") String timef, @Param("timea") String timea); + String getJsonData(@Param("mac") String mac, + @Param("time") String time, + @Param("table") String table); } \ No newline at end of file diff --git a/src/main/java/com/moral/service/HistoryService.java b/src/main/java/com/moral/service/HistoryService.java index 2ab5e0e..ebcae1f 100644 --- a/src/main/java/com/moral/service/HistoryService.java +++ b/src/main/java/com/moral/service/HistoryService.java @@ -36,5 +36,7 @@ //������������������������������ List<Map<String, Object>> getO3AVG(Map<String, Object> parameters); + String getJsonData(String mac,String time,String table); + } diff --git a/src/main/java/com/moral/service/impl/HistoryServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryServiceImpl.java index 03d2ccb..42c7456 100644 --- a/src/main/java/com/moral/service/impl/HistoryServiceImpl.java +++ b/src/main/java/com/moral/service/impl/HistoryServiceImpl.java @@ -644,4 +644,10 @@ } return maxList; } + + @Override + public String getJsonData(String mac, String time,String table) { + return historyMapper.getJsonData(mac,time,table); + } + } diff --git a/src/main/resources/mapper/HistoryMapper.xml b/src/main/resources/mapper/HistoryMapper.xml index 05c8a4c..c4ba95d 100644 --- a/src/main/resources/mapper/HistoryMapper.xml +++ b/src/main/resources/mapper/HistoryMapper.xml @@ -286,5 +286,10 @@ and mac=#{mac} ORDER BY `time` </select> + <select id="getJsonData" resultType="java.lang.String"> + select `json` from ${table} + where time = #{time} and mac = #{mac} + </select> + </mapper> \ No newline at end of file -- Gitblit v1.8.0