李林
2024-02-26 8d817b3847f9a96850c1a28f7923940697df7235
src/components/tool/value-table.vue
@@ -16,6 +16,29 @@
      text-align: right;
      margin-top: 10px;
   }
   .down-left {
      width: 50%;
      display: flex;
      align-items: center;
      justify-content: center;
   }
   .down-right {
      width: 50%;
      display: flex;
      align-items: center;
      justify-content: center;
   }
</style>
<style>
   .value-table .el-upload {
      width: 100%;
   }
   .value-table .el-upload-dragger {
      width: 100%;
   }
</style>
<template>
@@ -23,13 +46,13 @@
      <div class="table">
         <el-table ref="eltable" :data="tableData" style="width: 100%;" height="100%" tooltip-effect="dark" border
            @selection-change="selectChange" @select="select" v-loading="loading" @sort-change="sortChange"
            @row-click="rowClick">
            <el-table-column type="selection" width="50" v-if="data.showSelect">
            @row-click="rowClick" :show-summary="data.countFleid!=undefined && data.countFleid.length > 0" :summary-method="getSummaries">
            <el-table-column type="selection" width="65" v-if="data.showSelect">
            </el-table-column>
            <el-table-column align="center" type="index" label="序号" width="70" v-if="data.isIndex">
            </el-table-column>
            <el-table-column :prop="a.label" :label="a.value" sortable="custom" v-for="(a, ai) in tableHead" :key="ai"
               show-overflow-tooltip min-width="145">
               show-overflow-tooltip min-width="160">
               <template slot-scope="scope">
                  <div v-if="showType(a.label, data.tagField) != null">
                     <el-tag v-for="(b, bi) in data.tagField[a.label].select" :key="bi" v-if="b.value == scope.row[a.label]"
@@ -56,12 +79,14 @@
      <el-dialog title="编辑" :visible.sync="upDia" width="500px">
         <div class="body" v-if="upDia">
            <el-row v-for="(a, ai) in upHead" :key="ai" style="line-height: 50px;">
               <el-col :span="5" style="text-align: right;">{{a.value}}:</el-col>
               <el-col :span="17" :offset="1">
                  <el-input v-model="upData[a.label]" size="small" clearable
                     v-if="showType(a.label, data.selectField) == null"></el-input>
               <el-col :span="6" style="text-align: right;">
                  <span class="required-span" v-if="showUpReq(a.label)">* </span>{{a.value}}:
               </el-col>
               <el-col :span="16" :offset="1">
                  <el-input v-model="upData[a.label]" size="small" clearable :placeholder="`请输入${a.value}`"
                     v-if="showType(a.label, data.selectField) == null" :disabled="isDisabled(a.label)"></el-input>
                  <el-select v-model="upData[a.label]" size="small" v-if="showType(a.label, data.selectField) != null"
                     style="width: 100%;">
                     style="width: 100%;" :disabled="isDisabled(a.label)">
                     <el-option v-for="(b, bi) in data.selectField[a.label].select" :key="bi" :value="b.value"
                        :label="b.label"></el-option>
                  </el-select>
@@ -74,10 +99,11 @@
         </span>
      </el-dialog>
      <el-dialog title="新增" :visible.sync="addDia" width="500px">
         <div class="body" v-if="addDia">
         <div class="body" v-if="addDia" style="max-height: 550px;overflow-y: auto;padding: 5px 0;">
            <el-row v-for="(a, ai) in upHead" :key="ai" style="line-height: 50px;">
               <el-col :span="5" style="text-align: right;">{{a.value}}:</el-col>
               <el-col :span="17" :offset="1">
               <el-col :span="6" style="text-align: right;"><span class="required-span" v-if="showAddReq(a.label)">*
                  </span>{{a.value}}:</el-col>
               <el-col :span="16" :offset="1">
                  <el-input v-model="upData[a.label]" size="small" clearable :placeholder="`请输入${a.value}`"
                     v-if="showType(a.label, data.selectField) == null"></el-input>
                  <el-select v-model="upData[a.label]" size="small" v-if="showType(a.label, data.selectField) != null"
@@ -95,11 +121,26 @@
      </el-dialog>
      <el-dialog title="导出" :visible.sync="downDia" width="400px">
         <div style="display: flex;width: 100%;height: 100px;">
            <div class="down-left"></div>
            <div class="down-right"></div>
            <div class="down-left" @click="downFile(true)">
               <el-button>本页导出</el-button>
            </div>
            <div class="down-right" @click="downFile(false)">
               <el-button>全部导出</el-button>
            </div>
         </div>
      </el-dialog>
      <el-dialog title="数据导入" :visible.sync="uploadDia" width="500px">
         <div style="margin: 0 auto;">
            <el-upload ref="upload" drag :action="javaApi + inputUrl" :headers="token" :file-list="fileList" name="file"
               :auto-upload="false" accept=".csv" :limit="1" :on-change="beforeUpload" :on-success="onSuccess"
               :on-error="onError" :data="{param: data.uploadStr}">
               <i class="el-icon-upload"></i>
               <div class="el-upload__text">将文件拖到此处,或<em>点击上传</em></div>
            </el-upload>
         </div>
         <span slot="footer" class="dialog-footer">
            <el-button @click="downDia = false">取 消</el-button>
            <el-button @click="uploadDia = false">取 消</el-button>
            <el-button type="primary" @click="submitUpload()">上 传</el-button>
         </span>
      </el-dialog>
   </div>
@@ -120,6 +161,14 @@
            default: () => null
         },
         delUrl: {
            type: String,
            default: () => null
         },
         downUrl: {
            type: String,
            default: () => null
         },
         inputUrl: {
            type: String,
            default: () => null
         },
@@ -180,7 +229,8 @@
                  font: '删除',
                  type: 'text'
               }],
               type: []
               type: [],
               uploadStr: ""
            },
            tableHead: [],
            tableData: [],
@@ -200,7 +250,10 @@
            addUrl: null,
            addLoad: false,
            dataCopy: {},
            downDia: false
            downDia: false,
            uploadDia: false,
            token: null,
            fileList: [],
         }
      },
      watch: {
@@ -217,6 +270,9 @@
         this.data = this.componentData
         this.dataCopy = this.HaveJson(this.componentData)
         this.selectList()
         this.token = {
            'token': sessionStorage.getItem('token')
         }
      },
      methods: {
         selectChange(val) {
@@ -289,12 +345,34 @@
            var str = ob[val]
            return str == undefined ? null : ob[val].select
         },
         showAddReq(label) {
            if (this.data.requiredAdd == undefined) {
               return
            }
            for (var i = 0; i < this.data.requiredAdd.length; i++) {
               if (label == this.data.requiredAdd[i]) {
                  return true
               }
            }
            return false
         },
         showUpReq(label) {
            if (this.data.requiredUp == undefined) {
               return
            }
            for (var i = 0; i < this.data.requiredUp.length; i++) {
               if (label == this.data.requiredUp[i]) {
                  return true
               }
            }
            return false
         },
         main(row, val) {
            if (val.method == undefined) return
            else if (val.method == 'doDiy') {
               if (val.id == 'update') {
                  this.upDia = true,
                     this.upData = this.HaveJson(row)
                  this.upData = this.HaveJson(row)
                  this.upHead = this.HaveJson(this.tableHead)
                  this.upHead = this.upHead.filter(a => a.label != 'createTime' && a.label != 'updateTime')
                  delete this.upData.orderBy
@@ -352,6 +430,16 @@
               this.$message.error('请给修改请求地址')
               return
            }
            for (var i = 0; i < this.data.requiredUp.length; i++) {
               if (this.upData[this.data.requiredUp[i]] == null || this.upData[this.data.requiredUp[i]] == '') {
                  var list = this.upHead.filter(a => {
                     if (a.label == this.data.requiredUp[i]) return a
                  })
                  if (list[0].value == undefined) continue
                  this.$message.error(list[0].value + '是必填项')
                  return
               }
            }
            this.upLoad = true
            this.$axios.post(this.upUrl, this.upData, {
               headers: {
@@ -385,8 +473,10 @@
            this.upHead = this.HaveJson(this.tableHead)
            this.upHead = this.upHead.filter(a => a.label != 'createTime' && a.label != 'updateTime')
            var val = this.data.do.filter(a => a.id == 'update')[0]
            if(val == undefined) {
               val = {field: []}
            if (val == undefined) {
               val = {
                  field: []
               }
            }
            val.field.forEach(a => {
               if (JSON.stringify(this.upData[a]) == undefined) {
@@ -411,6 +501,16 @@
               this.$message.error('请给添加请求地址')
               return
            }
            for (var i = 0; i < this.data.requiredAdd.length; i++) {
               if (this.upData[this.data.requiredAdd[i]] == null || this.upData[this.data.requiredAdd[i]] == '') {
                  var list = this.upHead.filter(a => {
                     if (a.label == this.data.requiredAdd[i]) return a
                  })
                  if (list[0].value == undefined) continue
                  this.$message.error(list[0].value + '是必填项')
                  return
               }
            }
            this.addLoad = true
            this.$axios.post(this.addUrl, this.upData, {
               headers: {
@@ -430,8 +530,130 @@
               this.addLoad = false
            })
         },
         openDownDia(){
         openDownDia() {
            this.downDia = true
         },
         downFile(type) {
            if (this.downUrl == null) {
               this.$message.error('请给导出请求地址')
               return
            }
            var page = this.HaveJson(this.page)
            if (!type) {
               page.current = 0
               page.size = this.total
            }
            this.loading = true
            this.$axios.post(this.downUrl, {
               page: page,
               entity: this.data.entity
            }, {
               headers: {
                  'Content-Type': 'application/json'
               }
            }).then(res => {
               if (res.code === 201) {
                  this.loading = false
                  return
               }
               this.downDia = false
               this.loading = false
               this.$message.success('导出成功')
               let eleLink = document.createElement('a')
               eleLink.style.display = 'none'
               eleLink.download = res.data
               eleLink.href = this.javaApi + '/outPath/' + res.data
               document.body.appendChild(eleLink)
               eleLink.click()
               document.body.removeChild(eleLink)
            }).catch(e => {
               console.log(e);
               this.loading = false
               this.$message.error('请刷新页面再尝试')
            })
         },
         openUpload() {
            if (this.inputUrl == null) {
               this.$message.error('请给导入请求地址')
               return
            }
            this.uploadDia = true
         },
         beforeUpload(file, fileList) {
            if (file.raw.type != 'text/csv') {
               this.$message.error('上传文件格式不正确');
               this.$refs.upload.clearFiles()
               return false;
            }
         },
         submitUpload() {
            if (this.$refs.upload.uploadFiles.length == 0) {
               this.$message.error('未选择文件')
               return
            }
            this.uploading = true
            this.$refs.upload.submit();
         },
         onSuccess(response, file, fileList) {
            this.$refs.upload.clearFiles()
            this.uploadDia = false
            this.uploading = false
            if (response.code == 201) {
               this.$message.error(response.message)
               return
            }
            this.$message.success('上传成功')
            this.selectList()
         },
         onError(err, file, fileList) {
            this.$message.error('上传失败')
            this.$refs.upload.clearFiles()
            this.uploading = false
         },
         isDisabled(label) {
            if (this.data.disabledUp == undefined) {
               return
            }
            for (var i = 0; i < this.data.disabledUp.length; i++) {
               if (label == this.data.disabledUp[i]) {
                  return true
               }
            }
            return false
         },
         getSummaries(param) {
            const {
               columns,
               data
            } = param;
            const sums = [];
            columns.forEach((column, index) => {
               if (index === 0) {
                  sums[index] = '合计';
                  return;
               }
               const values = data.map(item => Number(item[column.property]));
               if(this.data.countFleid==undefined){
                  sums[index] = ''
                  return
               }
               if (this.data.countFleid.filter(str=>{
                  return str === column.property
               }).length > 0) {
                  sums[index] = values.reduce((prev, curr) => {
                     const value = Number(curr);
                     if (!isNaN(value)) {
                        return prev + curr;
                     } else {
                        return prev;
                     }
                  }, 0);
                  sums[index] += '';
               } else {
                  sums[index] = '';
               }
            });
            return sums;
         }
      }
   }