From 12d591d4ed4880ee87bdda444424b9acaa73d9f7 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 20 二月 2024 18:12:11 +0800
Subject: [PATCH] 2024-02-20

---
 src/menu/components/table/edit-table/columns/editColumn/index.jsx |  352 +++++++++++++++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 309 insertions(+), 43 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 00c47c3..038dee7 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 { checkSQL } from '@/utils/utils-custom.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'],
@@ -25,8 +30,8 @@
 
 class EdiTableColumn extends Component {
   static propTpyes = {
-    visible: PropTypes.bool,
     column: PropTypes.object,
+    wrap: PropTypes.object,
     columns: PropTypes.array,
     fields: PropTypes.array,
     submitCol: PropTypes.func,  // 鎻愪氦浜嬩欢
@@ -35,11 +40,12 @@
 
   state = {
     visible: false,
+    loading: false,
     formlist: null,
     transfield: {}
   }
 
-  column = null
+  record = null
 
   UNSAFE_componentWillMount() {
     let transfield = {}
@@ -57,18 +63,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', 'cache', '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')
@@ -76,9 +90,17 @@
         } else {
           _options.push('required', 'enter')
         }
-      } else if (this.column.type === 'number') {
-        _options.push('max', 'min', 'enter')
+      } else if (this.record.type === 'number') {
+        _options.push('max', 'min', 'enter', 'clearField')
       }
+    }
+    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
@@ -90,11 +112,12 @@
       return item
     })
 
-    let formlist = getColumnForm(column, fields, this.props.columns)
+    let formlist = getColumnForm(column, fields, this.props.columns, this.props.wrap)
+    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()
 
@@ -102,6 +125,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
       })
@@ -119,21 +147,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' || value === 'colspan') {
+        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') {
@@ -149,15 +196,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
@@ -170,12 +217,27 @@
       }
     } else if (key === 'format' && value === 'percent') {
       this.props.form.setFieldsValue({postfix: '%'})
-    } else if (key === 'editable' || key === 'editType' || key === 'resourceType') {
+    } else if (key === 'editType') {
       let _options = this.getOptions()
 
       this.setState({
         formlist: this.state.formlist.map(item => {
-          item.initVal = this.column[item.key] || item.initVal
+          if (item.key === 'enter' && item.options && item.options[item.options.length - 1].field === '$noActX') {
+            item.options[item.options.length - 1].disabled = value !== 'select'
+          }
+
+          item.initVal = this.record[item.key]
+          item.hidden = !_options.includes(item.key)
+
+          return item
+        })
+      })
+    } 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.record[item.key]
           item.hidden = !_options.includes(item.key)
 
           return item
@@ -187,7 +249,7 @@
   multiselectChange = (key, value) => {
     if (key !== 'linkSubField') return
 
-    this.column[key] = value
+    this.record[key] = value
   }
 
   handleEmpty = () => {
@@ -224,8 +286,8 @@
     this.props.form.setFieldsValue({dataSource: resource})
   }
 
-  changeOptions = (data) => {
-    this.column.options = data || []
+  changeOptions = (data, key) => {
+    this.record[key] = data || []
   }
 
   getFields() {
@@ -270,6 +332,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}
@@ -277,8 +345,8 @@
           onChange={(value, option) => {this.typeChange(item.key, value, option)}}
           getPopupContainer={() => document.getElementById('edit-table-column-winter')}
         >
-          {item.options.map((option, i) =>
-            <Select.Option key={i} datatype={option.datatype || ''} label={option.label || ''} value={(option.value || option.field || option.MenuID)}>
+          {options.map((option, i) =>
+            <Select.Option key={i} disabled={option.disabled === true} datatype={option.datatype || ''} label={option.label || ''} value={(option.value || option.field || option.MenuID)}>
               {(option.text || option.label || option.MenuName)}
             </Select.Option>
           )}
@@ -305,10 +373,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') {
@@ -316,18 +405,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(
@@ -349,7 +459,31 @@
     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 { fields } = this.props
     // 琛ㄥ崟鎻愪氦鏃舵鏌ヨ緭鍏ュ�兼槸鍚︽纭�
     this.props.form.validateFieldsAndScroll((err, values) => {
       if (!err) {
@@ -362,23 +496,153 @@
             })
             return
           }
-        }
-        this.setState({visible: false, formlist: null})
-        this.props.submitCol(values)
+          // 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}@)`})
+            }
+          })
 
-        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.type === 'text' && values.editable === 'true') {
+          if (values.editType !== 'select' && values.enter === '$noActX') {
+            values.enter = '$noAct'
+          }
+        }
+
+        if (values.dataSource) {
+          let pass = checkSQL(values.dataSource)
+
+          if (!pass) 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, '')
+  
+          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, `''`)
+
+          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 },
@@ -394,11 +658,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