/*
 Navicat Premium Data Transfer

 Source Server         : 47.100.202.245
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : 47.100.202.245:3306
 Source Schema         : workflow

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 16/11/2021 12:22:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for departments
-- ----------------------------
DROP TABLE IF EXISTS `departments`;
CREATE TABLE `departments`  (
  `dept_id` int(11) NOT NULL COMMENT '部门id',
  `dept_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名',
  `leader` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门主管',
  `parent_id` int(11) NULL DEFAULT NULL COMMENT '父部门id',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`dept_id`) USING BTREE,
  INDEX `dept_id`(`dept_id`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE,
  INDEX `leader`(`leader`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of departments
-- ----------------------------
INSERT INTO `departments` VALUES (35453, '业务部', NULL, 4319868, '2020-09-16 13:30:37', '2020-09-16 13:30:39');
INSERT INTO `departments` VALUES (231535, '生产管理部', NULL, 1486186, '2020-09-16 13:30:39', '2020-09-16 13:30:42');
INSERT INTO `departments` VALUES (264868, '行政人事部', NULL, 1486186, '2020-09-16 13:30:42', '2020-09-16 13:30:44');
INSERT INTO `departments` VALUES (689698, '客服部', NULL, 4319868, '2020-09-16 13:30:34', '2020-09-16 13:30:36');
INSERT INTO `departments` VALUES (1486186, 'xx科技有限公司', NULL, 0, '2020-09-16 13:26:25', '2020-09-16 13:26:28');
INSERT INTO `departments` VALUES (4319868, '销售服务部', NULL, 1486186, '2020-09-16 13:30:44', '2020-09-16 13:30:46');
INSERT INTO `departments` VALUES (6179678, '研发部', NULL, 1486186, '2020-09-16 13:26:56', '2020-09-17 16:31:32');

-- ----------------------------
-- Table structure for form_groups
-- ----------------------------
DROP TABLE IF EXISTS `form_groups`;
CREATE TABLE `form_groups`  (
  `group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '组名',
  `sort_num` int(3) NOT NULL DEFAULT 0 COMMENT '排序号',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`group_id`) USING BTREE,
  UNIQUE INDEX `group_name`(`group_name`) USING BTREE,
  INDEX `group_id`(`group_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of form_groups
-- ----------------------------
INSERT INTO `form_groups` VALUES (0, '已停用', 999999, NULL, '2020-09-22 10:40:04');
INSERT INTO `form_groups` VALUES (1, '其他', 2, NULL, '2021-11-15 18:51:26');
INSERT INTO `form_groups` VALUES (48, '校车', 4, '2021-07-20 23:12:28', '2021-11-15 19:23:44');
INSERT INTO `form_groups` VALUES (49, '工程车', 3, '2021-07-21 10:48:58', '2021-11-15 18:51:26');

-- ----------------------------
-- Table structure for process_instances
-- ----------------------------
DROP TABLE IF EXISTS `process_instances`;
CREATE TABLE `process_instances`  (
  `instance_id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '审批实例ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `commit_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发起人ID',
  `forms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '表单内容',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '流程状态',
  `result` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '流程结果',
  `instance_nodes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '流程审批链',
  `created` datetime(0) NULL DEFAULT NULL,
  `updated` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`instance_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of process_instances
-- ----------------------------
INSERT INTO `process_instances` VALUES ('f3fbb09f-0f31-43c5-98cc-a7f10eac563e', NULL, '381496', '', NULL, NULL, '[{\"mode\":\"OR\",\"userNode\":[{\"userName\":\"付佳威\",\"userId\":\"381496\"}],\"taskName\":\"发起人\",\"nodeType\":\"ROOT\",\"taskId\":\"45648648\"},{\"mode\":\"OR\",\"userNode\":[{\"userName\":\"付佳威\",\"userId\":\"381496\"},{\"userName\":\"李秋香\",\"userId\":\"489564\"}],\"taskName\":\"主管审批\",\"nodeType\":\"SP\",\"taskId\":\"4548648\"},{\"userNode\":[{\"userName\":\"王翠花\",\"userId\":\"568898\"},{\"userName\":\"张三\",\"userId\":\"6418616\"}],\"taskName\":\"抄送\",\"nodeType\":\"CS\",\"taskId\":\"454458648\"},{\"mode\":\"AND\",\"userNode\":[{\"userName\":\"王翠花\",\"userId\":\"568898\"},{\"userName\":\"张三\",\"userId\":\"6418616\"}],\"taskName\":\"总经理审批\",\"nodeType\":\"SP\",\"taskId\":\"454458648\"}]', '2020-10-13 17:41:23', '2020-10-13 17:41:23');

-- ----------------------------
-- Table structure for process_templates
-- ----------------------------
DROP TABLE IF EXISTS `process_templates`;
CREATE TABLE `process_templates`  (
  `template_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '审批摸板ID',
  `template_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '摸板名称',
  `form_items` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '摸板表单',
  `process` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '流程数据',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图标',
  `background` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标背景色',
  `notify` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '通知',
  `who_commit` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '谁能提交',
  `who_edit` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '谁能编辑',
  `who_export` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '谁能导出数据',
  `is_stop` bit(1) NULL DEFAULT b'0' COMMENT '是否已停用',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`template_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of process_templates
-- ----------------------------
INSERT INTO `process_templates` VALUES ('00966178', '费用报销', '[{\"text\":\"报销内容\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":true,\"props\":{\"type\":\"text\"},\"id\":\"5549700751115\"},{\"text\":\"科目\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":true,\"props\":{\"type\":\"text\"},\"id\":\"5549700751115\"},{\"text\":\"金额\",\"name\":\"jInput\",\"icon\":\"el-icon-more-outline\",\"valid\":true,\"props\":{\"type\":\"number\"},\"id\":\"1472100755841\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"99814008955\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"DAY\",\"limit\":1,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]}}}}', 'el-icon-eleme', 'rgba(30, 144, 255, 1)', NULL, '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', b'0', '费用报销', '2021-10-17 00:16:06', '2021-10-17 00:16:06');
INSERT INTO `process_templates` VALUES ('08003218', '违抛渣土', '[{\"text\":\"单行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":true,\"props\":{\"type\":\"text\"},\"id\":\"6355407921907\"},{\"text\":\"单选框\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":false,\"props\":{\"type\":\"one\",\"options\":[\"选项\"]},\"id\":\"8632654452174\"},{\"text\":\"单选框\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":false,\"props\":{\"type\":\"one\",\"options\":[\"选项\"]},\"id\":\"7767807927173\"},{\"text\":\"日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":false,\"props\":{\"type\":\"dateTime\"},\"id\":\"7699707959338\"},{\"text\":\"上传附件\",\"name\":\"jFile\",\"icon\":\"el-icon-upload\",\"valid\":false,\"props\":{\"type\":\"file\"},\"id\":\"7122907930048\"},{\"text\":\"说明文字\",\"name\":\"explain\",\"icon\":\"el-icon-warning-outline\",\"valid\":false,\"props\":{\"remark\":\"请输入说明内容\"},\"id\":\"9400907931661\"},{\"text\":\"部门\",\"name\":\"orgSelect\",\"icon\":\"el-icon-takeaway-box\",\"valid\":false,\"props\":{\"type\":\"dept\"},\"id\":\"8238907934311\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}', 'el-icon-circle-plus', 'rgba(27, 9, 3, 1)', NULL, '[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', '[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', '[{\"id\":231535,\"type\":\"dept\",\"name\":\"生产管理部\"},{\"id\":264868,\"type\":\"dept\",\"name\":\"行政人事部\"},{\"id\":4319868,\"type\":\"dept\",\"name\":\"销售服务部\"},{\"id\":6179678,\"type\":\"dept\",\"name\":\"研发部\"},{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', b'0', '', '2021-07-19 23:20:03', '2021-09-02 20:25:18');
INSERT INTO `process_templates` VALUES ('13236661', '入住流程', '[]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"80399128573\",\"pid\":\"10000\",\"name\":\"发起入住\",\"type\":\"SP\",\"node\":{\"id\":\"62396128965\",\"pid\":\"80399128573\",\"name\":\"审核信息\",\"type\":\"SP\",\"node\":{\"id\":\"56758129078\",\"pid\":\"62396128965\",\"name\":\"核名\",\"type\":\"SP\",\"node\":{\"id\":\"33400129210\",\"pid\":\"56758129078\",\"name\":\"办理营业执照\",\"type\":\"SP\",\"node\":{\"id\":\"85521129374\",\"pid\":\"33400129210\",\"name\":\"刻章\",\"type\":\"SP\",\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"10000\"],\"condition\":[{\"id\":\"10000\",\"name\":\"发起人\",\"type\":\"org\",\"values\":[{\"id\":6418616,\"name\":\"张三\",\"type\":\"user\",\"sex\":true,\"selected\":false}]}]}],\"connection\":\"AND\",\"pid\":\"43307129465\",\"id\":\"99210129465\",\"type\":\"TJ\",\"name\":\"指定企服\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"43307129465\",\"id\":\"54303129465\",\"type\":\"TJ\",\"name\":\"银行开户\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"43307129465\",\"id\":\"88629129752\",\"type\":\"TJ\",\"name\":\"税务备案\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"43307129465\",\"id\":\"88225129916\",\"type\":\"TJ\",\"name\":\"发起协议\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"48481130127\",\"pid\":\"88225129916\",\"name\":\"审核协议\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}],\"id\":\"43307129465\",\"pid\":\"85521129374\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"30495129465\",\"pid\":\"43307129465\"},\"connection\":\"OR\"},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":6418616,\"type\":\"user\",\"name\":\"张三\"}]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":6418616,\"type\":\"user\",\"name\":\"张三\"}]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":6418616,\"type\":\"user\",\"name\":\"张三\"}]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":6418616,\"type\":\"user\",\"name\":\"张三\"}]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":6418616,\"type\":\"user\",\"name\":\"张三\"}]}}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'1', '入驻流程', '2021-11-10 11:00:37', '2021-11-13 10:44:33');
INSERT INTO `process_templates` VALUES ('13456015', '未命名的表单', '[]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"96631134367\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"id\":\"35172134397\",\"pid\":\"96631134367\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'0', '', '2021-11-10 11:04:16', '2021-11-10 11:04:16');
INSERT INTO `process_templates` VALUES ('25206085', '动态表单', '[{\"text\":\"企业名称\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\",\"placeholder\":\"请选择企业名称\"},\"id\":\"9106925080268\"},{\"text\":\"上传图片\",\"name\":\"jFile\",\"icon\":\"el-icon-picture-outline\",\"valid\":false,\"props\":{\"type\":\"image\"},\"id\":\"9390905412102\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"91079054387\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"id\":\"74734054409\",\"pid\":\"91079054387\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'0', '', '2021-07-16 16:46:46', '2021-08-21 13:15:47');
INSERT INTO `process_templates` VALUES ('25208172', '产品库', '[{\"text\":\"产品编号\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\"},\"id\":\"2652959501838\"},{\"text\":\"产品名称\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\"},\"id\":\"9278259516618\"},{\"text\":\"检验项目\",\"name\":\"jSelect\",\"icon\":\"el-icon-s-grid\",\"valid\":false,\"props\":{\"type\":\"more\",\"options\":[\"外观\",\"功能\",\"尺寸\"]},\"id\":\"5913959527385\"},{\"text\":\"附件\",\"name\":\"jFile\",\"icon\":\"el-icon-upload\",\"valid\":false,\"props\":{\"type\":\"file\"},\"id\":\"8467959572286\"},{\"text\":\"签名\",\"name\":\"sign\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{},\"id\":\"3816459583318\"},{\"text\":\"人员\",\"name\":\"orgSelect\",\"icon\":\"el-icon-user\",\"valid\":false,\"props\":{\"type\":\"user\",\"single\":false},\"id\":\"8328859599768\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"16263199667\",\"id\":\"58518199667\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"16263199667\",\"id\":\"31330199667\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"29244199730\",\"id\":\"88083199730\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"29244199730\",\"id\":\"24865199730\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"57631199789\",\"id\":\"35272199789\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"57631199789\",\"id\":\"14786199789\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"57631199789\",\"pid\":\"24865199730\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"94734199789\",\"pid\":\"57631199789\"}}}],\"id\":\"29244199730\",\"pid\":\"31330199667\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"82428199730\",\"pid\":\"29244199730\"}}}],\"id\":\"16263199667\",\"pid\":\"10000\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"38505199667\",\"pid\":\"16263199667\"}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'0', '产品介绍', '2021-04-19 17:40:08', '2021-09-24 09:31:09');
INSERT INTO `process_templates` VALUES ('25817867', '未命名', '[{\"text\":\"人员\",\"name\":\"orgSelect\",\"icon\":\"el-icon-user\",\"valid\":false,\"props\":{\"type\":\"user\"},\"id\":\"7618525778809\"},{\"text\":\"签字\",\"name\":\"sign\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{},\"id\":\"4817425781751\"},{\"text\":\"上传附件\",\"name\":\"jFile\",\"icon\":\"el-icon-upload\",\"valid\":false,\"props\":{\"type\":\"file\"},\"id\":\"4400925784450\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"55302258056\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"SELF_SELECT\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-camera-solid', 'rgba(199, 21, 133, 1)', NULL, '[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', '[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', '[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', b'0', '黑乎乎', '2021-09-14 21:23:38', '2021-09-14 21:23:38');
INSERT INTO `process_templates` VALUES ('34364387', 'z-test-2', '[]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"62758354811\",\"id\":\"76023354811\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"23180354828\",\"pid\":\"58005352779\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":61769798,\"type\":\"user\",\"name\":\"李四\"}]}}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"62758354811\",\"id\":\"13524354811\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"62758354811\",\"id\":\"49317005640\",\"type\":\"TJ\",\"name\":\"条件4\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"62758354811\",\"pid\":\"10000\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"36628354811\",\"pid\":\"62758354811\"},\"connection\":\"OR\"}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'0', 'test2', '2021-09-13 19:59:24', '2021-11-11 11:16:21');
INSERT INTO `process_templates` VALUES ('35565463', '未命名的表单', '[{\"text\":\"请选择\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":false,\"props\":{\"type\":\"one\",\"options\":[\"选项1\",\"新选项1\",\"新选项2\"]},\"id\":\"7831735456802\"},{\"text\":\"单行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\"},\"id\":\"4751635454304\"},{\"text\":\"多行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit-outline\",\"valid\":false,\"props\":{\"type\":\"textarea\"},\"id\":\"4712935439573\"},{\"text\":\"单行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\"},\"id\":\"7682135441941\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}', 'el-icon-s-custom', 'rgba(0, 206, 209, 1)', NULL, '[]', '[]', '[]', b'0', '', '2021-11-10 17:12:45', '2021-11-10 17:12:45');
INSERT INTO `process_templates` VALUES ('40806849', '未命名的表单', '[]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"55335407070\",\"pid\":\"10000\",\"name\":\"领用确认\",\"type\":\"SP\",\"node\":{\"id\":\"42116407135\",\"pid\":\"55335407070\",\"name\":\"领用发货\",\"type\":\"SP\",\"node\":{\"id\":\"78549407257\",\"pid\":\"42116407135\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},\"props\":{\"type\":\"SELF\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},\"props\":{\"type\":\"SELF\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'0', '', '2021-11-09 14:53:27', '2021-11-09 14:53:27');
INSERT INTO `process_templates` VALUES ('51878242', '这是个啥', '[]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'1', '', '2021-07-22 19:04:38', '2021-09-02 19:27:56');
INSERT INTO `process_templates` VALUES ('60368016', '工资条', '[{\"text\":\"单行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\"},\"id\":\"9461038171066\"},{\"text\":\"说明文字\",\"name\":\"explain\",\"icon\":\"el-icon-warning-outline\",\"valid\":false,\"props\":{\"remark\":\"请输入说明内容\"},\"id\":\"2628238248413\"},{\"text\":\"多行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit-outline\",\"valid\":false,\"props\":{\"type\":\"textarea\"},\"id\":\"7883138179046\"},{\"text\":\"单选框\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":false,\"props\":{\"type\":\"one\",\"options\":[\"选项\"]},\"id\":\"6568038183629\"},{\"text\":\"日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":false,\"props\":{\"type\":\"dateTime\"},\"id\":\"1007738209063\"},{\"text\":\"部门\",\"name\":\"orgSelect\",\"icon\":\"el-icon-takeaway-box\",\"valid\":false,\"props\":{\"type\":\"dept\",\"single\":false},\"id\":\"2408538215830\"},{\"text\":\"签字\",\"name\":\"sign\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{},\"id\":\"9802138252947\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'0', '工资条通知a', '2021-09-12 23:26:08', '2021-09-13 22:12:12');
INSERT INTO `process_templates` VALUES ('60407089', '新的审批', '[{\"text\":\"多行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit-outline\",\"valid\":false,\"props\":{\"type\":\"textarea\"},\"id\":\"2367459778623\"},{\"text\":\"单选框\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":false,\"props\":{\"type\":\"one\",\"options\":[\"选项\"]},\"id\":\"8338759779438\"},{\"text\":\"日期区间\",\"name\":\"jDateTime\",\"icon\":\"el-icon-c-scale-to-original\",\"valid\":false,\"props\":{\"type\":\"dateTimeRange\"},\"id\":\"4694659790007\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"33361637440\",\"id\":\"55137637440\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"33361637440\",\"id\":\"75725637440\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"33361637440\",\"pid\":\"10000\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"33460637440\",\"pid\":\"33361637440\",\"node\":{\"id\":\"80965637475\",\"pid\":\"33460637440\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"id\":\"46135637689\",\"pid\":\"80965637475\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"id\":\"12474637761\",\"pid\":\"46135637689\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},\"props\":{\"type\":\"LEADER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}}}', 'el-icon-s-custom', '#718dff', NULL, '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', b'1', '', '2021-10-09 14:20:07', '2021-11-15 16:09:49');
INSERT INTO `process_templates` VALUES ('68268693', '资产报废流程', '[{\"text\":\"资产名称\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":true,\"props\":{\"type\":\"text\"},\"id\":\"7157467968658\"},{\"text\":\"数量\",\"name\":\"jInput\",\"icon\":\"el-icon-more-outline\",\"valid\":true,\"props\":{\"type\":\"number\"},\"id\":\"9873567978457\"},{\"text\":\"报废日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":true,\"props\":{\"type\":\"dateTime\"},\"id\":\"1823068092174\"},{\"text\":\"资产类型\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":true,\"props\":{\"type\":\"one\",\"options\":[\"办公电脑\",\"办公文具\",\"其他贵重资产\"]},\"id\":\"1070767997625\"},{\"text\":\"上传图片\",\"name\":\"jFile\",\"icon\":\"el-icon-picture-outline\",\"valid\":false,\"props\":{\"type\":\"image\"},\"id\":\"4932668077898\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":264868,\"type\":\"dept\",\"name\":\"行政人事部\"}]}},\"node\":{\"id\":\"48662681213\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"AND\",\"cids\":[\"1070767997625\"],\"condition\":[{\"id\":\"1070767997625\",\"name\":\"资产类型\",\"type\":\"one\",\"options\":[\"办公电脑\",\"办公文具\",\"其他贵重资产\"],\"values\":[\"办公电脑\"],\"symbol\":\"=\"}]}],\"connection\":\"AND\",\"pid\":\"67853681249\",\"id\":\"15533681249\",\"type\":\"TJ\",\"name\":\"电脑电子类\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"57115682027\",\"pid\":\"15533681249\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"SELF_SELECT\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}},{\"groups\":[{\"connection\":\"AND\",\"cids\":[\"1070767997625\"],\"condition\":[{\"id\":\"1070767997625\",\"name\":\"资产类型\",\"type\":\"one\",\"options\":[\"办公电脑\",\"办公文具\",\"其他贵重资产\"],\"values\":[\"办公文具\",\"其他贵重资产\"],\"symbol\":\"in\"}]},{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"67853681249\",\"id\":\"12770681249\",\"type\":\"TJ\",\"name\":\"贵重资产或者文具\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"92902682264\",\"id\":\"85320682264\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"62439682576\",\"id\":\"31269682576\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"67459682638\",\"pid\":\"31269682576\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"62439682576\",\"id\":\"39180682576\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"53806682610\",\"pid\":\"39180682576\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}],\"id\":\"62439682576\",\"pid\":\"85320682264\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"35556682576\",\"pid\":\"62439682576\",\"node\":{\"id\":\"21164593462\",\"pid\":\"35556682576\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"92902682264\",\"id\":\"84192682264\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"94643682295\",\"pid\":\"84192682264\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}],\"id\":\"92902682264\",\"pid\":\"12770681249\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"85833682264\",\"pid\":\"92902682264\"}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"67853681249\",\"id\":\"59396681966\",\"type\":\"TJ\",\"name\":\"条件3\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"95793682124\",\"pid\":\"59396681966\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"SELF_SELECT\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":true,\"roles\":[],\"objs\":[]}}}}],\"id\":\"67853681249\",\"pid\":\"48662681213\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"70367681249\",\"pid\":\"67853681249\",\"node\":{\"id\":\"30219682325\",\"pid\":\"70367681249\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}},\"connection\":\"OR\"},\"props\":{\"type\":\"LEADER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-s-platform', 'rgba(0, 206, 209, 1)', NULL, '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', '[]', '[]', b'0', '', '2021-04-16 18:17:49', '2021-10-18 20:34:54');
INSERT INTO `process_templates` VALUES ('68408993', '补卡申请', '[{\"text\":\"补卡日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":true,\"props\":{\"type\":\"dateTime\"},\"id\":\"8060368325224\"},{\"text\":\"补卡类型\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":true,\"props\":{\"type\":\"one\",\"options\":[\"上班卡\",\"下班卡\"],\"placeholder\":\"补卡类型选择哈\"},\"id\":\"5441068338375\"},{\"text\":\"补卡原因\",\"name\":\"jInput\",\"icon\":\"el-icon-edit-outline\",\"valid\":false,\"props\":{\"type\":\"textarea\"},\"id\":\"4424368371941\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"65045144075\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"id\":\"27211144100\",\"pid\":\"65045144075\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":489564,\"type\":\"user\",\"name\":\"李秋香\"}]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]}}}}', 'el-icon-s-claim', 'rgba(255, 140, 0, 1)', NULL, '[]', '[]', '[]', b'0', '', '2021-04-16 18:20:09', '2021-08-26 11:39:58');
INSERT INTO `process_templates` VALUES ('73587610', '离职申请', '[{\"text\":\"离职日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":true,\"props\":{\"type\":\"dateTime\"},\"id\":\"2005573506908\"},{\"text\":\"离职原因\",\"name\":\"jInput\",\"icon\":\"el-icon-edit-outline\",\"valid\":true,\"props\":{\"type\":\"textarea\"},\"id\":\"9854773528213\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"96910735485\",\"pid\":\"10000\",\"name\":\"主管审批\",\"type\":\"SP\",\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"53445735451\",\"id\":\"33523735451\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"53445735451\",\"id\":\"69092735451\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"53445735451\",\"pid\":\"96910735485\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"73138735451\",\"pid\":\"53445735451\",\"node\":{\"id\":\"53573735687\",\"pid\":\"73138735451\",\"name\":\"抄送人事\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}},\"props\":{\"type\":\"LEADER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-s-custom', 'rgba(255, 69, 0, 1)', NULL, '[]', '[]', '[]', b'1', '离职申请', '2021-04-16 19:46:28', '2021-09-01 16:04:06');
INSERT INTO `process_templates` VALUES ('74143105', '办公资源采购申请', '[{\"text\":\"采购的物品/资源\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":true,\"props\":{\"type\":\"text\",\"placeholder\":\"要买什么\"},\"id\":\"3587573756148\"},{\"text\":\"付款金额\",\"name\":\"jInput\",\"icon\":\"el-icon-more-outline\",\"valid\":true,\"props\":{\"type\":\"number\",\"placeholder\":\"提示文字\"},\"id\":\"7210373836937\"},{\"text\":\"使用部门\",\"name\":\"orgSelect\",\"icon\":\"el-icon-takeaway-box\",\"valid\":true,\"props\":{\"type\":\"dept\"},\"id\":\"6474973820961\"},{\"text\":\"期望日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":true,\"props\":{\"type\":\"dateTime\"},\"id\":\"2305073786474\"},{\"text\":\"上传附件\",\"name\":\"jFile\",\"icon\":\"el-icon-upload\",\"valid\":false,\"props\":{\"type\":\"file\"},\"id\":\"6104757543199\"},{\"text\":\"签字\",\"name\":\"sign\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{},\"id\":\"1169955658394\"},{\"text\":\"日期区间\",\"name\":\"jDateTime\",\"icon\":\"el-icon-c-scale-to-original\",\"valid\":false,\"props\":{\"type\":\"dateTimeRange\"},\"id\":\"9593755372761\"},{\"text\":\"日期区间\",\"name\":\"jDateTime\",\"icon\":\"el-icon-c-scale-to-original\",\"valid\":false,\"props\":{\"type\":\"dateTimeRange\"},\"id\":\"9593755372761\"},{\"text\":\"日期区间\",\"name\":\"jDateTime\",\"icon\":\"el-icon-c-scale-to-original\",\"valid\":false,\"props\":{\"type\":\"dateTimeRange\"},\"id\":\"9593755372761\"},{\"text\":\"申请材料\",\"name\":\"jFile\",\"icon\":\"el-icon-upload\",\"valid\":false,\"props\":{\"type\":\"file\"},\"id\":\"9849073808787\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"65993738501\",\"pid\":\"10000\",\"name\":\"主管审批\",\"type\":\"SP\",\"node\":{\"id\":\"27808549892\",\"pid\":\"65993738501\",\"name\":\"抄送人\",\"type\":\"CS\",\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"7210373836937\"],\"condition\":[{\"id\":\"7210373836937\",\"name\":\"付款金额\",\"type\":\"number\",\"symbol\":\">\",\"left\":\"1000\"}]}],\"connection\":\"AND\",\"pid\":\"46265738627\",\"id\":\"91984738627\",\"type\":\"TJ\",\"name\":\"金额>1000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"75398739527\",\"pid\":\"91984738627\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]}}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"7210373836937\"],\"condition\":[{\"id\":\"7210373836937\",\"name\":\"付款金额\",\"type\":\"number\",\"symbol\":\">\",\"left\":\"10000\"}]}],\"connection\":\"AND\",\"pid\":\"46265738627\",\"id\":\"22967738628\",\"type\":\"TJ\",\"name\":\"金额>1w\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"25069739564\",\"pid\":\"22967738628\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"7210373836937\"],\"condition\":[{\"id\":\"7210373836937\",\"name\":\"付款金额\",\"type\":\"number\",\"symbol\":\">\",\"left\":\"20000\"}]}],\"connection\":\"AND\",\"pid\":\"46265738627\",\"id\":\"87361739300\",\"type\":\"TJ\",\"name\":\"大于2w\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"10000\"],\"condition\":[{\"id\":\"10000\",\"name\":\"发起人\",\"type\":\"org\",\"values\":[{\"id\":6179678,\"name\":\"研发部\",\"type\":\"dept\",\"selected\":false}]}]}],\"connection\":\"AND\",\"pid\":\"78181739643\",\"id\":\"59261739643\",\"type\":\"TJ\",\"name\":\"如果是研发部\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"64053739721\",\"pid\":\"59261739643\",\"name\":\"指定审批\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]}}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"10000\"],\"condition\":[{\"id\":\"10000\",\"name\":\"发起人\",\"type\":\"org\",\"values\":[{\"id\":1486186,\"name\":\"xx科技有限公司\",\"type\":\"dept\",\"selected\":false}]}]}],\"connection\":\"AND\",\"pid\":\"78181739643\",\"id\":\"83129739643\",\"type\":\"TJ\",\"name\":\"如果是其他部门\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"99179739753\",\"pid\":\"83129739643\",\"name\":\"如果是其他部门\",\"type\":\"SP\",\"props\":{\"type\":\"LEADER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}],\"id\":\"78181739643\",\"pid\":\"87361739300\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"80935739643\",\"pid\":\"78181739643\"},\"connection\":\"OR\"}}],\"id\":\"46265738627\",\"pid\":\"27808549892\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"57474738627\",\"pid\":\"46265738627\",\"node\":{\"id\":\"49504741191\",\"pid\":\"57474738627\",\"name\":\"抄送李四处理\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":61769798,\"type\":\"user\",\"name\":\"李四\"}]}}}},\"connection\":\"OR\"},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"},{\"id\":6418616,\"type\":\"user\",\"name\":\"张三\"}]}}},\"props\":{\"type\":\"LEADER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-s-goods', 'rgba(5, 167, 5, 1)', NULL, '[]', '[]', '[]', b'0', '申请购买办公资料', '2021-04-16 19:55:43', '2021-10-08 10:43:10');
INSERT INTO `process_templates` VALUES ('75733229', 'yuxin', '[]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"76715780738\",\"id\":\"10443780738\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"10277062267\",\"id\":\"93221062267\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"10277062267\",\"id\":\"68897062267\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"10277062267\",\"pid\":\"10443780738\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"39344062267\",\"pid\":\"10277062267\",\"node\":{\"id\":\"24997913927\",\"pid\":\"39344062267\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"76715780738\",\"id\":\"98868780738\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"58415408585\",\"pid\":\"98868780738\",\"name\":\"抄送人\",\"type\":\"CS\",\"node\":{\"id\":\"98831319079\",\"pid\":\"58415408585\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"76715780738\",\"id\":\"31820780856\",\"type\":\"TJ\",\"name\":\"条件3\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"76715780738\",\"pid\":\"10000\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"45353780738\",\"pid\":\"76715780738\",\"node\":{\"id\":\"58041781950\",\"pid\":\"45353780738\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"10261785050\",\"id\":\"61384785050\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"10261785050\",\"id\":\"97881785050\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"10261785050\",\"pid\":\"58041781950\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"77201785050\",\"pid\":\"10261785050\"}},\"props\":{\"type\":\"SELF_SELECT\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"DAY\",\"limit\":10,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":true,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'0', '', '2021-09-24 17:28:53', '2021-09-30 16:43:58');
INSERT INTO `process_templates` VALUES ('85232953', '渣土车违停', '[{\"text\":\"单行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\"},\"id\":\"5521694418422\"},{\"text\":\"日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":false,\"props\":{\"type\":\"dateTime\"},\"id\":\"3382897730063\"},{\"text\":\"多行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit-outline\",\"valid\":false,\"props\":{\"type\":\"textarea\"},\"id\":\"5996694419755\"},{\"text\":\"数字输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-more-outline\",\"valid\":false,\"props\":{\"type\":\"number\"},\"id\":\"7157194421204\"},{\"text\":\"单选框\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":false,\"props\":{\"type\":\"one\",\"options\":[\"选项\"]},\"id\":\"8215694422656\"},{\"text\":\"多选框\",\"name\":\"jSelect\",\"icon\":\"el-icon-s-grid\",\"valid\":false,\"props\":{\"type\":\"more\",\"options\":[\"选项\"]},\"id\":\"7024894424179\"},{\"text\":\"上传图片\",\"name\":\"jFile\",\"icon\":\"el-icon-picture-outline\",\"valid\":false,\"props\":{\"type\":\"image\"},\"id\":\"5050694425536\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"86697455525\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"SELF_SELECT\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'0', '', '2021-09-02 20:20:33', '2021-09-11 15:33:10');
INSERT INTO `process_templates` VALUES ('88335142', '超载', '[]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}', 'el-icon-s-custom', '#FF7800', NULL, '[{\"id\":231535,\"type\":\"dept\",\"name\":\"生产管理部\"}]', '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', b'0', '11', '2021-08-23 11:12:15', '2021-09-02 19:34:11');
INSERT INTO `process_templates` VALUES ('89431232', '请假', '[{\"text\":\"部门\",\"name\":\"orgSelect\",\"icon\":\"el-icon-takeaway-box\",\"valid\":false,\"props\":{\"type\":\"dept\"},\"id\":\"3473580279856\"},{\"text\":\"学号\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\"},\"id\":\"8695780290079\"},{\"text\":\"学院\",\"name\":\"jSelect\",\"icon\":\"el-icon-s-grid\",\"valid\":false,\"props\":{\"type\":\"more\",\"options\":[\"本专科生\"]},\"id\":\"7250680372642\"},{\"text\":\"学段\",\"name\":\"jSelect\",\"icon\":\"el-icon-s-grid\",\"valid\":false,\"props\":{\"type\":\"more\",\"options\":[\"本专科生\"]},\"id\":\"6219980327291\"},{\"text\":\"说明文字\",\"name\":\"explain\",\"icon\":\"el-icon-warning-outline\",\"valid\":false,\"props\":{\"remark\":\"请输入说明内容\"},\"id\":\"8453767598366\"},{\"text\":\"单行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\"},\"id\":\"9742767593950\"},{\"text\":\"签字\",\"name\":\"sign\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{},\"id\":\"2187967585385\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"94328676097\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":true,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"42702804579\",\"pid\":\"94328676097\",\"name\":\"抄送人\",\"type\":\"CS\",\"node\":{\"id\":\"74833804932\",\"pid\":\"42702804579\",\"name\":\"抄送人\",\"type\":\"CS\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}}', 'el-icon-s-custom', '#FF7800', NULL, '[{\"id\":231535,\"type\":\"dept\",\"name\":\"生产管理部\"},{\"id\":264868,\"type\":\"dept\",\"name\":\"行政人事部\"},{\"id\":4319868,\"type\":\"dept\",\"name\":\"销售服务部\"},{\"id\":6179678,\"type\":\"dept\",\"name\":\"研发部\"},{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', b'0', '黑金沙跌幅超过市场各方有辨识度', '2021-07-20 21:57:11', '2021-11-11 15:33:37');
INSERT INTO `process_templates` VALUES ('89838817', '违停', '[{\"text\":\"单行输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{\"type\":\"text\"},\"id\":\"3291971530074\"},{\"text\":\"单选框\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":false,\"props\":{\"type\":\"one\",\"options\":[\"选项\",\"新选项\",\"新选项\"]},\"id\":\"4953471531591\"},{\"text\":\"人员\",\"name\":\"orgSelect\",\"icon\":\"el-icon-user\",\"valid\":false,\"props\":{\"type\":\"user\"},\"id\":\"3942573775437\"},{\"text\":\"日期区间\",\"name\":\"jDateTime\",\"icon\":\"el-icon-c-scale-to-original\",\"valid\":false,\"props\":{\"type\":\"dateTimeRange\"},\"id\":\"9833473774437\"},{\"text\":\"日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":false,\"props\":{\"type\":\"dateTime\"},\"id\":\"8645171537458\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"36351738159\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"id\":\"76351985400\",\"pid\":\"36351738159\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"id\":\"17058985516\",\"pid\":\"76351985400\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":61769798,\"type\":\"user\",\"name\":\"李四\"},{\"id\":6418616,\"type\":\"user\",\"name\":\"张三\"}]}},\"node\":{\"id\":\"13182439174\",\"pid\":\"17058985516\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":489564,\"type\":\"user\",\"name\":\"李秋香\"}]}}}},\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]}}},\"props\":{\"type\":\"LEADER\",\"mode\":\"NEXT\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_USER\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-s-custom', '#FF7800', NULL, '[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', '[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', '[]', b'0', '', '2021-08-17 16:43:59', '2021-10-08 14:17:48');
INSERT INTO `process_templates` VALUES ('91343471', '校车违章', '[]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"69851912872\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]}}}}', 'el-icon-s-custom', '#FF7800', NULL, '[]', '[]', '[]', b'0', '', '2021-09-01 18:15:43', '2021-09-02 19:39:47');
INSERT INTO `process_templates` VALUES ('91846144', '闯红灯', '[{\"text\":\"多选框\",\"name\":\"jSelect\",\"icon\":\"el-icon-s-grid\",\"valid\":false,\"props\":{\"type\":\"more\",\"options\":[\"选项\",\"新选项\",\"新选项2\"]},\"id\":\"5716391804258\"},{\"text\":\"数字输入框\",\"name\":\"jInput\",\"icon\":\"el-icon-more-outline\",\"valid\":false,\"props\":{\"type\":\"number\"},\"id\":\"1416114635299\"},{\"text\":\"部门\",\"name\":\"orgSelect\",\"icon\":\"el-icon-takeaway-box\",\"valid\":false,\"props\":{\"type\":\"dept\"},\"id\":\"7981391806404\"},{\"text\":\"多选框\",\"name\":\"jSelect\",\"icon\":\"el-icon-s-grid\",\"valid\":false,\"props\":{\"type\":\"more\",\"options\":[\"选项\",\"新选项\",\"新选项2\"]},\"id\":\"1010913819991\"},{\"text\":\"日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":false,\"props\":{\"type\":\"dateTime\"},\"id\":\"6567926610402\"},{\"text\":\"日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":true,\"props\":{\"type\":\"dateTime\"},\"id\":\"6567926610402\"},{\"text\":\"签字\",\"name\":\"sign\",\"icon\":\"el-icon-edit\",\"valid\":false,\"props\":{},\"id\":\"3204771839496\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"10000\"],\"condition\":[{\"id\":\"10000\",\"name\":\"发起人\",\"type\":\"org\",\"values\":[{\"id\":231535,\"name\":\"生产管理部\",\"type\":\"dept\",\"selected\":false}]}]}],\"connection\":\"AND\",\"pid\":\"59241718896\",\"id\":\"28419718896\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"59241718896\",\"id\":\"31584718896\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"59241718896\",\"pid\":\"10000\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"35190718896\",\"pid\":\"59241718896\",\"node\":{\"id\":\"51798700613\",\"pid\":\"35190718896\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"10000\"],\"condition\":[{\"id\":\"10000\",\"name\":\"发起人\",\"type\":\"org\",\"values\":[{\"id\":381496,\"name\":\"付佳威\",\"type\":\"user\",\"sex\":true,\"selected\":false}]}]},{\"connection\":\"OR\",\"cids\":[\"10000\"],\"condition\":[{\"id\":\"10000\",\"name\":\"发起人\",\"type\":\"org\",\"values\":[{\"id\":1486186,\"name\":\"xx科技有限公司\",\"type\":\"dept\",\"selected\":false}]}]}],\"connection\":\"AND\",\"pid\":\"70566701072\",\"id\":\"38526701072\",\"type\":\"TJ\",\"name\":\"金额大于100\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"10000\"],\"condition\":[{\"id\":\"10000\",\"name\":\"发起人\",\"type\":\"org\",\"values\":[{\"id\":264868,\"name\":\"行政人事部\",\"type\":\"dept\",\"selected\":false}]}]}],\"connection\":\"AND\",\"pid\":\"70566701072\",\"id\":\"97894701072\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"70566701072\",\"pid\":\"51798700613\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"47329701072\",\"pid\":\"70566701072\",\"node\":{\"id\":\"77916918130\",\"pid\":\"47329701072\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"SELF\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"58480701016\",\"pid\":\"77916918130\",\"name\":\"审批人\",\"type\":\"SP\",\"node\":{\"id\":\"74744268961\",\"pid\":\"58480701016\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":true,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[{\"id\":489564,\"type\":\"user\",\"name\":\"李秋香\"}]}}},\"props\":{\"type\":\"LEADER\",\"mode\":\"NEXT\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":3,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}},\"connection\":\"OR\"},\"props\":{\"type\":\"LEADER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}},\"connection\":\"OR\"}}', 'el-icon-s-promotion', 'rgba(255, 215, 0, 1)', NULL, '[{\"id\":6418616,\"type\":\"user\",\"name\":\"张三\"}]', '[{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', b'1', '管理员', '2021-06-04 15:30:46', '2021-11-10 11:43:43');
INSERT INTO `process_templates` VALUES ('94888127', '超速处理', '[{\"text\":\"单位\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":true,\"props\":{\"type\":\"one\",\"options\":[\"选项\"]},\"id\":\"8289694767260\"},{\"text\":\"测试\",\"name\":\"jSelect\",\"icon\":\"el-icon-menu\",\"valid\":true,\"props\":{\"type\":\"one\",\"options\":[\"选项\"]},\"id\":\"4622194797189\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"conditions\":[{\"groups\":[{\"connection\":\"OR\",\"cids\":[\"4622194797189\"],\"condition\":[{\"id\":\"4622194797189\",\"name\":\"测试\",\"type\":\"one\",\"options\":[\"选项\"],\"values\":[]}]}],\"connection\":\"AND\",\"pid\":\"25809947577\",\"id\":\"42702947577\",\"type\":\"TJ\",\"name\":\"条件1\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}},{\"groups\":[{\"connection\":\"OR\",\"cids\":[],\"condition\":[]}],\"connection\":\"AND\",\"pid\":\"25809947577\",\"id\":\"80511947577\",\"type\":\"TJ\",\"name\":\"条件2\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}],\"id\":\"25809947577\",\"pid\":\"10000\",\"type\":\"CONDITION\",\"node\":{\"type\":\"EMPTY\",\"id\":\"66188947577\",\"pid\":\"25809947577\"},\"connection\":\"OR\"}}', 'el-icon-s-custom', 'rgba(174, 131, 93, 1)', NULL, '[]', '[]', '[]', b'0', '', '2021-08-31 15:28:08', '2021-09-02 19:33:37');
INSERT INTO `process_templates` VALUES ('97807314', '请假', '[{\"text\":\"请假\",\"name\":\"jInput\",\"icon\":\"el-icon-edit-outline\",\"valid\":false,\"props\":{\"type\":\"textarea\"},\"id\":\"2438697774632\"},{\"text\":\"日期\",\"name\":\"jDateTime\",\"icon\":\"el-icon-date\",\"valid\":true,\"props\":{\"type\":\"dateTime\"},\"id\":\"3838497769819\"},{\"text\":\"说明文字\",\"name\":\"explain\",\"icon\":\"el-icon-warning-outline\",\"valid\":false,\"props\":{\"remark\":\"请输入说明内容\"},\"id\":\"2856397792289\"},{\"text\":\"上传附件\",\"name\":\"jFile\",\"icon\":\"el-icon-upload\",\"valid\":false,\"props\":{\"type\":\"file\"},\"id\":\"6538297796301\"}]', '{\"type\":\"ROOT\",\"name\":\"发起人\",\"id\":\"10000\",\"props\":{\"type\":\"ASSIGN_USER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}},\"node\":{\"id\":\"54291979589\",\"pid\":\"10000\",\"name\":\"审批人\",\"type\":\"SP\",\"props\":{\"type\":\"LEADER\",\"mode\":\"AND\",\"timeLimit\":{\"type\":\"HOUR\",\"limit\":0,\"event\":{\"type\":\"PASS\",\"loop\":false,\"loopTime\":0}},\"sign\":false,\"userEmpty\":\"TO_PASS\",\"leaderLevel\":1,\"endCondition\":\"TOP\",\"targetObj\":{\"multiple\":false,\"roles\":[],\"objs\":[]}}}}', 'el-icon-s-promotion', 'rgba(255, 69, 0, 1)', NULL, '[{\"id\":1486186,\"type\":\"dept\",\"name\":\"xx科技有限公司\"}]', '[{\"id\":6179678,\"type\":\"dept\",\"name\":\"研发部\"},{\"id\":4319868,\"type\":\"dept\",\"name\":\"销售服务部\"},{\"id\":264868,\"type\":\"dept\",\"name\":\"行政人事部\"},{\"id\":231535,\"type\":\"dept\",\"name\":\"生产管理部\"},{\"id\":381496,\"type\":\"user\",\"name\":\"付佳威\"}]', '[]', b'0', '请假申请', '2021-06-24 09:23:27', '2021-11-10 10:35:00');

-- ----------------------------
-- Table structure for template_group
-- ----------------------------
DROP TABLE IF EXISTS `template_group`;
CREATE TABLE `template_group`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `group_id` int(11) NOT NULL,
  `sort_num` int(11) NULL DEFAULT NULL,
  `created` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `template_id`(`template_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 198 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of template_group
-- ----------------------------
INSERT INTO `template_group` VALUES (43, '68268693', 1, 12, NULL);
INSERT INTO `template_group` VALUES (44, '68408993', 1, 10, NULL);
INSERT INTO `template_group` VALUES (46, '73587610', 0, 5, NULL);
INSERT INTO `template_group` VALUES (47, '74143105', 1, 11, NULL);
INSERT INTO `template_group` VALUES (48, '25208172', 1, 3, NULL);
INSERT INTO `template_group` VALUES (60, '91846144', 0, 2, NULL);
INSERT INTO `template_group` VALUES (64, '97807314', 1, 8, NULL);
INSERT INTO `template_group` VALUES (75, '25206085', 1, 9, NULL);
INSERT INTO `template_group` VALUES (76, '08003218', 1, 2, NULL);
INSERT INTO `template_group` VALUES (78, '89431232', 1, 5, NULL);
INSERT INTO `template_group` VALUES (83, '51878242', 0, 4, NULL);
INSERT INTO `template_group` VALUES (97, '89838817', 49, 3, NULL);
INSERT INTO `template_group` VALUES (103, '88335142', 48, 5, NULL);
INSERT INTO `template_group` VALUES (106, '94888127', 48, 3, NULL);
INSERT INTO `template_group` VALUES (107, '91343471', 48, 4, NULL);
INSERT INTO `template_group` VALUES (113, '85232953', 48, 2, NULL);
INSERT INTO `template_group` VALUES (123, '60368016', 48, 6, NULL);
INSERT INTO `template_group` VALUES (124, '34364387', 48, 1, NULL);
INSERT INTO `template_group` VALUES (127, '25817867', 1, 6, NULL);
INSERT INTO `template_group` VALUES (140, '75733229', 49, 2, NULL);
INSERT INTO `template_group` VALUES (154, '60407089', 0, 1, NULL);
INSERT INTO `template_group` VALUES (163, '00966178', 1, 7, NULL);
INSERT INTO `template_group` VALUES (194, '40806849', 1, 4, NULL);
INSERT INTO `template_group` VALUES (195, '13236661', 0, 3, NULL);
INSERT INTO `template_group` VALUES (196, '13456015', 49, 1, NULL);
INSERT INTO `template_group` VALUES (197, '35565463', 1, 1, NULL);

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `pingyin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拼音  全拼及首字母缩写',
  `alisa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  `sex` bit(1) NULL DEFAULT b'1' COMMENT '性别',
  `department_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id，分隔',
  `entry_date` date NULL DEFAULT NULL COMMENT '入职日期',
  `leave_date` date NULL DEFAULT NULL COMMENT '离职日期',
  `admin` int(2) NULL DEFAULT 2 COMMENT '管理级别 0=主管理员 1=子管理员 2=普通员工',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  INDEX `department_ids`(`department_ids`) USING BTREE,
  INDEX `leave_date`(`leave_date`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (381496, '付佳威', 'fujiawei,fjw', NULL, NULL, b'1', '1486186', '2020-09-16', NULL, 0, '2020-09-16 13:33:41', '2020-09-18 10:21:33');
INSERT INTO `users` VALUES (489564, '李秋香', 'liqiuxiang,lqx', NULL, NULL, b'1', '4319868', '2020-09-16', NULL, 2, '2020-09-16 13:35:40', '2020-09-18 10:21:45');
INSERT INTO `users` VALUES (568898, '王翠花', 'wangcuihua,wch', NULL, NULL, b'1', '689698', '2020-09-16', NULL, 2, '2020-09-16 13:35:01', '2020-09-18 10:49:38');
INSERT INTO `users` VALUES (6418616, '张三', 'zhangsan,zs', NULL, NULL, b'1', '6179678', '2020-09-16', NULL, 1, '2020-09-16 13:32:25', '2020-09-18 10:22:04');
INSERT INTO `users` VALUES (61769798, '李四', 'lisi,ls', NULL, NULL, b'1', '6179678', '2019-09-16', NULL, 2, '2020-09-16 13:33:00', '2020-09-18 10:22:12');

SET FOREIGN_KEY_CHECKS = 1;