【泛微OA-JS】批量设置节点选项

--关闭转发 是否允许待办事宜转发,是否等待被转发人意见,被转发人是否可转发,被转发人是否可转发,提交后被转发人是否可提交意见,是否允许已办及办结事宜转发,允许已办事宜转发

update workflow_flownode set IsPendingForward=0,IsWaitForwardOpinion=0,IsBeForward=0,IsSubmitedOpinion=0,IsSubmitForward=0,IsBeForwardSubmit=0,IsAlreadyForward=0;

--开启转办

update workflow_flownode set IsHandleForward=1;

--开启退回  是否流程退回提醒,退回方式,退回后再提交直达本节点

update workflow_flownode set isRejectRemind=1,isSelectRejectNode=1,isSubmitDirectNode=0;

--retract 强制收回 0不可收回 1查看前收回 2查看后收回

--pigeonhole 强制归档

merge into workflow_function_manage x

using (select a.id,c.id as workflowid from workflow_nodebase a

inner join workflow_flownode b on a.id=b.nodeid

inner join workflow_base c on b.workflowid=c.id

where c.isvalid=1) y

on(x.workflowid=y.workflowid and x.operatortype=y.id)

when matched then update set x.retract=2,x.pigeonhole=0

when  not matched then insert (workflowid,retract,pigeonhole,operatortype)values(y.workflowid,2,0,y.id);

--归档节点设置为不可收回

merge into workflow_function_manage x

using (select a.id,c.id as workflowid from workflow_nodebase a

inner join workflow_flownode b on a.id=b.nodeid

inner join workflow_base c on b.workflowid=c.id

where c.isvalid=1 and a.isend=1) y

on(x.workflowid=y.workflowid and x.operatortype=y.id)

when matched then update set x.retract=0,x.pigeonhole=0;

--自由节点设置为不可收回

update workflow_function_manage set pigeonhole=0 where operatortype=-9;

--isoverrb 允许强制收回

--isoveriv 允许流程干预

update workflow_base set isoverrb='' , isoveriv='1' where isvalid=1;