diff options
Diffstat (limited to 'classes/pref/system.php')
| -rw-r--r-- | classes/pref/system.php | 174 |
1 files changed, 105 insertions, 69 deletions
diff --git a/classes/pref/system.php b/classes/pref/system.php index 89052c6e3..33a567df5 100644 --- a/classes/pref/system.php +++ b/classes/pref/system.php @@ -2,6 +2,8 @@ class Pref_System extends Handler_Protected { + private $log_page_limit = 15; + function before($method) { if (parent::before($method)) { if ($_SESSION["access_level"] < 10) { @@ -23,101 +25,135 @@ class Pref_System extends Handler_Protected { $this->pdo->query("DELETE FROM ttrss_error_log"); } - function index() { + private function log_viewer(int $page, int $severity) { + $errno_values = []; - $severity = isset($_REQUEST["severity"]) ? (int) clean($_REQUEST["severity"]) : E_USER_WARNING; + switch ($severity) { + case E_USER_ERROR: + $errno_values = [ E_ERROR, E_USER_ERROR, E_PARSE ]; + break; + case E_USER_WARNING: + $errno_values = [ E_ERROR, E_USER_ERROR, E_PARSE, E_WARNING, E_USER_WARNING, E_DEPRECATED, E_USER_DEPRECATED ]; + break; + } - print "<div dojoType='dijit.layout.AccordionContainer' region='center'>"; - print "<div dojoType='dijit.layout.AccordionPane' style='padding : 0' - title='<i class=\"material-icons\">report</i> ".__('Event Log')."'>"; + if (count($errno_values) > 0) { + $errno_qmarks = arr_qmarks($errno_values); + $errno_filter_qpart = "errno IN ($errno_qmarks)"; + } else { + $errno_filter_qpart = "true"; + } - if (LOG_DESTINATION == "sql") { + $limit = $this->log_page_limit; + $offset = $limit * $page; - print "<div dojoType='dijit.layout.BorderContainer' gutters='false'>"; + $sth = $this->pdo->prepare("SELECT + COUNT(id) AS total_pages + FROM + ttrss_error_log + WHERE + $errno_filter_qpart"); - print "<div region='top' dojoType='fox.Toolbar'>"; + $sth->execute($errno_values); - print "<button dojoType='dijit.form.Button' - onclick='Helpers.updateEventLog()'>".__('Refresh')."</button>"; + if ($res = $sth->fetch()) { + $total_pages = (int)($res["total_pages"] / $limit); + } else { + $total_pages = 0; + } - print "<button dojoType='dijit.form.Button' - onclick='Helpers.clearEventLog()'>".__('Clear')."</button>"; + print "<div dojoType='dijit.layout.BorderContainer' gutters='false'>"; - print "<div class='pull-right'>"; + print "<div region='top' dojoType='fox.Toolbar'>"; - print __("Severity:") . " "; - print_select_hash("severity", $severity, - [ - E_USER_ERROR => __("Errors"), - E_USER_WARNING => __("Warnings"), - E_USER_NOTICE => __("Everything") - ], 'dojoType="fox.form.Select" onchange="Helpers.updateEventLog()"'); + print "<button dojoType='dijit.form.Button' + onclick='Helpers.EventLog.refresh()'>".__('Refresh')."</button>"; - print "</div>"; # pull-right + print "<button dojoType='dijit.form.Button' + onclick='Helpers.EventLog.prevPage()'>".__('<<')."</button>"; - print "</div>"; # toolbar + print "<button dojoType='dijit.form.Button' disabled>".T_sprintf('Page %d of %d', $page+1, $total_pages+1)."</button>"; - print '<div style="padding : 0px" dojoType="dijit.layout.ContentPane" region="center">'; + $next_page_disabled = $page >= $total_pages ? "disabled" : ""; - print "<table width='100%' cellspacing='10' class='prefErrorLog'>"; + print "<button dojoType='dijit.form.Button' $next_page_disabled + onclick='Helpers.EventLog.nextPage()'>".__('>>')."</button>"; - print "<tr class='title'> - <td width='5%'>".__("Error")."</td> - <td>".__("Filename")."</td> - <td>".__("Message")."</td> - <td width='5%'>".__("User")."</td> - <td width='5%'>".__("Date")."</td> - </tr>"; + print "<button dojoType='dijit.form.Button' + onclick='Helpers.EventLog.clear()'>".__('Clear')."</button>"; - $errno_values = []; + print "<div class='pull-right'>"; - switch ($severity) { - case E_USER_ERROR: - $errno_values = [ E_ERROR, E_USER_ERROR, E_PARSE ]; - break; - case E_USER_WARNING: - $errno_values = [ E_ERROR, E_USER_ERROR, E_PARSE, E_WARNING, E_USER_WARNING, E_DEPRECATED, E_USER_DEPRECATED ]; - break; - } + print __("Severity:") . " "; + print_select_hash("severity", $severity, + [ + E_USER_ERROR => __("Errors"), + E_USER_WARNING => __("Warnings"), + E_USER_NOTICE => __("Everything") + ], 'dojoType="fox.form.Select" onchange="Helpers.EventLog.refresh()"'); - if (count($errno_values) > 0) { - $errno_qmarks = arr_qmarks($errno_values); - $errno_filter_qpart = "errno IN ($errno_qmarks)"; - } else { - $errno_filter_qpart = "true"; - } + print "</div>"; # pull-right + + print "</div>"; # toolbar - $sth = $this->pdo->prepare("SELECT - errno, errstr, filename, lineno, created_at, login, context - FROM - ttrss_error_log LEFT JOIN ttrss_users ON (owner_uid = ttrss_users.id) - WHERE - $errno_filter_qpart - ORDER BY - ttrss_error_log.id DESC - LIMIT 100"); + print '<div style="padding : 0px" dojoType="dijit.layout.ContentPane" region="center">'; - $sth->execute($errno_values); + print "<table width='100%' class='event-log'>"; - while ($line = $sth->fetch()) { - print "<tr>"; + print "<tr class='title'> + <td width='5%'>".__("Error")."</td> + <td>".__("Filename")."</td> + <td>".__("Message")."</td> + <td width='5%'>".__("User")."</td> + <td width='5%'>".__("Date")."</td> + </tr>"; - foreach ($line as $k => $v) { - $line[$k] = htmlspecialchars($v); - } + $sth = $this->pdo->prepare("SELECT + errno, errstr, filename, lineno, created_at, login, context + FROM + ttrss_error_log LEFT JOIN ttrss_users ON (owner_uid = ttrss_users.id) + WHERE + $errno_filter_qpart + ORDER BY + ttrss_error_log.id DESC + LIMIT $limit OFFSET $offset"); - print "<td class='errno'>" . Logger::$errornames[$line["errno"]] . " (" . $line["errno"] . ")</td>"; - print "<td class='filename'>" . $line["filename"] . ":" . $line["lineno"] . "</td>"; - print "<td class='errstr'>" . $line["errstr"] . "<hr/>" . nl2br($line["context"]) . "</td>"; - print "<td class='login'>" . $line["login"] . "</td>"; + $sth->execute($errno_values); - print "<td class='timestamp'>" . - TimeHelper::make_local_datetime($line["created_at"], false) . "</td>"; + while ($line = $sth->fetch()) { + print "<tr>"; - print "</tr>"; + foreach ($line as $k => $v) { + $line[$k] = htmlspecialchars($v); } - print "</table>"; + print "<td class='errno'>" . Logger::$errornames[$line["errno"]] . " (" . $line["errno"] . ")</td>"; + print "<td class='filename'>" . $line["filename"] . ":" . $line["lineno"] . "</td>"; + print "<td class='errstr'>" . $line["errstr"] . "\n" . $line["context"] . "</td>"; + print "<td class='login'>" . $line["login"] . "</td>"; + + print "<td class='timestamp'>" . + TimeHelper::make_local_datetime($line["created_at"], false) . "</td>"; + + print "</tr>"; + } + + print "</table>"; + } + + function index() { + + $severity = (int) ($_REQUEST["severity"] ?? E_USER_WARNING); + $page = (int) ($_REQUEST["page"] ?? 0); + + print "<div dojoType='dijit.layout.AccordionContainer' region='center'>"; + print "<div dojoType='dijit.layout.AccordionPane' style='padding : 0' + title='<i class=\"material-icons\">report</i> ".__('Event Log')."'>"; + + if (LOG_DESTINATION == "sql") { + + $this->log_viewer($page, $severity); + } else { print_notice("Please set LOG_DESTINATION to 'sql' in config.php to enable database logging."); } |