青阳考试系统
blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
xiangpei
2024-03-15 f7196dff53805c9d5e6c945e5334ce4e4423d779 
 src/main/java/com/mindskip/xzs/controller/admin/QuestionController.java


@@ -1,5 +1,7 @@


package com.mindskip.xzs.controller.admin;




import com.alibaba.excel.EasyExcel;


import com.alibaba.excel.metadata.data.HyperlinkData;


import com.mindskip.xzs.base.BaseApiController;


import com.mindskip.xzs.base.RestResponse;


import com.mindskip.xzs.base.SystemCode;


@@ -9,6 +11,7 @@


import com.mindskip.xzs.domain.enums.QuestionSourceEnum;


import com.mindskip.xzs.domain.enums.QuestionTypeEnum;


import com.mindskip.xzs.domain.question.QuestionObject;


import com.mindskip.xzs.excel.SelectExcel;


import com.mindskip.xzs.repository.DepartmentMapper;


import com.mindskip.xzs.repository.SubjectMapper;


import com.mindskip.xzs.service.*;


@@ -18,12 +21,18 @@


import com.mindskip.xzs.viewmodel.admin.education.SubjectPageRequestVM;


import com.mindskip.xzs.viewmodel.admin.question.*;


import com.github.pagehelper.PageInfo;


import com.mindskip.xzs.vo.QuestionImportVO;


import org.apache.commons.lang3.StringUtils;


import org.apache.poi.ss.usermodel.DataValidationHelper;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.web.bind.annotation.*;


import org.springframework.web.multipart.MultipartFile;




import javax.servlet.http.HttpServletResponse;


import javax.validation.Valid;


import java.io.IOException;


import java.io.UnsupportedEncodingException;


import java.net.URLEncoder;


import java.util.ArrayList;


import java.util.Arrays;


import java.util.List;


@@ -121,6 +130,13 @@


        return RestResponse.ok();


    }




    @GetMapping("/download/question/import/temp")


    public void getImportTemp(HttpServletResponse response) throws IOException {


        String fileName = URLEncoder.encode("题目导入模板", "UTF-8").replaceAll("\\+", "%20");


        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");


        EasyExcel.write(response.getOutputStream(), QuestionImportVO.class).registerWriteHandler(new SelectExcel()).sheet("模板").doWrite(new ArrayList());


    }




    @PostMapping("/import")


    public RestResponse importUser(@RequestPart("file") MultipartFile file) throws Exception {


        List<QuestionEditVO> questionEditVOS = ExcelUtils.readMultipartFile(file, QuestionEditVO.class)