From fe631515b71782a10a750874f6d4582fe027cd22 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期一, 03 十一月 2025 09:32:49 +0800
Subject: [PATCH] 公司-所有的表格添加斑马纹
---
src/views/tool/gen/index.vue | 243 ++++++++++++++++++++++++++++++++++++++----------
1 files changed, 191 insertions(+), 52 deletions(-)
diff --git a/src/views/tool/gen/index.vue b/src/views/tool/gen/index.vue
index 77e8a80..4930cef 100644
--- a/src/views/tool/gen/index.vue
+++ b/src/views/tool/gen/index.vue
@@ -1,6 +1,11 @@
<template>
<div class="app-container">
- <el-form :model="queryParams" ref="queryRef" :inline="true" v-show="showSearch">
+ <el-form
+ :model="queryParams"
+ ref="queryRef"
+ :inline="true"
+ v-show="showSearch"
+ >
<el-form-item label="琛ㄥ悕绉�" prop="tableName">
<el-input
v-model="queryParams.tableName"
@@ -30,7 +35,9 @@
></el-date-picker>
</el-form-item>
<el-form-item>
- <el-button type="primary" icon="Search" @click="handleQuery">鎼滅储</el-button>
+ <el-button type="primary" icon="Search" @click="handleQuery"
+ >鎼滅储</el-button
+ >
<el-button icon="Refresh" @click="resetQuery">閲嶇疆</el-button>
</el-form-item>
</el-form>
@@ -44,7 +51,8 @@
:disabled="multiple"
@click="handleGenTable"
v-hasPermi="['tool:gen:code']"
- >鐢熸垚</el-button>
+ >鐢熸垚</el-button
+ >
</el-col>
<el-col :span="1.5">
<el-button
@@ -53,7 +61,8 @@
icon="Plus"
@click="openCreateTable"
v-hasRole="['admin']"
- >鍒涘缓</el-button>
+ >鍒涘缓</el-button
+ >
</el-col>
<el-col :span="1.5">
<el-button
@@ -62,7 +71,8 @@
icon="Upload"
@click="openImportTable"
v-hasPermi="['tool:gen:import']"
- >瀵煎叆</el-button>
+ >瀵煎叆</el-button
+ >
</el-col>
<el-col :span="1.5">
<el-button
@@ -72,7 +82,8 @@
:disabled="single"
@click="handleEditTable"
v-hasPermi="['tool:gen:edit']"
- >淇敼</el-button>
+ >淇敼</el-button
+ >
</el-col>
<el-col :span="1.5">
<el-button
@@ -82,16 +93,34 @@
:disabled="multiple"
@click="handleDelete"
v-hasPermi="['tool:gen:remove']"
- >鍒犻櫎</el-button>
+ >鍒犻櫎</el-button
+ >
</el-col>
- <right-toolbar v-model:showSearch="showSearch" @queryTable="getList"></right-toolbar>
+ <right-toolbar
+ v-model:showSearch="showSearch"
+ @queryTable="getList"
+ ></right-toolbar>
</el-row>
- <el-table v-loading="loading" :data="tableList" @selection-change="handleSelectionChange">
- <el-table-column type="selection" align="center" width="55"></el-table-column>
+ <el-table
+ ref="genRef"
+ v-loading="loading"
+ :data="tableList"
+ stripe
+ @selection-change="handleSelectionChange"
+ :default-sort="defaultSort"
+ @sort-change="handleSortChange"
+ >
+ <el-table-column
+ type="selection"
+ align="center"
+ width="55"
+ ></el-table-column>
<el-table-column label="搴忓彿" type="index" width="50" align="center">
<template #default="scope">
- <span>{{(queryParams.pageNum - 1) * queryParams.pageSize + scope.$index + 1}}</span>
+ <span>{{
+ (queryParams.pageNum - 1) * queryParams.pageSize + scope.$index + 1
+ }}</span>
</template>
</el-table-column>
<el-table-column
@@ -112,45 +141,108 @@
prop="className"
:show-overflow-tooltip="true"
/>
- <el-table-column label="鍒涘缓鏃堕棿" align="center" prop="createTime" width="160" />
- <el-table-column label="鏇存柊鏃堕棿" align="center" prop="updateTime" width="160" />
- <el-table-column label="鎿嶄綔" align="center" width="330" class-name="small-padding fixed-width">
+ <el-table-column
+ label="鍒涘缓鏃堕棿"
+ align="center"
+ prop="createTime"
+ width="160"
+ sortable="custom"
+ :sort-orders="['descending', 'ascending']"
+ />
+ <el-table-column
+ label="鏇存柊鏃堕棿"
+ align="center"
+ prop="updateTime"
+ width="160"
+ sortable="custom"
+ :sort-orders="['descending', 'ascending']"
+ />
+ <el-table-column
+ label="鎿嶄綔"
+ align="center"
+ width="330"
+ class-name="small-padding fixed-width"
+ >
<template #default="scope">
<el-tooltip content="棰勮" placement="top">
- <el-button link type="primary" icon="View" @click="handlePreview(scope.row)" v-hasPermi="['tool:gen:preview']"></el-button>
+ <el-button
+ link
+ type="primary"
+ icon="View"
+ @click="handlePreview(scope.row)"
+ v-hasPermi="['tool:gen:preview']"
+ ></el-button>
</el-tooltip>
<el-tooltip content="缂栬緫" placement="top">
- <el-button link type="primary" icon="Edit" @click="handleEditTable(scope.row)" v-hasPermi="['tool:gen:edit']"></el-button>
+ <el-button
+ link
+ type="primary"
+ icon="Edit"
+ @click="handleEditTable(scope.row)"
+ v-hasPermi="['tool:gen:edit']"
+ ></el-button>
</el-tooltip>
<el-tooltip content="鍒犻櫎" placement="top">
- <el-button link type="primary" icon="Delete" @click="handleDelete(scope.row)" v-hasPermi="['tool:gen:remove']"></el-button>
+ <el-button
+ link
+ type="primary"
+ icon="Delete"
+ @click="handleDelete(scope.row)"
+ v-hasPermi="['tool:gen:remove']"
+ ></el-button>
</el-tooltip>
<el-tooltip content="鍚屾" placement="top">
- <el-button link type="primary" icon="Refresh" @click="handleSynchDb(scope.row)" v-hasPermi="['tool:gen:edit']"></el-button>
+ <el-button
+ link
+ type="primary"
+ icon="Refresh"
+ @click="handleSynchDb(scope.row)"
+ v-hasPermi="['tool:gen:edit']"
+ ></el-button>
</el-tooltip>
<el-tooltip content="鐢熸垚浠ｇ爜" placement="top">
- <el-button link type="primary" icon="Download" @click="handleGenTable(scope.row)" v-hasPermi="['tool:gen:code']"></el-button>
+ <el-button
+ link
+ type="primary"
+ icon="Download"
+ @click="handleGenTable(scope.row)"
+ v-hasPermi="['tool:gen:code']"
+ ></el-button>
</el-tooltip>
</template>
</el-table-column>
</el-table>
<pagination
- v-show="total>0"
+ v-show="total > 0"
:total="total"
v-model:page="queryParams.pageNum"
v-model:limit="queryParams.pageSize"
@pagination="getList"
/>
<!-- 棰勮鐣岄潰 -->
- <el-dialog :title="preview.title" v-model="preview.open" width="80%" top="5vh" append-to-body class="scrollbar">
+ <el-dialog
+ :title="preview.title"
+ v-model="preview.open"
+ width="80%"
+ top="5vh"
+ append-to-body
+ class="scrollbar"
+ >
<el-tabs v-model="preview.activeName">
<el-tab-pane
v-for="(value, key) in preview.data"
- :label="key.substring(key.lastIndexOf('/')+1,key.indexOf('.vm'))"
- :name="key.substring(key.lastIndexOf('/')+1,key.indexOf('.vm'))"
+ :label="key.substring(key.lastIndexOf('/') + 1, key.indexOf('.vm'))"
+ :name="key.substring(key.lastIndexOf('/') + 1, key.indexOf('.vm'))"
:key="value"
>
- <el-link :underline="false" icon="DocumentCopy" v-copyText="value" v-copyText:callback="copyTextSuccess" style="float:right"> 澶嶅埗</el-link>
+ <el-link
+ :underline="false"
+ icon="DocumentCopy"
+ v-copyText="value"
+ v-copyText:callback="copyTextSuccess"
+ style="float: right"
+ > 澶嶅埗</el-link
+ >
<pre>{{ value }}</pre>
</el-tab-pane>
</el-tabs>
@@ -161,7 +253,13 @@
</template>
<script setup name="Gen">
-import { listTable, previewTable, delTable, genCode, synchDb } from "@/api/tool/gen";
+import {
+ listTable,
+ previewTable,
+ delTable,
+ genCode,
+ synchDb,
+} from "@/api/tool/gen";
import router from "@/router";
import importTable from "./importTable";
import createTable from "./createTable";
@@ -179,20 +277,23 @@
const tableNames = ref([]);
const dateRange = ref([]);
const uniqueId = ref("");
+const defaultSort = ref({ prop: "createTime", order: "descending" });
const data = reactive({
queryParams: {
pageNum: 1,
pageSize: 10,
tableName: undefined,
- tableComment: undefined
+ tableComment: undefined,
+ orderByColumn: defaultSort.value.prop,
+ isAsc: defaultSort.value.order,
},
preview: {
open: false,
title: "浠ｇ爜棰勮",
data: {},
- activeName: "domain.java"
- }
+ activeName: "domain.java",
+ },
});
const { queryParams, preview } = toRefs(data);
@@ -206,22 +307,26 @@
proxy.resetForm("queryForm");
getList();
}
-})
+});
/** 鏌ヨ琛ㄩ泦鍚� */
function getList() {
loading.value = true;
- listTable(proxy.addDateRange(queryParams.value, dateRange.value)).then(response => {
- tableList.value = response.rows;
- total.value = response.total;
- loading.value = false;
- });
+ listTable(proxy.addDateRange(queryParams.value, dateRange.value)).then(
+ (response) => {
+ tableList.value = response.rows;
+ total.value = response.total;
+ loading.value = false;
+ }
+ );
}
+
/** 鎼滅储鎸夐挳鎿嶄綔 */
function handleQuery() {
queryParams.value.pageNum = 1;
getList();
}
+
/** 鐢熸垚浠ｇ爜鎿嶄綔 */
function handleGenTable(row) {
const tbNames = row.tableName || tableNames.value;
@@ -230,69 +335,103 @@
return;
}
if (row.genType === "1") {
- genCode(row.tableName).then(response => {
+ genCode(row.tableName).then((response) => {
proxy.$modal.msgSuccess("鎴愬姛鐢熸垚鍒拌嚜瀹氫箟璺緞锛�" + row.genPath);
});
} else {
- proxy.$download.zip("/tool/gen/batchGenCode?tables=" + tbNames, "ruoyi.zip");
+ proxy.$download.zip(
+ "/tool/gen/batchGenCode?tables=" + tbNames,
+ "ruoyi.zip"
+ );
}
}
+
/** 鍚屾鏁版嵁搴撴搷浣� */
function handleSynchDb(row) {
const tableName = row.tableName;
- proxy.$modal.confirm('纭瑕佸己鍒跺悓姝�"' + tableName + '"琛ㄧ粨鏋勫悧锛�').then(function () {
- return synchDb(tableName);
- }).then(() => {
- proxy.$modal.msgSuccess("鍚屾鎴愬姛");
- }).catch(() => {});
+ proxy.$modal
+ .confirm('纭瑕佸己鍒跺悓姝�"' + tableName + '"琛ㄧ粨鏋勫悧锛�')
+ .then(function () {
+ return synchDb(tableName);
+ })
+ .then(() => {
+ proxy.$modal.msgSuccess("鍚屾鎴愬姛");
+ })
+ .catch(() => {});
}
+
/** 鎵撳紑瀵煎叆琛ㄥ脊绐� */
function openImportTable() {
proxy.$refs["importRef"].show();
}
+
/** 鎵撳紑鍒涘缓琛ㄥ脊绐� */
function openCreateTable() {
proxy.$refs["createRef"].show();
}
+
/** 閲嶇疆鎸夐挳鎿嶄綔 */
function resetQuery() {
dateRange.value = [];
proxy.resetForm("queryRef");
- handleQuery();
+ queryParams.value.pageNum = 1;
+ proxy.$refs["genRef"].sort(defaultSort.value.prop, defaultSort.value.order);
}
+
/** 棰勮鎸夐挳 */
function handlePreview(row) {
- previewTable(row.tableId).then(response => {
+ previewTable(row.tableId).then((response) => {
preview.value.data = response.data;
preview.value.open = true;
preview.value.activeName = "domain.java";
});
}
+
/** 澶嶅埗浠ｇ爜鎴愬姛 */
function copyTextSuccess() {
proxy.$modal.msgSuccess("澶嶅埗鎴愬姛");
}
+
// 澶氶�夋閫変腑鏁版嵁
function handleSelectionChange(selection) {
- ids.value = selection.map(item => item.tableId);
- tableNames.value = selection.map(item => item.tableName);
+ ids.value = selection.map((item) => item.tableId);
+ tableNames.value = selection.map((item) => item.tableName);
single.value = selection.length != 1;
multiple.value = !selection.length;
}
+
+/** 鎺掑簭瑙﹀彂浜嬩欢 */
+function handleSortChange(column, prop, order) {
+ queryParams.value.orderByColumn = column.prop;
+ queryParams.value.isAsc = column.order;
+ getList();
+}
+
/** 淇敼鎸夐挳鎿嶄綔 */
function handleEditTable(row) {
const tableId = row.tableId || ids.value[0];
- router.push({ path: "/tool/gen-edit/index/" + tableId, query: { pageNum: queryParams.value.pageNum } });
+ const tableName = row.tableName || tableNames.value[0];
+ const params = { pageNum: queryParams.value.pageNum };
+ proxy.$tab.openPage(
+ "淇敼[" + tableName + "]鐢熸垚閰嶇疆",
+ "/tool/gen-edit/index/" + tableId,
+ params
+ );
}
+
/** 鍒犻櫎鎸夐挳鎿嶄綔 */
function handleDelete(row) {
const tableIds = row.tableId || ids.value;
- proxy.$modal.confirm('鏄惁纭鍒犻櫎琛ㄧ紪鍙蜂负"' + tableIds + '"鐨勬暟鎹」锛�').then(function () {
- return delTable(tableIds);
- }).then(() => {
- getList();
- proxy.$modal.msgSuccess("鍒犻櫎鎴愬姛");
- }).catch(() => {});
+ proxy.$modal
+ .confirm('鏄惁纭鍒犻櫎琛ㄧ紪鍙蜂负"' + tableIds + '"鐨勬暟鎹」锛�')
+ .then(function () {
+ return delTable(tableIds);
+ })
+ .then(() => {
+ getList();
+ proxy.$modal.msgSuccess("鍒犻櫎鎴愬姛");
+ })
+ .catch(() => {});
}
getList();
--
Gitblit v1.9.3