From 6d2c778ff0c2be03fb64ecaeae45c09c92771637 Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期三, 23 七月 2025 15:34:59 +0800 Subject: [PATCH] 代码初始化 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java | 35 ++++++++++++++++++++++++++++++----- 1 files changed, 30 insertions(+), 5 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java index 5bbc2d2..485dd99 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java @@ -490,6 +490,7 @@ }*/ return list; } + @Override public WaningEventDataVO warningEventData(Integer type){ WaningEventDataVO lastResult = new WaningEventDataVO(); @@ -499,16 +500,36 @@ 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"); @@ -524,6 +545,9 @@ 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){ } @@ -1552,12 +1576,13 @@ 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; } -- Gitblit v1.9.3