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

import java.math.BigDecimal;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Service;

import com.qxueyou.scc.base.model.Result;
import com.qxueyou.scc.base.service.impl.CommonAppService;
import com.qxueyou.scc.base.util.ClientUtils;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.base.util.TraceUtils;
import com.qxueyou.scc.courseware.service.ICourseService;
import com.qxueyou.scc.org.model.OrgCategoryLevel;
import com.qxueyou.scc.org.model.OrgCollegeCourse;
import com.qxueyou.scc.teach.subject.model.Subject;
import com.qxueyou.scc.teach.subject.model.SubjectChapter;

/**
 * 项目服务类
 * 
 * @author 岩龙
 * @createtime 2017-10-31
 */
@Service
public class CourseService extends CommonAppService implements ICourseService {

	public List<Map<String, Object>> queryCategoryList() {
		String hql = "select categoryLevelId as id ,categoryName as name ,parentId as parentId,'category' as iconSkin,'true' as isParent , 'category' as type "
				+ "from OrgCategoryLevel " + "where parentId is null and deleteFlag is false";

		List<Map<String, Object>> result = findListWithMapByHql(hql, null);
		// List<OrgCategoryLevel> result = find(hql,
		// CollectionUtils.newList(categoryId), OrgCategoryLevel.class);

		return result;

	}

	public Result insertCourseCategory(String parentId, String categoryName) {
		OrgCategoryLevel vo = new OrgCategoryLevel();

		TraceUtils.setCreateTrace(vo);
		vo.setDeleteFlag(false);

		vo.setParentId(parentId);
		vo.setCategoryName(categoryName);
		vo.setOrgId(ClientUtils.getOrgId());
		vo.setTopOrgId(ClientUtils.getTopOrgId());

		save(vo);

		return new Result(true);
	}

	@Override
	public Result updateCourseCategory(String categoryId, String categoryName) {
		OrgCategoryLevel categoryLevel = read(OrgCategoryLevel.class, categoryId);

		TraceUtils.setCreateTrace(categoryLevel);
		categoryLevel.setCategoryName(categoryName);

		save(categoryLevel);

		return new Result(true);
	}

	@Override
	public Result deleteCategory(String categoryId) {
		this.bulkUpdate("update OrgCategoryLevel set deleteFlag is true where categoryLevelId=?",
				new Object[] { categoryId });

		return new Result(true, "Operation Success");
	}

	@Override
	public List<Map<String, Object>> queryCourse(String categoryId) {
		String hql = "select collegeCourseId as id , name as name ,courseCategoryId as parentId ,'course' as iconSkin,'true' as isParent,'course' as type  "
				+ " from OrgCollegeCourse" + " where courseCategoryId =:categoryId  and deleteFlag is false";

		return findListWithMapByHql(hql, CollectionUtils.newObjectMap("categoryId", categoryId));
	}

	@Override
	public Result insertCourse(String categoryId, String courseName) {
		OrgCollegeCourse course = new OrgCollegeCourse();
		TraceUtils.setCreateTrace(course);
		course.setDeleteFlag(false);

		course.setCourseCategoryId(categoryId);
		course.setName(courseName);
		course.setOrganizationId(ClientUtils.getOrgId());
		course.setTopOrgId(ClientUtils.getTopOrgId());
		course.setPrice(BigDecimal.ONE);

		save(course);

		return new Result(true);
	}

	@Override
	public Result updateCourse(String courseId, String courseName) {
		OrgCollegeCourse course = read(OrgCollegeCourse.class, courseId);

		TraceUtils.setUpdateTrace(course);
		course.setName(courseName);

		save(course);

		return new Result(true, "Operation Success");
	}

	@Override
	public Result deleteCourse(String courseId) {

		this.bulkUpdate("update OrgCollegeCourse set deleteFlag is true where collegeCourseId=?",
				new Object[] { courseId });

		return new Result(true, "Operation Success");
	}

	@Override
	public List<Map<String, Object>> querySubject(String courseId) {
		String hql = "select subjectId as id ,name as name ,collegeCourseId as parentId ,'subject' as iconSkin,'true' as isParent,'subject' as type"
				+ " from  SchSubject " + "where collegeCourseId=:courseId and  deleteFlag is false";

		return findListWithMapByHql(hql, CollectionUtils.newObjectMap("courseId", courseId));
	}

	@Override
	public Result insertSubject(String courseId, String subjectName) {
		Subject subject = new Subject();

		TraceUtils.setCreateTrace(subject);
		subject.setDeleteFlag(false);

		subject.setName(subjectName);

		save(subject);

		return new Result(true, "Operation Success");
	}

	@Override
	public Result updateSubject(String subjectId, String subjectName) {
		Subject subject = read(Subject.class, subjectName);

		TraceUtils.setUpdateTrace(subject);
		subject.setName(subjectName);

		save(subject);

		return new Result(true);
	}

	@Override
	public Result deleteSubject(String subjectId) {

		this.bulkUpdate("update SchSubject set deleteFlag is true where subjectId=?", new Object[] { subjectId });

		return new Result(true, "Operation Success");
	}

	@Override
	public List<Map<String, Object>> queryChapter(String subjectId) {
		String hql = "select chapterId as id ,name as name,parentChapterId as parentId,'chapter' as iconSkin,'true' as isParent,'chapter' as type "
				+ " from SchChapter "
				+ "where subjectId =:subjectId and parentChapterId is null and deleteFlag is false ";

		// List<SchChapter> result = find(hql,
		// CollectionUtils.newList(subjectId), SchChapter.class);

		return findListWithMapByHql(hql, CollectionUtils.newObjectMap("subjectId", subjectId));
	}

	@Override
	public List<Map<String, Object>> querychildChapter(String id) {
		String hql = "select chapterId as id ,name as name,parentChapterId as parentId,'section' as iconSkin,'false' as isParent,'section' as type "
				+ " from SchChapter " + "where parentChapterId =:parentChapterId and deleteFlag is false ";

		return findListWithMapByHql(hql, CollectionUtils.newObjectMap("parentChapterId", id));
	}

	@Override
	public Result insertChapter(String subjectId, String chapterId, String chapterName, String courseId) {
		SubjectChapter chapter = new SubjectChapter();

		TraceUtils.setCreateTrace(chapter);
		chapter.setDeleteFlag(false);

		chapter.setSubjectId(subjectId);
		chapter.setParentChapterId(chapterId);
		chapter.setName(chapterName);

		save(chapter);

		return new Result(true);
	}

	@Override
	public Result updateChapter(String chapterId, String chapterName) {
		SubjectChapter schChapter = read(SubjectChapter.class, chapterId);

		TraceUtils.setUpdateTrace(schChapter);
		schChapter.setName(chapterName);

		save(schChapter);

		return new Result(true);
	}

	@Override
	public Result deleteChapter(String chapterId) {
		this.bulkUpdate("update SchChapter set deleteFlag is true where chapterId=?", new Object[] { chapterId });

		return new Result(true, "操作成功!");
	}

	// 显示有过班级的项目名称
	@Override
	public List<Map<String, Object>> queryCourseName() {
		String hql = "select collegeCourseId as id , name as name  from OrgCollegeCourse where  deleteFlag is false  order by createTime asc";

		return findListWithMapByHql(hql, null);
	}

	// PC端首页显示有过班级的项目名称
	@Override
	public List<Map<String, Object>> findclassNameByCourse(String mode) {
		String hql = "select  distinct  c.collegeCourseId as id , c.name as name  from OrgCollegeCourse c ,ClsClass o where  o.deleteFlag is false and c.deleteFlag is false and o.collegeCourseId =c.collegeCourseId ";

		Map<String,Object> map =new HashMap<String, Object>();
		if (mode.equals("0")) {
			hql = hql.concat(" and o.mode = 0 and o.approveStatus = 4  and o.signupEndTime>:nowDate ");
			map.put("nowDate", new Date());
		}
		if (mode.equals("1")) {
			hql = hql.concat(" and o.mode = 1 and o.approveStatus = 4 ");
		}
		List<Map<String, Object>> lstCourse = findListWithMapByHql(hql, map);
		return lstCourse;
	}

	/**
	 * 删除科目下的项目
	 * 
	 * @param categoryId
	 * @return
	 */
	public Result deleteCourseByParentId(String categoryId) {
		String hql = "from OrgCollegeCourse where courseCategoryId=? and  deleteFlag =false ";

		List<OrgCollegeCourse> list = find(hql, CollectionUtils.newList(categoryId), OrgCollegeCourse.class);

		for (OrgCollegeCourse orgCollegeCourse : list) {
			TraceUtils.setUpdateTrace(orgCollegeCourse);
			orgCollegeCourse.setDeleteFlag(true);
			save(orgCollegeCourse);
		}
		return new Result(true);
	}

	/**
	 * 删除项目下的课程
	 * 
	 * @param courseId
	 * @return
	 */
	public Result deleteSubjectByParentId(String courseId) {
		String hql = "from SchSubject where collegeCourseId= ? and  deleteFlag = false";

		List<Subject> list = find(hql, CollectionUtils.newList(courseId), Subject.class);

		for (Subject schSubject : list) {
			TraceUtils.setUpdateTrace(schSubject);
			schSubject.setDeleteFlag(true);
			save(schSubject);
		}
		return new Result(true);
	}

	/**
	 * 删除节
	 * 
	 * @param chapterId
	 * @return
	 */
	public Result deleteChapterByParentId(String chapterId) {
		String hql = "from SchChapter where parentChapterId=? and deleteFlag = false ";

		List<SubjectChapter> list = find(hql, CollectionUtils.newList(chapterId), SubjectChapter.class);

		for (SubjectChapter schChapter : list) {
			TraceUtils.setUpdateTrace(schChapter);
			schChapter.setDeleteFlag(true);
			save(schChapter);
		}

		return new Result(true);

	}

	/**
	 * 删除树节点
	 */
	public Result deleteNode(String id, String type) {
		if (type.equals("category")) {
			return this.deleteCategory(id);

		} else if (type.equals("course")) {
			return this.deleteCourse(id);

		} else if (type.equals("subject")) {
			return this.deleteSubject(id);

		} else if (type.equals("chapter") || type.equals("section")) {
			return this.deleteChapter(id);
		} else {
			return new Result(false, "Parameter error");
		}
	}

}