2025-04-10

king

2025-04-10 fcdfdc9670866fecd2d239d75a6ec28391175e9f

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

@@ -1,4 +1,4 @@
import React, {Component} from 'react'
import React, { Component } from 'react'
import PropTypes from 'prop-types'
import { is, fromJS } from 'immutable'
import { Form, Row, Col, Button, notification, Modal, Tooltip, Radio, Select, Switch } from 'antd'
@@ -22,8 +22,7 @@
    editItem: null,
    usefulfields: null,
    loading: false,
    skip: false,
    verifySql: ''
    skip: false
  }

  UNSAFE_componentWillMount () {
@@ -37,26 +36,12 @@
  }

  resetfield = (columns) => {
    const { btn } = this.props
    columns = columns.filter(item => item.import !== 'false')
    let fields = columns.map(item => item.Column)

    fields.push('jskey')

    let _dec = columns.map(item => item.Column + ' ' + item.type).join(',')
    let sheet = btn.sheet.replace(/(.*)\.(.*)\.|@db@/ig, '')

    if (_dec) {
      _dec += ','
    }

    let _sql = `create table #${sheet} (${_dec}jskey nvarchar(50),BID nvarchar(50) )
      Declare @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),@ErrorCode nvarchar(50), @retmsg nvarchar(4000),@tbid Nvarchar(512)
      Select @ErrorCode='', @retmsg=''
    `
    
    this.setState({
      verifySql: _sql,
      usefulfields: fields.join(', ')
    })
  }
@@ -81,7 +66,7 @@
  }

  handleConfirm = () => {
    const { type, btn } = this.props
    const { type, btn, workFlow, usefulfields } = this.props
    const { editItem, skip } = this.state

    // 表单提交时检查输入值是否正确
@@ -114,13 +99,7 @@

        let pass = checkSQL(values.sql, 'customscript')

        if (!pass) return

        let sheet = btn.sheet.replace(/(.*)\.(.*)\.|@db@/ig, '')
        let tail = `
          drop table #${sheet}
          aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg
        `
        if (!pass && !skip) return

        let _initCustomScript = '' // 初始化脚本
        let _prevCustomScript = '' // 默认sql前执行脚本
@@ -165,10 +144,85 @@
            `
          }
        }
        
        let sheet = btn.sheet.replace(/(.*)\.(.*)\.|@db@/ig, '')
        let fields = []
        let _dec = []
        let vals = []

        let sql = this.state.verifySql + _initCustomScript + _prevCustomScript + _backCustomScript + tail
        usefulfields.forEach(col => {
          if (col.import === 'false') return

          fields.push(col.Column)
          _dec.push(col.Column + ' ' + col.type)

          let val = ''
          if (col.import === 'init') {
            if (/^Nvarchar/ig.test(col.type)) {
              val = ''
            } else if (/^Decimal/ig.test(col.type) || /^int/ig.test(col.type)) {
              val = 0
            } else if (col.type === 'date') {
              val = '1949-10-01'
            } else if (col.type === 'datetime') {
              val = '1949-10-01 00:00:00'
            }
          } else if (/^Nvarchar/ig.test(col.type)) {
            val = 'mk'
          } else if (/^Decimal/ig.test(col.type) || /^int/ig.test(col.type)) {
            val = 1
          } else if (col.type === 'date') {
            val = '1949-10-01'
          } else if (col.type === 'datetime') {
            val = '1949-10-01 00:00:00'
          }

          vals.push(`'${val}'`)
        })

        vals.push(`'${new Date().getTime()}000010'`)
        vals.push(`'bid'`)
        vals =  `Select ${vals.join(',')}`

        fields.push('jskey')
        fields = fields.join(',')
        
        _dec = _dec.join(',')
        _dec = _dec ? _dec + ',' : ''

        let sql = `create table #${sheet} (${_dec}jskey nvarchar(50),BID nvarchar(50) )
          Declare @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),@ErrorCode nvarchar(50), @retmsg nvarchar(4000),@tbid Nvarchar(512)
          Select @ErrorCode='', @retmsg='', @UserName='', @FullName='', @RoleID='', @mk_departmentcode='', @mk_organization='', @mk_user_type='', @mk_nation='', @mk_province='', @mk_city='', @mk_district='', @mk_address=''
        
          ${_initCustomScript}

          Insert into #${sheet} (${fields},BID)

          /* excel数据*/
          ${vals}

          ${_prevCustomScript}

          ${_backCustomScript}

          drop table #${sheet}
          aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg
        `

        sql = sql.replace(/@\$|\$@/ig, '').replace(/\$check@|@check\$/ig, '').replace(/@datam@/ig, `''`).replace(/@typename@/ig, `'debug'`)
        
        if (workFlow === 'true') {
          sql = sql.replace(/@works_flow_code@/ig, `'works_flow_code'`)
          sql = sql.replace(/@works_flow_name@/ig, `'works_flow_name'`)
          sql = sql.replace(/@works_flow_param@/ig, `'works_flow_param'`)
          sql = sql.replace(/@works_flow_detail_id@/ig, `'works_flow_detail_id'`)
          sql = sql.replace(/@status@/ig, `0`)
          sql = sql.replace(/@statusname@/ig, `'开始'`)
          sql = sql.replace(/@work_group@/ig, `'work_group'`)
          sql = sql.replace(/@work_grade@/ig, '0')
          sql = sql.replace(/@start_type@/ig, `'开始'`)
        }

        if (skip) {
          this.setState({
            skip: false,
@@ -220,11 +274,25 @@

    let _value = ''
    if (value === 'default') {
      let fields = usefulfields.filter(item => item.import !== 'false')
      fields = fields.map(col => col.Column).join(',')
      let fields = []
      let decls = []
      usefulfields.forEach(col => {
        if (col.import === 'false') return
        
        if (col.type === 'date') {
          decls.push(`${col.Column} Nvarchar(50)`)
        } else {
          decls.push(`${col.Column} ${col.type}`)
        }
        fields.push(col.Column)
      })

      decls = decls.join(',')
      fields = fields.join(',')
      
      if (fields) {
        fields = fields + ','
        decls = decls + ','
      }

      let database = btn.sheet.match(/(.*)\.(.*)\.|@db@/ig) || ''
@@ -232,7 +300,25 @@

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

      _value = `Insert into ${database}${sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From #${sheet}`
      _value = `/* create table #${sheet} (${decls}jskey nvarchar(50),BID nvarchar(50) ) */\nInsert into ${database}${sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From #${sheet}`
    } else if (value === 'flowSql') {
      let sheet = btn.sheet.replace(/(.*)\.(.*)\.|@db@/ig, '')

      _value = `insert into s_my_works_flow (works_flow_id,works_flow_code,works_flow_name,works_flow_param,status,statusname,work_group,works_flow_detail_id,work_grade,bid,createuserid,CreateUser,CreateStaff,upid)
      select jskey,@works_flow_code@,@works_flow_name@,@works_flow_param@,@status@,@statusname@,@work_group@,@works_flow_detail_id@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@
      from #${sheet}
                                                                 
      insert into s_my_works_flow_log (works_flow_id,works_flow_code,works_flow_name,works_flow_param,status,statusname,works_flow_detail_id,work_group,work_grade,bid,createuserid,CreateUser,CreateStaff,upid)
      select jskey,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@
      from #${sheet}
                                                                 
      insert into s_my_works_flow_notice (works_flow_id,works_flow_code,works_flow_detail_id,userid,notice_type,createuserid,CreateUser,CreateStaff,upid)
      select jskey,@works_flow_code@,@works_flow_detail_id@,@userid@,@start_type@,@userid@,@UserName,@FullName,@time_id@
      from #${sheet}
                                                                 
      insert into s_my_works_flow_role (works_flow_id,works_flow_code,userid,works_flow_detail_id,createuserid,CreateUser,CreateStaff,upid,typecharone)
      select jskey,@works_flow_code@,@userid@,@works_flow_detail_id@,@userid@,@UserName,@FullName,@time_id@,'begin'
      from #${sheet}`
    } else {
      _value = value
    }
@@ -259,7 +345,7 @@
  }

  render() {
    const { systemScripts, btn, type } = this.props
    const { systemScripts, btn, type, workFlow } = this.props
    const { usefulfields, editItem, skip } = this.state
    const { getFieldDecorator } = this.props.form
    const formItemLayout = {
@@ -288,7 +374,8 @@
          </Col> : null}
          {!type ? <Col span={24} className="sqlfield">
            <Form.Item label="可用字段">
              <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title={'公共值，请按照@xxx@格式使用。'}><span style={{color: '#1890ff'}}>BID, ID, LoginUID, SessionUid, UserID, Appkey, time_id, typename</span></Tooltip>,&nbsp;
              <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title={'公共值，请按照@xxx@格式使用。'}><span style={{color: '#1890ff'}}>BID, ID, LoginUID, SessionUid, UserID, Appkey, lang, time_id, typename</span></Tooltip>,&nbsp;
              {workFlow === 'true' ? <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title="工作流变量，请按照@xxx@格式使用。"><span style={{color: '#26C281'}}>works_flow_code, works_flow_name, works_flow_param, works_flow_detail_id, status, statusname, work_group, work_grade, start_type, </span></Tooltip> : null}
              <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title={'系统变量，系统会定义变量并赋值。'}><span style={{color: '#fa8c16'}}>UserName, FullName, RoleID, mk_departmentcode, mk_organization, mk_user_type, mk_nation, mk_province, mk_city, mk_district, mk_address</span></Tooltip>,&nbsp;
              {usefulfields}
            </Form.Item>
@@ -319,9 +406,8 @@
                onSelect={this.selectScript}
                getPopupContainer={() => document.getElementById('verify-excelin-custom-scripts')}
              >
                <Select.Option key="default" value={'default'}>
                  默认sql
                </Select.Option>
                <Select.Option key="default" value="default">默认sql</Select.Option>
                {workFlow === 'true' ? <Select.Option key="flow" value="flowSql">默认sql（工作流）</Select.Option> : null}
                <Select.Option key="debugger" value={`z_debug: select @ErrorCode='E',@retmsg='测试断点' goto aaa`}>
                  测试断点
                </Select.Option>