From 09a7c021d02ef10d86c9df5e5f395dc336e98d12 Mon Sep 17 00:00:00 2001 From: 18756 <1875631620@qq.com> Date: 星期四, 22 八月 2024 17:50:01 +0800 Subject: [PATCH] 会议室功能优化8.22-2 --- src/main/java/com/product/administration/service/ConferenceManagerService.java | 13 ++++++------- 1 files changed, 6 insertions(+), 7 deletions(-) diff --git a/src/main/java/com/product/administration/service/ConferenceManagerService.java b/src/main/java/com/product/administration/service/ConferenceManagerService.java index 8764512..23a19b0 100644 --- a/src/main/java/com/product/administration/service/ConferenceManagerService.java +++ b/src/main/java/com/product/administration/service/ConferenceManagerService.java @@ -227,13 +227,12 @@ } StringBuilder bs=new StringBuilder(); - bs.append(" SELECT DISTINCT y.*, g.room_name,g.uuid as meet_room_uuid "); - bs.append(" FROM product_oa_conference_apply y"); - bs.append(" left JOIN product_oa_conference_room_config g "); - bs.append(" on y.meeting_room=g.uuid "); - bs.append(" where DATE_FORMAT(y.start_time,\"%Y-%m-%d\")=?"); + bs.append(" SELECT DISTINCT g.room_name,g.uuid as meet_room_uuid,y.* "); + bs.append(" FROM product_oa_conference_room_config g"); + bs.append(" left JOIN product_oa_conference_apply y "); + bs.append(" on y.meeting_room=g.uuid and DATE_FORMAT(y.start_time,\"%Y-%m-%d\")=? "); if(!StringUtils.isEmpty(meeting_resource)){ - bs.append(" and y.meeting_resource like ? "); + bs.append(" where y.meeting_resource like ? "); } bs.append(" ORDER BY y.start_time"); DataTableEntity dataTableEntity = baseDao.listTable(bs.toString(), param.toArray()); @@ -674,7 +673,7 @@ SystemUser currentUser = SpringMVCContextHolder.getCurrentUser(); int user_id = currentUser.getUser_id(); String send_user=user_id+""; - String reminder_mode = product_oa_conference_apply.getString("reminder_mode"); + //String reminder_mode = product_oa_conference_apply.getString("reminder_mode"); /* //鐭俊 if(reminder_mode.equals("0")){ } -- Gitblit v1.9.2