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 | 4 +++- 1 files changed, 3 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/product/administration/service/ConferenceManagerService.java b/src/main/java/com/product/administration/service/ConferenceManagerService.java index 7221351..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(); @@ -214,7 +216,7 @@ 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(" and LOCATE(?, g.enable_seal)"); + 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