From 882d11341442d5128c9e314f76e48d4d829f31cc Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期五, 27 十月 2023 17:15:47 +0800
Subject: [PATCH] 2023-10-27
---
src/menu/components/table/edit-table/columns/editColumn/index.jsx | 363 ++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 309 insertions(+), 54 deletions(-)
diff --git a/src/menu/components/table/edit-table/columns/editColumn/index.jsx b/src/menu/components/table/edit-table/columns/editColumn/index.jsx
index 102006c..25e6c22 100644
--- a/src/menu/components/table/edit-table/columns/editColumn/index.jsx
+++ b/src/menu/components/table/edit-table/columns/editColumn/index.jsx
@@ -1,22 +1,27 @@
import React, {Component} from 'react'
import PropTypes from 'prop-types'
import { is, fromJS } from 'immutable'
-import { Form, Row, Col, Input, Select, InputNumber, Radio, Tooltip, Modal, notification } from 'antd'
+import { Form, Row, Col, Input, Select, InputNumber, Radio, Tooltip, Modal, notification, Popover } from 'antd'
import { QuestionCircleOutlined } from '@ant-design/icons'
+import Api from '@/api'
+import Utils from '@/utils/utils.js'
import { getColumnForm } from './formconfig'
+import asyncComponent from '@/utils/asyncComponent'
import { formRule } from '@/utils/option.js'
import CodeMirror from '@/templates/zshare/codemirror'
import EditTable from '@/templates/zshare/modalform/modaleditable'
import './index.scss'
+const FieldsTable = asyncComponent(() => import('@/templates/zshare/editTable'))
const { TextArea } = Input
const columnTypeOptions = {
text: ['label', 'field', 'type', 'Align', 'Hide', 'IsSort', 'Width', 'prefix', 'postfix', 'textFormat', 'editable', 'initval', 'blacklist'],
number: ['label', 'field', 'type', 'Align', 'Hide', 'IsSort', 'Width', 'decimal', 'format', 'prefix', 'postfix', 'editable', 'initval', 'sum', 'blacklist'],
textarea: ['label', 'field', 'type', 'Align', 'Hide', 'Width', 'prefix', 'initval', 'postfix', 'blacklist'],
- custom: ['label', 'type', 'Align', 'Hide', 'Width', 'blacklist'],
+ custom: ['label', 'type', 'Align', 'Width', 'blacklist', 'IsSort'],
+ colspan: ['label', 'type', 'Align', 'Hide', 'blacklist'],
action: ['label', 'type', 'Align', 'Width'],
formula: ['label', 'type', 'Align', 'Hide', 'Width', 'prefix', 'postfix', 'eval', 'formula', 'blacklist'],
index: ['label', 'type', 'Align', 'Width']
@@ -24,7 +29,6 @@
class EdiTableColumn extends Component {
static propTpyes = {
- visible: PropTypes.bool,
column: PropTypes.object,
columns: PropTypes.array,
fields: PropTypes.array,
@@ -34,11 +38,12 @@
state = {
visible: false,
+ loading: false,
formlist: null,
transfield: {}
}
- column = null
+ record = null
UNSAFE_componentWillMount() {
let transfield = {}
@@ -56,18 +61,26 @@
}
getOptions = () => {
- let _options = fromJS(columnTypeOptions[this.column.type]).toJS()
+ let _options = fromJS(columnTypeOptions[this.record.type]).toJS()
- if (this.column.editable === 'true') {
- if (this.column.type === 'text') {
+ if (['number', 'text'].includes(this.record.type) && this.record.editable === 'true') {
+ _options.push('ctrlField')
+ if (this.record.ctrlField) {
+ _options.push('ctrlValue')
+ }
+ if (this.record.type === 'text') {
_options.push('editType')
- if (this.column.editType === 'switch') {
- _options.push('enter', 'openVal', 'closeVal', 'openText', 'closeText', 'editField')
- } else if (this.column.editType === 'select') {
- _options.push('required', 'enter', 'resourceType', 'linkSubField', 'editField', 'dropdown')
+ if (this.record.editType === 'switch') {
+ _options.push('enter', 'openVal', 'closeVal', 'openText', 'closeText')
+ } else if (this.record.editType === 'date') {
+ _options.push('required', 'precision', 'enter', 'declareType')
+ } else if (this.record.editType === 'popSelect') {
+ _options.push('required', 'enter', 'linkSubField', 'columns', 'dataSource', 'primaryKey', 'order', 'showField', 'controlField', 'searchKey', 'popWidth', 'laypage', 'onload')
+ } else if (this.record.editType === 'select') {
+ _options.push('required', 'enter', 'resourceType', 'linkSubField', 'dropdown')
- if (this.column.resourceType === '0') {
+ if (this.record.resourceType === '0') {
_options.push('options')
} else {
_options.push('dataSource', 'valueField', 'valueText', 'orderBy', 'orderType', 'disableField', 'database')
@@ -75,9 +88,17 @@
} else {
_options.push('required', 'enter')
}
- } else if (this.column.type === 'number') {
+ } else if (this.record.type === 'number') {
_options.push('max', 'min', 'enter')
}
+ }
+ if (this.record.type === 'formula' && this.record.eval === 'true') {
+ _options.push('decimal')
+ } else if (this.record.type === 'custom' && this.record.IsSort === 'true') {
+ _options.push('sortField')
+ }
+ if (['number', 'formula'].includes(this.record.type) && this.record.Hide !== 'true') {
+ _options.push('noValue')
}
return _options
@@ -85,17 +106,16 @@
editColumn = (column) => {
let fields = fromJS(this.props.fields).toJS().map(item => {
- if (item.label.toLowerCase() !== item.field.toLowerCase()) {
- item.text = item.label + '锛�' + item.field + '锛�'
- }
+ item.text = `${item.field}锛�${item.label}锛塦
return item
})
let formlist = getColumnForm(column, fields, this.props.columns)
+ this.record = {}
- this.column = fromJS(column).toJS()
- this.column.editType = this.column.editType || 'text'
- this.column.resourceType = this.column.resourceType || '0'
+ formlist.forEach(item => {
+ this.record[item.key] = item.initVal
+ })
let _options = this.getOptions()
@@ -103,6 +123,11 @@
visible: true,
formlist: formlist.map(item => {
item.hidden = !_options.includes(item.key)
+
+ if (item.key === 'formula') {
+ item.fields = this.props.fields.map(col => col.field)
+ item.fields = item.fields.join(', ')
+ }
return item
})
@@ -120,21 +145,40 @@
}
typeChange = (key, value, option) => {
- this.column[key] = value
+ this.record[key] = value
if (key === 'type') {
+ if (['textarea', 'custom'].includes(value)) {
+ this.record.IsSort = 'false'
+ }
+
let _options = this.getOptions()
+
+ let _field = ''
+ if (value === 'formula') {
+ _field = this.props.form.getFieldValue('field') || ''
+ }
this.setState({
formlist: this.state.formlist.map(item => {
- item.initVal = this.column[item.key] || item.initVal
+ if (item.key === 'decimal' && value === 'formula') {
+ this.record.decimal = ''
+ }
+
+ item.initVal = this.record[item.key]
item.hidden = !_options.includes(item.key)
return item
})
}, () => {
- if (value === 'action') {
+ if (['textarea', 'custom'].includes(value)) {
+ this.props.form.setFieldsValue({IsSort: 'false'})
+ } else if (value === 'colspan') {
this.props.form.setFieldsValue({Align: 'center'})
+ } else if (value === 'formula' && _field) {
+ this.props.form.setFieldsValue({formula: '@' + _field + '@'})
+ } else if (value === 'index') {
+ this.props.form.setFieldsValue({label: '搴忓彿'})
}
})
} else if (key === 'field') {
@@ -150,15 +194,15 @@
values.type = 'text'
}
- let _type = this.column.type
- this.column.type = values.type
+ let _type = this.record.type
+ this.record.type = values.type
if (values.type !== _type) {
let _options = this.getOptions()
this.setState({
formlist: this.state.formlist.map(item => {
- item.initVal = this.column[item.key] || item.initVal
+ item.initVal = this.record[item.key]
item.hidden = !_options.includes(item.key)
return item
@@ -171,12 +215,12 @@
}
} else if (key === 'format' && value === 'percent') {
this.props.form.setFieldsValue({postfix: '%'})
- } else if (key === 'editable' || key === 'editType' || key === 'resourceType') {
+ } else if (['editable', 'editType', 'resourceType', 'ctrlField', 'eval', 'Hide', 'IsSort'].includes(key)) {
let _options = this.getOptions()
this.setState({
formlist: this.state.formlist.map(item => {
- item.initVal = this.column[item.key] || item.initVal
+ item.initVal = this.record[item.key]
item.hidden = !_options.includes(item.key)
return item
@@ -188,7 +232,7 @@
multiselectChange = (key, value) => {
if (key !== 'linkSubField') return
- this.column[key] = value
+ this.record[key] = value
}
handleEmpty = () => {
@@ -216,13 +260,17 @@
let resource = this.props.form.getFieldValue('dataSource') || ''
- resource = `select '' as ${field},'鍏ㄩ儴' as ${text} union all \n${resource}`
+ if (field === text) {
+ resource = `select '' as ${field} union all \n${resource}`
+ } else {
+ resource = `select '' as ${field},'鍏ㄩ儴' as ${text} union all \n${resource}`
+ }
this.props.form.setFieldsValue({dataSource: resource})
}
- changeOptions = (data) => {
- this.column.options = data || []
+ changeOptions = (data, key) => {
+ this.record[key] = data || []
}
getFields() {
@@ -267,6 +315,12 @@
rules = [
{ required: item.required, message: '璇烽�夋嫨' + item.label + '!' }
]
+
+ let options = item.options
+ if (typeof(item.options) === 'string') {
+ options = this.record[item.options] || []
+ }
+
content = <Select
showSearch
allowClear={item.allowClear === true}
@@ -274,7 +328,7 @@
onChange={(value, option) => {this.typeChange(item.key, value, option)}}
getPopupContainer={() => document.getElementById('edit-table-column-winter')}
>
- {item.options.map((option, i) =>
+ {options.map((option, i) =>
<Select.Option key={i} datatype={option.datatype || ''} label={option.label || ''} value={(option.value || option.field || option.MenuID)}>
{(option.text || option.label || option.MenuName)}
</Select.Option>
@@ -302,10 +356,31 @@
</Select>
} else if (item.type === 'textarea') {
span = 24
- className = 'text-area'
rules = [
{ required: item.required, message: '璇疯緭鍏�' + item.label + '!' }
]
+
+ if (item.key === 'formula') {
+ fields.push(
+ <Col span={span} key={index}>
+ <Form.Item className={className} extra={extra} label={item.tooltip ?
+ <Tooltip placement="topLeft" title={item.tooltip}>
+ <QuestionCircleOutlined className="mk-form-tip" />
+ {item.label}
+ </Tooltip> : item.label
+ }>
+ {getFieldDecorator(item.key, {
+ initialValue: initVal,
+ rules: rules
+ })(<TextArea rows={item.rows || 2}/>)}
+ </Form.Item>
+ <Popover overlayClassName="formula-fields" placement="topLeft" title="" content={<div>{item.fields}</div>} trigger="click">
+ <span className="formula-icon">瀛楁闆�</span>
+ </Popover>
+ </Col>
+ )
+ return
+ }
content = <TextArea rows={item.rows || 2}/>
} else if (item.type === 'codemirror') {
@@ -313,18 +388,39 @@
{ required: item.required, message: '璇疯緭鍏�' + item.label + '!' }
]
span = 24
- className = 'text-area'
- extra = <span className="add-resource-empty" onClick={this.handleEmpty}>绌�</span>
+ if (this.record.editType !== 'popSelect') {
+ extra = <span className="add-resource-empty" onClick={this.handleEmpty}>绌�</span>
+ }
+ if (item.placeholder) {
+ extra = <><span className="resource-public-var">{item.placeholder}</span>{extra}</>
+ }
content = <CodeMirror />
} else if (item.type === 'options') {
span = 24
- className = 'text-area'
- let linkSubFields = this.column.linkSubField || []
+ let linkSubFields = this.record.linkSubField || []
+
+ let columns = []
+
+ columns.push({ title: 'Value', key: 'Value', strict: true })
+ columns.push({ title: 'Text', key: 'Text' })
+
+ linkSubFields.forEach(field => {
+ if (field === 'Value' || field === 'Text') return
+
+ columns.push({ title: transfield[field] || field, key: field })
+ })
- content = <EditTable type={'select'} module="form" transfield={transfield} linkSubFields={linkSubFields} onChange={this.changeOptions}/>
+ content = <EditTable columns={columns} module="form" onChange={(data) => this.changeOptions(data, item.key)}/>
+ } else if (item.type === 'fields') {
+ span = 24
+ rules = [
+ { required: item.required, message: '璇锋坊鍔�' + item.label + '!' }
+ ]
+
+ content = <FieldsTable indexShow={false} actions={['edit', 'move', 'del', 'add']} columns={item.columns} data={this.record[item.key] || []} onChange={(data) => this.changeOptions(data, item.key)}/>
}
fields.push(
@@ -346,38 +442,195 @@
return fields
}
+ transfer = (options) => {
+ if (options.length === 0) return options
+
+ let isNumber = true
+ options.forEach(item => {
+ if (!item.Value || isNaN(item.Value)) {
+ isNumber = false
+ }
+ })
+
+ if (isNumber) {
+ return options.map(item => {
+ item.Value = +item.Value
+ return item
+ })
+ } else {
+ return options.map(item => {
+ item.Value = item.Value + ''
+ return item
+ })
+ }
+ }
+
handleSubmit = () => {
- const { columns, column } = this.props
+ const { fields } = this.props
// 琛ㄥ崟鎻愪氦鏃舵鏌ヨ緭鍏ュ�兼槸鍚︽纭�
this.props.form.validateFieldsAndScroll((err, values) => {
if (!err) {
- values.uuid = column.uuid
- values.marks = column.marks || []
-
- if (values.field && columns.filter(col => col.field && col.uuid !== values.uuid && col.field === values.field).length > 0) {
- notification.warning({
- top: 92,
- message: '瀛楁宸叉坊鍔狅紒',
- duration: 5
+ if (values.type === 'number' && values.editable === 'true') {
+ if (typeof(values.max) === 'number' && typeof(values.min) === 'number' && values.max < values.min) {
+ notification.warning({
+ top: 92,
+ message: '鏈�澶у�间笉鍙皬浜庢渶灏忓�硷紒',
+ duration: 5
+ })
+ return
+ }
+ // eslint-disable-next-line
+ } else if (values.type === 'formula' && values.eval === 'true' && /^[\u4E00-\u9FA50-9a-zA-Z_\s@\+\-\*\/]*$/ig.test(values.formula) && /[\+\-\*\/]/ig.test(values.formula)) {
+ let cols = []
+ fields.forEach(col => {
+ if (/^(Int|Decimal)/ig.test(col.datatype)) {
+ cols.push({reg: new RegExp('@' + col.field + '@', 'ig'), value: `(@${col.field}@)`})
+ }
})
- return
- }
- this.setState({visible: false, formlist: null})
- this.props.submitCol(values)
- this.column = null
+ cols.forEach(col => {
+ values.formula = values.formula.replace(col.reg, col.value)
+ })
+ } else if (values.type === 'text' && values.editable === 'true' && values.editType === 'select') {
+ if (values.resourceType === '0') {
+ values.options = values.options || []
+
+ values.options = this.transfer(values.options)
+
+ if (values.options.filter(op => op.Text === '').length > 0) {
+ notification.warning({
+ top: 92,
+ message: '鎻愮ず鏂囨湰锛圱ext锛変笉鍙负绌猴紒',
+ duration: 5
+ })
+ return
+ } else {
+ let arr = values.options.map(m => m.Value)
+ let _arr = Array.from(new Set(arr))
+ if (arr.length > _arr.length) {
+ notification.warning({
+ top: 92,
+ message: 'Value鍊间笉鍙噸澶嶏紒',
+ duration: 5
+ })
+ return
+ }
+ }
+ }
+ }
+
+ if (values.dataSource) {
+ let error = Utils.verifySql(values.dataSource)
+
+ if (error) {
+ notification.warning({
+ top: 92,
+ message: '鏁版嵁婧愪腑涓嶅彲浣跨敤' + error,
+ duration: 5
+ })
+ return
+ }
+ }
+
+ if (values.editType === 'select' && values.resourceType === '1' && values.dataSource) {
+ let _option = Utils.getSelectQueryOptions(values)
+
+ let sql = `declare @mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20)
+ ${_option.sql}`
+
+ // LoginUID|SessionUid|UserID|Appkey 宸叉浛鎹�
+ sql = sql.replace(/@\$|\$@/ig, '').replace(/@(BID|ID|time_id)@/ig, `'1949-10-01 15:00:00'`)
+
+ let rduri = ''
+ if (window.GLOB.mainSystemApi && values.database === 'sso') {
+ rduri = window.GLOB.mainSystemApi
+ }
+
+ Api.sDebug(sql, rduri).then(result => {
+ if (result.status || result.ErrCode === '-2') {
+ this.setState({visible: false, loading: false, formlist: null})
+ this.props.submitCol(values)
+ this.record = null
+ } else {
+ this.setState({loading: false})
+ Modal.error({
+ title: result.message
+ })
+ }
+ })
+ } else if (values.editType === 'popSelect' && values.dataSource) {
+ let arrfield = values.columns.map(f => f.field)
+
+ if (values.linkSubField && values.linkSubField.length > 0) {
+ values.linkSubField.forEach(n => {
+ if (!arrfield.includes(n)) {
+ arrfield.push(n)
+ }
+ })
+ }
+
+ let _datasource = values.dataSource
+ let sql = ''
+
+ if (/\s/.test(_datasource)) { // 鎷兼帴鍒悕
+ _datasource = '(' + _datasource + ') tb'
+ }
+
+ arrfield = arrfield.join(',')
+
+ let _search = ''
+
+ if (values.searchKey) {
+ let fields = values.searchKey.split(',').map(field => field + ' like \'%mk%\'')
+ _search = 'where ' + fields.join(' OR ')
+ }
+
+ if (values.laypage === 'true') {
+ sql = `/*system_query*/select top 10 ${arrfield} from (select ${arrfield} ,ROW_NUMBER() over(order by ${values.order}) as rows from ${_datasource} ${_search}) tmptable where rows > 0 order by tmptable.rows `
+ } else if (values.order) {
+ sql = `/*system_query*/select ${arrfield} from (select ${arrfield} ,ROW_NUMBER() over(order by ${values.order}) as rows from ${_datasource} ${_search}) tmptable order by tmptable.rows `
+ } else {
+ sql = `/*system_query*/select ${arrfield} from ${_datasource} ${_search} `
+ }
+
+ sql = `declare @mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20)
+ ${sql}`
+
+ sql = sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, '\'\'')
+ sql = sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`)
+ sql = sql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') || ''}'`)
+ sql = sql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') || ''}'`)
+ sql = sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey || ''}'`)
+
+ Api.sDebug(sql).then(result => {
+ if (result.status || result.ErrCode === '-2') {
+ this.setState({visible: false, loading: false, formlist: null})
+ this.props.submitCol(values)
+ this.record = null
+ } else {
+ this.setState({loading: false})
+ Modal.error({
+ title: result.message
+ })
+ }
+ })
+ } else {
+ this.setState({visible: false, formlist: null})
+ this.props.submitCol(values)
+ this.record = null
+ }
}
})
}
editModalCancel = () => {
- this.setState({visible: false, formlist: null})
+ this.setState({visible: false, loading: false, formlist: null})
this.props.cancelCol()
}
render() {
- const { visible } = this.state
+ const { visible, loading } = this.state
const formItemLayout = {
labelCol: {
xs: { span: 24 },
@@ -393,11 +646,13 @@
<div style={{display: 'inline-block'}}>
<Modal
title="鏄剧ず鍒楃紪杈�"
+ wrapClassName="mk-scroll-modal"
visible={visible}
width={900}
maskClosable={false}
onOk={this.handleSubmit}
onCancel={this.editModalCancel}
+ confirmLoading={loading}
destroyOnClose
>
<Form {...formItemLayout} className="commontable-column-form" id="edit-table-column-winter">
--
Gitblit v1.8.0