工单及流程删除

此处工单的删除以抢修工单为例，目标是删除抢修工单的表单以及流程待办信息。

关联信息查询

工单信息

工单主表查询

# 工单主表信息查询
SELECT *
FROM mt674589329401577541
WHERE f_id IN (
               '714849961811910533',
               '714849225904496517',
               '714848273520664453',
               '714846358376292101'
    );

物料子表查询

# 工单 - 物料子表查询
SELECT *
FROM ct674589329405771846
WHERE f_foreign_id IN (
                       '714849961811910533',
                       '714849225904496517',
                       '714848273520664453',
                       '714846358376292101'
    );

任务子表查询

SELECT *
FROM ct674589329405771845
WHERE f_foreign_id IN (
                       '714849961811910533',
                       '714849225904496517',
                       '714848273520664453',
                       '714846358376292101'
    );

流程信息

流程主版本 ID 以及流程任务 ID

# f_flow_id 流程主版本ID，关联 workflow_version
# f_flow_task_id 流程任务主键，关联workflow_task
SELECT f_flow_id, f_flow_task_id
FROM mt674589329401577541
WHERE f_id IN (
               '714849961811910533',
               '714849225904496517',
               '714848273520664453',
               '714846358376292101'
    );

流程主版本

# f_flow_id 流程主版本ID，关联 workflow_version
# 流程模板主键 713033608876531269
SELECT *
FROM workflow_version
WHERE f_id = '714808298871725829';

流程定义

# workflow_version 关联 workflow_template
# 流程模板主键 713033608876531269
SELECT *
FROM workflow_template
WHERE f_id = '713033608876531269';

表单与流程节点

# workflow_node 关联 workflow_version以及base_form
-- 获取抢修工单信息
SELECT *
FROM base_visual_release
WHERE f_full_name = '抢修工单';
-- 获取相关node
SELECT *
FROM workflow_node
WHERE f_form_id = '674598677179793477'
  AND f_flow_id = '714808298871725829';

流程任务

# 获取 流程节点任务
SELECT *
FROM workflow_task
WHERE f_flow_id = '714808298871725829'
  AND f_template_id = '713033608876531269';

SELECT *
FROM workflow_task_line
WHERE f_task_id IN (SELECT wt.f_id
                    FROM workflow_task as wt
                    WHERE wt.f_flow_id = '714808298871725829'
                      AND wt.f_template_id = '713033608876531269');

流程记录

# 获取流程记录
SELECT *
FROM workflow_record
WHERE f_task_id IN (SELECT wt.f_id
                    FROM workflow_task as wt
                    WHERE wt.f_flow_id = '714808298871725829'
                      AND wt.f_template_id = '713033608876531269');

流程发起信息

# 流程发起信息
SELECT *
FROM workflow_launch_user
WHERE f_task_id IN (SELECT wt.f_id
                    FROM workflow_task as wt
                    WHERE wt.f_flow_id = '714808298871725829'
                      AND wt.f_template_id = '713033608876531269');

经办信息

# 经办信息
SELECT *
FROM workflow_operator
WHERE f_task_id IN (SELECT wt.f_id
                    FROM workflow_task as wt
                    WHERE wt.f_flow_id = '714808298871725829'
                      AND wt.f_template_id = '713033608876531269');

删除关联信息

删除流程经办

DELETE
FROM workflow_operator
WHERE f_task_id IN (SELECT wt.f_id
                    FROM workflow_task as wt
                    WHERE wt.f_flow_id = '714808298871725829'
                      AND wt.f_template_id = '713033608876531269');

删除流程发起

DELETE
FROM workflow_launch_user
WHERE f_task_id IN (SELECT wt.f_id
                    FROM workflow_task as wt
                    WHERE wt.f_flow_id = '714808298871725829'
                      AND wt.f_template_id = '713033608876531269');

删除流程记录

DELETE
FROM workflow_record
WHERE f_task_id IN (SELECT wt.f_id
                    FROM workflow_task as wt
                    WHERE wt.f_flow_id = '714808298871725829'
                      AND wt.f_template_id = '713033608876531269');

删除任务子表

DELETE
FROM ct674589329405771845
WHERE f_foreign_id IN (
                       '714849961811910533',
                       '714849225904496517',
                       '714848273520664453',
                       '714846358376292101'
    );

删除物料子表

DELETE
FROM ct674589329405771846
WHERE f_foreign_id IN (
                       '714849961811910533',
                       '714849225904496517',
                       '714848273520664453',
                       '714846358376292101'
    );

删除工单

DELETE
FROM mt674589329401577541
WHERE f_id IN (
               '714849961811910533',
               '714849225904496517',
               '714848273520664453',
               '714846358376292101'
    );