Activiti数据库设计和模型映射2-RE流程定义存储表
2019-08-23 本文已影响0人
安安汐而
Demo项目代码：
https://gitee.com/AnAnXiEr/activiti6-demo
1、ACT_RE_DEPLOYMENT 【DeploymentEntityImpl】：流程部署记录表
ID_：主键
NAME_:名称
CATEGORY:分类
TENANT_ID：多租户标志
DEPLOY_TIME_：部署时间
KEY_：标志key
ENGINE_VERSION：兼容版本
2、ACT_RE_PROCDEF 【ProcessDefinitionEntityImpl】：流程定义信息表
DEPLOYMENT_ID_:管理部署ID
RESOURCE_NAME_：流程定义资源名称
DGRM_RESOURCE_NAME_：流程图片资源名称
HAS_START_FORM_KEY_：是否存在开始表单标志
HAS_GRAPHICAL_NOTATION_：是否有图形信息
SUSPENSION_STATE_:挂起状态 1正常、2挂起
修改bpmn配置文件，设置formkey
<startEvent id="startEvent" name="开始" activiti:formKey="/process/form/key"></startEvent>
3、ACT_RE_MODEL：模型信息表（用户web设计器）
4、ACT_PROCDEF_INFO：流程定义动态改变信息表
代码
DbRepositoryTest
package com.imooc.activiti.activitidemo.dbentity;
import org.activiti.engine.test.ActivitiRule;
import org.junit.Rule;
import org.junit.Test;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
/**
* @Description GE通用数据库配置测试
* @Author 胡浩
* @Date 2019/8/23
**/
public class DbRepositoryTest {
private static final Logger LOGGER = LoggerFactory.getLogger(DbRepositoryTest.class);
//测试、改为自己的mysql数据库
@Rule
public ActivitiRule activitiRule = new ActivitiRule("dbentity/activiti-mysql.cfg.xml");
/**
* 部署
*/
@Test
public void testDeploy() {
//会往act_ge_byteArray表插入一条资源记录
//会往act_re_deployment表插入一条流程部署记录表
//会往act_re_procdef表插入一条流程定义信息表
//<startEvent id="startEvent" name="开始" activiti:formKey="secend_approve_formkey"></startEvent>
activitiRule.getRepositoryService().createDeployment().name("二次审批流程")
.addClasspathResource("MyProcess.bpmn20.xml")
.deploy();
}
/**
* 挂起
*/
@Test
public void testSuspend() {
//挂起
activitiRule.getRepositoryService().suspendProcessDefinitionById("process:2:7504");
boolean processDefinitionSuspended = activitiRule.getRepositoryService().isProcessDefinitionSuspended("process:2:7504");
LOGGER.info("是否挂起 {}",processDefinitionSuspended);
}
}
MyProcess.bpmn20.xml
<?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:activiti="http://activiti.org/bpmn" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:omgdi="http://www.omg.org/spec/DD/20100524/DI" typeLanguage="http://www.w3.org/2001/XMLSchema" expressionLanguage="http://www.w3.org/1999/XPath" targetNamespace="http://www.activiti.org/processdef">
<process id="process" name="二级审批流程" isExecutable="true">
<documentation>二级审批流程描述</documentation>
<startEvent id="startEvent" name="开始" activiti:formKey="/process/form/key"></startEvent>
<userTask id="submitForm" name="填写审批信息">
<extensionElements>
<activiti:formProperty id="message" name="申请信息" type="string" required="true"/>
<activiti:formProperty id="name" name="申请人姓名" type="string" required="true"/>
<activiti:formProperty id="submitTime" name="提交时间" type="date" datePattern="yyyy-MM-dd hh:mm" required="true"/>
<activiti:formProperty id="submitType" name="确认申请" type="string" required="true"/>
</extensionElements>
</userTask>
<sequenceFlow id="sid-DB948276-B02D-4AEC-A0F3-2F07FE14539F" sourceRef="startEvent" targetRef="submitForm"/>
<exclusiveGateway id="decideSubmit" name="提交Or取消"/>
<sequenceFlow id="sid-90C08259-B2E4-4040-AFD0-887A1B63BCB4" sourceRef="submitForm" targetRef="decideSubmit"/>
<userTask id="tl_approve" name="主管审批">
<extensionElements>
<activiti:formProperty id="tlApprove" name="主管审批结果" type="string" required="true"/>
<activiti:formProperty id="tlMessage" name="主管备注" type="string" required="true"/>
</extensionElements>
</userTask>
<exclusiveGateway id="decideTLApprove" name="主管审批校验"/>
<sequenceFlow id="sid-F2A588E6-D75D-4853-9776-D19EE387AC36" sourceRef="tl_approve" targetRef="decideTLApprove"/>
<userTask id="hr_approve" name="人事审批">
<extensionElements>
<activiti:formProperty id="hrApprove" name="人事审批结果" type="string" required="true"/>
<activiti:formProperty id="hrMessage" name="人事审批备注" type="string" required="true"/>
</extensionElements>
</userTask>
<exclusiveGateway id="decideHrApprove" name="人事审批校验"/>
<sequenceFlow id="sid-08679356-C5A5-40E1-9233-BC15BFEB2C58" sourceRef="hr_approve" targetRef="decideHrApprove"/>
<endEvent id="endEvent" name="结束"/>
<endEvent id="endEventCancel" name="取消"/>
<sequenceFlow id="sid-C75DA753-2A7B-4188-B959-02D684EEDE82" sourceRef="decideSubmit" targetRef="tl_approve">
<conditionExpression xsi:type="tFormalExpression">
<![CDATA[ ${submitType == "y" || submitType=="Y"} ]]>
</conditionExpression>
</sequenceFlow>
<sequenceFlow id="sid-3F088F53-AD0C-47C4-8CC7-EE9B6F0AD26A" sourceRef="decideSubmit" targetRef="endEventCancel">
<conditionExpression xsi:type="tFormalExpression">
<![CDATA[ ${submitType == "n" || submitType =="N"} ]]>
</conditionExpression>
</sequenceFlow>
<sequenceFlow id="sid-09D306B4-A1C7-4399-9CF4-03EF3B5FE3BD" sourceRef="decideTLApprove" targetRef="hr_approve">
<conditionExpression xsi:type="tFormalExpression">
<![CDATA[ ${tlApprove=="y" || tlApprove=="Y"} ]]>
</conditionExpression>
</sequenceFlow>
<sequenceFlow id="sid-A437F37A-0732-433E-B608-3103029C96BD" sourceRef="decideHrApprove" targetRef="endEvent">
<conditionExpression xsi:type="tFormalExpression">
<![CDATA[ ${hrApprove=="y" || hrApprove=="Y"} ]]>
</conditionExpression>
</sequenceFlow>
<sequenceFlow id="sid-E8944E87-C69E-4DCF-85D7-A67CD378EC63" sourceRef="decideHrApprove" targetRef="submitForm">
<conditionExpression xsi:type="tFormalExpression">
<![CDATA[ ${hrApprove=="n" || hrApprove=="N"} ]]>
</conditionExpression>
</sequenceFlow>
<sequenceFlow id="sid-A8329121-BD51-4AE9-B390-FE837F5FAD36" sourceRef="decideTLApprove" targetRef="submitForm">
<conditionExpression xsi:type="tFormalExpression">
<![CDATA[ ${tlApprove=="n" || tlApprove=="N"} ]]>
</conditionExpression>
</sequenceFlow>
</process>
<bpmndi:BPMNDiagram id="BPMNDiagram_process">
<bpmndi:BPMNPlane bpmnElement="process" id="BPMNPlane_process">
<bpmndi:BPMNShape bpmnElement="startEvent" id="BPMNShape_startEvent">
<omgdc:Bounds height="30.0" width="30.0" x="75.0" y="100.0"/>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="submitForm" id="BPMNShape_submitForm">
<omgdc:Bounds height="80.0" width="100.0" x="150.0" y="75.0"/>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="decideSubmit" id="BPMNShape_decideSubmit">
<omgdc:Bounds height="40.0" width="40.0" x="285.0" y="96.0"/>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="tl_approve" id="BPMNShape_tl_approve">
<omgdc:Bounds height="80.0" width="100.0" x="380.0" y="76.0"/>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="decideTLApprove" id="BPMNShape_decideTLApprove">
<omgdc:Bounds height="40.0" width="40.0" x="525.0" y="96.0"/>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="hr_approve" id="BPMNShape_hr_approve">
<omgdc:Bounds height="80.0" width="100.0" x="660.0" y="76.0"/>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="decideHrApprove" id="BPMNShape_decideHrApprove">
<omgdc:Bounds height="40.0" width="40.0" x="810.0" y="90.0"/>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="endEvent" id="BPMNShape_endEvent">
<omgdc:Bounds height="28.0" width="28.0" x="960.0" y="101.0"/>
</bpmndi:BPMNShape>
<bpmndi:BPMNShape bpmnElement="endEventCancel" id="BPMNShape_endEventCancel">
<omgdc:Bounds height="28.0" width="28.0" x="416.0" y="180.0"/>
</bpmndi:BPMNShape>
<bpmndi:BPMNEdge bpmnElement="sid-90C08259-B2E4-4040-AFD0-887A1B63BCB4" id="BPMNEdge_sid-90C08259-B2E4-4040-AFD0-887A1B63BCB4">
<omgdi:waypoint x="250.0" y="115.71090047393365"/>
<omgdi:waypoint x="285.21153846153845" y="116.21153846153845"/>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="sid-E8944E87-C69E-4DCF-85D7-A67CD378EC63" id="BPMNEdge_sid-E8944E87-C69E-4DCF-85D7-A67CD378EC63">
<omgdi:waypoint x="830.5" y="129.5"/>
<omgdi:waypoint x="830.5" y="253.0"/>
<omgdi:waypoint x="200.0" y="253.0"/>
<omgdi:waypoint x="200.0" y="155.0"/>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="sid-F2A588E6-D75D-4853-9776-D19EE387AC36" id="BPMNEdge_sid-F2A588E6-D75D-4853-9776-D19EE387AC36">
<omgdi:waypoint x="480.0" y="116.21645021645021"/>
<omgdi:waypoint x="525.4130434782609" y="116.41304347826087"/>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="sid-A437F37A-0732-433E-B608-3103029C96BD" id="BPMNEdge_sid-A437F37A-0732-433E-B608-3103029C96BD">
<omgdi:waypoint x="849.5" y="110.5"/>
<omgdi:waypoint x="905.0" y="110.5"/>
<omgdi:waypoint x="905.0" y="115.0"/>
<omgdi:waypoint x="960.0" y="115.0"/>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="sid-DB948276-B02D-4AEC-A0F3-2F07FE14539F" id="BPMNEdge_sid-DB948276-B02D-4AEC-A0F3-2F07FE14539F">
<omgdi:waypoint x="105.0" y="115.0"/>
<omgdi:waypoint x="150.0" y="115.0"/>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="sid-A8329121-BD51-4AE9-B390-FE837F5FAD36" id="BPMNEdge_sid-A8329121-BD51-4AE9-B390-FE837F5FAD36">
<omgdi:waypoint x="545.5" y="96.5"/>
<omgdi:waypoint x="545.5" y="32.0"/>
<omgdi:waypoint x="200.0" y="32.0"/>
<omgdi:waypoint x="200.0" y="75.0"/>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="sid-09D306B4-A1C7-4399-9CF4-03EF3B5FE3BD" id="BPMNEdge_sid-09D306B4-A1C7-4399-9CF4-03EF3B5FE3BD">
<omgdi:waypoint x="564.5579268292682" y="116.4420731707317"/>
<omgdi:waypoint x="660.0" y="116.15197568389058"/>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="sid-3F088F53-AD0C-47C4-8CC7-EE9B6F0AD26A" id="BPMNEdge_sid-3F088F53-AD0C-47C4-8CC7-EE9B6F0AD26A">
<omgdi:waypoint x="305.5" y="135.5"/>
<omgdi:waypoint x="305.5" y="194.0"/>
<omgdi:waypoint x="416.0" y="194.0"/>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="sid-C75DA753-2A7B-4188-B959-02D684EEDE82" id="BPMNEdge_sid-C75DA753-2A7B-4188-B959-02D684EEDE82">
<omgdi:waypoint x="324.62666666666667" y="116.37333333333333"/>
<omgdi:waypoint x="380.0" y="116.00662251655629"/>
</bpmndi:BPMNEdge>
<bpmndi:BPMNEdge bpmnElement="sid-08679356-C5A5-40E1-9233-BC15BFEB2C58" id="BPMNEdge_sid-08679356-C5A5-40E1-9233-BC15BFEB2C58">
<omgdi:waypoint x="760.0" y="116.0"/>
<omgdi:waypoint x="785.0" y="116.0"/>
<omgdi:waypoint x="785.0" y="110.5"/>
<omgdi:waypoint x="810.5" y="110.5"/>
</bpmndi:BPMNEdge>
</bpmndi:BPMNPlane>
</bpmndi:BPMNDiagram>
</definitions>
