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


import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.Timestamp;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang3.StringUtils;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.alibaba.fastjson.JSONObject;
import com.qxueyou.scc.base.model.Constants;
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.ClientUtils;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.base.util.DateTimeUtils;
import com.qxueyou.scc.base.util.DateUtils;
import com.qxueyou.scc.base.util.TraceUtils;
import com.qxueyou.scc.exercise.model.ExciseExtendReqData;
import com.qxueyou.scc.exercise.model.ExerGroupResponseData;
import com.qxueyou.scc.exercise.model.ExerItemResponseData;
import com.qxueyou.scc.exercise.model.ExerciseDataSubmitLog;
import com.qxueyou.scc.exercise.model.ExerciseExtendRecordData;
import com.qxueyou.scc.exercise.model.ExerciseFault;
import com.qxueyou.scc.exercise.model.ExerciseFaultBook;
import com.qxueyou.scc.exercise.model.ExerciseFaultHis;
import com.qxueyou.scc.exercise.model.ExerciseFaultRecord;
import com.qxueyou.scc.exercise.model.ExerciseFaultStatistics;
import com.qxueyou.scc.exercise.model.ExerciseFavorite;
import com.qxueyou.scc.exercise.model.ExerciseFavoriteBook;
import com.qxueyou.scc.exercise.model.ExerciseFavoriteHis;
import com.qxueyou.scc.exercise.model.ExerciseFavoriteRecord;
import com.qxueyou.scc.exercise.model.ExerciseGroup;
import com.qxueyou.scc.exercise.model.ExerciseItem;
import com.qxueyou.scc.exercise.model.ExerciseItemAnalisi;
import com.qxueyou.scc.exercise.model.ExerciseItemAnalisiU;
import com.qxueyou.scc.exercise.model.ExerciseItemAnswerData;
import com.qxueyou.scc.exercise.model.ExerciseItemAnswerU;
import com.qxueyou.scc.exercise.model.ExerciseRecord;
import com.qxueyou.scc.exercise.model.ExerciseSubmitAnswerData;
import com.qxueyou.scc.exercise.model.ExerciseSubmitAnswerDataList;
import com.qxueyou.scc.exercise.service.IExerciseExtendService;
import com.qxueyou.scc.exercise.service.IExerciseVerService;
import com.qxueyou.scc.exercise.util.ExerciseUtils;


/**
 * Á·Ï°  ʵÏÖservice
 * @author zhiyong
 *
 */
@Service(value = "exerciseExtendService")
public class ExerciseExtendService extends CommonAppService implements IExerciseExtendService {
	/** ÈÕÖ¾ */
	private static final Logger log = LogManager.getLogger(ExerciseExtendService.class);
	
	/** Á·Ï°½Ó¿Úservice  */
	@Autowired
	private IExerciseVerService exerciseVerService;
	
	/** ×öÌâ¼Ç¼id */
	private static final String EXERCISE_RECORD_ID = "exerciseRecordId";
	
	/** ¸üÐÂʱ¼ä */
	private static final String UPDATE_TIME = "updateTime";
	
	/**
	 * ÐÂÔöÊÕ²Øbook¼Ç¼
	 * @param groupId
	 * @return 
	 */
	public String insertExerciseFavorBook(String currTitleNum) {
		
		ExerciseFavoriteBook record = new ExerciseFavoriteBook();
		record.setUserId(ClientUtils.getUserId());
		record.setClassId(ClientUtils.getClassId());
		record.setDeleteFlag(false);
		//record.setTitleMaxNumber(currTitleNum);
		TraceUtils.setCreateTrace(record);
		
		this.save(record);
		
		return record.getFavoriteBookId();
	}
	
	/**
	 * ÐÂÔö´íÌâbook¼Ç¼
	 * @param groupId
	 * @return 
	 */
	public String insertExerciseFaultBook() {
		
		ExerciseFaultBook record = new ExerciseFaultBook();
		record.setUserId(ClientUtils.getUserId());
		record.setClassId(ClientUtils.getClassId());
		record.setDeleteFlag(false);
		TraceUtils.setCreateTrace(record);
		
		this.save(record);
		
		return record.getResumeBookId();
	}
	
	/**
	 * ÐÂÔöÊղؼǼ
	 * @param groupId
	 * @return 
	 */
	public Result insertExerciseFavor(String favoriteBookId, String exerciseItemId) {
		ExerciseFavorite record = new ExerciseFavorite();
		record.setFavoriteBookId(favoriteBookId);
		record.setExerciseItemId(exerciseItemId);
		record.setDeleteFlag(false);
		TraceUtils.setCreateTrace(record);
		
		this.save(record);
		
		return new Result(true);
	}
	
	/**
	 * ÐÂÔö´íÌâ¼Ç¼
	 * @param groupId
	 * @return 
	 */
	public Result insertExerciseFault(String resumeBookId, String exerciseItemId, String repeatFlag) {
		ExerciseFault record = new ExerciseFault();
		record.setExerciseItemId(exerciseItemId);
		record.setResumeBookId(resumeBookId);
		record.setDeleteFlag(false);
		TraceUtils.setCreateTrace(record);
		
		this.save(record);
		
		return new Result(true);
	}
	
	/** -------------------------APP--V2.0- start------------------------------------------- */
	/**
	 * ²Ù×÷´íÌâ¼Ç¼
	 */
	public Map<String,Object> doOperExerciseFaultRecordData(String subjectId, ExciseExtendReqData recordResult) {
		// Á·Ï°×éid
		String exerciseGroupId = recordResult.getExerciseGroupId();
		String exerciseGroupType = recordResult.getExerciseGroupType();
		
		// 1.²Ù×÷Á·Ï°×ܼǼ
		ExerciseFaultBook resumeBook = doOperExerciseFaultBook(subjectId,recordResult);
		String resumeBookId = resumeBook.getResumeBookId();
		
		// 2.²Ù×÷Á·Ï°¼Ç¼
		ExerciseFaultRecord record = doOperExerciseFaultRecord(resumeBookId,
				exerciseGroupId, exerciseGroupType, recordResult);
		
		String faultRecordId = record.getFaultRecordId();
		
		// 3.×é×°´íÌâ½á¹ûÈë¿â
		doOperFaultExerciseToDB(resumeBookId, faultRecordId, recordResult);
		
		// 4.ÖØмÆËã×öÌâ¼Ç¼ÕýÈ·¸öÊý ×öÌâ¸öÊý  ÕýÈ·ÂÊ  ´íÌâ±¾
		record = this.doCalcFaultExericseStatisBySubmitData(record,resumeBook,subjectId);
		
		// 5.·µ»Ø½á¹û
		Map<String,Object> map = new HashMap<String, Object>(3);
		map.put(EXERCISE_RECORD_ID, faultRecordId);
		map.put("exerciseGroupId", exerciseGroupId);
		map.put(UPDATE_TIME, DateTimeUtils.getCurrDateTime(record.getUpdateTime()));
		
		return map;
	}
	
	/**
	 * ÖØмÆËã´íÌârecordÊý¾Ý½á¹û
	 * @param record
	 * @return
	 */
	@SuppressWarnings("unchecked")
	public Result updateExerciseFaultRecordData(ExerciseFaultRecord record){
		String sql = "SELECT"+
				" count(1) allCount,"+
				" sum(CORRECT = 1) corrCount,"+
				" sum(ANSWER IS NOT NULL) doCount,"+
				" round(sum(CORRECT = 1) / count(1) * 100,2) accuracy,"+
				" round(sum(ANSWER IS NOT NULL) / count(1) * 100,2) rate"+
				" FROM exercise_fault"+
				" WHERE DELETE_FLAG = 0"+
				" AND FAULT_RECORD_ID = ?";

		List<Object[]> lstFault = this.findBySql(sql,  CollectionUtils.newList(record.getFaultRecordId()));
		
		Object[] objs = lstFault.get(0);
		
		// ²ð·Ö×ÓÊý¾Ý
		packagingExerciseFaultRecordData(record, objs);
		
		if(record.getAllCount().compareTo(BigInteger.ZERO) == 0){// È«²¿É¾³ýºó Êý¾ÝÇå0
			record.setTitleMaxNumber("0");
			record.setStatus("0");
		}else if(StringUtils.isNotBlank(record.getTitleMaxNumber()) && 
				record.getAllCount().compareTo(new BigInteger(record.getTitleMaxNumber())) < 0){// ×ܸöÊýСÓÚ×î´óÌâºÅÊý
			record.setTitleMaxNumber(String.valueOf(record.getAllCount()));
		}
		TraceUtils.setUpdateTrace(record);
		this.save(record);
		
		return new Result(true);
	}
	
	/**
	 * ÖØмÆËã´íÌârecordÊý¾Ý½á¹û   ²ð·Ö×ÓÊý¾Ý
	 * @param record
	 * @param objs
	 */
	private void packagingExerciseFaultRecordData(ExerciseFaultRecord record,
			Object[] objs) {
		record.setAllCount((BigInteger)objs[0]);
		record.setCorrectCount(new BigInteger(String.valueOf(objs[1]==null ? "0" : objs[1])));
		record.setDoCount(new BigInteger(String.valueOf(objs[2]==null ? "0" : objs[2])));
		record.setAccuracy(new BigDecimal(String.valueOf(objs[3]==null ? "0" : objs[3])));
		record.setCompletionRate(new BigDecimal(String.valueOf(objs[4]==null ? "0" : objs[4])));
		record.setScore(record.getAccuracy());
	}
	
	/**
	 * ÖØмÆËã×öÌâ¼Ç¼×ܸöÊý    ´íÌâ±¾ ÕýÈ·¸öÊý ×öÌâ¸öÊý  ÕýÈ·ÂÊ  ´íÌâ±¾
	 * @return
	 */
	public ExerciseFaultRecord doCalcFaultExericseStatisBySubmitData(ExerciseFaultRecord record,
			ExerciseFaultBook resumeBook, String subjectId){
		// 1.¼ÆËã×öÌâ×ܸöÊý record
		this.updateExerciseFaultRecordData(record);
		
		// 2.¼ÆËã¸Ã°à¼¶µÄ×ܸöÊý
		this.updateExerciseFaultBookInfo(resumeBook);
		if(resumeBook.getAllCount().compareTo(BigInteger.ZERO) == 0){// È«²¿É¾³ýºó Êý¾ÝÇå0
			resumeBook.setTitleMaxNumber("0");
			resumeBook.setStatus("0");
		}else if(StringUtils.isNotBlank(resumeBook.getTitleMaxNumber()) && 
				resumeBook.getAllCount().compareTo(new BigInteger(resumeBook.getTitleMaxNumber())) < 0){// ×ܸöÊýСÓÚ×î´óÌâºÅÊý
			resumeBook.setTitleMaxNumber(String.valueOf(resumeBook.getAllCount()));
		}
		TraceUtils.setUpdateTrace(resumeBook);
		this.save(resumeBook);
		
		return record;
	}
	
	/**
	 * ×é×°´íÌâ½á¹ûÈë¿â
	 * @param resumeBookId
	 * @param faultRecordId
	 * @param recordResult
	 * @return
	 */
	private Result doOperFaultExerciseToDB(String resumeBookId, String faultRecordId, ExciseExtendReqData recordResult){
		List<ExerciseExtendRecordData> lstItems = recordResult.getItems();
		
		Map<String, Object> argsMap = new HashMap<String, Object>();
		Object[] args = new Object[lstItems.size()];
		for(int i=0; i<lstItems.size(); i++){
			args[i] = lstItems.get(i).getExerciseId();
		}
		argsMap.put("exerciseIds", args);
		argsMap.put("resumeBookId", resumeBookId);
		
		//  ²éѯ´ËÓû§ÊÇ·ñÓдíÌâ¼Ç¼
		String hql = "from ExerciseFault where exerciseItemId in (:exerciseIds) and resumeBookId=:resumeBookId and deleteFlag is false ";
		List<ExerciseFault> lstExistfavor = this.findByComplexHql(hql, argsMap, ExerciseFault.class);
		
		Map<String, ExerciseFault> faultMap = new HashMap<String, ExerciseFault>();
		for(ExerciseFault fault:lstExistfavor){
			faultMap.put(fault.getExerciseItemId(), fault);
		}
		
		List<ExerciseFault> lstFault = new ArrayList<ExerciseFault>(recordResult.getItems().size());
		ExerciseFault fault=null;
		
		// Ñ­»·Ã¿Ò»Ìõ¼Ç¼
		// ÅжϿͻ§¶ËÌá½»µÄÊý¾ÝÊÇ·ñÖظ´map
		Map<String,Object> repeatMap = new HashMap<String,Object>(lstItems.size());
		
		for(ExerciseExtendRecordData record:lstItems){
				if(repeatMap.get(record.getExerciseId()) != null && 
						(boolean)repeatMap.get(record.getExerciseId()) == record.getFlag()){//Öظ´Êý¾Ý
					continue;
				}
			
				fault=faultMap.get(record.getExerciseId());
				if(record.getFlag()){//Ìí¼Ó´íÌâ
					if(fault == null){
						fault = new ExerciseFault();
						fault.setFaultRecordId(faultRecordId);
						fault.setResumeBookId(resumeBookId);
						fault.setExerciseItemId(record.getExerciseId());
						fault.setDeleteFlag(false);
						TraceUtils.setCreateTrace(fault);
					}else{// Ô­À´ÒѾ­É¾³ý  »Ö¸´
						if(fault.getDeleteFlag()){
							fault.setDeleteFlag(false);
							fault.setAnswer(null);
							fault.setCorrect(Byte.valueOf("0"));
							TraceUtils.setUpdateTrace(fault);
						}else{
							continue;
						}
					}
					
				}else{// ɾ³ý´íÌâ
					if(fault == null){
						continue;
					}
					fault.setDeleteFlag(true);
					fault.setAnswer(null);
					fault.setCorrect(Byte.valueOf("0"));
					TraceUtils.setUpdateTrace(fault);
				}
				lstFault.add(fault);
				
				repeatMap.put(record.getExerciseId(), record.getFlag());
		}
		
		// 2.¼Ç¼´íÌâitemList
		// ÅúÁ¿Ôö¼Ó
		this.saveOrUpdateAll(lstFault);
		this.flush();
		
		return new Result(true);
	}
	
	/**
	 * ²Ù×÷Á·Ï°¼Ç¼
	 * @param subjectId
	 * @return
	 */
	public ExerciseFaultRecord doOperExerciseFaultRecord(String resumeBookId,String exerciseGroupId,
			String exerciseGroupType, ExciseExtendReqData recordResult){
		// ´íÌâ¼Ç¼ µ±Ç°×é
		String hql = "from ExerciseFaultRecord where resumeBookId=? and exerciseGroupId=? and deleteFlag is false ";
		
		ExerciseFaultRecord record = this.findUnique(hql, 
				CollectionUtils.newList(resumeBookId, exerciseGroupId), ExerciseFaultRecord.class);
		
		if(null == record){// ¼Ç¼²»´æÔÚ
			
			record = new ExerciseFaultRecord();
			record.setResumeBookId(resumeBookId);
			record.setExerciseGroupId(exerciseGroupId);
			record.setExerciseGroupType(Short.valueOf(exerciseGroupType));
			record.setDeleteFlag(false);
			TraceUtils.setCreateTrace(record);
			
			this.save(record);
		}
		
		
		return record;
	}
	
	
	/**
	 * ²Ù×÷Á·Ï°¼Ç¼
	 * @param subjectId
	 * @return
	 */
	public ExerciseFaultBook doOperExerciseFaultBook(String subjectId,ExciseExtendReqData recordResult){
		StringBuffer hql = new StringBuffer(512);
		hql.append("from ExerciseFaultBook where classId=? and userId=? and deleteFlag is false ");
		
		List<Object> args = CollectionUtils.newList(ClientUtils.getClassId(), 
					ClientUtils.getUserId());
		if(StringUtils.isNotBlank(subjectId)){// ¸ßУ
			hql.append(" and subjectId=? ");
			 args.add(subjectId);
		}
		
		//  ²éѯ´ËÓû§ÊÇ·ñÓдíÌâ¼Ç¼
		List<ExerciseFaultBook> lstFault = this.find(hql.toString(), args, ExerciseFaultBook.class);
		
		ExerciseFaultBook book = null;
		String hql_book;
		if(lstFault.isEmpty()){// ¼Ç¼Ϊ¿Õ
			
			if(StringUtils.isNotBlank(subjectId)){// ¸ßУ
				
				// ÏȲéѯÉϼ¶¼Ç¼ÊÇ·ñ´æÔÚ
				hql_book = "from ExerciseFaultBook where classId=? and userId=? and deleteFlag is false ";
				
				lstFault = this.find(hql_book, CollectionUtils.newList(ClientUtils.getClassId(), 
						ClientUtils.getUserId()), ExerciseFaultBook.class);
				
				if(lstFault.isEmpty()){//°à¼¶¼Ç¼²»´æÔÚ
					book = this.insertExerciseFaultBookNew(ExerciseFaultBook.TYPE_ORGANIZATION, null);
				}
				
				book = this.insertExerciseFaultBookNew(ExerciseFaultBook.TYPE_COLLEGE, lstFault.get(0).getResumeBookId());
				
				
			}else{
				book = this.insertExerciseFaultBookNew(ExerciseFaultBook.TYPE_ORGANIZATION, null);
			}
		}else{
			book = lstFault.get(0);
		}
		
		
		return book;
	}
	
	
	/**
	 * ÐÂÔö´íÌâbook¼Ç¼
	 * @param groupId
	 * @return 
	 */
	public ExerciseFaultBook insertExerciseFaultBookNew(short type, String parentId) {
		
		ExerciseFaultBook record = new ExerciseFaultBook();
		record.setUserId(ClientUtils.getUserId());
		record.setClassId(ClientUtils.getClassId());
		record.setCollegeCourseId(ClientUtils.getCourseId());
		record.setOrgId(ClientUtils.getOrgId());
		//record.setSubjectId();
		record.setParentId(parentId);
		record.setType(type);
		record.setDeleteFlag(false);
		TraceUtils.setCreateTrace(record);
		
		this.save(record);
		
		return record;
	}
	
	/**
	 * ¸üдíÌâbook¼Ç¼
	 * @param groupId
	 * @return 
	 */
	public Result updateExerciseFaultBookNew(ExerciseFaultBook record) {
		
		TraceUtils.setUpdateTrace(record);
		
		this.save(record);
		
		return new Result(true);
	}
	
	
	/**
	 * ²Ù×÷´íÌâ¼Ç¼
	 */
	public Map<String,Object> doOperExerciseFavorRecordData(String subjectId, ExciseExtendReqData recordResult) {
		// Á·Ï°×éid
		String exerciseGroupId = recordResult.getExerciseGroupId();
		String exerciseGroupType = recordResult.getExerciseGroupType();
		
		// 1.²Ù×÷Á·Ï°×ܼǼ
		ExerciseFavoriteBook  favorBook = doOperExerciseFavoriteBook(subjectId, recordResult);
		String favoriteBookId = favorBook.getFavoriteBookId();
		
		// 2.²Ù×÷Á·Ï°¼Ç¼
		ExerciseFavoriteRecord record = doOperExerciseFavorRecord(favoriteBookId,
				exerciseGroupId, exerciseGroupType,recordResult);
		String favoriteRecordId = record.getFavoriteRecordId();
		
		// 3.×é×°´íÌâ½á¹ûÈë¿â
		doOperFavorExerciseToDB(favoriteBookId, favoriteRecordId, recordResult);
		
		
		// 4. ÖØмÆËã×öÌâ¼Ç¼×ܸöÊý  ÊÕ²Ø
		record = this.doCalcFavorExericseStatisBySubmitData(record, favorBook, subjectId);
		
		// 5.·µ»Ø½á¹û
		Map<String,Object> map = new HashMap<String, Object>(3);
		map.put(EXERCISE_RECORD_ID, favoriteRecordId);
		map.put("exerciseGroupId", exerciseGroupId);
		map.put(UPDATE_TIME, DateTimeUtils.getCurrDateTime(record.getUpdateTime()));
		
		return map;
	}
	
	/**
	 * ¸üÐÂExerciseFavoriteRecordÊý¾Ý
	 * @param record
	 * @return
	 */
	@SuppressWarnings("unchecked")
	public Result updateExerciseFavoriteRecordData(ExerciseFavoriteRecord record){
		String sql = "SELECT"+
				" count(1) allCount,"+
				" sum(CORRECT = 1) corrCount,"+
				" sum(ANSWER IS NOT NULL) doCount,"+
				" round(sum(CORRECT = 1) / count(1) * 100,2) accuracy,"+
				" round(sum(ANSWER IS NOT NULL) / count(1) * 100,2) rate"+
				" FROM exercise_favorite"+
				" WHERE DELETE_FLAG = 0"+
				" AND FAVORITE_RECORD_ID = ?";

		List<Object[]> lstFault = this.findBySql(sql,  CollectionUtils.newList(record.getFavoriteRecordId()));
		
		Object[] objs = lstFault.get(0);
		
		//  ²ð·Ö×ÓÊý¾Ý
		packagingExerciseFavoriteRecordData(record, objs);
		
		if(record.getAllCount().compareTo(BigInteger.ZERO) == 0){// È«²¿É¾³ýºó Êý¾ÝÇå0
			record.setTitleMaxNumber("0");
			record.setStatus("0");
		}else if(StringUtils.isNotBlank(record.getTitleMaxNumber()) && 
				record.getAllCount().compareTo(new BigInteger(record.getTitleMaxNumber())) < 0){// ×ܸöÊýСÓÚ×î´óÌâºÅÊý
			record.setTitleMaxNumber(String.valueOf(record.getAllCount()));
		}
		TraceUtils.setUpdateTrace(record);
		this.save(record);
		
		return new Result(true);
	}
	
	/**
	 * ²ð·Ö×ÓÊý¾Ý
	 * @param record
	 * @param objs
	 */
	private void packagingExerciseFavoriteRecordData(
			ExerciseFavoriteRecord record, Object[] objs) {
		record.setAllCount((BigInteger)objs[0]);
		record.setCorrectCount(new BigInteger(String.valueOf(objs[1]==null ? "0" : objs[1])));
		record.setDoCount(new BigInteger(String.valueOf(objs[2]==null ? "0" : objs[2])));
		record.setAccuracy(new BigDecimal(String.valueOf(objs[3]==null ? "0" : objs[3])));
		record.setCompletionRate(new BigDecimal(String.valueOf(objs[4]==null ? "0" : objs[4])));
		record.setScore(record.getAccuracy());
	}
	
	/**
	 * ÖØмÆËã×öÌâ¼Ç¼×ܸöÊý  ÊÕ²Ø
	 * @param exerciseGroupId
	 * @param exerciseRecordId
	 * @return
	 */
	public ExerciseFavoriteRecord doCalcFavorExericseStatisBySubmitData(ExerciseFavoriteRecord record,
			ExerciseFavoriteBook favorBook,String subjectId){
		// 1.¼ÆËã×öÌâ×ܸöÊý record
		this.updateExerciseFavoriteRecordData(record);
				
		// 2.¼ÆËã¸Ã°à¼¶µÄ×ܸöÊý
		this.updateExerciseFavorBookInfo(favorBook);
		if(favorBook.getAllCount().compareTo(BigInteger.ZERO) == 0){// È«²¿É¾³ýºó Êý¾ÝÇå0
			favorBook.setTitleMaxNumber("0");
			favorBook.setStatus("0");
		}else if(StringUtils.isNotBlank(favorBook.getTitleMaxNumber()) 
				&& favorBook.getAllCount().compareTo(new BigInteger(favorBook.getTitleMaxNumber())) < 0){// ×ܸöÊýСÓÚ×î´óÌâºÅÊý
			favorBook.setTitleMaxNumber(String.valueOf(favorBook.getAllCount()));
		}
		TraceUtils.setUpdateTrace(favorBook);
		this.save(favorBook);
		
		return record;
	}
	
	/**
	 * ×é×°´íÌâ½á¹ûÈë¿â
	 * @param resumeBookId
	 * @param faultRecordId
	 * @param recordResult
	 * @return
	 */
	private Result doOperFavorExerciseToDB(String favoriteBookId, String favoriteRecordId, ExciseExtendReqData recordResult){
		List<ExerciseExtendRecordData> lstItems = recordResult.getItems();
		Map<String, Object> argsMap = new HashMap<String, Object>();
		Object[] args = new Object[lstItems.size()];
		for(int i=0; i<lstItems.size(); i++){
			args[i] = lstItems.get(i).getExerciseId();
		}
		argsMap.put("exerciseIds", args);
		argsMap.put("favoriteRecordId", favoriteRecordId);
		
		//  ²éѯ´ËÓû§ÊÇ·ñÓÐÊղؼǼ
		String hql = "from ExerciseFavorite where exerciseItemId in (:exerciseIds) and favoriteRecordId=:favoriteRecordId and deleteFlag is false";
		List<ExerciseFavorite>  lstExistfavor =  this.findByComplexHql(hql, argsMap, ExerciseFavorite.class);
		Map<String, ExerciseFavorite> favorMap = new HashMap<String, ExerciseFavorite>();
		for(ExerciseFavorite favor:lstExistfavor){
			favorMap.put(favor.getExerciseItemId(), favor);
		}
		
		List<ExerciseFavorite> lstFavor= new ArrayList<ExerciseFavorite>();
		ExerciseFavorite favor=null;
		// Ñ­»·Ã¿Ò»Ìõ¼Ç¼
		// ÅжϿͻ§¶ËÌá½»µÄÊý¾ÝÊÇ·ñÖظ´map
		Map<String,Object> repeatMap = new HashMap<String,Object>(lstItems.size());
		
		for(ExerciseExtendRecordData record:lstItems){
			if(repeatMap.get(record.getExerciseId()) != null && 
					(boolean)repeatMap.get(record.getExerciseId()) == record.getFlag()){//Öظ´Êý¾Ý
				continue;
			}
				
			favor = favorMap.get(record.getExerciseId());
			if(record.getFlag()){//Ìí¼ÓÊղؼǼ
				if(favor == null){
					favor = new ExerciseFavorite();
					favor.setFavoriteBookId(favoriteBookId);
					favor.setFavoriteRecordId(favoriteRecordId);
					favor.setExerciseItemId(record.getExerciseId());
					TraceUtils.setCreateTrace(favor);
					favor.setDeleteFlag(false);
				}else{//Ô­À´ÒѾ­É¾³ý ÏÖÔÚ»Ö¸´
					if(favor.getDeleteFlag()){
						favor.setAnswer(null);
						favor.setCorrect(Byte.valueOf("0"));
						favor.setDeleteFlag(false);
						TraceUtils.setUpdateTrace(favor);
					}else{
						continue;
					}
				}
				
			}else{// ɾ³ýÊÕ²Ø
				if(favor == null){
					continue;
				}
				favor.setDeleteFlag(true);
				favor.setAnswer(null);
				favor.setCorrect(Byte.valueOf("0"));
				favor.setCreateTime(new Date(System.currentTimeMillis()));
				TraceUtils.setUpdateTrace(favor);
			}
			lstFavor.add(favor);
			
			repeatMap.put(record.getExerciseId(), record.getFlag());
		}
		
		// 2.¼Ç¼ÊÕ²ØitemList
		// ÅúÁ¿Ôö¼Ó»òÕ߸üÐÂ
		this.saveOrUpdateAll(lstFavor);
		this.flush();
		
		return new Result(true);
	}
	/**
	 * ²Ù×÷Á·Ï°¼Ç¼
	 * @param subjectId
	 * @return
	 */
	public ExerciseFavoriteRecord doOperExerciseFavorRecord(String favoriteBookId,String exerciseGroupId,
			String exerciseGroupType,ExciseExtendReqData recordResult){
		// ´íÌâ¼Ç¼ µ±Ç°×é
		String hql = "from ExerciseFavoriteRecord where favoriteBookId=? and exerciseGroupId=? and deleteFlag is false ";
		
		ExerciseFavoriteRecord record = this.findUnique(hql, 
				CollectionUtils.newList(favoriteBookId, exerciseGroupId), ExerciseFavoriteRecord.class);
		
		if(null == record){// ¼Ç¼²»´æÔÚ
			
			record = new ExerciseFavoriteRecord();
			record.setFavoriteBookId(favoriteBookId);
			record.setExerciseGroupId(exerciseGroupId);
			record.setExerciseGroupType(Short.valueOf(exerciseGroupType));
			record.setDeleteFlag(false);
			TraceUtils.setCreateTrace(record);
			
			this.save(record);
		}
		
		return record;
	}
	
	
	/**
	 * ²Ù×÷Á·Ï°¼Ç¼
	 * @param subjectId
	 * @return
	 */
	public ExerciseFavoriteBook doOperExerciseFavoriteBook(String subjectId,ExciseExtendReqData recordResult){
		StringBuffer hql = new StringBuffer(512);
		hql.append("from ExerciseFavoriteBook where classId=? and userId=? and deleteFlag is false ");
		
		List<Object> args = CollectionUtils.newList(ClientUtils.getClassId(), 
					ClientUtils.getUserId());
		if(StringUtils.isNotBlank(subjectId)){// ¸ßУ
			hql.append(" and subjectId=? ");
			args.add(subjectId);
		}
		
		//  ²éѯ´ËÓû§ÊÇ·ñÓдíÌâ¼Ç¼
		List<ExerciseFavoriteBook> lstFavor = this.find(hql.toString(), args, ExerciseFavoriteBook.class);
		
		ExerciseFavoriteBook book = null;
		String hql_book;
		if(lstFavor.isEmpty()){// ¼Ç¼Ϊ¿Õ
			
			if(StringUtils.isNotBlank(subjectId)){// ¸ßУ
				
				// ÏȲéѯÉϼ¶¼Ç¼ÊÇ·ñ´æÔÚ
				hql_book = "from ExerciseFavoriteBook where classId=? and userId=? and deleteFlag is false ";
				
				lstFavor = this.find(hql_book, CollectionUtils.newList(ClientUtils.getClassId(), 
						ClientUtils.getUserId()), ExerciseFavoriteBook.class);
				
				if(lstFavor.isEmpty()){//°à¼¶¼Ç¼²»´æÔÚ
					book = this.insertExerciseFavorBookNew(ExerciseFavoriteBook.TYPE_ORGANIZATION, null);
				}else{
					book = lstFavor.get(0);
				}
				
				book = this.insertExerciseFavorBookNew(ExerciseFavoriteBook.TYPE_COLLEGE, book.getFavoriteBookId());
				
				
			}else{
				book = this.insertExerciseFavorBookNew(ExerciseFavoriteBook.TYPE_ORGANIZATION, null);
			}
		}else{
			book = lstFavor.get(0);
		}
		
		return book;
	}
	
	/**
	 * ÐÂÔö´íÌâbook¼Ç¼
	 * @param groupId
	 * @return 
	 */
	public Result updateExerciseFavorBookNew(ExerciseFavoriteBook record) {
		
		TraceUtils.setUpdateTrace(record);
		
		this.save(record);
		
		return new Result(true);
	}
	
	/**
	 * ÐÂÔö´íÌâbook¼Ç¼
	 * @param groupId
	 * @return 
	 */
	public ExerciseFavoriteBook insertExerciseFavorBookNew(short type, String parentId) {
		
		ExerciseFavoriteBook record = new ExerciseFavoriteBook();
		record.setUserId(ClientUtils.getUserId());
		record.setClassId(ClientUtils.getClassId());
		record.setCollegeCourseId(ClientUtils.getCourseId());
		record.setOrgId(ClientUtils.getOrgId());
		record.setParentId(parentId);
		record.setType(type);
		record.setDeleteFlag(false);
		TraceUtils.setCreateTrace(record);
		
		this.save(record);
		
		return record;
	}
	
	/**
	 * ´íÌâ±¾Ìá½»´ð°¸
	 */
	@Override
	public Map<String,Object> doSubmitExerFaultAnswerDataNew(ExerciseSubmitAnswerData clientAnswerResult) {
		
		// 0.ÖØÐÂÕûÀí´ðÌâÊý¾Ý
		ExerciseSubmitAnswerData answerResult = exerciseVerService.getExerciseSubmitAnswerDataNew(clientAnswerResult);
		
		// 1.¸üдíÌâ¼Ç¼
		ExerciseFaultRecord record = this.doOperExerFaultRecord(answerResult);
		
		if(null == record){
			return null;
		}
		
		String faultRecordId = record.getFaultRecordId();
		
		// ·µ»Ø½á¹û
		Map<String,Object> map = new HashMap<String, Object>(3);
		map.put(EXERCISE_RECORD_ID, faultRecordId);
		map.put("exerciseGroupId", record.getExerciseGroupId());
		map.put(UPDATE_TIME, DateTimeUtils.getCurrDateTime(record.getAnswerUpdateTime()));
		map.put("exerciseBookId", record.getResumeBookId());
		map.put("correctCount", answerResult.getCorrectCount());
		map.put("doCount", answerResult.getDoCount());
				
		if(answerResult.getItems().isEmpty() 
				&& answerResult.getSubmitType() != 1){//  submitType:1±íʾ±¾µØÎÞÍøÇé¿öÏÂÖØÐÂ×öÌâ¹ý
			return map;
		}
		
		// 2.ÅжÏÊÇ·ñ±¾µØÖØÐÂ×ö¹ý submitType:1±íʾ±¾µØÎÞÍøÇé¿öÏÂÖØÐÂ×öÌâ¹ý
		if(1 == answerResult.getSubmitType()){
			doOperExerciseFaultRecordByRedo(faultRecordId);
		}
		
		// 2.¸üдð°¸
		answerResult.setExerciseRecordId(faultRecordId);
		Result result = this.doUpdateExerFaultAnswerData(answerResult);
		
		if(!result.isSuccess()){
			return null;
		}
		
		// 3.ÖØмÆËã×öÌâ¼Ç¼ÕýÈ·¸öÊý ×öÌâ¸öÊý  ÕýÈ·ÂÊ
		this.updateExerciseFaultRecordData(record);
		
		return map;
	}
	
	/**
	 * ¸üдíÌâ¼Ç¼
	 * @param answerResult
	 * @return 
	 */
	public ExerciseFaultRecord doOperExerFaultRecord(ExerciseSubmitAnswerData answerResult) {
		
		ExerciseFaultRecord record = null;
		String exerciseRecordId = answerResult.getExerciseRecordId();
		if(StringUtils.isNotBlank(exerciseRecordId)){// Õý³£×öÌâ
			
			record = this.read(ExerciseFaultRecord.class, answerResult.getExerciseRecordId());
			
		}else{// ÎÞÍøÇé¿öÏÂ
			String hql = "from ExerciseFaultRecord r where r.deleteFlag is false and "
					+ "r.faultBook.userId=? and r.faultBook.classId=? and r.exerciseGroupId=?";
			
			record = this.findUnique(hql, CollectionUtils.newList(ClientUtils.getUserId(), ClientUtils.getClassId(),
					answerResult.getExerciseGroupId()), ExerciseFaultRecord.class);
		}
		
		if(null == record){
			return null;
		}
		
		if(answerResult.getItems().isEmpty() 
				&& ExerciseRecord.STATUS_SUBMIT.equals(answerResult.getStatus())){//½ö½ö½»¾í
			record.setStatus(answerResult.getStatus());
			// ¸üдð°¸Ê±¼ä
			record.setAnswerUpdateTime(new Date(System.currentTimeMillis()));
			
			this.save(record);
			
			return record;
		}
		
		
		// ¼ÆËã
//		if(!"1".equals(record.getStatus())){// ·ÇÌá½»µÄ¾Í¸üР 
//		}
		record.setStatus(StringUtils.isBlank(answerResult.getStatus()) ? "0" : answerResult.getStatus());
		if(!"0".equals(answerResult.getCurrTitleNum())){
			record.setTitleMaxNumber(StringUtils.isBlank(answerResult.getCurrTitleNum()) ? "0" : answerResult.getCurrTitleNum());
		}
		// ¸üдð°¸Ê±¼ä
		record.setAnswerUpdateTime(new Date(System.currentTimeMillis()));
		
		this.save(record);
		
		return record;
	}
	
	/**
	 *Ìá½» ´íÌâ½á¹ûµ½db
	 * @return
	 */
	public Result doUpdateExerFaultAnswerData(ExerciseSubmitAnswerData answerResult) {
		List<ExerciseItemAnswerData> lstAnswers = answerResult.getItems();
		if(lstAnswers.isEmpty()){
			return new Result(true);
		}
		
		// ÅúÁ¿¸üдð°¸
		List<ExerciseFault> lstResultFault =new ArrayList<ExerciseFault>(lstAnswers.size());
		
		// 2.1.×é×°²ÎÊý ÓÃÓÚ²éѯÁ·Ï°Ñ¡ÏîͼƬ
		Map<String, Object> argsMap = new HashMap<String, Object>(2);
		Object[] args = new Object[lstAnswers.size()];
		for(int i=0; i<lstAnswers.size(); i++){
			args[i] = lstAnswers.get(i).getExerciseId();
		}
		argsMap.put("exerciseIds", args);
		argsMap.put(EXERCISE_RECORD_ID, answerResult.getExerciseRecordId());
		
		String hql = "from ExerciseFault where deleteFlag is false and exerciseItemId in (:exerciseIds) and faultRecordId =:exerciseRecordId ";
		List<ExerciseFault> lstFault = this.findByComplexHql(hql, argsMap, ExerciseFault.class);
		
		// °´Á·Ï°id ¶ÔÓ¦·Åµ½mapÖÐ
		Map<String, ExerciseFault> faultMap = new HashMap<String, ExerciseFault>(lstFault.size());
		for(ExerciseFault fault:lstFault){
			faultMap.put(fault.getExerciseItemId(), fault);
		}
		
		ExerciseFault fault=null;
		for(ExerciseItemAnswerData answer:lstAnswers){
			fault = faultMap.get(answer.getExerciseId());
			if(null == fault){
				continue;
			}
			if(StringUtils.isBlank(answer.getAnswer())){// ´ð°¸Îª¿Õ
				continue;
			}
			
			fault.setAnswer(answer.getAnswer());
			fault.setCorrect(Byte.valueOf(answer.getCorrect()));
			TraceUtils.setUpdateTrace(fault);
			lstResultFault.add(fault);
		}
		
		// 1.±£´æ ´íÌâ ÊÕ¼¯lst
		this.saveOrUpdateAll(lstResultFault);
		this.flush();
		
		return new Result(true);
	}
	
	/**
	 *  Êղر¾Ìá½»´ð°¸
	 */
	@Override
	public Map<String,Object> doSubmitExerFavorAnswerDataNew(ExerciseSubmitAnswerData clientAnswerResult) {
		
		// 0.ÖØÐÂÕûÀí´ðÌâÊý¾Ý
		ExerciseSubmitAnswerData answerResult = exerciseVerService.getExerciseSubmitAnswerDataNew(clientAnswerResult);
		
		// 1.¸üдíÌâ¼Ç¼
		ExerciseFavoriteRecord record = doOperExerFavorRecord(answerResult);
		if(null == record){
			return null;
		}
		String favoriteRecordId = record.getFavoriteRecordId();
		
		// ·µ»Ø½á¹û
		Map<String,Object> map = new HashMap<String, Object>(3);
		map.put(EXERCISE_RECORD_ID, favoriteRecordId);
		map.put("exerciseGroupId", record.getExerciseGroupId());
		map.put(UPDATE_TIME,   DateTimeUtils.getCurrDateTime(record.getAnswerUpdateTime()));
		map.put("exerciseBookId", record.getFavoriteBookId());
		
		if(answerResult.getItems().isEmpty() && answerResult.getSubmitType() != 1){//½ö½ö½»¾í
			return map;
		}
		
		// 2.ÅжÏÊÇ·ñ±¾µØÖØÐÂ×ö¹ý submitType:1±íʾ±¾µØÎÞÍøÇé¿öÏÂÖØÐÂ×öÌâ¹ý
		if(1 == answerResult.getSubmitType()){
			doOperExerciseFavorRecordByRedo(favoriteRecordId);
		}
				
		// 2.¸üдð°¸
		answerResult.setExerciseRecordId(favoriteRecordId);
		Result result = doUpdateExerFavorAnswerData(answerResult);
		
		if(!result.isSuccess()){
			return null;
		}
		
		//  3.ÖØмÆËã×öÌâ¼Ç¼ÕýÈ·¸öÊý ×öÌâ¸öÊý  ÕýÈ·ÂÊ  ÊÕ²Ø
		this.updateExerciseFavoriteRecordData(record);
		
		return map;
	}
	
	/**
	 * ¸üдíÌâ¼Ç¼
	 * @param answerResult
	 * @return 
	 */
	public ExerciseFavoriteRecord doOperExerFavorRecord(ExerciseSubmitAnswerData answerResult) {
		
		ExerciseFavoriteRecord record = null;
		String exerciseRecordId = answerResult.getExerciseRecordId();
		if(StringUtils.isNotBlank(exerciseRecordId)){// Õý³£×öÌâ
			
			record = this.read(ExerciseFavoriteRecord.class, exerciseRecordId);
			
		}else{// ÎÞÍøÇé¿öÏÂ
			String hql = "from ExerciseFavoriteRecord r where r.deleteFlag is false "
					+ " and r.favorBook.userId=? and r.favorBook.classId=? and r.exerciseGroupId=?";
			
			record = this.findUnique(hql, CollectionUtils.newList(ClientUtils.getUserId(),ClientUtils.getClassId(),
					answerResult.getExerciseGroupId()), ExerciseFavoriteRecord.class);
		}
		
		if(null == record){
			return null;
		}
		
		if(answerResult.getItems().isEmpty() 
				&& ExerciseRecord.STATUS_SUBMIT.equals(answerResult.getStatus())){//½ö½ö½»¾í
			record.setStatus(answerResult.getStatus());
			// ¸üдð°¸Ê±¼ä
			record.setAnswerUpdateTime(new Date(System.currentTimeMillis()));
			
			this.save(record);
			
			return record;
		}
		
//		// ¼ÆËã
//		if(!"1".equals(record.getStatus())){// ·ÇÌá½»µÄ¾Í¸üÐÂ
//		}
		record.setStatus(answerResult.getStatus());
		if(!"0".equals(answerResult.getCurrTitleNum())){
			record.setTitleMaxNumber(answerResult.getCurrTitleNum());
		}
		
		// ¸üдð°¸Ê±¼ä
		record.setAnswerUpdateTime(new Date(System.currentTimeMillis()));
		
		this.save(record);
		
		return record;
	}
	
	
	/**
	 *Ìá½» ´íÌâ½á¹ûµ½db
	 * @return
	 */
	public Result doUpdateExerFavorAnswerData(ExerciseSubmitAnswerData answerResult) {
		List<ExerciseItemAnswerData> lstAnswers = answerResult.getItems();
		
		if(lstAnswers.isEmpty()){
			return new Result(true);
		}
		// ÅúÁ¿¸üдð°¸
		List<ExerciseFavorite> lstResultFavor =new ArrayList<ExerciseFavorite>(lstAnswers.size());
		
		// 2.1.×é×°²ÎÊý ÓÃÓÚ²éѯÁ·Ï°Ñ¡ÏîͼƬ
		Map<String, Object> argsMap = new HashMap<String, Object>(2);
		Map<String, Object> exerItemIdMap = new HashMap<String, Object>(1);
		Object[] args = new Object[lstAnswers.size()];
		for(int i=0; i<lstAnswers.size(); i++){
			args[i] = lstAnswers.get(i).getExerciseId();
		}
		exerItemIdMap.put("exerciseIds", args);
		argsMap.put("exerciseIds", args);
		argsMap.put(EXERCISE_RECORD_ID, answerResult.getExerciseRecordId());
		
		String hql = "from ExerciseFavorite where deleteFlag is false and exerciseItemId in (:exerciseIds) and favoriteRecordId =:exerciseRecordId ";
		List<ExerciseFavorite> lstFavor = this.findByComplexHql(hql, argsMap, ExerciseFavorite.class);
		
		// °´Á·Ï°id ¶ÔÓ¦·Åµ½mapÖÐ
		Map<String, ExerciseFavorite> favorMap = new HashMap<String, ExerciseFavorite>(lstFavor.size());
		for(ExerciseFavorite favor:lstFavor){
			favorMap.put(favor.getExerciseItemId(), favor);
		}
		
		ExerciseFavorite favor;
		for(ExerciseItemAnswerData answer:lstAnswers){
			favor = favorMap.get(answer.getExerciseId());
			if(null == favor){
				continue;
			}
			if(StringUtils.isBlank(answer.getAnswer())){// ´ð°¸Îª¿Õ
				continue;
			}
			favor.setAnswer(answer.getAnswer());
			favor.setCorrect(Byte.valueOf(answer.getCorrect()));
			TraceUtils.setUpdateTrace(favor);
			lstResultFavor.add(favor);
		}
		
		this.saveOrUpdateAll(lstResultFavor);
		this.flush();
		
		return new Result(true);
	}
	
	/**
	 * ²éѯ´íÌâ±¾ÁбíÊý¾Ý
	 * @param exerType
	 * @param subjectId
	 * @param pager
	 * @return
	 */
	@Override
	public List<ExerGroupResponseData> queryExerciseFaultListData(
			int exerType, String subjectId, Pager pager) {
		StringBuffer hql = new StringBuffer(512);
		//  1.²éѯ·Ö×éÁбí
		hql.append("select r,g from ExerciseFaultRecord r, ExerciseFaultBook b, ExerciseGroup g "
				+ " where r.resumeBookId=b.resumeBookId "
				+ " and r.exerciseGroupId=g.groupId "
				+ "	and r.deleteFlag is false "
				+ "	and b.deleteFlag is false "
				+ "	and b.userId=?  and r.allCount>0 ");
		
		List<Object> args = CollectionUtils.newList(ClientUtils.getUserId());
		if(exerType != 0){ //±íʾ²éѯȫ²¿´íÌâ
			hql.append(" and r.exerciseGroupType=?");
			args.add((short)exerType);
		}
				
		if(StringUtils.isNotBlank(subjectId)){// ¸ßУ  ͨ¹ý¿Î³Ì¹ýÂË
			
			hql.append(" and b.type=? and b.subjectId=? and g.subjectId=? ");
			args.add(ExerciseFaultBook.TYPE_COLLEGE);
			args.add(subjectId);
			args.add(subjectId);
		}else{// ·Ç¸ßУ
			
			hql.append(" and b.type=? and b.classId=? and g.classId=?");
			args.add(ExerciseFaultBook.TYPE_ORGANIZATION);
			args.add(ClientUtils.getClassId());
			args.add(ClientUtils.getClassId());
		}
		hql.append(" order by r.updateTime desc ");
		
		// ¸ù¾Ý½á¹¹²éѯµÃµ½ËùÐè¼Ç¼
		List<Object[]> lstRecord = this.findList(hql.toString(), pager, args, Object[].class);
		
		if(lstRecord.isEmpty()){// ²éѯ½á¹û¼Ç¼Ϊ¿Õ
			return null;
		}
		
		// 3.×é×°²ÎÊý
		Object[] argss = new Object[lstRecord.size()];
		ExerciseGroup groupp=null;
		for(int i=0; i<lstRecord.size(); i++){
			groupp = (ExerciseGroup)lstRecord.get(i)[1];
			argss[i] = groupp.getGroupId();
		}
		
		// »ñÈ¡¸öÈËÓû§×é¶ÔÓ¦µÄÊղؼǼ ÌâÄ¿¸üÐÂʱ¼ä
		Map<String, Map<String, Object>> favorMap = this.queryFavorRecordByGroup(subjectId, argss);
				
		// ½á¹û·µ»Ø²ÎÊý
		List<ExerGroupResponseData> lstResult = new ArrayList<ExerGroupResponseData>(lstRecord.size());
		
		for(Object[] objs:lstRecord){
			
			// ×é×°Á·Ï°´íÌâ±¾ÁбíÊý¾Ý
			lstResult.add(packagingExerciseFaultListData(
					favorMap, objs));
		}
		
		return lstResult; 
	}

	/**
	 * ×é×°Á·Ï°´íÌâ±¾ÁбíÊý¾Ý
	 * @param favorMap
	 * @param objs
	 * @return
	 */
	private ExerGroupResponseData packagingExerciseFaultListData(
			Map<String, Map<String, Object>> favorMap, Object[] objs) {
		ExerciseFaultRecord record = (ExerciseFaultRecord)objs[0];
		ExerciseGroup group = (ExerciseGroup)objs[1];
		
		ExerGroupResponseData resultObj = new ExerGroupResponseData();
		
		// ²ð·Ö·½·¨
		packagingExerciseFaultListChildData(record, resultObj);
		
		resultObj.setExtendAllCount(record.getAllCount()==null ? BigInteger.ZERO  : record.getAllCount());
		if(new BigInteger(resultObj.getCurrTitleNumber()).compareTo(resultObj.getExtendAllCount())>0){
			resultObj.setCurrTitleNumber(String.valueOf(resultObj.getExtendAllCount()));
		}
		BeanUtils.copyProperties(group, resultObj);
		resultObj.setExerciseTime(group.getAttribute1());
		resultObj.setUpdateTime(record.getUpdateTime());
		resultObj.setAnswerUpdateTime(record.getAnswerUpdateTime());
		resultObj.setFaultUpdateTime(record.getUpdateTime());
		resultObj.setFaultCount(resultObj.getAllCount());
		if(favorMap != null && favorMap.get(group.getGroupId()) != null){
			resultObj.setFavorUpdateTime((Timestamp)favorMap.get(group.getGroupId()).get(UPDATE_TIME));//ÉèÖÃÊղر¾ÌâÄ¿¸üÐÂʱ¼ä
			resultObj.setFavorCount((BigInteger)favorMap.get(group.getGroupId()).get("allCount"));
		}
		
		if(resultObj.getDoCount().compareTo(resultObj.getExtendAllCount())>0){
			resultObj.setDoCount(resultObj.getExtendAllCount());
		}
		return resultObj;
	}
	
	/**
	 * ×é×°Á·Ï°´íÌâ±¾ÁбíÊý¾Ý ²ð·Ö·½·¨
	 * @param record
	 * @param resultObj
	 */
	private void packagingExerciseFaultListChildData(
			ExerciseFaultRecord record, ExerGroupResponseData resultObj) {
		resultObj.setStatus(record.getStatus());
		resultObj.setGroupId(record.getExerciseGroupId());
		resultObj.setExerciseRecordId(record.getFaultRecordId());
		resultObj.setAccuracy(record.getAccuracy()==null ? BigDecimal.ZERO : record.getAccuracy());
		resultObj.setCorrectCount(record.getCorrectCount()==null ? BigInteger.ZERO : record.getCorrectCount());
		resultObj.setDoCount(record.getDoCount()==null ? BigInteger.ZERO : record.getDoCount());
		resultObj.setCurrTitleNumber(record.getTitleMaxNumber()==null ? "0" : record.getTitleMaxNumber());
	}
	
	/**
	 * »ñÈ¡¸öÈËÓû§×é¶ÔÓ¦µÄ´íÌâÌâÄ¿¸üÐÂʱ¼ä
	 * @param subjectId
	 * @param args
	 * @return
	 */
	@Override
	public Map<String, Map<String, Object>> queryFaultRecordByGroup(String subjectId, Object[] args) {
		StringBuffer hql = new StringBuffer(512);
		//  1.²éѯ·Ö×éÁбí
		hql.append("select r.exerciseGroupId,r.updateTime,r.allCount from ExerciseFaultRecord r, ExerciseFaultBook b "
				+ " where r.resumeBookId=b.resumeBookId "
				+ "	and b.userId = :userId and r.exerciseGroupId in (:groupIds)  ");
		
		Map<String, Object> argsMap = new HashMap<String, Object>(4);
		
		argsMap.put("userId", ClientUtils.getUserId());
		argsMap.put("groupIds", args);
		
		if(StringUtils.isNotBlank(subjectId)){// ¸ßУ  ͨ¹ý¿Î³Ì¹ýÂË
			
			hql.append(" and b.type=:type and b.subjectId=:subjectId ");
			argsMap.put("type", ExerciseFaultBook.TYPE_COLLEGE);
			argsMap.put("subjectId", subjectId);
		}else{// ·Ç¸ßУ
			
			hql.append(" and b.type=:type and b.classId=:classId ");
			argsMap.put("type", ExerciseFaultBook.TYPE_ORGANIZATION);
			argsMap.put("classId", ClientUtils.getClassId());
		}
		
		// ¸ù¾Ý½á¹¹²éѯµÃµ½ËùÐè¼Ç¼
		List<Object[]> lstRecord = this.findByComplexHql(hql.toString(), argsMap, Object[].class);
		
		Map<String, Map<String, Object>> resultMap = new HashMap<String, Map<String, Object>>(lstRecord.size());
		Map<String, Object> paramMap = null;
		for(Object[] obj:lstRecord){
			paramMap = new HashMap<String, Object>(2);
			paramMap.put(UPDATE_TIME, obj[1]);
			paramMap.put("allCount", obj[2]);
			resultMap.put(String.valueOf(obj[0]), paramMap);
		}
		
		return resultMap;
	}
	
	/**
	 *»ñÈ¡¸öÈËÓû§×é¶ÔÓ¦µÄÊÕ²ØÌâÄ¿¸üÐÂʱ¼ä
	 * @param subjectId
	 * @param args
	 * @return
	 */
	@Override
	public Map<String, Map<String, Object>> queryFavorRecordByGroup(String subjectId, Object[] args) {
		StringBuffer hql = new StringBuffer(512);
		//  1.²éѯ·Ö×éÁбí
		hql.append("select r.exerciseGroupId,r.updateTime,r.allCount from ExerciseFavoriteRecord r, ExerciseFavoriteBook b"
				+ " where r.favoriteBookId=b.favoriteBookId "
				+ "	and b.userId = :userId and r.exerciseGroupId in (:groupIds)  ");
		
		Map<String, Object> argsMap = new HashMap<String, Object>(4);
		
		argsMap.put("userId", ClientUtils.getUserId());
		argsMap.put("groupIds", args);
		
		if(StringUtils.isNotBlank(subjectId)){// ¸ßУ  ͨ¹ý¿Î³Ì¹ýÂË
			
			hql.append(" and b.type=:type and b.subjectId=:subjectId ");
			argsMap.put("type", ExerciseFaultBook.TYPE_COLLEGE);
			argsMap.put("subjectId", subjectId);
		}else{// ·Ç¸ßУ
			
			hql.append(" and b.type=:type and b.classId=:classId ");
			argsMap.put("type", ExerciseFaultBook.TYPE_ORGANIZATION);
			argsMap.put("classId", ClientUtils.getClassId());
		}
		
		// ¸ù¾Ý½á¹¹²éѯµÃµ½ËùÐè¼Ç¼
		List<Object[]> lstRecord = this.findByComplexHql(hql.toString(), argsMap, Object[].class);
		Map<String, Map<String, Object>> resultMap = new HashMap<String, Map<String, Object>>(lstRecord.size());
		Map<String, Object> paramMap = null;
		for(Object[] obj:lstRecord){
			paramMap = new HashMap<String, Object>(2);
			paramMap.put(UPDATE_TIME, obj[1]);
			paramMap.put("allCount", obj[2]);
			resultMap.put(String.valueOf(obj[0]), paramMap);
		}
		
		return resultMap;
	}
	
	/**
	 * ²éѯÊղر¾ÁбíÊý¾Ý
	 * @param exerType 0:±íʾȫ²¿´íÌâ
	 * @param subjectId
	 * @param pager
	 * @return
	 */
	@Override
	public List<ExerGroupResponseData> queryExerciseFavorListData(int exerType,
			String subjectId, Pager pager) {
		StringBuffer hql = new StringBuffer(512);
		//  1.²éѯ·Ö×éÁбí
		hql.append("select r, g from ExerciseFavoriteRecord r, ExerciseFavoriteBook b, ExerciseGroup g"
				+ " where r.favoriteBookId=b.favoriteBookId "
				+ " and r.exerciseGroupId=g.groupId "
				+ "	and r.deleteFlag is false "
				+ "	and b.deleteFlag is false "
				+ " and b.userId=? and r.allCount>0 ");
		
		List<Object> args = CollectionUtils.newList(ClientUtils.getUserId());
		if(exerType != 0){ //±íʾ²éѯ·ÇÈ«²¿ÊÕ²Ø  exerType=0Ϊ²éѯȫ²¿ÊÕ²Ø
			hql.append(" and r.exerciseGroupType=?");
			args.add((short)exerType);
		}
		
		if(StringUtils.isNotBlank(subjectId)){// ¸ßУ  ͨ¹ý¿Î³Ì¹ýÂË
			
			hql.append(" and b.type=? and b.subjectId=? and g.subjectId=? ");
			args.add(ExerciseFaultBook.TYPE_COLLEGE);
			args.add(subjectId);
			args.add(subjectId);
		}else{// ·Ç¸ßУ
			
			hql.append(" and b.type=? and b.classId=? and g.classId=?");
			args.add(ExerciseFaultBook.TYPE_ORGANIZATION);
			args.add(ClientUtils.getClassId());
			args.add(ClientUtils.getClassId());
		}
		hql.append(" order by r.updateTime desc ");
		
		// ¸ù¾Ý½á¹¹²éѯµÃµ½ËùÐè¼Ç¼
		List<Object[]> lstRecord = this.findList(hql.toString(), pager, args,Object[].class);
		
		if(lstRecord.isEmpty()){// ²éѯ½á¹û¼Ç¼Ϊ¿Õ
			return null;
		}
		
		Object[] argss = new Object[lstRecord.size()];
		ExerciseGroup groupp=null;
		for(int i=0; i<lstRecord.size(); i++){
			groupp = (ExerciseGroup)lstRecord.get(i)[1];
			argss[i] = groupp.getGroupId();
		}
		
		// »ñÈ¡¸öÈËÓû§×é¶ÔÓ¦µÄ´íÌâ¼Ç¼ ÌâÄ¿¸üÐÂʱ¼ä
		Map<String, Map<String, Object>> faultMap = this.queryFaultRecordByGroup(subjectId, argss);
		
		// ½á¹û·µ»Ø²ÎÊý
		List<ExerGroupResponseData> lstResult = new ArrayList<ExerGroupResponseData>(lstRecord.size());
		
		for(Object[] objs:lstRecord){
			
			// ×é×°Á·Ï°ÊÕ²ØÁбíÊý¾Ý
			lstResult.add(packagingExerciseFavorListData(
					faultMap, objs));
			
		}
		
		return lstResult;
	}
	
	/**
	 * ×é×°Á·Ï°ÊÕ²ØÁбíÊý¾Ý
	 * @param faultMap
	 * @param objs
	 * @return
	 */
	private ExerGroupResponseData packagingExerciseFavorListData(
			Map<String, Map<String, Object>> faultMap, Object[] objs) {
		ExerciseFavoriteRecord record = (ExerciseFavoriteRecord)objs[0];
		ExerciseGroup group = (ExerciseGroup)objs[1];
		
		ExerGroupResponseData resultObj = new ExerGroupResponseData();
		
		// ²ð·Ö×é×°Êý¾Ý
		packagingExerciseFavorListChildData(record, resultObj);
		
		resultObj.setExtendAllCount(record.getAllCount()==null ? BigInteger.ZERO  : record.getAllCount());
		if(new BigInteger(resultObj.getCurrTitleNumber()).compareTo(resultObj.getExtendAllCount())>0){
			resultObj.setCurrTitleNumber(String.valueOf(resultObj.getExtendAllCount()));
		}
		
		BeanUtils.copyProperties(group, resultObj);
		resultObj.setExerciseTime(group.getAttribute1());
		resultObj.setUpdateTime(record.getUpdateTime());
		resultObj.setAnswerUpdateTime(record.getAnswerUpdateTime());
		resultObj.setFavorUpdateTime(record.getUpdateTime());
		resultObj.setFavorCount(resultObj.getAllCount());
		if(faultMap !=null && faultMap.get(group.getGroupId()) !=null){
			resultObj.setFaultUpdateTime((Timestamp)faultMap.get(group.getGroupId()).get(UPDATE_TIME));//ÉèÖôíÌâ±¾ÌâÄ¿¸üÐÂʱ¼ä
			resultObj.setFaultCount((BigInteger)faultMap.get(group.getGroupId()).get("allCount"));
		}
		
		if(resultObj.getDoCount().compareTo(resultObj.getExtendAllCount())>0){
			resultObj.setDoCount(resultObj.getExtendAllCount());
		}
		return resultObj;
	}
	
	/**
	 * ×é×°Á·Ï°ÊÕ²ØÁбíÊý¾Ý ²ð·Ö×é×°Êý¾Ý
	 * @param record
	 * @param resultObj
	 */
	private void packagingExerciseFavorListChildData(
			ExerciseFavoriteRecord record, ExerGroupResponseData resultObj) {
		resultObj.setStatus(record.getStatus());
		resultObj.setGroupId(record.getExerciseGroupId());
		resultObj.setExerciseRecordId(record.getFavoriteRecordId());
		resultObj.setAccuracy(record.getAccuracy()==null ? BigDecimal.ZERO : record.getAccuracy());
		resultObj.setCorrectCount(record.getCorrectCount()==null ? BigInteger.ZERO : record.getCorrectCount());
		resultObj.setDoCount(record.getDoCount()==null ? BigInteger.ZERO : record.getDoCount());
		resultObj.setCurrTitleNumber(record.getTitleMaxNumber()==null ? "0" : record.getTitleMaxNumber());
	}
	

	/**
	 * »ñÈ¡È«²¿ÊÕ²ØÁ·Ï°Êý¾Ý
	 * @return
	 */
	@Override
	public ExerItemResponseData queryAllExerciseFavorData(Pager pager) {
		//  1.²éѯ´ËÓû§ÊÇ·ñÓдíÌâ¼Ç¼
		String hql = "select item, favor.favorRecord.exerciseGroupId,favor.favorRecord.favorBook.status "
				+ " from ExerciseItem item, ExerciseFavorite favor "
				+ " where item.exerciseId=favor.exerciseItemId"
				+ " and favor.favorRecord.favorBook.classId=?"
				+ " and favor.favorRecord.favorBook.userId=?"
				+ " and item.deleteFlag is false"
				+ " and favor.deleteFlag is false"
				+ " order by favor.createTime";
		
		List<Object[]> lstResult = this.findList(hql, pager, 
				CollectionUtils.newList(ClientUtils.getClassId(), ClientUtils.getUserId()), Object[].class);
		
		
		if(lstResult.isEmpty()){
			return null; 
		}
		
		String status=null;
		ExerciseItem item = null;
		List<ExerciseItem> lstItems = new ArrayList<ExerciseItem>(lstResult.size());
		for(Object[] objs:lstResult){
			if(null != objs[2]) {
				status = String.valueOf(objs[2]);
			}
			item = new ExerciseItem();
			BeanUtils.copyProperties((ExerciseItem)objs[0], item);// ·ÀÖ¹itemͬһ¸öÄÚ´æµØÖ·
			item.setExerciseGroupId(String.valueOf(objs[1]));//ÉèÖÃÿ¸öÌâÄ¿µÄ×éid
			lstItems.add(item);
		}
		
		// 2.ÖØÐÂ×é×°Á·Ï°Ìâ ¼ÓÈë·ÖÎö½á¹û
		lstItems =  exerciseVerService.getCommonExerItemDetail(lstItems, null);
		
		// 3.×é×°´ð°¸
		ExerItemResponseData result = new ExerItemResponseData();
				
		result.setItems(lstItems);
		result.setStatus(status);
		
		result.setResult(new Result(true,"²éѯ³É¹¦"));
		
		return result; 
	}
	
	/**
	 * »ñÈ¡ÊÕ²ØÁ·Ï°Êý¾Ý
	 * @param groupId
	 * @param exerciseRecordId ·ÏÆú
	 * @return
	 */
	@Override
	public ExerItemResponseData queryExerciseFavorData(String groupId) {
		//  1.²éѯ´ËÓû§ÊÇ·ñÓдíÌâ¼Ç¼
		String hql = "select item, favor "
				+ " from ExerciseItem item, ExerciseFavorite favor "
				+ " where item.exerciseId=favor.exerciseItemId"
				+ " and favor.favorRecord.exerciseGroupId=?"
				+ " and favor.favorRecord.favorBook.userId=?"
				+ " and item.deleteFlag is false"
				+ " and favor.deleteFlag is false"
				+ " order by favor.createTime";
		
		List<Object[]> lstResult = this.findwithRawResult(hql, CollectionUtils.newList(groupId,ClientUtils.getUserId()));
		
		
		return goQueryExerciseFavorData(lstResult, groupId); 
	}
	
	/**
	 * »ñÈ¡¶àÌ×ÊÕ²ØÁ·Ï°Êý¾Ý
	 * @param groupId
	 * @return
	 */
	@Override
	public Map<String,Object> queryExerciseMutiFavorData(String groupId) {
		//  1.²éѯ´ËÓû§ÊÇ·ñÓдíÌâ¼Ç¼
		String hql = "select item.exerciseId "
				+ " from ExerciseItem item, ExerciseFavorite favor "
				+ " where item.exerciseId=favor.exerciseItemId"
				+ " and favor.favorRecord.favorBook.userId=?"
				+ " and favor.favorRecord.favorBook.classId=?"
				+ " and favor.favorRecord.exerciseGroupId=?"
				+ " and item.deleteFlag is false"
				+ " and favor.deleteFlag is false"
				+ " order by favor.createTime";
		
		List<String> lstFavor = this.find(hql, CollectionUtils.newList(ClientUtils.getUserId(), 
				ClientUtils.getClassId(), groupId),String.class);
		
		List<Map<String,String>> lstResult = new ArrayList<Map<String,String>>(lstFavor.size());
		Map<String,String>  exerciseIdMap = null;
		for(String exerciseId:lstFavor){
			exerciseIdMap = new HashMap<String, String>(1);
			exerciseIdMap.put("exerciseId", exerciseId);
			lstResult.add(exerciseIdMap);
		}
		
		Map<String,Object> resultMap = new HashMap<String, Object>(2);
		resultMap.put("exerciseGroupId", groupId);
		resultMap.put("exerciseIds", lstResult);
		
		return resultMap; 
	}
	
	/**
	 * ²éѯÊÕ²ØÌâÄ¿Ã÷ϸ
	 * @param lstResult
	 * @param groupId
	 * @return
	 */
	public ExerItemResponseData goQueryExerciseFavorData(List<Object[]> lstResult, String groupId) {
		if(lstResult.isEmpty()){
			return null; 
		}
		
		List<ExerciseItem> lstItems = new ArrayList<ExerciseItem>(lstResult.size());
		ExerciseItem item;
		List<ExerciseItemAnswerU> lstAnswers = new ArrayList<ExerciseItemAnswerU>(lstResult.size());
		ExerciseItemAnswerU answerU;
		
		ExerciseFavorite favor;
		for(Object[] objs:lstResult){
			
			item = (ExerciseItem)objs[0];
			lstItems.add(item);
			
			favor = (ExerciseFavorite)objs[1];
			
			if(StringUtils.isNotBlank(favor.getAnswer())){
				answerU = new ExerciseItemAnswerU();
				answerU.setAnswer(favor.getAnswer());
				answerU.setCorrect(favor.getCorrect());
				answerU.setAnswerUId(favor.getExerciseFavoriteId());
				answerU.setExerciseItemId(favor.getExerciseItemId());
				answerU.setExerciseRecordId(favor.getFavoriteRecordId());
				lstAnswers.add(answerU);
			}
			
		}
		
		// 2.ÖØÐÂ×é×°Á·Ï°Ìâ ¼ÓÈë·ÖÎö½á¹û
		lstItems =  exerciseVerService.getCommonExerItemDetail(lstItems, groupId);
		
		
		// 3.×é×°´ð°¸
		ExerItemResponseData result = new ExerItemResponseData();
				
		result.setExerciseGroupId(groupId);
		
		result.setItems(lstItems);
		
		result.setAnswers(lstAnswers);
		
		result.setResult(new Result(true,"²éѯ³É¹¦"));
		
		return result; 
	}
	
	/**
	 * »ñÈ¡È«²¿´íÌâÁ·Ï°Êý¾Ý
	 * @return
	 */
	@Override
	public ExerItemResponseData queryAllExerciseFaultData(Pager pager) {
		//  1.²éѯ´ËÓû§ÊÇ·ñÓдíÌâ¼Ç¼
		String hql = "select item, fault.faultRecord.exerciseGroupId,fault.faultRecord.faultBook.status "
				+ " from ExerciseItem item, ExerciseFault fault "
				+ " where item.exerciseId=fault.exerciseItemId"
				+ " and fault.faultRecord.faultBook.userId=?" 
				+ " and fault.faultRecord.faultBook.classId=?"
				+ " and item.deleteFlag is false"
				+ " and fault.deleteFlag is false"
				+ " order by fault.createTime";
		
		List<Object[]> lstResult = this.findList(hql, pager, CollectionUtils.newList(ClientUtils.getUserId(),ClientUtils.getClassId()),Object[].class);
		
		
		if(lstResult.isEmpty()){
			return null; 
		}
		
		List<ExerciseItem> lstItems = new ArrayList<ExerciseItem>(lstResult.size());
		ExerciseItem item = null;
		String status=null;
		for(Object[] objs:lstResult){
			if(objs[2] !=null) {
				status=String.valueOf(objs[2]);//»ñÈ¡È«²¿ÌâÄ¿µÄÌύ״̬
			}
			item = new ExerciseItem();
			BeanUtils.copyProperties((ExerciseItem)objs[0], item);// ·ÀÖ¹itemͬһ¸öÄÚ´æµØÖ·
			item.setExerciseGroupId(String.valueOf(objs[1]));//ÉèÖÃÿ¸öÌâÄ¿µÄ×éid
			lstItems.add(item);
		}
		
		// 2.ÖØÐÂ×é×°Á·Ï°Ìâ ¼ÓÈë·ÖÎö½á¹û
		lstItems = exerciseVerService.getCommonExerItemDetail(lstItems, null);
		
		
		// 3.×é×°´ð°¸
		ExerItemResponseData result = new ExerItemResponseData();
		
		result.setStatus(status);
		result.setItems(lstItems);
		
		result.setResult(new Result(true,"²éѯ³É¹¦"));
		
		return result; 
	}
	
	/**
	 * »ñÈ¡µ¥Ì×Ìâ´íÌâÁ·Ï°Êý¾Ý
	 * @param groupId
	 * @return
	 */
	@Override
	public ExerItemResponseData queryExerciseFaultData(String groupId) {
		//  1.²éѯ´ËÓû§ÊÇ·ñÓдíÌâ¼Ç¼
		String hql = "select item, fault "
				+ " from ExerciseItem item, ExerciseFault fault "
				+ " where item.exerciseId=fault.exerciseItemId"
				+ " and fault.faultRecord.faultBook.userId=?"
				+ " and fault.faultRecord.exerciseGroupId=?"
				+ " and item.deleteFlag is false"
				+ " and fault.deleteFlag is false"
				+ " order by fault.createTime";
		// 2.²éѯ´ð°¸
		
		List<Object[]> lstResult = this.findwithRawResult(hql, CollectionUtils.newList(ClientUtils.getUserId(), groupId));
		
		return goQueryExerciseFaultData(lstResult, groupId); 
	}
	
	/**
	 * »ñÈ¡¶àÌ×Ìâ´íÌâÁ·Ï°Êý¾Ý
	 * @param groupId
	 * @return
	 */
	@Override
	public Map<String,Object> queryExerciseMutiFaultData(String groupId) {
		
		//  1.²éѯÌâÄ¿
		String hql = "select item.exerciseId "
				+ " from ExerciseItem item, ExerciseFault fault "
				+ " where item.exerciseId=fault.exerciseItemId"
				+ " and fault.faultRecord.faultBook.userId=?"
				+ " and fault.faultRecord.faultBook.classId=?"
				+ " and fault.faultRecord.exerciseGroupId=?"
				+ " and item.deleteFlag is false"
				+ " and fault.deleteFlag is false"
				+ " order by fault.createTime";
		
		List<String> lstFault = this.find(hql, CollectionUtils.newList(ClientUtils.getUserId(), 
				ClientUtils.getClassId(), groupId),String.class);
		
		List<Map<String,String>> lstResult = new ArrayList<Map<String,String>>(lstFault.size());
		Map<String,String>  exerciseIdMap = null;
		for(String exerciseId:lstFault){
			exerciseIdMap = new HashMap<String, String>(1);
			exerciseIdMap.put("exerciseId", exerciseId);
			lstResult.add(exerciseIdMap);
		}
		
		Map<String,Object> resultMap = new HashMap<String, Object>(2);
		resultMap.put("exerciseGroupId", groupId);
		resultMap.put("exerciseIds", lstResult);
		
		return resultMap; 
	}
	
	
	/**
	 * ²éѯ´íÌâÃ÷ϸÊý¾Ý
	 * @param lstResult
	 * @param groupId
	 * @return
	 */
	public ExerItemResponseData goQueryExerciseFaultData(List<Object[]> lstResult, String groupId) {
		if(lstResult.isEmpty()){
			return null; 
		}
		
		List<ExerciseItem> lstItems = new ArrayList<ExerciseItem>(lstResult.size());
		ExerciseItem item;
		List<ExerciseItemAnswerU> lstAnswers = new ArrayList<ExerciseItemAnswerU>(lstResult.size());
		ExerciseItemAnswerU answerU;
		
		ExerciseFault fault;
		for(Object[] objs:lstResult){
			
			item = (ExerciseItem)objs[0];
			if(StringUtils.isBlank(groupId)){// ±íʾ²éѯËùÓдíÌâ
				item.setExerciseGroupId(String.valueOf(objs[2]));//ÉèÖÃÿ¸öÌâÄ¿µÄ×éid
			}
			lstItems.add(item);
			
			fault = (ExerciseFault)objs[1];
			
			
			if(StringUtils.isNotBlank(fault.getAnswer())){
				answerU = new ExerciseItemAnswerU();
				answerU.setAnswer(fault.getAnswer());
				answerU.setCorrect(fault.getCorrect());
				answerU.setAnswerUId(fault.getExerciseFaultId());
				answerU.setExerciseItemId(fault.getExerciseItemId());
				answerU.setExerciseRecordId(fault.getFaultRecordId());
				lstAnswers.add(answerU);
			}
		}
		
		// 2.ÖØÐÂ×é×°Á·Ï°Ìâ ¼ÓÈë·ÖÎö½á¹û
		lstItems = exerciseVerService.getCommonExerItemDetail(lstItems, groupId);
		
		
		// 3.×é×°´ð°¸
		ExerItemResponseData result = new ExerItemResponseData();
		
		result.setExerciseGroupId(groupId);
				
		result.setItems(lstItems);
		
		result.setAnswers(lstAnswers);
		
		result.setResult(new Result(true,"²éѯ³É¹¦"));
		
		return result; 
	}
	
	/**
	 * »ñÈ¡Êղر¾´ð°¸Êý¾Ý 
	 */
	@Override
	public ExerItemResponseData queryExerciseFavorAnswerData(String groupId) {
		
		String hql = "select f "
				+ " from ExerciseFavorite f "
				+ " where f.favorRecord.exerciseGroupId=?"
				+ " and f.favorRecord.favorBook.userId=?"
				+ " and f.favorRecord.favorBook.classId=?"
				+ " and f.answer is not null and f.deleteFlag is false";
		
		//  1.²éѯ´íÌâ
		List<ExerciseFavorite> lstFavors = this.find(hql, CollectionUtils.newList(groupId,
				ClientUtils.getUserId(),ClientUtils.getClassId()), ExerciseFavorite.class);
		
		List<ExerciseItemAnswerU> lstAnswers = new ArrayList<ExerciseItemAnswerU>(lstFavors.size());
		ExerciseItemAnswerU answerU;
		
		for(ExerciseFavorite favor:lstFavors){
			answerU = new ExerciseItemAnswerU();
			answerU.setAnswer(favor.getAnswer());
			answerU.setCorrect(favor.getCorrect());
			answerU.setExerciseItemId(favor.getExerciseItemId());
			lstAnswers.add(answerU);
		}
			
		// 3.×é×°´ð°¸
		ExerItemResponseData result = new ExerItemResponseData();
				
		result.setAnswers(lstAnswers);
		result.setExerciseGroupId(groupId);
		
		return result; 
	}
	
	/**
	 * »ñÈ¡´íÌâ±¾´ð°¸Êý¾Ý 
	 */
	@Override
	public ExerItemResponseData queryExerciseFaultAnswerData(String groupId) {
		
		String hql = "select f "
				+ " from ExerciseFault f "
				+ " where f.faultRecord.exerciseGroupId=?"
				+ " and f.faultRecord.faultBook.userId=?"
				+ " and f.faultRecord.faultBook.classId=?"
				+ " and f.answer is not null and f.deleteFlag is false";
		
		//  1.²éѯ´íÌâ
		List<ExerciseFault> lstFaults = this.find(hql, CollectionUtils.newList(groupId, 
				ClientUtils.getUserId(),ClientUtils.getClassId()), ExerciseFault.class);
		
		List<ExerciseItemAnswerU> lstAnswers = new ArrayList<ExerciseItemAnswerU>(lstFaults.size());
		ExerciseItemAnswerU answerU;
		
		for(ExerciseFault fault:lstFaults){
			answerU = new ExerciseItemAnswerU();
			answerU.setAnswer(fault.getAnswer());
			answerU.setCorrect(fault.getCorrect());
			answerU.setExerciseItemId(fault.getExerciseItemId());
			lstAnswers.add(answerU);
		}
			
		// 3.×é×°´ð°¸
		ExerItemResponseData result = new ExerItemResponseData();
				
		result.setAnswers(lstAnswers);
		result.setExerciseGroupId(groupId);
		
		return result; 
	}

	/**
	 * ²Ù×÷±¾´Î×öÌâ¼Ç¼
	 * groupId Ï°Ìâ×éID  Èç¹ûΪAllʱ£¬±íʾȫ²¿´íÌ⡢ȫ²¿ÊÕ²Ø
	 * @return
	 */
	@Override
	public Map<String, Object> doUpdateFaultExerRecordNew(String groupId) {
		
		if("All".equals(groupId)){//±íʾȫ²¿´íÌâÖØ×ö
			return doCleanAllFaultRecordByRedo();
		}
		
		String hql="select r from ExerciseFaultRecord r,ExerciseFaultBook b where"
				+ " r.resumeBookId=b.resumeBookId and r.exerciseGroupId=? and b.userId=? and b.classId=? and b.type=?";
		
		ExerciseFaultRecord record = this.findUnique(hql, CollectionUtils.newList(groupId,
				ClientUtils.getUserId(), ClientUtils.getClassId(),ExerciseFaultBook.TYPE_ORGANIZATION), ExerciseFaultRecord.class);
		
		if(null == record){
			return null;
		}
		
		record.setScore(BigDecimal.ZERO);
		record.setCompletionRate(BigDecimal.ZERO);
		record.setDoCount(BigInteger.ZERO);
		record.setCorrectCount(BigInteger.ZERO);
		record.setAccuracy(BigDecimal.ZERO);
		record.setTitleMaxNumber("0");
		record.setStatus("0");
		
		TraceUtils.setUpdateTrace(record);
		
		this.save(record);
		
		String faultRecordId = record.getFaultRecordId();
		
		//  ÖØÐÂ×öÌâ ÇåÀí¾ÉÊý¾Ý 
		doOperExerciseFaultRecordByRedo(faultRecordId);
		
		
		// ¸üÐÂÈ«²¿ÊÕ²ØÌâÄ¿µÄÐÅÏ¢
		this.doOperFaultBookBySubmitAllAnswer(
				null, null, record.getResumeBookId(),null);
		
		
		Map<String,Object> resultMap = new HashMap<String, Object>(3);
		resultMap.put(EXERCISE_RECORD_ID, faultRecordId);
		resultMap.put("exerciseGroupId", groupId);
		resultMap.put(UPDATE_TIME,  DateTimeUtils.getCurrDateTime(record.getUpdateTime()));
		
		return resultMap;
	}
	
	/**
	 * È«²¿´íÌâÖØ×ö
	 * @return
	 */
	private Map<String,Object> doCleanAllFaultRecordByRedo(){
		
		/** 1.¸üдíÌâbook¼Ç¼Ϊ³õʼֵ */
		String hql_book = "from ExerciseFaultBook b where b.userId=? and b.classId=? and b.type=? ";
		
		ExerciseFaultBook book = this.findUnique(hql_book, CollectionUtils.newList(ClientUtils.getUserId(),
				ClientUtils.getClassId(),ExerciseFaultBook.TYPE_ORGANIZATION), ExerciseFaultBook.class);
		
		if(book == null){
			return null;
		}
		
		book.setScore(BigDecimal.ZERO);
		book.setCompletionRate(BigDecimal.ZERO);
		book.setDoCount(BigInteger.ZERO);
		book.setCorrectCount(BigInteger.ZERO);
		book.setAccuracy(BigDecimal.ZERO);
		book.setTitleMaxNumber("0");
		book.setStatus("0");
		TraceUtils.setUpdateTrace(book);
		this.save(book);
		
		String resumeBookId = book.getResumeBookId();
		BigDecimal decimalZero = BigDecimal.ZERO;
		BigInteger integerZero = BigInteger.ZERO;
		
		/** 2.¸üÐÂËùÓдíÌârecord¼Ç¼Ϊ³õʼֵ */
		String hql_record = "update ExerciseFaultRecord t set t.score="+decimalZero+", t.completionRate="+decimalZero+", t.doCount="+integerZero+","
				+ "  t.correctCount="+integerZero+", t.accuracy="+decimalZero+", t.titleMaxNumber='0', t.status='0'"
				+ "  where t.resumeBookId=? and t.deleteFlag is false";
		
		this.bulkUpdateInLoop(hql_record, new String[]{resumeBookId});
		
		
		/** 3.ÖØÐÂ×öÌâ ÇåÀíËùÓоÉÊý¾Ý    */
		// 3.1¸´ÖÆ´íÌâÊý¾Ýµ½ÀúÊ·±í
		String hql_fault = "from ExerciseFault where resumeBookId=? and answer is not null and deleteFlag is false";
		doCopyExerciseFaultToHis(hql_fault,resumeBookId);
		
		// 3.2Çå¿Õ´íÌâ×öÌâ¼Ç¼
		String hql_delFault = "update ExerciseFault t set t.answer=null,t.correct=0"
				+ " where t.resumeBookId=? and t.answer is not null and t.deleteFlag is false";
		this.bulkUpdateInLoop(hql_delFault, new String[]{resumeBookId});
		
		/** 4.·µ»Ø½á¹û    */
		Map<String,Object> resultMap = new HashMap<String, Object>(3);
		resultMap.put(EXERCISE_RECORD_ID, null);
		resultMap.put("exerciseGroupId", "All");
		resultMap.put(UPDATE_TIME, book.getUpdateTime());
		
		return resultMap;
	}
	
	/**
	 * ÖØÐÂ×öÌâ ÇåÀí¾ÉÊý¾Ý 
	 * @param faultRecordId
	 * @return
	 */
	public Result doOperExerciseFaultRecordByRedo(String faultRecordId){
		
		// 1.¿½±´×öÌâ¼Ç¼µ½´íÌâ´ð°¸ÀúÊ·±í
		String hql = "from ExerciseFault where faultRecordId=? and answer is not null and deleteFlag is false";
		doCopyExerciseFaultToHis(hql, faultRecordId);
		
		// 2.ɾ³ý×öÌâ¼Ç¼
		deleteExerciseFaultRecord(faultRecordId);
				
		return new Result(true);
	}
	
	/**
	 * ¿½±´×öÌâ¼Ç¼µ½´íÌâ´ð°¸ÀúÊ·±í
	 * @param faultRecordId/resumeBookId
	 * @return
	 */
	public Result doCopyExerciseFaultToHis(String hql,String recordId){
		List<ExerciseFault> lstFault = this.find(hql, CollectionUtils.newList(recordId), ExerciseFault.class);
		
		// ´íÌâÀúÊ·¼Ç¼±í
		List<ExerciseFaultHis> lstFaultHis = new ArrayList<ExerciseFaultHis>(lstFault.size());
		ExerciseFaultHis his = null;
		for(ExerciseFault fault:lstFault){
			his = new ExerciseFaultHis();
			BeanUtils.copyProperties(fault, his);
			his.setUpdateTime(new Date(System.currentTimeMillis()));
			
			lstFaultHis.add(his);
		}
		
		this.saveOrUpdateAll(lstFaultHis);
		
		return new Result(true);
	}
	
	/**
	 * ÅúÁ¿„h³ý´íÌâ×öÌâ¼Ç¼
	 * @param faultRecordId
	 * @return
	 */
	public Result deleteExerciseFaultRecord(String faultRecordId){
		
		String hql = "update ExerciseFault t set t.answer=null,t.correct=0"
				+ " where t.faultRecordId=? and t.answer is not null and t.deleteFlag is false";
		
		Result result = this.bulkUpdateInLoop(hql, new String[]{faultRecordId});
		this.flush();
		return result;
	}
	
	/**
	 * ÅúÁ¿„h³ý´íÌâ×öÌâ¼Ç¼
	 * @param faultRecordId
	 * @return
	 */
	public Result deleteExerciseFavorRecord(String favorRecordId){
		
		String hql = "update ExerciseFavorite t set t.answer=null,t.correct=0"
				+ " where t.favoriteRecordId=? and t.deleteFlag is false";
		
		Result result = this.bulkUpdateInLoop(hql, new String[]{favorRecordId});
		this.flush();
		return result;
	}
	
	/**
	 * ²Ù×÷±¾´Î×öÌâ¼Ç¼ ÊÕ²Ø
	 * @return
	 */
	@Override
	public Map<String, Object> doUpdateFavortExerRecordNew(String groupId) {
		
		if("All".equals(groupId)){//±íʾȫ²¿ÊÕ²ØÖØ×ö
			return doCleanAllFavorRecordByRedo();
		}
		
		
		String hql="select r from ExerciseFavoriteRecord r,ExerciseFavoriteBook b where"
				+ " r.favoriteBookId=b.favoriteBookId and r.exerciseGroupId=? and b.userId=? and b.classId=? ";
		
		ExerciseFavoriteRecord record = this.findUnique(hql, CollectionUtils.newList(groupId,
				ClientUtils.getUserId(), ClientUtils.getClassId()), ExerciseFavoriteRecord.class);
		
		if(null == record){
			return null;
		}
		
		record.setScore(BigDecimal.ZERO);
		record.setCompletionRate(BigDecimal.ZERO);
		record.setDoCount(BigInteger.ZERO);
		record.setCorrectCount(BigInteger.ZERO);
		record.setAccuracy(BigDecimal.ZERO);
		record.setTitleMaxNumber("0");
		record.setStatus("0");
		
		TraceUtils.setUpdateTrace(record);
		
		this.save(record);
		
		String favoriteRecordId = record.getFavoriteRecordId();
	
		//  ÖØпªÊ¼×öÌâ ÇåÀí¾ÉÊý¾Ý
		doOperExerciseFavorRecordByRedo(favoriteRecordId);
		
		// ¸üÐÂÈ«²¿ÊÕ²ØÌâÄ¿µÄͳ¼ÆÐÅÏ¢
		this.doOperFavorBookBySubmitAllAnswer(null, null, record.getFavoriteBookId(),null);
		
		Map<String,Object> resultMap = new HashMap<String, Object>(3);
		resultMap.put(EXERCISE_RECORD_ID, favoriteRecordId);
		resultMap.put(UPDATE_TIME, DateTimeUtils.getCurrDateTime(record.getUpdateTime()));
		return resultMap;
	}
	
	/**
	 * È«²¿ÊÕ²ØÖØ×ö
	 * @return
	 */
	private Map<String,Object> doCleanAllFavorRecordByRedo(){
		
		/** 1.¸üÐÂÊÕ²Øbook¼Ç¼Ϊ³õʼֵ */
		String hql_book = "from ExerciseFavoriteBook b where b.userId=? and b.classId=? and b.type=? ";
		
		ExerciseFavoriteBook book = this.findUnique(hql_book, CollectionUtils.newList(ClientUtils.getUserId(),
				ClientUtils.getClassId(),ExerciseFaultBook.TYPE_ORGANIZATION), ExerciseFavoriteBook.class);
		
		if(book == null){
			return null;
		}
		
		book.setScore(BigDecimal.ZERO);
		book.setCompletionRate(BigDecimal.ZERO);
		book.setDoCount(BigInteger.ZERO);
		book.setCorrectCount(BigInteger.ZERO);
		book.setAccuracy(BigDecimal.ZERO);
		book.setTitleMaxNumber("0");
		book.setStatus("0");
		TraceUtils.setUpdateTrace(book);
		this.save(book);
		
		String favoriteBookId = book.getFavoriteBookId();
		BigDecimal decimalZero = BigDecimal.ZERO;
		BigInteger integerZero = BigInteger.ZERO;
		
		/** 2.¸üÐÂËùÓÐÊÕ²Ørecord¼Ç¼Ϊ³õʼֵ */
		String hql_record = "update ExerciseFavoriteRecord t set t.score="+decimalZero+", t.completionRate="+decimalZero+", t.doCount="+integerZero+","
				+ "  t.correctCount="+integerZero+", t.accuracy="+decimalZero+", t.titleMaxNumber='0', t.status='0'"
				+ "  where t.favoriteBookId=? and t.deleteFlag is false";
		
		this.bulkUpdateInLoop(hql_record, new String[]{favoriteBookId});
		
		
		/** 3.ÖØÐÂ×öÌâ ÇåÀíËùÓоÉÊý¾Ý    */
		// 3.1¸´ÖÆÊÕ²ØÊý¾Ýµ½ÀúÊ·±í
		String hql_favor = "from ExerciseFavorite where favoriteBookId=? and answer is not null and deleteFlag is false";
		doCopyExerciseFavorToHis(hql_favor,favoriteBookId);
		
		// 3.2Çå¿ÕÊÕ²Ø×öÌâ¼Ç¼
		String hql_delFavor = "update ExerciseFavorite t set t.answer=null,t.correct=0"
				+ " where t.favoriteBookId=? and t.answer is not null and t.deleteFlag is false";
		this.bulkUpdateInLoop(hql_delFavor, new String[]{favoriteBookId});
		
		/** 4.·µ»Ø½á¹û    */
		Map<String,Object> resultMap = new HashMap<String, Object>(3);
		resultMap.put(EXERCISE_RECORD_ID, null);
		resultMap.put("exerciseGroupId", "All");
		resultMap.put(UPDATE_TIME, book.getUpdateTime());
		
		return resultMap;
	}
	
	/**
	 * ÖØпªÊ¼×öÌâ ÇåÀí¾ÉÊý¾Ý
	 * @param favoriteRecordId
	 * @return
	 */
	public Result doOperExerciseFavorRecordByRedo(String favoriteRecordId){
		
		// 1.¿½±´×öÌâ¼Ç¼µ½Êղشð°¸ÀúÊ·±í
		String hql = "from ExerciseFavorite where favoriteRecordId=? and answer is not null and deleteFlag is false";
		doCopyExerciseFavorToHis(hql, favoriteRecordId);
		
		// 2.ɾ³ý×öÌâ¼Ç¼
		deleteExerciseFavorRecord(favoriteRecordId);
		
		return new Result(true);
	}
	
	/**
	 * ¿½±´×öÌâ¼Ç¼µ½Êղشð°¸ÀúÊ·±í
	 * @param faultRecordId/favoriteBookId
	 * @return
	 */
	public Result doCopyExerciseFavorToHis(String hql, String recordId){
		List<ExerciseFavorite> lstFavor = this.find(hql, CollectionUtils.newList(recordId), ExerciseFavorite.class);
		
		// ´íÌâÀúÊ·¼Ç¼±í
		List<ExerciseFavoriteHis> lstFavorHis = new ArrayList<ExerciseFavoriteHis>(lstFavor.size());
		ExerciseFavoriteHis his = null;
		for(ExerciseFavorite favor:lstFavor){
			his = new ExerciseFavoriteHis();
			BeanUtils.copyProperties(favor, his);
			his.setUpdateTime(new Date(System.currentTimeMillis()));
			
			lstFavorHis.add(his);
		}
		
		this.saveOrUpdateAll(lstFavorHis);
		
		return new Result(true);
	}
	
	/**
	 * ²éѯÌâĿͳ¼Æ·ÖÎö½á¹û ¸öÈËͳ¼Æ ȫվͳ¼Æ
	 * @param exerciseType
	 * @return
	 */
	@Override
	public List<Map<String, Object>> queryExerciseItemStatisics(String exerciseType) {
		// ÌâÄ¿¸öÈËͳ¼Æ
		String hql_analisisU = "";
		// ÌâĿȫվͳ¼Æ
		String hql_analisis = "";
		// 퉀		String hql_item = "";
		
		if(Constants.EXERCISE_TYPE_FAULT.equals(exerciseType)){// ´íÌâ±¾
			
			hql_analisisU = "select a from ExerciseItemAnalisiU a,ExerciseFault re"
					+ " where a.exerciseItemId=re.exerciseItemId "
					+ " and a.userId=? and re.faultBook.userId=? and re.faultBook.classId=?"
					+ " and a.deleteFlag is false and re.deleteFlag is false ";
			
			hql_analisis = "select a from ExerciseItemAnalisi a, ExerciseFault re"
					+ " where a.exerciseItemId=re.exerciseItemId "
					+ " and re.faultBook.userId=? and re.faultBook.classId=?"
					+ " and a.deleteFlag is false and re.deleteFlag is false ";
			
			hql_item = "select re.exerciseItemId from ExerciseFault re"
					+ " where re.faultBook.userId=? and re.faultBook.classId=? "
					+ " and re.deleteFlag is false order by re.createTime";
			
		}else if(Constants.EXERCISE_TYPE_FAVORT.equals(exerciseType)){// ÊÕ²Ø
			
			hql_analisisU =  "select a from ExerciseItemAnalisiU a,ExerciseFavorite re"
					+ " where a.exerciseItemId=re.exerciseItemId "
					+ " and a.userId=? and re.favorBook.userId=? and re.favorBook.classId=?"
					+ " and a.deleteFlag is false and re.deleteFlag is false ";
			
			hql_analisis = "select a from ExerciseItemAnalisi a, ExerciseFavorite re"
					+ " where a.exerciseItemId=re.exerciseItemId "
					+ " and re.favorBook.userId=? and re.favorBook.classId=?"
					+ " and a.deleteFlag is false and re.deleteFlag is false ";
			
			hql_item =  "select re.exerciseItemId from ExerciseFavorite re"
					+ " where re.favorBook.userId=? and re.favorBook.classId=? "
					+ " and re.deleteFlag is false order by re.createTime";
		}
		
		List<Map<String, Object>> resultLst = this.doQueryExerciseItemStatisicsData(hql_analisisU, hql_analisis, hql_item);
		
		return resultLst;
	}
	
	/**
	 * ²éѯ´íÌâÌâĿͳ¼Æ
	 * @return
	 */
	private List<Map<String, Object>> doQueryExerciseItemStatisicsData(String hql_analisisU,
			String hql_analisis, String hql_item) {
		// 1.²éѯ¸öÈËͳ¼Æ
		List<ExerciseItemAnalisiU> lstAnalisiU = this.find(hql_analisisU,
				CollectionUtils.newList(ClientUtils.getUserId(),ClientUtils.getUserId(),ClientUtils.getClassId()), ExerciseItemAnalisiU.class);
		
		Map<String, ExerciseItemAnalisiU> anasisUMap = new HashMap<String, ExerciseItemAnalisiU>(lstAnalisiU.size());
		for(ExerciseItemAnalisiU analisisU:lstAnalisiU){
			anasisUMap.put(analisisU.getExerciseItemId(), analisisU);
		}
		
		// 2.²éѯȫվͳ¼Æ
		List<ExerciseItemAnalisi> lstAnalisi = this.find(hql_analisis,
				CollectionUtils.newList(ClientUtils.getUserId(),ClientUtils.getClassId()), ExerciseItemAnalisi.class);
		Map<String, ExerciseItemAnalisi> anasisMap = new HashMap<String, ExerciseItemAnalisi>(lstAnalisi.size());
		for(ExerciseItemAnalisi analisi:lstAnalisi){
			anasisMap.put(analisi.getExerciseItemId(), analisi);
		}
		
		if(lstAnalisiU.isEmpty() && lstAnalisi.isEmpty()){
			return null;
		}
		
		// 3.²éѯ´Ë×éËùÓÐÌâÄ¿
		List<String> lstItemIds = this.find(hql_item,
				CollectionUtils.newList(ClientUtils.getUserId(),ClientUtils.getClassId()), String.class);
		
		List<Map<String, Object>> lstResult = new ArrayList<Map<String, Object>>(lstItemIds.size());
		Map<String, Object> resultMap = null;
		ExerciseItemAnalisi analisis;
		ExerciseItemAnalisiU analisisU;
		
		// 3.×é×°½á¹û 
		
		// Ñ­»µ×éËùÓÐÌâÄ¿
		for(String  exerciseItemId:lstItemIds){
			// ½á¹ûmap
			resultMap = new HashMap<String, Object>(10);
			
			// 1.¸öÈË·ÖÎö½á¹û
			analisisU = anasisUMap.get(exerciseItemId);
			// 2.È«Õ¾·ÖÎö½á¹û
			analisis = anasisMap.get(exerciseItemId);
			
			resultMap.put("exerciseId", exerciseItemId);
			
			// 3.¸öÈËͳ¼Æ
			if(null == analisisU){// Ϊ¿Õ
				resultMap.put("doAll_u", 0);
				resultMap.put("doError_u", 0);
				resultMap.put("doAccuracy_u", 0);
			}else{
				resultMap.put("doAll_u", analisisU.getSubmitNumber());
				resultMap.put("doError_u", analisisU.getSubmitNumber().subtract(analisisU.getSubmitCorrectNumber()));
				resultMap.put("doAccuracy_u", analisisU.getAccuracy());
			}
			
			// 4.ȫվͳ¼Æ
			if(null == analisis){// Ϊ¿Õ
				resultMap.put("doAll", 0);
				resultMap.put("doAccuracy", 0);
			}else{
				resultMap.put("doAll", analisis.getSubmitNumber());
				resultMap.put("doAccuracy", analisis.getAccuracy());
			}
			
			lstResult.add(resultMap);
		}
		
		
		return lstResult;
	}
	
	/**
	 * ¸üдíÌâbookÐÅÏ¢
	 * @param faultBookId
	 * @return
	 */
	@SuppressWarnings("unchecked")
	private void updateExerciseFaultBookInfo(ExerciseFaultBook book){
		
		String sql = "SELECT"+
				" count(1) allCount,"+
				" sum(CORRECT = 1) corrCount,"+
				" sum(ANSWER IS NOT NULL) doCount,"+
				" round(sum(CORRECT = 1) / count(1) * 100,2) accuracy,"+
				" round(sum(ANSWER IS NOT NULL) / count(1) * 100,2) rate"+
				" FROM exercise_fault"+
				" WHERE DELETE_FLAG = 0"+
				" AND RESUME_BOOK_ID = ?";

		List<Object[]> lstFault = this.findBySql(sql,  CollectionUtils.newList(book.getResumeBookId()));
		
		Object[] objs = lstFault.get(0);
		book.setAllCount((BigInteger)objs[0]);
		book.setCorrectCount(new BigInteger(String.valueOf(objs[1]==null ? "0" : objs[1])));
		book.setDoCount(new BigInteger(String.valueOf(objs[2]==null ? "0" : objs[2])));
		book.setAccuracy(new BigDecimal(String.valueOf(objs[3]==null ? "0" : objs[3])));
		book.setCompletionRate(new BigDecimal(String.valueOf(objs[4]==null ? "0" : objs[4])));
		book.setScore(book.getAccuracy());
	}
	
	/**
	 * ¸üдíÌâbookÐÅÏ¢ byÌύȫ²¿´íÌâ´ð°¸
	 * @param currTitleNum
	 * @param status
	 * @return
	 */
	@Override
	public Result doOperFaultBookBySubmitAllAnswer(String currTitleNum,
			String status,String faultBookId, String exerciseType) {
		ExerciseFaultBook book = null;
		if(StringUtils.isBlank(faultBookId)){// ÊÇ·ñÈ«²¿´íÌâ  ½ö½öÌá½»²Ù×÷
			if(Constants.EXERCISE_TYPE_FAULT.equals(exerciseType)
				&& ExerciseRecord.STATUS_SUBMIT.equals(status)){// È«²¿´íÌâ½öÌá½»´ð°¸
				
				book = this.findUnique("from ExerciseFaultBook where classId=? and userId=? and type=? and deleteFlag is false ",
						CollectionUtils.newList(ClientUtils.getClassId(), 
						ClientUtils.getUserId(),ExerciseFaultBook.TYPE_ORGANIZATION), ExerciseFaultBook.class);
				
			}else{
				return new Result(false);
			}
			
		}else{// »ìºÏÌá½»
			book = this.read(ExerciseFaultBook.class, faultBookId);
			if(book == null){
				return new Result(false);
			}
		}
		
		// ¸üÐÂbookÐÅÏ¢
		this.updateExerciseFaultBookInfo(book);
		
		if(StringUtils.isNotBlank(currTitleNum)){
			book.setTitleMaxNumber(currTitleNum);
		}
		if(StringUtils.isNotBlank(status)){
			book.setStatus("1".equals(status)?"1":"0");// 1£ºÌá½» 0£ºÎ´Ìá½»
			
			if("1".equals(status)){// È«²¿´íÌâÌá½»´ð°¸Ê±  ¶ÔÓ¦µÄrecordÒ²¸ÄΪÌύ״̬
				
				/** ¸üÐÂËùÓдíÌârecord¼Ç¼ΪÌύ״̬ */
				String hql_record = "update ExerciseFaultRecord t set t.status='1'"
						+ "  where t.resumeBookId=? and t.deleteFlag is false";
				
				this.bulkUpdateInLoop(hql_record, new String[]{book.getResumeBookId()});
			}
		}
		
		TraceUtils.setUpdateTrace(book);
		this.save(book);
		
		return new Result(true);
	}

	/**
	 * ¸üÐÂÊÕ²ØbookÐÅÏ¢
	 * @param faultBookId
	 * @return
	 */
	@SuppressWarnings("unchecked")
	private void updateExerciseFavorBookInfo(ExerciseFavoriteBook book){
		String sql = "SELECT"+
				" count(1) allCount,"+
				" sum(CORRECT = 1) corrCount,"+
				" sum(ANSWER IS NOT NULL) doCount,"+
				" round(sum(CORRECT = 1) / count(1) * 100,2) accuracy,"+
				" round(sum(ANSWER IS NOT NULL) / count(1) * 100,2) rate"+
				" FROM exercise_favorite"+
				" WHERE DELETE_FLAG = 0"+
				" AND FAVORITE_BOOK_ID = ?";

		List<Object[]> lstFault = this.findBySql(sql,  CollectionUtils.newList(book.getFavoriteBookId()));
		
		Object[] objs = lstFault.get(0);
		book.setAllCount((BigInteger)objs[0]);
		book.setCorrectCount(new BigInteger(String.valueOf(objs[1]==null ? "0" : objs[1])));
		book.setDoCount(new BigInteger(String.valueOf(objs[2]==null ? "0" : objs[2])));
		book.setAccuracy(new BigDecimal(String.valueOf(objs[3]==null ? "0" : objs[3])));
		book.setCompletionRate(new BigDecimal(String.valueOf(objs[4]==null ? "0" : objs[4])));
		book.setScore(book.getAccuracy());
	}
	
	/**
	 * ¸üÐÂÊÕ²ØbookÐÅÏ¢ byÌύȫ²¿Êղشð°¸
	 * @param currTitleNum
	 * @param status
	 * @return
	 */
	@Override
	public Result doOperFavorBookBySubmitAllAnswer(String currTitleNum,
			String status,String favoriteBookId, String exerciseType) {
		
		ExerciseFavoriteBook book = null;
		if(StringUtils.isBlank(favoriteBookId)){// ÊÇ·ñÈ«²¿ÊÕ²Ø  ½ö½öÌá½»²Ù×÷
			if(Constants.EXERCISE_TYPE_FAVORT.equals(exerciseType)
				&& ExerciseRecord.STATUS_SUBMIT.equals(status)){// È«²¿´íÌâ½öÌá½»´ð°¸
				
				book = this.findUnique("from ExerciseFavoriteBook where classId=? and userId=? and type=? and deleteFlag is false ",
						CollectionUtils.newList(ClientUtils.getClassId(), 
						ClientUtils.getUserId(),ExerciseFaultBook.TYPE_ORGANIZATION), ExerciseFavoriteBook.class);
				
			}else{
				return new Result(false);
			}
			
		}else{// »ìºÏÌá½»
			book = this.read(ExerciseFavoriteBook.class, favoriteBookId);
			if(book == null){
				return new Result(false);
			}
		}
		
		// ¸üÐÂÊÕ²ØbookÐÅÏ¢
		this.updateExerciseFavorBookInfo(book);
		
		if(StringUtils.isNotBlank(currTitleNum)){
			book.setTitleMaxNumber(currTitleNum);
		}
		
		if(StringUtils.isNotBlank(status)){
			book.setStatus("1".equals(status)?"1":"0");// 1£ºÌá½» 0£ºÎ´Ìá½»
			
			if("1".equals(status)){// È«²¿ÊÕ²ØÌá½»´ð°¸Ê±  ¶ÔÓ¦µÄrecordÒ²¸ÄΪÌύ״̬
				
				/** ¸üÐÂËùÓÐÊÕ²Ørecord¼Ç¼ΪÌύ״̬ */
				String hql_record = "update ExerciseFavoriteRecord t set t.status='1'"
						+ "  where t.favoriteBookId=? and t.deleteFlag is false";
				
				this.bulkUpdateInLoop(hql_record, new String[]{book.getFavoriteBookId()});
			}
		}
		
		TraceUtils.setUpdateTrace(book);
		this.save(book);
		
		return new Result(true);
	}
	
	/**
	 * ²éѯ´íÌâ±¾bookÐÅÏ¢
	 */
	@Override
	public Map<String, Object> queryExerFaultInfo() {
		String hql = "from ExerciseFaultBook where classId=? and userId=? and type=? and deleteFlag is false ";
		
		ExerciseFaultBook book = this.findUnique(hql, CollectionUtils.newList(ClientUtils.getClassId(), 
				ClientUtils.getUserId(), ExerciseFaultBook.TYPE_ORGANIZATION), ExerciseFaultBook.class);
		
		Map<String, Object> map = new HashMap<String, Object>(5);
		
		if(book == null){
			map.put("allCount", 0);
			map.put("doCount", 0);
			map.put(UPDATE_TIME, null);
			map.put("currTitleNum",  "0");
			map.put("status",  "0");
			return map;
		}
		
		map.put("allCount", book.getAllCount());
		map.put("doCount", book.getDoCount());
		map.put(UPDATE_TIME, book.getUpdateTime());
		map.put("currTitleNum", StringUtils.isBlank(book.getTitleMaxNumber()) ? "0" :book.getTitleMaxNumber());
		map.put("status",  StringUtils.isBlank(book.getStatus()) ? "0" :book.getStatus());
		
		return map;
	}

	/**
	 * ²éѯÊղر¾bookÐÅÏ¢
	 */
	@Override
	public Map<String, Object> queryExerFavorInfo() {
		String hql = "from ExerciseFavoriteBook where classId=? and userId=? and type=? and deleteFlag is false ";
		
		ExerciseFavoriteBook book = this.findUnique(hql, CollectionUtils.newList(ClientUtils.getClassId(), 
				ClientUtils.getUserId(), ExerciseFavoriteBook.TYPE_ORGANIZATION), ExerciseFavoriteBook.class);
		
		Map<String, Object> map = new HashMap<String, Object>(5);
		
		if(book == null){
			map.put("allCount", 0);
			map.put("doCount", 0);
			map.put(UPDATE_TIME, null);
			map.put("currTitleNum",  "0");
			map.put("status",  "0");
			return map;
		}
		
		map.put("allCount", book.getAllCount());
		map.put("doCount", book.getDoCount());
		map.put(UPDATE_TIME, book.getUpdateTime());
		map.put("currTitleNum", StringUtils.isBlank(book.getTitleMaxNumber()) ? "0" :book.getTitleMaxNumber());
		map.put("status",  StringUtils.isBlank(book.getStatus()) ? "0" :book.getStatus());
		
		return map;	
	}
	
	/**
	 * ¼ÆËãÓû§Ã¿Ìì×ö´íÌâµÄͳ¼ÆÐÅÏ¢
	 */
	@SuppressWarnings("unchecked")
	@Override
	public Result doCalcExerFaultStatisticsByDay(){
		log.info("---------------¶¨Ê±Æ÷ ¿ªÊ¼Í³¼Æ×öÌâ´íÌâͳ¼ÆÐÅÏ¢-----------start ------------------");
		// 1.¼ÆËãÇ°Ò»Ìì ¶ÔÓ¦×öÌâÈ˵Ä×öÌâÐÅÏ¢
		String sql = "SELECT"
				+ " 	r.CLASS_ID,"
				+ " 	t.USER_ID,"
				+ " 	count(1) doCount,"
				+ " 	sum(t.CORRECT = 0) faultCount,"
				+ " 	r.ORG_ID,"
				+ " 	r.COLLEGE_COURSE_ID,"
				+ " 	r.SUBJECT_ID"
				+ " FROM"
				+ " 	exercise_item_answer_u t,"
				+ " 	exercise_record r"
				+ " WHERE"
				+ " 	t.EXERCISE_RECORD_ID = r.RECORD_ID"
				+ " AND t.UPDATE_TIME >= ?"
				+ " AND t.UPDATE_TIME < ?"
				+ " AND t.DELETE_FLAG = 0"
				+ " AND r.DELETE_FLAG = 0"
				+ " GROUP BY"
				+ " 	r.CLASS_ID,"
				+ " 	t.USER_ID";
		
		String yesterday = DateUtils.getTheDay(-1);
		List<Object[]> resultlst = this.findBySql(sql, CollectionUtils.newList(yesterday, DateUtils.getToday()));
		
		
		// 2.´íÌâÐÅÏ¢¼Ç¼±í
		List<ExerciseFaultStatistics> statisLst = new ArrayList<ExerciseFaultStatistics>(resultlst.size());
		ExerciseFaultStatistics faultStatis = null;
		for(Object[] objs:resultlst){
			faultStatis = new ExerciseFaultStatistics();
			
			faultStatis.setClassId(String.valueOf(objs[0]));
			faultStatis.setUserId(String.valueOf(objs[1]));
			faultStatis.setDoCount(new BigInteger(String.valueOf(objs[2])));
			faultStatis.setFaultCount(new BigInteger(String.valueOf(objs[3])));
			faultStatis.setFaultRate( ExerciseUtils.parseStrToBigDecimal(String.valueOf(objs[3]), String.valueOf(objs[2])));
			faultStatis.setOrgId(String.valueOf(objs[4]));
			faultStatis.setCollegeCourseId(String.valueOf(objs[5]));
			faultStatis.setSubjectId(String.valueOf(objs[6]));
			faultStatis.setExerciseTime(DateTimeUtils.stringConvertTS(yesterday));
			
			TraceUtils.setCreateTrace(faultStatis);
			statisLst.add(faultStatis);
		}
		
		this.saveOrUpdateAll(statisLst);
		
		log.info("---------------¶¨Ê±Æ÷ ¿ªÊ¼Í³¼Æ×öÌâ´íÌâͳ¼ÆÐÅÏ¢-----------end ------------------");
		return new Result(true, "²Ù×÷³É¹¦,ͳ¼Æ¼Ç¼×ÜÌõÊý£º"+statisLst.size());
	}
	
	/**
	 * ²éѯ´íÌâͳ¼ÆÐÅÏ¢
	 * @param type:  week ×î½üÒ»ÖÜ   month:×î½üÒ»Ô  year£º×î½üÒ»Äê
	 * @return
	 */
	@Override
	public List<Map<String,Object>> doGetFaultStatisInfo(String type) {
		try {
			// ¿ªÊ¼Ê±¼ä
			String startDate = "";
			// ½áÊøʱ¼ä  ½ñÌì
			String endDate = DateUtils.getToday();
				
			if("week".equals(type)){// ×î½üÒ»ÖÜ     7ÌìÇ°µ½½ñÌì ²»°üº¬½ñÌì
				
				startDate= DateUtils.getTheDay(-7);
			}else if("month".equals(type)){// ×î½üÒ»Ô   30ÌìÇ°µ½½ñÌì  ²»°üº¬½ñÌì
				
				startDate= DateUtils.getTheDay(-30);
			}else if("year".equals(type)){// ×î½üÒ»Äê 365ÌìÇ°µ½½ñÌì  ²»°üº¬½ñÌì
				
				startDate= DateUtils.getTheDay(-365);
			}
			
			String hql = "select exerciseTime,doCount,faultCount,faultRate"
					+ "  from ExerciseFaultStatistics where deleteFlag is false "
					+ " and userId=? and classId=?"
					+ " and exerciseTime >=? and exerciseTime<=?"
					+ " order by exerciseTime";
			
			// ²éѯ½á¹û
			List<Object[]> statisLst = this.findwithRawResult(hql, 
						CollectionUtils.newList(ClientUtils.getUserId(),ClientUtils.getClassId(), 
								DateUtils.convertStringToDate(startDate, "yyyy-MM-dd"), 
								DateUtils.convertStringToDate(endDate, "yyyy-MM-dd")));
			
			
			Map<String,Object> resultMap = null;
			List<Map<String,Object>> resultLst = new ArrayList<Map<String,Object>>(statisLst.size());
			
			if(statisLst.isEmpty()){
				return resultLst;
			}
			
			for(Object[] objs:statisLst){
				resultMap = new HashMap<String, Object>(4);
				resultMap.put("exerciseTime", objs[0]);
				resultMap.put("doCount", objs[1]);
				resultMap.put("faultCount", objs[2]);
				resultMap.put("faultRate", objs[3]);
			
				resultLst.add(resultMap);
			}
			
			return resultLst;
			
		} catch (ParseException e) {
			log.error("²éѯ´íÌâÈÝ´íÂʽӿÚÒì³£", e);
		}
		
		return null;
	}
	
	/**
	 * ²Ù×÷±¾´Î×öÌâ¼Ç¼ ´íÌâ
	 * @return
	 */
	@Override
	public Result doUpdateExerciseFaultRecord(ExerciseFaultRecord record) {
		//TraceUtils.setUpdateTrace(record);²»¸üÐÂupdateTime
		this.save(record);
		return new Result(true);
	}

	/**
	 * ²Ù×÷±¾´Î×öÌâ¼Ç¼ ÊÕ²Ø
	 * @return
	 */
	@Override
	public Result doUpdateExerciseFavorRecord(ExerciseFavoriteRecord record) {
		//TraceUtils.setUpdateTrace(record); ²»¸üÐÂupdateTime
		this.save(record);
		return new Result(true);
	}
	
	/**
	 * 
	 * ±£´æapp¶ËÇëÇó±£´æµÄÊý¾Ý
	 * @return
	 */
	@Override
	public String doSaveExerciseDataSubmitLog(String data,
			String exerBussinessId, short type, int status, String url) {
		
		return exerciseVerService.doSaveExerciseDataSubmitLog(data,
				exerBussinessId, type, status, url);
	}
	
	@Override
	public Result doUpdateExerciseFaultBook(String currTitleNum) {
		//  ²éѯ´ËÓû§ÊÇ·ñÓÐÊղؼǼ
		String hql = "from ExerciseFaultBook where classId=? and userId=? and deleteFlag is false ";
		
		List<ExerciseFaultBook> lstFault = this.find(hql,
				CollectionUtils.newList(ClientUtils.getClassId(), 
						ClientUtils.getUserId()), ExerciseFaultBook.class);
		
		
		ExerciseFaultBook book =  lstFault.get(0);
		
		book.setTitleMaxNumber(currTitleNum);
		this.save(book);
		
		return new Result(true);
	}

	@Override
	public Result doUpdateExerciseFavorBook(String currTitleNum) {
		//  ²éѯ´ËÓû§ÊÇ·ñÓÐÊղؼǼ
		String hql = "from ExerciseFavoriteBook where classId=? and userId=? and deleteFlag is false ";
		
		List<ExerciseFavoriteBook> lstFavor = this.find(hql,
				CollectionUtils.newList(ClientUtils.getClassId(), 
						ClientUtils.getUserId()), ExerciseFavoriteBook.class);
		
		
		ExerciseFavoriteBook book =  lstFavor.get(0);
		
		book.setTitleMaxNumber(currTitleNum);
		this.save(book);
		
		return new Result(true);
	}

	/**
	 *Ìá½»¶àÌ×Ìâ´ð°¸½á¹ûµ½db 
	 */
	@Override
	public Map<String, Object> doSubmitMutiExerciseAnswerData(ExerciseSubmitAnswerDataList answerDataList) {
		// Óû§±¾´Î×öÌâÌá½»µÄÊý¾Ý
		List<ExerciseSubmitAnswerData> lstRecord = null;
		ExerciseSubmitAnswerData answerResult= null;
		List<ExerciseItemAnswerData> lstAnswers= null;
		Map<String,Object> resultMap = new HashMap<String,Object>(2);
		Map<String,Object> returnMap = null;
		resultMap.put("success", false);
		resultMap.put("attrs", null);
		
		lstRecord = answerDataList.getDatas();
		
		List<Map<String,Object>> resultList = new ArrayList<Map<String,Object>>(lstRecord.size());
		
		// ´íÌâ¡¢Êղر¾bookid
		String faultBookId = null;
		String favoriteBookId = null;
		for(int i=0; i<lstRecord.size(); i++){
			
			answerResult = lstRecord.get(i);
			if(null == answerResult){
				continue;
			}
			
			lstAnswers = answerResult.getItems();
			
			// ¼Ç¼id
			String initExerciseRecordId = answerResult.getExerciseRecordId();
						
			String recordData = JSONObject.toJSONString(answerResult);
			
			if(lstAnswers.isEmpty() 
					&& !ExerciseRecord.STATUS_SUBMIT.equals(answerResult.getStatus()) 
					&& answerResult.getSubmitType() != 1){// Ìύ״̬
				this.doSaveExerciseDataSubmitLog(recordData,
						initExerciseRecordId, ExerciseDataSubmitLog.TYPE_SUBMIT_EXTEND_ANSWER,
						ExerciseDataSubmitLog.STATUS_FAILED, "/exercise/Extend/exerExtendMutiAnswers");
				continue;
			}
			
			/**  1.---------¼Ç¼Ìá½»µÄÊý¾ÝÈÕÖ¾ */
			// ¼Ç¼Ìá½»µÄÊý¾ÝÈÕÖ¾
			String exerciseDataLogId = this.doSaveExerciseDataSubmitLog(recordData,
					initExerciseRecordId, ExerciseDataSubmitLog.TYPE_SUBMIT_EXTEND_ANSWER, 
					ExerciseDataSubmitLog.STATUS_SUCCESS, "/exercise/Extend/exerExtendMutiAnswers");
						
			/** 2.Ìá½»´ð°¸  */
			String exerciseType = answerResult.getType();
			if(Constants.EXERCISE_TYPE_FAULT.equals(exerciseType)){// ´íÌâ±¾
				// ¸üРÌá½»Á·Ï°´ð°¸
				returnMap = this.doSubmitExerFaultAnswerDataNew(answerResult);
				
				if(null == returnMap){
					continue;
				}
				
				faultBookId = (String) returnMap.get("exerciseBookId");
			}else if(Constants.EXERCISE_TYPE_FAVORT.equals(exerciseType)){// ÊÕ²Ø
				// ¸üРÌá½»Á·Ï°´ð°¸
				returnMap = this.doSubmitExerFavorAnswerDataNew(answerResult);
				
				if(null == returnMap){
					continue;
				}
				
				favoriteBookId = (String) returnMap.get("exerciseBookId");
			}else{
				continue;
			}
			
			/** 3.·¢ËÍ ÌâÄ¿µÄȫվͳ¼Æ  ¸öÈËͳ¼ÆÇëÇóÏûÏ¢  */
			exerciseVerService.sendUpdateExerItemStatisticsMsg(answerResult.getExerciseGroupId(), answerResult);
			
			returnMap.put("type", exerciseType);
			resultList.add(returnMap);
			
			// 4.---------¸üб¾´ÎÌá½»µÄÊý¾ÝÈÕÖ¾exerciseRecordId
			if(StringUtils.isBlank(initExerciseRecordId) 
					&& returnMap.get(EXERCISE_RECORD_ID) != null){// Ϊ¿Õ ˵Ã÷µÚÒ»´ÎÌá½»  ¸üÐÂÈÕÖ¾¼Ç¼id
				exerciseVerService.doUpdateExerciseDataSubmitLog(exerciseDataLogId, 
						String.valueOf(returnMap.get(EXERCISE_RECORD_ID)));
				
			}
						
		}
		
		/** 4.ÅжÏÊÇ·ñÈ«²¿×öÌâʱ ͳ¼ÆÈ«²¿×öÌâÐÅÏ¢  */
		this.doOperFaultBookBySubmitAllAnswer(
				answerDataList.getCurrTitleNum(), answerDataList.getStatus(),faultBookId, answerDataList.getExerciseType());
		
		this.doOperFavorBookBySubmitAllAnswer(
				answerDataList.getCurrTitleNum(), answerDataList.getStatus(),favoriteBookId, answerDataList.getExerciseType());
		
		/**  5.·µ»Ø½á¹û */
		resultMap.put("success", true);
		resultMap.put("attrs", resultList);
		resultMap.put("msg", "Ìá½»³É¹¦");
		
		return resultMap;
	}
	
	/**
	 * Ìá½»µ¥Ì×Ìâ´ð°¸½á¹ûµ½db 
	 */
	@Override
	public Result doSubmitExerciseAnswerData(ExerciseSubmitAnswerData answerResult) {
		// Óû§±¾´Î×öÌâÌá½»µÄÊý¾Ý
		Result result = new Result(false);
					
		if(answerResult.getItems().isEmpty() 
				&& !ExerciseRecord.STATUS_SUBMIT.equals(answerResult.getStatus()) 
				&& answerResult.getSubmitType() != 1){// Ìύ״̬
			return result;
		}
		
		String exerciseType = answerResult.getType();
		
		Map<String,Object> resultMap = null;
		if(Constants.EXERCISE_TYPE_FAULT.equals(exerciseType)){// ´íÌâ±¾
			// ¸üРÌá½»Á·Ï°´ð°¸
			resultMap = this.doSubmitExerFaultAnswerDataNew(answerResult);
			
			if(null == resultMap){
				return new Result(false,"Ìύʧ°Ü");
			}
			
			// ͳ¼ÆÈ«²¿×öÌâÐÅÏ¢/
			this.doOperFaultBookBySubmitAllAnswer(null,null,(String) resultMap.get("exerciseBookId"),null);
			
		}else if(Constants.EXERCISE_TYPE_FAVORT.equals(exerciseType)){// ÊÕ²Ø
			// ¸üРÌá½»Á·Ï°´ð°¸
			resultMap = this.doSubmitExerFavorAnswerDataNew(answerResult);
			
			if(null == resultMap){
				return new Result(false,"Ìύʧ°Ü");
			}
			
			// ͳ¼ÆÈ«²¿×öÌâÐÅÏ¢/
			this.doOperFavorBookBySubmitAllAnswer(null,null, (String) resultMap.get("exerciseBookId"),null);
		}else{
			
			return new Result(false, "exerciseType´«Öµ´íÎó£ºexerciseType="+exerciseType);
		}
		
		
		// 3.·¢ËÍ ÌâÄ¿µÄȫվͳ¼Æ  ¸öÈËͳ¼ÆÇëÇóÏûÏ¢
		List<ExerciseItemAnswerData> lstAnswers= answerResult.getItems();
		if(!lstAnswers.isEmpty()){
			exerciseVerService.sendUpdateExerItemStatisticsMsg(answerResult.getExerciseGroupId(), answerResult);
		}
		
		result.setData(resultMap);
		result.setResult(true);
			
		return result;
	}
	
	/**
	 * ³õʼ»¯´íÌâͳ¼ÆÊý¾Ý
	 */
	@SuppressWarnings("unchecked")
	@Override
	public Result doInitFaultStatisData() {
		log.info("---------------¶¨Ê±Æ÷ ¿ªÊ¼Í³¼Æ×öÌâ´íÌâͳ¼ÆÐÅÏ¢-----------start ------------------");
		// 1.¼ÆËãÇ°Ò»Ìì ¶ÔÓ¦×öÌâÈ˵Ä×öÌâÐÅÏ¢
		String sql = "SELECT"
				+ " 	r.CLASS_ID,"
				+ " 	t.USER_ID,"
				+ " 	count(1) doCount,"
				+ " 	sum(t.CORRECT = 0) faultCount,"
				+ " 	r.ORG_ID,"
				+ " 	r.COLLEGE_COURSE_ID,"
				+ " 	r.SUBJECT_ID,"
				+ " 	r.UPDATE_TIME"
				+ " FROM"
				+ " 	exercise_item_answer_u t,"
				+ " 	exercise_record r"
				+ " WHERE"
				+ " 	t.EXERCISE_RECORD_ID = r.RECORD_ID"
				+ " AND t.UPDATE_TIME < ?"
				+ " AND t.DELETE_FLAG = 0"
				+ " AND r.DELETE_FLAG = 0"
				+ " GROUP BY"
				+ " 	r.CLASS_ID,"
				+ " 	t.USER_ID,"
				+ " 	r.UPDATE_TIME";
		
		String yesterday = DateUtils.getTheDay(-1);
		List<Object[]> resultlst = this.findBySql(sql, CollectionUtils.newList(yesterday));
		
		
		// 2.´íÌâÐÅÏ¢¼Ç¼±í
		List<ExerciseFaultStatistics> statisLst = new ArrayList<ExerciseFaultStatistics>(resultlst.size());
		ExerciseFaultStatistics faultStatis = null;
		for(Object[] objs:resultlst){
			faultStatis = new ExerciseFaultStatistics();
			
			faultStatis.setClassId(String.valueOf(objs[0]));
			faultStatis.setUserId(String.valueOf(objs[1]));
			faultStatis.setDoCount(new BigInteger(String.valueOf(objs[2])));
			faultStatis.setFaultCount(new BigInteger(String.valueOf(objs[3])));
			faultStatis.setFaultRate( ExerciseUtils.parseStrToBigDecimal(String.valueOf(objs[3]), String.valueOf(objs[2])));
			faultStatis.setOrgId(String.valueOf(objs[4]));
			faultStatis.setCollegeCourseId(String.valueOf(objs[5]));
			faultStatis.setSubjectId(String.valueOf(objs[6]));
			faultStatis.setExerciseTime((Date)(objs[7]));
			
			TraceUtils.setCreateTrace(faultStatis);
			statisLst.add(faultStatis);
		}
		
		this.saveOrUpdateAll(statisLst);
		
		log.info("---------------¶¨Ê±Æ÷ ¿ªÊ¼Í³¼Æ×öÌâ´íÌâͳ¼ÆÐÅÏ¢-----------end ------------------");
		return new Result(true, "²Ù×÷³É¹¦,ͳ¼Æ¼Ç¼×ÜÌõÊý£º"+statisLst.size());
	}

	@Override
	public Result doUpdateExerciseDataSubmitLog(String exerciseDataLogId,
			String exerBussinessId) {
		return exerciseVerService.doUpdateExerciseDataSubmitLog(exerciseDataLogId, exerBussinessId);
	}

	/** -----------------------APP----V2.0--end---------------------------------------- */
	
	/*@SuppressWarnings("unchecked")
	@Override
	public Result doInitExerRecentRecord() {
		
		String sql = " select r.RECORD_ID,"
				+"  r.EXERCISE_GROUP_ID,"
				+"  r.CLASS_ID,"
				+"  r.USER_ID,"
				+"  r.COLLEGE_COURSE_ID,"
				+"  r.ORG_ID,"
				+"  r.SUBJECT_ID,"
				+"  r.CREATE_TIME,"
				+"  r.CREATE_ID,"
				+"  r.CREATOR,"
				+"  r.UPDATE_ID,"
				+"  r.UPDATE_TIME,"
				+"  r.UPDATOR"
				+"  from exercise_record r, "
				+" ("
				+" select max(UPDATE_TIME) uptime,t.USER_ID,t.EXERCISE_GROUP_ID "
				+" from exercise_record t "
				+" group by t.USER_ID,t.EXERCISE_GROUP_ID) tmp"
				+" where r.EXERCISE_GROUP_ID=tmp.EXERCISE_GROUP_ID "
				+" and r.USER_ID=tmp.USER_ID "
				+" and r.UPDATE_TIME=tmp.uptime"
				+" and not EXISTS"
				+" (select 1 from exercise_recent_record re"
				+" where re.EXERCISE_RECORD_ID=r.RECORD_ID)";
		
		List<Object[]> lstData =this.findBySql(sql, new ArrayList<Object>());
		
		if(lstData.isEmpty()){
			return new Result(false,"×î½ü×öÌâ¼Ç¼Êý¾ÝΪ¿Õ");
		}
		
		List<ExerciseRecentRecord> lstRecord = new ArrayList<ExerciseRecentRecord>(lstData.size());
		ExerciseRecentRecord record=null;
		for(Object[] objs:lstData){
			record = new ExerciseRecentRecord();
			record.setExerciseRecordId(String.valueOf(objs[0]));
			record.setExerciseGroupId(String.valueOf(objs[1]));
			record.setClassId(objs[2]==null?null:String.valueOf(objs[2]));
			record.setUserId(String.valueOf(objs[3]));
			record.setCollegeCourseId(objs[4]==null?null:String.valueOf(objs[4]));
			record.setOrgId(objs[5]==null?null:String.valueOf(objs[5]));
			record.setSubjectId(objs[6]==null?null:String.valueOf(objs[6]));
			record.setCreateTime((Date)(objs[7]));
			record.setCreateId(String.valueOf(objs[8]));
			record.setCreator(String.valueOf(objs[9]));
			record.setDeleteFlag(false);
			TraceUtils.setUpdateTrace(record);
			
			lstRecord.add(record);
		}
		
		this.saveOrUpdateAll(lstRecord);
		
		return new Result(true,"´Ë´Î²åÈëExerciseRecentRecordÌõÊý£º"+lstRecord.size());
	}

	@SuppressWarnings({ "unchecked" })
	@Override
	public Result doInitFaultRecord() {
		String sql = "select b.USER_ID,re.EXERCISE_GROUP_ID,g.TYPE,g.ALL_COUNT,count(1),b.RESUME_BOOK_ID,b.TITLE_MAX_NUMBER,"
		+" (select count(1) from exercise_fault t where t.EXERCISE_FAULT_ID=f.EXERCISE_FAULT_ID and t.CORRECT=1 ) correctCount,"
		+" (select count(1) from exercise_fault t where t.EXERCISE_FAULT_ID=f.EXERCISE_FAULT_ID and t.answer is not null ) doCount,"
		+ " b.UPDATE_ID,b.UPDATE_TIME,b.UPDATOR,b.CREATE_ID,b.CREATE_TIME,b.CREATOR"
		+" from exercise_fault f,exercise_group_item_re re,exercise_fault_book b,exercise_group g"
		+" where f.EXERCISE_ITEM_ID =re.EXERCISE_ITEM_ID"
		+" and f.RESUME_BOOK_ID=b.RESUME_BOOK_ID"
		+" and re.EXERCISE_GROUP_ID=g.GROUP_ID"
		+" and (f.FAULT_RECORD_ID is null or f.FAULT_RECORD_ID='') "
		+" group by b.USER_ID,re.EXERCISE_GROUP_ID";

		List<Object[]> lstData =this.findBySql(sql, new ArrayList<Object>());
		
		if(lstData.isEmpty()){
			return new Result(false,"´íÌâÊý¾ÝΪ¿Õ,±¾´ÎûÓÐÐèÒª¸üеĴíÌâÊý¾Ý");
		}
		
		
		String hql_existRecord = "from ExerciseFaultRecord where  resumeBookId=? and exerciseGroupId=? ";
		
		List<ExerciseFaultRecord> lstRecord = new ArrayList<ExerciseFaultRecord>(lstData.size());
		ExerciseFaultRecord record=null;
		BigInteger allCount;
		for(Object[] objs:lstData){
			if(!this.find(hql_existRecord, 
					CollectionUtils.newList(String.valueOf(objs[5]),String.valueOf(objs[1])), ExerciseFaultRecord.class).isEmpty()){
				continue;
			}
			
			record = new ExerciseFaultRecord();
			
			allCount = (BigInteger)objs[4];
			
			if(allCount.compareTo(BigInteger.ZERO) == 0){
				continue;
			}
			record.setResumeBookId(String.valueOf(objs[5]));
			record.setExerciseGroupId(String.valueOf(objs[1]));
			record.setExerciseGroupType((short)objs[2]);
			
			record.setAllCount(allCount);
			record.setDoCount(new BigInteger(String.valueOf(objs[8]==null ? 0 :objs[8])));
			record.setCorrectCount(new BigInteger(String.valueOf(objs[7]==null ? 0 :objs[7])));
			record.setCompletionRate(new BigDecimal(CommonUtils.formatDecimalFormat(
					record.getDoCount().doubleValue()/allCount.doubleValue()*100,
					CommonUtils.PARTEN_TWO)));
			
			record.setAccuracy(new BigDecimal(CommonUtils.formatDecimalFormat(
					record.getCorrectCount().doubleValue()/allCount.doubleValue()*100,
					CommonUtils.PARTEN_TWO)));
			record.setScore(record.getAccuracy());
			record.setStatus("0");
			record.setTitleMaxNumber(objs[6]==null?null:String.valueOf(objs[6]));
			if(StringUtils.isNotBlank(record.getTitleMaxNumber()) && 
							new BigInteger(record.getTitleMaxNumber()).compareTo(record.getAllCount())>0){
				record.setTitleMaxNumber(String.valueOf(record.getAllCount()));
			}
			record.setCreateId(String.valueOf(objs[12]));
			record.setCreateTime((Date)(objs[13]));
			record.setCreator(String.valueOf(objs[14]));
			TraceUtils.setUpdateTrace(record);
			
			lstRecord.add(record);
		}
		
		this.saveOrUpdateAll(lstRecord);
		
		return new Result(true, "²åÈëExerciseFaultRecordÌõÊý£º"+lstRecord.size());
	}

	@SuppressWarnings("unchecked")
	@Override
	public Result doInitFavorRecord() {
		
		String sql = " select b.USER_ID,re.EXERCISE_GROUP_ID,g.TYPE,g.ALL_COUNT,count(1),b.FAVORITE_BOOK_ID,b.TITLE_MAX_NUMBER,"
				+" (select count(1) from exercise_favorite t where t.EXERCISE_FAVORITE_ID=f.EXERCISE_FAVORITE_ID and t.CORRECT=1 ) correctCount,"
				+" (select count(1) from exercise_favorite t where t.EXERCISE_FAVORITE_ID=f.EXERCISE_FAVORITE_ID and t.answer is not null ) doCount,"
				+" +  b.UPDATE_ID,b.UPDATE_TIME,b.UPDATOR,b.CREATE_ID,b.CREATE_TIME,b.CREATOR"
				+" from exercise_favorite f,exercise_group_item_re re,exercise_favorite_book b,exercise_group g"
				+" where f.EXERCISE_ITEM_ID =re.EXERCISE_ITEM_ID"
				+" and f.FAVORITE_BOOK_ID=b.FAVORITE_BOOK_ID"
				+" and re.EXERCISE_GROUP_ID=g.GROUP_ID"
				+" and (f.FAVORITE_RECORD_ID is null or f.FAVORITE_RECORD_ID = '')"
				+" group by b.USER_ID,re.EXERCISE_GROUP_ID";

				List<Object[]> lstData =this.findBySql(sql, new ArrayList<Object>());
				
				if(lstData.isEmpty()){
					return new Result(false,"ÊÕ²ØÊý¾ÝΪ¿Õ,±¾´ÎûÓÐÐèÒª¸üеÄÊÕ²ØÊý¾Ý");
				}
				
				String hql_existRecord = "from ExerciseFavoriteRecord where  favoriteBookId=? and exerciseGroupId=? ";
				
				List<ExerciseFavoriteRecord> lstRecord = new ArrayList<ExerciseFavoriteRecord>(lstData.size());
				ExerciseFavoriteRecord record=null;
				BigInteger allCount;
				for(Object[] objs:lstData){
					if(!this.find(hql_existRecord, 
							CollectionUtils.newList(String.valueOf(objs[5]),String.valueOf(objs[1])), ExerciseFavoriteRecord.class).isEmpty()){
						continue;
					}
					
					record = new ExerciseFavoriteRecord();
					
					allCount = (BigInteger)objs[4];
					
					if(allCount.compareTo(BigInteger.ZERO) == 0){
						continue;
					}
					record.setFavoriteBookId(String.valueOf(objs[5]));
					record.setExerciseGroupId(String.valueOf(objs[1]));
					record.setExerciseGroupType((short)objs[2]);
					
					record.setAllCount(allCount);
					record.setDoCount(new BigInteger(String.valueOf(objs[8]==null ? 0 :objs[8])));
					record.setCorrectCount(new BigInteger(String.valueOf(objs[7]==null ? 0 :objs[7])));
					record.setCompletionRate(new BigDecimal(CommonUtils.formatDecimalFormat(
							record.getDoCount().doubleValue()/allCount.doubleValue()*100,
							CommonUtils.PARTEN_TWO)));
					
					record.setAccuracy(new BigDecimal(CommonUtils.formatDecimalFormat(
							record.getCorrectCount().doubleValue()/allCount.doubleValue()*100,
							CommonUtils.PARTEN_TWO)));
					record.setScore(record.getAccuracy());
					record.setStatus("0");
					record.setTitleMaxNumber(objs[6]==null?null:String.valueOf(objs[6]));
					if(record.getTitleMaxNumber() != null && 
							new BigInteger(record.getTitleMaxNumber()).compareTo(record.getAllCount())>0){
						record.setTitleMaxNumber(String.valueOf(record.getAllCount()));
					}
					record.setCreateId(String.valueOf(objs[12]));
					record.setCreateTime((Date)(objs[13]));
					record.setCreator(String.valueOf(objs[14]));
					TraceUtils.setUpdateTrace(record);
					
					lstRecord.add(record);
				}
				
				this.saveOrUpdateAll(lstRecord);
				
				
				return new Result(true,"²åÈëExerciseFavoriteRecordÌõÊý£º"+lstRecord.size());
	}

	@Override
	public Result doInitFaultItem() {
		// 2.
		String sql2="select f,re.exerciseGroupId"
				+" from ExerciseFault f,ExerciseGroupItemRe re"
				+" where f.exerciseItemId=re.exerciseItemId"
				+" and (f.faultRecordId is null or f.faultRecordId='') order by f.exerciseFaultId";
		
		List<Object[]> lstData2 =this.findwithRawResult(sql2, new ArrayList<Object>());
		
		if(lstData2.isEmpty()){//Å×Òì³£»Ø¹ö
			return new Result(false,"´íÌâÊý¾ÝΪ¿Õ2222");
		}
		
		String hql_existRecord = "from ExerciseFaultRecord where  resumeBookId=? and exerciseGroupId=? ";
		List<ExerciseFault> lstFaults = new ArrayList<ExerciseFault>(lstData2.size());
		ExerciseFault fault=null;
		ExerciseFault newFault=null;
		String exerciseFaultId="";
		List<ExerciseFaultRecord> lstRecord = null;
		for(Object[] objs:lstData2){
			fault = (ExerciseFault)objs[0];
			if(fault.getExerciseFaultId().equals(exerciseFaultId)){
				newFault = new ExerciseFault();
				BeanUtils.copyProperties(fault, newFault);
				newFault.setExerciseFaultId(null);
				
				lstRecord = this.find(hql_existRecord, CollectionUtils.newList(newFault.getResumeBookId(),String.valueOf(objs[1])), ExerciseFaultRecord.class);
				if(lstRecord.isEmpty()){
					continue;
				}
				
				newFault.setFaultRecordId(lstRecord.get(0).getFaultRecordId());
				TraceUtils.setUpdateTrace(newFault);
				lstFaults.add(newFault);
			}else{
				lstRecord = this.find(hql_existRecord, CollectionUtils.newList(fault.getResumeBookId(),String.valueOf(objs[1])), ExerciseFaultRecord.class);
				if(lstRecord.isEmpty()){
					continue;
				}
				
				fault.setFaultRecordId(lstRecord.get(0).getFaultRecordId());
				TraceUtils.setUpdateTrace(fault);
				lstFaults.add(fault);
			}
			
			exerciseFaultId=fault.getExerciseFaultId();
		}
		
		this.saveOrUpdateAll(lstFaults);
		
		return new Result(true, "¸üÐÂExerciseFaultÌõÊý£º"+lstFaults.size());
	}

	@Override
	public Result doInitFavorItem() {
		// 2.
		String sql2="select f,re.exerciseGroupId"
				+" from ExerciseFavorite f,ExerciseGroupItemRe re"
				+" where f.exerciseItemId=re.exerciseItemId"
				+" and (f.favoriteRecordId is null or f.favoriteRecordId = '') order by f.exerciseFavoriteId";
		
		List<Object[]> lstData2 =this.findwithRawResult(sql2, new ArrayList<Object>());
		
		if(lstData2.isEmpty()){//Å×Òì³£»Ø¹ö
			return new Result(false,"ÊÕ²ØÊý¾ÝΪ¿Õ2222");
		}
		
		String hql_existRecord = "from ExerciseFavoriteRecord where  favoriteBookId=? and exerciseGroupId=? ";
		List<ExerciseFavoriteRecord> lstRecord = null;
		List<ExerciseFavorite> lstFavors = new ArrayList<ExerciseFavorite>(lstData2.size());
		ExerciseFavorite favor=null;
		ExerciseFavorite newFavor=null;
		String exerciseFavoriteId="";
		for(Object[] objs:lstData2){
			favor = (ExerciseFavorite)objs[0];
			if(favor.getExerciseFavoriteId().equals(exerciseFavoriteId)){
				
				newFavor = new ExerciseFavorite();
				BeanUtils.copyProperties(favor, newFavor);
				newFavor.setExerciseFavoriteId(null);
				
				lstRecord = this.find(hql_existRecord, CollectionUtils.newList(newFavor.getFavoriteBookId(),String.valueOf(objs[1])), ExerciseFavoriteRecord.class);
				if(lstRecord.isEmpty()){
					continue;
				}
				
				newFavor.setFavoriteRecordId(lstRecord.get(0).getFavoriteRecordId());
				TraceUtils.setUpdateTrace(newFavor);
				lstFavors.add(newFavor);
			}else{
				lstRecord = this.find(hql_existRecord, CollectionUtils.newList(favor.getFavoriteBookId(),String.valueOf(objs[1])), ExerciseFavoriteRecord.class);
				if(lstRecord.isEmpty()){
					continue;
				}
				
				favor.setFavoriteRecordId(lstRecord.get(0).getFavoriteRecordId());
				TraceUtils.setUpdateTrace(favor);
				lstFavors.add(favor);
			}
			
			exerciseFavoriteId = favor.getExerciseFavoriteId();
		}
		
		this.saveOrUpdateAll(lstFavors);
		
		return new Result(true,"|¸üÐÂExerciseFavoriteÌõÊý£º"+lstFavors.size());
	}

	@Override
	public Result doSavetoDB(Object obj) {
		this.save(obj);
		return new Result(true);
	}*/
}