From fe0a4c0495cf9f1a65343158c2a8c2d4a163e045 Mon Sep 17 00:00:00 2001
From: qirong <2032486488@qq.com>
Date: 星期二, 28 十一月 2023 21:16:21 +0800
Subject: [PATCH] 优化查询
---
src/main/java/com/mindskip/xzs/controller/student/DashboardController.java | 8 +++-----
1 files changed, 3 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/mindskip/xzs/controller/student/DashboardController.java b/src/main/java/com/mindskip/xzs/controller/student/DashboardController.java
index 7ca8e44..a011aec 100644
--- a/src/main/java/com/mindskip/xzs/controller/student/DashboardController.java
+++ b/src/main/java/com/mindskip/xzs/controller/student/DashboardController.java
@@ -108,23 +108,21 @@
ExamTemplatesVO vo = new ExamTemplatesVO();
vo.setStatus("0");
+ vo.setUserId(user.getId());
List<ExamTemplates> gets = templatesMapper.gets(vo);
ExamTemplatesUserCountVO templatesUserCountVO = new ExamTemplatesUserCountVO();
templatesUserCountVO.setUserId(user.getId());
for (ExamTemplates get : gets) {
templatesUserCountVO.setId(get.getId());
- List<ExamTemplatesUser> byUserId = examTemplatesUserMapper.getByUserId(user.getId(), get.getId());
- if(byUserId.size()>0){
- List<ExamTemplatesUserCount> byUserIdAndTemplatesId = templatesUserCountMapper.getByUserIdAndTemplatesId(templatesUserCountVO);
- if(byUserIdAndTemplatesId.size()==0){
+ Integer number = templatesUserCountMapper.getCountByUserIdAndTemplatesId(templatesUserCountVO);
+ if(number==0){
PaperInfo info = new PaperInfo();
info.setId(get.getId());
info.setName(get.getName());
info.setStatus("1");
paperInfos.add(info);
}
- }
}
indexVM.setFixedPaper(paperInfos);
--
Gitblit v1.8.0