From 6f1203d1cf895efc473fade3ab049fc30d92c618 Mon Sep 17 00:00:00 2001 From: MrShi <1878285526@qq.com> Date: 星期三, 26 三月 2025 16:48:23 +0800 Subject: [PATCH] 优化 --- server/system_service/src/main/java/com/doumee/core/utils/Constants.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/server/system_service/src/main/java/com/doumee/core/utils/Constants.java b/server/system_service/src/main/java/com/doumee/core/utils/Constants.java index 95c9d88..4b0a54c 100644 --- a/server/system_service/src/main/java/com/doumee/core/utils/Constants.java +++ b/server/system_service/src/main/java/com/doumee/core/utils/Constants.java @@ -726,7 +726,7 @@ "meeting_user_rel ur\n" + "LEFT JOIN `SYSTEM_USER` su ON ur.USER_ID = su.id \n" + "LEFT JOIN meeting_book b ON ur.OBJ_ID = b.id \n" + - "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS = 0" + + "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) and b.isdeleted=0" + "<if test='userId != null'>"+ "and ur.USER_ID = #{userId}\n" + "</if>"+ -- Gitblit v1.9.3