From c7414c3cc93649479119d51b230c4b8e36884ca7 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期五, 23 七月 2021 18:18:55 +0800
Subject: [PATCH] 2021-07-23
---
src/tabviews/custom/components/share/tabtransfer/index.jsx | 131 ++-----------------------------------------
1 files changed, 6 insertions(+), 125 deletions(-)
diff --git a/src/tabviews/custom/components/share/tabtransfer/index.jsx b/src/tabviews/custom/components/share/tabtransfer/index.jsx
index 03daff4..62512b7 100644
--- a/src/tabviews/custom/components/share/tabtransfer/index.jsx
+++ b/src/tabviews/custom/components/share/tabtransfer/index.jsx
@@ -3,12 +3,13 @@
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 {
+ getStructuredParams,
+ getStructDefaultParam
+} from '@/utils/utils-datamanage.js'
import Utils from '@/utils/utils.js'
import './index.scss'
@@ -87,7 +88,7 @@
item.setting.sync = 'false'
item.setting.onload = 'false'
} else {
- params.push(this.getDefaultParam(item, searchlist))
+ params.push(getStructDefaultParam(item, searchlist))
}
} else {
item.setting.sync = 'false'
@@ -110,130 +111,10 @@
}
/**
- * @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)
- }
- })
- }
-
- _dataresource = _dataresource.replace(/@select\$|\$select@/ig, '')
- _customScript = _customScript.replace(/@select\$|\$select@/ig, '')
- _dataresource = _dataresource.replace(/\$sum@/ig, '/*')
- _dataresource = _dataresource.replace(/@sum\$/ig, '*/')
- _customScript = _customScript.replace(/\$sum@/ig, '/*')
- _customScript = _customScript.replace(/@sum\$/ig, '*/')
-
- 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)
+ let param = getStructuredParams(params, this.props.config)
Api.getLocalConfig(param).then(result => {
if (result.status) {
--
Gitblit v1.8.0