JAVA简易审批流-01
1、逻辑模型
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');
这篇好文章是转载于:学新通技术网
- 版权申明: 本站部分内容来自互联网,仅供学习及演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,请提供相关证据及您的身份证明,我们将在收到邮件后48小时内删除。
- 本站站名: 学新通技术网
- 本文地址: /news/detail/tanhccfige
系列文章
更多
同类精品
更多
-
2023 年度 A 类学科竞赛项目清单
那个人有梦想 09-16 -
从《银行业金融机构数据治理指引》监管要求看商业银行数据能力建设
51CTO 09-21 -
爱思唯尔的ESWA——模板、投稿、返修、接收的
老板来碗小面加蛋~ 09-16 -
国航天科技集团公司的各个研究院
知识在于积累 09-17 -
全球WIFI功率信号最强的国家清单,无线WIFI调优
Cisco_VIP 09-17 -
AI绘画Midjourney的咒语关键词汇
毕设小程序软件程序猿 09-17 -
ChatGPT注册流程攻略,含验证码接收
PHP中文网 05-29 -
创作者身份认证申请规则和审核标准
CSDN官方博客 09-16 -
OBS做绿幕直播滤镜实现去掉绿色背景
视频砖家 09-16 -
的10 个顶尖的国内外设计网站
四喜圆子- 09-16