| | |
| | | String meeting_date= fse.getString("meeting_date"); |
| | | String meeting_resource = fse.getString("meeting_resource"); |
| | | param.add(meeting_date); |
| | | String replace_meeting_resource=""; |
| | | if(!StringUtils.isEmpty(meeting_resource)){ |
| | | String replace_meeting_resource = meeting_resource.replace(",", "%"); |
| | | meeting_resource="%"+replace_meeting_resource+"%"; |
| | | param.add(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+"y.meeting_resource like '%"+split[i]+"%' and "; |
| | | }else { |
| | | replace_meeting_resource=replace_meeting_resource+"y.meeting_resource like '%"+split[i]+"%'"; |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | | |
| | | StringBuilder bs=new StringBuilder(); |
| | |
| | | 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(" where y.meeting_resource like ? "); |
| | | bs.append(" where ( "+replace_meeting_resource+" )"); |
| | | } |
| | | bs.append(" ORDER BY y.start_time"); |
| | | DataTableEntity dataTableEntity = baseDao.listTable(bs.toString(), param.toArray()); |
| | |
| | | }else { |
| | | fieldSetEntity1.setValue("status","会议中"); |
| | | } |
| | | baseDao.executeUpdate("update product_oa_conference_apply set status='"+fieldSetEntity1.getString("status")+"' where uuid='"+fieldSetEntity1.getString("uuid")+"'"); |
| | | baseDao.executeUpdate("update product_oa_conference_apply set status='"+fieldSetEntity1.getString("status")+"' where uuid='"+fieldSetEntity1.getString("uuid")+"'"); |
| | | } |
| | | |
| | | if(ObjectUtil.isNotEmpty(fieldSetEntity.getString("uuid"))){ |