import React, {Component} from 'react'
|
import PropTypes from 'prop-types'
|
import { connect } from 'react-redux'
|
import { is, fromJS } from 'immutable'
|
import { Row, Col, Empty, notification } from 'antd'
|
import moment from 'moment'
|
import md5 from 'md5'
|
|
import Api from '@/api'
|
import options from '@/store/options.js'
|
import asyncComponent from '@/utils/asyncComponent'
|
import Utils from '@/utils/utils.js'
|
import './index.scss'
|
|
// 通用组件
|
const AntvBarAndLine = asyncComponent(() => import('@/tabviews/custom/components/chart/antv-bar-line'))
|
const MainSearch = asyncComponent(() => import('@/tabviews/zshare/topSearch'))
|
const AntvPie = asyncComponent(() => import('@/tabviews/custom/components/chart/antv-pie'))
|
const AntvTabs = asyncComponent(() => import('@/tabviews/custom/components/tabs/antv-tabs'))
|
const DataCard = asyncComponent(() => import('@/tabviews/custom/components/card/data-card'))
|
const TableCard = asyncComponent(() => import('@/tabviews/custom/components/card/table-card'))
|
const NormalTable = asyncComponent(() => import('@/tabviews/custom/components/table/normal-table'))
|
const PropCard = asyncComponent(() => import('@/tabviews/custom/components/card/prop-card'))
|
const NormalGroup = asyncComponent(() => import('@/tabviews/custom/components/group/normal-group'))
|
const BraftEditor = asyncComponent(() => import('@/tabviews/custom/components/editor/braft-editor'))
|
const SandBox = asyncComponent(() => import('@/tabviews/custom/components/code/sand-box'))
|
|
class TabTransfer extends Component {
|
static propTpyes = {
|
bids: PropTypes.any, // 父级Id集
|
config: PropTypes.object, // 组件配置信息
|
mainSearch: PropTypes.any, // 全局搜索条件
|
menuType: PropTypes.any, // 菜单类型
|
}
|
|
state = {
|
mainSearch: [],
|
self: false,
|
data: null
|
}
|
|
UNSAFE_componentWillMount () {
|
const { config, mainSearch } = this.props
|
|
// 获取主搜索条件
|
let _mainSearch = []
|
let self = false
|
config.components.forEach(component => {
|
if (component.type === 'search') {
|
self = true
|
_mainSearch = Utils.initMainSearch(component.search)
|
}
|
})
|
|
if (!self) {
|
_mainSearch = fromJS(mainSearch).toJS()
|
}
|
|
let params = []
|
config.components.forEach(item => {
|
if (item.type === 'tabs' || item.type === 'group') return
|
|
if (!item.setting || item.setting.interType !== 'system') return
|
if (!item.format) return
|
|
if (item.dataName && (!item.pageable || (item.pageable && !item.setting.laypage)) && item.setting.onload === 'true' && item.setting.sync === 'true') {
|
let param = this.getDefaultParam(item, _mainSearch)
|
params.push(param)
|
} else {
|
item.setting.sync = 'false'
|
}
|
})
|
|
this.setState({mainSearch: _mainSearch, self})
|
|
if (params.length > 0) {
|
this.loadmaindata(params)
|
}
|
}
|
|
UNSAFE_componentWillReceiveProps(nextProps) {
|
const { self } = this.state
|
|
if (!self && nextProps.mainSearch && !is(fromJS(this.props.mainSearch), fromJS(nextProps.mainSearch))) {
|
this.setState({mainSearch: fromJS(nextProps.mainSearch).toJS()})
|
}
|
}
|
|
/**
|
* @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') {
|
let keys = searchlist.map(item => item.key)
|
mainSearch.forEach(item => {
|
if (!keys.includes(item.key)) {
|
searchlist.push(item)
|
}
|
})
|
}
|
|
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.info(`${_dataresource ? '' : '/*不执行默认sql*/\n'}${_customScript}`)
|
_dataresource && console.info(_dataresource)
|
}
|
|
return {
|
name: dataName,
|
columns: columns,
|
par_tablename: '',
|
type: format === 'array' ? format : '',
|
primaryKey: setting.primaryKey || '',
|
foreign_key: '',
|
sql: _dataresource,
|
script: _customScript
|
}
|
}
|
|
/**
|
* @description 主表数据加载
|
*/
|
loadmaindata = (params) => {
|
const { config } = this.props
|
let LText_field = []
|
let diffUser = false
|
let userName = sessionStorage.getItem('User_Name') || ''
|
let fullName = sessionStorage.getItem('Full_Name') || ''
|
let city = sessionStorage.getItem('city') || ''
|
|
if (sessionStorage.getItem('isEditState') === 'true') {
|
userName = sessionStorage.getItem('CloudUserName') || ''
|
fullName = sessionStorage.getItem('CloudFullName') || ''
|
}
|
|
let _LText = params.map((item, index) => {
|
let _script = item.script
|
|
if (index === 0) {
|
_script = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@UserName nvarchar(50),@FullName nvarchar(50),@login_city nvarchar(50)
|
select @ErrorCode='',@retmsg ='',@UserName='${userName}', @FullName='${fullName}', @login_city='${city}'
|
${_script}
|
`
|
}
|
if (!diffUser && (/@userid@/ig.test(item.sql) || /@userid@/ig.test(_script))) {
|
diffUser = true
|
}
|
|
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(item.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 ')
|
}
|
|
let { LText, LText1, LText2 } = Utils.sPCInUpDeFormatOptions(param.LText)
|
|
param.LText1 = LText1
|
param.LText = LText
|
param.LText2 = LText2
|
param.LText_field = Utils.formatOptions(param.LText_field)
|
|
if (config.cacheUseful === 'true') {
|
param.time_type = config.timeUnit
|
param.time_limit = config.cacheTime
|
if (diffUser) {
|
param.userid = sessionStorage.getItem('UserID')
|
}
|
param.data_md5 = md5(JSON.stringify(param))
|
}
|
|
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
|
})
|
} else {
|
this.setState({
|
data: ''
|
})
|
notification.error({
|
top: 92,
|
message: result.message,
|
duration: 10
|
})
|
}
|
})
|
}
|
|
resetSearch = (search) => {
|
this.setState({mainSearch: null}, () => {
|
this.setState({mainSearch: search})
|
})
|
}
|
|
getComponents = () => {
|
const { menuType, bids, config } = this.props
|
const { mainSearch, data } = this.state
|
|
if (!config || !config.components || config.components.length === 0) return (<Empty description={false} />)
|
|
return config.components.map(item => {
|
let BID = ''
|
if (item.setting && item.setting.supModule) {
|
BID = bids[item.setting.supModule] || ''
|
}
|
|
if (item.type === 'bar' || item.type === 'line') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<AntvBarAndLine data={data} config={item} BID={BID} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else if (item.type === 'pie') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<AntvPie data={data} config={item} BID={BID} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else if (item.type === 'search') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<MainSearch config={item} mainSearch={mainSearch} menuType={menuType} refreshdata={this.resetSearch} />
|
</Col>
|
)
|
} else if (item.type === 'tabs') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<AntvTabs config={item} bids={bids} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else if (item.type === 'card' && item.subtype === 'datacard') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<DataCard config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else if (item.type === 'card' && item.subtype === 'propcard') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<PropCard config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else if (item.type === 'table' && item.subtype === 'tablecard') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<TableCard config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else if (item.type === 'table' && item.subtype === 'normaltable') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<NormalTable config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else if (item.type === 'group' && item.subtype === 'normalgroup') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<NormalGroup config={item} bids={bids} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else if (item.type === 'editor') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<BraftEditor config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else if (item.type === 'code') {
|
return (
|
<Col span={item.width} key={item.uuid}>
|
<SandBox config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} />
|
</Col>
|
)
|
} else {
|
return null
|
}
|
})
|
}
|
|
render() {
|
return (
|
<Row gutter={8}>{this.getComponents()}</Row>
|
)
|
}
|
}
|
|
const mapStateToProps = (state) => {
|
return {
|
menuType: state.editLevel
|
}
|
}
|
|
const mapDispatchToProps = () => {
|
return {}
|
}
|
|
export default connect(mapStateToProps, mapDispatchToProps)(TabTransfer)
|
