= '$current_date' $urlCondition"; $result = Database::query($sql); $result = Database::fetch_array($result); return $result['count']; } $sql = "SELECT DISTINCT last_access.login_user_id, last_access.c_id FROM ".Database::get_main_table(TABLE_STATISTIC_TRACK_E_ONLINE)." AS last_access INNER JOIN ".Database::get_main_table(TABLE_MAIN_USER)." AS user ON user.id = last_access.login_user_id $urlJoin WHERE session_id ='".$sessionId."' AND login_date >= '$current_date' $urlCondition GROUP BY login_user_id LIMIT $from, $numberItems"; $studentsOnline = []; $result = Database::query($sql); while ($user_list = Database::fetch_array($result)) { $studentsOnline[$user_list['login_user_id']] = $user_list; } return $studentsOnline; } function getCountUsers() { return getUsers(0, 0, 0, 0, true); } $table = new SortableTable( 'users', 'getCountUsers', 'getUsers', '1', $maxNumberItems ); $table->set_header(0, get_lang('Name'), false); $table->set_header(1, get_lang('InCourse'), false); $table->set_column_filter(0, 'user_filter'); $table->set_column_filter(1, 'course_filter'); $table->display(); function user_filter($userId, $urlParams, $row) { $userInfo = api_get_user_info($userId); return $userInfo['complete_name_with_message_link']; } function course_filter($courseId, $urlParams, $row) { $sessionId = api_get_session_id(); $courseInfo = api_get_course_info_by_id($courseId); return Display::url( $courseInfo['title'], $courseInfo['course_public_url'].'?id_session='.$sessionId, ['target' => '_blank'] ). ' '. Display::url( get_lang('Chat'), 'main/chat/chat.php?cidReq='.$courseInfo['code'].'&id_session='.$sessionId, ['target' => '_blank', 'class' => 'btn btn-primary'] ); } Display::display_footer();