personalized_vars_values.php

<?php
// This file is part of the Moodle module "EJSApp"
//
// EJSApp is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// EJSApp is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
//
// EJSApp has been developed by:
// - Luis de la Torre: ldelatorre@dia.uned.es
// - Ruben Heradio: rheradio@issi.uned.es
//
// at the Computer Science and Automatic Control, Spanish Open University
// (UNED), Madrid, Spain.

/**
 * Page for listing the value of the personalized variables of an ejsapp activity for all users
 *
 * @package    mod_ejsapp
 * @copyright  2012 Luis de la Torre and Ruben Heradio
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

require_once('../../config.php');
require_once($CFG->libdir.'/tablelib.php');
require_once($CFG->libdir.'/filelib.php');
require_once($CFG->dirroot . '/filter/multilang/filter.php');
require_once('locallib.php');

define('USER_SMALL_CLASS', 20);   // Below this is considered small.
define('USER_LARGE_CLASS', 200);  // Above this is considered large.
define('DEFAULT_PAGE_SIZE', 20);
define('SHOW_ALL_PAGE_SIZE', 5000);

$id = required_param('id', PARAM_INT);
$courseid = required_param('courseid', PARAM_INT);
$cm = get_coursemodule_from_id('ejsapp', $id, 0, false, MUST_EXIST);

$ejsappid = optional_param('ejsappid', 0, PARAM_INT);
$page = optional_param('page', 0, PARAM_INT);                       // Which page to show.
$perpage = optional_param('perpage', DEFAULT_PAGE_SIZE, PARAM_INT); // How many per page.
$mode = optional_param('mode', null, PARAM_INT);                    // Use the MODE_ constants.
$accesssince = optional_param('accesssince', 0, PARAM_INT);         // Filter by last access. -1 = never.
$search = optional_param('search', '', PARAM_RAW);
$roleid = optional_param('roleid', 0, PARAM_INT);                   // 0 means all enrolled users.

$course = $DB->get_record('course', array('id' => $courseid), '*', MUST_EXIST);

require_login($course, true, $cm);
$contextmod = context_module::instance($cm->id);
$context = context_course::instance($courseid);

$title = get_string('personalVars_pageTitle', 'ejsapp');
$PAGE->set_context($contextmod);
$PAGE->set_title($title);
$PAGE->set_heading($title);

$ejsappid = $cm->instance;
// Check whether the selected or other ejsapp in this course have personalized variables or not.
$ejsapps = $DB->get_records_select('ejsapp', 'course = ? AND personalvars = ?', array($courseid, 1));
$i = 1;
$multilang = new filter_multilang($context, array('filter_multilang_force_old' => 0));
foreach ($ejsapps as $ejsapp) {
    $ejsappnames[$ejsapp->id] = $multilang->filter($ejsapp->name);
    if ($i == 1 && $ejsappid == 0) {
        $ejsappid = $cm->instance;
    }
    $i++;
}
$ejsapp = $DB->get_record('ejsapp', array('id' => $ejsappid));
if ($ejsapp->personalvars == 1) {
    $personalized = true;
} else {
    $personalized = false;
}

$PAGE->set_url('/mod/ejsapp/personalized_vars_values.php', array('id' => $id, 'courseid' => $courseid));

$systemcontext = context_system::instance();
$isfrontpage = ($course->id == SITEID);

$frontpagectx = context_course::instance(SITEID);

if ($isfrontpage) {
    $PAGE->set_pagelayout('admin');
} else {
    $PAGE->set_pagelayout('incourse');
}

$rolenamesurl = new moodle_url($CFG->wwwroot .
    "/mod/ejsapp/personalized_vars_values.php?id=$id&courseid=$courseid&sifirst=&silast=");

$allroles = get_all_roles();
$roles = get_profile_roles($context);
$allrolenames = array();
if ($isfrontpage) {
    $rolenames = array(0 => get_string('allsiteusers', 'role'));
} else {
    $rolenames = array(0 => get_string('allparticipants'));
}


foreach ($allroles as $role) {
    $allrolenames[$role->id] = strip_tags(role_get_name($role, $context));   // Used in menus, etc. later on.
    if (isset($roles[$role->id])) {
        $rolenames[$role->id] = $allrolenames[$role->id];
    }
}

// Make sure other roles may not be selected by any means.
if (empty($rolenames[$roleid])) {
    print_error('noparticipants');
}

// No roles to display yet?
// Frontpage course is an exception, on the front page course we should display all users.
if (empty($rolenames) && !$isfrontpage) {
    if (has_capability('moodle/role:assign', $context)) {
        redirect($CFG->wwwroot.'/'.$CFG->admin.'/roles/assign.php?contextid='.$context->id);
    } else {
        print_error('noparticipants');
    }
}

$countries = get_string_manager()->get_list_of_countries();

$strnever = get_string('never');

$datestring = new stdClass();
$datestring->year  = get_string('year');
$datestring->years = get_string('years');
$datestring->day   = get_string('day');
$datestring->days  = get_string('days');
$datestring->hour  = get_string('hour');
$datestring->hours = get_string('hours');
$datestring->min   = get_string('min');
$datestring->mins  = get_string('mins');
$datestring->sec   = get_string('sec');
$datestring->secs  = get_string('secs');

if ($mode !== null) {
    $mode = (int)$mode;
    $SESSION->userindexmode = $mode;
} else if (isset($SESSION->userindexmode)) {
    $mode = (int)$SESSION->userindexmode;
}

// Check to see if groups are being used in this course and if so, set $currentgroup to reflect the current group.
$groupmode    = groups_get_course_groupmode($course);   // Groups are being used.
$currentgroup = groups_get_course_group($course, true);

if (!$currentgroup) {      // To make some other functions work better later.
    $currentgroup  = null;
}

$isseparategroups = ($course->groupmode == SEPARATEGROUPS and
    !has_capability('moodle/site:accessallgroups', $context));

/**
 * Returns the course last access
 *
 * @param int $accesssince
 * @return string
 */
function get_course_lastaccess_sql($accesssince='') {
    if (empty($accesssince)) {
        return '';
    }
    if ($accesssince == -1) { // Never.
        return 'ul.timeaccess = 0';
    } else {
        return 'ul.timeaccess != 0 AND ul.timeaccess < '.$accesssince;
    }
}

/**
 * Returns the user last access
 *
 * @param int $accesssince
 * @return string
 *
 */
function get_user_lastaccess_sql($accesssince='') {
    if (empty($accesssince)) {
        return '';
    }
    if ($accesssince == -1) { // Never.
        return 'u.lastaccess = 0';
    } else {
        return 'u.lastaccess != 0 AND u.lastaccess < '.$accesssince;
    }
}

if ($personalized) { // If there is at least one ejsapp activity with personalized variables.
    $download = optional_param('download', '', PARAM_ALPHA);
    $exportfilename = get_string('personalized_values', 'ejsapp').$ejsappnames[$ejsapp->id];
    $table = new flexible_table('user-index-participants-'.$course->id);
    if (!$table->is_downloading($download, $exportfilename)) {
        $table->show_download_buttons_at(array(TABLE_P_BOTTOM));

        if ($course->id === SITEID) {
            $PAGE->navbar->ignore_active();
        }

        echo $OUTPUT->header();
        echo $OUTPUT->heading(get_string('users_ejsapp_selection', 'ejsapp'));
        echo '<div class="userlist">';

        if ($isseparategroups and (!$currentgroup)) {
            // The user is not in the group so show message and exit.
            echo $OUTPUT->heading(get_string("notingroup"));
            echo $OUTPUT->footer();
            exit;
        }
    }

    // Should use this variable so that we don't break stuff every time a variable is added or changed.
    $baseurl = new moodle_url('/mod/ejsapp/personalized_vars_values.php', array(
          'id' => $id,
          'courseid' => $courseid,
          'roleid' => $roleid,
          'perpage' => $perpage,
          'accesssince' => $accesssince,
          'search' => s($search)));

    // Setting up tags.
    if ($course->id == SITEID) {
        $filtertype = 'site';
    } else if ($course->id && !$currentgroup) {
        $filtertype = 'course';
        $filterselect = $course->id;
    } else {
        $filtertype = 'group';
        $filterselect = $currentgroup;
    }

    // Get the hidden field list.
    if (has_capability('moodle/course:viewhiddenuserfields', $context)) {
        $hiddenfields = array();  // Teachers and admins are allowed to see everything.
    } else {
        $hiddenfields = array_flip(explode(',', $CFG->hiddenuserfields));
    }

    if (isset($hiddenfields['lastaccess'])) {
        // Do not allow access since filtering.
        $accesssince = 0;
    }

    // Print settings and things in a table across the top.
    $controlstable = new html_table();
    $controlstable->attributes['class'] = 'controls';
    $controlstable->data[] = new html_table_row();

    // Print my course menus.
    if ($mycourses = enrol_get_my_courses()) {
        $courselist = array();
        $popupurl = new moodle_url('/mod/ejsapp/personalized_vars_values.php?id='.$id.'&courseid='.$courseid.
            '&roleid='.$roleid.'&sifirst=&silast=');
        foreach ($mycourses as $mycourse) {
            $courselist[$mycourse->id] = format_string($mycourse->shortname);
        }
        if (has_capability('moodle/site:viewparticipants', $systemcontext)) {
            unset($courselist[SITEID]);
            $courselist = array(SITEID => format_string($SITE->shortname)) + $courselist;
        }
        $select = new single_select($popupurl, 'id', $courselist, $course->id,
            array('' => 'choosedots'), 'courseform');
        $select->set_label(get_string('mycourses'));
        $controlstable->data[0]->cells[] = $OUTPUT->render($select);
    }
    
    $controlstable->data[0]->cells[] = groups_print_course_menu($course, $baseurl->out(), true);
    
    if (!isset($hiddenfields['lastaccess'])) {
        // Get minimum lastaccess for this course and display a dropbox to filter by lastaccess going back this far.
        // We need to make it differently for normal courses and site course.
        if (!$isfrontpage) {
            $minlastaccess = $DB->get_field_sql('SELECT min(timeaccess)
                                                 FROM {user_lastaccess}
                                                 WHERE courseid = ?
                                                 AND timeaccess != 0', array($course->id));
            $lastaccess0exists = $DB->record_exists('user_lastaccess',
                array('courseid' => $course->id, 'timeaccess' => 0));
        } else {
            $minlastaccess = $DB->get_field_sql('SELECT min(lastaccess)
                                                 FROM {user}
                                                 WHERE lastaccess != 0');
            $lastaccess0exists = $DB->record_exists('user', array('lastaccess' => 0));
        }

        $now = usergetmidnight(time());
        $timeaccess = array();
        $baseurl->remove_params('accesssince');

        // Makes sense for this to go first.
        $timeoptions[0] = get_string('selectperiod');

        // Days.
        for ($i = 1; $i < 7; $i++) {
            if (strtotime('-' . $i . ' days', $now) >= $minlastaccess) {
                $timeoptions[strtotime('-' . $i . ' days', $now)] = get_string('numdays', 'moodle', $i);
            }
        }
        // Weeks.
        for ($i = 1; $i < 10; $i++) {
            if (strtotime('-' . $i . ' weeks', $now) >= $minlastaccess) {
                $timeoptions[strtotime('-' . $i . ' weeks', $now)] = get_string('numweeks', 'moodle', $i);
            }
        }
        // Months.
        for ($i = 2; $i < 12; $i++) {
            if (strtotime('-' . $i . ' months', $now) >= $minlastaccess) {
                $timeoptions[strtotime('-' . $i . ' months', $now)] = get_string('nummonths', 'moodle', $i);
            }
        }
        // Try a year.
        if (strtotime('-1 year', $now) >= $minlastaccess) {
            $timeoptions[strtotime('-1 year', $now)] = get_string('lastyear');
        }

        if (!empty($lastaccess0exists)) {
            $timeoptions[-1] = get_string('never');
        }

        if (count($timeoptions) > 1) {
            $select = new single_select($baseurl, 'accesssince', $timeoptions, $accesssince, null, 'timeoptions');
            $select->set_label(get_string('usersnoaccesssince'));
            $controlstable->data[0]->cells[] = $OUTPUT->render($select);
        }
    }

    if ($currentgroup and (!$isseparategroups or has_capability('moodle/site:accessallgroups', $context))) {
        // Display info about the group.
        if ($group = groups_get_group($currentgroup)) {
            if (!empty($group->description) or (!empty($group->picture) and empty($group->hidepicture))) {
                $groupinfotable = new html_table();
                $groupinfotable->attributes['class'] = 'groupinfobox';
                $picturecell = new html_table_cell();
                $picturecell->attributes['class'] = 'left side picture';
                $picturecell->text = print_group_picture($group, $course->id, true, true, false);

                $contentcell = new html_table_cell();
                $contentcell->attributes['class'] = 'content';

                $contentheading = $group->name;
                if (has_capability('moodle/course:managegroups', $context)) {
                    $aurl = new moodle_url('/group/group.php', array('id' => $group->id, 'courseid' => $group->courseid));
                    $contentheading .= '&nbsp;' . $OUTPUT->action_icon($aurl, new pix_icon('t/edit',
                            get_string('editgroupprofile')));
                }

                $group->description = file_rewrite_pluginfile_urls($group->description, 'pluginfile.php', $context->id,
                    'group', 'description', $group->id);
                if (!isset($group->descriptionformat)) {
                    $group->descriptionformat = FORMAT_MOODLE;
                }
                $options = array('overflowdiv' => true);
                $contentcell->text = $OUTPUT->heading($contentheading, 3) . format_text($group->description,
                        $group->descriptionformat, $options);
                $groupinfotable->data[] = new html_table_row(array($picturecell, $contentcell));
                if (!$table->is_downloading($download, $exportfilename)) {
                    echo html_writer::table($groupinfotable);
                }
            }
        }
    }

    // Define a table showing a list of users in the current role selection.
    $tablecolumns = array('userpic', 'fullname');
    $tableheaders = array(get_string('userpic'), get_string('fullnameuser'));
    if (!isset($hiddenfields['city'])) {
        $tablecolumns[] = 'city';
        $tableheaders[] = get_string('city');
    }
    if (!isset($hiddenfields['country'])) {
        $tablecolumns[] = 'country';
        $tableheaders[] = get_string('country');
    }
    if (!isset($hiddenfields['lastaccess'])) {
        $tablecolumns[] = 'lastaccess';
        $tableheaders[] = get_string('lastaccess');
    }

    $personalvars = $DB->get_records('ejsapp_personal_vars', array('ejsappid' => $ejsappid));
    for ($i = 0; $i < count($personalvars); $i++) {
        if (!isset($hiddenfields['variable_name_' . $i])) {
            $tablecolumns[] = 'variable_name_' . $i;
            $tableheaders[] = get_string('variable_name', 'ejsapp');
        }
        if (!isset($hiddenfields['variable_value_' . $i])) {
            $tablecolumns[] = 'variable_value_' . $i;
            $tableheaders[] = get_string('variable_value', 'ejsapp');
        }
    }

    $table->define_columns($tablecolumns);
    $table->define_headers($tableheaders);
    $table->define_baseurl($baseurl->out());

    if (!isset($hiddenfields['lastaccess'])) {
        $table->sortable(true, 'lastaccess', SORT_DESC);
    }

    $table->no_sorting('roles');
    $table->no_sorting('groups');
    $table->no_sorting('groupings');
    for ($i = 0; $i < count($personalvars); $i++) {
        $table->no_sorting('variable_name_' . $i);
        $table->no_sorting('variable_value_' . $i);
    }

    $table->set_attribute('cellspacing', '0');
    $table->set_attribute('align', 'center');
    $table->set_attribute('id', 'participants');
    $table->set_attribute('class', 'generaltable generalbox');

    $table->set_control_variables(array(
        TABLE_VAR_SORT    => 'ssort',
        TABLE_VAR_HIDE    => 'shide',
        TABLE_VAR_SHOW    => 'sshow',
        TABLE_VAR_IFIRST  => 'sifirst',
        TABLE_VAR_ILAST   => 'silast',
        TABLE_VAR_PAGE    => 'spage'
    ));
    $table->setup();

    // We are looking for all users with this role assigned in this context or higher.
    $contextlist = $context->get_parent_context_ids(true);

    list($esql, $params) = get_enrolled_sql($context, null, $currentgroup, true);

    $joins = array("FROM {user} u");
    $wheres = array();

    if ($isfrontpage) {
        $select = "SELECT u.id, u.username, u.firstname, u.lastname,
                        u.email, u.city, u.country, u.picture,
                        u.lang, u.timezone, u.maildisplay, u.imagealt,
                        u.lastaccess";
        $joins[] = "JOIN ($esql) e ON e.id = u.id"; // Everybody on the frontpage usually.
        if ($accesssince) {
            $wheres[] = get_user_lastaccess_sql($accesssince);
        }
    } else {
        $select = "SELECT u.id, u.username, u.firstname, u.lastname,
                        u.email, u.city, u.country, u.picture,
                        u.lang, u.timezone, u.maildisplay, u.imagealt,
                        COALESCE(ul.timeaccess, 0) AS lastaccess";
        $joins[] = "JOIN ($esql) e ON e.id = u.id"; // Course enrolled users only.
        // Not everybody accessed course yet.
        $joins[] = "LEFT JOIN {user_lastaccess} ul ON (ul.userid = u.id AND ul.courseid = :courseid)";
        $params['courseid'] = $course->id;
        if ($accesssince) {
            $wheres[] = get_course_lastaccess_sql($accesssince);
        }
    }

    // Performance hacks - we preload user contexts together with accounts.
    $joinon = 'u.id';
    $contextlevel = CONTEXT_USER;
    $tablealias = 'ctx';
    $ccselect = ", " . context_helper::get_preload_record_columns_sql($tablealias);
    $ccjoin = "LEFT JOIN {context} $tablealias ON ($tablealias.instanceid = $joinon AND $tablealias.contextlevel = $contextlevel)";
    $select .= $ccselect;
    $joins[] = $ccjoin;

    // Limit list to users with some role only.
    if ($roleid) {
        $wheres[] = "u.id IN (SELECT userid FROM {role_assignments} WHERE roleid = :roleid AND contextid IN (" .
            implode(',', $contextlist) . "))";
        $params['roleid'] = $roleid;
    }

    $from = implode("\n", $joins);
    if ($wheres) {
        $where = "WHERE " . implode(" AND ", $wheres);
    } else {
        $where = "";
    }

    $totalcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);

    if (!empty($search)) {
        $fullname = $DB->sql_fullname('u.firstname', 'u.lastname');
        $wheres[] = "(". $DB->sql_like($fullname, ':search1', false, false) .
            " OR ". $DB->sql_like('email', ':search2', false, false) .
            " OR ". $DB->sql_like('idnumber', ':search3', false, false) .") ";
        $params['search1'] = "%$search%";
        $params['search2'] = "%$search%";
        $params['search3'] = "%$search%";
    }

    list($twhere, $tparams) = $table->get_sql_where();
    if ($twhere) {
        $wheres[] = $twhere;
        $params = array_merge($params, $tparams);
    }

    $from = implode("\n", $joins);
    if ($wheres) {
        $where = "WHERE " . implode(" AND ", $wheres);
    } else {
        $where = "";
    }

    if ($table->get_sql_sort()) {
        $sort = ' ORDER BY '.$table->get_sql_sort();
    } else {
        $sort = '';
    }

    $matchcount = $DB->count_records_sql("SELECT COUNT(u.id) $from $where", $params);

    $table->initialbars(true);
    $table->pagesize($perpage, $matchcount);

    // List of users at the current visible page - paging makes it relatively short.
    $userlist = $DB->get_recordset_sql("$select $from $where $sort", $params, $table->get_page_start(),
        $table->get_page_size());

    // If there are multiple Roles in the course, then show a drop down menu for switching.
    if (!$table->is_downloading($download, $exportfilename)) {
        if (count($rolenames) > 1) {
            echo '<div class="rolesform">
        <label for="rolesform_jump">' . get_string('currentrole', 'role') . '&nbsp;</label>';
            echo $OUTPUT->single_select($rolenamesurl, 'roleid', $rolenames, $roleid, null, 'rolesform');
            echo '</div>';

        } else if (count($rolenames) == 1) {
            // When all users with the same role - print its name.
            echo '<div class="rolesform">';
            echo get_string('role') . get_string('labelsep', 'langconfig');
            $rolename = reset($rolenames);
            echo $rolename . '</div>';
        }

        // Select ejsapp pulldown menu.
        $select = new single_select($baseurl, 'ejsappid', $ejsappnames, $ejsappid, null, 'formatmenu');
        $select->set_label(get_string('ejsapp_activity_selection', 'ejsapp'));
        $remlabslistcell = new html_table_cell();
        $remlabslistcell->attributes['class'] = 'right';
        $remlabslistcell->text = $OUTPUT->render($select);
        $controlstable->data[0]->cells[] = $remlabslistcell;

        echo html_writer::table($controlstable);

        if ($roleid > 0) {
            $a = new stdClass();
            $a->number = $totalcount;
            $a->role = $rolenames[$roleid];
            $heading = format_string(get_string('xuserswiththerole', 'role', $a));

            if ($currentgroup and $group) {
                $a->group = $group->name;
                $heading .= ' ' . format_string(get_string('ingroup', 'role', $a));
            }

            if ($accesssince) {
                $a->timeperiod = $timeoptions[$accesssince];
                $heading .= ' ' . format_string(get_string('inactiveformorethan', 'role', $a));
            }

            $heading .= ": $a->number";
            if (user_can_assign($context, $roleid)) {
                $heading .= ' <a href="' . $CFG->wwwroot . '/' . $CFG->admin . '/roles/assign.php?roleid=' . $roleid .
                    '&amp;contextid=' . $context->id . '">';
                $heading .= '<img src="' . $OUTPUT->pix_url('i/edit') . '" class="icon" alt="" /></a>';
            }
            echo $OUTPUT->heading($heading, 3);
        } else {
            if ($course->id != SITEID && has_capability('moodle/course:enrolreview', $context)) {
                $editlink = $OUTPUT->action_icon(new moodle_url('/enrol/users.php', array('id' => $course->id)),
                    new pix_icon('i/edit', get_string('edit')));
            } else {
                $editlink = '';
            }
            if ($course->id == SITEID and $roleid < 0) {
                $strallparticipants = get_string('allsiteusers', 'role');
            } else {
                $strallparticipants = get_string('allparticipants');
            }
            if ($matchcount < $totalcount) {
                echo $OUTPUT->heading($strallparticipants . get_string('labelsep', 'langconfig') .
                    $matchcount . '/' . $totalcount . $editlink, 3);
            } else {
                echo $OUTPUT->heading($strallparticipants . get_string('labelsep', 'langconfig') .
                    $matchcount . $editlink, 3);
            }
        }
    }

    $countrysort = (strpos($sort, 'country') !== false);

    if ($userlist) {
        $usersprinted = array();
        foreach ($userlist as $user) {
            if (in_array($user->id, $usersprinted)) { // Prevent duplicates by r.hidden - MDL-13935.
                continue;
            }
            $usersprinted[] = $user->id; // Add new user to the array of users printed.

            context_helper::preload_from_record($user);

            if ($user->lastaccess) {
                $lastaccess = format_time(time() - $user->lastaccess, $datestring);
            } else {
                $lastaccess = $strnever;
            }

            if (empty($user->country)) {
                $country = '';
            } else {
                if ($countrysort) {
                    $country = '('.$user->country.') '.$countries[$user->country];
                } else {
                    $country = $countries[$user->country];
                }
            }

            $usercontext = context_user::instance($user->id);

            if (!isset($user->firstnamephonetic)) {
                $user->firstnamephonetic = $user->firstname;
            }
            if (!isset($user->lastnamephonetic)) {
                $user->lastnamephonetic = $user->lastname;
            }
            if (!isset($user->middlename)) {
                $user->middlename = '';
            }
            if (!isset($user->alternatename)) {
                $user->alternatename = '';
            }

            if ($piclink = ($USER->id == $user->id || has_capability('moodle/user:viewdetails', $context) ||
                has_capability('moodle/user:viewdetails', $usercontext))) {
                $profilelink = '<strong><a href="'.$CFG->wwwroot.'/user/view.php?id='.$user->id.'&amp;course='.
                    $course->id.'">'.fullname($user).'</a></strong>';
            } else {
                $profilelink = '<strong>'.fullname($user).'</strong>';
            }

            $data = array ($OUTPUT->user_picture($user, array('size' => 35, 'courseid' => $course->id)), $profilelink);

            if (!isset($hiddenfields['city'])) {
                $data[] = $user->city;
            }
            if (!isset($hiddenfields['country'])) {
                $data[] = $country;
            }
            if (!isset($hiddenfields['lastaccess'])) {
                $data[] = $lastaccess;
            }

            if (isset($userlistextra) && isset($userlistextra[$user->id])) {
                $ras = $userlistextra[$user->id]['ra'];
                $rastring = '';
                foreach ($ras as $key => $ra) {
                    $rolename = $allrolenames[$ra['roleid']];
                    if ($ra['ctxlevel'] == CONTEXT_COURSECAT) {
                        $rastring .= $rolename. ' @ ' . '<a href="' . $CFG->wwwroot . '/course/category.php?id=' .
                            $ra['ctxinstanceid'] . '">' . s($ra['ccname']) . '</a>';
                    } else if ($ra['ctxlevel'] == CONTEXT_SYSTEM) {
                        $rastring .= $rolename. ' - ' . get_string('globalrole', 'role');
                    } else {
                        $rastring .= $rolename;
                    }
                }
                $data[] = $rastring;
                if ($groupmode != 0) {
                    // Htmlescape with s() and implode the array.
                    $data[] = implode(', ', array_map('s', $userlistextra[$user->id]['group']));
                    $data[] = implode(', ', array_map('s', $userlistextra[$user->id]['gping']));
                }
            }

            $personalvarsinfo = personalize_vars($ejsapp, $user, false);
            for ($i = 0; $i < count($personalvarsinfo->name); $i++) {
                $data[] = $personalvarsinfo->name[$i];
                $data[] = $personalvarsinfo->value[$i];
            }

            $table->add_data($data);

        } // End of foreach ($userlist as $user).
    } // End of if ($userlist).

    $table->finish_output();

    if (!$table->is_downloading($download, $exportfilename)) {
        if (has_capability('moodle/site:viewparticipants', $context) && $totalcount > ($perpage * 3)) {
            echo '<form action="collaborative_index.php" class="searchform"><div><input type="hidden" name="id" value="' .
                $course->id . '" />' . get_string('search') . ':&nbsp;' . "\n";
            echo '<input type="text" name="search" value="' . s($search) . '" />&nbsp;<input type="submit" value="' .
                get_string('search') . '" /></div></form>' . "\n";
        }

        $perpageurl = clone($baseurl);
        $perpageurl->remove_params('perpage');
        if ($perpage == SHOW_ALL_PAGE_SIZE) {
            $perpageurl->param('perpage', DEFAULT_PAGE_SIZE);
            echo $OUTPUT->container(html_writer::link($perpageurl, get_string('showperpage', '',
                DEFAULT_PAGE_SIZE)), array(), 'showall');
        } else if ($matchcount > 0 && $perpage < $matchcount) {
            $perpageurl->param('perpage', SHOW_ALL_PAGE_SIZE);
            echo $OUTPUT->container(html_writer::link($perpageurl, get_string('showall', '',
                $matchcount)), array(), 'showall');
        }
    }

    if (!$table->is_downloading()) {
        echo $OUTPUT->footer();
    }

    if ($userlist) {
        $userlist->close();
    }
} else { // If there are no ejsapp activities with personalized variables.
    echo $OUTPUT->header();
    echo $OUTPUT->heading(get_string('no_ejsapps', 'ejsapp'));
    echo $OUTPUT->footer();
}