优化导出数据操作

RuoYi

2021-11-17 9c3cf692ec5c32a3df450b65a5882ccb6f9fc189

 src/main/resources/vm/vue/index-tree.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>

@@ -64,7 +64,7 @@
#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>

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

        <el-button

          type="primary"

          plain

          icon="el-icon-plus"

          size="mini"

          @click="handleAdd"

@@ -105,9 +106,17 @@
        </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)

#if(${foreach.index} == 1)

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

#else

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

#end

#end

#end

      <el-table-column label="操作" align="center" class-name="small-padding fixed-width">

@@ -119,6 +128,13 @@
            @click="handleUpdate(scope.row)"

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

          >修改</el-button>

          <el-button

            size="mini"

            type="text"

            icon="el-icon-plus"

            @click="handleAdd(scope.row)"

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

          >新增</el-button>

          <el-button

            size="mini"

            type="text"

@@ -152,9 +168,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}">

@@ -164,10 +184,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>

@@ -182,10 +202,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>

@@ -199,11 +219,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)

@@ -242,34 +262,13 @@
import { list${BusinessName}, get${BusinessName}, del${BusinessName}, add${BusinessName}, update${BusinessName}, export${BusinessName} } from "@/api/${moduleName}/${businessName}";

import Treeselect from "@riophae/vue-treeselect";

import "@riophae/vue-treeselect/dist/vue-treeselect.css";

#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



export default {

  name: "${BusinessName}",

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

  dicts: [${dicts}],

#end

  components: {

#foreach($column in $columns)

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

    UploadImage,

#break

#end

#end

#foreach($column in $columns)

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

    Editor,

#break

#end

#end

    Treeselect

  },

  data() {

@@ -287,15 +286,10 @@
      // 是否显示弹出层

      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

      // 查询参数

@@ -330,18 +324,26 @@
  },

  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 = this.handleTree(response.data, "${treeCode}", "${treeParentCode}");

        this.loading = false;

@@ -358,7 +360,7 @@
        children: node.children

      };

    },

   /** 查询部门下拉树结构 */

   /** 查询${functionName}下拉树结构 */

    getTreeselect() {

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

        this.${businessName}Options = [];

@@ -367,20 +369,6 @@
        this.${businessName}Options.push(data);

      });

    },

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

@@ -410,20 +398,31 @@
    },

    /** 重置按钮操作 */

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

    },

    /** 新增按钮操作 */

    handleAdd() {

    handleAdd(row) {

      this.reset();

     this.getTreeselect();

      this.getTreeselect();

      if (row != null && row.${treeCode}) {

        this.form.${treeParentCode} = row.${treeCode};

      } else {

        this.form.${treeParentCode} = 0;

      }

      this.open = true;

      this.title = "添加${functionName}";

    },

    /** 修改按钮操作 */

    handleUpdate(row) {

      this.reset();

     this.getTreeselect();

      this.getTreeselect();

      if (row != null) {

        this.form.${treeParentCode} = row.${treeCode};

      }

@@ -449,13 +448,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();

            });

@@ -465,16 +464,12 @@
    },

    /** 删除按钮操作 */

    handleDelete(row) {

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

          confirmButtonText: "确定",

          cancelButtonText: "取消",

          type: "warning"

        }).then(function() {

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

        }).then(() => {

          this.getList();

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

        })

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

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

      }).then(() => {

        this.getList();

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

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

    }

  }

};