JAVA简易审批流-01

1、逻辑模型

2、建表脚本

1.  
   /*Table structure for table `pro_approval_flow_instance_t` */
2.  
    
3.  
   DROP TABLE IF EXISTS `pro_approval_flow_instance_t`;
4.  
    
5.  
   CREATE TABLE `pro_approval_flow_instance_t` (
6.  
   `flow_instance_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流程实例ID',
7.  
   `flow_id` bigint(20) DEFAULT NULL COMMENT '流程ID',
8.  
   `flow_node_version` varchar(50) DEFAULT NULL COMMENT '流程节点版本号',
9.  
   `biz_type` varchar(50) DEFAULT NULL COMMENT '业务类型',
10.  
    `biz_data_id` varchar(50) DEFAULT NULL COMMENT '业务数据ID',
11.  
    `biz_data` varchar(5000) DEFAULT NULL COMMENT '业务数据',
12.  
    `owner` varchar(50) DEFAULT NULL COMMENT '责任人',
13.  
    `owner_name` varchar(50) DEFAULT NULL COMMENT '责任人名称',
14.  
    `current_node` bigint(20) DEFAULT NULL COMMENT '当前节点',
15.  
    `resubmit_node` bigint(20) DEFAULT NULL COMMENT '重新提交节点',
16.  
    `status` varchar(20) DEFAULT NULL COMMENT '实例状态，RUNNING进行中，FINISHED已完成，ABORT作废，REVOKE撤回，REJECT驳回',
17.  
    `creator` varchar(100) DEFAULT NULL COMMENT '创建人W3账号',
18.  
    `creator_name` varchar(100) DEFAULT NULL COMMENT '创建人名称',
19.  
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
20.  
    `last_updater` varchar(100) DEFAULT NULL COMMENT '最后更新人W3账号',
21.  
    `last_updater_name` varchar(100) DEFAULT NULL COMMENT '最后更新人名称',
22.  
    `last_update_date` datetime DEFAULT NULL COMMENT '最后更新时间',
23.  
    PRIMARY KEY (`flow_instance_id`),
24.  
    KEY `idx_biztype_bizdataid` (`biz_type`,`biz_data_id`)
25.  
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批流流程实例表';
26.  
     
27.  
    /*Table structure for table `pro_approval_flow_log_t` */
28.  
     
29.  
    DROP TABLE IF EXISTS `pro_approval_flow_log_t`;
30.  
     
31.  
    CREATE TABLE `pro_approval_flow_log_t` (
32.  
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
33.  
    `flow_instance_id` bigint(20) DEFAULT NULL COMMENT '流程实例ID',
34.  
    `flow_node_id` bigint(20) DEFAULT NULL COMMENT '流程节点ID',
35.  
    `op_type` varchar(50) DEFAULT NULL COMMENT '操作类型，SUBMIT提交,AGREE同意,REJECT驳回,RESUBMIT重新提交,REVOKE撤回,REFERRAL转审,ABORT作废,FINISHED已完成',
36.  
    `remark` varchar(5000) DEFAULT NULL COMMENT '备注',
37.  
    `creator` varchar(100) DEFAULT NULL COMMENT '创建人W3账号',
38.  
    `creator_name` varchar(100) DEFAULT NULL COMMENT '创建人名称',
39.  
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
40.  
    `last_updater` varchar(100) DEFAULT NULL COMMENT '最后更新人W3账号',
41.  
    `last_updater_name` varchar(100) DEFAULT NULL COMMENT '最后更新人名称',
42.  
    `last_update_date` datetime DEFAULT NULL COMMENT '最后更新时间',
43.  
    PRIMARY KEY (`id`),
44.  
    KEY `idx_flowinstanceid` (`flow_instance_id`)
45.  
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批日志表';
46.  
     
47.  
    /*Table structure for table `pro_approval_flow_node_handler_t` */
48.  
     
49.  
    DROP TABLE IF EXISTS `pro_approval_flow_node_handler_t`;
50.  
     
51.  
    CREATE TABLE `pro_approval_flow_node_handler_t` (
52.  
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
53.  
    `flow_instance_id` bigint(20) DEFAULT NULL COMMENT '流程实例ID',
54.  
    `flow_node_id` bigint(20) DEFAULT NULL COMMENT '流程节点ID',
55.  
    `handler` varchar(50) DEFAULT NULL COMMENT '处理人',
56.  
    `handler_name` varchar(50) DEFAULT NULL COMMENT '处理人名称',
57.  
    `handler_type` varchar(20) DEFAULT NULL COMMENT '处理人类型，approver审批人，ccperson抄送人',
58.  
    `creator` varchar(100) DEFAULT NULL COMMENT '创建人W3账号',
59.  
    `creator_name` varchar(100) DEFAULT NULL COMMENT '创建人名称',
60.  
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
61.  
    `last_updater` varchar(100) DEFAULT NULL COMMENT '最后更新人W3账号',
62.  
    `last_updater_name` varchar(100) DEFAULT NULL COMMENT '最后更新人名称',
63.  
    `last_update_date` datetime DEFAULT NULL COMMENT '最后更新时间',
64.  
    PRIMARY KEY (`id`),
65.  
    KEY `idx_flowinstanceid_flownodeid` (`flow_instance_id`,`flow_node_id`)
66.  
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批节点处理人表';
67.  
     
68.  
    /*Table structure for table `pro_approval_flow_node_t` */
69.  
     
70.  
    DROP TABLE IF EXISTS `pro_approval_flow_node_t`;
71.  
     
72.  
    CREATE TABLE `pro_approval_flow_node_t` (
73.  
    `flow_node_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流程节点ID',
74.  
    `flow_node_code` varchar(50) DEFAULT NULL COMMENT '节点编码',
75.  
    `flow_node_name` varchar(50) DEFAULT NULL COMMENT '节点名称',
76.  
    `flow_id` bigint(20) DEFAULT NULL COMMENT '流程ID',
77.  
    `node_type` varchar(50) DEFAULT 'APPROVAL' COMMENT '节点类型,APPROVAL:审批节点;CONDITION:条件节点;SYSTEM:系统节点',
78.  
    `approver_rule` varchar(5000) DEFAULT NULL COMMENT '审批人规则',
79.  
    `cc_user_rule` varchar(5000) DEFAULT NULL COMMENT '抄送人规则',
80.  
    `reject_node_rule` varchar(500) DEFAULT NULL COMMENT '驳回节点规则',
81.  
    `pass_ratio` decimal(4,3) DEFAULT NULL COMMENT '通过比例',
82.  
    `reject_ratio` decimal(4,3) DEFAULT NULL COMMENT '驳回比例',
83.  
    `condition_expression` varchar(500) DEFAULT NULL COMMENT '条件表达式',
84.  
    `system_activity` varchar(50) DEFAULT NULL COMMENT '系统活动',
85.  
    `resubmit_to_self` varchar(1) DEFAULT NULL COMMENT '重新提交后回到当前节点',
86.  
    `active_todo_rule` varchar(500) DEFAULT NULL COMMENT '激活待办规则',
87.  
    `reject_todo_rule` varchar(500) DEFAULT NULL COMMENT '驳回待办规则',
88.  
    `biz_status` varchar(50) DEFAULT NULL COMMENT '业务数据状态',
89.  
    `last_flag` varchar(1) DEFAULT 'N' COMMENT '最后节点标记',
90.  
    `sort_num` tinyint(4) DEFAULT NULL COMMENT '排序号',
91.  
    `flow_node_version` varchar(50) DEFAULT NULL COMMENT '流程节点版本号',
92.  
    `creator` varchar(100) DEFAULT 'admin' COMMENT '创建人W3账号',
93.  
    `creator_name` varchar(100) DEFAULT 'admin' COMMENT '创建人名称',
94.  
    `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
95.  
    `last_updater` varchar(100) DEFAULT 'admin' COMMENT '最后更新人W3账号',
96.  
    `last_updater_name` varchar(100) DEFAULT 'admin' COMMENT '最后更新人名称',
97.  
    `last_update_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后更新时间',
98.  
    PRIMARY KEY (`flow_node_id`),
99.  
    KEY `idx_flowid_flownodeversion_ordernum` (`flow_id`,`flow_node_version`,`sort_num`)
100.  
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批流节点表';
101.  
      
102.  
     /*Table structure for table `pro_approval_flow_t` */
103.  
      
104.  
     DROP TABLE IF EXISTS `pro_approval_flow_t`;
105.  
      
106.  
     CREATE TABLE `pro_approval_flow_t` (
107.  
     `flow_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流程ID',
108.  
     `flow_code` varchar(50) DEFAULT NULL COMMENT '流程编码',
109.  
     `flow_name` varchar(50) DEFAULT NULL COMMENT '流程名称',
110.  
     `biz_finished_status` varchar(50) DEFAULT NULL COMMENT '业务数据已完成状态',
111.  
     `todo_done_rule` varchar(4000) DEFAULT NULL COMMENT '已完成待办规则',
112.  
     `public_flag` varchar(1) DEFAULT 'Y' COMMENT '发布状态，Y发布，N草稿',
113.  
     `creator` varchar(100) DEFAULT 'admin' COMMENT '创建人W3账号',
114.  
     `creator_name` varchar(100) DEFAULT 'admin' COMMENT '创建人名称',
115.  
     `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
116.  
     `last_updater` varchar(100) DEFAULT 'admin' COMMENT '最后更新人W3账号',
117.  
     `last_updater_name` varchar(100) DEFAULT 'admin' COMMENT '最后更新人名称',
118.  
     `last_update_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后更新时间',
119.  
     PRIMARY KEY (`flow_id`)
120.  
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批流流程表';
121.  
      
122.  
     /*Table structure for table `pro_approval_flow_todo_t` */
123.  
      
124.  
     DROP TABLE IF EXISTS `pro_approval_flow_todo_t`;
125.  
      
126.  
     CREATE TABLE `pro_approval_flow_todo_t` (
127.  
     `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
128.  
     `app_task_id` varchar(100) DEFAULT NULL COMMENT 'W3待办ID',
129.  
     `flow_instance_id` bigint(20) DEFAULT NULL COMMENT '流程实例ID',
130.  
     `flow_node_id` bigint(20) DEFAULT NULL COMMENT '流程节点ID',
131.  
     `handler` varchar(50) DEFAULT NULL COMMENT '处理人',
132.  
     `handler_name` varchar(50) DEFAULT NULL COMMENT '处理人名称',
133.  
     `result` varchar(20) DEFAULT NULL COMMENT '待办结果，UNHANDLED未处理，AGREE同意，REJECT驳回，REFERRAL转审，REVOKE撤回，ABORT作废',
134.  
     `comment` varchar(5000) DEFAULT NULL COMMENT '审批意见',
135.  
     `forward_user` varchar(50) DEFAULT NULL COMMENT '转审人W3账号，当待办结果为转审时必填',
136.  
     `forward_user_name` varchar(50) DEFAULT NULL COMMENT '转审人名称，当待办结果为转审时必填',
137.  
     `active_flag` varchar(1) DEFAULT 'Y' COMMENT '激活标识，Y激活，N未激活',
138.  
     `creator` varchar(100) DEFAULT NULL COMMENT '创建人W3账号',
139.  
     `creator_name` varchar(100) DEFAULT NULL COMMENT '创建人名称',
140.  
     `create_date` datetime DEFAULT NULL COMMENT '创建时间',
141.  
     `last_updater` varchar(100) DEFAULT NULL COMMENT '最后更新人W3账号',
142.  
     `last_updater_name` varchar(100) DEFAULT NULL COMMENT '最后更新人名称',
143.  
     `last_update_date` datetime DEFAULT NULL COMMENT '最后更新时间',
144.  
     PRIMARY KEY (`id`),
145.  
     KEY `idx_flowinstanceid_flownodeid_handler` (`flow_instance_id`,`flow_node_id`,`handler`)
146.  
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批流待办表';

3、示例数据

1.  
   insert into `pro_approval_flow_t`(`flow_id`,`flow_code`,`flow_name`,`biz_finished_status`,`todo_done_rule`,`public_flag`,`creator`,`creator_name`,`create_date`,`last_updater`,`last_updater_name`,`last_update_date`) values
2.  
   (1,'ADD_SITE','新增Site审批流','EFFECTIVE','static:{\"title\":\"“${supplierName}供应商${siteCode}已集成”。（${supplierName} supplier${siteCode} is already Integrated）\",\"desc\":\"“${supplierName}供应商${siteCode}已集成”。（${supplierName} supplier${siteCode} is already Integrated）\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','Y','admin','admin','2023-03-01 14:26:23','admin','admin','2023-03-01 14:26:28');
3.  
    
4.  
   insert into `pro_approval_flow_node_t`(`flow_node_id`,`flow_node_code`,`flow_node_name`,`flow_id`,`node_type`,`approver_rule`,`cc_user_rule`,`reject_node_rule`,`pass_ratio`,`reject_ratio`,`condition_expression`,`system_activity`,`resubmit_to_self`,`active_todo_rule`,`reject_todo_rule`,`biz_status`,`last_flag`,`sort_num`,`flow_node_version`,`creator`,`creator_name`,`create_date`,`last_updater`,`last_updater_name`,`last_update_date`) values
5.  
   (1,'FILL_SITE_INFO','填写Site基本信息',1,'APPROVAL','var:owner',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DRAFT','N',1,'20230310001','admin','admin','2023-03-10 13:32:46','admin','admin','2023-03-10 13:32:55'),
6.  
   (2,'SITECREATOR_SUPOWNER_NOT_EQUAL','Site创建人与供应商Owner不为同一个人',1,'CONDITION',NULL,NULL,NULL,NULL,NULL,'#map[\'isSiteCreatorSupOwnerNotEqual\']?3:4',NULL,NULL,NULL,NULL,NULL,'N',2,'20230310001','admin','admin','2023-03-10 13:32:51','admin','admin','2023-03-10 13:32:57'),
7.  
   (3,'SUPPLIER_OWNER_APPROVAL','供应商Owner审核',1,'APPROVAL','var:ownerApprover',NULL,'static:1',NULL,NULL,NULL,NULL,NULL,'static:{\"title\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"desc\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','static:{\"title\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"desc\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','DRAFT','N',3,'20230310001','admin','admin','2023-03-10 13:32:51','admin','admin','2023-03-10 13:32:57'),
8.  
   (4,'REF_EXISTING_BANK_LETTER','是否引用现有银行信息',1,'CONDITION',NULL,NULL,NULL,NULL,NULL,'#map[\'isRefExistingBankLetter\']?8:5',NULL,NULL,NULL,NULL,NULL,'N',4,'20230310001','admin','admin','2023-03-10 13:32:51','admin','admin','2023-03-10 13:32:57'),
9.  
   (5,'IS_SUP_MAIN','是否供应商维护',1,'CONDITION',NULL,NULL,NULL,NULL,NULL,'#map[\'isSupMain\']?6:7',NULL,NULL,NULL,NULL,NULL,'N',5,'20230310001','admin','admin','2023-03-10 13:32:51','admin','admin','2023-03-10 13:32:57'),
10.  
    (6,'SUPPLIER_FILL','供应商填写',1,'APPROVAL','var:supApprover',NULL,'static:1',NULL,NULL,NULL,NULL,NULL,'static:{\"title\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"desc\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"url\":\"${isupplierTodoHost}/#/group/procurement/bank-letter-information?id=${siteMainId}\"}',NULL,'DRAFT','N',6,'20230310001','admin','admin','2023-03-10 13:32:51','admin','admin','2023-03-10 13:32:57'),
11.  
    (7,'AP_APPROVAL','AP审核',1,'APPROVAL','var:apApprover',NULL,'spel:#map[\'isSupMain\']?6:1',NULL,NULL,NULL,NULL,'Y','static:{\"title\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"desc\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','spel:\'{\"title\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"desc\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"url\":\"\' (#map[\'isSupMain\']?\'${isupplierTodoHost}/#/group/procurement/bank-letter-information?id=${siteMainId}\':\'${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\') \'\"}\'','DRAFT','N',7,'20230310001','admin','admin','2023-03-10 13:32:51','admin','admin','2023-03-13 10:41:44'),
12.  
    (8,'COMPLIANCE_APPROVAL','金融合规审核',1,'SYSTEM',NULL,NULL,'static:1',NULL,NULL,NULL,'SYSTEM_ACTIVITY_BEAN:COMPLIANCE',NULL,NULL,'static:{\"title\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"desc\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','DRAFT','N',8,'20230310001','admin','admin','2023-03-10 13:32:51','admin','admin','2023-03-10 13:32:57'),
13.  
    (9,'PROCUREMENT_REAPPROVAL','采购复核',1,'APPROVAL','var:proApprover',NULL,'static:1',NULL,NULL,NULL,NULL,NULL,'static:{\"title\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"desc\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','static:{\"title\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"desc\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','DRAFT','N',9,'20230310001','admin','admin','2023-03-10 13:32:51','admin','admin','2023-03-10 13:32:57'),
14.  
    (10,'CEG_LEADER_APPROVAL','CEG Leader 审批',1,'APPROVAL','var:cegLeaderApprover',NULL,'static:1',NULL,NULL,NULL,NULL,NULL,'static:{\"title\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"desc\":\"“请审核${supplierName}供应商${siteCode}新增”。（Please review ${supplierName} supplier ${siteCode} Add）。\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','static:{\"title\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"desc\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','DRAFT','N',10,'20230310001','admin','admin','2023-03-10 13:32:51','admin','admin','2023-03-10 13:32:57'),
15.  
    (11,'EBS_INTE','EBS集成',1,'SYSTEM',NULL,NULL,'static:1',NULL,NULL,NULL,'SYSTEM_ACTIVITY_BEAN:ADD_SITE_CALL_EBS',NULL,NULL,'static:{\"title\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"desc\":\"“新增${supplierName}供应商${siteCode}被驳回”。（Add ${supplierName} supplier ${siteCode} has been rejected）\",\"url\":\"${todoHost}/#/group/procurement/site-approve?id=${siteMainId}\"}','DRAFT','Y',11,'20230310001','admin','admin','2023-06-01 12:04:54','admin','admin','2023-06-01 12:04:59');

这篇好文章是转载于：学新通技术网