| | |
| | | } |
| | | |
| | | StringBuilder bs=new StringBuilder(); |
| | | 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(" SELECT DISTINCT g.room_name,g.uuid as meet_room_uuid,DATE_FORMAT(y.start_time, \"%d-%m-%Y %H:%i\") start_time_format,DATE_FORMAT(y.end_time, \"%d-%m-%Y %H:%i\") end_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 y.start_time between ? and ? "); |