1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<template>
<el-dialog :visible.sync="visible" :title="!dataForm.id ? $t('add') : $t('update')" :close-on-click-modal="false" :close-on-press-escape="false">
<el-form :model="dataForm" :rules="dataRule" ref="dataForm" @keyup.enter.native="dataFormSubmitHandle()" :label-width="$i18n.locale === 'en-US' ? '120px' : '80px'">
<el-form-item label="日志名称" prop="sqlLogName">
<el-input v-model="dataForm.sqlLogName" placeholder="日志名称"></el-input>
</el-form-item>
<el-form-item label="SQL内容" prop="sqlLogContent">
<el-input v-model="dataForm.sqlLogContent" placeholder="SQL内容"></el-input>
</el-form-item>
<el-form-item label="SQL结果" prop="sqlLogResult">
<el-input v-model="dataForm.sqlLogResult" placeholder="SQL结果"></el-input>
</el-form-item>
<el-form-item label="执行IP" prop="sqlLogIp">
<el-input v-model="dataForm.sqlLogIp" placeholder="执行IP"></el-input>
</el-form-item>
<el-form-item label="执行时间" prop="sqlExecuteTime">
<el-input v-model="dataForm.sqlExecuteTime" placeholder="执行时间"></el-input>
</el-form-item>
<el-form-item label="状态" prop="status">
<el-input v-model="dataForm.status" placeholder="状态"></el-input>
</el-form-item>
<el-form-item label="备注" prop="remark">
<el-input v-model="dataForm.remark" placeholder="备注"></el-input>
</el-form-item>
</el-form>
<template slot="footer">
<el-button @click="visible = false">{{ $t('cancel') }}</el-button>
<el-button type="primary" @click="dataFormSubmitHandle()">{{ $t('confirm') }}</el-button>
</template>
</el-dialog>
</template>
<script>
import debounce from 'lodash/debounce'
export default {
data () {
return {
visible: false,
dataForm: {
id: '',
sqlLogName: '',
sqlLogContent: '',
sqlLogResult: '',
sqlLogIp: '',
sqlExecuteTime: '',
status: '',
remark: '',
creator: '',
createDate: ''
}
}
},
computed: {
dataRule () {
return {
sqlLogName: [
{ required: true, message: this.$t('validate.required'), trigger: 'blur' }
],
sqlLogContent: [
{ required: true, message: this.$t('validate.required'), trigger: 'blur' }
],
sqlLogResult: [
{ required: true, message: this.$t('validate.required'), trigger: 'blur' }
],
sqlLogIp: [
{ required: true, message: this.$t('validate.required'), trigger: 'blur' }
],
sqlExecuteTime: [
{ required: true, message: this.$t('validate.required'), trigger: 'blur' }
],
status: [
{ required: true, message: this.$t('validate.required'), trigger: 'blur' }
],
remark: [
{ required: true, message: this.$t('validate.required'), trigger: 'blur' }
],
}
}
},
methods: {
init () {
this.visible = true
this.$nextTick(() => {
this.$refs['dataForm'].resetFields()
if (this.dataForm.id) {
this.getInfo()
}
})
},
// 获取信息
getInfo () {
this.$http.get(`/datasource/syssqllog/${this.dataForm.id}`).then(({ data: res }) => {
if (res.code !== 0) {
return this.$message.error(res.msg)
}
this.dataForm = {
...this.dataForm,
...res.data
}
}).catch(() => {})
},
// 表单提交
dataFormSubmitHandle: debounce(function () {
this.$refs['dataForm'].validate((valid) => {
if (!valid) {
return false
}
this.$http[!this.dataForm.id ? 'post' : 'put']('/datasource/syssqllog/', this.dataForm).then(({ data: res }) => {
if (res.code !== 0) {
return this.$message.error(res.msg)
}
this.$message({
message: this.$t('prompt.success'),
type: 'success',
duration: 500,
onClose: () => {
this.visible = false
this.$emit('refreshDataList')
}
})
}).catch(() => {})
})
}, 1000, { 'leading': true, 'trailing': false })
}
}
</script>