智慧保安后台管理-外网项目备份
zhongrj
2023-09-17 8853292babb2ad94de4a3207966f1e83b767cd2d
src/main/java/org/springblade/modules/exam/service/impl/ExamPaperServiceImpl.java
@@ -18,20 +18,23 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import liquibase.pro.packaged.L;
import org.springblade.common.utils.TimeSwitchUtil;
import org.springblade.core.mp.support.Condition;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.exam.entity.*;
import org.springblade.modules.exam.mapper.ExamPaperMapper;
import org.springblade.modules.exam.service.*;
import org.springblade.modules.exam.vo.ExamPaperSubjectVO;
import org.springblade.modules.exam.vo.ExamPaperVO;
import org.springblade.modules.exam.vo.ExamScoreVO;
import org.springblade.modules.exam.vo.ExamSubjectChoicesVO;
import org.springblade.modules.exam.vo.*;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.service.TrainingRegistrationService;
import org.springblade.modules.vip.entity.VipTopic;
import org.springblade.modules.vip.service.VipTopicService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.*;
/**
@@ -43,7 +46,7 @@
public class ExamPaperServiceImpl extends ServiceImpl<ExamPaperMapper, ExamPaper> implements ExamPaperService {
   @Autowired
   private ExamExaminationSubjectService examExaminationSubjectService;
   private VipTopicService vipTopicService;
   @Autowired
   private ExamAnswerRecordService examAnswerRecordService;
@@ -53,6 +56,9 @@
   @Autowired
   private ExamScoreService examScoreService;
   @Autowired
   private TrainingRegistrationService trainingRegistrationService;
@@ -81,6 +87,21 @@
         if (examPaperVO1.getExamType()==2) {
            examPaperVO1.setNum(baseMapper.getTrainNumber(examPaperVO1));
            examPaperVO1.setExamNum(baseMapper.getExamNumber(examPaperVO1));
            //计算截止时间
            long nowTime = System.currentTimeMillis();
            long examStartTime = examPaperVO1.getStartTime().getTime();
            long examEndTime = examPaperVO1.getEndTime().getTime();
            //判断时间
            if (nowTime-examEndTime>0){
               //剩余时间大于1天
               examPaperVO1.setDeadline("考试已结束");
            }else if(nowTime-examStartTime>=0 && nowTime-examEndTime<=0){
               //已到考试时间
               examPaperVO1.setDeadline("已到考试时间");
            }else {
               long time = examStartTime - nowTime;
               examPaperVO1.setDeadline(TimeSwitchUtil.secondToTime(time));
            }
         }
      });
      return examPaperVOIPage;
@@ -92,12 +113,83 @@
      return baseMapper.queryPagerSubject(paper);
   }
//   @Override
//   public List<ExamSubjectChoicesVO> queryRandomSubject(ExamPaperVO paper) {
//      //保存题目信息
//      if (null!=paper.getScoreId()){
//         //查询该保安员是否为会员
//         ExamScore score = examScoreService.getById(paper.getScoreId());
//         TrainingRegistration trainingRegistration = trainingRegistrationService.getById(score.getApplyId());
//
//         List<ExamSubjectChoicesVO> examSubjectChoicesVOS = new ArrayList<>();
//         if (null!=trainingRegistration.getVipStatus()){
//            //如果是会员,从会员库里取题目
//            if (trainingRegistration.getVipStatus().equals(1)){
//               //查询该vip 用户的 vip 库,从该120题中取出题目
//               VipTopic vipTopic = new VipTopic();
//               vipTopic.setUserId(Long.parseLong(score.getUserId()));
////               vipTopic.setApplyId(score.getApplyId());
//               VipTopic topic = vipTopicService.getOne(Condition.getQueryWrapper(vipTopic));
//               if (null!=topic){
//                  List<String> list = Arrays.asList(topic.getTopicIds().split(","));
////                  System.out.println("list.size() = " + list.size());
//                  List<String> radio = list.subList(0, 49);
//                  List<String> checkbox = list.subList(50, 69);
//                  List<String> judge = list.subList(70, 109);
//                  List<String> sort = list.subList(110, 119);
//                  //随机题目
//                  List<ExamSubjectChoicesVO> radioRandomSubjectList = baseMapper.queryRandomSubjectList(radio,25);
//                  List<ExamSubjectChoicesVO> checkboxRandomSubjectList = baseMapper.queryRandomSubjectList(checkbox,10);
//                  List<ExamSubjectChoicesVO> judgeRandomSubjectList = baseMapper.queryRandomSubjectList(judge,20);
//                  List<ExamSubjectChoicesVO> sortRandomSubjectList = baseMapper.queryRandomSubjectList(sort,5);
//                  //合并集合数据
//                  examSubjectChoicesVOS.addAll(radioRandomSubjectList);
//                  examSubjectChoicesVOS.addAll(checkboxRandomSubjectList);
//                  examSubjectChoicesVOS.addAll(judgeRandomSubjectList);
//                  examSubjectChoicesVOS.addAll(sortRandomSubjectList);
//               }
//            }else {
//               //随机分类信息
//               examSubjectChoicesVOS = baseMapper.queryRandomSubject(paper);
//            }
//         }else {
//            //随机分类信息
//            examSubjectChoicesVOS = baseMapper.queryRandomSubject(paper);
//         }
////         long before = System.currentTimeMillis();
//         List<ExamExaminationSubject> list = new ArrayList<>();
//         examSubjectChoicesVOS.forEach(examSubjectChoicesVO -> {
//            //新增个人对应每场考试成绩试卷
//            ExamExaminationSubject ksxtSginup = new ExamExaminationSubject();
//            ksxtSginup.setExaminationId(paper.getScoreId());
//            ksxtSginup.setCategoryId(examSubjectChoicesVO.getChoicesType());
//            ksxtSginup.setSubjectId(examSubjectChoicesVO.getId());
//            //新增
////            examExaminationSubjectService.save(ksxtSginup);
//            list.add(ksxtSginup);
//            //将题目答案设置为空字符串,不让前端看到
//            examSubjectChoicesVO.setAnswer("");
//         });
//         //批量新增
//         baseMapper.insertBatch(list);
////         long after = System.currentTimeMillis();
////         System.out.println("时间差"+(after-before));
//         //新增试卷关联信息
//         return examSubjectChoicesVOS;
//      }
//      //返回
//      return null;
//   }
   @Override
   public List<ExamSubjectChoicesVO> queryRandomSubject(ExamPaperVO paper) {
      //保存题目信息
      if (null!=paper.getScoreId()){
         //随机分类信息
         List<ExamSubjectChoicesVO> examSubjectChoicesVOS = baseMapper.queryRandomSubject(paper);
         //查询该保安员是否为会员
//         ExamScore score = examScoreService.getById(paper.getScoreId());
         List<ExamSubjectChoicesVO> examSubjectChoicesVOS = new ArrayList<>();
         examSubjectChoicesVOS = baseMapper.queryRandomSubject(paper);
//         long before = System.currentTimeMillis();
         List<ExamExaminationSubject> list = new ArrayList<>();
         examSubjectChoicesVOS.forEach(examSubjectChoicesVO -> {
@@ -114,8 +206,6 @@
         });
         //批量新增
         baseMapper.insertBatch(list);
//         long after = System.currentTimeMillis();
//         System.out.println("时间差"+(after-before));
         //新增试卷关联信息
         return examSubjectChoicesVOS;
      }
@@ -147,13 +237,13 @@
   /**
    * 查询考生考试信息
    * @param userId 用户id
    * @param examPaper 用户id
    * @return
    */
   @Override
   public List<ExamPaperVO> getExamDetail(String userId) {
   public List<ExamPaperVO> getExamDetail(ExamPaperVO examPaper) {
      //查询考试信息
      return baseMapper.getExamDetail(userId);
      return baseMapper.getExamDetail(examPaper);
   }
   /**
@@ -230,7 +320,6 @@
         //4.其他信息
         ExamScore examScore = examScoreService.getById(examPaperVO.getScoreId());
         //5.数据封装
         map.put("examSubjectChoicesVOSList",examSubjectChoicesVOSList);
         map.put("examAnswerRecordList",examAnswerRecordList);
@@ -242,4 +331,91 @@
      }
      return null;
   }
   /**
    * 查询考试统计信息
    * @param examPaperVO
    * @param page
    * @return
    */
   @Override
   public IPage<ExamStatisticsVO> getExamStatistics(IPage<ExamStatisticsVO> page, ExamPaperVO examPaperVO) {
      return page.setRecords(baseMapper.getExamStatistics(page,examPaperVO));
   }
   /**
    * 根据考试id 统计查询考试信息
    * @param examPaperVO
    * @return
    */
   @Override
   public IPage<ExamStatisticsVO> getExamInfoByExamId(IPage<ExamStatisticsVO> page, ExamStatisticsVO examPaperVO) {
      List<ExamStatisticsVO> statisticsVOS = baseMapper.getExamInfoByExamId(page, examPaperVO);
      //遍历,计算占比
      if (statisticsVOS.size()>0){
         statisticsVOS.forEach(examStatisticsVO -> {
            //格式化小数
            DecimalFormat df = new DecimalFormat("0.00");
            //返回的是String类型
            examStatisticsVO.setAbsentProportion(df.format((float)examStatisticsVO.getQknum()/examStatisticsVO.getZnum()*100));
            DecimalFormat df1 = new DecimalFormat("0.00");
            examStatisticsVO.setQualifiedProportion(df1.format((float)examStatisticsVO.getYknum()/examStatisticsVO.getZnum()*100));
         });
      }
      return page.setRecords(statisticsVOS);
   }
   /**
    * 根据考试id 统计查询考试信息
    * @param examScoreVO
    * @return
    */
   @Override
   public List<ExamStatisticsVO> getExamInfoByExamIdList(ExamScoreVO examScoreVO) {
      List<ExamStatisticsVO> statisticsVOS = baseMapper.getExamInfoByExamIdList(examScoreVO);
      //遍历,计算占比
      if (statisticsVOS.size()>0){
         statisticsVOS.forEach(examStatisticsVO -> {
            //格式化小数
            DecimalFormat df = new DecimalFormat("0.00");
            //返回的是String类型
            examStatisticsVO.setAbsentProportion(df.format((float)examStatisticsVO.getQknum()/examStatisticsVO.getZnum()*100));
            DecimalFormat df1 = new DecimalFormat("0.00");
            examStatisticsVO.setQualifiedProportion(df1.format((float)examStatisticsVO.getYknum()/examStatisticsVO.getZnum()*100));
         });
      }
      return statisticsVOS;
   }
   /**
    * 查询考试成绩明细
    * @param examScoreVO
    * @return
    */
   @Override
   public List<ExamScoreVO> getExamScoreList(ExamScoreVO examScoreVO) {
      return baseMapper.getExamScoreList(examScoreVO);
   }
   /**
    * 根据id 取出题目信息(随机取)
    * @param list 题目id集合
    * @param number 题目梳理
    * @return
    */
   @Override
   public List<ExamSubjectChoicesVO> queryRandomSubjectList(List<String> list, int number) {
      return baseMapper.queryRandomSubjectList(list,number);
   }
   /**
    * 模拟考试随机抽题,未缴费人员
    * @return
    */
   @Override
   public List<ExamSubjectChoicesVO> simulateQueryRandomSubjectList() {
      return baseMapper.simulateQueryRandomSubjectList();
   }
}