2023-09-11

king

2023-09-11 f6dbdd98a13296455b8efc5dadd6e9e4eaa63693

 src/templates/zshare/verifycard/customscript/index.jsx

@@ -45,7 +45,7 @@
  }

  handleConfirm = () => {
    const { type } = this.props
    const { type, workFlow } = this.props
    const { editItem, skip } = this.state
    // 表单提交时检查输入值是否正确
    this.props.form.validateFieldsAndScroll((err, values) => {
@@ -198,6 +198,13 @@
        param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
        param.LText = param.LText.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|typename)@/ig, `'${param.timestamp}'`)

        if (window.GLOB.process && workFlow === 'true') {
          param.LText = param.LText.replace(/@works_flow_code@/ig, `'${param.timestamp}'`)
          param.LText = param.LText.replace(/@works_flow_name@/ig, `'${param.timestamp}'`)
          param.LText = param.LText.replace(/@works_flow_param@/ig, `'${param.timestamp}'`)
          param.LText = param.LText.replace(/@works_flow_detail_id@/ig, `'${param.timestamp}'`)
        }

        console.info(`/* sql 验证 */\n${param.LText.replace(/\n\s{6,20}/ig, '\n')}`)

        param.LText = param.LText.replace(/\n/g, ' ')
@@ -251,7 +258,7 @@
  }

  selectScript = (value, option) => {
    // const { flowType } = this.props
    const { flowType } = this.props

    if (!value || !option) return

@@ -266,8 +273,16 @@
    }

    if (value === 'flowSql') {
      if (flowType === 'start') {
      value = `insert into s_my_works_flow ( works_flow_id,works_flow_code,works_flow_param,work_group,works_flow_detail_id,work_grade,bid,createuserid,CreateUser,CreateStaff)
      select @ID@,'流程编码','下一步要用到的参数串','职员分组','流程节点id','职员等级',@bid@,@UserID@,@UserName,@FullName`
        select @ID@,@works_flow_code@,@works_flow_param@,'职员分组',@works_flow_detail_id@,'职员等级',@bid@,@UserID@,@UserName,@FullName
        insert into s_my_works_flow_log (works_flow_id,works_flow_code,works_flow_name,status,statuscharone,statuschartwo,StatusCharThree,StatusCharFour,StatusCharFive,statusname,remark,CreateUserID,CreateUser,CreateStaff,works_flow_detail_id,sort,upid,work_group,work_grade,typecharone,deleted,statusname_suc,statusname_back )`
      } else {
        value = `insert into s_my_works_flow (works_flow_id,works_flow_code,works_flow_param,work_group,works_flow_detail_id,work_grade,bid,createuserid,CreateUser,CreateStaff)
        select @ID@,@works_flow_code@,@works_flow_param@,'职员分组',@works_flow_detail_id@,'职员等级',@bid@,@UserID@,@UserName,@FullName`
      }

      value = value.replace(/\n\s{8}/g, '\n')
    }

    _sql = _sql.replace(/\s{6}$/, '')