From 5b6c4c659710814ea5f59dcab8ac64ddd8acfe6f Mon Sep 17 00:00:00 2001
From: zhouwx <1175765986@qq.com>
Date: 星期四, 03 七月 2025 14:08:44 +0800
Subject: [PATCH] 模板导入
---
src/views/build/conpanyFunctionConsult/qualityObjectives/table/index.vue | 3
src/views/build/conpanyFunctionConsult/industryTemplate/index.vue | 158 ++++++++++++++++++++++++++++++++++++---
src/views/build/conpanyFunctionConsult/qualityObjectives/objective/index.vue | 3
src/views/build/conpanyFunctionConsult/industryTemplate/components/editDialog.vue | 26 ++++-
public/example.xls | 0
src/api/staffManage/staff.js | 9 ++
src/views/build/conpanyFunctionConsult/qualityObjectives/reportsituation/index.vue | 3
7 files changed, 177 insertions(+), 25 deletions(-)
diff --git a/public/example.xls b/public/example.xls
new file mode 100644
index 0000000..18c1d68
--- /dev/null
+++ b/public/example.xls
Binary files differ
diff --git a/src/api/staffManage/staff.js b/src/api/staffManage/staff.js
index e07231e..da52611 100644
--- a/src/api/staffManage/staff.js
+++ b/src/api/staffManage/staff.js
@@ -71,6 +71,13 @@
data: data
})
}
+export function uploadTemplate(data) {
+ return request({
+ url: '/company/industryTemplate/upload',
+ method: 'post',
+ data: data
+ })
+}
export function delSysClause(params) {
return request({
@@ -110,4 +117,4 @@
method: 'get',
params: params
})
-}
\ No newline at end of file
+}
diff --git a/src/views/build/conpanyFunctionConsult/industryTemplate/components/editDialog.vue b/src/views/build/conpanyFunctionConsult/industryTemplate/components/editDialog.vue
index a8c2cd4..6c640b6 100644
--- a/src/views/build/conpanyFunctionConsult/industryTemplate/components/editDialog.vue
+++ b/src/views/build/conpanyFunctionConsult/industryTemplate/components/editDialog.vue
@@ -19,8 +19,14 @@
</el-option>
</el-select>
</el-form-item>
- <el-form-item label="模板名称:" prop="templateName">
- <el-input v-model.trim="state.form.templateName" :disabled="state.title =='查看'" placeholder="模板名称"></el-input>
+ <el-form-item label="章节:" prop="chapter">
+ <el-input v-model.trim="state.form.chapter" :disabled="state.title =='查看'" placeholder="章节"></el-input>
+ </el-form-item>
+ <el-form-item label="文件记录:" prop="templateName">
+ <el-input v-model.trim="state.form.templateName" :disabled="state.title =='查看'" placeholder="文件记录"></el-input>
+ </el-form-item>
+ <el-form-item label="分类:" prop="type">
+ <el-input v-model.trim="state.form.type" :disabled="state.title =='查看'" placeholder="分类"></el-input>
</el-form-item>
<el-form-item label="行业:" prop="industryType">
<el-select v-model="state.form.industryType" placeholder="请选择" clearable style="width: 100%">
@@ -32,7 +38,7 @@
</el-option>
</el-select>
</el-form-item>
- <el-form-item label="模板文件:" prop="filePath">
+ <el-form-item label="模板:" prop="filePath">
<el-upload accept=".doc,.docx" :action="state.uploadUrl" :headers="state.header" method="post" :on-success="(res, uploadFile)=>handleAvatarSuccess(res, uploadFile)" :on-exceed="showTip" :limit='state.fileLimit' v-model:file-list="state.fileList" :before-upload="picSize" :on-remove="(file, uploadFiles)=>handleRemove(file, uploadFiles)" >
<el-button type="primary">点击上传</el-button>
<template #tip>
@@ -80,13 +86,17 @@
filePath: '',
fileName: '',
format: '',
- companyId: null
+ companyId: null,
+ type: '',
+ chapter: ''
},
formRules:{
companyId: [{ required: true, message: '请选择企业', trigger: 'blur' }],
- templateName: [{ required: true, message: '请输入模板名称', trigger: 'blur' }],
+ templateName: [{ required: true, message: '请输入文件记录', trigger: 'blur' }],
industryType: [{ required: true, message: '请选择行业类型', trigger: 'blur' }],
- filePath: [{ required: true, validator: checkFiles, trigger: 'blur' }]
+ filePath: [{ required: true, validator: checkFiles, trigger: 'blur' }],
+ chapter: [{ required: true, message: '请输入章节', trigger: 'blur' }],
+ type: [{ required: true, message: '请输入分类', trigger: 'blur' }],
},
isAdmin: false,
companyList: [],
@@ -223,7 +233,9 @@
filePath: '',
fileName: '',
format: '',
- companyId: null
+ companyId: null,
+ type: '',
+ chapter: ''
}
state.fileList = []
superRef.value.clearValidate();
diff --git a/src/views/build/conpanyFunctionConsult/industryTemplate/index.vue b/src/views/build/conpanyFunctionConsult/industryTemplate/index.vue
index 632ba9c..f53ebab 100644
--- a/src/views/build/conpanyFunctionConsult/industryTemplate/index.vue
+++ b/src/views/build/conpanyFunctionConsult/industryTemplate/index.vue
@@ -30,22 +30,29 @@
</el-option>
</el-select>
</el-form-item>
+ <el-form-item label="分类：" >
+ <el-input v-model.trim="data.queryParams.type" placeholder="请输入"></el-input>
+ </el-form-item>
<el-form-item >
- <el-button v-if="isAdmin" type="primary" @click="getList">查询</el-button>
- <el-button v-if="isAdmin" type="primary" plain @click="reset">重置</el-button>
+ <el-button type="primary" @click="getList">查询</el-button>
+ <el-button type="primary" plain @click="reset">重置</el-button>
+ <el-button type="primary" @click="exportData">导入</el-button>
</el-form-item>
</el-form>
</div>
<!-- 表格数据 -->
<el-table v-loading="loading" :data="dataList" :border="true">
<el-table-column label="序号" type="index" align="center" width="80"/>
- <el-table-column label="模板名称" prop="templateName" align="center"/>
+ <el-table-column label="章节" prop="chapter" align="center"/>
+ <el-table-column label="文件记录" prop="templateName" align="center"/>
<el-table-column label="行业" prop="industryName" align="center" />
- <el-table-column label="模板文件" prop="fileName" align="center">
+ <el-table-column label="模板" prop="fileName" align="center">
<template #default="scope">
<el-link style="" type="primary" @click="downloadFile(scope.row)">{{scope.row.fileName}}</el-link>
</template>
</el-table-column>
+
+ <el-table-column label="分类" prop="type" align="center" />
<el-table-column label="操作" align="center" class-name="small-padding fixed-width" >
<template #default="scope">
<el-button link type="primary" @click="openDialog('edit',scope.row)">编辑</el-button>
@@ -63,6 +70,39 @@
/>
<edit-dialog ref="dialogRef" @getList=getList></edit-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" :icon="Download" type="primary" plain>下载模板</el-button>
+ </el-form-item>
+ <el-form-item label="导入文件">
+ <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 :icon="Upload" 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>
@@ -70,12 +110,13 @@
import {getCurrentInstance, onMounted, onUnmounted, reactive, ref, toRefs} from "vue";
import {ElMessage, ElMessageBox} from "element-plus";
import {delCompany, getCompany} from "@/api/onlineEducation/company";
+import { Plus, Upload, Download} from '@element-plus/icons-vue';
import {delUser, getUser} from "@/api/onlineEducation/user";
import Cookies from "js-cookie";
import editDialog from './components/editDialog.vue'
import {
delIndustryTemp,
- getIndustryTemp,
+ getIndustryTemp, uploadTemplate,
} from "@/api/staffManage/staff";
import useUserStore from "@/store/modules/user";
import axios from "axios";
@@ -85,20 +126,42 @@
const { proxy } = getCurrentInstance();
const loading = ref(false);
const dialogRef = ref();
+const checkFiles = (rule, value, callback) => {
+ if (state.exportFileList.length == 0) {
+ callback(new Error('请上传导入文件'))
+ } else {
+ callback()
+ }
+}
const data = reactive({
queryParams: {
pageNum: 1,
pageSize: 10,
companyId: null,
- industryType: null
+ industryType: null,
+ type: ''
},
total: 0,
dataList: [],
companyList: [],
industryList: [],
isAdmin: false,
- typeList: []
+ typeList: [],
+ exportDialog: false,
+
});
+const state = reactive({
+ form: {
+ id: null,
+ filePath: '',
+ companyId: null
+ },
+ formRules:{
+ companyId: [{ required: true, message: '请选择企业', trigger: 'blur' }],
+ filePath: [{ required: true, validator: checkFiles, trigger: 'blur' }]
+ },
+ exportFileList: [],
+})
const { queryParams, total, dataList,companyList,industryList, isAdmin } = toRefs(data);
const userInfo = ref()
@@ -123,7 +186,7 @@
loading.value = true
const res = await getIndustryTemp(data.queryParams)
if(res.code == 200){
- data.dataList = res.data.list || []
+ data.dataList = res.data.list
data.total = res.data.total
}else{
ElMessage.warning(res.message)
@@ -177,15 +240,81 @@
dialogRef.value.openDialog(type, value, data.queryParams.companyId, data.isAdmin, data.companyList);
}
+const exportData = () => {
+ 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 downloadFileTable = () => {
+ const filePath = '/example.xls';
+ const link = document.createElement('a');
+ link.href = filePath;
+ link.download = filePath.substr(filePath.lastIndexOf('/') + 1);
+ link.click();
+}
+const fileBinaryList = ref([])
+const handleChange = (file, files) => {
+ fileBinaryList.value = files;
+};
+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
+ });
+ }
+ }
+}
+
/** 重置新增的表单以及其他数据 */
const reset= async()=> {
- data.queryParams = {
- pageNum: 1,
- pageSize: 10,
- companyId: null,
- industryType: null
+ if(data.isAdmin){
+ data.queryParams = {
+ pageNum: 1,
+ pageSize: 10,
+ companyId: null,
+ industryType: null,
+ type: ''
+ }
+ await getCompanyList()
+ }else {
+ data.queryParams = {
+ pageNum: 1,
+ pageSize: 10,
+ companyId: data.queryParams.companyId,
+ industryType: null,
+ type: ''
+ }
}
- await getCompanyList()
await getList()
}
const handleDelete = (val) => {
@@ -208,4 +337,5 @@
})
}
+
</script>
diff --git a/src/views/build/conpanyFunctionConsult/qualityObjectives/objective/index.vue b/src/views/build/conpanyFunctionConsult/qualityObjectives/objective/index.vue
index 8897cfa..5c056b1 100644
--- a/src/views/build/conpanyFunctionConsult/qualityObjectives/objective/index.vue
+++ b/src/views/build/conpanyFunctionConsult/qualityObjectives/objective/index.vue
@@ -281,6 +281,7 @@
}
choosedData.value = []
data.companyList = [];
+ getCompanyList()
}else {
data.queryParams = {
companyId: data.queryParams.companyId,
@@ -291,7 +292,7 @@
}
}
getList();
- getCompanyList()
+
}
const exportData = () => {
if(choosedData.value && choosedData.value.length === 0){
diff --git a/src/views/build/conpanyFunctionConsult/qualityObjectives/reportsituation/index.vue b/src/views/build/conpanyFunctionConsult/qualityObjectives/reportsituation/index.vue
index 1b0ce6e..8a6edce 100644
--- a/src/views/build/conpanyFunctionConsult/qualityObjectives/reportsituation/index.vue
+++ b/src/views/build/conpanyFunctionConsult/qualityObjectives/reportsituation/index.vue
@@ -339,6 +339,7 @@
}
choosedData.value = []
data.companyList = [];
+ getCompanyList()
}else {
data.queryParams = {
companyId: data.queryParams.companyId,
@@ -349,7 +350,7 @@
}
}
getList();
- getCompanyList()
+
}
const exportData = () => {
if(choosedData.value && choosedData.value.length === 0){
diff --git a/src/views/build/conpanyFunctionConsult/qualityObjectives/table/index.vue b/src/views/build/conpanyFunctionConsult/qualityObjectives/table/index.vue
index 15fd5a0..2e24d96 100644
--- a/src/views/build/conpanyFunctionConsult/qualityObjectives/table/index.vue
+++ b/src/views/build/conpanyFunctionConsult/qualityObjectives/table/index.vue
@@ -310,6 +310,7 @@
}
choosedData.value = []
data.companyList = [];
+ getCompanyList()
}else {
data.queryParams = {
companyId: data.queryParams.companyId,
@@ -320,7 +321,7 @@
}
}
getList();
- getCompanyList()
+
}
const exportData = () => {
if(choosedData.value && choosedData.value.length === 0){
--
Gitblit v1.9.2