productDev/dmvisit.git

			@@ -334,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 >= 7){
			String tt = "";
			for (int i = 0; i < l-6; i++) {
			tt = tt+"*";
			}
			if(l <= 8){
			return s.substring(0,3)+"***"+s.substring(l-2,l);
			return s.substring(0,2)+tt+s.substring(l-4,l);
			}
			return s;
			}
			@@ -417,6 +418,7 @@
			int selfTruck = 3;
			int outTruck = 4;
			int cityComTruck = 5;
			int unknown = 6;
			}


			@@ -676,14 +678,60 @@
			}

			public static void main(String[] args) {
			getChinesePingyin("DDaa江萍的对对对");
			// 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("皖AA10991"));
			// System.out.println(Constants.getVehiclePlateNo("湘B140D17").getDescription());
			// System.out.println(Constants.getVehiclePlateNo("宿AP0637").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>");
			}


			@@ -1282,6 +1330,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}】，进行【删除隐患随手拍】,对象信息：${param3}"),
			;

			// 成员变量