题目导出

xiangpei

2024-03-29 49e5e59e00628d1a216f52de5c1a299d695cf6c0

题目导出

 src/api/question.js

@@ -5,5 +5,6 @@
  edit: query => post('/api/admin/question/edit', query),
  select: id => post('/api/admin/question/select/' + id),
  deleteQuestion: id => post('/api/admin/question/delete/' + id),
  downloadImportTemplate: () => download('/api/admin/question/download/question/import/temp')
  downloadImportTemplate: () => download('/api/admin/question/download/question/import/temp'),
  exportQuestion: query => download('/api/admin/question/question/export', query)
}

 src/utils/request.js

@@ -99,8 +99,8 @@
    withCredentials: true,
    timeout: 30000,
    data: params,
    responseType: 'blob',//关键
    headers: {'Content-Type': 'application/vnd.ms-excel',}//类型修改为excel
    responseType: 'blob', // 关键
    headers: { 'Content-Type': 'application/vnd.ms-excel' }// 类型修改为excel
  }
  return request(false, query)
}
@@ -111,10 +111,10 @@
    url: url,
    method: 'get',
    withCredentials: true,
    timeout: 30000,
    data: params,
    responseType: 'blob',//关键
    headers: {'Content-Type': 'application/vnd.ms-excel',}//类型修改为excel
    timeout: 300000,
    params: params,
    responseType: 'blob', // 关键
    headers: { 'Content-Type': 'application/vnd.ms-excel' }// 类型修改为excel
  }
  return request(false, query)
}
@@ -127,7 +127,7 @@
    withCredentials: true,
    timeout: 30000,
    data: params,
    headers: {  responseType: 'blob', 'Content-Type': 'multipart/form-data', 'request-ajax': true}
    headers: { responseType: 'blob', 'Content-Type': 'multipart/form-data', 'request-ajax': true }
  }
  return request(false, query)
}

 src/views/exam/question/list.vue

@@ -26,6 +26,33 @@
          <el-button slot="reference" type="primary">添加</el-button>

        </el-popover>
        <el-popover
          placement="right"
          width="400"
          trigger="click">
          <el-form
            label-position="top"
          >
            <el-form-item label="题型：">
              <el-select v-model="exportForm.questionType" clearable>
                <el-option v-for="item in questionType" :key="item.key" :value="item.key" :label="item.value"></el-option>
              </el-select>
            </el-form-item>
            <el-form-item label="创建时间：">
              <el-date-picker
                v-model="timeRange"
                type="daterange"
                range-separator="至"
                start-placeholder="开始日期"
                end-placeholder="结束日期">
              </el-date-picker>
            <el-form-item style="text-align: center;margin-top: 5px">
              <el-button type="primary" @click="exportQuestion">导出</el-button>
            </el-form-item>
            </el-form-item>
          </el-form>
          <el-button slot="reference" class="op-item" type="success">导出</el-button>
        </el-popover>
        <el-button class="op-item" type="danger" @click="downloadImportTemplate">下载导入模板</el-button>
        <el-upload
          class="op-item"
@@ -45,12 +72,6 @@
    </el-form>
    <el-table v-loading="listLoading" :data="tableData" border fit highlight-current-row style="width: 100%">
      <el-table-column prop="subjectId" label="课目" :formatter="subjectIdFormatte" width="120px"/>
<!--      <el-table-column prop="subjectId" label="课目">-->
<!--        <template slot-scope="scope">-->
<!--&lt;!&ndash;          <span>{{this.subjectIdFormatte}}</span>&ndash;&gt;-->
<!--          <span>{{scope.row.questionSubjects.forEach(item=>{ return item.subName})}}</span>-->
<!--        </template>-->
<!--      </el-table-column>-->
      <el-table-column prop="questionType" label="题型" :formatter="questionTypeFormatter" width="70px"/>
      <el-table-column prop="shortTitle" label="题干" show-overflow-tooltip/>
      <el-table-column prop="score" label="分数" width="60px"/>
@@ -77,15 +98,20 @@
import Pagination from '@/components/Pagination'
import QuestionShow from './components/Show'
import questionApi from '@/api/question'
import {downloadExcel} from '@/utils/download'
import { downloadExcel } from '@/utils/download'

import Cookies from 'js-cookie'
export default {
  components: { Pagination, QuestionShow },
  data () {
    return {
      upLoadUrl:'/api/admin/question/import',
      fileList:[],
      timeRange: [],
      exportForm: {
        questionType: null,
        start: null,
        end: null
      },
      upLoadUrl: '/api/admin/question/import',
      fileList: [],
      queryParam: {
        id: null,
        questionType: null,
@@ -114,10 +140,20 @@
    this.subjectFilter = this.subjects
  },
  methods: {
    // 导出题目
    exportQuestion () {
      if (this.timeRange && this.timeRange.length > 1) {
        this.exportForm.startStr = this.timeRange[0]
        this.exportForm.endStr = this.timeRange[1]
      }
      questionApi.exportQuestion(this.exportForm).then(res => {
        downloadExcel(res, '题目导出')
      })
    },
    // 下载导入模板
    downloadImportTemplate () {
      questionApi.downloadImportTemplate().then(res => {
        downloadExcel(res, '题目导出')
        downloadExcel(res, '题目导入模板')
      })
    },
    handlePreview (e) {
@@ -200,13 +236,13 @@
    questionTypeFormatter (row, column, cellValue, index) {
      return this.enumFormat(this.questionType, cellValue)
    },
    subjectIdFormatte(row, column, cellValue, index){
    subjectIdFormatte (row, column, cellValue, index) {
      console.log(row, column, cellValue, index)
      let str = ''
      row.questionSubjects.forEach(item=>{
        str+=item.subName+','
      row.questionSubjects.forEach(item => {
        str += item.subName + ','
      })
      return str = str.slice(0,str.length-1)
      return str = str.slice(0, str.length - 1)
    },
    subjectFormatter (row, column, cellValue, index) {
      return this.subjectEnumFormat(cellValue)
@@ -216,12 +252,11 @@
  computed: {

    headers: function () {
      console.log( Cookies.get('adminUserName'),)
      // console.log(store.getters.Admin-Token)
      // const tenantId = store.getters.userInfo.tenantId
      return {
        // 'Authorization': "Bearer " + store.getters.Admin-Token,
        "Cookie":"JSESSIONID=shpHmjIK1ysHPDyAQB4-M-N3WytgJ3UIwYrfcA2t; adminUserName=admin"
        'Cookie': 'JSESSIONID=shpHmjIK1ysHPDyAQB4-M-N3WytgJ3UIwYrfcA2t; adminUserName=admin'
      }
    },
    ...mapGetters('enumItem', ['enumFormat']),