优化导出数据操作

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>

@@ -38,20 +38,33 @@
          <el-option label="请选择字典生成" value="" />

        </el-select>

      </el-form-item>

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

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

      <el-form-item label="${comment}" prop="${column.javaField}">

        <el-date-picker clearable size="small" style="width: 200px"

        <el-date-picker clearable size="small"

          v-model="queryParams.${column.javaField}"

          type="date"

          value-format="yyyy-MM-dd"

          placeholder="选择${comment}">

        </el-date-picker>

      </el-form-item>

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

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

        <el-date-picker

          v-model="daterange${AttrName}"

          size="small"

          style="width: 240px"

          value-format="yyyy-MM-dd"

          type="daterange"

          range-separator="-"

          start-placeholder="开始日期"

          end-placeholder="结束日期"

        ></el-date-picker>

      </el-form-item>

#end

#end

#end

      <el-form-item>

        <el-button type="cyan" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>

        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>

        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>

      </el-form-item>

    </el-form>

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

        <el-button

          type="primary"

          plain

          icon="el-icon-plus"

          size="mini"

          @click="handleAdd"

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

        <el-button

          type="success"

          plain

          icon="el-icon-edit"

          size="mini"

          :disabled="single"

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

        <el-button

          type="danger"

          plain

          icon="el-icon-delete"

          size="mini"

          :disabled="multiple"

@@ -89,20 +105,14 @@
      <el-col :span="1.5">

        <el-button

          type="warning"

          plain

          icon="el-icon-download"

          size="mini"

          @click="handleExport"

          v-hasPermi="['${moduleName}:${businessName}:export']"

        >导出</el-button>

      </el-col>

      <div class="top-right-btn">

        <el-tooltip class="item" effect="dark" content="刷新" placement="top">

          <el-button size="mini" circle icon="el-icon-refresh" @click="handleQuery" />

        </el-tooltip>

        <el-tooltip class="item" effect="dark" :content="showSearch ? '隐藏搜索' : '显示搜索'" placement="top">

          <el-button size="mini" circle icon="el-icon-search" @click="showSearch=!showSearch" />

        </el-tooltip>

      </div>

      <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>

    </el-row>



    <el-table v-loading="loading" :data="${businessName}List" @selection-change="handleSelectionChange">

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

@@ -175,20 +189,32 @@
        <el-form-item label="${comment}" prop="${field}">

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

        </el-form-item>

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

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

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

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

          <editor v-model="form.${field}" :min-height="192"/>

        </el-form-item>

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

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

        </el-form-item>

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

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

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

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

            <el-option label="请选择字典生成" value="" />

          </el-select>

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

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

@@ -229,7 +255,7 @@
        </el-form-item>

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

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

          <el-date-picker clearable size="small" style="width: 200px"

          <el-date-picker clearable size="small"

            v-model="form.${field}"

            type="date"

            value-format="yyyy-MM-dd"

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

@@ -254,40 +312,46 @@
</template>



<script>

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

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



export default {

  name: "${BusinessName}",

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

  dicts: [${dicts}],

#end

  data() {

    return {

      // 遮罩层

      loading: true,

      // 选中数组

      ids: [],

#if($table.sub)

      // 子表选中数据

      checked${subClassName}: [],

#end

      // 非单个禁用

      single: true,

      // 非多个禁用

      multiple: true,

     // 显示搜索条件

      // 显示搜索条件

      showSearch: true,

      // 总条数

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

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

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

      // $comment时间范围

      daterange${AttrName}: [],

#end

#end

      // 查询参数

@@ -296,7 +360,7 @@
        pageSize: 10,

#foreach ($column in $columns)

#if($column.query)

        $column.javaField: undefined#if($velocityCount != $columns.size()),#end

        $column.javaField: null#if($velocityCount != $columns.size()),#end



#end

#end

@@ -313,9 +377,8 @@
#else

#set($comment=$column.columnComment)

#end

#set($comment=$column.columnComment)

        $column.javaField: [

          { required: true, message: "$comment不能为空", trigger: "blur" }

          { required: true, message: "$comment不能为空", trigger: #if($column.htmlType == "select")"change"#else"blur"#end }

        ]#if($velocityCount != $columns.size()),#end



#end

@@ -325,38 +388,32 @@
  },

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

    getList() {

      this.loading = true;

#foreach ($column in $columns)

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

      this.queryParams.params = {};

#break

#end

#end

#foreach ($column in $columns)

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

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

      if (null != this.daterange${AttrName} && '' != this.daterange${AttrName}) {

        this.queryParams.params["begin${AttrName}"] = this.daterange${AttrName}[0];

        this.queryParams.params["end${AttrName}"] = this.daterange${AttrName}[1];

      }

#end

#end

      list${BusinessName}(this.queryParams).then(response => {

        this.${businessName}List = response.rows;

        this.total = response.total;

        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;

@@ -367,17 +424,20 @@
      this.form = {

#foreach ($column in $columns)

#if($column.htmlType == "radio")

        $column.javaField: "0"#if($velocityCount != $columns.size()),#end

        $column.javaField: #if($column.javaType == "Integer" || $column.javaType == "Long")0#else"0"#end#if($velocityCount != $columns.size()),#end



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

        $column.javaField: []#if($velocityCount != $columns.size()),#end



#else

        $column.javaField: undefined#if($velocityCount != $columns.size()),#end

        $column.javaField: null#if($velocityCount != $columns.size()),#end



#end

#end

      };

#if($table.sub)

      this.${subclassName}List = [];

#end

      this.resetForm("form");

    },

    /** 搜索按钮操作 */

@@ -387,13 +447,19 @@
    },

    /** 重置按钮操作 */

    resetQuery() {

#foreach ($column in $columns)

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

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

      this.daterange${AttrName} = [];

#end

#end

      this.resetForm("queryForm");

      this.handleQuery();

    },

    // 多选框选中数据

    handleSelectionChange(selection) {

      this.ids = selection.map(item => item.${pkColumn.javaField})

      this.single = selection.length!=1

      this.single = selection.length!==1

      this.multiple = !selection.length

    },

    /** 新增按钮操作 */

@@ -413,12 +479,15 @@
        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}";

      });

    },

    /** 提交按钮 */

    submitForm: function() {

    submitForm() {

      this.#[[$]]#refs["form"].validate(valid => {

        if (valid) {

#foreach ($column in $columns)

@@ -426,21 +495,20 @@
          this.form.$column.javaField = this.form.${column.javaField}.join(",");

#end

#end

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

#if($table.sub)

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

#end

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

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

              if (response.code === 200) {

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

                this.open = false;

                this.getList();

              }

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

              this.open = false;

              this.getList();

            });

          } else {

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

              if (response.code === 200) {

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

                this.open = false;

                this.getList();

              }

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

              this.open = false;

              this.getList();

            });

          }

        }

@@ -449,30 +517,52 @@
    /** 删除按钮操作 */

    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("删除成功");

        }).catch(function() {});

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

        }).catch(function() {});

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

        ...this.queryParams

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

    }

  }

};

</script>
</script>