优化导出数据操作

RuoYi

2021-11-17 9c3cf692ec5c32a3df450b65a5882ccb6f9fc189

 src/main/resources/vm/vue/index.vue.vm

@@ -25,10 +25,10 @@
      <el-form-item label="${comment}" prop="${column.javaField}">

        <el-select v-model="queryParams.${column.javaField}" placeholder="请选择${comment}" clearable size="small">

          <el-option

            v-for="dict in ${column.javaField}Options"

            :key="dict.dictValue"

            :label="dict.dictLabel"

            :value="dict.dictValue"

            v-for="dict in dict.type.${dictType}"

            :key="dict.value"

            :label="dict.label"

            :value="dict.value"

          />

        </el-select>

      </el-form-item>

@@ -134,7 +134,11 @@
        </template>

      </el-table-column>

#elseif($column.list && "" != $column.dictType)

      <el-table-column label="${comment}" align="center" prop="${javaField}" :formatter="${javaField}Format" />

      <el-table-column label="${comment}" align="center" prop="${javaField}">

        <template slot-scope="scope">

          <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.${javaField}"/>

        </template>

      </el-table-column>

#elseif($column.list && "" != $javaField)

      <el-table-column label="${comment}" align="center" prop="${javaField}" />

#end

@@ -201,10 +205,10 @@
        <el-form-item label="${comment}" prop="${field}">

          <el-select v-model="form.${field}" placeholder="请选择${comment}">

            <el-option

              v-for="dict in ${field}Options"

              :key="dict.dictValue"

              :label="dict.dictLabel"

              #if($column.javaType == "Integer" || $column.javaType == "Long"):value="parseInt(dict.dictValue)"#else:value="dict.dictValue"#end

              v-for="dict in dict.type.${dictType}"

              :key="dict.value"

              :label="dict.label"

              #if($column.javaType == "Integer" || $column.javaType == "Long"):value="parseInt(dict.value)"#else:value="dict.value"#end



            ></el-option>

          </el-select>

@@ -219,10 +223,10 @@
        <el-form-item label="${comment}">

          <el-checkbox-group v-model="form.${field}">

            <el-checkbox

              v-for="dict in ${field}Options"

              :key="dict.dictValue"

              :label="dict.dictValue">

              {{dict.dictLabel}}

              v-for="dict in dict.type.${dictType}"

              :key="dict.value"

              :label="dict.value">

              {{dict.label}}

            </el-checkbox>

          </el-checkbox-group>

        </el-form-item>

@@ -236,11 +240,11 @@
        <el-form-item label="${comment}">

          <el-radio-group v-model="form.${field}">

            <el-radio

              v-for="dict in ${field}Options"

              :key="dict.dictValue"

              #if($column.javaType == "Integer" || $column.javaType == "Long"):label="parseInt(dict.dictValue)"#else:label="dict.dictValue"#end

              v-for="dict in dict.type.${dictType}"

              :key="dict.value"

              #if($column.javaType == "Integer" || $column.javaType == "Long"):label="parseInt(dict.value)"#else:label="dict.value"#end



            >{{dict.dictLabel}}</el-radio>

            >{{dict.label}}</el-radio>

          </el-radio-group>

        </el-form-item>

#elseif($column.htmlType == "radio" && $dictType)

@@ -308,48 +312,13 @@
</template>



<script>

import { list${BusinessName}, get${BusinessName}, del${BusinessName}, add${BusinessName}, update${BusinessName}, export${BusinessName} } from "@/api/${moduleName}/${businessName}";

#foreach($column in $columns)

#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == "imageUpload")

import ImageUpload from '@/components/ImageUpload';

#break

#end

#end

#foreach($column in $columns)

#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == "fileUpload")

import FileUpload from '@/components/FileUpload';

#break

#end

#end

#foreach($column in $columns)

#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == "editor")

import Editor from '@/components/Editor';

#break

#end

#end

import { list${BusinessName}, get${BusinessName}, del${BusinessName}, add${BusinessName}, update${BusinessName} } from "@/api/${moduleName}/${businessName}";



export default {

  name: "${BusinessName}",

  components: {

#foreach($column in $columns)

#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == "imageUpload")

    ImageUpload,

#break

#if(${dicts} != '')

  dicts: [${dicts}],

#end

#end

#foreach($column in $columns)

#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == "fileUpload")

    FileUpload,

#break

#end

#end

#foreach($column in $columns)

#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == "editor")

    Editor,

#break

#end

#end

  },

  data() {

    return {

      // 遮罩层

@@ -379,16 +348,7 @@
      // 是否显示弹出层

      open: false,

#foreach ($column in $columns)

#set($parentheseIndex=$column.columnComment.indexOf("（"))

#if($parentheseIndex != -1)

#set($comment=$column.columnComment.substring(0, $parentheseIndex))

#else

#set($comment=$column.columnComment)

#end

#if(${column.dictType} != '')

      // $comment字典

      ${column.javaField}Options: [],

#elseif($column.htmlType == "datetime" && $column.queryType == "BETWEEN")

#if($column.htmlType == "datetime" && $column.queryType == "BETWEEN")

#set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})

      // $comment时间范围

      daterange${AttrName}: [],

@@ -428,13 +388,6 @@
  },

  created() {

    this.getList();

#foreach ($column in $columns)

#if(${column.dictType} != '')

    this.getDicts("${column.dictType}").then(response => {

      this.${column.javaField}Options = response.data;

    });

#end

#end

  },

  methods: {

    /** 查询${functionName}列表 */

@@ -461,20 +414,6 @@
        this.loading = false;

      });

    },

#foreach ($column in $columns)

#if(${column.dictType} != '')

#set($parentheseIndex=$column.columnComment.indexOf("（"))

#if($parentheseIndex != -1)

#set($comment=$column.columnComment.substring(0, $parentheseIndex))

#else

#set($comment=$column.columnComment)

#end

    // $comment字典翻译

    ${column.javaField}Format(row, column) {

      return this.selectDictLabel#if($column.htmlType == "checkbox")s#end(this.${column.javaField}Options, row.${column.javaField});

    },

#end

#end

    // 取消按钮

    cancel() {

      this.open = false;

@@ -561,13 +500,13 @@
#end

          if (this.form.${pkColumn.javaField} != null) {

            update${BusinessName}(this.form).then(response => {

              this.msgSuccess("修改成功");

              this.#[[$modal]]#.msgSuccess("修改成功");

              this.open = false;

              this.getList();

            });

          } else {

            add${BusinessName}(this.form).then(response => {

              this.msgSuccess("新增成功");

              this.#[[$modal]]#.msgSuccess("新增成功");

              this.open = false;

              this.getList();

            });

@@ -578,16 +517,12 @@
    /** 删除按钮操作 */

    handleDelete(row) {

      const ${pkColumn.javaField}s = row.${pkColumn.javaField} || this.ids;

      this.$confirm('是否确认删除${functionName}编号为"' + ${pkColumn.javaField}s + '"的数据项?', "警告", {

          confirmButtonText: "确定",

          cancelButtonText: "取消",

          type: "warning"

        }).then(function() {

          return del${BusinessName}(${pkColumn.javaField}s);

        }).then(() => {

          this.getList();

          this.msgSuccess("删除成功");

        })

      this.#[[$modal]]#.confirm('是否确认删除${functionName}编号为"' + ${pkColumn.javaField}s + '"的数据项？').then(function() {

        return del${BusinessName}(${pkColumn.javaField}s);

      }).then(() => {

        this.getList();

        this.#[[$modal]]#.msgSuccess("删除成功");

      }).catch(() => {});

    },

#if($table.sub)

   /** ${subTable.functionName}序号 */

@@ -608,33 +543,25 @@
    /** ${subTable.functionName}删除按钮操作 */

    handleDelete${subClassName}() {

      if (this.checked${subClassName}.length == 0) {

        this.$alert("请先选择要删除的${subTable.functionName}数据", "提示", { confirmButtonText: "确定", });

        this.#[[$modal]]#.msgError("请先选择要删除的${subTable.functionName}数据");

      } else {

        this.${subclassName}List.splice(this.checked${subClassName}[0].index - 1, 1);

        const ${subclassName}List = this.${subclassName}List;

        const checked${subClassName} = this.checked${subClassName};

        this.${subclassName}List = ${subclassName}List.filter(function(item) {

          return checked${subClassName}.indexOf(item.index) == -1

        });

      }

    },

    /** 单选框选中数据 */

    /** 复选框选中数据 */

    handle${subClassName}SelectionChange(selection) {

      if (selection.length > 1) {

        this.$refs.${subclassName}.clearSelection();

        this.$refs.${subclassName}.toggleRowSelection(selection.pop());

      } else {

        this.checked${subClassName} = selection;

      }

      this.checked${subClassName} = selection.map(item => item.index)

    },

#end

    /** 导出按钮操作 */

    handleExport() {

      const queryParams = this.queryParams;

      this.$confirm('是否确认导出所有${functionName}数据项?', "警告", {

          confirmButtonText: "确定",

          cancelButtonText: "取消",

          type: "warning"

        }).then(function() {

          return export${BusinessName}(queryParams);

        }).then(response => {

          this.download(response.msg);

        })

      this.download('${moduleName}/${businessName}/export', {

        ...this.queryParams

      }, `${businessName}_#[[${new Date().getTime()}]]#.xlsx`)

    }

  }

};