From 4487fbf1c128a877108b2add0f2d4897c573bf53 Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期日, 24 三月 2024 21:44:32 +0800 Subject: [PATCH] 导入模板下载 --- src/utils/download.js | 15 +++++++ src/utils/request.js | 17 ++++++++ src/views/exam/question/list.vue | 32 ++++++++++----- src/api/question.js | 5 +- 4 files changed, 55 insertions(+), 14 deletions(-) diff --git a/src/api/question.js b/src/api/question.js index f28d6ce..a57710b 100644 --- a/src/api/question.js +++ b/src/api/question.js @@ -1,8 +1,9 @@ -import { post } from '@/utils/request' +import { post, download } from '@/utils/request' export default { pageList: query => post('/api/admin/question/page', query), edit: query => post('/api/admin/question/edit', query), select: id => post('/api/admin/question/select/' + id), - deleteQuestion: id => post('/api/admin/question/delete/' + id) + deleteQuestion: id => post('/api/admin/question/delete/' + id), + downloadImportTemplate: () => download('/api/admin/question/download/question/import/temp') } diff --git a/src/utils/download.js b/src/utils/download.js new file mode 100644 index 0000000..713e178 --- /dev/null +++ b/src/utils/download.js @@ -0,0 +1,15 @@ +/** + * 涓嬭浇鏂囦欢 + * @param data 鍝嶅簲鏁版嵁 + */ +export function downloadExcel (data, fileName) { + // let url = window.URL.createObjectURL(data) // 灏嗕簩杩涘埗鏂囦欢杞寲涓哄彲璁块棶鐨剈rl + let url = window.URL.createObjectURL(new Blob([data])) // 灏嗕簩杩涘埗鏂囦欢杞寲涓哄彲璁块棶鐨剈rl + + let a = document.createElement('a') + document.body.appendChild(a) + a.href = url + a.download = fileName + '.xlsx' // 鏂囦欢鍚� + a.click() // 妯℃嫙鐐瑰嚮涓嬭浇 + window.URL.revokeObjectURL(url) +} diff --git a/src/utils/request.js b/src/utils/request.js index 43763a6..c6a596c 100644 --- a/src/utils/request.js +++ b/src/utils/request.js @@ -104,6 +104,21 @@ } return request(false, query) } + +const download = function (url, params) { + const query = { + baseURL: process.env.VUE_APP_URL, + url: url, + method: 'get', + withCredentials: true, + timeout: 30000, + data: params, + responseType: 'blob',//鍏抽敭 + headers: {'Content-Type': 'application/vnd.ms-excel',}//绫诲瀷淇敼涓篹xcel + } + return request(false, query) +} + export const down = function (url, params) { const query = { baseURL: process.env.VUE_APP_URL, @@ -122,5 +137,5 @@ postWithOutLoadTip, get, form, - + download } diff --git a/src/views/exam/question/list.vue b/src/views/exam/question/list.vue index 556372b..aa4f035 100644 --- a/src/views/exam/question/list.vue +++ b/src/views/exam/question/list.vue @@ -7,7 +7,7 @@ <!-- <el-option v-for="item in levelEnum" :key="item.key" :value="item.key" :label="item.value"></el-option>--> <!-- </el-select>--> <!-- </el-form-item>--> - + <el-form-item label="棰樺瀷锛�"> <el-select v-model="queryParam.questionType" clearable> <el-option v-for="item in questionType" :key="item.key" :value="item.key" :label="item.value"></el-option> @@ -18,16 +18,17 @@ </el-form-item> <el-form-item> <div style="display: flex"> - <el-button type="primary" @click="submitForm">鏌ヨ</el-button> - <el-popover placement="bottom" trigger="click"> - <el-button type="warning" size="mini" v-for="item in editUrlEnum" :key="item.key" + <el-button class="op-item" type="primary" @click="submitForm">鏌ヨ</el-button> + <el-popover class="op-item" placement="bottom" trigger="click"> + <el-button type="warning" size="mini" v-for="item in editUrlEnum" :key="item.key" @click="$router.push({path:item.value})">{{item.name}} </el-button> - <el-button slot="reference" type="primary" class="link-left">娣诲姞</el-button> + <el-button slot="reference" type="primary">娣诲姞</el-button> </el-popover> + <el-button class="op-item" type="danger" @click="downloadImportTemplate">涓嬭浇瀵煎叆妯℃澘</el-button> <el-upload - class="upload-demo" + class="op-item" :action="upLoadUrl" :with-credentials="true" :on-success="handlePreview" @@ -76,7 +77,7 @@ import Pagination from '@/components/Pagination' import QuestionShow from './components/Show' import questionApi from '@/api/question' -import store from '@/store' +import {downloadExcel} from '@/utils/download' import Cookies from 'js-cookie' export default { @@ -113,16 +114,22 @@ this.subjectFilter = this.subjects }, methods: { - handlePreview(e){ + // 涓嬭浇瀵煎叆妯℃澘 + downloadImportTemplate () { + questionApi.downloadImportTemplate().then(res => { + downloadExcel(res, '棰樼洰瀵煎嚭') + }) + }, + handlePreview (e) { console.log(e) - if (e.code==1){ + if (e.code === 1) { this.search() this.$message.success(e.message) - }else { + } else { this.$message.error(e.message) } }, - beforeAvatarUpload(file) { + beforeAvatarUpload (file) { let legalName = ['xlsx', 'xls'] // 鎷垮埌鍚庣紑鍚� let name = file.name.substring(file.name.lastIndexOf('.') + 1, file.name.length) @@ -229,6 +236,9 @@ } </script> <style scoped lang="scss"> +.op-item { + margin-left: 5px; +} .upload-demo{ margin-left: 5px; } -- Gitblit v1.8.0