ImportForm.vue 11.8 KB
<template>
  <el-dialog title="批量导入" :close-on-click-modal="false" :visible.sync="visible"
    class="NCC-dialog NCC-dialog_center" lock-scroll width="1000px">
    <el-steps :active="active" align-center>
      <el-step title="上传文件"></el-step>
      <el-step title="数据预览"></el-step>
      <el-step title="导入数据"></el-step>
    </el-steps>
    <div class="import-main" v-show="active==1">
      <div class="upload">
        <div class="up_left">
          <img src="@/assets/images/upload.png">
        </div>
        <div class="up_right">
          <p class="title">上传填好的数据表</p>
          <p class="tip">文件后缀名必须是xls或xlsx,文件大小不超过500KB,最多支持导入1000条数据</p>
          <el-upload :action="define.comUrl+'/api/extend/Employee/Uploader'"
            :headers="{ Authorization: $store.getters.token}" :on-success="handleSuccess"
            :on-remove="handleRemove" :before-remove="beforeRemove" :on-change="handleChange"
            :file-list="fileList" accept=".xls,.xlsx" :before-upload="beforeUpload"
            class="upload-area">
            <el-button type="text">上传文件</el-button>
          </el-upload>
        </div>
      </div>
      <div class="upload">
        <div class="up_left">
          <img src="@/assets/images/import.png">
        </div>
        <div class="up_right">
          <p class="title">填写导入数据信息</p>
          <p class="tip">请按照数据模板的格式准备导入数据,模板中的表头名称不可更改,表头行不能删除</p>
          <el-button type="text" @click="templateDownload">下载模板</el-button>
        </div>
      </div>
    </div>
    <div class="import-main" v-show="active==2">
      <NCC-table v-loading="listLoading" :data="list">
        <el-table-column prop="enCode" label="工号" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.enCode" />
          </template>
        </el-table-column>
        <el-table-column prop="fullName" label="姓名" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.fullName" />
          </template>
        </el-table-column>
        <el-table-column prop="gender" label="性别" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.gender" />
          </template>
        </el-table-column>
        <el-table-column prop="departmentName" label="部门" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.departmentName" />
          </template>
        </el-table-column>
        <el-table-column prop="positionName" label="岗位" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.positionName" />
          </template>
        </el-table-column>
        <el-table-column prop="workingNature" label="用工性质" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.workingNature" />
          </template>
        </el-table-column>
        <el-table-column prop="idNumber" label="身份证号" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.idNumber" />
          </template>
        </el-table-column>
        <el-table-column prop="telephone" label="联系电话" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.telephone" />
          </template>
        </el-table-column>
        <el-table-column prop="birthday" label="出生年月" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.birthday" />
          </template>
        </el-table-column>
        <el-table-column prop="attendWorkTime" label="参加工作" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.attendWorkTime" />
          </template>
        </el-table-column>
        <el-table-column prop="education" label="最高学历" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.education" />
          </template>
        </el-table-column>
        <el-table-column prop="major" label="所学专业" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.major" />
          </template>
        </el-table-column>
        <el-table-column prop="graduationAcademy" label="毕业院校" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.graduationAcademy" />
          </template>
        </el-table-column>
        <el-table-column prop="graduationTime" label="毕业时间" width="150">
          <template slot-scope="scope">
            <el-input v-model="scope.row.graduationTime" />
          </template>
        </el-table-column>
        <el-table-column label="操作" fixed="right" width="50">
          <template slot-scope="scope">
            <el-button size="mini" type="text" class="NCC-table-delBtn"
              @click="handleDel(scope.$index)">删除</el-button>
          </template>
        </el-table-column>
      </NCC-table>
    </div>
    <div class="import-main" v-show="active==3">
      <div class="success" v-if="!result.resultType">
        <img src="@/assets/images/success.png" alt="">
        <p class="success-title">批量导入成功</p>
        <p class="success-tip">您已成功导入{{result.snum}}条数据</p>
      </div>
      <div class="unsuccess" v-if="result.resultType">
        <el-alert title="错误提醒:导入失败数据展示" type="warning" show-icon :closable="false" />
        <div class="upload error-show">
          <div class="up_left">
            <img class="" src="@/assets/images/tip.png">
          </div>
          <div class="up_right">
            <p class="tip">正常数量条数:<el-link type="success" :underline="false">{{result.snum}}条
              </el-link>
            </p>
            <p class="tip">异常数量条数:<el-link type="danger" :underline="false">{{result.fnum}}条
              </el-link>
            </p>
          </div>
        </div>
        <p class="contips">以下文件数据为导入异常数据</p>
        <NCC-table :data="resultList" height="280px">
          <el-table-column prop="enCode" label="工号" width="100" />
          <el-table-column prop="fullName" label="姓名" width="100" />
          <el-table-column prop="gender" label="性别" width="80" />
          <el-table-column prop="departmentName" label="部门" width="120" />
          <el-table-column prop="positionName" label="岗位" width="120" />
          <el-table-column prop="workingNature" label="用工性质" width="100" />
          <el-table-column prop="idNumber" label="身份证号" width="150" />
          <el-table-column prop="telephone" label="联系电话" width="100" />
          <el-table-column prop="birthday" label="出生年月" width="100" />
          <el-table-column prop="attendWorkTime" label="参加工作" width="100" />
          <el-table-column prop="education" label="最高学历" width="100" />
          <el-table-column prop="major" label="所学专业" width="120" />
          <el-table-column prop="graduationAcademy" label="毕业院校" width="150" />
          <el-table-column prop="graduationTime" label="毕业时间" width="100" />
        </NCC-table>
      </div>
    </div>
    <span slot="footer" class="dialog-footer">
      <el-button @click="cancle()" v-if="active == 1">取 消</el-button>
      <el-button @click="prev" v-if="active == 2">上一步</el-button>
      <el-button @click="next" type="primary" v-if="active < 3" :loading="btnLoading">下一步
      </el-button>
      <el-button @click="cancle(true)" type="primary" v-else>关 闭</el-button>
    </span>
  </el-dialog>
</template>

<script>
import { TemplateDownload, ImportData, ImportPreview } from '@/api/extend/employee'
export default {
  data() {
    return {
      visible: false,
      btnLoading: false,
      listLoading: false,
      fileName: '',
      fileList: [],
      active: 1,
      list: [],
      resultList: [],
      result: {
        resultType: 0,
        snum: 0,
        fnum: 0
      }
    }
  },
  methods: {
    prev() {
      if (this.active == 1) return
      this.active--
    },
    next() {
      if (this.active == 2) {
        if (!this.list.length) return this.$message({ message: '导入数据为空', type: 'warning' })
        this.btnLoading = true
        ImportData({ list: this.list }).then(res => {
          console.log(res);
          this.result = res.data
          this.resultList = res.data.failResult
          this.btnLoading = false
          this.active++
        }).catch(() => { this.btnLoading = false })
      }
      if (this.active == 1) {
        if (!this.fileList.length || !this.fileName) return this.$message({ message: '请先上传文件', type: 'warning' })
        this.btnLoading = true
        ImportPreview({ fileName: this.fileName }).then(res => {
          this.list = res.data.dataRow
          this.btnLoading = false
          this.active++
        }).catch(() => { this.btnLoading = false })
      }
    },
    cancle(isRefresh) {
      this.visible = false
      if (isRefresh) this.$emit('refresh')
    },
    init() {
      this.active = 1
      this.fileList = []
      this.fileName = ''
      this.visible = true
    },
    handleDel(index) {
      this.list.splice(index, 1)
    },
    templateDownload() {
      TemplateDownload().then(res => {
        if (!res.data.url) return
        window.location.href = this.define.comUrl + res.data.url
      })
    },
    beforeUpload(file) {
      let isRightSize = file.size / 1024 < 500
      if (!isRightSize) this.$message.error(`文件大小不能超过500KB`)
      return isRightSize
    },
    handleRemove(file, fileList) {
      this.fileList = []
    },
    beforeRemove(file, fileList) {
      return this.$confirm(`确定移除 ${file.name}?`).catch(() => { })
    },
    handleChange(file, fileList) {
      this.fileList = fileList.slice(-1)
    },
    handleSuccess(res, file, fileList) {
      if (res.code == 200) {
        this.fileList = fileList.slice(-1)
        this.fileName = res.data.name
      } else {
        this.fileList = fileList.filter(o => o.uid != file.uid)
        this.$message({ message: res.msg, type: 'error', duration: 1000 })
      }
    }
  }
}
</script>
<style lang="scss" scoped>
::v-deep .el-dialog__body {
  padding: 20px 40px 2px !important;
}
.import-main {
  height: 500px;
  margin-top: 20px;
  overflow: hidden;
  position: relative;
  .upload {
    display: flex;
    border: 1px solid #dcdfe6;
    margin-bottom: 25px;
    &.error-show {
      margin-top: 10px;
      margin-bottom: 15px;
      .up_left {
        height: 120px;
      }
      .up_right {
        padding-top: 20px;
        font-size: 16px;
        ::v-deep .el-link {
          font-size: 16px;
        }
      }
    }
    .up_left {
      width: 126px;
      height: 140px;
      background: #f9f9f9;
      text-align: center;
      padding-top: 20px;
      flex-shrink: 0;
      img {
        width: 80px;
        height: 80px;
      }
    }

    .up_right {
      color: #333;
      margin-left: 30px;
      font-size: 14px;
      padding-top: 30px;
      flex: 1;

      .title {
        font-size: 18px;
        font-weight: bold;
      }
      .tip {
        margin: 15px 0;
      }
    }
    .upload-area {
      display: flex;
      padding-right: 200px;
      ::v-deep {
        .el-upload {
          margin-right: 50px;
          flex-shrink: 0;
        }
        .el-upload-list {
          flex: 1;
        }
        .el-upload-list__item:first-child {
          margin-top: 5px;
        }
      }
    }
  }
  .success {
    display: flex;
    flex-direction: column;
    align-items: center;
    margin-top: 110px;
    .success-title {
      margin: 20px 0;
      font-size: 18px;
      font-weight: bold;
    }
  }
  .contips {
    margin-bottom: 15px;
  }
}
</style>