| | |
| | | param.add(meeting_room); |
| | | param.add(meeting_date); |
| | | StringBuilder sb=new StringBuilder(); |
| | | sb.append(" SELECT b.uuid,b.start_time,b.end_time,b.meeting_topic,b.status, "); |
| | | sb.append(" SELECT b.uuid,b.start_time,b.end_time,b.meeting_topic,b.status,b.record_man as record_man_uuid, "); |
| | | sb.append(" (select user_name from product_sys_users where user_id=b.record_man) as record_man,"); |
| | | sb.append(" (select user_name from product_sys_users where user_id=b.record_master) as record_master,"); |
| | | sb.append(" CONCAT(DATE_FORMAT(b.start_time,\"%H-%i-%S\"),'~',DATE_FORMAT(b.end_time,\"%H-%i-%S\")) as time_quantum,"); |
| | |
| | | String end_time_date = dateFormat.format(end_time); |
| | | MapValues.put("start_time",start_time_date); |
| | | MapValues.put("end_time",end_time_date); |
| | | } |
| | | |
| | | Date date = new Date(); |
| | | //是否能够取消 |
| | | if(date.before(fieldSetEntity.getDate("start_time"))){ |
| | | MapValues.put("isCancel",true); |
| | | } |
| | | //是否执行开启功能 |
| | | if(date.before(fieldSetEntity.getDate("start_time")) && fieldSetEntity.getString("status").equals("已取消")){ |
| | | MapValues.put("isStart",true); |
| | | } |
| | | dataList.add(MapValues); |
| | | } |
| | |
| | | |
| | | BitMatrix bitMatrix = null; |
| | | try { |
| | | //生成矩阵,因为我的业务场景传来的是编码之后的URL,所以先解码 |
| | | |
| | | bitMatrix = new MultiFormatWriter().encode(content, |
| | | BarcodeFormat.QR_CODE, width, height, hints); |
| | | |
| | | |
| | | } catch (WriterException e) { |
| | | e.printStackTrace(); |
| | | } |
| | |
| | | return bitMatrix; |
| | | } |
| | | |
| | | @Override |
| | | public void CancelAndStart(FieldSetEntity fse) throws BaseException { |
| | | |
| | | String uuid = fse.getString("uuid"); |
| | | String filter=" uuid='"+uuid+"'"; |
| | | DataTableEntity product_oa_conference_apply = baseDao.listTable("product_oa_conference_apply", filter, new Object[]{}); |
| | | if(product_oa_conference_apply.getRows()!=0){ |
| | | FieldSetEntity fieldSetEntity = product_oa_conference_apply.getFieldSetEntity(0); |
| | | if(fieldSetEntity.getString("status").equals("已取消")){ |
| | | fieldSetEntity.setValue("status","已启用"); |
| | | }else { |
| | | fieldSetEntity.setValue("status","已取消"); |
| | | } |
| | | baseDao.update(fieldSetEntity); |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | /** |
| | |
| | | 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 "); |