weekly release 3.4dev
[moodle.git] / user / index.php
CommitLineData
aa6c1ced 1<?php
a2ed6e69
SH
2// This file is part of Moodle - http://moodle.org/
3//
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.
8//
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.
13//
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/>.
16
17/**
18 * Lists all the users within a given course.
19 *
20 * @copyright 1999 Martin Dougiamas http://dougiamas.com
21 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
22 * @package core_user
23 */
24
25require_once('../config.php');
0ff203b6 26require_once($CFG->dirroot.'/user/lib.php');
a2ed6e69
SH
27require_once($CFG->libdir.'/tablelib.php');
28require_once($CFG->libdir.'/filelib.php');
29
30define('USER_SMALL_CLASS', 20); // Below this is considered small.
31define('USER_LARGE_CLASS', 200); // Above this is considered large.
32define('DEFAULT_PAGE_SIZE', 20);
33define('SHOW_ALL_PAGE_SIZE', 5000);
34define('MODE_BRIEF', 0);
35define('MODE_USERDETAILS', 1);
36
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.
5b7c500a 45$selectall = optional_param('selectall', false, PARAM_BOOL); // When rendering checkboxes against users mark them all checked.
a2ed6e69
SH
46
47$PAGE->set_url('/user/index.php', array(
48 'page' => $page,
49 'perpage' => $perpage,
50 'mode' => $mode,
51 'accesssince' => $accesssince,
52 'search' => $search,
53 'roleid' => $roleid,
54 'contextid' => $contextid,
55 'id' => $courseid));
56
57if ($contextid) {
58 $context = context::instance_by_id($contextid, MUST_EXIST);
59 if ($context->contextlevel != CONTEXT_COURSE) {
60 print_error('invalidcontext');
61 }
62 $course = $DB->get_record('course', array('id' => $context->instanceid), '*', MUST_EXIST);
63} else {
64 $course = $DB->get_record('course', array('id' => $courseid), '*', MUST_EXIST);
65 $context = context_course::instance($course->id, MUST_EXIST);
66}
67// Not needed anymore.
68unset($contextid);
69unset($courseid);
f9903ed0 70
a2ed6e69 71require_login($course);
f9903ed0 72
a2ed6e69
SH
73$systemcontext = context_system::instance();
74$isfrontpage = ($course->id == SITEID);
f9903ed0 75
a2ed6e69 76$frontpagectx = context_course::instance(SITEID);
4f0c2d00 77
a2ed6e69
SH
78if ($isfrontpage) {
79 $PAGE->set_pagelayout('admin');
80 require_capability('moodle/site:viewparticipants', $systemcontext);
81} else {
82 $PAGE->set_pagelayout('incourse');
83 require_capability('moodle/course:viewparticipants', $context);
84}
224aa44a 85
a2ed6e69 86$rolenamesurl = new moodle_url("$CFG->wwwroot/user/index.php?contextid=$context->id&sifirst=&silast=");
6d3c57f4 87
a2ed6e69
SH
88$rolenames = role_fix_names(get_profile_roles($context), $context, ROLENAME_ALIAS, true);
89if ($isfrontpage) {
90 $rolenames[0] = get_string('allsiteusers', 'role');
91} else {
92 $rolenames[0] = get_string('allparticipants');
93}
d7270311 94
a2ed6e69
SH
95// Make sure other roles may not be selected by any means.
96if (empty($rolenames[$roleid])) {
97 print_error('noparticipants');
98}
5f9e296a 99
a2ed6e69
SH
100// No roles to display yet?
101// frontpage course is an exception, on the front page course we should display all users.
102if (empty($rolenames) && !$isfrontpage) {
103 if (has_capability('moodle/role:assign', $context)) {
104 redirect($CFG->wwwroot.'/'.$CFG->admin.'/roles/assign.php?contextid='.$context->id);
105 } else {
4f0c2d00 106 print_error('noparticipants');
5f9e296a 107 }
a2ed6e69 108}
5f9e296a 109
0ff203b6
JL
110// Trigger events.
111user_list_view($course, $context);
a2ed6e69
SH
112
113$bulkoperations = has_capability('moodle/course:bulkmessaging', $context);
114
115$countries = get_string_manager()->get_list_of_countries();
116
117$strnever = get_string('never');
118
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');
130
131if ($mode !== null) {
132 $mode = (int)$mode;
133 $SESSION->userindexmode = $mode;
134} else if (isset($SESSION->userindexmode)) {
135 $mode = (int)$SESSION->userindexmode;
136} else {
137 $mode = MODE_BRIEF;
138}
41d7209c 139
a2ed6e69
SH
140// Check to see if groups are being used in this course
141// and if so, set $currentgroup to reflect the current group.
ff3caf30 142
a2ed6e69
SH
143$groupmode = groups_get_course_groupmode($course); // Groups are being used.
144$currentgroup = groups_get_course_group($course, true);
ff3caf30 145
a2ed6e69
SH
146if (!$currentgroup) { // To make some other functions work better later.
147 $currentgroup = null;
148}
ff3caf30 149
a2ed6e69 150$isseparategroups = ($course->groupmode == SEPARATEGROUPS and !has_capability('moodle/site:accessallgroups', $context));
ff3caf30 151
a2ed6e69
SH
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');
2cb2ce61 157
a2ed6e69 158echo $OUTPUT->header();
4e1f6047 159echo $OUTPUT->heading(get_string('participants'));
caa8363f 160
a2ed6e69 161echo '<div class="userlist">';
0be6f678 162
a2ed6e69
SH
163if ($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();
167 exit;
168}
99cca847 169
ff3caf30 170
a2ed6e69
SH
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,
174 'roleid' => $roleid,
175 'id' => $course->id,
176 'perpage' => $perpage,
177 'accesssince' => $accesssince,
178 'search' => s($search)));
179
180// Setting up tags.
181if ($course->id == SITEID) {
182 $filtertype = 'site';
183} else if ($course->id && !$currentgroup) {
184 $filtertype = 'course';
185 $filterselect = $course->id;
186} else {
187 $filtertype = 'group';
188 $filterselect = $currentgroup;
189}
03d9401e 190
1242eb8f 191
03d9401e 192
a2ed6e69
SH
193// Get the hidden field list.
194if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
195 $hiddenfields = array(); // Teachers and admins are allowed to see everything.
196} else {
c6b44cb4 197 $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields));
a2ed6e69 198}
1242eb8f 199
a2ed6e69
SH
200if (isset($hiddenfields['lastaccess'])) {
201 // Do not allow access since filtering.
202 $accesssince = 0;
203}
3468d58a 204
a2ed6e69
SH
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();
210
211// Print my course menus.
212if ($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));
218 }
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;
222 }
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);
226}
bbbf2d40 227
24c3db91
DP
228if ($groupmenu = groups_print_course_menu($course, $baseurl->out(), true)) {
229 $controlstable->data[0]->cells[] = $groupmenu;
230}
a2ed6e69
SH
231
232if (!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.
235 if (!$isfrontpage) {
236 $minlastaccess = $DB->get_field_sql('SELECT min(timeaccess)
237 FROM {user_lastaccess}
238 WHERE courseid = ?
239 AND timeaccess != 0', array($course->id));
240 $lastaccess0exists = $DB->record_exists('user_lastaccess', array('courseid' => $course->id, 'timeaccess' => 0));
241 } else {
242 $minlastaccess = $DB->get_field_sql('SELECT min(lastaccess)
243 FROM {user}
244 WHERE lastaccess != 0');
245 $lastaccess0exists = $DB->record_exists('user', array('lastaccess' => 0));
7da0af9f 246 }
87a13824 247
a2ed6e69
SH
248 $now = usergetmidnight(time());
249 $timeaccess = array();
250 $baseurl->remove_params('accesssince');
87a13824 251
a2ed6e69
SH
252 // Makes sense for this to go first.
253 $timeoptions[0] = get_string('selectperiod');
87a13824 254
a2ed6e69
SH
255 // Days.
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);
ca792680 259 }
a2ed6e69
SH
260 }
261 // Weeks.
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);
5ff311f0 265 }
a2ed6e69
SH
266 }
267 // Months.
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);
31b71336 271 }
a2ed6e69
SH
272 }
273 // Try a year.
274 if (strtotime('-1 year', $now) >= $minlastaccess) {
275 $timeoptions[strtotime('-1 year', $now)] = get_string('lastyear');
276 }
87a13824 277
a2ed6e69
SH
278 if (!empty($lastaccess0exists)) {
279 $timeoptions[-1] = get_string('never');
280 }
87a13824 281
a2ed6e69
SH
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);
77c645df 286 }
a2ed6e69 287}
87a13824 288
a2ed6e69
SH
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;
297
298echo html_writer::table($controlstable);
299
300if ($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);
309
310 $contentcell = new html_table_cell();
311 $contentcell->attributes['class'] = 'content';
312
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 .= '&nbsp;' . $OUTPUT->action_icon($aurl, new pix_icon('t/edit', get_string('editgroupprofile')));
317 }
8bdc9cac 318
a2ed6e69
SH
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;
ff3caf30 323 }
a2ed6e69
SH
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);
ff3caf30 329 }
330 }
a2ed6e69 331}
ff3caf30 332
a2ed6e69
SH
333// Define a table showing a list of users in the current role selection.
334$tablecolumns = array();
335$tableheaders = array();
336if ($bulkoperations && $mode === MODE_BRIEF) {
337 $tablecolumns[] = 'select';
338 $tableheaders[] = get_string('select');
339}
340$tablecolumns[] = 'userpic';
341$tablecolumns[] = 'fullname';
c238e1e2 342
a2ed6e69
SH
343$extrafields = get_extra_user_fields($context);
344$tableheaders[] = get_string('userpic');
345$tableheaders[] = get_string('fullnameuser');
77c645df 346
a2ed6e69
SH
347if ($mode === MODE_BRIEF) {
348 foreach ($extrafields as $field) {
349 $tablecolumns[] = $field;
350 $tableheaders[] = get_user_field_name($field);
77c645df 351 }
a2ed6e69
SH
352}
353if ($mode === MODE_BRIEF && !isset($hiddenfields['city'])) {
354 $tablecolumns[] = 'city';
355 $tableheaders[] = get_string('city');
356}
357if ($mode === MODE_BRIEF && !isset($hiddenfields['country'])) {
358 $tablecolumns[] = 'country';
359 $tableheaders[] = get_string('country');
360}
361if (!isset($hiddenfields['lastaccess'])) {
362 $tablecolumns[] = 'lastaccess';
e89682d8
DC
363 if ($course->id == SITEID) {
364 // Exception case for viewing participants on site home.
365 $tableheaders[] = get_string('lastsiteaccess');
366 } else {
367 $tableheaders[] = get_string('lastcourseaccess');
368 }
a2ed6e69 369}
77c645df 370
a2ed6e69
SH
371if ($bulkoperations && $mode === MODE_USERDETAILS) {
372 $tablecolumns[] = 'select';
373 $tableheaders[] = get_string('select');
374}
0be6f678 375
a2ed6e69
SH
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());
5ff311f0 380
28d27e85 381if (!isset($hiddenfields['lastaccess'])) {
382 $table->sortable(true, 'lastaccess', SORT_DESC);
a2ed6e69
SH
383} else {
384 $table->sortable(true, 'firstname', SORT_ASC);
385}
4f0c2d00 386
a2ed6e69
SH
387$table->no_sorting('roles');
388$table->no_sorting('groups');
389$table->no_sorting('groupings');
390$table->no_sorting('select');
391
392$table->set_attribute('cellspacing', '0');
393$table->set_attribute('id', 'participants');
394$table->set_attribute('class', 'generaltable generalbox');
395
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'
403 ));
404$table->setup();
405
406list($esql, $params) = get_enrolled_sql($context, null, $currentgroup, true);
407$joins = array("FROM {user} u");
408$wheres = array();
409
368f0bf8
DC
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);
a2ed6e69
SH
413
414if ($isfrontpage) {
415 $select = "SELECT $mainuserfields, u.lastaccess$extrasql";
416 $joins[] = "JOIN ($esql) e ON e.id = u.id"; // Everybody on the frontpage usually.
417 if ($accesssince) {
418 $wheres[] = get_user_lastaccess_sql($accesssince);
419 }
420
421} else {
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;
426 if ($accesssince) {
427 $wheres[] = get_course_lastaccess_sql($accesssince);
165088f6 428 }
a2ed6e69 429}
5f9e296a 430
a2ed6e69
SH
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;
436$joins[] = $ccjoin;
c0527567 437
4f0c2d00 438
a2ed6e69
SH
439// Limit list to users with some role only.
440if ($roleid) {
419d1abd
DW
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');
443
a2ed6e69 444 $wheres[] = "u.id IN (SELECT userid FROM {role_assignments} WHERE roleid = :roleid AND contextid $relatedctxsql)";
419d1abd 445 $params = array_merge($params, array('roleid' => $roleid), $relatedctxparams);
a2ed6e69 446}
0be6f678 447
a2ed6e69
SH
448$from = implode("\n", $joins);
449if ($wheres) {
450 $where = "WHERE " . implode(" AND ", $wheres);
451} else {
452 $where = "";
453}
4f0c2d00 454
a2ed6e69 455$totalcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
77c645df 456
a2ed6e69
SH
457if (!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%";
465}
77c645df 466
a2ed6e69
SH
467list($twhere, $tparams) = $table->get_sql_where();
468if ($twhere) {
469 $wheres[] = $twhere;
470 $params = array_merge($params, $tparams);
471}
77c645df 472
a2ed6e69
SH
473$from = implode("\n", $joins);
474if ($wheres) {
475 $where = "WHERE " . implode(" AND ", $wheres);
476} else {
477 $where = "";
478}
77c645df 479
a2ed6e69
SH
480if ($table->get_sql_sort()) {
481 $sort = ' ORDER BY '.$table->get_sql_sort();
482} else {
483 $sort = '';
484}
77c645df 485
a2ed6e69 486$matchcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
77c645df 487
a2ed6e69
SH
488$table->initialbars(true);
489$table->pagesize($perpage, $matchcount);
77c645df 490
a2ed6e69
SH
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());
3e219038 493
a2ed6e69
SH
494// If there are multiple Roles in the course, then show a drop down menu for switching.
495if (count($rolenames) > 1) {
496 echo '<div class="rolesform">';
32bd11cb
BB
497 echo $OUTPUT->single_select($rolenamesurl, 'roleid', $rolenames, $roleid, null,
498 'rolesform', array('label' => get_string('currentrole', 'role')));
a2ed6e69 499 echo '</div>';
5f9e296a 500
a2ed6e69
SH
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);
506 echo $rolename;
507 echo '</div>';
508}
3e219038 509
7057c3ef
DP
510$editlink = '';
511if ($course->id != SITEID && has_capability('moodle/course:enrolreview', $context)) {
512 $editlink = new moodle_url('/enrol/users.php', array('id' => $course->id));
513}
514
a2ed6e69
SH
515if ($roleid > 0) {
516 $a = new stdClass();
517 $a->number = $totalcount;
518 $a->role = $rolenames[$roleid];
519 $heading = format_string(get_string('xuserswiththerole', 'role', $a));
f642a21a 520
9488b6f3 521 if ($currentgroup and !empty($group)) {
a2ed6e69
SH
522 $a->group = $group->name;
523 $heading .= ' ' . format_string(get_string('ingroup', 'role', $a));
524 }
f642a21a 525
9488b6f3 526 if ($accesssince && !empty($timeoptions[$accesssince])) {
a2ed6e69
SH
527 $a->timeperiod = $timeoptions[$accesssince];
528 $heading .= ' ' . format_string(get_string('inactiveformorethan', 'role', $a));
529 }
f642a21a 530
a2ed6e69 531 $heading .= ": $a->number";
b85b25eb 532
7057c3ef
DP
533 if (!empty($editlink)) {
534 $editlink->param('role', $roleid);
535 $heading .= $OUTPUT->action_icon($editlink, new pix_icon('t/edit', get_string('edit')));
a2ed6e69
SH
536 }
537 echo $OUTPUT->heading($heading, 3);
538} else {
a2ed6e69
SH
539 if ($course->id == SITEID and $roleid < 0) {
540 $strallparticipants = get_string('allsiteusers', 'role');
541 } else {
542 $strallparticipants = get_string('allparticipants');
543 }
7057c3ef
DP
544
545 if (!empty($editlink)) {
546 $editlink = $OUTPUT->action_icon($editlink, new pix_icon('t/edit', get_string('edit')));
547 }
548
a2ed6e69
SH
549 if ($matchcount < $totalcount) {
550 echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount.'/'.$totalcount . $editlink, 3);
551 } else {
552 echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount . $editlink, 3);
553 }
554}
3e219038 555
77c645df 556
a2ed6e69
SH
557if ($bulkoperations) {
558 echo '<form action="action_redir.php" method="post" id="participantsform">';
559 echo '<div>';
560 echo '<input type="hidden" name="sesskey" value="'.sesskey().'" />';
561 echo '<input type="hidden" name="returnto" value="'.s($PAGE->url->out(false)).'" />';
562}
77c645df 563
a2ed6e69
SH
564if ($mode === MODE_USERDETAILS) { // Print simple listing.
565 if ($totalcount < 1) {
566 echo $OUTPUT->heading(get_string('nothingtodisplay'));
567 } else {
568 if ($totalcount > $perpage) {
77c645df 569
8b844f70
IT
570 // Initials bar.
571 $table->print_initials_bar();
77c645df 572
a2ed6e69
SH
573 $pagingbar = new paging_bar($matchcount, intval($table->get_page_start() / $perpage), $perpage, $baseurl);
574 $pagingbar->pagevar = 'spage';
575 echo $OUTPUT->render($pagingbar);
576 }
577
578 if ($matchcount > 0) {
579 $usersprinted = array();
580 foreach ($userlist as $user) {
581 if (in_array($user->id, $usersprinted)) { // Prevent duplicates by r.hidden - MDL-13935.
582 continue;
583 }
584 $usersprinted[] = $user->id; // Add new user to the array of users printed.
1f807bc4 585
a2ed6e69 586 context_helper::preload_from_record($user);
c351150f 587
a2ed6e69
SH
588 $context = context_course::instance($course->id);
589 $usercontext = context_user::instance($user->id);
c351150f 590
a2ed6e69 591 $countries = get_string_manager()->get_list_of_countries();
c351150f 592
a2ed6e69
SH
593 // Get the hidden field list.
594 if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
595 $hiddenfields = array();
596 } else {
c6b44cb4 597 $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields));
a2ed6e69
SH
598 }
599 $table = new html_table();
600 $table->attributes['class'] = 'userinfobox';
c351150f 601
a2ed6e69
SH
602 $row = new html_table_row();
603 $row->cells[0] = new html_table_cell();
604 $row->cells[0]->attributes['class'] = 'left side';
f2f085ee 605
a2ed6e69
SH
606 $row->cells[0]->text = $OUTPUT->user_picture($user, array('size' => 100, 'courseid' => $course->id));
607 $row->cells[1] = new html_table_cell();
608 $row->cells[1]->attributes['class'] = 'content';
c351150f 609
a2ed6e69
SH
610 $row->cells[1]->text = $OUTPUT->container(fullname($user, has_capability('moodle/site:viewfullnames', $context)), 'username');
611 $row->cells[1]->text .= $OUTPUT->container_start('info');
c351150f 612
a2ed6e69
SH
613 if (!empty($user->role)) {
614 $row->cells[1]->text .= get_string('role').get_string('labelsep', 'langconfig').$user->role.'<br />';
615 }
616 if ($user->maildisplay == 1 or ($user->maildisplay == 2 and ($course->id != SITEID) and !isguestuser()) or
a2ed6e69
SH
617 in_array('email', $extrafields) or ($user->id == $USER->id)) {
618 $row->cells[1]->text .= get_string('email').get_string('labelsep', 'langconfig').html_writer::link("mailto:$user->email", $user->email) . '<br />';
619 }
620 foreach ($extrafields as $field) {
621 if ($field === 'email') {
622 // Skip email because it was displayed with different logic above
623 // because this page is intended for students too.
624 continue;
c351150f 625 }
a2ed6e69
SH
626 $row->cells[1]->text .= get_user_field_name($field) .
627 get_string('labelsep', 'langconfig') . s($user->{$field}) . '<br />';
628 }
629 if (($user->city or $user->country) and (!isset($hiddenfields['city']) or !isset($hiddenfields['country']))) {
630 $row->cells[1]->text .= get_string('city').get_string('labelsep', 'langconfig');
631 if ($user->city && !isset($hiddenfields['city'])) {
632 $row->cells[1]->text .= $user->city;
43aa295b 633 }
a2ed6e69 634 if (!empty($countries[$user->country]) && !isset($hiddenfields['country'])) {
c351150f 635 if ($user->city && !isset($hiddenfields['city'])) {
a2ed6e69 636 $row->cells[1]->text .= ', ';
c351150f 637 }
a2ed6e69 638 $row->cells[1]->text .= $countries[$user->country];
c351150f 639 }
a2ed6e69
SH
640 $row->cells[1]->text .= '<br />';
641 }
c351150f 642
a2ed6e69
SH
643 if (!isset($hiddenfields['lastaccess'])) {
644 if ($user->lastaccess) {
645 $row->cells[1]->text .= get_string('lastaccess').get_string('labelsep', 'langconfig').userdate($user->lastaccess);
646 $row->cells[1]->text .= '&nbsp; ('. format_time(time() - $user->lastaccess, $datestring) .')';
647 } else {
648 $row->cells[1]->text .= get_string('lastaccess').get_string('labelsep', 'langconfig').get_string('never');
c351150f 649 }
a2ed6e69 650 }
c351150f 651
a2ed6e69 652 $row->cells[1]->text .= $OUTPUT->container_end();
3aac07d8 653
a2ed6e69
SH
654 $row->cells[2] = new html_table_cell();
655 $row->cells[2]->attributes['class'] = 'links';
656 $row->cells[2]->text = '';
3aac07d8 657
a2ed6e69 658 $links = array();
c351150f 659
66b864c7 660 if ($CFG->enableblogs && ($CFG->bloglevel != BLOG_USER_LEVEL || $USER->id == $user->id)) {
a2ed6e69
SH
661 $links[] = html_writer::link(new moodle_url('/blog/index.php?userid='.$user->id), get_string('blogs', 'blog'));
662 }
c351150f 663
a2ed6e69
SH
664 if (!empty($CFG->enablenotes) and (has_capability('moodle/notes:manage', $context) || has_capability('moodle/notes:view', $context))) {
665 $links[] = html_writer::link(new moodle_url('/notes/index.php?course=' . $course->id. '&user='.$user->id), get_string('notes', 'notes'));
666 }
c351150f 667
a2ed6e69
SH
668 if (has_capability('moodle/site:viewreports', $context) or has_capability('moodle/user:viewuseractivitiesreport', $usercontext)) {
669 $links[] = html_writer::link(new moodle_url('/course/user.php?id='. $course->id .'&user='. $user->id), get_string('activity'));
670 }
c351150f 671
a2ed6e69
SH
672 if ($USER->id != $user->id && !\core\session\manager::is_loggedinas() && has_capability('moodle/user:loginas', $context) && !is_siteadmin($user->id)) {
673 $links[] = html_writer::link(new moodle_url('/course/loginas.php?id='. $course->id .'&user='. $user->id .'&sesskey='. sesskey()), get_string('loginas'));
674 }
c351150f 675
a2ed6e69 676 $links[] = html_writer::link(new moodle_url('/user/view.php?id='. $user->id .'&course='. $course->id), get_string('fullprofile') . '...');
3aac07d8 677
a2ed6e69 678 $row->cells[2]->text .= implode('', $links);
c351150f 679
a2ed6e69 680 if ($bulkoperations) {
5b7c500a
AH
681 if ($selectall) {
682 $checked = 'checked="true"';
683 } else {
684 $checked = '';
685 }
686 $row->cells[2]->text .= '<br /><input type="checkbox" class="usercheckbox" name="user'.$user->id.'" ' .$checked .'/> ';
ee4a52c5 687 }
a2ed6e69
SH
688 $table->data = array($row);
689 echo html_writer::table($table);
ee4a52c5 690 }
a2ed6e69
SH
691
692 } else {
693 echo $OUTPUT->heading(get_string('nothingtodisplay'));
ee4a52c5 694 }
a2ed6e69 695 }
77c645df 696
a2ed6e69
SH
697} else {
698 $countrysort = (strpos($sort, 'country') !== false);
699 $timeformat = get_string('strftimedate');
3997cb40 700
701
a2ed6e69 702 if ($userlist) {
664fe87f 703
a2ed6e69
SH
704 $usersprinted = array();
705 foreach ($userlist as $user) {
706 if (in_array($user->id, $usersprinted)) { // Prevent duplicates by r.hidden - MDL-13935.
707 continue;
708 }
709 $usersprinted[] = $user->id; // Add new user to the array of users printed.
1f807bc4 710
a2ed6e69 711 context_helper::preload_from_record($user);
0be6f678 712
a2ed6e69
SH
713 if ($user->lastaccess) {
714 $lastaccess = format_time(time() - $user->lastaccess, $datestring);
715 } else {
716 $lastaccess = $strnever;
717 }
77c645df 718
a2ed6e69
SH
719 if (empty($user->country)) {
720 $country = '';
77c645df 721
a2ed6e69
SH
722 } else {
723 if ($countrysort) {
724 $country = '('.$user->country.') '.$countries[$user->country];
77c645df 725 } else {
a2ed6e69 726 $country = $countries[$user->country];
77c645df 727 }
a2ed6e69 728 }
0be6f678 729
a2ed6e69 730 $usercontext = context_user::instance($user->id);
0be6f678 731
a2ed6e69
SH
732 if ($piclink = ($USER->id == $user->id || has_capability('moodle/user:viewdetails', $context) || has_capability('moodle/user:viewdetails', $usercontext))) {
733 $profilelink = '<strong><a href="'.$CFG->wwwroot.'/user/view.php?id='.$user->id.'&amp;course='.$course->id.'">'.fullname($user).'</a></strong>';
734 } else {
735 $profilelink = '<strong>'.fullname($user).'</strong>';
736 }
0be6f678 737
a2ed6e69
SH
738 $data = array();
739 if ($bulkoperations) {
5b7c500a
AH
740 if ($selectall) {
741 $checked = 'checked="true"';
742 } else {
743 $checked = '';
744 }
745 $data[] = '<input type="checkbox" class="usercheckbox" name="user'.$user->id.'" ' . $checked .'/>';
a2ed6e69
SH
746 }
747 $data[] = $OUTPUT->user_picture($user, array('size' => 35, 'courseid' => $course->id));
748 $data[] = $profilelink;
22ae509e 749
a2ed6e69
SH
750 if ($mode === MODE_BRIEF) {
751 foreach ($extrafields as $field) {
752 $data[] = $user->{$field};
77c645df 753 }
a2ed6e69
SH
754 }
755 if ($mode === MODE_BRIEF && !isset($hiddenfields['city'])) {
756 $data[] = $user->city;
757 }
758 if ($mode === MODE_BRIEF && !isset($hiddenfields['country'])) {
759 $data[] = $country;
760 }
761 if (!isset($hiddenfields['lastaccess'])) {
762 $data[] = $lastaccess;
763 }
664fe87f 764
a2ed6e69 765 $table->add_data($data);
eca3af25 766 }
a2ed6e69 767 }
576ad290 768
a2ed6e69 769 $table->print_html();
d88c5043 770
a2ed6e69 771}
b90e2f19 772
8dd42b38
AH
773$perpageurl = clone($baseurl);
774$perpageurl->remove_params('perpage');
775if ($perpage == SHOW_ALL_PAGE_SIZE) {
776 $perpageurl->param('perpage', DEFAULT_PAGE_SIZE);
777 echo $OUTPUT->container(html_writer::link($perpageurl, get_string('showperpage', '', DEFAULT_PAGE_SIZE)), array(), 'showall');
778
779} else if ($matchcount > 0 && $perpage < $matchcount) {
780 $perpageurl->param('perpage', SHOW_ALL_PAGE_SIZE);
781 echo $OUTPUT->container(html_writer::link($perpageurl, get_string('showall', '', $matchcount)), array(), 'showall');
782}
783
a2ed6e69
SH
784if ($bulkoperations) {
785 echo '<br /><div class="buttons">';
5b7c500a
AH
786
787 if ($matchcount > 0 && $perpage < $matchcount) {
788 $perpageurl = clone($baseurl);
789 $perpageurl->remove_params('perpage');
790 $perpageurl->param('perpage', SHOW_ALL_PAGE_SIZE);
791 $perpageurl->param('selectall', true);
792 $showalllink = $perpageurl;
793 } else {
794 $showalllink = false;
795 }
796
b27c8d81 797 echo html_writer::start_tag('div', array('class' => 'btn-group'));
5b7c500a
AH
798 if ($perpage < $matchcount) {
799 // Select all users, refresh page showing all users and mark them all selected.
800 $label = get_string('selectalluserswithcount', 'moodle', $matchcount);
b27c8d81
SB
801 echo html_writer::tag('input', "", array('type' => 'button', 'id' => 'checkall', 'class' => 'btn btn-secondary',
802 'value' => $label, 'data-showallink' => $showalllink));
5b7c500a 803 // Select all users, mark all users on page as selected.
b27c8d81
SB
804 echo html_writer::tag('input', "", array('type' => 'button', 'id' => 'checkallonpage', 'class' => 'btn btn-secondary',
805 'value' => get_string('selectallusersonpage')));
5b7c500a 806 } else {
b27c8d81
SB
807 echo html_writer::tag('input', "", array('type' => 'button', 'id' => 'checkallonpage', 'class' => 'btn btn-secondary',
808 'value' => get_string('selectall')));
5b7c500a
AH
809 }
810
b27c8d81
SB
811 echo html_writer::tag('input', "", array('type' => 'button', 'id' => 'checknone', 'class' => 'btn btn-secondary',
812 'value' => get_string('deselectall')));
813 echo html_writer::end_tag('div');
a2ed6e69
SH
814 $displaylist = array();
815 $displaylist['messageselect.php'] = get_string('messageselectadd');
816 if (!empty($CFG->enablenotes) && has_capability('moodle/notes:manage', $context) && $context->id != $frontpagectx->id) {
817 $displaylist['addnote.php'] = get_string('addnewnote', 'notes');
818 $displaylist['groupaddnote.php'] = get_string('groupaddnewnote', 'notes');
819 }
820
821 echo $OUTPUT->help_icon('withselectedusers');
822 echo html_writer::tag('label', get_string("withselectedusers"), array('for' => 'formactionid'));
823 echo html_writer::select($displaylist, 'formaction', '', array('' => 'choosedots'), array('id' => 'formactionid'));
824
825 echo '<input type="hidden" name="id" value="'.$course->id.'" />';
826 echo '<noscript style="display:inline">';
827 echo '<div><input type="submit" value="'.get_string('ok').'" /></div>';
828 echo '</noscript>';
829 echo '</div></div>';
830 echo '</form>';
831
832 $module = array('name' => 'core_user', 'fullpath' => '/user/module.js');
833 $PAGE->requires->js_init_call('M.core_user.init_participation', null, false, $module);
834}
b90e2f19 835
a2ed6e69
SH
836// Show a search box if all participants don't fit on a single screen.
837if ($totalcount > $perpage) {
838 echo '<form action="index.php" class="searchform"><div><input type="hidden" name="id" value="'.$course->id.'" />';
839 echo '<label for="search">' . get_string('search', 'search') . ' </label>';
840 echo '<input type="text" id="search" name="search" value="'.s($search).'" />&nbsp;<input type="submit" value="'.get_string('search').'" /></div></form>'."\n";
841}
77c645df 842
a2ed6e69 843echo '</div>'; // Userlist.
f9903ed0 844
a2ed6e69 845echo $OUTPUT->footer();
77c645df 846
a2ed6e69
SH
847if ($userlist) {
848 $userlist->close();
849}
77c645df 850
a2ed6e69
SH
851/**
852 * Returns SQL that can be used to limit a query to a period where the user last accessed a course..
853 *
854 * @param string $accesssince
855 * @return string
856 */
0749caef 857function get_course_lastaccess_sql($accesssince='') {
31b71336 858 if (empty($accesssince)) {
859 return '';
860 }
a2ed6e69 861 if ($accesssince == -1) { // Never.
4f0c2d00 862 return 'ul.timeaccess = 0';
31b71336 863 } else {
4f0c2d00 864 return 'ul.timeaccess != 0 AND ul.timeaccess < '.$accesssince;
0749caef 865 }
866}
867
a2ed6e69
SH
868/**
869 * Returns SQL that can be used to limit a query to a period where the user last accessed the system.
870 *
871 * @param string $accesssince
872 * @return string
873 */
0749caef 874function get_user_lastaccess_sql($accesssince='') {
875 if (empty($accesssince)) {
876 return '';
877 }
a2ed6e69 878 if ($accesssince == -1) { // Never.
4f0c2d00 879 return 'u.lastaccess = 0';
0749caef 880 } else {
4f0c2d00 881 return 'u.lastaccess != 0 AND u.lastaccess < '.$accesssince;
31b71336 882 }
883}