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