".get_lang('ListStudents')."";
if( $is_allowedToTrackEverybodyInCourse ) {
// if user can track everybody : list user of course
$sql = "SELECT count(user_id)
FROM $TABLECOURSUSER
WHERE course_code = '".Database::escape_string($_cid)."' AND relation_type<>".COURSE_RELATION_TYPE_RRHH."";
} else {
// if user can only track one group : list users of this group
$sql = "SELECT count(user)
FROM $TABLECOURSE_GROUPSUSER
WHERE group_id = '".Database::escape_string($_gid)."'";
}
$userGroupNb = getOneResult($sql);
$step = 25; // number of student per page
if ($userGroupNb > $step) {
if(!isset($offset)) {
$offset=0;
}
$next = $offset + $step;
$previous = $offset - $step;
$navLink = "\n";
} else {
$offset = 0;
}
echo $navLink;
if (!settype($offset, 'integer') || !settype($step, 'integer')) die('Offset or step variables are not integers.'); //sanity check of integer vars
if( $is_allowedToTrackEverybodyInCourse ) {
// list of users in this course
$sql = "SELECT u.user_id, u.firstname,u.lastname
FROM $TABLECOURSUSER cu , $TABLEUSER u
WHERE cu.user_id = u.user_id AND cu.relation_type<>".COURSE_RELATION_TYPE_RRHH."
AND cu.course_code = '".Database::escape_string($_cid)."'
LIMIT $offset,$step";
}
else
{
// list of users of this group
$sql = "SELECT u.user_id, u.firstname,u.lastname
FROM $TABLECOURSE_GROUPSUSER gu , $TABLEUSER u
WHERE gu.user_id = u.user_id
AND gu.group_id = '".Database::escape_string($_gid)."'
LIMIT $offset,$step";
}
$list_users = getManyResults3Col($sql);
echo "\n";
echo $navLink;
} else {
// if uInfo is set
/*
* Informations about student uInfo
*/
// these checks exists for security reasons, neither a prof nor a tutor can see statistics of a user from
// another course, or group
if( $is_allowedToTrackEverybodyInCourse ) {
// check if user is in this course
$tracking_is_accepted = $is_course_member;
$tracked_user_info = api_get_user_info($uInfo);
} else {
// check if user is in the group of this tutor
$sql = "SELECT u.firstname,u.lastname, u.email
FROM $TABLECOURSE_GROUPSUSER gu , $TABLEUSER u
WHERE gu.user_id = u.user_id
AND gu.group_id = '".Database::escape_string($_gid)."'
AND u.user_id = '".Database::escape_string($uInfo)."'";
$query = Database::query($sql);
$tracked_user_info = @Database::fetch_assoc($query);
if(is_array($tracked_user_info)) $tracking_is_accepted = true;
}
if ($tracking_is_accepted) {
$tracked_user_info['email'] == '' ? $mail_link = get_lang('NoEmail') : $mail_link = Display::encrypted_mailto_link($tracked_user_info['email']);
echo "";
echo get_lang('informationsAbout').' :';
echo "\n"
."- ".get_lang('FirstName')." : ".$tracked_user_info['firstname']."
\n"
."- ".get_lang('LastName')." : ".$tracked_user_info['lastname']."
\n"
."- ".get_lang('Email')." : ".$mail_link."
\n"
." ";
echo " |
\n";
// show all : number of 1 is equal to or bigger than number of categories
// show none : number of 0 is equal to or bigger than number of categories
echo "
|
[".get_lang('ShowAll')."]
[".get_lang('ShowNone')."]".
//"||[".get_lang('BackToList')."]".
" |
";
if(!isset($view))
{
$view ='0000000';
}
//Logins
TrackingUserLog::display_login_tracking_info($view, $uInfo, $courseId);
//Exercise results
TrackingUserLog::display_exercise_tracking_info($view, $uInfo, $courseId);
//Student publications uploaded
TrackingUserLog::display_student_publications_tracking_info($view, $uInfo, $courseId);
//Links usage
TrackingUserLog::display_links_tracking_info($view, $uInfo, $courseId);
//Documents downloaded
TrackingUserLog::display_document_tracking_info($view, $uInfo, $courseId);
} else {
echo get_lang('ErrorUserNotInGroup');
}
/*
* Scorm contents and Learning Path
*/
if(substr($view,5,1) == '1') {
$new_view = substr_replace($view,'0',5,1);
echo "
|
- ".get_lang('ScormAccess')." [".get_lang('Close')."] [".get_lang('ExportAsCSV')."]
|
";
$sql = "SELECT id, name FROM $tbl_learnpath_main";
$result=Database::query($sql);
$ar=Database::fetch_array($result);
echo "";
echo "
|
".get_lang('ScormContentColumn')."
|
";
if (is_array($ar)) {
while ($ar['id'] != '') {
$lp_title = stripslashes($ar['name']);
echo "| ";
echo "$lp_title";
echo " | ";
if ($ar['id']==$scormcontopen) { //have to list the students here
$contentId=$ar['id'];
$sql3 = "SELECT iv.status, iv.score, i.title, iv.total_time " .
"FROM $tbl_learnpath_item i " .
"INNER JOIN $tbl_learnpath_item_view iv ON i.id=iv.lp_item_id " .
"INNER JOIN $tbl_learnpath_view v ON iv.lp_view_id=v.id " .
"WHERE (v.user_id=".Database::escape_string($uInfo)." and v.lp_id=$contentId) ORDER BY v.id, i.id";
$result3=Database::query($sql3);
$ar3=Database::fetch_array($result3);
if (is_array($ar3)) {
echo "| |
".get_lang('ScormTitleColumn')."
|
".get_lang('ScormStatusColumn')."
|
".get_lang('ScormScoreColumn')."
|
".get_lang('ScormTimeColumn')."
|
";
while ($ar3['status'] != '') {
require_once '../newscorm/learnpathItem.class.php';
$time = learnpathItem::get_scorm_time('php',$ar3['total_time']);
echo "| | ";
echo "$title | {$ar3['status']} | {$ar3['score']} | $time | ";
echo " ";
$ar3=Database::fetch_array($result3);
}
} else {
echo "";
echo "| ".get_lang('ScormNeverOpened')." | ";
echo" ";
}
}
$ar=Database::fetch_array($result);
}
} else {
$noscorm=true;
}
if ($noscorm) {
echo "";
echo "| ".get_lang('NoResult')." | ";
echo " ";
}
echo "
";
echo " |
";
} else {
$new_view = substr_replace($view,'1',5,1);
echo "
|
+ ".get_lang('ScormAccess')."
|
";
}
}
} else {
// not allowed
api_not_allowed();
}
?>