5 lines
3.3 KiB
SQL
5 lines
3.3 KiB
SQL
--付款申请app发起，web取消数据丢失
|
||
delete from flow_model where flowno='FundPaymentCarFlow' and phaseno='0010'
|
||
-- INSERT INTO flow_model VALUES ('FundPaymentCarFlow', '0010', '1010', '经销商发起', NULL, NULL, '!基础操作.合同信息正式到临时(#ObjectNo)+!基础操作.放款申请导表(#ObjectNo)+!基础操作.商务条件合同层到临时表(#ObjectNo)', '{#UserID}', NULL, 'commroute', NULL, '[{usertype:\"指定角色\",userinfo:\"401,经销商业务人员\"}]', '#PhaseOpinion1', 'closePage,doSubmit,signOpinion', NULL, 'all_except', NULL, NULL, NULL, '01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 366, 141, '100', '50', '1', NULL, 'TASK', NULL, 'N', 'N', 'FundPaymentCarFlow010', 'TreeView.addLastNodeByCode(\"11268\");\r\nTreeView.updateNodeSetReadOnly(\"商务条件\",\"ReadOnly\");\r\nTreeView.addBeforeNodeByCode(\"合同列表\",\"11532\");\r\nTreeView.updateNodeSetReadOnly(\"扣款卡信息\",\"ReadOnly\");\r\nTreeView.deleteNode(\"扣款卡信息详情\");', 'TreeView.addProductCheckByCode(\'11090_x\');', 'backnextstep', NULL, NULL, 'TreeView.addDeleteCallBackSql(\"jbo.app.tenwa.calc.LC_FUND_INCOME_TEMP\",\"delete from o where o.flowunid=:FlowUnid\");', NULL, 'Y', '订单初审(0020)', NULL, NULL, NULL, NULL, NULL);
|
||
insert into `flow_model` (`flowno`, `phaseno`, `phasetype`, `phasename`, `phasedescribe`, `phaseattribute`, `prescript`, `initscript`, `choicedescribe`, `choicescript`, `actiondescribe`, `actionscript`, `postscript`, `attribute1`, `attribute2`, `attribute3`, `attribute4`, `attribute5`, `attribute6`, `attribute7`, `attribute8`, `attribute9`, `attribute10`, `aaenabled`, `aapointinitscript`, `aapointcomp`, `aapointcompurl`, `standardtime1`, `standardtime2`, `costlob`, `strips`, `checklist`, `decisionscript`, `riskscanrule`, `buttonset2`, `inputuser`, `inputtime`, `updateuser`, `updatetime`, `distributerule`, `id`, `type`, `name`, `xcoordinate`, `ycoordinate`, `width`, `height`, `version`, `swimlane`, `nodetype`, `flowphasecontext`, `OPINIONSREQUIRED`, `isreadonly`, `flowpageconfig`, `flowprocessclass`, `flowpagecheck`, `backstepnexttype`, `backsteps`, `backscript`, `deletescript`, `phasescript`, `loadproductcheck`, `nextsteps`, `flowtiptype`, `remindnoticttype`, `flowoverdate`, `overnoticetype`, `overnoticeUser`) values('FundPaymentCarFlow','0010','1010','经销商发起',NULL,NULL,'!基础操作.合同信息正式到临时(#ObjectNo)+!基础操作.放款申请导表(#ObjectNo)+!基础操作.商务条件合同层到临时表(#ObjectNo)','{#UserID}',NULL,'commroute',NULL,'[{usertype:\"指定角色\",userinfo:\"401,经销商业务人员\"}]','#PhaseOpinion1','closePage,doSubmit,signOpinion',NULL,'all_except',NULL,NULL,NULL,'01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'366','141','100','50','1',NULL,'TASK',NULL,'N','N','FundPaymentCarFlow010','TreeView.addLastNodeByCode(\"11268\");\r\nTreeView.updateNodeSetReadOnly(\"商务条件\",\"ReadOnly\");\r\nTreeView.addBeforeNodeByCode(\"合同列表\",\"11532\");\r\nTreeView.updateNodeSetReadOnly(\"扣款卡信息\",\"ReadOnly\");\r\nTreeView.deleteNode(\"扣款卡信息详情\");','TreeView.addProductCheckByCode(\'11090_x\');','backnextstep',NULL,NULL,'TreeView.addDeleteCallBackSql(\"jbo.app.tenwa.calc.LC_FUND_INCOME_TEMP\",\"delete from o where o.flowunid=:FlowUnid\");',NULL,'Y','订单初审(0020)',NULL,NULL,NULL,NULL,NULL);
|
||
commit; |