import React, {Component} from 'react'
|
import { fromJS } from 'immutable'
|
import { Tooltip, Select, List, notification } from 'antd'
|
import { QuestionCircleOutlined, CloseOutlined } from '@ant-design/icons'
|
import moment from 'moment'
|
|
import Api from '@/api'
|
import Utils from '@/utils/utils.js'
|
import MKEmitter from '@/utils/events.js'
|
import { queryTableSql } from '@/utils/option.js'
|
|
import './index.scss'
|
|
const { Option } = Select
|
|
class TablesComponent extends Component {
|
state = {
|
tables: [], // 系统表
|
selectedTables: [], // 已选表
|
}
|
|
/**
|
* @description 搜索条件初始化
|
*/
|
UNSAFE_componentWillMount () {
|
this.setState({
|
selectedTables: window.GLOB.publicTables ? fromJS(window.GLOB.publicTables).toJS() : []
|
})
|
}
|
|
componentDidMount () {
|
this.gettables()
|
}
|
|
/**
|
* @description 获取系统表
|
*/
|
gettables = () => {
|
let param = {
|
func: 'sPC_Get_SelectedList',
|
LText: queryTableSql,
|
obj_name: 'data',
|
arr_field: 'TbName,Remark'
|
}
|
|
param.LText = Utils.formatOptions(param.LText)
|
param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
|
param.secretkey = Utils.encrypt(param.LText, param.timestamp)
|
param.open_key = Utils.encryptOpenKey(param.secretkey, param.timestamp) // 云端数据验证
|
|
if (window.GLOB.cloudServiceApi) { // 且存在云端地址
|
param.rduri = window.GLOB.cloudServiceApi
|
param.userid = sessionStorage.getItem('CloudUserID') || ''
|
param.LoginUID = sessionStorage.getItem('CloudLoginUID') || ''
|
}
|
|
Api.getSystemCacheConfig(param).then(res => {
|
if (res.status) {
|
this.setState({
|
tables: res.data
|
})
|
} else {
|
notification.warning({
|
top: 92,
|
message: res.message,
|
duration: 5
|
})
|
}
|
})
|
}
|
|
/**
|
* @description 添加表名
|
*/
|
onTableChange = (value) => {
|
const { tables, selectedTables } = this.state
|
|
let _table = tables.filter(item => item.TbName === value)[0]
|
let isSelected = !!selectedTables.filter(cell => cell.TbName === value)[0]
|
if (!isSelected) {
|
let _tables = [...selectedTables, _table]
|
|
MKEmitter.emit('publicTableChange', value, 'plus')
|
|
this.setState({
|
selectedTables: _tables
|
})
|
}
|
}
|
|
/**
|
* @description 删除表名
|
*/
|
deleteTable = (table) => {
|
const { selectedTables } = this.state
|
|
let _tables = selectedTables.filter(item => item.TbName !== table.TbName)
|
|
MKEmitter.emit('publicTableChange', table, 'del')
|
|
this.setState({
|
selectedTables: _tables
|
})
|
}
|
|
/**
|
* @description 组件销毁，清除state更新
|
*/
|
componentWillUnmount () {
|
this.setState = () => {
|
return
|
}
|
}
|
|
render() {
|
const { tables, selectedTables } = this.state
|
|
return (
|
<div className="model-tablename-manage-view">
|
{/* 表名添加 */}
|
<div className="ant-col ant-form-item-label">
|
<label>
|
<Tooltip placement="topLeft" title="此处可以添加页面配置相关的常用表。">
|
<QuestionCircleOutlined className="mk-form-tip" />
|
表名
|
</Tooltip>
|
</label>
|
</div>
|
<Select
|
showSearch
|
className="tables"
|
style={{ width: '100%' }}
|
optionFilterProp="children"
|
value="请选择表名"
|
onSelect={this.onTableChange}
|
dropdownClassName="mk-tables"
|
dropdownMatchSelectWidth={false}
|
showArrow={false}
|
filterOption={(input, option) => {
|
return option.props.children[0].toLowerCase().indexOf(input.toLowerCase()) >= 0 ||
|
option.props.children[2].toLowerCase().indexOf(input.toLowerCase()) >= 0
|
}}
|
>
|
{tables.map((table, index) => (
|
<Option key={index} title={table.TbName} value={table.TbName}>{table.Remark}<br/>{table.TbName}</Option>
|
))}
|
</Select>
|
{selectedTables.length > 0 && <List
|
size="small"
|
bordered
|
dataSource={selectedTables}
|
renderItem={(item, index) => <List.Item key={index} title={item.Remark + ' (' + item.TbName + ')'}>
|
{item.Remark + ' (' + item.TbName + ')'}
|
<CloseOutlined onClick={() => this.deleteTable(item)}/>
|
</List.Item>}
|
/>}
|
</div>
|
)
|
}
|
}
|
|
export default TablesComponent
|
