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->libdir.'/tablelib.php');
  27 require_once($CFG->libdir.'/filelib.php');
  28
  29 define('USER_SMALL_CLASS', 20);   // Below this is considered small.
  30 define('USER_LARGE_CLASS', 200);  // Above this is considered large.
  31 define('DEFAULT_PAGE_SIZE', 20);
  32 define('SHOW_ALL_PAGE_SIZE', 5000);
  33 define('MODE_BRIEF', 0);
  34 define('MODE_USERDETAILS', 1);
  35
  36 $page         = optional_param('page', 0, PARAM_INT); // Which page to show.
  37 $perpage      = optional_param('perpage', DEFAULT_PAGE_SIZE, PARAM_INT); // How many per page.
  38 $mode         = optional_param('mode', null, PARAM_INT); // Use the MODE_ constants.
  39 $accesssince  = optional_param('accesssince', 0, PARAM_INT); // Filter by last access. -1 = never.
  40 $search       = optional_param('search', '', PARAM_RAW); // Make sure it is processed with p() or s() when sending to output!
  41 $roleid       = optional_param('roleid', 0, PARAM_INT); // Optional roleid, 0 means all enrolled users (or all on the frontpage).
  42 $contextid    = optional_param('contextid', 0, PARAM_INT); // One of this or.
  43 $courseid     = optional_param('id', 0, PARAM_INT); // This are required.
  44
  45 $PAGE->set_url('/user/index.php', array(
  46         'page' => $page,
  47         'perpage' => $perpage,
  48         'mode' => $mode,
  49         'accesssince' => $accesssince,
  50         'search' => $search,
  51         'roleid' => $roleid,
  52         'contextid' => $contextid,
  53         'id' => $courseid));
  54
  55 if ($contextid) {
  56     $context = context::instance_by_id($contextid, MUST_EXIST);
  57     if ($context->contextlevel != CONTEXT_COURSE) {
  58         print_error('invalidcontext');
  59     }
  60     $course = $DB->get_record('course', array('id' => $context->instanceid), '*', MUST_EXIST);
  61 } else {
  62     $course = $DB->get_record('course', array('id' => $courseid), '*', MUST_EXIST);
  63     $context = context_course::instance($course->id, MUST_EXIST);
  64 }
  65 // Not needed anymore.
  66 unset($contextid);
  67 unset($courseid);
  68
  69 require_login($course);
  70
  71 $systemcontext = context_system::instance();
  72 $isfrontpage = ($course->id == SITEID);
  73
  74 $frontpagectx = context_course::instance(SITEID);
  75
  76 if ($isfrontpage) {
  77     $PAGE->set_pagelayout('admin');
  78     require_capability('moodle/site:viewparticipants', $systemcontext);
  79 } else {
  80     $PAGE->set_pagelayout('incourse');
  81     require_capability('moodle/course:viewparticipants', $context);
  82 }
  83
  84 $rolenamesurl = new moodle_url("$CFG->wwwroot/user/index.php?contextid=$context->id&sifirst=&silast=");
  85
  86 $rolenames = role_fix_names(get_profile_roles($context), $context, ROLENAME_ALIAS, true);
  87 if ($isfrontpage) {
  88     $rolenames[0] = get_string('allsiteusers', 'role');
  89 } else {
  90     $rolenames[0] = get_string('allparticipants');
  91 }
  92
  93 // Make sure other roles may not be selected by any means.
  94 if (empty($rolenames[$roleid])) {
  95     print_error('noparticipants');
  96 }
  97
  98 // No roles to display yet?
  99 // frontpage course is an exception, on the front page course we should display all users.
 100 if (empty($rolenames) && !$isfrontpage) {
 101     if (has_capability('moodle/role:assign', $context)) {
 102         redirect($CFG->wwwroot.'/'.$CFG->admin.'/roles/assign.php?contextid='.$context->id);
 103     } else {
 104         print_error('noparticipants');
 105     }
 106 }
 107
 108 $event = \core\event\user_list_viewed::create(array(
 109     'objectid' => $course->id,
 110     'courseid' => $course->id,
 111     'context' => $context,
 112     'other' => array(
 113         'courseshortname' => $course->shortname,
 114         'coursefullname' => $course->fullname
 115     )
 116 ));
 117 $event->trigger();
 118
 119 $bulkoperations = has_capability('moodle/course:bulkmessaging', $context);
 120
 121 $countries = get_string_manager()->get_list_of_countries();
 122
 123 $strnever = get_string('never');
 124
 125 $datestring = new stdClass();
 126 $datestring->year  = get_string('year');
 127 $datestring->years = get_string('years');
 128 $datestring->day   = get_string('day');
 129 $datestring->days  = get_string('days');
 130 $datestring->hour  = get_string('hour');
 131 $datestring->hours = get_string('hours');
 132 $datestring->min   = get_string('min');
 133 $datestring->mins  = get_string('mins');
 134 $datestring->sec   = get_string('sec');
 135 $datestring->secs  = get_string('secs');
 136
 137 if ($mode !== null) {
 138     $mode = (int)$mode;
 139     $SESSION->userindexmode = $mode;
 140 } else if (isset($SESSION->userindexmode)) {
 141     $mode = (int)$SESSION->userindexmode;
 142 } else {
 143     $mode = MODE_BRIEF;
 144 }
 145
 146 // Check to see if groups are being used in this course
 147 // and if so, set $currentgroup to reflect the current group.
 148
 149 $groupmode    = groups_get_course_groupmode($course);   // Groups are being used.
 150 $currentgroup = groups_get_course_group($course, true);
 151
 152 if (!$currentgroup) {      // To make some other functions work better later.
 153     $currentgroup  = null;
 154 }
 155
 156 $isseparategroups = ($course->groupmode == SEPARATEGROUPS and !has_capability('moodle/site:accessallgroups', $context));
 157
 158 $PAGE->set_title("$course->shortname: ".get_string('participants'));
 159 $PAGE->set_heading($course->fullname);
 160 $PAGE->set_pagetype('course-view-' . $course->format);
 161 $PAGE->add_body_class('path-user');                     // So we can style it independently.
 162 $PAGE->set_other_editing_capability('moodle/course:manageactivities');
 163
 164 echo $OUTPUT->header();
 165
 166 echo '<div class="userlist">';
 167
 168 if ($isseparategroups and (!$currentgroup) ) {
 169     // The user is not in the group so show message and exit.
 170     echo $OUTPUT->heading(get_string("notingroup"));
 171     echo $OUTPUT->footer();
 172     exit;
 173 }
 174
 175
 176 // Should use this variable so that we don't break stuff every time a variable is added or changed.
 177 $baseurl = new moodle_url('/user/index.php', array(
 178         'contextid' => $context->id,
 179         'roleid' => $roleid,
 180         'id' => $course->id,
 181         'perpage' => $perpage,
 182         'accesssince' => $accesssince,
 183         'search' => s($search)));
 184
 185 // Setting up tags.
 186 if ($course->id == SITEID) {
 187     $filtertype = 'site';
 188 } else if ($course->id && !$currentgroup) {
 189     $filtertype = 'course';
 190     $filterselect = $course->id;
 191 } else {
 192     $filtertype = 'group';
 193     $filterselect = $currentgroup;
 194 }
 195
 196
 197
 198 // Get the hidden field list.
 199 if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
 200     $hiddenfields = array();  // Teachers and admins are allowed to see everything.
 201 } else {
 202     $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields));
 203 }
 204
 205 if (isset($hiddenfields['lastaccess'])) {
 206     // Do not allow access since filtering.
 207     $accesssince = 0;
 208 }
 209
 210 // Print settings and things in a table across the top.
 211 $controlstable = new html_table();
 212 $controlstable->attributes['class'] = 'controls';
 213 $controlstable->cellspacing = 0;
 214 $controlstable->data[] = new html_table_row();
 215
 216 // Print my course menus.
 217 if ($mycourses = enrol_get_my_courses()) {
 218     $courselist = array();
 219     $popupurl = new moodle_url('/user/index.php?roleid='.$roleid.'&sifirst=&silast=');
 220     foreach ($mycourses as $mycourse) {
 221         $coursecontext = context_course::instance($mycourse->id);
 222         $courselist[$mycourse->id] = format_string($mycourse->shortname, true, array('context' => $coursecontext));
 223     }
 224     if (has_capability('moodle/site:viewparticipants', $systemcontext)) {
 225         unset($courselist[SITEID]);
 226         $courselist = array(SITEID => format_string($SITE->shortname, true, array('context' => $systemcontext))) + $courselist;
 227     }
 228     $select = new single_select($popupurl, 'id', $courselist, $course->id, null, 'courseform');
 229     $select->set_label(get_string('mycourses'));
 230     $controlstable->data[0]->cells[] = $OUTPUT->render($select);
 231 }
 232
 233 $controlstable->data[0]->cells[] = groups_print_course_menu($course, $baseurl->out(), true);
 234
 235 if (!isset($hiddenfields['lastaccess'])) {
 236     // Get minimum lastaccess for this course and display a dropbox to filter by lastaccess going back this far.
 237     // We need to make it diferently for normal courses and site course.
 238     if (!$isfrontpage) {
 239         $minlastaccess = $DB->get_field_sql('SELECT min(timeaccess)
 240                                                FROM {user_lastaccess}
 241                                               WHERE courseid = ?
 242                                                     AND timeaccess != 0', array($course->id));
 243         $lastaccess0exists = $DB->record_exists('user_lastaccess', array('courseid' => $course->id, 'timeaccess' => 0));
 244     } else {
 245         $minlastaccess = $DB->get_field_sql('SELECT min(lastaccess)
 246                                                FROM {user}
 247                                               WHERE lastaccess != 0');
 248         $lastaccess0exists = $DB->record_exists('user', array('lastaccess' => 0));
 249     }
 250
 251     $now = usergetmidnight(time());
 252     $timeaccess = array();
 253     $baseurl->remove_params('accesssince');
 254
 255     // Makes sense for this to go first.
 256     $timeoptions[0] = get_string('selectperiod');
 257
 258     // Days.
 259     for ($i = 1; $i < 7; $i++) {
 260         if (strtotime('-'.$i.' days', $now) >= $minlastaccess) {
 261             $timeoptions[strtotime('-'.$i.' days', $now)] = get_string('numdays', 'moodle', $i);
 262         }
 263     }
 264     // Weeks.
 265     for ($i = 1; $i < 10; $i++) {
 266         if (strtotime('-'.$i.' weeks', $now) >= $minlastaccess) {
 267             $timeoptions[strtotime('-'.$i.' weeks', $now)] = get_string('numweeks', 'moodle', $i);
 268         }
 269     }
 270     // Months.
 271     for ($i = 2; $i < 12; $i++) {
 272         if (strtotime('-'.$i.' months', $now) >= $minlastaccess) {
 273             $timeoptions[strtotime('-'.$i.' months', $now)] = get_string('nummonths', 'moodle', $i);
 274         }
 275     }
 276     // Try a year.
 277     if (strtotime('-1 year', $now) >= $minlastaccess) {
 278         $timeoptions[strtotime('-1 year', $now)] = get_string('lastyear');
 279     }
 280
 281     if (!empty($lastaccess0exists)) {
 282         $timeoptions[-1] = get_string('never');
 283     }
 284
 285     if (count($timeoptions) > 1) {
 286         $select = new single_select($baseurl, 'accesssince', $timeoptions, $accesssince, null, 'timeoptions');
 287         $select->set_label(get_string('usersnoaccesssince'));
 288         $controlstable->data[0]->cells[] = $OUTPUT->render($select);
 289     }
 290 }
 291
 292 $formatmenu = array( '0' => get_string('brief'),
 293                      '1' => get_string('userdetails'));
 294 $select = new single_select($baseurl, 'mode', $formatmenu, $mode, null, 'formatmenu');
 295 $select->set_label(get_string('userlist'));
 296 $userlistcell = new html_table_cell();
 297 $userlistcell->attributes['class'] = 'right';
 298 $userlistcell->text = $OUTPUT->render($select);
 299 $controlstable->data[0]->cells[] = $userlistcell;
 300
 301 echo html_writer::table($controlstable);
 302
 303 if ($currentgroup and (!$isseparategroups or has_capability('moodle/site:accessallgroups', $context))) {
 304     // Display info about the group.
 305     if ($group = groups_get_group($currentgroup)) {
 306         if (!empty($group->description) or (!empty($group->picture) and empty($group->hidepicture))) {
 307             $groupinfotable = new html_table();
 308             $groupinfotable->attributes['class'] = 'groupinfobox';
 309             $picturecell = new html_table_cell();
 310             $picturecell->attributes['class'] = 'left side picture';
 311             $picturecell->text = print_group_picture($group, $course->id, true, true, false);
 312
 313             $contentcell = new html_table_cell();
 314             $contentcell->attributes['class'] = 'content';
 315
 316             $contentheading = $group->name;
 317             if (has_capability('moodle/course:managegroups', $context)) {
 318                 $aurl = new moodle_url('/group/group.php', array('id' => $group->id, 'courseid' => $group->courseid));
 319                 $contentheading .= '&nbsp;' . $OUTPUT->action_icon($aurl, new pix_icon('t/edit', get_string('editgroupprofile')));
 320             }
 321
 322             $group->description = file_rewrite_pluginfile_urls($group->description, 'pluginfile.php', $context->id, 'group',
 323                 'description', $group->id);
 324             if (!isset($group->descriptionformat)) {
 325                 $group->descriptionformat = FORMAT_MOODLE;
 326             }
 327             $options = array('overflowdiv' => true);
 328             $formatteddesc = format_text($group->description, $group->descriptionformat, $options);
 329             $contentcell->text = $OUTPUT->heading($contentheading, 3) . $formatteddesc;
 330             $groupinfotable->data[] = new html_table_row(array($picturecell, $contentcell));
 331             echo html_writer::table($groupinfotable);
 332         }
 333     }
 334 }
 335
 336 // Define a table showing a list of users in the current role selection.
 337 $tablecolumns = array();
 338 $tableheaders = array();
 339 if ($bulkoperations && $mode === MODE_BRIEF) {
 340     $tablecolumns[] = 'select';
 341     $tableheaders[] = get_string('select');
 342 }
 343 $tablecolumns[] = 'userpic';
 344 $tablecolumns[] = 'fullname';
 345
 346 $extrafields = get_extra_user_fields($context);
 347 $tableheaders[] = get_string('userpic');
 348 $tableheaders[] = get_string('fullnameuser');
 349
 350 if ($mode === MODE_BRIEF) {
 351     foreach ($extrafields as $field) {
 352         $tablecolumns[] = $field;
 353         $tableheaders[] = get_user_field_name($field);
 354     }
 355 }
 356 if ($mode === MODE_BRIEF && !isset($hiddenfields['city'])) {
 357     $tablecolumns[] = 'city';
 358     $tableheaders[] = get_string('city');
 359 }
 360 if ($mode === MODE_BRIEF && !isset($hiddenfields['country'])) {
 361     $tablecolumns[] = 'country';
 362     $tableheaders[] = get_string('country');
 363 }
 364 if (!isset($hiddenfields['lastaccess'])) {
 365     $tablecolumns[] = 'lastaccess';
 366     if ($course->id == SITEID) {
 367         // Exception case for viewing participants on site home.
 368         $tableheaders[] = get_string('lastsiteaccess');
 369     } else {
 370         $tableheaders[] = get_string('lastcourseaccess');
 371     }
 372 }
 373
 374 if ($bulkoperations && $mode === MODE_USERDETAILS) {
 375     $tablecolumns[] = 'select';
 376     $tableheaders[] = get_string('select');
 377 }
 378
 379 $table = new flexible_table('user-index-participants-'.$course->id);
 380 $table->define_columns($tablecolumns);
 381 $table->define_headers($tableheaders);
 382 $table->define_baseurl($baseurl->out());
 383
 384 if (!isset($hiddenfields['lastcourseaccess'])) {
 385     $table->sortable(true, 'lastcourseaccess', SORT_DESC);
 386 } else {
 387     $table->sortable(true, 'firstname', SORT_ASC);
 388 }
 389
 390 $table->no_sorting('roles');
 391 $table->no_sorting('groups');
 392 $table->no_sorting('groupings');
 393 $table->no_sorting('select');
 394
 395 $table->set_attribute('cellspacing', '0');
 396 $table->set_attribute('id', 'participants');
 397 $table->set_attribute('class', 'generaltable generalbox');
 398
 399 $table->set_control_variables(array(
 400             TABLE_VAR_SORT    => 'ssort',
 401             TABLE_VAR_HIDE    => 'shide',
 402             TABLE_VAR_SHOW    => 'sshow',
 403             TABLE_VAR_IFIRST  => 'sifirst',
 404             TABLE_VAR_ILAST   => 'silast',
 405             TABLE_VAR_PAGE    => 'spage'
 406             ));
 407 $table->setup();
 408
 409 list($esql, $params) = get_enrolled_sql($context, null, $currentgroup, true);
 410 $joins = array("FROM {user} u");
 411 $wheres = array();
 412
 413 $extrasql = get_extra_user_fields_sql($context, 'u', '', array(
 414         'id', 'username', 'firstname', 'lastname', 'email', 'city', 'country',
 415         'picture', 'lang', 'timezone', 'maildisplay', 'imagealt', 'lastaccess'));
 416
 417 $mainuserfields = user_picture::fields('u', array('username', 'email', 'city', 'country', 'lang', 'timezone', 'maildisplay'));
 418
 419 if ($isfrontpage) {
 420     $select = "SELECT $mainuserfields, u.lastaccess$extrasql";
 421     $joins[] = "JOIN ($esql) e ON e.id = u.id"; // Everybody on the frontpage usually.
 422     if ($accesssince) {
 423         $wheres[] = get_user_lastaccess_sql($accesssince);
 424     }
 425
 426 } else {
 427     $select = "SELECT $mainuserfields, COALESCE(ul.timeaccess, 0) AS lastaccess$extrasql";
 428     $joins[] = "JOIN ($esql) e ON e.id = u.id"; // Course enrolled users only.
 429     $joins[] = "LEFT JOIN {user_lastaccess} ul ON (ul.userid = u.id AND ul.courseid = :courseid)"; // Not everybody accessed course yet.
 430     $params['courseid'] = $course->id;
 431     if ($accesssince) {
 432         $wheres[] = get_course_lastaccess_sql($accesssince);
 433     }
 434 }
 435
 436 // Performance hacks - we preload user contexts together with accounts.
 437 $ccselect = ', ' . context_helper::get_preload_record_columns_sql('ctx');
 438 $ccjoin = "LEFT JOIN {context} ctx ON (ctx.instanceid = u.id AND ctx.contextlevel = :contextlevel)";
 439 $params['contextlevel'] = CONTEXT_USER;
 440 $select .= $ccselect;
 441 $joins[] = $ccjoin;
 442
 443
 444 // Limit list to users with some role only.
 445 if ($roleid) {
 446     // We want to query both the current context and parent contexts.
 447     list($relatedctxsql, $relatedctxparams) = $DB->get_in_or_equal($context->get_parent_context_ids(true), SQL_PARAMS_NAMED, 'relatedctx');
 448
 449     $wheres[] = "u.id IN (SELECT userid FROM {role_assignments} WHERE roleid = :roleid AND contextid $relatedctxsql)";
 450     $params = array_merge($params, array('roleid' => $roleid), $relatedctxparams);
 451 }
 452
 453 $from = implode("\n", $joins);
 454 if ($wheres) {
 455     $where = "WHERE " . implode(" AND ", $wheres);
 456 } else {
 457     $where = "";
 458 }
 459
 460 $totalcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
 461
 462 if (!empty($search)) {
 463     $fullname = $DB->sql_fullname('u.firstname', 'u.lastname');
 464     $wheres[] = "(". $DB->sql_like($fullname, ':search1', false, false) .
 465                 " OR ". $DB->sql_like('email', ':search2', false, false) .
 466                 " OR ". $DB->sql_like('idnumber', ':search3', false, false) .") ";
 467     $params['search1'] = "%$search%";
 468     $params['search2'] = "%$search%";
 469     $params['search3'] = "%$search%";
 470 }
 471
 472 list($twhere, $tparams) = $table->get_sql_where();
 473 if ($twhere) {
 474     $wheres[] = $twhere;
 475     $params = array_merge($params, $tparams);
 476 }
 477
 478 $from = implode("\n", $joins);
 479 if ($wheres) {
 480     $where = "WHERE " . implode(" AND ", $wheres);
 481 } else {
 482     $where = "";
 483 }
 484
 485 if ($table->get_sql_sort()) {
 486     $sort = ' ORDER BY '.$table->get_sql_sort();
 487 } else {
 488     $sort = '';
 489 }
 490
 491 $matchcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);
 492
 493 $table->initialbars(true);
 494 $table->pagesize($perpage, $matchcount);
 495
 496 // List of users at the current visible page - paging makes it relatively short.
 497 $userlist = $DB->get_recordset_sql("$select $from $where $sort", $params, $table->get_page_start(), $table->get_page_size());
 498
 499 // If there are multiple Roles in the course, then show a drop down menu for switching.
 500 if (count($rolenames) > 1) {
 501     echo '<div class="rolesform">';
 502     echo '<label for="rolesform_jump">'.get_string('currentrole', 'role').'&nbsp;</label>';
 503     echo $OUTPUT->single_select($rolenamesurl, 'roleid', $rolenames, $roleid, null, 'rolesform');
 504     echo '</div>';
 505
 506 } else if (count($rolenames) == 1) {
 507     // When all users with the same role - print its name.
 508     echo '<div class="rolesform">';
 509     echo get_string('role').get_string('labelsep', 'langconfig');
 510     $rolename = reset($rolenames);
 511     echo $rolename;
 512     echo '</div>';
 513 }
 514
 515 if ($roleid > 0) {
 516     $a = new stdClass();
 517     $a->number = $totalcount;
 518     $a->role = $rolenames[$roleid];
 519     $heading = format_string(get_string('xuserswiththerole', 'role', $a));
 520
 521     if ($currentgroup and $group) {
 522         $a->group = $group->name;
 523         $heading .= ' ' . format_string(get_string('ingroup', 'role', $a));
 524     }
 525
 526     if ($accesssince) {
 527         $a->timeperiod = $timeoptions[$accesssince];
 528         $heading .= ' ' . format_string(get_string('inactiveformorethan', 'role', $a));
 529     }
 530
 531     $heading .= ": $a->number";
 532
 533     if (user_can_assign($context, $roleid)) {
 534         $headingurl = new moodle_url($CFG->wwwroot . '/' . $CFG->admin . '/roles/assign.php',
 535                 array('roleid' => $roleid, 'contextid' => $context->id));
 536         $heading .= $OUTPUT->action_icon($headingurl, new pix_icon('t/edit', get_string('edit')));
 537     }
 538     echo $OUTPUT->heading($heading, 3);
 539 } else {
 540     if ($course->id != SITEID && has_capability('moodle/course:enrolreview', $context)) {
 541         $editlink = $OUTPUT->action_icon(new moodle_url('/enrol/users.php', array('id' => $course->id)),
 542                                          new pix_icon('t/edit', get_string('edit')));
 543     } else {
 544         $editlink = '';
 545     }
 546     if ($course->id == SITEID and $roleid < 0) {
 547         $strallparticipants = get_string('allsiteusers', 'role');
 548     } else {
 549         $strallparticipants = get_string('allparticipants');
 550     }
 551     if ($matchcount < $totalcount) {
 552         echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount.'/'.$totalcount . $editlink, 3);
 553     } else {
 554         echo $OUTPUT->heading($strallparticipants.get_string('labelsep', 'langconfig').$matchcount . $editlink, 3);
 555     }
 556 }
 557
 558
 559 if ($bulkoperations) {
 560     echo '<form action="action_redir.php" method="post" id="participantsform">';
 561     echo '<div>';
 562     echo '<input type="hidden" name="sesskey" value="'.sesskey().'" />';
 563     echo '<input type="hidden" name="returnto" value="'.s($PAGE->url->out(false)).'" />';
 564 }
 565
 566 if ($mode === MODE_USERDETAILS) {    // Print simple listing.
 567     if ($totalcount < 1) {
 568         echo $OUTPUT->heading(get_string('nothingtodisplay'));
 569     } else {
 570         if ($totalcount > $perpage) {
 571
 572             $firstinitial = $table->get_initial_first();
 573             $lastinitial  = $table->get_initial_last();
 574             $strall = get_string('all');
 575             $alpha  = explode(',', get_string('alphabet', 'langconfig'));
 576
 577             // Bar of first initials.
 578
 579             echo '<div class="initialbar firstinitial">'.get_string('firstname').' : ';
 580             if (!empty($firstinitial)) {
 581                 echo '<a href="'.$baseurl->out().'&amp;sifirst=">'.$strall.'</a>';
 582             } else {
 583                 echo '<strong>'.$strall.'</strong>';
 584             }
 585             foreach ($alpha as $letter) {
 586                 if ($letter == $firstinitial) {
 587                     echo ' <strong>'.$letter.'</strong>';
 588                 } else {
 589                     echo ' <a href="'.$baseurl->out().'&amp;sifirst='.$letter.'">'.$letter.'</a>';
 590                 }
 591             }
 592             echo '</div>';
 593
 594             // Bar of last initials.
 595
 596             echo '<div class="initialbar lastinitial">'.get_string('lastname').' : ';
 597             if (!empty($lastinitial)) {
 598                 echo '<a href="'.$baseurl->out().'&amp;silast=">'.$strall.'</a>';
 599             } else {
 600                 echo '<strong>'.$strall.'</strong>';
 601             }
 602             foreach ($alpha as $letter) {
 603                 if ($letter == $lastinitial) {
 604                     echo ' <strong>'.$letter.'</strong>';
 605                 } else {
 606                     echo ' <a href="'.$baseurl->out().'&amp;silast='.$letter.'">'.$letter.'</a>';
 607                 }
 608             }
 609             echo '</div>';
 610
 611             $pagingbar = new paging_bar($matchcount, intval($table->get_page_start() / $perpage), $perpage, $baseurl);
 612             $pagingbar->pagevar = 'spage';
 613             echo $OUTPUT->render($pagingbar);
 614         }
 615
 616         if ($matchcount > 0) {
 617             $usersprinted = array();
 618             foreach ($userlist as $user) {
 619                 if (in_array($user->id, $usersprinted)) { // Prevent duplicates by r.hidden - MDL-13935.
 620                     continue;
 621                 }
 622                 $usersprinted[] = $user->id; // Add new user to the array of users printed.
 623
 624                 context_helper::preload_from_record($user);
 625
 626                 $context = context_course::instance($course->id);
 627                 $usercontext = context_user::instance($user->id);
 628
 629                 $countries = get_string_manager()->get_list_of_countries();
 630
 631                 // Get the hidden field list.
 632                 if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
 633                     $hiddenfields = array();
 634                 } else {
 635                     $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields));
 636                 }
 637                 $table = new html_table();
 638                 $table->attributes['class'] = 'userinfobox';
 639
 640                 $row = new html_table_row();
 641                 $row->cells[0] = new html_table_cell();
 642                 $row->cells[0]->attributes['class'] = 'left side';
 643
 644                 $row->cells[0]->text = $OUTPUT->user_picture($user, array('size' => 100, 'courseid' => $course->id));
 645                 $row->cells[1] = new html_table_cell();
 646                 $row->cells[1]->attributes['class'] = 'content';
 647
 648                 $row->cells[1]->text = $OUTPUT->container(fullname($user, has_capability('moodle/site:viewfullnames', $context)), 'username');
 649                 $row->cells[1]->text .= $OUTPUT->container_start('info');
 650
 651                 if (!empty($user->role)) {
 652                     $row->cells[1]->text .= get_string('role').get_string('labelsep', 'langconfig').$user->role.'<br />';
 653                 }
 654                 if ($user->maildisplay == 1 or ($user->maildisplay == 2 and ($course->id != SITEID) and !isguestuser()) or
 655                             has_capability('moodle/course:viewhiddenuserfields', $context) or
 656                             in_array('email', $extrafields) or ($user->id == $USER->id)) {
 657                     $row->cells[1]->text .= get_string('email').get_string('labelsep', 'langconfig').html_writer::link("mailto:$user->email", $user->email) . '<br />';
 658                 }
 659                 foreach ($extrafields as $field) {
 660                     if ($field === 'email') {
 661                         // Skip email because it was displayed with different logic above
 662                         // because this page is intended for students too.
 663                         continue;
 664                     }
 665                     $row->cells[1]->text .= get_user_field_name($field) .
 666                             get_string('labelsep', 'langconfig') . s($user->{$field}) . '<br />';
 667                 }
 668                 if (($user->city or $user->country) and (!isset($hiddenfields['city']) or !isset($hiddenfields['country']))) {
 669                     $row->cells[1]->text .= get_string('city').get_string('labelsep', 'langconfig');
 670                     if ($user->city && !isset($hiddenfields['city'])) {
 671                         $row->cells[1]->text .= $user->city;
 672                     }
 673                     if (!empty($countries[$user->country]) && !isset($hiddenfields['country'])) {
 674                         if ($user->city && !isset($hiddenfields['city'])) {
 675                             $row->cells[1]->text .= ', ';
 676                         }
 677                         $row->cells[1]->text .= $countries[$user->country];
 678                     }
 679                     $row->cells[1]->text .= '<br />';
 680                 }
 681
 682                 if (!isset($hiddenfields['lastaccess'])) {
 683                     if ($user->lastaccess) {
 684                         $row->cells[1]->text .= get_string('lastaccess').get_string('labelsep', 'langconfig').userdate($user->lastaccess);
 685                         $row->cells[1]->text .= '&nbsp; ('. format_time(time() - $user->lastaccess, $datestring) .')';
 686                     } else {
 687                         $row->cells[1]->text .= get_string('lastaccess').get_string('labelsep', 'langconfig').get_string('never');
 688                     }
 689                 }
 690
 691                 $row->cells[1]->text .= $OUTPUT->container_end();
 692
 693                 $row->cells[2] = new html_table_cell();
 694                 $row->cells[2]->attributes['class'] = 'links';
 695                 $row->cells[2]->text = '';
 696
 697                 $links = array();
 698
 699                 if ($CFG->enableblogs && ($CFG->bloglevel != BLOG_USER_LEVEL || $USER->id == $user->id)) {
 700                     $links[] = html_writer::link(new moodle_url('/blog/index.php?userid='.$user->id), get_string('blogs', 'blog'));
 701                 }
 702
 703                 if (!empty($CFG->enablenotes) and (has_capability('moodle/notes:manage', $context) || has_capability('moodle/notes:view', $context))) {
 704                     $links[] = html_writer::link(new moodle_url('/notes/index.php?course=' . $course->id. '&user='.$user->id), get_string('notes', 'notes'));
 705                 }
 706
 707                 if (has_capability('moodle/site:viewreports', $context) or has_capability('moodle/user:viewuseractivitiesreport', $usercontext)) {
 708                     $links[] = html_writer::link(new moodle_url('/course/user.php?id='. $course->id .'&user='. $user->id), get_string('activity'));
 709                 }
 710
 711                 if ($USER->id != $user->id && !\core\session\manager::is_loggedinas() && has_capability('moodle/user:loginas', $context) && !is_siteadmin($user->id)) {
 712                     $links[] = html_writer::link(new moodle_url('/course/loginas.php?id='. $course->id .'&user='. $user->id .'&sesskey='. sesskey()), get_string('loginas'));
 713                 }
 714
 715                 $links[] = html_writer::link(new moodle_url('/user/view.php?id='. $user->id .'&course='. $course->id), get_string('fullprofile') . '...');
 716
 717                 $row->cells[2]->text .= implode('', $links);
 718
 719                 if ($bulkoperations) {
 720                     $row->cells[2]->text .= '<br /><input type="checkbox" class="usercheckbox" name="user'.$user->id.'" /> ';
 721                 }
 722                 $table->data = array($row);
 723                 echo html_writer::table($table);
 724             }
 725
 726         } else {
 727             echo $OUTPUT->heading(get_string('nothingtodisplay'));
 728         }
 729     }
 730
 731 } else {
 732     $countrysort = (strpos($sort, 'country') !== false);
 733     $timeformat = get_string('strftimedate');
 734
 735
 736     if ($userlist) {
 737
 738         $usersprinted = array();
 739         foreach ($userlist as $user) {
 740             if (in_array($user->id, $usersprinted)) { // Prevent duplicates by r.hidden - MDL-13935.
 741                 continue;
 742             }
 743             $usersprinted[] = $user->id; // Add new user to the array of users printed.
 744
 745             context_helper::preload_from_record($user);
 746
 747             if ($user->lastaccess) {
 748                 $lastaccess = format_time(time() - $user->lastaccess, $datestring);
 749             } else {
 750                 $lastaccess = $strnever;
 751             }
 752
 753             if (empty($user->country)) {
 754                 $country = '';
 755
 756             } else {
 757                 if ($countrysort) {
 758                     $country = '('.$user->country.') '.$countries[$user->country];
 759                 } else {
 760                     $country = $countries[$user->country];
 761                 }
 762             }
 763
 764             $usercontext = context_user::instance($user->id);
 765
 766             if ($piclink = ($USER->id == $user->id || has_capability('moodle/user:viewdetails', $context) || has_capability('moodle/user:viewdetails', $usercontext))) {
 767                 $profilelink = '<strong><a href="'.$CFG->wwwroot.'/user/view.php?id='.$user->id.'&amp;course='.$course->id.'">'.fullname($user).'</a></strong>';
 768             } else {
 769                 $profilelink = '<strong>'.fullname($user).'</strong>';
 770             }
 771
 772             $data = array();
 773             if ($bulkoperations) {
 774                 $data[] = '<input type="checkbox" class="usercheckbox" name="user'.$user->id.'" />';
 775             }
 776             $data[] = $OUTPUT->user_picture($user, array('size' => 35, 'courseid' => $course->id));
 777             $data[] = $profilelink;
 778
 779             if ($mode === MODE_BRIEF) {
 780                 foreach ($extrafields as $field) {
 781                     $data[] = $user->{$field};
 782                 }
 783             }
 784             if ($mode === MODE_BRIEF && !isset($hiddenfields['city'])) {
 785                 $data[] = $user->city;
 786             }
 787             if ($mode === MODE_BRIEF && !isset($hiddenfields['country'])) {
 788                 $data[] = $country;
 789             }
 790             if (!isset($hiddenfields['lastaccess'])) {
 791                 $data[] = $lastaccess;
 792             }
 793
 794             $table->add_data($data);
 795         }
 796     }
 797
 798     $table->print_html();
 799
 800 }
 801
 802 if ($bulkoperations) {
 803     echo '<br /><div class="buttons">';
 804     echo '<input type="button" id="checkall" value="'.get_string('selectall').'" /> ';
 805     echo '<input type="button" id="checknone" value="'.get_string('deselectall').'" /> ';
 806     $displaylist = array();
 807     $displaylist['messageselect.php'] = get_string('messageselectadd');
 808     if (!empty($CFG->enablenotes) && has_capability('moodle/notes:manage', $context) && $context->id != $frontpagectx->id) {
 809         $displaylist['addnote.php'] = get_string('addnewnote', 'notes');
 810         $displaylist['groupaddnote.php'] = get_string('groupaddnewnote', 'notes');
 811     }
 812
 813     echo $OUTPUT->help_icon('withselectedusers');
 814     echo html_writer::tag('label', get_string("withselectedusers"), array('for' => 'formactionid'));
 815     echo html_writer::select($displaylist, 'formaction', '', array('' => 'choosedots'), array('id' => 'formactionid'));
 816
 817     echo '<input type="hidden" name="id" value="'.$course->id.'" />';
 818     echo '<noscript style="display:inline">';
 819     echo '<div><input type="submit" value="'.get_string('ok').'" /></div>';
 820     echo '</noscript>';
 821     echo '</div></div>';
 822     echo '</form>';
 823
 824     $module = array('name' => 'core_user', 'fullpath' => '/user/module.js');
 825     $PAGE->requires->js_init_call('M.core_user.init_participation', null, false, $module);
 826 }
 827
 828 // Show a search box if all participants don't fit on a single screen.
 829 if ($totalcount > $perpage) {
 830     echo '<form action="index.php" class="searchform"><div><input type="hidden" name="id" value="'.$course->id.'" />';
 831     echo '<label for="search">' . get_string('search', 'search') . ' </label>';
 832     echo '<input type="text" id="search" name="search" value="'.s($search).'" />&nbsp;<input type="submit" value="'.get_string('search').'" /></div></form>'."\n";
 833 }
 834
 835 $perpageurl = clone($baseurl);
 836 $perpageurl->remove_params('perpage');
 837 if ($perpage == SHOW_ALL_PAGE_SIZE) {
 838     $perpageurl->param('perpage', DEFAULT_PAGE_SIZE);
 839     echo $OUTPUT->container(html_writer::link($perpageurl, get_string('showperpage', '', DEFAULT_PAGE_SIZE)), array(), 'showall');
 840
 841 } else if ($matchcount > 0 && $perpage < $matchcount) {
 842     $perpageurl->param('perpage', SHOW_ALL_PAGE_SIZE);
 843     echo $OUTPUT->container(html_writer::link($perpageurl, get_string('showall', '', $matchcount)), array(), 'showall');
 844 }
 845
 846 echo '</div>';  // Userlist.
 847
 848 echo $OUTPUT->footer();
 849
 850 if ($userlist) {
 851     $userlist->close();
 852 }
 853
 854 /**
 855  * Returns SQL that can be used to limit a query to a period where the user last accessed a course..
 856  *
 857  * @param string $accesssince
 858  * @return string
 859  */
 860 function get_course_lastaccess_sql($accesssince='') {
 861     if (empty($accesssince)) {
 862         return '';
 863     }
 864     if ($accesssince == -1) { // Never.
 865         return 'ul.timeaccess = 0';
 866     } else {
 867         return 'ul.timeaccess != 0 AND ul.timeaccess < '.$accesssince;
 868     }
 869 }
 870
 871 /**
 872  * Returns SQL that can be used to limit a query to a period where the user last accessed the system.
 873  *
 874  * @param string $accesssince
 875  * @return string
 876  */
 877 function get_user_lastaccess_sql($accesssince='') {
 878     if (empty($accesssince)) {
 879         return '';
 880     }
 881     if ($accesssince == -1) { // Never.
 882         return 'u.lastaccess = 0';
 883     } else {
 884         return 'u.lastaccess != 0 AND u.lastaccess < '.$accesssince;
 885     }
 886 }