From ee8f62695b005cfc965ec174a915e9b3e775d252 Mon Sep 17 00:00:00 2001
From: doum <doum>
Date: 星期三, 23 七月 2025 15:41:07 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 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