文件上传,简单好用,直接拿走

啥话不说,直接上代码,封装好的,直接拿走

<template>
  <div>
    <el-dialog title="批量导入" :visible.sync="visible" width="500px" :append-to-body="true" :close-on-click-modal="false"
               :modal-append-to-body="true" :before-close="close" @open="open" destroy-on-close>
      <el-form ref="form" :model="form" label-width="80px" :rules="rules">
        <el-form-item label="纳税类别" prop="fileName">
          <div>
            <span style="color: rgba(0, 0, 0, 0.65)" class="fs-14">请先下载模版,编辑完成后再导入</span>
            <el-button type="text" icon="el-icon-download" class="ml-5 fs-14" @click="downloadTemplate">下载模版</el-button>
          </div>
          <el-upload action="" :http-request="(e) =>{uploadFile(e, form.file)}" :show-file-list="false" accept="application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
                     v-if="!form.fileName">
            <el-button type="primary" plain icon="el-icon-upload2" class="upload-btn">上传文件</el-button>
          </el-upload>
          <div class="fs-14" v-else>
            <a style="text-decoration: underline">{{ form.fileName }}</a>
            <i class="el-icon-circle-close ml-5 cursor" @click="clearFile"></i>
          </div>
        </el-form-item>
      </el-form>
      <span slot="footer">
        <el-button size="small" @click="close">取消</el-button>
        <el-button size="small" type="primary" @click="submit" :loading="loading">确定</el-button>
      </span>
    </el-dialog>

    <el-dialog title="导入结果" :visible.sync="result" width="500px" :append-to-body="true" :close-on-click-modal="false"
               :modal-append-to-body="true"   destroy-on-close>
      <img v-if="wrongNum===0" width src="@/assets/img/user/success.png" alt="">
      <img v-else  width src="@/assets/img/user/error.png" alt="">
      <div class="text-box">导入文档<el-button size="small" type="text">{{form.fileName}}</el-button>共{{total}}条数据,成功{{ correctNum }}条,错误{{wrongNum}}条</div>
      <div class="text-box" v-if="wrongNum"><el-button size="small" type="text" @click="handleExport">导出错误结果文件</el-button>— — — — — 修改完成然后<el-button size="small" type="text" @click="uploadAgain">再次上传</el-button></div>
      <span slot="footer">
        <el-button size="small" @click="closeFn">取消</el-button>
        <el-button size="small" type="primary" @click="closeFn" >确定</el-button>
      </span>
    </el-dialog>
  </div>
</template>

<script>
import { setFocus } from '@/api'
export default {
  data () {
    return {
      result: false,
      form: {
        fileName: '', // 用来表单验证的文件名称
        file: '' // 员工文件
      },
      wrongUrl: '',
      loading: false,
      rules: {
        fileName: []
      },
      total: 0,
      wrongNum: 0,
      correctNum: 0,
      correctList: [],
      wrongList: []
    }
  },
  props: {
    // 控制弹窗显隐
    visible: {
      type: Boolean,
      default: false
    }
  },
  methods: {
    // 再次上传
    uploadAgain () {
      this.closeFn()
      this.$emit('update:visible', true)
    },
    closeFn () {
      this.result = false
      this.reset()
    },
    // 打开弹窗时触发
    open () {
      this.$nextTick(() => {
        this.$refs.form.clearValidate()
        this.reset()
      })
    },
    // 上传图片
    uploadFile (e) {
      const fileName = e.file.name
      let fileType
      const i = fileName.lastIndexOf('.')
      if (i > -1) {
        fileType = fileName.slice(i + 1)
      }
      if (!['xls', 'xlsx'].includes(fileType)) {
        this.$message.error('上传文件有误,只支持xls、xlsx文件!')
        return
      }
      this.form.fileName = fileName
      this.form.file = e.file
    },
    // 删除文件
    clearFile () {
      this.form.file = ''
      this.form.fileName = ''
    },
    close () {
      this.$emit('update:visible', false)
      this.reset()
    },
    // 确认
    submit () {
      if (!this.form.fileName || this.form.fileName === '') return this.$message.error('请上传纳税类别文件')
      this.$refs.form.validate(async (valid) => {
        if (valid) {
          this.loading = true
          const { data } = await this.$http.postFormData(setFocus.importTestData, { multipartFile: this.form.file })
          if (data.code === '1') {
            console.log(data)
            this.total = data.data.total
            this.wrongNum = data.data.wrongNum
            this.wrongUrl = data.data.wrongUrl
            this.correctNum = data.data.correctNum
            this.result = true
            this.$emit('auto')
            console.log(this.wrongNum)
            // this.$parent.getDataList()
          } else if (data.code + '' === '555') {
            this.$message.error(data.msg)
          } else {
            this.$message.error('数据导入失败')
          }
          this.loading = false
          this.$emit('update:visible', false)
        } else {
          return false
        }
      })
    },
    // 重置
    reset () {
      this.form = this.$options.data().form
    },
    // 导出
    handleExport () {
      // this.$http.post(taxSubmit.exportList, this.form, { responseType: 'blob' }).then((res) => {
      //   if (res.data.code + '' === '500') {
      //     this.$message.error(res.data.msg)
      // } else {
      // const blob = new Blob([this.wrongUrl], {
      //   type: 'application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
      // })
      const fileName = '错误结果文件.xlsx'
      if ('download' in document.createElement('a')) {
        // 支持a标签download的浏览器
        const link = document.createElement('a') // 创建a标签
        link.download = fileName // a标签添加属性
        link.style.display = 'none'
        link.href = this.wrongUrl
        document.body.appendChild(link)
        link.click() // 执行下载
        URL.revokeObjectURL(link.href) // 释放url
        document.body.removeChild(link) // 释放标签
      } else {
        navigator.msSaveBlob(this.wrongUrl, fileName)
      }
      // }
      // })
    },
    // 下载模板
    downloadTemplate () {
      const link = document.createElement('a') // 创建a标签
      link.download = '算税类别模板.xlsx' // 由于下方的下载链接会跨域,所以此处的download属性失效,文件名并不会修改,如有需求,可以使用new XMLHttpRequest()解决
      link.style.display = 'none'
      link.href = 'http://lsqk.oss-cn-beijing.aliyuncs.com/%E7%BA%B3%E7%A8%8E%E7%B1%BB%E5%88%AB%E4%BF%A1%E6%81%AF%E6%A8%A1%E6%9D%BF.xlsx'
      document.body.appendChild(link)
      link.click() // 执行下载
      document.body.removeChild(link) // 释放标签
    }
  }
}
</script>

<style scoped lang="scss">
.upload-btn {
  width: 200px;
  height: 40px;
  background: #f9ffff;
  border: 1px dotted #00b5b9;
}

.remark {
  padding: 12px 26px;
  border: 1px dashed #d9d9d9;

  > div {
    .el-icon-warning {
      color: #faad14;
      font-size: 19px;
      margin-right: 6px;
    }

    span {
      font-size: 16px;
      font-weight: bold;
    }
  }

  > ul {
    list-style: none;
    padding-left: 26px;
    margin: 0;
    > li {
      margin-top: 9px;
    }
  }
}

::v-deep .el-checkbox__label,
::v-deep .el-checkbox__input.is-checked + .el-checkbox__label {
  color: rgba(0, 0, 0, 0.65);
}

::v-deep .el-dialog {
  .el-dialog__header {
    border-bottom: 1px solid #f0eff2;
  }

  .el-dialog__body {
    padding: 40px 50px 0;
    text-align: center;
  }

  .el-dialog__footer {
    padding: 24px;
    text-align: right;
  }
}
.prompt-img{
  margin: 0 auto;
  width: 50px;
  height: 50px;
  border-radius: 50%;
  background-color: red;
}
.text-box{
  text-align: center;
}
::v-deep .el-form-item__content{
  margin-left: 0 !important;
}
</style>

2.引入直接使用

// 引入
import importTestData from 
'@/views/set-focus/ratepaying/component/importTestData.vue'

// components: { importTestData },


<importTestData :visible.sync="visible" @auto="auto"/>

<el-button type="primary" size="small" @click="importFn">批量导入</el-button>



 importFn () {
      this.visible = true
    },

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值