user/index.php

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