index.vue
8.15 KB
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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
<template>
<div class="NCC-common-layout">
<div class="NCC-common-layout-center">
<el-row class="NCC-common-search-box" :gutter="16">
<el-form @submit.native.prevent>
<el-col :span="6">
<el-form-item label="数据库">
<el-select v-model="dataBase" placeholder="请选择数据库">
<el-option-group v-for="group in dbOptions" :key="group.fullName"
:label="group.fullName">
<el-option v-for="item in group.children" :key="item.id" :label="item.fullName"
:value="item.id" />
</el-option-group>
</el-select>
</el-form-item>
</el-col>
<el-col :span="6">
<el-form-item label="关键词">
<el-input v-model="keyword" placeholder="请输入关键词查询" clearable
@keyup.enter.native="search()" />
</el-form-item>
</el-col>
<el-col :span="6">
<el-form-item>
<el-button type="primary" icon="el-icon-search" @click="search()">
{{$t('common.search')}}</el-button>
<el-button icon="el-icon-refresh-right" @click="reset()">{{$t('common.reset')}}
</el-button>
</el-form-item>
</el-col>
</el-form>
</el-row>
<div class="NCC-common-layout-main NCC-flex-main">
<div class="NCC-common-head">
<topOpts @add="addOrUpdateHandle()" addText="新建表名">
<upload-btn :url="'/api/system/DataModel/'+dataBase+'/Action/Import'"
@on-success="getTabelData" />
<el-button type="text" icon="el-icon-menu" @click="handleFieldsManage()">常用字段
</el-button>
</topOpts>
<div class="NCC-common-head-right">
<el-tooltip effect="dark" :content="$t('common.refresh')" placement="top">
<el-link icon="icon-ym icon-ym-Refresh NCC-common-head-icon" :underline="false"
@click="reset()" />
</el-tooltip>
<screenfull />
</div>
</div>
<NCC-table v-loading="listLoading" :data="list" @expand-change="expandChange"
:hasNO="false">
<el-table-column type="expand" width="40">
<template slot-scope="props">
<el-table v-loading="props.row.childTableLoading" :data="props.row.childTable" stripe
size='mini' :element-loading-text="$t('common.loadingText')">
<el-table-column prop="field" label="字段" />
<el-table-column prop="fieldName" label="说明" />
<el-table-column prop="dataType" label="类型" />
<el-table-column prop="dataLength" label="长度" />
<el-table-column prop="allowNull" label="允许空">
<template slot-scope="scope">
<el-checkbox :value='!!scope.row.allowNull' />
</template>
</el-table-column>
<el-table-column prop="defaults" label="默认值" />
</el-table>
</template>
</el-table-column>
<el-table-column type="index" width="50" label="序号" align="center" />
<el-table-column prop="table" label="表名" sortable />
<el-table-column prop="sum" label="总数" width="150" sortable />
<el-table-column prop="tableName" label="说明" width="200" sortable />
<el-table-column label="操作" width="160" fixed="right">
<template slot-scope="scope">
<tableOpts @edit="addOrUpdateHandle(scope.row.table)"
@del="handleDel(scope.$index,scope.row.table)">
<el-dropdown hide-on-click>
<span class="el-dropdown-link">
<el-button size="mini" type="text">
{{$t('common.moreBtn')}}<i class="el-icon-arrow-down el-icon--right"></i>
</el-button>
</span>
<el-dropdown-menu slot="dropdown">
<el-dropdown-item @click.native="openData(scope.row.table)">
打开数据
</el-dropdown-item>
<el-dropdown-item @click.native="exportTpl(scope.row.table)">
导出
</el-dropdown-item>
</el-dropdown-menu>
</el-dropdown>
</tableOpts>
</template>
</el-table-column>
</NCC-table>
</div>
</div>
<Form v-show="formVisible" ref="Form" @close="colseForm" />
<Preview v-show="showData" ref="preview" @close="closeData" />
<FieldsList v-if="drawer" ref="fieldsList" />
</div>
</template>
<script>
import { getDataSourceListAll } from '@/api/systemData/dataSource'
import { DataModelList, DataModelDelete, DataModelFieldList, exportTpl } from '@/api/systemData/dataModel'
import Form from './Form'
import Preview from './Preview'
import FieldsList from './fields/index'
export default {
name: 'systemData-dataModel',
components: { Form, Preview, FieldsList },
data() {
return {
keyword: '',
list: [],
formVisible: false,
dataBase: '0',
dbOptions: [],
listLoading: false,
childTableLoading: false,
showData: false,
drawer: false
}
},
created() {
this.initData()
},
methods: {
search() {
this.getTabelData()
},
reset() {
this.keyword = ''
this.getTabelData()
},
initData() {
this.listLoading = true
getDataSourceListAll().then(res => {
const defaultItem = {
fullName: '',
children: [{
fullName: '默认数据库',
id: '0'
}]
}
const list = [defaultItem, ...res.data.list]
this.dbOptions = list.filter(o => o.children && o.children.length)
this.getTabelData()
})
},
getTabelData() {
this.listLoading = true
DataModelList(this.dataBase, { keyword: this.keyword }).then(res => {
this.list = res.data.list
for (let i = 0; i < this.list.length; i++) {
this.$set(this.list[i], 'isExpanded', false)
this.$set(this.list[i], 'childTableLoading', false)
this.$set(this.list[i], 'childTable', [])
}
this.listLoading = false
})
},
handleDel(index, tableName) {
this.$confirm('您确定要删除这些数据吗, 是否继续?', '提示', {
type: 'warning'
}).then(() => {
this.asyncDel(index, tableName);
}).catch(() => { });
},
asyncDel(index, tableName) {
DataModelDelete(this.dataBase, tableName).then(res => {
this.list.splice(index, 1);
this.$message({
type: 'success',
message: res.msg
});
})
},
exportTpl(id) {
this.$confirm('您确定要导出该表, 是否继续?', '提示', {
type: 'warning'
}).then(() => {
exportTpl(this.dataBase, id).then(res => {
if (res.data.url) window.location.href = this.define.comUrl + res.data.url
})
}).catch(() => { });
},
// 新增 / 修改
addOrUpdateHandle(id) {
this.formVisible = true
this.$nextTick(() => {
this.$refs.Form.init(this.dataBase, id)
})
},
expandChange(rows) {
rows.isExpanded = !rows.isExpanded
if (!rows.isExpanded) return
if (rows.childTable.length) return
rows.childTableLoading = true
DataModelFieldList(this.dataBase, rows.table).then(res => {
rows.childTableLoading = false
rows.childTable = res.data.list
}).catch(() => {
rows.childTableLoading = false
})
},
closeData() {
this.showData = false
},
colseForm(isRefresh) {
this.formVisible = false
if (isRefresh) {
this.keyword = ''
this.getTabelData()
}
},
openData(table) {
this.showData = true
this.$nextTick(() => {
this.$refs.preview.init(this.dataBase, table)
})
},
handleFieldsManage() {
this.drawer = true
this.$nextTick(() => {
this.$refs.fieldsList.init()
})
},
}
}
</script>