From cadfd4ed559fb170bb81d5bafbb6ae9775ba1ddc Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期四, 03 三月 2022 18:18:39 +0800
Subject: [PATCH] 2022-03-03
---
src/tabviews/custom/components/table/edit-table/normalTable/index.jsx | 1072 +++++++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 923 insertions(+), 149 deletions(-)
diff --git a/src/tabviews/custom/components/table/edit-table/normalTable/index.jsx b/src/tabviews/custom/components/table/edit-table/normalTable/index.jsx
index 8580b14..987b60d 100644
--- a/src/tabviews/custom/components/table/edit-table/normalTable/index.jsx
+++ b/src/tabviews/custom/components/table/edit-table/normalTable/index.jsx
@@ -1,16 +1,24 @@
import React, {Component} from 'react'
import PropTypes from 'prop-types'
import { is, fromJS } from 'immutable'
-import { Table, Typography, Icon, Switch, Input, InputNumber } from 'antd'
+import { Table, Typography, Switch, Modal, Input, InputNumber, Tooltip, Button, notification, message, Select } from 'antd'
+import { ExclamationCircleOutlined, EditOutlined, PlusOutlined, PlusCircleOutlined, DeleteOutlined } from '@ant-design/icons'
+import moment from 'moment'
+import Api from '@/api'
+import options from '@/store/options.js'
import asyncComponent from '@/utils/asyncComponent'
+import Utils, { getEditTableSql, getMark } from '@/utils/utils.js'
+import MkIcon from '@/components/mk-icon'
import MKEmitter from '@/utils/events.js'
import zhCN from '@/locales/zh-CN/main.js'
import enUS from '@/locales/en-US/main.js'
+import CusSwitch from './cusSwitch'
import '@/assets/css/table.scss'
import './index.scss'
const { Paragraph } = Typography
+const { confirm } = Modal
const CardCellComponent = asyncComponent(() => import('@/tabviews/custom/components/card/cardcellList'))
class BodyRow extends React.Component {
@@ -91,82 +99,14 @@
class BodyCell extends React.Component {
state = {
- editing: false
- }
-
- getMark = (record, marks, style, content) => {
- marks.some(mark => {
- let originVal = record[mark.field[0]] + ''
- let contrastVal = ''
- let result = false
-
- if (mark.field[1] === 'static') {
- contrastVal = mark.contrastValue + ''
- } else {
- contrastVal = record[mark.field[2]] + ''
- }
-
- if (mark.match === '=') {
- result = originVal === contrastVal
- } else if (mark.match === '!=') {
- result = originVal !== contrastVal
- } else if (mark.match === 'like') {
- result = originVal.indexOf(contrastVal) > -1
- } else if (mark.match === '>') {
- try {
- originVal = parseFloat(originVal)
- contrastVal = parseFloat(contrastVal)
- } catch (e) {
- originVal = NaN
- }
-
- if (!isNaN(originVal) && !isNaN(contrastVal) && originVal > contrastVal) {
- result = true
- }
- } else if (mark.match === '<') {
- try {
- originVal = parseFloat(originVal)
- contrastVal = parseFloat(contrastVal)
- } catch (e) {
- originVal = NaN
- }
-
- if (!isNaN(originVal) && !isNaN(contrastVal) && originVal < contrastVal) {
- result = true
- }
- }
-
- if (result) {
- if (mark.signType[0] === 'font') {
- style.color = mark.color
- } else if (mark.signType[0] === 'background') {
- style.background = mark.color
- if (mark.fontColor) {
- style.color = mark.fontColor
- }
- } else if (mark.signType[0] === 'underline') {
- style.textDecoration = 'underline'
- style.color = mark.color
- } else if (mark.signType[0] === 'line-through') {
- style.textDecoration = 'line-through'
- style.color = mark.color
- } else if (mark.signType[0] === 'icon') {
- let icon = (<Icon style={{color: mark.color}} type={mark.signType[3]} />)
- if (mark.signType[1] === 'front') {
- content = <span>{icon} {content}</span>
- } else {
- content = <span>{content} {icon}</span>
- }
- }
- }
- return result
- })
-
- return content
+ editing: false,
+ err: null
}
shouldComponentUpdate (nextProps, nextState) {
- return !is(fromJS(this.props.record), fromJS(nextProps.record)) || nextState.editing !== this.state.editing
+ return !is(fromJS(this.props.record), fromJS(nextProps.record)) ||
+ nextState.editing !== this.state.editing ||
+ nextState.err !== this.state.err
}
componentDidMount () {
@@ -185,7 +125,8 @@
tdFocus = (id) => {
const { col, record } = this.props
- if (id !== col.uuid + record.$Index) return
+
+ if (id !== col.uuid + record.$$uuid) return
this.focus()
}
@@ -194,23 +135,50 @@
const { value } = this.state
this.setState({editing: false})
- if (col.enter === '$next') {
- MKEmitter.emit('nextLine', col, record.$Index)
- } else {
- MKEmitter.emit('tdFocus', col.enter + record.$Index)
- }
+ setTimeout(() => {
+ if (col.enter === '$next') {
+ MKEmitter.emit('nextLine', col, record.$$uuid)
+ } else {
+ MKEmitter.emit('tdFocus', col.enter + record.$$uuid)
+ }
+ }, 50)
- let _record = {...record, [col.field]: value}
- MKEmitter.emit('changeRecord', _record)
+ if (value !== record[col.field]) {
+ MKEmitter.emit('changeRecord', col.tableId, {...record, [col.field]: value})
+ }
}
focus = () => {
const { col, record } = this.props
- this.setState({editing: true, value: record[col.field] !== undefined ? record[col.field] : ''}, () => {
- let node = document.getElementById(col.uuid + record.$Index)
- node && node.select()
- })
+ if (col.editType === 'switch' || col.editType === 'select') {
+ this.setState({editing: true}, () => {
+ let node = document.getElementById(col.uuid + record.$$uuid)
+ node && node.click()
+ })
+ } else {
+ let err = null
+ let val = record[col.field] !== undefined ? record[col.field] : ''
+
+ if (col.type === 'number') {
+ val = +val
+ if (isNaN(val)) {
+ val = 0
+ }
+ if (typeof(col.max) === 'number' && val > col.max) {
+ err = col.label + '鏈�澶т负' + col.max
+ } else if (typeof(col.min) === 'number' && val < col.min) {
+ err = col.label + '鏈�灏忎负' + col.min
+ }
+ } else if (col.required === 'true' && !val) {
+ err = '璇峰～鍐�' + col.label
+ }
+
+ this.setState({editing: true, value: val, err}, () => {
+ let node = document.getElementById(col.uuid + record.$$uuid)
+ node && node.select()
+ })
+ }
}
onBlur = () => {
@@ -219,13 +187,91 @@
this.setState({editing: false})
- let _record = {...record, [col.field]: value}
- MKEmitter.emit('changeRecord', _record)
+ if (value !== record[col.field]) {
+ MKEmitter.emit('changeRecord', col.tableId, {...record, [col.field]: value})
+ }
+ }
+
+ onChange = (val) => {
+ const { col } = this.props
+
+ let err = null
+
+ if (col.type === 'number') {
+ val = +val
+ if (isNaN(val)) {
+ val = 0
+ }
+ if (typeof(col.max) === 'number' && val > col.max) {
+ err = col.label + '鏈�澶т负' + col.max
+ } else if (typeof(col.min) === 'number' && val < col.min) {
+ err = col.label + '鏈�灏忎负' + col.min
+ }
+ } else if (col.required === 'true' && !val) {
+ err = '璇峰～鍐�' + col.label
+ }
+ this.setState({value: val, err})
+ }
+
+ onSwitchChange = (val) => {
+ const { col, record } = this.props
+
+ this.setState({editing: false})
+
+ setTimeout(() => {
+ if (col.enter === '$next') {
+ MKEmitter.emit('nextLine', col, record.$$uuid)
+ } else {
+ MKEmitter.emit('tdFocus', col.enter + record.$$uuid)
+ }
+ }, 50)
+
+ MKEmitter.emit('changeRecord', col.tableId, {...record, [col.field]: val})
+ }
+
+ onSelectChange = (val, option) => {
+ const { col, record } = this.props
+
+ let values = {}
+ let _option = col.options.filter(m => m.key === option.key)[0]
+
+ if (_option) {
+ if (col.linkSubField) {
+ col.linkSubField.forEach(m => {
+ values[m] = _option[m] !== undefined ? _option[m] : ''
+ })
+ }
+
+ if (col.editField) {
+ values[col.field] = _option.label
+ values[col.editField] = val
+ } else {
+ values[col.field] = val
+ }
+ }
+
+ this.setState({editing: false})
+
+ setTimeout(() => {
+ if (col.enter === '$next') {
+ MKEmitter.emit('nextLine', col, record.$$uuid)
+ } else {
+ MKEmitter.emit('tdFocus', col.enter + record.$$uuid)
+ }
+ }, 50)
+
+ MKEmitter.emit('changeRecord', col.tableId, {...record, ...values})
+ }
+
+ switchBlur = () => {
+ setTimeout(() => {
+ this.setState({editing: false})
+ }, 10)
}
render() {
let { col, config, record, style, className } = this.props
- const { editing, value } = this.state
+ const { editing, value, err } = this.state
let children = null
if (col.type === 'text') {
@@ -245,15 +291,46 @@
}
if (col.marks) {
- style = style || {}
- content = this.getMark(record, col.marks, style, content)
+ let mark = getMark(col.marks, record, style)
+
+ style = mark.style
+
+ if (mark.icon) {
+ if (mark.position === 'front') {
+ content = <span><MkIcon style={{color: mark.color}} type={mark.icon} /> {content}</span>
+ } else {
+ content = <span>{content} <MkIcon style={{color: mark.color}} type={mark.icon} /></span>
+ }
+ }
}
if (col.editable === 'true') {
if (editing) {
- return (<td className="editing_table_cell">
- <Input id={col.uuid + record.$Index} defaultValue={value} onChange={(e) => this.setState({value: e.target.value})} onPressEnter={this.enterPress} onBlur={this.onBlur}/>
- </td>)
+ if (!col.editType || col.editType === 'text') {
+ return (<td className="editing_table_cell">
+ <Input id={col.uuid + record.$$uuid} defaultValue={value} onChange={(e) => this.onChange(e.target.value)} onPressEnter={this.enterPress} onBlur={this.onBlur}/>
+ {err ? <Tooltip title={err}><ExclamationCircleOutlined /></Tooltip> : null}
+ </td>)
+ } else if (col.editType === 'switch') {
+ let _value = record[col.field] !== undefined ? record[col.field] : ''
+ return (<td className="editing_table_cell">
+ <CusSwitch config={col} defaultValue={_value} onChange={this.onSwitchChange} onBlur={this.switchBlur}/>
+ </td>)
+ } else {
+ let _value = record[col.field] !== undefined ? record[col.field] : ''
+ return (<td className="editing_table_cell">
+ <Select
+ showSearch
+ defaultValue={_value}
+ id={col.uuid + record.$$uuid}
+ onBlur={() => this.setState({editing: false})}
+ filterOption={(input, option) => option.props.children.toLowerCase().indexOf(input.toLowerCase()) >= 0}
+ onSelect={this.onSelectChange}
+ >
+ {col.options.map((item, i) => (<Select.Option key={item.key} disabled={item.$disabled} value={item.value}>{item.label}</Select.Option>))}
+ </Select>
+ </td>)
+ }
} else {
return (<td className={className + ' pointer'} style={style}><div className="mk-mask" onClick={this.focus}></div>{content}</td>)
}
@@ -276,6 +353,8 @@
if (col.format === 'percent') {
content = content * 100
decimal = decimal > 2 ? decimal - 2 : 0
+ } else if (col.format === 'abs') {
+ content = Math.abs(content)
}
content = content.toFixed(decimal)
@@ -288,14 +367,24 @@
}
if (col.marks) {
- style = style || {}
- content = this.getMark(record, col.marks, style, content)
+ let mark = getMark(col.marks, record, style)
+
+ style = mark.style
+
+ if (mark.icon) {
+ if (mark.position === 'front') {
+ content = <span><MkIcon style={{color: mark.color}} type={mark.icon} /> {content}</span>
+ } else {
+ content = <span>{content} <MkIcon style={{color: mark.color}} type={mark.icon} /></span>
+ }
+ }
}
if (col.editable === 'true') {
if (editing) {
return (<td className="editing_table_cell">
- <InputNumber id={col.uuid + record.$Index} defaultValue={value} onChange={(val) => this.setState({value: val})} onPressEnter={this.enterPress} onBlur={this.onBlur}/>
+ <InputNumber id={col.uuid + record.$$uuid} defaultValue={value} onChange={(val) => this.onChange(val)} onPressEnter={this.enterPress} onBlur={this.onBlur}/>
+ {err ? <Tooltip title={err}><ExclamationCircleOutlined /></Tooltip> : null}
</td>)
} else {
return (<td className={className + ' pointer'} style={style}><div className="mk-mask" onClick={this.focus}></div>{content}</td>)
@@ -318,6 +407,48 @@
{content ? <Paragraph copyable ellipsis={{ rows: 3, expandable: true }}>{content}</Paragraph> : null }
</div>
)
+ } else if (col.type === 'formula') {
+ let content = col.formula
+ Object.keys(record).forEach(key => {
+ let reg = new RegExp('@' + key + '@', 'ig')
+ content = content.replace(reg, record[key])
+ })
+
+ if (col.eval !== 'false') {
+ try {
+ // eslint-disable-next-line
+ content = eval(content)
+ } catch (e) {
+ content = ''
+ }
+ }
+
+ content = content === undefined ? '' : content
+
+ if (content !== '') {
+ content = `${col.prefix || ''}${content}${col.postfix || ''}`
+
+ if (col.eval === 'false') {
+ content = content.replace(/\n/ig, '<br/>').replace(/\s/ig, ' ')
+ content = <span dangerouslySetInnerHTML={{__html: content}}></span>
+ }
+ }
+
+ if (col.marks) {
+ let mark = getMark(col.marks, record, style)
+
+ style = mark.style
+
+ if (mark.icon) {
+ if (mark.position === 'front') {
+ content = <span><MkIcon style={{color: mark.color}} type={mark.icon} /> {content}</span>
+ } else {
+ content = <span>{content} <MkIcon style={{color: mark.color}} type={mark.icon} /></span>
+ }
+ }
+ }
+
+ children = content
} else if (col.type === 'custom') {
style.padding = '0px'
if (col.style) {
@@ -332,9 +463,15 @@
children = (
<CardCellComponent data={record} cards={config} elements={col.elements}/>
)
+ } else if (col.type === 'operation') {
+ style.padding = '0px 5px'
+ children = (
+ <Button type="link" style={{color: 'rgb(255, 77, 79)', backgroundColor: 'transparent'}} onClick={() => MKEmitter.emit('delRecord', col.tableId, {...record})}>鍒犻櫎</Button>
+ )
}
- return (<td className={className} style={style}>{children}</td>)
+ return (<td className={className} style={style}>{col.addable ? <PlusCircleOutlined onClick={() => MKEmitter.emit('addRecord', col.tableId, {...record})} className="mk-editable mk-plus"/> : null}{children}{col.delable ? <DeleteOutlined onClick={() => MKEmitter.emit('delRecord', col.tableId, {...record})} className="mk-editable mk-del"/> : null}</td>)
+ // return (<td className={className} style={style}>{children}</td>)
}
}
@@ -346,7 +483,7 @@
columns: PropTypes.array, // 琛ㄦ牸鍒�
lineMarks: PropTypes.any, // 琛屾爣璁�
fields: PropTypes.array, // 缁勪欢瀛楁闆�
- BData: PropTypes.any, // 涓昏〃鏁版嵁
+ BID: PropTypes.any, // 涓昏〃ID
data: PropTypes.any, // 琛ㄦ牸鏁版嵁
total: PropTypes.any, // 鎬绘暟
loading: PropTypes.bool, // 琛ㄦ牸鍔犺浇涓�
@@ -356,37 +493,47 @@
state = {
dict: sessionStorage.getItem('lang') !== 'en-US' ? zhCN : enUS,
data: [],
+ edData: [],
+ edColumns: [],
tableId: '', // 琛ㄦ牸ID
pageIndex: 1, // 鍒濆椤甸潰绱㈠紩
pageSize: 10, // 姣忛〉鏁版嵁鏉℃暟
columns: null, // 鏄剧ず鍒�
+ fields: [],
pickup: false, // 鏀惰捣鏈�夋嫨椤�
- orderfields: {} // 鎺掑簭id涓巉ield杞崲
+ orderfields: {}, // 鎺掑簭id涓巉ield杞崲
+ loading: false,
+ editable: 'false',
+ pageOptions: []
}
UNSAFE_componentWillMount () {
const { setting, fields, columns, data } = this.props
let orderfields = {}
let initEditLine = null
+ let edColumns = []
- let _columns = columns.map(item => {
- if (item.type === 'index') {
- item.field = '$Index'
- item.type = 'text'
- }
+ let _columns = []
+ let deForms = []
+ columns.forEach(item => {
if (!initEditLine && item.editable === 'true') {
initEditLine = item
}
- if (item.marks && item.marks.length === 0) {
- item.marks = ''
+ if (item.type === 'text' && item.editable === 'true' && item.editType === 'select' && item.resourceType === '1') {
+ let _option = Utils.getSelectQueryOptions(item)
+
+ item.base_sql = window.btoa(window.encodeURIComponent(_option.sql))
+ item.arr_field = _option.field
+
+ deForms.push(item)
}
if (item.field) {
orderfields[item.uuid] = item.field
}
- return {
+ let _item = {
align: item.Align,
dataIndex: item.uuid,
title: item.label,
@@ -398,30 +545,62 @@
config: item.type === 'custom' || item.type === 'action' ? {setting, columns: fields} : null,
})
}
+
+ if (item.type !== 'action') {
+ let _copy = fromJS(_item).toJS()
+ _copy.sorter = false
+
+ if (item.editable === 'true') {
+ _copy.title = <span>{item.label}<EditOutlined className="system-color" style={{position: 'absolute', bottom: '2px', right: '5px'}}/></span>
+ }
+ edColumns.push(_copy)
+ }
+ _columns.push(_item)
})
- let tableId = (() => {
- let uuid = []
- let _options = 'abcdefghigklmnopqrstuv'
- for (let i = 0; i < 19; i++) {
- uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
- }
- return uuid.join('')
- }) ()
+ if (setting.delable !== 'false' && setting.operType !== 'buoyMode') {
+ edColumns.push({
+ align: 'center',
+ dataIndex: 'mkoperation',
+ title: '鎿嶄綔',
+ sorter: false,
+ width: 100,
+ onCell: record => ({
+ record,
+ col: {type: 'operation', tableId: setting.tableId},
+ })
+ })
+ }
if (setting.borderColor) { // 杈规棰滆壊
- let style = `#${tableId} table, #${tableId} tr, #${tableId} th, #${tableId} td {border-color: ${setting.borderColor}}`
+ let style = `#${setting.tableId} table, #${setting.tableId} tr, #${setting.tableId} th, #${setting.tableId} td {border-color: ${setting.borderColor}}`
let ele = document.createElement('style')
ele.innerHTML = style
document.getElementsByTagName('head')[0].appendChild(ele)
}
+ let size = (setting.pageSize || 10) + ''
+ let pageOptions = ['10', '25', '50', '100', '500', '1000']
+
+ if (!pageOptions.includes(size)) {
+ pageOptions.push(size)
+ pageOptions = pageOptions.sort((a, b) => a - b)
+ }
+
this.setState({
+ pageSize: setting.pageSize || 10,
+ pageOptions,
data,
columns: _columns,
- tableId,
+ edColumns,
+ tableId: setting.tableId,
orderfields,
- initEditLine
+ initEditLine,
+ editable: setting.editable
+ }, () => {
+ if (deForms.length > 0) {
+ this.improveActionForm(deForms)
+ }
})
}
@@ -430,8 +609,23 @@
}
componentDidMount () {
- MKEmitter.addListener('resetTable', this.resetTable)
+ const { fields, setting } = this.props
+ const { data, editable } = this.state
+
+ this.setState({
+ fields: fields.filter(item => item.field !== setting.primaryKey),
+ })
+
+ if (editable === 'true' && data && data.length > 0) {
+ setTimeout(() => {
+ this.pickupChange()
+ }, 200)
+ }
+
MKEmitter.addListener('nextLine', this.nextLine)
+ MKEmitter.addListener('addRecord', this.addLine)
+ MKEmitter.addListener('delRecord', this.delRecord)
+ MKEmitter.addListener('resetTable', this.resetTable)
MKEmitter.addListener('changeRecord', this.changeRecord)
}
@@ -442,36 +636,573 @@
this.setState = () => {
return
}
- MKEmitter.removeListener('resetTable', this.resetTable)
MKEmitter.removeListener('nextLine', this.nextLine)
+ MKEmitter.removeListener('addRecord', this.addLine)
+ MKEmitter.removeListener('delRecord', this.delRecord)
+ MKEmitter.removeListener('resetTable', this.resetTable)
MKEmitter.removeListener('changeRecord', this.changeRecord)
}
UNSAFE_componentWillReceiveProps(nextProps) {
if (!is(fromJS(this.props.data), fromJS(nextProps.data))) {
this.setState({data: nextProps.data || []})
+ if (this.state.editable === 'true' && !this.state.pickup) {
+ setTimeout(() => {
+ this.pickupChange()
+ }, 200)
+ }
}
+ }
+
+ improveActionForm = (deForms) => {
+ const { BID, setting } = this.props
+
+ let deffers = []
+ let mainItems = [] // 浜戠鎴栧崟鐐规暟鎹�
+ let localItems = [] // 鏈湴鏁版嵁
+ let cache = setting.cache !== 'false'
+
+ deForms.forEach(item => {
+ if (item.database === 'sso') {
+ mainItems.push(`select '${item.uuid}' as obj_name,'${item.arr_field}' as arr_field,'${item.base_sql}' as LText`)
+ } else {
+ localItems.push(`select '${item.uuid}' as obj_name,'${item.arr_field}' as arr_field,'${item.base_sql}' as LText`)
+ }
+ })
+
+ if (options.sysType !== 'local') {
+ localItems = [...localItems, ...mainItems]
+ mainItems = []
+ }
+
+ // 鏈湴璇锋眰
+ let param = {
+ func: 'sPC_Get_SelectedList',
+ LText: localItems.join(' union all '),
+ obj_name: '',
+ arr_field: '',
+ table_type: 'Y',
+ BID: BID || ''
+ }
+
+ if (param.LText) {
+ param.LText = Utils.formatOptions(param.LText)
+ param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
+ param.secretkey = Utils.encrypt(param.LText, param.timestamp)
+
+ deffers.push(
+ new Promise(resolve => {
+ Api.getSystemCacheConfig(param, cache).then(res => {
+ if (!res.status) {
+ notification.warning({
+ top: 92,
+ message: res.message,
+ duration: 5
+ })
+ }
+ resolve(res)
+ })
+ })
+ )
+ }
+
+ // 绯荤粺璇锋眰
+ let mainparam = {
+ func: 'sPC_Get_SelectedList',
+ LText: mainItems.join(' union all '),
+ obj_name: '',
+ arr_field: '',
+ table_type: 'Y',
+ BID: BID || ''
+ }
+
+ if (mainparam.LText) {
+ mainparam.LText = Utils.formatOptions(mainparam.LText)
+ mainparam.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
+ mainparam.secretkey = Utils.encrypt(mainparam.LText, mainparam.timestamp)
+
+ if (window.GLOB.mainSystemApi) {
+ mainparam.rduri = window.GLOB.mainSystemApi
+ }
+
+ deffers.push(
+ new Promise(resolve => {
+ Api.getSystemCacheConfig(mainparam, cache).then(res => {
+ if (!res.status) {
+ notification.warning({
+ top: 92,
+ message: res.message,
+ duration: 5
+ })
+ }
+ resolve(res)
+ })
+ })
+ )
+ }
+
+ Promise.all(deffers).then(response => {
+ let result = {...response[0], ...(response[1] || {})}
+
+ delete result.ErrCode
+ delete result.ErrMesg
+ delete result.message
+ delete result.status
+
+ this.resetFormList(result)
+ })
+ }
+
+ resetFormList = (result) => {
+ const { columns } = this.props
+ const { edColumns } = this.state
+
+ let _edColumns = []
+
+ let reCols = {}
+ columns.forEach(item => {
+ if (item.resourceType === '1' && result[item.uuid] && result[item.uuid].length > 0) {
+ let options = []
+ let _map = new Map()
+ result[item.uuid].forEach(cell => {
+ let _cell = {key: Utils.getuuid()}
+
+ _cell.value = cell[item.valueField]
+ _cell.label = cell[item.valueText]
+
+ if (!_cell.label && _cell.label !== 0) return
+
+ if (_map.has(_cell.value)) return
+ _map.set(_cell.value, true)
+
+ if (item.linkSubField) {
+ item.linkSubField.forEach(m => {
+ _cell[m] = cell[m] === undefined ? '' : cell[m]
+ })
+ }
+
+ if (item.disableField && cell[item.disableField] && /^true$/ig.test(cell[item.disableField])) {
+ _cell.$disabled = true
+ }
+
+ options.push(_cell)
+ })
+
+ item.options = options
+
+ reCols[item.uuid] = item
+ }
+ })
+
+ _edColumns = edColumns.map(item => {
+ if (reCols[item.dataIndex]) {
+ item.onCell = record => ({
+ record,
+ col: reCols[item.dataIndex]
+ })
+ }
+
+ return item
+ })
+
+ this.setState({edColumns: []}, () => {
+ this.setState({edColumns: _edColumns})
+ })
}
nextLine = (col, index) => {
- const { data, initEditLine } = this.state
+ const { setting } = this.props
+ const { edData, initEditLine, tableId } = this.state
+
+ if (col.tableId !== tableId) return
+
index = +index
- if (index < data.length && initEditLine) {
+ if (index < edData.length && initEditLine) {
MKEmitter.emit('tdFocus', initEditLine.uuid + (index + 1))
+ } else if (col.footEnter === 'add' && setting.addable === 'true') {
+ setTimeout(() => {
+ this.plusLine()
+ }, 10)
+ } else if (col.footEnter === 'sub') {
+ setTimeout(() => {
+ this.checkData()
+ }, 10)
}
}
- changeRecord = (record) => {
- let _data = this.state.data.map(item => {
- if (item.$Index === record.$Index) {
+ plusLine = () => {
+ const { edData, fields, initEditLine } = this.state
+
+ let item = {...edData[edData.length - 1]}
+
+ item.$$uuid = Utils.getguid()
+ item.$type = 'add'
+ item.$Index = ''
+
+ fields.forEach(col => {
+ if (col.initval !== '$copy') {
+ item[col.field] = col.initval
+ }
+ if (col.type === 'number') {
+ item[col.field] = +item[col.field]
+ if (isNaN(item[col.field])) {
+ item[col.field] = 0
+ }
+ }
+ if (item[col.field] === undefined) {
+ item[col.field] = ''
+ }
+ })
+
+ this.setState({edData: [...edData, item]}, () => {
+ MKEmitter.emit('tdFocus', initEditLine.uuid + item.$$uuid)
+ })
+ }
+
+ delRecord = (id, record) => {
+ const { tableId, edData } = this.state
+
+ if (id !== tableId) return
+
+ let _data = []
+
+ if (record.$type === 'add') {
+ _data = edData.filter(item => item.$$uuid !== record.$$uuid)
+ } else {
+ _data = edData.map(item => {
+ if (item.$$uuid === record.$$uuid) {
+ record.$deleted = true
+ record.$origin = false
+ record.$type = 'del'
+ return record
+ } else {
+ return item
+ }
+ })
+ }
+
+ this.setState({edData: _data})
+ }
+
+ changeRecord = (id, record) => {
+ const { tableId } = this.state
+
+ if (id !== tableId) return
+
+ let _data = this.state.edData.map(item => {
+ if (item.$$uuid === record.$$uuid) {
+ record.$origin = false
return record
} else {
return item
}
})
- this.setState({data: _data})
+ this.setState({edData: _data})
+ }
+
+ addLine = (id, record) => {
+ const { BID } = this.props
+ const { edData, fields, tableId } = this.state
+
+ if (id) {
+ if (id !== tableId) return
+ let _edData = fromJS(edData).toJS()
+ let index = _edData.findIndex(item => record.$$uuid === item.$$uuid)
+
+ let item = {}
+
+ item.$$uuid = Utils.getguid()
+ item.$type = 'add'
+ item.$Index = ''
+ item.$$BID = BID || ''
+
+ fields.forEach(col => {
+ if (col.initval !== '$copy') {
+ item[col.field] = col.initval
+ }
+ if (col.type === 'number') {
+ item[col.field] = +item[col.field]
+ if (isNaN(item[col.field])) {
+ item[col.field] = 0
+ }
+ }
+
+ if (item[col.field] === undefined) {
+ item[col.field] = ''
+ }
+ })
+
+ _edData.splice(index, 0, item)
+
+ this.setState({edData: _edData})
+ } else {
+ let item = {}
+ if (edData.length > 0) {
+ item = {...edData[edData.length - 1]}
+ item.$$uuid = Utils.getguid()
+ item.$type = 'add'
+ item.$Index = ''
+ } else {
+ item.$$uuid = Utils.getguid()
+ item.$type = 'add'
+ item.$Index = ''
+ item.$$BID = BID || ''
+ }
+
+ fields.forEach(col => {
+ if (col.initval !== '$copy') {
+ item[col.field] = col.initval
+ }
+ if (col.type === 'number') {
+ item[col.field] = +item[col.field]
+ if (isNaN(item[col.field])) {
+ item[col.field] = 0
+ }
+ }
+
+ if (item[col.field] === undefined) {
+ item[col.field] = ''
+ }
+ })
+
+ this.setState({edData: [...edData, item]})
+ }
+ }
+
+ checkData = () => {
+ const { edData, fields } = this.state
+
+ if (edData.length === 0) {
+ notification.warning({
+ top: 92,
+ message: '鎻愪氦鏁版嵁涓嶅彲涓虹┖锛�',
+ duration: 5
+ })
+ return
+ }
+ let err = ''
+ let Index = 1
+ let data = fromJS(edData).toJS().map(item => {
+ let line = []
+ fields.forEach(col => {
+ if (col.editable !== 'true' || item.$deleted) {
+ if (col.type === 'number') {
+ item[col.field] = +item[col.field]
+ if (isNaN(item[col.field])) {
+ item[col.field] = 0
+ }
+ } else {
+ item[col.field] = item[col.field] !== undefined ? (item[col.field] + '') : ''
+ }
+ return
+ }
+ if (col.type === 'text') {
+ let val = item[col.field] !== undefined ? (item[col.field] + '') : ''
+ if (col.required === 'true' && !val) {
+ line.push(`${col.label}涓嶅彲涓虹┖`)
+ }
+ item[col.field] = val
+ } else if (col.type === 'number') {
+ let val = item[col.field]
+ if (!val && val !== 0) {
+ line.push(`${col.label}涓嶅彲涓虹┖`)
+ return
+ }
+ val = +val
+ if (isNaN(val)) {
+ line.push(`${col.label}鏁版嵁鏍煎紡閿欒`)
+ return
+ }
+
+ val = +val.toFixed(col.decimal || 0)
+
+ if (typeof(col.max) === 'number' && val > col.max) {
+ line.push(`${col.label}涓嶅彲澶т簬${col.max}`)
+ } else if (typeof(col.min) === 'number' && val < col.min) {
+ line.push(`${col.label}涓嶅彲灏忎簬${col.min}`)
+ }
+
+ item[col.field] = val
+ }
+ })
+
+ if (line.length > 0) {
+ err += `绗�${Index}琛岋細` + line.join('锛�') + '锛�'
+ }
+ if (!item.$deleted) {
+ Index++
+ }
+
+ return item
+ })
+
+ if (err) {
+ notification.warning({
+ top: 92,
+ message: err,
+ duration: 5
+ })
+ } else {
+ this.submit(data)
+ }
+ }
+
+ submit = (data) => {
+ const { submit, BID, setting } = this.props
+ const { fields } = this.state
+
+ if (setting.commit === 'change') {
+ data = data.filter(item => !item.$origin)
+ }
+
+ if (data.length === 0) {
+ notification.warning({
+ top: 92,
+ message: '鏁版嵁鏈慨鏀癸紝涓嶅彲鎻愪氦锛�',
+ duration: 5
+ })
+ return
+ }
+
+ let result = getEditTableSql(submit, data, fields)
+
+ let param = {
+ excel_in: result.lines,
+ BID: BID || ''
+ }
+
+ this.setState({
+ loading: true
+ })
+
+ if (submit.intertype === 'system') { // 绯荤粺瀛樺偍杩囩▼
+ param.func = 'sPC_TableData_InUpDe'
+
+ if (sessionStorage.getItem('dataM') === 'true') { // 鏁版嵁鏉冮檺
+ result.sql = result.sql.replace(/\$@/ig, '/*')
+ result.sql = result.sql.replace(/@\$/ig, '*/')
+ result.bottom = result.bottom.replace(/\$@/ig, '/*')
+ result.bottom = result.bottom.replace(/@\$/ig, '*/')
+ } else {
+ result.sql = result.sql.replace(/@\$|\$@/ig, '')
+ result.bottom = result.bottom.replace(/@\$|\$@/ig, '')
+ }
+
+ param.excel_in_type = 'true'
+ param.LText1 = Utils.formatOptions(result.insert)
+ param.LText2 = Utils.formatOptions(result.bottom)
+ param.LText = Utils.formatOptions(result.sql)
+ param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
+ param.secretkey = Utils.encrypt(param.LText, param.timestamp)
+
+ param.menuname = submit.logLabel
+
+ if (window.GLOB.probation) {
+ param.s_debug_type = 'Y'
+ }
+
+ Api.genericInterface(param).then((res) => {
+ if (res.status) {
+ this.execSuccess(res)
+ } else {
+ this.execError(res)
+ }
+ }, () => {
+ this.execError({})
+ })
+ } else if (submit.intertype === 'inner' && submit.innerFunc) { // 鑷畾涔夊瓨鍌ㄨ繃绋�
+ param.func = submit.innerFunc
+
+ Api.genericInterface(param).then((res) => {
+ if (res.status) {
+ this.execSuccess(res)
+ } else {
+ this.execError(res)
+ }
+ }, () => {
+ this.execError({})
+ })
+ }
+ }
+
+ execSuccess = (res) => {
+ const { submit } = this.props
+
+ if (res && res.ErrCode === 'S') { // 鎵ц鎴愬姛
+ notification.success({
+ top: 92,
+ message: res.ErrMesg || this.state.dict['main.action.confirm.success'],
+ duration: submit.stime ? submit.stime : 2
+ })
+ } else if (res && res.ErrCode === 'Y') { // 鎵ц鎴愬姛
+ Modal.success({
+ title: res.ErrMesg || this.state.dict['main.action.confirm.success']
+ })
+ } else if (res && res.ErrCode === '-1') { // 瀹屾垚鍚庝笉鎻愮ず
+
+ }
+
+ this.setState({
+ loading: false
+ })
+
+ if (submit.closetab === 'true') {
+ MKEmitter.emit('popclose')
+ }
+ if (submit.execSuccess !== 'never') {
+ this.repick()
+ MKEmitter.emit('refreshByButtonResult', submit.$menuId, submit.execSuccess, submit)
+ }
+ }
+
+ execError = (res) => {
+ const { submit } = this.props
+
+ if (res.ErrCode === 'E') {
+ Modal.error({
+ title: res.message || res.ErrMesg,
+ })
+ } else if (res.ErrCode === 'N') {
+ notification.error({
+ top: 92,
+ message: res.message || res.ErrMesg,
+ duration: submit.ntime ? submit.ntime : 10
+ })
+ } else if (res.ErrCode === 'F') {
+ notification.error({
+ className: 'notification-custom-error',
+ top: 92,
+ message: res.message || res.ErrMesg,
+ duration: submit.ftime ? submit.ftime : 10
+ })
+ } else if (res.ErrCode === 'NM') {
+ message.error(res.message || res.ErrMesg)
+ }
+
+ this.setState({
+ loading: false
+ })
+
+ if (submit.execError !== 'never') {
+ this.repick()
+ MKEmitter.emit('refreshByButtonResult', submit.$menuId, submit.execError, submit)
+ }
+ }
+
+ repick = () => {
+ const { data } = this.state
+
+ this.setState({
+ data: [],
+ edData: [],
+ pickup: false,
+ }, () => {
+ this.setState({
+ data: data,
+ })
+ })
}
changeTable = (pagination, filters, sorter) => {
@@ -479,8 +1210,7 @@
this.setState({
pageIndex: pagination.current,
- pageSize: pagination.pageSize,
- pickup: false
+ pageSize: pagination.pageSize
})
sorter.field = orderfields[sorter.field] || ''
@@ -493,27 +1223,65 @@
if (id !== MenuID) return
- if (repage === 'false') {
+ if (repage !== 'false') {
this.setState({
- pickup: false
- })
- } else {
- this.setState({
- pageIndex: 1,
- pickup: false
+ pageIndex: 1
})
}
}
pickupChange = () => {
- this.setState({
- pickup: !this.state.pickup
- })
+ const { submit } = this.props
+ const { data } = this.state
+
+ let pickup = !this.state.pickup
+
+ if (!submit.sheet) {
+ notification.warning({
+ top: 92,
+ message: '鎻愪氦鎸夐挳灏氭湭璁剧疆锛屼笉鍙紪杈戯紒',
+ duration: 5
+ })
+ return
+ }
+
+ if (!pickup && !is(fromJS(data), fromJS(this.state.edData))) {
+ const _this = this
+ confirm({
+ title: '鏁版嵁宸蹭慨鏀癸紝纭畾鏀惧純淇濆瓨鍚楋紵',
+ onOk() {
+ _this.setState({
+ data: [],
+ edData: [],
+ pickup
+ }, () => {
+ _this.setState({
+ data: data,
+ edData: pickup ? fromJS(data).toJS() : []
+ })
+ })
+ },
+ onCancel() {}
+ })
+ } else {
+ this.setState({
+ data: [],
+ edData: [],
+ pickup,
+ loading: false,
+ editable: 'false'
+ }, () => {
+ this.setState({
+ data: data,
+ edData: pickup ? fromJS(data).toJS() : []
+ })
+ })
+ }
}
render() {
- const { setting, statFValue, lineMarks } = this.props
- const { pickup, tableId, data } = this.state
+ const { setting, statFValue, lineMarks, submit } = this.props
+ const { pickup, tableId, data, edData, columns, edColumns, loading, pageOptions } = this.state
const components = {
body: {
@@ -523,18 +1291,21 @@
}
// 鏁版嵁鏀惰捣鏃讹紝杩囨护宸查�夋暟鎹�
- let _data = data || []
+ let _data = data
+ let _columns = columns
if (pickup) {
+ _data = edData
_data = _data.filter(item => !item.$deleted)
+ _columns = edColumns
}
-
+
let _pagination = false
- if (setting.laypage !== 'false' && setting.laypage !== false) {
+ if (!pickup && setting.laypage !== 'false' && setting.laypage !== false) {
_pagination = {
current: this.state.pageIndex,
pageSize: this.state.pageSize,
- pageSizeOptions: ['10', '25', '50', '100', '500', '1000'],
+ pageSizeOptions: pageOptions,
showSizeChanger: true,
total: this.props.total || 0,
showTotal: (total, range) => `${range[0]}-${range[1]} ${this.state.dict['main.pagination.of']} ${total} ${this.state.dict['main.pagination.items']}`
@@ -543,21 +1314,23 @@
let _footer = ''
- if (statFValue && statFValue.length > 0) {
+ if (!pickup && statFValue && statFValue.length > 0) {
_footer = statFValue.map(f => `${f.label}(鍚堣)锛�${f.value}`).join('锛�')
}
let height = setting.height || false
return (
- <div className={`edit-custom-table ${pickup ? 'editable' : ''} ${setting.tableHeader || ''} ${height ? 'fixed-height' : ''} ${setting.mode || ''}`} id={tableId}>
- <Switch title="缂栬緫" className="main-pickup" checkedChildren="寮�" unCheckedChildren="鍏�" checked={pickup} onChange={this.pickupChange} />
+ <div className={`edit-custom-table ${pickup ? 'editable' : ''} ${setting.tableHeader || ''} ${setting.operType || ''} ${height ? 'fixed-height' : ''} ${setting.mode || ''}`} id={tableId}>
+ <Switch title="缂栬緫" className="main-pickup" checkedChildren="寮�" unCheckedChildren="鍏�" disabled={loading || this.props.loading} checked={pickup} onChange={this.pickupChange} />
+ {pickup ? <Button style={submit.style} onClick={() => setTimeout(() => {this.checkData()}, 10)} loading={loading} className="submit-table" type="link">鎻愪氦</Button> : null}
<Table
+ rowKey="$$uuid"
components={components}
style={setting.style}
size={setting.size || 'middle'}
bordered={setting.bordered !== 'false'}
- columns={this.state.columns}
+ columns={_columns}
dataSource={_data}
loading={this.props.loading}
scroll={{ x: '100%', y: height }}
@@ -571,6 +1344,7 @@
pagination={_pagination}
/>
{_footer ? <div className={'normal-table-footer ' + (_pagination ? 'pagination' : '')}>{_footer}</div> : null}
+ {pickup && setting.addable === 'true' ? <Button className="mk-add-line" onClick={() => this.addLine()} disabled={this.props.loading} type="link"><PlusOutlined /></Button> : null}
</div>
)
}
--
Gitblit v1.8.0