EOS实际开发流程(自己总结).doc

EOS流程开发实例一、任务要求 徐州管道操作系统申请流程管理，首先由申请人填写申请表，然后将申请表提交给信息部门负责人审批，最后由信息部门负责人转派系统管理员为此申请人分配操作系统登录的账号与密码。表1为操作系统用户申请表。操作系统用户申请表单位/部门申请人申请时间服务器名称IP地址申请账号原因/用途用户名密码系统管理员信息部审批表1二、开发步骤1、数据库表的开发A、新建业务流程表 每个流程都应该具有四张表： IPTWF_*_DUPLICATE、IPTWF_*_LINK、IPTWF_*_TASK、IPTWF_*_MAIN。它们的建表语句如下：create table IPTWF_*_DUPLICATE( DUPLICATE_ID NUMBER(12) not null, MAIN_ID NUMBER(12), PROCESS_INST_ID NUMBER(12), FROM_USER_ID VARCHAR2(32), FROM_USER_NAME VARCHAR2(32), TO_USER_ID VARCHAR2(32), TO_USER_TYPE VARCHAR2(32), TO_USER_NAME VARCHAR2(32), SEND_TIME DATE, ACTIVITY_DEF_ID VARCHAR2(32), ACTIVITY_DEF_NAME VARCHAR2(32), ACCEPT_FLAG NUMBER(1), ACCEPT_TIME DATE, DELETED_FLAG NUMBER(1);comment on column IPTWF_*_DUPLICATE.DUPLICATE_ID is 抄送表ID;comment on column IPTWF_*_DUPLICATE.MAIN_ID is 工单ID;comment on column IPTWF_*_DUPLICATE.PROCESS_INST_ID is 流程实例ID;comment on column IPTWF_*_DUPLICATE.FROM_USER_ID is 发送者ID;comment on column IPTWF_*_DUPLICATE.FROM_USER_NAME is 发送者名称;comment on column IPTWF_*_DUPLICATE.TO_USER_ID is 接收抄送人ID;comment on column IPTWF_*_DUPLICATE.TO_USER_TYPE is 接收抄送人类型;comment on column IPTWF_*_DUPLICATE.TO_USER_NAME is 接收抄送人中文名;comment on column IPTWF_*_DUPLICATE.SEND_TIME is 发送时间;comment on column IPTWF_*_DUPLICATE.ACTIVITY_DEF_ID is 发送所处的环节ID;comment on column IPTWF_*_DUPLICATE.ACTIVITY_DEF_NAME is 发送所处的环节名称;comment on column IPTWF_*_DUPLICATE.ACCEPT_FLAG is 是否已打开查看;comment on column IPTWF_*_DUPLICATE.ACCEPT_TIME is 第一次打开时间;comment on column IPTWF_*_DUPLICATE.DELETED_FLAG is 是否已删除;alter table IPTWF_*_DUPLICATE add constraint PK_*_DUPLICATE_ID primary key (DUPLICATE_ID);create table IPTWF_*_LINK( LINK_ID NUMBER(12) not null, PHASE_ADVICE_FLAG NUMBER(1), MAIN_ID NUMBER(12), PROCESS_INST_ID NUMBER(12), ACTIVITY_DEF_ID VARCHAR2(64), ACTIVITY_INST_NAME VARCHAR2(64), ACTIVITY_INST_ID NUMBER(12), OPERATE_TYPE NUMBER(12), OPERATE_TIME DATE, OPERATE_USER_ID VARCHAR2(50), OPERATE_DEPT_ID NUMBER(12), OPERATE_CONTACT VARCHAR2(32), OPERATE_ROLE_ID VARCHAR2(32), NEXT_ACCEPT_LIMIT DATE, NEXT_COMPLETE_LIMIT DATE, ACCEPT_TIME DATE, ACCEPT_FLAG NUMBER(12), COMPLETE_TIME DATE, COMPLETE_FLAG NUMBER(12), SHEET_ACCESSORIES VARCHAR2(256), REMARK VARCHAR2(256), WORKITEM_ID NUMBER(12), OPERATE_USER_NAME VARCHAR2(50), NEXTSTEPPROCESSOR VARCHAR2(256), DESCRIPTION VARCHAR2(256);comment on column IPTWF_*_LINK.LINK_ID is link表主键;comment on column IPTWF_*_LINK.PHASE_ADVICE_FLAG is 阶段建议标志，默认为空，1：阶段建议;comment on column IPTWF_*_LINK.MAIN_ID is main表主键;comment on column IPTWF_*_LINK.PROCESS_INST_ID is 流程实例id;comment on column IPTWF_*_LINK.ACTIVITY_DEF_ID is 活动定义id;comment on column IPTWF_*_LINK.ACTIVITY_INST_NAME is 活动项名称;comment on column IPTWF_*_LINK.ACTIVITY_INST_ID is 活动实例id;comment on column IPTWF_*_LINK.OPERATE_TYPE is 操作类型：1.普通处理,2转派,3驳回,4直接提交,5阶段回复,6终止流程;comment on column IPTWF_*_LINK.OPERATE_TIME is 操作时间;comment on column IPTWF_*_LINK.OPERATE_USER_ID is 操作人;comment on column IPTWF_*_LINK.OPERATE_DEPT_ID is 操作部门;comment on column IPTWF_*_LINK.OPERATE_CONTACT is 操作人联系方式 ;comment on column IPTWF_*_LINK.OPERATE_ROLE_ID is 操作人角色;comment on column IPTWF_*_LINK.NEXT_ACCEPT_LIMIT is 当前操作人对下一环节的接单时限要求：接单时限(派单操作专用) 回复时限;comment on column IPTWF_*_LINK.NEXT_COMPLETE_LIMIT is 当前操作人对下一环节的完成时限要求：回复时限(派单操作专用);comment on column IPTWF_*_LINK.ACCEPT_TIME is 接单时间(接单操作专用);comment on column IPTWF_*_LINK.ACCEPT_FLAG is 接单及时标志(接单操作专用);comment on column IPTWF_*_LINK.COMPLETE_TIME is 回复时间(回单操作专用);comment on column IPTWF_*_LINK.COMPLETE_FLAG is 回复及时标志(回单操作专用);comment on column IPTWF_*_LINK.SHEET_ACCESSORIES is 附件，如果在一个页面中有多个附件分组，那么就建立多个字段，分别记录;comment on column IPTWF_*_LINK.REMARK is 处理意见;comment on column IPTWF_*_LINK.WORKITEM_ID is 工作项id;comment on column IPTWF_*_LINK.OPERATE_USER_NAME is 操作中文名;comment on column IPTWF_*_LINK.NEXTSTEPPROCESSOR is 下一步处理者;comment on column IPTWF_*_LINK.DESCRIPTION is 处理描述;alter table IPTWF_*_LINK add constraint PK_*_LINK_ID primary key (LINK_ID);create table IPTWF_*_TASK( TASK_ID NUMBER(12) not null, PROCESS_INST_ID NUMBER(12), ACTIVITY_DEF_ID VARCHAR2(64), ACTIVITY_INST_NAME VARCHAR2(64), ACTIVITY_INST_ID NUMBER(12), WORKITEM_ID NUMBER(12), TASK_ACCEPT_LIMIT DATE, FROM_USER_ID VARCHAR2(50), FROM_USER_NAME VARCHAR2(64), ACCEPT_FLAG NUMBER(12), TASK_COMPLETE_LIMIT DATE, COMPLETE_TIME DATE, COMPLETE_FLAG NUMBER(12), TASK_TYPE NUMBER(12), CREATE_TIME DATE, OPERATE_TIME DATE, MAIN_ID NUMBER(12), ROOT_PROCESS_INST_ID NUMBER(12), ROOT_ACTIVITY_INST_ID NUMBER(12), ROOT_WORKITEM_ID NUMBER(12), PARENT_PROCESS_INST_ID NUMBER(12), PARENT_ACTIVITY_INST_ID NUMBER(12), PARENT_WORKITEM_ID NUMBER(12), DRAW_FLAG NUMBER(12), READ_FLAG VARCHAR2(10), ACCEPT_TIME DATE, LOCKOWNER VARCHAR2(32);comment on column IPTWF_*_TASK.TASK_ID is task表主键;comment on column IPTWF_*_TASK.PROCESS_INST_ID is 流程实例id;comment on column IPTWF_*_TASK.ACTIVITY_DEF_ID is 活动定义id;comment on column IPTWF_*_TASK.ACTIVITY_INST_NAME is 活动项名称;comment on column IPTWF_*_TASK.ACTIVITY_INST_ID is 活动实例id;comment on column IPTWF_*_TASK.WORKITEM_ID is 工作项id;comment on column IPTWF_*_TASK.TASK_ACCEPT_LIMIT is 接单时限;comment on column IPTWF_*_TASK.FROM_USER_ID is 上一步处理人ID;comment on column IPTWF_*_TASK.FROM_USER_NAME is 上一步处理人名称;comment on column IPTWF_*_TASK.ACCEPT_FLAG is 接单及时标志;comment on column IPTWF_*_TASK.TASK_COMPLETE_LIMIT is 回复时限;comment on column IPTWF_*_TASK.COMPLETE_TIME is 回复时间;comment on column IPTWF_*_TASK.COMPLETE_FLAG is 回复及时标志;comment on column IPTWF_*_TASK.TASK_TYPE is task类型：2008-11-18添加：主工单（1）、子工单（2）、抄送任务产生的（3）;comment on column IPTWF_*_TASK.CREATE_TIME is task记录生成时间;comment on column IPTWF_*_TASK.OPERATE_TIME is 操作时间;comment on column IPTWF_*_TASK.MAIN_ID is 对main表工单主键;comment on column IPTWF_*_TASK.ROOT_PROCESS_INST_ID is 发起子流程的根流程实例ID;comment on column IPTWF_*_TASK.ROOT_ACTIVITY_INST_ID is 发起子流程的根活动实例id;comment on column IPTWF_*_TASK.ROOT_WORKITEM_ID is 发起子流程的根工作项id;comment on column IPTWF_*_TASK.PARENT_PROCESS_INST_ID is 发起子流程的父流程实例id;comment on column IPTWF_*_TASK.PARENT_ACTIVITY_INST_ID is 发起子流程的父活动实例id;comment on column IPTWF_*_TASK.PARENT_WORKITEM_ID is 发起子流程的父工作项id;comment on column IPTWF_*_TASK.DRAW_FLAG is 是否已领取,1：领取，0 ：未领取;comment on column IPTWF_*_TASK.READ_FLAG is 是否查看抄送：1表式已查看；对应的task_type 为3;comment on column IPTWF_*_TASK.ACCEPT_TIME is 接单时间;comment on column IPTWF_*_TASK.LOCKOWNER is 上锁人UESR_ID;alter table IPTWF_*_TASK add constraint PK_*_TASK_ID primary key (TASK_ID);create table IPTWF_*_MAIN( MAIN_ID NUMBER(12) not null, PROCESS_INST_ID NUMBER(12), SHEET_ID VARCHAR2(128), TITLE VARCHAR2(128), DETAIL VARCHAR2(1024), ANNEX VARCHAR2(256), STATUS NUMBER(12), SEND_TIME DATE, SEND_USER_ID VARCHAR2(50), SEND_USER_NAME VARCHAR2(32), SEND_DEPT_ID NUMBER(12), SEND_CONTACT VARCHAR2(32), SEND_ROLE_ID VARCHAR2(32), END_TIME DATE, END_USER_ID NUMBER(12), END_USER_NAME VARCHAR2(32), END_DEPT_ID NUMBER(12), END_CONTACT VARCHAR2(32), END_ROLE_ID VARCHAR2(32), DELETED NUMBER(12), PARENT_MAIN_ID NUMBER(12), PARENT_PROCESS_INST_ID NUMBER(12), PARENT_ACTIVITY_ID NUMBER(12), PARENT_WORKITEM_ID NUMBER(12), MAIN_);comment on column IPTWF_*_MAIN.MAIN_ID is main表主键;comment on column IPTWF_*_MAIN.PROCESS_INST_ID is 流程实例id;comment on column IPTWF_*_MAIN.SHEET_ID is 工单流水号;comment on column IPTWF_*_MAIN.TITLE is 工单标题;comment on column IPTWF_*_MAIN.DETAIL is 工单信息的详细描述;comment on column IPTWF_*_MAIN.ANNEX is 新建工单附件，如果有多个附件，用逗号区分（如：111，112）;comment on column IPTWF_*_MAIN.STATUS is 工单状态：0:草稿 1： 新建 2：已分配、3：退回、4：处理中、5：已解决、6：已关闭;comment on column IPTWF_*_MAIN.SEND_TIME is 派单时间，流程第一个环节的生成时间;comment on column IPTWF_*_MAIN.SEND_USER_ID is 建单id;comment on column IPTWF_*_MAIN.SEND_USER_NAME is 建单人;comment on column IPTWF_*_MAIN.SEND_DEPT_ID is 建单人部门;comment on column IPTWF_*_MAIN.SEND_CONTACT is 建单人联系方式;comment on column IPTWF_*_MAIN.SEND_ROLE_ID is 建单人角色;comment on column IPTWF_*_MAIN.END_TIME is 结束时间;comment on column IPTWF_*_MAIN.END_USER_ID is 结束人ID;comment on column IPTWF_*_MAIN.END_USER_NAME is 结束人;comment on column IPTWF_*_MAIN.END_DEPT_ID is 结束人部门;comment on column IPTWF_*_MAIN.END_CONTACT is 结束人联系方式;comment on column IPTWF_*_MAIN.END_ROLE_ID is 结束人角色;comment on column IPTWF_*_MAIN.DELETED is 是否有效：0：有效、1无效;comment on column IPTWF_*_MAIN.PARENT_MAIN_ID is a工单触发b工单，a工单的主键，父子流程，记录在子流程中。;comment on column IPTWF_*_MAIN.PARENT_PROCESS_INST_ID is a工单触发b工单，a工单的流程实例;comment on column IPTWF_*_MAIN.PARENT_ACTIVITY_ID is a工单触发b工单，a工单的活动实例;comment on column IPTWF_*_MAIN.PARENT_WORKITEM_ID is a工单触发b工单，a工单的工作项;alter table IPTWF_*_MAINadd constraint FK_*_MAIN_ID primary key (MAIN_ID);B、表说明 其中*由具体的项目名称和流程以及业务名称组成，例如：徐州管道的操作系统用户申请流程对应的表为IPTWF_XZGD_OSUSERAPPLY_MAI