index.vue 5.18 KB
<template>
  <div style="margin: 20px">
    <el-form :inline="true" :model="form" class="demo-form-inline" size="small">
      <el-form-item label="航班种类">
        <el-select v-model="form.type" placeholder="航班种类">
          <el-option
            v-for="item in flightType"
            :key="item.id"
            :label="item.englishName"
            :value="item.code"
            >{{ item.englishName }}</el-option
          >
        </el-select>
      </el-form-item>
      <el-form-item>
        <el-upload
          action="/flightInfoImport/importFlight"
          name="file"
          :http-request="uploadExcel"
          :on-remove="handleRemove"
          :limit="1"
          :on-exceed="handleExceed"
          :file-list="fileList"
          accept=".xlsx"
          class="upload-demo"
          v-hasPermi="['base:flightImport:importFlight']"
        >
          <el-button type="primary">点击上传</el-button>
        </el-upload>
      </el-form-item>
      <el-form-item>
        <el-button type="primary" @click="downloadTempleate" v-hasPermi="['base:flightImport:exportExcel']"
          >下载模板</el-button
        >
      </el-form-item>
    </el-form>
    <div style="font-size: 12px; font-weight: 700">
      提示:<span style="color: #1890ff">以下为所提交的数据或出错信息</span>
    </div>
    <el-table
      ref="filterTable"
      :data="tableData"
      style="margin-top: 20px"
      size="small"
      border
    >
      <el-table-column label="行号" prop="line" fixed width="50" align="center">
      </el-table-column>
      <el-table-column label="错误信息" prop="errorMessage" fixed width="200">
        <template slot-scope="scope">
          <div v-for="(m, key) in scope.row.errorMessage" :key="key">
            {{ m }}
          </div>
        </template>
      </el-table-column>
      <el-table-column v-if="tableData.length == 0"></el-table-column>
      <el-table-column
        v-for="(value, key) in this.tableData[0]"
        :key="key"
        v-if="key != 'errorMessage' && key != 'line'"
        :label="key"
        :prop="key"
        width="120"
      ></el-table-column>
    </el-table>
  </div>
</template>

<script>
import {
  filghtKindData,
  downLoadTemplate,
  importFlight,
} from "@/api/flightInfoImport";
export default {
  name:"FlightInformationImport",
  data() {
    return {
      flightType: [],
      form: {
        type: "",
        region: "",
      },
      fileList: [],
      tableData: [],
    };
  },
  methods: {
    downloadTempleate() {
      let downloadType = "";
      let fileName = "";
      switch (this.form.type) {
        case "flightKind20":
          downloadType = "whiteTail";
          fileName = "航班信息导入模板WhiteTail.xlsx";
          break;
        case "flightKind30":
          downloadType = "purpleTail";
          fileName = "航班信息导入模板PurpleTail.xlsx";
          break;
        default:
          this.$confirm("此类航班暂无模板,请选择其他类型航班", "提示", {
            confirmButtonText: "确定",
            showCancelButton: false,
            type: "warning",
          });
      }
      if (downloadType != "") {
        downLoadTemplate(downloadType).then((res) => {
          if (res) {
            const blob = new Blob([res]);
            const link = document.createElement("a"); //创建a标签
            link.download = fileName; //a标签添加属性
            link.style.display = "none";
            link.href = URL.createObjectURL(blob);
            document.body.appendChild(link);
            link.click(); //执行下载
            URL.revokeObjectURL(link.href); //释放url
            document.body.removeChild(link); //释放标签
          } else {
            this.$message.error("下载失败");
          }
        });
      }
    },
    uploadExcel(option) {
      //上传excel
      const file = option.file;
      console.log(option);
      importFlight(file, this.form.type).then((res) => {
        if (res.code != 200) {
          if (res.code == 603) {
            this.$alert(res.msg , "提示", {
              confirmButtonText: "确定",
              type: "warning",
            });
          }else {
            this.$message.error(res.msg);
            this.tableData = res.data;
          }
        } else {
          this.$message.success("导入成功");
          this.tableData = res.data;
        }
      });
    },
    handleRemove(file, fileList) {
      //清掉上传的文件
      this.tableData = [];
      this.fileList = [];
    },
    handleExceed(files) {
      //重复上传文件
      let file = {};
      file.file = files[0];
      file.name = files[0].name;
      this.fileList = [];
      this.fileList.push(file);
      this.uploadExcel(file);
    },
  },
  created() {
    filghtKindData().then((response) => {
      if (response.code != 200) {
        this.$message({
          message: response.msg,
          type: "error",
        });
      }
      this.flightType = response.data;
      this.form.type = response.data[0].code;
    });
  },
};
</script>
<style rel="stylesheet/scss" lang="scss">
.upload-demo {
  float: right;
}
.el-upload-list {
  display: inline-block;
  margin-left: 10px;
  vertical-align: top;
}
</style>