| 提交 | 用户 | 时间 | ||
| fd2207 | 1 | <template> |
| 懒 | 2 | <div class="app-container"> |
| 3 | <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px"> | |
| 4 | <el-form-item label="表名称" prop="tableName"> | |
| 5 | <el-input | |
| 6 | v-model="queryParams.tableName" | |
| 7 | placeholder="请输入表名称" | |
| 8 | clearable | |
| 9 | @keyup.enter.native="handleQuery" | |
| 10 | /> | |
| 11 | </el-form-item> | |
| 12 | <el-form-item label="表描述" prop="tableComment"> | |
| 13 | <el-input | |
| 14 | v-model="queryParams.tableComment" | |
| 15 | placeholder="请输入表描述" | |
| 16 | clearable | |
| 17 | @keyup.enter.native="handleQuery" | |
| 18 | /> | |
| 19 | </el-form-item> | |
| 20 | <el-form-item label="创建时间"> | |
| 21 | <el-date-picker | |
| 22 | v-model="dateRange" | |
| 23 | style="width: 240px" | |
| 24 | value-format="yyyy-MM-dd" | |
| 25 | type="daterange" | |
| 26 | range-separator="-" | |
| 27 | start-placeholder="开始日期" | |
| 28 | end-placeholder="结束日期" | |
| 29 | ></el-date-picker> | |
| 30 | </el-form-item> | |
| 31 | <el-form-item> | |
| 32 | <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button> | |
| 33 | <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button> | |
| 34 | </el-form-item> | |
| 35 | </el-form> | |
| 36 | ||
| 37 | <el-row :gutter="10" class="mb8"> | |
| 38 | <el-col :span="1.5"> | |
| 39 | <el-button | |
| 40 | type="primary" | |
| 41 | plain | |
| 42 | icon="el-icon-download" | |
| 43 | size="mini" | |
| 44 | @click="handleGenTable" | |
| 45 | v-hasPermi="['tool:gen:code']" | |
| 46 | >生成</el-button> | |
| 47 | </el-col> | |
| 48 | <el-col :span="1.5"> | |
| 49 | <el-button | |
| 50 | type="info" | |
| 51 | plain | |
| 52 | icon="el-icon-upload" | |
| 53 | size="mini" | |
| 54 | @click="openImportTable" | |
| 55 | v-hasPermi="['tool:gen:import']" | |
| 56 | >导入</el-button> | |
| 57 | </el-col> | |
| 58 | <el-col :span="1.5"> | |
| 59 | <el-button | |
| 60 | type="success" | |
| 61 | plain | |
| 62 | icon="el-icon-edit" | |
| 63 | size="mini" | |
| 64 | :disabled="single" | |
| 65 | @click="handleEditTable" | |
| 66 | v-hasPermi="['tool:gen:edit']" | |
| 67 | >修改</el-button> | |
| 68 | </el-col> | |
| 69 | <el-col :span="1.5"> | |
| 70 | <el-button | |
| 71 | type="danger" | |
| 72 | plain | |
| 73 | icon="el-icon-delete" | |
| 74 | size="mini" | |
| 75 | :disabled="multiple" | |
| 76 | @click="handleDelete" | |
| 77 | v-hasPermi="['tool:gen:remove']" | |
| 78 | >删除</el-button> | |
| 79 | </el-col> | |
| 80 | <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar> | |
| 81 | </el-row> | |
| 82 | ||
| 83 | <el-table v-loading="loading" :data="tableList" @selection-change="handleSelectionChange"> | |
| 84 | <el-table-column type="selection" align="center" width="55"></el-table-column> | |
| 85 | <el-table-column label="序号" type="index" width="50" align="center"> | |
| 86 | <template slot-scope="scope"> | |
| 87 | <span>{{(queryParams.pageNum - 1) * queryParams.pageSize + scope.$index + 1}}</span> | |
| 88 | </template> | |
| 89 | </el-table-column> | |
| 90 | <el-table-column | |
| 91 | label="表名称" | |
| 92 | align="center" | |
| 93 | prop="tableName" | |
| 94 | :show-overflow-tooltip="true" | |
| 95 | width="120" | |
| 96 | /> | |
| 97 | <el-table-column | |
| 98 | label="表描述" | |
| 99 | align="center" | |
| 100 | prop="tableComment" | |
| 101 | :show-overflow-tooltip="true" | |
| 102 | width="120" | |
| 103 | /> | |
| 104 | <el-table-column | |
| 105 | label="实体" | |
| 106 | align="center" | |
| 107 | prop="className" | |
| 108 | :show-overflow-tooltip="true" | |
| 109 | width="120" | |
| 110 | /> | |
| 111 | <el-table-column label="创建时间" align="center" prop="createTime" width="160" /> | |
| 112 | <el-table-column label="更新时间" align="center" prop="updateTime" width="160" /> | |
| 113 | <el-table-column label="操作" align="center" class-name="small-padding fixed-width"> | |
| 114 | <template slot-scope="scope"> | |
| 115 | <el-button | |
| 116 | type="text" | |
| 117 | size="small" | |
| 118 | icon="el-icon-view" | |
| 119 | @click="handlePreview(scope.row)" | |
| 120 | v-hasPermi="['tool:gen:preview']" | |
| 121 | >预览</el-button> | |
| 122 | <el-button | |
| 123 | type="text" | |
| 124 | size="small" | |
| 125 | icon="el-icon-edit" | |
| 126 | @click="handleEditTable(scope.row)" | |
| 127 | v-hasPermi="['tool:gen:edit']" | |
| 128 | >编辑</el-button> | |
| 129 | <el-button | |
| 130 | type="text" | |
| 131 | size="small" | |
| 132 | icon="el-icon-delete" | |
| 133 | @click="handleDelete(scope.row)" | |
| 134 | v-hasPermi="['tool:gen:remove']" | |
| 135 | >删除</el-button> | |
| 136 | <el-button | |
| 137 | type="text" | |
| 138 | size="small" | |
| 139 | icon="el-icon-refresh" | |
| 140 | @click="handleSynchDb(scope.row)" | |
| 141 | v-hasPermi="['tool:gen:edit']" | |
| 142 | >同步</el-button> | |
| 143 | <el-button | |
| 144 | type="text" | |
| 145 | size="small" | |
| 146 | icon="el-icon-download" | |
| 147 | @click="handleGenTable(scope.row)" | |
| 148 | v-hasPermi="['tool:gen:code']" | |
| 149 | >生成代码</el-button> | |
| 150 | </template> | |
| 151 | </el-table-column> | |
| 152 | </el-table> | |
| 153 | <pagination | |
| 154 | v-show="total>0" | |
| 155 | :total="total" | |
| 156 | :page.sync="queryParams.pageNum" | |
| 157 | :limit.sync="queryParams.pageSize" | |
| 158 | @pagination="getList" | |
| 159 | /> | |
| 160 | <!-- 预览界面 --> | |
| 161 | <el-dialog :title="preview.title" :visible.sync="preview.open" width="80%" top="5vh" append-to-body class="scrollbar"> | |
| 162 | <el-tabs v-model="preview.activeName"> | |
| 163 | <el-tab-pane | |
| 164 | v-for="(value, key) in preview.data" | |
| 165 | :label="key.substring(key.lastIndexOf('/')+1,key.indexOf('.vm'))" | |
| 166 | :name="key.substring(key.lastIndexOf('/')+1,key.indexOf('.vm'))" | |
| 167 | :key="key" | |
| 168 | > | |
| 169 | <el-link :underline="false" icon="el-icon-document-copy" v-clipboard:copy="value" v-clipboard:success="clipboardSuccess" style="float:right">复制</el-link> | |
| 170 | <pre><code class="hljs" v-html="highlightedCode(value, key)"></code></pre> | |
| 171 | </el-tab-pane> | |
| 172 | </el-tabs> | |
| 173 | </el-dialog> | |
| 174 | <import-table ref="import" @ok="handleQuery" /> | |
| 175 | </div> | |
| 176 | </template> | |
| 177 | ||
| 178 | <script> | |
| 179 | import { listTable, previewTable, delTable, genCode, synchDb } from "@/api/tool/gen"; | |
| 180 | import importTable from "./importTable"; | |
| 181 | import hljs from "highlight.js/lib/highlight"; | |
| 182 | import "highlight.js/styles/github-gist.css"; | |
| 183 | hljs.registerLanguage("java", require("highlight.js/lib/languages/java")); | |
| 184 | hljs.registerLanguage("xml", require("highlight.js/lib/languages/xml")); | |
| 185 | hljs.registerLanguage("html", require("highlight.js/lib/languages/xml")); | |
| 186 | hljs.registerLanguage("vue", require("highlight.js/lib/languages/xml")); | |
| 187 | hljs.registerLanguage("javascript", require("highlight.js/lib/languages/javascript")); | |
| 188 | hljs.registerLanguage("sql", require("highlight.js/lib/languages/sql")); | |
| 189 | ||
| 190 | export default { | |
| 191 | name: "Gen", | |
| 192 | components: { importTable }, | |
| 193 | data() { | |
| 194 | return { | |
| 195 | // 遮罩层 | |
| 196 | loading: true, | |
| 197 | // 唯一标识符 | |
| 198 | uniqueId: "", | |
| 199 | // 选中数组 | |
| 200 | ids: [], | |
| 201 | // 选中表数组 | |
| 202 | tableNames: [], | |
| 203 | // 非单个禁用 | |
| 204 | single: true, | |
| 205 | // 非多个禁用 | |
| 206 | multiple: true, | |
| 207 | // 显示搜索条件 | |
| 208 | showSearch: true, | |
| 209 | // 总条数 | |
| 210 | total: 0, | |
| 211 | // 表数据 | |
| 212 | tableList: [], | |
| 213 | // 日期范围 | |
| 214 | dateRange: "", | |
| 215 | // 查询参数 | |
| 216 | queryParams: { | |
| 217 | pageNum: 1, | |
| 218 | pageSize: 10, | |
| 219 | tableName: undefined, | |
| 220 | tableComment: undefined | |
| 221 | }, | |
| 222 | // 预览参数 | |
| 223 | preview: { | |
| 224 | open: false, | |
| 225 | title: "代码预览", | |
| 226 | data: {}, | |
| 227 | activeName: "domain.java" | |
| 228 | } | |
| 229 | }; | |
| 230 | }, | |
| 231 | created() { | |
| 232 | this.getList(); | |
| 233 | }, | |
| 234 | activated() { | |
| 235 | const time = this.$route.query.t; | |
| 236 | if (time != null && time != this.uniqueId) { | |
| 237 | this.uniqueId = time; | |
| 238 | this.queryParams.pageNum = Number(this.$route.query.pageNum); | |
| 239 | this.getList(); | |
| 240 | } | |
| 241 | }, | |
| 242 | methods: { | |
| 243 | /** 查询表集合 */ | |
| 244 | getList() { | |
| 245 | this.loading = true; | |
| 246 | listTable(this.addDateRange(this.queryParams, this.dateRange)).then(response => { | |
| 247 | this.tableList = response.rows; | |
| 248 | this.total = response.total; | |
| 249 | this.loading = false; | |
| 250 | } | |
| 251 | ); | |
| 252 | }, | |
| 253 | /** 搜索按钮操作 */ | |
| 254 | handleQuery() { | |
| 255 | this.queryParams.pageNum = 1; | |
| 256 | this.getList(); | |
| 257 | }, | |
| 258 | /** 生成代码操作 */ | |
| 259 | handleGenTable(row) { | |
| 260 | const tableNames = row.tableName || this.tableNames; | |
| 261 | if (tableNames == "") { | |
| 262 | this.$modal.msgError("请选择要生成的数据"); | |
| 263 | return; | |
| 264 | } | |
| 265 | if(row.genType === "1") { | |
| 266 | genCode(row.tableName).then(response => { | |
| 267 | this.$modal.msgSuccess("成功生成到自定义路径：" + row.genPath); | |
| 268 | }); | |
| 269 | } else { | |
| 270 | this.$download.zip("/tool/gen/batchGenCode?tables=" + tableNames, "JCDM.zip"); | |
| 271 | } | |
| 272 | }, | |
| 273 | /** 同步数据库操作 */ | |
| 274 | handleSynchDb(row) { | |
| 275 | const tableName = row.tableName; | |
| 276 | this.$modal.confirm('确认要强制同步"' + tableName + '"表结构吗？').then(function() { | |
| 277 | return synchDb(tableName); | |
| 278 | }).then(() => { | |
| 279 | this.$modal.msgSuccess("同步成功"); | |
| 280 | }).catch(() => {}); | |
| 281 | }, | |
| 282 | /** 打开导入表弹窗 */ | |
| 283 | openImportTable() { | |
| 284 | this.$refs.import.show(); | |
| 285 | }, | |
| 286 | /** 重置按钮操作 */ | |
| 287 | resetQuery() { | |
| 288 | this.dateRange = []; | |
| 289 | this.resetForm("queryForm"); | |
| 290 | this.handleQuery(); | |
| 291 | }, | |
| 292 | /** 预览按钮 */ | |
| 293 | handlePreview(row) { | |
| 294 | previewTable(row.tableId).then(response => { | |
| 295 | this.preview.data = response.data; | |
| 296 | this.preview.open = true; | |
| 297 | this.preview.activeName = "domain.java"; | |
| 298 | }); | |
| 299 | }, | |
| 300 | /** 高亮显示 */ | |
| 301 | highlightedCode(code, key) { | |
| 302 | const vmName = key.substring(key.lastIndexOf("/") + 1, key.indexOf(".vm")); | |
| 303 | var language = vmName.substring(vmName.indexOf(".") + 1, vmName.length); | |
| 304 | const result = hljs.highlight(language, code || "", true); | |
| 305 | return result.value || ' '; | |
| 306 | }, | |
| 307 | /** 复制代码成功 */ | |
| 308 | clipboardSuccess() { | |
| 309 | this.$modal.msgSuccess("复制成功"); | |
| 310 | }, | |
| 311 | // 多选框选中数据 | |
| 312 | handleSelectionChange(selection) { | |
| 313 | this.ids = selection.map(item => item.tableId); | |
| 314 | this.tableNames = selection.map(item => item.tableName); | |
| 315 | this.single = selection.length != 1; | |
| 316 | this.multiple = !selection.length; | |
| 317 | }, | |
| 318 | /** 修改按钮操作 */ | |
| 319 | handleEditTable(row) { | |
| 320 | const tableId = row.tableId || this.ids[0]; | |
| 321 | const tableName = row.tableName || this.tableNames[0]; | |
| 322 | const params = { pageNum: this.queryParams.pageNum }; | |
| 323 | this.$tab.openPage("修改[" + tableName + "]生成配置", '/tool/gen-edit/index/' + tableId, params); | |
| 324 | }, | |
| 325 | /** 删除按钮操作 */ | |
| 326 | handleDelete(row) { | |
| 327 | const tableIds = row.tableId || this.ids; | |
| 328 | this.$modal.confirm('是否确认删除表编号为"' + tableIds + '"的数据项？').then(function() { | |
| 329 | return delTable(tableIds); | |
| 330 | }).then(() => { | |
| 331 | this.getList(); | |
| 332 | this.$modal.msgSuccess("删除成功"); | |
| 333 | }).catch(() => {}); | |
| 334 | } | |
| 335 | } | |
| 336 | }; | |
| 337 | </script> | |
