From 71af09a7d35a1146122776bebac8d51c1903beed Mon Sep 17 00:00:00 2001 From: fengxiang <110431245@qq.com> Date: Fri, 04 May 2018 08:55:39 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- src/main/resources/mapper/AlarmMapper.xml | 8 ++++---- src/main/java/com/moral/service/impl/AlarmServiceImpl.java | 24 +++++++++++++----------- src/main/java/com/moral/controller/ScreenController.java | 28 ++++++++++++++++++++++++++-- 3 files changed, 43 insertions(+), 17 deletions(-) diff --git a/src/main/java/com/moral/controller/ScreenController.java b/src/main/java/com/moral/controller/ScreenController.java index 8d3d851..5957588 100644 --- a/src/main/java/com/moral/controller/ScreenController.java +++ b/src/main/java/com/moral/controller/ScreenController.java @@ -7,6 +7,9 @@ import java.io.ByteArrayInputStream; import java.io.InputStream; import java.io.InputStreamReader; +import java.net.InetAddress; +import java.net.URL; +import java.net.URLConnection; import java.util.ArrayList; import java.util.HashMap; import java.util.LinkedHashMap; @@ -262,7 +265,7 @@ * ������������������������������������ *********************************************/ private String fileName = "Version.xml"; - private String ip = "121.40.92.176"; + private String ip = "47.96.19.115"; private String userName = "ftp_user"; private String userPwd = "qwer1234"; private int port = 21; @@ -276,8 +279,9 @@ ftpClient.connect(ip, port); ftpClient.login(userName, userPwd); ftpClient.changeWorkingDirectory(path); - //ftpClient.enterRemotePassiveMode(); ftpClient.enterLocalPassiveMode(); + //ftpClient.enterLocalActiveMode(); + InputStream ins = ftpClient.retrieveFileStream(fileName); BufferedReader reader = new BufferedReader(new InputStreamReader(ins,"utf-8")); String line; @@ -295,6 +299,19 @@ ftpClient.logout(); ftpClient.disconnect(); } + +// String urlStr = "http://www.7drlb.com/apps/Version.xml"; +// URL realUrl = new URL(urlStr); +// URLConnection connection = realUrl.openConnection(); +// connection.connect(); +// StringBuffer result = new StringBuffer(); +// BufferedReader in = new BufferedReader(new InputStreamReader(connection.getInputStream(), "utf-8")); +// String line; +// while ((line = in.readLine()) != null) { +// result.append(line); +// } +// String content = result.toString(); + SAXReader saxReader = new SAXReader(); Document document = saxReader.read(new InputSource(new ByteArrayInputStream(content.getBytes("utf-8")))); Element root = document.getRootElement(); @@ -306,6 +323,13 @@ } return version; } + + public static void main(String[] args) { + ScreenController sc = new ScreenController(); + Version a = sc.index(); + System.out.println(a.getVer()); + } + /** * ������������ * ������ diff --git a/src/main/java/com/moral/service/impl/AlarmServiceImpl.java b/src/main/java/com/moral/service/impl/AlarmServiceImpl.java index c07e707..8b97ca5 100644 --- a/src/main/java/com/moral/service/impl/AlarmServiceImpl.java +++ b/src/main/java/com/moral/service/impl/AlarmServiceImpl.java @@ -70,18 +70,20 @@ Map<String, Object> alarmData = alarmDatas.get(0); List<String> sensors = (List<String>) parameters.get("sensors"); List list = new ArrayList(); - for (String key : alarmData.keySet()) { - for (String sensor : sensors) { - String[] split = sensor.split("-"); - if (key.equals(split[0]) && !"0".equals(alarmData.get(key).toString())) { - Map<String, Object> map = new HashMap<String, Object>(); - if (parameters.containsKey("description")) { - map.put("name", split[3]); - } else { - map.put("name", split[1]); + if (!ObjectUtils.isEmpty(alarmData)) { + for (String key : alarmData.keySet()) { + for (String sensor : sensors) { + String[] split = sensor.split("-"); + if (key.equals(split[0]) && !"0".equals(alarmData.get(key).toString())) { + Map<String, Object> map = new HashMap<String, Object>(); + if (parameters.containsKey("description")) { + map.put("name", split[3]); + } else { + map.put("name", split[1]); + } + map.put("value", alarmData.get(key)); + list.add(map); } - map.put("value", alarmData.get(key)); - list.add(map); } } } diff --git a/src/main/resources/mapper/AlarmMapper.xml b/src/main/resources/mapper/AlarmMapper.xml index 1417b37..b3baecf 100644 --- a/src/main/resources/mapper/AlarmMapper.xml +++ b/src/main/resources/mapper/AlarmMapper.xml @@ -1,7 +1,7 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.moral.mapper.AlarmMapper"> - <select id="getAlarmData" resultType="java.util.Map"> + <select id="getAlarmData" resultType="java.util.LinkedHashMap"> SELECT <if test="dimension=='monitorPoint'"> `name`, @@ -32,11 +32,11 @@ </foreach> </when> <otherwise> - DATE_FORMAT( h.time, '%Y-%m-%d' ) AS 'time' + h.time </otherwise> </choose> FROM - alarm h, + alarm_daily h, device d, monitor_point mp WHERE d.monitor_point_id = mp.id @@ -68,7 +68,7 @@ <if test="dimension=='monitorPoint'"> mp.id, </if> - DATE_FORMAT( h.time, '%Y-%m-%d' ) + h.time ) a <if test="dimension=='monitorPoint'"> GROUP BY name -- Gitblit v1.8.0