2 // This file is part of Moodle - http://moodle.org/
4 // Moodle is free software: you can redistribute it and/or modify
5 // it under the terms of the GNU General Public License as published by
6 // the Free Software Foundation, either version 3 of the License, or
7 // (at your option) any later version.
9 // Moodle is distributed in the hope that it will be useful,
10 // but WITHOUT ANY WARRANTY; without even the implied warranty of
11 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 // GNU General Public License for more details.
14 // You should have received a copy of the GNU General Public License
15 // along with Moodle. If not, see <http://www.gnu.org/licenses/>.
18 * Lists all the users within a given course.
20 * @copyright 1999 Martin Dougiamas http://dougiamas.com
21 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
25 require_once('../config.php');
26 require_once($CFG->dirroot
.'/user/lib.php');
27 require_once($CFG->libdir
.'/tablelib.php');
28 require_once($CFG->libdir
.'/filelib.php');
30 define('USER_SMALL_CLASS', 20); // Below this is considered small.
31 define('USER_LARGE_CLASS', 200); // Above this is considered large.
32 define('DEFAULT_PAGE_SIZE', 20);
33 define('SHOW_ALL_PAGE_SIZE', 5000);
34 define('MODE_BRIEF', 0);
35 define('MODE_USERDETAILS', 1);
37 $page = optional_param('page', 0, PARAM_INT
); // Which page to show.
38 $perpage = optional_param('perpage', DEFAULT_PAGE_SIZE
, PARAM_INT
); // How many per page.
39 $mode = optional_param('mode', null, PARAM_INT
); // Use the MODE_ constants.
40 $accesssince = optional_param('accesssince', 0, PARAM_INT
); // Filter by last access. -1 = never.
41 $search = optional_param('search', '', PARAM_RAW
); // Make sure it is processed with p() or s() when sending to output!
42 $roleid = optional_param('roleid', 0, PARAM_INT
); // Optional roleid, 0 means all enrolled users (or all on the frontpage).
43 $contextid = optional_param('contextid', 0, PARAM_INT
); // One of this or.
44 $courseid = optional_param('id', 0, PARAM_INT
); // This are required.
45 $selectall = optional_param('selectall', false, PARAM_BOOL
); // When rendering checkboxes against users mark them all checked.
47 $PAGE->set_url('/user/index.php', array(
49 'perpage' => $perpage,
51 'accesssince' => $accesssince,
54 'contextid' => $contextid,
58 $context = context
::instance_by_id($contextid, MUST_EXIST
);
59 if ($context->contextlevel
!= CONTEXT_COURSE
) {
60 print_error('invalidcontext');
62 $course = $DB->get_record('course', array('id' => $context->instanceid
), '*', MUST_EXIST
);
64 $course = $DB->get_record('course', array('id' => $courseid), '*', MUST_EXIST
);
65 $context = context_course
::instance($course->id
, MUST_EXIST
);
67 // Not needed anymore.
71 require_login($course);
73 $systemcontext = context_system
::instance();
74 $isfrontpage = ($course->id
== SITEID
);
76 $frontpagectx = context_course
::instance(SITEID
);
79 $PAGE->set_pagelayout('admin');
80 require_capability('moodle/site:viewparticipants', $systemcontext);
82 $PAGE->set_pagelayout('incourse');
83 require_capability('moodle/course:viewparticipants', $context);
86 $rolenamesurl = new moodle_url("$CFG->wwwroot/user/index.php?contextid=$context->id&sifirst=&silast=");
88 $rolenames = role_fix_names(get_profile_roles($context), $context, ROLENAME_ALIAS
, true);
90 $rolenames[0] = get_string('allsiteusers', 'role');
92 $rolenames[0] = get_string('allparticipants');
95 // Make sure other roles may not be selected by any means.
96 if (empty($rolenames[$roleid])) {
97 print_error('noparticipants');
100 // No roles to display yet?
101 // frontpage course is an exception, on the front page course we should display all users.
102 if (empty($rolenames) && !$isfrontpage) {
103 if (has_capability('moodle/role:assign', $context)) {
104 redirect($CFG->wwwroot
.'/'.$CFG->admin
.'/roles/assign.php?contextid='.$context->id
);
106 print_error('noparticipants');
111 user_list_view($course, $context);
113 $bulkoperations = has_capability('moodle/course:bulkmessaging', $context);
115 $countries = get_string_manager()->get_list_of_countries();
117 $strnever = get_string('never');
119 $datestring = new stdClass();
120 $datestring->year
= get_string('year');
121 $datestring->years
= get_string('years');
122 $datestring->day
= get_string('day');
123 $datestring->days
= get_string('days');
124 $datestring->hour
= get_string('hour');
125 $datestring->hours
= get_string('hours');
126 $datestring->min
= get_string('min');
127 $datestring->mins
= get_string('mins');
128 $datestring->sec
= get_string('sec');
129 $datestring->secs
= get_string('secs');
131 if ($mode !== null) {
133 $SESSION->userindexmode
= $mode;
134 } else if (isset($SESSION->userindexmode
)) {
135 $mode = (int)$SESSION->userindexmode
;
140 // Check to see if groups are being used in this course
141 // and if so, set $currentgroup to reflect the current group.
143 $groupmode = groups_get_course_groupmode($course); // Groups are being used.
144 $currentgroup = groups_get_course_group($course, true);
146 if (!$currentgroup) { // To make some other functions work better later.
147 $currentgroup = null;
150 $isseparategroups = ($course->groupmode
== SEPARATEGROUPS
and !has_capability('moodle/site:accessallgroups', $context));
152 $PAGE->set_title("$course->shortname: ".get_string('participants'));
153 $PAGE->set_heading($course->fullname
);
154 $PAGE->set_pagetype('course-view-' . $course->format
);
155 $PAGE->add_body_class('path-user'); // So we can style it independently.
156 $PAGE->set_other_editing_capability('moodle/course:manageactivities');
158 echo $OUTPUT->header();
159 echo $OUTPUT->heading(get_string('participants'));
161 echo '<div class="userlist">';
163 if ($isseparategroups and (!$currentgroup) ) {
164 // The user is not in the group so show message and exit.
165 echo $OUTPUT->heading(get_string("notingroup"));
166 echo $OUTPUT->footer();
171 // Should use this variable so that we don't break stuff every time a variable is added or changed.
172 $baseurl = new moodle_url('/user/index.php', array(
173 'contextid' => $context->id
,
176 'perpage' => $perpage,
177 'accesssince' => $accesssince,
178 'search' => s($search)));
181 if ($course->id
== SITEID
) {
182 $filtertype = 'site';
183 } else if ($course->id
&& !$currentgroup) {
184 $filtertype = 'course';
185 $filterselect = $course->id
;
187 $filtertype = 'group';
188 $filterselect = $currentgroup;
193 // Get the hidden field list.
194 if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
195 $hiddenfields = array(); // Teachers and admins are allowed to see everything.
197 $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields
));
200 if (isset($hiddenfields['lastaccess'])) {
201 // Do not allow access since filtering.
205 // Print settings and things in a table across the top.
206 $controlstable = new html_table();
207 $controlstable->attributes
['class'] = 'controls';
208 $controlstable->cellspacing
= 0;
209 $controlstable->data
[] = new html_table_row();
211 // Print my course menus.
212 if ($mycourses = enrol_get_my_courses()) {
213 $courselist = array();
214 $popupurl = new moodle_url('/user/index.php?roleid='.$roleid.'&sifirst=&silast=');
215 foreach ($mycourses as $mycourse) {
216 $coursecontext = context_course
::instance($mycourse->id
);
217 $courselist[$mycourse->id
] = format_string($mycourse->shortname
, true, array('context' => $coursecontext));
219 if (has_capability('moodle/site:viewparticipants', $systemcontext)) {
220 unset($courselist[SITEID
]);
221 $courselist = array(SITEID
=> format_string($SITE->shortname
, true, array('context' => $systemcontext))) +
$courselist;
223 $select = new single_select($popupurl, 'id', $courselist, $course->id
, null, 'courseform');
224 $select->set_label(get_string('mycourses'));
225 $controlstable->data
[0]->cells
[] = $OUTPUT->render($select);
228 if ($groupmenu = groups_print_course_menu($course, $baseurl->out(), true)) {
229 $controlstable->data
[0]->cells
[] = $groupmenu;
232 if (!isset($hiddenfields['lastaccess'])) {
233 // Get minimum lastaccess for this course and display a dropbox to filter by lastaccess going back this far.
234 // We need to make it diferently for normal courses and site course.
236 $minlastaccess = $DB->get_field_sql('SELECT min(timeaccess)
237 FROM {user_lastaccess}
239 AND timeaccess != 0', array($course->id
));
240 $lastaccess0exists = $DB->record_exists('user_lastaccess', array('courseid' => $course->id
, 'timeaccess' => 0));
242 $minlastaccess = $DB->get_field_sql('SELECT min(lastaccess)
244 WHERE lastaccess != 0');
245 $lastaccess0exists = $DB->record_exists('user', array('lastaccess' => 0));
248 $now = usergetmidnight(time());
249 $timeaccess = array();
250 $baseurl->remove_params('accesssince');
252 // Makes sense for this to go first.
253 $timeoptions[0] = get_string('selectperiod');
256 for ($i = 1; $i < 7; $i++
) {
257 if (strtotime('-'.$i.' days', $now) >= $minlastaccess) {
258 $timeoptions[strtotime('-'.$i.' days', $now)] = get_string('numdays', 'moodle', $i);
262 for ($i = 1; $i < 10; $i++
) {
263 if (strtotime('-'.$i.' weeks', $now) >= $minlastaccess) {
264 $timeoptions[strtotime('-'.$i.' weeks', $now)] = get_string('numweeks', 'moodle', $i);
268 for ($i = 2; $i < 12; $i++
) {
269 if (strtotime('-'.$i.' months', $now) >= $minlastaccess) {
270 $timeoptions[strtotime('-'.$i.' months', $now)] = get_string('nummonths', 'moodle', $i);
274 if (strtotime('-1 year', $now) >= $minlastaccess) {
275 $timeoptions[strtotime('-1 year', $now)] = get_string('lastyear');
278 if (!empty($lastaccess0exists)) {
279 $timeoptions[-1] = get_string('never');
282 if (count($timeoptions) > 1) {
283 $select = new single_select($baseurl, 'accesssince', $timeoptions, $accesssince, null, 'timeoptions');
284 $select->set_label(get_string('usersnoaccesssince'));
285 $controlstable->data
[0]->cells
[] = $OUTPUT->render($select);
289 $formatmenu = array( '0' => get_string('brief'),
290 '1' => get_string('userdetails'));
291 $select = new single_select($baseurl, 'mode', $formatmenu, $mode, null, 'formatmenu');
292 $select->set_label(get_string('userlist'));
293 $userlistcell = new html_table_cell();
294 $userlistcell->attributes
['class'] = 'right';
295 $userlistcell->text
= $OUTPUT->render($select);
296 $controlstable->data
[0]->cells
[] = $userlistcell;
298 echo html_writer
::table($controlstable);
300 if ($currentgroup and (!$isseparategroups or has_capability('moodle/site:accessallgroups', $context))) {
301 // Display info about the group.
302 if ($group = groups_get_group($currentgroup)) {
303 if (!empty($group->description
) or (!empty($group->picture
) and empty($group->hidepicture
))) {
304 $groupinfotable = new html_table();
305 $groupinfotable->attributes
['class'] = 'groupinfobox';
306 $picturecell = new html_table_cell();
307 $picturecell->attributes
['class'] = 'left side picture';
308 $picturecell->text
= print_group_picture($group, $course->id
, true, true, false);
310 $contentcell = new html_table_cell();
311 $contentcell->attributes
['class'] = 'content';
313 $contentheading = $group->name
;
314 if (has_capability('moodle/course:managegroups', $context)) {
315 $aurl = new moodle_url('/group/group.php', array('id' => $group->id
, 'courseid' => $group->courseid
));
316 $contentheading .= ' ' . $OUTPUT->action_icon($aurl, new pix_icon('t/edit', get_string('editgroupprofile')));
319 $group->description
= file_rewrite_pluginfile_urls($group->description
, 'pluginfile.php', $context->id
, 'group',
320 'description', $group->id
);
321 if (!isset($group->descriptionformat
)) {
322 $group->descriptionformat
= FORMAT_MOODLE
;
324 $options = array('overflowdiv' => true);
325 $formatteddesc = format_text($group->description
, $group->descriptionformat
, $options);
326 $contentcell->text
= $OUTPUT->heading($contentheading, 3) . $formatteddesc;
327 $groupinfotable->data
[] = new html_table_row(array($picturecell, $contentcell));
328 echo html_writer
::table($groupinfotable);
333 // Define a table showing a list of users in the current role selection.
334 $tablecolumns = array();
335 $tableheaders = array();
336 if ($bulkoperations && $mode === MODE_BRIEF
) {
337 $tablecolumns[] = 'select';
338 $tableheaders[] = get_string('select');
340 $tablecolumns[] = 'userpic';
341 $tablecolumns[] = 'fullname';
343 $extrafields = get_extra_user_fields($context);
344 $tableheaders[] = get_string('userpic');
345 $tableheaders[] = get_string('fullnameuser');
347 if ($mode === MODE_BRIEF
) {
348 foreach ($extrafields as $field) {
349 $tablecolumns[] = $field;
350 $tableheaders[] = get_user_field_name($field);
353 if ($mode === MODE_BRIEF
&& !isset($hiddenfields['city'])) {
354 $tablecolumns[] = 'city';
355 $tableheaders[] = get_string('city');
357 if ($mode === MODE_BRIEF
&& !isset($hiddenfields['country'])) {
358 $tablecolumns[] = 'country';
359 $tableheaders[] = get_string('country');
361 if (!isset($hiddenfields['lastaccess'])) {
362 $tablecolumns[] = 'lastaccess';
363 if ($course->id
== SITEID
) {
364 // Exception case for viewing participants on site home.
365 $tableheaders[] = get_string('lastsiteaccess');
367 $tableheaders[] = get_string('lastcourseaccess');
371 if ($bulkoperations && $mode === MODE_USERDETAILS
) {
372 $tablecolumns[] = 'select';
373 $tableheaders[] = get_string('select');
376 $table = new flexible_table('user-index-participants-'.$course->id
);
377 $table->define_columns($tablecolumns);
378 $table->define_headers($tableheaders);
379 $table->define_baseurl($baseurl->out());
381 if (!isset($hiddenfields['lastaccess'])) {
382 $table->sortable(true, 'lastaccess', SORT_DESC
);
384 $table->sortable(true, 'firstname', SORT_ASC
);
387 $table->no_sorting('roles');
388 $table->no_sorting('groups');
389 $table->no_sorting('groupings');
390 $table->no_sorting('select');
392 $table->set_attribute('cellspacing', '0');
393 $table->set_attribute('id', 'participants');
394 $table->set_attribute('class', 'generaltable generalbox');
396 $table->set_control_variables(array(
397 TABLE_VAR_SORT
=> 'ssort',
398 TABLE_VAR_HIDE
=> 'shide',
399 TABLE_VAR_SHOW
=> 'sshow',
400 TABLE_VAR_IFIRST
=> 'sifirst',
401 TABLE_VAR_ILAST
=> 'silast',
402 TABLE_VAR_PAGE
=> 'spage'
406 list($esql, $params) = get_enrolled_sql($context, null, $currentgroup, true);
407 $joins = array("FROM {user} u");
410 $userfields = array('username', 'email', 'city', 'country', 'lang', 'timezone', 'maildisplay');
411 $mainuserfields = user_picture
::fields('u', $userfields);
412 $extrasql = get_extra_user_fields_sql($context, 'u', '', $userfields);
415 $select = "SELECT $mainuserfields, u.lastaccess$extrasql";
416 $joins[] = "JOIN ($esql) e ON e.id = u.id"; // Everybody on the frontpage usually.
418 $wheres[] = get_user_lastaccess_sql($accesssince);
422 $select = "SELECT $mainuserfields, COALESCE(ul.timeaccess, 0) AS lastaccess$extrasql";
423 $joins[] = "JOIN ($esql) e ON e.id = u.id"; // Course enrolled users only.
424 $joins[] = "LEFT JOIN {user_lastaccess} ul ON (ul.userid = u.id AND ul.courseid = :courseid)"; // Not everybody accessed course yet.
425 $params['courseid'] = $course->id
;
427 $wheres[] = get_course_lastaccess_sql($accesssince);
431 // Performance hacks - we preload user contexts together with accounts.
432 $ccselect = ', ' . context_helper
::get_preload_record_columns_sql('ctx');
433 $ccjoin = "LEFT JOIN {context} ctx ON (ctx.instanceid = u.id AND ctx.contextlevel = :contextlevel)";
434 $params['contextlevel'] = CONTEXT_USER
;
435 $select .= $ccselect;
439 // Limit list to users with some role only.
441 // We want to query both the current context and parent contexts.
442 list($relatedctxsql, $relatedctxparams) = $DB->get_in_or_equal($context->get_parent_context_ids(true), SQL_PARAMS_NAMED
, 'relatedctx');
444 $wheres[] = "u.id IN (SELECT userid FROM {role_assignments} WHERE roleid = :roleid AND contextid $relatedctxsql)";
445 $params = array_merge($params, array('roleid' => $roleid), $relatedctxparams);
448 $from = implode("\n", $joins);
450 $where = "WHERE " . implode(" AND ", $wheres);
455 $totalcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
457 if (!empty($search)) {
458 $fullname = $DB->sql_fullname('u.firstname', 'u.lastname');
459 $wheres[] = "(". $DB->sql_like($fullname, ':search1', false, false) .
460 " OR ". $DB->sql_like('email', ':search2', false, false) .
461 " OR ". $DB->sql_like('idnumber', ':search3', false, false) .") ";
462 $params['search1'] = "%$search%";
463 $params['search2'] = "%$search%";
464 $params['search3'] = "%$search%";
467 list($twhere, $tparams) = $table->get_sql_where();
470 $params = array_merge($params, $tparams);
473 $from = implode("\n", $joins);
475 $where = "WHERE " . implode(" AND ", $wheres);
480 if ($table->get_sql_sort()) {
481 $sort = ' ORDER BY '.$table->get_sql_sort();
486 $matchcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
488 $table->initialbars(true);
489 $table->pagesize($perpage, $matchcount);
491 // List of users at the current visible page - paging makes it relatively short.
492 $userlist = $DB->get_recordset_sql("$select $from $where $sort", $params, $table->get_page_start(), $table->get_page_size());
494 // If there are multiple Roles in the course, then show a drop down menu for switching.
495 if (count($rolenames) > 1) {
496 echo '<div class="rolesform">';
497 echo $OUTPUT->single_select($rolenamesurl, 'roleid', $rolenames, $roleid, null,
498 'rolesform', array('label' => get_string('currentrole', 'role')));
501 } else if (count($rolenames) == 1) {
502 // When all users with the same role - print its name.
503 echo '<div class="rolesform">';
504 echo get_string('role').get_string('labelsep', 'langconfig');
505 $rolename = reset($rolenames);
511 if ($course->id
!= SITEID
&& has_capability('moodle/course:enrolreview', $context)) {
512 $editlink = new moodle_url('/enrol/users.php', array('id' => $course->id
));
517 $a->number
= $totalcount;
518 $a->role
= $rolenames[$roleid];
519 $heading = format_string(get_string('xuserswiththerole', 'role', $a));
521 if ($currentgroup and !empty($group)) {
522 $a->group
= $group->name
;
523 $heading .= ' ' . format_string(get_string('ingroup', 'role', $a));
526 if ($accesssince && !empty($timeoptions[$accesssince])) {
527 $a->timeperiod
= $timeoptions[$accesssince];
528 $heading .= ' ' . format_string(get_string('inactiveformorethan', 'role', $a));
531 $heading .= ": $a->number";
533 if (!empty($editlink)) {
534 $editlink->param('role', $roleid);
535 $heading .= $OUTPUT->action_icon($editlink, new pix_icon('t/edit', get_string('edit')));
537 echo $OUTPUT->heading($heading, 3);
539 if ($course->id
== SITEID
and $roleid < 0) {
540 $strallparticipants = get_string('allsiteusers', 'role');
542 $strallparticipants = get_string('allparticipants');
545 if (!empty($editlink)) {
546 $editlink = $OUTPUT->action_icon($editlink, new pix_icon('t/edit', get_string('edit')));
549 if ($matchcount < $totalcount) {
550 echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount.'/'.$totalcount . $editlink, 3);
552 echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount . $editlink, 3);
557 if ($bulkoperations) {
558 echo '<form action="action_redir.php" method="post" id="participantsform">';
560 echo '<input type="hidden" name="sesskey" value="'.sesskey().'" />';
561 echo '<input type="hidden" name="returnto" value="'.s($PAGE->url
->out(false)).'" />';
564 if ($mode === MODE_USERDETAILS
) { // Print simple listing.
565 if ($totalcount < 1) {
566 echo $OUTPUT->heading(get_string('nothingtodisplay'));
568 if ($totalcount > $perpage) {
570 $firstinitial = $table->get_initial_first();
571 $lastinitial = $table->get_initial_last();
572 $strall = get_string('all');
573 $alpha = explode(',', get_string('alphabet', 'langconfig'));
575 // Bar of first initials.
577 echo '<div class="initialbar firstinitial">'.get_string('firstname').' : ';
578 if (!empty($firstinitial)) {
579 echo '<a href="'.$baseurl->out().'&sifirst=">'.$strall.'</a>';
581 echo '<strong>'.$strall.'</strong>';
583 foreach ($alpha as $letter) {
584 if ($letter == $firstinitial) {
585 echo ' <strong>'.$letter.'</strong>';
587 echo ' <a href="'.$baseurl->out().'&sifirst='.$letter.'">'.$letter.'</a>';
592 // Bar of last initials.
594 echo '<div class="initialbar lastinitial">'.get_string('lastname').' : ';
595 if (!empty($lastinitial)) {
596 echo '<a href="'.$baseurl->out().'&silast=">'.$strall.'</a>';
598 echo '<strong>'.$strall.'</strong>';
600 foreach ($alpha as $letter) {
601 if ($letter == $lastinitial) {
602 echo ' <strong>'.$letter.'</strong>';
604 echo ' <a href="'.$baseurl->out().'&silast='.$letter.'">'.$letter.'</a>';
609 $pagingbar = new paging_bar($matchcount, intval($table->get_page_start() / $perpage), $perpage, $baseurl);
610 $pagingbar->pagevar
= 'spage';
611 echo $OUTPUT->render($pagingbar);
614 if ($matchcount > 0) {
615 $usersprinted = array();
616 foreach ($userlist as $user) {
617 if (in_array($user->id
, $usersprinted)) { // Prevent duplicates by r.hidden - MDL-13935.
620 $usersprinted[] = $user->id
; // Add new user to the array of users printed.
622 context_helper
::preload_from_record($user);
624 $context = context_course
::instance($course->id
);
625 $usercontext = context_user
::instance($user->id
);
627 $countries = get_string_manager()->get_list_of_countries();
629 // Get the hidden field list.
630 if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
631 $hiddenfields = array();
633 $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields
));
635 $table = new html_table();
636 $table->attributes
['class'] = 'userinfobox';
638 $row = new html_table_row();
639 $row->cells
[0] = new html_table_cell();
640 $row->cells
[0]->attributes
['class'] = 'left side';
642 $row->cells
[0]->text
= $OUTPUT->user_picture($user, array('size' => 100, 'courseid' => $course->id
));
643 $row->cells
[1] = new html_table_cell();
644 $row->cells
[1]->attributes
['class'] = 'content';
646 $row->cells
[1]->text
= $OUTPUT->container(fullname($user, has_capability('moodle/site:viewfullnames', $context)), 'username');
647 $row->cells
[1]->text
.= $OUTPUT->container_start('info');
649 if (!empty($user->role
)) {
650 $row->cells
[1]->text
.= get_string('role').get_string('labelsep', 'langconfig').$user->role
.'<br />';
652 if ($user->maildisplay
== 1 or ($user->maildisplay
== 2 and ($course->id
!= SITEID
) and !isguestuser()) or
653 in_array('email', $extrafields) or ($user->id
== $USER->id
)) {
654 $row->cells
[1]->text
.= get_string('email').get_string('labelsep', 'langconfig').html_writer
::link("mailto:$user->email", $user->email
) . '<br />';
656 foreach ($extrafields as $field) {
657 if ($field === 'email') {
658 // Skip email because it was displayed with different logic above
659 // because this page is intended for students too.
662 $row->cells
[1]->text
.= get_user_field_name($field) .
663 get_string('labelsep', 'langconfig') . s($user->{$field}) . '<br />';
665 if (($user->city
or $user->country
) and (!isset($hiddenfields['city']) or !isset($hiddenfields['country']))) {
666 $row->cells
[1]->text
.= get_string('city').get_string('labelsep', 'langconfig');
667 if ($user->city
&& !isset($hiddenfields['city'])) {
668 $row->cells
[1]->text
.= $user->city
;
670 if (!empty($countries[$user->country
]) && !isset($hiddenfields['country'])) {
671 if ($user->city
&& !isset($hiddenfields['city'])) {
672 $row->cells
[1]->text
.= ', ';
674 $row->cells
[1]->text
.= $countries[$user->country
];
676 $row->cells
[1]->text
.= '<br />';
679 if (!isset($hiddenfields['lastaccess'])) {
680 if ($user->lastaccess
) {
681 $row->cells
[1]->text
.= get_string('lastaccess').get_string('labelsep', 'langconfig').userdate($user->lastaccess
);
682 $row->cells
[1]->text
.= ' ('. format_time(time() - $user->lastaccess
, $datestring) .')';
684 $row->cells
[1]->text
.= get_string('lastaccess').get_string('labelsep', 'langconfig').get_string('never');
688 $row->cells
[1]->text
.= $OUTPUT->container_end();
690 $row->cells
[2] = new html_table_cell();
691 $row->cells
[2]->attributes
['class'] = 'links';
692 $row->cells
[2]->text
= '';
696 if ($CFG->enableblogs
&& ($CFG->bloglevel
!= BLOG_USER_LEVEL ||
$USER->id
== $user->id
)) {
697 $links[] = html_writer
::link(new moodle_url('/blog/index.php?userid='.$user->id
), get_string('blogs', 'blog'));
700 if (!empty($CFG->enablenotes
) and (has_capability('moodle/notes:manage', $context) ||
has_capability('moodle/notes:view', $context))) {
701 $links[] = html_writer
::link(new moodle_url('/notes/index.php?course=' . $course->id
. '&user='.$user->id
), get_string('notes', 'notes'));
704 if (has_capability('moodle/site:viewreports', $context) or has_capability('moodle/user:viewuseractivitiesreport', $usercontext)) {
705 $links[] = html_writer
::link(new moodle_url('/course/user.php?id='. $course->id
.'&user='. $user->id
), get_string('activity'));
708 if ($USER->id
!= $user->id
&& !\core\session\manager
::is_loggedinas() && has_capability('moodle/user:loginas', $context) && !is_siteadmin($user->id
)) {
709 $links[] = html_writer
::link(new moodle_url('/course/loginas.php?id='. $course->id
.'&user='. $user->id
.'&sesskey='. sesskey()), get_string('loginas'));
712 $links[] = html_writer
::link(new moodle_url('/user/view.php?id='. $user->id
.'&course='. $course->id
), get_string('fullprofile') . '...');
714 $row->cells
[2]->text
.= implode('', $links);
716 if ($bulkoperations) {
718 $checked = 'checked="true"';
722 $row->cells
[2]->text
.= '<br /><input type="checkbox" class="usercheckbox" name="user'.$user->id
.'" ' .$checked .'/> ';
724 $table->data
= array($row);
725 echo html_writer
::table($table);
729 echo $OUTPUT->heading(get_string('nothingtodisplay'));
734 $countrysort = (strpos($sort, 'country') !== false);
735 $timeformat = get_string('strftimedate');
740 $usersprinted = array();
741 foreach ($userlist as $user) {
742 if (in_array($user->id
, $usersprinted)) { // Prevent duplicates by r.hidden - MDL-13935.
745 $usersprinted[] = $user->id
; // Add new user to the array of users printed.
747 context_helper
::preload_from_record($user);
749 if ($user->lastaccess
) {
750 $lastaccess = format_time(time() - $user->lastaccess
, $datestring);
752 $lastaccess = $strnever;
755 if (empty($user->country
)) {
760 $country = '('.$user->country
.') '.$countries[$user->country
];
762 $country = $countries[$user->country
];
766 $usercontext = context_user
::instance($user->id
);
768 if ($piclink = ($USER->id
== $user->id ||
has_capability('moodle/user:viewdetails', $context) ||
has_capability('moodle/user:viewdetails', $usercontext))) {
769 $profilelink = '<strong><a href="'.$CFG->wwwroot
.'/user/view.php?id='.$user->id
.'&course='.$course->id
.'">'.fullname($user).'</a></strong>';
771 $profilelink = '<strong>'.fullname($user).'</strong>';
775 if ($bulkoperations) {
777 $checked = 'checked="true"';
781 $data[] = '<input type="checkbox" class="usercheckbox" name="user'.$user->id
.'" ' . $checked .'/>';
783 $data[] = $OUTPUT->user_picture($user, array('size' => 35, 'courseid' => $course->id
));
784 $data[] = $profilelink;
786 if ($mode === MODE_BRIEF
) {
787 foreach ($extrafields as $field) {
788 $data[] = $user->{$field};
791 if ($mode === MODE_BRIEF
&& !isset($hiddenfields['city'])) {
792 $data[] = $user->city
;
794 if ($mode === MODE_BRIEF
&& !isset($hiddenfields['country'])) {
797 if (!isset($hiddenfields['lastaccess'])) {
798 $data[] = $lastaccess;
801 $table->add_data($data);
805 $table->print_html();
809 if ($bulkoperations) {
810 echo '<br /><div class="buttons">';
812 if ($matchcount > 0 && $perpage < $matchcount) {
813 $perpageurl = clone($baseurl);
814 $perpageurl->remove_params('perpage');
815 $perpageurl->param('perpage', SHOW_ALL_PAGE_SIZE
);
816 $perpageurl->param('selectall', true);
817 $showalllink = $perpageurl;
819 $showalllink = false;
822 if ($perpage < $matchcount) {
823 // Select all users, refresh page showing all users and mark them all selected.
824 $label = get_string('selectalluserswithcount', 'moodle', $matchcount);
825 echo '<input type="button" id="checkall" value="' . $label . '" data-showallink="' . $showalllink . '" /> ';
826 // Select all users, mark all users on page as selected.
827 echo '<input type="button" id="checkallonpage" value="' . get_string('selectallusersonpage') . '" /> ';
829 echo '<input type="button" id="checkallonpage" value="' . get_string('selectall') . '" /> ';
832 echo '<input type="button" id="checknone" value="'.get_string('deselectall').'" /> ';
833 $displaylist = array();
834 $displaylist['messageselect.php'] = get_string('messageselectadd');
835 if (!empty($CFG->enablenotes
) && has_capability('moodle/notes:manage', $context) && $context->id
!= $frontpagectx->id
) {
836 $displaylist['addnote.php'] = get_string('addnewnote', 'notes');
837 $displaylist['groupaddnote.php'] = get_string('groupaddnewnote', 'notes');
840 echo $OUTPUT->help_icon('withselectedusers');
841 echo html_writer
::tag('label', get_string("withselectedusers"), array('for' => 'formactionid'));
842 echo html_writer
::select($displaylist, 'formaction', '', array('' => 'choosedots'), array('id' => 'formactionid'));
844 echo '<input type="hidden" name="id" value="'.$course->id
.'" />';
845 echo '<noscript style="display:inline">';
846 echo '<div><input type="submit" value="'.get_string('ok').'" /></div>';
851 $module = array('name' => 'core_user', 'fullpath' => '/user/module.js');
852 $PAGE->requires
->js_init_call('M.core_user.init_participation', null, false, $module);
855 // Show a search box if all participants don't fit on a single screen.
856 if ($totalcount > $perpage) {
857 echo '<form action="index.php" class="searchform"><div><input type="hidden" name="id" value="'.$course->id
.'" />';
858 echo '<label for="search">' . get_string('search', 'search') . ' </label>';
859 echo '<input type="text" id="search" name="search" value="'.s($search).'" /> <input type="submit" value="'.get_string('search').'" /></div></form>'."\n";
862 $perpageurl = clone($baseurl);
863 $perpageurl->remove_params('perpage');
864 if ($perpage == SHOW_ALL_PAGE_SIZE
) {
865 $perpageurl->param('perpage', DEFAULT_PAGE_SIZE
);
866 echo $OUTPUT->container(html_writer
::link($perpageurl, get_string('showperpage', '', DEFAULT_PAGE_SIZE
)), array(), 'showall');
868 } else if ($matchcount > 0 && $perpage < $matchcount) {
869 $perpageurl->param('perpage', SHOW_ALL_PAGE_SIZE
);
870 echo $OUTPUT->container(html_writer
::link($perpageurl, get_string('showall', '', $matchcount)), array(), 'showall');
873 echo '</div>'; // Userlist.
875 echo $OUTPUT->footer();
882 * Returns SQL that can be used to limit a query to a period where the user last accessed a course..
884 * @param string $accesssince
887 function get_course_lastaccess_sql($accesssince='') {
888 if (empty($accesssince)) {
891 if ($accesssince == -1) { // Never.
892 return 'ul.timeaccess = 0';
894 return 'ul.timeaccess != 0 AND ul.timeaccess < '.$accesssince;
899 * Returns SQL that can be used to limit a query to a period where the user last accessed the system.
901 * @param string $accesssince
904 function get_user_lastaccess_sql($accesssince='') {
905 if (empty($accesssince)) {
908 if ($accesssince == -1) { // Never.
909 return 'u.lastaccess = 0';
911 return 'u.lastaccess != 0 AND u.lastaccess < '.$accesssince;