4.3.4 流程结束事件
当某个动作结束,跳转到下一个流程状态时,系统会触发流程结束事件,我们可以在这里增加一些业务处理方法,常用的有三种方法:
新增表单数据
通过表单ID方式新增/更新
[{ "8001": { "GUID": "@REPORTLOG.ID", "STATE": "申请中", "CREATOR": "@REPORTLOG.EMPLOYEENAME", "CREATEDATE": "@REPORTLOG.REPORTDATE", "LOCATION": "@FORMTABLE.LOCATION", "CEA": "@FORMTABLE.CEA", "TEXT": "@FORMTABLE.TEXT", "APPLYINFO": "@FORMREPORT.SYS_REPORTNOTE" } }]通过表名新增/更新
[{ "GIS_PROJECT": { "GUID": "@REPORTLOG.ID", "STATE": "申请中", "CREATOR": "@REPORTLOG.EMPLOYEENAME", "CREATEDATE": "@REPORTLOG.REPORTDATE", "LOCATION": "@FORMTABLE.LOCATION", "CEA": "@FORMTABLE.CEA", "TEXT": "@FORMTABLE.TEXT", "APPLYINFO": "@FORMREPORT.SYS_REPORTNOTE" } }]条件新增/更新
[{ "TableID":"1130", "Fields":{ "STATE": "已派单", "BUSITYPE":"改管", "USERID": "@FORMTABLE.USERID", "TEXT":"@FORMTABLE.TEXT", "LOCATION": "@FORMTABLE.LOCATION", "YUYUESHIJIAN":"@FORMREPORT.YUYUESHIJIAN", "KANCHADAN":"@LASTREPORTLOG[130301].ID", "WFPREVSTEP":"@FORMTABLE.GUID" }, "Condition":"@FORMREPORT.EXECUTOR != \"\"", "Type": "Table" }]数据更新 只能更新当前流程所在的主表栏位
[{ "FormTable": { "STATE": "验收合格" }, "Condition": "@FORMREPORT.YANSHOUJIEGUO==\"合格\"", "Type": "FormTable" }, { "FormTable": { "STATE": "验收不合格" }, "Condition": "@FORMREPORT.YANSHOUJIEGUO==\"不合格\"", "Type": "FormTable" }]只能更新当前流程所在的计划表栏位
[{ "PlanTable": { "PLAN_STATE": "验收合格" }, "Condition": "@FORMREPORT.YANSHOUJIEGUO==\"合格\"", "Type": "PlanTable" }, { "PlanTable": { " PLAN_STATE": "验收不合格" }, "Condition": "@FORMREPORT.YANSHOUJIEGUO==\"不合格\"", "Type": "PlanTable" }]- sql命令调用
[{ "SQL": "UPDATE PROJECT SET STATE='已初验',MODIFYDATE=SYSDATE WHERE CEA='@FORMTABLE.CEA'", "Condition": "@FORMREPORT.CANAPT==\"审批通过\"", "Type": "Sql" }, { "SQL": "UPDATE PROJECT SET STATE='施工中',MODIFYDATE=SYSDATE WHERE CEA='@FORMTABLE.CEA'", "Condition": "@FORMREPORT.CANAPT==\"审批不通过\"", "Type": "Sql" }] - 标签调用
[ { "Label": { "name": "TCIS燃气具维修数据回写", "FEETYPE": "GS005", "BUSIREPORT": "11306", "Async" : "false" }, "Type": "Label" }]
配置参数说明
| 参数 | 说明 | 备注 |
|---|---|---|
| Condition | 条件满足时执行 | javascript 表达式 |
| Type | 类型 | Table,FormTable,PlanTable,Sql,Label |
| Async | 同步或异步执行。同步执行有错误立刻终止,异步有错误也继续执行 | true,false |
| @FORMTABLE | 存取主表单栏位数据 | CREATOR(创建人), CREATEDATE(创建时间), MODIFYDATE(修改时间) |
| @FORMREPORT | 存取检查表表单栏位数据 | |
| @REPORTLOG | 存取操作日志数据 | ID(日志ID),EMPLOYEENAME(填报人),REPORTDATE(填报时间),STATUSNAME(操作名称) |
标签参数说明
| 参数 | 说明 | 备注 |
|---|---|---|
| Params.tabledata | 主表的数据 | |
| Params.reportdata | 检查表的数据 | |
| Params.reportlog | 操作的日志 | |
| Params.trans | 当前数据库开启的事务 |