[C2] Add generic videoconference tables to ease conference plugins integration #4195
Description
As the need for distance teaching and remote meetings increase (it's a constant, even removing pandemics and wars from the equation) and we integrate more videoconference tools in Chamilo (BBB, Zoom, probably Teams in the medium term), there is a growing demand (by teachers/trainers) for activity tracking to be integrated into Chamilo in a more consistent way (at the moment you can sometime get that through the plugins' respective interfaces).
Adding a table for the activity in conferences: total time connected, number of logins to the conference, first connexion, last connexion, conference room ID, course, session, and then, if this data can be collected, number of messages, number of polls answered, general activity score, documents shared, number of times presenter role has been assigned).
Plugins could then be able to register events there through a method like Event::conferenceActivity()
- Create a "conference_meeting" table with records of each conference.
- Create a "conference_recording" table with records of each conference recording.
- Create a "conference_activity" table with records of activity of each user in the conference.
- [C2] Create default callback script that enables a videoconference system to send activity information back #6145
conference_meeting
Cloned from plugin_bbb_meeting and plugin_zoom_meeting
- id
- c_id
- session_id
- access_url_id
- group_id
- user_id
- calendar_id
- service_provider varchar(20) -- (the name of the plugin: bbb/zoom/teams, etc)
- remote_id
- internal_meeting_id
- title
- attendee_pw
- moderator_pw
- record
- status
- welcome_msg
- visibility
- voice_bridge
- video_url
- has_video_m4v
- created_at
- closed_at
- meeting_list_item
- meeting_info_get
- sign_attendance
- reason_to_sign_attendance
- account_email
- webinar_schema
conference_recording
Cloned from plugin_bbb_meeting_format & plugin_zoom_recording
- id
- meeting_id
- format_type
- resource_url
conference_activity
Cloned from plugin_bbb_room & plugin_zoom_meeting_activity
- id
- meeting_id
- participant_id
- in_at
- out_at
- close
- type
- event
- activity_data (longtext)
- signature_file
- signed_at