From 58826d6f4eab9f8c9acf9fa8696f60039c645cfe Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 20 八月 2024 18:18:00 +0800
Subject: [PATCH] 2024-08-20
---
src/templates/zshare/verifycard/customform/index.jsx | 136 ++++++++++++++++++++++-----------------------
1 files changed, 67 insertions(+), 69 deletions(-)
diff --git a/src/templates/zshare/verifycard/customform/index.jsx b/src/templates/zshare/verifycard/customform/index.jsx
index 60367db..efca89b 100644
--- a/src/templates/zshare/verifycard/customform/index.jsx
+++ b/src/templates/zshare/verifycard/customform/index.jsx
@@ -1,18 +1,17 @@
import React, {Component} from 'react'
import PropTypes from 'prop-types'
-import { Form, Row, Col, Input, Select, Button, notification, Modal } from 'antd'
-import moment from 'moment'
+import { Form, Row, Col, Input, Select, Button, notification, Modal, Tooltip } from 'antd'
-import Utils from '@/utils/utils.js'
import Api from '@/api'
+import { checkSQL } from '@/utils/utils-custom.js'
import CodeMirror from '@/templates/zshare/codemirror'
-import './index.scss'
+// import './index.scss'
class CustomForm extends Component {
static propTpyes = {
- dict: PropTypes.object, // 瀛楀吀椤�
btn: PropTypes.object, // 鎸夐挳
- usefulfields: PropTypes.string, // 鍙敤瀛楁
+ formfields: PropTypes.string,
+ colfields: PropTypes.string,
initsql: PropTypes.string, // 鍙敤瀛楁
customChange: PropTypes.func // 琛ㄥ崟
}
@@ -35,71 +34,61 @@
})
}
+ handleCancel = () => {
+ this.setState({
+ editItem: null
+ })
+
+ this.props.form.setFieldsValue({
+ sql: ' ',
+ errmsg: ''
+ })
+ }
handleConfirm = () => {
// 琛ㄥ崟鎻愪氦鏃舵鏌ヨ緭鍏ュ�兼槸鍚︽纭�
this.props.form.validateFieldsAndScroll((err, values) => {
if (!err) {
+ if (/^[\s\n]+$/.test(values.sql)) {
+ notification.warning({
+ top: 92,
+ message: '璇疯緭鍏ql!',
+ duration: 5
+ })
+ return
+ }
+
values.uuid = this.state.editItem ? this.state.editItem.uuid : ''
values.resultName = values.result === 'false' ? '涓嶅瓨鍦�' : '瀛樺湪'
- let _quot = values.sql.match(/'{1}/g)
- let _lparen = values.sql.match(/\({1}/g)
- let _rparen = values.sql.match(/\){1}/g)
+ let pass = checkSQL(values.sql, 'customscript')
- _quot = _quot ? _quot.length : 0
- _lparen = _lparen ? _lparen.length : 0
- _rparen = _rparen ? _rparen.length : 0
+ if (!pass) return
- if (_quot % 2 !== 0) {
- notification.warning({
- top: 92,
- message: 'sql涓璡'蹇呴』鎴愬鍑虹幇',
- duration: 5
- })
- return
- } else if (_lparen !== _rparen) {
- notification.warning({
- top: 92,
- message: 'sql涓�()蹇呴』鎴愬鍑虹幇',
- duration: 5
- })
- return
- } else if (/--/ig.test(values.sql)) {
- notification.warning({
- top: 92,
- message: '鑷畾涔塻ql璇彞涓紝涓嶅彲鍑虹幇瀛楃 -- 锛屾敞閲婅鐢� /*鍐呭*/',
- duration: 5
- })
- return
- }
+ let sql = `${this.props.initsql}
+ /* 鑷畾涔夐獙璇� */
+ select @tbid='', @ErrorCode='',@retmsg=''
+ select top 1 @tbid='X' from (${values.sql}) a
+ If @tbid = ''
+ Begin
+ select @ErrorCode='${values.errorCode}',@retmsg='${values.errmsg}'
+ goto aaa
+ end
+ aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
- let error = Utils.verifySql(values.sql)
-
- if (error) {
- notification.warning({
- top: 92,
- message: 'sql涓笉鍙娇鐢�' + error,
- duration: 5
- })
- return
- }
-
- let param = {
- func: 's_debug_sql',
- LText: this.props.initsql + values.sql
- }
-
+ // if (window.GLOB.funcs && window.GLOB.funcs.length > 0) {
+ // window.GLOB.funcs.forEach(item => {
+ // let reg = new RegExp('\\$ex@' + item.func_code + '@ex\\$', 'ig')
+ // sql = sql.replace(reg, `/*$ex@${item.func_code}-begin*/\n${item.key_sql}\n/*@ex$-end*/`)
+ // })
+ // }
+
// 鏁版嵁鏉冮檺
- param.LText = param.LText.replace(/@\$|\$@/ig, '')
-
- param.LText = Utils.formatOptions(param.LText)
- param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
- param.secretkey = Utils.encrypt(param.LText, param.timestamp)
+ sql = sql.replace(/@\$|\$@/ig, '')
this.setState({loading: true})
- Api.getLocalConfig(param).then(res => {
- if (res.status) {
+ Api.sDebug(sql).then(res => {
+ if (res.status || res.ErrCode === '-2') {
this.setState({
loading: false,
editItem: null
@@ -107,7 +96,7 @@
this.props.customChange(values)
})
this.props.form.setFieldsValue({
- sql: '',
+ sql: ' ',
errmsg: ''
})
} else {
@@ -123,7 +112,7 @@
}
render() {
- const { usefulfields, btn } = this.props
+ const { formfields, colfields, btn } = this.props
const { getFieldDecorator } = this.props.form
const formItemLayout = {
labelCol: {
@@ -135,22 +124,27 @@
sm: { span: 16 }
}
}
+
return (
<Form {...formItemLayout} className="verify-form" id="verifycard2">
<Row gutter={24}>
- {usefulfields ? <Col span={21} className="sqlfield">
+ <Col span={21} className="sqlfield">
<Form.Item label={'鍙敤瀛楁'}>
- {usefulfields}
+ <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title={'鍏叡鍊硷紝璇锋寜鐓xxx@鏍煎紡浣跨敤銆�'}><span style={{color: '#1890ff'}}>BID, ID, LoginUID, SessionUid, UserID, Appkey, lang, time_id</span></Tooltip>,
+ <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title={'绯荤粺鍙橀噺锛岀郴缁熶細瀹氫箟鍙橀噺骞惰祴鍊笺��'}><span style={{color: '#fa8c16'}}>UserName, FullName, RoleID, mk_departmentcode, mk_organization, mk_user_type, mk_nation, mk_province, mk_city, mk_district, mk_address, mk_deleted</span></Tooltip>,
+ <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title={'绯荤粺鍙橀噺锛岀郴缁熶細瀹氫箟鍙橀噺骞跺湪鍗曞彿鐢熸垚鎴栧垱寤哄嚟璇佹椂浣跨敤銆�'}><span style={{color: '#13c2c2'}}>BillCode, BVoucher, FIBVoucherDate, FiYear, ModularDetailCode</span></Tooltip>
+ {formfields ? <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title="琛ㄥ崟鍙橀噺锛岀郴缁熶細瀹氫箟鍙橀噺骞惰祴鍊笺��">, <span style={{color: '#8E44AD'}}>{formfields}</span></Tooltip> : ''}
+ {colfields ? <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title="瀛楁闆嗗彉閲忥紝绯荤粺浼氬畾涔夊彉閲忓苟璧嬪�笺��">, {colfields}</Tooltip> : ''}
</Form.Item>
- </Col> : null}
+ </Col>
<Col span={21} className="sql">
- <Form.Item label={'sql'}>
+ <Form.Item label="sql">
{getFieldDecorator('sql', {
initialValue: '',
rules: [
{
required: true,
- message: this.props.dict['form.required.input'] + 'sql!'
+ message: '璇疯緭鍏ql!'
}
]
})(<CodeMirror />)}
@@ -159,6 +153,10 @@
<Col span={3} className="add">
<Button onClick={this.handleConfirm} loading={this.state.loading} className="mk-green">
淇濆瓨
+ </Button>
+ <div></div>
+ <Button onClick={this.handleCancel}>
+ 鍙栨秷
</Button>
{btn.sql ? <div style={{marginTop: '31px'}}>
琛ㄥ悕: <div style={{wordBreak: 'break-all'}}>{btn.sql}</div>
@@ -171,7 +169,7 @@
rules: [
{
required: true,
- message: this.props.dict['form.required.select'] + '缁撴灉澶勭悊!'
+ message: '璇烽�夋嫨缁撴灉澶勭悊!'
}
]
})(
@@ -183,20 +181,20 @@
</Form.Item>
</Col>
<Col span={7}>
- <Form.Item label={'鎻愮ず淇℃伅'}>
+ <Form.Item label="鎻愮ず淇℃伅">
{getFieldDecorator('errmsg', {
initialValue: '',
rules: [
{
required: true,
- message: this.props.dict['form.required.input'] + '鎻愮ず淇℃伅!'
+ message: '璇疯緭鍏ユ彁绀轰俊鎭�!'
},
{
pattern: /^[^']*$/ig,
message: '鎻愮ず淇℃伅涓嶅厑璁稿寘鍚玕''
}
]
- })(<Input placeholder="" autoComplete="off" />)}
+ })(<Input placeholder="" autoComplete="off" onPressEnter={this.handleConfirm}/>)}
</Form.Item>
</Col>
<Col span={7}>
@@ -206,7 +204,7 @@
rules: [
{
required: true,
- message: this.props.dict['form.required.select'] + '鎶ラ敊缂栫爜!'
+ message: '璇烽�夋嫨鎶ラ敊缂栫爜!'
}
]
})(
--
Gitblit v1.8.0