3 require_once('../../config.php');
4 require_once($CFG->libdir
.'/adminlib.php');
6 $sort = optional_param('sort', 'fullname', PARAM_ALPHA
);
7 $dir = optional_param('dir', 'asc', PARAM_ALPHA
);
9 admin_externalpage_setup('userbulk');
11 $return = $CFG->wwwroot
.'/'.$CFG->admin
.'/user/user_bulk.php';
13 if (empty($SESSION->bulk_users
)) {
17 $users = $SESSION->bulk_users
;
18 $usertotal = get_users(false);
19 $usercount = count($users);
21 $strnever = get_string('never');
23 $PAGE->set_primary_active_tab('siteadminnode');
24 $PAGE->set_secondary_active_tab('users');
26 echo $OUTPUT->header();
28 $countries = get_string_manager()->get_list_of_countries(true);
30 $userfieldsapi = \core_user\fields
::for_name();
31 $namefields = $userfieldsapi->get_sql('', false, '', '', false)->selects
;
32 foreach ($users as $key => $id) {
33 $user = $DB->get_record('user', array('id'=>$id), 'id, ' . $namefields . ', username, email, country, lastaccess, city');
34 $user->fullname
= fullname($user, true);
35 $user->country
= @$countries[$user->country
];
36 unset($user->firstname
);
37 unset($user->lastname
);
42 // Need to sort by date
43 function sort_compare($a, $b) {
45 if($sort == 'lastaccess') {
46 $rez = $b->lastaccess
- $a->lastaccess
;
48 $rez = strcasecmp(@$a->$sort, @$b->$sort);
50 return $dir == 'desc' ?
-$rez : $rez;
52 usort($users, 'sort_compare');
54 $table = new html_table();
55 $table->width
= "95%";
56 $columns = array('fullname', /*'username', */'email', 'city', 'country', 'lastaccess');
57 foreach ($columns as $column) {
58 $strtitle = get_string($column);
59 if ($sort != $column) {
63 $columndir = $dir == 'asc' ?
'desc' : 'asc';
65 $iconstr = $columndir;
69 $columnicon = ' ' . $OUTPUT->pix_icon($icon, get_string($iconstr));
71 $table->head
[] = '<a href="user_bulk_display.php?sort='.$column.'&dir='.$columndir.'">'.$strtitle.'</a>'.$columnicon;
72 $table->align
[] = 'left';
75 foreach($users as $user) {
76 $table->data
[] = array (
77 '<a href="'.$CFG->wwwroot
.'/user/view.php?id='.$user->id
.'&course='.SITEID
.'">'.$user->fullname
.'</a>',
82 $user->lastaccess ?
format_time(time() - $user->lastaccess
) : $strnever
86 echo $OUTPUT->heading("$usercount / $usertotal ".get_string('users'));
87 echo html_writer
::table($table);
89 echo $OUTPUT->continue_button($return);
91 echo $OUTPUT->footer();