1<?php
2
3require_once('../../config.php');
4require_once($CFG->libdir.'/adminlib.php');
5
6$sort = optional_param('sort', 'fullname', PARAM_ALPHA);
7$dir  = optional_param('dir', 'asc', PARAM_ALPHA);
8
9admin_externalpage_setup('userbulk');
10
11$return = $CFG->wwwroot.'/'.$CFG->admin.'/user/user_bulk.php';
12
13if (empty($SESSION->bulk_users)) {
14    redirect($return);
15}
16
17$users = $SESSION->bulk_users;
18$usertotal = get_users(false);
19$usercount = count($users);
20
21$strnever = get_string('never');
22
23echo $OUTPUT->header();
24
25$countries = get_string_manager()->get_list_of_countries(true);
26
27$userfieldsapi = \core_user\fields::for_name();
28$namefields = $userfieldsapi->get_sql('', false, '', '', false)->selects;
29foreach ($users as $key => $id) {
30    $user = $DB->get_record('user', array('id'=>$id), 'id, ' . $namefields . ', username, email, country, lastaccess, city');
31    $user->fullname = fullname($user, true);
32    $user->country = @$countries[$user->country];
33    unset($user->firstname);
34    unset($user->lastname);
35    $users[$key] = $user;
36}
37unset($countries);
38
39// Need to sort by date
40function sort_compare($a, $b) {
41    global $sort, $dir;
42    if($sort == 'lastaccess') {
43        $rez = $b->lastaccess - $a->lastaccess;
44    } else {
45        $rez = strcasecmp(@$a->$sort, @$b->$sort);
46    }
47    return $dir == 'desc' ? -$rez : $rez;
48}
49usort($users, 'sort_compare');
50
51$table = new html_table();
52$table->width = "95%";
53$columns = array('fullname', /*'username', */'email', 'city', 'country', 'lastaccess');
54foreach ($columns as $column) {
55    $strtitle = get_string($column);
56    if ($sort != $column) {
57        $columnicon = '';
58        $columndir = 'asc';
59    } else {
60        $columndir = $dir == 'asc' ? 'desc' : 'asc';
61        $icon = 't/down';
62        $iconstr = $columndir;
63        if ($dir != 'asc') {
64            $icon = 't/up';
65        }
66        $columnicon = ' ' . $OUTPUT->pix_icon($icon, get_string($iconstr));
67    }
68    $table->head[] = '<a href="user_bulk_display.php?sort='.$column.'&amp;dir='.$columndir.'">'.$strtitle.'</a>'.$columnicon;
69    $table->align[] = 'left';
70}
71
72foreach($users as $user) {
73    $table->data[] = array (
74        '<a href="'.$CFG->wwwroot.'/user/view.php?id='.$user->id.'&amp;course='.SITEID.'">'.$user->fullname.'</a>',
75//        $user->username,
76        s($user->email),
77        $user->city,
78        $user->country,
79        $user->lastaccess ? format_time(time() - $user->lastaccess) : $strnever
80    );
81}
82
83echo $OUTPUT->heading("$usercount / $usertotal ".get_string('users'));
84echo html_writer::table($table);
85
86echo $OUTPUT->continue_button($return);
87
88echo $OUTPUT->footer();
89