function dblog_overview in Drupal 7
Same name and namespace in other branches
- 6 modules/dblog/dblog.admin.inc \dblog_overview()
Page callback: Displays a listing of database log messages.
Messages are truncated at 56 chars. Full-length messages can be viewed on the message details page.
See also
Related topics
1 string reference to 'dblog_overview'
- dblog_menu in modules/
dblog/ dblog.module - Implements hook_menu().
File
- modules/
dblog/ dblog.admin.inc, line 21 - Administrative page callbacks for the Database Logging module.
Code
function dblog_overview() {
$filter = dblog_build_filter_query();
$rows = array();
$classes = array(
WATCHDOG_DEBUG => 'dblog-debug',
WATCHDOG_INFO => 'dblog-info',
WATCHDOG_NOTICE => 'dblog-notice',
WATCHDOG_WARNING => 'dblog-warning',
WATCHDOG_ERROR => 'dblog-error',
WATCHDOG_CRITICAL => 'dblog-critical',
WATCHDOG_ALERT => 'dblog-alert',
WATCHDOG_EMERGENCY => 'dblog-emerg',
);
$build['dblog_filter_form'] = drupal_get_form('dblog_filter_form');
$build['dblog_clear_log_form'] = drupal_get_form('dblog_clear_log_form');
$header = array(
'',
// Icon column.
array(
'data' => t('Type'),
'field' => 'w.type',
),
array(
'data' => t('Date'),
'field' => 'w.wid',
'sort' => 'desc',
),
t('Message'),
array(
'data' => t('User'),
'field' => 'u.name',
),
array(
'data' => t('Operations'),
),
);
$query = db_select('watchdog', 'w')
->extend('PagerDefault')
->extend('TableSort');
$query
->leftJoin('users', 'u', 'w.uid = u.uid');
$query
->fields('w', array(
'wid',
'uid',
'severity',
'type',
'timestamp',
'message',
'variables',
'link',
))
->addField('u', 'name');
if (!empty($filter['where'])) {
$query
->where($filter['where'], $filter['args']);
}
$result = $query
->limit(50)
->orderByHeader($header)
->execute();
foreach ($result as $dblog) {
$rows[] = array(
'data' => array(
// Cells
array(
'class' => 'icon',
),
t($dblog->type),
format_date($dblog->timestamp, 'short'),
theme('dblog_message', array(
'event' => $dblog,
'link' => TRUE,
)),
theme('username', array(
'account' => $dblog,
)),
filter_xss($dblog->link),
),
// Attributes for tr
'class' => array(
drupal_html_class('dblog-' . $dblog->type),
$classes[$dblog->severity],
),
);
}
$build['dblog_table'] = array(
'#theme' => 'table',
'#header' => $header,
'#rows' => $rows,
'#attributes' => array(
'id' => 'admin-dblog',
),
'#empty' => t('No log messages available.'),
);
$build['dblog_pager'] = array(
'#theme' => 'pager',
);
return $build;
}