package com.skua.modules.edu.controller; import java.util.Arrays; import java.util.List; import java.util.Map; import java.io.IOException; import java.io.UnsupportedEncodingException; import java.net.URLDecoder; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.skua.core.api.vo.Result; import com.skua.core.aspect.annotation.AutoLog; import com.skua.core.context.BaseContextHandler; import com.skua.core.query.QueryGenerator; import com.skua.core.util.ConvertUtils; import com.skua.core.util.DateUtils; import com.skua.core.util.push.IPushService; import com.skua.core.util.push.MessageEntity; import com.skua.core.util.push.PushMessageFactory; import com.skua.modules.edu.entity.Paper; import com.skua.modules.edu.entity.Question; import com.skua.modules.edu.service.IPaperService; import java.util.Date; import java.util.stream.Collectors; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.skua.modules.edu.service.IQuestionService; import com.skua.modules.edu.vo.PaperRandomVO; import com.skua.modules.edu.vo.PaperVO; import com.skua.modules.guest.util.DateUtil; import com.skua.modules.system.entity.SysUser; import com.skua.modules.system.service.ISysUserService; import com.skua.tool.util.JSUtils; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import org.jeecgframework.poi.excel.ExcelImportUtil; import org.jeecgframework.poi.excel.def.NormalExcelConstants; import org.jeecgframework.poi.excel.entity.ExportParams; import org.jeecgframework.poi.excel.entity.ImportParams; import org.jeecgframework.poi.excel.view.JeecgEntityExcelView; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.multipart.MultipartHttpServletRequest; import org.springframework.web.servlet.ModelAndView; import com.alibaba.fastjson.JSON; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; /** * <pre> * 在线考试-试卷 * </pre> * @author 开发者姓名 * @version V0.1, 开发时间 */ @Slf4j @Api(tags="在线考试-试卷") @RestController("webPaperController") @RequestMapping("/web/edu/paper") public class PaperController { @Autowired private ISysUserService userService; @Autowired private IPaperService paperService; @Autowired private IQuestionService questionService; @AutoLog(value = "在线考试-试卷-分页列表查询") @ApiOperation(value="在线考试-试卷-分页列表查询", notes="在线考试-试卷-分页列表查询") @GetMapping(value = "/list") public Result<IPage<Paper>> queryPageList(Paper paper, @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, HttpServletRequest req) { Result<IPage<Paper>> result = new Result<IPage<Paper>>(); QueryWrapper<Paper> queryWrapper = QueryGenerator.initQueryWrapper(paper, req.getParameterMap()); Page<Paper> page = new Page<Paper>(pageNo, pageSize); IPage<Paper> pageList = paperService.page(page, queryWrapper); result.setSuccess(true); result.setResult(pageList); return result; } @AutoLog(value = "在线考试-随机组卷试题") @ApiOperation(value="在线考试-随机组卷试题", notes="在线考试-随机组卷试题") @PostMapping(value = "/randomQuestion") public Result<List<Question>> randomQuestion(@RequestBody PaperRandomVO paperRandomVO) throws Exception{ Result<List<Question>> result = new Result<>(); try { List<Question> dataList = questionService.randomQuestion(paperRandomVO); result.setResult( dataList ); result.success("操作成功!"); } catch (Exception e) { log.error(e.getMessage(),e); result.error500("操作失败"); } return result; } @AutoLog(value = "在线考试-试卷-添加") @ApiOperation(value="在线考试-试卷-添加", notes="在线考试-试卷-添加") @PostMapping(value = "/add") public Result<Paper> add(@RequestBody PaperVO paperVO) throws Exception{ Result<Paper> result = new Result<Paper>(); try { paperService.savePaper(paperVO); result.success("添加成功!"); } catch (Exception e) { log.error(e.getMessage(),e); result.error500("操作失败"); } return result; } @AutoLog(value = "在线考试-试卷-编辑") @ApiOperation(value="在线考试-试卷-编辑", notes="在线考试-试卷-编辑") @PutMapping(value = "/edit") public Result<Paper> edit(@RequestBody PaperVO paperVO) throws Exception{ Result<Paper> result = new Result<Paper>(); Paper paperEntity = paperService.getById(paperVO.getId()); if(paperEntity==null) { result.error500("未找到对应实体"); }else { boolean ok = paperService.updatePaper(paperVO); //TODO 返回false说明什么? if(ok) { result.success("修改成功!"); } } return result; } @AutoLog(value = "在线考试-发布试卷") @ApiOperation(value="在线考试-发布试卷", notes="在线考试-发布试卷") @GetMapping(value = "/publish") public Result<Paper> publish(@RequestParam(name="id",required=true) String id,@RequestParam(name="sendStatus",required=true) String sendStatus) { Result<Paper> result = new Result<Paper>(); Paper paper = paperService.getById(id); if(paper==null) { result.error500("未找到对应实体"); }else { paper.setSendStatus(sendStatus); paper.setSendTime( new Date()); boolean ok = paperService.updateById(paper); //TODO 返回false说明什么? if(ok) { if("1".equals(sendStatus)){ //信息推送 String messageTitle = "考试任务:"+paper.getPaperTitle() +"";// JSUtils.dateFormat( paper.getStartTime() ,null,"yyyy年MM月dd日") + String messageBody = "考试任务:"+paper.getPaperTitle() +",考试时间:"+paper.getStartTime() +"至"+paper.getEndTime()+",请准时参加考试"; //信息推送 pushMsgNoProcess(messageTitle,messageBody,paper.getExamUserIds()); } result.success("操作成功!"); } } return result; } //信息推送 private void pushMsgNoProcess(String messageTitle ,String messageBody ,String userIds) { if(StringUtils.isNotEmpty(userIds)){ List<SysUser> sysUserList = userService.getUserByUserIds(userIds); List<String> userCidList = sysUserList.stream().map(SysUser::getCid).filter(v -> StringUtils.isNotBlank(v)).collect(Collectors.toList()); List<String> userIdList = sysUserList.stream().map(SysUser::getId).collect(Collectors.toList()); MessageEntity messageEntity = new MessageEntity(); //messageEntity.setMessageTitle("考试马上开始"); //messageEntity.setMessageBody("**考试于*****开始考试,请尽快准备!"); messageEntity.setMessageTitle(messageTitle); messageEntity.setMessageBody(messageBody); messageEntity.setReceiveUser(userIdList); messageEntity.setReceiveUserCid(userCidList);//移动端推送 messageEntity.setSendUser(BaseContextHandler.getUserName()); messageEntity.setForwardTag("historyRecordRemind");//消息提醒类型 保持唯一 IPushService appPushService = PushMessageFactory.getPushService("MOB"); IPushService webPushService = PushMessageFactory.getPushService("WEB"); appPushService.pushMessage(messageEntity); webPushService.pushMessage(messageEntity); } } /** * <pre> * 通过id删除 * </pre> * @param id * @return * @author 开发者姓名, 开发时间 * @Description: TODO(这里描述这个方法的需求变更情况) */ @AutoLog(value = "在线考试-试卷-通过id删除") @ApiOperation(value="在线考试-试卷-通过id删除", notes="在线考试-试卷-通过id删除") @DeleteMapping(value = "/delete") public Result<?> delete(@RequestParam(name="id",required=true) String id) { try { paperService.removeById(id); } catch (Exception e) { log.error("删除失败",e.getMessage()); return Result.error("删除失败!"); } return Result.ok("删除成功!"); } /** * <pre> * 批量删除 * </pre> * @param ids * @return * @author 开发者姓名, 开发时间 * @Description: TODO(这里描述这个方法的需求变更情况) */ @AutoLog(value = "在线考试-试卷-批量删除") @ApiOperation(value="在线考试-试卷-批量删除", notes="在线考试-试卷-批量删除") @DeleteMapping(value = "/deleteBatch") public Result<Paper> deleteBatch(@RequestParam(name="ids",required=true) String ids) { Result<Paper> result = new Result<Paper>(); if(ids==null || "".equals(ids.trim())) { result.error500("参数不识别!"); }else { this.paperService.removeByIds(Arrays.asList(ids.split(","))); result.success("删除成功!"); } return result; } /** * <pre> * 通过id查询 * </pre> * @param id * @return * @author 开发者姓名, 开发时间 * @Description: TODO(这里描述这个方法的需求变更情况) */ @AutoLog(value = "在线考试-试卷-通过id查询") @ApiOperation(value="在线考试-试卷-通过id查询", notes="在线考试-试卷-通过id查询") @GetMapping(value = "/queryById") public Result<PaperVO> queryById(@RequestParam(name="id",required=true) String id) { Result<PaperVO> result = new Result<PaperVO>(); PaperVO paperVO = paperService.queryById(id); if(paperVO==null) { result.error500("未找到对应实体"); }else { result.setResult(paperVO); result.setSuccess(true); } return result; } /** * <pre> * 导出excel * </pre> * @param request * @param response * @return * @author 开发者姓名, 开发时间 * @Description: TODO(这里描述这个方法的需求变更情况) */ @RequestMapping(value = "/exportXls") public ModelAndView exportXls(HttpServletRequest request, HttpServletResponse response) { // Step.1 组装查询条件 QueryWrapper<Paper> queryWrapper = null; try { String paramsStr = request.getParameter("paramsStr"); if (ConvertUtils.isNotEmpty(paramsStr)) { String deString = URLDecoder.decode(paramsStr, "UTF-8"); Paper paper = JSON.parseObject(deString, Paper.class); queryWrapper = QueryGenerator.initQueryWrapper(paper, request.getParameterMap()); } } catch (UnsupportedEncodingException e) { e.printStackTrace(); } //Step.2 AutoPoi 导出Excel ModelAndView mv = new ModelAndView(new JeecgEntityExcelView()); List<Paper> pageList = paperService.list(queryWrapper); //导出文件名称 mv.addObject(NormalExcelConstants.FILE_NAME, "在线考试-试卷列表"); mv.addObject(NormalExcelConstants.CLASS, Paper.class); mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("在线考试-试卷列表数据", "导出人:Jeecg", "导出信息")); mv.addObject(NormalExcelConstants.DATA_LIST, pageList); return mv; } /** * <pre> * 通过excel导入数据 * </pre> * @param request * @param response * @return * @author 开发者姓名, 开发时间 * @Description: TODO(这里描述这个方法的需求变更情况) */ @RequestMapping(value = "/importExcel", method = RequestMethod.POST) public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request; Map<String, MultipartFile> fileMap = multipartRequest.getFileMap(); for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) { MultipartFile file = entity.getValue();// 获取上传文件对象 ImportParams params = new ImportParams(); params.setTitleRows(2); params.setHeadRows(1); params.setNeedSave(true); try { List<Paper> listPapers = ExcelImportUtil.importExcel(file.getInputStream(), Paper.class, params); paperService.saveBatch(listPapers); return Result.ok("文件导入成功!数据行数:" + listPapers.size()); } catch (Exception e) { log.error(e.getMessage(),e); return Result.error("文件导入失败:"+e.getMessage()); } finally { try { file.getInputStream().close(); } catch (IOException e) { e.printStackTrace(); } } } return Result.ok("文件导入失败!"); } }