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>"+