import React, {Component} from 'react'
|
import PropTypes from 'prop-types'
|
import { is, fromJS } from 'immutable'
|
import { notification, Switch } from 'antd'
|
import moment from 'moment'
|
|
import Api from '@/api'
|
import zhCN from '@/locales/zh-CN/main.js'
|
import enUS from '@/locales/en-US/main.js'
|
import Utils from '@/utils/utils.js'
|
import options from '@/store/options.js'
|
import { scriptMainTable, buttonConfig } from './config'
|
|
import asyncSpinComponent from '@/utils/asyncSpinComponent'
|
import TopSearch from './topSearch'
|
import MainAction from './actionList'
|
import './index.scss'
|
|
const MainTable = asyncSpinComponent(() => import('@/tabviews/zshare/normalTable'))
|
|
class ScriptTable extends Component {
|
static propTpyes = {
|
MenuNo: PropTypes.string, // 菜单参数
|
MenuName: PropTypes.string, // 菜单参数
|
MenuID: PropTypes.string // 菜单Id
|
}
|
|
state = {
|
dict: sessionStorage.getItem('lang') !== 'en-US' ? zhCN : enUS,
|
ContainerId: Utils.getuuid(), // 菜单外层html Id
|
config: {}, // 页面配置信息，包括按钮、搜索、显示列、标签等
|
searchlist: [], // 搜索条件
|
actions: [], // 按钮集
|
columns: [], // 显示列
|
arr_field: '', // 使用 sPC_Get_TableData 时的查询字段集
|
logcolumns: null, // 日志中显示的列信息 (增加至全部列，除去合并列)
|
setting: {}, // 页面全局设置：数据源、按钮及显示列固定、主键等
|
data: [], // 列表数据集
|
selectedData: [], // 已选表格数据
|
resetTable: false, // 表格重置，值在true与false之间切换，切换时表格重置
|
total: 0, // 总数
|
loading: false, // 列表数据加载中
|
pageIndex: 1, // 页码
|
pageSize: 10, // 每页数据条数
|
orderBy: '', // 排序
|
search: '', // 搜索条件数组，使用时需分场景处理
|
pickup: false, // 主表数据隐藏显示切换
|
visible: false // 弹框显示隐藏控制
|
}
|
|
/**
|
* @description 获取页面配置信息
|
*/
|
async loadconfig () {
|
let config = scriptMainTable
|
|
let _arrField = [] // 字段集
|
let _columns = [] // 显示列
|
let _logcolumns = [] // 日志显示列
|
let _hideCol = [] // 隐藏及合并列中字段的uuid集
|
let colMap = new Map() // 用于字段过滤
|
|
// 1、筛选字段集，2、过滤隐藏列及合并列中的字段uuid
|
config.columns.forEach(col => {
|
if (col.field) {
|
_arrField.push(col.field)
|
|
_logcolumns.push(col)
|
}
|
if (col.type === 'colspan' && col.sublist) { // 筛选隐藏列
|
_hideCol = _hideCol.concat(col.sublist)
|
} else if (col.Hide === 'true') {
|
_hideCol.push(col.uuid)
|
}
|
colMap.set(col.uuid, col)
|
})
|
|
// 生成显示列，处理合并列中的字段
|
config.columns.forEach(col => {
|
if (_hideCol.includes(col.uuid)) return
|
|
if (col.type === 'colspan' && col.sublist) {
|
let _col = JSON.parse(JSON.stringify(col))
|
let subColumn = []
|
_col.sublist.forEach(sub => {
|
if (colMap.has(sub)) {
|
subColumn.push(colMap.get(sub))
|
}
|
})
|
_col.subColumn = subColumn
|
_columns.push(_col)
|
} else {
|
_columns.push(col)
|
}
|
})
|
|
this.setState({
|
config: config,
|
setting: config.setting,
|
searchlist: config.search,
|
actions: config.action.map(item => {
|
if (buttonConfig[item.uuid]) {
|
item = {...buttonConfig[item.uuid], ...item}
|
}
|
return item
|
}),
|
columns: _columns,
|
logcolumns: _logcolumns,
|
arr_field: _arrField.join(','),
|
search: Utils.initMainSearch(config.search)
|
}, () => {
|
this.setState({
|
loading: true
|
})
|
this.loadmaindata()
|
})
|
}
|
|
/**
|
* @description 主表数据加载
|
*/
|
async loadmaindata () {
|
let param = this.getDefaultParam()
|
|
this.setState({
|
pickup: false
|
})
|
|
if (options.cloudServiceApi) {
|
param.rduri = options.cloudServiceApi
|
}
|
|
let result = await Api.genericInterface(param)
|
if (result.status) {
|
this.setState({
|
data: result.data.map((item, index) => {
|
item.LongParam = Utils.UnformatOptions(item.LongParam)
|
item.key = index
|
return item
|
}),
|
total: result.total,
|
loading: false
|
})
|
} else {
|
this.setState({
|
loading: false
|
})
|
notification.error({
|
top: 92,
|
message: result.message,
|
duration: 10
|
})
|
}
|
}
|
|
/**
|
* @description 获取系统存储过程 sPC_Get_TableData 的参数
|
*/
|
getDefaultParam = () => {
|
const { arr_field, pageIndex, pageSize, orderBy, search, setting } = this.state
|
|
let _search = Utils.joinMainSearchkey(search)
|
|
_search = _search ? 'where ' + _search : ''
|
|
let param = {
|
func: 'sPC_Get_TableData',
|
obj_name: 'data',
|
arr_field: arr_field
|
}
|
|
let _orderBy = orderBy || setting.order
|
let _dataresource = setting.dataresource
|
|
if (/\s/.test(_dataresource)) {
|
_dataresource = '(' + _dataresource + ') tb'
|
}
|
|
let LText = `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`
|
let DateCount = `select count(1) as total from ${_dataresource} ${_search}`
|
|
param.LText = Utils.formatOptions(LText)
|
param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
|
param.secretkey = Utils.encrypt(param.LText, param.timestamp)
|
param.DateCount = Utils.formatOptions(DateCount)
|
|
param.open_key = Utils.encryptOpenKey(param.secretkey, param.timestamp) // 云端数据验证
|
|
return param
|
}
|
|
/**
|
* @description 搜索条件改变时，重置表格数据
|
* 含有初始不加载的页面，修改设置
|
*/
|
refreshbysearch = (searches) => {
|
this.setState({
|
loading: true,
|
pageIndex: 1,
|
selectedData: [],
|
search: searches,
|
resetTable: !this.state.resetTable
|
}, () => {
|
this.loadmaindata()
|
})
|
}
|
|
/**
|
* @description 表格条件改变时重置数据（分页或排序）
|
*/
|
refreshbytable = (pagination, filters, sorter) => {
|
if (sorter.order) {
|
let _chg = {
|
ascend: 'asc',
|
descend: 'desc'
|
}
|
sorter.order = _chg[sorter.order]
|
}
|
|
this.setState({
|
loading: true,
|
selectedData: [],
|
pageIndex: pagination.current,
|
pageSize: pagination.pageSize,
|
orderBy: (sorter.field && sorter.order) ? `${sorter.field} ${sorter.order}` : ''
|
}, () => {
|
this.loadmaindata()
|
})
|
}
|
|
/**
|
* @description 表格刷新
|
*/
|
reloadtable = () => {
|
this.setState({
|
loading: true,
|
pageIndex: 1,
|
selectedData: [],
|
resetTable: !this.state.resetTable
|
}, () => {
|
this.loadmaindata()
|
})
|
}
|
|
/**
|
* @description 页面刷新，重新获取配置
|
*/
|
reloadview = () => {
|
this.setState({ config: {}, searchlist: [], actions: [], columns: [], arr_field: '', setting: {}, data: [], total: 0,
|
loading: false, pageIndex: 1, pageSize: 10, orderBy: '', search: '', pickup: false, selectedData: []
|
}, () => {
|
this.loadconfig()
|
})
|
}
|
|
/**
|
* @description 按钮操作完成后（成功或失败），页面刷新，重置页码及选择项
|
*/
|
refreshbyaction = (btn, type) => {
|
if (btn.execSuccess === 'grid' && type === 'success') {
|
this.reloadtable()
|
} else if (btn.execError === 'grid' && type === 'error') {
|
this.reloadtable()
|
} else if (btn.execSuccess === 'view' && type === 'success') {
|
this.reloadview()
|
} else if (btn.execError === 'view' && type === 'error') {
|
this.reloadview()
|
}
|
}
|
|
/**
|
* @description 表格选择项切换
|
*/
|
changeSelectedData = (selectedData) => {
|
this.setState({selectedData})
|
}
|
|
/**
|
* @description 数据展开合并切换
|
*/
|
pickupChange = () => {
|
const { pickup } = this.state
|
this.setState({
|
pickup: !pickup
|
})
|
}
|
|
UNSAFE_componentWillMount () {
|
// 组件加载时，获取菜单数据
|
this.loadconfig()
|
}
|
|
shouldComponentUpdate (nextProps, nextState) {
|
return !is(fromJS(this.props), fromJS(nextProps)) || !is(fromJS(this.state), fromJS(nextState))
|
}
|
|
/**
|
* @description 组件销毁，清除state更新
|
*/
|
componentWillUnmount () {
|
this.setState = () => {
|
return
|
}
|
}
|
|
render() {
|
const { dict, searchlist, config, setting, actions, columns, pickup, selectedData } = this.state
|
|
return (
|
<div className="script-manage-table" id={this.state.ContainerId}>
|
<TopSearch
|
dict={dict}
|
searchlist={searchlist}
|
refreshdata={this.refreshbysearch}
|
/>
|
<MainAction
|
BID=""
|
type="main"
|
setting={setting}
|
actions={actions}
|
dict={this.state.dict}
|
MenuID={this.props.MenuID}
|
selectedData={selectedData}
|
logcolumns={this.state.logcolumns}
|
ContainerId={this.state.ContainerId}
|
refreshdata={this.refreshbyaction}
|
/>
|
<div className="main-table-box">
|
{this.state.data && this.state.data.length > 0 ?
|
<div className="pickchange">
|
<Switch title="收起" checkedChildren="开" unCheckedChildren="关" defaultChecked={pickup} onChange={this.pickupChange} />
|
</div> : null
|
}
|
<MainTable
|
tableId="mainTable"
|
pickup={pickup}
|
config={config}
|
setting={setting}
|
columns={columns}
|
dict={this.state.dict}
|
data={this.state.data}
|
total={this.state.total}
|
MenuID={this.props.MenuID}
|
loading={this.state.loading}
|
refreshdata={this.refreshbytable}
|
buttonTrigger={() => {}}
|
handleTableId={() => {}}
|
resetTable={this.state.resetTable}
|
chgSelectData={this.changeSelectedData}
|
/>
|
</div>
|
</div>
|
)
|
}
|
}
|
|
export default ScriptTable
|
