From 2a347c8d91d6962f4302f0553c55a3b9f743baa5 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 09 九月 2020 21:15:58 +0800
Subject: [PATCH] 2020-09-09
---
src/templates/sharecomponent/settingcomponent/settingform/index.jsx | 505 ++++++++++++++++++-------------------------------------
1 files changed, 169 insertions(+), 336 deletions(-)
diff --git a/src/templates/sharecomponent/settingcomponent/settingform/index.jsx b/src/templates/sharecomponent/settingcomponent/settingform/index.jsx
index 50ca2a2..84361f9 100644
--- a/src/templates/sharecomponent/settingcomponent/settingform/index.jsx
+++ b/src/templates/sharecomponent/settingcomponent/settingform/index.jsx
@@ -1,28 +1,25 @@
import React, {Component} from 'react'
import PropTypes from 'prop-types'
import { fromJS } from 'immutable'
-import { Form, Icon, notification, Modal, Spin, Tabs, Table, Popconfirm, Typography } from 'antd'
+import { Form, notification, Modal, Spin, Tabs } from 'antd'
import moment from 'moment'
import Api from '@/api'
import Utils from '@/utils/utils.js'
import SettingUtils from './utils.jsx'
-import CustomScript from './customscript'
+import CustomScript from '@/templates/zshare/customscript'
import DataSource from './datasource'
import './index.scss'
const { TabPane } = Tabs
-const { Paragraph } = Typography
class SettingForm extends Component {
static propTpyes = {
- type: PropTypes.string, // 鑿滃崟绫诲瀷
dict: PropTypes.object, // 瀛楀吀椤�
menu: PropTypes.object, // 鑿滃崟淇℃伅
config: PropTypes.object, // 椤甸潰閰嶇疆淇℃伅
permFuncField: PropTypes.array, // 鑷畾涔夊嚱鏁板彲鐢ㄥ瓧娈�
- search: PropTypes.array, // 鎼滅储鏉′欢
- inputSubmit: PropTypes.any // 鍥炶溅鎻愪氦浜嬩欢
+ search: PropTypes.array // 鎼滅储鏉′欢
}
state = {
@@ -33,57 +30,7 @@
arr_field: '',
regoptions: [],
setting: null,
- view: 'normal',
- defaultSql: '',
- systemScripts: [],
- scriptsColumns: [
- {
- title: 'SQL',
- dataIndex: 'sql',
- width: '70%',
- render: (text) => (
- <Paragraph copyable ellipsis={{ rows: 5, expandable: true }}>{text}</Paragraph>
- )
- },
- {
- title: '鐘舵��',
- dataIndex: 'status',
- width: '10%',
- render: (text, record) => record.status === 'false' ?
- (
- <div>
- {this.props.dict['model.status.forbidden']}
- <Icon style={{marginLeft: '5px'}} type="stop" theme="twoTone" twoToneColor="#ff4d4f" />
- </div>
- ) :
- (
- <div>
- {this.props.dict['model.status.open']}
- <Icon style={{marginLeft: '5px'}} type="check-circle" theme="twoTone" twoToneColor="#52c41a" />
- </div>
- )
- },
- {
- title: '鎿嶄綔',
- align: 'center',
- width: '20%',
- dataIndex: 'operation',
- render: (text, record) =>
- (<div>
- <span className="operation-btn" title={this.props.dict['model.edit']} onClick={() => this.handleEdit(record)} style={{color: '#1890ff'}}><Icon type="edit" /></span>
- <span className="operation-btn" title={this.props.dict['header.form.up']} onClick={() => this.handleUpDown(record, 'up')} style={{color: '#1890ff'}}><Icon type="arrow-up" /></span>
- <span className="operation-btn" title={this.props.dict['header.form.down']} onClick={() => this.handleUpDown(record, 'down')} style={{color: '#ff4d4f'}}><Icon type="arrow-down" /></span>
- <span className="operation-btn" title={this.props.dict['header.form.status.change']} onClick={() => this.handleStatus(record)} style={{color: '#8E44AD'}}><Icon type="swap" /></span>
- <Popconfirm
- overlayClassName="popover-confirm"
- title={this.props.dict['model.query.delete']}
- onConfirm={() => this.handleDelete(record)
- }>
- <span className="operation-btn" style={{color: '#ff4d4f'}}><Icon type="delete" /></span>
- </Popconfirm>
- </div>)
- }
- ]
+ defaultSql: ''
}
UNSAFE_componentWillMount() {
@@ -144,173 +91,6 @@
})
}
- componentDidMount () {
- this.getsysScript()
- }
-
- getsysScript = () => {
- 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') + '.000'
- _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) {
- let _scripts = res.data.map(item => {
- let _item = {
- name: item.funcname,
- value: Utils.UnformatOptions(item.longparam)
- }
- return _item
- })
-
- this.setState({
- systemScripts: _scripts
- })
- } else {
- notification.warning({
- top: 92,
- message: res.message,
- duration: 5
- })
- }
- })
- }
-
- handleConfirm = (trigger) => {
- const { activeKey, setting, scripts } = this.state
-
- if (trigger) {
- this.setState({loading: true})
- }
-
- // 琛ㄥ崟鎻愪氦鏃舵鏌ヨ緭鍏ュ�兼槸鍚︽纭�
- if (activeKey === 'setting') {
- return new Promise((resolve, reject) => {
- this.settingForm.handleConfirm().then(res => {
- if (res.interType === 'system' && res.default === 'false' && scripts.length === 0) {
- notification.warning({
- top: 92,
- message: '涓嶆墽琛岄粯璁ql鏃讹紝璇锋坊鍔犺嚜瀹氫箟鑴氭湰锛�',
- duration: 5
- })
- reject()
- return
- }
-
- this.setState({
- setting: res
- }, () => {
- this.sqlverify(() => {
- this.setState({loading: false})
- resolve({...res, scripts})
- }, () => {
- this.setState({loading: false})
- reject()
- }, true)
- })
- }, () => {
- this.setState({loading: false})
- })
- })
- } else {
- return new Promise((resolve, reject) => {
- let _loading = false
- if (this.scriptsForm && this.scriptsForm.state.editItem) {
- _loading = true
- } else if (this.scriptsForm && this.scriptsForm.props.form.getFieldValue('sql')) {
- _loading = true
- }
-
- if (_loading) {
- notification.warning({
- top: 92,
- message: '瀛樺湪鏈繚瀛樿剼鏈紝璇风偣鍑荤‘瀹氫繚瀛橈紝鎴栫偣鍑诲彇娑堟斁寮冧慨鏀癸紒',
- duration: 5
- })
- this.setState({loading: false})
- reject()
- } else if (setting.interType === 'system' && setting.default === 'false' && scripts.length === 0) {
- notification.warning({
- top: 92,
- message: '涓嶆墽琛岄粯璁ql鏃讹紝璇锋坊鍔犺嚜瀹氫箟鑴氭湰锛�',
- duration: 5
- })
- this.setState({loading: false})
- reject()
- } else {
- this.sqlverify(() => {
- this.setState({loading: false})
- resolve({...setting, scripts})
- }, () => {
- this.setState({loading: false})
- reject()
- }, true)
- }
- })
- }
- }
-
- getCustomScript = (setting) => {
- let _customScript = ''
- if (setting.scripts && setting.scripts.length > 0) {
- setting.scripts.forEach(item => {
- if (item.status === 'false') return
- _customScript += `
- ${item.sql}
- `
- })
- }
-
- if (_customScript) {
- _customScript = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000) select @ErrorCode='',@retmsg =''
- ${_customScript}
- `
- }
-
- return _customScript
- }
-
- sqlverify = (_resolve, _reject, force) => {
- const { setting, scripts, arr_field, regoptions, search } = this.state
-
- if (setting.interType !== 'system') { // 涓嶄娇鐢ㄧ郴缁熸帴鍙ｆ椂锛屼笉闇�瑕乻ql楠岃瘉
- _resolve()
- }
- if (force || (setting.interType === 'system' && setting.default !== 'false')) {
- let param = {
- func: 's_debug_sql',
- LText: SettingUtils.getDebugSql(setting, scripts, arr_field, regoptions, search)
- }
- param.LText = Utils.formatOptions(param.LText)
- param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + '.000'
- param.secretkey = Utils.encrypt(param.LText, param.timestamp)
-
- Api.getLocalConfig(param).then(result => {
- if (result.status) {
- _resolve()
- } else {
- _reject()
- Modal.error({
- title: result.message
- })
- }
- })
- } else {
- _resolve()
- }
- }
-
/**
* @description 鑾峰彇鍏ㄩ儴鎼滅储鏉′欢
* @param {Array} searches 鎼滅储鏉′欢鏁扮粍
@@ -363,108 +143,155 @@
return newsearches
}
- handleSubmit = (e) => {
- e.preventDefault()
+ handleConfirm = (trigger) => {
+ const { activeKey, setting, scripts } = this.state
- if (this.props.inputSubmit) {
- this.props.inputSubmit()
+ if (trigger) {
+ this.setState({loading: true})
}
- }
- handleEdit = (record) => {
- this.scriptsForm.edit(record)
+ let _scripts = scripts.filter(script => script.status !== 'false')
- this.scrolltop()
- }
+ // 琛ㄥ崟鎻愪氦鏃舵鏌ヨ緭鍏ュ�兼槸鍚︽纭�
+ if (activeKey === 'setting') {
+ return new Promise((resolve, reject) => {
+ this.settingForm.handleConfirm().then(res => {
+ if (trigger === 'func' && res.interType !== 'inner') {
+ notification.warning({
+ top: 92,
+ message: '浣跨敤鍐呴儴鎺ュ彛锛屾墠鍙互鍒涘缓瀛樺偍杩囩▼锛�',
+ duration: 5
+ })
+ this.setState({loading: false})
+ reject()
+ return
+ } else if (trigger === 'interface' && res.interType !== 'system') {
+ notification.warning({
+ top: 92,
+ message: '浣跨敤绯荤粺鎺ュ彛鏃讹紝鎵嶅彲浠ュ垱寤烘帴鍙ｏ紒',
+ duration: 5
+ })
+ this.setState({loading: false})
+ reject()
+ return
+ } else if (res.interType === 'system' && res.default === 'false' && _scripts.length === 0) {
+ notification.warning({
+ top: 92,
+ message: '涓嶆墽琛岄粯璁ql鏃讹紝璇锋坊鍔犺嚜瀹氫箟鑴氭湰锛�',
+ duration: 5
+ })
+ reject()
+ return
+ }
- scrolltop = () => {
- let node = document.getElementById('model-table-setting-form-box').parentNode
-
- if (node && node.scrollTop) {
- let inter = Math.ceil(node.scrollTop / 10)
-
- let timer = setInterval(() => {
- if (node.scrollTop - inter > 0) {
- node.scrollTop = node.scrollTop - inter
- } else {
- node.scrollTop = 0
- clearInterval(timer)
+ this.setState({
+ setting: res
+ }, () => {
+ this.sqlverify(() => {
+ this.setState({loading: false})
+ resolve({...res, scripts})
+ }, () => {
+ this.setState({loading: false})
+ reject()
+ }, 'submit')
+ })
+ }, () => {
+ this.setState({loading: false})
+ reject()
+ })
+ })
+ } else {
+ return new Promise((resolve, reject) => {
+ let _loading = false
+ if (this.scriptsForm && this.scriptsForm.state.editItem) {
+ _loading = true
+ } else if (this.scriptsForm && this.scriptsForm.props.form.getFieldValue('sql')) {
+ _loading = true
}
- }, 10)
+
+ if (trigger === 'func' && setting.interType !== 'inner') {
+ notification.warning({
+ top: 92,
+ message: '浣跨敤鍐呴儴鎺ュ彛锛屾墠鍙互鍒涘缓瀛樺偍杩囩▼锛�',
+ duration: 5
+ })
+ this.setState({loading: false})
+ reject()
+ } else if (_loading) {
+ notification.warning({
+ top: 92,
+ message: '瀛樺湪鏈繚瀛樿剼鏈紝璇风偣鍑荤‘瀹氫繚瀛橈紝鎴栫偣鍑诲彇娑堟斁寮冧慨鏀癸紒',
+ duration: 5
+ })
+ this.setState({loading: false})
+ reject()
+ } else if (setting.interType === 'system' && setting.default === 'false' && _scripts.length === 0) {
+ notification.warning({
+ top: 92,
+ message: '涓嶆墽琛岄粯璁ql鏃讹紝璇锋坊鍔犺嚜瀹氫箟鑴氭湰锛�',
+ duration: 5
+ })
+ this.setState({loading: false})
+ reject()
+ } else {
+ this.sqlverify(() => {
+ this.setState({loading: false})
+ resolve({...setting, scripts})
+ }, () => {
+ this.setState({loading: false})
+ reject()
+ }, 'submit')
+ }
+ })
}
}
- handleUpDown = (record, direction) => {
- let scripts = fromJS(this.state.scripts).toJS()
- let index = 0
+ sqlverify = (_resolve, _reject, type, uscripts) => {
+ const { setting, scripts, arr_field, regoptions, search } = this.state
- scripts = scripts.filter((item, i) => {
- if (item.uuid === record.uuid) {
- index = i
- }
-
- return item.uuid !== record.uuid
- })
- if ((index === 0 && direction === 'up') || (index === scripts.length && direction === 'down')) {
+ if (setting.interType !== 'system') { // 涓嶄娇鐢ㄧ郴缁熸帴鍙ｆ椂锛屼笉闇�瑕乻ql楠岃瘉
+ _resolve()
return
}
- if (direction === 'up') {
- scripts.splice(index - 1, 0, record)
+ let _scripts = []
+ if (uscripts) { // 杩囨护绂佺敤鐨勮剼鏈�
+ _scripts = uscripts.filter(script => script.status !== 'false')
} else {
- scripts.splice(index + 1, 0, record)
+ _scripts = scripts.filter(script => script.status !== 'false')
}
- this.setState({scripts})
- }
-
- handleStatus = (record) => {
- let scripts = fromJS(this.state.scripts).toJS()
- record.status = record.status === 'false' ? 'true' : 'false'
-
- scripts = scripts.map(item => {
- if (item.uuid === record.uuid) {
- return record
- } else {
- return item
+ if (type === 'setting' && setting.default === 'false') {
+ _resolve()
+ } else if (type === 'scripts' && _scripts.length === 0) {
+ _resolve()
+ } else { // type 涓� submit 銆� verify 锛屼互鍙婂叾浠栭渶瑕侀獙璇佺殑鍦烘櫙
+ let param = {
+ func: 's_debug_sql',
+ LText: SettingUtils.getDebugSql(setting, _scripts, arr_field, regoptions, search)
}
- })
-
- this.setState({scripts})
- }
-
- handleDelete = (record) => {
- let scripts = fromJS(this.state.scripts).toJS()
- scripts = scripts.filter(item => item.uuid !== record.uuid)
-
- this.setState({ scripts })
- }
-
- scriptsChange = (values) => {
- let scripts = fromJS(this.state.scripts).toJS()
-
- if (values.uuid) {
- scripts = scripts.map(item => {
- if (item.uuid === values.uuid) {
- return values
+ param.LText = Utils.formatOptions(param.LText)
+ param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + '.000'
+ param.secretkey = Utils.encrypt(param.LText, param.timestamp)
+
+ Api.getLocalConfig(param).then(result => {
+ if (result.status) {
+ _resolve()
} else {
- return item
+ _reject()
+ Modal.error({
+ title: result.message
+ })
}
})
- } else {
- values.uuid = Utils.getuuid()
- scripts.push(values)
}
-
- this.setState({scripts})
}
+ // 鏍囩鍒囨崲
changeTab = (val) => {
const { activeKey, search, arr_field } = this.state
if (activeKey === 'setting') {
- this.setState({loading: true})
-
let _defaultSql = ''
this.settingForm.handleConfirm().then(res => {
if (res.interType !== 'system') {
@@ -473,37 +300,35 @@
message: '浣跨敤绯荤粺鎺ュ彛鏃讹紝鎵嶅彲浠ヨ缃嚜瀹氫箟鑴氭湰锛�',
duration: 5
})
- this.setState({loading: false})
return
+ }
+
+ if (res.dataresource) {
+ let _dataresource = res.dataresource
+
+ if (/\s/.test(_dataresource)) {
+ _dataresource = '(' + _dataresource + ') tb'
+ }
+
+ _defaultSql = `select top @pageSize@ ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${_dataresource} ${search}) tmptable where rows > (@pageSize@ * (@pageIndex@ - 1)) order by tmptable.rows`
}
this.setState({
- setting: res
+ setting: res,
+ defaultSql: _defaultSql
}, () => {
- if (res.dataresource) {
- let _dataresource = res.dataresource
-
- if (/\s/.test(_dataresource)) {
- _dataresource = '(' + _dataresource + ') tb'
- }
-
- _defaultSql = `select top @pageSize@ ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${_dataresource} ${search}) tmptable where rows > (@pageSize@ * (@pageIndex@ - 1)) order by tmptable.rows`
- }
-
+ this.setState({loading: true})
this.sqlverify(() => { // 楠岃瘉鎴愬姛
this.setState({
activeKey: val,
- defaultSql: _defaultSql,
loading: false
})
}, () => { // 楠岃瘉澶辫触
this.setState({
loading: false
})
- })
+ }, activeKey)
})
- }, () => {
- this.setState({loading: false})
})
} else if (activeKey === 'scripts') {
let _loading = false
@@ -521,24 +346,44 @@
})
return
}
-
- this.setState({
- activeKey: val
- })
+
+ this.setState({loading: true})
+ this.sqlverify(() => { // 楠岃瘉鎴愬姛
+ this.setState({
+ activeKey: val,
+ loading: false
+ })
+ }, () => { // 楠岃瘉澶辫触
+ this.setState({
+ loading: false
+ })
+ }, activeKey)
}
}
+ // 鑷畾涔夎剼鏈慨鏀�
+ scriptsChange = (scripts) => {
+ return new Promise((resolve, reject) => {
+ this.sqlverify(resolve, reject, 'verify', scripts)
+ })
+ }
+
+ // 鑷畾涔夎剼鏈洿鏂�
+ scriptsUpdate = (scripts) => {
+ this.setState({scripts})
+ }
+
render() {
- const { type, menu, dict, permFuncField } = this.props
- const { loading, activeKey, setting, scriptsColumns, systemScripts, arr_field, defaultSql, regoptions, search, columns, scripts } = this.state
+ const { config, menu, dict, permFuncField } = this.props
+ const { loading, activeKey, setting, defaultSql, columns, scripts } = this.state
return (
- <div className="model-table-setting-form-box" id="model-table-setting-form-box">
+ <div className="model-table-setting-form-box" id="model-setting-form-body">
{loading && <Spin size="large" />}
<Tabs activeKey={activeKey} className="verify-card-box" onChange={this.changeTab}>
<TabPane tab="鏁版嵁婧�" key="setting">
<DataSource
- type={type}
+ type={config.Template === 'CommonTable' ? 'main' : ''}
menu={menu}
dict={dict}
columns={columns}
@@ -550,26 +395,14 @@
</TabPane>
<TabPane tab="鑷畾涔夎剼鏈�" key="scripts">
<CustomScript
- type={type}
dict={dict}
- swhere={search}
setting={setting}
scripts={scripts}
- arr_field={arr_field}
defaultSql={defaultSql}
- regoptions={regoptions}
searches={this.props.search}
- systemScripts={systemScripts}
scriptsChange={this.scriptsChange}
+ scriptsUpdate={this.scriptsUpdate}
wrappedComponentRef={(inst) => this.scriptsForm = inst}
- />
- <Table
- bordered
- rowKey="uuid"
- className="custom-table"
- dataSource={scripts}
- columns={scriptsColumns}
- pagination={false}
/>
</TabPane>
</Tabs>
--
Gitblit v1.8.0