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