From 49ee3dec1513991d5ff29db09be669a37885b59d Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期四, 18 四月 2024 15:58:24 +0800
Subject: [PATCH] 定时任务bug修改。可重试的http请求工具类，请求配置、sql备份

---
 sql/zgyw418.sql |  115 +++++++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 99 insertions(+), 16 deletions(-)

diff --git a/sql/zgyw0418.sql b/sql/zgyw418.sql
similarity index 99%
rename from sql/zgyw0418.sql
rename to sql/zgyw418.sql
index 761d503..7c85b0a 100644
--- a/sql/zgyw0418.sql
+++ b/sql/zgyw418.sql
@@ -11,7 +11,7 @@
  Target Server Version : 80300
  File Encoding         : 65001
 
- Date: 18/04/2024 11:49:00
+ Date: 18/04/2024 15:56:22
 */
 
 SET NAMES utf8mb4;
@@ -824,6 +824,33 @@
 INSERT INTO `sys_job` VALUES (1, '绯荤粺榛樿锛堟棤鍙傦級', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2024-04-01 16:27:13', '', NULL, '');
 INSERT INTO `sys_job` VALUES (2, '绯荤粺榛樿锛堟湁鍙傦級', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2024-04-01 16:27:13', '', NULL, '');
 INSERT INTO `sys_job` VALUES (3, '绯荤粺榛樿锛堝鍙傦級', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2024-04-01 16:27:13', '', NULL, '');
+INSERT INTO `sys_job` VALUES (100, '娴嬭瘯璇锋眰', 'DEFAULT', 'testJob.test()', '0/20 * * * * ?', '3', '1', '1', 'admin', '2024-04-18 07:37:49', '', NULL, '');
+
+-- ----------------------------
+-- Table structure for sys_job_log
+-- ----------------------------
+DROP TABLE IF EXISTS `sys_job_log`;
+CREATE TABLE `sys_job_log`  (
+  `job_log_id` bigint NOT NULL AUTO_INCREMENT,
+  `job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
+  `job_group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
+  `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
+  `job_message` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
+  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
+  `exception_info` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
+  `start_time` datetime NULL DEFAULT NULL,
+  `stop_time` datetime NULL DEFAULT NULL,
+  `create_time` datetime NULL DEFAULT NULL,
+  PRIMARY KEY (`job_log_id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '瀹氭椂浠诲姟鏃ュ織' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of sys_job_log
+-- ----------------------------
+INSERT INTO `sys_job_log` VALUES (1, '娴嬭瘯璇锋眰', 'DEFAULT', 'testJob.test()', '娴嬭瘯璇锋眰 鎬诲叡鑰楁椂锛�110姣', '0', NULL, NULL, NULL, '2024-04-18 07:47:43');
+INSERT INTO `sys_job_log` VALUES (2, '娴嬭瘯璇锋眰', 'DEFAULT', 'testJob.test()', '娴嬭瘯璇锋眰 鎬诲叡鑰楁椂锛�58118姣', '0', NULL, NULL, NULL, '2024-04-18 07:49:11');
+INSERT INTO `sys_job_log` VALUES (3, '娴嬭瘯璇锋眰', 'DEFAULT', 'testJob.test()', '娴嬭瘯璇锋眰 鎬诲叡鑰楁椂锛�90姣', '0', NULL, NULL, NULL, '2024-04-18 07:49:30');
+INSERT INTO `sys_job_log` VALUES (4, '娴嬭瘯璇锋眰', 'DEFAULT', 'testJob.test()', '娴嬭瘯璇锋眰 鎬诲叡鑰楁椂锛�394姣', '0', NULL, NULL, NULL, '2024-04-18 07:51:49');
 
 -- ----------------------------
 -- Table structure for sys_logininfor
@@ -1539,6 +1566,7 @@
 INSERT INTO `sys_logininfor` VALUES (789, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-18 02:51:05');
 INSERT INTO `sys_logininfor` VALUES (790, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-18 03:00:49');
 INSERT INTO `sys_logininfor` VALUES (791, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-18 03:00:53');
+INSERT INTO `sys_logininfor` VALUES (792, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-18 07:44:34');
 
 -- ----------------------------
 -- Table structure for sys_menu
@@ -1694,7 +1722,7 @@
 INSERT INTO `sys_menu` VALUES (2063, '鑰冩牳绉垎瀹℃牳', 2036, 1, '', NULL, NULL, 1, 0, 'F', '0', '1', 'score:publish:audit', '#', 'admin', '2024-03-20 17:48:12', 'admin', '2024-03-29 15:20:02', '');
 INSERT INTO `sys_menu` VALUES (2064, '杩愮淮鑰冩牳瀹℃牳', 2029, 1, '', NULL, NULL, 1, 0, 'F', '0', '1', 'default:audit', '#', 'admin', '2024-03-21 10:57:52', 'admin', '2024-03-29 15:20:06', '');
 INSERT INTO `sys_menu` VALUES (2065, '鐪佸巺鑰冩牳', 2031, 0, 'province', 'system/result/province/index', NULL, 1, 0, 'C', '0', '1', 'check:result:list', '#', 'admin', '2024-03-25 10:28:40', 'admin', '2024-04-10 05:54:45', '');
-INSERT INTO `sys_menu` VALUES (2066, '宸ュ崟闃堝��', 2082, 0, 'threshold', 'system/threshold/index', NULL, 1, 0, 'C', '0', '0', 'ycl:threshold:list', '#', 'admin', '2024-03-25 11:43:40', 'admin', '2024-04-10 03:58:33', '杩愮淮闃堝�艰彍鍗�');
+INSERT INTO `sys_menu` VALUES (2066, '宸ュ崟闃堝��', 2082, 0, 'threshold', 'system/threshold/index', NULL, 1, 1, 'C', '0', '0', 'ycl:threshold:list', '#', 'admin', '2024-03-25 11:43:40', 'admin', '2024-04-18 06:03:29', '杩愮淮闃堝�艰彍鍗�');
 INSERT INTO `sys_menu` VALUES (2067, '杩愮淮闃堝�兼煡璇�', 2066, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'ycl:threshold:query', '#', 'admin', '2024-03-25 11:43:40', '', NULL, '');
 INSERT INTO `sys_menu` VALUES (2068, '杩愮淮闃堝�兼柊澧�', 2066, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'ycl:threshold:add', '#', 'admin', '2024-03-25 11:43:40', '', NULL, '');
 INSERT INTO `sys_menu` VALUES (2069, '杩愮淮闃堝�间慨鏀�', 2066, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'ycl:threshold:edit', '#', 'admin', '2024-03-25 11:43:40', '', NULL, '');
@@ -1722,6 +1750,36 @@
 INSERT INTO `sys_menu` VALUES (2104, '骞冲彴杩愯鐩戞帶淇敼', 2084, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'platform:platform:edit', '#', 'admin', '2024-04-18 03:34:59', '', NULL, '');
 INSERT INTO `sys_menu` VALUES (2105, '骞冲彴杩愯鐩戞帶鍒犻櫎', 2084, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'platform:platform:remove', '#', 'admin', '2024-04-18 03:34:59', '', NULL, '');
 INSERT INTO `sys_menu` VALUES (2106, '骞冲彴杩愯鐩戞帶瀵煎嚭', 2084, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'platform:platform:export', '#', 'admin', '2024-04-18 03:34:59', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2107, '鏍哥畻瑙勫垯鏌ヨ', 2019, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:query', '#', 'admin', '2024-04-18 06:35:02', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2108, '鏍哥畻瑙勫垯鏂板', 2019, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:add', '#', 'admin', '2024-04-18 06:35:02', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2109, '鏍哥畻瑙勫垯淇敼', 2019, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:edit', '#', 'admin', '2024-04-18 06:35:02', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2110, '鏍哥畻瑙勫垯鍒犻櫎', 2019, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:remove', '#', 'admin', '2024-04-18 06:35:02', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2111, '鏍哥畻瑙勫垯瀵煎嚭', 2019, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:export', '#', 'admin', '2024-04-18 06:35:02', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2112, '鑰冩牳缁撴灉鏌ヨ', NULL, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:result:query', '#', 'admin', '2024-04-18 06:39:05', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2113, '鑰冩牳缁撴灉鏂板', NULL, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:result:add', '#', 'admin', '2024-04-18 06:39:06', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2114, '鑰冩牳缁撴灉淇敼', NULL, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:result:edit', '#', 'admin', '2024-04-18 06:39:06', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2115, '鑰冩牳缁撴灉鍒犻櫎', NULL, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:result:remove', '#', 'admin', '2024-04-18 06:39:06', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2116, '鑰冩牳缁撴灉瀵煎嚭', NULL, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:result:export', '#', 'admin', '2024-04-18 06:39:06', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2117, '鑰冩牳瑙勫垯鏌ヨ', 2015, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:query', '#', 'admin', '2024-04-18 06:50:24', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2118, '鑰冩牳瑙勫垯鏂板', 2015, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:add', '#', 'admin', '2024-04-18 06:50:24', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2119, '鑰冩牳瑙勫垯淇敼', 2015, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:edit', '#', 'admin', '2024-04-18 06:50:24', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2120, '鑰冩牳瑙勫垯鍒犻櫎', 2015, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:remove', '#', 'admin', '2024-04-18 06:50:24', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2121, '鑰冩牳瑙勫垯瀵煎嚭', 2015, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'calculate:rule:export', '#', 'admin', '2024-04-18 06:50:24', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2122, '鑰冩牳妯℃澘鏌ヨ', 2017, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:template:query', '#', 'admin', '2024-04-18 06:57:11', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2123, '鑰冩牳妯℃澘鏂板', 2017, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:template:add', '#', 'admin', '2024-04-18 06:57:11', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2124, '鑰冩牳妯℃澘淇敼', 2017, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:template:edit', '#', 'admin', '2024-04-18 06:57:11', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2125, '鑰冩牳妯℃澘鍒犻櫎', 2017, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:template:remove', '#', 'admin', '2024-04-18 06:57:11', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2126, '鑰冩牳妯℃澘瀵煎嚭', 2017, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:template:export', '#', 'admin', '2024-04-18 06:57:12', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2127, '鍚堝悓绉垎鏌ヨ', NULL, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'platform:score:query', '#', 'admin', '2024-04-18 07:01:27', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2128, '鍚堝悓绉垎鏂板', NULL, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'platform:score:add', '#', 'admin', '2024-04-18 07:01:27', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2129, '鍚堝悓绉垎淇敼', NULL, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'platform:score:edit', '#', 'admin', '2024-04-18 07:01:27', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2130, '鍚堝悓绉垎鍒犻櫎', NULL, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'platform:score:remove', '#', 'admin', '2024-04-18 07:01:27', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2131, '鍚堝悓绉垎瀵煎嚭', NULL, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'platform:score:export', '#', 'admin', '2024-04-18 07:01:27', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2132, '杩愮淮鍚堝悓鏌ヨ', 2091, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:contract:query', '#', 'admin', '2024-04-18 07:43:43', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2133, '杩愮淮鍚堝悓鏂板', 2091, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:contract:add', '#', 'admin', '2024-04-18 07:43:43', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2134, '杩愮淮鍚堝悓淇敼', 2091, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:contract:edit', '#', 'admin', '2024-04-18 07:43:43', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2135, '杩愮淮鍚堝悓鍒犻櫎', 2091, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:contract:remove', '#', 'admin', '2024-04-18 07:43:43', '', NULL, '');
+INSERT INTO `sys_menu` VALUES (2136, '杩愮淮鍚堝悓瀵煎嚭', 2091, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'system:contract:export', '#', 'admin', '2024-04-18 07:43:43', '', NULL, '');
 
 -- ----------------------------
 -- Table structure for sys_oper_log
@@ -2752,6 +2810,28 @@
 INSERT INTO `sys_oper_log` VALUES (1095, '鑿滃崟绠＄悊', 2, 'com.ycl.system.controller.SysMenuController.edit()', 'PUT', 1, 'admin', '鐪佸巺', '/system/menu', '192.168.3.87', '鍐呯綉IP', '{\"children\":[],\"component\":\"system/recovery/index\",\"createTime\":\"2024-03-04 10:14:38\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2008,\"menuName\":\"寮傚父鎭㈠鐩戞帶\",\"menuType\":\"C\",\"orderNum\":4,\"params\":{},\"parentId\":2000,\"path\":\"recovery\",\"perms\":\"system:monitor:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 03:19:57', 151);
 INSERT INTO `sys_oper_log` VALUES (1096, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":6,\"createTime\":\"2024-04-18 11:30:42\",\"createUser\":1,\"createUserName\":\"admin\",\"deleted\":\"0\",\"deptId\":[101,102,201,202,203,210,211],\"description\":\"娴嬭瘯妯℃澘\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"id\":1,\"pageNum\":1,\"pageSize\":10,\"status\":\"1\",\"templateName\":\"杞﹁締鑰冩牳娴嬭瘯妯℃澘\",\"updateTime\":\"2024-04-17 17:11:17\",\"updateUser\":1,\"updateUserName\":\"admin\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 03:30:40', 606);
 INSERT INTO `sys_oper_log` VALUES (1097, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":6,\"createTime\":\"2024-04-18 11:36:20\",\"deptId\":[101,102,201,202,203,210,211],\"description\":\"test\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"pageNum\":1,\"pageSize\":10,\"status\":\"0\",\"templateName\":\"test\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 03:36:19', 299);
+INSERT INTO `sys_oper_log` VALUES (1098, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":\"6.0\",\"createTime\":\"2024-04-18 13:55:20\",\"deptId\":[101],\"description\":\"111\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"pageNum\":1,\"pageSize\":10,\"status\":\"0\",\"templateName\":\"test\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 05:55:18', 115510);
+INSERT INTO `sys_oper_log` VALUES (1099, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":\"6.0\",\"createTime\":\"2024-04-18 13:57:16\",\"deptId\":[101],\"description\":\"111\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"pageNum\":1,\"pageSize\":10,\"status\":\"0\",\"templateName\":\"test\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 05:57:14', 68542);
+INSERT INTO `sys_oper_log` VALUES (1100, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":\"1\",\"createTime\":\"2024-04-18 14:01:34\",\"deptId\":[101],\"description\":\"1\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"pageNum\":1,\"pageSize\":10,\"ruleFormList\":[{\"ruleId\":16,\"weight\":\"1\"},{\"ruleId\":18,\"weight\":\"2\"},{\"ruleId\":17,\"weight\":\"3\"}],\"status\":\"0\",\"templateName\":\"1111\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 06:01:33', 33492);
+INSERT INTO `sys_oper_log` VALUES (1101, '鑿滃崟绠＄悊', 2, 'com.ycl.system.controller.SysMenuController.edit()', 'PUT', 1, 'admin', '鐪佸巺', '/system/menu', '127.0.0.1', '鍐呯綉IP', '{\"children\":[],\"component\":\"system/threshold/index\",\"createTime\":\"2024-03-25 11:43:40\",\"icon\":\"#\",\"isCache\":\"1\",\"isFrame\":\"1\",\"menuId\":2066,\"menuName\":\"宸ュ崟闃堝�糪",\"menuType\":\"C\",\"orderNum\":0,\"params\":{},\"parentId\":2082,\"path\":\"threshold\",\"perms\":\"ycl:threshold:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 06:03:29', 195);
+INSERT INTO `sys_oper_log` VALUES (1102, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":\"1\",\"createTime\":\"2024-04-18 14:07:52\",\"deptId\":[101],\"description\":\"1\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"pageNum\":1,\"pageSize\":10,\"ruleFormList\":[{\"ruleId\":16,\"weight\":\"1\"},{\"ruleId\":18,\"weight\":\"2\"},{\"ruleId\":17,\"weight\":\"3\"}],\"status\":\"0\",\"templateName\":\"1111\"}', NULL, 1, '', '2024-04-18 06:07:51', 412);
+INSERT INTO `sys_oper_log` VALUES (1103, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":\"1\",\"createTime\":\"2024-04-18 14:11:35\",\"deptId\":[101],\"description\":\"1\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"pageNum\":1,\"pageSize\":10,\"ruleFormList\":[{\"ruleId\":16,\"weight\":\"1\"},{\"ruleId\":18,\"weight\":\"2\"},{\"ruleId\":17,\"weight\":\"3\"}],\"status\":\"0\",\"templateName\":\"1111\"}', NULL, 1, '', '2024-04-18 06:11:34', 376);
+INSERT INTO `sys_oper_log` VALUES (1104, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":\"1\",\"createTime\":\"2024-04-18 14:15:09\",\"deptId\":[101],\"description\":\"1\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"pageNum\":1,\"pageSize\":10,\"ruleFormList\":[{\"ruleId\":16,\"weight\":\"1\"},{\"ruleId\":18,\"weight\":\"2\"},{\"ruleId\":17,\"weight\":\"3\"}],\"status\":\"0\",\"templateName\":\"1111\"}', NULL, 1, 'com.ycl.platform.mapper.CheckTemplateRuleMapper.insert (batch index #1) failed. Cause: java.sql.BatchUpdateException: Field \'check_template_id\' doesn\'t have a default value\n; Field \'check_template_id\' doesn\'t have a default value', '2024-04-18 06:15:08', 672);
+INSERT INTO `sys_oper_log` VALUES (1105, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":\"1\",\"createTime\":\"2024-04-18 14:18:23\",\"deptId\":[101],\"description\":\"1\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"pageNum\":1,\"pageSize\":10,\"ruleFormList\":[{\"ruleId\":16,\"weight\":\"1\"},{\"ruleId\":18,\"weight\":\"2\"},{\"ruleId\":17,\"weight\":\"3\"}],\"status\":\"0\",\"templateName\":\"1111\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 06:18:22', 567);
+INSERT INTO `sys_oper_log` VALUES (1106, '瀹氭椂浠诲姟', 1, 'com.ycl.system.controller.SysJobController.add()', 'POST', 1, 'admin', '鐪佸巺', '/monitor/job', '127.0.0.1', '鍐呯綉IP', '{\"concurrent\":\"1\",\"cronExpression\":\"0/20 * * * * ?\",\"invokeTarget\":\"testRequestJob.test\",\"jobGroup\":\"DEFAULT\",\"jobName\":\"娴嬭瘯璇锋眰\",\"misfirePolicy\":\"3\",\"nextValidTime\":\"2024-04-18 15:32:40\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"鏂板浠诲姟\'娴嬭瘯璇锋眰\'澶辫触锛岀洰鏍囧瓧绗︿覆涓嶅湪鐧藉悕鍗曞唴\",\"code\":500}', 0, NULL, '2024-04-18 07:32:35', 35);
+INSERT INTO `sys_oper_log` VALUES (1107, '瀹氭椂浠诲姟', 1, 'com.ycl.system.controller.SysJobController.add()', 'POST', 1, 'admin', '鐪佸巺', '/monitor/job', '127.0.0.1', '鍐呯綉IP', '{\"concurrent\":\"1\",\"cronExpression\":\"0/20 * * * * ?\",\"invokeTarget\":\"testJob.test\",\"jobGroup\":\"DEFAULT\",\"jobName\":\"娴嬭瘯璇锋眰\",\"misfirePolicy\":\"3\",\"nextValidTime\":\"2024-04-18 15:34:00\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"鏂板浠诲姟\'娴嬭瘯璇锋眰\'澶辫触锛岀洰鏍囧瓧绗︿覆涓嶅湪鐧藉悕鍗曞唴\",\"code\":500}', 0, NULL, '2024-04-18 07:33:57', 8);
+INSERT INTO `sys_oper_log` VALUES (1108, '瀹氭椂浠诲姟', 1, 'com.ycl.system.controller.SysJobController.add()', 'POST', 1, 'admin', '鐪佸巺', '/monitor/job', '127.0.0.1', '鍐呯綉IP', '{\"concurrent\":\"1\",\"cronExpression\":\"0/20 * * * * ?\",\"invokeTarget\":\"testJob.test\",\"jobGroup\":\"DEFAULT\",\"jobName\":\"娴嬭瘯璇锋眰\",\"misfirePolicy\":\"3\",\"nextValidTime\":\"2024-04-18 15:35:20\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"鏂板浠诲姟\'娴嬭瘯璇锋眰\'澶辫触锛岀洰鏍囧瓧绗︿覆涓嶅湪鐧藉悕鍗曞唴\",\"code\":500}', 0, NULL, '2024-04-18 07:35:04', 9948);
+INSERT INTO `sys_oper_log` VALUES (1109, '瀹氭椂浠诲姟', 1, 'com.ycl.system.controller.SysJobController.add()', 'POST', 1, 'admin', '鐪佸巺', '/monitor/job', '127.0.0.1', '鍐呯綉IP', '{\"concurrent\":\"1\",\"cronExpression\":\"0/20 * * * * ?\",\"invokeTarget\":\"testJob.test()\",\"jobGroup\":\"DEFAULT\",\"jobName\":\"娴嬭瘯璇锋眰\",\"misfirePolicy\":\"3\",\"nextValidTime\":\"2024-04-18 15:35:20\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"鏂板浠诲姟\'娴嬭瘯璇锋眰\'澶辫触锛岀洰鏍囧瓧绗︿覆涓嶅湪鐧藉悕鍗曞唴\",\"code\":500}', 0, NULL, '2024-04-18 07:35:17', 1);
+INSERT INTO `sys_oper_log` VALUES (1110, '瀹氭椂浠诲姟', 1, 'com.ycl.system.controller.SysJobController.add()', 'POST', 1, 'admin', '鐪佸巺', '/monitor/job', '127.0.0.1', '鍐呯綉IP', '{\"concurrent\":\"1\",\"cronExpression\":\"0/20 * * * * ?\",\"invokeTarget\":\"testJob.test()\",\"jobGroup\":\"DEFAULT\",\"jobName\":\"娴嬭瘯璇锋眰\",\"misfirePolicy\":\"3\",\"nextValidTime\":\"2024-04-18 15:36:00\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"鏂板浠诲姟\'娴嬭瘯璇锋眰\'澶辫触锛岀洰鏍囧瓧绗︿覆涓嶅湪鐧藉悕鍗曞唴\",\"code\":500}', 0, NULL, '2024-04-18 07:35:47', 1);
+INSERT INTO `sys_oper_log` VALUES (1111, '瀹氭椂浠诲姟', 1, 'com.ycl.system.controller.SysJobController.add()', 'POST', 1, 'admin', '鐪佸巺', '/monitor/job', '127.0.0.1', '鍐呯綉IP', '{\"concurrent\":\"1\",\"cronExpression\":\"0/20 * * * * ?\",\"invokeTarget\":\"testJob.test()\",\"jobGroup\":\"DEFAULT\",\"jobName\":\"娴嬭瘯璇锋眰\",\"misfirePolicy\":\"3\",\"nextValidTime\":\"2024-04-18 15:37:20\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"鏂板浠诲姟\'娴嬭瘯璇锋眰\'澶辫触锛岀洰鏍囧瓧绗︿覆涓嶅湪鐧藉悕鍗曞唴\",\"code\":500}', 0, NULL, '2024-04-18 07:37:04', 63978);
+INSERT INTO `sys_oper_log` VALUES (1112, '瀹氭椂浠诲姟', 1, 'com.ycl.system.controller.SysJobController.add()', 'POST', 1, 'admin', '鐪佸巺', '/monitor/job', '127.0.0.1', '鍐呯綉IP', '{\"concurrent\":\"1\",\"createBy\":\"admin\",\"cronExpression\":\"0/20 * * * * ?\",\"invokeTarget\":\"testJob.test()\",\"jobGroup\":\"DEFAULT\",\"jobId\":100,\"jobName\":\"娴嬭瘯璇锋眰\",\"misfirePolicy\":\"3\",\"nextValidTime\":\"2024-04-18 15:38:00\",\"params\":{},\"status\":\"1\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 07:37:49', 339);
+INSERT INTO `sys_oper_log` VALUES (1113, '瀹氭椂浠诲姟', 2, 'com.ycl.system.controller.SysJobController.run()', 'PUT', 1, 'admin', '鐪佸巺', '/monitor/job/run', '127.0.0.1', '鍐呯綉IP', '{\"jobGroup\":\"DEFAULT\",\"jobId\":100,\"misfirePolicy\":\"0\",\"params\":{}}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 07:38:03', 182);
+INSERT INTO `sys_oper_log` VALUES (1114, '鑰冩牳妯℃澘', 1, 'com.ycl.platform.controller.CheckTemplateController.add()', 'POST', 1, 'admin', '鐪佸巺', '/check/template', '127.0.0.1', '鍐呯綉IP', '{\"adjustCoefficient\":1,\"adjustWay\":\"*\",\"alarmScore\":\"6\",\"deptId\":[101,102,201,202,203,210,211],\"description\":\"111\",\"examineCategory\":0,\"examineTag\":1,\"frequency\":0,\"pageNum\":1,\"pageSize\":10,\"ruleFormList\":[{\"ruleId\":14,\"weight\":\"1\"},{\"ruleId\":16,\"weight\":\"1\"}],\"status\":\"0\",\"templateName\":\"1111\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 07:45:28', 552);
+INSERT INTO `sys_oper_log` VALUES (1115, '瀹氭椂浠诲姟', 2, 'com.ycl.system.controller.SysJobController.run()', 'PUT', 1, 'admin', '鐪佸巺', '/monitor/job/run', '127.0.0.1', '鍐呯綉IP', '{\"jobGroup\":\"DEFAULT\",\"jobId\":100,\"misfirePolicy\":\"0\",\"params\":{}}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 07:46:19', 279);
+INSERT INTO `sys_oper_log` VALUES (1116, '瀹氭椂浠诲姟', 2, 'com.ycl.system.controller.SysJobController.run()', 'PUT', 1, 'admin', '鐪佸巺', '/monitor/job/run', '127.0.0.1', '鍐呯綉IP', '{\"jobGroup\":\"DEFAULT\",\"jobId\":100,\"misfirePolicy\":\"0\",\"params\":{}}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 07:47:43', 235);
+INSERT INTO `sys_oper_log` VALUES (1117, '瀹氭椂浠诲姟', 2, 'com.ycl.system.controller.SysJobController.run()', 'PUT', 1, 'admin', '鐪佸巺', '/monitor/job/run', '127.0.0.1', '鍐呯綉IP', '{\"jobGroup\":\"DEFAULT\",\"jobId\":100,\"misfirePolicy\":\"0\",\"params\":{}}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 07:49:11', 58156);
+INSERT INTO `sys_oper_log` VALUES (1118, '瀹氭椂浠诲姟', 2, 'com.ycl.system.controller.SysJobController.run()', 'PUT', 1, 'admin', '鐪佸巺', '/monitor/job/run', '127.0.0.1', '鍐呯綉IP', '{\"jobGroup\":\"DEFAULT\",\"jobId\":100,\"misfirePolicy\":\"0\",\"params\":{}}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 07:49:30', 192);
+INSERT INTO `sys_oper_log` VALUES (1119, '瀹氭椂浠诲姟', 2, 'com.ycl.system.controller.SysJobController.run()', 'PUT', 1, 'admin', '鐪佸巺', '/monitor/job/run', '127.0.0.1', '鍐呯綉IP', '{\"jobGroup\":\"DEFAULT\",\"jobId\":100,\"misfirePolicy\":\"0\",\"params\":{}}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-18 07:51:49', 294);
 
 -- ----------------------------
 -- Table structure for sys_post
@@ -3085,7 +3165,7 @@
 -- ----------------------------
 -- Records of sys_user
 -- ----------------------------
-INSERT INTO `sys_user` VALUES (1, 100, 'admin', '瓒呯', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$xHdnEgPAOwtRZhqqJi87I.UH/TY6kl09gpePBCQP8jN5fBlyMJe8m', '0', '0', '127.0.0.1', '2024-04-18 11:00:53', 'admin', '2024-02-04 16:27:33', '', '2024-03-11 10:03:49', '绠＄悊鍛�', 1);
+INSERT INTO `sys_user` VALUES (1, 100, 'admin', '瓒呯', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$xHdnEgPAOwtRZhqqJi87I.UH/TY6kl09gpePBCQP8jN5fBlyMJe8m', '0', '0', '127.0.0.1', '2024-04-18 15:44:36', 'admin', '2024-02-04 16:27:33', '', '2024-03-11 10:03:49', '绠＄悊鍛�', 1);
 INSERT INTO `sys_user` VALUES (100, 207, 'zgga', '鑷础甯傚眬鍏畨', '00', '', '', '0', '', '$2a$10$T.OMRlqYt2srhxkYxOqQcOrsL.mlvwKGw7TYjdnNKwxzLqzREJu66', '0', '0', '127.0.0.1', '2024-04-12 15:45:24', 'admin', '2024-03-07 16:23:27', 'admin', '2024-03-11 14:34:06', NULL, 1);
 INSERT INTO `sys_user` VALUES (101, 101, 'zgfsga', '鑷础瀵岄『璀﹀畼', '00', '', '', '0', '', '$2a$10$lFOzvNQz9u/VSptoqvwr6.rzkEfcI.z9R9orXulsgwqc.4.VzXLLK', '0', '0', '127.0.0.1', '2024-04-12 16:25:27', 'admin', '2024-03-18 10:18:20', 'admin', NULL, NULL, 1);
 INSERT INTO `sys_user` VALUES (102, 209, 'zgyw', 'zgyw', '00', '', '13345678910', '0', '', '$2a$10$D9.9k.7OsWKaL.eEqShN8e5Gl2u8uasxyINPlIugZrGNlEHN7bSDi', '0', '0', '127.0.0.1', '2024-04-12 16:52:01', 'admin', '2024-03-18 10:22:15', 'admin', NULL, NULL, 1);
@@ -3339,7 +3419,7 @@
   `update_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
   `job_id` int NULL DEFAULT NULL COMMENT '瀹氭椂浠诲姟id',
   `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '0/1 鍚敤/鍋滅敤',
-  `deleted` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '閫昏緫鍒犻櫎',
+  `deleted` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '閫昏緫鍒犻櫎',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鑰冩牳妯℃澘' ROW_FORMAT = DYNAMIC;
 
@@ -3353,6 +3433,11 @@
 INSERT INTO `t_check_template` VALUES (13, '鐪佸巺浜鸿劯鑰冩牳娴嬭瘯妯℃澘', 1, '*', 0, 1, 6.0000, '娴嬭瘯妯℃澘', '[101,102,201,202,203,210,211]', 0, '2024-04-07 11:36:27', '2024-04-07 11:36:27', 1, 'admin', 1, 'admin', NULL, '0', '0');
 INSERT INTO `t_check_template` VALUES (14, '鐪佸巺瑙嗛鑰冩牳娴嬭瘯妯℃澘', 1, '*', 0, 2, 6.0000, '娴嬭瘯妯℃澘', '[101,102,201,202,203,210,211]', 0, '2024-04-07 11:36:27', '2024-04-17 09:32:10', 1, 'admin', 1, 'admin', NULL, '0', '0');
 INSERT INTO `t_check_template` VALUES (18, 'test', 1, '*', 1, 0, 6.0000, 'test', '[101,102,201,202,203,210,211]', 0, '2024-04-18 11:36:21', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL);
+INSERT INTO `t_check_template` VALUES (19, 'test', 1, '*', 1, 0, NULL, '111', '[101]', 0, '2024-04-18 13:55:20', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL);
+INSERT INTO `t_check_template` VALUES (20, 'test', 1, '*', 1, 0, NULL, '111', '[101]', 0, '2024-04-18 13:57:16', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL);
+INSERT INTO `t_check_template` VALUES (21, '1111', 1, '*', 1, 0, NULL, '1', '[101]', 0, '2024-04-18 14:01:35', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL);
+INSERT INTO `t_check_template` VALUES (25, '1111', 1, '*', 1, 0, NULL, '1', '[101]', 0, '2024-04-18 14:18:24', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL);
+INSERT INTO `t_check_template` VALUES (26, '1111', 1, '*', 1, 0, NULL, '111', '[101,102,201,202,203,210,211]', 0, '2024-04-18 15:45:29', '2024-04-18 15:45:29', 1, 'admin', 1, 'admin', NULL, '0', '0');
 
 -- ----------------------------
 -- Table structure for t_check_template_rule
@@ -3365,16 +3450,13 @@
   `check_rule_id` int NOT NULL COMMENT '鑰冩牳瑙勫垯ID',
   `weight` decimal(10, 2) NULL DEFAULT NULL COMMENT '瑙勫垯鏉冮噸',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鑰冩牳妯℃澘-瑙勫垯涓棿琛�' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鑰冩牳妯℃澘-瑙勫垯涓棿琛�' ROW_FORMAT = DYNAMIC;
 
 -- ----------------------------
 -- Records of t_check_template_rule
 -- ----------------------------
-INSERT INTO `t_check_template_rule` VALUES (1, 1, NULL, 1, 0.50);
-INSERT INTO `t_check_template_rule` VALUES (18, 1, NULL, 2, 0.50);
-INSERT INTO `t_check_template_rule` VALUES (19, 1, NULL, 3, 0.50);
-INSERT INTO `t_check_template_rule` VALUES (20, 1, NULL, 4, 0.50);
-INSERT INTO `t_check_template_rule` VALUES (21, 1, NULL, 5, 0.50);
+INSERT INTO `t_check_template_rule` VALUES (25, 1, NULL, 14, 1.00);
+INSERT INTO `t_check_template_rule` VALUES (26, 1, NULL, 16, 1.00);
 
 -- ----------------------------
 -- Table structure for t_contract
@@ -9155,7 +9237,7 @@
   `begin_create_time` datetime NULL DEFAULT NULL COMMENT '鐢熸晥鏃堕棿',
   `end_create_time` datetime NULL DEFAULT NULL COMMENT '澶辨晥鏃堕棿',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎶ュ' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎶ュ' ROW_FORMAT = DYNAMIC;
 
 -- ----------------------------
 -- Records of t_report
@@ -9284,7 +9366,7 @@
   `processing_period` int NULL DEFAULT NULL COMMENT '澶勭悊鏈熼檺锛堝皬鏃讹級',
   PRIMARY KEY (`id`) USING BTREE,
   INDEX `work_order_no_index`(`work_order_no` ASC) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '宸ュ崟' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '宸ュ崟' ROW_FORMAT = DYNAMIC;
 
 -- ----------------------------
 -- Records of t_work_order
@@ -9310,7 +9392,7 @@
 INSERT INTO `t_work_order` VALUES (19, '20240417152724', 'DISTRIBUTED', '璁惧鏁呴殰', 4, '鑷础甯傚瘜椤哄幙閲滄睙澶ч亾涓196鍙�', 4, NULL, NULL, NULL, NULL, NULL, '2024-04-17 15:27:24', '2024-04-17 15:27:24', '0', NULL);
 INSERT INTO `t_work_order` VALUES (20, '20240417152734', 'DISTRIBUTED', '甯傛斂鏂藉伐', 6, '瀵岄『鍘挎案骞撮晣', 2, NULL, NULL, NULL, NULL, NULL, '2024-04-17 15:27:34', '2024-04-17 15:27:34', '0', NULL);
 INSERT INTO `t_work_order` VALUES (21, '20240417174159', 'WAIT_DISTRIBUTE', '甯傛斂鏂藉伐', 4, '鑷础甯傚瘜椤哄幙閲滄睙澶ч亾涓196鍙�', 4, NULL, NULL, NULL, NULL, NULL, '2024-04-17 17:42:00', '2024-04-17 17:42:00', '0', NULL);
-INSERT INTO `t_work_order` VALUES (22, '20240417174748', 'WAIT_DISTRIBUTE', '璁惧鏁呴殰', 6, '瀵岄『鍘挎案骞撮晣', 4, NULL, NULL, NULL, NULL, NULL, '2024-04-17 17:47:49', '2024-04-17 17:47:49', '0', NULL);
+INSERT INTO `t_work_order` VALUES (22, '20240417174748', 'DISTRIBUTED', '璁惧鏁呴殰', 6, '瀵岄『鍘挎案骞撮晣', 4, NULL, NULL, NULL, NULL, NULL, '2024-04-17 17:47:49', '2024-04-17 17:47:49', '0', NULL);
 INSERT INTO `t_work_order` VALUES (23, '20240417174752', 'DISTRIBUTED', '甯傛斂鏂藉伐', 6, '瀵岄『鍘挎案骞撮晣', 4, NULL, NULL, NULL, NULL, NULL, '2024-04-17 17:47:53', '2024-04-17 17:47:53', '0', NULL);
 INSERT INTO `t_work_order` VALUES (24, '20240418102853', 'DISTRIBUTED', '甯傛斂鏂藉伐', 4, '鑷础甯傚瘜椤哄幙閲滄睙澶ч亾涓196鍙�', 4, NULL, NULL, NULL, NULL, NULL, '2024-04-18 10:28:54', '2024-04-18 10:28:54', '0', NULL);
 INSERT INTO `t_work_order` VALUES (25, '20240418103145', 'DISTRIBUTED', '甯傛斂鏂藉伐', 6, '瀵岄『鍘挎案骞撮晣', 2, NULL, NULL, NULL, NULL, NULL, '2024-04-18 10:31:45', '2024-04-18 10:31:45', '0', NULL);
@@ -9370,6 +9452,7 @@
 INSERT INTO `t_work_order_distribute_record` VALUES (16, 23, 1, 'SELECTED_DISTRIBUTE', '2024-04-18 02:36:01', NULL, '0');
 INSERT INTO `t_work_order_distribute_record` VALUES (17, 25, 1, 'FAST_DISTRIBUTE', '2024-04-18 02:36:27', NULL, '0');
 INSERT INTO `t_work_order_distribute_record` VALUES (18, 20, 1, 'ALL_DISTRIBUTE', '2024-04-18 02:36:57', NULL, '0');
+INSERT INTO `t_work_order_distribute_record` VALUES (19, 22, 1, 'SELECTED_DISTRIBUTE', '2024-04-18 07:07:55', NULL, '0');
 
 -- ----------------------------
 -- Table structure for t_work_order_yw_condition_record
@@ -9479,9 +9562,9 @@
 -- ----------------------------
 -- Records of t_yw_threshold
 -- ----------------------------
-INSERT INTO `t_yw_threshold` VALUES (2, 'car', '[{\"label\":\"杩囪溅鏁版嵁閲廫",\"value\":\"12\",\"value2\":\"22\"},{\"label\":\"杩囪溅缂哄け鐜嘰",\"value\":\"9\",\"value2\":\"22\"},{\"label\":\"鏈夋晥杩囪溅鏁版嵁閲廫",\"value\":\"99\",\"value2\":\"22\"},{\"label\":\"鎶芥閲廫",\"value\":\"89\",\"value2\":\"23\"},{\"label\":\"璁惧娲昏穬鐜嘰",\"value\":\"79\",\"value2\":\"24\"},{\"label\":\"鎶撴媿鍙婃椂鐜嘰",\"value\":\"77\",\"value2\":\"25\"},{\"label\":\"鏃堕挓鍑嗙‘鐜嘰",\"value\":\"87\",\"value2\":\"26\"},{\"label\":\"鏃堕挓涓嶅噯纭巼\",\"value\":\"23\",\"value2\":\"27\"}]', '2024-03-25 14:22:08', '2024-04-09 14:49:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO `t_yw_threshold` VALUES (4, 'face', '[{\"label\":\"鎶撴媿閲廫",\"value\":\"57\",\"value2\":\"123\"},{\"label\":\"鍙婃椂鐜嘰",\"value\":\"22\",\"value2\":\"4324\"},{\"label\":\"寤惰繜閲廫",\"value\":\"90\",\"value2\":\"124\"},{\"label\":\"鎶芥閲廫",\"value\":\"34\",\"value2\":\"124\"},{\"label\":\"璁惧娲昏穬鐜嘰",\"value\":\"94\",\"value2\":\"2321\"},{\"label\":\"鎶撴媿鍙婃椂鐜嘰",\"value\":\"99\",\"value2\":\"15\"},{\"label\":\"鏃堕挓鍑嗙‘鐜嘰",\"value\":\"80\",\"value2\":\"215\"},{\"label\":\"鏃堕挓涓嶅噯纭巼\",\"value\":\"10\",\"value2\":\"5125\"}]', '2024-03-25 15:23:05', '2024-04-09 14:49:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO `t_yw_threshold` VALUES (5, 'video', '[{\"label\":\"閲囬泦璁惧鎬绘暟\",\"value\":\"25\",\"value2\":\"124\"},{\"label\":\"鐩戞祴姝ｅ父璁惧鏁癨",\"value\":\"28\",\"value2\":\"235\"},{\"label\":\"缂栫爜寮傚父璁惧鏁癨",\"value\":\"52\",\"value2\":\"231\"},{\"label\":\"缁忕含搴﹀紓甯歌澶囨暟\",\"value\":\"84\",\"value2\":\"3145\"}]', '2024-03-25 17:59:56', '2024-04-09 14:49:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO `t_yw_threshold` VALUES (2, 'car', '[{\"label\":\"杩囪溅鏁版嵁閲廫",\"value\":\"12\",\"value2\":\"22\"},{\"label\":\"杩囪溅缂哄け鐜嘰",\"value\":\"9\",\"value2\":\"22\"},{\"label\":\"鏈夋晥杩囪溅鏁版嵁閲廫",\"value\":\"99\",\"value2\":\"22\"},{\"label\":\"鎶芥閲廫",\"value\":\"89\",\"value2\":\"23\"},{\"label\":\"璁惧娲昏穬鐜嘰",\"value\":\"79\",\"value2\":\"24\"},{\"label\":\"鎶撴媿鍙婃椂鐜嘰",\"value\":\"77\",\"value2\":\"25\"},{\"label\":\"鏃堕挓鍑嗙‘鐜嘰",\"value\":\"87\",\"value2\":\"26\"},{\"label\":\"鏃堕挓涓嶅噯纭巼\",\"value\":\"23\",\"value2\":\"27\"}]', '2024-03-25 14:22:08', '2024-04-09 14:49:20', '0', NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO `t_yw_threshold` VALUES (4, 'face', '[{\"label\":\"鎶撴媿閲廫",\"value\":\"57\",\"value2\":\"123\"},{\"label\":\"鍙婃椂鐜嘰",\"value\":\"22\",\"value2\":\"4324\"},{\"label\":\"寤惰繜閲廫",\"value\":\"90\",\"value2\":\"124\"},{\"label\":\"鎶芥閲廫",\"value\":\"34\",\"value2\":\"124\"},{\"label\":\"璁惧娲昏穬鐜嘰",\"value\":\"94\",\"value2\":\"2321\"},{\"label\":\"鎶撴媿鍙婃椂鐜嘰",\"value\":\"99\",\"value2\":\"15\"},{\"label\":\"鏃堕挓鍑嗙‘鐜嘰",\"value\":\"80\",\"value2\":\"215\"},{\"label\":\"鏃堕挓涓嶅噯纭巼\",\"value\":\"10\",\"value2\":\"5125\"}]', '2024-03-25 15:23:05', '2024-04-09 14:49:34', '0', NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO `t_yw_threshold` VALUES (5, 'video', '[{\"label\":\"閲囬泦璁惧鎬绘暟\",\"value\":\"25\",\"value2\":\"124\"},{\"label\":\"鐩戞祴姝ｅ父璁惧鏁癨",\"value\":\"28\",\"value2\":\"235\"},{\"label\":\"缂栫爜寮傚父璁惧鏁癨",\"value\":\"52\",\"value2\":\"231\"},{\"label\":\"缁忕含搴﹀紓甯歌澶囨暟\",\"value\":\"84\",\"value2\":\"3145\"}]', '2024-03-25 17:59:56', '2024-04-09 14:49:39', '0', NULL, NULL, NULL, NULL, NULL, NULL);
 
 -- ----------------------------
 -- Table structure for t_yw_unit

--
Gitblit v1.8.0