From c97ae0369607c7091041273012b291d3b6e6bdc1 Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期一, 25 八月 2025 10:10:01 +0800 Subject: [PATCH] 迭代代码 --- ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/controller/TStudyController.java | 176 +++++++++++++++++++++++++++++++++------------------------- 1 files changed, 99 insertions(+), 77 deletions(-) diff --git a/ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/controller/TStudyController.java b/ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/controller/TStudyController.java index c76eac0..b6cf51a 100644 --- a/ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/controller/TStudyController.java +++ b/ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/controller/TStudyController.java @@ -198,12 +198,17 @@ List<Integer> collect2 = categoryService.lambdaQuery().eq(TCategory::getState, 1) .eq(TCategory::getType, 2) .like(TCategory::getName, query.getCategoryName()).list() - .stream().map(TCategory::getParentId).collect(Collectors.toList()); + .stream().map(TCategory::getId).collect(Collectors.toList()); collect.addAll(collect2); - if (collect.isEmpty()) { - collect.add(-1); + if (collect2.isEmpty()) { + if (collect.isEmpty()) { + collect.add(-1); + } + wrapper.in("firstCategory", collect); + }else{ + wrapper.in("secondCategory", collect2); } - wrapper.in("firstCategory", collect); + } if (StringUtils.hasLength(query.getEnglish())) { wrapper.like("english", query.getEnglish()); @@ -211,15 +216,15 @@ if (StringUtils.hasLength(query.getType())) { wrapper.like("type", query.getType()); } + List<TCategory> list5 = categoryService.list(); wrapper.eq("state", 1); + List<TSubject> list = subjectService.list(wrapper); + switch (query.getStudyType()) { case 1: - List<TSubject> list = subjectService.list(wrapper); for (TSubject tSubject : list) { - TCategory first = categoryService.getById(tSubject.getFirstCategory()); - - TCategory second = categoryService.getById(tSubject.getSecondCategory()); - + TCategory first = list5.stream().filter(e->e.getId().equals(tSubject.getFirstCategory())).findFirst().orElse(null); + TCategory second = list5.stream().filter(e->e.getId().equals(tSubject.getSecondCategory())).findFirst().orElse(null); if (first != null && second != null) { tSubject.setCategoryName(first.getName() + "-" + second.getName()); } @@ -233,9 +238,8 @@ List<TSubject> list1 = subjectService.list(wrapper); List<TSubject> tSubjects = new ArrayList<>(); for (TSubject tSubject : list1) { - TCategory first = categoryService.getById(tSubject.getFirstCategory()); - - TCategory second = categoryService.getById(tSubject.getSecondCategory()); + TCategory first = list5.stream().filter(e->e.getId().equals(tSubject.getFirstCategory())).findFirst().orElse(null); + TCategory second = list5.stream().filter(e->e.getId().equals(tSubject.getSecondCategory())).findFirst().orElse(null); if (first != null && second != null) { tSubject.setCategoryName(first.getName() + "-" + second.getName()); @@ -250,8 +254,8 @@ case 3: List<TSubject> list2 = subjectService.list(wrapper); for (TSubject tSubject : list2) { - TCategory first = categoryService.getById(tSubject.getFirstCategory()); - TCategory second = categoryService.getById(tSubject.getSecondCategory()); + TCategory first = list5.stream().filter(e->e.getId().equals(tSubject.getFirstCategory())).findFirst().orElse(null); + TCategory second = list5.stream().filter(e->e.getId().equals(tSubject.getSecondCategory())).findFirst().orElse(null); if (first != null && second != null) { tSubject.setCategoryName(first.getName() + "-" + second.getName()); @@ -266,9 +270,8 @@ List<TSubject> list3 = subjectService.list(wrapper); List<TSubject> tSubjects3 = new ArrayList<>(); for (TSubject tSubject : list3) { - TCategory first = categoryService.getById(tSubject.getFirstCategory()); - - TCategory second = categoryService.getById(tSubject.getSecondCategory()); + TCategory first = list5.stream().filter(e->e.getId().equals(tSubject.getFirstCategory())).findFirst().orElse(null); + TCategory second = list5.stream().filter(e->e.getId().equals(tSubject.getSecondCategory())).findFirst().orElse(null); if (first != null && second != null) { tSubject.setCategoryName(first.getName() + "-" + second.getName()); } @@ -282,9 +285,8 @@ case 5: List<TSubject> list4 = subjectService.list(wrapper); for (TSubject tSubject : list4) { - TCategory first = categoryService.getById(tSubject.getFirstCategory()); - - TCategory second = categoryService.getById(tSubject.getSecondCategory()); + TCategory first = list5.stream().filter(e->e.getId().equals(tSubject.getFirstCategory())).findFirst().orElse(null); + TCategory second = list5.stream().filter(e->e.getId().equals(tSubject.getSecondCategory())).findFirst().orElse(null); if (first != null && second != null) { tSubject.setCategoryName(first.getName() + "-" + second.getName()); } @@ -319,6 +321,7 @@ studyService.updateById(one); GameDTO game = dto.getGame(); StoryListenDTO storyListen = dto.getStoryListen(); + System.err.println("学习配置"+dto); if (day == 6) { // 先判断有没有配置 TGame studyId = gameService.getOne(new QueryWrapper<TGame>() @@ -419,6 +422,15 @@ storyListenService.save(tStoryListen); } } else { + List<Integer> ids = studyListenService.lambdaQuery().eq(TStudyListen::getId, one.getId()) + .eq(TStudyListen::getWeek, week) + .eq(TStudyListen::getDay, day).list().stream().map(TStudyListen::getId).collect(Collectors.toList()); + for (Integer id : ids) { + subjectRecordDetailService.remove(new LambdaQueryWrapper<TSubjectRecordDetail>() + .eq(TSubjectRecordDetail::getObjectId, id) + .eq(TSubjectRecordDetail::getWeek, week) + .eq(TSubjectRecordDetail::getType, 1)); + } // 删除原有数据 studyListenService.remove(new QueryWrapper<TStudyListen>() .eq("studyId", one.getId()) @@ -435,6 +447,15 @@ tStudyListen.setIsVip(studyListenDTO.getIsVip()); tStudyListen.setRate(dto.getListenRate()); studyListenService.save(tStudyListen); + } + List<Integer> ids1 = studyLookService.lambdaQuery().eq(TStudyLook::getId, one.getId()) + .eq(TStudyLook::getWeek, week) + .eq(TStudyLook::getDay, day).list().stream().map(TStudyLook::getId).collect(Collectors.toList()); + for (Integer id : ids1) { + subjectRecordDetailService.remove(new LambdaQueryWrapper<TSubjectRecordDetail>() + .eq(TSubjectRecordDetail::getObjectId, id) + .eq(TSubjectRecordDetail::getWeek, week) + .eq(TSubjectRecordDetail::getType, 2)); } studyLookService.remove(new QueryWrapper<TStudyLook>() .eq("studyId", one.getId()) @@ -454,6 +475,15 @@ studyLookService.save(tStudyLook); } + List<Integer> ids2 = studyInductionService.lambdaQuery().eq(TStudyInduction::getId, one.getId()) + .eq(TStudyInduction::getWeek, week) + .eq(TStudyInduction::getDay, day).list().stream().map(TStudyInduction::getId).collect(Collectors.toList()); + for (Integer id : ids2) { + subjectRecordDetailService.remove(new LambdaQueryWrapper<TSubjectRecordDetail>() + .eq(TSubjectRecordDetail::getObjectId, id) + .eq(TSubjectRecordDetail::getWeek, week) + .eq(TSubjectRecordDetail::getType, 3)); + } studyInductionService.remove(new QueryWrapper<TStudyInduction>() .eq("studyId", one.getId()) .eq("week", week) @@ -471,6 +501,15 @@ tStudyInduction.setIsVip(studyInductionDTO.getIsVip()); studyInductionService.save(tStudyInduction); } + List<Integer> ids3 = studyAnswerService.lambdaQuery().eq(TStudyAnswer::getId, one.getId()) + .eq(TStudyAnswer::getWeek, week) + .eq(TStudyAnswer::getDay, day).list().stream().map(TStudyAnswer::getId).collect(Collectors.toList()); + for (Integer id : ids3) { + subjectRecordDetailService.remove(new LambdaQueryWrapper<TSubjectRecordDetail>() + .eq(TSubjectRecordDetail::getObjectId, id) + .eq(TSubjectRecordDetail::getWeek, week) + .eq(TSubjectRecordDetail::getType, 4)); + } studyAnswerService.remove(new QueryWrapper<TStudyAnswer>() .eq("studyId", one.getId()) .eq("week", week) @@ -486,9 +525,17 @@ tStudyAnswer.setIntegral(studyAnswerDTO.getIntegral()); tStudyAnswer.setWeek(week); tStudyAnswer.setRate(dto.getAnswerRate()); - tStudyAnswer.setIsVip(studyAnswerDTO.getIsVip()); studyAnswerService.save(tStudyAnswer); + } + List<Integer> ids4 = studyPairService.lambdaQuery().eq(TStudyPair::getId, one.getId()) + .eq(TStudyPair::getWeek, week) + .eq(TStudyPair::getDay, day).list().stream().map(TStudyPair::getId).collect(Collectors.toList()); + for (Integer id : ids4) { + subjectRecordDetailService.remove(new LambdaQueryWrapper<TSubjectRecordDetail>() + .eq(TSubjectRecordDetail::getObjectId, id) + .eq(TSubjectRecordDetail::getWeek, week) + .eq(TSubjectRecordDetail::getType, 5)); } studyPairService.remove(new QueryWrapper<TStudyPair>() .eq("studyId", one.getId()) @@ -1001,6 +1048,24 @@ Integer userid = loginStudy.getUserid(); TUserStudy studyRecord = userStudyService.lambdaQuery().eq(TUserStudy::getUserId, loginStudy.getUserid()) .eq(TUserStudy::getDisabled, 0).one(); + TStudy study = studyService.lambdaQuery().eq(TStudy::getWeek, week).one(); + if (study.getQuarter()!=1){ + // 判断上季度 通关率 + String quarterRate = study.getQuarterRate(); + BigDecimal bigDecimal = new BigDecimal(quarterRate); + // 查询五个自主学习通关率 + List<TSubjectRecordDetail> list = subjectRecordDetailService.lambdaQuery().eq(TSubjectRecordDetail::getWeek, week) + .eq(TSubjectRecordDetail::getUserId, userid).list(); + List<TSubjectRecordDetail> pass = list.stream().filter(e -> e.getStatus() == 2).collect(Collectors.toList()); + if (list.isEmpty()){ + return R.fail("上季度未达到通关率"+quarterRate+"%,当前通关率0%"); + } + BigDecimal divide = new BigDecimal(pass.size()).divide(new BigDecimal(list.size()), 2, RoundingMode.HALF_UP); + if (divide.compareTo(bigDecimal)<1){ + return R.fail("上季度未达到通关率"+quarterRate+"%,当前通关率"+divide.multiply(new BigDecimal(100))+"%"); + } + + } if (null != studyRecord) { // 计算当前周 day 1-5的总进度 int computeSchedule = studyService.computeSchedule(studyRecord, week); @@ -1040,58 +1105,6 @@ if (listen != 100 && listen != -1) { studyRecord.setListen(100 - listen); } -// // 自主学习答题记录 查询通关率 -// List<TSubjectRecordDetail> list = subjectRecordDetailService.lambdaQuery().eq(TSubjectRecordDetail::getUserId, userid) -// .eq(TSubjectRecordDetail::getWeek, week).ne(BaseModel::getDisabled, 0).list(); -// List<TSubjectRecordDetail> listenList = list.stream().filter(e -> e.getType() == 1).collect(Collectors.toList()); -// int listenPass = (int) listenList.stream().filter(e -> e.getStatus() == 2).count(); -// List<TSubjectRecordDetail> lookList = list.stream().filter(e -> e.getType() == 2).collect(Collectors.toList()); -// int lookPass = (int) lookList.stream().filter(e -> e.getStatus() == 2).count(); -// List<TSubjectRecordDetail> inductionList = list.stream().filter(e -> e.getType() == 3).collect(Collectors.toList()); -// int inductionPass = (int) inductionList.stream().filter(e -> e.getStatus() == 2).count(); -// List<TSubjectRecordDetail> answerList = list.stream().filter(e -> e.getType() == 4).collect(Collectors.toList()); -// int answerPass = (int) answerList.stream().filter(e -> e.getStatus() == 2).count(); -// List<TSubjectRecordDetail> pairList = list.stream().filter(e -> e.getType() == 5).collect(Collectors.toList()); -// int pairPass = (int) pairList.stream().filter(e -> e.getStatus() == 2).count(); -// int listenSize = listenList.size(); -// if (listenSize!=0){ -// double listenRate = (double) listenPass /listenSize; -// studyRecord.setListen((int)listenRate); -// }else{ -// studyRecord.setListen(-1); -// } -// int lookSize = lookList.size(); -// if (lookSize!=0) { -// double lookRate = (double) lookPass / lookSize; -// studyRecord.setLook((int) lookRate); -// }else{ -// studyRecord.setLook(-1); -// } -// int inductionSize = inductionList.size(); -// -// if (inductionSize!=0) { -// double inductionRate = (double) inductionPass /inductionSize; -// studyRecord.setInduction((int)inductionRate); -// }else{ -// studyRecord.setInduction(-1); -// } -// -// int answerSize = answerList.size(); -// if (answerSize!=0) { -// double answerRate = (double) answerPass /answerSize; -// studyRecord.setAnswer((int)answerRate); -// }else{ -// studyRecord.setAnswer(-1); -// } -// -// int pairSize = pairList.size(); -// if (pairSize!=0) { -// double pairRate = (double) pairPass /pairSize; -// studyRecord.setPair((int)pairRate); -// }else{ -// studyRecord.setPair(-1); -// } - } return R.ok(studyRecord); } @@ -1535,6 +1548,7 @@ if (null == userStudy) { return R.tokenError("登录失效!"); } + System.err.println("答题DTO"+answerQuestionDTO); TSubjectRecordDetail byId = subjectRecordDetailService.getById(answerQuestionDTO.getId()); byId.setUserId(null); byId.setStatus(answerQuestionDTO.getStatus()); @@ -1669,7 +1683,7 @@ return R.tokenError("登录失效!"); } List<TSubjectRecordDetail> subjectRecordDetails = subjectRecordDetailService.lambdaQuery().eq(TSubjectRecordDetail::getUserId, userStudy.getUserid()) - .eq(TSubjectRecordDetail::getWeek, week).ne(BaseModel::getDisabled, 0).list(); + .eq(TSubjectRecordDetail::getWeek, week).eq(BaseModel::getDisabled, 0).list(); List<TSubjectRecordDetail> listenList = subjectRecordDetails.stream().filter(e -> e.getType() == 5).collect(Collectors.toList()); int listenPass = (int) listenList.stream().filter(e -> e.getStatus() == 2).count(); int listenSize = listenList.size(); @@ -1681,7 +1695,7 @@ .eq(TStudyPair::getDay, 5).last("limit 1").one(); if (one!=null){ if (listenRate<(Double.parseDouble(one.getRate())/100)){ - return R.fail("音图相配未达到通关率"+one.getRate()+"%,"+"当前通关率:"+divide+"%"); + return R.fail("音图相配未达到通关率"+one.getRate()+"%,"+"当前通关率:"+divide.multiply(new BigDecimal(100))+"%"); } } } @@ -1732,7 +1746,7 @@ return R.tokenError("登录失效!"); } List<TSubjectRecordDetail> subjectRecordDetails = subjectRecordDetailService.lambdaQuery().eq(TSubjectRecordDetail::getUserId, userStudy.getUserid()) - .eq(TSubjectRecordDetail::getWeek, week).ne(BaseModel::getDisabled, 0).list(); + .eq(TSubjectRecordDetail::getWeek, week).eq(BaseModel::getDisabled, 0).list(); List<TSubjectRecordDetail> listenList = subjectRecordDetails.stream().filter(e -> e.getType() == 5).collect(Collectors.toList()); int listenPass = (int) listenList.stream().filter(e -> e.getStatus() == 2).count(); int listenSize = listenList.size(); @@ -1744,7 +1758,7 @@ .eq(TStudyPair::getDay, 5).last("limit 1").one(); if (one!=null){ if (listenRate<(Double.parseDouble(one.getRate())/100)){ - return R.fail("音图相配未达到通关率"+one.getRate()+"%,"+"当前通关率:"+divide+"%"); + return R.fail("音图相配未达到通关率"+one.getRate()+"%,"+"当前通关率:"+divide.multiply(new BigDecimal(100))+"%"); } } } @@ -1762,6 +1776,8 @@ photoList.add(new GameMemoryPhotoVO(tSubject.getId(), tSubject.getImg())); voiceList.add(new GameMemoryVoiceVO(tSubject.getId(), tSubject.getCorrect())); } + photoList = photoList.stream().distinct().collect(Collectors.toList()); + voiceList = voiceList.stream().distinct().collect(Collectors.toList()); // 校验超级听力是否通过 // studyService.checkClearance(game,userStudy.getUserid()); // 框架记忆数量翻倍,前端需要根据数量画格子 @@ -1980,6 +1996,9 @@ public R<StudyStoryListenResultVO> lookPictureDbu(@RequestParam Integer quarter, @RequestParam Integer week) { // 看图配音信息 TStoryListen storyListen = storyListenService.storyDetail(quarter, week); + if (storyListen==null){ + return R.fail("当前未配置看图配音信息"); + } // 题组信息 StudyStoryVO studyStory = new StudyStoryVO(); studyStory.setId(storyListen.getId()); @@ -2003,6 +2022,9 @@ public R<StudyStoryListenResultVO> frameworkMemory(@RequestParam Integer quarter, @RequestParam Integer week) { // 看图配音信息 TStoryListen storyListen = storyListenService.storyDetail(quarter, week); + if (storyListen==null){ + return R.fail("当前未配置框架记忆信息"); + } // 题组信息 StudyStoryVO studyStory = new StudyStoryVO(); studyStory.setId(storyListen.getId()); -- Gitblit v1.7.1