package com.qxueyou.scc.admin.progress.dao;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.cache.annotation.CachePut;
import org.springframework.cache.annotation.Cacheable;
import org.springframework.stereotype.Repository;

import com.qxueyou.scc.admin.progress.model.Progress;
import com.qxueyou.scc.admin.progress.model.SubjectLectureProgressDetail;
import com.qxueyou.scc.admin.progress.model.view.SubjectProgressTreeV;
import com.qxueyou.scc.admin.progress.service.impl.StudyProgressUtils;
import com.qxueyou.scc.base.dao.BaseDAO;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.teach.subject.model.Subject;

@Repository
public class ProgressDAO extends BaseDAO {

	public Progress getProgress(String progressTypeLecture, String targetId, String learnerId) {

		String hql = "from Progress where type=:type and learnerId=:learnerId and targetId=:targetId";
		Progress progress = findUniqueByHql(hql, CollectionUtils.newObjectMap("type", Progress.PROGRESS_TYPE_LECTURE,
				"learnerId", learnerId, "targetId", targetId));

		return progress;
	}

	/**
	 * 根据targetId和learnerId获取进度
	 *
	 * @param targetId
	 *            targetId
	 * @param learnerId
	 *            学习者id
	 * @return
	 */
	@Cacheable(value = "progress", key = "#targetId+#learnerId")
	public int[][] getProgress(String targetId, String learnerId) {
		List<SubjectLectureProgressDetail> lstDetail = this.find("from SubjectLectureProgressDetail where targetId = ? and learnerId = ? and deleteFlag is false", CollectionUtils.newList(targetId, learnerId), SubjectLectureProgressDetail.class);
		if(lstDetail == null || lstDetail.isEmpty()) {
			return new int[][] {};
		}else {
			int[][] progress = new  int[lstDetail.size()][2];
			 int i = 0;
			 for(SubjectLectureProgressDetail objDetail : lstDetail) {
				 progress[i++] = new int[] {objDetail.getStart(), objDetail.getEnd()};
			 }

			 return progress;
		}
	}

	@CachePut(value = "progress", key = "#targetId+#learnerId")
	public int[][] mergeProgress(String targetId, String learnerId, int start, int end, int[][] origProgress) {
		return StudyProgressUtils.merge(origProgress, start, end);
	}

	/**
	 * 获取学生的各个节点的学习进度,进度值
	 *
	 * @param parentId
	 * @param userId
	 * @return
	 */
	public Map<String, Object> getItemProgress(String parentId, String userId) {
		String getProgressAvgByHql = "select avg(percent) as progressPercent , sum(progressValue) as progressValue"
				+ "  from  SubjectProgressTreeV  where  parentId =:parentId and id.userId =:userId";
		List<Map<String, Object>> mapLst = findListWithMapByHql(getProgressAvgByHql,
				CollectionUtils.newObjectMap("parentId", parentId, "userId", userId));
		Map<String, Object> map = mapLst.get(0);
		return map;
	}

	/**
	 * 获取当前节点下的父节点
	 *
	 * @param nodeId
	 * @return
	 */
	public SubjectProgressTreeV getSubjectProgressTreeV(String nodeId, String userId) {
		String hql = "from SubjectProgressTreeV where  id.nodeId =:nodeId and id.userId =:userId";
		SubjectProgressTreeV subjectProgressTreeV = findUniqueByHql(hql,
				CollectionUtils.newObjectMap("nodeId", nodeId, "userId", userId));
		return subjectProgressTreeV;
	}

	/**
	 * 根据subjectId获取章节列表
	 *
	 * @param parentId
	 * @param userId
	 * @return
	 */
	public List<SubjectProgressTreeV> getSubjectChapterTreeVList(String parentId, String userId) {
		String hql = "from SubjectProgressTreeV where  parentId =:parentId and id.userId =:userId and nodeType='chapter' order by createTime asc";
		return findByComplexHql(hql, CollectionUtils.newObjectMap("parentId", parentId, "userId", userId),
				SubjectProgressTreeV.class);
	}

	/**
	 * 获取progress 对象
	 */
	public Progress getProgressObject(String targetId, String userId) {
		return findUniqueByHql(
				"from Progress where targetId =:targetId and learnerId =:userId  and deleteFlag is false",
				CollectionUtils.newObjectMap("targetId", targetId, "userId", userId));
	}

	/**
	 * 记录用户每个课程学习的位置
	 */
	@CachePut(value = "lastStudied", key = "#userId + #subjectId + #classId")
	public Map<String, Object> putStudyById(String userId, String subjectId, String lectureId, String lectureParentId,
			String classId) {
		Map<String, Object> map = new HashMap<String, Object>(4);
		Subject subject = this.read(Subject.class, subjectId);
		map.put("subjectId", subjectId);
		map.put("lectureId", lectureId);
		map.put("lectureParentId", lectureParentId);
		map.put("classId", classId);
		map.put("subjectName", subject.getName());
		return map;
	}

	@CachePut(value = "lastStudied", key = "#userId")
	public Map<String, Object> putStudyByUserId(String userId, String subjectId, String lectureId,
			String lectureParentId, String classId) {
		Map<String, Object> map = new HashMap<String, Object>(4);
		map.put("subjectId", subjectId);
		map.put("lectureId", lectureId);
		map.put("lectureParentId", lectureParentId);
		map.put("classId", classId);
		return map;
	}

	/**
	 * 获取用户每个课程上次学习的数据
	 */
	@Cacheable(value = "lastStudied", key = "#userId + #subjectId +#classId")
	public Map<String, Object> getStudyById(String userId, String subjectId, String classId) {
		return new HashMap<String, Object>();
	}

	/**
	 * 获取用户上次学习的数据
	 */
	@Cacheable(value = "lastStudied", key = "#userId")
	public Map<String, Object> getStudyByUserId(String userId) {
		return new HashMap<String, Object>();
	}

}