2023-02-16

king

2023-02-16 fc55bf4131e3056a84ac7bae16540a4e714214b8

 src/menu/datasource/verifycard/index.jsx

@@ -32,6 +32,7 @@

  state = {
    columns: [],
    subColumns: [],
    activeKey: 'setting',
    loading: false,
    initsql: '',          // sql验证时变量声明及赋值
@@ -197,6 +198,7 @@
    this.setState({
      scripts,
      columns: config.columns ? fromJS(config.columns).toJS() : [],
      subColumns: config.subColumns ? fromJS(config.subColumns).toJS() : [],
      setting: _setting,
      median: _setting,
      searches: search,
@@ -272,6 +274,26 @@
    values.uuid = Utils.getuuid()

    this.setState({ columns: [...columns, values] })
  }

  subColumnChange = (values, resolve) => {
    const { subColumns } = this.state

    let fields = subColumns.map(item => item.field.toLowerCase())
    if (fields.includes(values.field.toLowerCase())) {
      notification.warning({
        top: 92,
        message: '字段已存在！',
        duration: 5
      })
      return
    }

    resolve()

    values.uuid = Utils.getuuid()

    this.setState({ subColumns: [...subColumns, values] })
  }

  deleteScript = (record) => {
@@ -422,6 +444,23 @@
        loading: false
      })
      this.getdefaultSql()
    } else if (activeKey === 'subcolumns') {
      if (this.subdatasource && this.subdatasource.state.editingKey) {
        notification.warning({
          top: 92,
          message: '字段未保存，请保存后切换！',
          duration: 5
        })
        this.setState({
          loading: false
        })
        return
      }

      this.setState({
        activeKey: val,
        loading: false
      })
    } else if (activeKey === 'scripts') {
      let _loading = false
      if (this.scriptsForm && this.scriptsForm.state.editItem) {
@@ -514,7 +553,7 @@

  submitDataSource = () => {
    const { config, mainSearch } = this.props
    const { activeKey, setting, columns, scripts } = this.state
    const { activeKey, setting, columns, subColumns, scripts } = this.state

    return new Promise((resolve, reject) => {
      if (activeKey === 'setting') {
@@ -536,7 +575,7 @@
            defaultSearch: _search,
            setting: res
          }, () => {
            this.sqlverify(() => { resolve({setting: res, columns, scripts }) }, reject, false)
            this.sqlverify(() => { resolve({setting: res, columns, subColumns, scripts }) }, reject, false)
          })
        }, () => {
          reject()
@@ -551,7 +590,18 @@
          reject()
          return
        }
        this.sqlverify(() => { resolve({setting, columns, scripts }) }, reject, false)
        this.sqlverify(() => { resolve({setting, columns, subColumns, scripts }) }, reject, false)
      } else if (activeKey === 'subcolumns') {
        if (this.subdatasource && this.subdatasource.state.editingKey) {
          notification.warning({
            top: 92,
            message: '字段未保存，请保存后提交！',
            duration: 5
          })
          reject()
          return
        }
        this.sqlverify(() => { resolve({setting, columns, subColumns, scripts }) }, reject, false)
      } else if (activeKey === 'scripts') {
        let _loading = false
        if (this.scriptsForm && this.scriptsForm.state.editItem) {
@@ -570,7 +620,7 @@
          return
        }

        this.sqlverify(() => { resolve({setting, columns, scripts }) }, reject, false)
        this.sqlverify(() => { resolve({setting, columns, subColumns, scripts }) }, reject, false)
      }
    })
  }
@@ -701,6 +751,12 @@
    })
  }

  updateSubfields = (columns) => {
    this.setState({
      subColumns: columns
    })
  }

  copyDatasource = () => {
    const { config } = this.props
    const { columns, scripts } = this.state
@@ -823,6 +879,27 @@
    message.success('复制成功。')
  }

  copySubColumns = () => {
    const { subColumns } = this.state
    let m = []
    let n = []

    subColumns.forEach(col => {
      m.push(`${col.field}(${col.label})`)
      n.push(col.field)
    })

    let oInput = document.createElement('input')
    oInput.value = `/*${m.join(',')}*/
      ${n.join(',')}`
    document.body.appendChild(oInput)
    oInput.select()
    document.execCommand('Copy')
    document.body.removeChild(oInput)

    message.success('复制成功。')
  }

  /**
   * @description 组件销毁，清除state更新
   */
@@ -834,7 +911,7 @@

  render() {
    const { config } = this.props
    const { columns, median, setting, scripts, colColumns, scriptsColumns, activeKey, loading, searches, defaultsql, visible, pvisible, reload, script, scriptValue } = this.state
    const { columns, subColumns, median, setting, scripts, colColumns, scriptsColumns, activeKey, loading, searches, defaultsql, visible, pvisible, reload, script, scriptValue } = this.state

    return (
      <div className="model-data-source-wrap">
@@ -844,8 +921,6 @@
          <TabPane tab={
            <span>
              数据源
              {config.type !== 'interface' ? <CopyOutlined title="复制数据源" className="mk-copy-datasource" onClick={this.copyDatasource}/> : null}
              {config.type !== 'interface' ? <SnippetsOutlined title="导入数据源" className="mk-paste-datasource" onClick={() => this.setState({pvisible: true})}/> : null}
            </span>
          } key="setting">
            {!reload ? <SettingForm
@@ -861,21 +936,38 @@
            <span>
              字段集
              {columns.length ? <span className="count-tip">{columns.length}</span> : null}
              <CopyOutlined title="以逗号拼接形式复制字段" className="mk-copy-fields" onClick={this.copyColumns}/>
            </span>
          } key="columns">
            <ColForm columnChange={this.columnChange}/>
            <FieldsComponent
              config={{...config, columns}}
              config={{columns}}
              type="fields"
              updatefield={this.updatefields}
            />
            <EditTable actions={['edit', 'move', 'copy', 'del', 'clear']} type="datasourcefield" wrappedComponentRef={(inst) => this.datasource = inst} data={columns} columns={colColumns} onChange={(columns) => this.setState({columns})}/>
          </TabPane> : null}
          {config.subtype === 'dualdatacard' ? <TabPane tab={
            <span>
              子表字段集
              {subColumns.length ? <span className="count-tip">{subColumns.length}</span> : null}
            </span>
          } key="subcolumns">
            <ColForm columnChange={this.subColumnChange}/>
            <FieldsComponent
              config={{columns: subColumns}}
              type="fields"
              updatefield={this.updateSubfields}
            />
            <EditTable actions={['edit', 'move', 'copy', 'del', 'clear']} type="datasourcefield" wrappedComponentRef={(inst) => this.subdatasource = inst} data={subColumns} columns={colColumns} onChange={(subColumns) => this.setState({subColumns})}/>
          </TabPane> : null}
          <TabPane tab={
            <span>
              自定义脚本
              {scripts.length ? <span className="count-tip">{scripts.length}</span> : null}
              {config.type !== 'interface' && activeKey === 'setting' ? <CopyOutlined title="复制数据源" className="mk-copy-datasource" onClick={(e) => {e.stopPropagation();this.copyDatasource()}}/> : null}
              {config.type !== 'interface' && activeKey === 'setting' ? <SnippetsOutlined title="导入数据源" className="mk-paste-datasource" onClick={(e) => {e.stopPropagation();this.setState({pvisible: true})}}/> : null}
              {activeKey === 'columns' ? <CopyOutlined title="以逗号拼接形式复制字段" className="mk-copy-fields" onClick={(e) => {e.stopPropagation();this.copyColumns()}}/> : null}
              {activeKey === 'subcolumns' ? <CopyOutlined title="以逗号拼接形式复制字段" className="mk-copy-fields" onClick={(e) => {e.stopPropagation();this.copySubColumns()}}/> : null}
            </span>
          } key="scripts" disabled={median.interType !== 'system'} id="mk-scripts-tabpane">
            {scripts.length ? <BorderOutlined className="full-scripts" onClick={() => {