3 namespace Drupal\dblog\Controller;
5 use Drupal\Component\Utility\Html;
6 use Drupal\Component\Utility\Unicode;
7 use Drupal\Component\Utility\Xss;
8 use Drupal\Core\Controller\ControllerBase;
9 use Drupal\Core\Database\Connection;
10 use Drupal\Core\Datetime\DateFormatterInterface;
11 use Drupal\Core\Extension\ModuleHandlerInterface;
12 use Drupal\Core\Form\FormBuilderInterface;
13 use Drupal\Core\Logger\RfcLogLevel;
15 use Drupal\user\Entity\User;
16 use Symfony\Component\DependencyInjection\ContainerInterface;
19 * Returns responses for dblog routes.
21 class DbLogController extends ControllerBase {
24 * The database service.
26 * @var \Drupal\Core\Database\Connection
31 * The module handler service.
33 * @var \Drupal\Core\Extension\ModuleHandlerInterface
35 protected $moduleHandler;
38 * The date formatter service.
40 * @var \Drupal\Core\Datetime\DateFormatterInterface
42 protected $dateFormatter;
45 * The form builder service.
47 * @var \Drupal\Core\Form\FormBuilderInterface
49 protected $formBuilder;
54 * @var \Drupal\user\UserStorageInterface
56 protected $userStorage;
61 public static function create(ContainerInterface $container) {
63 $container->get('database'),
64 $container->get('module_handler'),
65 $container->get('date.formatter'),
66 $container->get('form_builder')
71 * Constructs a DbLogController object.
73 * @param \Drupal\Core\Database\Connection $database
74 * A database connection.
75 * @param \Drupal\Core\Extension\ModuleHandlerInterface $module_handler
77 * @param \Drupal\Core\Datetime\DateFormatterInterface $date_formatter
78 * The date formatter service.
79 * @param \Drupal\Core\Form\FormBuilderInterface $form_builder
80 * The form builder service.
82 public function __construct(Connection $database, ModuleHandlerInterface $module_handler, DateFormatterInterface $date_formatter, FormBuilderInterface $form_builder) {
83 $this->database = $database;
84 $this->moduleHandler = $module_handler;
85 $this->dateFormatter = $date_formatter;
86 $this->formBuilder = $form_builder;
87 $this->userStorage = $this->entityManager()->getStorage('user');
91 * Gets an array of log level classes.
94 * An array of log level classes.
96 public static function getLogLevelClassMap() {
98 RfcLogLevel::DEBUG => 'dblog-debug',
99 RfcLogLevel::INFO => 'dblog-info',
100 RfcLogLevel::NOTICE => 'dblog-notice',
101 RfcLogLevel::WARNING => 'dblog-warning',
102 RfcLogLevel::ERROR => 'dblog-error',
103 RfcLogLevel::CRITICAL => 'dblog-critical',
104 RfcLogLevel::ALERT => 'dblog-alert',
105 RfcLogLevel::EMERGENCY => 'dblog-emergency',
110 * Displays a listing of database log messages.
112 * Messages are truncated at 56 chars.
113 * Full-length messages can be viewed on the message details page.
116 * A render array as expected by drupal_render().
118 * @see Drupal\dblog\Form\DblogClearLogConfirmForm
119 * @see Drupal\dblog\Controller\DbLogController::eventDetails()
121 public function overview() {
123 $filter = $this->buildFilterQuery();
126 $classes = static::getLogLevelClassMap();
128 $this->moduleHandler->loadInclude('dblog', 'admin.inc');
130 $build['dblog_filter_form'] = $this->formBuilder->getForm('Drupal\dblog\Form\DblogFilterForm');
136 'data' => $this->t('Type'),
138 'class' => [RESPONSIVE_PRIORITY_MEDIUM]],
140 'data' => $this->t('Date'),
143 'class' => [RESPONSIVE_PRIORITY_LOW]],
146 'data' => $this->t('User'),
147 'field' => 'ufd.name',
148 'class' => [RESPONSIVE_PRIORITY_MEDIUM]],
150 'data' => $this->t('Operations'),
151 'class' => [RESPONSIVE_PRIORITY_LOW]],
154 $query = $this->database->select('watchdog', 'w')
155 ->extend('\Drupal\Core\Database\Query\PagerSelectExtender')
156 ->extend('\Drupal\Core\Database\Query\TableSortExtender');
157 $query->fields('w', [
167 $query->leftJoin('users_field_data', 'ufd', 'w.uid = ufd.uid');
169 if (!empty($filter['where'])) {
170 $query->where($filter['where'], $filter['args']);
174 ->orderByHeader($header)
177 foreach ($result as $dblog) {
178 $message = $this->formatMessage($dblog);
179 if ($message && isset($dblog->wid)) {
180 $title = Unicode::truncate(Html::decodeEntities(strip_tags($message)), 256, TRUE, TRUE);
181 $log_text = Unicode::truncate($title, 56, TRUE, TRUE);
182 // The link generator will escape any unsafe HTML entities in the final
184 $message = $this->l($log_text, new Url('dblog.event', ['event_id' => $dblog->wid], [
186 // Provide a title for the link for useful hover hints. The
187 // Attribute object will escape any unsafe HTML entities in the
194 '#theme' => 'username',
195 '#account' => $this->userStorage->load($dblog->uid),
200 ['class' => ['icon']],
201 $this->t($dblog->type),
202 $this->dateFormatter->format($dblog->timestamp, 'short'),
204 ['data' => $username],
205 ['data' => ['#markup' => $dblog->link]],
207 // Attributes for table row.
208 'class' => [Html::getClass('dblog-' . $dblog->type), $classes[$dblog->severity]],
212 $build['dblog_table'] = [
214 '#header' => $header,
216 '#attributes' => ['id' => 'admin-dblog', 'class' => ['admin-dblog']],
217 '#empty' => $this->t('No log messages available.'),
219 'library' => ['dblog/drupal.dblog'],
222 $build['dblog_pager'] = ['#type' => 'pager'];
229 * Displays details about a specific database log message.
231 * @param int $event_id
232 * Unique ID of the database log message.
235 * If the ID is located in the Database Logging table, a build array in the
236 * format expected by drupal_render();
238 public function eventDetails($event_id) {
240 if ($dblog = $this->database->query('SELECT w.*, u.uid FROM {watchdog} w LEFT JOIN {users} u ON u.uid = w.uid WHERE w.wid = :id', [':id' => $event_id])->fetchObject()) {
241 $severity = RfcLogLevel::getLevels();
242 $message = $this->formatMessage($dblog);
244 '#theme' => 'username',
245 '#account' => $dblog->uid ? $this->userStorage->load($dblog->uid) : User::getAnonymousUser(),
249 ['data' => $this->t('Type'), 'header' => TRUE],
250 $this->t($dblog->type),
253 ['data' => $this->t('Date'), 'header' => TRUE],
254 $this->dateFormatter->format($dblog->timestamp, 'long'),
257 ['data' => $this->t('User'), 'header' => TRUE],
258 ['data' => $username],
261 ['data' => $this->t('Location'), 'header' => TRUE],
262 $this->l($dblog->location, $dblog->location ? Url::fromUri($dblog->location) : Url::fromRoute('<none>')),
265 ['data' => $this->t('Referrer'), 'header' => TRUE],
266 $this->l($dblog->referer, $dblog->referer ? Url::fromUri($dblog->referer) : Url::fromRoute('<none>')),
269 ['data' => $this->t('Message'), 'header' => TRUE],
273 ['data' => $this->t('Severity'), 'header' => TRUE],
274 $severity[$dblog->severity],
277 ['data' => $this->t('Hostname'), 'header' => TRUE],
281 ['data' => $this->t('Operations'), 'header' => TRUE],
282 ['data' => ['#markup' => $dblog->link]],
285 $build['dblog_table'] = [
288 '#attributes' => ['class' => ['dblog-event']],
290 'library' => ['dblog/drupal.dblog'],
299 * Builds a query for database log administration filters based on session.
302 * An associative array with keys 'where' and 'args'.
304 protected function buildFilterQuery() {
305 if (empty($_SESSION['dblog_overview_filter'])) {
309 $this->moduleHandler->loadInclude('dblog', 'admin.inc');
311 $filters = dblog_filters();
315 foreach ($_SESSION['dblog_overview_filter'] as $key => $filter) {
317 foreach ($filter as $value) {
318 $filter_where[] = $filters[$key]['where'];
321 if (!empty($filter_where)) {
322 $where[] = '(' . implode(' OR ', $filter_where) . ')';
325 $where = !empty($where) ? implode(' AND ', $where) : '';
334 * Formats a database log message.
337 * The record from the watchdog table. The object properties are: wid, uid,
338 * severity, type, timestamp, message, variables, link, name.
340 * @return string|\Drupal\Core\StringTranslation\TranslatableMarkup|false
341 * The formatted log message or FALSE if the message or variables properties
344 public function formatMessage($row) {
345 // Check for required properties.
346 if (isset($row->message, $row->variables)) {
347 $variables = @unserialize($row->variables);
348 // Messages without variables or user specified text.
349 if ($variables === NULL) {
350 $message = Xss::filterAdmin($row->message);
352 elseif (!is_array($variables)) {
353 $message = $this->t('Log data is corrupted and cannot be unserialized: @message', ['@message' => Xss::filterAdmin($row->message)]);
355 // Message to translate with injected variables.
357 $message = $this->t(Xss::filterAdmin($row->message), $variables);
367 * Shows the most frequent log messages of a given event type.
369 * Messages are not truncated on this page because events detailed herein do
370 * not have links to a detailed view.
372 * @param string $type
373 * Type of database log events to display (e.g., 'search').
376 * A build array in the format expected by drupal_render().
378 public function topLogMessages($type) {
380 ['data' => $this->t('Count'), 'field' => 'count', 'sort' => 'desc'],
381 ['data' => $this->t('Message'), 'field' => 'message'],
384 $count_query = $this->database->select('watchdog');
385 $count_query->addExpression('COUNT(DISTINCT(message))');
386 $count_query->condition('type', $type);
388 $query = $this->database->select('watchdog', 'w')
389 ->extend('\Drupal\Core\Database\Query\PagerSelectExtender')
390 ->extend('\Drupal\Core\Database\Query\TableSortExtender');
391 $query->addExpression('COUNT(wid)', 'count');
393 ->fields('w', ['message', 'variables'])
394 ->condition('w.type', $type)
396 ->groupBy('variables')
398 ->orderByHeader($header);
399 $query->setCountQuery($count_query);
400 $result = $query->execute();
403 foreach ($result as $dblog) {
404 if ($message = $this->formatMessage($dblog)) {
405 $rows[] = [$dblog->count, $message];
409 $build['dblog_top_table'] = [
411 '#header' => $header,
413 '#empty' => $this->t('No log messages available.'),
415 'library' => ['dblog/drupal.dblog'],
418 $build['dblog_top_pager'] = ['#type' => 'pager'];