This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.
Logic Machine Forum › LogicMachine eco-system › Gateway v
How to export / print alerts

Threaded Mode
How to export / print alerts
gjniewenhuijse Offline
Senior Member
Posts: 449
Threads: 94
Joined: Jun 2015
Reputation: 6
#1
13.11.2019, 10:10
How to export or print all alerts given in the alerts tab?
Find
Reply
admin Offline
Administrator
Posts: 7758
Threads: 42
Joined: Jun 2015
Reputation: 447
#2
14.11.2019, 09:47
Via .lp file:
Code:
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Alerts</title>
  <link rel="stylesheet" href="/apps/css/bootstrap.css">
</head>
<body>
<table class="table">
  <tr>
    <th>Date/time</th>
    <th>Script name</th>
    <th>Message</th>
  </tr>
<?
require('apps')
items = db:getall('SELECT * FROM alerts ORDER BY id DESC')
for _, item in ipairs(items) do
  datetime = os.date('%c', item.alerttime)
?>
  <tr>
    <td><?=escape(datetime)?></td>
    <td><?=escape(item.scriptname)?></td>
    <td><?=escape(item.alert)?></td>
    <td></td>
  </tr>
<? end ?>
</table>
</body>
</html>
Find
Reply


Forum Jump: