/** 查询无班级学生信息 */
@Override
public List<StudentManagerDTO> queryStudentsWithoutClassId(String schoolId) {
List<MStudentManager> usersList = studentMapper.selectStudentsWithoutClassId(null, schoolId);
List<StudentManagerDTO> userDTOList = new ArrayList<>();
for (MStudentManager user : usersList) {
StudentManagerDTO userDTO = new StudentManagerDTO();
BeanUtils.copyProperties(user, userDTO);
userDTOList.add(userDTO);
}
return userDTOList;
}
// 学生换班，管理员修改名称，删除该家长的缓存信息
private void deleteRedis(List<MFamilyRelation> frList) {
List<String> keyList = new ArrayList<>();
for (MFamilyRelation fr : frList) {
keyList.add(MessageFormat.format(CacheConstants.KEY_KID_OF_PARENT, fr.getUserId()));
keyList.add(MessageFormat.format(CacheConstants.KEY_FAMILY_RELATION, fr.getUserId()));
keyList.add(MessageFormat.format(CacheConstants.KEY_KID_NAME_OF_PARENT, fr.getUserId()));
}
if (CollectionUtils.isNotEmpty(keyList)) {
cacheService.delete(keyList);
}
}
/** APP接口、WEB平台：根据班级ID查询该班级所有学生 */
@Override
public List<StudentManagerDTO> queryClassStudents(String classId) {
String schoolId = classService.getSchoolId(classId);
List<MStudentManager> userList = studentMapper.selectClassStudents(classId, schoolId);
List<StudentManagerDTO> userDTOList = new ArrayList<>();
for (MStudentManager u : userList) {
StudentManagerDTO userDTO = new StudentManagerDTO();
BeanUtils.copyProperties(u, userDTO);
userDTOList.add(userDTO);
}
return userDTOList;
}
/** APP接口、WEB平台：根据学生名称查询学生信息 */
@Override
public List<StudentManagerDTO> queryStudentByRealName(String realName, String userId) {
if (StringUtils.isEmpty(userId)) {
logger.debug("userId 不能为空");
return null;
}
String schoolId = userService.getSchoolId(userId);
List<MStudentManager> userList = studentMapper.selectStudentByRealName(realName, schoolId);
List<StudentManagerDTO> userDTOList = new ArrayList<>();
for (MStudentManager u : userList) {
StudentManagerDTO userDTO = new StudentManagerDTO();
BeanUtils.copyProperties(u, userDTO);
userDTOList.add(userDTO);
}
return userDTOList;
}
/** 通知用 根据学生Id查询家庭成员 */
@Override
public List<FamilyRelationDTO> queryFamilyByStudent(String userId) {
String key = MessageFormat.format(CacheConstants.KEY_PARENT_OF_KID, userId);
List<FamilyRelationDTO> list = cacheService.get(key);
if (list != null) {
return list;
}
List<FamilyRelationDTO> familyRelationDTOs = new ArrayList<>();
List<MFamilyRelation> mFamilyRelations =
famillyRelationMapper.queryFamilyByStudent(userId, userService.getSchoolId(userId));
for (MFamilyRelation fr : mFamilyRelations) {
FamilyRelationDTO familyRelationDTO = new FamilyRelationDTO();
BeanUtils.copyProperties(fr, familyRelationDTO);
familyRelationDTOs.add(familyRelationDTO);
}
cacheService.set(key, familyRelationDTOs, CacheConstants.CACHE_SEVEN_DAY, TimeUnit.DAYS);
return familyRelationDTOs;
}
/** 查询学生信息分页 */
@Override
public PageResponse<StudentManagerDTO> queryStudentPage(StudentPageRequest studentPageRequest) {
String schoolId = studentPageRequest.getSchoolId();
if (schoolId == null) {
schoolId = userService.getSchoolId(studentPageRequest.getUserId());
studentPageRequest.setSchoolId(schoolId);
}
// 获取学生信息的总条数
MStudentManager studentManager = new MStudentManager();
BeanUtils.copyProperties(studentPageRequest, studentManager);
long count = studentMapper.selectCount(studentManager);
// 获取当前页的信息
Page page = PageUtils.buildPage(studentPageRequest);
List<MStudentManager> mStudentList =
studentMapper.selectMStudentManagerPage(page, studentManager);
/*
给返回接口赋值
*/
List<StudentManagerDTO> studentManagerDTOs = new ArrayList<>();
for (MStudentManager mstudents : mStudentList) {
StudentManagerDTO studentManagerDTO = new StudentManagerDTO();
BeanUtils.copyProperties(mstudents, studentManagerDTO);
studentManagerDTO.setLastLoginDate(
mstudents.getLastLoginDate() == null
? "从未登录"
: DateFormatUtils.format(mstudents.getLastLoginDate(), "yyyy-MM-dd HH:mm"));
if (mstudents.getYears() != null) {
studentManagerDTO.setClassAliasName(
getGrade(mstudents.getYears()) + studentManagerDTO.getClassAliasName());
} else {
studentManagerDTO.setClassAliasName("无班级");
}
studentManagerDTOs.add(studentManagerDTO);
}
// 返回对象
PageResponse<StudentManagerDTO> pageResponse = new PageResponse<>();
PageUtils.buldPageResponse(studentPageRequest, pageResponse);
pageResponse.setRows(studentManagerDTOs);
pageResponse.setRecords(count);
return pageResponse;
}
/** 导出学生信息 */
@Override
public List<ExcelInfo> queryExcelInfo(StudentPageRequest studentPageRequest) {
Map<Integer, ExcelInfo> map = new TreeMap<>();
String schoolId = studentPageRequest.getSchoolId();
if (schoolId == null) {
schoolId = userService.getSchoolId(studentPageRequest.getUserId());
studentPageRequest.setSchoolId(schoolId);
}
// 获取学生信息的总条数
MStudentManager studentManager = new MStudentManager();
BeanUtils.copyProperties(studentPageRequest, studentManager);
List<MStudentManager> mStudentList = studentMapper.selectStudents_export(studentManager);
for (MStudentManager students : mStudentList) {
List<List<Object>> data;
List<Object> row = new ArrayList<>();
row.add(students.getRealName());
if (students.getYears() != null) {
int grade = ClassNameUtil.getGradeNum(students.getYears());
ExcelInfo excelInfo = map.get(grade);
if (excelInfo == null) {
excelInfo = new ExcelInfo();
data = new ArrayList<>();
excelInfo.setData(data);
excelInfo.setSheetName(grade + "年级");
excelInfo.setHeaders(new String[] {"学生姓名", "所在班级", "登录账号", "上线情况"});
excelInfo.setColumnWidth(20);
map.put(grade, excelInfo);
} else {
data = excelInfo.getData();
}
row.add(grade + "年级" + students.getClassAliasName());
} else {
ExcelInfo excelInfo = map.get(0);
if (excelInfo == null) {
excelInfo = new ExcelInfo();
data = new ArrayList<>();
excelInfo.setData(data);
excelInfo.setSheetName("无班级");
excelInfo.setColumnWidth(20);
excelInfo.setHeaders(new String[] {"学生姓名", "所在班级", "登录账号", "上线情况"});
map.put(0, excelInfo);
} else {
data = excelInfo.getData();
}
row.add("无班级");
}
row.add(students.getUserId());
row.add(DateUtil.getLogin_date(students.getLastLoginDate()));
data.add(row);
}
return new ArrayList<>(map.values());
}