优化导出数据操作

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>

@@ -73,7 +73,7 @@
      <el-col :span="1.5">

        <el-button

          type="primary"

        plain

          plain

          icon="el-icon-plus"

          size="mini"

          @click="handleAdd"

@@ -83,7 +83,7 @@
      <el-col :span="1.5">

        <el-button

          type="success"

        plain

          plain

          icon="el-icon-edit"

          size="mini"

          :disabled="single"

@@ -94,7 +94,7 @@
      <el-col :span="1.5">

        <el-button

          type="danger"

        plain

          plain

          icon="el-icon-delete"

          size="mini"

          :disabled="multiple"

@@ -105,7 +105,7 @@
      <el-col :span="1.5">

        <el-button

          type="warning"

        plain

          plain

          icon="el-icon-download"

          size="mini"

          @click="handleExport"

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

@@ -185,9 +189,13 @@
        <el-form-item label="${comment}" prop="${field}">

          <el-input v-model="form.${field}" placeholder="请输入${comment}" />

        </el-form-item>

#elseif($column.htmlType == "uploadImage")

#elseif($column.htmlType == "imageUpload")

        <el-form-item label="${comment}">

          <uploadImage v-model="form.${field}"/>

          <imageUpload v-model="form.${field}"/>

        </el-form-item>

#elseif($column.htmlType == "fileUpload")

        <el-form-item label="${comment}">

          <fileUpload v-model="form.${field}"/>

        </el-form-item>

#elseif($column.htmlType == "editor")

        <el-form-item label="${comment}">

@@ -197,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>

@@ -215,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>

@@ -232,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)

@@ -262,6 +270,38 @@
#end

#end

#end

#if($table.sub)

        <el-divider content-position="center">${subTable.functionName}信息</el-divider>

        <el-row :gutter="10" class="mb8">

          <el-col :span="1.5">

            <el-button type="primary" icon="el-icon-plus" size="mini" @click="handleAdd${subClassName}">添加</el-button>

          </el-col>

          <el-col :span="1.5">

            <el-button type="danger" icon="el-icon-delete" size="mini" @click="handleDelete${subClassName}">删除</el-button>

          </el-col>

        </el-row>

        <el-table :data="${subclassName}List" :row-class-name="row${subClassName}Index" @selection-change="handle${subClassName}SelectionChange" ref="${subclassName}">

          <el-table-column type="selection" width="50" align="center" />

          <el-table-column label="序号" align="center" prop="index" width="50"/>

#foreach($column in $subTable.columns)

#set($javaField=$column.javaField)

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

#if($parentheseIndex != -1)

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

#else

#set($comment=$column.columnComment)

#end

#if($column.pk || $javaField == ${subTableFkclassName})

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

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

            <template slot-scope="scope">

              <el-input v-model="scope.row.$javaField" placeholder="请输入$comment" />

            </template>

          </el-table-column>

#end

#end

        </el-table>

#end

      </el-form>

      <div slot="footer" class="dialog-footer">

        <el-button type="primary" @click="submitForm">确 定</el-button>

@@ -272,42 +312,23 @@
</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 == "uploadImage")

import UploadImage from '@/components/UploadImage';

#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 == "uploadImage")

    UploadImage,

#break

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

  dicts: [${dicts}],

#end

#end

#foreach($column in $columns)

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

    Editor,

#break

#end

#end

  },

  data() {

    return {

      // 遮罩层

      loading: true,

      // 选中数组

      ids: [],

#if($table.sub)

      // 子表选中数据

      checked${subClassName}: [],

#end

      // 非单个禁用

      single: true,

      // 非多个禁用

@@ -318,21 +339,16 @@
      total: 0,

      // ${functionName}表格数据

      ${businessName}List: [],

#if($table.sub)

      // ${subTable.functionName}表格数据

      ${subclassName}List: [],

#end

      // 弹出层标题

      title: "",

      // 是否显示弹出层

      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}: [],

@@ -372,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}列表 */

@@ -405,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;

@@ -440,6 +435,9 @@
#end

#end

      };

#if($table.sub)

      this.${subclassName}List = [];

#end

      this.resetForm("form");

    },

    /** 搜索按钮操作 */

@@ -481,6 +479,9 @@
        this.form.$column.javaField = this.form.${column.javaField}.split(",");

#end

#end

#if($table.sub)

        this.${subclassName}List = response.data.${subclassName}List;

#end

        this.open = true;

        this.title = "修改${functionName}";

      });

@@ -494,15 +495,18 @@
          this.form.$column.javaField = this.form.${column.javaField}.join(",");

#end

#end

#if($table.sub)

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

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

            });

@@ -513,29 +517,51 @@
    /** 删除按钮操作 */

    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}序号 */

    row${subClassName}Index({ row, rowIndex }) {

      row.index = rowIndex + 1;

    },

    /** ${subTable.functionName}添加按钮操作 */

    handleAdd${subClassName}() {

      let obj = {};

#foreach($column in $subTable.columns)

#if($column.pk || $column.javaField == ${subTableFkclassName})

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

      obj.$column.javaField = "";

#end

#end

      this.${subclassName}List.push(obj);

    },

    /** ${subTable.functionName}删除按钮操作 */

    handleDelete${subClassName}() {

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

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

      } else {

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

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

    }

  }

};