2024-04-22

king

2024-04-22 fc8c8d714687a22f711d642d192bd4149f3b7e88

 src/templates/sharecomponent/actioncomponent/verifyexcelin/index.jsx

@@ -521,7 +521,7 @@
    })
  }

  columnChange = (values) => {
  columnChange = (values, callback) => {
    let verify = JSON.parse(JSON.stringify(this.state.verify))

    let fields = verify.columns.map(item => item.Column)
@@ -532,6 +532,8 @@
        duration: 5
      })
      return
    } else {
      callback()
    }

    values.uuid = Utils.getuuid()
@@ -714,37 +716,44 @@
        if (!err) {
          let _verify = {...verify, ...values}

          if (_verify.excelHandle !== 'true') {
          if (_verify.excelHandle !== 'true') { 
            delete _verify.excel_func
          }
          if (_verify.default === 'false' && _verify.scripts.length === 0) {
            notification.warning({
              top: 92,
              message: '不执行默认sql时，必须设置自定义脚本！',
              duration: 5
            })
            return
          }

          let cols = _verify.columns.map(col => col.Column.toLowerCase())
          cols = Array.from(new Set(cols))
          let error = ''

          if (_verify.columns.length === 0) {
            notification.warning({
              top: 92,
              message: '请设置Excel列字段!',
              duration: 5
            })
            return
            error = '请设置Excel列字段!'
          } else if (_verify.columns.length > cols.length) {
            notification.warning({
              top: 92,
              message: 'Excel列字段名，不可重复!',
              duration: 5
            })
            return
            error = 'Excel列字段名，不可重复!'
          } else if (cols.includes('bid')) {
            error = 'bid字段为保留字，不可使用!'
          } else if (cols.includes('jskey')) {
            error = 'jskey字段为保留字，不可使用!'
          } else if (_verify.range === 1) {
            let tEmptys = _verify.columns.filter(op => !op.Text)
            if (tEmptys.length > 0) {
              notification.warning({
                top: 92,
                message: '忽略首行时，会使用Text值校验Excel首行内容，Text值与Excel表首行内容相同，且均不可为空！',
                duration: 5
              })
              return
              error = '忽略首行时，会使用Text值校验Excel首行内容，Text值与Excel表首行内容相同，且均不可为空！'
            }
          }

          if (error) {
            notification.warning({
              top: 92,
              message: error,
              duration: 5
            })
            return
          }

          _verify.columns.sort((a, b) => {
@@ -902,19 +911,6 @@
                    </Radio.Group>)}
                  </Form.Item>
                </Col>
                {verify.excelHandle === 'true' ? <Col span={24} style={{paddingLeft: '30px'}}>
                  <Form.Item wrapperCol={ {xs: { span: 24 }, sm: { span: 24 }} } label="">
                    {getFieldDecorator('excel_func', {
                      initialValue: verify.excel_func || '',
                      rules: [
                        {
                          required: true,
                          message: '请填写自定义逻辑!'
                        }
                      ]
                    })(<CodeMirror mode="text/javascript" theme="cobalt" />)}
                  </Form.Item>
                </Col> : null}
                {verify.excelHandle !== 'true' ? <Col span={8}>
                  <Form.Item label={
                    <Tooltip placement="bottomLeft" title="导入时工作表名与excel中必须一致，注：工作表名为Sheet1且excel中仅有一个工作表时不进行表名验证。">
@@ -933,7 +929,7 @@
                    })(<Input placeholder="" autoComplete="off" />)}
                  </Form.Item>
                </Col> : null}
                {verify.excelHandle !== 'true' ? <Col span={8}>
                <Col span={8}>
                  <Form.Item label={
                    <Tooltip placement="bottomLeft" title="忽略首行时，会校验excel中表头名称与excel列设置是否一致。">
                      <QuestionCircleOutlined className="mk-form-tip" />
@@ -944,6 +940,19 @@
                      initialValue: verify.range || 0
                    })(<InputNumber min={0} max={100} precision={0} />)}
                  </Form.Item>
                </Col>
                {verify.excelHandle === 'true' ? <Col span={24} style={{paddingLeft: '30px'}}>
                  <Form.Item wrapperCol={ {xs: { span: 24 }, sm: { span: 24 }} } label="">
                    {getFieldDecorator('excel_func', {
                      initialValue: verify.excel_func || '',
                      rules: [
                        {
                          required: true,
                          message: '请填写自定义逻辑!'
                        }
                      ]
                    })(<CodeMirror mode="text/javascript" theme="cobalt" />)}
                  </Form.Item>
                </Col> : null}
              </Row>
            </Form>