From 63639ada5b6fffa13e201fe143d328b465123890 Mon Sep 17 00:00:00 2001 From: liukangdong <898885815@qq.com> Date: 星期四, 16 五月 2024 11:04:05 +0800 Subject: [PATCH] Merge branch 'master' of http://139.186.142.91:10010/r/productDev/dmvisit --- server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java b/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java index cc0769d..e8e58bc 100644 --- a/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java +++ b/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java @@ -22,7 +22,7 @@ - @Select(" select a.id , b.`NAME` as roomName , a.`NAME` as meetingName ,date_format(a.START_TIME,'%Y-%m-%d') as meetingDate ," + + @Select(" select a.id , b.`NAME` as roomName , a.`NAME` as meetingName ,date_format(a.START_TIME,'%Y-%m-%d') as meetingDate , a.START_TIME as startTime, a.status ," + " CONCAT(date_format(a.START_TIME,'%H:%i') , ' ~ ',date_format(a.END_TIME,'%H:%i')) as meetingTime, c.REALNAME as bookingUser ," + " CASE WHEN a.START_TIME > now() and a.`STATUS` = 0 THEN 1 WHEN a.END_TIME < now() or a.`STATUS` = 1 THEN 3 ELSE 2 END meetingStatus , b.IMGURL as imgUrl " + " from meeting_book a inner join meeting_rooms b on a.ROOM_ID = b.ID " + -- Gitblit v1.9.3