From 068fc7f2e81178e55fa191a13709af64b1a163f6 Mon Sep 17 00:00:00 2001 From: EricsHu <hrr145632> Date: 星期一, 05 十二月 2022 14:27:43 +0800 Subject: [PATCH] 处理编码 --- src/main/java/com/qxueyou/scc/teach/student/service/impl/StudentService.java | 174 +++++++++++++++++++++++++++++----------------------------- 1 files changed, 87 insertions(+), 87 deletions(-) diff --git a/src/main/java/com/qxueyou/scc/teach/student/service/impl/StudentService.java b/src/main/java/com/qxueyou/scc/teach/student/service/impl/StudentService.java index b1b5b0f..13b8d8d 100644 --- a/src/main/java/com/qxueyou/scc/teach/student/service/impl/StudentService.java +++ b/src/main/java/com/qxueyou/scc/teach/student/service/impl/StudentService.java @@ -52,7 +52,7 @@ public Result insertStudent(String classId, String name, String studentNo, boolean sex, String phoneNo, String orgId) { if (dao.exists(studentNo, orgId)) { - return new Result(false, "学号已存在"); + return new Result(false, "瀛﹀彿宸插瓨鍦�"); } User user = userService.insertUser(name, studentNo, phoneNo, "000000", sex, orgId); @@ -71,7 +71,7 @@ student.setUserId(user.getUserId()); student.setMobilePhone(phoneNo); if(StringUtils.isNoneBlank(classId)) { - bulkUpdate("update ClsClass set studentCount = studentCount + 1 where deleteFlag is false and classId = ?", new Object[]{classId}); + bulkUpdate("update ClsClass set studentCount = studentCount + 1 where deleteFlag is false and classId = ?", new Object[]{classId}); } save(student); @@ -83,7 +83,7 @@ public Result insertStudent(String classId, String name, String studentNo, boolean sex, String phoneNo, String orgId,String comName) { if (dao.exists(studentNo, orgId)) { - return new Result(false, "学号已存在"); + return new Result(false, "瀛﹀彿宸插瓨鍦�"); } User user = userService.insertUser(name, studentNo, phoneNo, "000000", sex, orgId); @@ -101,32 +101,32 @@ student.setSex(sex); student.setUserId(user.getUserId()); student.setMobilePhone(phoneNo); - //公司名称 + //鍏徃鍚嶇О student.setSubjectId(comName); if(StringUtils.isNoneBlank(classId)) { - bulkUpdate("update ClsClass set studentCount = studentCount + 1 where deleteFlag is false and classId = ?", new Object[]{classId}); + bulkUpdate("update ClsClass set studentCount = studentCount + 1 where deleteFlag is false and classId = ?", new Object[]{classId}); } save(student); return new Result(true, "success", CollectionUtils.newStringMap("studentId", student.getStudentId(), "password", user.getPassword())); } - @Override - public Result updateImgStudent(String studentId){ - //根据学学员ID,获取用户信息 - StuStudent stu = this.read(StuStudent.class, studentId); - stu.setTenantId("1"); - save(stu); - return new Result(true, "success"); - } - @Override + @Override + public Result updateImgStudent(String studentId){ + //鏍规嵁瀛﹀鍛業D锛岃幏鍙栫敤鎴蜂俊鎭� + StuStudent stu = this.read(StuStudent.class, studentId); + stu.setTenantId("1"); + save(stu); + return new Result(true, "success"); + } + @Override public Result updateStudent(String studentId, String name,String password, String studentNo, boolean sex, String phoneNo) { - //根据学学员ID,获取用户信息 + //鏍规嵁瀛﹀鍛業D锛岃幏鍙栫敤鎴蜂俊鎭� StuStudent stu = this.read(StuStudent.class, studentId); - if (!stu.getStudentNo().equals(studentNo) && dao.exists(studentNo,ClientUtils.getOrgId())) { - return new Result(false, "学号已存在"); + if (!stu.getStudentNo().equals(studentNo) && dao.exists(studentNo,ClientUtils.getOrgId())) { + return new Result(false, "瀛﹀彿宸插瓨鍦�"); } stu.setName(name); @@ -141,7 +141,7 @@ user.setSex(sex); user.setMobilePhone(phoneNo); if(!StringUtils.isEmpty(password)){ - user.setPassword(password); + user.setPassword(password); } user.setName(name); save(user); @@ -151,42 +151,42 @@ @Override public List<Map<String, Object>> getStudentLst(String classId, String keyword, Pager pager) { - QUser qUser = QUser.user; - QStuStudent qStuStudent = QStuStudent.stuStudent; - return this.getQueryFactory() - .select(qStuStudent.studentId, qStuStudent.name, qStuStudent.studentNo, qStuStudent.sex, - qStuStudent.mobilePhone, qStuStudent.status, qStuStudent.studyDuration, qStuStudent.tenantId, qStuStudent.score, - qUser.imgPath) - .from(qUser, qStuStudent) - .where(qUser.deleteFlag.isFalse().and(qUser.userId.eq(qStuStudent.userId)) - .and(qStuStudent.classId.eq(classId)).and(qStuStudent.name.like("%" + keyword + "%")).and(qStuStudent.deleteFlag.isFalse())) - .limit(pager.getPageSize()).offset(pager.getOffset()).orderBy(qStuStudent.createTime.desc()).fetch().stream().map(tuple -> { - Map<String, Object> map = new HashMap<String, Object>(); - map.put("studentId", tuple.get(qStuStudent.studentId)); - map.put("name", tuple.get(qStuStudent.name)); - map.put("studentNo", tuple.get(qStuStudent.studentNo)); - map.put("studentNumber", tuple.get(qStuStudent.studentNo)); - map.put("sex", tuple.get(qStuStudent.sex)); - map.put("mobilePhone", tuple.get(qStuStudent.mobilePhone)); - map.put("status", tuple.get(qStuStudent.status)); - map.put("studyDuration", tuple.get(qStuStudent.studyDuration)); - map.put("tenantId", tuple.get(qStuStudent.tenantId)); - map.put("score", tuple.get(qStuStudent.score)); - map.put("imgPath", tuple.get(qUser.imgPath)); - return map; - }).collect(Collectors.toList()); + QUser qUser = QUser.user; + QStuStudent qStuStudent = QStuStudent.stuStudent; + return this.getQueryFactory() + .select(qStuStudent.studentId, qStuStudent.name, qStuStudent.studentNo, qStuStudent.sex, + qStuStudent.mobilePhone, qStuStudent.status, qStuStudent.studyDuration, qStuStudent.tenantId, qStuStudent.score, + qUser.imgPath) + .from(qUser, qStuStudent) + .where(qUser.deleteFlag.isFalse().and(qUser.userId.eq(qStuStudent.userId)) + .and(qStuStudent.classId.eq(classId)).and(qStuStudent.name.like("%" + keyword + "%")).and(qStuStudent.deleteFlag.isFalse())) + .limit(pager.getPageSize()).offset(pager.getOffset()).orderBy(qStuStudent.createTime.desc()).fetch().stream().map(tuple -> { + Map<String, Object> map = new HashMap<String, Object>(); + map.put("studentId", tuple.get(qStuStudent.studentId)); + map.put("name", tuple.get(qStuStudent.name)); + map.put("studentNo", tuple.get(qStuStudent.studentNo)); + map.put("studentNumber", tuple.get(qStuStudent.studentNo)); + map.put("sex", tuple.get(qStuStudent.sex)); + map.put("mobilePhone", tuple.get(qStuStudent.mobilePhone)); + map.put("status", tuple.get(qStuStudent.status)); + map.put("studyDuration", tuple.get(qStuStudent.studyDuration)); + map.put("tenantId", tuple.get(qStuStudent.tenantId)); + map.put("score", tuple.get(qStuStudent.score)); + map.put("imgPath", tuple.get(qUser.imgPath)); + return map; + }).collect(Collectors.toList()); } @Override public int getStudentsCount(String classId, String keyword) { -// //TODO 判断是否为补考分组 +// //TODO 鍒ゆ柇鏄惁涓鸿ˉ鑰冨垎缁� // ClsClass cls = clsService.read(classId); // String hql=null; // if(cls!=null && cls.getClassTypes()!=null && "1".equals(cls.getClassTypes())){ -// //TODO 补考分组需要另一种查询学员 stu.tenantId = class.classId +// //TODO 琛ヨ�冨垎缁勯渶瑕佸彟涓�绉嶆煡璇㈠鍛� stu.tenantId = class.classId // hql = "from StuStudent where tenantId=:classId and name like :keyword and deleteFlag is false"; // }else { - String hql = "from StuStudent where classId=:classId and name like :keyword and deleteFlag is false"; + String hql = "from StuStudent where classId=:classId and name like :keyword and deleteFlag is false"; // } return findCountByComplexHql(hql, CollectionUtils.newObjectMap("classId", classId, "keyword", "%" + keyword + "%" )); @@ -205,14 +205,14 @@ private Result deleteStudent(String classId, String studentId) { StuStudent student = read(StuStudent.class, studentId); - User user = read(User.class, student.getUserId()); + User user = read(User.class, student.getUserId()); if (StuStudent.STATUS_ACTIVE.equals(student.getStatus())) { - return new Result(false, "已激活学员不能移除"); + return new Result(false, "宸叉縺娲诲鍛樹笉鑳界Щ闄�"); } TraceUtils.setUpdateTrace(student); student.setDeleteFlag(true); save(student); - deleteTrace(user); + deleteTrace(user); return new Result(true); } @@ -259,7 +259,7 @@ StuStudent student = read(StuStudent.class, studentId); if(student == null) { - return new Result(false, "未查询到学员信息"); + return new Result(false, "鏈煡璇㈠埌瀛﹀憳淇℃伅"); } return new Result(true, "success", CollectionUtils.newObjectMap("studentId", student.getStudentId(), "name", student.getName(), "status", @@ -277,13 +277,13 @@ } @Override public List<StuStudent> getStudentByclassId(String classId) { - QStuStudent qClassStudent=QStuStudent.stuStudent; - return new ArrayList<>(this.getQueryFactory() - .select(qClassStudent - ) - .from(qClassStudent) - .where(qClassStudent.classId.eq(classId)) - .fetch()); + QStuStudent qClassStudent=QStuStudent.stuStudent; + return new ArrayList<>(this.getQueryFactory() + .select(qClassStudent + ) + .from(qClassStudent) + .where(qClassStudent.classId.eq(classId)) + .fetch()); } @@ -293,45 +293,45 @@ @Override public Result studentProgress(String classId, String studentId) { - StuStudent student = read(StuStudent.class, studentId); - if(student == null) { - return new Result(false, "未查询到学员信息"); - } + StuStudent student = read(StuStudent.class, studentId); + if(student == null) { + return new Result(false, "鏈煡璇㈠埌瀛﹀憳淇℃伅"); + } - String userId = student.getUserId(); + String userId = student.getUserId(); - User u = this.read(User.class, userId); - if(u == null) { - return new Result(false, "未查询到用户信息"); - } + User u = this.read(User.class, userId); + if(u == null) { + return new Result(false, "鏈煡璇㈠埌鐢ㄦ埛淇℃伅"); + } - QSubjectProgressTreeV qSubjectProgressTreeV = QSubjectProgressTreeV.subjectProgressTreeV; + QSubjectProgressTreeV qSubjectProgressTreeV = QSubjectProgressTreeV.subjectProgressTreeV; - //班级进度 - SubjectProgressTreeV objSubjectProgressTreeV = this.getQueryFactory().selectFrom(qSubjectProgressTreeV).where(qSubjectProgressTreeV.id.nodeId.eq(classId).and(qSubjectProgressTreeV.id.userId.eq(userId))).fetchOne(); + //鐝骇杩涘害 + SubjectProgressTreeV objSubjectProgressTreeV = this.getQueryFactory().selectFrom(qSubjectProgressTreeV).where(qSubjectProgressTreeV.id.nodeId.eq(classId).and(qSubjectProgressTreeV.id.userId.eq(userId))).fetchOne(); - if(objSubjectProgressTreeV != null) { - //学员总数 - long studentCount = this.getQueryFactory().selectFrom(qSubjectProgressTreeV).where(qSubjectProgressTreeV.id.nodeId.eq(classId)).fetchCount(); + if(objSubjectProgressTreeV != null) { + //瀛﹀憳鎬绘暟 + long studentCount = this.getQueryFactory().selectFrom(qSubjectProgressTreeV).where(qSubjectProgressTreeV.id.nodeId.eq(classId)).fetchCount(); - // 当前学员排行 - long studentIndex = this - .getQueryFactory().selectFrom(qSubjectProgressTreeV).where(qSubjectProgressTreeV.id.nodeId - .eq(classId).and(qSubjectProgressTreeV.percent.gt(objSubjectProgressTreeV.getPercent()) - .or(qSubjectProgressTreeV.percent.eq(objSubjectProgressTreeV.getPercent())))) - .fetchCount(); + // 褰撳墠瀛﹀憳鎺掕 + long studentIndex = this + .getQueryFactory().selectFrom(qSubjectProgressTreeV).where(qSubjectProgressTreeV.id.nodeId + .eq(classId).and(qSubjectProgressTreeV.percent.gt(objSubjectProgressTreeV.getPercent()) + .or(qSubjectProgressTreeV.percent.eq(objSubjectProgressTreeV.getPercent())))) + .fetchCount(); - //学员的课程 - List<Map<String, Object>> lstSubject = this.subjectService.myClsSubjectlist(classId, userId, new Pager(Integer.MAX_VALUE, 0)); + //瀛﹀憳鐨勮绋� + List<Map<String, Object>> lstSubject = this.subjectService.myClsSubjectlist(classId, userId, new Pager(Integer.MAX_VALUE, 0)); - return new Result(true, "success", CollectionUtils.newObjectMap("studentId", student.getStudentId(), "name", student.getName(), "imgPath", u.getImgPath(), - "status", student.getStatus(), "studentNumber", student.getStudentNo(), "sex", student.getSex(), "mobilePhone", - student.getMobilePhone(), "subjectList", lstSubject, "studentCount", studentCount, "studentIndex", studentIndex, "studyDuration", objSubjectProgressTreeV.getProgressValue())); - }{ - return new Result(true, "success", CollectionUtils.newObjectMap("studentId", student.getStudentId(), "name", student.getName(), "imgPath", u.getImgPath(), - "status", student.getStatus(), "studentNumber", student.getStudentNo(), "sex", student.getSex(), "mobilePhone", - student.getMobilePhone(), "subjectList", new ArrayList<Map<String, Object>>(), "studentCount", 0, "studentIndex", 1, "studyDuration", 0)); - } + return new Result(true, "success", CollectionUtils.newObjectMap("studentId", student.getStudentId(), "name", student.getName(), "imgPath", u.getImgPath(), + "status", student.getStatus(), "studentNumber", student.getStudentNo(), "sex", student.getSex(), "mobilePhone", + student.getMobilePhone(), "subjectList", lstSubject, "studentCount", studentCount, "studentIndex", studentIndex, "studyDuration", objSubjectProgressTreeV.getProgressValue())); + }{ + return new Result(true, "success", CollectionUtils.newObjectMap("studentId", student.getStudentId(), "name", student.getName(), "imgPath", u.getImgPath(), + "status", student.getStatus(), "studentNumber", student.getStudentNo(), "sex", student.getSex(), "mobilePhone", + student.getMobilePhone(), "subjectList", new ArrayList<Map<String, Object>>(), "studentCount", 0, "studentIndex", 1, "studyDuration", 0)); + } } -- Gitblit v1.8.0