From 10c28ce3d0b384584c77ce9111a66a0641250752 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期四, 27 二月 2025 18:30:32 +0800
Subject: [PATCH] 最新版本541200007

---
 server/system_service/src/main/java/com/doumee/core/utils/Constants.java |  209 ++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 186 insertions(+), 23 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 371bfbd..b66f5bf 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
@@ -1,26 +1,17 @@
 package com.doumee.core.utils;
 
 
-import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.doumee.core.model.LoginUserInfo;
 import com.fasterxml.jackson.annotation.JsonInclude;
 import com.fasterxml.jackson.core.JsonProcessingException;
 import com.fasterxml.jackson.databind.ObjectMapper;
 import com.fasterxml.jackson.databind.PropertyNamingStrategy;
-import io.swagger.models.auth.In;
-import org.apache.batik.util.Platform;
+import net.sourceforge.pinyin4j.PinyinHelper;
 import org.apache.commons.lang3.StringUtils;
-import org.springframework.util.CollectionUtils;
 
 import java.io.IOException;
 import java.math.BigDecimal;
-import java.net.URLDecoder;
+import java.text.Collator;
 import java.text.SimpleDateFormat;
-import java.util.ArrayList;
-import java.util.Arrays;
-import  java.util.Date;
-import java.util.List;
-import java.util.Random;
 import java.util.*;
 import java.util.Date;
 import java.util.regex.Matcher;
@@ -140,17 +131,26 @@
     public static final String WMS_GET_INVENTORYLIST_URL ="WMS_GET_INVENTORYLIST_URL" ;
     public static final String WMS_OUTBOUND_PLATFROM_URL ="WMS_OUTBOUND_PLATFROM_URL" ;
     public static final String TSM_PARAM ="TSM_PARAM" ;
-    public static final String TMS_ORDER_LIST_URL ="TMS_ORDER_LIST_URL" ;
-    public static final String TMS_ORDER_DETAIL_URL ="TMS_ORDER_DETAIL_URL" ;
-    public static final String TMS_LOCK_STATUS_URL ="TMS_LOCK_STATUS_URL" ;
     public static final String TMS_INTERFACE_URL_PREFIX ="TMS_INTERFACE_URL_PREFIX" ;
     public static final String MYSQL_BACKUP_CDOE ="MYSQL_BACKUP_CDOE" ;
     public static final String MYSQL_BACKUP_DIR ="MYSQL_BACKUP_DIR" ;
     public static final String EVENT_FILES_PRIVATE_DOMAIN ="EVENT_FILES_PRIVATE_DOMAIN" ;
     public static final String EVENT_FILES_PUBLIC_DOMAIN ="EVENT_FILES_PUBLIC_DOMAIN" ;
+    public static final String TEMPERATURE_HUMIDITY ="TEMPERATURE_HUMIDITY" ;
+
     public static final String HK_WXTOKEN_CONFIGID ="HK_WXTOKEN_CONFIGID" ;
     public static final String HK_WXTOKEN_TAGID ="HK_WXTOKEN_TAGID" ;
     public static final String WMS_TOTAL_STOCK_NUM ="WMS_TOTAL_STOCK_NUM" ;
+    public static final String WMS_LIQUID_LEVEL ="WMS_LIQUID_LEVEL" ;
+    public static final String WMS_PRESSURE_LEVEL ="WMS_PRESSURE_LEVEL" ;
+    public static final String WX_REDIRECT_URL = "WX_REDIRECT_URL";
+    public static final String HK_CHANGNEI_SCREEN_INDEXCODES = "HK_CHANGNEI_SCREEN_INDEXCODES";
+    public static final String CITY_XH_REASON_ID ="CITY_XH_REASON_ID" ;
+    public static final String ATWL_XH_PLATFORM_ID ="ATWL_XH_PLATFORM_ID" ;
+    public static final String SCREEN_SEVENT_ARRIVAL_STARTDATE = "SCREEN_SEVENT_ARRIVAL_STARTDATE";
+    public static final String EARLY_START_WX_NOTICE = "EARLY_START_WX_NOTICE";
+    public static final String OVER_NOTICE_WX = "OVER_NOTICE_WX";
+
     public static  boolean DEALING_HK_SYNCPRIVILEGE= false;
     public static  boolean DEALING_HK_SYNCDEVICE = false;
     public static  boolean DEALING_HK_SYNCPLATFORM = false;
@@ -201,6 +201,24 @@
 
         return sb.toString();
     }
+
+    /**
+     * 鑾峰彇鍏紬鍙疯烦杞噸瀹氬悜涓氬姟鍦板潃
+     * @param code
+     * @param paramCode
+     * @param ywid
+     * @return
+     */
+    public static String getWxUrl(String code, WxUrlParams paramCode, String ywid) {
+        String url = code.replace("${type}",paramCode.type+"").replace("${yw}",paramCode.yw).replace("${ywid}",ywid);
+//        try {
+//            url = URLEncoder.encode(code,"UTF-8");
+//        }catch (Exception e){
+//
+//        }
+        return url;
+    }
+
     public interface VisitIccmStatus{
         //璁垮鐘舵��(0:鏈鍒�,1:宸茬鍒�,2:宸茬閫�,3:婊炵暀,4:鏈闂�,5:鑷姩绛剧,6:鏈閫�)
         int waitSign = 0;
@@ -316,11 +334,12 @@
             return "";
         }
         int l = s.length();
-        if(Constants.equalsInteger(l,7)){
-            return s.substring(0,3)+"**"+s.substring(l-2,l);
-        }
-        if(l <= 8){
-            return s.substring(0,3)+"***"+s.substring(l-2,l);
+        if(l >= 7){
+            String tt = "";
+            for (int i = 0; i < l-6; i++) {
+                tt = tt+"*";
+            }
+            return s.substring(0,2)+tt+s.substring(l-4,l);
         }
         return s;
     }
@@ -399,6 +418,7 @@
          int selfTruck = 3;
          int outTruck = 4;
          int cityComTruck = 5;
+         int unknown = 6;
     }
 
 
@@ -523,10 +543,15 @@
     }
 
 
+    /**
+     * 杩愬崟浜嗗崟浣嶇被鍨� 0涓囨敮 1绠�
+     */
+    public static final  int UNIT_TYPE =1;
 public interface  memberType{
     int driver = 0;//鍙告満浜哄憳
     int visitor = 1;//鏅�氳瀹�
     int internal = 2;//鍐呴儴浜哄憳
+    int gkuser = 3;//绠℃帶浜哄憳锛堣繍鍗曟煡璇級
 }
 
 
@@ -653,12 +678,60 @@
     }
 
     public static void main(String[] args) {
-        System.out.println(Constants.checkCarNo("鐨朅10991"));
-        System.out.println(Constants.checkCarNo("鐨朅A10991"));
+//        getChinesePingyin("DDaa姹熻悕鐨勫瀵瑰");
+//        System.out.println(DateUtil.getShortTime(new Date()));
+//        System.out.println( "2025-01-14 10:50:56".substring(0,10));
+//        System.out.println(Constants.checkCarNo("鐨朅A10991"));
 //        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 = 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>");
     }
 
 
@@ -678,6 +751,10 @@
         LW_FK(0,"鍔冲姟璁垮"),
         PT_FK(1,"鏅�氳瀹�"),
         NB_FK(2,"鍐呴儴浜哄憳"),
+
+        COMPANY_TYPE_REL(0,"鐩稿叧鏂圭粍缁�"),
+        COMPANY_TYPE_INTERNAL(1,"鍐呴儴浜哄憳"),
+        COMPANY_TYPE_FK(3,"璁垮"),
 
         /** 杩涘満绫诲瀷 **/
         OUT(0,"鍑�"),
@@ -961,6 +1038,25 @@
             this.info = info;
         }
     }
+    public static String getChinesePingyin(String chinese) {
+        if(StringUtils.isBlank(chinese)){
+            return null;
+        }
+        StringBuilder result = new StringBuilder();
+        for (char ch : chinese.toCharArray()) {
+            String[] pinyinArray = PinyinHelper.toHanyuPinyinStringArray(ch);
+
+            // 濡傛灉瀛楃鏄腑鏂囷紝鍒欒幏鍙栧叾鎷奸煶鐨勯瀛楁瘝
+            if (pinyinArray != null && pinyinArray.length > 0) {
+                result.append(pinyinArray[0].charAt(0));
+            } else {
+                // 闈炰腑鏂囧瓧绗︾洿鎺ユ嫾鎺�
+                result.append(ch);
+            }
+        }
+        System.out.println(result.toString());
+        return result.toString().toUpperCase();
+    }
 
     /**
      * 鏈堝彴浣滀笟 鐘舵��
@@ -972,7 +1068,7 @@
         WAIT_CALL(2, "宸茬鍒�","宸茬鍒�"),
         IN_WAIT(3, "鍏ュ洯绛夊緟","鍏ュ洯绛夊緟" ),
         CALLED(4, "宸插彨鍙�","宸插彨鍙�" ),
-        WORKING(5, "浣滀笟涓�","浣滀笟涓�" ),
+         WORKING(5, "浣滀笟涓�","浣滀笟涓�" ),
         DONE(6, "浣滀笟瀹屾垚 ","浣滀笟瀹屾垚" ),
         TRANSFERING(7, "杞Щ涓�","杞Щ涓�" ),
         EXCEPTION(8, "寮傚父鎸傝捣","寮傚父鎸傝捣" ),
@@ -1148,6 +1244,66 @@
         }
 
     }
+    public  enum WxUrlParams {
+        BISCREEN_CODE(0,0, "0", "闂ㄥ彛澶у睆浜岀淮鐮�"),
+        MEETING_CODE(1,2, "1","浼氳瀹ゅぇ灞�"),
+        VISIT_RECORD_VISIT(2,1, "2","璁垮璁板綍-璁垮"),
+        VISIT_RECORD_USER(3,2, "2","璁垮璁板綍-鍛樺伐"),
+        VISIT_REPORT_RECORD_USER(5,2, "3","璁垮鎶ュ璁板綍-鍛樺伐"),
+        HIDDEN_DANGER(6,2, "4","闅愭偅闅忔墜鎷�"),
+        CAR_USE(7,2, "5","鐢ㄨ溅鐢宠"),
+        MEETING(8,2, "6","浼氳璇︽儏"),
+        PLATFORM_BOOK_DRIVER(9,0, "7","鐗╂祦杞﹂绾�-鍙告満"),
+        PLATFORM_BOOK(10,2, "7","鐗╂祦杞﹂绾�-鍛樺伐"),
+        PLATFORM_JOB_DRIVER(11,0, "8","鏈堝彴浣滀笟-鍙告満"),
+        ;
+        // 鎴愬憳鍙橀噺
+        private int key;
+        private int type;//鐢ㄦ埛绫诲瀷 0鍙告満 1璁垮 2鍛樺伐
+        private String yw;//涓氬姟绫诲瀷
+        private String info;//璇存槑
+
+        // 鏋勯�犳柟娉�
+        WxUrlParams(int key,int type, String yw,String  info) {
+            this.yw = yw;
+            this.key = key;
+            this.type = type;
+            this.info= info;
+        }
+
+
+        public int getKey() {
+            return key;
+        }
+
+        public void setKey(int key) {
+            this.key = key;
+        }
+
+        public int getType() {
+            return type;
+        }
+
+        public void setType(int type) {
+            this.type = type;
+        }
+
+        public String getYw() {
+            return yw;
+        }
+
+        public void setYw(String yw) {
+            this.yw = yw;
+        }
+
+        public String getInfo() {
+            return info;
+        }
+
+        public void setInfo(String info) {
+            this.info = info;
+        }
+    }
     public static <T> T toSnakeObject(String json, Class<T> clazz) throws IOException {
         ObjectMapper mapper = new ObjectMapper();
         mapper.setPropertyNamingStrategy(PropertyNamingStrategy.SNAKE_CASE);
@@ -1178,6 +1334,13 @@
         IMPORT_TRAIMETIME(14, "瀵煎叆鍩硅鏈夋晥","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愬鍏ュ煿璁湁鏁堛�戞搷浣�" ),
         BE_HEAD(15, "璁句负涓荤","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愯涓轰富绠°�戞搷浣�" ),
         NOT_HEAD(16, "鍙栨秷涓荤","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愬彇娑堜富绠°�戞搷浣�" ),
+        MEET_BOOK_DEL(17, "鍒犻櫎浼氳瀹ょ敵璇�","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愬垹闄や細璁鐢宠銆戞搷浣�,瀵硅薄淇℃伅${param3}" ),
+        VISIT_DEL(18, "鍒犻櫎璁垮鐢宠","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愬垹闄よ瀹㈢敵璇枫��,瀵硅薄淇℃伅锛�${param3}" ),
+        VISIT_CAR_DEL(19, "鍒犻櫎璁垮鎶ュ","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愬垹闄よ瀹㈡姤澶囥��,瀵硅薄淇℃伅锛�${param3}" ),
+        PLATFROM_BOOK_DEL(20, "鍒犻櫎鏈堝彴棰勭害浠诲姟","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愬垹闄ゆ湀鍙伴绾︿换鍔°��,瀵硅薄淇℃伅锛�${param3}"  ),
+        CAR_BOOK_DEL(21, "鍒犻櫎鍏溅鐢宠","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愬垹闄ゅ叕杞︾敵璇枫��,瀵硅薄淇℃伅锛�${param3}"),
+        PLATFROM_JOB_DEL(22, "鍒犻櫎瀹夋嘲鐗╂祦浣滀笟浠诲姟","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愬垹闄ゅ畨娉扮墿娴佷綔涓氫换鍔°��,瀵硅薄淇℃伅锛�${param3}"  ),
+        HIDEN_DANGER_DEL(23, "鍒犻櫎闅愭偅闅忔墜鎷�","鐢便��${param1}銆戜簬銆�${param2}銆戯紝杩涜銆愬垹闄ら殣鎮i殢鎵嬫媿銆�,瀵硅薄淇℃伅锛�${param3}"),
         ;
 
         // 鎴愬憳鍙橀噺

--
Gitblit v1.9.3