index.vue 9.5 KB

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