1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
| insert into sys_menu values('11616', '工作流' , '0', '6', 'workflow', '', '', '1', '0', 'M', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11617', '模型管理', '11616', '2', 'model', 'workflow/model/index', '', '1', '1', 'C', '0', '0', 'workflow:model:list', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11618', '我的任务', '0', '7', 'task', '', '', '1', '0', 'M', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11619', '我的待办', '11618', '2', 'taskWaiting', 'workflow/task/taskWaiting', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11632', '我的已办', '11618', '3', 'taskFinish', 'workflow/task/taskFinish', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11633', '我的抄送', '11618', '4', 'taskCopyList', 'workflow/task/taskCopyList', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11620', '流程定义', '11616', '3', 'processDefinition', 'workflow/processDefinition/index', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11621', '流程实例', '11630', '1', 'processInstance', 'workflow/processInstance/index', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11622', '流程分类', '11616', '1', 'category', 'workflow/category/index', '', '1', '0', 'C', '0', '0', 'workflow:category:list', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11629', '我发起的', '11618', '1', 'myDocument', 'workflow/task/myDocument', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11630', '流程监控', '11616', '4', 'monitor', '', '', '1', '0', 'M', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
| insert into sys_menu values('11631', '待办任务', '11630', '2', 'allTaskWaiting', 'workflow/task/allTaskWaiting', '', '1', '1', 'C', '0', '0', '', 'tree-table', 103, 1, sysdate(), NULL, NULL, '');
|
|
| -- 流程分类管理相关按钮
| insert into sys_menu values ('11623', '流程分类查询', '11622', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:query', '#', 103, 1, sysdate(), null, null, '');
| insert into sys_menu values ('11624', '流程分类新增', '11622', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:add', '#', 103, 1, sysdate(), null, null, '');
| insert into sys_menu values ('11625', '流程分类修改', '11622', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:edit', '#', 103, 1, sysdate(), null, null, '');
| insert into sys_menu values ('11626', '流程分类删除', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, sysdate(), null, null, '');
| insert into sys_menu values ('11627', '流程分类导出', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, sysdate(), null, null, '');
| -- 请假单信息
| DROP TABLE if EXISTS test_leave;
| create table test_leave
| (
| id bigint not null comment '主键',
| leave_type varchar(255) not null comment '请假类型',
| start_date datetime not null comment '开始时间',
| end_date datetime not null comment '结束时间',
| leave_days int(10) not null comment '请假天数',
| remark varchar(255) null comment '请假原因',
| create_dept bigint null comment '创建部门',
| create_by bigint null comment '创建者',
| create_time datetime null comment '创建时间',
| update_by bigint null comment '更新者',
| update_time datetime null comment '更新时间',
| tenant_id varchar(20) null comment '租户编号',
| PRIMARY KEY (id) USING BTREE
| ) ENGINE = InnoDB COMMENT = '请假申请表';
|
| -- 流程分类信息表
| DROP TABLE if EXISTS wf_category;
| create table wf_category
| (
| id bigint not null comment '主键'
| primary key,
| category_name varchar(255) null comment '分类名称',
| category_code varchar(255) null comment '分类编码',
| parent_id bigint null comment '父级id',
| sort_num int(19) null comment '排序',
| tenant_id varchar(20) null comment '租户编号',
| create_dept bigint null comment '创建部门',
| create_by bigint null comment '创建者',
| create_time datetime null comment '创建时间',
| update_by bigint null comment '更新者',
| update_time datetime null comment '更新时间',
| constraint uni_category_code
| unique (category_code)
| ) engine=innodb comment= '流程分类';
| INSERT INTO wf_category values (1, 'OA', 'OA', 0, 0, '000000', 103, 1, sysdate(), 1, sysdate());
|
| DROP TABLE if EXISTS wf_task_back_node;
| create table wf_task_back_node
| (
| id bigint not null
| primary key,
| node_id varchar(255) not null comment '节点id',
| node_name varchar(255) not null comment '节点名称',
| order_no int not null comment '排序',
| instance_id varchar(255) null comment '流程实例id',
| task_type varchar(255) not null comment '节点类型',
| assignee varchar(2000) not null comment '审批人',
| tenant_id varchar(20) null comment '租户编号',
| create_dept bigint null comment '创建部门',
| create_by bigint null comment '创建者',
| create_time datetime null comment '创建时间',
| update_by bigint null comment '更新者',
| update_time datetime null comment '更新时间'
| )
| comment '节点审批记录';
|
| DROP TABLE if EXISTS wf_definition_config;
| create table wf_definition_config
| (
| id bigint not null comment '主键'
| primary key,
| form_id bigint not null comment '表单ID',
| definition_id varchar(255) not null comment '流程定义ID',
| process_key varchar(255) not null comment '流程KEY',
| create_dept bigint null comment '创建部门',
| create_by bigint null comment '创建者',
| create_time datetime null comment '创建时间',
| update_by bigint null comment '更新者',
| update_time datetime null comment '更新时间',
| remark varchar(500) default '' null comment '备注',
| tenant_id varchar(20) null comment '租户编号',
| constraint uni_definition_id
| unique (definition_id)
| )
| comment '流程定义配置';
|
| create table wf_form_manage
| (
| id bigint not null comment '主键'
| primary key,
| form_name varchar(255) not null comment '表单名称',
| form_type varchar(255) not null comment '表单类型',
| router varchar(255) not null comment '路由地址/表单ID',
| remark varchar(500) null comment '备注',
| tenant_id varchar(20) null comment '租户编号',
| create_dept bigint null comment '创建部门',
| create_by bigint null comment '创建者',
| create_time datetime null comment '创建时间',
| update_by bigint null comment '更新者',
| update_time datetime null comment '更新时间'
| )
| comment '表单管理';
|
| insert into wf_form_manage(id, form_name, form_type, router, remark, tenant_id, create_dept, create_by, create_time, update_by, update_time) VALUES (1, '请假申请', 'static', '/demo/leaveEdit/index', NULL, '000000', 103, 1, sysdate(), 1, sysdate());
|
| create table wf_node_config
| (
| id bigint not null comment '主键'
| primary key,
| form_id bigint null comment '表单id',
| form_type varchar(255) null comment '表单类型',
| node_name varchar(255) not null comment '节点名称',
| node_id varchar(255) not null comment '节点id',
| definition_id varchar(255) not null comment '流程定义id',
| create_dept bigint null comment '创建部门',
| create_by bigint null comment '创建者',
| create_time datetime null comment '创建时间',
| update_by bigint null comment '更新者',
| update_time datetime null comment '更新时间',
| tenant_id varchar(20) null comment '租户编号'
| )
| comment '节点配置';
|
|
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11638, '请假申请', 5, 1, 'leave', 'workflow/leave/index', 1, 0, 'C', '0', '0', 'demo:leave:list', '#', 103, 1, sysdate(), NULL, NULL, '请假申请菜单');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11639, '请假申请查询', 11638, 1, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:query', '#', 103, 1, sysdate(), NULL, NULL, '');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11640, '请假申请新增', 11638, 2, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:add', '#', 103, 1, sysdate(), NULL, NULL, '');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11641, '请假申请修改', 11638, 3, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:edit', '#', 103, 1, sysdate(), NULL, NULL, '');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11642, '请假申请删除', 11638, 4, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:remove', '#', 103, 1, sysdate(), NULL, NULL, '');
| INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11643, '请假申请导出', 11638, 5, '#', '', 1, 0, 'F', '0', '0', 'demo:leave:export', '#', 103, 1, sysdate(), NULL, NULL, '');
|
|
