陈杰 / smartCampus

Blame view

src/main/java/com/jevon/service/impl/StudentServiceImpl.java 4.9 KB
Edit Raw Normal View History
ef5c16a0   陈杰   试卷导入 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
 
package com.jevon.service.impl;

import com.jevon.mapper.StudentMapper;
import com.jevon.model.Student;
import com.jevon.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;

/**
 * @author chen
 * @version 1.0
 * @date 2019/10/18 0018 15:16
 */
@Service
public class StudentServiceImpl implements StudentService {

    @Autowired
    StudentMapper studentMapper;

    @Override
    public int insertBatch(List<Student> list) {
        int i = 0 ;
        List<Student> result = new ArrayList<>();
        for(Student student :list){
            i++ ;
            result.add(student);
            if(i % 100 == 0){
                studentMapper.insertBatch(result);
                result = new ArrayList<>();
            }
        }
1de4a428   陈杰   批量上传bug 修复 
35
36
37
 
        studentMapper.insertBatch(result);
        return  1 ;
    }
ef5c16a0   陈杰   试卷导入 
38
39
40
41
 

    @Override
    public List<Student> selectBySchoolName(int analyseId , List<String> league , String schoolName) {
        Student student = new Student();
5cba275e   陈杰   个人学情 
42
43
44
45
46
47
48
49
50
 
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        student.setSchoolNames(league);
        return studentMapper.selectByStudent(student);
    }

    @Override
    public List<Student> selectByClassName(int analyseId, String schoolName, String className) {
        Student student = new Student();
a923e3fe   陈杰   四维诊断 
51
 
        student.setAnalyseId(analyseId);
ef5c16a0   陈杰   试卷导入 
52
53
54
 
        student.setSchoolName(schoolName);
        student.setClassName(className);
        return studentMapper.selectByStudent(student);
a923e3fe   陈杰   四维诊断 
55
 
    }
e6e6895d   陈杰   学科考试概况 
56
57
58
59
60
61
62
63
64
65
 

    @Override
    public int selectCountByScore(int analyseId,  List<String> league , String schoolName, double begin, double end) {
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        student.setBegin(begin);
        student.setEnd(end);
        student.setSchoolNames(league);
        return studentMapper.selectCountByScore(student);
ef5c16a0   陈杰   试卷导入 
66
67
68
 
    }

    @Override
a923e3fe   陈杰   四维诊断 
69
 
    public int selectCountBySchoolScore(int analyseId, String schoolName, String className, double begin, double end) {
ef5c16a0   陈杰   试卷导入 
70
71
72
73
74
 
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        student.setClassName(className);
        student.setBegin(begin);
a923e3fe   陈杰   四维诊断 
75
 
        student.setEnd(end);
ef5c16a0   陈杰   试卷导入 
76
77
 
        return studentMapper.selectCountByScore(student);    }
e6e6895d   陈杰   学科考试概况 
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
 
    @Override
    public List<String> selectClassNameBySchool(int analyseId, String schoolName) {
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        return studentMapper.selectClassNameBySchool(student);
    }

    @Override
    public List<String> selectSchoolNameByAnalyse(int analyseId) {
        return studentMapper.selectSchoolNameByAnalyse(analyseId);
    }

    @Override
    public Double selectMaxScore(int analyseId,List<String> league , String schoolName) {
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        student.setSchoolNames(league);
        return studentMapper.selectMaxScore(student);
a923e3fe   陈杰   四维诊断 
98
99
100
101
102
 
    }

    @Override
    public Double selectMinScore(int analyseId, List<String> league ,String schoolName) {
        Student student = new Student();
5cba275e   陈杰   个人学情 
103
104
105
106
107
108
109
110
111
 
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        student.setSchoolNames(league);
        return studentMapper.selectMinScore(student);
    }

    @Override
    public Double selectAvgScore(int analyseId,List<String> league , String schoolName) {
        Student student = new Student();
a923e3fe   陈杰   四维诊断 
112
 
        student.setAnalyseId(analyseId);
e6e6895d   陈杰   学科考试概况 
113
114
115
 
        student.setSchoolName(schoolName);
        student.setSchoolNames(league);
        return studentMapper.selectAvgScore(student);
a923e3fe   陈杰   四维诊断 
116
 
    }
e6e6895d   陈杰   学科考试概况 
117
118
119
120
 

    @Override
    public Double selectModeNumber(int analyseId,List<String> league , String schoolName) {
        Student student = new Student();
a923e3fe   陈杰   四维诊断 
121
 
        student.setAnalyseId(analyseId);
e6e6895d   陈杰   学科考试概况 
122
123
124
 
        student.setSchoolName(schoolName);
        student.setSchoolNames(league);
        List<Double> list = studentMapper.selectModeNumber(student);
a923e3fe   陈杰   四维诊断 
125
 
        if(list.size() > 1){
e6e6895d   陈杰   学科考试概况 
126
127
128
129
 
            return null ;
        }else {
            return list.get(0);
        }
a923e3fe   陈杰   四维诊断 
130
 
    }
e6e6895d   陈杰   学科考试概况 
131
132
133
 

    @Override
    public Double selectMedian(int analyseId,List<String> league , String schoolName) {
a923e3fe   陈杰   四维诊断 
134
 
        Student student = new Student();
e6e6895d   陈杰   学科考试概况 
135
136
137
138
 
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        student.setSchoolNames(league);
        return studentMapper.selectMedian(student);
a923e3fe   陈杰   四维诊断 
139
 
    }
e6e6895d   陈杰   学科考试概况 
140
141
142
 

    @Override
    public Double selectStdev(int analyseId,List<String> league , String schoolName) {
a923e3fe   陈杰   四维诊断 
143
144
145
146
147
148
149
 
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        student.setSchoolNames(league);
        return studentMapper.selectStdev(student);
    }
}
e6e6895d   陈杰   学科考试概况 












a923e3fe
 
 陈杰
 
四维诊断
















e6e6895d
 
 陈杰
 
学科考试概况
















a923e3fe
 
 陈杰
 
四维诊断
















e6e6895d
 
 陈杰
 
学科考试概况
















a923e3fe
 
 陈杰
 
四维诊断
















e6e6895d
 
 陈杰
 
学科考试概况
















a923e3fe
 
 陈杰
 
四维诊断
















e6e6895d
 
 陈杰
 
学科考试概况
















ef5c16a0
 
 陈杰
 
试卷导入