| | |
| | | import java.lang.reflect.Array; |
| | | import java.text.DateFormat; |
| | | import java.text.DecimalFormat; |
| | | import java.text.ParseException; |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.LocalDateTime; |
| | | import java.time.format.DateTimeFormatter; |
| | |
| | | |
| | | import com.rabbitmq.client.*; |
| | | import com.rabbitmq.client.Channel; |
| | | |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.models.auth.In; |
| | | import jdk.nashorn.internal.runtime.regexp.joni.Regex; |
| | | import net.sf.json.JSONString; |
| | | |
| | | import org.apache.commons.collections.CollectionUtils; |
| | | import org.apache.commons.collections.MapUtils; |
| | | import org.apache.commons.net.ftp.FTPClient; |
| | |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | import org.xml.sax.InputSource; |
| | | |
| | | import static com.moral.common.util.ResourceUtil.getValue; |
| | | import static com.moral.common.util.WebUtils.getParametersStartingWith; |
| | | import static java.util.Calendar.*; |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | @GetMapping("/contrastFactor") |
| | | @ApiOperation(value = "因子对比", notes = "因子对比") |
| | | @ApiImplicitParams(value = { |
| | |
| | | return alarmData; |
| | | } |
| | | |
| | | @GetMapping("multiDeviceContrast") |
| | | @ApiOperation(value = "多设备因子对比", notes = "多设备因子对比") |
| | | @ApiImplicitParams(value = { |
| | | @ApiImplicitParam(name = "macs", value = "设备mac,如有多个用逗号分隔", required = true, paramType = "query", dataType = "String"), |
| | | @ApiImplicitParam(name = "sensorKey", value = "传感器key", required = true, paramType = "query", dataType = "String"), |
| | | @ApiImplicitParam(name = "time", value = "时间,日期(格式:2018-03-12)", required = true, paramType = "query", dataType = "String"),}) |
| | | public ResultBean<List<Map<String, Object>>> multiDeviceSensor(HttpServletRequest request) throws Exception { |
| | | Map<String, Object> parameters = getParametersStartingWith(request, null); |
| | | ParameterUtils.getTimeType4Time(parameters); |
| | | List<Map<String, Object>> list = historyMinutelyService.getMultiDeviceSensorData(parameters); |
| | | return new ResultBean<List<Map<String, Object>>>(list); |
| | | } |
| | | |
| | | |
| | | @GetMapping("/tellAlarm") |
| | | @ResponseBody |
| | | public List<List> tellAlarm(@Param("states") String states, |
| | | @Param("orgId") String orgId, |
| | | @Param("accountId") String accountId, |
| | | @Param("states1") String states1, |
| | | @Param("regionCode") String regionCode) { |
| | | JSONArray stateList = JSONArray.parseArray(states);//最新的设备数据 |
| | | JSONArray stateList1 = JSONArray.parseArray(states1);//前10秒的设备数据 |
| | | List<List> lookList = new ArrayList<>(); |
| | | Map params = new HashMap(); |
| | | String lookString = ""; |
| | | //判断前十秒数据和现在数据是否相等,如果不相等进入方法 |
| | | //第一次进入接口前十秒数据为null |
| | | if (stateList1 != null && !states.equals(states1)) { |
| | | List<Map> listDevice = JSONObject.parseArray(stateList.toJSONString(), Map.class); |
| | | List<Map> listDevice1 = JSONObject.parseArray(stateList1.toJSONString(), Map.class); |
| | | //将所有设备放到同一个集合下 |
| | | List<Map> deviceList = new ArrayList<Map>(); |
| | | List<Map> deviceList1 = new ArrayList<Map>(); |
| | | //存放所有组织的id |
| | | List orgList = new ArrayList(); |
| | | for (Map devices : listDevice) { |
| | | int monitorId = Integer.parseInt((String) devices.get("id")); |
| | | MonitorPoint monitorPoint = monitorPointService.byIdGetMonitorPoint(monitorId); |
| | | int org_id = monitorPoint.getOrganizationId(); |
| | | orgList.add(org_id); |
| | | List<Map> devicesList = (List<Map>) devices.get("devices"); |
| | | if (!devicesList.isEmpty()) { |
| | | if (devicesList.size() > 1) { |
| | | for (Map map : devicesList) { |
| | | deviceList.add(map); |
| | | } |
| | | } else { |
| | | deviceList.add((Map) ((List) devices.get("devices")).get(0)); |
| | | } |
| | | } |
| | | } |
| | | for (Map devices1 : listDevice1) { |
| | | int monitorId = Integer.parseInt((String) devices1.get("id")); |
| | | MonitorPoint monitorPoint = monitorPointService.byIdGetMonitorPoint(monitorId); |
| | | int org_id = monitorPoint.getOrganizationId(); |
| | | List<Map> devicesList = (List<Map>) devices1.get("devices"); |
| | | if (!devicesList.isEmpty()) { |
| | | if (devicesList.size() > 1) { |
| | | for (Map map : devicesList) { |
| | | deviceList1.add(map); |
| | | } |
| | | } else { |
| | | deviceList1.add((Map) ((List) devices1.get("devices")).get(0)); |
| | | } |
| | | } |
| | | } |
| | | List<String> macList = new ArrayList<String>(); |
| | | //获得两个时间的设备状态改变的mac号 |
| | | for (Map map : deviceList) { |
| | | String state = (String) map.get("state"); |
| | | String mac = (String) map.get("mac"); |
| | | for (Map map1 : deviceList1) { |
| | | String state1 = (String) map1.get("state"); |
| | | String mac1 = (String) map1.get("mac"); |
| | | if (mac.equals(mac1)) { |
| | | if (Integer.parseInt(state) > Integer.parseInt(state1) && Integer.parseInt(state) != 4 /*&& Integer.parseInt(state1) == 0*/) { |
| | | macList.add(mac + "-" + state + "-" + state1); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | //存放不重合的数组 |
| | | LinkedHashSet<Integer> orgS = new LinkedHashSet<Integer>(orgList); |
| | | SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | Date date = new Date(System.currentTimeMillis()); |
| | | Date date1 = new Date(System.currentTimeMillis() - 1000); |
| | | //系统当前时间 |
| | | String time = formatter.format(date); |
| | | //系统当前时间的前一秒 |
| | | String time1 = formatter.format(date1); |
| | | List<Map> alarmList = new ArrayList<Map>(); |
| | | for (Integer org : orgS) { |
| | | int orgNum = alarmConfigService.containOrgId(org); |
| | | Map<String, Object> eMap = new HashMap<String, Object>(); |
| | | if (orgNum == 1) { |
| | | String alarmConfig = alarmConfigService.getValueByOrganizationId(Integer.parseInt(String.valueOf(org))); |
| | | Map hashMap = JSON.parseObject(alarmConfig, HashMap.class); |
| | | Map alarmLevels = (Map) hashMap.get("alarmLevels"); |
| | | //数据库因子表只有106个因子 |
| | | for (int i = 1; i < 106; i++) { |
| | | if (alarmLevels.containsKey("e" + i)) { |
| | | Map map = (Map) alarmLevels.get("e" + i); |
| | | if (!map.isEmpty()) { |
| | | Integer enable = (Integer) map.get("enable"); |
| | | List increment = (List) map.get("increment"); |
| | | if (enable == 1) { |
| | | if (!(increment.get(0).toString().equals("0") && increment.get(1).toString().equals("0"))) { |
| | | eMap.put("e" + i, increment); |
| | | } else { |
| | | continue; |
| | | } |
| | | } else { |
| | | continue; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } else { |
| | | String defultAlarm = dictionaryDataService.getDefultAlarm(); |
| | | Map hashMap = JSON.parseObject(defultAlarm, HashMap.class); |
| | | Map alarmLevels = (Map) hashMap.get("alarmLevels"); |
| | | //数据库因子表只有106个因子 |
| | | for (int i = 1; i < 106; i++) { |
| | | if (alarmLevels.containsKey("e" + i)) { |
| | | Map map = (Map) alarmLevels.get("e" + i); |
| | | if (!map.isEmpty()) { |
| | | Integer enable = (Integer) map.get("enable"); |
| | | List increment = (List) map.get("increment"); |
| | | if (enable == 1) { |
| | | if (!(increment.get(0).toString().equals("0") && increment.get(1).toString().equals("0"))) { |
| | | eMap.put("e" + i, increment); |
| | | } else { |
| | | continue; |
| | | } |
| | | } else { |
| | | continue; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | Map map = new HashMap(); |
| | | map.put("eMap", eMap); |
| | | map.put("org", org); |
| | | alarmList.add(map); |
| | | } |
| | | for (Map aEMap : alarmList) { |
| | | List<Map> values = new ArrayList<Map>(); |
| | | if (macList.size() > 0) { |
| | | for (String sMac : macList) { |
| | | String[] aMac = sMac.split("-"); |
| | | String mac = aMac[0]; |
| | | //因为数据库数据是两秒钟插入一条,所以通过两个时间区间获取一条数据,防止一个时间获取数据为空的情况 |
| | | String value = historyService.getValueByMacAndTime(mac, time, time1); |
| | | Map<String, String> map = new HashMap<String, String>(); |
| | | if (value == null) { |
| | | Date date2 = new Date(System.currentTimeMillis() - 2000); |
| | | //系统当前时间的前两秒 |
| | | String time2 = formatter.format(date1); |
| | | value = historyService.getValueByMacAndTime(mac, time, time2); |
| | | if (value == null) { |
| | | Date date3 = new Date(System.currentTimeMillis() - 3000); |
| | | //系统当前时间的前三秒 |
| | | String time3 = formatter.format(date1); |
| | | value = historyService.getValueByMacAndTime(mac, time, time3); |
| | | } |
| | | } |
| | | if (value != null) { |
| | | map.put("mac", mac); |
| | | map.put("value", value); |
| | | map.put("state", aMac[1]); |
| | | map.put("state1", aMac[2]); |
| | | values.add(map); |
| | | } else { |
| | | continue; |
| | | } |
| | | } |
| | | } |
| | | |
| | | if (values.size() > 0 && values.size() == macList.size()) { |
| | | for (Map dataMap : values) { |
| | | String oId = deviceService.byMacGetOrgId((String) dataMap.get("mac")); |
| | | if (!(aEMap.get("org").toString()).equals(oId)) { |
| | | continue; |
| | | } |
| | | List<String> list = new ArrayList<String>(); |
| | | Map sensorMap = JSONObject.parseObject((String) dataMap.get("value")); |
| | | Iterator<String> iter = sensorMap.keySet().iterator(); |
| | | while (iter.hasNext()) { |
| | | String key = iter.next(); |
| | | list.add(key); |
| | | } |
| | | String state = (String) dataMap.get("state"); |
| | | String state1 = (String) dataMap.get("state1"); |
| | | List<Map> mapList=new ArrayList(); |
| | | for (String key : list) { |
| | | if (((Map) aEMap.get("eMap")).containsKey(key)) { |
| | | Double val = Double.valueOf(sensorMap.get(key).toString()); |
| | | List valueList = (List) ((Map) aEMap.get("eMap")).get(key); |
| | | Device device = deviceService.byMacGetDevice((String) dataMap.get("mac")); |
| | | Map<String, Object> sensors = sensorService.getSensorBySensorKey(key); |
| | | if (key.equals("e1") || key.equals("e2") || key.equals("e10") || key.equals("e11") || key.equals("e15") || key.equals("e16")) { |
| | | //判断六参因子超标 |
| | | if ((state1.equals("0") || state1.equals("1")) && Integer.parseInt(state) > 1) { |
| | | if (val > Double.valueOf(String.valueOf(valueList.get(1)))) { |
| | | Map lookMap = new HashMap(); |
| | | lookMap.put("time",time); |
| | | lookMap.put("name",device.getName()); |
| | | lookMap.put("sensor",sensors.get("description")); |
| | | lookMap.put("value",val + ""+sensors.get("unit")); |
| | | mapList.add(lookMap); |
| | | //lookString = time+" "+device.getName()+sensors.get("description")+"="+val + sensors.get("unit")+"超标"; |
| | | //System.out.println(time + "====" + device.getName() + "=====" + sensors.get("description") + "======" + val + sensors.get("unit")); |
| | | } |
| | | } |
| | | }else {//判断非六参因子超标 |
| | | if (state1.equals("0")) { |
| | | if (val > Double.valueOf(String.valueOf(valueList.get(0)))) { |
| | | Map lookMap = new HashMap(); |
| | | lookMap.put("time",time); |
| | | lookMap.put("name",device.getName()); |
| | | lookMap.put("sensor",sensors.get("description")); |
| | | lookMap.put("value",val + ""+sensors.get("unit")); |
| | | mapList.add(lookMap); |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |
| | | } |
| | | if (mapList.size()>0){ |
| | | lookList.add(mapList); |
| | | }else { |
| | | continue; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | return lookList; |
| | | } |
| | | |
| | | /* @GetMapping("/lianxian") |
| | | @ApiOperation(value = "连线", notes = "连线" ) |
| | | @GetMapping("multiDeviceContrast") |
| | | @ApiOperation(value = "多设备因子对比", notes = "多设备因子对比") |
| | | @ApiImplicitParams(value = { |
| | |
| | | List<Map<String, Object>> list = historyMinutelyService.getDevicesSensorsToExcel(parameters); |
| | | return new ResultBean<List<Map<String, Object>>>(list); |
| | | } |
| | | } |
| | | } |