Activiti7 任务委派【十四】

Activiti 7系列文章目录

文章代码下载

Activiti7 工作流设计器【一】
Activiti7 创建表【二】
Activiti7 表结构介绍 【三】
Activiti7 设计器创建流程 【四】
Activiti7 部署流程【五】
Activiti7 查询流程【六】
Activiti7 删除流程【七】
Activiti7 生成SVG图片【八】
Activiti7 发起任务【九】
Activiti7 查询任务执行流程图【十】
Activiti7 完成任务【十一】
Activiti7 历史数据【十二】
Activiti7 任务办理人、委派、转办、持有人、候选人、候选人组、审批意见【十三】
Activiti7 监听器【十四】
Activiti7 流程变量【十五】
Activiti7 网关Gateway【十六】
Activiti7 整合SpringBoot【十七】
Activiti7 多种任务类型【十八】
Activiti7 子流程【十九】
Activiti7 流程回退、流程拒绝【二十】

任务委派

任务委派只是任务人将当前的任务交给接收人进行审批，完成任务后又重新回到任务人身上。委派人查询任务与完成任务与正常的有区别。

/**
 * 指定代办人
 */
@Test
public void delegateTask() {
    List<Task> list = taskService.createTaskQuery().list();
    String taskId = list.get(0).getId();
    String loginName = "李四";
    taskService.delegateTask(taskId, loginName);
}

插入数据表

==>  Preparing: insert into ACT_HI_IDENTITYLINK (ID_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_) values (?, ?, ?, ?, ?, ?)
==> Parameters: 2501(String), participant(String), 李四(String), null, null, 4(String)
<==    Updates: 1
==>  Preparing: insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_) values (?, 1, ?, ?, ?, ?, ?, ?)
==> Parameters: 2501(String), participant(String), 李四(String), null, null, 4(String), null
<==    Updates: 1

修改的数据表

==>  Preparing: update ACT_RU_TASK SET REV_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, PRIORITY_ = ?, CREATE_TIME_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, DELEGATION_ = ?, EXECUTION_ID_ = ?, PROC_DEF_ID_ = ?, DESCRIPTION_ = ?, DUE_DATE_ = ?, CATEGORY_ = ?, SUSPENSION_STATE_ = ?, FORM_KEY_ = ?, CLAIM_TIME_ = ? where ID_= ? and REV_ = ?
==> Parameters: 2(Integer), 经理审批(String), null, 50(Integer), 2023-07-28 11:00:14.096(Timestamp), null, 李四(String), PENDING(String), 5(String), test03:1:3(String), null, null, null, 1(Integer), null, null, 8(String), 1(Integer)
<==    Updates: 1
==>  Preparing: update ACT_HI_TASKINST set PROC_DEF_ID_ = ?, EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, CLAIM_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, FORM_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ?, CATEGORY_ = ? where ID_ = ?
==> Parameters: test03:1:3(String), 5(String), 经理审批(String), null, null, null, 李四(String), null, null, null, null, sid-BD4D49BD-E99D-4D9A-9688-7778F37E3180(String), null, 50(Integer), null, null, 8(String)
<==    Updates: 1
==>  Preparing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ? where ID_ = ?
==> Parameters: 5(String), 李四(String), null, null, null, 7(String)

这里关键是将ACT_RU_TASK的ASSIGNEE_设置为新待办人

被委派人处理任务

/**
 * 正在运行的任务表中被委派人办理任务后任务会回到委派人 ，历史任务表中也一样,只是多了一个人进行审批
 */
@Test
public void resolveTask() {
    List<Task> list = taskService.createTaskQuery().list();
    String taskId = list.get(0).getId();

    taskService.resolveTask(taskId);
}

执行的SQL语句

==>  Preparing: update ACT_RU_TASK SET REV_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, PRIORITY_ = ?, CREATE_TIME_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, DELEGATION_ = ?, EXECUTION_ID_ = ?, PROC_DEF_ID_ = ?, DESCRIPTION_ = ?, DUE_DATE_ = ?, CATEGORY_ = ?, SUSPENSION_STATE_ = ?, FORM_KEY_ = ?, CLAIM_TIME_ = ? where ID_= ? and REV_ = ?
==> Parameters: 3(Integer), 经理审批(String), null, 50(Integer), 2023-07-28 11:00:14.096(Timestamp), null, null, RESOLVED(String), 5(String), test03:1:3(String), null, null, null, 1(Integer), null, null, 8(String), 2(Integer)
<==    Updates: 1
==>  Preparing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ? where ID_ = ?
==> Parameters: 5(String), null, null, null, null, 7(String)
<==    Updates: 1
==>  Preparing: update ACT_HI_TASKINST set PROC_DEF_ID_ = ?, EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, CLAIM_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, FORM_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ?, CATEGORY_ = ? where ID_ = ?
==> Parameters: test03:1:3(String), 5(String), 经理审批(String), null, null, null, null, null, null, null, null, sid-BD4D49BD-E99D-4D9A-9688-7778F37E3180(String), null, 50(Integer), null, null, 8(String)
<==    Updates: 1