import React, {Component} from 'react'
|
import PropTypes from 'prop-types'
|
import {connect} from 'react-redux'
|
import { is, fromJS } from 'immutable'
|
import { notification, Spin, Row, Col, Button, message } from 'antd'
|
import moment from 'moment'
|
|
import Api from '@/api'
|
import options from '@/store/options.js'
|
import zhCN from '@/locales/zh-CN/main.js'
|
import enUS from '@/locales/en-US/main.js'
|
import Utils from '@/utils/utils.js'
|
import asyncSpinComponent from '@/utils/asyncSpinComponent'
|
import { refreshTabView } from '@/store/action'
|
|
import NotFount from '@/components/404'
|
import './index.scss'
|
|
// 通用组件
|
const AntvBarAndLine = asyncSpinComponent(() => import('./components/chart/antv-bar-line'))
|
|
class NormalTable extends Component {
|
static propTpyes = {
|
param: PropTypes.any, // 其他页面传递的参数
|
MenuID: PropTypes.string, // 菜单Id
|
MenuNo: PropTypes.string, // 菜单参数
|
MenuName: PropTypes.string // 菜单名称
|
}
|
|
state = {
|
dict: sessionStorage.getItem('lang') !== 'en-US' ? zhCN : enUS,
|
ContainerId: Utils.getuuid(), // 菜单外层html Id
|
BID: null, // 页面跳转时携带ID
|
loadingview: true, // 页面加载中
|
viewlost: false, // 页面丢失：1、未获取到配置-页面丢失；2、页面未启用
|
lostmsg: '', // 页面丢失时的提示信息
|
config: null, // 页面配置信息，包括组件等
|
mainSearch: null,
|
userConfig: null, // 用户自定义设置
|
arr_field: '', // 使用 sPC_Get_TableData 时的查询字段集
|
setting: null, // 页面全局设置：数据源、按钮及显示列固定、主键等
|
data: null, // 列表数据集
|
loading: false, // 列表数据加载中
|
visible: false, // 标签页控制
|
treevisible: false, // 菜单结构树弹框显示隐藏控制
|
}
|
|
/**
|
* @description 获取页面配置信息
|
*/
|
async loadconfig () {
|
const { permAction, param } = this.props
|
|
let _param = {
|
func: 'sPC_Get_LongParam',
|
MenuID: this.props.MenuID
|
}
|
let result = await Api.getCacheConfig(_param)
|
|
if (result.status) {
|
let config = ''
|
let userConfig = null
|
|
try { // 配置信息解析
|
config = JSON.parse(window.decodeURIComponent(window.atob(result.LongParam)))
|
} catch (e) {
|
console.warn('Parse Failure')
|
config = ''
|
}
|
|
// HS不使用自定义设置
|
if (result.LongParamUser && this.props.menuType !== 'HS') {
|
try { // 配置信息解析
|
userConfig = JSON.parse(window.decodeURIComponent(window.atob(result.LongParamUser)))
|
} catch (e) {
|
console.warn('Parse Failure')
|
userConfig = null
|
}
|
}
|
|
// 页面配置解析错误时提示
|
if (!config) {
|
this.setState({
|
loadingview: false,
|
viewlost: true
|
})
|
return
|
}
|
|
// 页面未启用时，显示未启用页面
|
if (!config.enabled) {
|
this.setState({
|
loadingview: false,
|
viewlost: true,
|
lostmsg: this.state.dict['main.view.unenabled']
|
})
|
return
|
}
|
|
// 获取主搜索条件
|
let mainSearch = []
|
config.components.forEach(component => {
|
if (component.type === 'search') {
|
component.search = component.search.map(item => {
|
item.oriInitval = item.initval
|
if (['text', 'select', 'link'].includes(item.type) && param) {
|
if (param.searchkey === item.field) {
|
item.initval = param.searchval
|
} else if (param.BID && item.field.toLowerCase() === 'bid') {
|
item.initval = param.BID
|
} else if (param.data && param.data[item.field]) {
|
item.initval = param.data[item.field]
|
}
|
}
|
|
if (!item.blacklist || item.blacklist.length === 0) return item
|
|
let _black = item.blacklist.filter(v => {
|
return this.props.permRoles.indexOf(v) !== -1
|
})
|
|
if (_black.length > 0) {
|
item.Hide = 'true'
|
}
|
|
return item
|
})
|
|
mainSearch = Utils.initMainSearch(component.search)
|
}
|
})
|
|
let params = []
|
config.components = this.formatSetting(config.components, params, mainSearch, permAction)
|
|
this.setState({
|
BID: param && param.BID ? param.BID : '',
|
loadingview: false,
|
userConfig: userConfig,
|
setting: config.setting,
|
config,
|
mainSearch
|
}, () => {
|
this.loadmaindata(params)
|
})
|
} else {
|
this.setState({
|
loadingview: false,
|
viewlost: true
|
})
|
notification.warning({
|
top: 92,
|
message: result.message,
|
duration: 5
|
})
|
}
|
}
|
|
// 格式化默认设置
|
formatSetting = (components, params, mainSearch, permAction) => {
|
return components.map(component => {
|
if (component.type === 'tabs') {
|
component.subtabs = component.subtabs.map(tab => {
|
tab.components = this.formatSetting(tab.components, [], [], permAction)
|
return tab
|
})
|
}
|
|
// 权限过滤
|
if (this.props.menuType !== 'HS') {
|
if (component.action) {
|
component.action = component.action.filter(item => permAction[item.uuid])
|
}
|
}
|
|
if (!component.format) return component // 没有动态数据 数据格式 array 或 object
|
|
let _customScript = ''
|
component.scripts && component.scripts.forEach(script => {
|
if (script.status !== 'false') {
|
_customScript += `
|
${script.sql}
|
`
|
}
|
})
|
delete component.scripts
|
|
if (component.setting && component.setting.interType === 'system') { // 使用系统函数
|
component.setting.execute = component.setting.execute !== 'false' // 默认sql是否执行，转为boolean 统一格式
|
component.setting.laypage = component.setting.laypage === 'true' // 是否分页，转为boolean 统一格式
|
|
if (!component.setting.execute) {
|
component.setting.dataresource = ''
|
}
|
if (/\s/.test(component.setting.dataresource)) {
|
component.setting.dataresource = '(' + component.setting.dataresource + ') tb'
|
}
|
|
if (this.props.dataManager) { // 数据权限
|
component.setting.dataresource = component.setting.dataresource.replace(/\$@/ig, '/*')
|
component.setting.dataresource = component.setting.dataresource.replace(/@\$/ig, '*/')
|
_customScript = _customScript.replace(/\$@/ig, '/*')
|
_customScript = _customScript.replace(/@\$/ig, '*/')
|
} else {
|
component.setting.dataresource = component.setting.dataresource.replace(/@\$|\$@/ig, '')
|
_customScript = _customScript.replace(/@\$|\$@/ig, '')
|
}
|
}
|
|
if (component.setting) {
|
component.setting.customScript = _customScript // 整理后自定义脚本
|
}
|
|
// floor 组件的层级
|
// dataName 系统生成的数据源名称
|
// pageable 是否分页，组件属性，不分页的组件才可以统一查询
|
if (component.floor === 1 && component.dataName && !component.pageable && component.setting.interType === 'system' && component.setting.onload === 'true' && component.setting.sync === 'true') {
|
let param = this.getDefaultParam(component, mainSearch)
|
params.push(param)
|
} else {
|
component.setting.sync = 'false'
|
}
|
|
return component
|
})
|
}
|
|
/**
|
* @description 获取系统存储过程 sPC_Get_TableData 的参数
|
*/
|
getDefaultParam = (component, mainSearch) => {
|
const { columns, search, setting, dataName, format } = component
|
|
let searchlist = []
|
if (search && search.length > 0) {
|
searchlist = Utils.initMainSearch(search)
|
}
|
if (setting.useMSearch === 'true') {
|
searchlist = [...mainSearch, ...searchlist]
|
}
|
|
let arr_field = columns.map(col => col.field)
|
let _dataresource = setting.dataresource
|
let _customScript = setting.customScript
|
|
if (setting.queryType === 'statistics' || _customScript) {
|
let allSearch = Utils.getAllSearchOptions(searchlist)
|
let regoptions = allSearch.map(item => {
|
return {
|
reg: new RegExp('@' + item.key + '@', 'ig'),
|
value: `'${item.value}'`
|
}
|
})
|
|
regoptions.forEach(item => {
|
if (_dataresource && setting.queryType === 'statistics') {
|
_dataresource = _dataresource.replace(item.reg, item.value)
|
}
|
if (_customScript) {
|
_customScript = _customScript.replace(item.reg, item.value)
|
}
|
})
|
}
|
|
let _search = ''
|
if (setting.queryType !== 'statistics' && _dataresource) {
|
_search = Utils.joinMainSearchkey(searchlist)
|
_search = _search ? 'where ' + _search : ''
|
}
|
|
if (setting.order && _dataresource) {
|
_dataresource = `select top 1000 ${arr_field.join(',')} from (select ${arr_field.join(',')} ,ROW_NUMBER() over(order by ${setting.order}) as rows from ${_dataresource} ${_search}) tmptable order by tmptable.rows `
|
} else if (_dataresource) {
|
_dataresource = `select top 1000 ${arr_field.join(',')} from ${_dataresource} ${_search} `
|
}
|
|
// 测试系统打印查询语句
|
if ((options.sysType === 'local' && !window.GLOB.systemType) || window.debugger === true) {
|
_customScript && console.log(`${_dataresource ? '' : '/*不执行默认sql*/\n'}${_customScript}`)
|
_dataresource && console.log(_dataresource)
|
}
|
|
return {
|
name: dataName,
|
columns: columns,
|
par_tablename: '',
|
type: format === 'array' ? format : '',
|
primaryKey: setting.primaryKey || '',
|
foreign_key: '',
|
sql: _dataresource,
|
script: _customScript
|
}
|
}
|
|
/**
|
* @description 主表数据加载
|
*/
|
loadmaindata = (params) => {
|
let LText_field = []
|
let LText = params.map((item, index) => {
|
let _sql = item.sql
|
let _script = item.script
|
|
// if (index === 0) {
|
// _script = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000) select @ErrorCode='',@retmsg =''
|
// ${_script}
|
// `
|
// }
|
|
// if (params.length === index + 1) {
|
// _sql = `${_sql}
|
// aaa:
|
// if @ErrorCode!=''
|
// begin
|
// insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
|
// goto bbb
|
// end
|
// `
|
// }
|
|
item.columns.forEach(cell => {
|
LText_field.push(`Select '${item.name}' as tablename,'${cell.field}' as fieldname,'${cell.datatype}' as field_type`)
|
})
|
return `Select '${item.name}' as tablename,'${window.btoa(window.encodeURIComponent(_sql))}' as LText,'${window.btoa(window.encodeURIComponent(_script))}' as Lcustomize,'${item.type}' as table_type,'${item.primaryKey}' as primary_key,'${item.par_tablename}' as par_tablename,'${item.foreign_key}' as foreign_key,'${index}' as Sort`
|
})
|
|
let param = {
|
func: 'sPC_Get_structured_data',
|
LText: LText.join(' union all '),
|
LText_field: LText_field.join(' union all ')
|
}
|
|
param.LText = Utils.formatOptions(param.LText)
|
param.LText_field = Utils.formatOptions(param.LText_field)
|
param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
|
param.secretkey = Utils.encrypt(param.LText, param.timestamp)
|
|
Api.getLocalConfig(param).then(result => {
|
if (result.status) {
|
delete result.status
|
delete result.message
|
delete result.ErrMesg
|
delete result.ErrCode
|
|
this.setState({
|
data: result,
|
loading: false
|
})
|
} else {
|
this.setState({
|
data: '',
|
loading: false
|
})
|
notification.error({
|
top: 92,
|
message: result.message,
|
duration: 10
|
})
|
}
|
})
|
}
|
|
/**
|
* @description 搜索条件改变时，重置表格数据
|
* 含有初始不加载的页面，修改设置
|
*/
|
refreshbysearch = (searches) => {
|
this.setState({
|
mainSearch: searches
|
})
|
}
|
|
|
/**
|
* @description 页面刷新，重新获取配置
|
*/
|
reloadview = () => {
|
this.setState({ loadingview: true, viewlost: false, lostmsg: '', data: null, loading: false, search: ''
|
}, () => {
|
this.loadconfig()
|
})
|
}
|
|
handleviewconfig = (e) => {
|
e.stopPropagation()
|
|
const { MenuNo } = this.props
|
const { config } = this.state
|
|
if (config && config.funcs && config.funcs.length > 0) {
|
this.setState({
|
treevisible: true
|
})
|
} else {
|
let oInput = document.createElement('input')
|
oInput.value = MenuNo || ''
|
document.body.appendChild(oInput)
|
oInput.select()
|
document.execCommand('Copy')
|
document.body.removeChild(oInput)
|
message.success(this.state.dict['main.copy.success'])
|
}
|
}
|
|
UNSAFE_componentWillMount () {
|
// 组件加载时，获取菜单数据
|
this.loadconfig()
|
}
|
|
UNSAFE_componentWillReceiveProps(nextProps) {
|
if (nextProps.refreshTab && nextProps.refreshTab.MenuID === this.props.MenuID) {
|
if (nextProps.refreshTab.position === 'view') {
|
this.reloadview()
|
}
|
this.props.refreshTabView('')
|
}
|
}
|
|
shouldComponentUpdate (nextProps, nextState) {
|
return !is(fromJS(this.props), fromJS(nextProps)) || !is(fromJS(this.state), fromJS(nextState))
|
}
|
|
/**
|
* @description 组件销毁，清除state更新，清除快捷键设置
|
*/
|
componentWillUnmount () {
|
this.setState = () => {
|
return
|
}
|
}
|
|
getComponents = () => {
|
const { menuType, dataManager } = this.props
|
const { config, BID, data, mainSearch } = this.state
|
|
if (!config || !config.components) return
|
|
return config.components.map(item => {
|
if (item.type === 'bar' || item.type === 'line') {
|
return (
|
<Col span={item.setting.span} key={item.uuid}>
|
<AntvBarAndLine config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} dataManager={dataManager} />
|
</Col>
|
)
|
} else {
|
return null
|
}
|
})
|
}
|
|
|
render() {
|
const { loadingview, viewlost } = this.state
|
|
return (
|
<div className="custom-page-wrap" id={this.state.ContainerId}>
|
{loadingview && <Spin size="large" />}
|
<Row gutter={8}>{this.getComponents()}</Row>
|
{options.sysType !== 'cloud' ? <Button
|
icon="copy"
|
shape="circle"
|
className="common-table-copy"
|
onClick={this.handleviewconfig}
|
/> : null}
|
{viewlost ? <NotFount msg={this.state.lostmsg} /> : null}
|
</div>
|
)
|
}
|
}
|
|
const mapStateToProps = (state) => {
|
return {
|
menuType: state.editLevel,
|
tabviews: state.tabviews,
|
refreshTab: state.refreshTab,
|
permAction: state.permAction,
|
permRoles: state.permRoles,
|
dataManager: state.dataManager
|
}
|
}
|
|
const mapDispatchToProps = (dispatch) => {
|
return {
|
refreshTabView: (refreshTab) => dispatch(refreshTabView(refreshTab))
|
}
|
}
|
|
export default connect(mapStateToProps, mapDispatchToProps)(NormalTable)
|
