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

import java.math.BigDecimal;
import java.math.BigInteger;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.beanutils.BeanUtils;
import org.apache.commons.lang3.StringUtils;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
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.base.util.UUIDUtils;
import com.qxueyou.scc.exercise.model.ExerciseGroup;
import com.qxueyou.scc.exercise.service.IExerciseService;
import com.qxueyou.scc.media.model.MediaVideo;
import com.qxueyou.scc.media.service.IMediaVideoService;
import com.qxueyou.scc.org.model.OrgText;
import com.qxueyou.scc.org.service.IOrgTextService;
import com.qxueyou.scc.school.model.SchArticle;
import com.qxueyou.scc.school.model.SchClassSubject;
import com.qxueyou.scc.school.model.SchCourseware;
import com.qxueyou.scc.school.model.SchHandout;
import com.qxueyou.scc.school.service.IArticleService;
import com.qxueyou.scc.school.service.ICourseWareService;
import com.qxueyou.scc.school.service.IHandoutService;
import com.qxueyou.scc.school.service.ILessonService;
import com.qxueyou.scc.teach.subject.model.Subject;
import com.qxueyou.scc.teach.subject.model.SubjectChapter;

/**
 * 课件管理
 * 
 * @author lihanqi
 *
 */
@Service
public class CoursewareService extends CommonAppService implements ICourseWareService {
	private static Logger log = LogManager.getLogger("CoursewareService");
	
	@Autowired
	IArticleService articleService;
	
	@Autowired
	IExerciseService exerciseService;
	
	@Autowired
	IHandoutService handoutService;
	
	@Autowired
	ILessonService lessonService;
	
	@Autowired
	IMediaVideoService mediaVideoService;
	
	@Autowired
	IOrgTextService orgTextService;
	
	/**
	 * 新增章节
	 * 
	 * @param name
	 * @param parentChapterId
	 * @return
	 */
	public Result addOrUpdateChapter(String chapterId, String subjectId, String name, String parentChapterId){
		if(StringUtils.isEmpty(subjectId) || StringUtils.isEmpty(name)){
			return new Result(false, "参数错误");
		}
		SubjectChapter objSchChapter = null;
		if(StringUtils.isEmpty(chapterId)){
			objSchChapter = new SubjectChapter();
			String uuid = UUIDUtils.generateUUID().replace("-", "");
			objSchChapter.setChapterId(uuid);
			objSchChapter.setParentChapterId(StringUtils.isEmpty(parentChapterId) ? uuid : parentChapterId);
			objSchChapter.setDeleteFlag(false);
			TraceUtils.setCreateTrace(objSchChapter);
		}else{
			objSchChapter = this.read(SubjectChapter.class, chapterId);
			TraceUtils.setUpdateTrace(objSchChapter);
		}
		
		objSchChapter.setName(name);
		objSchChapter.setParentChapterId(parentChapterId);
		objSchChapter.setSubjectId(subjectId);
		
		this.save(objSchChapter);
		
		return new Result(true,"",objSchChapter);
	}
	
	/**
	 * 删除章节
	 * 
	 * @param chapterId
	 * @return
	 */
	public Result deleteChapter(String[] chapterIds){
		if(chapterIds.length == 0){
			return new Result(false, "参数错误");
		}
		int iCount = 0;
		for(String chapterId : chapterIds){//级联删除课件
			SubjectChapter chapter = this.read(SubjectChapter.class, chapterId);
			if(chapter != null && StringUtils.isEmpty(chapter.getParentChapterId())){
				iCount += this.findCount("from SchCourseware where chapterId = ? and cType = ?", CollectionUtils.newList(chapterId, 6));
			}
			this.deleteCourseWare(null, chapterId);
		}
		this.bulkUpdateInLoop("update SchChapter set deleteFlag = true where chapterId = ?", chapterIds);
		return new Result(true, "", iCount);
	}
	
	/**
	 * 拷贝课件
	 * 
	 * @param type 课件类型
	 * @param id 主键
	 * @param subjectId 课程
	 * @param collegeCourseId 科目
	 * @param chapterId 章节
	 * @return
	 */
	public Result doCopyCourseware(String type, String id, String subjectId, String collegeCourseId, String chapterId){
		try {
			subjectId = StringUtils.isEmpty(subjectId)?null:subjectId;
			chapterId = StringUtils.isEmpty(chapterId)?null:chapterId;
			collegeCourseId = StringUtils.isEmpty(collegeCourseId)?null:collegeCourseId;
			Subject subject = this.read(Subject.class, subjectId);
			String subjectName = subject == null?null:subject.getName();
			
			if(SchCourseware.COURSEWARE_TYPE_ARTICLE.equals(type)){
				SchArticle article = this.read(SchArticle.class, id);
				SchArticle newArticle = (SchArticle) BeanUtils.cloneBean(article);
				newArticle.setArticleId(null);
				
				newArticle.setChapterId(chapterId);
				newArticle.setSubjectId(subjectId);
				newArticle.setSubjectName(subjectName);
				newArticle.setOrderNum(1000);
				newArticle.setCollegeCourseId(collegeCourseId);
				OrgText text = orgTextService.getOrgText(id, OrgText.TABLE_NAME_ARTICLE);
				newArticle.setContent(text == null?null:text.getContent());
				
				articleService.updateOrgArticle(newArticle, collegeCourseId);
			}else if(SchCourseware.COURSEWARE_TYPE_EXERCISE.equals(type)){
				exerciseService.doCopyExerciseGroup(id, subjectId, collegeCourseId, chapterId);
			}else if(SchCourseware.COURSEWARE_TYPE_HANDOUT.equals(type)){
				handoutService.doCopyHandout(id, subjectId, collegeCourseId, chapterId, subjectName);
			}else if(SchCourseware.COURSEWARE_TYPE_VIDEO.equals(type)){
				MediaVideo video = this.read(MediaVideo.class, id);
				MediaVideo newVideo = (MediaVideo) BeanUtils.cloneBean(video);
				newVideo.setVideoId(null);
				
				//newVideo.setChapterId(chapterId);
				newVideo.setSubjectId(subjectId);
				newVideo.setSubjectName(subjectName);
				newVideo.setCollegeCourseId(collegeCourseId);
				newVideo.setVideoOrder(1000);
				
				lessonService.insertOrgVideo(newVideo, collegeCourseId, true);
			}
		} catch (Exception e) {
			log.error(e.getMessage(),e);
		}
		return new Result(true);
	}
	
	/**
	 * 移动课件
	 * 
	 * @param type 课件类型
	 * @param id 主键
	 * @param subjectId 课程
	 * @param collegeCourseId 科目
	 * @param chapterId 章节
	 * @return
	 */
	public Result doMoveCourseware(String type, String id, String subjectId, String collegeCourseId, String chapterId){
		
		boolean isOrg = StringUtils.isEmpty(ClientUtils.getClassId());
		subjectId = StringUtils.isEmpty(subjectId)?null:subjectId;
		chapterId = StringUtils.isEmpty(chapterId)?null:chapterId;
		collegeCourseId = StringUtils.isEmpty(collegeCourseId)?null:collegeCourseId;
		String subjectName = null;
		if(StringUtils.isNoneBlank(subjectId)){
			if(isOrg){
				subjectName = this.read(Subject.class, subjectId).getName();
			}else{
				subjectName = this.read(SchClassSubject.class, subjectId).getName();
			}
		}
		
		if(SchCourseware.COURSEWARE_TYPE_ARTICLE.equals(type)){
			SchArticle article = this.read(SchArticle.class, id);
			article.setSubjectId(subjectId);
			article.setSubjectName(subjectName);
			article.setChapterId(chapterId);
			TraceUtils.setUpdateTrace(article);
			article.setOrderNum(1000);
			
			this.articleService.saveArticle(article);
			
			this.bulkUpdate("update SchArticleReCourse set collegeCourseId = ? where articleId = ?", new Object[]{collegeCourseId, id});
		}else if(SchCourseware.COURSEWARE_TYPE_EXERCISE.equals(type)){
			ExerciseGroup exercise = this.read(ExerciseGroup.class, id);
			exercise.setSubjectId(subjectId);
			exercise.setChapterId(chapterId);
			TraceUtils.setUpdateTrace(exercise);
			exercise.setOrderNum(BigInteger.valueOf(1000));
			
			this.exerciseService.saveExerciseGroup(exercise);
			
			this.bulkUpdate("update ExerciseReCourse set collegeCourseId = ? where groupId = ?", new Object[]{collegeCourseId, id});
		}else if(SchCourseware.COURSEWARE_TYPE_HANDOUT.equals(type)){
			SchHandout handout = this.read(SchHandout.class, id);
			handout.setSubjectId(subjectId);
			handout.setSubjectName(subjectName);
			handout.setChapterId(chapterId);
			TraceUtils.setUpdateTrace(handout);
			handout.setOrderNum(1000);
			
			this.handoutService.saveHandout(handout);
			
			this.bulkUpdate("update SchHandoutReCourse set collegeCourseId = ? where handoutId = ?", new Object[]{collegeCourseId, id});
		}else if(SchCourseware.COURSEWARE_TYPE_VIDEO.equals(type)){
			MediaVideo video = this.read(MediaVideo.class, id);
			video.setSubjectId(subjectId);
			video.setSubjectName(subjectName);
			//video.setChapterId(chapterId);
			TraceUtils.setUpdateTrace(video);
			video.setVideoOrder(1000);
			
			this.mediaVideoService.saveVideo(video);
			
			this.bulkUpdate("update MediaVideoReCourse set collegeCourseId = ? where videoId = ?", new Object[]{collegeCourseId, id});
		}
		if(isOrg){
			this.bulkUpdate("update SchCourseware set collegeCourseId = ? where id = ? and orgId = ?", new Object[]{collegeCourseId, id, ClientUtils.getOrgId()});
		}
		return new Result(true);
	}
	
	/**
	 * 删除课件
	 * 
	 * @param types
	 * @param ids
	 * @param delAll
	 * @param orgIds
	 * @param classIds
	 * @return
	 */
	public Result deleteCourseware(String[] types, String[] ids, Integer delAll, String orgIds[], String classIds[]){
		
		for(String id: ids) {
			this.bulkUpdate("update SchCourseware set deleteFlag = 1 where id=? ", new Object[] {id});
		}
		
		
		Map<String, String[]> result = this.coursewareClassify(types, ids);
		
		this.articleService.deleteOrgArticleIds(result.get(SchCourseware.COURSEWARE_TYPE_ARTICLE), delAll, orgIds, classIds);
		String [] groupIds = result.get(SchCourseware.COURSEWARE_TYPE_EXERCISE);
		if(groupIds != null && groupIds.length > 0){
			String [] groupTypes = new String[groupIds.length];
			for(int i=0;i<groupIds.length;i++){
				ExerciseGroup objExerciseGroup = this.read(ExerciseGroup.class, groupIds[i]);
				groupTypes[i] = String.valueOf(objExerciseGroup.getType());
			}
			this.exerciseService.deleteExerciseGroup(StringUtils.join(groupIds, ","), StringUtils.join(groupTypes, ","), "org", delAll, orgIds, classIds);
		}
		this.handoutService.deleteOrgHandouts(result.get(SchCourseware.COURSEWARE_TYPE_HANDOUT), delAll, orgIds, classIds);
		String [] videoIds = result.get(SchCourseware.COURSEWARE_TYPE_VIDEO);
		if(videoIds != null && videoIds.length > 0){
			for(int i=0;i<videoIds.length;i++){
				this.lessonService.deleteOrgVideo(videoIds[i], delAll, orgIds, classIds);
			}
		}
		return new Result(true);
	}
	
	/**
	 * 下发课件
	 * 
	 * @param types
	 * @param ids
	 * @param orgIds
	 * @param classIds
	 * @return
	 */
	public Result doAppointCourseware(String[] types, String[] ids, String orgIds[], String classIds[], String collegeCourseId){
		Map<String, String[]> result = this.coursewareClassify(types, ids);
		
		this.articleService.insertAppointArticle(result.get(SchCourseware.COURSEWARE_TYPE_ARTICLE), orgIds, classIds, collegeCourseId);
		this.exerciseService.insertAppointExercise(result.get(SchCourseware.COURSEWARE_TYPE_EXERCISE), orgIds, classIds);
		this.handoutService.insertAppointHandout(result.get(SchCourseware.COURSEWARE_TYPE_HANDOUT), orgIds, classIds, collegeCourseId);
		this.lessonService.insertAppointOrgVideo(result.get(SchCourseware.COURSEWARE_TYPE_VIDEO), orgIds, classIds);
		
		return new Result(true);
	}
	
	/**
	 * 下发课件到子机构
	 * 
	 * @param id
	 * @param sourceOrgId
	 * @param targetOrgId
	 * @param collegeCourseId
	 * @return
	 */
	public Result insertOrgCourseware(String id, String sourceOrgId, String targetOrgId, String collegeCourseId){
		SchCourseware courseware = this.findUnique("from SchCourseware where id = ? and orgId = ? and deleteFlag is false",
				CollectionUtils.newList(id, sourceOrgId), SchCourseware.class);
		
		if(courseware == null){
			return new Result(false, "原课件不存在");
		}
		SchCourseware newCourseware = new SchCourseware();
		try {
			BeanUtils.copyProperties(newCourseware, courseware);
			
			newCourseware.setCoursewareId(null);
			newCourseware.setOrgId(targetOrgId);
			TraceUtils.setCreateTrace(newCourseware);
			
			this.save(newCourseware);
		} catch (Exception e) {
			log.error("机构下发课件报错：课件id："+id+",子机构id："+targetOrgId, e);
		}
		
		return new Result(true);
	}
	
	/**
	 * 撤回
	 * 
	 * @param id
	 * @param orgId
	 * @return
	 */
	public Result deleteOrgCourseware(String id, String orgId){
		SchCourseware courseware = this.findUnique("from SchCourseware where id = ? and orgId = ? and deleteFlag is false",
				CollectionUtils.newList(id, orgId), SchCourseware.class);
		if(courseware != null){
			courseware.setDeleteFlag(true);
			TraceUtils.setUpdateTrace(courseware);
			
			this.save(courseware);
		}
		return new Result(true);
	}
	
	/**
	 * 查询已下发的班级
	 * 
	 * @param types
	 * @param ids
	 * @return
	 */
	public Result findAlready(String[] types, String[] ids){
		Map<String, String[]> classify = this.coursewareClassify(types, ids);
		
		String[] articleId = classify.get(SchCourseware.COURSEWARE_TYPE_ARTICLE);
		String[] groupId = classify.get(SchCourseware.COURSEWARE_TYPE_EXERCISE);
		String[] handoutId = classify.get(SchCourseware.COURSEWARE_TYPE_HANDOUT);
		String[] videoId = classify.get(SchCourseware.COURSEWARE_TYPE_VIDEO);
		
		List<String> lstOrg = new ArrayList<String>();
		List<String> lstClass = new ArrayList<String>();
		if(articleId.length > 0){
			String hql = " select c.orgId from SchArticleReCourse c" 
					   + " where c.deleteFlag is false" 
					   + " and c.articleId in(:articleId)";
			lstOrg.addAll(this.findByComplexHql(hql, CollectionUtils.newObjectMap("articleId", articleId), String.class));
			lstClass.addAll(this.findByComplexHql("select distinct classId from SchArticle where deleteFlag is false and originArticleId in(:articleId) and classId is not null", CollectionUtils.newObjectMap("articleId", articleId), String.class));
		}
		if(groupId.length > 0){
			String hql = " select c.orgId from ExerciseReCourse c"
					+ " where c.deleteFlag is false"
					+ " and c.groupId in (:groupId)";
			lstOrg.addAll(this.findByComplexHql(hql, CollectionUtils.newObjectMap("groupId", groupId), String.class));
			lstClass.addAll(this.findByComplexHql("select distinct classId from ExerciseGroup where  deleteFlag is false and originExerciseId in (:groupId) and classId is not null", CollectionUtils.newObjectMap("groupId", groupId), String.class));	
		}
		if(handoutId.length > 0){
			String hql = " select c.orgId from SchHandoutReCourse c" 
					   + " where c.deleteFlag is false" 
					   + " and c.handoutId in(:handoutId)";
			lstOrg.addAll(this.findByComplexHql(hql, CollectionUtils.newObjectMap("handoutId", handoutId), String.class));
			lstClass.addAll(this.findByComplexHql("select distinct classId from SchHandout where deleteFlag is false and originHandoutId in(:handoutId) and classId is not null", CollectionUtils.newObjectMap("handoutId", handoutId), String.class));
		}
		if(videoId.length > 0){
			String hql = " select c.orgId from MediaVideoReCourse c"
					+ " where c.deleteFlag is false"
					+ " and c.videoId in(:videoId)";
			lstOrg.addAll(this.findByComplexHql(hql, CollectionUtils.newObjectMap("videoId", videoId), String.class));
			lstClass.addAll(this.findByComplexHql("select distinct classId from MediaVideo where deleteFlag is false and originVideoId in(:videoId) and classId is not null", CollectionUtils.newObjectMap("videoId", videoId), String.class));
		}
		return new Result(true, "", CollectionUtils.newObjectMap("orgs", lstOrg, "classes", lstClass));
	}
	
	/**
	 * 课件分类
	 * 
	 * @param types
	 * @param ids
	 * @return
	 */
	private Map<String, String[]> coursewareClassify(String[] types, String[] ids){
		List<String> articleId = new ArrayList<String>();
		List<String> groupId = new ArrayList<String>();
		List<String> handoutId = new ArrayList<String>();
		List<String> videoId = new ArrayList<String>();
		for(int i=0;i<ids.length;i++){
			String type = types[i];
			if(SchCourseware.COURSEWARE_TYPE_ARTICLE.equals(type)){
				articleId.add(ids[i]);
			}else if(SchCourseware.COURSEWARE_TYPE_EXERCISE.equals(type)){
				groupId.add(ids[i]);
			}else if(SchCourseware.COURSEWARE_TYPE_HANDOUT.equals(type)){
				handoutId.add(ids[i]);
			}else if(SchCourseware.COURSEWARE_TYPE_VIDEO.equals(type)){
				videoId.add(ids[i]);
			}
		}
		Map<String, String[]> result = new HashMap<String, String[]>();
		result.put(SchCourseware.COURSEWARE_TYPE_ARTICLE, articleId.toArray(new String[articleId.size()]));
		result.put(SchCourseware.COURSEWARE_TYPE_EXERCISE, groupId.toArray(new String[groupId.size()]));
		result.put(SchCourseware.COURSEWARE_TYPE_HANDOUT, handoutId.toArray(new String[handoutId.size()]));
		result.put(SchCourseware.COURSEWARE_TYPE_VIDEO, videoId.toArray(new String[videoId.size()]));
		
		return result;
	}
	
	/**
	 * 课件树排序
	 * 
	 * @param ids[] 排序的id
	 * @param type 排序类型
	 * @param parentId 父节点id
	 * @return
	 */
	public Result doOrder(String[] ids, String type, String parentId){
		for(int i=0;i<ids.length;i++){
			int index = ids.length - i;
			if("courseCategory".equals(type)){//科目类别
				this.bulkUpdate("update OrgCategoryLevel set orderNum = ? where categoryLevelId = ?", new Object[]{index, ids[i]});
			}else if("course".equals(type)){//科目
				this.bulkUpdate("update OrgCollegeCourse set orderNum = ? where collegeCourseId = ? and courseCategoryId = ?", new Object[]{index, ids[i], parentId});
			}else if("subject".equals(type)){//课程
				this.bulkUpdate("update SchSubject set orderNum = ? where subjectId = ? ", new Object[]{index, ids[i]});
			}else if("chapter".equals(type)){//章
				this.bulkUpdate("update SchChapter set orderNum = ? where chapterId = ? and subjectId = ?", new Object[]{index, ids[i], parentId});
			}else if("section".equals(type)){//节
				this.bulkUpdate("update SchChapter set orderNum = ? where chapterId = ? and parentChapterId = ?", new Object[]{index, ids[i], parentId});
			}else if("classSubject".equals(type)){//班级课程
				this.bulkUpdate("update SchClassSubject set orderNum = ? where classSubjectId = ? ", new Object[]{index, ids[i]});
			}
		}
		
		return new Result(true);
	}
	
	/*****************************************************班主任课件管理**************************************************************************************************/
	
	/**
	 * 删除课件
	 * 
	 * @param types
	 * @param ids
	 * @return
	 */
	public Result deleteClassCourseware(String[] types, String[] ids){
		Map<String, String[]> result = this.coursewareClassify(types, ids);
		
		for(String id:ids) {
			bulkUpdate("update SchCourseware set deleteFlag=true where id=?", new Object[] {id});
		}
		
		this.articleService.deleteArticle(StringUtils.join(result.get(SchCourseware.COURSEWARE_TYPE_ARTICLE), ","));
		this.exerciseService.deleteExerciseGroup(StringUtils.join(result.get(SchCourseware.COURSEWARE_TYPE_EXERCISE), ","));
		this.handoutService.deleteHandouts(result.get(SchCourseware.COURSEWARE_TYPE_HANDOUT));
		this.lessonService.deleteVideos(StringUtils.join(result.get(SchCourseware.COURSEWARE_TYPE_VIDEO), ","));
		
		return new Result(true);
	}
	
	/**
	 * 拷贝课件
	 * 
	 * @param type 课件类型
	 * @param id 主键
	 * @param subjectId 课程
	 * @param collegeCourseId 科目
	 * @param chapterId 章节
	 * @return
	 */
	public Result doCopyClassCourseware(String type, String id, String subjectId, String chapterId){
		try {
			subjectId = StringUtils.isEmpty(subjectId)?null:subjectId;
			chapterId = StringUtils.isEmpty(chapterId)?null:chapterId;
			SchClassSubject subject = this.read(SchClassSubject.class, subjectId);
			String subjectName = subject == null?null:subject.getName();
			
			if(SchCourseware.COURSEWARE_TYPE_ARTICLE.equals(type)){
				SchArticle article = this.read(SchArticle.class, id);
				SchArticle newArticle = (SchArticle) BeanUtils.cloneBean(article);
				newArticle.setArticleId(null);
				
				newArticle.setChapterId(chapterId);
				newArticle.setSubjectId(subjectId);
				newArticle.setSubjectName(subjectName);
				newArticle.setCollegeCourseId(ClientUtils.getCourseId());
				OrgText text = orgTextService.getOrgText(id, OrgText.TABLE_NAME_ARTICLE);
				newArticle.setContent(text == null?null:text.getContent());
				
				articleService.updateArticle(newArticle);
			}else if(SchCourseware.COURSEWARE_TYPE_EXERCISE.equals(type)){
				exerciseService.doCopyExerciseGroup(id, subjectId, ClientUtils.getCourseId(), chapterId);
			}else if(SchCourseware.COURSEWARE_TYPE_HANDOUT.equals(type)){
				handoutService.doCopyHandout(id, subjectId, ClientUtils.getCourseId(), chapterId, subjectName);
			}else if(SchCourseware.COURSEWARE_TYPE_VIDEO.equals(type)){
				MediaVideo video = this.read(MediaVideo.class, id);
				MediaVideo newVideo = (MediaVideo) BeanUtils.cloneBean(video);
				newVideo.setVideoId(null);
				
				//newVideo.setChapterId(chapterId);
				newVideo.setSubjectId(subjectId);
				newVideo.setSubjectName(subjectName);
				newVideo.setCollegeCourseId(ClientUtils.getCourseId());
				
				lessonService.insertVideo(newVideo,"", true);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return new Result(true);
	}
	
	/**
	 * 发布和停用
	 * 
	 * @param types
	 * @param ids
	 * @param status
	 * @return
	 */
	public Result updateStatus(String[] types, String[] ids, int status){
		Map<String, String[]> result = this.coursewareClassify(types, ids);
		if(status == 1){
			if(result.get(SchCourseware.COURSEWARE_TYPE_ARTICLE).length > 0){
				this.bulkUpdateInLoop("update SchArticle set status = 2 where articleId = ?", result.get(SchCourseware.COURSEWARE_TYPE_ARTICLE));
				this.bulkUpdateInLoop("update SchCourseware set status = 2 where id = ?", result.get(SchCourseware.COURSEWARE_TYPE_ARTICLE));
			}
			if(result.get(SchCourseware.COURSEWARE_TYPE_EXERCISE).length > 0){
				this.bulkUpdateInLoop("update ExerciseGroup set status = 2 where groupId = ?", result.get(SchCourseware.COURSEWARE_TYPE_EXERCISE));
				this.bulkUpdateInLoop("update SchCourseware set status = 2 where id = ?", result.get(SchCourseware.COURSEWARE_TYPE_EXERCISE));
			}
			if(result.get(SchCourseware.COURSEWARE_TYPE_HANDOUT).length > 0){
				this.handoutService.doStartHandouts(StringUtils.join(result.get(SchCourseware.COURSEWARE_TYPE_HANDOUT), ","));
			}
			if(result.get(SchCourseware.COURSEWARE_TYPE_VIDEO).length > 0){
				this.lessonService.doStartVideos(StringUtils.join(result.get(SchCourseware.COURSEWARE_TYPE_VIDEO), ","));
			}
			
		}else if(status == 2){
			if(result.get(SchCourseware.COURSEWARE_TYPE_ARTICLE).length > 0){
				this.bulkUpdateInLoop("update SchArticle set status = 3 where articleId = ?", result.get(SchCourseware.COURSEWARE_TYPE_ARTICLE));
				this.bulkUpdateInLoop("update SchCourseware set status = 3 where id = ?", result.get(SchCourseware.COURSEWARE_TYPE_ARTICLE));
			}
			if(result.get(SchCourseware.COURSEWARE_TYPE_EXERCISE).length > 0){
				this.bulkUpdateInLoop("update ExerciseGroup set status = 3 where groupId = ?", result.get(SchCourseware.COURSEWARE_TYPE_EXERCISE));
				this.bulkUpdateInLoop("update SchCourseware set status = 3 where id = ?", result.get(SchCourseware.COURSEWARE_TYPE_EXERCISE));
			}
			if(result.get(SchCourseware.COURSEWARE_TYPE_HANDOUT).length > 0){
				this.handoutService.doStopHandouts(result.get(SchCourseware.COURSEWARE_TYPE_HANDOUT));
			}
			if(result.get(SchCourseware.COURSEWARE_TYPE_VIDEO).length > 0){
				this.lessonService.doStopVideos(StringUtils.join(result.get(SchCourseware.COURSEWARE_TYPE_VIDEO), ","));
			}
		}
		return new Result(true);
	}
	
	/**
	 * 删除课程和章节级联删除课件
	 *  
	 * @param subjectId 机构课程id
	 * @param chapterId 章节id
	 * @param classSubjectId 班级课程id
	 * @return
	 */
	public Result deleteCourseWare(String subjectId, String chapterId){
		if(StringUtils.isNotEmpty(chapterId)){
			SubjectChapter chapter = this.read(SubjectChapter.class, chapterId);
			String newChapterId = null;
			if(StringUtils.isNotEmpty(chapter.getParentChapterId())){
				newChapterId = chapter.getParentChapterId();
			}else{
				//删除章节练习
				this.bulkUpdate("update ExerciseGroup set deleteFlag = ? where chapterId = ? and type = ?", new Object[]{true, chapterId, ExerciseGroup.TYPE_CHAPTER_ITEM});
				this.bulkUpdate("update SchCourseware set deleteFlag = ? where chapterId = ? and cType = ?", new Object[]{true, chapterId, 6});
			}
			
			this.bulkUpdate("update MediaVideo set chapterId = ? where chapterId = ?", new Object[]{newChapterId, chapterId});
			this.bulkUpdate("update SchHandout set chapterId = ? where chapterId = ?", new Object[]{newChapterId, chapterId});
			this.bulkUpdate("update ExerciseGroup set chapterId = ? where chapterId = ?", new Object[]{newChapterId, chapterId});
			this.bulkUpdate("update SchArticle set chapterId = ? where chapterId = ?", new Object[]{newChapterId, chapterId});
			
			this.bulkUpdate("update SchCourseware set chapterId = ? where chapterId = ?", new Object[]{newChapterId, chapterId});
		}
		if(StringUtils.isNotEmpty(subjectId)){
			this.bulkUpdate("update MediaVideo set subjectId = null,subjectName = null where subjectId = ?", new Object[]{subjectId});
			this.bulkUpdate("update SchHandout set subjectId = null,subjectName = null where subjectId = ?", new Object[]{subjectId});
			this.bulkUpdate("update ExerciseGroup set subjectId = null where subjectId = ?", new Object[]{subjectId});
			this.bulkUpdate("update SchArticle set subjectId = null,subjectName = null where subjectId = ?", new Object[]{subjectId});
			
			this.bulkUpdate("update SchCourseware set subjectId = null where subjectId = ?", new Object[]{subjectId});
			
			//删除章节练习
			this.bulkUpdate("update ExerciseGroup set deleteFlag = ? where subjectId = ? and type = ?", new Object[]{true, subjectId, ExerciseGroup.TYPE_CHAPTER_ITEM});
			this.bulkUpdate("update SchCourseware set deleteFlag = ? where subjectId = ? and cType = ?", new Object[]{true, subjectId, 6});
		}
		return new Result(true);
	}
	
	/**
	 * 同步更新课件课程名称
	 * 
	 * @param subjectId
	 * @param subjectName
	 * @return
	 */
	public Result updateCourseWare(String subjectId, String subjectName){
		if(StringUtils.isNotEmpty(subjectId)){
			this.bulkUpdate("update MediaVideo set subjectName = ? where subjectId = ?", new Object[]{subjectName, subjectId});
			this.bulkUpdate("update SchHandout set subjectName = ? where subjectId = ?", new Object[]{subjectName, subjectId});
			this.bulkUpdate("update SchArticle set subjectName = ? where subjectId = ?", new Object[]{subjectName, subjectId});
		}
		return new Result(true);
	}

	/**
	 * 设置学分
	 */
	public Result updateCoursewareScore(String id, int score) {
		if(StringUtils.isNotEmpty(id)){
			this.bulkUpdate("update Schchapter set score = ? where id = ?", new Object[]{score, id});
		}
		return new Result(true);
	}


	/**
	 * 查询课件
	 */
	public List<Map<String, Object>> queryCourseware(String id, String type) {
		 if(type.equals("category")) {
				 
			 List<Map<String, Object>> items=new ArrayList<Map<String, Object>>();
			 //查询项目列表
				String hql1="select collegeCourseId as id from OrgCollegeCourse where courseCategoryId=? and deleteFlag is false ";
				List<String> courseList =find(hql1, CollectionUtils.newList(id),String.class);
             //查询机构课程
				for (String courseId : courseList) {
					List<Map<String, Object>> result = queryCoursewareByCourseId(courseId);
					items.addAll(result);
				}
				return items;
		}else if(type.equals("course"))
		{
			return queryCoursewareByCourseId(id);
		}else {
			return queryCoursewareById( id ,type);
		}

	}
	
	
	
	/**
	 * 根据项目id查询所有机构课程的课件
	 * @param id
	 * @return
	 */
	public List<Map<String, Object>> queryCoursewareByCourseId(String id){
		List<Map<String, Object>> items=new ArrayList<Map<String, Object>>();
		
		String hql="select subjectId from  SchSubject where  collegeCourseId=?  and  deleteFlag is false";
		List<String> subjectList  =find(hql, CollectionUtils.newList(id),String.class);
		
		for (String subjectId : subjectList) {
			 List<Map<String, Object>> courseware = queryCoursewareById(subjectId ,"subject");
			 items.addAll(courseware);
		}
		return items;
	}
	
	/**
	 * 根据项目id查询课件
	 * @param courseId
	 * @return
	 */
	public  List<Map<String, Object>> queryCoursewareById(String id ,String type ){
		String hql="select id as id,name as name, describe as desc,type as type,score as score from SchCourseware "
				+ "where deleteFlag is false";
		
		 
		if(type.equals("course")) {
			hql+=" and collegeCourseId=:courseId";
			 
			   
		    return findListWithMapByHql(hql, CollectionUtils.newObjectMap("courseId",id));
		}
		
		if(type.equals("subject")) {
			hql+=" and subjectId=:subjectId";
			 
	
		    return findListWithMapByHql(hql, CollectionUtils.newObjectMap("subjectId",id));
		}
		
		if(type.equals("chapter")) {
			hql+=" and chapterId=:chapterId or parentChapterId=:parentChapterId";

			   
		    return  findListWithMapByHql(hql, CollectionUtils.newObjectMap("chapterId",id,"parentChapterId",id));
		}
		
		if(type.equals("section")) {
			hql+=" and chapterId=:chapterId";
			   
		    return findListWithMapByHql(hql, CollectionUtils.newObjectMap("chapterId",id));
		}
		
		return null;
		
	}

	@Override
	public Result updateCoursewareScoreValue(String id,BigDecimal scoreValue) {
		String hql = "from SchCourseware c where c.id=? and c.deleteFlag is false";
		SchCourseware  courseWare = this.findUnique(hql, CollectionUtils.newList(id), SchCourseware.class);
		courseWare.setScoreValue(scoreValue);
		this.save(courseWare);
		return new Result(true);
	}
	

	/**
	 * 获取排序
	 * 
	 * @param isOrg
	 * @param subjectId
	 * @param chapterId
	 * @return
	 */
	@Override
	public Map<String, Integer> getOrder(boolean isOrg, String subjectId, String chapterId){
		Map<String, Integer> result = new HashMap<>();
		//同步排序
		int subjectOrder = 0;
		int chapterOrder = 0;
		int partOrder = 0;
		if(StringUtils.isNoneBlank(subjectId)){
			if(isOrg){
				Subject subject = this.read(Subject.class, subjectId);
				subjectOrder = subject.getOrderNum();
			}else{
				SchClassSubject subject = this.read(SchClassSubject.class, subjectId);
				subjectOrder = subject.getOrderNum();
			}
		}
		if(StringUtils.isNoneBlank(chapterId)){
			SubjectChapter chapter = this.read(SubjectChapter.class, chapterId);
			if(StringUtils.isEmpty(chapter.getParentChapterId())){
				chapterOrder = chapter.getOrderNum();
			}else{
				SubjectChapter parentChapter = this.read(SubjectChapter.class, chapter.getParentChapterId());
				chapterOrder = parentChapter.getOrderNum();
				partOrder = chapter.getOrderNum();
			}
		}
		result.put("subjectOrder", subjectOrder);
		result.put("chapterOrder", chapterOrder);
		result.put("partOrder", partOrder);
		
		return result;
	}
	
	
	
}