import React, {Component} from 'react'
|
import PropTypes from 'prop-types'
|
import { fromJS } from 'immutable'
|
import { Form, notification, Modal, Spin, Tabs, Typography, Popconfirm, Button } from 'antd'
|
import { CheckCircleOutlined, StopOutlined, SwapOutlined, DeleteOutlined, BorderOutlined } from '@ant-design/icons'
|
import moment from 'moment'
|
|
import Api from '@/api'
|
import Utils from '@/utils/utils.js'
|
import SettingUtils from './utils.jsx'
|
import asyncComponent from '@/utils/asyncComponent'
|
import DataSource from './datasource'
|
import MinView from '@/assets/img/minview.png'
|
import './index.scss'
|
|
const { TabPane } = Tabs
|
const { Paragraph } = Typography
|
const CodeMirror = asyncComponent(() => import('@/templates/zshare/codemirror'))
|
const CustomScript = asyncComponent(() => import('@/templates/zshare/customscript'))
|
const SimpleScript = asyncComponent(() => import('./simplescript'))
|
|
class SettingForm extends Component {
|
static propTpyes = {
|
dict: PropTypes.object, // 字典项
|
menu: PropTypes.object, // 菜单信息
|
config: PropTypes.object, // 页面配置信息
|
search: PropTypes.array, // 搜索条件
|
updRecord: PropTypes.func
|
}
|
|
state = {
|
formlist: [],
|
btnloading: false,
|
activeKey: 'setting',
|
search: '',
|
arr_field: '',
|
regoptions: [],
|
setting: null,
|
defaultSql: '',
|
visible: false,
|
script: null,
|
scriptValue: '',
|
status: {}
|
}
|
|
UNSAFE_componentWillMount() {
|
const { config, search } = this.props
|
|
let _setting = fromJS(config.setting).toJS()
|
let _scripts = _setting.scripts || []
|
let _preScripts = _setting.preScripts || []
|
let _cbScripts = _setting.cbScripts || []
|
|
_setting.default = _setting.default || 'true' // 默认sql
|
_setting.sysInterface = _setting.sysInterface || 'false' // 是否为系统接口
|
_setting.interface = _setting.sysInterface === 'true' ? (window.GLOB.mainSystemApi || '') : (_setting.interface || '')
|
|
// 显示列字段，用于查询
|
let columns = []
|
let arr_field = []
|
config.columns.forEach(col => {
|
if (col.field) {
|
columns.push({
|
value: col.field,
|
text: col.label
|
})
|
arr_field.push(col.field)
|
}
|
if (col.nameField) { // 链接的名称字段
|
arr_field.push(col.nameField)
|
}
|
})
|
|
if (_setting.primaryKey && !arr_field.includes(_setting.primaryKey)) {
|
_setting.primaryKey = ''
|
}
|
if (!_setting.primaryKey && arr_field.length > 0) {
|
arr_field.forEach(field => {
|
if (field.toLowerCase() === 'id') {
|
_setting.primaryKey = field
|
}
|
})
|
}
|
|
// 搜索的where条件
|
let _search = this.formatSearch(search)
|
_search = Utils.joinMainSearchkey(_search)
|
|
_search = _search.replace(/@\$@/ig, '')
|
_search = _search ? 'where ' + _search : ''
|
|
let status = fromJS(_setting).toJS()
|
status.requestMode = status.requestMode || 'system'
|
status.procMode = status.procMode || 'script'
|
status.callbackType = status.callbackType || 'script'
|
let regoptions = this.getRegOptions(search)
|
|
if (config.urlFields && config.urlFields.length > 0) {
|
config.urlFields.forEach(field => {
|
regoptions.push({
|
key: field,
|
value: '0',
|
type: 'url'
|
})
|
})
|
}
|
|
if (window.GLOB.funcs && window.GLOB.funcs.length > 0) {
|
window.GLOB.funcs.forEach(m => {
|
let reg = new RegExp(`\\/\\*\\$ex@${m.func_code}-begin\\*\\/[\\s\\S]+\\/\\*@ex\\$-end\\*\\/`, 'ig')
|
_scripts.forEach(item => {
|
item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`)
|
})
|
_preScripts.forEach(item => {
|
item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`)
|
})
|
_cbScripts.forEach(item => {
|
item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`)
|
})
|
if (_setting.dataresource) {
|
_setting.dataresource = _setting.dataresource.replace(reg, `$ex@${m.func_code}@ex$`)
|
}
|
})
|
}
|
|
this.setState({
|
setting: _setting,
|
search: _search,
|
arr_field: arr_field.join(','),
|
regoptions: regoptions, // 搜索条件，正则替换
|
columns: columns,
|
scripts: _scripts,
|
preScripts: _preScripts,
|
cbScripts: _cbScripts,
|
status
|
})
|
}
|
|
componentDidMount () {
|
this.props.updRecord(this.state.status)
|
}
|
|
getRegOptions = (searches) => {
|
if (!searches || searches.length === 0) return []
|
|
let options = []
|
let fieldmap = new Map()
|
searches.forEach(search => {
|
let item = {
|
key: search.field,
|
value: '0'
|
}
|
|
if (fieldmap.has(item.key)) {
|
item.key = item.key + '1'
|
}
|
|
fieldmap.set(item.key, true)
|
|
if (search.type === 'group') {
|
options.push({
|
key: search.field,
|
value: '0'
|
})
|
options.push({
|
key: search.datefield,
|
value: '0'
|
})
|
options.push({
|
key: search.datefield + '1',
|
value: '0'
|
})
|
options.push(item)
|
} else if (['datemonth', 'dateweek', 'daterange'].includes(search.type)) {
|
options.push(item)
|
options.push({
|
key: item.key + '1',
|
value: '0'
|
})
|
} else if (search.type === 'text' || search.type === 'select') {
|
item.key.split(',').forEach(field => {
|
let cell = JSON.parse(JSON.stringify(item))
|
cell.key = field
|
|
options.push(cell)
|
})
|
} else {
|
options.push(item)
|
}
|
})
|
|
return options
|
}
|
|
/**
|
* @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
|
}
|
|
handleConfirm = (trigger) => {
|
const { activeKey, setting, scripts, preScripts, cbScripts } = this.state
|
|
let _loading = false
|
if (this.scriptsForm && this.scriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.scriptsForm.props.form.getFieldValue('sql'))) {
|
_loading = true
|
} else if (this.preScriptsForm && this.preScriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.preScriptsForm.props.form.getFieldValue('sql'))) {
|
_loading = true
|
} else if (this.cbScriptsForm && this.cbScriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.cbScriptsForm.props.form.getFieldValue('sql'))) {
|
_loading = true
|
}
|
|
if (_loading) {
|
notification.warning({
|
top: 92,
|
message: '存在未保存脚本，请点击确定保存，或点击取消放弃修改！',
|
duration: 5
|
})
|
return Promise.reject()
|
}
|
|
if (trigger) {
|
this.setState({loading: true})
|
}
|
|
// 表单提交时检查输入值是否正确
|
if (activeKey === 'setting') {
|
return new Promise((resolve, reject) => {
|
this.settingForm.handleConfirm().then(res => {
|
this.setState({
|
setting: res
|
}, () => {
|
this.sqlverify(() => {
|
this.setState({loading: false})
|
resolve({...res, scripts, preScripts, cbScripts})
|
}, () => {
|
this.setState({loading: false})
|
reject()
|
}, 'submit')
|
})
|
}, () => {
|
this.setState({loading: false})
|
reject()
|
})
|
})
|
} else if (activeKey === 'scripts') {
|
return new Promise((resolve, reject) => {
|
this.sqlverify(() => {
|
this.setState({loading: false})
|
resolve({...setting, scripts, preScripts, cbScripts})
|
}, () => {
|
this.setState({loading: false})
|
reject()
|
}, 'submit')
|
})
|
} else {
|
this.setState({loading: false})
|
return new Promise((resolve) => {
|
resolve({...setting, scripts, preScripts, cbScripts})
|
})
|
}
|
}
|
|
sqlverify = (_resolve, _reject, type, uscripts) => {
|
const { setting, scripts, arr_field, regoptions, search } = this.state
|
|
if (setting.interType !== 'system' && setting.requestMode !== 'system') { // 不使用系统接口时，不需要sql验证
|
_resolve()
|
return
|
}
|
|
let _scripts = []
|
if (uscripts) { // 过滤禁用的脚本
|
_scripts = uscripts.filter(script => script.status !== 'false')
|
} else {
|
_scripts = scripts.filter(script => script.status !== 'false')
|
}
|
|
if (type === 'setting' && setting.default === 'false') {
|
_resolve()
|
} else if (type === 'scripts' && _scripts.length === 0) {
|
_resolve()
|
} else { // type 为 submit 、 verify ，以及其他需要验证的场景
|
let r = SettingUtils.getDebugSql(setting, _scripts, arr_field, regoptions, search)
|
let param = {
|
func: 's_debug_sql',
|
exec_type: 'y',
|
LText: r.sql
|
}
|
param.LText = Utils.formatOptions(param.LText)
|
param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
|
param.secretkey = Utils.encrypt('', param.timestamp)
|
|
let sumParam = null
|
if (r.sumSql) {
|
sumParam = {
|
func: 's_debug_sql',
|
exec_type: 'y',
|
LText: r.sumSql
|
}
|
sumParam.LText = Utils.formatOptions(sumParam.LText)
|
sumParam.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
|
sumParam.secretkey = Utils.encrypt('', sumParam.timestamp)
|
}
|
|
Api.getLocalConfig(param).then(result => {
|
if (result.status) {
|
if (sumParam) {
|
Api.getLocalConfig(sumParam).then(res => {
|
if (res.status) {
|
_resolve()
|
} else {
|
_reject()
|
Modal.error({
|
title: res.message
|
})
|
}
|
})
|
} else {
|
_resolve()
|
}
|
} else {
|
_reject()
|
Modal.error({
|
title: result.message
|
})
|
}
|
})
|
}
|
}
|
|
// 标签切换
|
changeTab = (val) => {
|
const { activeKey, search, arr_field, setting } = this.state
|
|
let _loading = false
|
if (this.scriptsForm && this.scriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.scriptsForm.props.form.getFieldValue('sql'))) {
|
_loading = true
|
} else if (this.preScriptsForm && this.preScriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.preScriptsForm.props.form.getFieldValue('sql'))) {
|
_loading = true
|
} else if (this.cbScriptsForm && this.cbScriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.cbScriptsForm.props.form.getFieldValue('sql'))) {
|
_loading = true
|
}
|
|
if (_loading) {
|
notification.warning({
|
top: 92,
|
message: '存在未保存脚本，请点击确定保存，或点击取消放弃修改！',
|
duration: 5
|
})
|
return
|
}
|
|
if (activeKey !== 'setting') {
|
if (setting.interType !== 'system' && setting.requestMode !== 'system' && val === 'scripts') {
|
notification.warning({
|
top: 92,
|
message: '使用系统接口时，才可以设置自定义脚本！',
|
duration: 5
|
})
|
return
|
} else if (setting.interType !== 'custom' && (val === 'prescripts' || val === 'cbscripts')) {
|
notification.warning({
|
top: 92,
|
message: '使用自定义接口时，才可以设置前置或回调脚本！',
|
duration: 5
|
})
|
return
|
}
|
}
|
|
if (activeKey === 'setting') {
|
let _defaultSql = ''
|
this.settingForm.handleConfirm().then(res => {
|
if (res.interType !== 'system' && res.requestMode !== 'system' && val === 'scripts') {
|
notification.warning({
|
top: 92,
|
message: '使用系统接口时，才可以设置自定义脚本！',
|
duration: 5
|
})
|
return
|
} else if (res.interType !== 'custom' && (val === 'prescripts' || val === 'cbscripts')) {
|
notification.warning({
|
top: 92,
|
message: '使用自定义接口时，才可以设置前置或回调脚本！',
|
duration: 5
|
})
|
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,
|
defaultSql: _defaultSql
|
}, () => {
|
this.setState({loading: true})
|
this.sqlverify(() => { // 验证成功
|
this.setState({
|
activeKey: val,
|
loading: false
|
})
|
}, () => { // 验证失败
|
this.setState({
|
activeKey: val,
|
loading: false
|
})
|
}, activeKey)
|
})
|
})
|
} else if (activeKey === 'scripts') {
|
this.setState({loading: true})
|
this.sqlverify(() => { // 验证成功
|
this.setState({
|
activeKey: val,
|
loading: false
|
})
|
}, () => { // 验证失败
|
this.setState({
|
activeKey: val,
|
loading: false
|
})
|
}, activeKey)
|
} else {
|
this.setState({
|
activeKey: val
|
})
|
}
|
}
|
|
// 自定义脚本修改
|
scriptsChange = (scripts) => {
|
return new Promise((resolve, reject) => {
|
this.sqlverify(resolve, reject, 'verify', scripts)
|
})
|
}
|
|
triggerConfirm = () => {
|
const { script, scriptValue, scripts } = this.state
|
let _scripts = fromJS(scripts).toJS()
|
|
if (!scriptValue) {
|
notification.warning({
|
top: 92,
|
message: '请输入sql!',
|
duration: 5
|
})
|
return
|
}
|
|
if (script) {
|
_scripts = _scripts.map(item => {
|
if (script.uuid === item.uuid) {
|
item.sql = scriptValue
|
}
|
return item
|
})
|
} else {
|
let _script = {
|
uuid: Utils.getuuid(),
|
sql: scriptValue,
|
$index: _scripts.length + 1,
|
status: 'true'
|
}
|
|
_scripts.push(_script)
|
}
|
|
this.setState({loading: true})
|
|
this.sqlverify(() => {this.setState({scripts: _scripts, script: null, scriptValue: '', loading: false})}, () => {this.setState({loading: false})}, 'verify', _scripts)
|
}
|
|
// 自定义脚本更新
|
scriptsUpdate = (scripts) => {
|
this.setState({scripts})
|
}
|
|
// 前置脚本更新
|
preScriptsUpdate = (preScripts) => {
|
this.setState({preScripts})
|
}
|
|
// 后置脚本更新
|
cbScriptsUpdate = (cbScripts) => {
|
this.setState({cbScripts})
|
}
|
|
handleDelete = (item) => {
|
const { script, scripts } = this.state
|
|
if (script && script.uuid === item.uuid) {
|
this.setState({script: null})
|
}
|
this.setState({scripts: scripts.filter(cell => cell.uuid !== item.uuid)})
|
}
|
|
handleStatus = (item) => {
|
item.status = item.status === 'false' ? 'true' : 'false'
|
|
this.setState({scripts: this.state.scripts.map(cell => {
|
if (cell.uuid === item.uuid) {
|
return item
|
}
|
return cell
|
})})
|
}
|
|
updateStatus = (status) => {
|
let _status = {...this.state.status, ...status}
|
this.setState({status: _status})
|
this.props.updRecord(_status)
|
}
|
|
render() {
|
const { config, menu, dict } = this.props
|
const { loading, activeKey, setting, defaultSql, columns, scripts, preScripts, cbScripts, status, regoptions, visible, script, scriptValue } = this.state
|
|
return (
|
<div className="model-table-setting-form-box" id="model-setting-form-body">
|
{loading && <Spin size="large" />}
|
<Tabs activeKey={activeKey} onChange={this.changeTab}>
|
<TabPane tab="数据源" key="setting">
|
<DataSource
|
menu={menu}
|
dict={dict}
|
config={config}
|
columns={columns}
|
setting={setting}
|
scripts={scripts}
|
updateStatus={this.updateStatus}
|
wrappedComponentRef={(inst) => this.settingForm = inst}
|
/>
|
</TabPane>
|
<TabPane tab={
|
<span>
|
自定义脚本
|
{scripts.length ? <span className="count-tip">{scripts.length}</span> : null}
|
</span>
|
} disabled={!(status.interType === 'system' || (status.interType === 'custom' && status.requestMode === 'system'))} key="scripts">
|
<BorderOutlined className="full-scripts" onClick={() => {
|
if (this.scriptsForm && (this.scriptsForm.state.editItem || (this.scriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.scriptsForm.props.form.getFieldValue('sql'))))) {
|
notification.warning({
|
top: 92,
|
message: '请保存自定义脚本！',
|
duration: 5
|
})
|
return
|
}
|
this.setState({visible: true, script: null, scriptValue: ''})
|
}}/>
|
<CustomScript
|
dict={dict}
|
setting={setting}
|
scripts={scripts}
|
defaultSql={defaultSql}
|
urlFields={config.urlFields}
|
searches={this.props.search}
|
scriptsChange={this.scriptsChange}
|
scriptsUpdate={this.scriptsUpdate}
|
wrappedComponentRef={(inst) => this.scriptsForm = inst}
|
/>
|
</TabPane>
|
<TabPane tab={
|
<span>
|
前置脚本
|
{preScripts.length ? <span className="count-tip">{preScripts.length}</span> : null}
|
</span>
|
} disabled={status.interType !== 'custom' || status.procMode !== 'script'} key="prescripts">
|
<SimpleScript
|
dict={dict}
|
setting={setting}
|
scripts={preScripts}
|
regoptions={regoptions}
|
urlFields={config.urlFields}
|
searches={this.props.search}
|
scriptsUpdate={this.preScriptsUpdate}
|
wrappedComponentRef={(inst) => this.preScriptsForm = inst}
|
/>
|
</TabPane>
|
<TabPane tab={
|
<span>
|
回调脚本
|
{cbScripts.length ? <span className="count-tip">{cbScripts.length}</span> : null}
|
</span>
|
} disabled={status.interType !== 'custom' || status.callbackType !== 'script'} key="cbscripts">
|
<SimpleScript
|
dict={dict}
|
setting={setting}
|
scripts={cbScripts}
|
scriptsUpdate={this.cbScriptsUpdate}
|
wrappedComponentRef={(inst) => this.cbScriptsForm = inst}
|
/>
|
</TabPane>
|
</Tabs>
|
<Modal
|
wrapClassName="model-custom-table-scripts-modal"
|
title="自定义脚本"
|
visible={visible}
|
width={'95vw'}
|
maskClosable={false}
|
destroyOnClose
|
>
|
<img className="unfull-scripts" src={MinView} onClick={() => this.setState({visible: false, script: null})} alt=""/>
|
<div className="script-table-wrap">
|
{scripts.map(item => {
|
let title = item.sql.match(/^\s*\/\*.+\*\//)
|
title = title && title[0] ? title[0] : ''
|
let _text = title ? item.sql.replace(title, '') : item.sql
|
|
return (
|
<div className={'script-item ' + (script && script.uuid === item.uuid ? 'active' : '') } key={item.uuid}>
|
<div style={{cursor: 'pointer'}} onClick={() => {
|
this.setState({script: item, scriptValue: item.sql})
|
}}>
|
{title ? <div style={{color: '#a50', whiteSpace: 'nowrap', overflow: 'hidden', textOverflow: 'ellipsis'}}>{title}</div> : null}
|
<Paragraph copyable={{ text: item.sql }} ellipsis={{ rows: 4 }}>{_text}</Paragraph>
|
<div>{item.status === 'false' ?
|
<span style={{color: '#ff4d4f', marginLeft: '20px'}}>
|
禁用
|
<StopOutlined style={{marginLeft: '5px'}} />
|
</span> :
|
<span style={{color: '#26C281', marginLeft: '20px'}}>
|
启用
|
<CheckCircleOutlined style={{marginLeft: '5px'}}/>
|
</span>}
|
</div>
|
</div>
|
<div style={{textAlign: 'right'}}>
|
<span className="operation-btn" onClick={() => this.handleStatus(item)} style={{color: '#8E44AD'}}><SwapOutlined /></span>
|
<Popconfirm
|
overlayClassName="popover-confirm"
|
title={this.props.dict['model.query.delete']}
|
onConfirm={() => this.handleDelete(item)
|
}>
|
<span className="operation-btn" style={{color: '#ff4d4f'}}><DeleteOutlined /></span>
|
</Popconfirm>
|
</div>
|
</div>
|
)
|
})}
|
</div>
|
<div className="script-button">
|
<Button onClick={this.triggerConfirm} loading={loading} className="mk-green" style={{marginBottom: 15, marginLeft: 40}}>
|
{script ? '保存' : '添加'}
|
</Button>
|
<Button onClick={() => {this.setState({script: null, scriptValue: ''})}} style={{marginBottom: 15, marginLeft: 10}}>
|
取消
|
</Button>
|
</div>
|
<CodeMirror value={scriptValue} onChange={(val) => {this.setState({scriptValue: val})}}></CodeMirror>
|
</Modal>
|
</div>
|
)
|
}
|
}
|
|
export default Form.create()(SettingForm)
|
