| | |
| | | String filter=" meeting_room = '"+fieldSetEntity.getString("meeting_room")+"' and DATE_FORMAT(start_time,\"%Y-%m-%d\") ='"+meeting_date+"'"; |
| | | DataTableEntity product_oa_conference_apply = baseDao.listTable("product_oa_conference_apply", filter, new Object[]{}); |
| | | for (int i1 = 0; i1 < product_oa_conference_apply.getRows(); i1++) { |
| | | FieldSetEntity fieldSetEntity1 = product_oa_conference_apply.getData().get(i); |
| | | FieldSetEntity fieldSetEntity1 = product_oa_conference_apply.getFieldSetEntity(i1); |
| | | Date date = new Date(); |
| | | if(date.before(fieldSetEntity1.getDate("start_time"))){ |
| | | fieldSetEntity1.setValue("status","未开始"); |
| | |
| | | }else { |
| | | fieldSetEntity1.setValue("status","会议中"); |
| | | } |
| | | |
| | | baseDao.executeUpdate("update product_oa_conference_apply set status='"+fieldSetEntity1.getString("status")+"' where uuid='"+fieldSetEntity1.getString("uuid")+"'"); |
| | | } |
| | | baseDao.update(product_oa_conference_apply); |
| | | //构造所需要的格式 |
| | | if(!list.contains(fieldSetEntity.getValue("room_name").toString())){ |
| | | HashMap<String,Object> hashMap=new HashMap<>(); |
| | |
| | | |
| | | } |
| | | HashMap<String,Object> hashMap=new HashMap<>(); |
| | | BaseUtil.createCreatorAndCreationTime(SpringMVCContextHolder.getCurrentUser(), fse); |
| | | if(flag==false){ |
| | | hashMap.put("code","200"); |
| | | hashMap.put("msg","此时间段已被占用"); |
| | |
| | | sql.append(" b.end_time, "); |
| | | } |
| | | sql.append(" b.flow_flag, "); |
| | | sql.append(" ( SELECT user_name FROM product_sys_users WHERE user_id = b.created_by ) proposer "); |
| | | sql.append(" FROM "); |
| | | sql.append(" ( SELECT user_name FROM product_sys_users WHERE user_id = b.created_by ) proposer "); |
| | | sql.append(" product_oa_CONFERENCE_room_config a "); |
| | | sql.append(" LEFT JOIN ( SELECT flow_flag,meeting_room,uuid,meeting_topic,start_time,end_time,created_by FROM "); |
| | | sql.append(" product_oa_conference_apply b WHERE "); |