//$hierarche->get_school_items(); echo $OUTPUT->box(get_string('asignregistrartabdes', 'local_collegestructure')); if (is_siteadmin()) $sql = "SELECT * FROM {local_school}"; else $sql = " SELECT distinct(s.id),s.* FROM {local_school} s where id in(select schoolid from {local_school_permissions} where userid={$USER->id}) ORDER BY s.sortorder "; $schoolusers = $DB->get_records_sql($sql); $data = array(); if ($schoolusers) { foreach ($schoolusers as $schooluser) { $line = array(); $reg = array(); $line[] = $schooluser->fullname; $reg[] = $hierarche->get_allregisters($schooluser->id); $line[] = $reg[0]; $data[] = $line; } } else { $line = array(); $line[] = "No user is assigned till now"; $data[] = $line; } $table = new html_table(); if ($schoolusers) { $table->head = array( get_string('schoolname', 'local_collegestructure'), get_string('username', 'local_collegestructure')); } $table->size = array('40%', '40%', '20%');