From 5df732ffe16b3f162422c2db61a78458e28c7f8d Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期五, 10 十月 2025 14:45:29 +0800
Subject: [PATCH] 钥匙柜开发 天气预警通知

---
 server/system_service/src/main/java/com/doumee/core/utils/Constants.java |   73 +++++++++++++-----------------------
 1 files changed, 26 insertions(+), 47 deletions(-)

diff --git a/server/system_service/src/main/java/com/doumee/core/utils/Constants.java b/server/system_service/src/main/java/com/doumee/core/utils/Constants.java
index b538ada..6635af7 100644
--- a/server/system_service/src/main/java/com/doumee/core/utils/Constants.java
+++ b/server/system_service/src/main/java/com/doumee/core/utils/Constants.java
@@ -26,7 +26,10 @@
     public static final int ZERO = 0 ;
     public static final int ONE = 1 ;
     public static final int TWO = 2 ;
+    public static final Integer DD_STATUS_SUCCESS_CODE = 200 ;
+    public static final Long DD_ERR_CODE = 0L ;
     public static final String HK_PARAM ="HK_PARAM" ;
+    public static final String HK_WEBSITE_DOMAIN_URL ="HK_WEBSITE_DOMAIN_URL" ;
     public static final String LED_CONTENT_SPEED ="LED_CONTENT_SPEED" ;
     public static final String HK_HOST ="HK_HOST" ;
     public static final String HK_APPKEY ="HK_APPKEY" ;
@@ -52,6 +55,10 @@
     public static final String SIGN_IN_QRCODE_PREFIX ="SIGN_IN_QRCODE_PREFIX" ;
 
 
+    public static final String WEATHER_CONFIG ="WEATHER_CONFIG" ;
+    public static final String REQUEST_URL ="REQUEST_URL" ;
+    public static final String LOCATION ="LOCATION" ;
+    public static final String API_KEY ="API_KEY" ;
     //琚嫓璁夸汉淇℃伅鏍¢獙鏂瑰紡锛�0鎵嬫満鍙峰崟鐙牎楠� 1鎵嬫満鍙峰拰濮撳悕缁勫悎鏍¢獙锛�
     public static final String BEVISITED_USER_VALID = "BEVISITED_USER_VALID";
     public static final String LW_BEVISITED_USER_VALID = "LW_BEVISITED_USER_VALID";
@@ -104,12 +111,16 @@
     public static final String FTP_PORT ="FTP_PORT" ;
     public static final String FTP_USERNAME ="FTP_USERNAME" ;
     public static final String FTP_PWD ="FTP_PWD" ;
+    public static final String COMPANY_DOCUMENTS ="COMPANY_DOCUMENTS" ;
+    public static final String APP_FILE ="APP_FILE" ;
+
     public static final String FTP_RESOURCE_PATH ="FTP_RESOURCE_PATH" ;
     public static final String FTP_LOCAL_RESOURCE_PATH ="FTP_LOCAL_RESOURCE_PATH" ;
     public static final String ERP_ORGLIST_URL ="ERP_ORGLIST_URL" ;
     public static final String ERP_USERLIST_URL ="ERP_USERLIST_URL" ;
     public static final String ERP_APPROVE_URL ="ERP_APPROVE_URL" ;
     public static final String ERP_USERSTATUS_RL ="ERP_USERSTATUS_RL" ;
+
     public static final String ERP ="ERP" ;
     public static final Integer THREE =3 ;
     public static final Integer FOUR =4 ;
@@ -153,6 +164,9 @@
     public static final String OVER_NOTICE_WX = "OVER_NOTICE_WX";
     public static final String PRESSURE_LEVEL_UNIT = "PRESSURE_LEVEL_UNIT";
     public static final String LIQUID_LEVEL_UNIT ="LIQUID_LEVEL_UNIT" ;
+    public static final String OUT_HY_LOT_TOTAL ="OUT_HY_LOT_TOTAL" ;
+    public static final String BANNER_IMG ="BANNER_IMG" ;
+    public static final String GAODE_LOCATION_GEOAPI_URL = "GAODE_LOCATION_GEOAPI_URL";
 
     public static  boolean DEALING_HK_SYNCPRIVILEGE= false;
     public static  boolean DEALING_HK_SYNCDEVICE = false;
@@ -487,6 +501,11 @@
 
 
     public static final String HOME_IMAGE ="HOME_IMAGE";
+    public static final String DD_TALK ="DD_TALK";
+    public static final String APP_KEY ="APP_KEY";
+    public static final String APP_SECRET ="APP_SECRET";
+    public static final String ACCESS_TOKEN ="ACCESS_TOKEN";
+    public static final String AGENT_ID ="AGENT_ID";
 
 
 
@@ -505,6 +524,10 @@
 
     public interface RedisKeys {
         public static final String IMPORTING_CARS ="IMPORTING_CARS";
+        public static final String CHECKING_JKCUSTOMER_LOCATION ="CHECKING_JKCUSTOMER_LOCATION";
+        public static final String IMPORTING_JKCUSTOMER ="IMPORTING_JKCUSTOMER";
+        public static final String IMPORTING_JKORDERS ="IMPORTING_JKORDERS";
+        public static final String IMPORTING_JKLINE ="IMPORTING_JKLINE";
         public static final String IMPORTING_MEMBER ="IMPORTING_MEMBER";
         public static final String BIGSCREEN_UUID ="BIGSCREEN_UUID";
         public static final String IMPORTING_GAS ="IMPORTING_GAS";
@@ -718,53 +741,8 @@
 //        System.out.println(Constants.getVehiclePlateNo("婀楤140D17").getDescription());
 //        System.out.println(Constants.getVehiclePlateNo("瀹緼P0637").getDescription());
 
-        System.out.println("<script> SELECT \n" +
-                "t1.REALNAME `REALNAME`,\n" +
-                "MAX(t1.`01`) `januaryCount`,\n" +
-                "MAX(t1.`02`) `februaryCount`,\n" +
-                "MAX(t1.`03`) `marchCount`,\n" +
-                "MAX(t1.`04`) `aprilCount`,\n" +
-                "MAX(t1.`05`) `mayCount`,\n" +
-                "MAX(t1.`06`) `juneCount`,\n" +
-                "MAX(t1.`07`) `julyCount`,\n" +
-                "MAX(t1.`08`) `augustCount`,\n" +
-                "MAX(t1.`09`) `septemberCount`,\n" +
-                "MAX(t1.`10`) `octoberCount`,\n" +
-                "MAX(t1.`11`) `novemberCount`,\n" +
-                "MAX(t1.`12`) `decemberCount`\n" +
-                "FROM(\n" +
-                "SELECT \n" +
-                "t.id,\n" +
-                "t.REALNAME,\n" +
-                "CASE  WHEN t.yue='01' THEN t.c ELSE 0 END AS `01`,\n" +
-                "CASE  WHEN t.yue='02' THEN t.c ELSE 0 END AS `02`,\n" +
-                "CASE  WHEN t.yue='03' THEN t.c ELSE 0 END AS `03`,\n" +
-                "CASE  WHEN t.yue='04' THEN t.c ELSE 0 END AS `04`,\n" +
-                "CASE  WHEN t.yue='05' THEN t.c ELSE 0 END AS `05`,\n" +
-                "CASE  WHEN t.yue='06' THEN t.c ELSE 0 END AS `06`,\n" +
-                "CASE  WHEN t.yue='07' THEN t.c ELSE 0 END AS `07`,\n" +
-                "CASE  WHEN t.yue='08' THEN t.c ELSE 0 END AS `08`,\n" +
-                "CASE  WHEN t.yue='09' THEN t.c ELSE 0 END AS `09`,\n" +
-                "CASE  WHEN t.yue='10' THEN t.c ELSE 0 END AS `10`,\n" +
-                "CASE  WHEN t.yue='11' THEN t.c ELSE 0 END AS `11`,\n" +
-                "CASE  WHEN t.yue='12' THEN t.c ELSE 0 END AS `12`  \n" +
-                "FROM   \n" +
-                "(SELECT \n" +
-                "su.id,\n" +
-                "su.REALNAME,\n" +
-                "DATE_FORMAT(b.START_TIME,'%m') yue,\n" +
-                "SUM(" +
-                "CONVERT( (UNIX_TIMESTAMP(b.END_TIME) - UNIX_TIMESTAMP(b.START_TIME))/(60*60), DECIMAL(5,1))) c\n" +
-                "FROM \n" +
-                "meeting_user_rel ur\n" +
-                "LEFT JOIN `SYSTEM_USER` su ON ur.USER_ID = su.id \n" +
-                "LEFT JOIN meeting_book b ON ur.OBJ_ID = b.id \n" +
-                "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) and b.isdeleted=0" +
-                "<if test='userId != null'>"+
-                "and ur.USER_ID = #{userId}\n" +
-                "</if>"+
-                "GROUP BY su.id, DATE_FORMAT(b.START_TIME,'%m')) t) t1 GROUP BY t1.id" +
-                "</script>");
+        System.out.println( "{\"data\":{\"paramValues\":{\"accessType\":\"2\",\"certTypes\":\"111\",\"certificateNos\":\"340122199904297373\",\"defineEventType\":\"771760131\",\"eventId\":\"6eb4a18bf3744c4385adb37eecdc9d37_634acece3fcf0_3d87\",\"eventType\":\"541200060\",\"eventTypeName\":\"\",\"extEventCardNo\":\"\",\"extEventPictureURL\":\"/pic?9d9c568c1a2do-4el*71-871o9=1524*7l9=0507*3607416=7147*=t212**ps5=2*8b9=559838d9837371-b162of-5pi2dc3=88=20c\",\"extEventReaderID\":\"\",\"extEventReaderKind\":\"\",\"gateIndex\":\"fc92c663ffb9420994f2574469f35e2d\",\"gateName\":\"瀹夋嘲瑗块棬\",\"happenTime\":\"2025-05-09T13:06:13.000+08:00\",\"inOrOut\":\"0\",\"invoicesIds\":\"9857A54DAD5947EDB032575ECDD9EA4Bf4ebb8b61e344cd09118bfbdb5ff285c\",\"parkIndex\":\"1c4cdb8b66ed4c23bacb385c3fb6c46b\",\"parkName\":\"鍋滆溅鍦篭",\"phones\":\"19956520776\",\"plateNos\":\"鐨朅AA1652\",\"srcIndex\":\"6eb4a18bf3744c4385adb37eecdc9d37\",\"srcName\":\"\",\"srcParentIndex\":\"\",\"srcType\":\"roadway\",\"svrIndexCode\":\"eae18a71-1ffd-4e72-bcf6-998c5977630d\",\"userType\":\"\",\"visitorNames\":\"淇炴壃\"},\"targetPerson\":{\"certType\":\"111\",\"createTime\":\"2024-08-19T17:43:09.966+08:00\",\"jobNo\":\"18055162696\",\"mobile\":\"18055162696\",\"name\":\"鏈变箣钀孿",\"orgId\":\"d815b989-877a-40e7-8f34-a5388295a3d2\",\"orgPathName\":\"瀹夋嘲鐗╂祦鍥尯/瀹夋嘲鐗╂祦/缁煎悎绠$悊绉慭",\"personId\":\"1d8d42233bce4722a741917de4195084\",\"personNumber\":\"18055162696\",\"pinyin\":\"zhuzhimeng\",\"sex\":\"1\",\"updateTime\":\"2025-05-09T11:20:42.000+08:00\",\"userName\":\"18055162696\"},\"visitorInformationList\":[{\"appointmentCode\":\"947384\",\"cardNo\":\"6206767065588\",\"certNo\":\"340122199904297373\",\"certType\":111,\"companionPerson\":\"0\",\"createTime\":\"2025-05-09T13:04:26.740+08:00\",\"faceUrl\":\"2ffa5b542ec2448f9033e6901b326f44\",\"phone\":\"19956520776\",\"plateNo\":\"鐨朅AA1652\",\"sex\":1,\"unit\":\"瀹夊窘涓滅櫨淇濆畨鏈嶅姟鏈夐檺鍏徃\",\"updateTime\":\"2025-05-09T13:05:36.472+08:00\",\"visitNum\":\"0\",\"visitorId\":\"6424f11498de48228fb2a418d3fc3bb1\",\"visitorName\":\"淇炴壃\"}],\"visitorInvoices\":{\"appointmentType\":\"3\",\"authIssueStatus\":\"1\",\"beginTime\":\"2025-05-09T13:01:00.000+08:00\",\"campusId\":\"root000000\",\"campusName\":\"榛樿鍥尯\",\"createTime\":\"2025-05-09T13:04:26.693+08:00\",\"extendJson\":\"\",\"finishTime\":\"2025-05-09T14:01:00.000+08:00\",\"ifInfoAbnormal\":\"0\",\"invoicesId\":\"9857A54DAD5947EDB032575ECDD9EA4Bf4ebb8b61e344cd09118bfbdb5ff285c\",\"invoicesNo\":\"FK20250509130002\",\"invoicesStatus\":\"1\",\"isRepast\":\"0\",\"type\":\"0\",\"updateTime\":\"2025-05-09T13:05:30.372+08:00\",\"visitReason\":\"-1\",\"visitReasonName\":\"鍏朵粬\",\"visitTargetId\":\"1d8d42233bce4722a741917de4195084\",\"workflowInitiatorId\":\"6424f11498de48228fb2a418d3fc3bb1\",\"workflowInitiatorType\":\"0\",\"workflowInstanceId\":\"7010a8521de54f088331e7176b82fd10\"}},\"eventId\":\"b5024c7b6c8b4b5587baf42dc5bce025\",\"eventType\":541200060,\"happenTime\":\"2025-05-09T13:06:14+08:00\",\"srcIndex\":\"9857A54DAD5947EDB032575ECDD9EA4Bf4ebb8b61e344cd09118bfbdb5ff285c\",\"srcType\":\"9857A54DAD5947EDB032575ECDD9EA4Bf4ebb8b61e344cd09118bfbdb5ff285c\",\"status\":0,\"timeout\":0}");
+        System.out.println("{\"data\":{\"paramValues\":{\"accessType\":\"2\",\"certTypes\":\"111\",\"certificateNos\":\"340122199904297373\",\"defineEventType\":\"771760134\",\"eventId\":\"6cf8a9b5cb614bddb74f338701975ade_634ad693b6b33_3db4\",\"eventType\":\"541200060\",\"eventTypeName\":\"\",\"extEventCardNo\":\"\",\"extEventPictureURL\":\"/pic?9d9c568c1a2do-4el*81-891*9o3=5563*4l0=0206706794t6=318**ps==515b*=5698*8d9835393-b9667f-1pi1dco=852c2=083\",\"extEventReaderID\":\"\",\"extEventReaderKind\":\"\",\"gateIndex\":\"fc92c663ffb9420994f2574469f35e2d\",\"gateName\":\"瀹夋嘲瑗块棬\",\"happenTime\":\"2025-05-09T13:40:59.000+08:00\",\"inOrOut\":\"1\",\"invoicesIds\":\"9857A54DAD5947EDB032575ECDD9EA4Bf4ebb8b61e344cd09118bfbdb5ff285c\",\"parkIndex\":\"1c4cdb8b66ed4c23bacb385c3fb6c46b\",\"parkName\":\"鍋滆溅鍦篭",\"phones\":\"19956520776\",\"plateNos\":\"鐨朅AA1652\",\"srcIndex\":\"6cf8a9b5cb614bddb74f338701975ade\",\"srcName\":\"\",\"srcParentIndex\":\"\",\"srcType\":\"roadway\",\"svrIndexCode\":\"eae18a71-1ffd-4e72-bcf6-998c5977630d\",\"userType\":\"\",\"visitorNames\":\"淇炴壃\"},\"targetPerson\":{\"certType\":\"111\",\"createTime\":\"2024-08-19T17:43:09.966+08:00\",\"jobNo\":\"18055162696\",\"mobile\":\"18055162696\",\"name\":\"鏈变箣钀孿",\"orgId\":\"d815b989-877a-40e7-8f34-a5388295a3d2\",\"orgPathName\":\"瀹夋嘲鐗╂祦鍥尯/瀹夋嘲鐗╂祦/缁煎悎绠$悊绉慭",\"personId\":\"1d8d42233bce4722a741917de4195084\",\"personNumber\":\"18055162696\",\"pinyin\":\"zhuzhimeng\",\"sex\":\"1\",\"updateTime\":\"2025-05-09T11:20:42.000+08:00\",\"userName\":\"18055162696\"},\"visitorInformationList\":[{\"appointmentCode\":\"947384\",\"cardNo\":\"6206767065588\",\"certNo\":\"340122199904297373\",\"certType\":111,\"companionPerson\":\"0\",\"createTime\":\"2025-05-09T13:04:26.740+08:00\",\"faceUrl\":\"2ffa5b542ec2448f9033e6901b326f44\",\"phone\":\"19956520776\",\"plateNo\":\"鐨朅AA1652\",\"sex\":1,\"unit\":\"瀹夊窘涓滅櫨淇濆畨鏈嶅姟鏈夐檺鍏徃\",\"updateTime\":\"2025-05-09T13:05:36.472+08:00\",\"visitNum\":\"0\",\"visitorId\":\"6424f11498de48228fb2a418d3fc3bb1\",\"visitorName\":\"淇炴壃\"}],\"visitorInvoices\":{\"appointmentType\":\"3\",\"authIssueStatus\":\"1\",\"beginTime\":\"2025-05-09T13:01:00.000+08:00\",\"campusId\":\"root000000\",\"campusName\":\"榛樿鍥尯\",\"createTime\":\"2025-05-09T13:04:26.693+08:00\",\"extendJson\":\"\",\"finishTime\":\"2025-05-09T14:01:00.000+08:00\",\"ifInfoAbnormal\":\"0\",\"invoicesId\":\"9857A54DAD5947EDB032575ECDD9EA4Bf4ebb8b61e344cd09118bfbdb5ff285c\",\"invoicesNo\":\"FK20250509130002\",\"invoicesStatus\":\"5\",\"isRepast\":\"0\",\"type\":\"0\",\"updateTime\":\"2025-05-09T13:41:00.369+08:00\",\"visitReason\":\"-1\",\"visitReasonName\":\"鍏朵粬\",\"visitTargetId\":\"1d8d42233bce4722a741917de4195084\",\"workflowInitiatorId\":\"6424f11498de48228fb2a418d3fc3bb1\",\"workflowInitiatorType\":\"0\",\"workflowInstanceId\":\"7010a8521de54f088331e7176b82fd10\"}},\"eventId\":\"2bb6700a9e4f48849227100243f470b2\",\"eventType\":541200060,\"happenTime\":\"2025-05-09T13:41:00+08:00\",\"srcIndex\":\"9857A54DAD5947EDB032575ECDD9EA4Bf4ebb8b61e344cd09118bfbdb5ff285c\",\"srcType\":\"9857A54DAD5947EDB032575ECDD9EA4Bf4ebb8b61e344cd09118bfbdb5ff285c\",\"status\":0,\"timeout\":0}");
     }
 
 
@@ -902,6 +880,7 @@
         AUTHED_LEAVE(9, "涓嬪彂鎺堟潈绂诲洯","涓嬪彂鎺堟潈绂诲洯" ),
         LEAVED(10, "宸茬鍥� ","杞﹁締浠巤data}绂诲満 " ),
         OVER_NUMBER(11, "宸茶繃鍙�","瓒呮椂鏈埌鎸囧畾鏈堝彴鑷姩杩囧彿" ),
+        CHANGE_GROUP(12, "鏇存崲鏈堝彴缁�","浠庛�恵data}銆戞洿鎹㈠埌銆恵data1}銆�" ),
         ;
 
         // 鎴愬憳鍙橀噺

--
Gitblit v1.9.3