3 // Lists all the users within a given course
5 require_once('../config.php');
6 require_once($CFG->libdir
.'/tablelib.php');
7 require_once($CFG->libdir
.'/filelib.php');
9 define('USER_SMALL_CLASS', 20); // Below this is considered small
10 define('USER_LARGE_CLASS', 200); // Above this is considered large
11 define('DEFAULT_PAGE_SIZE', 20);
12 define('SHOW_ALL_PAGE_SIZE', 5000);
13 define('MODE_BRIEF', 0);
14 define('MODE_USERDETAILS', 1);
16 $page = optional_param('page', 0, PARAM_INT
); // which page to show
17 $perpage = optional_param('perpage', DEFAULT_PAGE_SIZE
, PARAM_INT
); // how many per page
18 $mode = optional_param('mode', NULL, PARAM_INT
); // use the MODE_ constants
19 $accesssince = optional_param('accesssince',0,PARAM_INT
); // filter by last access. -1 = never
20 $search = optional_param('search','',PARAM_RAW
); // make sure it is processed with p() or s() when sending to output!
21 $roleid = optional_param('roleid', 0, PARAM_INT
); // optional roleid, 0 means all enrolled users (or all on the frontpage)
23 $contextid = optional_param('contextid', 0, PARAM_INT
); // one of this or
24 $courseid = optional_param('id', 0, PARAM_INT
); // this are required
26 $PAGE->set_url('/user/index.php', array(
28 'perpage' => $perpage,
30 'accesssince' => $accesssince,
33 'contextid' => $contextid,
37 $context = context
::instance_by_id($contextid, MUST_EXIST
);
38 if ($context->contextlevel
!= CONTEXT_COURSE
) {
39 print_error('invalidcontext');
41 $course = $DB->get_record('course', array('id'=>$context->instanceid
), '*', MUST_EXIST
);
43 $course = $DB->get_record('course', array('id'=>$courseid), '*', MUST_EXIST
);
44 $context = context_course
::instance($course->id
, MUST_EXIST
);
50 require_login($course);
52 $systemcontext = context_system
::instance();
53 $isfrontpage = ($course->id
== SITEID
);
55 $frontpagectx = context_course
::instance(SITEID
);
58 $PAGE->set_pagelayout('admin');
59 require_capability('moodle/site:viewparticipants', $systemcontext);
61 $PAGE->set_pagelayout('incourse');
62 require_capability('moodle/course:viewparticipants', $context);
65 $rolenamesurl = new moodle_url("$CFG->wwwroot/user/index.php?contextid=$context->id&sifirst=&silast=");
67 $rolenames = role_fix_names(get_profile_roles($context), $context, ROLENAME_ALIAS
, true);
69 $rolenames[0] = get_string('allsiteusers', 'role');
71 $rolenames[0] = get_string('allparticipants');
74 // make sure other roles may not be selected by any means
75 if (empty($rolenames[$roleid])) {
76 print_error('noparticipants');
79 // no roles to display yet?
80 // frontpage course is an exception, on the front page course we should display all users
81 if (empty($rolenames) && !$isfrontpage) {
82 if (has_capability('moodle/role:assign', $context)) {
83 redirect($CFG->wwwroot
.'/'.$CFG->admin
.'/roles/assign.php?contextid='.$context->id
);
85 print_error('noparticipants');
89 $event = \core\event\user_list_viewed
::create(array(
90 'context' => $context,
91 'objectid' => $course->id
,
93 'courseid' => $course->id
,
94 'courseshortname' => $course->shortname
,
95 'coursefullname' => $course->fullname
100 $bulkoperations = has_capability('moodle/course:bulkmessaging', $context);
102 $countries = get_string_manager()->get_list_of_countries();
104 $strnever = get_string('never');
106 $datestring = new stdClass();
107 $datestring->year
= get_string('year');
108 $datestring->years
= get_string('years');
109 $datestring->day
= get_string('day');
110 $datestring->days
= get_string('days');
111 $datestring->hour
= get_string('hour');
112 $datestring->hours
= get_string('hours');
113 $datestring->min
= get_string('min');
114 $datestring->mins
= get_string('mins');
115 $datestring->sec
= get_string('sec');
116 $datestring->secs
= get_string('secs');
118 if ($mode !== NULL) {
120 $SESSION->userindexmode
= $mode;
121 } else if (isset($SESSION->userindexmode
)) {
122 $mode = (int)$SESSION->userindexmode
;
127 /// Check to see if groups are being used in this course
128 /// and if so, set $currentgroup to reflect the current group
130 $groupmode = groups_get_course_groupmode($course); // Groups are being used
131 $currentgroup = groups_get_course_group($course, true);
133 if (!$currentgroup) { // To make some other functions work better later
134 $currentgroup = NULL;
137 $isseparategroups = ($course->groupmode
== SEPARATEGROUPS
and !has_capability('moodle/site:accessallgroups', $context));
139 $PAGE->set_title("$course->shortname: ".get_string('participants'));
140 $PAGE->set_heading($course->fullname
);
141 $PAGE->set_pagetype('course-view-' . $course->format
);
142 $PAGE->add_body_class('path-user'); // So we can style it independently
143 $PAGE->set_other_editing_capability('moodle/course:manageactivities');
145 echo $OUTPUT->header();
147 echo '<div class="userlist">';
149 if ($isseparategroups and (!$currentgroup) ) {
150 // The user is not in the group so show message and exit
151 echo $OUTPUT->heading(get_string("notingroup"));
152 echo $OUTPUT->footer();
157 // Should use this variable so that we don't break stuff every time a variable is added or changed.
158 $baseurl = new moodle_url('/user/index.php', array(
159 'contextid' => $context->id
,
162 'perpage' => $perpage,
163 'accesssince' => $accesssince,
164 'search' => s($search)));
167 if ($course->id
== SITEID
) {
168 $filtertype = 'site';
169 } else if ($course->id
&& !$currentgroup) {
170 $filtertype = 'course';
171 $filterselect = $course->id
;
173 $filtertype = 'group';
174 $filterselect = $currentgroup;
179 /// Get the hidden field list
180 if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
181 $hiddenfields = array(); // teachers and admins are allowed to see everything
183 $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields
));
186 if (isset($hiddenfields['lastaccess'])) {
187 // do not allow access since filtering
191 /// Print settings and things in a table across the top
192 $controlstable = new html_table();
193 $controlstable->attributes
['class'] = 'controls';
194 $controlstable->cellspacing
= 0;
195 $controlstable->data
[] = new html_table_row();
197 /// Print my course menus
198 if ($mycourses = enrol_get_my_courses()) {
199 $courselist = array();
200 $popupurl = new moodle_url('/user/index.php?roleid='.$roleid.'&sifirst=&silast=');
201 foreach ($mycourses as $mycourse) {
202 $coursecontext = context_course
::instance($mycourse->id
);
203 $courselist[$mycourse->id
] = format_string($mycourse->shortname
, true, array('context' => $coursecontext));
205 if (has_capability('moodle/site:viewparticipants', $systemcontext)) {
206 unset($courselist[SITEID
]);
207 $courselist = array(SITEID
=> format_string($SITE->shortname
, true, array('context' => $systemcontext))) +
$courselist;
209 $select = new single_select($popupurl, 'id', $courselist, $course->id
, null, 'courseform');
210 $select->set_label(get_string('mycourses'));
211 $controlstable->data
[0]->cells
[] = $OUTPUT->render($select);
214 $controlstable->data
[0]->cells
[] = groups_print_course_menu($course, $baseurl->out(), true);
216 if (!isset($hiddenfields['lastaccess'])) {
217 // get minimum lastaccess for this course and display a dropbox to filter by lastaccess going back this far.
218 // we need to make it diferently for normal courses and site course
220 $minlastaccess = $DB->get_field_sql('SELECT min(timeaccess)
221 FROM {user_lastaccess}
223 AND timeaccess != 0', array($course->id
));
224 $lastaccess0exists = $DB->record_exists('user_lastaccess', array('courseid'=>$course->id
, 'timeaccess'=>0));
226 $minlastaccess = $DB->get_field_sql('SELECT min(lastaccess)
228 WHERE lastaccess != 0');
229 $lastaccess0exists = $DB->record_exists('user', array('lastaccess'=>0));
232 $now = usergetmidnight(time());
233 $timeaccess = array();
234 $baseurl->remove_params('accesssince');
236 // makes sense for this to go first.
237 $timeoptions[0] = get_string('selectperiod');
240 for ($i = 1; $i < 7; $i++
) {
241 if (strtotime('-'.$i.' days',$now) >= $minlastaccess) {
242 $timeoptions[strtotime('-'.$i.' days',$now)] = get_string('numdays','moodle',$i);
246 for ($i = 1; $i < 10; $i++
) {
247 if (strtotime('-'.$i.' weeks',$now) >= $minlastaccess) {
248 $timeoptions[strtotime('-'.$i.' weeks',$now)] = get_string('numweeks','moodle',$i);
252 for ($i = 2; $i < 12; $i++
) {
253 if (strtotime('-'.$i.' months',$now) >= $minlastaccess) {
254 $timeoptions[strtotime('-'.$i.' months',$now)] = get_string('nummonths','moodle',$i);
258 if (strtotime('-1 year',$now) >= $minlastaccess) {
259 $timeoptions[strtotime('-1 year',$now)] = get_string('lastyear');
262 if (!empty($lastaccess0exists)) {
263 $timeoptions[-1] = get_string('never');
266 if (count($timeoptions) > 1) {
267 $select = new single_select($baseurl, 'accesssince', $timeoptions, $accesssince, null, 'timeoptions');
268 $select->set_label(get_string('usersnoaccesssince'));
269 $controlstable->data
[0]->cells
[] = $OUTPUT->render($select);
273 $formatmenu = array( '0' => get_string('brief'),
274 '1' => get_string('userdetails'));
275 $select = new single_select($baseurl, 'mode', $formatmenu, $mode, null, 'formatmenu');
276 $select->set_label(get_string('userlist'));
277 $userlistcell = new html_table_cell();
278 $userlistcell->attributes
['class'] = 'right';
279 $userlistcell->text
= $OUTPUT->render($select);
280 $controlstable->data
[0]->cells
[] = $userlistcell;
282 echo html_writer
::table($controlstable);
284 if ($currentgroup and (!$isseparategroups or has_capability('moodle/site:accessallgroups', $context))) { /// Display info about the group
285 if ($group = groups_get_group($currentgroup)) {
286 if (!empty($group->description
) or (!empty($group->picture
) and empty($group->hidepicture
))) {
287 $groupinfotable = new html_table();
288 $groupinfotable->attributes
['class'] = 'groupinfobox';
289 $picturecell = new html_table_cell();
290 $picturecell->attributes
['class'] = 'left side picture';
291 $picturecell->text
= print_group_picture($group, $course->id
, true, true, false);
293 $contentcell = new html_table_cell();
294 $contentcell->attributes
['class'] = 'content';
296 $contentheading = $group->name
;
297 if (has_capability('moodle/course:managegroups', $context)) {
298 $aurl = new moodle_url('/group/group.php', array('id' => $group->id
, 'courseid' => $group->courseid
));
299 $contentheading .= ' ' . $OUTPUT->action_icon($aurl, new pix_icon('t/edit', get_string('editgroupprofile')));
302 $group->description
= file_rewrite_pluginfile_urls($group->description
, 'pluginfile.php', $context->id
, 'group', 'description', $group->id
);
303 if (!isset($group->descriptionformat
)) {
304 $group->descriptionformat
= FORMAT_MOODLE
;
306 $options = array('overflowdiv'=>true);
307 $contentcell->text
= $OUTPUT->heading($contentheading, 3) . format_text($group->description
, $group->descriptionformat
, $options);
308 $groupinfotable->data
[] = new html_table_row(array($picturecell, $contentcell));
309 echo html_writer
::table($groupinfotable);
314 /// Define a table showing a list of users in the current role selection
315 $tablecolumns = array();
316 $tableheaders = array();
317 if ($bulkoperations && $mode === MODE_BRIEF
) {
318 $tablecolumns[] = 'select';
319 $tableheaders[] = get_string('select');
321 $tablecolumns[] = 'userpic';
322 $tablecolumns[] = 'fullname';
324 $extrafields = get_extra_user_fields($context);
325 $tableheaders[] = get_string('userpic');
326 $tableheaders[] = get_string('fullnameuser');
328 if ($mode === MODE_BRIEF
) {
329 foreach ($extrafields as $field) {
330 $tablecolumns[] = $field;
331 $tableheaders[] = get_user_field_name($field);
334 if ($mode === MODE_BRIEF
&& !isset($hiddenfields['city'])) {
335 $tablecolumns[] = 'city';
336 $tableheaders[] = get_string('city');
338 if ($mode === MODE_BRIEF
&& !isset($hiddenfields['country'])) {
339 $tablecolumns[] = 'country';
340 $tableheaders[] = get_string('country');
342 if (!isset($hiddenfields['lastaccess'])) {
343 $tablecolumns[] = 'lastaccess';
344 $tableheaders[] = get_string('lastaccess');
347 if ($bulkoperations && $mode === MODE_USERDETAILS
) {
348 $tablecolumns[] = 'select';
349 $tableheaders[] = get_string('select');
352 $table = new flexible_table('user-index-participants-'.$course->id
);
353 $table->define_columns($tablecolumns);
354 $table->define_headers($tableheaders);
355 $table->define_baseurl($baseurl->out());
357 if (!isset($hiddenfields['lastaccess'])) {
358 $table->sortable(true, 'lastaccess', SORT_DESC
);
360 $table->sortable(true, 'firstname', SORT_ASC
);
363 $table->no_sorting('roles');
364 $table->no_sorting('groups');
365 $table->no_sorting('groupings');
366 $table->no_sorting('select');
368 $table->set_attribute('cellspacing', '0');
369 $table->set_attribute('id', 'participants');
370 $table->set_attribute('class', 'generaltable generalbox');
372 $table->set_control_variables(array(
373 TABLE_VAR_SORT
=> 'ssort',
374 TABLE_VAR_HIDE
=> 'shide',
375 TABLE_VAR_SHOW
=> 'sshow',
376 TABLE_VAR_IFIRST
=> 'sifirst',
377 TABLE_VAR_ILAST
=> 'silast',
378 TABLE_VAR_PAGE
=> 'spage'
382 list($esql, $params) = get_enrolled_sql($context, NULL, $currentgroup, true);
383 $joins = array("FROM {user} u");
386 $extrasql = get_extra_user_fields_sql($context, 'u', '', array(
387 'id', 'username', 'firstname', 'lastname', 'email', 'city', 'country',
388 'picture', 'lang', 'timezone', 'maildisplay', 'imagealt', 'lastaccess'));
390 $mainuserfields = user_picture
::fields('u', array('username', 'email', 'city', 'country', 'lang', 'timezone', 'maildisplay'));
393 $select = "SELECT $mainuserfields, u.lastaccess$extrasql";
394 $joins[] = "JOIN ($esql) e ON e.id = u.id"; // everybody on the frontpage usually
396 $wheres[] = get_user_lastaccess_sql($accesssince);
400 $select = "SELECT $mainuserfields, COALESCE(ul.timeaccess, 0) AS lastaccess$extrasql";
401 $joins[] = "JOIN ($esql) e ON e.id = u.id"; // course enrolled users only
402 $joins[] = "LEFT JOIN {user_lastaccess} ul ON (ul.userid = u.id AND ul.courseid = :courseid)"; // not everybody accessed course yet
403 $params['courseid'] = $course->id
;
405 $wheres[] = get_course_lastaccess_sql($accesssince);
409 // performance hacks - we preload user contexts together with accounts
410 $ccselect = ', ' . context_helper
::get_preload_record_columns_sql('ctx');
411 $ccjoin = "LEFT JOIN {context} ctx ON (ctx.instanceid = u.id AND ctx.contextlevel = :contextlevel)";
412 $params['contextlevel'] = CONTEXT_USER
;
413 $select .= $ccselect;
417 // limit list to users with some role only
419 // We want to query both the current context and parent contexts.
420 list($relatedctxsql, $relatedctxparams) = $DB->get_in_or_equal($context->get_parent_context_ids(true), SQL_PARAMS_NAMED
, 'relatedctx');
422 $wheres[] = "u.id IN (SELECT userid FROM {role_assignments} WHERE roleid = :roleid AND contextid $relatedctxsql)";
423 $params = array_merge($params, array('roleid' => $roleid), $relatedctxparams);
426 $from = implode("\n", $joins);
428 $where = "WHERE " . implode(" AND ", $wheres);
433 $totalcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
435 if (!empty($search)) {
436 $fullname = $DB->sql_fullname('u.firstname','u.lastname');
437 $wheres[] = "(". $DB->sql_like($fullname, ':search1', false, false) .
438 " OR ". $DB->sql_like('email', ':search2', false, false) .
439 " OR ". $DB->sql_like('idnumber', ':search3', false, false) .") ";
440 $params['search1'] = "%$search%";
441 $params['search2'] = "%$search%";
442 $params['search3'] = "%$search%";
445 list($twhere, $tparams) = $table->get_sql_where();
448 $params = array_merge($params, $tparams);
451 $from = implode("\n", $joins);
453 $where = "WHERE " . implode(" AND ", $wheres);
458 if ($table->get_sql_sort()) {
459 $sort = ' ORDER BY '.$table->get_sql_sort();
464 $matchcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
466 $table->initialbars(true);
467 $table->pagesize($perpage, $matchcount);
469 // list of users at the current visible page - paging makes it relatively short
470 $userlist = $DB->get_recordset_sql("$select $from $where $sort", $params, $table->get_page_start(), $table->get_page_size());
472 /// If there are multiple Roles in the course, then show a drop down menu for switching
473 if (count($rolenames) > 1) {
474 echo '<div class="rolesform">';
475 echo '<label for="rolesform_jump">'.get_string('currentrole', 'role').' </label>';
476 echo $OUTPUT->single_select($rolenamesurl, 'roleid', $rolenames, $roleid, null, 'rolesform');
479 } else if (count($rolenames) == 1) {
480 // when all users with the same role - print its name
481 echo '<div class="rolesform">';
482 echo get_string('role').get_string('labelsep', 'langconfig');
483 $rolename = reset($rolenames);
490 $a->number
= $totalcount;
491 $a->role
= $rolenames[$roleid];
492 $heading = format_string(get_string('xuserswiththerole', 'role', $a));
494 if ($currentgroup and $group) {
495 $a->group
= $group->name
;
496 $heading .= ' ' . format_string(get_string('ingroup', 'role', $a));
500 $a->timeperiod
= $timeoptions[$accesssince];
501 $heading .= ' ' . format_string(get_string('inactiveformorethan', 'role', $a));
504 $heading .= ": $a->number";
506 if (user_can_assign($context, $roleid)) {
507 $headingurl = new moodle_url($CFG->wwwroot
. '/' . $CFG->admin
. '/roles/assign.php',
508 array('roleid' => $roleid, 'contextid' => $context->id
));
509 $heading .= $OUTPUT->action_icon($headingurl, new pix_icon('t/edit', get_string('edit')));
511 echo $OUTPUT->heading($heading, 3);
513 if ($course->id
!= SITEID
&& has_capability('moodle/course:enrolreview', $context)) {
514 $editlink = $OUTPUT->action_icon(new moodle_url('/enrol/users.php', array('id' => $course->id
)),
515 new pix_icon('t/edit', get_string('edit')));
519 if ($course->id
== SITEID
and $roleid < 0) {
520 $strallparticipants = get_string('allsiteusers', 'role');
522 $strallparticipants = get_string('allparticipants');
524 if ($matchcount < $totalcount) {
525 echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount.'/'.$totalcount . $editlink, 3);
527 echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount . $editlink, 3);
532 if ($bulkoperations) {
533 echo '<form action="action_redir.php" method="post" id="participantsform">';
535 echo '<input type="hidden" name="sesskey" value="'.sesskey().'" />';
536 echo '<input type="hidden" name="returnto" value="'.s($PAGE->url
->out(false)).'" />';
539 if ($mode === MODE_USERDETAILS
) { // Print simple listing
540 if ($totalcount < 1) {
541 echo $OUTPUT->heading(get_string('nothingtodisplay'));
543 if ($totalcount > $perpage) {
545 $firstinitial = $table->get_initial_first();
546 $lastinitial = $table->get_initial_last();
547 $strall = get_string('all');
548 $alpha = explode(',', get_string('alphabet', 'langconfig'));
550 // Bar of first initials
552 echo '<div class="initialbar firstinitial">'.get_string('firstname').' : ';
553 if(!empty($firstinitial)) {
554 echo '<a href="'.$baseurl->out().'&sifirst=">'.$strall.'</a>';
556 echo '<strong>'.$strall.'</strong>';
558 foreach ($alpha as $letter) {
559 if ($letter == $firstinitial) {
560 echo ' <strong>'.$letter.'</strong>';
562 echo ' <a href="'.$baseurl->out().'&sifirst='.$letter.'">'.$letter.'</a>';
567 // Bar of last initials
569 echo '<div class="initialbar lastinitial">'.get_string('lastname').' : ';
570 if(!empty($lastinitial)) {
571 echo '<a href="'.$baseurl->out().'&silast=">'.$strall.'</a>';
573 echo '<strong>'.$strall.'</strong>';
575 foreach ($alpha as $letter) {
576 if ($letter == $lastinitial) {
577 echo ' <strong>'.$letter.'</strong>';
579 echo ' <a href="'.$baseurl->out().'&silast='.$letter.'">'.$letter.'</a>';
584 $pagingbar = new paging_bar($matchcount, intval($table->get_page_start() / $perpage), $perpage, $baseurl);
585 $pagingbar->pagevar
= 'spage';
586 echo $OUTPUT->render($pagingbar);
589 if ($matchcount > 0) {
590 $usersprinted = array();
591 foreach ($userlist as $user) {
592 if (in_array($user->id
, $usersprinted)) { /// Prevent duplicates by r.hidden - MDL-13935
595 $usersprinted[] = $user->id
; /// Add new user to the array of users printed
597 context_helper
::preload_from_record($user);
599 $context = context_course
::instance($course->id
);
600 $usercontext = context_user
::instance($user->id
);
602 $countries = get_string_manager()->get_list_of_countries();
604 /// Get the hidden field list
605 if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
606 $hiddenfields = array();
608 $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields
));
610 $table = new html_table();
611 $table->attributes
['class'] = 'userinfobox';
613 $row = new html_table_row();
614 $row->cells
[0] = new html_table_cell();
615 $row->cells
[0]->attributes
['class'] = 'left side';
617 $row->cells
[0]->text
= $OUTPUT->user_picture($user, array('size' => 100, 'courseid'=>$course->id
));
618 $row->cells
[1] = new html_table_cell();
619 $row->cells
[1]->attributes
['class'] = 'content';
621 $row->cells
[1]->text
= $OUTPUT->container(fullname($user, has_capability('moodle/site:viewfullnames', $context)), 'username');
622 $row->cells
[1]->text
.= $OUTPUT->container_start('info');
624 if (!empty($user->role
)) {
625 $row->cells
[1]->text
.= get_string('role').get_string('labelsep', 'langconfig').$user->role
.'<br />';
627 if ($user->maildisplay
== 1 or ($user->maildisplay
== 2 and ($course->id
!= SITEID
) and !isguestuser()) or
628 has_capability('moodle/course:viewhiddenuserfields', $context) or
629 in_array('email', $extrafields) or ($user->id
== $USER->id
)) {
630 $row->cells
[1]->text
.= get_string('email').get_string('labelsep', 'langconfig').html_writer
::link("mailto:$user->email", $user->email
) . '<br />';
632 foreach ($extrafields as $field) {
633 if ($field === 'email') {
634 // Skip email because it was displayed with different
635 // logic above (because this page is intended for
639 $row->cells
[1]->text
.= get_user_field_name($field) .
640 get_string('labelsep', 'langconfig') . s($user->{$field}) . '<br />';
642 if (($user->city
or $user->country
) and (!isset($hiddenfields['city']) or !isset($hiddenfields['country']))) {
643 $row->cells
[1]->text
.= get_string('city').get_string('labelsep', 'langconfig');
644 if ($user->city
&& !isset($hiddenfields['city'])) {
645 $row->cells
[1]->text
.= $user->city
;
647 if (!empty($countries[$user->country
]) && !isset($hiddenfields['country'])) {
648 if ($user->city
&& !isset($hiddenfields['city'])) {
649 $row->cells
[1]->text
.= ', ';
651 $row->cells
[1]->text
.= $countries[$user->country
];
653 $row->cells
[1]->text
.= '<br />';
656 if (!isset($hiddenfields['lastaccess'])) {
657 if ($user->lastaccess
) {
658 $row->cells
[1]->text
.= get_string('lastaccess').get_string('labelsep', 'langconfig').userdate($user->lastaccess
);
659 $row->cells
[1]->text
.= ' ('. format_time(time() - $user->lastaccess
, $datestring) .')';
661 $row->cells
[1]->text
.= get_string('lastaccess').get_string('labelsep', 'langconfig').get_string('never');
665 $row->cells
[1]->text
.= $OUTPUT->container_end();
667 $row->cells
[2] = new html_table_cell();
668 $row->cells
[2]->attributes
['class'] = 'links';
669 $row->cells
[2]->text
= '';
673 if ($CFG->bloglevel
> 0) {
674 $links[] = html_writer
::link(new moodle_url('/blog/index.php?userid='.$user->id
), get_string('blogs','blog'));
677 if (!empty($CFG->enablenotes
) and (has_capability('moodle/notes:manage', $context) ||
has_capability('moodle/notes:view', $context))) {
678 $links[] = html_writer
::link(new moodle_url('/notes/index.php?course=' . $course->id
. '&user='.$user->id
), get_string('notes','notes'));
681 if (has_capability('moodle/site:viewreports', $context) or has_capability('moodle/user:viewuseractivitiesreport', $usercontext)) {
682 $links[] = html_writer
::link(new moodle_url('/course/user.php?id='. $course->id
.'&user='. $user->id
), get_string('activity'));
685 if ($USER->id
!= $user->id
&& !\core\session\manager
::is_loggedinas() && has_capability('moodle/user:loginas', $context) && !is_siteadmin($user->id
)) {
686 $links[] = html_writer
::link(new moodle_url('/course/loginas.php?id='. $course->id
.'&user='. $user->id
.'&sesskey='. sesskey()), get_string('loginas'));
689 $links[] = html_writer
::link(new moodle_url('/user/view.php?id='. $user->id
.'&course='. $course->id
), get_string('fullprofile') . '...');
691 $row->cells
[2]->text
.= implode('', $links);
693 if ($bulkoperations) {
694 $row->cells
[2]->text
.= '<br /><input type="checkbox" class="usercheckbox" name="user'.$user->id
.'" /> ';
696 $table->data
= array($row);
697 echo html_writer
::table($table);
701 echo $OUTPUT->heading(get_string('nothingtodisplay'));
706 $countrysort = (strpos($sort, 'country') !== false);
707 $timeformat = get_string('strftimedate');
712 $usersprinted = array();
713 foreach ($userlist as $user) {
714 if (in_array($user->id
, $usersprinted)) { /// Prevent duplicates by r.hidden - MDL-13935
717 $usersprinted[] = $user->id
; /// Add new user to the array of users printed
719 context_helper
::preload_from_record($user);
721 if ($user->lastaccess
) {
722 $lastaccess = format_time(time() - $user->lastaccess
, $datestring);
724 $lastaccess = $strnever;
727 if (empty($user->country
)) {
732 $country = '('.$user->country
.') '.$countries[$user->country
];
735 $country = $countries[$user->country
];
739 $usercontext = context_user
::instance($user->id
);
741 if ($piclink = ($USER->id
== $user->id ||
has_capability('moodle/user:viewdetails', $context) ||
has_capability('moodle/user:viewdetails', $usercontext))) {
742 $profilelink = '<strong><a href="'.$CFG->wwwroot
.'/user/view.php?id='.$user->id
.'&course='.$course->id
.'">'.fullname($user).'</a></strong>';
744 $profilelink = '<strong>'.fullname($user).'</strong>';
748 if ($bulkoperations) {
749 $data[] = '<input type="checkbox" class="usercheckbox" name="user'.$user->id
.'" />';
751 $data[] = $OUTPUT->user_picture($user, array('size' => 35, 'courseid'=>$course->id
));
752 $data[] = $profilelink;
754 if ($mode === MODE_BRIEF
) {
755 foreach ($extrafields as $field) {
756 $data[] = $user->{$field};
759 if ($mode === MODE_BRIEF
&& !isset($hiddenfields['city'])) {
760 $data[] = $user->city
;
762 if ($mode === MODE_BRIEF
&& !isset($hiddenfields['country'])) {
765 if (!isset($hiddenfields['lastaccess'])) {
766 $data[] = $lastaccess;
769 if (isset($userlist_extra) && isset($userlist_extra[$user->id
])) {
770 $ras = $userlist_extra[$user->id
]['ra'];
772 foreach ($ras AS $key=>$ra) {
773 $rolename = $allrolenames[$ra['roleid']] ;
774 if ($ra['ctxlevel'] == CONTEXT_COURSECAT
) {
775 $rastring .= $rolename. ' @ ' . '<a href="'.$CFG->wwwroot
.'/course/index.php?categoryid='.$ra['ctxinstanceid'].'">'.s($ra['ccname']).'</a>';
776 } elseif ($ra['ctxlevel'] == CONTEXT_SYSTEM
) {
777 $rastring .= $rolename. ' - ' . get_string('globalrole','role');
779 $rastring .= $rolename;
783 if ($groupmode != 0) {
784 // htmlescape with s() and implode the array
785 $data[] = implode(', ', array_map('s',$userlist_extra[$user->id
]['group']));
786 $data[] = implode(', ', array_map('s', $userlist_extra[$user->id
]['gping']));
790 $table->add_data($data);
794 $table->print_html();
798 if ($bulkoperations) {
799 echo '<br /><div class="buttons">';
800 echo '<input type="button" id="checkall" value="'.get_string('selectall').'" /> ';
801 echo '<input type="button" id="checknone" value="'.get_string('deselectall').'" /> ';
802 $displaylist = array();
803 $displaylist['messageselect.php'] = get_string('messageselectadd');
804 if (!empty($CFG->enablenotes
) && has_capability('moodle/notes:manage', $context) && $context->id
!= $frontpagectx->id
) {
805 $displaylist['addnote.php'] = get_string('addnewnote', 'notes');
806 $displaylist['groupaddnote.php'] = get_string('groupaddnewnote', 'notes');
809 echo $OUTPUT->help_icon('withselectedusers');
810 echo html_writer
::tag('label', get_string("withselectedusers"), array('for'=>'formactionid'));
811 echo html_writer
::select($displaylist, 'formaction', '', array(''=>'choosedots'), array('id'=>'formactionid'));
813 echo '<input type="hidden" name="id" value="'.$course->id
.'" />';
814 echo '<noscript style="display:inline">';
815 echo '<div><input type="submit" value="'.get_string('ok').'" /></div>';
820 $module = array('name'=>'core_user', 'fullpath'=>'/user/module.js');
821 $PAGE->requires
->js_init_call('M.core_user.init_participation', null, false, $module);
824 // Show a search box if all participants don't fit on a single screen
825 if ($totalcount > $perpage) {
826 echo '<form action="index.php" class="searchform"><div><input type="hidden" name="id" value="'.$course->id
.'" />';
827 echo '<label for="search">' . get_string('search', 'search') . ' </label>';
828 echo '<input type="text" id="search" name="search" value="'.s($search).'" /> <input type="submit" value="'.get_string('search').'" /></div></form>'."\n";
831 $perpageurl = clone($baseurl);
832 $perpageurl->remove_params('perpage');
833 if ($perpage == SHOW_ALL_PAGE_SIZE
) {
834 $perpageurl->param('perpage', DEFAULT_PAGE_SIZE
);
835 echo $OUTPUT->container(html_writer
::link($perpageurl, get_string('showperpage', '', DEFAULT_PAGE_SIZE
)), array(), 'showall');
837 } else if ($matchcount > 0 && $perpage < $matchcount) {
838 $perpageurl->param('perpage', SHOW_ALL_PAGE_SIZE
);
839 echo $OUTPUT->container(html_writer
::link($perpageurl, get_string('showall', '', $matchcount)), array(), 'showall');
842 echo '</div>'; // userlist
844 echo $OUTPUT->footer();
851 function get_course_lastaccess_sql($accesssince='') {
852 if (empty($accesssince)) {
855 if ($accesssince == -1) { // never
856 return 'ul.timeaccess = 0';
858 return 'ul.timeaccess != 0 AND ul.timeaccess < '.$accesssince;
862 function get_user_lastaccess_sql($accesssince='') {
863 if (empty($accesssince)) {
866 if ($accesssince == -1) { // never
867 return 'u.lastaccess = 0';
869 return 'u.lastaccess != 0 AND u.lastaccess < '.$accesssince;