package com.qxueyou.scc.exam.service.impl;
|
|
import java.math.BigDecimal;
|
import java.math.BigInteger;
|
import java.util.*;
|
|
import com.qxueyou.scc.base.util.*;
|
import com.qxueyou.scc.exam.model.*;
|
import com.qxueyou.scc.exam.service.IExamBatchService;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.data.redis.core.StringRedisTemplate;
|
import org.springframework.scheduling.annotation.Scheduled;
|
import org.springframework.stereotype.Service;
|
|
import com.qxueyou.scc.base.model.Pager;
|
import com.qxueyou.scc.base.model.Result;
|
import com.qxueyou.scc.base.service.ICacheService;
|
import com.qxueyou.scc.base.service.impl.CommonAppService;
|
import com.qxueyou.scc.exam.service.IExamPaperService;
|
import com.qxueyou.scc.exam.service.IExamService;
|
import com.qxueyou.scc.exercise.model.ExerciseExamReGroup;
|
import com.qxueyou.scc.exercise.model.ExerciseGroup;
|
import com.qxueyou.scc.exercise.model.ExerciseItem;
|
import com.qxueyou.scc.exercise.model.ExerciseItemSet;
|
import com.qxueyou.scc.exercise.model.ExerciseRecord;
|
import com.qxueyou.scc.exercise.service.IExerciseGroupService;
|
import com.qxueyou.scc.exercise.service.IExerciseVerService;
|
import com.qxueyou.scc.msg.model.MsgInfo;
|
import com.qxueyou.scc.msg.service.IMsgInfoService;
|
|
/**
|
* ¿¼ÊÔ¹ÜÀí·þÎñ²ã
|
*
|
* @author kevin
|
* @createTime 2017-11-1
|
*/
|
@Service
|
public class ExamService extends CommonAppService implements IExamService {
|
@Autowired
|
ICacheService cacheService;
|
|
@Autowired
|
IExerciseVerService exerciseVerService;
|
|
@Autowired
|
IExamPaperService examPaperService;
|
|
@Autowired
|
IExerciseGroupService exerciseGroupService;
|
|
@Autowired
|
private StringRedisTemplate stringRedisTemplate;
|
|
@Autowired
|
IMsgInfoService msgInfoService;
|
|
@Autowired
|
IExamBatchService examBatchService;
|
|
@Override
|
public List<ExamInfo> list(String keyword,String classId,String subjectId,Short status, Integer pageSize,Integer pageNum) {
|
StringBuffer hql = new StringBuffer(500);
|
hql.append("from ExamInfo e where e.examName like ? and e.createId=? ");
|
List<Object> params = CollectionUtils.newList('%' + keyword.trim() + '%',ClientUtils.getUserId());
|
|
if(status!=null){
|
hql.append(" and e.examStatus = ? ");
|
params.add(status);
|
}
|
|
if(StringUtils.isNotEmpty(classId)){
|
hql.append(" and exists( select 1 from ExamBatchClassRe r where e.examId = r.examId and r.deleteFlag is false and r.classId=?) ");
|
params.add(classId);
|
}
|
|
if(StringUtils.isNotEmpty(subjectId)){
|
hql.append(" and e.subjectId = ? ");
|
params.add(subjectId);
|
}
|
|
hql.append(" and e.deleteFlag is false order by e.createTime desc");
|
return findList(hql.toString(),new Pager(pageSize, pageNum),params, ExamInfo.class);
|
}
|
|
@Override
|
public int listCount(String keyword,String classId,String subjectId,Short status) {
|
StringBuffer hql = new StringBuffer(500);
|
hql.append("from ExamInfo e where e.examName like ? and e.createId=? ");
|
List<Object> params = CollectionUtils.newList('%' + keyword.trim() + '%',ClientUtils.getUserId());
|
|
if(status!=null){
|
hql.append(" and e.examStatus = ? ");
|
params.add(status);
|
}
|
|
if(StringUtils.isNotEmpty(classId)){
|
hql.append(" and exists( select 1 from ExamBatchClassRe r where e.examId = r.examId and r.deleteFlag is false and r.classId=?) ");
|
params.add(classId);
|
}
|
|
|
if(StringUtils.isNotEmpty(subjectId)){
|
hql.append(" and e.subjectId = ? ");
|
params.add(subjectId);
|
}
|
|
hql.append(" and e.deleteFlag is false");
|
return findCount(hql.toString(),params);
|
}
|
|
@Override
|
public List<ExamResultV> listResult(String examId,String[] examBatchIds, String classId,String keyword, Integer pageSize, Integer pageNum) {
|
StringBuffer hql = new StringBuffer(1000);
|
hql.append("from ExamResultV v where v.studentName like :studentName");
|
|
Map<String,Object> params = CollectionUtils.newObjectMap("studentName", '%' + keyword.trim() + '%');
|
|
if(!StringUtils.isEmpty(examId)){
|
hql.append(" and v.examId=:examId");
|
params.put("examId", examId);
|
}
|
|
if(examBatchIds!=null && examBatchIds.length>0){
|
hql.append(" and v.id.examBatchId in (:examBatchIds)");
|
params.put("examBatchIds", examBatchIds);
|
}
|
|
if(!StringUtils.isEmpty(classId)){
|
hql.append(" and v.id.classId=:classId");
|
params.put("classId", classId);
|
}
|
|
hql.append(" order by v.id.examBatchId,v.score desc");
|
|
return this.findByComplexHql(hql.toString(), new Pager(pageSize,pageNum), params, ExamResultV.class);
|
}
|
|
@Override
|
public int listResultCount(String examId,String[] examBatchIds,String classId,String keyword) {
|
StringBuffer hql = new StringBuffer(1000);
|
hql.append("from ExamResultV v where v.studentName like :studentName");
|
|
Map<String,Object> params = CollectionUtils.newObjectMap("studentName", '%' + keyword.trim() + '%');
|
|
if(!StringUtils.isEmpty(examId)){
|
hql.append(" and v.examId=:examId");
|
params.put("examId", examId);
|
}
|
|
if(examBatchIds!=null && examBatchIds.length>0){
|
hql.append(" and v.id.examBatchId in (:examBatchIds)");
|
params.put("examBatchIds", examBatchIds);
|
}
|
|
if(!StringUtils.isEmpty(classId)){
|
hql.append(" and v.id.classId=:classId");
|
params.put("classId", classId);
|
}
|
|
return this.findCountByComplexHql(hql.toString(),params);
|
}
|
|
@Override
|
public List<ExamResultV> listStudentExam(String keyword, String [] classIds, String subjectId, Integer status, Integer pageSize, Integer pageNum,String userId) {
|
StringBuffer hql = new StringBuffer(1000);
|
hql.append("from ExamResultV v where v.examName like :examName and v.examStatus=:examStatus and v.userId=:userId and v.id.classId in (:classIds) ");
|
|
Map<String,Object> params = CollectionUtils.newObjectMap("examName", keyword.trim()+'%',"examStatus",ExamInfo.STATUS_PUBLISH,"userId",userId,"classIds",classIds);
|
if(!StringUtils.isEmpty(subjectId)){
|
hql.append(" and v.subjectId=:subjectId ");
|
|
params.put("subjectId", subjectId);
|
}
|
|
//¸ù¾Ý״̬²éѯ£º1δ¿ªÊ¼£¬2δ½»¾í£¬3Òѽ»¾í£¬4ÓâÆÚδ½»,5ÒÑÅúÔÄ
|
if(status != null) {
|
switch(status){
|
case 1:hql.append(" and v.status is null") ;break;
|
case 2:hql.append(" and v.status = :status");params.put("status", ExerciseRecord.STATUS_SUBMIT);break;
|
case 3:hql.append(" and v.status = :status");params.put("status", ExerciseRecord.STATUS_NOT_SUBMIT);break;
|
case 4:hql.append(" and (v.status is null or v.status=0) and v.end_Time < sysdate() ");break;
|
case 5:hql.append(" and v.status = :status");params.put("status", ExerciseRecord.STATUS_CHECK);break;
|
default:break;
|
}
|
}
|
|
hql.append(" order by v.startTime desc ");
|
return this.findByComplexHql(hql.toString(),new Pager(pageSize,pageNum),params,ExamResultV.class);
|
}
|
|
@Override
|
public List<ExamResultV> studentExam(String[] classIds) {
|
StringBuffer hql = new StringBuffer(1000);
|
hql.append("from ExamResultV v where v.examStatus=:examStatus and v.userId=:userId and v.id.classId in (:classIds)");
|
|
Map<String,Object> params = CollectionUtils.newObjectMap
|
("examStatus",ExamInfo.STATUS_PUBLISH,"userId",ClientUtils.getUserId(),"classIds",classIds);
|
|
hql.append(" order by v.endTime desc ");
|
return this.findByComplexHql(hql.toString(),params,ExamResultV.class);
|
}
|
|
@Override
|
public int listStudentExamCount(String keyword,String [] classIds,String subjectId,Integer status) {
|
StringBuffer hql = new StringBuffer(1000);
|
hql.append("from ExamResultV v where v.examName like :examName and v.examStatus=:examStatus and v.userId=:userId and v.id.classId in (:classIds)");
|
Map<String,Object> params = CollectionUtils.newObjectMap("examName", keyword.trim() + '%',"examStatus",ExamInfo.STATUS_PUBLISH,
|
"userId",ClientUtils.getUserId(),"classIds",classIds);
|
|
if(!StringUtils.isEmpty(subjectId)){
|
hql.append(" and v.subjectId=:subjectId ");
|
params.put("subjectId", subjectId);
|
}
|
|
//¸ù¾Ý״̬²éѯ£º1δ¿ªÊ¼£¬2δ½»¾í£¬3Òѽ»¾í£¬4ÓâÆÚδ½»,5ÒÑÅúÔÄ
|
if(status != null) {
|
switch(status){
|
case 1:hql.append(" and v.status is null") ;break;
|
case 2:hql.append(" and v.status = :status");params.put("status", ExerciseRecord.STATUS_SUBMIT);break;
|
case 3:hql.append(" and v.status = :status");params.put("status", ExerciseRecord.STATUS_NOT_SUBMIT);break;
|
case 4:hql.append(" and (v.status is null or v.status=0) and v.end_Time < sysdate() ");break;
|
case 5:hql.append(" and v.status = :status");params.put("status", ExerciseRecord.STATUS_CHECK);break;
|
default:break;
|
}
|
}
|
return this.findCountByComplexHql(hql.toString(),params);
|
}
|
|
@Override
|
public void addRemedy(String examId,Date startTime,Date endTime) {
|
//¸ù¾Ý¿¼ÊÔID»ñÈ¡¿¼ÊÔÐÅÏ¢
|
ExamInfo examInfo = queryExamDetail(examId);
|
//¸ù¾Ý¿¼ÊÔID»ñÈ¡¶ÔÓ¦µÄÅú´ÎÐÅÏ¢
|
String hql = "from ExamBatchInfo where examId=? and deleteFlag is false";
|
List<ExamBatchInfo> list = this.find(hql, CollectionUtils.newList(examId), ExamBatchInfo.class);
|
List<ExamBatchInfo> remedylist = new ArrayList<>(list.size());
|
//¸ù¾Ý¿¼ÊÔID»ñÈ¡¶ÔÓ¦µÄÌâÄ¿ÉèÖÃ
|
List<ExerciseItemSet> exerciseItemSets = queryExerciseItemSet(examId);
|
List<ExerciseItemSet> exerciseItemSetses = new ArrayList<>(exerciseItemSets.size());
|
//...
|
List<ExamReExamPaper> reExamPapers = examInfo.getReExamPapers();
|
List<ExamReExamPaper> reExamPaperses = new ArrayList<>(reExamPapers.size());
|
//¸´ÖÆÐÅÏ¢
|
ExamInfo examInfo1=new ExamInfo();
|
//ÖØÐÂÖ¸ÏòÒ»¸ö¶ÔÏ󲢸´ÖÆÊôÐÔ
|
BeanUtils.copyProperties(examInfo,examInfo1);
|
//ÉèÖÿ¼ÊÔÃû³Æ
|
examInfo1.setExamName(examInfo1.getExamName()+"(²¹¿¼"+new Date().getTime()+")");
|
//ÉèÖÃÐÂÖ¸ÏòÅú´Î¼¯ºÏ
|
examInfo1.setExamBatchInfos(remedylist);
|
examInfo1.setExerciseItemSets(exerciseItemSetses);
|
//ÉèÖÃÐÂÖ¸ÏòÊÔ¾í¼¯ºÏ
|
reExamPapers.forEach(reExamPaper -> reExamPaperses.add(reExamPaper));
|
examInfo1.setReExamPapers(reExamPaperses);
|
String examremedyId = addExam(examInfo1);
|
//ÉèÖÃÐÂÖ¸ÏòÌâÄ¿ÉèÖü¯ºÏ²¢¸´ÖÆÌí¼Ó
|
exerciseItemSets.forEach(exerciseItemSet -> {
|
ExerciseItemSet exerciseItemSet1 = new ExerciseItemSet();
|
BeanUtils.copyProperties(exerciseItemSet,exerciseItemSet1);
|
exerciseItemSet1.setExerciseInfoId(examremedyId);
|
TraceUtils.setCreateTrace(exerciseItemSet1);
|
this.insert(exerciseItemSet1);
|
exerciseItemSetses.add(exerciseItemSet1);
|
});
|
//¸ù¾Ý¿¼ÊÔID»ñÈ¡Ìâ¿â¹ØÁªÐÅÏ¢
|
String ql = "from ExerciseExamReGroup where examId=? and deleteFlag is false";
|
List<ExerciseExamReGroup> exerciseExamReGroups = this.find(ql, CollectionUtils.newList(examId), ExerciseExamReGroup.class);
|
exerciseExamReGroups.forEach(exerciseExamReGroup -> {
|
ExerciseExamReGroup exerciseExamReGroup1 = new ExerciseExamReGroup();
|
BeanUtils.copyProperties(exerciseExamReGroup,exerciseExamReGroup1);
|
//ÉèÖÿ¼ÊÔID±£´æÐÅÏ¢
|
exerciseExamReGroup1.setExamId(examremedyId);
|
TraceUtils.setCreateTrace(exerciseExamReGroup1);
|
this.insert(exerciseExamReGroup1);
|
});
|
//Ñ»·¸´ÖÆÅú´Î
|
for (ExamBatchInfo examBatchInfo : list) {
|
String remedyExamBatchId = UUIDUtils.generateSpecialUuid(32);
|
List<ExamBatchClassRe> reClasses = examBatchInfo.getReClasses();
|
List<ExamBatchClassRe> examBatchClassRes = new ArrayList<>();
|
reClasses.forEach(reClass -> {
|
//н¨bean
|
ExamBatchClassRe examBatchClassRe = new ExamBatchClassRe();
|
//¸´ÖÆÊôÐÔ
|
BeanUtils.copyProperties(reClass,examBatchClassRe);
|
//Ð޸Ŀ¼ÊÔIDÒÔ¼°Åú´ÎID
|
examBatchClassRe.setExamId(examremedyId);
|
examBatchClassRe.setExamBatchId(remedyExamBatchId);
|
examBatchClassRe.setExamClassReId(UUIDUtils.generateSpecialUuid(32));
|
examBatchClassRes.add(examBatchClassRe);
|
});
|
ExamBatchInfo examBatchInfo1 = new ExamBatchInfo();
|
BeanUtils.copyProperties(examBatchInfo,examBatchInfo1);
|
//ÉèÖÃÅú´Î¿¼ÊÔIDΪ²¹¿¼µÄID
|
examBatchInfo1.setExamId(examremedyId);
|
//ÉèÖÿªÊ¼½áÊøʱ¼ä
|
examBatchInfo1.setStartTime(startTime);
|
examBatchInfo1.setEndTime(endTime);
|
examBatchInfo1.setExamBatchId(remedyExamBatchId);
|
examBatchInfo1.setReClasses(examBatchClassRes);
|
//Ìí¼ÓÅú´Î
|
examBatchService.addExamBatch(examBatchInfo1);
|
remedylist.add(examBatchInfo1);
|
}
|
}
|
|
@Override
|
public String addExam(ExamInfo examInfo) {
|
TraceUtils.setCreateTrace(examInfo);
|
examInfo.setExamStatus(ExamInfo.STATUS_DRAFT);
|
this.insert(examInfo);
|
return examInfo.getExamId();
|
}
|
|
@Override
|
public Result deleteExam(String[] examIds) {
|
Result result = new Result(true);
|
if (examIds != null && examIds.length > 0) {
|
String hql = "update ExamInfo set deleteFlag = true where examId=?";
|
//ÅжÏIDÀïÊÇ·ñ°üº¬²¹¿¼¿¼ÊÔ
|
ExamInfo examInfo = queryReExam();
|
if (examInfo!=null) {
|
for (String examId : examIds) {
|
if (examId.equals(examInfo.getExamId())){
|
result.setSuccess(false);
|
result.setMsg("º¬Óв¹¿¼¿¼ÊÔ£¬²»¿Éɾ³ý");
|
return result;
|
}
|
}
|
}
|
result = bulkUpdateInLoop(hql, examIds);
|
}
|
return result;
|
}
|
|
@Override
|
public Result updateExam(ExamInfo param) {
|
ExamInfo examInfo = read(ExamInfo.class, param.getExamId());
|
|
if (examInfo == null) {
|
return new Result(false, "¿¼ÊÔ²»´æÔÚ");
|
}
|
|
TraceUtils.setUpdateTrace(examInfo);
|
examInfo.setExamName(param.getExamName());
|
examInfo.setSubjectId(param.getSubjectId());
|
examInfo.setDurationMin(param.getDurationMin());
|
// examInfo.setMaxLateMin(param.getMaxLateMin());
|
examInfo.setShowCorrectAnswer(param.getShowCorrectAnswer());
|
examInfo.setShowScore(param.getShowScore());
|
examInfo.setShowAnalyse(param.getShowAnalyse());
|
examInfo.setShowType(param.getShowType());
|
examInfo.setShowScoreTime(param.getShowScoreTime());
|
return save(examInfo);
|
}
|
|
@Override
|
public Result updateExamPaperInfo(ExamInfo param) {
|
ExamInfo examInfo = read(ExamInfo.class, param.getExamId());
|
if (examInfo != null) {
|
TraceUtils.setUpdateTrace(examInfo);
|
examInfo.setExamType(param.getExamType());
|
examInfo.setTotalScore(param.getTotalScore());
|
examInfo.setPassingScore(param.getPassingScore());
|
|
//Èç¹ûÊÇËæ»ú×é¾í
|
if(ExamInfo.EXAM_TYPE_RANDOM==examInfo.getExamType()||ExamInfo.EXAM_TYPE_RANDOM_BY_GROUP==examInfo.getExamType()){
|
// ɾ³ý֮ǰµÄExercise¹ØÁªµÄgroup
|
this.bulkUpdate("update ExerciseExamReGroup set deleteFlag = 1 where examId = ?",new Object[] { param.getExamId()});
|
|
List<ExerciseItemSet> lstExerciseItemSet = param.getExerciseItemSets();
|
|
// ±£´æÌâÄ¿ÀàÐÍ
|
if (lstExerciseItemSet != null && lstExerciseItemSet.size() > 0) {
|
// ɾ³ýÀúÊ·Êý¾Ý
|
this.bulkUpdate("update ExerciseItemSet set deleteFlag = 1 where deleteFlag is false and exerciseInfoId = ?",
|
new Object[] { param.getExamId()});
|
for (ExerciseItemSet itemSet : lstExerciseItemSet) {
|
TraceUtils.setCreateTrace(itemSet);
|
itemSet.setExerciseInfoId(param.getExamId());
|
this.save(itemSet);
|
}
|
}
|
|
//±£´æ¿¼ÊÔ£¬Ô´ÌâÄ¿×éÐÅÏ¢
|
String [] sourceGroupIds = param.getSourceGroupIds().split(",");
|
|
// ±£´æ¹ØÁªÁ·Ï°×é
|
if (sourceGroupIds != null && sourceGroupIds.length > 0) {
|
ExerciseExamReGroup reGroup = null;
|
for (String groupId : sourceGroupIds) {
|
reGroup = new ExerciseExamReGroup();
|
reGroup.setGroupId(groupId);
|
reGroup.setDeleteFlag(false);
|
reGroup.setType(ExerciseExamReGroup.GROUP_TYPE_SOURCE);
|
reGroup.setExamId(param.getExamId());
|
TraceUtils.setCreateTrace(reGroup);
|
this.save(reGroup);
|
}
|
}
|
|
}else{
|
// ɾ³ýÔÀ´µÄ¹ØÁª¹Øϵ
|
String hql = "update ExamReExamPaper set deleteFlag = true where examId=? ";
|
this.bulkUpdate(hql, new Object[] { param.getExamId() });
|
List<ExamReExamPaper> lstExamReExamPaper = param.getReExamPapers();
|
String[] arrPaperCode = new String[] { "A", "B", "C", "D" };
|
if (lstExamReExamPaper != null && lstExamReExamPaper.size() > 0) {
|
for (int i = 0; i < lstExamReExamPaper.size(); i++) {
|
TraceUtils.setCreateTrace(lstExamReExamPaper.get(i));
|
lstExamReExamPaper.get(i).setExamPaperId(lstExamReExamPaper.get(i).getExamPaperId());
|
lstExamReExamPaper.get(i).setExamId(param.getExamId());
|
lstExamReExamPaper.get(i).setRelationPaperCode(arrPaperCode[i]);
|
this.insert(lstExamReExamPaper.get(i));
|
}
|
}
|
}
|
}
|
return save(examInfo);
|
}
|
|
@Override
|
public Result doPublishExam(String[] examIds) {
|
Map<String, Object> pramMap = null;
|
if (examIds != null && examIds.length > 0) {
|
pramMap = new HashMap<String, Object>(1);
|
pramMap.put("examIds", examIds);
|
String hql = "from ExamInfo where examId in (:examIds)";
|
List<ExamInfo> lstExamInfo = this.findByComplexHql(hql, pramMap, ExamInfo.class);
|
|
for (ExamInfo examInfo : lstExamInfo) {
|
if (ExamInfo.STATUS_DRAFT != examInfo.getExamStatus()) {
|
return new Result(false, "Ö»Óвݸå״̬µÄ¿¼ÊÔ,²ÅÄÜ·¢²¼¡£");
|
}
|
examInfo.setExamStatus(ExamInfo.STATUS_PUBLISH);
|
TraceUtils.setUpdateTrace(examInfo);
|
|
save(examInfo);
|
|
this.doExamPublishMsg(examInfo.getExamId());
|
}
|
} else {
|
return new Result(false, "ûÓÐÑ¡ÔñÒª·¢²¼µÄ¿¼ÊÔ¡£");
|
}
|
return new Result(true);
|
}
|
|
|
private void doExamPublishMsg(String examId){
|
ExamInfo examInfo = this.read(ExamInfo.class, examId);
|
|
String hql = "select id.examBatchId as examBatchId,id.classId as classId,recordId as recordId ,userId as userId from ExamResultV where examId=:examId";
|
List<Map<String,Object>> lstInfo = this.findListWithMapByHql(hql,CollectionUtils.newObjectMap("examId",examId));
|
|
if(lstInfo!=null && lstInfo.size()>0){
|
for(Map<String,Object> temp:lstInfo){
|
Map<String,String> attrs = CollectionUtils.newStringMap("examId",examId,"examName",examInfo.getExamName(),
|
"subjectId",examInfo.getSubjectId(),"subjectName",examInfo.getSubject().getName(),
|
"examBatchId",(String)temp.get("examBatchId"),"classId",(String)temp.get("classId"),"recordId",(String)temp.get("recordId"));
|
msgInfoService.doSendTextMsgToUsers(new String[]{(String)temp.get("userId")},MsgInfo.TYPE_EXAM, "·¢²¼ÁË¿¼ÊÔ", attrs);
|
}
|
}
|
}
|
|
@Scheduled(cron = " 0 0/5 * * * ?")
|
protected void doTimer() {
|
// System.out.println("Ö´Ðп¼ÊÔÌáÐѶ¨Ê±Æ÷");
|
Calendar cal =Calendar.getInstance();
|
cal.add(Calendar.HOUR, 1);
|
Date beginDate = cal.getTime();
|
|
cal.add(Calendar.MINUTE, 5);
|
Date endDate = cal.getTime();
|
|
String hql = "select b.examBatchId from ExamBatchInfo b ,ExamInfo f where b.examId = f.examId "
|
+ " and b.startTime>=? and b.startTime<? and f.examStatus=? and f.deleteFlag is false and b.deleteFlag is false order by b.startTime desc";
|
|
//²éѯ1СʱÄÚ½«¿ªÊ¼µÄÖ±²¥
|
List<String> lstBatchIds = this.find(hql,CollectionUtils.newList(beginDate,endDate,ExamInfo.STATUS_PUBLISH), String.class);
|
|
if(lstBatchIds!=null && lstBatchIds.size()>0){
|
for(String batchId:lstBatchIds){
|
this.doExamRemindMsg(batchId,MsgInfo.TYPE_REMIND, "¿¼ÊÔÂíÉÏ¿ªÊ¼ÁË£¬Çë×öºÃ¿¼ÊÔ×¼±¸");
|
}
|
}
|
}
|
|
private void doExamRemindMsg(String batchId,short type,String msg){
|
ExamBatchInfo batchInfo = this.read(ExamBatchInfo.class, batchId);
|
ExamInfo examInfo = batchInfo.getExamInfo();
|
Map<String,String> attrs = CollectionUtils.newStringMap("examId",examInfo.getExamId(),"examName",examInfo.getExamName(),"remindType","exam",
|
"subjectId",examInfo.getSubjectId(),"subjectName",examInfo.getSubject().getName(),
|
"examBatchId",batchInfo.getExamBatchId(),"creator",batchInfo.getCreator(),
|
"startTime",String.valueOf(batchInfo.getStartTime().getTime()),
|
"endTime",String.valueOf(batchInfo.getEndTime().getTime()),
|
"examBatchNo",String.valueOf(batchInfo.getExamBatchNo()));
|
|
msgInfoService.doSendTextMsgToUsers(new String[]{batchInfo.getCreateId()},type, msg, attrs);
|
}
|
|
@Override
|
public Result doRevokeExam(String[] examIds) {
|
Map<String, Object> pramMap = null;
|
if (examIds != null && examIds.length > 0) {
|
pramMap = new HashMap<String, Object>(1);
|
pramMap.put("examIds", examIds);
|
String hql = "from ExamInfo where examId in (:examIds)";
|
List<ExamInfo> lstExamInfo = this.findByComplexHql(hql, pramMap, ExamInfo.class);
|
for (ExamInfo examInfo : lstExamInfo) {
|
if (ExamInfo.STATUS_PUBLISH != examInfo.getExamStatus()) {
|
return new Result(false, "Ö»Óз¢²¼×´Ì¬µÄ¿¼ÊÔ,²ÅÄܳ·»Ø");
|
}
|
examInfo.setExamStatus(ExamInfo.STATUS_DRAFT);
|
TraceUtils.setUpdateTrace(examInfo);
|
save(examInfo);
|
}
|
} else {
|
return new Result(false, "ûÓÐÑ¡ÔñÒª³·»ØµÄ¿¼ÊÔ");
|
}
|
return new Result(true);
|
}
|
|
@Override
|
public ExamInfo queryExamDetail(String examId) {
|
ExamInfo examInfo = this.read(ExamInfo.class, examId);
|
examInfo.setSubjectName(examInfo.getSubject().getName());
|
|
if(examInfo.getExamType() == ExamInfo.EXAM_TYPE_RANDOM || examInfo.getExamType() == ExamInfo.EXAM_TYPE_RANDOM_BY_GROUP){
|
List<ExerciseGroup> lstGroup = queryExamGroups(examId, ExerciseExamReGroup.GROUP_TYPE_SOURCE);
|
examInfo.setSourceGroupIds(StringUtils.join(QBeanUtils.listPropertyVal(lstGroup, "groupId"),","));
|
examInfo.setSourceGroupNames(StringUtils.join(QBeanUtils.listPropertyVal(lstGroup, "name"),","));
|
}
|
|
return examInfo;
|
}
|
@Override
|
public ExamInfo queryReExam() {
|
// ²éѯÊÇ·ñÓнøÐÐÖеĿ¼ÊÔ
|
ExamInfo examInfo = this.findUnique(
|
"from ExamInfo where maxLateMin=? and deleteFlag is false ",
|
CollectionUtils.newList((short)1),
|
ExamInfo.class);
|
|
return examInfo;
|
}
|
|
/**
|
* ¿ªÊ¼¿¼ÊÔ
|
*
|
* @param
|
* @return
|
*/
|
@Override
|
public Result doStartExam(String examBatchId, String classId, String studentUserId) {
|
ExamBatchInfo examBatchInfo = this.read(ExamBatchInfo.class, examBatchId);
|
ExamInfo examInfo = examBatchInfo.getExamInfo();
|
|
List<ExerciseItemSet> lstItemSets = queryExerciseItemSet(examBatchInfo.getExamId());
|
|
ExerciseRecord record = this.doInitExerciseRecord(examBatchInfo, lstItemSets, classId, studentUserId);
|
|
Map<String,Object> resultData = CollectionUtils.newObjectMap("exerciseRecordId", record.getRecordId(),"submitTime",record.getSubmitTime(),
|
//TODO
|
"remainingSeconds",record.getRemainingSeconds(),"itemSet", lstItemSets,"subjectName", examInfo.getSubject().getName());
|
|
// Èç¹ûÒÑÌá½»¾Í²éѯÓû§´ð°¸ÐÅÏ¢
|
//TODO ÔÝʱ²»¿ÉÒԲ鿴¿¼ÊԴ𰸣¬ÒÑÌá½»¾Í²»¿ÉÒÔ½øÈë
|
if (Integer.valueOf(record.getStatus())> 0) {
|
resultData.put("studentScore", record.getScore());
|
resultData.put("objStudentScore", record.getObjScore()==null?BigDecimal.ZERO:record.getObjScore());
|
return new Result(false,"¿¼ÊÔÒÑÌá½»");
|
}
|
//»ñÈ¡¿¼ÊÔ
|
String ql="select i from ExamInfo i , ExamBatchClassRe r where i.deleteFlag is false and r.examBatchId=? and r.examId=i.examId";
|
ExamInfo exam = this.findUnique(ql, CollectionUtils.newList(examBatchId), ExamInfo.class);
|
//Ìí¼Ó¿¼ÊÔ×Üʱ³¤
|
resultData.put("durationMin",exam.getDurationMin());
|
resultData.put("groupId", record.getExerciseGroupId());
|
resultData.put("totalScore", examInfo.getTotalScore());
|
resultData.put("accuracy", record.getAccuracy());
|
resultData.put("userAnswers", this.queryUserAnswers(record.getRecordId()));
|
resultData.put("paperInfo", this.getUserExamPaperInfo(record.getExerciseGroupId(),examInfo.getExamType(),(float)examInfo.getTotalScore(),lstItemSets));
|
return new Result(true,"",resultData);
|
}
|
/**
|
* ¿ªÊ¼²¹¿¼¿¼ÊÔ
|
*
|
* @param examId
|
* @return
|
*/
|
@Override
|
public Result doStartReExam(String examId,String studentUserId) {
|
ExamInfo examInfo = this.read(ExamInfo.class, examId);
|
|
List<ExerciseItemSet> lstItemSets = queryExerciseItemSet(examId);
|
|
ExerciseRecord record = this.doInitReExerciseRecord(examInfo, lstItemSets, studentUserId);
|
|
Map<String,Object> resultData = CollectionUtils.newObjectMap("exerciseRecordId", record.getRecordId(),"submitTime",record.getSubmitTime(),
|
//TODO
|
"remainingSeconds",record.getRemainingSeconds(),"itemSet", lstItemSets,"subjectName", examInfo.getSubject().getName());
|
//Ìí¼Ó¿¼ÊÔ×Üʱ³¤
|
resultData.put("durationMin",examInfo.getDurationMin());
|
resultData.put("groupId", record.getExerciseGroupId());
|
resultData.put("totalScore", examInfo.getTotalScore());
|
resultData.put("accuracy", record.getAccuracy());
|
resultData.put("userAnswers", this.queryUserAnswers(record.getRecordId()));
|
resultData.put("paperInfo", this.getUserExamPaperInfo(record.getExerciseGroupId(),examInfo.getExamType(),(float)examInfo.getTotalScore(),lstItemSets));
|
return new Result(true,"",resultData);
|
}
|
|
/**
|
* ÅжÏÊÇ·ñÊÇËæ»ú¿¼ÊÔ
|
* @param examType
|
* @return
|
*/
|
private boolean checkIsRandomExam(short examType){
|
return ExamInfo.EXAM_TYPE_RANDOM==examType || ExamInfo.EXAM_TYPE_RANDOM_BY_GROUP==examType;
|
}
|
|
/**
|
* »ñÈ¡¿¼ÊÔÊÔ¾íÐÅÏ¢
|
* @param examId
|
* @param groupId
|
* @param examType
|
* @param totalSocre
|
* @return
|
*/
|
private ExamPaperInfo getUserExamPaperInfo(String groupId,short examType,float totalSocre){
|
ExamPaperInfo examPaperInfo = null;
|
if(checkIsRandomExam(examType)){
|
examPaperInfo= new ExamPaperInfo();
|
examPaperInfo.setGroupId(groupId);
|
examPaperInfo.setTotalScore(new Float(totalSocre).shortValue());
|
examPaperInfo.setExerciseGroup(exerciseGroupService.queryExerciseGroupDetail(groupId));
|
List<ExamPaperSectionInfo> examPaperSectionInfos = new ArrayList<>();
|
examPaperInfo.setSectionInfos(examPaperSectionInfos);
|
}else{
|
examPaperInfo = examPaperService.queryExamPaperByGroupId(groupId);
|
examPaperInfo = examPaperService.queryExamPaperDetail(examPaperInfo.getExamPaperId());
|
}
|
return examPaperInfo;
|
}
|
|
/**
|
* ÊÖ¶¯Ìí¼ÓÌâĿλÖÃÐÅÏ¢
|
* @param groupId
|
* @param examType
|
* @param totalSocre
|
* @param lstItemSets
|
* @return
|
*/
|
private ExamPaperInfo getUserExamPaperInfo(String groupId,short examType,float totalSocre,List<ExerciseItemSet> lstItemSets){
|
ExamPaperInfo examPaperInfo = null;
|
if(checkIsRandomExam(examType)){
|
examPaperInfo= new ExamPaperInfo();
|
examPaperInfo.setGroupId(groupId);
|
//TODO
|
examPaperInfo.setPaperStatus(new Integer(1).shortValue());
|
examPaperInfo.setOrgId("1");
|
examPaperInfo.setTotalScore(new Float(totalSocre).shortValue());
|
examPaperInfo.setExerciseGroup(exerciseGroupService.queryExerciseGroupDetail(groupId));
|
List<ExamPaperSectionInfo> examPaperSectionInfos = new ArrayList<>();
|
int count=0;
|
for (int i=0;i<lstItemSets.size();i++) {
|
ExamPaperSectionInfo examPaperSectionInfo=new ExamPaperSectionInfo();
|
int itemCount = lstItemSets.get(i).getItemCount();
|
if (itemCount>0) {
|
examPaperSectionInfo.setGroupId(groupId);
|
//ÉèÖÿªÊ¼½áÊø
|
examPaperSectionInfo.setItemStartOrder((short)count);
|
//»ñÈ¡ÌâÄ¿ÉèÖõÄcount,Ï´ÎÑ»·ÓÃ
|
count+=itemCount;
|
examPaperSectionInfo.setItemEndOrder((short)count);
|
//Ãû³Æ
|
examPaperSectionInfo.setSectionName(String.valueOf(lstItemSets.get(i).getItemType()));
|
examPaperSectionInfos.add(examPaperSectionInfo);
|
}
|
}
|
examPaperInfo.setSectionInfos(examPaperSectionInfos);
|
}else{
|
examPaperInfo = examPaperService.queryExamPaperByGroupId(groupId);
|
examPaperInfo = examPaperService.queryExamPaperDetail(examPaperInfo.getExamPaperId());
|
List<ExamPaperSectionInfo> examPaperSectionInfos = new ArrayList<>();
|
int count=0;
|
//»ñÈ¡ÊÔ¾íÀïµÄ¸÷ÖÖÌâÊýÁ¿ÉèÖÃ
|
Map<String, ExamPaperInfo> statisticsMap = examPaperService.queryExamPaperItemsStatistic(new String[]{examPaperInfo.getExamPaperId()});
|
//°ÑÉèÖ÷â×°³ÉitemSets
|
lstItemSets=new ArrayList<ExerciseItemSet>();
|
//µ¥Ñ¡
|
ExerciseItemSet exerciseItemSet1 = new ExerciseItemSet();
|
exerciseItemSet1.setItemCount(statisticsMap.get(examPaperInfo.getExamPaperId()).getSingleSelectCount());
|
exerciseItemSet1.setItemType((short) 1);
|
lstItemSets.add(exerciseItemSet1);
|
//¶àÑ¡
|
ExerciseItemSet exerciseItemSet2 = new ExerciseItemSet();
|
exerciseItemSet2.setItemCount(statisticsMap.get(examPaperInfo.getExamPaperId()).getMultiSelectCount());
|
exerciseItemSet2.setItemType((short) 2);
|
lstItemSets.add(exerciseItemSet2);
|
//ÅжÏ
|
ExerciseItemSet exerciseItemSet3 = new ExerciseItemSet();
|
exerciseItemSet3.setItemCount(statisticsMap.get(examPaperInfo.getExamPaperId()).getJudgeCount());
|
exerciseItemSet3.setItemType((short) 3);
|
lstItemSets.add(exerciseItemSet3);
|
//
|
ExerciseItemSet exerciseItemSet8 = new ExerciseItemSet();
|
exerciseItemSet8.setItemCount(statisticsMap.get(examPaperInfo.getExamPaperId()).getQuestionCount());
|
exerciseItemSet8.setItemType((short) 8);
|
lstItemSets.add(exerciseItemSet8);
|
//
|
ExerciseItemSet exerciseItemSet4 = new ExerciseItemSet();
|
exerciseItemSet4.setItemCount(statisticsMap.get(examPaperInfo.getExamPaperId()).getFillBlanksCount());
|
exerciseItemSet4.setItemType((short) 4);
|
lstItemSets.add(exerciseItemSet4);
|
//½«itemSetsÉèÖóÉÒ³ÃæÒªÓõ½µÄExamPaperSectionInfoÉèÖÃ
|
for (int i=0;i<lstItemSets.size();i++) {
|
ExamPaperSectionInfo examPaperSectionInfo=new ExamPaperSectionInfo();
|
int itemCount = lstItemSets.get(i).getItemCount();
|
if (itemCount>0) {
|
examPaperSectionInfo.setGroupId(groupId);
|
//ÉèÖÿªÊ¼½áÊø
|
examPaperSectionInfo.setItemStartOrder((short)count);
|
//»ñÈ¡ÌâÄ¿ÉèÖõÄcount,Ï´ÎÑ»·ÓÃ
|
count+=itemCount;
|
examPaperSectionInfo.setItemEndOrder((short)count);
|
//Ãû³Æ
|
examPaperSectionInfo.setSectionName(String.valueOf(lstItemSets.get(i).getItemType()));
|
examPaperSectionInfos.add(examPaperSectionInfo);
|
}
|
}
|
examPaperInfo.setSectionInfos(examPaperSectionInfos);
|
}
|
return examPaperInfo;
|
}
|
|
/**
|
* »ñÈ¡Óû§´ðÌâÐÅÏ¢
|
* @param recordId
|
* @return
|
*/
|
private List<Map<String,Object>> queryUserAnswers(String recordId){
|
return this.findListWithMapByHql(
|
"select u.answerUId as answerUId, u.exerciseItemId as exerciseId,u.answer as answer,u.correct as correct,u.teacherScore as teacherScore,i.type as type"
|
+ " from ExerciseItemAnswerU u,ExerciseItem i where u.exerciseItemId = i.exerciseId and u.exerciseRecordId=:recordId and u.deleteFlag is false order by u.createTime asc ",
|
CollectionUtils.newObjectMap("recordId", recordId));
|
}
|
|
/**
|
* »ñÈ¡Óû§µÄ¿¼ÊԼǼ£¬Èç¹û²»´æÔÚÔò´´½¨²¢·µ»Ø
|
* @param examBatchInfo
|
* @param itemSets
|
* @param classId
|
* @param studentUserId
|
* @return
|
*/
|
private ExerciseRecord doInitExerciseRecord(ExamBatchInfo examBatchInfo,List<ExerciseItemSet> itemSets,String classId,String studentUserId){
|
String[] examTypes = new String[] { "A", "B", "C", "D" };
|
String examBatchId = examBatchInfo.getExamBatchId();
|
String examId = examBatchInfo.getExamId();
|
short examBatchNo = examBatchInfo.getExamBatchNo();
|
short examType = examBatchInfo.getExamInfo().getExamType();
|
int remainingSeconds = examBatchInfo.getExamInfo().getDurationMin()*60;
|
|
// ²éѯÊÇ·ñÓнøÐÐÖеĿ¼ÊÔ
|
ExerciseRecord record = this.findUnique(
|
"from ExerciseRecord where examBatchId=? and classId=? and userId = ? and deleteFlag is false ",
|
CollectionUtils.newList(examBatchId,classId,StringUtils.isNotEmpty(studentUserId) ? studentUserId : ClientUtils.getUserId()),
|
ExerciseRecord.class);
|
|
if (record==null) {
|
String groupId = null;
|
String cacheKey = "EXAM_DO_COUNT_".concat(examBatchId);
|
int doCount = this.getCachedRecordCount(cacheKey,examBatchId);
|
|
//Ëæ»ú´´½¨ÌâÄ¿×é
|
if(checkIsRandomExam(examType)){
|
String newGroupName = examId+"-"+examBatchNo+"-Ëæ»úÊÔ¾íÌâ¿â-"+(++doCount);
|
//²éÌâ¿â
|
List<ExerciseGroup> lstSourceGroup = queryExamGroups(examId, ExerciseExamReGroup.GROUP_TYPE_SOURCE);
|
String[] sourceGroupIds = QBeanUtils.listPropertyVal(lstSourceGroup, "groupId").toArray(new String[lstSourceGroup.size()]);
|
groupId = this.exerciseGroupService.doCreateRandomExerciseGroup(newGroupName,ExerciseGroup.TYPE_EXERCISE_EXAM_ITEM,sourceGroupIds,itemSets);
|
}else{
|
groupId = examPaperService.queryExamPaperByCode(examId,examTypes[doCount % examType]).getGroupId();
|
}
|
|
record = this.insertExerRecord(examBatchInfo,itemSets,groupId,classId,remainingSeconds);
|
stringRedisTemplate.opsForValue().increment(cacheKey, 1); //+1
|
}
|
return record;
|
}
|
/**
|
* ´´½¨²¹¿¼¿¼ÊԼǼ
|
* @param examBatchInfo
|
* @param itemSets
|
* @param studentUserId
|
* @return
|
*/
|
private ExerciseRecord doInitReExerciseRecord(ExamInfo examInfo,List<ExerciseItemSet> itemSets,String studentUserId){
|
String[] examTypes = new String[] { "A", "B", "C", "D" };
|
// String examBatchId = examBatchInfo.getExamBatchId();
|
String examId = examInfo.getExamId();
|
// short examBatchNo = examBatchInfo.getExamBatchNo();
|
short examType = examInfo.getExamType();
|
int remainingSeconds = examInfo.getDurationMin()*60;
|
|
//´´½¨¿¼ÊԼǼ
|
String groupId = null;
|
String cacheKey = "EXAM_DO_COUNT_".concat(examId);
|
int doCount = this.getCachedRecordCount(cacheKey,examId);
|
|
//Ëæ»ú´´½¨ÌâÄ¿×é
|
if(checkIsRandomExam(examType)){
|
String newGroupName = examId+"-"+UUIDUtils.generateSpecialUuid(4)+"-Ëæ»úÊÔ¾íÌâ¿â-"+(++doCount);
|
//²éÌâ¿â
|
List<ExerciseGroup> lstSourceGroup = queryExamGroups(examId, ExerciseExamReGroup.GROUP_TYPE_SOURCE);
|
String[] sourceGroupIds = QBeanUtils.listPropertyVal(lstSourceGroup, "groupId").toArray(new String[lstSourceGroup.size()]);
|
groupId = this.exerciseGroupService.doCreateRandomExerciseGroup(newGroupName,ExerciseGroup.TYPE_EXERCISE_EXAM_ITEM,sourceGroupIds,itemSets);
|
}else{
|
groupId = examPaperService.queryExamPaperByCode(examId,examTypes[doCount % examType]).getGroupId();
|
}
|
ExerciseRecord record = this.insertReExerRecord(examInfo,itemSets,groupId,remainingSeconds);
|
stringRedisTemplate.opsForValue().increment(cacheKey, 1); //+1
|
|
return record;
|
}
|
|
// »ñÈ¡ÕýÔÚ×öÊÔ¾íµÄѧÉúÊý
|
private int getCachedRecordCount(String cacheKey,String examBatchId){
|
String cacheCount = stringRedisTemplate.opsForValue().get(cacheKey);
|
int doCount = StringUtils.isEmpty(cacheCount) ? 0 : Integer.valueOf(cacheCount);
|
if (doCount == 0) {
|
doCount = this.findCount("from ExerciseRecord where examBatchId=? and deleteFlag is false",
|
CollectionUtils.newList(examBatchId));
|
}
|
return doCount;
|
}
|
|
private ExerciseRecord insertExerRecord(ExamBatchInfo examBatchInfo,List<ExerciseItemSet> itemSets,String groupId,String classId,int remainingSeconds) {
|
ExamInfo examInfo = examBatchInfo.getExamInfo();
|
|
ExerciseRecord record = new ExerciseRecord();
|
record.setDeleteFlag(false);
|
record.setExerciseGroupId(groupId);
|
record.setExamBatchId(examBatchInfo.getExamBatchId());
|
record.setDoCount(BigInteger.ZERO);
|
record.setCorrectCount(BigInteger.ZERO);
|
record.setTitleMaxNumber("0");
|
record.setStatus("0");
|
record.setClassId(classId);
|
record.setRemainingSeconds(remainingSeconds);
|
record.setScore(BigDecimal.ZERO);
|
record.setUserId(ClientUtils.getUserId());
|
record.setOrgId(ClientUtils.getOrgId());
|
|
//»ñÈ¡¿¼ÊÔÌâĿͳ¼ÆÐÅÏ¢£¬²¢±£´æ
|
Map<String,Object> result = this.queryItemStatics(itemSets, groupId);
|
record.setTotalScore(new BigDecimal(examInfo.getTotalScore()));
|
record.setPassingScore(new BigDecimal(examInfo.getPassingScore()));
|
record.setSubTotalScore((BigDecimal)result.get("subTotalScore"));
|
record.setObjTotalScore((BigDecimal)result.get("objTotalScore"));
|
record.setSubItemCount((int)result.get("subItemCount"));
|
record.setObjItemCount((int)result.get("objItemCount"));
|
|
TraceUtils.setCreateTrace(record);
|
this.save(record);
|
return record;
|
}
|
|
//ÉèÖò¹¿¼¿¼ÊԼǼ
|
private ExerciseRecord insertReExerRecord(ExamInfo examInfo,List<ExerciseItemSet> itemSets,String groupId,int remainingSeconds) {
|
// ExamInfo examInfo = examBatchInfo.getExamInfo();
|
|
ExerciseRecord record = new ExerciseRecord();
|
record.setDeleteFlag(false);
|
record.setExerciseGroupId(groupId);
|
//ÒòΪûÓÐÅú´Î£¬ËùÓÐʱ¼äËùÓÐÈ˶¼¿ÉÒÔ¿¼£¬ËùÒÔÕâÀｫÅú´ÎIDÉèÖóɿ¼ÊÔID
|
record.setExamBatchId(examInfo.getExamId());
|
record.setDoCount(BigInteger.ZERO);
|
record.setCorrectCount(BigInteger.ZERO);
|
record.setTitleMaxNumber("0");
|
record.setStatus("0");
|
//²»ÉèÖÃclassID
|
// record.setClassId(classId);
|
record.setRemainingSeconds(remainingSeconds);
|
record.setScore(BigDecimal.ZERO);
|
record.setUserId(ClientUtils.getUserId());
|
record.setOrgId(ClientUtils.getOrgId());
|
|
//»ñÈ¡¿¼ÊÔÌâĿͳ¼ÆÐÅÏ¢£¬²¢±£´æ
|
Map<String,Object> result = this.queryItemStatics(itemSets, groupId);
|
record.setTotalScore(new BigDecimal(examInfo.getTotalScore()));
|
record.setPassingScore(new BigDecimal(examInfo.getPassingScore()));
|
record.setSubTotalScore((BigDecimal)result.get("subTotalScore"));
|
record.setObjTotalScore((BigDecimal)result.get("objTotalScore"));
|
record.setSubItemCount((int)result.get("subItemCount"));
|
record.setObjItemCount((int)result.get("objItemCount"));
|
|
TraceUtils.setCreateTrace(record);
|
this.save(record);
|
return record;
|
}
|
|
/**
|
* »ñÈ¡²¹¿¼¼Ç¼¼¯ºÏ
|
* @param examId
|
* @param userId
|
* @return
|
*/
|
@Override
|
public Result getReExamRecordList(String examId, String userId) {
|
// ²éѯÊÇ·ñÓнøÐÐÖеĿ¼ÊÔ
|
List<ExerciseRecord> exerciseRecords = this.find(
|
"from ExerciseRecord where examBatchId=? and userId = ? and deleteFlag is false ",
|
CollectionUtils.newList(examId, StringUtils.isNotEmpty(userId) ? userId : ClientUtils.getUserId()),
|
ExerciseRecord.class);
|
return new Result(true,"",exerciseRecords);
|
}
|
|
private Map<String,Object> queryItemStatics(List<ExerciseItemSet> itemSets,String groupId){
|
float subTotalScore = 0,objTotalScore=0;
|
int subItemCount=0,objItemCount=0;
|
|
//Èç¹ûÊÇËæ»ú×é¾í
|
if(itemSets!=null && itemSets.size()>0){
|
for(ExerciseItemSet s:itemSets){
|
if(s.getItemType()==ExerciseItem.TYPE_ESSAY_QUESTION){
|
subTotalScore+= s.getItemCount()*s.getRightScore();
|
subItemCount+=s.getItemCount();
|
}else{
|
objTotalScore += s.getItemCount()*s.getRightScore();
|
objItemCount += s.getItemCount();
|
}
|
}
|
}else{
|
List<ExamItemV> lstItems = this.find("from ExamItemV where id.groupId=?",CollectionUtils.newList(groupId),ExamItemV.class);
|
if(lstItems!=null && lstItems.size()>0){
|
for(ExamItemV v: lstItems){
|
if(v.getItemType()==ExerciseItem.TYPE_ESSAY_QUESTION){
|
subTotalScore+= v.getItemScore();
|
++subItemCount;
|
}else{
|
objTotalScore += v.getItemScore();
|
++objItemCount;
|
}
|
}
|
}
|
}
|
|
Map<String,Object> result = new HashMap<String,Object>();
|
result.put("subTotalScore", new BigDecimal(subTotalScore));
|
result.put("objTotalScore", new BigDecimal(objTotalScore));
|
result.put("subItemCount", subItemCount);
|
result.put("objItemCount", objItemCount);
|
|
return result;
|
}
|
|
|
|
|
|
@Override
|
public int getExamCount(String classId, String userId) {
|
// ²éѯ¼Ç¼Êý
|
String hqlCount = "from ExamInfo i, ExamBatchInfo b,ExamBatchClassRe r WHERE "
|
+ " i.examId=b.examId and b.examBatchId = r.examBatchId AND r.classId =:classId AND i.examStatus=:examStatus AND b.deleteFlag is false AND r.deleteFlag is false ";
|
int examCount = findCountByComplexHql(hqlCount,
|
CollectionUtils.newObjectMap("classId", classId, "examStatus", ExamInfo.STATUS_PUBLISH));
|
return examCount;
|
}
|
|
/**
|
* ²éѯ¿¼ÊÔ¹ØÁªµÄÌâÄ¿×é
|
* @param examId
|
* @param
|
* @return ÌâÄ¿×éMap<id£¬>
|
*/
|
private List<ExerciseGroup> queryExamGroups(String examId,Short reType){
|
return this.find( "select p from ExerciseExamReGroup g,ExerciseGroup p where g.groupId = p.groupId and g.examId=? and g.type=? and g.deleteFlag is false",
|
CollectionUtils.newList(examId,reType) , ExerciseGroup.class);
|
}
|
|
|
/**
|
* ²éѯ¿¼ÊÔ¹ØÁªµÄÌâÄ¿ÅäÖÃÐÅÏ¢
|
* @param examId
|
* @param
|
* @return
|
*/
|
private List<ExerciseItemSet> queryExerciseItemSet(String examId){
|
return this.find( "from ExerciseItemSet s where s.deleteFlag is false and s.exerciseInfoId=?",
|
CollectionUtils.newList(examId) , ExerciseItemSet.class);
|
}
|
|
@Override
|
public int getUnCommitExamCount(String classId, String userId) {
|
String sql = "SELECT c.exam_id, c.exam_name, c.exam_batch_Id, c.start_Time, c.end_Time, "
|
+ "c.class_id, d.exercise_Group_Id, d.score, d. STATUS FROM ( SELECT i.exam_Id, "
|
+ "i.exam_Name, b.exam_Batch_Id, b.start_Time,b.end_Time, r.class_Id FROM Exam_Info i, "
|
+ "Exam_Batch_Info b, Exam_Class_Re r WHERE i.exam_Id = b.exam_Id AND b.exam_Batch_Id "
|
+ "= r.exam_Batch_Id AND r.class_Id =:classId AND i.exam_status = 1 AND b.delete_Flag"
|
+ "= 0 AND r.delete_Flag = 0 ) c LEFT OUTER JOIN ( SELECT * FROM Exercise_Record "
|
+ "d WHERE d.delete_Flag = 0 AND d.user_id =:userId ) d ON c.exam_Batch_Id = d.exam_Batch_Id "
|
+ "AND c.class_id = d.class_id where ifnull(d.status,0)= 0 and (c.end_Time - CURRENT_TIMESTAMP ()) < 0 ";
|
List<Object[]> list = findByComplexSql(sql, CollectionUtils.newObjectMap("classId", classId, "userId", userId),
|
Object[].class);
|
return list.size();
|
|
}
|
|
@Override
|
public int getToBeCommitExamCount(String classId, String userId) {
|
String sql = "SELECT c.exam_id, c.exam_name, c.exam_batch_Id, c.start_Time, c.end_Time, "
|
+ "c.class_id, d.exercise_Group_Id, d.score, d. STATUS FROM ( SELECT i.exam_Id, "
|
+ "i.exam_Name, b.exam_Batch_Id, b.start_Time,b.end_Time, r.class_Id FROM Exam_Info i, "
|
+ "Exam_Batch_Info b, Exam_Class_Re r WHERE i.exam_Id = b.exam_Id AND b.exam_Batch_Id "
|
+ "= r.exam_Batch_Id AND r.class_Id =:classId AND i.exam_status = 1 AND b.delete_Flag"
|
+ "= 0 AND r.delete_Flag = 0 ) c LEFT OUTER JOIN ( SELECT * FROM Exercise_Record "
|
+ "d WHERE d.delete_Flag = 0 AND d.user_id =:userId ) d ON c.exam_Batch_Id = d.exam_Batch_Id "
|
+ "AND c.class_id = d.class_id where ifnull(d.status,0)= 0 and (c.end_Time - CURRENT_TIMESTAMP ()) > 0 ";
|
List<Object[]> list = findByComplexSql(sql, CollectionUtils.newObjectMap("classId", classId, "userId", userId),
|
Object[].class);
|
return list.size();
|
}
|
|
@Override
|
public int getCommitExamCount(String classId, String userId) {
|
String sql = "SELECT c.exam_id, c.exam_name, c.exam_batch_Id, c.start_Time, c.end_Time, "
|
+ "c.class_id, d.exercise_Group_Id, d.score, d. STATUS FROM ( SELECT i.exam_Id, "
|
+ "i.exam_Name, b.exam_Batch_Id, b.start_Time,b.end_Time, r.class_Id FROM Exam_Info i, "
|
+ "Exam_Batch_Info b, Exam_Class_Re r WHERE i.exam_Id = b.exam_Id AND b.exam_Batch_Id "
|
+ "= r.exam_Batch_Id AND r.class_Id =:classId AND i.exam_status = 1 AND b.delete_Flag"
|
+ "= 0 AND r.delete_Flag = 0 ) c LEFT OUTER JOIN ( SELECT * FROM Exercise_Record "
|
+ "d WHERE d.delete_Flag = 0 AND d.user_id =:userId ) d ON c.exam_Batch_Id = d.exam_Batch_Id "
|
+ "AND c.class_id = d.class_id where d.status > 0";
|
List<Object[]> list = findByComplexSql(sql, CollectionUtils.newObjectMap("classId", classId, "userId", userId),
|
Object[].class);
|
return list.size();
|
}
|
|
@Override
|
public Map<String,Integer> queryExamResultStatusCount(List<String> lstExamIds) {
|
if(lstExamIds == null || lstExamIds.size()==0){
|
return null;
|
}
|
|
String hql = "select examId||'-'||status ,count(1) from ExamResultV "
|
+ "where examId in(:examIds) group by examId,status";
|
|
List<Object[]> lstResult = this.findByComplexHql(hql,
|
CollectionUtils.newObjectMap("examIds",lstExamIds.toArray(new String[lstExamIds.size()])), Object[].class);
|
|
Map<String,Integer> resultMap = new HashMap<String,Integer>(lstResult.size());
|
|
for(Object[] o:lstResult){
|
resultMap.put((String)o[0],((Long)o[1]).intValue());
|
}
|
|
return resultMap;
|
}
|
|
}
|
