whoisonlinesession.php

<?php
/* For licensing terms, see /license.txt */
/**
 * Shows who is online in a specific session
 * @todo move this inside web/users/online-in-course
 * @package chamilo.main
 */
/**
 * Initialization
 */
// name of the language file that needs to be included
$language_file = array ('index', 'chat', 'tracking');

require_once './main/inc/global.inc.php';

api_block_anonymous_users();

if (isset($_REQUEST['session_id'])) {
    $session_id = intval($_REQUEST['session_id']);
} else {
    $session_id = api_get_session_id();
}
if (empty($session_id)) {
    api_not_allowed(true);
}

Display::display_header(get_lang('UserOnlineListSession'));

echo Display::page_header(get_lang('UserOnlineListSession'));

?>
<br /><br />
<table class="data_table">
	<tr>
		<th>
			<?php echo get_lang('Name'); ?>
		</th>
		<th>
			<?php echo get_lang('InCourse'); ?>
		</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 	DISTINCT last_access.access_user_id,
							last_access.access_date,
							last_access.c_id,
							last_access.access_session_id,
							course.code,
							".(api_is_western_name_order() ? "CONCAT(user.firstname,' ',user.lastname)" : "CONCAT(user.lastname,' ',user.firstname)")." as name,
							user.email
					FROM ".Database::get_main_table(TABLE_STATISTIC_TRACK_E_LASTACCESS)." AS last_access
					INNER JOIN ".Database::get_main_table(TABLE_MAIN_USER)." AS user
					    ON user.user_id = last_access.access_user_id
					INNER JOIN ".Database::get_main_table(TABLE_MAIN_COURSE)." AS course
					    ON course.id = last_access.c_id
					WHERE access_session_id='".$session['id']."' AND access_date >= '$current_date'
					GROUP 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>";
				echo $student_online['name'];
				echo "</td><td align='center'>";
				echo $student_online['code'];
				echo "</td><td align='center'>";
                if (api_get_setting('show_email_addresses') == 'true') {
                    if (!empty($student_online['email'])) {
                       echo $student_online['email'];
                    } else {
                       echo get_lang('NoEmail');
                    }
                }
				echo "	</td>
						<td align='center'>
					 ";
				echo '<a target="_blank" class="btn" href="main/chat/chat.php?cidReq='.$student_online['code'].'&id_session='.$student_online['access_session_id'].'">
                    '.get_lang('Chat').'
                        </a>';
				echo "	</td>
					</tr>
					 ";
			}
		} else {
			echo '	<tr>
						<td colspan="4">
							'.get_lang('NoOnlineStudents').'
						</td>
					</tr>
				 ';
		}
	}
?>
</table>
<?php
Display::display_footer();