product-server-administration
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
18756
2024-09-02 00fa2194d460b9aec12750bd9381099036593fa3 
 src/main/java/com/product/administration/service/ConferenceManagerService.java


@@ -218,22 +218,32 @@




        List<Object>param=new ArrayList<>();


        String meeting_date= fse.getString("meeting_date");


        String meeting_date_end= fse.getString("meeting_date_end");


        String meeting_resource = fse.getString("meeting_resource");


        param.add(meeting_date);


        param.add(meeting_date_end);


        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(" SELECT DISTINCT y.*, g.room_name,g.uuid as meet_room_uuid ");


        bs.append(" FROM product_oa_conference_apply y");


        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(" SELECT DISTINCT  g.room_name,g.uuid as meet_room_uuid,DATE_FORMAT(y.start_time, \"%d-%m-%Y %H:%i\")  start_time_format,y.* ");


        bs.append(" FROM product_oa_conference_room_config g");


        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\") between  ? and ? ");


        if(!StringUtils.isEmpty(meeting_resource)){


            bs.append(" and  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());


@@ -256,40 +266,60 @@


                }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(!list.contains(fieldSetEntity.getValue("room_name").toString())){




            if(ObjectUtil.isNotEmpty(fieldSetEntity.getString("uuid"))){


                //构造所需要的格式


                if(!list.contains(fieldSetEntity.getValue("room_name").toString())){


                    HashMap<String,Object> hashMap=new HashMap<>();


                    hashMap.put("room_name",fieldSetEntity.getValue("room_name").toString());


                    hashMap.put("uuid",fieldSetEntity.getValue("meet_room_uuid").toString());


                    Object getStartTime = null;


                    for (int j = 0; j < dataTableEntity.getRows(); j++) {


                        FieldSetEntity fieldSetEntity1 = dataTableEntity.getFieldSetEntity(j);


                        if(fieldSetEntity1.getString("room_name").equals(hashMap.get("room_name"))){


                            getStartTime = fieldSetEntity1.getValue("start_time");


                            SimpleDateFormat dateFormat = new SimpleDateFormat("dd-MM-yyyy HH:mm");


                            String time = dateFormat.format(getStartTime);


                            hashMap.put("start_time",time);


                            break;


                        }




                    }


                    list.add(fieldSetEntity.getValue("room_name").toString());


                    listDate.add(hashMap);




                }


                fieldSetEntity.setValue("parent",fieldSetEntity.getValue("meet_room_uuid").toString());


                HashMap<String,Object> hashMap=new HashMap<>();


                hashMap.put("room_name",fieldSetEntity.getValue("room_name").toString());


                hashMap.put("uuid",fieldSetEntity.getValue("meet_room_uuid").toString());


                Object getStartTime = dataTableEntity.getData().get(0).getValue("start_time");


                SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");


                String time = dateFormat.format(getStartTime);


                hashMap.put("start_time",time);


                list.add(fieldSetEntity.getValue("room_name").toString());


                for (int j = 0; j < fieldSetEntity.getValues().keySet().size(); j++) {


                    if(fieldSetEntity.getValues().keySet().toArray()[j].toString().equals("start_time") || fieldSetEntity.getValues().keySet().toArray()[j].toString().equals("end_time")){


                        Object meeting_time = fieldSetEntity.getValue(fieldSetEntity.getValues().keySet().toArray()[j].toString());


                        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");


                        String time = dateFormat.format(meeting_time);


                        hashMap.put(fieldSetEntity.getValues().keySet().toArray()[j].toString(),time);


                        if(fieldSetEntity.getValues().keySet().toArray()[j].equals("start_time")){


                            hashMap.put("start_date",time);


                        }else {


                            hashMap.put("end_date",time);


                        }


                    }else {


                        hashMap.put(fieldSetEntity.getValues().keySet().toArray()[j].toString(),fieldSetEntity.getValue(fieldSetEntity.getValues().keySet().toArray()[j].toString()));


                    }




                }


                listDate.add(hashMap);




            }


            fieldSetEntity.setValue("parent",fieldSetEntity.getValue("meet_room_uuid").toString());


            HashMap<String,Object> hashMap=new HashMap<>();


            for (int j = 0; j < fieldSetEntity.getValues().keySet().size(); j++) {


                if(fieldSetEntity.getValues().keySet().toArray()[j].toString().equals("start_time") || fieldSetEntity.getValues().keySet().toArray()[j].toString().equals("end_time")){


                    Object meeting_time = fieldSetEntity.getValue(fieldSetEntity.getValues().keySet().toArray()[j].toString());


                    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");


                    String time = dateFormat.format(meeting_time);


                    hashMap.put(fieldSetEntity.getValues().keySet().toArray()[j].toString(),time);


                    if(fieldSetEntity.getValues().keySet().toArray()[j].equals("start_time")){


                        hashMap.put("start_date",time);


                    }else {


                        hashMap.put("end_date",time);


                    }


                }else {


                    hashMap.put(fieldSetEntity.getValues().keySet().toArray()[j].toString(),fieldSetEntity.getValue(fieldSetEntity.getValues().keySet().toArray()[j].toString()));


            }else {


                if(!list.contains(fieldSetEntity.getValue("room_name").toString())){


                    HashMap<String,Object> hashMap=new HashMap<>();


                    hashMap.put("room_name",fieldSetEntity.getValue("room_name").toString());


                    hashMap.put("uuid",fieldSetEntity.getValue("meet_room_uuid").toString());


                    list.add(fieldSetEntity.getValue("room_name").toString());


                    listDate.add(hashMap);


                }




            }


            listDate.add(hashMap);




        }


        return  listDate;


@@ -299,15 +329,17 @@


    public List getMeetingDetails(FieldSetEntity fse) throws BaseException {


        String meeting_room = fse.getString("meeting_room");


        String meeting_date = fse.getString("meeting_date");


        if(!StringUtils.isEmpty(meeting_room)&&!StringUtils.isEmpty(meeting_date)){


        String meeting_date_end = fse.getString("meeting_date_end");


        if(!StringUtils.isEmpty(meeting_room)&&!StringUtils.isEmpty(meeting_date)&&!StringUtils.isEmpty(meeting_date_end)){


            List<Object>param=new ArrayList<>();


            param.add(meeting_room);


            param.add(meeting_date);


            param.add(meeting_date_end);


            StringBuilder sb=new StringBuilder();


            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 b.uuid,DATE_FORMAT(b.start_time, \"%Y-%m-%d\")  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,");


            sb.append(" CONCAT(DATE_FORMAT(b.start_time,\"%H:%i\"),'~',DATE_FORMAT(b.end_time,\"%H:%i\"))  as time_quantum,");


            sb.append(" DATE_FORMAT(b.start_time,\"%Y-%m-%d\") as meeting_date,");


            sb.append(" GROUP_CONCAT(b.dict_label   SEPARATOR ',') AS meeting_resouces ");


            sb.append(" FROM (");


@@ -319,7 +351,7 @@


            sb.append(" LEFT JOIN ( SELECT 0 AS digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 ) T2");


            sb.append(" ON T2.digit < ( length( T1.meeting_resource )- length( REPLACE ( T1.meeting_resource, ',', '' ))+ 1 )");


            sb.append(" WHERE T1.meeting_room = ? ");


            sb.append(" and DATE_FORMAT(T1.start_time,\"%Y-%m-%d\")=? ");


            sb.append(" and DATE_FORMAT(T1.start_time,\"%Y-%m-%d\") between ? and ? ");


            sb.append(" ) a");


            sb.append(" LEFT JOIN product_sys_dict t ON a.type = t.dict_value ");


            sb.append(" AND t.dict_name = '会议室资源'");


@@ -612,9 +644,13 @@




        String meeting_uuid= fse.getString("meeting_uuid");


        String type = fse.getString("type");


        String user_ids = fse.getString("user_ids");




        FieldSetEntity product_oa_conference_apply = baseDao.getFieldSetEntity("product_oa_conference_apply", meeting_uuid, false);




        List<Object> params=new ArrayList<>();




        //此方式是根据后台自动统计未访问人员


       /* List<Object> params=new ArrayList<>();


        params.add(meeting_uuid);


        params.add(meeting_uuid);




@@ -660,7 +696,7 @@


                user_ids=user_ids+fieldSetEntity.getString("staff_id")+",";


            }




        }


        }*/


        String content="";


        if(type.equals("1")){


            content="会议将开始签到,"+product_oa_conference_apply.getString("meeting_topic")+"-"+product_oa_conference_apply.getString("start_time")+",请按时签到";


@@ -670,7 +706,7 @@


        SystemUser currentUser = SpringMVCContextHolder.getCurrentUser();


        int user_id = currentUser.getUser_id();


        String send_user=user_id+"";


        String reminder_mode = product_oa_conference_apply.getString("reminder_mode");


        //String reminder_mode = product_oa_conference_apply.getString("reminder_mode");


     /*   //短信


        if(reminder_mode.equals("0")){


        }