From 81397bfd9fa54c60a8568812fc0ad99802a4e360 Mon Sep 17 00:00:00 2001
From: Kristian Lyngstol <kristian@bohemians.org>
Date: Wed, 18 May 2016 18:34:28 +0200
Subject: Add basic oplog

It still needs to be integrated with switches/info box, but this is a good
start.

Shows the last 5 log messages in an overlay on the map, with the rest
visible in an oplog tab.

Fixes #20
---
 web/api/read/oplog | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100755 web/api/read/oplog

(limited to 'web/api/read')

diff --git a/web/api/read/oplog b/web/api/read/oplog
new file mode 100755
index 0000000..d56890a
--- /dev/null
+++ b/web/api/read/oplog
@@ -0,0 +1,22 @@
+#! /usr/bin/perl
+# vim:ts=8:sw=8
+
+use lib '/opt/gondul/include';
+use nms::web;
+use strict;
+use warnings;
+
+my $query = $nms::web::dbh->prepare('select id,time as timestamp,extract(hour from time) as h, extract(minute from time) as m,systems,username,log from oplog order by id desc;');
+$query->execute();
+while (my $ref = $query->fetchrow_hashref()) {
+	my %meh;
+	$meh{'time'} = $ref->{'h'} . ":" . $ref->{'m'};
+	$meh{'log'} = $ref->{'log'};
+	$meh{'username'} = $ref->{'username'};
+	$meh{'id'} = $ref->{'id'};
+	$meh{'systems'} = $ref->{'systems'};
+	$meh{'timestamp'} = $ref->{'timestamp'};
+	push @{$nms::web::json{'oplog'}},\%meh;
+}
+
+nms::web::finalize_output();
-- 
cgit v1.2.3