| | |
| | | }*/ |
| | | return list; |
| | | } |
| | | |
| | | @Override |
| | | public WaningEventDataVO warningEventData(Integer type){ |
| | | WaningEventDataVO lastResult = new WaningEventDataVO(); |
| | |
| | | request.setPageSize(1000); |
| | | request.setFiledOptions(new ArrayList<>()); |
| | | request.setSorts(new ArrayList<>()); |
| | | request.setFetchImg(true); |
| | | RuleEventFiledOptionsRequest file = new RuleEventFiledOptionsRequest(); |
| | | file.setFieldName("event_type"); |
| | | file.setFieldValue("131588,131593");//安防告警和人员告警 |
| | | file.setType("in"); |
| | | if(type == 1){ |
| | | file.setFieldValue("131588");//安防告警 |
| | | file.setFieldValue("131588");//安防告警 区域入侵 |
| | | }else if(type == 2){ |
| | | file.setFieldValue("131593");//人员告警 |
| | | file.setFieldValue("131593");//人员告警 危险行为 |
| | | } |
| | | request.getFiledOptions().add(file); |
| | | |
| | | RuleEventFiledOptionsRequest fileLte = new RuleEventFiledOptionsRequest(); |
| | | fileLte.setFieldName("happen_time"); |
| | | fileLte.setFieldValue(DateUtil.formatDate(Utils.Date.getEnd(new Date()),"yyyy-MM-dd HH:mm:ss")); |
| | | fileLte.setType("lte"); |
| | | request.getFiledOptions().add(fileLte); |
| | | |
| | | RuleEventFiledOptionsRequest fileGte = new RuleEventFiledOptionsRequest(); |
| | | fileGte.setFieldName("happen_time"); |
| | | fileGte.setFieldValue(DateUtil.formatDate(Utils.Date.getStart(new Date()),"yyyy-MM-dd HH:mm:ss")); |
| | | fileGte.setType("gte"); |
| | | request.getFiledOptions().add(fileGte); |
| | | |
| | | RuleEventFiledOptionsRequest fileStatus = new RuleEventFiledOptionsRequest(); |
| | | fileStatus.setFieldName("happen_time"); |
| | | fileStatus.setFieldValue("99"); |
| | | fileStatus.setType("neq"); |
| | | request.getFiledOptions().add(fileStatus); |
| | | |
| | | SortRequest sort = new SortRequest(); |
| | | sort.setSortField("happen_time"); |
| | | sort.setSortType("desc"); |
| | |
| | | try { |
| | | if(DateUtil.getISO8601DateByStr(r.getHappen_time()).getTime() < Utils.Date.getStart(new Date()).getTime()){ |
| | | continue; |
| | | } |
| | | if(StringUtils.equals(r.getStatus(),"99")){ |
| | | continue; |
| | | } |
| | | }catch (Exception e){ |
| | | } |
| | |
| | | data.setDeviceTypeList(list); |
| | | Long totalNum =hiddenDangerMapper.selectCount(new QueryWrapper<HiddenDanger>().lambda() |
| | | .eq(HiddenDanger::getIsdeleted,Constants.ZERO ) |
| | | .apply("to_days(create_date) = to_days(now())" ) ); |
| | | .apply(" DATE_FORMAT(create_date, '%Y-%m') = DATE_FORMAT(now(), '%Y-%m') " ) ); |
| | | data.setDangerTotalNum(totalNum !=null?totalNum.intValue():0);//今日隐患数量 |
| | | totalNum =hiddenDangerMapper.selectCount(new QueryWrapper<HiddenDanger>().lambda() |
| | | .eq(HiddenDanger::getIsdeleted,Constants.ZERO ) |
| | | .in(HiddenDanger::getStatus,Constants.ONE,Constants.TWO ) |
| | | .apply("to_days(check_date) = to_days(now())" ) ); |
| | | // .in(HiddenDanger::getStatus,Constants.ONE,Constants.TWO ) |
| | | .eq(HiddenDanger::getStatus,Constants.ZERO ) |
| | | .apply(" DATE_FORMAT(check_date, '%Y-%m') = DATE_FORMAT(now(), '%Y-%m') " ) ); |
| | | data.setDangerDealedNum(totalNum !=null?totalNum.intValue():0);//今日处理隐患数量 |
| | | return data; |
| | | } |