From b8e1395f02c929eaa96b949cf6027ee2a43856a6 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 06 九月 2022 19:03:37 +0800
Subject: [PATCH] 2022-09-06

---
 src/templates/sharecomponent/actioncomponent/verifyexcelout/index.jsx |  931 ++++++++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 847 insertions(+), 84 deletions(-)

diff --git a/src/templates/sharecomponent/actioncomponent/verifyexcelout/index.jsx b/src/templates/sharecomponent/actioncomponent/verifyexcelout/index.jsx
index 5cb21ad..a1587be 100644
--- a/src/templates/sharecomponent/actioncomponent/verifyexcelout/index.jsx
+++ b/src/templates/sharecomponent/actioncomponent/verifyexcelout/index.jsx
@@ -1,118 +1,339 @@
 import React, {Component} from 'react'
 import PropTypes from 'prop-types'
-import { Form, Tabs, Row, Col, Button, Table, Popconfirm, Icon, notification, Modal, message, InputNumber } from 'antd'
+import { fromJS } from 'immutable'
+import { Form, Tabs, Row, Col, Button, notification, Modal, message, InputNumber, Radio, Spin, Typography, Popconfirm } from 'antd'
+import { EditOutlined, StopOutlined, CheckCircleOutlined, SwapOutlined, DeleteOutlined } from '@ant-design/icons'
+import moment from 'moment'
 
+import Api from '@/api'
 import Utils from '@/utils/utils.js'
-
+import SettingUtils from './utils.jsx'
 import ColumnForm from './columnform'
+import DataSource from './datasource'
+import CustomScript from './customscript'
+import CodeMirror from '@/templates/zshare/codemirror'
+import asyncComponent from '@/utils/asyncComponent'
 import './index.scss'
 
 const { TabPane } = Tabs
+const { confirm } = Modal
+const { Paragraph } = Typography
+const EditTable = asyncComponent(() => import('@/templates/zshare/editTable'))
 
 class VerifyCard extends Component {
   static propTpyes = {
     dict: PropTypes.object,    // 瀛楀吀椤�
+    config: PropTypes.object,
     card: PropTypes.object,
   }
 
   state = {
     verify: {},
+    activeKey: 'setting',
+    systemScripts: [],
+    defaultscript: '', // 鑷畾涔夎剼鏈�
     excelColumns: [
       {
         title: this.props.dict['model.form.field'],
         dataIndex: 'Column',
-        width: '20%'
+        inputType: 'input',
+        editable: true,
+        unique: true,
+        width: '17%'
       },
       {
         title: this.props.dict['model.name'],
         dataIndex: 'Text',
-        width: '20%'
-      },
-      {
-        title: this.props.dict['model.export'],
-        dataIndex: 'export',
-        width: '20%',
+        inputType: 'input',
         editable: true,
-        render: (text, record) => record.export !== 'false' ? this.props.dict['model.true'] : this.props.dict['model.false']
+        unique: true,
+        width: '17%'
       },
       {
         title: this.props.dict['model.form.columnWidth'],
         dataIndex: 'Width',
-        width: '20%'
+        inputType: 'number',
+        min: 5,
+        max: 200,
+        editable: true,
+        width: '12%',
+        render: (text) => text || 20
+      },
+      {
+        title: '绫诲瀷',
+        dataIndex: 'type',
+        inputType: 'select',
+        editable: true,
+        required: false,
+        width: '14%',
+        render: (text) => {
+          if (text === 'image') {
+            return '鍥剧墖'
+          } else if (text === 'number') {
+            return '鏁板��'
+          } else {
+            return '鏂囨湰'
+          }
+        },
+        options: [
+          {value: 'text', text: '鏂囨湰'},
+          {value: 'number', text: '鏁板��'},
+          {value: 'image', text: '鍥剧墖'}
+        ]
+      },
+      {
+        title: '鍙栫粷瀵瑰��',
+        dataIndex: 'abs',
+        inputType: 'radio',
+        editable: true,
+        required: false,
+        width: '14%',
+        render: (text) => {
+          if (text === 'true') {
+            return '鏄�'
+          } else {
+            return '鍚�'
+          }
+        },
+        options: [
+          {value: 'true', text: '鏄�'},
+          {value: 'false', text: '鍚�'}
+        ]
+      },
+      {
+        title: '灏忔暟浣�',
+        dataIndex: 'decimal',
+        inputType: 'number',
+        min: 0,
+        max: 18,
+        editable: true,
+        required: false,
+        width: '12%'
+      },
+      {
+        title: '瀵煎嚭',
+        dataIndex: 'output',
+        inputType: 'radio',
+        editable: true,
+        required: false,
+        width: '14%',
+        render: (text) => {
+          if (text !== 'false') {
+            return '鏄�'
+          } else {
+            return '鍚�'
+          }
+        },
+        options: [
+          {value: 'true', text: '鏄�'},
+          {value: 'false', text: '鍚�'}
+        ]
+      }
+    ],
+    scriptsColumns: [
+      {
+        title: 'SQL',
+        dataIndex: 'sql',
+        width: '60%',
+        render: (text) => {
+          let title = text.match(/^\s*\/\*.+\*\//)
+          title = title && title[0] ? title[0] : ''
+          let _text = title ? text.replace(title, '') : text
+
+          return (
+            <div>
+              {title ? <span style={{color: '#a50'}}>{title}<span style={{fontSize: '12px', marginLeft: '5px'}}>{_text.length}</span></span> : null}
+              <Paragraph copyable={{ text: text }} ellipsis={{ rows: 4, expandable: true }}>{_text}</Paragraph>
+            </div>
+          )
+        }
+      },
+      {
+        title: '鎵ц浣嶇疆',
+        dataIndex: 'position',
+        width: '10%',
+        render: (text, record) => {
+          if (record.position === 'init') {
+            return <span style={{color: 'orange'}}>鍒濆鍖�</span>
+          } else if (record.position === 'front') {
+            return <span style={{color: '#26C281'}}>sql鍓�</span>
+          } else {
+            return <span style={{color: '#1890ff'}}>sql鍚�</span>
+          }
+        }
+      },
+      {
+        title: '鐘舵��',
+        dataIndex: 'status',
+        width: '10%',
+        render: (text, record) => record.status === 'false' ?
+          (
+            <div style={{color: '#ff4d4f'}}>
+              绂佺敤
+              <StopOutlined style={{marginLeft: '5px'}} />
+            </div>
+          ) :
+          (
+            <div style={{color: '#26C281'}}>
+              鍚敤
+              <CheckCircleOutlined style={{marginLeft: '5px'}}/>
+            </div>
+          )
       },
       {
         title: '鎿嶄綔',
         align: 'center',
+        width: '140px',
         dataIndex: 'operation',
         render: (text, record) =>
-          (
-            <div>
-              <span className="operation-btn" title={this.props.dict['model.edit']} onClick={() => this.handleEdit(record, 'columns')} style={{color: '#1890ff'}}><Icon type="edit" /></span>
-              <span className="operation-btn" title={this.props.dict['header.form.up']} onClick={() => this.handleUpDown(record, 'columns', 'up')} style={{color: '#1890ff'}}><Icon type="arrow-up" /></span>
-              <span className="operation-btn" title={this.props.dict['header.form.down']} onClick={() => this.handleUpDown(record, 'columns', 'down')} style={{color: '#ff4d4f'}}><Icon type="arrow-down" /></span>
-              <Popconfirm
-                title={this.props.dict['header.form.query.delete']}
-                okText={this.props.dict['model.confirm']}
-                cancelText={this.props.dict['model.cancel']}
-                onConfirm={() => this.handleDelete(record, 'columns')
-              }>
-                <span style={{color: '#ff4d4f', cursor: 'pointer'}}><Icon type="delete" /></span>
-              </Popconfirm>
-            </div>
-          )
+          (<div style={{textAlign: 'center'}}>
+            <span className="operation-btn" title={this.props.dict['model.edit']} onClick={() => this.handleEdit(record, 'scripts')} style={{color: '#1890ff'}}><EditOutlined /></span>
+            <span className="operation-btn" title={this.props.dict['header.form.status.change']} onClick={() => this.handleStatus(record, 'scripts')} style={{color: '#8E44AD'}}><SwapOutlined /></span>
+            <Popconfirm
+              overlayClassName="popover-confirm"
+              title={this.props.dict['model.query.delete']}
+              onConfirm={() => this.handleDelete(record, 'scripts')
+            }>
+              <span className="operation-btn" style={{color: '#ff4d4f'}}><DeleteOutlined /></span>
+            </Popconfirm>
+          </div>)
       }
     ]
   }
 
   UNSAFE_componentWillMount() {
-    let _verify = this.props.card.verify || {}
+    const { config, card } = this.props
+    let _verify = {}
 
-    let _columns = _verify.columns || []
-    _columns = _columns.map(col => {
-      col.Width = col.Width || 20
+    if (card.verify) {
+      _verify = fromJS(card.verify).toJS()
+    }
+
+    _verify.enable = _verify.enable || 'false'
+    _verify.dataType = _verify.dataType || 'default'
+    _verify.columns = _verify.columns || []
+    _verify.scripts = _verify.scripts || []
+
+    if (card.intertype !== 'system') {
+      _verify.enable = 'false'
+    }
+    if (_verify.columns[0] && (!_verify.columns[0].type || !_verify.columns[0].output)) {
+      _verify.columns = _verify.columns.map(col => {
+        col.type = col.type || 'text'
+        col.output = col.output || 'true'
+        return col
+      })
+    }
+
+    let defaultscript = ''
+    if (!_verify.script && card.intertype === 'system') {
+      let search = this.formatSearch(config.search)
+      search = Utils.joinMainSearchkey(search)
+      search = search.replace(/@\$@/ig, '')
+      search = search ? 'where ' + search : ''
       
-      return col
-    })
+      defaultscript = `update ${config.setting.tableName || ''} set idefine5= idefine5+1 ,modifydate=getdate(),cdefine5='宸插鍑�',modifyuserid=@userid@ ${search}`
+    }
+
+    let search = []
+
+    if (config.setting && config.setting.useMSearch === 'true' && window.GLOB.customMenu) {
+      let menu = fromJS(window.GLOB.customMenu).toJS()
+      let _search = null
+      let filterComponent = (box) => {
+        box.components.forEach(item => {
+          if (_search) return
+  
+          if (item.type === 'search') {
+            box.slist = [...box.slist, item.search]
+          } else if (item.uuid === config.uuid) {
+            _search = box.slist.pop()
+          } else if (item.type === 'group') {
+            item.components.forEach(m => {
+              if (m.uuid !== config.uuid) return
+              _search = box.slist.pop()
+            })
+          } else if (item.type === 'tabs') {
+            item.subtabs.forEach(tab => {
+              tab.slist = [...box.slist]
+              filterComponent(tab)
+            })
+          }
+        })
+      }
+      menu.slist = []
+      filterComponent(menu)
+  
+      if (_search) {
+        search = _search
+      } else {
+        menu.components.forEach(item => {
+          if (item.type !== 'search') return
+          search = item.search
+        })
+      }
+    }
+
+    let searches = fromJS(config.search || []).toJS()
+
+    if (search.length > 0) {
+      let keys = searches.map(item => (item.field ? item.field.toLowerCase() : ''))
+      search.forEach(item => {
+        if (item.field && !keys.includes(item.field.toLowerCase())) {
+          searches.push(item)
+        }
+      })
+    }
 
     this.setState({
-      verify: {
-        ..._verify,
-        columns: _columns,
+      verify: _verify,
+      searches: searches,
+      activeKey: card.intertype === 'system' && _verify.dataType === 'custom' ? 'setting' : 'columns',
+      defaultscript: defaultscript
+    })
+  }
+
+  componentDidMount () {
+    let _scriptSql = `Select distinct func+Remark as funcname,longparam, s.Sort from聽 s_custom_script s inner join (select OpenID from sapp where ID=@Appkey@) p on s.openid = case when s.appkey='' then s.openid else p.OpenID end order by s.Sort`
+
+    _scriptSql = Utils.formatOptions(_scriptSql)
+
+    let _sParam = {
+      func: 'sPC_Get_SelectedList',
+      LText: _scriptSql,
+      obj_name: 'data',
+      arr_field: 'funcname,longparam'
+    }
+    
+    _sParam.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
+    _sParam.secretkey = Utils.encrypt(_sParam.LText, _sParam.timestamp)
+
+    _sParam.open_key = Utils.encryptOpenKey(_sParam.secretkey, _sParam.timestamp) // 浜戠鏁版嵁楠岃瘉
+    
+    Api.getSystemConfig(_sParam).then(res => {
+      if (res.status) {
+        this.setState({
+          systemScripts: res.data.map(item => {
+            return {
+              name: item.funcname,
+              value: window.decodeURIComponent(window.atob(item.longparam))
+            }
+          })
+        })
+      } else {
+        notification.warning({
+          top: 92,
+          message: res.message,
+          duration: 5
+        })
       }
     })
   }
 
-  columnChange = (values) => {
-    let verify = JSON.parse(JSON.stringify(this.state.verify))
-
-    if (values.uuid) {
-      verify.columns = verify.columns.map(item => {
-        if (item.uuid === values.uuid) {
-          return values
-        } else {
-          return item
-        }
-      })
-    } else {
-      values.uuid = Utils.getuuid()
-      verify.columns.push(values)
-    }
-
-    this.setState({
-      verify: verify
-    })
-  }
-
-  handleDelete = (record, type) => {
-    const { verify } = this.state
-
-    verify.columns = verify.columns.filter(item => item.uuid !== record.uuid)
-
-    this.setState({ verify: verify })
-  }
-
   handleEdit = (record, type) => {
-    this.columnForm.edit(record)
+    if (type === 'scripts') {
+      this.scriptsForm.edit(record)
+    }
 
     let node = document.getElementById('verify-excelout-box-tab').parentNode
 
@@ -128,6 +349,102 @@
         }
       }, 10)
     }
+  }
+
+  handleStatus = (record, type) => {
+    let verify = JSON.parse(JSON.stringify(this.state.verify))
+    record.status = record.status === 'false' ? 'true' : 'false'
+
+    if (type === 'scripts') {
+      verify.scripts = verify.scripts.map(item => {
+        if (item.uuid === record.uuid) {
+          return record
+        } else {
+          return item
+        }
+      })
+    }
+
+    this.setState({
+      verify: verify
+    })
+  }
+
+  /**
+   * @description 鑾峰彇鍏ㄩ儴鎼滅储鏉′欢
+   * @param {Array} searches 鎼滅储鏉′欢鏁扮粍
+   */
+  formatSearch (searches) {
+    if (!searches || searches.length === 0) return []
+
+    let newsearches = []
+    searches.forEach(search => {
+      if (!search.field) return
+      
+      let item = {
+        key: search.field,
+        match: search.match,
+        type: search.type,
+        label: search.label,
+        value: search.initval,
+        required: search.required === 'true'
+      }
+      if (item.type === 'group') {
+        item.key = search.datefield
+        item.type = 'daterange'
+        item.match = 'between'
+        item.value = [moment().format('YYYY-MM-DD'), moment().format('YYYY-MM-DD')].join(',')
+
+        newsearches.push(item)
+        return
+      } else if (item.type === 'date') {
+        item.value = moment().format('YYYY-MM-DD')
+      } else if (item.type === 'datemonth') {
+        item.value = moment().format('YYYY-MM')
+      } else if (item.type === 'dateweek') {
+        item.value = moment().format('YYYY-MM-DD')
+      } else if (item.type === 'daterange') {
+        item.value = [moment().format('YYYY-MM-DD'), moment().format('YYYY-MM-DD')].join(',')
+      } else if (item.type === 'multiselect' || (item.type === 'checkcard' && search.multiple === 'true')) {
+        item.type = 'multi'
+        item.value = '@$@'
+      } else {
+        item.value = '@$@'
+      }
+      newsearches.push(item)
+    })
+    
+    return newsearches
+  }
+
+  columnChange = (values) => {
+    let verify = JSON.parse(JSON.stringify(this.state.verify))
+
+    let fields = verify.columns.map(item => item.Column)
+    if (fields.includes(values.Column)) {
+      notification.warning({
+        top: 92,
+        message: values.Column + '瀛楁宸插瓨鍦紒',
+        duration: 5
+      })
+      return
+    }
+    values.uuid = Utils.getuuid()
+    values.abs = 'false'
+    values.output = 'true'
+    verify.columns.push(values)
+
+    this.setState({
+      verify: verify
+    })
+  }
+
+  handleDelete = (record, type) => {
+    const { verify } = this.state
+
+    verify.columns = verify.columns.filter(item => item.uuid !== record.uuid)
+
+    this.setState({ verify: verify })
   }
 
   handleUpDown = (record, type, direction) => {
@@ -198,7 +515,7 @@
   }
 
   handleConfirm = () => {
-    let verify = JSON.parse(JSON.stringify(this.state.verify))
+    const { activeKey, verify } = this.state
     
     // 琛ㄥ崟鎻愪氦鏃舵鏌ヨ緭鍏ュ�兼槸鍚︽纭�
     return new Promise((resolve, reject) => {
@@ -215,12 +532,403 @@
         return
       }
 
-      resolve(verify)
+      if (activeKey === 'backscript' && verify.enable === 'true') {
+        this.checkScript(resolve, reject)
+      } else if (activeKey === 'setting') {
+        this.settingForm.handleConfirm().then(res => {
+          let _verify = {...verify, ...res}
+          this.setState({
+            verify: _verify
+          }, () => {
+            this.setState({loading: true})
+            this.sqlverify(() => { // 楠岃瘉鎴愬姛
+              this.setState({
+                loading: false
+              })
+              resolve(_verify)
+            }, () => {             // 楠岃瘉澶辫触
+              this.setState({
+                loading: false
+              })
+              reject()
+            }, verify.scripts)
+          })
+        })
+      } else if (activeKey === 'columns') {
+        if (this.columnRef && this.columnRef.state.editingKey) {
+          notification.warning({
+            top: 92,
+            message: '瀛楁鏈繚瀛橈紒',
+            duration: 5
+          })
+          return
+        }
+
+        if (this.props.card.intertype !== 'system' || verify.dataType !== 'custom') {
+          resolve(verify)
+        } else {
+          this.setState({loading: true})
+    
+          this.sqlverify(() => { // 楠岃瘉鎴愬姛
+            this.setState({
+              loading: false
+            })
+            resolve(verify)
+          }, () => {             // 楠岃瘉澶辫触
+            this.setState({
+              loading: false
+            })
+            reject()
+          }, verify.scripts)
+        }
+      } else if (activeKey === 'scripts') {
+        if (this.scriptsForm && this.scriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.scriptsForm.props.form.getFieldValue('sql'))) {
+          notification.warning({
+            top: 92,
+            message: '瀛樺湪鏈繚瀛樿剼鏈紝璇风偣鍑荤‘瀹氫繚瀛橈紝鎴栫偣鍑诲彇娑堟斁寮冧慨鏀癸紒',
+            duration: 5
+          })
+          return
+        }
+  
+        this.setState({loading: true})
+        this.sqlverify(() => { // 楠岃瘉鎴愬姛
+          this.setState({
+            loading: false
+          })
+          resolve(verify)
+        }, () => {             // 楠岃瘉澶辫触
+          this.setState({
+            loading: false
+          })
+          reject()
+        }, verify.scripts)
+      } else {
+        resolve(verify)
+      }
     })
   }
 
+  checkScript = (_resolve, _reject) => {
+    this.props.form.validateFieldsAndScroll((err, values) => {
+      if (!err) {
+        values.sql = values.sql || ''
+
+        let _quot = values.sql.match(/'{1}/g)
+        let _lparen = values.sql.match(/\({1}/g)
+        let _rparen = values.sql.match(/\){1}/g)
+
+        _quot = _quot ? _quot.length : 0
+        _lparen = _lparen ? _lparen.length : 0
+        _rparen = _rparen ? _rparen.length : 0
+
+        if (_quot % 2 !== 0) {
+          notification.warning({
+            top: 92,
+            message: 'sql涓璡'蹇呴』鎴愬鍑虹幇',
+            duration: 5
+          })
+          return
+        } else if (_lparen !== _rparen) {
+          notification.warning({
+            top: 92,
+            message: 'sql涓�()蹇呴』鎴愬鍑虹幇',
+            duration: 5
+          })
+          return
+        } else if (/--/ig.test(values.sql)) {
+          notification.warning({
+            top: 92,
+            message: '鑷畾涔塻ql璇彞涓紝涓嶅彲鍑虹幇瀛楃 -- 锛屾敞閲婅鐢� /*鍐呭*/',
+            duration: 5
+          })
+          return
+        }
+
+        let error = Utils.verifySql(values.sql, 'customscript')
+
+        if (error) {
+          notification.warning({
+            top: 92,
+            message: 'sql涓笉鍙娇鐢�' + error,
+            duration: 5
+          })
+          return
+        }
+
+        let param = {
+          func: 's_debug_sql',
+          exec_type: 'y',
+          LText: values.sql
+        }
+
+        param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
+        param.LText = param.LText.replace(/@\$|\$@/ig, '').replace(/@(BID|ID|LoginUID|SessionUid|UserID|Appkey|time_id)@/ig, `'${param.timestamp}'`)
+
+        param.LText = Utils.formatOptions(param.LText)
+        param.secretkey = Utils.encrypt('', param.timestamp)
+        
+        this.setState({
+          loading: true
+        })
+        Api.genericInterface(param).then(res => {
+          this.setState({
+            loading: false
+          })
+          if (res.status) {
+            let verify = {...this.state.verify, script: values.sql}
+
+            this.setState({verify: verify}, () => {
+              _resolve(verify)
+            })
+          } else {
+            Modal.error({
+              title: res.message
+            })
+          }
+        })
+      } else {
+        notification.warning({
+          top: 92,
+          message: '鑷畾涔夎剼鏈笉鍙负绌猴紒',
+          duration: 5
+        })
+        _reject()
+      }
+    })
+  }
+
+  changeEnable = (e) => {
+    const { verify } = this.state
+
+    this.setState({
+      verify: {...verify, enable: e.target.value}
+    })
+  }
+
+  columnFieldInput = () => {
+    const { config } = this.props
+    const { verify } = this.state
+
+    let columns = fromJS(verify.columns).toJS()
+    let fields = columns.map(item => item.Column)
+
+    config.columns.forEach(item => {
+      if (fields.includes(item.field) || !item.field) return
+      fields.push(item.field)
+
+      let cell = {
+        Column: item.field,
+        Text: item.label,
+        Width: 20,
+        abs: 'false',
+        output: 'true',
+        type: 'text',
+        uuid: Utils.getuuid()
+      }
+
+      if (item.type === 'number') {
+        cell.type = 'number'
+        cell.decimal = item.decimal
+      }
+
+      columns.push(cell)
+    })
+
+    this.setState({
+      verify: {...verify, columns: columns}
+    })
+  }
+
+  clearField = () => {
+    const { verify } = this.state
+    const _this = this
+
+    confirm({
+      content: `纭畾娓呯┖Excel鍒楀悧锛焋,
+      onOk() {
+        _this.setState({
+          verify: {
+            ...verify,
+            columns: []
+          }
+        })
+      },
+      onCancel() {}
+    })
+  }
+
+  changeColumns = (columns) => {
+    const { verify } = this.state
+
+    if (columns[0] && (columns[0].type !== 'image' && columns[0].type !== 'text' && columns[0].type !== 'number')) {
+      columns = columns.map(col => {
+        let _cell = {
+          uuid: Utils.getuuid(),
+          Column: col.Column,
+          Text: col.Text,
+          Width: 20,
+          abs: 'false',
+          output: 'true',
+          type: 'text',
+        }
+
+        return _cell
+      })
+    }
+
+    this.setState({verify: {...verify, columns}})
+  }
+
+  // 鏍囩鍒囨崲
+  tabchange = (val) => {
+    const { card } = this.props
+    const { activeKey, verify } = this.state
+
+    if (activeKey === 'backscript' && verify.enable === 'true') {
+      this.checkScript(() => {
+        this.setState({
+          activeKey: val
+        })
+      }, () => {})
+    } else if (card.intertype !== 'system' || verify.dataType !== 'custom') {
+      this.setState({activeKey: val})
+      return
+    } else if (activeKey === 'setting') {
+      this.settingForm.handleConfirm().then(res => {
+        this.setState({
+          verify: {...verify, ...res}
+        }, () => {
+          this.setState({loading: true})
+          this.sqlverify(() => { // 楠岃瘉鎴愬姛
+            this.setState({
+              activeKey: val,
+              loading: false
+            })
+          }, () => {             // 楠岃瘉澶辫触
+            this.setState({
+              activeKey: val,
+              loading: false
+            })
+          }, verify.scripts)
+        })
+      })
+    } else if (activeKey === 'columns') {
+      if (this.columnRef && this.columnRef.state.editingKey) {
+        notification.warning({
+          top: 92,
+          message: '瀛楁鏈繚瀛橈紒',
+          duration: 5
+        })
+        return
+      }
+
+      this.setState({loading: true})
+
+      this.sqlverify(() => { // 楠岃瘉鎴愬姛
+        this.setState({
+          activeKey: val,
+          loading: false
+        })
+      }, () => {             // 楠岃瘉澶辫触
+        this.setState({
+          activeKey: val,
+          loading: false
+        })
+      }, verify.scripts)
+    } else if (activeKey === 'scripts') {
+      if (this.scriptsForm && this.scriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.scriptsForm.props.form.getFieldValue('sql'))) {
+        notification.warning({
+          top: 92,
+          message: '瀛樺湪鏈繚瀛樿剼鏈紝璇风偣鍑荤‘瀹氫繚瀛橈紝鎴栫偣鍑诲彇娑堟斁寮冧慨鏀癸紒',
+          duration: 5
+        })
+        return
+      }
+
+      this.setState({loading: true})
+      this.sqlverify(() => { // 楠岃瘉鎴愬姛
+        this.setState({
+          activeKey: val,
+          loading: false
+        })
+      }, () => {             // 楠岃瘉澶辫触
+        this.setState({
+          activeKey: val,
+          loading: false
+        })
+      }, verify.scripts)
+    } else {
+      this.setState({
+        activeKey: val
+      })
+    }
+  }
+
+  scriptsChange = (values) => {
+    let verify = JSON.parse(JSON.stringify(this.state.verify))
+
+    if (values.uuid) {
+      verify.scripts = verify.scripts.map(item => {
+        if (item.uuid === values.uuid) {
+          return values
+        } else {
+          return item
+        }
+      })
+    } else {
+      values.uuid = Utils.getuuid()
+      verify.scripts.push(values)
+    }
+
+    this.setState({loading: true})
+
+    this.sqlverify(() => { // 楠岃瘉鎴愬姛
+      this.setState({
+        loading: false,
+        verify: verify
+      })
+    }, () => {             // 楠岃瘉澶辫触
+      this.setState({
+        loading: false
+      })
+    }, verify.scripts)
+  }
+
+  sqlverify = (_resolve, _reject, scripts) => {
+    const { searches, verify } = this.state
+
+    let timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
+    let sql = SettingUtils.getDebugSql(verify, scripts, searches, Utils, timestamp)
+    let param = {
+      func: 's_debug_sql',
+      exec_type: 'y',
+      LText: sql
+    }
+    param.LText = Utils.formatOptions(param.LText)
+    param.timestamp = timestamp
+    param.secretkey = Utils.encrypt('', timestamp)
+
+    Api.genericInterface(param).then(result => {
+      if (result.status) {
+        _resolve()
+      } else {
+        _reject()
+        Modal.error({
+          title: result.message
+        })
+      }
+    })
+  }
+
+  updateDataType = (val) => {
+    this.setState({verify: {...this.state.verify, dataType: val}})
+  }
+
   render() {
-    const { verify, excelColumns } = this.state
+    const { card } = this.props
+    const { verify, excelColumns, defaultscript, scriptsColumns, activeKey, loading } = this.state
+    const { getFieldDecorator } = this.props.form
     const formItemLayout = {
       labelCol: {
         xs: { span: 24 },
@@ -234,23 +942,78 @@
 
     return (
       <div id="verify-excelout-box-tab">
-        <Tabs defaultActiveKey="1" className="verify-card-box" onChange={this.tabchange}>
-          <TabPane tab="Excel瀵煎嚭鍒�" key="1">
-            <ColumnForm
-              dict={this.props.dict}
-              columnChange={this.columnChange}
-              wrappedComponentRef={(inst) => this.columnForm = inst}
-            />
-            <Table
-              bordered
-              rowKey="uuid"
-              className="custom-table"
-              dataSource={verify.columns}
-              columns={excelColumns}
-              pagination={false}
-            />
+        {loading && <Spin size="large" />}
+        <Tabs activeKey={activeKey} className="excelout-verify-card-box" onChange={this.tabchange}>
+          {card.intertype === 'system' ? <TabPane tab="鍩虹楠岃瘉" key="setting">
+            <DataSource setting={verify} updateDataType={this.updateDataType} wrappedComponentRef={(inst) => this.settingForm = inst}/>
+          </TabPane> : null}
+          <TabPane tab={
+            <span>
+              Excel瀵煎嚭鍒�
+              {verify.columns.length ? <span className="count-tip">{verify.columns.length}</span> : null}
+            </span>
+          } key="columns">
+            <ColumnForm dict={this.props.dict} columnChange={this.columnChange}/>
+            <Button className="excel-col-add mk-green" title="娣诲姞鏄剧ず鍒楀瓧娈�" onClick={this.columnFieldInput}>
+              鍚屾鏄剧ず鍒�
+            </Button>
+            <Button className="excel-col-add mk-red" title="娓呯┖Excel鍒�" onClick={this.clearField}>
+              娓呯┖Excel鍒�
+            </Button>
+            <div style={{color: '#959595', fontSize: '13px', paddingLeft: '10px'}}>濡傞渶瀵煎嚭搴忓彿锛岃浣跨敤瀛楁 $Index锛涙暟鍊肩被鍨嬪鍑烘椂鍙繘琛屾暟鎹鐞嗭紙鍙栫粷瀵瑰�笺�佷繚鐣欏皬鏁颁綅锛夈��</div>
+            <EditTable actions={['edit', 'move', 'copy', 'del']} type="excelcolumn" wrappedComponentRef={(inst) => this.columnRef = inst} data={verify.columns} columns={excelColumns} onChange={this.changeColumns}/>
           </TabPane>
-          <TabPane tab="淇℃伅鎻愮ず" key="7">
+          {card.intertype === 'system' ? <TabPane tab={
+            <span>
+              鑷畾涔夎剼鏈�
+              {verify.scripts.length ? <span className="count-tip">{verify.scripts.length}</span> : null}
+            </span>
+          } key="scripts" disabled={verify.dataType !== 'custom'}>
+            <CustomScript
+              btn={card}
+              sheet={verify.tableName}
+              usefulfields={verify.columns}
+              scripts={verify.scripts}
+              systemScripts={this.state.systemScripts}
+              scriptsChange={this.scriptsChange}
+              wrappedComponentRef={(inst) => this.scriptsForm = inst}
+            />
+            <EditTable actions={['move']} data={verify.scripts} columns={scriptsColumns} onChange={(scripts) => {this.setState({verify: {...verify, scripts}})}}/>
+          </TabPane> : null}
+          {card.intertype === 'system' ? <TabPane tab={
+            <span>
+              鍥炶皟鑴氭湰
+              {verify.enable === 'true' ? <span className="count-tip">1</span> : null}
+            </span>
+          } key="backscript">
+            <Form {...formItemLayout} className="verify-form">
+              <Row gutter={24}>
+                <Col span={8}>
+                  <Form.Item style={{marginBottom: 10}} label={'鍚敤'}>
+                    <Radio.Group defaultValue={verify.enable || 'false'} onChange={this.changeEnable}>
+                      <Radio value="true">鏄�</Radio>
+                      <Radio value="false">鍚�</Radio>
+                    </Radio.Group>
+                  </Form.Item>
+                </Col>
+                <div style={{color: '#959595', fontSize: '13px', paddingTop: '30px', float: 'right'}}>鎵ц鎴愬姛鍚庣殑鍥炶皟鍑芥暟銆�</div>
+                <Col span={24} className="sql">
+                  <Form.Item label={'sql'}>
+                    {getFieldDecorator('sql', {
+                      initialValue: verify.script || defaultscript,
+                      rules: [
+                        {
+                          required: true,
+                          message: this.props.dict['form.required.input'] + 'sql!'
+                        }
+                      ]
+                    })(<CodeMirror />)}
+                  </Form.Item>
+                </Col>
+              </Row>
+            </Form>
+          </TabPane> : null}
+          <TabPane tab="淇℃伅鎻愮ず" key="message">
             <Form {...formItemLayout}>
               <Row gutter={24}>
                 <Col offset={6} span={6}>

--
Gitblit v1.8.0