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

import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
import org.apache.commons.lang3.StringUtils;
import org.springblade.common.constant.AgeUtil;
import org.springblade.common.utils.IdCardNoUtil;
import org.springblade.core.log.exception.ServiceException;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.BeanUtil;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.FTP.Monitor;
import org.springblade.modules.FTP.Result;
import org.springblade.modules.absentrecords.entity.AbsentRecords;
import org.springblade.modules.absentrecords.service.AbsentRecordsService;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.apply.excel.ApplyInfoExcel;
import org.springblade.modules.exam.entity.ExamAnswerRecord;
import org.springblade.modules.exam.entity.ExamPaper;
import org.springblade.modules.exam.entity.ExamScore;
import org.springblade.modules.exam.service.ExamAnswerRecordService;
import org.springblade.modules.exam.service.ExamPaperService;
import org.springblade.modules.exam.service.ExamScoreService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserDeptService;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.system.service.MyAsyncService;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.excel.TrainingRegistrationExcel;
import org.springblade.modules.training.mapper.TrainingRegistrationMapper;
import org.springblade.modules.training.service.TrainingRegistrationService;
import org.springblade.modules.training.util.LongTimeUtil;
import org.springblade.modules.training.vo.TrainingRegistrationVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.concurrent.atomic.AtomicBoolean;

/**
 * 报名培训服务实现类
 * @author zhongrj
 */
@Service
@AllArgsConstructor
public class TrainingRegistrationServiceImpl extends ServiceImpl<TrainingRegistrationMapper, TrainingRegistration> implements TrainingRegistrationService {

	private final IUserService userService;

	private final IUserDeptService userDeptService;

	private final ExamPaperService examPaperService;

	private final AbsentRecordsService absentRecordsService;

	private final ExamScoreService examScoreService;

	private final RedisTemplate redisTemplate;


	@Autowired
	private  MyAsyncService myAsyncService;

	@Autowired
	private ExamAnswerRecordService examAnswerRecordService;

	@Override
	public IPage<TrainingRegistrationVo> selectTrainingRegistrationPage(IPage<TrainingRegistrationVo> page, TrainingRegistrationVo trainingRegistration) {
		List<TrainingRegistrationVo> trainingRegistrationVos = baseMapper.selectTrainingRegistrationPage(page, trainingRegistration);
		trainingRegistrationVos.forEach(trainingRegistrationVo -> {
			//如果考试id 为空,考试尚未提交审核
			if (null==trainingRegistrationVo.getAuditStatus()){
				trainingRegistrationVo.setAuditStatus(4);
			}
		});
		return page.setRecords(trainingRegistrationVos);
	}

	/**
	 * 详情
	 * @param trainingRegistration 报名培训信息对象
	 */
	@Override
	public TrainingRegistrationVo selectTrainingRegistrationInfo(TrainingRegistration trainingRegistration) {
		return baseMapper.selectTrainingRegistrationInfo(trainingRegistration);
	}

	/**
	 * 导出报名数数据
	 * @param trainingRegistration 培训报名对象
	 * @return
	 */
	@Override
	public List<TrainingRegistrationExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration) {
		return baseMapper.getTrainingRegistrationExcelList(trainingRegistration);
	}

	/**
	 * 培训考试清册导入
	 * @param data
	 * @param isCovered
	 */
	@Override
	@Transactional(rollbackFor = Exception.class)
	public void importTrainingRegistration(List<TrainingRegistrationExcel> data, Boolean isCovered,String deptId) {
		//需要推送内网的保安员信息集合
		List<TrainingRegistration> trainingRegistrationList = new ArrayList<>();
		//年龄不符的保安员信息存入集合
		List<String> ageErrorList = new ArrayList<>();
		List<String> cardErrorList = new ArrayList<>();
		AtomicBoolean ageStatus = new AtomicBoolean(true);
		AtomicBoolean cardStatus = new AtomicBoolean(true);
		if (data.size()>0){
			for (TrainingRegistrationExcel trainingRegistrationExcel : data) {
				//判断是否为当前单位
				String deptIds = userDeptService.selectIn(trainingRegistrationExcel.getDeptName());
				if (null!=deptIds && !deptIds.equals("")) {
					if (null != deptId && !deptId.equals("")) {
						if (!deptId.equals(deptIds)) {
							throw new ServiceException("导入失败!不能给予不是本公司的保安员报名!");
						}
					}
				}else {
					//如果deptIds 为空，则说明还没有改公司
					throw new ServiceException("导入失败!公司名:["+trainingRegistrationExcel.getDeptName()+"]不存在!");
				}

				//身份证校验
				if (null==trainingRegistrationExcel.getIdCardNo() || trainingRegistrationExcel.getIdCardNo().equals("")){
					throw new ServiceException("导入失败!身份证号码不能为空!");
				}
				//姓名校验
				if (null==trainingRegistrationExcel.getRealName() || trainingRegistrationExcel.getRealName().equals("")){
					throw new ServiceException("导入失败!姓名不能为空!");
				}

				if (null!=trainingRegistrationExcel.getIdCardNo() && !trainingRegistrationExcel.getIdCardNo().equals("")){
					//去除所有空格
					String cardid = trainingRegistrationExcel.getIdCardNo().replaceAll(" ", "");
					//校验
					boolean b = IdCardNoUtil.checkIdCardNo(cardid);
					if(!b){
						cardStatus.set(false);
						cardErrorList.add(trainingRegistrationExcel.getIdCardNo());
						continue;
					}
				}

				//计算年龄
				Integer age = AgeUtil.idCardToAge(trainingRegistrationExcel.getIdCardNo());

				//判断年龄
				if (age<18 || age>60) {
					ageStatus.set(false);
					ageErrorList.add(trainingRegistrationExcel.getIdCardNo());
					continue;
				}

				//向内网推送数据
				//生成随机数
				String uuid = UUID.randomUUID().toString();
				//创建培训对象
				TrainingRegistration trainingRegistration = new TrainingRegistration();
				trainingRegistration.setName(trainingRegistrationExcel.getRealName());
				trainingRegistration.setDeptId(Long.parseLong(deptId));
				trainingRegistration.setIdCardNo(trainingRegistrationExcel.getIdCardNo());
				//已报名
				trainingRegistration.setCancel(1);
				//默认为未考试状态
				trainingRegistration.setIsExam(1);
				//未提交考试审核
				trainingRegistration.setAuditStatus(4);
				trainingRegistration.setTrainingTime(new Date());
				//将 user 存入 redis
				redisTemplate.opsForValue().set(uuid, JSON.toJSONString(trainingRegistration));
				//trainingRegistration 临时设置uuid 到 AcademicUrl字段
				trainingRegistration.setAcademicUrl(uuid);
				//加入集合
				trainingRegistrationList.add(trainingRegistration);
			}

			Result result = new Result();
			//培训批量插入
			if (trainingRegistrationList.size()>0) {
				//生成随机数
				String uuid = UUID.randomUUID().toString();
				//数据推送
				Map<String, Object> map = new HashMap<>(1);
				map.put(uuid, trainingRegistrationList);
//				myAsyncService.FTPObjectTrianList(map);

				int count = 0;
				//调用ftp获取返回数据
				while (true){
					try {
						Thread.sleep(1000);
					} catch (InterruptedException e) {
						e.printStackTrace();
					}
					//调用ftp获取返回数据
					result = Monitor.getFtpDataByUuidList(uuid);
					//如果返回true,就退处
					if (result.getCode() == 200) {
						break;
					}else {
						count++;
						if (count == 30) {
							break;
						}
					}
				}
			}

//			if (null!=result){
//				//获取 result
//				List<Result> data1 = result.getData();
//				if (data1.size()>0){
//					for (Result result1 : data1) {
//						// 取出 Msg ,此 msg 存的对应的 uuid
//						String uuid = result1.getMsg();
//						// 从redis 中获取对应的用户信息
//						User user = handlerUserInfo(uuid);
//						if (result1.getCode()==200){
//							user.setId(result1.getUserId());
//							this.save(user);
//						}
//						if (result1.getCode()==201){
//							user.setId(result1.getUserId());
//							user.setCreateTime(null);
//							this.updateById(user);
//						}
//						if (result1.getCode()==202){
//							status.set(false);
//							//已在其他单位存在
//							errorList.add(user.getCardid());
//						}
//						if (result1.getCode()==203){
//							securityInvalidStatus.set(false);
//							//保安证编号不匹配
//							securityInvalidList.add(user.getCardid());
//						}
//					}
//				}
//			}
			//如果所有数据导入有一个异常
			StringBuilder errorBuilder = new StringBuilder();
			if (!ageStatus.get()){
				String errorAccount = StringUtils.join(ageErrorList, "\\\n");
				errorBuilder.append("保安员:[" + errorAccount + "]报名失败!年龄不符,报名年龄为[18-60]周岁!");
			}
			if (!cardStatus.get()){
				String errorAccount = StringUtils.join(cardErrorList, "\\\n");
				errorBuilder.append("用户:[" + errorAccount + "]导入失败!身份证号码不正确,请核对!");
			}
			//抛出异常
			if (errorBuilder.length()>0){
				throw new ServiceException(errorBuilder.toString());
			}
		}
	}


	/**
	 * 生成准考证号码
	 * @param examPaper 考试报名信息对象
	 */
	private String getCandidateNo(ExamPaper examPaper) {
		//获取考试信息
		if (null!=examPaper.getStartTime()){
			String format = new SimpleDateFormat("yyyy-MM-dd").format(examPaper.getStartTime());
			String year = format.substring(2,4);
			String quarter  = null;
			String months = null;
			int month = Integer.parseInt(format.substring(5,7));
			int day = Integer.parseInt(format.substring(8,10));
			String days = null;
			if (month>0 && month<=3){
				quarter = "C";
			}
			if (month>3 && month<=6){
				quarter = "X";
			}
			if (month>6 && month<=9){
				quarter = "Q";
			}
			if (month>9 && month<=12){
				quarter = "D";
			}
			if (month<=9){
				months = "0" + month;
			}else {
				months = String.valueOf(month);
			}
			if (day<=9){
				days = "0" + day;
			}else {
				days = ""+day;
			}
			String type = null;
			if (examPaper.getExamType()==1){
				type = "z";
			}
			if (examPaper.getExamType()==2){
				type = "m";
			}
			//获取考试名称前缀,去除数字，字母
//			String examName
//				= examPaper.getExamName().replaceAll("\\s*", "").replaceAll("[^(\\u4e00-\\u9fa5)]", "").substring(0,1);

			//前缀 = 年的最后两位  + 月份（两位） + 考试名称（中文拼音）首字母（去除数字，字母） + 考试类型 + 季度拼音首字母大写（春季就是 C）
//			String result = year
//							+ months
//							+ toFirstChar(examName).toUpperCase()
//							+ examPaper.getExamType()
//							+ quarter;

			//前缀 = 年的最后两位  + 月份（两位） + 日 （两位） + 考试类型 正式考试  z   模拟考试   m
			String pre = year
				+ months
				+ days
				+ type;
			//查询是当前前缀已生成准考证号码最大的一位
			int count = examPaperService.getCandidateNoCount(pre);
			String result = null;
			//格式化
			DecimalFormat decimalFormat = new DecimalFormat("0000");
			count++;
			result = pre + (decimalFormat.format(count));
			//返回
			return result;
		}
		return null;
	}

	/**
	 * 报名
	 */
	private void saveTrainingRegistration(TrainingRegistration trainingRegistration,User user1){
		String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
		Long id = trainingRegistration.getId();
		String s = "insert into sys_training_registration(id,training_unit_id,training_time,cancel,user_id,is_exam,audit_status) " +
			"values(" + "'" + id + "'"
			+ "," + "'" + trainingRegistration.getTrainingUnitId() +"'"
			+ "," + "'" + formatStr +"'"
			+ "," + "'" + trainingRegistration.getCancel() + "'"
			+ "," + "'" + trainingRegistration.getUserId() + "'"
			+ "," + "'" + trainingRegistration.getIsExam() + "'"
			+ "," +"'" + trainingRegistration.getAuditStatus() + "'" + ");" +
			"update blade_user set is_train = " + user1.getIsTrain() + " " +"where id = " + "'" + user1.getId() + "'";
		//FtpUtil.sqlFileUpload(s);
		myAsyncService.FTP(s);
	}


	/**
	 * 查询准考证前缀相同的数量
	 * @param result
	 * @return
	 */
	@Override
	public int getCandidateNoCount(String result) {
		return baseMapper.getCandidateNoCount(result);
	}

	/**
	 * 查询培训报名信息
	 * @param trainingRegistration 培训报名对象信息
	 * @return
	 */
	@Override
	public Integer getTrainingRegistrationInfo(TrainingRegistration trainingRegistration) {
		return baseMapper.getTrainingRegistrationInfo(trainingRegistration);
	}

	/**
	 * 查询已报名培训公司未关联考试的人员
	 * @return
	 */
	@Override
	public List<TrainingRegistration> getTrainIds(TrainingRegistrationVo trainingRegistrationVo) {
		trainingRegistrationVo.setSerialStart(trainingRegistrationVo.getSerialStart() -1);
		trainingRegistrationVo.setSerialEnd(trainingRegistrationVo.getSerialEnd() -trainingRegistrationVo.getSerialStart());
		return baseMapper.getTrainIds(trainingRegistrationVo);
	}

	/**
	 * 自动处理之前报了名，申请了考试又没有去考试的，做缺考标记，并将报名状态修改为已取消报名
	 */
	@Override
	public void examApplyStatus() {
		//封装条件
		TrainingRegistration trainingRegistration = new TrainingRegistration();
		trainingRegistration.setCancel(1);
		trainingRegistration.setAuditStatus(1);
		trainingRegistration.setIsExam(1);
		//查询考试申请审核通过，已报名，未考试的人员
		List<TrainingRegistration> trainingRegistrationList = baseMapper.selectTrainingRegistrationList(trainingRegistration);
		if (trainingRegistrationList.size()>0) {
			trainingRegistrationList.forEach(trainingRegistration1 -> {
				//判断时间
				//查询考试信息
				ExamPaper paper = examPaperService.getById(trainingRegistration1.getTrainExamId());
				if (null!=paper) {
					//比对考试结束时间
					Date now = new Date();
					Date exanEndTime = paper.getEndTime();
					//考试截止时间小于当前时间，说明已过考试时间
					if (exanEndTime.before(now)) {
						//修改报名状态
						trainingRegistration1.setCancel(1);
						//缺考标记
						trainingRegistration1.setIsExam(4);
						this.updateById(trainingRegistration1);
						//修改保安报名状态
						User user = userService.getById(trainingRegistration1.getUserId());
						if (null != user) {
							//考试结束
							user.setIsTrain(3);
							userService.updateById(user);
							//生成缺考记录
							AbsentRecords absentRecords = new AbsentRecords();
							absentRecords.setUserId(user.getId());
							absentRecords.setApplyId(trainingRegistration1.getId());
							absentRecords.setExamId(Long.parseLong(trainingRegistration1.getTrainExamId()));
							absentRecords.setCandidateNo(trainingRegistration1.getCandidateNo());
							absentRecords.setCreateTime(new Date());
							//新增
							absentRecordsService.save(absentRecords);

							//新增成绩，成绩为0
							ExamScore examScore = new ExamScore();
							examScore.setCandidateNo(trainingRegistration1.getCandidateNo());
							examScore.setTheoryGrade(0);
							examScore.setAllGrade(0);
							examScore.setQualified(3);
							examScore.setUserId(user.getId().toString());
							examScore.setApplyId(trainingRegistration1.getId());
							examScore.setExamId(trainingRegistration1.getTrainExamId());
							//新增
							examScoreService.save(examScore);

							//内网同步
							String s =
								"update sys_training_registration set cancel = " + trainingRegistration1.getCancel() +
									",is_exam = " + "'" + trainingRegistration1.getIsExam() + "'" +
									" " + "where id = " + "'" + trainingRegistration1.getId() + "';" +
								"update blade_user set is_train = " + user.getIsTrain() + " " + "where id = " + "'" + user.getId() + "';" +
								"insert into sys_absent_records(id,user_id,create_time,exam_id,apply_id,candidate_no) " +
									"values(" + "'" + absentRecords.getId() + "'" + ","
									+ "'" + absentRecords.getUserId() + "'" + ","
									+ "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(absentRecords.getCreateTime()) + "'" + ","
									+ "'" + absentRecords.getExamId() + "'" + ","
									+ "'" + absentRecords.getApplyId() + "'" + ","
									+ "'" + absentRecords.getCandidateNo() + "'" + ");" +
								"insert into exam_score(id,candidate_no,theory_grade,all_grade,qualified,user_id,apply_id,exam_id) " +
									"values(" + "'" + examScore.getId() + "'" + ","
									+ "'" + examScore.getCandidateNo() + "'" + ","
									+ "'" + examScore.getTheoryGrade() + "'" + ","
									+ "'" + examScore.getAllGrade() + "'" + ","
									+ "'" + examScore.getQualified() + "'" + ","
									+ "'" + examScore.getUserId() + "'" + ","
									+ "'" + examScore.getApplyId() + "'" + ","
									+ "'" + examScore.getExamId() + "'" + ")";
							myAsyncService.FTP(s);
						}
					}
				}
			});
		}
	}

	/**
	 * 定时任务处理考试中的
	 */
	@Override
	public void examLoading() {
		//封装条件
		TrainingRegistration trainingRegistration = new TrainingRegistration();
		trainingRegistration.setCancel(1);
		trainingRegistration.setAuditStatus(1);
		trainingRegistration.setIsExam(3);
		//查询考试申请审核通过，已报名，未考试的人员
		List<TrainingRegistration> trainingRegistrationList = baseMapper.selectTrainingRegistrationList(trainingRegistration);
		if (trainingRegistrationList.size()>0){
			//遍历
			trainingRegistrationList.forEach(trainingRegistration1 -> {
				//修改考试状态,已结束
				trainingRegistration1.setIsExam(2);
				//更新
				this.updateById(trainingRegistration1);
				//查询考试成绩记录
				ExamScore examScore = new ExamScore();
				examScore.setApplyId(trainingRegistration1.getId());
				List<ExamScore> list = examScoreService.list(Condition.getQueryWrapper(examScore));
				if (list.size()>0) {
					list.forEach(examScore1 -> {
						//查询是否有考试记录
						ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
						examAnswerRecord.setScoreId(examScore1.getId());
						List<ExamAnswerRecord> examAnswerRecordList = examAnswerRecordService.list(Condition.getQueryWrapper(examAnswerRecord));
						if (examAnswerRecordList.size()>0){
							//计算成绩
							int sum = examAnswerRecordList.stream().mapToInt(ExamAnswerRecord::getAnswerScore).sum();
							examScore1.setTheoryGrade(sum);
							if (sum>=60){
								//暂未录入实操成绩
								examScore1.setQualified(2);
							}else {
								examScore1.setQualified(1);
							}
						}else {
							//理论成绩设置为0
							examScore1.setTheoryGrade(0);
							//不合格
							examScore1.setQualified(1);
						}
						//更新成绩数据
//						examScoreService.updateById(examScore1);

						//数据同步
						String s =
							"update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() +
								" " + "where id = " + "'" + trainingRegistration1.getId() + "';" +
							"update exam_score set theory_grade = " + examScore1.getTheoryGrade() +
								",qualified = " + "'" + examScore1.getQualified() + "'" +
								" " + "where id = " + "'" + examScore1.getId() + "'";
						myAsyncService.FTP(s);
					});
				}else {
					//数据同步
					String s =
						"update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() +
							" " + "where id = " + "'" + trainingRegistration1.getId() + "'";
					myAsyncService.FTP(s);
				}
			});
		}
	}

	/**
	 * 查看报名集合信息
	 * @return
	 */
	@Override
	public List<TrainingRegistration> getList(TrainingRegistrationVo trainingRegistration) {
		return baseMapper.getList(trainingRegistration);
	}
}