user/index.php

   1 <?php
   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
  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');
  29
  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);
  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.
  45 $selectall    = optional_param('selectall', false, PARAM_BOOL); // When rendering checkboxes against users mark them all checked.
  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
  57 if ($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.
  68 unset($contextid);
  69 unset($courseid);
  70
  71 require_login($course);
  72
  73 $systemcontext = context_system::instance();
  74 $isfrontpage = ($course->id == SITEID);
  75
  76 $frontpagectx = context_course::instance(SITEID);
  77
  78 if ($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 }
  85
  86 $rolenamesurl = new moodle_url("$CFG->wwwroot/user/index.php?contextid=$context->id&sifirst=&silast=");
  87
  88 $rolenames = role_fix_names(get_profile_roles($context), $context, ROLENAME_ALIAS, true);
  89 if ($isfrontpage) {
  90     $rolenames[0] = get_string('allsiteusers', 'role');
  91 } else {
  92     $rolenames[0] = get_string('allparticipants');
  93 }
  94
  95 // Make sure other roles may not be selected by any means.
  96 if (empty($rolenames[$roleid])) {
  97     print_error('noparticipants');
  98 }
  99
 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);
 105     } else {
 106         print_error('noparticipants');
 107     }
 108 }
 109
 110 // Trigger events.
 111 user_list_view($course, $context);
 112
 113 $bulkoperations = has_capability('moodle/course:bulkmessaging', $context);
 114
 115 $countries = get_string_manager()->get_list_of_countries(true);
 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
 131 if ($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 }
 139
 140 // Check to see if groups are being used in this course
 141 // and if so, set $currentgroup to reflect the current group.
 142
 143 $groupmode    = groups_get_course_groupmode($course);   // Groups are being used.
 144 $currentgroup = groups_get_course_group($course, true);
 145
 146 if (!$currentgroup) {      // To make some other functions work better later.
 147     $currentgroup  = null;
 148 }
 149
 150 $isseparategroups = ($course->groupmode == SEPARATEGROUPS and !has_capability('moodle/site:accessallgroups', $context));
 151
 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');
 157
 158 echo $OUTPUT->header();
 159 echo $OUTPUT->heading(get_string('participants'));
 160
 161 echo '<div class="userlist">';
 162
 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();
 167     exit;
 168 }
 169
 170
 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.
 181 if ($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 }
 190
 191
 192
 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.
 196 } else {
 197     $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields));
 198 }
 199
 200 if (isset($hiddenfields['lastaccess'])) {
 201     // Do not allow access since filtering.
 202     $accesssince = 0;
 203 }
 204
 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.
 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));
 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 }
 227
 228 if ($groupmenu = groups_print_course_menu($course, $baseurl->out(), true)) {
 229     $controlstable->data[0]->cells[] = $groupmenu;
 230 }
 231
 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.
 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));
 246     }
 247
 248     $now = usergetmidnight(time());
 249     $timeaccess = array();
 250     $baseurl->remove_params('accesssince');
 251
 252     // Makes sense for this to go first.
 253     $timeoptions[0] = get_string('selectperiod');
 254
 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);
 259         }
 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);
 265         }
 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);
 271         }
 272     }
 273     // Try a year.
 274     if (strtotime('-1 year', $now) >= $minlastaccess) {
 275         $timeoptions[strtotime('-1 year', $now)] = get_string('lastyear');
 276     }
 277
 278     if (!empty($lastaccess0exists)) {
 279         $timeoptions[-1] = get_string('never');
 280     }
 281
 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);
 286     }
 287 }
 288
 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
 298 echo html_writer::table($controlstable);
 299
 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);
 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             }
 318
 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;
 323             }
 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);
 329         }
 330     }
 331 }
 332
 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');
 339 }
 340 $tablecolumns[] = 'userpic';
 341 $tablecolumns[] = 'fullname';
 342
 343 $extrafields = get_extra_user_fields($context);
 344 $tableheaders[] = get_string('userpic');
 345 $tableheaders[] = get_string('fullnameuser');
 346
 347 if ($mode === MODE_BRIEF) {
 348     foreach ($extrafields as $field) {
 349         $tablecolumns[] = $field;
 350         $tableheaders[] = get_user_field_name($field);
 351     }
 352 }
 353 if ($mode === MODE_BRIEF && !isset($hiddenfields['city'])) {
 354     $tablecolumns[] = 'city';
 355     $tableheaders[] = get_string('city');
 356 }
 357 if ($mode === MODE_BRIEF && !isset($hiddenfields['country'])) {
 358     $tablecolumns[] = 'country';
 359     $tableheaders[] = get_string('country');
 360 }
 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');
 366     } else {
 367         $tableheaders[] = get_string('lastcourseaccess');
 368     }
 369 }
 370
 371 if ($bulkoperations && $mode === MODE_USERDETAILS) {
 372     $tablecolumns[] = 'select';
 373     $tableheaders[] = get_string('select');
 374 }
 375
 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());
 380
 381 if (!isset($hiddenfields['lastaccess'])) {
 382     $table->sortable(true, 'lastaccess', SORT_DESC);
 383 } else {
 384     $table->sortable(true, 'firstname', SORT_ASC);
 385 }
 386
 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
 406 list($esql, $params) = get_enrolled_sql($context, null, $currentgroup, true);
 407 $joins = array("FROM {user} u");
 408 $wheres = array();
 409
 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);
 413
 414 if ($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);
 428     }
 429 }
 430
 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;
 437
 438
 439 // Limit list to users with some role only.
 440 if ($roleid) {
 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
 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);
 446 }
 447
 448 $from = implode("\n", $joins);
 449 if ($wheres) {
 450     $where = "WHERE " . implode(" AND ", $wheres);
 451 } else {
 452     $where = "";
 453 }
 454
 455 $totalcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
 456
 457 if (!empty($search)) {
 458     $conditions = array();
 459
 460     // Search by fullname.
 461     $fullname = $DB->sql_fullname('u.firstname', 'u.lastname');
 462     $conditions[] = $DB->sql_like($fullname, ':search1', false, false);
 463
 464     // Search by email.
 465     $email = $DB->sql_like('email', ':search2', false, false);
 466     if (!in_array('email', $extrafields)) {
 467         // Prevent users who hide their email address from being found by others
 468         // who aren't allowed to see hidden email addresses.
 469         $email = "(". $email ." AND (" .
 470                 "u.maildisplay <> :maildisplayhide " .
 471                 "OR u.id = :userid1". // User can always find himself.
 472                 "))";
 473         $params['maildisplayhide'] = core_user::MAILDISPLAY_HIDE;
 474         $params['userid1'] = $USER->id;
 475     }
 476     $conditions[] = $email;
 477
 478     // Search by idnumber.
 479     $idnumber = $DB->sql_like('idnumber', ':search3', false, false);
 480     if (!in_array('idnumber', $extrafields)) {
 481         // Users who aren't allowed to see idnumbers should at most find themselves
 482         // when searching for an idnumber.
 483         $idnumber = "(". $idnumber . " AND u.id = :userid2)";
 484         $params['userid2'] = $USER->id;
 485     }
 486     $conditions[] = $idnumber;
 487
 488     $wheres[] = "(". implode(" OR ", $conditions) .") ";
 489     $params['search1'] = "%$search%";
 490     $params['search2'] = "%$search%";
 491     $params['search3'] = "%$search%";
 492 }
 493
 494 list($twhere, $tparams) = $table->get_sql_where();
 495 if ($twhere) {
 496     $wheres[] = $twhere;
 497     $params = array_merge($params, $tparams);
 498 }
 499
 500 $from = implode("\n", $joins);
 501 if ($wheres) {
 502     $where = "WHERE " . implode(" AND ", $wheres);
 503 } else {
 504     $where = "";
 505 }
 506
 507 if ($table->get_sql_sort()) {
 508     $sort = ' ORDER BY '.$table->get_sql_sort();
 509 } else {
 510     $sort = '';
 511 }
 512
 513 $matchcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
 514
 515 $table->initialbars(true);
 516 $table->pagesize($perpage, $matchcount);
 517
 518 // List of users at the current visible page - paging makes it relatively short.
 519 $userlist = $DB->get_recordset_sql("$select $from $where $sort", $params, $table->get_page_start(), $table->get_page_size());
 520
 521 // If there are multiple Roles in the course, then show a drop down menu for switching.
 522 if (count($rolenames) > 1) {
 523     echo '<div class="rolesform">';
 524     echo $OUTPUT->single_select($rolenamesurl, 'roleid', $rolenames, $roleid, null,
 525         'rolesform', array('label' => get_string('currentrole', 'role')));
 526     echo '</div>';
 527
 528 } else if (count($rolenames) == 1) {
 529     // When all users with the same role - print its name.
 530     echo '<div class="rolesform">';
 531     echo get_string('role').get_string('labelsep', 'langconfig');
 532     $rolename = reset($rolenames);
 533     echo $rolename;
 534     echo '</div>';
 535 }
 536
 537 $editlink = '';
 538 if ($course->id != SITEID && has_capability('moodle/course:enrolreview', $context)) {
 539     $editlink = new moodle_url('/enrol/users.php', array('id' => $course->id));
 540 }
 541
 542 if ($roleid > 0) {
 543     $a = new stdClass();
 544     $a->number = $totalcount;
 545     $a->role = $rolenames[$roleid];
 546     $heading = format_string(get_string('xuserswiththerole', 'role', $a));
 547
 548     if ($currentgroup and !empty($group)) {
 549         $a->group = $group->name;
 550         $heading .= ' ' . format_string(get_string('ingroup', 'role', $a));
 551     }
 552
 553     if ($accesssince && !empty($timeoptions[$accesssince])) {
 554         $a->timeperiod = $timeoptions[$accesssince];
 555         $heading .= ' ' . format_string(get_string('inactiveformorethan', 'role', $a));
 556     }
 557
 558     $heading .= ": $a->number";
 559
 560     if (!empty($editlink)) {
 561         $editlink->param('role', $roleid);
 562         $heading .= $OUTPUT->action_icon($editlink, new pix_icon('t/edit', get_string('edit')));
 563     }
 564     echo $OUTPUT->heading($heading, 3);
 565 } else {
 566     if ($course->id == SITEID and $roleid < 0) {
 567         $strallparticipants = get_string('allsiteusers', 'role');
 568     } else {
 569         $strallparticipants = get_string('allparticipants');
 570     }
 571
 572     if (!empty($editlink)) {
 573         $editlink = $OUTPUT->action_icon($editlink, new pix_icon('t/edit', get_string('edit')));
 574     }
 575
 576     if ($matchcount < $totalcount) {
 577         echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount.'/'.$totalcount . $editlink, 3);
 578     } else {
 579         echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount . $editlink, 3);
 580     }
 581 }
 582
 583
 584 if ($bulkoperations) {
 585     echo '<form action="action_redir.php" method="post" id="participantsform">';
 586     echo '<div>';
 587     echo '<input type="hidden" name="sesskey" value="'.sesskey().'" />';
 588     echo '<input type="hidden" name="returnto" value="'.s($PAGE->url->out(false)).'" />';
 589 }
 590
 591 if ($mode === MODE_USERDETAILS) {    // Print simple listing.
 592     if ($totalcount < 1) {
 593         echo $OUTPUT->heading(get_string('nothingtodisplay'));
 594     } else {
 595         if ($totalcount > $perpage) {
 596
 597             // Initials bar.
 598             $table->print_initials_bar();
 599
 600             $pagingbar = new paging_bar($matchcount, intval($table->get_page_start() / $perpage), $perpage, $baseurl);
 601             $pagingbar->pagevar = 'spage';
 602             echo $OUTPUT->render($pagingbar);
 603         }
 604
 605         if ($matchcount > 0) {
 606             $usersprinted = array();
 607             foreach ($userlist as $user) {
 608                 if (in_array($user->id, $usersprinted)) { // Prevent duplicates by r.hidden - MDL-13935.
 609                     continue;
 610                 }
 611                 $usersprinted[] = $user->id; // Add new user to the array of users printed.
 612
 613                 context_helper::preload_from_record($user);
 614
 615                 $context = context_course::instance($course->id);
 616                 $usercontext = context_user::instance($user->id);
 617
 618                 // Get the hidden field list.
 619                 if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
 620                     $hiddenfields = array();
 621                 } else {
 622                     $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields));
 623                 }
 624                 $table = new html_table();
 625                 $table->attributes['class'] = 'userinfobox';
 626
 627                 $row = new html_table_row();
 628                 $row->cells[0] = new html_table_cell();
 629                 $row->cells[0]->attributes['class'] = 'left side';
 630
 631                 $row->cells[0]->text = $OUTPUT->user_picture($user, array('size' => 100, 'courseid' => $course->id));
 632                 $row->cells[1] = new html_table_cell();
 633                 $row->cells[1]->attributes['class'] = 'content';
 634
 635                 $row->cells[1]->text = $OUTPUT->container(fullname($user, has_capability('moodle/site:viewfullnames', $context)), 'username');
 636                 $row->cells[1]->text .= $OUTPUT->container_start('info');
 637
 638                 if (!empty($user->role)) {
 639                     $row->cells[1]->text .= get_string('role').get_string('labelsep', 'langconfig').$user->role.'<br />';
 640                 }
 641                 if ($user->maildisplay == 1 or ($user->maildisplay == 2 and ($course->id != SITEID) and !isguestuser()) or
 642                             in_array('email', $extrafields) or ($user->id == $USER->id)) {
 643                     $row->cells[1]->text .= get_string('email').get_string('labelsep', 'langconfig').html_writer::link("mailto:$user->email", $user->email) . '<br />';
 644                 }
 645                 foreach ($extrafields as $field) {
 646                     if ($field === 'email') {
 647                         // Skip email because it was displayed with different logic above
 648                         // because this page is intended for students too.
 649                         continue;
 650                     }
 651                     $row->cells[1]->text .= get_user_field_name($field) .
 652                             get_string('labelsep', 'langconfig') . s($user->{$field}) . '<br />';
 653                 }
 654                 if (($user->city or $user->country) and (!isset($hiddenfields['city']) or !isset($hiddenfields['country']))) {
 655                     $row->cells[1]->text .= get_string('city').get_string('labelsep', 'langconfig');
 656                     if ($user->city && !isset($hiddenfields['city'])) {
 657                         $row->cells[1]->text .= $user->city;
 658                     }
 659                     if (!empty($countries[$user->country]) && !isset($hiddenfields['country'])) {
 660                         if ($user->city && !isset($hiddenfields['city'])) {
 661                             $row->cells[1]->text .= ', ';
 662                         }
 663                         $row->cells[1]->text .= $countries[$user->country];
 664                     }
 665                     $row->cells[1]->text .= '<br />';
 666                 }
 667
 668                 if (!isset($hiddenfields['lastaccess'])) {
 669                     if ($user->lastaccess) {
 670                         $row->cells[1]->text .= get_string('lastaccess').get_string('labelsep', 'langconfig').userdate($user->lastaccess);
 671                         $row->cells[1]->text .= '&nbsp; ('. format_time(time() - $user->lastaccess, $datestring) .')';
 672                     } else {
 673                         $row->cells[1]->text .= get_string('lastaccess').get_string('labelsep', 'langconfig').get_string('never');
 674                     }
 675                 }
 676
 677                 $row->cells[1]->text .= $OUTPUT->container_end();
 678
 679                 $row->cells[2] = new html_table_cell();
 680                 $row->cells[2]->attributes['class'] = 'links';
 681                 $row->cells[2]->text = '';
 682
 683                 $links = array();
 684
 685                 if ($CFG->enableblogs && ($CFG->bloglevel != BLOG_USER_LEVEL || $USER->id == $user->id)) {
 686                     $links[] = html_writer::link(new moodle_url('/blog/index.php?userid='.$user->id), get_string('blogs', 'blog'));
 687                 }
 688
 689                 if (!empty($CFG->enablenotes) and (has_capability('moodle/notes:manage', $context) || has_capability('moodle/notes:view', $context))) {
 690                     $links[] = html_writer::link(new moodle_url('/notes/index.php?course=' . $course->id. '&user='.$user->id), get_string('notes', 'notes'));
 691                 }
 692
 693                 if (has_capability('moodle/site:viewreports', $context) or has_capability('moodle/user:viewuseractivitiesreport', $usercontext)) {
 694                     $links[] = html_writer::link(new moodle_url('/course/user.php?id='. $course->id .'&user='. $user->id), get_string('activity'));
 695                 }
 696
 697                 if ($USER->id != $user->id && !\core\session\manager::is_loggedinas() && has_capability('moodle/user:loginas', $context) && !is_siteadmin($user->id)) {
 698                     $links[] = html_writer::link(new moodle_url('/course/loginas.php?id='. $course->id .'&user='. $user->id .'&sesskey='. sesskey()), get_string('loginas'));
 699                 }
 700
 701                 $links[] = html_writer::link(new moodle_url('/user/view.php?id='. $user->id .'&course='. $course->id), get_string('fullprofile') . '...');
 702
 703                 $row->cells[2]->text .= implode('', $links);
 704
 705                 if ($bulkoperations) {
 706                     if ($selectall) {
 707                         $checked = 'checked="true"';
 708                     } else {
 709                         $checked = '';
 710                     }
 711                     $row->cells[2]->text .= '<br /><input type="checkbox" class="usercheckbox" name="user'.$user->id.'" ' .$checked .'/> ';
 712                 }
 713                 $table->data = array($row);
 714                 echo html_writer::table($table);
 715             }
 716
 717         } else {
 718             echo $OUTPUT->heading(get_string('nothingtodisplay'));
 719         }
 720     }
 721
 722 } else {
 723     $countrysort = (strpos($sort, 'country') !== false);
 724     $timeformat = get_string('strftimedate');
 725
 726
 727     if ($userlist) {
 728
 729         $usersprinted = array();
 730         foreach ($userlist as $user) {
 731             if (in_array($user->id, $usersprinted)) { // Prevent duplicates by r.hidden - MDL-13935.
 732                 continue;
 733             }
 734             $usersprinted[] = $user->id; // Add new user to the array of users printed.
 735
 736             context_helper::preload_from_record($user);
 737
 738             if ($user->lastaccess) {
 739                 $lastaccess = format_time(time() - $user->lastaccess, $datestring);
 740             } else {
 741                 $lastaccess = $strnever;
 742             }
 743
 744             if (empty($user->country)) {
 745                 $country = '';
 746
 747             } else {
 748                 if ($countrysort) {
 749                     $country = '('.$user->country.') '.$countries[$user->country];
 750                 } else {
 751                     $country = $countries[$user->country];
 752                 }
 753             }
 754
 755             $usercontext = context_user::instance($user->id);
 756
 757             if ($piclink = ($USER->id == $user->id || has_capability('moodle/user:viewdetails', $context) || has_capability('moodle/user:viewdetails', $usercontext))) {
 758                 $profilelink = '<strong><a href="'.$CFG->wwwroot.'/user/view.php?id='.$user->id.'&amp;course='.$course->id.'">'.fullname($user).'</a></strong>';
 759             } else {
 760                 $profilelink = '<strong>'.fullname($user).'</strong>';
 761             }
 762
 763             $data = array();
 764             if ($bulkoperations) {
 765                 if ($selectall) {
 766                     $checked = 'checked="true"';
 767                 } else {
 768                     $checked = '';
 769                 }
 770                 $data[] = '<input type="checkbox" class="usercheckbox" name="user'.$user->id.'" ' . $checked .'/>';
 771             }
 772             $data[] = $OUTPUT->user_picture($user, array('size' => 35, 'courseid' => $course->id));
 773             $data[] = $profilelink;
 774
 775             if ($mode === MODE_BRIEF) {
 776                 foreach ($extrafields as $field) {
 777                     $data[] = $user->{$field};
 778                 }
 779             }
 780             if ($mode === MODE_BRIEF && !isset($hiddenfields['city'])) {
 781                 $data[] = $user->city;
 782             }
 783             if ($mode === MODE_BRIEF && !isset($hiddenfields['country'])) {
 784                 $data[] = $country;
 785             }
 786             if (!isset($hiddenfields['lastaccess'])) {
 787                 $data[] = $lastaccess;
 788             }
 789
 790             $table->add_data($data);
 791         }
 792     }
 793
 794     $table->print_html();
 795
 796 }
 797
 798 $perpageurl = clone($baseurl);
 799 $perpageurl->remove_params('perpage');
 800 if ($perpage == SHOW_ALL_PAGE_SIZE) {
 801     $perpageurl->param('perpage', DEFAULT_PAGE_SIZE);
 802     echo $OUTPUT->container(html_writer::link($perpageurl, get_string('showperpage', '', DEFAULT_PAGE_SIZE)), array(), 'showall');
 803
 804 } else if ($matchcount > 0 && $perpage < $matchcount) {
 805     $perpageurl->param('perpage', SHOW_ALL_PAGE_SIZE);
 806     echo $OUTPUT->container(html_writer::link($perpageurl, get_string('showall', '', $matchcount)), array(), 'showall');
 807 }
 808
 809 if ($bulkoperations) {
 810     echo '<br /><div class="buttons">';
 811
 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;
 818     } else {
 819         $showalllink = false;
 820     }
 821
 822     echo html_writer::start_tag('div', array('class' => 'btn-group'));
 823     if ($perpage < $matchcount) {
 824         // Select all users, refresh page showing all users and mark them all selected.
 825         $label = get_string('selectalluserswithcount', 'moodle', $matchcount);
 826         echo html_writer::tag('input', "", array('type' => 'button', 'id' => 'checkall', 'class' => 'btn btn-secondary',
 827                 'value' => $label, 'data-showallink' => $showalllink));
 828         // Select all users, mark all users on page as selected.
 829         echo html_writer::tag('input', "", array('type' => 'button', 'id' => 'checkallonpage', 'class' => 'btn btn-secondary',
 830         'value' => get_string('selectallusersonpage')));
 831     } else {
 832         echo html_writer::tag('input', "", array('type' => 'button', 'id' => 'checkallonpage', 'class' => 'btn btn-secondary',
 833         'value' => get_string('selectall')));
 834     }
 835
 836     echo html_writer::tag('input', "", array('type' => 'button', 'id' => 'checknone', 'class' => 'btn btn-secondary',
 837         'value' => get_string('deselectall')));
 838     echo html_writer::end_tag('div');
 839     $displaylist = array();
 840     $displaylist['messageselect.php'] = get_string('messageselectadd');
 841     if (!empty($CFG->enablenotes) && has_capability('moodle/notes:manage', $context) && $context->id != $frontpagectx->id) {
 842         $displaylist['addnote.php'] = get_string('addnewnote', 'notes');
 843         $displaylist['groupaddnote.php'] = get_string('groupaddnewnote', 'notes');
 844     }
 845
 846     echo $OUTPUT->help_icon('withselectedusers');
 847     echo html_writer::tag('label', get_string("withselectedusers"), array('for' => 'formactionid'));
 848     echo html_writer::select($displaylist, 'formaction', '', array('' => 'choosedots'), array('id' => 'formactionid'));
 849
 850     echo '<input type="hidden" name="id" value="'.$course->id.'" />';
 851     echo '<noscript style="display:inline">';
 852     echo '<div><input type="submit" value="'.get_string('ok').'" /></div>';
 853     echo '</noscript>';
 854     echo '</div></div>';
 855     echo '</form>';
 856
 857     $module = array('name' => 'core_user', 'fullpath' => '/user/module.js');
 858     $PAGE->requires->js_init_call('M.core_user.init_participation', null, false, $module);
 859 }
 860
 861 // Show a search box if all participants don't fit on a single screen.
 862 if ($totalcount > $perpage) {
 863     echo '<form action="index.php" class="searchform"><div><input type="hidden" name="id" value="'.$course->id.'" />';
 864     echo '<label for="search">' . get_string('search', 'search') . ' </label>';
 865     echo '<input type="text" id="search" name="search" value="'.s($search).'" />&nbsp;<input type="submit" value="'.get_string('search').'" /></div></form>'."\n";
 866 }
 867
 868 echo '</div>';  // Userlist.
 869
 870 echo $OUTPUT->footer();
 871
 872 if ($userlist) {
 873     $userlist->close();
 874 }
 875
 876 /**
 877  * Returns SQL that can be used to limit a query to a period where the user last accessed a course..
 878  *
 879  * @param string $accesssince
 880  * @return string
 881  */
 882 function get_course_lastaccess_sql($accesssince='') {
 883     if (empty($accesssince)) {
 884         return '';
 885     }
 886     if ($accesssince == -1) { // Never.
 887         return 'ul.timeaccess = 0';
 888     } else {
 889         return 'ul.timeaccess != 0 AND ul.timeaccess < '.$accesssince;
 890     }
 891 }
 892
 893 /**
 894  * Returns SQL that can be used to limit a query to a period where the user last accessed the system.
 895  *
 896  * @param string $accesssince
 897  * @return string
 898  */
 899 function get_user_lastaccess_sql($accesssince='') {
 900     if (empty($accesssince)) {
 901         return '';
 902     }
 903     if ($accesssince == -1) { // Never.
 904         return 'u.lastaccess = 0';
 905     } else {
 906         return 'u.lastaccess != 0 AND u.lastaccess < '.$accesssince;
 907     }
 908 }