package com.qxueyou.scc.exam.service.impl;
|
|
import java.util.HashMap;
|
import java.util.LinkedHashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.qxueyou.scc.base.model.Result;
|
import com.qxueyou.scc.base.service.impl.CommonAppService;
|
import com.qxueyou.scc.base.util.CollectionUtils;
|
import com.qxueyou.scc.base.util.TraceUtils;
|
import com.qxueyou.scc.base.util.UUIDUtils;
|
import com.qxueyou.scc.exam.model.ExamPaperInfo;
|
import com.qxueyou.scc.exam.service.IExamPaperSectionService;
|
import com.qxueyou.scc.exam.service.IExamPaperService;
|
import com.qxueyou.scc.exercise.model.ExerciseGroup;
|
import com.qxueyou.scc.exercise.model.ExerciseItem;
|
import com.qxueyou.scc.exercise.service.IExerciseGroupService;
|
|
/**
|
* 试卷管理服务层
|
*
|
* @author kevin
|
* @createTime 2017-11-1
|
*/
|
@Service
|
public class ExamPaperService extends CommonAppService implements IExamPaperService {
|
|
@Autowired
|
IExerciseGroupService exerciseGroupService;
|
|
@Autowired
|
IExamPaperSectionService examPaperSectionService;
|
|
@Override
|
public Result addExamPaper(ExamPaperInfo examPaperInfo) {
|
Result result = new Result(true);
|
String examPaperId = null, groupId = null;
|
ExerciseGroup exerciseGroup = null;
|
|
//创建试卷关联题库
|
exerciseGroup = new ExerciseGroup();
|
exerciseGroup.setName(examPaperInfo.getExamPaperName()+"-试卷题库");
|
exerciseGroup.setType(ExerciseGroup.TYPE_EXERCISE_EXAM_ITEM);
|
groupId = exerciseGroupService.addExerciseGroup(exerciseGroup);
|
|
//保存试卷
|
examPaperId = UUIDUtils.generateUUID().replace("-", "");
|
examPaperInfo.setExamPaperId(examPaperId);
|
examPaperInfo.setPaperStatus(ExamPaperInfo.STATUS_DRAFT);
|
examPaperInfo.setGroupId(groupId);
|
TraceUtils.setCreateTrace(examPaperInfo);
|
this.insert(examPaperInfo);
|
|
result.addData("examPaperId", examPaperId);
|
return result;
|
}
|
|
|
@Override
|
public Result deleteExamPaper(String[] examPaperIds) {
|
Result result = new Result(true) ;
|
if(examPaperIds!=null && examPaperIds.length>0 ){
|
String hql = "update ExamPaperInfo set deleteFlag = true where examPaperId=?";
|
result = bulkUpdateInLoop(hql, examPaperIds);
|
}
|
return result;
|
}
|
|
@Override
|
public Result updateExamPaper(ExamPaperInfo param) {
|
ExamPaperInfo examPaperInfo = read(ExamPaperInfo.class, param.getExamPaperId());
|
if(examPaperInfo!=null){
|
TraceUtils.setUpdateTrace(examPaperInfo);
|
examPaperInfo.setDifficultLevel(param.getDifficultLevel());
|
examPaperInfo.setExamPaperName(param.getExamPaperName());
|
}
|
return save(examPaperInfo);
|
}
|
|
@Override
|
public Result doPublishExamPaper(String[] examPaperIds) {
|
Map<String, Object> pramMap = null;
|
if(examPaperIds!=null && examPaperIds.length>0){
|
pramMap = new HashMap<String, Object>(1);
|
pramMap.put("examPaperIds", examPaperIds);
|
String hql = "from ExamPaperInfo where examPaperId in (:examPaperIds)";
|
List<ExamPaperInfo> lstExamPaperInfo = this.findByComplexHql(hql,pramMap, ExamPaperInfo.class);
|
|
for (ExamPaperInfo examPaperInfo : lstExamPaperInfo) {
|
if(ExamPaperInfo.STATUS_DRAFT!=examPaperInfo.getPaperStatus()){
|
return new Result(false, "只有草稿状态的试卷,才能发布。");
|
}
|
|
if(examPaperInfo.getTotalScore()<=0){
|
return new Result(false, "试卷总分大于零,才能发布。");
|
}
|
|
examPaperInfo.setPaperStatus(ExamPaperInfo.STATUS_PUBLISH);
|
TraceUtils.setUpdateTrace(examPaperInfo);
|
save(examPaperInfo);
|
}
|
}else{
|
return new Result(false, "没有选择要发布的试卷。");
|
}
|
return new Result(true);
|
}
|
|
@Override
|
public Result doRevokeExamPaper(String[] examPaperIds) {
|
Map<String, Object> pramMap = null;
|
if(examPaperIds!=null && examPaperIds.length>0){
|
pramMap = new HashMap<String, Object>(1);
|
pramMap.put("examPaperIds", examPaperIds);
|
String hql = "from ExamPaperInfo where examPaperId in (:examPaperIds)";
|
List<ExamPaperInfo> lstExamPaperInfo = this.findByComplexHql(hql,pramMap, ExamPaperInfo.class);
|
for (ExamPaperInfo examPaperInfo : lstExamPaperInfo) {
|
if(ExamPaperInfo.STATUS_PUBLISH!=examPaperInfo.getPaperStatus()){
|
return new Result(false, "只有发布状态的试卷,才能撤回。");
|
}
|
examPaperInfo.setPaperStatus(ExamPaperInfo.STATUS_DRAFT);
|
TraceUtils.setUpdateTrace(examPaperInfo);
|
save(examPaperInfo);
|
}
|
}else{
|
return new Result(false, "没有选择要撤回的试卷。");
|
}
|
|
return new Result(true);
|
}
|
|
@Override
|
public ExamPaperInfo queryExamPaperDetail(String examPaperId) {
|
ExamPaperInfo examPaperInfo= this.read(ExamPaperInfo.class, examPaperId);
|
ExerciseGroup exerciseGroup = exerciseGroupService.queryExerciseGroupDetail(examPaperInfo.getGroupId());
|
examPaperInfo.setExerciseGroup(exerciseGroup);
|
return examPaperInfo;
|
}
|
|
@Override
|
public Map<String,ExamPaperInfo> queryExamPaperItemsStatistic(String[] examPaperIds){
|
Map<String,ExamPaperInfo> resultMap =null;
|
if(examPaperIds!=null &&examPaperIds.length>0){
|
resultMap = new LinkedHashMap<String,ExamPaperInfo>(examPaperIds.length);
|
String hql = " select p.examPaperId, i.type,count(i.type) from ExamPaperInfo p, ExerciseGroupItemRe r,ExerciseItem i where p.examPaperId in (:examPaperIds) "
|
+ "and p.groupId=r.exerciseGroupId and r.exerciseItemId = i.exerciseId and r.deleteFlag is false group by p.examPaperId,i.type";
|
Map<String,Object> param =new HashMap<String,Object>();
|
param.put("examPaperIds", examPaperIds);
|
List<Object[]> lstItemStatics = this.findByComplexHql(hql, param, Object[].class);
|
|
ExamPaperInfo tempPaperInfo = null;
|
String tempPaperId = null;
|
short tempType= 0;
|
int tempCount=0;
|
for(int i=0;i<lstItemStatics.size();i++){
|
tempPaperId= (String) lstItemStatics.get(i)[0];
|
tempType = (Short) lstItemStatics.get(i)[1];
|
tempCount = ((Long) lstItemStatics.get(i)[2]).intValue();
|
|
if(resultMap.get(tempPaperId)==null){
|
tempPaperInfo = new ExamPaperInfo();
|
tempPaperInfo.setExamPaperId(tempPaperId);
|
resultMap.put(tempPaperId, tempPaperInfo);
|
}else{
|
tempPaperInfo = resultMap.get(tempPaperId);
|
}
|
|
if(tempType==ExerciseItem.TYPE_SINGLE_SELECT){
|
tempPaperInfo.setSingleSelectCount(tempCount);
|
}else if(tempType==ExerciseItem.TYPE_MULTI_SELECT){
|
tempPaperInfo.setMultiSelectCount(tempCount);
|
}else if(tempType==ExerciseItem.TYPE_TRUE_OR_FALSE){
|
tempPaperInfo.setJudgeCount(tempCount);
|
}else if(tempType==ExerciseItem.TYPE_ESSAY_QUESTION){
|
tempPaperInfo.setQuestionCount(tempCount);
|
}else if(tempType==ExerciseItem.TYPE_FILL_BLANKS){
|
tempPaperInfo.setFillBlanksCount(tempCount);
|
}
|
}
|
}
|
return resultMap;
|
}
|
|
@Override
|
public ExamPaperInfo queryExamPaperByCode(String examId,String paperCode){
|
return this.findUnique("select p from ExamReExamPaper r,ExamPaperInfo p "
|
+ " where r.examPaperId=p.examPaperId and r.examId = ? and r.relationPaperCode=? and r.deleteFlag is false",
|
CollectionUtils.newList(examId, paperCode), ExamPaperInfo.class);
|
}
|
|
@Override
|
public ExamPaperInfo queryExamPaperByGroupId(String groupId){
|
return this.findUnique("from ExamPaperInfo where groupId=? and deleteFlag is false ",CollectionUtils.newList(groupId), ExamPaperInfo.class);
|
}
|
|
|
|
|
}
|
