package org.springblade.modules.exam.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.exam.entity.ExamAnswerRecord;
import org.springblade.modules.exam.entity.ExamSubjectChoices;
import org.springblade.modules.exam.entity.ExamSubjectOption;
import org.springblade.modules.exam.excel.ExamSubjectExcel;
import org.springblade.modules.exam.mapper.ExamSubjectChoicesMapper;
import org.springblade.modules.exam.service.ExamAnswerRecordService;
import org.springblade.modules.exam.service.ExamSubjectChoicesService;
import org.springblade.modules.exam.service.ExamSubjectOptionService;
import org.springblade.modules.exam.vo.ExamSubjectChoicesVO;
import org.springblade.modules.simulateexam.entity.SimulateExamAnswerRecord;
import org.springblade.modules.simulateexam.service.SimulateExamAnswerRecordService;
import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.text.SimpleDateFormat;
import java.util.Arrays;
import java.util.Date;
import java.util.List;

/**
 * 选择题服务实现类
 *
 * @author zhongrj
 */
@Service
public class ExamSubjectChoicesServiceImpl extends ServiceImpl<ExamSubjectChoicesMapper, ExamSubjectChoices> implements ExamSubjectChoicesService {

	@Autowired
	private ExamSubjectOptionService examSubjectOptionService;

	@Autowired
	private ExamAnswerRecordService examAnswerRecordService;

	@Autowired
	private SimulateExamAnswerRecordService simulateExamAnswerRecordService;
	@Autowired
	private MyAsyncService myAsyncService;


	@Override
	public IPage<ExamSubjectChoicesVO> selectExamSubjectChoicesPage(IPage<ExamSubjectChoicesVO> page, ExamSubjectChoicesVO examSubjectChoices) {
		return page.setRecords(baseMapper.selectExamSubjectChoicesPage(page, examSubjectChoices));
	}

	@Override
	public IPage<ExamSubjectChoicesVO> getEexPaperChoices(IPage<ExamSubjectChoicesVO> page, ExamSubjectChoicesVO examSubjectChoices) {
		return page.setRecords(baseMapper.getEexPaperChoices(page, examSubjectChoices));
	}

	/**
	 * 详情
	 *
	 * @param examSubjectChoices 选择题信息对象
	 */
	@Override
	public ExamSubjectChoicesVO selectExamSubjectChoicesInfo(ExamSubjectChoices examSubjectChoices) {
		return baseMapper.selectExamSubjectChoicesInfo(examSubjectChoices);
	}

	@Override
	public boolean updateChoicesValue(String id, String value) {
		return baseMapper.updateChoicesValue(id, value);
	}

	/**
	 * 新增题目及选项信息
	 *
	 * @param examSubjectChoices 题目信息对象
	 * @return
	 */
	@Override
	@Transactional(rollbackFor = Exception.class)
	public boolean saveSubjectChoicesAndOption(ExamSubjectChoicesVO examSubjectChoices) {
		boolean status = false;
		//新增
		if (null == examSubjectChoices.getId()) {
			ExamSubjectChoices subjectChoices = new ExamSubjectChoices();
			subjectChoices.setCreateDate(new Date());
			subjectChoices.setDelFlag(0);
			subjectChoices.setAnswer(examSubjectChoices.getAnswer());
			if (null != examSubjectChoices.getAnalysis() && examSubjectChoices.getAnalysis() != "") {
				subjectChoices.setAnalysis(examSubjectChoices.getAnalysis());
			}
			subjectChoices.setCreator(examSubjectChoices.getCreator());
			subjectChoices.setChoicesType(examSubjectChoices.getChoicesType());
			subjectChoices.setSubjectName(examSubjectChoices.getSubjectName());
			subjectChoices.setScore(examSubjectChoices.getScore());
			subjectChoices.setTktype(examSubjectChoices.getTktype());
			//题目新增
			status = this.save(subjectChoices);
			//判断类型,单选，多选，实操
			if (examSubjectChoices.getChoicesType() == 0 || examSubjectChoices.getChoicesType() == 1 || examSubjectChoices.getChoicesType() == 3) {
				//选项新增
				List<ExamSubjectOption> examSubjectOptions = examSubjectChoices.getExamSubjectOptions();
				examSubjectOptions.forEach(examSubjectOption -> {
					examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
					examSubjectOption.setCreateDate(new Date());
					examSubjectOption.setDelFlag(0);
					//新增
					examSubjectOptionService.save(examSubjectOption);
				});
				return true;
			}
		} else {
			//修改
			ExamSubjectChoices subjectChoices = new ExamSubjectChoices();
			subjectChoices.setId(examSubjectChoices.getId());
			subjectChoices.setModifyDate(new Date());
			subjectChoices.setAnswer(examSubjectChoices.getAnswer());
			if (null != examSubjectChoices.getAnalysis() && examSubjectChoices.getAnalysis() != "") {
				subjectChoices.setAnalysis(examSubjectChoices.getAnalysis());
			}
			subjectChoices.setModifier(examSubjectChoices.getCreator());
			subjectChoices.setChoicesType(examSubjectChoices.getChoicesType());
			subjectChoices.setSubjectName(examSubjectChoices.getSubjectName());
			subjectChoices.setScore(examSubjectChoices.getScore());
			subjectChoices.setTktype(examSubjectChoices.getTktype());
			//题目修改
			status = this.updateById(subjectChoices);
			//判断类型,单选，多选
			if (examSubjectChoices.getChoicesType() == 0 || examSubjectChoices.getChoicesType() == 1) {
				//选项修改
				List<ExamSubjectOption> examSubjectOptions = examSubjectChoices.getExamSubjectOptions();
				examSubjectOptions.forEach(examSubjectOption -> {
					examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
					examSubjectOption.setModifyDate(new Date());
					examSubjectOption.setModifier(examSubjectChoices.getCreator());
					//修改
					examSubjectOptionService.updateById(examSubjectOption);
				});
				return true;
			}
			//实操
			if (examSubjectChoices.getChoicesType() == 3) {
				//先将选项删除
				baseMapper.removeBySubjectId(examSubjectChoices.getId());
				//选项新增
				List<ExamSubjectOption> examSubjectOptions = examSubjectChoices.getExamSubjectOptions();
				examSubjectOptions.forEach(examSubjectOption -> {
					examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
					examSubjectOption.setCreateDate(new Date());
					examSubjectOption.setDelFlag(0);
					//新增
					examSubjectOptionService.save(examSubjectOption);
				});
				return true;
			}
		}
		return status;
	}


	/**
	 * 题库导入
	 *
	 * @param data      导入数据
	 * @param isCovered
	 */
	@Override
	public void importSubject(List<ExamSubjectExcel> data, Boolean isCovered) {
		data.forEach(examSubjectExcel -> {
			//题目对象
			ExamSubjectChoices subjectChoices = new ExamSubjectChoices();
			subjectChoices.setCreateDate(new Date());
			subjectChoices.setDelFlag(0);
			subjectChoices.setAnswer(examSubjectExcel.getAnswer());
			if (null != examSubjectExcel.getAnalysis() && examSubjectExcel.getAnalysis() != "") {
				subjectChoices.setAnalysis(examSubjectExcel.getAnalysis());
			}
			subjectChoices.setChoicesType(examSubjectExcel.getChoicesType());
			subjectChoices.setSubjectName(examSubjectExcel.getSubjectName());
			subjectChoices.setScore(examSubjectExcel.getScore());
			subjectChoices.setTktype(examSubjectExcel.getTktype());
			//题目新增
			this.save(subjectChoices);


			//判断类型,单选，多选选项新增
			if (examSubjectExcel.getChoicesType() == 0 || examSubjectExcel.getChoicesType() == 1) {
				//A选项新增
				ExamSubjectOption examSubjectOption = new ExamSubjectOption();
				//选项新增
				examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
				examSubjectOption.setCreateDate(new Date());
				examSubjectOption.setDelFlag(0);
				examSubjectOption.setOptionName("A");
				examSubjectOption.setOptionContent(examSubjectExcel.getOptionContentA());
				//新增
				examSubjectOptionService.save(examSubjectOption);

				//B选项新增
				ExamSubjectOption examSubjectOption1 = new ExamSubjectOption();
				//选项新增
				examSubjectOption1.setSubjectChoicesId(subjectChoices.getId());
				examSubjectOption1.setCreateDate(new Date());
				examSubjectOption1.setDelFlag(0);
				examSubjectOption1.setOptionName("B");
				examSubjectOption1.setOptionContent(examSubjectExcel.getOptionContentB());
				//新增
				examSubjectOptionService.save(examSubjectOption1);

				//C选项新增
				ExamSubjectOption examSubjectOption2 = new ExamSubjectOption();
				//选项新增
				examSubjectOption2.setSubjectChoicesId(subjectChoices.getId());
				examSubjectOption2.setCreateDate(new Date());
				examSubjectOption2.setDelFlag(0);
				examSubjectOption2.setOptionName("C");
				examSubjectOption2.setOptionContent(examSubjectExcel.getOptionContentC());
				//新增
				examSubjectOptionService.save(examSubjectOption2);

				//D选项新增
				ExamSubjectOption examSubjectOption3 = new ExamSubjectOption();
				//选项新增
				examSubjectOption3.setSubjectChoicesId(subjectChoices.getId());
				examSubjectOption3.setCreateDate(new Date());
				examSubjectOption3.setDelFlag(0);
				examSubjectOption3.setOptionName("D");
				examSubjectOption3.setOptionContent(examSubjectExcel.getOptionContentD());
				//新增
				examSubjectOptionService.save(examSubjectOption3);
			}


			//多选选项新增
			if (examSubjectExcel.getChoicesType() == 3) {
				//1选项新增
				if (null != examSubjectExcel.getOptionContentA() && examSubjectExcel.getOptionContentA() != "") {
					ExamSubjectOption examSubjectOption = new ExamSubjectOption();
					//选项新增
					examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
					examSubjectOption.setCreateDate(new Date());
					examSubjectOption.setDelFlag(0);
					examSubjectOption.setOptionName("1");
					examSubjectOption.setOptionContent(examSubjectExcel.getOptionContentA());
					//新增
					examSubjectOptionService.save(examSubjectOption);
				}

				//2选项新增
				if (null != examSubjectExcel.getOptionContentB() && examSubjectExcel.getOptionContentB() != "") {
					ExamSubjectOption examSubjectOption1 = new ExamSubjectOption();
					//选项新增
					examSubjectOption1.setSubjectChoicesId(subjectChoices.getId());
					examSubjectOption1.setCreateDate(new Date());
					examSubjectOption1.setDelFlag(0);
					examSubjectOption1.setOptionName("2");
					examSubjectOption1.setOptionContent(examSubjectExcel.getOptionContentB());
					//新增
					examSubjectOptionService.save(examSubjectOption1);
				}

				//3选项新增
				if (null != examSubjectExcel.getOptionContentC() && examSubjectExcel.getOptionContentC() != "") {
					ExamSubjectOption examSubjectOption2 = new ExamSubjectOption();
					//选项新增
					examSubjectOption2.setSubjectChoicesId(subjectChoices.getId());
					examSubjectOption2.setCreateDate(new Date());
					examSubjectOption2.setDelFlag(0);
					examSubjectOption2.setOptionName("3");
					examSubjectOption2.setOptionContent(examSubjectExcel.getOptionContentC());
					//新增
					examSubjectOptionService.save(examSubjectOption2);
				}

				//4选项新增
				if (null != examSubjectExcel.getOptionContentD() && examSubjectExcel.getOptionContentD() != "") {
					ExamSubjectOption examSubjectOption3 = new ExamSubjectOption();
					//选项新增
					examSubjectOption3.setSubjectChoicesId(subjectChoices.getId());
					examSubjectOption3.setCreateDate(new Date());
					examSubjectOption3.setDelFlag(0);
					examSubjectOption3.setOptionName("4");
					examSubjectOption3.setOptionContent(examSubjectExcel.getOptionContentD());
					//新增
					examSubjectOptionService.save(examSubjectOption3);
				}


				//5选项新增
				if (null != examSubjectExcel.getOptionContentE() && examSubjectExcel.getOptionContentE() != "") {
					ExamSubjectOption examSubjectOption4 = new ExamSubjectOption();
					//选项新增
					examSubjectOption4.setSubjectChoicesId(subjectChoices.getId());
					examSubjectOption4.setCreateDate(new Date());
					examSubjectOption4.setDelFlag(0);
					examSubjectOption4.setOptionName("5");
					examSubjectOption4.setOptionContent(examSubjectExcel.getOptionContentE());
					//新增
					examSubjectOptionService.save(examSubjectOption4);
				}
			}
		});

	}


	/**
	 * 判断当前题目的答题结果
	 *
	 * @param preSubJectId 题目Id
	 * @param preResult    提交的结果
	 * @param scoreId      成绩id
	 * @return
	 */
	@Override
	public Integer getAnswerResult(Long preSubJectId, String preResult, Long scoreId) {
		//查询题目信息
		ExamSubjectChoices choices = this.getById(preSubJectId);
		//对比答案
		if (choices.getChoicesType() == 2 || choices.getChoicesType() == 3) {
			//保存答题记录
			boolean result = preResult.equals(choices.getAnswer());
			int status = 0;
			//判断题逻辑
			if (result) {
				status = 1;
			} else {
				status = 2;
			}
			//新增答题记录
			saveExamAns(choices, preSubJectId, preResult, scoreId, result);
			//返回
			return status;
		} else if (choices.getChoicesType() == 0 || choices.getChoicesType() == 1) {
			//处理多选题的答案排序
			String[] split = preResult.split(",");
			StringBuilder builder = new StringBuilder();
			for (String s : split) {
				builder.append(s);
			}
			char[] arrayCh = builder.toString().toCharArray();
			//利用数组帮助类自动排序
			Arrays.sort(arrayCh);
			String sub0 = Arrays.toString(arrayCh);
			String sub = sub0.substring(1, sub0.length() - 1).replaceAll(" ", "");

			//保存答题记录
			boolean result = sub.equals(choices.getAnswer());
			int status = 0;
			//判断题逻辑
			if (result) {
				status = 1;
			} else {
				status = 2;
			}
			//新增答题记录
			saveExamAns(choices, preSubJectId, preResult, scoreId, result);
			//返回
			return status;
		}
		return 2;
	}

	/**
	 * 新增答题记录
	 *
	 * @param choices      题目
	 * @param preSubJectId 上一题题目id
	 * @param preResult    上一题答题结果
	 * @param scoreId      成绩 id
	 * @param result       答题是否正确
	 */
	private void saveExamAns(ExamSubjectChoices choices, Long preSubJectId, String preResult, Long scoreId, boolean result) {
		ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
		examAnswerRecord.setScoreId(scoreId);
		examAnswerRecord.setAnswerOption(preResult);
		examAnswerRecord.setSubjectChoicesId(preSubJectId);
		examAnswerRecord.setAnswer(choices.getAnswer());
		examAnswerRecord.setSubjectChoicesType(choices.getChoicesType());
		examAnswerRecord.setAnswerTime(new Date());
		int status = 0;
		//判断题逻辑
		if (result) {
			status = 1;
			examAnswerRecord.setAnswerScore(choices.getScore());
		} else {
			status = 2;
			examAnswerRecord.setAnswerScore(0);
		}
		examAnswerRecord.setAnswerResult(status);
		//新增
		examAnswerRecordService.save(examAnswerRecord);

		//内网数据同步...
		String s = "insert into exam_answer_record(id,subject_choices_id,subject_choices_type,answer_option,answer" +
			",answer_time,answer_score,answer_result,score_id) " +
			"values(" + "'" + examAnswerRecord.getId() + "'" +
			"," + "'" + examAnswerRecord.getSubjectChoicesId() + "'" +
			"," + "'" + examAnswerRecord.getSubjectChoicesType() + "'" +
			"," + "'" + examAnswerRecord.getAnswerOption() + "'" +
			"," + "'" + examAnswerRecord.getAnswer() + "'" +
			"," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examAnswerRecord.getAnswerTime()) + "'" +
			"," + "'" + examAnswerRecord.getAnswerScore() + "'" +
			"," + "'" + examAnswerRecord.getAnswerResult() + "'" +
			"," + "'" + examAnswerRecord.getScoreId() + "'" + ")";
		//FtpUtil.sqlFileUpload(s);
		myAsyncService.dataSync(s);
	}

	/**
	 * 随机查询题库120道
	 *
	 * @return
	 */
	@Override
	public List<String> getExamSubjectChoicesList() {
		return baseMapper.getExamSubjectChoicesList();
	}

	/**
	 * 判断当前题目的答题结果
	 *
	 * @param preSubJectId   题目 id
	 * @param preResult      提交的结果
	 * @param simulateExamId 模拟考试记录 id
	 * @return
	 */
	@Override
	public Integer getAnswerResultBySimulate(Long preSubJectId, String preResult, Long simulateExamId) {
		//查询题目信息
		ExamSubjectChoices choices = this.getById(preSubJectId);
		//对比答案
		if (choices.getChoicesType() == 2 || choices.getChoicesType() == 3) {
			//保存答题记录
			boolean result = preResult.equals(choices.getAnswer());
			int status = 0;
			//判断题逻辑
			if (result) {
				status = 1;
			} else {
				status = 2;
			}
			//新增模拟考试答题记录
			saveSimulateExamAns(choices, preSubJectId, preResult, simulateExamId, result);
			//返回
			return status;
		} else if (choices.getChoicesType() == 0 || choices.getChoicesType() == 1) {
			//处理多选题的答案排序
			String[] split = preResult.split(",");
			StringBuilder builder = new StringBuilder();
			for (String s : split) {
				builder.append(s);
			}
			char[] arrayCh = builder.toString().toCharArray();
			//利用数组帮助类自动排序
			Arrays.sort(arrayCh);
			String sub0 = Arrays.toString(arrayCh);
			String sub = sub0.substring(1, sub0.length() - 1).replaceAll(" ", "");

			//保存模拟考试答题记录
			boolean result = sub.equals(choices.getAnswer());
			int status = 0;
			//判断题逻辑
			if (result) {
				status = 1;
			} else {
				status = 2;
			}
			//新增模拟考试答题记录
			saveSimulateExamAns(choices, preSubJectId, preResult, simulateExamId, result);
			//返回
			return status;
		}
		return 2;
	}

	/**
	 * 新增模拟考试答题记录
	 *
	 * @param choices        题目信息
	 * @param preSubJectId   题目id
	 * @param preResult      提交的答案
	 * @param simulateExamId 模拟考试id
	 * @param result         答题的结果
	 */
	private void saveSimulateExamAns(ExamSubjectChoices choices, Long preSubJectId, String preResult, Long simulateExamId, boolean result) {
		SimulateExamAnswerRecord simulateExamAnswerRecord = new SimulateExamAnswerRecord();
		simulateExamAnswerRecord.setSimulateExamId(simulateExamId);
		simulateExamAnswerRecord.setAnswerOption(preResult);
		simulateExamAnswerRecord.setSubjectChoicesId(preSubJectId);
		simulateExamAnswerRecord.setAnswer(choices.getAnswer());
		simulateExamAnswerRecord.setSubjectChoicesType(choices.getChoicesType());
		simulateExamAnswerRecord.setAnswerTime(new Date());
		int status = 0;
		//判断题逻辑
		if (result) {
			status = 1;
			simulateExamAnswerRecord.setAnswerScore(choices.getScore());
		} else {
			status = 2;
			simulateExamAnswerRecord.setAnswerScore(0);
		}
		simulateExamAnswerRecord.setAnswerResult(status);
		//新增
		simulateExamAnswerRecordService.save(simulateExamAnswerRecord);
	}
}