From 06dc2c181c8c4fc55a646964425e1dd44d7e2ce7 Mon Sep 17 00:00:00 2001
From: 18756 <1875631620@qq.com>
Date: 星期五, 16 八月 2024 15:58:41 +0800
Subject: [PATCH] 会议室看板8.16-2
---
src/main/java/com/product/administration/service/ConferenceManagerService.java | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/product/administration/service/ConferenceManagerService.java b/src/main/java/com/product/administration/service/ConferenceManagerService.java
index fc520c9..024e4d1 100644
--- a/src/main/java/com/product/administration/service/ConferenceManagerService.java
+++ b/src/main/java/com/product/administration/service/ConferenceManagerService.java
@@ -206,6 +206,8 @@
List<Object>param=new ArrayList<>();
String meeting_date = fse.getValue("meeting_date").toString();
String meeting_resource = fse.getValue("meeting_resource").toString();
+ String replace_meeting_resource = meeting_resource.replace(",", "%");
+ meeting_resource="%"+replace_meeting_resource+"%";
param.add(meeting_date);
param.add(meeting_resource);
StringBuilder bs=new StringBuilder();
@@ -213,8 +215,8 @@
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(start_time,\"%Y-%m-%d\")=?");
- bs.append(" and meeting_resource in ( ? )");
+ bs.append(" where DATE_FORMAT(y.start_time,\"%Y-%m-%d\")=?");
+ bs.append(" and y.meeting_resource like ? ");
DataTableEntity dataTableEntity = baseDao.listTable(bs.toString(), param.toArray());
List<String> list=new ArrayList();
List<HashMap> listDate=new ArrayList<>();
--
Gitblit v1.9.2