echo $item;
}
}
}
echo '</div>';
$sessions = array();
if (empty($session_id)) {
// Getting courses followed by a coach (No session courses)
$courses = CourseManager::get_course_list_as_coach($user_id, false);
if (isset($courses[0])) {
$courses = $courses[0];
}
//Getting students from courses and courses in sessions (To show the total students that the user follows)
$students = CourseManager::get_user_list_from_courses_as_coach($user_id);
// Sessions for the coach
$sessions = SessionManager::get_sessions_coached_by_user($user_id);
//If is drh
if ($is_drh) {
$students = array_keys(UserManager::get_users_followed_by_drh($user_id, STUDENT));
$courses_of_the_platform = CourseManager::get_courses_followed_by_drh($user_id);
foreach ($courses_of_the_platform as $course) {
$courses[$course['real_id']] = $course['real_id'];
}
$sessions = SessionManager::get_sessions_followed_by_drh($user_id);
}
//Courses for the user
$count_courses = count($courses);
//Sessions for the user
$count_sessions = count($sessions);
//Students
$nb_students = count($students);
/**
* Get course list as coach
*
* @param int user id
* @return array course list
*
* */
public static function get_course_list_as_coach($user_id, $include_courses_in_sessions = false)
{
//1. Getting courses as teacher (No session)
$courses_temp = CourseManager::get_course_list_of_user_as_course_admin($user_id);
$courses_as_admin = array();
if (!empty($courses_temp)) {
foreach ($courses_temp as $course_item) {
$courses_as_admin[0][$course_item['real_id']] = $course_item['real_id'];
}
}
//2. Include courses in sessions
if ($include_courses_in_sessions) {
$sessions = SessionManager::get_sessions_coached_by_user($user_id);
if (!empty($sessions)) {
foreach ($sessions as $session_item) {
$courses = Tracking::get_courses_followed_by_coach($user_id, $session_item['id']);
if (is_array($courses)) {
foreach ($courses as $course_item) {
$courses_as_admin[$session_item['id']][$course_item] = $course_item;
}
}
}
}
}
return $courses_as_admin;
}
echo $item;
}
}
if (count($a_sessions) > 0) {
echo '<span style="float:right">';
echo Display::url(Display::return_icon('printer.png', get_lang('Print'), array(), 32), 'javascript: void(0);', array('onclick' => 'javascript: window.print();'));
echo Display::url(Display::return_icon('export_csv.png', get_lang('ExportAsCSV'), array(), 32), api_get_self() . '?export=csv');
echo '</span>';
}
echo '</div>';
echo Display::page_header(get_lang('YourSessionsList'));
} else {
/*if (api_is_platform_admin()) {
$a_sessions = SessionManager::get_sessions_list();
} else {*/
$a_sessions = SessionManager::get_sessions_coached_by_user($id_coach);
//}
}
$nb_sessions = count($a_sessions);
if ($export_csv) {
$csv_content = array();
}
if ($nb_sessions > 0) {
$table = new SortableTable('tracking', 'count_sessions_coached');
$table->set_header(0, get_lang('Title'));
$table->set_header(1, get_lang('Date'));
$table->set_header(2, get_lang('NbCoursesPerSession'));
$table->set_header(3, get_lang('Details'), false);
$all_data = array();
foreach ($a_sessions as $session) {
$row = array();
</th>
<th>
<?php
echo get_lang('Email');
?>
</th>
<th>
<?php
echo get_lang('Chat');
?>
</th>
</tr>
<?php
$session_is_coach = array();
if (isset($_user['user_id']) && $_user['user_id'] != '') {
$session_is_coach = SessionManager::get_sessions_coached_by_user(api_get_user_id());
$students_online = array();
$now = api_get_utc_datetime();
$time_limit = api_get_setting('time_limit_whosonline');
$online_time = time() - $time_limit * 60;
$current_date = api_get_utc_datetime($online_time);
foreach ($session_is_coach as $session) {
$sql = "SELECT \tDISTINCT last_access.access_user_id,\n\t\t\t\t\t\t\tlast_access.access_date,\n\t\t\t\t\t\t\tlast_access.c_id,\n\t\t\t\t\t\t\tlast_access.access_session_id,\n\t\t\t\t\t\t\tcourse.code,\n\t\t\t\t\t\t\t" . (api_is_western_name_order() ? "CONCAT(user.firstname,' ',user.lastname)" : "CONCAT(user.lastname,' ',user.firstname)") . " as name,\n\t\t\t\t\t\t\tuser.email\n\t\t\t\t\tFROM " . Database::get_main_table(TABLE_STATISTIC_TRACK_E_LASTACCESS) . " AS last_access\n\t\t\t\t\tINNER JOIN " . Database::get_main_table(TABLE_MAIN_USER) . " AS user\n\t\t\t\t\t ON user.user_id = last_access.access_user_id\n\t\t\t\t\tINNER JOIN " . Database::get_main_table(TABLE_MAIN_COURSE) . " AS course\n\t\t\t\t\t ON course.id = last_access.c_id\n\t\t\t\t\tWHERE access_session_id='" . $session['id'] . "' AND access_date >= '{$current_date}'\n\t\t\t\t\tGROUP BY access_user_id";
$result = Database::query($sql);
while ($user_list = Database::fetch_array($result)) {
$students_online[$user_list['access_user_id']] = $user_list;
}
}
if (count($students_online) > 0) {
foreach ($students_online as $student_online) {
echo "<tr><td>";
