| | |
| | | String meeting_room = fse.getString("meeting_room"); |
| | | String meeting_date = fse.getString("meeting_date"); |
| | | String meeting_date_end = fse.getString("meeting_date_end"); |
| | | String meeting_resource = fse.getString("meeting_resource"); |
| | | String replace_meeting_resource=""; |
| | | if(!StringUtils.isEmpty(meeting_resource)){ |
| | | |
| | | String[] split = meeting_resource.split(","); |
| | | for (int i = 0; i < split.length; i++) { |
| | | if(i!=split.length-1){ |
| | | replace_meeting_resource=replace_meeting_resource+"T1.meeting_resource like '%"+split[i]+"%' and "; |
| | | }else { |
| | | replace_meeting_resource=replace_meeting_resource+"T1.meeting_resource like '%"+split[i]+"%'"; |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | | |
| | | if(!StringUtils.isEmpty(meeting_room)&&!StringUtils.isEmpty(meeting_date)&&!StringUtils.isEmpty(meeting_date_end)){ |
| | | List<Object>param=new ArrayList<>(); |
| | | param.add(meeting_room); |
| | |
| | | sb.append(" ON T2.digit < ( length( T1.meeting_resource )- length( REPLACE ( T1.meeting_resource, ',', '' ))+ 1 )"); |
| | | sb.append(" WHERE T1.meeting_room = ? "); |
| | | sb.append(" and T1.start_time between ? and ? "); |
| | | if(!StringUtils.isEmpty(meeting_resource)){ |
| | | sb.append(" and ("+replace_meeting_resource+" )"); |
| | | } |
| | | sb.append(" ) a"); |
| | | sb.append(" LEFT JOIN product_sys_dict t ON a.type = t.dict_value "); |
| | | sb.append(" AND t.dict_name = '会议室资源'"); |