代码生成列表支持按时间排序

RuoYi

2025-02-28 094e300939e42582cf08e6bef1628307eb22fed9

 src/views/tool/gen/index.vue

@@ -41,9 +41,19 @@
          type="primary"

          plain

          icon="Download"

          :disabled="multiple"

          @click="handleGenTable"

          v-hasPermi="['tool:gen:code']"

        >生成</el-button>

      </el-col>

      <el-col :span="1.5">

        <el-button

          type="primary"

          plain

          icon="Plus"

          @click="openCreateTable"

          v-hasRole="['admin']"

        >创建</el-button>

      </el-col>

      <el-col :span="1.5">

        <el-button

@@ -77,74 +87,34 @@
      <right-toolbar v-model:showSearch="showSearch" @queryTable="getList"></right-toolbar>

    </el-row>



    <el-table v-loading="loading" :data="tableList" @selection-change="handleSelectionChange">

    <el-table ref="genRef" v-loading="loading" :data="tableList" @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>

        </template>

      </el-table-column>

      <el-table-column

        label="表名称"

        align="center"

        prop="tableName"

        :show-overflow-tooltip="true"

      />

      <el-table-column

        label="表描述"

        align="center"

        prop="tableComment"

        :show-overflow-tooltip="true"

      />

      <el-table-column

        label="实体"

        align="center"

        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" prop="tableName" :show-overflow-tooltip="true" />

      <el-table-column label="表描述" align="center" prop="tableComment" :show-overflow-tooltip="true" />

      <el-table-column label="实体" align="center" prop="className" :show-overflow-tooltip="true" />

      <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

              type="text"

              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

              type="text"

              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

              type="text"

              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

              type="text"

              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

              type="text"

              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>

@@ -157,7 +127,7 @@
      @pagination="getList"

    />

    <!-- 预览界面 -->

    <el-dialog :title="preview.title" v-model="preview.open" width="80%" top="5vh" append-to-body custom-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"

@@ -171,6 +141,7 @@
      </el-tabs>

    </el-dialog>

    <import-table ref="importRef" @ok="handleQuery" />

    <create-table ref="createRef" @ok="handleQuery" />

  </div>

</template>



@@ -178,6 +149,7 @@
import { listTable, previewTable, delTable, genCode, synchDb } from "@/api/tool/gen";

import router from "@/router";

import importTable from "./importTable";

import createTable from "./createTable";



const route = useRoute();

const { proxy } = getCurrentInstance();

@@ -192,13 +164,16 @@
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,

@@ -230,11 +205,13 @@
    loading.value = false;

  });

}



/** 搜索按钮操作 */

function handleQuery() {

  queryParams.value.pageNum = 1;

  getList();

}



/** 生成代码操作 */

function handleGenTable(row) {

  const tbNames = row.tableName || tableNames.value;

@@ -247,9 +224,10 @@
      proxy.$modal.msgSuccess("成功生成到自定义路径：" + row.genPath);

    });

  } else {

    proxy.$download.zip("/tool/gen/batchGenCode?tables=" + tbNames, "ruoyi");

    proxy.$download.zip("/tool/gen/batchGenCode?tables=" + tbNames, "ruoyi.zip");

  }

}



/** 同步数据库操作 */

function handleSynchDb(row) {

  const tableName = row.tableName;

@@ -259,16 +237,25 @@
    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 => {

@@ -277,10 +264,12 @@
    preview.value.activeName = "domain.java";

  });

}



/** 复制代码成功 */

function copyTextSuccess() {

  proxy.$modal.msgSuccess("复制成功");

}



// 多选框选中数据

function handleSelectionChange(selection) {

  ids.value = selection.map(item => item.tableId);

@@ -288,11 +277,20 @@
  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 } });

}



/** 删除按钮操作 */

function handleDelete(row) {

  const tableIds = row.tableId || ids.value;