From 876a5e6657d67df66bb525d02dd6d147ba81cae5 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期四, 05 一月 2023 09:53:37 +0800 Subject: [PATCH] 2023-01-05 --- src/views/systemproc/proc/index.jsx | 363 +++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 349 insertions(+), 14 deletions(-) diff --git a/src/views/systemproc/proc/index.jsx b/src/views/systemproc/proc/index.jsx index 56bc51f..6f13864 100644 --- a/src/views/systemproc/proc/index.jsx +++ b/src/views/systemproc/proc/index.jsx @@ -1,5 +1,6 @@ import React, {Component} from 'react' -import { Input, notification } from 'antd' +import { Input, notification, Button, Form, Modal, Empty } from 'antd' +import { MenuUnfoldOutlined, MenuFoldOutlined } from '@ant-design/icons' import moment from 'moment' import Utils from '@/utils/utils.js' @@ -7,17 +8,52 @@ import CodeMirror from '@/templates/zshare/codemirror' import './index.scss' +const { confirm } = Modal const { Search } = Input class ProcControl extends Component { state = { procName: '', - content: null, - loading: false + content: '', + loading: false, + visible: false, + searchable: false, + inputing: false, + procList: [], + permFuncs: [] } componentDidMount () { + if (sessionStorage.getItem('permFuncField')) { + this.setState({permFuncs: JSON.parse(sessionStorage.getItem('permFuncField'))}) + } else { + Api.getCloudConfig({func: 'sPC_Get_Roles_sModular'}).then(res => { + if (res.status) { + let _permFuncs = [] + + if (res.sModular && res.sModular.length > 0) { + res.sModular.forEach(field => { + if (field.ModularNo) { + _permFuncs.push(field.ModularNo) + } + }) + _permFuncs = _permFuncs.sort() + } + + if (_permFuncs.length) { + this.setState({permFuncs: _permFuncs}) + sessionStorage.setItem('permFuncField', JSON.stringify(_permFuncs)) + } + } else { + notification.warning({ + top: 92, + message: res.message, + duration: 5 + }) + } + }) + } } search = (value) => { @@ -47,31 +83,330 @@ }) this.setState({content: '', procName: '', loading: false}) return + } else if (!res.Ltext) { + this.setState({content: '', procName: '', loading: false}) + } else { + this.setState({content: res.Ltext.replace(/mchr13k/ig, '\n'), procName: proc, loading: false}) + } + }) + } + + save = (type) => { + const { content, procName, permFuncs } = this.state + let value = content.replace(/^(\s*)|(\s*)$/ig, '') + + if (!value) { + notification.warning({ + top: 92, + message: '瀛樺偍杩囩▼涓嶅彲涓虹┖', + duration: 5 + }) + return + } else { + let chars = [ + {key: 'drop', reg: /(^|\s)drop\s/ig}, + {key: 'alter', reg: /(^|\s)alter\s/ig}, + {key: 'object', reg: /(^|\s)object(\s|\()/ig}, + {key: 'kill', reg: /(^|\s)kill\s/ig}, + {key: '--', reg: /--/ig} + ] + + let error = '' + + if (!/create(\s+)proc/ig.test(value)) { + error = '鑴氭湰涓繀椤讳娇鐢╟reate proc' + } + + chars.forEach(char => { + if (!error && char.reg.test(value)) { + error = '涓嶅彲浣跨敤' + char.key + } + }) + + if (error) { + notification.warning({ + top: 92, + message: error, + duration: 5 + }) + return + } + } + + if (!procName) { + if (permFuncs.length > 0) { + this.setState({visible: true}) + } else { + notification.warning({ + top: 92, + message: '鏈幏鍙栧埌鎺堟潈缂栫爜涓嶅彲鏂板缓锛�', + duration: 5 + }) + } + return + } + + let dropfunc = `IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('${procName}') AND type in (N'P', N'PC')) mdrpk PROCEDURE ${procName}` + let createfunc = value.replace(/\n/ig, 'mchr13k') + + let dropParam = { + func: 'sPC_TableData_InUpDe', + LText: Utils.formatOptions(dropfunc), + TypeCharOne: 'proc' // 鍒犻櫎瀛樺偍杩囩▼ + } + + dropParam.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + dropParam.secretkey = Utils.encrypt(dropParam.LText, dropParam.timestamp) + dropParam.open_key = Utils.encryptOpenKey(dropParam.secretkey, dropParam.timestamp) + + + let createParam = { + func: 'sPC_TableData_InUpDe', + LText: Utils.formatOptions(createfunc), + TypeCharOne: 'proc' // 鍒涘缓瀛樺偍杩囩▼ + } + + createParam.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + createParam.secretkey = Utils.encrypt(createParam.LText, createParam.timestamp) + createParam.open_key = Utils.encryptOpenKey(createParam.secretkey, createParam.timestamp) + + let saveParam = { + func: 's_proc_save', + sql_script: window.btoa(window.encodeURIComponent(createfunc)), + proc_name: procName, + save_type: type !== 'prev' ? 'auto' : '' // 'auto' 鏃� 浼氭竻y鐨勬暟鎹� + } + + this.setState({loading: true}) + + Api.genericInterface(dropParam).then(res => { + if (!res.status) { + notification.warning({ + top: 92, + message: res.message, + duration: 5 + }) + this.setState({loading: false}) + return } - this.setState({content: res.Ltext.replace(/mchr13k/ig, '\n'), procName: proc, loading: false}) + Api.genericInterface(createParam).then(result => { + if (!result.status) { + notification.warning({ + top: 92, + message: result.message, + duration: 5 + }) + this.setState({loading: false}) + return + } + + Api.genericInterface(saveParam).then(response => { + this.setState({loading: false}) + if (!response.status) { + notification.warning({ + top: 92, + message: response.message, + duration: 5 + }) + } else { + notification.success({ + top: 92, + message: '淇濆瓨鎴愬姛銆�', + duration: 5 + }) + } + }) + }) + }) + } + + prev = () => { + const { procName } = this.state + const that = this + + let saveParam = { + func: 's_proc_ctrl_z', + proc_name: procName + } + + confirm({ + title: '纭畾鍒囨崲涓婁竴鐗堟湰鍚楋紵', + content: '', + onOk() { + that.setState({loading: true}) + + Api.genericInterface(saveParam).then(res => { + that.setState({loading: false}) + if (!res.status || !res.Ltext) { + notification.warning({ + top: 92, + message: !res.status ? res.message : '娌℃湁鍙互鍚庨��鐨勭増鏈�', + duration: 5 + }) + return + } + + let value = window.decodeURIComponent(window.atob(res.Ltext)) + value = value.replace(/mchr13k/ig, '\n') + + that.setState({content: value}, () => { + that.save('prev') + }) + }) + }, + onCancel() {} + }) + } + + next = () => { + const { procName } = this.state + const that = this + + let saveParam = { + func: 's_proc_ctrl_y', + proc_name: procName + } + + confirm({ + title: '纭畾鍒囨崲涓嬩竴鐗堟湰鍚楋紵', + content: '', + onOk() { + that.setState({loading: true}) + + Api.genericInterface(saveParam).then(res => { + that.setState({loading: false}) + if (!res.status || !res.Ltext) { + notification.warning({ + top: 92, + message: !res.status ? res.message : '娌℃湁鍙互鎾ら攢鍚庨��鐨勭増鏈�', + duration: 5 + }) + return + } + + let value = window.decodeURIComponent(window.atob(res.Ltext)) + value = value.replace(/mchr13k/ig, '\n') + + that.setState({content: value}, () => { + that.save() + }) + }) + }, + onCancel() {} + }) + } + + handleConfirm = () => { + this.props.form.validateFieldsAndScroll((err, values) => { + if (err) return + + this.setState({procName: values.name}, () => { + this.save() + }) + }) + } + + searchAll = (value) => { + let param = { + func: 's_proc_search', + proc_name: value || '' + } + + this.setState({loading: true}) + + Api.genericInterface(param).then(res => { + this.setState({loading: false}) + if (!res.status) { + notification.warning({ + top: 92, + message: res.message, + duration: 5 + }) + return + } + + this.setState({procList: res.data || []}) + }) + } + + changeProc = (name) => { + const { loading } = this.state + + if (loading) { + notification.warning({ + top: 92, + message: '鏌ヨ涓绋嶅悗銆�', + duration: 5 + }) + return + } + + this.setState({inputing: true, procName: name}, () => { + this.setState({inputing: false}) + this.search(name) }) } render () { - const { loading, content } = this.state + const { getFieldDecorator } = this.props.form + const { loading, content, procName, visible, permFuncs, searchable, procList, inputing } = this.state + + let _patten = permFuncs.length ? new RegExp('^(' + permFuncs.join('|') + ')[0-9a-zA-Z_]*$', 'g') : '' return ( <div className="mk-proc-wrap"> - <div className="control-wrap"> - <div className="search-wrap"> - <Search placeholder="璇疯緭鍏ュ瓨鍌ㄨ繃绋嬪悕绉�" disabled={loading} enterButton="纭畾" onSearch={this.search}/> - </div> - <div className="action-wrap"> - + <div className={'searh-list' + (searchable ? ' open' : '')}> + <Search placeholder="瀛樺偍杩囩▼鍚嶇О鏌ヨ" disabled={loading} onSearch={this.searchAll}/> + <div className="proc-list"> + {procList.map((item, index) => (<div className="proc-item" onClick={() => this.changeProc(item.proc_name)} key={index}>{item.proc_name}</div>))} + {procList.length === 0 ? <Empty /> : null} </div> </div> - <div className="edit-wrap"> - <CodeMirror value={content} onChange={(val) => this.setState({content: val})}/> + <div className="proc-wrap"> + <div className="control-wrap"> + <div className="search-wrap"> + {searchable ? <MenuUnfoldOutlined onClick={() => this.setState({searchable: !searchable})}/> : <MenuFoldOutlined onClick={() => this.setState({searchable: !searchable})}/>} + {!inputing ? <Search placeholder="璇疯緭鍏ュ瓨鍌ㄨ繃绋嬪悕绉�" defaultValue={procName} disabled={loading} enterButton="纭畾" onSearch={this.search}/> : null} + </div> + <div className="action-wrap"> + <Button key="save" className="mk-btn mk-green" disabled={loading} onClick={() => this.save()}>淇濆瓨</Button> + <Button key="prev" className="mk-btn mk-primary" disabled={!procName || loading} onClick={this.prev}>涓婁竴鐗堟湰</Button> + <Button key="next" className="mk-btn mk-primary" disabled={!procName || loading} onClick={this.next}>涓嬩竴鐗堟湰</Button> + </div> + </div> + <div className="edit-wrap"> + <CodeMirror value={content} onChange={(val) => this.setState({content: val})}/> + </div> </div> + <Modal + title="鏂板缓" + wrapClassName="mk-create-func" + visible={visible} + onOk={this.handleConfirm} + width={540} + onCancel={() => {this.setState({ visible: false })}} + destroyOnClose + > + <Form.Item label="瀛樺偍杩囩▼鍚嶇О"> + {getFieldDecorator('name', { + initialValue: '', + rules: [ + { + required: true, + message: '璇疯緭鍏ュ瓨鍌ㄨ繃绋嬪悕绉�!' + }, + { + pattern: _patten, + message: `鍙厑璁稿寘鍚暟瀛椼�佸瓧姣嶅拰涓嬪垝绾匡紝涓斾互${permFuncs.join(', ')}绛夊瓧绗﹀紑濮嬨�俙 + } + ] + })(<Input placeholder="" autoComplete="off" />)} + </Form.Item> + </Modal> </div> ) } } -export default ProcControl \ No newline at end of file +export default Form.create()(ProcControl) \ No newline at end of file -- Gitblit v1.8.0