中科大支线—用户导入

zhouwx

yesterday 398794afbbe0696e763aa002313dcf4c3b82420c

中科大支线—用户导入

 .env.development

@@ -7,6 +7,6 @@
# 危化品全生命周期管理/开发环境

#董
#VITE_APP_BASE_API = 'http://192.168.2.152:8083/api'
VITE_APP_BASE_API = 'http://192.168.2.152:8005/api'
#线上
VITE_APP_BASE_API = 'http://106.15.95.149:8005/api'
#VITE_APP_BASE_API = 'http://106.15.95.149:8005/api'

 public/files/userExcel.xlsx

Binary files differ

 src/api/hazardousChemicals/user.js

@@ -45,3 +45,11 @@
        method: 'put'
    })
}

export function uploadTemplate(data) {
    return request({
        url: '/system/user/importExcel',
        method: 'post',
        data: data
    })
}

 src/views/hazardousChemicals/systemManage/user/index.vue

@@ -23,6 +23,10 @@
              plain
              @click="reset"
          >重置</el-button>
          <el-button
              type="primary"
              @click="exportUser"
          >导入</el-button>
        </el-form-item>
      </el-form>
    </div>
@@ -61,6 +65,39 @@
    />

    <user-dialog ref="dialogRef" @getList=getList></user-dialog>
    <el-dialog
        v-model="data.exportDialog"
        title="导入模板"
        width="550px"
        :before-close="handleCloseExport"
        :close-on-press-escape="false"
        :close-on-click-modal="false"
    >
      <el-form :model="state.form" size="default" ref="superRef" :rules="state.formRules" label-width="110px" >
        <el-form-item  label="表格模板：" >
          <el-button @click="downloadFileTable" size="default"  type="primary" plain>下载模板</el-button>
        </el-form-item>
        <el-form-item label="导入文件" prop="filePath">
          <el-upload
              accept=".xlsx,.xls"
              :before-upload="beforeUpload"
              v-model:file-list="state.exportFileList"
              action="#"
              :auto-upload="false"
              :on-change="handleChange"
              style="width: 100%"
          >
            <el-button  size="default" type="primary">点击上传</el-button>
          </el-upload>
        </el-form-item>
      </el-form>
      <template #footer>
        <span class="dialog-footer">
          <el-button @click="handleCloseExport" size="default">取 消</el-button>
          <el-button  type="primary" @click="onUpload" size="default">确定</el-button>
        </span>
      </template>
    </el-dialog>
  </div>
</template>

@@ -68,7 +105,7 @@
import {getCurrentInstance, onMounted, onUnmounted, reactive, ref, toRefs} from "vue";
import {ElMessage, ElMessageBox} from "element-plus";
import userDialog from './components/userDialog.vue'
import {delUser, getUser} from "@/api/hazardousChemicals/user";
import {delUser, getUser, uploadTemplate} from "@/api/hazardousChemicals/user";
import Cookies from "js-cookie";


@@ -84,6 +121,7 @@
  },
  total: 0,
  dataList: [],
  exportDialog: false,
  userTypeList: [
    {
      id: 0,
@@ -109,6 +147,18 @@

});

const state = reactive({
  form: {
    id: null,
    filePath: '',
    companyId: null
  },
  formRules:{
    companyId: [{ required: true, message: '请选择企业', trigger: 'blur' }],
    filePath: [{ required: true, message: '请上传文件', trigger: 'blur' }]
  },
  exportFileList: [],
})
const isAdmin = ref(false)
const { queryParams, total, dataList } = toRefs(data);
const userInfo = ref()
@@ -168,5 +218,57 @@
        }
      })
}

const exportUser = () => {
  data.exportDialog = true
}
const handleCloseExport = () => {
  state.exportFileList = []
  data.exportDialog = false
}
const beforeUpload = (file) => {
  state.exportFileList = [...state.exportFileList, file]
  state.exportFileList = state.exportFileList.slice(-1)
  return false;
}
const fileBinaryList = ref([])
const handleChange = (file, files) => {
  fileBinaryList.value = files;
};
const downloadFileTable = () => {
  const filePath = '/files/userExcel.xlsx';
  const link = document.createElement('a');
  link.href = filePath;
  link.download = filePath.substr(filePath.lastIndexOf('/') + 1);
  link.click();
}
const onUpload = async () => {
  if(state.exportFileList.length == 0){
    ElMessage({
      type: 'warning',
      message: '请先上传表格文件'
    });
    return
  }else{
    const formData = new FormData();
    fileBinaryList.value.forEach((file) => {
      formData.append('file', file.raw)
    })
    console.log('form',formData)
    const res = await uploadTemplate(formData)
    if(res.code == 200){
      ElMessage({
        type: 'success',
        message: '导入成功'
      });
      state.exportFileList = []
      data.exportDialog = false
      await getList()
    }else{
      ElMessage({
        type: 'error',
        message: res.message
      });
    }
  }
}
</script>