Merge remote-tracking branch 'origin/master'

胡仁荣

2022-11-03 efb51d5e1f6625ac528bdedb572435dfd788c603

Merge remote-tracking branch 'origin/master'

 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 {
@@ -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;

@@ -19,6 +23,9 @@
    
    @Autowired
    ExamScoreVDAO examDao;

    @Autowired
    ExamResultVDao examResultVDao;

    @Override
    public Map<String,Object> queryClassExamScoreInfo(String classId) {
@@ -43,4 +50,10 @@
                );
    }

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


}

 src/main/java/com/qxueyou/scc/exam/dao/ExamResultVDao.java

New file
@@ -0,0 +1,20 @@
package com.qxueyou.scc.exam.dao;

import com.qxueyou.scc.base.dao.BaseDAO;
import com.qxueyou.scc.base.model.Pager;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.exam.model.ExamResultV;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public class ExamResultVDao extends BaseDAO {

    public List<ExamResultV> getResultList(String classId, Pager pager) {
        String hql = "from ExamResultV where class_Id LIKE ?";
        return this.findList(hql,pager,CollectionUtils.newList(classId),ExamResultV.class);
    }


}