1、逻辑模型
文章来源:https://www.toymoban.com/news/detail-689823.html
文章来源地址https://www.toymoban.com/news/detail-689823.html
2、建表脚本
/*Table structure for table `pro_approval_flow_instance_t` */
DROP TABLE IF EXISTS `pro_approval_flow_instance_t`;
CREATE TABLE `pro_approval_flow_instance_t` (
`flow_instance_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流程实例ID',
`flow_id` bigint(20) DEFAULT NULL COMMENT '流程ID',
`flow_node_version` varchar(50) DEFAULT NULL COMMENT '流程节点版本号',
`biz_type` varchar(50) DEFAULT NULL COMMENT '业务类型',
`biz_data_id` varchar(50) DEFAULT NULL COMMENT '业务数据ID',
`biz_data` varchar(5000) DEFAULT NULL COMMENT '业务数据',
`owner` varchar(50) DEFAULT NULL COMMENT '责任人',
`owner_name` varchar(50) DEFAULT NULL COMMENT '责任人名称',
`current_node` bigint(20) DEFAULT NULL COMMENT '当前节点',
`resubmit_node` bigint(20) DEFAULT NULL COMMENT '重新提交节点',
`status` varchar(20) DEFAULT NULL COMMENT '实例状态,RUNNING进行中,FINISHED已完成,ABORT作废,REVOKE撤回,REJECT驳回',
`creator` varchar(100) DEFAULT NULL COMMENT '创建人W3账号',
`creator_name` varchar(100) DEFAULT NULL COMMENT '创建人名称',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`last_updater` varchar(100) DEFAULT NULL COMMENT '最后更新人W3账号',
`last_updater_name` varchar(100) DEFAULT NULL COMMENT '最后更新人名称',
`last_update_date` datetime DEFAULT NULL COMMENT '最后更新时间',
PRIMARY KEY (`flow_instance_id`),
KEY `idx_biztype_bizdataid` (`biz_type`,`biz_data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批流流程实例表';
/*Table structure for table `pro_approval_flow_log_t` */
DROP TABLE IF EXISTS `pro_approval_flow_log_t`;
CREATE TABLE `pro_approval_flow_log_t` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`flow_instance_id` bigint(20) DEFAULT NULL COMMENT '流程实例ID',
`flow_node_id` bigint(20) DEFAULT NULL COMMENT '流程节点ID',
`op_type` varchar(50) DEFAULT NULL COMMENT '操作类型,SUBMIT提交,AGREE同意,REJECT驳回,RESUBMIT重新提交,REVOKE撤回,REFERRAL转审,ABORT作废,FINISHED已完成',
`remark` varchar(5000) DEFAULT NULL COMMENT '备注',
`creator` varchar(100) DEFAULT NULL COMMENT '创建人W3账号',
`creator_name` varchar(100) DEFAULT NULL COMMENT '创建人名称',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`last_updater` varchar(100) DEFAULT NULL COMMENT '最后更新人W3账号',
`last_updater_name` varchar(100) DEFAULT NULL COMMENT '最后更新人名称',
`last_update_date` datetime DEFAULT NULL COMMENT '最后更新时间',
PRIMARY KEY (`id`),
KEY `idx_flowinstanceid` (`flow_instance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批日志表';
/*Table structure for table `pro_approval_flow_node_handler_t` */
DROP TABLE IF EXISTS `pro_approval_flow_node_handler_t`;
CREATE TABLE `pro_approval_flow_node_handler_t` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`flow_instance_id` bigint(20) DEFAULT NULL COMMENT '流程实例ID',
`flow_node_id` bigint(20) DEFAULT NULL COMMENT '流程节点ID',
`handler` varchar(50) DEFAULT NULL COMMENT '处理人',
`handler_name` varchar(50) DEFAULT NULL COMMENT '处理人名称',
`handler_type` varchar(20) DEFAULT NULL COMMENT '处理人类型,approver审批人,ccperson抄送人',
`creator` varchar(100) DEFAULT NULL COMMENT '创建人W3账号',
`creator_name` varchar(100) DEFAULT NULL COMMENT '创建人名称',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`last_updater` varchar(100) DEFAULT NULL COMMENT '最后更新人W3账号',
`last_updater_name` varchar(100) DEFAULT NULL COMMENT '最后更新人名称',
`last_update_date` datetime DEFAULT NULL COMMENT '最后更新时间',
PRIMARY KEY (`id`),
KEY `idx_flowinstanceid_flownodeid` (`flow_instance_id`,`flow_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批节点处理人表';
/*Table structure for table `pro_approval_flow_node_t` */
DROP TABLE IF EXISTS `pro_approval_flow_node_t`;
CREATE TABLE `pro_approval_flow_node_t` (
`flow_node_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流程节点ID',
`flow_node_code` varchar(50) DEFAULT NULL COMMENT '节点编码',
`flow_node_name` varchar(50) DEFAULT NULL COMMENT '节点名称',
`flow_id` bigint(20) DEFAULT NULL COMMENT '流程ID',
`node_type` varchar(50) DEFAULT 'APPROVAL' COMMENT '节点类型,APPROVAL:审批节点;CONDITION:条件节点;SYSTEM:系统节点',
`approver_rule` varchar(5000) DEFAULT NULL COMMENT '审批人规则',
`cc_user_rule` varchar(5000) DEFAULT NULL COMMENT '抄送人规则',
`reject_node_rule` varchar(500) DEFAULT NULL COMMENT '驳回节点规则',
`pass_ratio` decimal(4,3) DEFAULT NULL COMMENT '通过比例',
`reject_ratio` decimal(4,3) DEFAULT NULL COMMENT '驳回比例',
`condition_expression` varchar(500) DEFAULT NULL COMMENT '条件表达式',
`system_activity` varchar(50) DEFAULT NULL COMMENT '系统活动',
`resubmit_to_self` varchar(1) DEFAULT NULL COMMENT '重新提交后回到当前节点',
`active_todo_rule` varchar(500) DEFAULT NULL COMMENT '激活待办规则',
`reject_todo_rule` varchar(500) DEFAULT NULL COMMENT '驳回待办规则',
`biz_status` varchar(50) DEFAULT NULL COMMENT '业务数据状态',
`last_flag` varchar(1) DEFAULT 'N' COMMENT '最后节点标记',
`sort_num` tinyint(4) DEFAULT NULL COMMENT '排序号',
`flow_node_version` varchar(50) DEFAULT NULL COMMENT '流程节点版本号',
`creator` varchar(100) DEFAULT 'admin' COMMENT '创建人W3账号',
`creator_name` varchar(100) DEFAULT 'admin' COMMENT '创建人名称',
`create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`last_updater` varchar(100) DEFAULT 'admin' COMMENT '最后更新人W3账号',
`last_updater_name` varchar(100) DEFAULT 'admin' COMMENT '最后更新人名称',
`last_update_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后更新时间',
PRIMARY KEY (`flow_node_id`),
KEY `idx_flowid_flownodeversion_ordernum` (`flow_id`,`flow_node_version`,`sort_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批流节点表';
/*Table structure for table `pro_approval_flow_t` */
DROP TABLE IF EXISTS `pro_approval_flow_t`;
CREATE TABLE `pro_approval_flow_t` (
`flow_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流程ID',
`flow_code` varchar(50) DEFAULT NULL COMMENT '流程编码',
`flow_name` varchar(50) DEFAULT NULL COMMENT '流程名称',
`biz_finished_status` varchar(50) DEFAULT NULL COMMENT '业务数据已完成状态',
`todo_done_rule` varchar(4000) DEFAULT NULL COMMENT '已完成待办规则',
`public_flag` varchar(1) DEFAULT 'Y' COMMENT '发布状态,Y发布,N草稿',
`creator` varchar(100) DEFAULT 'admin' COMMENT '创建人W3账号',
`creator_name` varchar(100) DEFAULT 'admin' COMMENT '创建人名称',
`create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`last_updater` varchar(100) DEFAULT 'admin' COMMENT '最后更新人W3账号',
`last_updater_name` varchar(100) DEFAULT 'admin' COMMENT '最后更新人名称',
`last_update_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后更新时间',
PRIMARY KEY (`flow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批流流程表';
/*Table structure for table `pro_approval_flow_todo_t` */
DROP TABLE IF EXISTS `pro_approval_flow_todo_t`;
CREATE TABLE `pro_approval_flow_todo_t` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`app_task_id` varchar(100) DEFAULT NULL COMMENT 'W3待办ID',
`flow_instance_id` bigint(20) DEFAULT NULL COMMENT '流程实例ID',
`flow_node_id` bigint(20) DEFAULT NULL COMMENT '流程节点ID',
`handler` varchar(50) DEFAULT NULL COMMENT '处理人',
`handler_name` varchar(50) DEFAULT NULL COMMENT '处理人名称',
`result` varchar(20) DEFAULT NULL COMMENT '待办结果,UNHANDLED未处理,AGREE同意,REJECT驳回,REFERRAL转审,REVOKE撤回,ABORT作废',
`comment` varchar(5000) DEFAULT NULL COMMENT '审批意见',
`forward_user` varchar(50) DEFAULT NULL COMMENT '转审人W3账号,当待办结果为转审时必填',
`forward_user_name` varchar(50) DEFAULT NULL COMMENT '转审人名称,当待办结果为转审时必填',
`active_flag` varchar(1) DEFAULT 'Y' COMMENT '激活标识,Y激活,N未激活',
`creator` varchar(100) DEFAULT NULL COMMENT '创建人W3账号',
`creator_name` varchar(100) DEFAULT NULL COMMENT '创建人名称',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`last_updater` varchar(100) DEFAULT NULL COMMENT '最后更新人W3账号',
`last_updater_name` varchar(100) DEFAULT NULL COMMENT '最后更新人名称',
`last_update_date` datetime DEFAULT NULL COMMENT '最后更新时间',
PRIMARY KEY (`id`),
KEY `idx_flowinstanceid_flownodeid_handler` (`flow_instance_id`,`flow_node_id`,`handler`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='审批流待办表';
3、示例数据
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
(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');
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
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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'),
(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');
到了这里,关于JAVA简易审批流-01的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!