成绩管理修改（持续修改中）

Administrator

2022-11-03 bf7fef028c847b6e63199a7f20991bff2de50765

成绩管理修改（持续修改中）

 src/main/java/com/qxueyou/scc/admin/score/action/ScoreController.java

New file
@@ -0,0 +1,56 @@
package com.qxueyou.scc.admin.score.action;

import com.qxueyou.scc.admin.score.model.Score;
import com.qxueyou.scc.admin.score.service.impl.ScoreService;
import com.qxueyou.scc.base.model.Pager;
import com.qxueyou.scc.base.model.Result;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.base.util.QBeanUtils;
import com.qxueyou.scc.exam.model.ExamBatchInfo;
import com.qxueyou.scc.exam.model.ExamInfo;
import com.qxueyou.scc.exam.model.ExamReExamPaper;
import com.qxueyou.scc.exam.model.ExamResultV;
import com.qxueyou.scc.exercise.model.ExerciseRecord;
import io.swagger.annotations.Api;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Api(tags = "成绩管理接口")
@Controller
@CrossOrigin(origins="*",maxAge=3600)
@RequestMapping(value = "admin/score")
public class ScoreController {

    // 分页查询中，默认记录条数和页数
    private static final int DEFAULT_PAGE_SIZE = 10;
    private static final int DEFAULT_PAGE_NUM = 2;

    @Autowired
    ScoreService scoreService;

    @RequestMapping(value = "lstScore", method = RequestMethod.GET)
    public @ResponseBody
    Result list(String classId,Integer pageSize, Integer pageNum) {
        pageSize = pageSize != null && pageSize > 0 ? pageSize : DEFAULT_PAGE_SIZE;
        pageNum = pageNum != null && pageNum > 0 ? pageNum : DEFAULT_PAGE_NUM;
        Pager pager = new Pager(pageSize,pageNum);
        if(classId == null){
            classId = "%";
        }else {
            classId += "%";
        }
        //总成绩数量
        int totalCount = scoreService.findCount("from ExamResultV where class_Id Like ?",CollectionUtils.newList(classId));
        pager.setTotalCount(totalCount);
        List<ExamResultV> list =  scoreService.allExamResultV(classId,pager);
        return new Result(true,"success",CollectionUtils.newObjectMap("data", list, "scoreCount", totalCount));
    }
}

 src/main/java/com/qxueyou/scc/admin/score/service/IScoreService.java

@@ -1,5 +1,9 @@
package com.qxueyou.scc.admin.score.service;

import com.qxueyou.scc.base.model.Pager;
import com.qxueyou.scc.exam.model.ExamResultV;

import java.util.List;
import java.util.Map;

public interface IScoreService {
@@ -10,7 +14,7 @@
     * @return
     */
    Map<String,Object> queryClassExamScoreInfo(String classId);
	

    /**
     * 获取班级作业成绩信息
     * @param classId
@@ -18,4 +22,10 @@
     */
    Map<String,Object> queryClassHomeworkScoreInfo(String classId);

    /**
     * 获取成绩信息
     * @return
     */
    List<ExamResultV> allExamResultV(String classId, Pager page);

}

 src/main/java/com/qxueyou/scc/admin/score/service/impl/ScoreService.java

@@ -1,7 +1,11 @@
package com.qxueyou.scc.admin.score.service.impl;

import java.util.List;
import java.util.Map;

import com.qxueyou.scc.base.model.Pager;
import com.qxueyou.scc.exam.dao.ExamResultVDao;
import com.qxueyou.scc.exam.model.ExamResultV;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@@ -13,28 +17,31 @@

@Service
public class ScoreService extends CommonAppService implements IScoreService {
	

    @Autowired
    HomeworkScoreVDAO homeworkDao;
	

    @Autowired
    ExamScoreVDAO examDao;

    @Autowired
    ExamResultVDao examResultVDao;

    @Override
    public Map<String,Object> queryClassExamScoreInfo(String classId) {
		

        return CollectionUtils.newObjectMap(
                "examCount",examDao.getExamCount(classId),
                "examHasAuditCount",examDao.getExamCount(classId),
                "examToAuditCount",0,
                "examNoSubmitCount",examDao.getToSubmitExamCount(classId)
                );
		

    }

    @Override
    public Map<String,Object> queryClassHomeworkScoreInfo(String classId) {
		

        return CollectionUtils.newObjectMap(
                "homeworkCount",homeworkDao.getHomeworkCount(classId),
                "homeworkHasAuditCount",homeworkDao.getHomeworkHasAuditCount(classId),
@@ -43,4 +50,10 @@
                );
    }

    @Override
    public List<ExamResultV> allExamResultV(String classId, Pager page) {
        return examResultVDao.getResultList(classId,page);
    }


}