package com.qxueyou.scc.exam.service.impl;

import java.text.SimpleDateFormat;
import java.util.*;

import com.qxueyou.scc.exam.model.ExamResultV;
import org.springframework.stereotype.Service;

import com.qxueyou.scc.base.model.Pager;
import com.qxueyou.scc.base.model.Result;
import com.qxueyou.scc.base.service.impl.CommonAppService;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.base.util.TraceUtils;
import com.qxueyou.scc.exam.model.ExamBatchClassRe;
import com.qxueyou.scc.exam.model.ExamBatchInfo;
import com.qxueyou.scc.exam.service.IExamBatchService;

/**
 * 试卷批次管理服务层
 *
 * @author kevin
 * @createTime 2017-11-1
 */
@Service
public class ExamBatchService extends CommonAppService implements IExamBatchService {

	@Override
	public int queryExamBatchCount(Map<String, Object> param) {
		// TODO Auto-generated method stub
		return 0;
	}

	@Override
	public List<ExamBatchInfo> queryExamBatchList(Map<String, Object> param,Pager page) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public List<Map<String,Object>> queryListForIdName() {
//		String hql="select v from ExamResultV v where v.startTime >? ";
		//根据考试获取所有批次信息
		String hql="select r from ExamBatchInfo i , ExamBatchClassRe r where i.examId in (SELECT e.examId from ExamInfo e where e.deleteFlag is false )" +
				" and i.deleteFlag is false and i.startTime>? and r.examBatchId=i.examBatchId ";
		//获取列表，开始时间大于当前时间，也就是还未开始
		List<ExamBatchClassRe> examResults = this.find(hql, CollectionUtils.newList(new Date()), ExamBatchClassRe.class);
		List<Map<String,Object>> list=new ArrayList<>();
		for (ExamBatchClassRe examResult : examResults) {
			//封装成前端要用的数据
			Map<String,Object> map=new HashMap<>();
			//获取考试名称加批次信息
			String ql="SELECT e.examName from ExamInfo e where e.deleteFlag is false and e.examId=?";
			//获取考试名称
			String s = this.findUnique(ql, CollectionUtils.newList(examResult.getExamId()), String.class);
			String q="SELECT e from ExamBatchInfo e where e.deleteFlag is false and e.examBatchId=?";
			//批次信息
			ExamBatchInfo examBatchInfo = this.findUnique(q, CollectionUtils.newList(examResult.getExamBatchId()), ExamBatchInfo.class);
			SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			//测试考试(考场一_2020-06-16 9:00 ~ 06-16 12:00)
			s+="("+examBatchInfo.getExamRoomName()+"_"+format.format(examBatchInfo.getStartTime())+" ~ "+new SimpleDateFormat("MM-dd HH:mm:ss").format(examBatchInfo.getEndTime())+")";
			map.put("batchName",s);
			map.put("batchId",examResult.getExamBatchId());
			map.put("classId",examResult.getClassId());
			list.add(map);
		}
		return list;
	}
	@Override
	public List<String> queryComNameByBatchId(String classId) {
		//根据所在组id
		String hql="select f.subjectId from StuStudent f where f.subjectId is not null and f.classId =? and f.deleteFlag is false group by f.subjectId";
		//获取公司名称列表
		return this.find(hql, CollectionUtils.newList(classId), String.class);
	}
	@Override
	public List<String> queryStudentNoByComNameAndBatch(String subjectId,String classId) {
		//根据所在组id
//		String hql="select f.studentNo from StuStudent f where f.subjectId=? and f.classId =? and f.deleteFlag is false ";
		String hql="select f.studentNo from StuStudent f where  f.classId =? and f.deleteFlag is false ";
		//获取列表
//		return this.find(hql, CollectionUtils.newList(subjectId,classId), String.class);
		return this.find(hql, CollectionUtils.newList(classId), String.class);
	}

	@Override
	public String addExamBatch(ExamBatchInfo examBatchInfo) {
		//查询最大批次号
		Short  maxBatchNo = this.findUnique("select max(f.examBatchNo) from ExamBatchInfo f where f.examId =? and f.deleteFlag is false", CollectionUtils.newList(examBatchInfo.getExamId()), Short.class);
		maxBatchNo = maxBatchNo==null?0:maxBatchNo;
		examBatchInfo.setExamBatchNo(++maxBatchNo);
		TraceUtils.setCreateTrace(examBatchInfo);
		this.insert(examBatchInfo);
		List<ExamBatchClassRe> lstExamBatchClassRe = examBatchInfo.getReClasses();
		if(lstExamBatchClassRe!=null &&lstExamBatchClassRe.size()>0){
			for(ExamBatchClassRe examBatchClassRe :lstExamBatchClassRe){
				TraceUtils.setCreateTrace(examBatchClassRe);
				examBatchClassRe.setExamBatchId(examBatchInfo.getExamBatchId());
				examBatchClassRe.setExamId(examBatchInfo.getExamId());
				this.insert(examBatchClassRe);
			}
		}
		return examBatchInfo.getExamBatchId();
	}

	@Override
	public Result deleteExamBatch(String[] elxamBatchIds) {
		Result result = new Result(true) ;
		if(elxamBatchIds!=null && elxamBatchIds.length>0 ){
			String hql = "update ExamBatchInfo set deleteFlag = true where examBatchId=?";
			result = bulkUpdateInLoop(hql, elxamBatchIds);
		}
		return result;
	}

	@Override
	public Result updateExamBatch(ExamBatchInfo param) {
		ExamBatchInfo examBatchInfo = read(ExamBatchInfo.class, param.getExamBatchId());
		if(examBatchInfo!=null){
			TraceUtils.setUpdateTrace(examBatchInfo);
			examBatchInfo.setStartTime(param.getStartTime());
			examBatchInfo.setEndTime(param.getEndTime());
			List<ExamBatchClassRe> lstExamBatchClassRe = param.getReClasses();
			//删除原来的关联关系
			String hql="update ExamBatchClassRe set deleteFlag = true where examBatchId=? ";
			this.bulkUpdate(hql, new Object[]{ param.getExamBatchId()});

			if(lstExamBatchClassRe!=null &&lstExamBatchClassRe.size()>0){
				for(ExamBatchClassRe examBatchClassRe :lstExamBatchClassRe){
					TraceUtils.setCreateTrace(examBatchClassRe);
					examBatchClassRe.setExamBatchId(examBatchInfo.getExamBatchId());
					examBatchClassRe.setExamId(examBatchInfo.getExamId());
					this.insert(examBatchClassRe);
				}
			}
		}
		return save(examBatchInfo);
	}

	@Override
	public ExamBatchInfo queryExamBatchDetail(String examBatchId) {
		return this.read(ExamBatchInfo.class, examBatchId);
	}

	@Override
	public ExamBatchClassRe queryExamBatchByClassId(String examBatchId) {
		String hql="select f from ExamBatchClassRe f where f.examBatchId =? and f.deleteFlag is false";
		return this.findUnique(hql, CollectionUtils.newList(examBatchId), ExamBatchClassRe.class);
	}

}