| | |
| | | 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(); |
| | |
| | | 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<>(); |