flowable查询待办流程和审批

查询需要我审批的流程需要用到TaskService这个类。

@Autowired
TaskService taskService;

查询代码如下：

    TaskQuery taskQuery = taskService.createTaskQuery()
            .taskAssignee("MAINTAIN_ID_A")
            .processDefinitionKey("workorder_01")
            .active()
            .includeProcessVariables()
            .orderByTaskCreateTime().asc();
    List<Task> list = taskQuery.list();

查询流程为：

2023-01-31 17:30:14.517 DEBUG 32540 --- [           main] tTasksWithRelatedEntitiesByQueryCriteria : ==>  Preparing: SELECT RES.*, VAR.ID_ as VAR_ID_, VAR.NAME_ as VAR_NAME_, VAR.TYPE_ as VAR_TYPE_, VAR.REV_ as VAR_REV_, VAR.PROC_INST_ID_ as VAR_PROC_INST_ID_, VAR.EXECUTION_ID_ as VAR_EXECUTION_ID_, VAR.TASK_ID_ as VAR_TASK_ID_, VAR.BYTEARRAY_ID_ as VAR_BYTEARRAY_ID_, VAR.DOUBLE_ as VAR_DOUBLE_, VAR.TEXT_ as VAR_TEXT_, VAR.TEXT2_ as VAR_TEXT2_, VAR.LONG_ as VAR_LONG_, VAR.SCOPE_ID_ AS VAR_SCOPE_ID_, VAR.SUB_SCOPE_ID_ AS VAR_SUB_SCOPE_ID_,VAR.SCOPE_TYPE_ AS VAR_SCOPE_TYPE_ FROM ( SELECT RES.* from ACT_RU_TASK RES WHERE RES.ASSIGNEE_ = ? and exists ( select 1 from ACT_RE_PROCDEF D WHERE RES.PROC_DEF_ID_ = D.ID_ and D.KEY_ = ? ) and RES.SUSPENSION_STATE_ = 1 order by RES.CREATE_TIME_ asc ) RES left outer join ACT_RU_VARIABLE VAR ON (RES.PROC_INST_ID_ = VAR.EXECUTION_ID_) order by RES.CREATE_TIME_ asc
2023-01-31 17:30:14.527 DEBUG 32540 --- [           main] tTasksWithRelatedEntitiesByQueryCriteria : ==> Parameters: MAINTAIN_ID_A(String), workorder_01(String)
2023-01-31 17:30:14.591 DEBUG 32540 --- [           main] tTasksWithRelatedEntitiesByQueryCriteria : <==      Total: 2

从图中可以看到flowable是如何查询的。
但是返回的对象Task中只包含了基本信息，例如上一个人填写的信息，一般情况下页面展示这些信息就够了，但是如果还需要展示其他信息，就需要自己再次去查询，例如根据ProcessDefinitionId去查询流程定义信息：

    String processDefinitionId = task.getProcessDefinitionId();
    ProcessInstance instance = runtimeService.createProcessInstanceQuery()
            .processDefinitionId(processDefinitionId)
            .singleResult();

前端页面就可以给审批人展示这些相关信息，审批人可以根据这些信息决定是同意还是拒绝，因为下个节点为网关，需要将审批结果传入。

    <sequenceFlow id="Flow_1e19tqg" name="接单" sourceRef="Gateway_0c54yl7" targetRef="Activity_1mx7v71" >
        <conditionExpression xsi:type="tFormalExpression">
            <![CDATA[
              ${receive}
            ]]>
        </conditionExpression>
    </sequenceFlow>

审批同意的代码如下：

    Task task = taskService.createTaskQuery().taskId("3262ff86-a144-11ed-be1c-d41b81b9a72d").singleResult();
    Map<String, Object> maps = new HashMap<>();
    //审批结果，是否同意
    maps.put("receive", true);
    //记录审批人，在多人会签的时候会有多个可以审批的人员，因此需要记录具体是哪个人审批了
    maps.put("receiveUser#" + "维修工1号", "维修工1号");
    taskService.addComment(task.getId(), task.getProcessInstanceId(), "符合维修条件");
    taskService.complete(task.getId(), maps);

执行流程如下：

2023-02-01 09:00:26.761 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert org.flowable.engine.impl.persistence.entity.CommentEntityImpl@6e669b5c
2023-02-01 09:00:26.761 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : flush summary: 1 insert, 0 update, 0 delete.
2023-02-01 09:00:26.762 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : now executing flush...
2023-02-01 09:00:26.762 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : inserting: org.flowable.engine.impl.persistence.entity.CommentEntityImpl@6e669b5c
2023-02-01 09:00:26.762 DEBUG 26944 --- [           main] o.f.e.i.p.e.C.insertComment              : ==>  Preparing: insert into ACT_HI_COMMENT (ID_, TYPE_, TIME_, USER_ID_, TASK_ID_, PROC_INST_ID_, ACTION_, MESSAGE_, FULL_MSG_) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
2023-02-01 09:00:26.770 DEBUG 26944 --- [           main] o.f.e.i.p.e.C.insertComment              : ==> Parameters: d08ba898-a1cb-11ed-a185-d41b81b9a72d(String), comment(String), 2023-02-01 09:00:26.76(Timestamp), null, 6d5b3419-a1cb-11ed-93dc-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), AddComment(String), 符合维修条件(String), java.io.ByteArrayInputStream@c7aac7c(ByteArrayInputStream)
2023-02-01 09:00:26.853 DEBUG 26944 --- [           main] o.f.e.i.p.e.C.insertComment              : <==    Updates: 1
2023-02-01 09:00:26.855 DEBUG 26944 --- [           main] o.f.c.e.impl.interceptor.LogInterceptor  : --- AddCommentCmd finished --------------------------------------------------------
2023-02-01 09:00:44.286 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert VariableInstanceEntity[id=dae04fd9-a1cb-11ed-a185-d41b81b9a72d, name=receive, type=boolean, longValue=1]
2023-02-01 09:00:44.286 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert VariableInstanceEntity[id=dae1af6a-a1cb-11ed-a185-d41b81b9a72d, name=receiveUser#维修工1号, type=string, textValue=维修工1号]
2023-02-01 09:00:44.291 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert Task[id=dafb2adf-a1cb-11ed-a185-d41b81b9a72d, name=维修工开始维修]
2023-02-01 09:00:44.292 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert org.flowable.identitylink.service.impl.persistence.entity.HistoricIdentityLinkEntityImpl@74fda9ed
2023-02-01 09:00:44.292 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert HistoricVariableInstanceEntity[id=dae04fd9-a1cb-11ed-a185-d41b81b9a72d, name=receive, revision=0, type=boolean, longValue=1]
2023-02-01 09:00:44.292 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert HistoricVariableInstanceEntity[id=dae1af6a-a1cb-11ed-a185-d41b81b9a72d, name=receiveUser#维修工1号, revision=0, type=string, textValue=维修工1号]
2023-02-01 09:00:44.292 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert HistoricActivityInstanceEntity[id=daed211b-a1cb-11ed-a185-d41b81b9a72d, activityId=Flow_1ew27l5, activityName=null, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.293 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert HistoricActivityInstanceEntity[id=daede46c-a1cb-11ed-a185-d41b81b9a72d, activityId=Gateway_0c54yl7, activityName=, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.293 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert HistoricActivityInstanceEntity[id=daf9cb4d-a1cb-11ed-a185-d41b81b9a72d, activityId=Flow_1e19tqg, activityName=接单, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.293 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert HistoricActivityInstanceEntity[id=dafab5ae-a1cb-11ed-a185-d41b81b9a72d, activityId=Activity_1mx7v71, activityName=维修工开始维修, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.293 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert ActivityInstanceEntity[id=daed211b-a1cb-11ed-a185-d41b81b9a72d, activityId=Flow_1ew27l5, activityName=null, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.293 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert ActivityInstanceEntity[id=daede46c-a1cb-11ed-a185-d41b81b9a72d, activityId=Gateway_0c54yl7, activityName=, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.294 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert ActivityInstanceEntity[id=daf9cb4d-a1cb-11ed-a185-d41b81b9a72d, activityId=Flow_1e19tqg, activityName=接单, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.294 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert ActivityInstanceEntity[id=dafab5ae-a1cb-11ed-a185-d41b81b9a72d, activityId=Activity_1mx7v71, activityName=维修工开始维修, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.294 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : insert HistoricTaskInstanceEntity[id=dafb2adf-a1cb-11ed-a185-d41b81b9a72d]
2023-02-01 09:00:44.294 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : update HistoricActivityInstanceEntity[id=6d57b1a8-a1cb-11ed-93dc-d41b81b9a72d, activityId=Activity_06mh37b, activityName=维修工接单或者转单, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.294 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : update Execution[ id '6d567925-a1cb-11ed-93dc-d41b81b9a72d' ] - activity 'Activity_1mx7v71' - parent '6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d'
2023-02-01 09:00:44.295 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : update ActivityInstanceEntity[id=6d57b1a8-a1cb-11ed-93dc-d41b81b9a72d, activityId=Activity_06mh37b, activityName=维修工接单或者转单, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.295 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : update HistoricTaskInstanceEntity[id=6d5b3419-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.295 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : delete Task[id=6d5b3419-a1cb-11ed-93dc-d41b81b9a72d, name=维修工接单或者转单] with id 6d5b3419-a1cb-11ed-93dc-d41b81b9a72d
2023-02-01 09:00:44.295 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : flush summary: 15 insert, 4 update, 1 delete.
2023-02-01 09:00:44.295 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : now executing flush...
2023-02-01 09:00:44.310 DEBUG 26944 --- [           main] p.e.H.bulkInsertHistoricVariableInstance : ==>  Preparing: insert into ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
2023-02-01 09:00:44.320 DEBUG 26944 --- [           main] p.e.H.bulkInsertHistoricVariableInstance : ==> Parameters: dae04fd9-a1cb-11ed-a185-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), null, receive(String), 0(Integer), boolean(String), null, null, null, null, null, 1(Long), null, null, 2023-02-01 09:00:44.1(Timestamp), 2023-02-01 09:00:44.1(Timestamp), dae1af6a-a1cb-11ed-a185-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), null, receiveUser#维修工1号(String), 0(Integer), string(String), null, null, null, null, null, null, 维修工1号(String), null, 2023-02-01 09:00:44.101(Timestamp), 2023-02-01 09:00:44.101(Timestamp)
2023-02-01 09:00:44.324 DEBUG 26944 --- [           main] p.e.H.bulkInsertHistoricVariableInstance : <==    Updates: 2
2023-02-01 09:00:44.324 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : inserting: org.flowable.identitylink.service.impl.persistence.entity.HistoricIdentityLinkEntityImpl@74fda9ed
2023-02-01 09:00:44.325 DEBUG 26944 --- [           main] f.i.s.i.p.e.H.insertHistoricIdentityLink : ==>  Preparing: insert into ACT_HI_IDENTITYLINK (ID_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_, CREATE_TIME_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2023-02-01 09:00:44.331 DEBUG 26944 --- [           main] f.i.s.i.p.e.H.insertHistoricIdentityLink : ==> Parameters: dafba010-a1cb-11ed-a185-d41b81b9a72d(String), assignee(String), MAINTAIN_ID_A(String), null, dafb2adf-a1cb-11ed-a185-d41b81b9a72d(String), null, null, null, null, null, 2023-02-01 09:00:44.271(Timestamp)
2023-02-01 09:00:44.333 DEBUG 26944 --- [           main] f.i.s.i.p.e.H.insertHistoricIdentityLink : <==    Updates: 1
2023-02-01 09:00:44.334 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : inserting: HistoricTaskInstanceEntity[id=dafb2adf-a1cb-11ed-a185-d41b81b9a72d]
2023-02-01 09:00:44.335 DEBUG 26944 --- [           main] f.t.s.i.p.e.H.insertHistoricTaskInstance : ==>  Preparing: insert into ACT_HI_TASKINST ( ID_, REV_, TASK_DEF_ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_, PROPAGATED_STAGE_INST_ID_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_, CATEGORY_, TENANT_ID_, LAST_UPDATED_TIME_ ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
2023-02-01 09:00:44.345 DEBUG 26944 --- [           main] f.t.s.i.p.e.H.insertHistoricTaskInstance : ==> Parameters: dafb2adf-a1cb-11ed-a185-d41b81b9a72d(String), null, workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), null, null, null, null, null, 维修工开始维修(String), null, null, null, MAINTAIN_ID_A(String), 2023-02-01 09:00:44.265(Timestamp), null, null, null, null, Activity_1mx7v71(String), null, 50(Integer), null, null, (String), 2023-02-01 09:00:44.27(Timestamp)
2023-02-01 09:00:44.347 DEBUG 26944 --- [           main] f.t.s.i.p.e.H.insertHistoricTaskInstance : <==    Updates: 1
2023-02-01 09:00:44.367 DEBUG 26944 --- [           main] p.e.H.bulkInsertHistoricActivityInstance : ==>  Preparing: insert into ACT_HI_ACTINST ( ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, TRANSACTION_ORDER_, DURATION_, DELETE_REASON_, TENANT_ID_ ) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2023-02-01 09:00:44.382 DEBUG 26944 --- [           main] p.e.H.bulkInsertHistoricActivityInstance : ==> Parameters: daed211b-a1cb-11ed-a185-d41b81b9a72d(String), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), Flow_1ew27l5(String), null, null, null, sequenceFlow(String), null, 2023-02-01 09:00:44.176(Timestamp), 2023-02-01 09:00:44.176(Timestamp), 1(Integer), 0(Long), null, (String), daede46c-a1cb-11ed-a185-d41b81b9a72d(String), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), Gateway_0c54yl7(String), null, null, (String), exclusiveGateway(String), null, 2023-02-01 09:00:44.181(Timestamp), 2023-02-01 09:00:44.259(Timestamp), 2(Integer), 78(Long), null, (String), daf9cb4d-a1cb-11ed-a185-d41b81b9a72d(String), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), Flow_1e19tqg(String), null, null, 接单(String), sequenceFlow(String), null, 2023-02-01 09:00:44.26(Timestamp), 2023-02-01 09:00:44.26(Timestamp), 3(Integer), 0(Long), null, (String), dafab5ae-a1cb-11ed-a185-d41b81b9a72d(String), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), Activity_1mx7v71(String), dafb2adf-a1cb-11ed-a185-d41b81b9a72d(String), null, 维修工开始维修(String), userTask(String), MAINTAIN_ID_A(String), 2023-02-01 09:00:44.265(Timestamp), null, 4(Integer), null, null, (String)
2023-02-01 09:00:44.386 DEBUG 26944 --- [           main] p.e.H.bulkInsertHistoricActivityInstance : <==    Updates: 4
2023-02-01 09:00:44.404 DEBUG 26944 --- [           main] o.f.e.i.p.e.A.bulkInsertActivityInstance : ==>  Preparing: insert into ACT_RU_ACTINST ( ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, TRANSACTION_ORDER_, DURATION_, DELETE_REASON_, TENANT_ID_ ) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2023-02-01 09:00:44.418 DEBUG 26944 --- [           main] o.f.e.i.p.e.A.bulkInsertActivityInstance : ==> Parameters: daed211b-a1cb-11ed-a185-d41b81b9a72d(String), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), Flow_1ew27l5(String), null, null, null, sequenceFlow(String), null, 2023-02-01 09:00:44.176(Timestamp), 2023-02-01 09:00:44.176(Timestamp), 1(Integer), 0(Long), null, (String), daede46c-a1cb-11ed-a185-d41b81b9a72d(String), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), Gateway_0c54yl7(String), null, null, (String), exclusiveGateway(String), null, 2023-02-01 09:00:44.181(Timestamp), 2023-02-01 09:00:44.259(Timestamp), 2(Integer), 78(Long), null, (String), daf9cb4d-a1cb-11ed-a185-d41b81b9a72d(String), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), Flow_1e19tqg(String), null, null, 接单(String), sequenceFlow(String), null, 2023-02-01 09:00:44.26(Timestamp), 2023-02-01 09:00:44.26(Timestamp), 3(Integer), 0(Long), null, (String), dafab5ae-a1cb-11ed-a185-d41b81b9a72d(String), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), Activity_1mx7v71(String), dafb2adf-a1cb-11ed-a185-d41b81b9a72d(String), null, 维修工开始维修(String), userTask(String), MAINTAIN_ID_A(String), 2023-02-01 09:00:44.265(Timestamp), null, 4(Integer), null, null, (String)
2023-02-01 09:00:44.423 DEBUG 26944 --- [           main] o.f.e.i.p.e.A.bulkInsertActivityInstance : <==    Updates: 4
2023-02-01 09:00:44.424 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : inserting: Task[id=dafb2adf-a1cb-11ed-a185-d41b81b9a72d, name=维修工开始维修]
2023-02-01 09:00:44.425 DEBUG 26944 --- [           main] o.f.t.s.i.p.e.TaskEntityImpl.insertTask  : ==>  Preparing: insert into ACT_RU_TASK (ID_, REV_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, PRIORITY_, CREATE_TIME_, OWNER_, ASSIGNEE_, DELEGATION_, EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_ID_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_, PROPAGATED_STAGE_INST_ID_, TASK_DEF_KEY_, DUE_DATE_, CATEGORY_, SUSPENSION_STATE_, TENANT_ID_, FORM_KEY_, CLAIM_TIME_, IS_COUNT_ENABLED_, VAR_COUNT_, ID_LINK_COUNT_, SUB_TASK_COUNT_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
2023-02-01 09:00:44.435 DEBUG 26944 --- [           main] o.f.t.s.i.p.e.TaskEntityImpl.insertTask  : ==> Parameters: dafb2adf-a1cb-11ed-a185-d41b81b9a72d(String), 维修工开始维修(String), null, null, 50(Integer), 2023-02-01 09:00:44.265(Timestamp), null, MAINTAIN_ID_A(String), null, 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), null, null, null, null, null, null, Activity_1mx7v71(String), null, null, 1(Integer), (String), null, null, true(Boolean), 0(Integer), 0(Integer), 0(Integer)
2023-02-01 09:00:44.441 DEBUG 26944 --- [           main] o.f.t.s.i.p.e.TaskEntityImpl.insertTask  : <==    Updates: 1
2023-02-01 09:00:44.449 DEBUG 26944 --- [           main] f.v.s.i.p.e.V.bulkInsertVariableInstance : ==>  Preparing: INSERT INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
2023-02-01 09:00:44.457 DEBUG 26944 --- [           main] f.v.s.i.p.e.V.bulkInsertVariableInstance : ==> Parameters: dae04fd9-a1cb-11ed-a185-d41b81b9a72d(String), boolean(String), receive(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), null, null, null, null, null, null, 1(Long), null, null, dae1af6a-a1cb-11ed-a185-d41b81b9a72d(String), string(String), receiveUser#维修工1号(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), 6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d(String), null, null, null, null, null, null, null, 维修工1号(String), null
2023-02-01 09:00:44.459 DEBUG 26944 --- [           main] f.v.s.i.p.e.V.bulkInsertVariableInstance : <==    Updates: 2
2023-02-01 09:00:44.460 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : updating: HistoricActivityInstanceEntity[id=6d57b1a8-a1cb-11ed-93dc-d41b81b9a72d, activityId=Activity_06mh37b, activityName=维修工接单或者转单, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.468 DEBUG 26944 --- [           main] e.i.p.e.H.updateHistoricActivityInstance : ==>  Preparing: update ACT_HI_ACTINST SET REV_ = ?, PROC_DEF_ID_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ? and REV_ = ?
2023-02-01 09:00:44.471 DEBUG 26944 --- [           main] e.i.p.e.H.updateHistoricActivityInstance : ==> Parameters: 2(Integer), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 2023-02-01 09:00:44.159(Timestamp), 183834(Long), 6d57b1a8-a1cb-11ed-93dc-d41b81b9a72d(String), 1(Integer)
2023-02-01 09:00:44.473 DEBUG 26944 --- [           main] e.i.p.e.H.updateHistoricActivityInstance : <==    Updates: 1
2023-02-01 09:00:44.473 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : updating: Execution[ id '6d567925-a1cb-11ed-93dc-d41b81b9a72d' ] - activity 'Activity_1mx7v71' - parent '6d55b5d1-a1cb-11ed-93dc-d41b81b9a72d'
2023-02-01 09:00:44.491 DEBUG 26944 --- [           main] o.f.e.i.p.e.E.updateExecution            : ==>  Preparing: update ACT_RU_EXECUTION SET REV_ = ?, ACT_ID_ = ? where ID_ = ? and REV_ = ?
2023-02-01 09:00:44.493 DEBUG 26944 --- [           main] o.f.e.i.p.e.E.updateExecution            : ==> Parameters: 2(Integer), Activity_1mx7v71(String), 6d567925-a1cb-11ed-93dc-d41b81b9a72d(String), 1(Integer)
2023-02-01 09:00:44.494 DEBUG 26944 --- [           main] o.f.e.i.p.e.E.updateExecution            : <==    Updates: 1
2023-02-01 09:00:44.494 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : updating: ActivityInstanceEntity[id=6d57b1a8-a1cb-11ed-93dc-d41b81b9a72d, activityId=Activity_06mh37b, activityName=维修工接单或者转单, executionId= 6d567925-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.496 DEBUG 26944 --- [           main] o.f.e.i.p.e.A.updateActivityInstance     : ==>  Preparing: update ACT_RU_ACTINST SET REV_ = ?, PROC_DEF_ID_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ? and REV_ = ?
2023-02-01 09:00:44.499 DEBUG 26944 --- [           main] o.f.e.i.p.e.A.updateActivityInstance     : ==> Parameters: 2(Integer), workorder_01:2:00ed8d26-a110-11ed-b14e-d41b81b9a72d(String), 2023-02-01 09:00:44.159(Timestamp), 183834(Long), 6d57b1a8-a1cb-11ed-93dc-d41b81b9a72d(String), 1(Integer)
2023-02-01 09:00:44.500 DEBUG 26944 --- [           main] o.f.e.i.p.e.A.updateActivityInstance     : <==    Updates: 1
2023-02-01 09:00:44.501 DEBUG 26944 --- [           main] o.f.common.engine.impl.db.DbSqlSession   : updating: HistoricTaskInstanceEntity[id=6d5b3419-a1cb-11ed-93dc-d41b81b9a72d]
2023-02-01 09:00:44.512 DEBUG 26944 --- [           main] f.t.s.i.p.e.H.updateHistoricTaskInstance : ==>  Preparing: update ACT_HI_TASKINST SET REV_ = ?, END_TIME_ = ?, DURATION_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ?
2023-02-01 09:00:44.515 DEBUG 26944 --- [           main] f.t.s.i.p.e.H.updateHistoricTaskInstance : ==> Parameters: 2(Integer), 2023-02-01 09:00:44.102(Timestamp), 183776(Long), 2023-02-01 09:00:44.102(Timestamp), 6d5b3419-a1cb-11ed-93dc-d41b81b9a72d(String), 1(Integer)
2023-02-01 09:00:44.517 DEBUG 26944 --- [           main] f.t.s.i.p.e.H.updateHistoricTaskInstance : <==    Updates: 1
2023-02-01 09:00:44.518 DEBUG 26944 --- [           main] o.f.t.s.i.p.e.TaskEntityImpl.deleteTask  : ==>  Preparing: delete from ACT_RU_TASK where ID_ = ? and REV_ = ?
2023-02-01 09:00:44.520 DEBUG 26944 --- [           main] o.f.t.s.i.p.e.TaskEntityImpl.deleteTask  : ==> Parameters: 6d5b3419-a1cb-11ed-93dc-d41b81b9a72d(String), 1(Integer)
2023-02-01 09:00:44.522 DEBUG 26944 --- [           main] o.f.t.s.i.p.e.TaskEntityImpl.deleteTask  : <==    Updates: 1
2023-02-01 09:00:44.524 DEBUG 26944 --- [           main] o.f.c.e.impl.interceptor.LogInterceptor  : --- CompleteTaskCmd finished --------------------------------------------------------

flowable中有一张表ACT_HI_COMMENT用来存储审批时填写的审批意见。
其他涉及的表格后面分析。
这就是从绘制流程图到部署流程图，再到发起流程，流程审批的内容了，后面会以一个工单流转的具体例子详细分解每个步骤。

posted @ 2023-01-31 17:09 努力干饭的兔兔阅读(4463) 评论(0) 收藏举报

刷新页面返回顶部

lengshui

flowable查询待办流程和审批

公告