/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.exam.service.impl;

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.*;
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.*;

/**
 * 服务实现类
 *
 * @author Chill
 */
@Service
public class ExamPaperServiceImpl extends ServiceImpl<ExamPaperMapper, ExamPaper> implements ExamPaperService {

	@Autowired
	private VipTopicService vipTopicService;

	@Autowired
	private ExamAnswerRecordService examAnswerRecordService;

	@Autowired
	private ExamSubjectChoicesService examSubjectChoicesService;

	@Autowired
	private ExamScoreService examScoreService;

	@Autowired
	private TrainingRegistrationService trainingRegistrationService;



	@Override
	public IPage<ExamPaperVO> selectExamPaperPages(IPage<ExamScoreVO> page, ExamPaperVO exam) {
		return baseMapper.selectExamPaperPages(page,exam);
	}


	/**
	 * 自定义查询
	 * @param page 分页条件
	 * @param examPaperVO 查询参数
	 * @return
	 */
	@Override
	public IPage<ExamPaperVO> selectExamPaperPage(IPage<ExamScoreVO> page, ExamPaperVO examPaperVO) {
		IPage<ExamPaperVO> examPaperVOIPage = baseMapper.selectExamPaperPage(page, examPaperVO);
		List<ExamPaperVO> records = examPaperVOIPage.getRecords();
		records.forEach(examPaperVO1 -> {
			//查询每个考试的报名人员数量
			if (examPaperVO1.getExamType()==1) {
				examPaperVO1.setNum(baseMapper.getApplyNumber(examPaperVO1));
			}
			//模拟考试
			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;
	}

	@Override
	public ExamPaperSubjectVO queryPagerSubject(ExamPaper paper) {
		//查询试卷分类信息
		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()){
			//查询该保安员是否为会员
//			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 -> {
				//新增个人对应每场考试成绩试卷
				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);
			//新增试卷关联信息
			return examSubjectChoicesVOS;
		}
		//返回
		return null;
	}

	@Override
	public ExamPaperSubjectVO PagerSubject(ExamPaper paper) {
		//查询试卷分类信息
		return baseMapper.PagerSubject(paper);
	}

	/**
	 * 自定义树
	 * @param examPaper 试卷对象
	 * @return
	 */
	@Override
	public List<ExamPaper> selectExamPaperPageTree(ExamPaper examPaper) {
		return baseMapper.selectExamPaperPageTree(examPaper);
	}

	@Override
	public boolean UnbindSubject(String paperid, String subjectid) {
		return baseMapper.UnbindSubject(paperid,subjectid);
	}


	/**
	 * 查询考生考试信息
	 * @param examPaper 用户id
	 * @return
	 */
	@Override
	public List<ExamPaperVO> getExamDetail(ExamPaperVO examPaper) {
		//查询考试信息
		return baseMapper.getExamDetail(examPaper);
	}

	/**
	 * 查询是当前前缀已生成准考证号码最大的一位
	 * @param result 前缀
	 * @return
	 */
	@Override
	public int getCandidateNoCount(String result) {
		return baseMapper.getCandidateNoCount(result);
	}

	/**
	 * 查询当前考试已报名的人员培训报名数据集合
	 * @param id 考试id
	 * @return
	 */
	@Override
	public List<TrainingRegistration> getTrainList(Long id) {
		return baseMapper.getTrainList(id);
	}

	/**
	 * 使用考试名称匹配考试信息
	 * @param examName 考试名称
	 * @return
	 */
	@Override
	public List<ExamPaper> getExamInfoByExamName(String examName) {
		return baseMapper.getExamInfoByExamName(examName);
	}

	/**
	 * 根据用户id查询报名信息
	 * @param userId 用户id
	 * @return
	 */
	@Override
	public List<Apply> getApplyDetail(String userId) {
		return baseMapper.getApplyDetail(userId);
	}

	/**
	 * 考试中页面刷新,1查询所有的答题信息，2查询所有的已答信息 3.下一题信息  3其他信息
	 * @param examPaperVO 必须包含 scoreId
	 * @return
	 */
	@Override
	public Map<String, Object> getExamRefreshInfo(ExamPaperVO examPaperVO) {
		if (null!=examPaperVO.getScoreId()) {
			Map<String, Object> map = new HashMap<>(4);
			//1.查询当前人员当前考试的考试题目信息
			List<ExamSubjectChoicesVO> examSubjectChoicesVOSList = baseMapper.getExaminationSubjectList(examPaperVO);
			if (examSubjectChoicesVOSList.size()==0) {
				examSubjectChoicesVOSList = baseMapper.queryRandomSubject(null);
				List<ExamExaminationSubject> list = new ArrayList<>();
				examSubjectChoicesVOSList.forEach(examSubjectChoicesVO -> {
					//新增个人对应每场考试成绩试卷
					ExamExaminationSubject ksxtSginup = new ExamExaminationSubject();
					ksxtSginup.setExaminationId(examPaperVO.getScoreId());
					ksxtSginup.setCategoryId(examSubjectChoicesVO.getChoicesType());
					ksxtSginup.setSubjectId(examSubjectChoicesVO.getId());
					//新增
					list.add(ksxtSginup);
					//将题目答案设置为空字符串，不让前端看到
					examSubjectChoicesVO.setAnswer("");
				});
				//批量新增
				baseMapper.insertBatch(list);
			}
			//2.查询当前人员已答的题目信息
			ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
			examAnswerRecord.setScoreId(examPaperVO.getScoreId());
			List<ExamAnswerRecord> examAnswerRecordList = examAnswerRecordService.list(Condition.getQueryWrapper(examAnswerRecord));

			//3.查询正在答题的信息
			int count = examAnswerRecordList.size();
			//查询下一题题目信息
			ExamSubjectChoicesVO examSubjectChoicesVO = new ExamSubjectChoicesVO();
			ExamSubjectChoices examSubjectChoices = new ExamSubjectChoices();
			if (count > 0) {
				examSubjectChoices.setId(examSubjectChoicesVOSList.get(count).getId());
				examSubjectChoicesVO = examSubjectChoicesService.selectExamSubjectChoicesInfo(examSubjectChoices);
			}
			if (count == 0) {
				examSubjectChoices.setId(examSubjectChoicesVOSList.get(0).getId());
				examSubjectChoicesVO = examSubjectChoicesService.selectExamSubjectChoicesInfo(examSubjectChoices);
			}

			//4.其他信息
			ExamScore examScore = examScoreService.getById(examPaperVO.getScoreId());

			//5.数据封装
			map.put("examSubjectChoicesVOSList", examSubjectChoicesVOSList);
			map.put("examAnswerRecordList", examAnswerRecordList);
			map.put("examSubjectChoicesVO", examSubjectChoicesVO);
			map.put("examScore", examScore);

			//6.返回数据
			return map;
		}
		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();
	}

	@Override
	public List<ExamPaperVO> getList(ExamPaperVO examPaperVO) {
		return baseMapper.getList(examPaperVO);
	}

	@Override
	public ExamPaperVO getLatest(ExamPaperVO examPaperVO) {
		return baseMapper.getLatest(examPaperVO);
	}
}