id_,node_type_,prco_def_id_,node_id_,node_name_,start_time_,end_time,is_muliti_task_,parent_id_,proc_inst_id_,node_path_,task_token_,TARGET_NODE_,TARGET_TOKEN_,INTERPOSE_
relation_id_,proc_inst_id_,from_stack_id_,to_stack_id_,from_node_id_,to_node_id_,relation_state_,from_node_type_,to_node_type_,created_time_
INSERT INTO bpm_exe_stack
(id_,node_type_,prco_def_id_,node_id_,node_name_,start_time_,end_time,is_muliti_task_,parent_id_,proc_inst_id_,node_path_,task_token_,TARGET_NODE_,TARGET_TOKEN_,INTERPOSE_)
VALUES
(#{id,jdbcType=VARCHAR},#{nodeType,jdbcType=VARCHAR},
#{prcoDefId,jdbcType=VARCHAR}, #{nodeId,jdbcType=VARCHAR},
#{nodeName,jdbcType=VARCHAR},
#{startTime,jdbcType=TIMESTAMP},
#{endTime,jdbcType=TIMESTAMP}, #{isMulitiTask,jdbcType=NUMERIC},
#{parentId,jdbcType=VARCHAR}, #{procInstId,jdbcType=VARCHAR},
#{nodePath,jdbcType=VARCHAR},
#{taskToken,jdbcType=VARCHAR},#{targetNode,jdbcType=VARCHAR},
#{targetToken,jdbcType=VARCHAR}, #{interpose,jdbcType=NUMERIC})
DELETE FROM bpm_exe_stack
WHERE
id_=#{id}
DELETE FROM bpm_exe_stack
WHERE
node_path_ != '${@com.artfess.base.util.StringUtil@substringBeforeLast(nodePath,
"%")}' and proc_inst_id_=#{procInstId,jdbcType=VARCHAR} and node_path_
like #{nodePath}
insert into bpm_exe_stack_his
(
)
select
from bpm_exe_stack
WHERE node_path_ !=
'${@com.artfess.base.util.StringUtil@substringBeforeLast(nodePath,
"%")}' and proc_inst_id_=#{procInstId,jdbcType=VARCHAR} and node_path_
like
#{nodePath}
insert into bpm_exe_stack
(
)
select
from bpm_exe_stack_his
WHERE
proc_inst_id_=#{procInstId,jdbcType=VARCHAR}
DELETE FROM bpm_exe_stack_his
WHERE
proc_inst_id_=#{procInstId,jdbcType=VARCHAR}
#{parentId}
]]>
DELETE FROM bpm_task
WHERE proc_inst_id_=#{procInstId,jdbcType=VARCHAR} and node_id_ in
#{nodeId}
DELETE FROM bpm_task_candidate where task_id_ in
(select id_ from bpm_task
WHERE proc_inst_id_=#{procInstId,jdbcType=VARCHAR} and node_id_ in
#{nodeId}
)
DELETE FROM bpm_pro_status where
proc_inst_id_=#{procInstId,jdbcType=VARCHAR} and node_id_ in
(select
node_id_ FROM bpm_exe_stack
WHERE
proc_inst_id_=#{procInstId,jdbcType=VARCHAR} and node_path_ like
#{nodePath})
insert into bpm_exe_stack_relation_his
(
)
select
from bpm_exe_stack_relation
where to_stack_id_ in
(SELECT id_ from
bpm_exe_stack where node_path_ !=
'${@com.artfess.base.util.StringUtil@substringBeforeLast(nodePath,
"%")}' and
proc_inst_id_=#{procInstId,jdbcType=VARCHAR} and
node_path_
like
#{nodePath}
)
or from_stack_id_ in
(SELECT id_ from
bpm_exe_stack where
proc_inst_id_=#{procInstId,jdbcType=VARCHAR} and
node_path_ like
#{nodePath}
)
insert into bpm_exe_stack_relation
(
)
select
from bpm_exe_stack_relation_his
where
proc_inst_id_=#{procInstId,jdbcType=VARCHAR}
DELETE FROM bpm_exe_stack_relation_his where
proc_inst_id_=#{procInstId,jdbcType=VARCHAR}
ID_
and ID_ not in (#{notIncludeExecuteIds,jdbcType=VARCHAR})
]]>
update bpm_exe_stack set target_node_='' WHERE
proc_inst_id_=#{procInstId,jdbcType=VARCHAR} and target_node_ =
#{targetNode,jdbcType=VARCHAR}
PROC_INST_ID_ and PROC_INST_ID_=#{actProcInstanceId,jdbcType=VARCHAR}
]]>
update bpm_exe_stack_executor set task_id_= #{newTaskId} WHERE task_id_= #{oldTaskId}