~jinfei/pc-plat.git

parent: cd93388b | 补丁 | 提交 | ignore whitespace

2024-02-20

king

2024-02-20 12d591d4ed4880ee87bdda444424b9acaa73d9f7

2024-02-20

17个文件已修改

	src/api/index.js	11 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/menu/components/search/main-search/index.jsx	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/menu/components/share/searchcomponent/index.jsx	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/menu/components/table/edit-table/columns/editColumn/index.jsx	8 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/menu/components/table/edit-table/columns/tableIn/customscript/index.jsx	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/menu/datasource/verifycard/utils.jsx	61 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/menu/debug/index.jsx	76 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/mob/searchconfig/index.jsx	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/templates/sharecomponent/actioncomponent/verifyexcelout/utils.jsx	23 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/templates/sharecomponent/actioncomponent/verifyprint/utils.jsx	30 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/templates/sharecomponent/searchcomponent/index.jsx	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/templates/zshare/modalform/index.jsx	8 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/templates/zshare/verifycard/callbackcustomscript/index.jsx	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/templates/zshare/verifycard/customform/index.jsx	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/templates/zshare/verifycard/customscript/index.jsx	30 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	src/templates/zshare/verifycard/index.jsx	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 src/api/index.js

@@ -1080,8 +1080,15 @@
      appkey: window.GLOB.appkey || ''
    }

    let id = Utils.getuuid()
    sql = sql.replace(/@time_id@/ig, `'${id}'`)
    sql = sql.replace(/@time_id@/ig, `'${Utils.getuuid()}'`)
    sql = sql.replace(/@ID@/ig, `'${Utils.getuuid()}'`)
    sql = sql.replace(/@BID@/ig, `'${Utils.getuuid()}'`)
    sql = sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID')}'`)
    sql = sql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid')}'`)
    sql = sql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID')}'`)
    sql = sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey}'`)
    // sql = sql.replace(/@datam@/ig, `''`)

    if (window.GLOB.externalDatabase !== null) {
      sql = sql.replace(/@db@/ig, window.GLOB.externalDatabase)
    }

 src/menu/components/search/main-search/index.jsx

@@ -256,7 +256,7 @@
        })

        let sql = res.dataSource
        sql = sql.replace(/@\$|\$@/ig, '').replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id)@/ig, `'1949-10-01 15:00:00'`)
        sql = sql.replace(/@\$|\$@/ig, '')

        let rduri = ''
        if (window.GLOB.mainSystemApi && res.database === 'sso') {

 src/menu/components/share/searchcomponent/index.jsx

@@ -203,7 +203,7 @@
        })

        let sql = res.dataSource
        sql = sql.replace(/@\$|\$@/ig, '').replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id)@/ig, `'1949-10-01 15:00:00'`)
        sql = sql.replace(/@\$|\$@/ig, '')

        let rduri = ''
        if (window.GLOB.mainSystemApi && res.database === 'sso') {

 src/menu/components/table/edit-table/columns/editColumn/index.jsx

@@ -555,7 +555,7 @@
          ${_option.sql}`
  
          // LoginUID|SessionUid|UserID|Appkey 已替换
          sql = sql.replace(/@\$|\$@/ig, '').replace(/@(BID|ID|time_id)@/ig, `'1949-10-01 15:00:00'`)
          sql = sql.replace(/@\$|\$@/ig, '')
  
          let rduri = ''
          if (window.GLOB.mainSystemApi && values.database === 'sso') {
@@ -612,11 +612,7 @@
          sql = `declare @mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20)
            ${sql}`

          sql = sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, '\'\'')
          sql = sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`)
          sql = sql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') || ''}'`)
          sql = sql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') || ''}'`)
          sql = sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey || ''}'`)
          sql = sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, `''`)

          Api.sDebug(sql).then(result => {
            if (result.status || result.ErrCode === '-2') {

 src/menu/components/table/edit-table/columns/tableIn/customscript/index.jsx

@@ -151,7 +151,7 @@

        let sql = this.state.verifySql + _initCustomScript + _prevCustomScript + _backCustomScript + tail
        
        sql = sql.replace(/@\$|\$@/ig, '').replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id)@/ig, `'1949-10-01 15:00:00'`)
        sql = sql.replace(/@\$|\$@/ig, '')

        if (skip) {
          this.setState({

 src/menu/datasource/verifycard/utils.jsx

@@ -49,43 +49,56 @@
      })
    }

    _dataresource = _dataresource.replace(/@(BID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|upid|typename)@/ig, `'1949-10-01 15:00:00'`)
    _customScript = _customScript.replace(/@(BID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|upid|typename)@/ig, `'1949-10-01 15:00:00'`)
    _tailScript = _tailScript.replace(/@(BID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|upid|typename)@/ig, `'1949-10-01 15:00:00'`)
    let getuuid = () => {
      let uuid = []
      let timestamp = new Date().getTime()
      let _options = '0123456789abcdefghigklmnopqrstuv'
      for (let i = 0; i < 19; i++) {
        uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
      }
      uuid = timestamp + uuid.join('')
      return uuid
    }

    _dataresource = _dataresource.replace(/@\$|\$@/ig, '')
    _customScript = _customScript.replace(/@\$|\$@/ig, '')
    _tailScript = _tailScript.replace(/@\$|\$@/ig, '')
    let regs = [
      {reg: /@time_id@/ig, value: `'${getuuid()}'`},
      {reg: /@BID@/ig, value: `'${getuuid()}'`},
      {reg: /@upid@/ig, value: `'${getuuid()}'`},
      {reg: /@typename@/ig, value: `'debug'`},
      {reg: /@datam@/ig, value: `''`},
      {reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID')}'`},
      {reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid')}'`},
      {reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID')}'`},
      {reg: /@Appkey@/ig, value: `'${window.GLOB.appkey}'`},
      {reg: /@\$|\$@/ig, value: ''},
      {reg: /@select\$|\$select@/ig, value: ''},
      {reg: /@sum\$|\$sum@/ig, value: ''},
    ]

    if (window.GLOB.process) {
      _dataresource = _dataresource.replace(/@works_flow_code@/ig, `'1949-10-01 15:00:00'`)
      _customScript = _customScript.replace(/@works_flow_code@/ig, `'1949-10-01 15:00:00'`)
      _tailScript = _tailScript.replace(/@works_flow_code@/ig, `'1949-10-01 15:00:00'`)
      regs.push({reg: /@works_flow_code@/ig, value: `'${getuuid()}'`})
    }

    _dataresource = _dataresource.replace(/@select\$|\$select@/ig, '')
    _customScript = _customScript.replace(/@select\$|\$select@/ig, '')
    _customScript = _customScript.replace(/@sum\$|\$sum@/ig, '')
    _dataresource = _dataresource.replace(/\$sum@/ig, '/*')
    _dataresource = _dataresource.replace(/@sum\$/ig, '*/')

    if (type === 'calendar') {
      _dataresource = _dataresource.replace(/@mk_year@/ig, '')
      _customScript = _customScript.replace(/@mk_year@/ig, '')
      regs.push({reg: /@mk_year@/ig, value: '2024'})
    }

    // 外联数据库替换
    if (window.GLOB.externalDatabase !== null) {
      regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase})
    }

    regs.forEach(item => {
      _dataresource = _dataresource.replace(item.reg, item.value)
      _customScript = _customScript.replace(item.reg, item.value)
      _tailScript = _tailScript.replace(item.reg, item.value)
    })

    if (_customScript) {
      _customScript = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100)
        select @ErrorCode='',@retmsg ='',@UserName='', @FullName='', @RoleID='', @mk_departmentcode='', @mk_organization='', @mk_user_type='', @mk_nation='', @mk_province='', @mk_city='', @mk_district='', @mk_address=''
        ${_customScript}
      `
    }

    // 外联数据库替换
    if (window.GLOB.externalDatabase !== null) {
      _dataresource = _dataresource.replace(/@db@/ig, window.GLOB.externalDatabase)
      _customScript = _customScript.replace(/@db@/ig, window.GLOB.externalDatabase)
      _tailScript = _tailScript.replace(/@db@/ig, window.GLOB.externalDatabase)
    }

    if (window.GLOB.urlFields) {

 src/menu/debug/index.jsx

@@ -74,13 +74,7 @@
      { reg: /@\$/ig, value: '' },
      { reg: /@datam@/ig, value: `''` },
    ]
    
    if (window.GLOB.externalDatabase !== null) {
      regs.push({
        reg: /@db@/ig,
        value: window.GLOB.externalDatabase
      })
    }

    if (config.urlFields) {
      config.urlFields.forEach(field => {
        regs.push({
@@ -423,12 +417,6 @@
              aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
          }

          backSql = backSql.replace(/@ID@/ig, `'id'`)
          backSql = backSql.replace(/@BID@/ig, `'bid'`)
          backSql = backSql.replace(/@LoginUID@/ig, `'LoginUID'`)
          backSql = backSql.replace(/@SessionUid@/ig, `'SessionUid'`)
          backSql = backSql.replace(/@UserID@/ig, `'UserID'`)
          backSql = backSql.replace(/@Appkey@/ig, `'appkey'`)
          backSql = backSql.replace(/@typename@/ig, `'typename'`)
          backSql = backSql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, `''`)
        }
@@ -462,13 +450,6 @@
          { reg: /@\$/ig, value: '' },
          { reg: /@datam@/ig, value: `''` },
        ]
        
        if (window.GLOB.externalDatabase !== null) {
          regs.push({
            reg: /@db@/ig,
            value: window.GLOB.externalDatabase
          })
        }
    
        if (process) {
          regs.push({ reg: /@works_flow_code@/ig, value: `'1949-10-01 15:00:00'` })
@@ -566,8 +547,8 @@
  }

  getSysDefaultSql = (btn, component, process, group, retmsg) => {
    let primaryId = 'id'
    let BID = 'bid'
    let primaryId = Utils.getuuid()
    let BID = Utils.getuuid()
    let verify = btn.verify || {}
    let _actionType = null
    let setting = component.setting
@@ -1344,10 +1325,6 @@
  
    _sql = _sql.replace(/@ID@/ig, `'${primaryId || ''}'`)
    _sql = _sql.replace(/@BID@/ig, `'${BID}'`)
    _sql = _sql.replace(/@LoginUID@/ig, `'LoginUID'`)
    _sql = _sql.replace(/@SessionUid@/ig, `'SessionUid'`)
    _sql = _sql.replace(/@UserID@/ig, `'UserID'`)
    _sql = _sql.replace(/@Appkey@/ig, `'appkey'`)
    _sql = _sql.replace(/@typename@/ig, `'typename'`)
    _sql = _sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, `''`)
  
@@ -1377,19 +1354,8 @@
    let sheet = _sheet.replace(/(.*)\.(.*)\./ig, '')
    
    database = database ? (database[0] || '') : ''
  
    let getuuid = () => {
      let uuid = []
      let timestamp = new Date().getTime()
      let _options = '0123456789abcdefghigklmnopqrstuv'
      for (let i = 0; i < 19; i++) {
        uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
      }
      uuid = timestamp + uuid.join('')
      return uuid
    }

    let upId = getuuid()
    let upId = Utils.getuuid()
  
    let vals = []
    btn.columns.forEach(col => {
@@ -1433,21 +1399,11 @@
      {reg: new RegExp('(^|\\s)@' + sheet + '(\\s|$)', 'ig'), value: ` #${sheet} `},
      {reg: new RegExp('(^|\\s)@' + sheet + '\\(', 'ig'), value: ` #${sheet}(`},
      {reg: new RegExp('(^|\\s)@' + sheet + '\\)', 'ig'), value: ` #${sheet})`},
      {reg: /@ID@/ig, value: `'id'`},
      {reg: /@BID@/ig, value: `'bid'`},
      {reg: /@LoginUID@/ig, value: `'LoginUID'`},
      {reg: /@SessionUid@/ig, value: `'SessionUid'`},
      {reg: /@UserID@/ig, value: `'UserID'`},
      {reg: /@Appkey@/ig, value: `'appkey'`},
      {reg: /@typename@/ig, value: `'admin'`},
      {reg: /\$@/ig, value: ''},
      {reg: /@\$/ig, value: ''},
      {reg: /@datam@/ig, value: `''`},
    ]

    if (window.GLOB.externalDatabase !== null) {
      regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase})
    }

    btn.scripts && btn.scripts.forEach(script => {
      if (script.status === 'false') return
@@ -1635,20 +1591,11 @@
      {reg: new RegExp('(^|\\s)@' + sheet + '(\\s|$)', 'ig'), value: ` #${sheet} `},
      {reg: new RegExp('(^|\\s)@' + sheet + '\\(', 'ig'), value: ` #${sheet}(`},
      {reg: new RegExp('(^|\\s)@' + sheet + '\\)', 'ig'), value: ` #${sheet})`},
      {reg: /@BID@/ig, value: `'${BID}'`},
      {reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID') || ''}'`},
      {reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid') || ''}'`},
      {reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID') || ''}'`},
      {reg: /@Appkey@/ig, value: `'${window.GLOB.appkey || ''}'`},
      {reg: /@typename@/ig, value: `'admin'`},
      {reg: /\$@/ig, value: isDM ? '/*' : ''},
      {reg: /@\$/ig, value: isDM ? '*/' : ''},
      {reg: /@datam@/ig, value: isDM ? `'Y'` : `''`},
    ]

    if (window.GLOB.externalDatabase !== null) {
      regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase})
    }

    btn.scripts && btn.scripts.forEach(script => {
      if (script.status === 'false') return
@@ -1792,13 +1739,6 @@
      { reg: /@\$/ig, value: '' },
      { reg: /@datam@/ig, value: `''` },
    ]
    
    if (window.GLOB.externalDatabase !== null) {
      regs.push({
        reg: /@db@/ig,
        value: window.GLOB.externalDatabase
      })
    }

    let sql = this.formatDataSource(item, regs)

@@ -1914,17 +1854,11 @@
      { reg: /@orderBy@/ig, value: item.setting.order || '' },
      { reg: /@pageSize@/ig, value: 9999 },
      { reg: /@pageIndex@/ig, value: 1},
      { reg: /@ID@/ig, value: `''`},
      { reg: /@BID@/ig, value: `''`},
      { reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID') || ''}'`},
      { reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid') || ''}'`},
      { reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID') || ''}'`},
      { reg: /@Appkey@/ig, value: `'${window.GLOB.appkey || ''}'`},
      { reg: /@typename@/ig, value: `'admin'`},
    )

    if (item.type === 'calendar') {
      regoptions.push({ reg: /@mk_year@/ig, value: '2023' })
      regoptions.push({ reg: /@mk_year@/ig, value: '2024' })
    }

    regoptions.forEach(cell => {

 src/mob/searchconfig/index.jsx

@@ -229,7 +229,7 @@
        })

        let sql = res.dataSource
        sql = sql.replace(/@\$|\$@/ig, '').replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id)@/ig, `'1949-10-01 15:00:00'`)
        sql = sql.replace(/@\$|\$@/ig, '')
        
        let rduri = ''
        if (window.GLOB.mainSystemApi && res.database === 'sso') {

 src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx

@@ -167,7 +167,7 @@
        }

        let sql = this.state.verifySql + _initCustomScript + _prevCustomScript + _backCustomScript + tail
        sql = sql.replace(/@\$|\$@/ig, '').replace(/\$check@|@check\$/ig, '').replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|typename)@/ig, `'1949-10-01 15:00:00'`)
        sql = sql.replace(/@\$|\$@/ig, '').replace(/\$check@|@check\$/ig, '').replace(/@datam@/ig, `''`).replace(/@typename@/ig, `'debug'`)
        
        if (skip) {
          this.setState({

 src/templates/sharecomponent/actioncomponent/verifyexcelout/utils.jsx

@@ -49,20 +49,6 @@
    if (/\s/.test(_dataresource)) {
      _dataresource = '(' + _dataresource + ') tb'
    }
    
    _dataresource = _dataresource.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|typename)@/ig, `'1949-10-01 15:00:00'`)
    _customScript = _customScript.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|typename)@/ig, `'1949-10-01 15:00:00'`)
    _tailScript = _tailScript.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|typename)@/ig, `'1949-10-01 15:00:00'`)
    _dataresource = _dataresource.replace(/@\$|\$@/ig, '')
    _customScript = _customScript.replace(/@\$|\$@/ig, '')
    _tailScript = _tailScript.replace(/@\$|\$@/ig, '')

    // 外联数据库替换
    if (window.GLOB.externalDatabase !== null) {
      _dataresource = _dataresource.replace(/@db@/ig, window.GLOB.externalDatabase)
      _customScript = _customScript.replace(/@db@/ig, window.GLOB.externalDatabase)
      _tailScript = _tailScript.replace(/@db@/ig, window.GLOB.externalDatabase)
    }

    let custompage = /@pageSize@|@orderBy@/i.test(_dataresource + _customScript)
    
@@ -76,6 +62,15 @@
    }, {
      reg: new RegExp('@pageIndex@', 'ig'),
      value: 1
    }, {
      reg: /@datam@/ig,
      value: `''`
    }, {
      reg: /@typename@/ig,
      value: `'debug'`
    }, {
      reg: /@\$|\$@/ig,
      value: ''
    })

    regoptions.forEach(item => {

 src/templates/sharecomponent/actioncomponent/verifyprint/utils.jsx

@@ -33,20 +33,24 @@
    if (/\s/.test(_dataresource)) {
      _dataresource = '(' + _dataresource + ') tb'
    }
    
    _dataresource = _dataresource.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|typename)@/ig, `'1949-10-01 15:00:00'`)
    _customScript = _customScript.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|typename)@/ig, `'1949-10-01 15:00:00'`)
    _tailScript = _tailScript.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|typename)@/ig, `'1949-10-01 15:00:00'`)
    _dataresource = _dataresource.replace(/@\$|\$@/ig, '')
    _customScript = _customScript.replace(/@\$|\$@/ig, '')
    _tailScript = _tailScript.replace(/@\$|\$@/ig, '')

    // 外联数据库替换
    if (window.GLOB.externalDatabase !== null) {
      _dataresource = _dataresource.replace(/@db@/ig, window.GLOB.externalDatabase)
      _customScript = _customScript.replace(/@db@/ig, window.GLOB.externalDatabase)
      _tailScript = _tailScript.replace(/@db@/ig, window.GLOB.externalDatabase)
    }
    // 正则替换
    let regoptions = [{
      reg: /@datam@/ig,
      value: `''`
    }, {
      reg: /@typename@/ig,
      value: `'debug'`
    }, {
      reg: /@\$|\$@/ig,
      value: ''
    }]

    regoptions.forEach(item => {
      _dataresource = _dataresource.replace(item.reg, item.value)
      _customScript = _customScript.replace(item.reg, item.value)
      _tailScript = _tailScript.replace(item.reg, item.value)
    })

    let arr_field = columns.map(col => col.field)
    arr_field = arr_field.join(',')

 src/templates/sharecomponent/searchcomponent/index.jsx

@@ -210,7 +210,7 @@
        })

        let sql = res.dataSource
        sql = sql.replace(/@\$|\$@/ig, '').replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id)@/ig, `'1949-10-01 15:00:00'`)
        sql = sql.replace(/@\$|\$@/ig, '')

        let rduri = ''
        if (window.GLOB.mainSystemApi && res.database === 'sso') {

 src/templates/zshare/modalform/index.jsx

@@ -1096,7 +1096,7 @@
            ${_option.sql}`
    
            // LoginUID|SessionUid|UserID|Appkey 已替换
            sql = sql.replace(/@\$|\$@/ig, '').replace(/@(BID|ID|time_id)@/ig, `'1949-10-01 15:00:00'`)
            sql = sql.replace(/@\$|\$@/ig, '')
    
            let rduri = ''
            if (window.GLOB.mainSystemApi && values.database === 'sso') {
@@ -1153,11 +1153,7 @@
            sql = `declare @mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20)
              ${sql}`
  
            sql = sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, '\'\'')
            sql = sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`)
            sql = sql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') || ''}'`)
            sql = sql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') || ''}'`)
            sql = sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey || ''}'`)
            sql = sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, `''`)
  
            resolve({values, loading: true, promise: () => new Promise((resolve, reject) => {
              Api.sDebug(sql).then(result => {

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

@@ -115,7 +115,7 @@

        // 数据权限
        sql = sql.replace(/@\$|\$@/ig, '').replace(/\$check@|@check\$/ig, '')
        sql = sql.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|typename)@/ig, `'1949-10-01 15:00:00'`)
        sql = sql.replace(/@typename@/ig, `'debug'`)
        
        if (skip) {
          this.setState({

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

@@ -84,7 +84,6 @@
        
        // 数据权限
        sql = sql.replace(/@\$|\$@/ig, '')
        sql = sql.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id)@/ig, `'1949-10-01 15:00:00'`)
        
        this.setState({loading: true})
        Api.sDebug(sql).then(res => {

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

@@ -11,13 +11,14 @@
class CustomForm extends Component {
  static propTpyes = {
    type: PropTypes.any,
    btn: PropTypes.object,          // 按钮信息
    usefulfields: PropTypes.string, // 可用字段
    initsql: PropTypes.string,      // sql前缀
    defaultsql: PropTypes.array,    // 默认sql
    systemScripts: PropTypes.array, // 系统脚本
    customScripts: PropTypes.array, // 自定义脚本
    scriptsChange: PropTypes.func   // 表单
    btn: PropTypes.object,
    usefulfields: PropTypes.string,
    initsql: PropTypes.string,
    defaultsql: PropTypes.string,
    useDefaultSql: PropTypes.any,
    systemScripts: PropTypes.array,
    customScripts: PropTypes.array,
    scriptsChange: PropTypes.func
  }

  state = {
@@ -44,7 +45,7 @@
  }

  handleConfirm = () => {
    const { type, workFlow, flowType } = this.props
    const { type, workFlow, flowType, useDefaultSql, defaultsql } = this.props
    const { editItem, skip } = this.state
    // 表单提交时检查输入值是否正确
    this.props.form.validateFieldsAndScroll((err, values) => {
@@ -126,7 +127,15 @@
          }
        }

        let sql = this.props.initsql + _initCustomScript + _prevCustomScript + _backCustomScript + tail
        let sql = this.props.initsql + _initCustomScript + _prevCustomScript

        if (useDefaultSql) {
          sql += `\n/* 默认sql */
            ${defaultsql}
          `
        }

        sql += _backCustomScript + tail

        if (window.GLOB.funcs && window.GLOB.funcs.length > 0) {
          window.GLOB.funcs.forEach(item => {
@@ -137,7 +146,8 @@

        // 数据权限
        sql = sql.replace(/@\$|\$@/ig, '').replace(/\$check@|@check\$/ig, '')
        sql = sql.replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|typename)@/ig, `'1949-10-01 15:00:00'`)
        sql = sql.replace(/@datam@/ig, `''`)
        sql = sql.replace(/@typename@/ig, `'debug'`)

        if (window.GLOB.process && workFlow === 'true') {
          sql = sql.replace(/@works_flow_code@/ig, `'works_flow_code'`)

 src/templates/zshare/verifycard/index.jsx

@@ -1776,6 +1776,7 @@
                btn={this.props.card}
                initsql={this.state.initsql}
                customScripts={verify.scripts}
                useDefaultSql={verify.default !== 'false'}
                defaultsql={this.state.defaultsql}
                usefulfields={this.state.usefulfields}
                systemScripts={this.state.systemScripts}
@@ -1789,6 +1790,7 @@
              workFlow={verify.workFlow}
              flowType={verify.flowType}
              customScripts={verify.scripts}
              useDefaultSql={verify.default !== 'false'}
              defaultsql={this.state.defaultsql}
              usefulfields={this.state.usefulfields}
              systemScripts={this.state.systemScripts}

			@@ -1080,8 +1080,15 @@
			appkey: window.GLOB.appkey \|\| ''
			}

			let id = Utils.getuuid()
			sql = sql.replace(/@time_id@/ig, `'${id}'`)
			sql = sql.replace(/@time_id@/ig, `'${Utils.getuuid()}'`)
			sql = sql.replace(/@ID@/ig, `'${Utils.getuuid()}'`)
			sql = sql.replace(/@BID@/ig, `'${Utils.getuuid()}'`)
			sql = sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID')}'`)
			sql = sql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid')}'`)
			sql = sql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID')}'`)
			sql = sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey}'`)
			// sql = sql.replace(/@datam@/ig, `''`)

			if (window.GLOB.externalDatabase !== null) {
			sql = sql.replace(/@db@/ig, window.GLOB.externalDatabase)
			}

			@@ -256,7 +256,7 @@
			})

			let sql = res.dataSource
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@\$\|\$@/ig, '')

			let rduri = ''
			if (window.GLOB.mainSystemApi && res.database === 'sso') {

			@@ -203,7 +203,7 @@
			})

			let sql = res.dataSource
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@\$\|\$@/ig, '')

			let rduri = ''
			if (window.GLOB.mainSystemApi && res.database === 'sso') {

			@@ -555,7 +555,7 @@
			${_option.sql}`

			// LoginUID\|SessionUid\|UserID\|Appkey 已替换
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@(BID\|ID\|time_id)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@\$\|\$@/ig, '')

			let rduri = ''
			if (window.GLOB.mainSystemApi && values.database === 'sso') {
			@@ -612,11 +612,7 @@
			sql = `declare @mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20)
			${sql}`

			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@datam@/ig, '\'\'')
			sql = sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') \|\| ''}'`)
			sql = sql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') \|\| ''}'`)
			sql = sql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') \|\| ''}'`)
			sql = sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey \|\| ''}'`)
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@datam@/ig, `''`)

			Api.sDebug(sql).then(result => {
			if (result.status \|\| result.ErrCode === '-2') {

			@@ -151,7 +151,7 @@

			let sql = this.state.verifySql + _initCustomScript + _prevCustomScript + _backCustomScript + tail

			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@\$\|\$@/ig, '')

			if (skip) {
			this.setState({

			@@ -49,43 +49,56 @@
			})
			}

			_dataresource = _dataresource.replace(/@(BID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|upid\|typename)@/ig, `'1949-10-01 15:00:00'`)
			_customScript = _customScript.replace(/@(BID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|upid\|typename)@/ig, `'1949-10-01 15:00:00'`)
			_tailScript = _tailScript.replace(/@(BID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|upid\|typename)@/ig, `'1949-10-01 15:00:00'`)
			let getuuid = () => {
			let uuid = []
			let timestamp = new Date().getTime()
			let _options = '0123456789abcdefghigklmnopqrstuv'
			for (let i = 0; i < 19; i++) {
			uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
			}
			uuid = timestamp + uuid.join('')
			return uuid
			}

			_dataresource = _dataresource.replace(/@\$\|\$@/ig, '')
			_customScript = _customScript.replace(/@\$\|\$@/ig, '')
			_tailScript = _tailScript.replace(/@\$\|\$@/ig, '')
			let regs = [
			{reg: /@time_id@/ig, value: `'${getuuid()}'`},
			{reg: /@BID@/ig, value: `'${getuuid()}'`},
			{reg: /@upid@/ig, value: `'${getuuid()}'`},
			{reg: /@typename@/ig, value: `'debug'`},
			{reg: /@datam@/ig, value: `''`},
			{reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID')}'`},
			{reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid')}'`},
			{reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID')}'`},
			{reg: /@Appkey@/ig, value: `'${window.GLOB.appkey}'`},
			{reg: /@\$\|\$@/ig, value: ''},
			{reg: /@select\$\|\$select@/ig, value: ''},
			{reg: /@sum\$\|\$sum@/ig, value: ''},
			]

			if (window.GLOB.process) {
			_dataresource = _dataresource.replace(/@works_flow_code@/ig, `'1949-10-01 15:00:00'`)
			_customScript = _customScript.replace(/@works_flow_code@/ig, `'1949-10-01 15:00:00'`)
			_tailScript = _tailScript.replace(/@works_flow_code@/ig, `'1949-10-01 15:00:00'`)
			regs.push({reg: /@works_flow_code@/ig, value: `'${getuuid()}'`})
			}

			_dataresource = _dataresource.replace(/@select\$\|\$select@/ig, '')
			_customScript = _customScript.replace(/@select\$\|\$select@/ig, '')
			_customScript = _customScript.replace(/@sum\$\|\$sum@/ig, '')
			_dataresource = _dataresource.replace(/\$sum@/ig, '/*')
			_dataresource = _dataresource.replace(/@sum\$/ig, '*/')

			if (type === 'calendar') {
			_dataresource = _dataresource.replace(/@mk_year@/ig, '')
			_customScript = _customScript.replace(/@mk_year@/ig, '')
			regs.push({reg: /@mk_year@/ig, value: '2024'})
			}

			// 外联数据库替换
			if (window.GLOB.externalDatabase !== null) {
			regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase})
			}

			regs.forEach(item => {
			_dataresource = _dataresource.replace(item.reg, item.value)
			_customScript = _customScript.replace(item.reg, item.value)
			_tailScript = _tailScript.replace(item.reg, item.value)
			})

			if (_customScript) {
			_customScript = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100)
			select @ErrorCode='',@retmsg ='',@UserName='', @FullName='', @RoleID='', @mk_departmentcode='', @mk_organization='', @mk_user_type='', @mk_nation='', @mk_province='', @mk_city='', @mk_district='', @mk_address=''
			${_customScript}
			`
			}

			// 外联数据库替换
			if (window.GLOB.externalDatabase !== null) {
			_dataresource = _dataresource.replace(/@db@/ig, window.GLOB.externalDatabase)
			_customScript = _customScript.replace(/@db@/ig, window.GLOB.externalDatabase)
			_tailScript = _tailScript.replace(/@db@/ig, window.GLOB.externalDatabase)
			}

			if (window.GLOB.urlFields) {

			@@ -74,13 +74,7 @@
			{ reg: /@\$/ig, value: '' },
			{ reg: /@datam@/ig, value: `''` },
			]

			if (window.GLOB.externalDatabase !== null) {
			regs.push({
			reg: /@db@/ig,
			value: window.GLOB.externalDatabase
			})
			}

			if (config.urlFields) {
			config.urlFields.forEach(field => {
			regs.push({
			@@ -423,12 +417,6 @@
			aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
			}

			backSql = backSql.replace(/@ID@/ig, `'id'`)
			backSql = backSql.replace(/@BID@/ig, `'bid'`)
			backSql = backSql.replace(/@LoginUID@/ig, `'LoginUID'`)
			backSql = backSql.replace(/@SessionUid@/ig, `'SessionUid'`)
			backSql = backSql.replace(/@UserID@/ig, `'UserID'`)
			backSql = backSql.replace(/@Appkey@/ig, `'appkey'`)
			backSql = backSql.replace(/@typename@/ig, `'typename'`)
			backSql = backSql.replace(/@\$\|\$@/ig, '').replace(/@datam@/ig, `''`)
			}
			@@ -462,13 +450,6 @@
			{ reg: /@\$/ig, value: '' },
			{ reg: /@datam@/ig, value: `''` },
			]

			if (window.GLOB.externalDatabase !== null) {
			regs.push({
			reg: /@db@/ig,
			value: window.GLOB.externalDatabase
			})
			}

			if (process) {
			regs.push({ reg: /@works_flow_code@/ig, value: `'1949-10-01 15:00:00'` })
			@@ -566,8 +547,8 @@
			}

			getSysDefaultSql = (btn, component, process, group, retmsg) => {
			let primaryId = 'id'
			let BID = 'bid'
			let primaryId = Utils.getuuid()
			let BID = Utils.getuuid()
			let verify = btn.verify \|\| {}
			let _actionType = null
			let setting = component.setting
			@@ -1344,10 +1325,6 @@

			_sql = _sql.replace(/@ID@/ig, `'${primaryId \|\| ''}'`)
			_sql = _sql.replace(/@BID@/ig, `'${BID}'`)
			_sql = _sql.replace(/@LoginUID@/ig, `'LoginUID'`)
			_sql = _sql.replace(/@SessionUid@/ig, `'SessionUid'`)
			_sql = _sql.replace(/@UserID@/ig, `'UserID'`)
			_sql = _sql.replace(/@Appkey@/ig, `'appkey'`)
			_sql = _sql.replace(/@typename@/ig, `'typename'`)
			_sql = _sql.replace(/@\$\|\$@/ig, '').replace(/@datam@/ig, `''`)

			@@ -1377,19 +1354,8 @@
			let sheet = _sheet.replace(/(.)\.(.)\./ig, '')

			database = database ? (database[0] \|\| '') : ''

			let getuuid = () => {
			let uuid = []
			let timestamp = new Date().getTime()
			let _options = '0123456789abcdefghigklmnopqrstuv'
			for (let i = 0; i < 19; i++) {
			uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
			}
			uuid = timestamp + uuid.join('')
			return uuid
			}

			let upId = getuuid()
			let upId = Utils.getuuid()

			let vals = []
			btn.columns.forEach(col => {
			@@ -1433,21 +1399,11 @@
			{reg: new RegExp('(^\|\\s)@' + sheet + '(\\s\|$)', 'ig'), value: ` #${sheet} `},
			{reg: new RegExp('(^\|\\s)@' + sheet + '\\(', 'ig'), value: ` #${sheet}(`},
			{reg: new RegExp('(^\|\\s)@' + sheet + '\\)', 'ig'), value: ` #${sheet})`},
			{reg: /@ID@/ig, value: `'id'`},
			{reg: /@BID@/ig, value: `'bid'`},
			{reg: /@LoginUID@/ig, value: `'LoginUID'`},
			{reg: /@SessionUid@/ig, value: `'SessionUid'`},
			{reg: /@UserID@/ig, value: `'UserID'`},
			{reg: /@Appkey@/ig, value: `'appkey'`},
			{reg: /@typename@/ig, value: `'admin'`},
			{reg: /\$@/ig, value: ''},
			{reg: /@\$/ig, value: ''},
			{reg: /@datam@/ig, value: `''`},
			]

			if (window.GLOB.externalDatabase !== null) {
			regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase})
			}

			btn.scripts && btn.scripts.forEach(script => {
			if (script.status === 'false') return
			@@ -1635,20 +1591,11 @@
			{reg: new RegExp('(^\|\\s)@' + sheet + '(\\s\|$)', 'ig'), value: ` #${sheet} `},
			{reg: new RegExp('(^\|\\s)@' + sheet + '\\(', 'ig'), value: ` #${sheet}(`},
			{reg: new RegExp('(^\|\\s)@' + sheet + '\\)', 'ig'), value: ` #${sheet})`},
			{reg: /@BID@/ig, value: `'${BID}'`},
			{reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID') \|\| ''}'`},
			{reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid') \|\| ''}'`},
			{reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID') \|\| ''}'`},
			{reg: /@Appkey@/ig, value: `'${window.GLOB.appkey \|\| ''}'`},
			{reg: /@typename@/ig, value: `'admin'`},
			{reg: /\$@/ig, value: isDM ? '/*' : ''},
			{reg: /@\$/ig, value: isDM ? '*/' : ''},
			{reg: /@datam@/ig, value: isDM ? `'Y'` : `''`},
			]

			if (window.GLOB.externalDatabase !== null) {
			regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase})
			}

			btn.scripts && btn.scripts.forEach(script => {
			if (script.status === 'false') return
			@@ -1792,13 +1739,6 @@
			{ reg: /@\$/ig, value: '' },
			{ reg: /@datam@/ig, value: `''` },
			]

			if (window.GLOB.externalDatabase !== null) {
			regs.push({
			reg: /@db@/ig,
			value: window.GLOB.externalDatabase
			})
			}

			let sql = this.formatDataSource(item, regs)

			@@ -1914,17 +1854,11 @@
			{ reg: /@orderBy@/ig, value: item.setting.order \|\| '' },
			{ reg: /@pageSize@/ig, value: 9999 },
			{ reg: /@pageIndex@/ig, value: 1},
			{ reg: /@ID@/ig, value: `''`},
			{ reg: /@BID@/ig, value: `''`},
			{ reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID') \|\| ''}'`},
			{ reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid') \|\| ''}'`},
			{ reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID') \|\| ''}'`},
			{ reg: /@Appkey@/ig, value: `'${window.GLOB.appkey \|\| ''}'`},
			{ reg: /@typename@/ig, value: `'admin'`},
			)

			if (item.type === 'calendar') {
			regoptions.push({ reg: /@mk_year@/ig, value: '2023' })
			regoptions.push({ reg: /@mk_year@/ig, value: '2024' })
			}

			regoptions.forEach(cell => {

			@@ -229,7 +229,7 @@
			})

			let sql = res.dataSource
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@\$\|\$@/ig, '')

			let rduri = ''
			if (window.GLOB.mainSystemApi && res.database === 'sso') {

			@@ -167,7 +167,7 @@
			}

			let sql = this.state.verifySql + _initCustomScript + _prevCustomScript + _backCustomScript + tail
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/\$check@\|@check\$/ig, '').replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|typename)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/\$check@\|@check\$/ig, '').replace(/@datam@/ig, `''`).replace(/@typename@/ig, `'debug'`)

			if (skip) {
			this.setState({

			@@ -49,20 +49,6 @@
			if (/\s/.test(_dataresource)) {
			_dataresource = '(' + _dataresource + ') tb'
			}

			_dataresource = _dataresource.replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|typename)@/ig, `'1949-10-01 15:00:00'`)
			_customScript = _customScript.replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|typename)@/ig, `'1949-10-01 15:00:00'`)
			_tailScript = _tailScript.replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|typename)@/ig, `'1949-10-01 15:00:00'`)
			_dataresource = _dataresource.replace(/@\$\|\$@/ig, '')
			_customScript = _customScript.replace(/@\$\|\$@/ig, '')
			_tailScript = _tailScript.replace(/@\$\|\$@/ig, '')

			// 外联数据库替换
			if (window.GLOB.externalDatabase !== null) {
			_dataresource = _dataresource.replace(/@db@/ig, window.GLOB.externalDatabase)
			_customScript = _customScript.replace(/@db@/ig, window.GLOB.externalDatabase)
			_tailScript = _tailScript.replace(/@db@/ig, window.GLOB.externalDatabase)
			}

			let custompage = /@pageSize@\|@orderBy@/i.test(_dataresource + _customScript)

			@@ -76,6 +62,15 @@
			}, {
			reg: new RegExp('@pageIndex@', 'ig'),
			value: 1
			}, {
			reg: /@datam@/ig,
			value: `''`
			}, {
			reg: /@typename@/ig,
			value: `'debug'`
			}, {
			reg: /@\$\|\$@/ig,
			value: ''
			})

			regoptions.forEach(item => {

			@@ -33,20 +33,24 @@
			if (/\s/.test(_dataresource)) {
			_dataresource = '(' + _dataresource + ') tb'
			}

			_dataresource = _dataresource.replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|typename)@/ig, `'1949-10-01 15:00:00'`)
			_customScript = _customScript.replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|typename)@/ig, `'1949-10-01 15:00:00'`)
			_tailScript = _tailScript.replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|typename)@/ig, `'1949-10-01 15:00:00'`)
			_dataresource = _dataresource.replace(/@\$\|\$@/ig, '')
			_customScript = _customScript.replace(/@\$\|\$@/ig, '')
			_tailScript = _tailScript.replace(/@\$\|\$@/ig, '')

			// 外联数据库替换
			if (window.GLOB.externalDatabase !== null) {
			_dataresource = _dataresource.replace(/@db@/ig, window.GLOB.externalDatabase)
			_customScript = _customScript.replace(/@db@/ig, window.GLOB.externalDatabase)
			_tailScript = _tailScript.replace(/@db@/ig, window.GLOB.externalDatabase)
			}
			// 正则替换
			let regoptions = [{
			reg: /@datam@/ig,
			value: `''`
			}, {
			reg: /@typename@/ig,
			value: `'debug'`
			}, {
			reg: /@\$\|\$@/ig,
			value: ''
			}]

			regoptions.forEach(item => {
			_dataresource = _dataresource.replace(item.reg, item.value)
			_customScript = _customScript.replace(item.reg, item.value)
			_tailScript = _tailScript.replace(item.reg, item.value)
			})

			let arr_field = columns.map(col => col.field)
			arr_field = arr_field.join(',')

			@@ -210,7 +210,7 @@
			})

			let sql = res.dataSource
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@\$\|\$@/ig, '')

			let rduri = ''
			if (window.GLOB.mainSystemApi && res.database === 'sso') {

			@@ -1096,7 +1096,7 @@
			${_option.sql}`

			// LoginUID\|SessionUid\|UserID\|Appkey 已替换
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@(BID\|ID\|time_id)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@\$\|\$@/ig, '')

			let rduri = ''
			if (window.GLOB.mainSystemApi && values.database === 'sso') {
			@@ -1153,11 +1153,7 @@
			sql = `declare @mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20)
			${sql}`

			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@datam@/ig, '\'\'')
			sql = sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') \|\| ''}'`)
			sql = sql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') \|\| ''}'`)
			sql = sql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') \|\| ''}'`)
			sql = sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey \|\| ''}'`)
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/@datam@/ig, `''`)

			resolve({values, loading: true, promise: () => new Promise((resolve, reject) => {
			Api.sDebug(sql).then(result => {

			@@ -115,7 +115,7 @@

			// 数据权限
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/\$check@\|@check\$/ig, '')
			sql = sql.replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|typename)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@typename@/ig, `'debug'`)

			if (skip) {
			this.setState({

			@@ -84,7 +84,6 @@

			// 数据权限
			sql = sql.replace(/@\$\|\$@/ig, '')
			sql = sql.replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id)@/ig, `'1949-10-01 15:00:00'`)

			this.setState({loading: true})
			Api.sDebug(sql).then(res => {

			@@ -11,13 +11,14 @@
			class CustomForm extends Component {
			static propTpyes = {
			type: PropTypes.any,
			btn: PropTypes.object, // 按钮信息
			usefulfields: PropTypes.string, // 可用字段
			initsql: PropTypes.string, // sql前缀
			defaultsql: PropTypes.array, // 默认sql
			systemScripts: PropTypes.array, // 系统脚本
			customScripts: PropTypes.array, // 自定义脚本
			scriptsChange: PropTypes.func // 表单
			btn: PropTypes.object,
			usefulfields: PropTypes.string,
			initsql: PropTypes.string,
			defaultsql: PropTypes.string,
			useDefaultSql: PropTypes.any,
			systemScripts: PropTypes.array,
			customScripts: PropTypes.array,
			scriptsChange: PropTypes.func
			}

			state = {
			@@ -44,7 +45,7 @@
			}

			handleConfirm = () => {
			const { type, workFlow, flowType } = this.props
			const { type, workFlow, flowType, useDefaultSql, defaultsql } = this.props
			const { editItem, skip } = this.state
			// 表单提交时检查输入值是否正确
			this.props.form.validateFieldsAndScroll((err, values) => {
			@@ -126,7 +127,15 @@
			}
			}

			let sql = this.props.initsql + _initCustomScript + _prevCustomScript + _backCustomScript + tail
			let sql = this.props.initsql + _initCustomScript + _prevCustomScript

			if (useDefaultSql) {
			sql += `\n/* 默认sql */
			${defaultsql}
			`
			}

			sql += _backCustomScript + tail

			if (window.GLOB.funcs && window.GLOB.funcs.length > 0) {
			window.GLOB.funcs.forEach(item => {
			@@ -137,7 +146,8 @@

			// 数据权限
			sql = sql.replace(/@\$\|\$@/ig, '').replace(/\$check@\|@check\$/ig, '')
			sql = sql.replace(/@(BID\|ID\|LoginUID\|SessionUid\|UserID\|Appkey\|time_id\|datam\|typename)@/ig, `'1949-10-01 15:00:00'`)
			sql = sql.replace(/@datam@/ig, `''`)
			sql = sql.replace(/@typename@/ig, `'debug'`)

			if (window.GLOB.process && workFlow === 'true') {
			sql = sql.replace(/@works_flow_code@/ig, `'works_flow_code'`)

			@@ -1776,6 +1776,7 @@
			btn={this.props.card}
			initsql={this.state.initsql}
			customScripts={verify.scripts}
			useDefaultSql={verify.default !== 'false'}
			defaultsql={this.state.defaultsql}
			usefulfields={this.state.usefulfields}
			systemScripts={this.state.systemScripts}
			@@ -1789,6 +1790,7 @@
			workFlow={verify.workFlow}
			flowType={verify.flowType}
			customScripts={verify.scripts}
			useDefaultSql={verify.default !== 'false'}
			defaultsql={this.state.defaultsql}
			usefulfields={this.state.usefulfields}
			systemScripts={this.state.systemScripts}