feat: 完成附件下载

曹睿

13 小时以前 14d71170912935b50f4e4e3f605c5305f2757fc3

 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,60 +93,155 @@
          :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 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

      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>

          <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" 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">

      <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 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">&nbsp;复制</el-link>

          <el-link

            :underline="false"

            icon="DocumentCopy"

            v-copyText="value"

            v-copyText:callback="copyTextSuccess"

            style="float: right"

            >&nbsp;复制</el-link

          >

          <pre>{{ value }}</pre>

        </el-tab-pane>

      </el-tabs>

@@ -146,25 +252,31 @@
</template>



<script setup name="Gen">

import { listTable, previewTable, delTable, genCode, synchDb } from "@/api/tool/gen"

import router from "@/router"

import importTable from "./importTable"

import createTable from "./createTable"

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()

const route = useRoute();

const { proxy } = getCurrentInstance();



const tableList = ref([])

const loading = ref(true)

const showSearch = ref(true)

const ids = ref([])

const single = ref(true)

const multiple = ref(true)

const total = ref(0)

const tableNames = ref([])

const dateRange = ref([])

const uniqueId = ref("")

const defaultSort = ref({ prop: "createTime", order: "descending" })

const tableList = ref([]);

const loading = ref(true);

const showSearch = ref(true);

const ids = ref([]);

const single = ref(true);

const multiple = ref(true);

const total = ref(0);

const tableNames = ref([]);

const dateRange = ref([]);

const uniqueId = ref("");

const defaultSort = ref({ prop: "createTime", order: "descending" });



const data = reactive({

  queryParams: {

@@ -173,134 +285,153 @@
    tableName: undefined,

    tableComment: undefined,

    orderByColumn: defaultSort.value.prop,

    isAsc: defaultSort.value.order

    isAsc: defaultSort.value.order,

  },

  preview: {

    open: false,

    title: "代码预览",

    data: {},

    activeName: "domain.java"

  }

})

    activeName: "domain.java",

  },

});



const { queryParams, preview } = toRefs(data)

const { queryParams, preview } = toRefs(data);



onActivated(() => {

  const time = route.query.t

  const time = route.query.t;

  if (time != null && time != uniqueId.value) {

    uniqueId.value = time

    queryParams.value.pageNum = Number(route.query.pageNum)

    dateRange.value = []

    proxy.resetForm("queryForm")

    getList()

    uniqueId.value = time;

    queryParams.value.pageNum = Number(route.query.pageNum);

    dateRange.value = [];

    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

  })

  loading.value = true;

  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()

  queryParams.value.pageNum = 1;

  getList();

}



/** 生成代码操作 */

function handleGenTable(row) {

  const tbNames = row.tableName || tableNames.value

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

  if (tbNames == "") {

    proxy.$modal.msgError("请选择要生成的数据")

    return

    proxy.$modal.msgError("请选择要生成的数据");

    return;

  }

  if (row.genType === "1") {

    genCode(row.tableName).then(response => {

      proxy.$modal.msgSuccess("成功生成到自定义路径：" + row.genPath)

    })

    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(() => {})

  const tableName = row.tableName;

  proxy.$modal

    .confirm('确认要强制同步"' + tableName + '"表结构吗？')

    .then(function () {

      return synchDb(tableName);

    })

    .then(() => {

      proxy.$modal.msgSuccess("同步成功");

    })

    .catch(() => {});

}



/** 打开导入表弹窗 */

function openImportTable() {

  proxy.$refs["importRef"].show()

  proxy.$refs["importRef"].show();

}



/** 打开创建表弹窗 */

function openCreateTable() {

  proxy.$refs["createRef"].show()

  proxy.$refs["createRef"].show();

}



/** 重置按钮操作 */

function resetQuery() {

  dateRange.value = []

  proxy.resetForm("queryRef")

  queryParams.value.pageNum = 1

  proxy.$refs["genRef"].sort(defaultSort.value.prop, defaultSort.value.order)

  dateRange.value = [];

  proxy.resetForm("queryRef");

  queryParams.value.pageNum = 1;

  proxy.$refs["genRef"].sort(defaultSort.value.prop, defaultSort.value.order);

}



/** 预览按钮 */

function handlePreview(row) {

  previewTable(row.tableId).then(response => {

    preview.value.data = response.data

    preview.value.open = true

    preview.value.activeName = "domain.java"

  })

  previewTable(row.tableId).then((response) => {

    preview.value.data = response.data;

    preview.value.open = true;

    preview.value.activeName = "domain.java";

  });

}



/** 复制代码成功 */

function copyTextSuccess() {

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

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

}



// 多选框选中数据

function handleSelectionChange(selection) {

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

  tableNames.value = selection.map(item => item.tableName)

  single.value = selection.length != 1

  multiple.value = !selection.length

  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()

  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 tableId = row.tableId || ids.value[0];

  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(() => {})

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

  proxy.$modal

    .confirm('是否确认删除表编号为"' + tableIds + '"的数据项？')

    .then(function () {

      return delTable(tableIds);

    })

    .then(() => {

      getList();

      proxy.$modal.msgSuccess("删除成功");

    })

    .catch(() => {});

}



getList()

getList();

</script>