4.3.4 流程结束事件

当某个动作结束,跳转到下一个流程状态时,系统会触发流程结束事件,我们可以在这里增加一些业务处理方法,常用的有三种方法:

  1. 新增表单数据

    通过表单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"
     }]
    
  2. 数据更新 只能更新当前流程所在的主表栏位

     [{
         "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"
     }]
    
  3. 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"
     }]
    
  4. 标签调用
    [ {
         "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 当前数据库开启的事务

results matching ""

    No results matching ""