import React, {Component} from 'react'
|
import PropTypes from 'prop-types'
|
import { fromJS } from 'immutable'
|
import { Form, Tabs, Popconfirm, Icon, notification, Modal, Typography, Spin, message } from 'antd'
|
import { StopOutlined, CheckCircleOutlined } from '@ant-design/icons'
|
import moment from 'moment'
|
|
import Api from '@/api'
|
import Utils from '@/utils/utils.js'
|
|
import asyncComponent from '@/utils/asyncComponent'
|
import ColForm from './columnform'
|
import CustomScriptsForm from './customscript'
|
import SettingForm from './settingform'
|
import SettingUtils from './utils'
|
import './index.scss'
|
|
const { TabPane } = Tabs
|
const { Paragraph } = Typography
|
|
const FieldsComponent = asyncComponent(() => import('@/templates/sharecomponent/fieldscomponent'))
|
const EditTable = asyncComponent(() => import('@/templates/zshare/editTable'))
|
|
class VerifyCard extends Component {
|
static propTpyes = {
|
dict: PropTypes.object, // 字典项
|
menu: PropTypes.object, // 菜单配置信息
|
config: PropTypes.object, // 组件配置信息
|
}
|
|
state = {
|
columns: [],
|
activeKey: 'setting',
|
loading: false,
|
initsql: '', // sql验证时变量声明及赋值
|
usefulfields: '',
|
defaultsql: '', // 默认Sql
|
defaultSearch: '',
|
systemScripts: [],
|
colColumns: [
|
{
|
title: '名称',
|
dataIndex: 'label',
|
inputType: 'input',
|
editable: true,
|
width: '28%'
|
},
|
{
|
title: '字段',
|
dataIndex: 'field',
|
inputType: 'input',
|
editable: true,
|
unique: true,
|
copy: true,
|
width: '28%'
|
},
|
{
|
title: '数据类型',
|
dataIndex: 'datatype',
|
inputType: 'select',
|
options: [
|
{ value: 'Nvarchar(10)', text: 'Nvarchar(10)' },
|
{ value: 'Nvarchar(20)', text: 'Nvarchar(20)' },
|
{ value: 'Nvarchar(50)', text: 'Nvarchar(50)' },
|
{ value: 'Nvarchar(100)', text: 'Nvarchar(100)' },
|
{ value: 'Nvarchar(512)', text: 'Nvarchar(512)' },
|
{ value: 'Nvarchar(1024)', text: 'Nvarchar(1024)' },
|
{ value: 'Nvarchar(2048)', text: 'Nvarchar(2048)' },
|
{ value: 'Nvarchar(max)', text: 'Nvarchar(max)' },
|
{ value: 'Int', text: 'Int' },
|
{ value: 'Decimal(18,0)', text: 'Decimal(18,0)' },
|
{ value: 'Decimal(18,1)', text: 'Decimal(18,1)' },
|
{ value: 'Decimal(18,2)', text: 'Decimal(18,2)' },
|
{ value: 'Decimal(18,3)', text: 'Decimal(18,3)' },
|
{ value: 'Decimal(18,4)', text: 'Decimal(18,4)' },
|
{ value: 'Decimal(18,5)', text: 'Decimal(18,5)' },
|
{ value: 'Decimal(18,6)', text: 'Decimal(18,6)' },
|
{ value: 'Decimal(18,7)', text: 'Decimal(18,7)' },
|
{ value: 'Decimal(18,8)', text: 'Decimal(18,8)' },
|
{ value: 'Decimal(18,9)', text: 'Decimal(18,9)' },
|
{ value: 'Decimal(18,10)', text: 'Decimal(18,10)' },
|
{ value: 'Decimal(18,11)', text: 'Decimal(18,11)' },
|
{ value: 'Decimal(18,12)', text: 'Decimal(18,12)' },
|
{ value: 'Decimal(18,13)', text: 'Decimal(18,13)' },
|
{ value: 'Decimal(18,14)', text: 'Decimal(18,14)' },
|
{ value: 'Decimal(18,15)', text: 'Decimal(18,15)' },
|
{ value: 'Decimal(18,16)', text: 'Decimal(18,16)' },
|
{ value: 'Decimal(18,17)', text: 'Decimal(18,17)' },
|
{ value: 'Decimal(18,18)', text: 'Decimal(18,18)' },
|
{ value: 'date', text: 'date' },
|
{ value: 'datetime', text: 'datetime' },
|
],
|
editable: true,
|
width: '25%',
|
}
|
],
|
scriptsColumns: [
|
{
|
title: 'SQL',
|
dataIndex: 'sql',
|
width: '72%',
|
render: (text) => {
|
let title = text.match(/^\s*\/\*.+\*\//)
|
title = title && title[0] ? title[0] : ''
|
text = title ? text.replace(title, '') : text
|
|
return (
|
<div>
|
{title ? <span style={{color: '#a50'}}>{title}</span> : null}
|
<Paragraph copyable ellipsis={{ rows: 4, expandable: true }}>{text}</Paragraph>
|
</div>
|
)
|
}
|
},
|
{
|
title: '状态',
|
dataIndex: 'status',
|
width: '13%',
|
render: (text, record) => record.status === 'false' ?
|
(
|
<div style={{color: '#ff4d4f'}}>
|
{this.props.dict['model.status.forbidden']}
|
<StopOutlined style={{marginLeft: '5px'}} />
|
</div>
|
) :
|
(
|
<div style={{color: '#26C281'}}>
|
{this.props.dict['model.status.open']}
|
<CheckCircleOutlined style={{marginLeft: '5px'}}/>
|
</div>
|
)
|
},
|
{
|
title: '操作',
|
align: 'center',
|
width: '15%',
|
dataIndex: 'operation',
|
render: (text, record) =>
|
(<div style={{textAlign: 'center'}}>
|
<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['model.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.deleteScript(record)
|
}>
|
<span className="operation-btn" style={{color: '#ff4d4f'}}><Icon type="delete" /></span>
|
</Popconfirm>
|
</div>)
|
}
|
]
|
}
|
|
UNSAFE_componentWillMount() {
|
const { config, mainSearch } = this.props
|
|
let search = config.search || []
|
|
if (config.setting.useMSearch === 'true') { // 使用主搜索条件
|
search = [...search, ...mainSearch]
|
}
|
|
let _setting = fromJS(config.setting).toJS()
|
let scripts = fromJS(config.scripts).toJS()
|
|
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')
|
if (_setting.dataresource) {
|
_setting.dataresource = _setting.dataresource.replace(reg, `$ex@${m.func_code}@ex$`)
|
}
|
scripts && scripts.forEach(item => {
|
item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`)
|
})
|
})
|
}
|
|
let _search = this.formatSearch(search)
|
_search = Utils.joinMainSearchkey(_search)
|
|
_search = _search.replace(/@\$@/ig, '')
|
_search = _search ? 'where ' + _search : ''
|
|
this.setState({
|
scripts,
|
columns: fromJS(config.columns).toJS(),
|
setting: _setting,
|
searches: search,
|
defaultSearch: _search
|
})
|
|
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')
|
_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.forEach(item => {
|
let _item = {
|
name: item.funcname,
|
value: window.decodeURIComponent(window.atob(item.longparam))
|
}
|
|
_scripts.push(_item)
|
})
|
|
this.setState({
|
systemScripts: _scripts
|
})
|
} else {
|
notification.warning({
|
top: 92,
|
message: res.message,
|
duration: 5
|
})
|
}
|
})
|
}
|
|
columnChange = (values) => {
|
const { columns } = this.state
|
|
let fields = columns.map(item => item.field.toLowerCase())
|
if (fields.includes(values.field.toLowerCase())) {
|
notification.warning({
|
top: 92,
|
message: '字段已存在！',
|
duration: 5
|
})
|
return
|
}
|
|
values.uuid = Utils.getuuid()
|
|
this.setState({ columns: [...columns, values] })
|
}
|
|
deleteScript = (record) => {
|
this.setState({ scripts: this.state.scripts.filter(item => item.uuid !== record.uuid) })
|
}
|
|
handleEdit = (record) => {
|
this.scriptsForm.edit(record)
|
|
let node = document.getElementById('model-data-source-wrap').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)
|
}
|
}, 10)
|
}
|
}
|
|
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
|
}
|
})
|
|
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
|
} else {
|
return item
|
}
|
})
|
} else {
|
scripts.push(values)
|
}
|
|
return new Promise((resolve, reject) => {
|
this.sqlverify(resolve, reject, false, scripts)
|
})
|
}
|
|
changeScripts = (scripts) => {
|
this.setState({ scripts })
|
}
|
|
scriptSubmit = (values) => {
|
let scripts = fromJS(this.state.scripts).toJS()
|
|
if (values.uuid) {
|
scripts = scripts.map(item => {
|
if (item.uuid === values.uuid) {
|
return values
|
} else {
|
return item
|
}
|
})
|
} else {
|
values.uuid = Utils.getuuid()
|
scripts.push(values)
|
}
|
|
this.setState({ scripts })
|
}
|
|
changeTab = (val) => {
|
const { config, mainSearch } = this.props
|
const { activeKey } = this.state
|
|
this.setState({loading: true})
|
if (activeKey === 'setting') {
|
this.settingForm.handleConfirm().then(res => {
|
let search = config.search || []
|
|
if (res.useMSearch === 'true') { // 使用主搜索条件
|
search = [...search, ...mainSearch]
|
}
|
|
let _search = this.formatSearch(search)
|
_search = Utils.joinMainSearchkey(_search)
|
|
_search = _search.replace(/@\$@/ig, '')
|
_search = _search ? 'where ' + _search : ''
|
|
this.setState({
|
searches: search,
|
defaultSearch: _search,
|
setting: res
|
}, () => {
|
this.sqlverify(() => { // 验证成功
|
this.setState({
|
activeKey: val,
|
loading: false
|
})
|
this.getdefaultSql()
|
}, () => { // 验证失败
|
this.setState({
|
activeKey: val,
|
loading: false
|
})
|
this.getdefaultSql()
|
}, true)
|
})
|
}, () => {
|
this.setState({loading: false})
|
})
|
} else if (activeKey === 'columns') {
|
this.setState({
|
activeKey: val,
|
loading: false
|
})
|
this.getdefaultSql()
|
} else if (activeKey === 'scripts') {
|
let _loading = false
|
if (this.scriptsForm && this.scriptsForm.state.editItem) {
|
_loading = true
|
} else if (this.scriptsForm && this.scriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.scriptsForm.props.form.getFieldValue('sql'))) {
|
_loading = true
|
}
|
|
if (_loading) {
|
notification.warning({
|
top: 92,
|
message: '存在未保存脚本，请点击确定保存，或点击取消放弃修改！',
|
duration: 5
|
})
|
this.setState({
|
loading: false
|
})
|
return
|
}
|
|
this.setState({
|
activeKey: val,
|
loading: false
|
})
|
}
|
}
|
|
getdefaultSql = () => {
|
const { columns, setting, defaultSearch } = this.state
|
let defaultsql = ''
|
let arr_field = columns.map(col => col.field).join(',')
|
|
if (setting.dataresource) {
|
let _dataresource = setting.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} ${defaultSearch}) tmptable where rows > (@pageSize@ * (@pageIndex@ - 1)) order by tmptable.rows`
|
}
|
|
this.setState({defaultsql})
|
}
|
|
/**
|
* @description 获取全部搜索条件
|
* @param {Array} searches 搜索条件数组
|
*/
|
formatSearch (searches) {
|
if (!searches) 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 === 'range') {
|
|
} else if (item.type === 'multiselect' || (item.type === 'checkcard' && search.multiple === 'true')) {
|
item.type = 'multi'
|
item.value = '@$@'
|
} else {
|
item.value = '@$@'
|
}
|
newsearches.push(item)
|
})
|
|
return newsearches
|
}
|
|
submitDataSource = () => {
|
const { config, mainSearch } = this.props
|
const { activeKey, setting, columns, scripts } = this.state
|
|
return new Promise((resolve, reject) => {
|
if (activeKey === 'setting') {
|
this.settingForm.handleConfirm().then(res => {
|
let search = config.search || []
|
|
if (res.useMSearch === 'true') { // 使用主搜索条件
|
search = [...search, ...mainSearch]
|
}
|
|
let _search = this.formatSearch(search)
|
_search = Utils.joinMainSearchkey(_search)
|
|
_search = _search.replace(/@\$@/ig, '')
|
_search = _search ? 'where ' + _search : ''
|
|
this.setState({
|
searches: search,
|
defaultSearch: _search,
|
setting: res
|
}, () => {
|
this.sqlverify(() => { resolve({setting: res, columns, scripts }) }, reject, false)
|
})
|
}, () => {
|
reject()
|
})
|
} else if (activeKey === 'columns') {
|
this.sqlverify(() => { resolve({setting, columns, scripts }) }, reject, false)
|
} else if (activeKey === 'scripts') {
|
let _loading = false
|
if (this.scriptsForm && this.scriptsForm.state.editItem) {
|
_loading = true
|
} else if (this.scriptsForm && this.scriptsForm.props.form.getFieldValue('sql') && !/^\s+$/.test(this.scriptsForm.props.form.getFieldValue('sql'))) {
|
_loading = true
|
}
|
|
if (_loading) {
|
notification.warning({
|
top: 92,
|
message: '存在未保存脚本，请点击确定保存，或点击取消放弃修改！',
|
duration: 5
|
})
|
reject()
|
return
|
}
|
|
this.sqlverify(() => { resolve({setting, columns, scripts }) }, reject, false)
|
}
|
})
|
}
|
|
sqlverify = (resolve, reject, change = false, testScripts) => {
|
const { columns, setting, scripts, searches, defaultSearch } = this.state
|
|
let _scripts = scripts.filter(item => item.status !== 'false')
|
|
if (testScripts) {
|
_scripts = testScripts.filter(item => item.status !== 'false')
|
}
|
if (!change && setting.interType === 'system' && setting.execute === 'false' && _scripts.length === 0) {
|
notification.warning({
|
top: 92,
|
message: '不执行默认sql时，请添加自定义脚本！',
|
duration: 5
|
})
|
reject()
|
return
|
}
|
|
if ((setting.interType === 'system' && setting.execute !== 'false') || _scripts.length > 0) {
|
let r = SettingUtils.getDebugSql(setting, _scripts, columns, searches, defaultSearch)
|
|
if (r.error) {
|
notification.warning({
|
top: 92,
|
message: r.error,
|
duration: 5
|
})
|
reject()
|
return
|
}
|
|
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
|
})
|
}
|
})
|
} else {
|
resolve()
|
}
|
}
|
|
updatefields = (columns) => {
|
this.setState({
|
columns: columns
|
})
|
}
|
|
copyColumns = () => {
|
const { columns } = this.state
|
let m = []
|
let n = []
|
|
columns.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更新
|
*/
|
componentWillUnmount () {
|
this.setState = () => {
|
return
|
}
|
}
|
|
render() {
|
const { menu, config } = this.props
|
const { columns, setting, scripts, colColumns, scriptsColumns, activeKey, loading, searches, defaultsql } = this.state
|
|
return (
|
<div id="model-data-source-wrap">
|
{loading && <Spin size="large" />}
|
<Tabs activeKey={activeKey} className="data-source-card-box" onChange={this.changeTab}>
|
<TabPane tab="数据源" key="setting">
|
<SettingForm
|
menu={menu}
|
dict={this.props.dict}
|
config={config}
|
columns={columns}
|
setting={setting}
|
scripts={scripts}
|
wrappedComponentRef={(inst) => this.settingForm = inst}
|
/>
|
</TabPane>
|
<TabPane tab="字段集" key="columns">
|
<ColForm dict={this.props.dict} columnChange={this.columnChange}/>
|
<FieldsComponent
|
config={{...config, columns}}
|
type="fields"
|
updatefield={this.updatefields}
|
/>
|
<Icon type="copy" title="以逗号拼接形式复制字段" onClick={this.copyColumns} style={{position: 'absolute', cursor: 'pointer', zIndex: 1, top: '-35px', right: '0px', color: '#1890ff'}} />
|
<EditTable actions={['edit', 'move', 'copy', 'del', 'clear']} type="datasourcefield" data={columns} columns={colColumns} onChange={(columns) => this.setState({columns})}/>
|
</TabPane>
|
<TabPane tab={
|
<span>
|
自定义脚本
|
{scripts.length ? <span className="count-tip">{scripts.length}</span> : null}
|
</span>
|
} key="scripts">
|
<CustomScriptsForm
|
setting={setting}
|
searches={searches}
|
defaultsql={defaultsql}
|
initsql={this.state.initsql}
|
dict={this.props.dict}
|
customScripts={scripts}
|
systemScripts={this.state.systemScripts}
|
scriptsChange={this.scriptsChange}
|
scriptSubmit={this.scriptSubmit}
|
wrappedComponentRef={(inst) => this.scriptsForm = inst}
|
/>
|
<EditTable actions={['move']} data={scripts} columns={scriptsColumns} onChange={this.changeScripts}/>
|
</TabPane>
|
</Tabs>
|
</div>
|
)
|
}
|
}
|
|
export default Form.create()(VerifyCard)
|
