会议室看板8.16-3

18756

2024-08-16 babe9c186f77b41bef3721a49262ab1a6ee41529

 src/main/java/com/product/administration/service/ConferenceManagerService.java

@@ -204,17 +204,24 @@
    public List getKbData(FieldSetEntity fse) throws BaseException {

        List<Object>param=new ArrayList<>();
        String meeting_date = fse.getValue("meeting_date").toString();
        String meeting_resource = fse.getValue("meeting_resource").toString();
        String meeting_date= fse.getString("meeting_date");
        String meeting_resource = fse.getString("meeting_resource");
        param.add(meeting_date);
        param.add(meeting_resource);
        if(!StringUtils.isEmpty(meeting_resource)){
            String replace_meeting_resource = meeting_resource.replace(",", "%");
            meeting_resource="%"+replace_meeting_resource+"%";
            param.add(meeting_resource);
        }

        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(start_time,\"%Y-%m-%d\")=?");
        bs.append(" and meeting_resource in ( ? )");
        bs.append(" where DATE_FORMAT(y.start_time,\"%Y-%m-%d\")=?");
        if(!StringUtils.isEmpty(meeting_resource)){
            bs.append(" and  y.meeting_resource like ? ");
        }
        DataTableEntity dataTableEntity = baseDao.listTable(bs.toString(), param.toArray());
        List<String> list=new ArrayList();
        List<HashMap> listDate=new ArrayList<>();
@@ -248,6 +255,13 @@
        return  listDate;
    }

    @Override
    public List getMeetingDetails(FieldSetEntity fse) throws BaseException {


        return null;
    }


    /**
     * 会议室使用情况