From f267d04e0561a0a20d1f2a9f558a273558ece90d Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期一, 24 五月 2021 17:50:19 +0800 Subject: [PATCH] 2021-05-24 --- src/tabviews/custom/components/share/tabtransfer/index.jsx | 351 ++++++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 313 insertions(+), 38 deletions(-) diff --git a/src/tabviews/custom/components/share/tabtransfer/index.jsx b/src/tabviews/custom/components/share/tabtransfer/index.jsx index 0238c31..555b730 100644 --- a/src/tabviews/custom/components/share/tabtransfer/index.jsx +++ b/src/tabviews/custom/components/share/tabtransfer/index.jsx @@ -2,104 +2,382 @@ import PropTypes from 'prop-types' import { connect } from 'react-redux' import { is, fromJS } from 'immutable' -import { Row, Col, Empty } from 'antd' +import { Row, Col, Empty, notification } from 'antd' +import moment from 'moment' +import md5 from 'md5' -import asyncSpinComponent from '@/utils/asyncSpinComponent' +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 = asyncSpinComponent(() => import('@/tabviews/custom/components/chart/antv-bar-line')) -const MainSearch = asyncSpinComponent(() => import('@/tabviews/custom/components/search/main-search')) -const AntvPie = asyncSpinComponent(() => import('@/tabviews/custom/components/chart/antv-pie')) -const AntvTabs = asyncSpinComponent(() => import('@/tabviews/custom/components/tabs/antv-tabs')) +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 AntvDashboard = asyncComponent(() => import('@/tabviews/custom/components/chart/antv-dashboard')) +const AntvTabs = asyncComponent(() => import('@/tabviews/custom/components/tabs/antv-tabs')) +const DataCard = asyncComponent(() => import('@/tabviews/custom/components/card/data-card')) +const AntvScatter = asyncComponent(() => import('@/tabviews/custom/components/chart/antv-scatter')) +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')) +const NormalForm = asyncComponent(() => import('@/tabviews/custom/components/form/normal-form')) +const NormalTree = asyncComponent(() => import('@/tabviews/custom/components/tree/antd-tree')) +const CarouselDataCard = asyncComponent(() => import('@/tabviews/custom/components/carousel/data-card')) +const CarouselPropCard = asyncComponent(() => import('@/tabviews/custom/components/carousel/prop-card')) class TabTransfer extends Component { static propTpyes = { - BID: PropTypes.any, // 鐖剁骇Id + bids: PropTypes.any, // 鐖剁骇Id闆� config: PropTypes.object, // 缁勪欢閰嶇疆淇℃伅 mainSearch: PropTypes.any, // 鍏ㄥ眬鎼滅储鏉′欢 menuType: PropTypes.any, // 鑿滃崟绫诲瀷 - dataManager: PropTypes.any, // 鏁版嵁鏉冮檺 } state = { mainSearch: [], - self: false + 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 - component.search = component.search.map(item => { - item.oriInitval = item.initval - - 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) } }) - this.setState({mainSearch: self ? _mainSearch : fromJS(mainSearch).toJS(), self}) + if (!self) { + _mainSearch = fromJS(mainSearch).toJS() + } + + let isEmpty = _mainSearch.filter(item => item.required && (!item.value || item.value.length === 0)).length > 0 + + 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') { + if (isEmpty && item.setting.useMSearch === 'true') { + item.setting.sync = 'false' + item.setting.onload = 'false' + } else { + let searchlist = [] + if (item.search && item.search.length > 0) { + searchlist = Utils.initMainSearch(item.search) + } + + let _empty = searchlist.filter(cell => cell.required && (!cell.value || cell.value.length === 0)).length > 0 + + if (_empty) { + item.setting.sync = 'false' + item.setting.onload = 'false' + } else { + if (item.setting.useMSearch === 'true') { + let keys = searchlist.map(item => item.key) + _mainSearch.forEach(item => { + if (!keys.includes(item.key)) { + searchlist.push(item) + } + }) + } + params.push(this.getDefaultParam(item, searchlist)) + } + } + } 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 && !is(fromJS(this.props.mainSearch), fromJS(nextProps.mainSearch))) { + 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, searchlist) => { + const { columns, setting, dataName, format } = component + + 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 ? '' : '/*涓嶆墽琛岄粯璁ql*/\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: search}) + this.setState({mainSearch: null}, () => { + this.setState({mainSearch: search}) + }) } getComponents = () => { - const { menuType, dataManager, BID, config } = this.props - const { mainSearch } = this.state + 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 config={item} BID={BID} mainSearch={mainSearch} menuType={menuType} dataManager={dataManager} /> + <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 config={item} BID={BID} mainSearch={mainSearch} menuType={menuType} dataManager={dataManager} /> + <AntvPie data={data} config={item} BID={BID} mainSearch={mainSearch} menuType={menuType} /> + </Col> + ) + } else if (item.type === 'dashboard') { + return ( + <Col span={item.width} key={item.uuid}> + <AntvDashboard config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} /> + </Col> + ) + } else if (item.type === 'scatter') { + return ( + <Col span={item.width} key={item.uuid}> + <AntvScatter config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} /> </Col> ) } else if (item.type === 'search') { return ( <Col span={item.width} key={item.uuid}> - <MainSearch config={item} BID={BID} mainSearch={mainSearch} menuType={menuType} dataManager={dataManager} refreshdata={this.resetSearch} /> + <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} BID={BID} mainSearch={mainSearch} menuType={menuType} dataManager={dataManager} /> + <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 === 'carousel' && item.subtype === 'datacard') { + return ( + <Col span={item.width} key={item.uuid}> + <CarouselDataCard config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} /> + </Col> + ) + } else if (item.type === 'carousel' && item.subtype === 'propcard') { + return ( + <Col span={item.width} key={item.uuid}> + <CarouselPropCard 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 === 'form') { + return ( + <Col span={item.width} key={item.uuid}> + <NormalForm config={item} data={data} BID={BID} mainSearch={mainSearch} menuType={menuType} /> + </Col> + ) + } else if (item.type === 'tree') { + return ( + <Col span={item.width} key={item.uuid}> + <NormalTree config={item} data={data} BID={BID} 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 { @@ -117,10 +395,7 @@ const mapStateToProps = (state) => { return { - menuType: state.editLevel, - permAction: state.permAction, - permRoles: state.permRoles, - dataManager: state.dataManager + menuType: state.editLevel } } -- Gitblit v1.8.0