import React, {Component} from 'react'
|
import PropTypes from 'prop-types'
|
import {connect} from 'react-redux'
|
import { is, fromJS } from 'immutable'
|
import { notification, Spin, Modal, Button, message, Tree, Typography } 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 MainSearch from '@/tabviews/zshare/topSearch'
|
import NotFount from '@/components/404'
|
import './index.scss'
|
|
// 通用组件
|
const CalendarComponent = asyncSpinComponent(() => import('@/tabviews/zshare/calendar'))
|
const SubTabTable = asyncSpinComponent(() => import('@/tabviews/subtabtable'))
|
|
const { TreeNode } = Tree
|
const { Paragraph } = Typography
|
|
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: {}, // 页面配置信息，包括按钮、搜索、显示列、标签等
|
userConfig: null, // 用户自定义设置
|
searchlist: null, // 搜索条件
|
arr_field: '', // 使用 sPC_Get_TableData 时的查询字段集
|
setting: null, // 页面全局设置：数据源、按钮及显示列固定、主键等
|
data: null, // 列表数据集
|
loading: false, // 列表数据加载中
|
search: '', // 搜索条件数组，使用时需分场景处理
|
visible: false, // 标签页控制
|
triggerTime: '', // 点击时间
|
treevisible: false, // 菜单结构树弹框显示隐藏控制
|
calendarYear: moment().format('YYYY') // 日历年份
|
}
|
|
/**
|
* @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
|
let _curUserConfig = ''
|
|
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)))
|
_curUserConfig = userConfig[this.props.MenuID]
|
} 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
|
}
|
|
// 权限过滤
|
if (this.props.menuType !== 'HS') {
|
if (config.tab && !permAction[config.tab.linkTab]) {
|
config.tab = null
|
}
|
}
|
|
if (_curUserConfig) {
|
config.setting = {...config.setting, ..._curUserConfig.setting}
|
config.easyCode = _curUserConfig.easyCode || config.easyCode || ''
|
}
|
|
// 字段权限黑名单、必填、字段透视
|
let valid = true
|
config.search = config.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.required === 'true' && !item.initval) {
|
valid = false
|
}
|
|
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
|
})
|
|
// 数据源
|
if (config.setting.interType === 'inner' && !config.setting.innerFunc) {
|
config.setting.interType = 'system'
|
}
|
|
if (config.setting.interType === 'system') {
|
// 整理数据源自定义脚本
|
let _customScript = ''
|
config.scripts && config.scripts.forEach(script => {
|
if (script.status !== 'false') {
|
_customScript += `
|
${script.sql}
|
`
|
}
|
})
|
|
if (/\s/.test(config.setting.dataresource)) {
|
config.setting.dataresource = '(' + config.setting.dataresource + ') tb'
|
}
|
|
if (this.props.dataManager) { // 数据权限
|
config.setting.dataresource = config.setting.dataresource.replace(/\$@/ig, '/*')
|
config.setting.dataresource = config.setting.dataresource.replace(/@\$/ig, '*/')
|
_customScript = _customScript.replace(/\$@/ig, '/*')
|
_customScript = _customScript.replace(/@\$/ig, '*/')
|
} else {
|
config.setting.dataresource = config.setting.dataresource.replace(/@\$|\$@/ig, '')
|
_customScript = _customScript.replace(/@\$|\$@/ig, '')
|
}
|
|
config.setting.customScript = _customScript
|
}
|
|
this.setState({
|
BID: param && param.BID ? param.BID : '',
|
loadingview: false,
|
config: config,
|
userConfig: userConfig,
|
setting: config.setting,
|
searchlist: config.search,
|
arr_field: config.columns.map(item => item.field).join(','),
|
search: Utils.initMainSearch(config.search) // 搜索条件初始化（含有时间格式，需要转化）
|
}, () => {
|
if (config.setting.onload !== 'false' && valid) { // 初始化可加载
|
this.loadmaindata()
|
}
|
})
|
} else {
|
this.setState({
|
loadingview: false,
|
viewlost: true
|
})
|
notification.warning({
|
top: 92,
|
message: result.message,
|
duration: 5
|
})
|
}
|
}
|
|
/**
|
* @description 主表数据加载
|
*/
|
async loadmaindata () {
|
const { setting, search, BID } = this.state
|
let param = ''
|
let requireFields = search.filter(item => item.required && (!item.value || item.value.length === 0))
|
|
if (requireFields.length > 0) {
|
let labels = requireFields.map(item => item.label)
|
labels = Array.from(new Set(labels))
|
|
notification.warning({
|
top: 92,
|
message: this.state.dict['form.required.input'] + labels.join('、') + ' !',
|
duration: 3
|
})
|
return
|
}
|
|
this.setState({
|
loading: true
|
})
|
|
if (setting.interType === 'system') {
|
param = this.getDefaultParam()
|
} else {
|
param = this.getCustomParam()
|
}
|
|
if (BID) {
|
param.BID = BID
|
}
|
// 数据管理权限
|
if (this.props.dataManager) {
|
param.dataM = 'Y'
|
}
|
|
let result = await Api.genericInterface(param)
|
if (result.status) {
|
this.setState({
|
data: result.data.map((item, index) => {
|
item.key = index
|
return item
|
}),
|
loading: false
|
})
|
} else {
|
this.setState({
|
loading: false
|
})
|
notification.error({
|
top: 92,
|
message: result.message,
|
duration: 10
|
})
|
}
|
}
|
|
/**
|
* @description 获取用户自定义存储过程传参
|
*/
|
getCustomParam = () => {
|
const { search, setting, calendarYear, config } = this.state
|
|
let _search = Utils.formatCustomMainSearch(search)
|
|
let param = {
|
..._search
|
}
|
|
if (config.calendar.refresh === 'true') {
|
param.calendarDate = calendarYear
|
}
|
|
if (setting.interType === 'inner') {
|
param.func = setting.innerFunc
|
} else {
|
if (this.props.menuType === 'HS') {
|
if (setting.sysInterface === 'true' && options.cloudServiceApi) {
|
param.rduri = options.cloudServiceApi
|
} else if (setting.sysInterface !== 'true') {
|
param.rduri = setting.interface
|
}
|
} else {
|
if (setting.sysInterface === 'true' && window.GLOB.mainSystemApi) {
|
param.rduri = window.GLOB.mainSystemApi
|
} else if (setting.sysInterface !== 'true') {
|
param.rduri = setting.interface
|
}
|
}
|
|
if (setting.outerFunc) {
|
param.func = setting.outerFunc
|
}
|
}
|
|
return param
|
}
|
|
/**
|
* @description 获取系统存储过程 sPC_Get_TableData 的参数
|
*/
|
getDefaultParam = () => {
|
const { arr_field, search, setting, config, calendarYear } = this.state
|
|
let _search = Utils.joinMainSearchkey(search)
|
_search = _search ? 'where ' + _search : ''
|
|
let param = {
|
func: 'sPC_Get_TableData',
|
obj_name: 'data',
|
arr_field: arr_field,
|
custom_script: setting.customScript,
|
default_sql: setting.execute || 'true',
|
menuname: this.props.MenuName || ''
|
}
|
|
let _dataresource = setting.dataresource
|
let regoptions = null
|
if (setting.queryType === 'statistics' || param.custom_script) {
|
let allSearch = Utils.getAllSearchOptions(search)
|
let userName = sessionStorage.getItem('User_Name') || ''
|
let fullName = sessionStorage.getItem('Full_Name') || ''
|
|
if (sessionStorage.getItem('isEditState') === 'true') {
|
userName = sessionStorage.getItem('CloudUserName') || ''
|
fullName = sessionStorage.getItem('CloudFullName') || ''
|
}
|
|
regoptions = allSearch.map(item => {
|
return {
|
reg: new RegExp('@' + item.key + '@', 'ig'),
|
value: `'${item.value}'`
|
}
|
})
|
regoptions.push({
|
reg: new RegExp('@userName@', 'ig'),
|
value: userName
|
}, {
|
reg: new RegExp('@fullName@', 'ig'),
|
value: fullName
|
})
|
}
|
|
if (config.calendar.refresh === 'true' && regoptions) {
|
regoptions.push({
|
reg: new RegExp('@calendarDate@', 'ig'),
|
value: `${calendarYear}-01-01 00:00:00.000`
|
})
|
regoptions.push({
|
reg: new RegExp('@calendarDate1@', 'ig'),
|
value: `${calendarYear}-12-31 23:59:59.999`
|
})
|
}
|
|
if (setting.queryType === 'statistics' && setting.execute !== 'false') { // 统计数据源，内容替换
|
regoptions.forEach(item => {
|
_dataresource = _dataresource.replace(item.reg, item.value)
|
})
|
_search = ''
|
}
|
|
let LText = ''
|
|
if (setting.execute !== 'false') {
|
LText = `select ${arr_field} from ${_dataresource} ${_search}`
|
}
|
|
if (param.custom_script) {
|
regoptions.forEach(item => {
|
param.custom_script = param.custom_script.replace(item.reg, item.value)
|
})
|
|
param.custom_script = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000) select @ErrorCode='',@retmsg =''
|
${param.custom_script}
|
`
|
|
if (LText) {
|
LText += `
|
aaa:
|
if @ErrorCode!=''
|
insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
|
`
|
} else {
|
param.custom_script += `
|
aaa:
|
if @ErrorCode!=''
|
insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
|
`
|
}
|
}
|
|
// 测试系统打印查询语句
|
if ((options.sysType === 'local' && !window.GLOB.systemType) || window.debugger === true) {
|
param.custom_script && console.log(`${LText ? '' : '/*不执行默认sql*/\n'}${param.custom_script}`)
|
LText && console.log(LText)
|
}
|
|
param.custom_script = Utils.formatOptions(param.custom_script)
|
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 = ''
|
|
if (this.props.menuType === 'HS') { // 云端数据验证
|
param.open_key = Utils.encryptOpenKey(param.secretkey, param.timestamp)
|
}
|
|
return param
|
}
|
|
/**
|
* @description 搜索条件改变时，重置表格数据
|
* 含有初始不加载的页面，修改设置
|
*/
|
refreshbysearch = (searches) => {
|
const { setting } = this.state
|
|
if (setting.onload === 'false') {
|
this.setState({
|
search: searches,
|
setting: {...setting, onload: 'true'}
|
}, () => {
|
this.loadmaindata()
|
})
|
} else {
|
this.setState({
|
search: searches
|
}, () => {
|
this.loadmaindata()
|
})
|
}
|
}
|
|
|
/**
|
* @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'])
|
}
|
}
|
|
getTreeNode = (data) => {
|
let _type = {
|
view: '页面',
|
btn: '按钮',
|
tab: '标签'
|
}
|
|
return data.map(item => {
|
let _title = _type[item.subtype]
|
let _others = []
|
|
_others.push(
|
(item.menuNo ? item.menuNo + '(菜单参数)' : ''),
|
(item.tableName ? item.tableName + '(表名) ' : ''),
|
(item.innerFunc ? item.innerFunc + '(内部函数) ' : ''),
|
(item.outerFunc ? item.outerFunc + '(外部函数)' : '')
|
)
|
_others = _others.filter(Boolean)
|
_others = _others.join('、')
|
|
if (item.label) {
|
_title = _title + '(' + item.label + ')'
|
}
|
if (_others) {
|
_title = _title + ': ' + _others
|
}
|
|
if (item.subfuncs && item.subfuncs.length > 0) {
|
return (
|
<TreeNode title={_title} key={item.uuid} dataRef={item} selectable={false}>
|
{this.getTreeNode(item.subfuncs)}
|
</TreeNode>
|
)
|
}
|
return <TreeNode key={item.uuid} title={_title} isLeaf selectable={false} />
|
})
|
}
|
|
UNSAFE_componentWillMount () {
|
// 组件加载时，获取菜单数据
|
this.loadconfig()
|
}
|
|
UNSAFE_componentWillReceiveProps(nextProps) {
|
if (nextProps.refreshTab && nextProps.refreshTab.MenuID === this.props.MenuID) {
|
this.reloadview()
|
this.props.refreshTabView('')
|
} else if (nextProps.param && !is(fromJS(this.props.param), fromJS(nextProps.param))) {
|
let search = this.state.search.map(item => {
|
if (item.type === 'text' && item.key === nextProps.param.searchkey) {
|
item.value = nextProps.param.searchval
|
}
|
return item
|
})
|
this.refreshbysearch(search)
|
}
|
}
|
|
shouldComponentUpdate (nextProps, nextState) {
|
return !is(fromJS(this.props), fromJS(nextProps)) || !is(fromJS(this.state), fromJS(nextState))
|
}
|
|
/**
|
* @description 组件销毁，清除state更新，清除快捷键设置
|
*/
|
componentWillUnmount () {
|
this.setState = () => {
|
return
|
}
|
}
|
|
changeDate = (value) => {
|
this.setState({calendarYear: value}, () => {
|
this.loadmaindata()
|
})
|
}
|
|
triggerDate = (item) => {
|
const { config } = this.state
|
|
if (!config.tab) return
|
|
this.setState({
|
visible: true,
|
triggerTime: item.time.substr(0, 4) + '-' + item.time.substr(4, 2) + '-' + item.time.substr(6, 2)
|
})
|
}
|
|
closeTab = () => {
|
this.setState({
|
visible: false,
|
triggerTime: ''
|
})
|
}
|
|
render() {
|
const { menuType } = this.props
|
const { BID, searchlist, loadingview, viewlost, config, loading, data, triggerTime } = this.state
|
|
return (
|
<div className="calendar-page" id={this.state.ContainerId}>
|
{loadingview && <Spin size="large" />}
|
{searchlist && searchlist.length > 0 ?
|
<MainSearch
|
BID={BID}
|
dict={this.state.dict}
|
searchlist={searchlist}
|
menuType={menuType}
|
dataManager={this.props.dataManager}
|
refreshdata={this.refreshbysearch}
|
/> : null
|
}
|
{config && config.calendar ? <CalendarComponent calendar={config.calendar} loading={loading} data={data} triggerDate={this.triggerDate} changeDate={this.changeDate}/> : null}
|
{options.sysType !== 'cloud' && menuType !== 'HS' ? <Button
|
icon="copy"
|
shape="circle"
|
className="common-table-copy"
|
onClick={this.handleviewconfig}
|
/> : null}
|
<Modal
|
className="menu-tree-modal"
|
title={'菜单结构树'}
|
width={'650px'}
|
maskClosable={false}
|
visible={this.state.treevisible}
|
onCancel={() => this.setState({treevisible: false})}
|
footer={[
|
<Button key="close" onClick={() => this.setState({treevisible: false})}>{this.state.dict['main.close']}</Button>
|
]}
|
destroyOnClose
|
>
|
<div className="menu-header">
|
<span>菜单名称：{this.props.MenuName}</span>
|
<span>菜单参数：{<Paragraph copyable>{this.props.MenuNo}</Paragraph>}</span>
|
</div>
|
{this.state.treevisible ? <Tree defaultExpandAll showLine={true}>
|
{this.getTreeNode(config.funcs)}
|
</Tree> : null}
|
</Modal>
|
<Modal
|
title={config.tab ? config.tab.label : ''}
|
width={'80vw'}
|
maskClosable={false}
|
visible={this.state.visible}
|
onCancel={this.closeTab}
|
footer={[
|
<Button key="close" onClick={this.closeTab}>{this.state.dict['main.close']}</Button>
|
]}
|
destroyOnClose
|
>
|
{config.tab ? <SubTabTable
|
type="calendar"
|
BID={triggerTime}
|
Tab={config.tab}
|
SupMenuID={this.props.MenuID}
|
MenuID={config.tab.linkTab}
|
refreshSupView={() => this.loadmaindata()}
|
closeModalView={this.closeTab}
|
/> : null}
|
</Modal>
|
{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)
|
