. /** * Config changes report * * @package report * @subpackage configlog * @copyright 2009 Petr Skoda * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ require(__DIR__.'/../../config.php'); require_once($CFG->libdir.'/adminlib.php'); // page parameters $page = optional_param('page', 0, PARAM_INT); $perpage = optional_param('perpage', 30, PARAM_INT); // how many per page $sort = optional_param('sort', 'timemodified', PARAM_ALPHA); $dir = optional_param('dir', 'DESC', PARAM_ALPHA); admin_externalpage_setup('reportconfiglog', '', null, '', array('pagelayout'=>'report')); echo $OUTPUT->header(); echo $OUTPUT->heading(get_string('configlog', 'report_configlog')); $changescount = $DB->count_records('config_log'); $columns = array('firstname' => get_string('firstname'), 'lastname' => get_string('lastname'), 'timemodified' => get_string('timemodified', 'report_configlog'), 'plugin' => get_string('plugin', 'report_configlog'), 'name' => get_string('setting', 'report_configlog'), 'value' => get_string('value', 'report_configlog'), 'oldvalue' => get_string('oldvalue', 'report_configlog'), ); $hcolumns = array(); if (!isset($columns[$sort])) { $sort = 'lastname'; } foreach ($columns as $column=>$strcolumn) { if ($sort != $column) { $columnicon = ''; if ($column == 'lastaccess') { $columndir = 'DESC'; } else { $columndir = 'ASC'; } } else { $columndir = $dir == 'ASC' ? 'DESC':'ASC'; if ($column == 'lastaccess') { $columnicon = $dir == 'ASC' ? 'up':'down'; } else { $columnicon = $dir == 'ASC' ? 'down':'up'; } $columnicon = $OUTPUT->pix_icon('t/' . $columnicon, ''); } $hcolumns[$column] = "".$strcolumn."$columnicon"; } $baseurl = new moodle_url('index.php', array('sort' => $sort, 'dir' => $dir, 'perpage' => $perpage)); echo $OUTPUT->paging_bar($changescount, $page, $perpage, $baseurl); $override = new stdClass(); $override->firstname = 'firstname'; $override->lastname = 'lastname'; $fullnamelanguage = get_string('fullnamedisplay', '', $override); if (($CFG->fullnamedisplay == 'firstname lastname') or ($CFG->fullnamedisplay == 'firstname') or ($CFG->fullnamedisplay == 'language' and $fullnamelanguage == 'firstname lastname' )) { $fullnamedisplay = $hcolumns['firstname'].' / '.$hcolumns['lastname']; } else { // ($CFG->fullnamedisplay == 'language' and $fullnamelanguage == 'lastname firstname') $fullnamedisplay = $hcolumns['lastname'].' / '.$hcolumns['firstname']; } $table = new html_table(); $table->head = array($hcolumns['timemodified'], $fullnamedisplay, $hcolumns['plugin'], $hcolumns['name'], $hcolumns['value'], $hcolumns['oldvalue']); $table->colclasses = array('leftalign date', 'leftalign name', 'leftalign plugin', 'leftalign setting', 'leftalign newvalue', 'leftalign originalvalue'); $table->id = 'configchanges'; $table->attributes['class'] = 'admintable generaltable'; $table->data = array(); if ($sort == 'firstname' or $sort == 'lastname') { $orderby = "u.$sort $dir"; } else if ($sort == 'value' or $sort == 'oldvalue') { // cross-db text-compatible sorting. $orderby = $DB->sql_order_by_text("cl.$sort", 255) . ' ' . $dir; } else { $orderby = "cl.$sort $dir"; } $ufields = user_picture::fields('u'); $sql = "SELECT $ufields, cl.timemodified, cl.plugin, cl.name, cl.value, cl.oldvalue FROM {config_log} cl JOIN {user} u ON u.id = cl.userid ORDER BY $orderby"; $rs = $DB->get_recordset_sql($sql, array(), $page*$perpage, $perpage); foreach ($rs as $log) { $row = array(); $row[] = userdate($log->timemodified); $row[] = fullname($log); if (is_null($log->plugin)) { $row[] = 'core'; } else { $row[] = $log->plugin; } $row[] = $log->name; $row[] = s($log->value); $row[] = s($log->oldvalue); $table->data[] = $row; } $rs->close(); echo html_writer::table($table); echo $OUTPUT->footer();