From 20ce8f72cd899a1433ef4da983ed0475000a19ca Mon Sep 17 00:00:00 2001
From: arjen <arjen>
Date: Sat, 4 Jun 2005 07:18:25 +0000
Subject: [PATCH] Added a view for the log analysis with a link from the log
 page.

---
 src/web/log.php    | 15 ++++++---
 src/web/logadv.php | 89 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 2 files changed, 99 insertions(+), 5 deletions(-)
 create mode 100644 src/web/logadv.php

diff --git a/src/web/log.php b/src/web/log.php
index 04896fa..f10cbc7 100644
--- a/src/web/log.php
+++ b/src/web/log.php
@@ -9,7 +9,7 @@
 ***********************
 **      FILE NAME      : log.php
 **      SYSTEM NAME    : Gnucomo - Gnu Computer Monitoring
-**      VERSION NUMBER : $Revision: 1.5 $
+**      VERSION NUMBER : $Revision: 1.6 $
 **
 **  DESCRIPTION      : Logs page
 **
@@ -27,7 +27,10 @@
 
 /*****************************
    $Log: log.php,v $
-   Revision 1.5  2003-08-11 17:59:17  arjen
+   Revision 1.6  2005-06-04 07:18:26  arjen
+   Added a view for the log analysis with a link from the log page.
+
+   Revision 1.5  2003/08/11 17:59:17  arjen
    BUGFIX: Convert special characters for HTML (<, >, and &) into
    their entities.
 
@@ -45,7 +48,7 @@
 
 ******************************/
 
-// RCSID = "$Id: log.php,v 1.5 2003-08-11 17:59:17 arjen Exp $";
+// RCSID = "$Id: log.php,v 1.6 2005-06-04 07:18:26 arjen Exp $";
 
 ini_set('include_path', '.:./classes:../phpclasses');
 
@@ -98,7 +101,7 @@ class log_page extends page
 
          // Show the log for one day only.
 
-         $res = pg_exec($this->database, "SELECT object_timestamp, servicecode, rawdata FROM log "
+         $res = pg_exec($this->database, "SELECT logid, object_timestamp, servicecode, rawdata FROM log "
                         ."WHERE objectid = CAST('" . $_GET['oid'] . "' AS BIGINT)
                          AND date_trunc('day', object_timestamp)='" . date('Y-m-d', $logday) . "'
                          ORDER BY object_timestamp, logid");
@@ -111,7 +114,9 @@ class log_page extends page
             $log = pg_fetch_object($res, $row);
             ?>
             <tr><td class='time'>
-               <?php echo $log->object_timestamp?>
+               <a target='_new' href='logadv.php?logid=<?php echo $log->logid?>'>
+                 <?php echo $log->object_timestamp?>
+               </a>
             </td><td>
                <?php echo $log->servicecode?>
             </td><td>
diff --git a/src/web/logadv.php b/src/web/logadv.php
new file mode 100644
index 0000000..0a3e8e1
--- /dev/null
+++ b/src/web/logadv.php
@@ -0,0 +1,89 @@
+<?php
+
+/**************************************************************************
+**  (c) Copyright 2003, Andromeda Technology & Automation
+** This is free software; you can redistribute it and/or modify it under the
+** terms of the GNU General Public License, see the file COPYING.
+***************************************************************************
+** MODULE INFORMATION *
+***********************
+**      FILE NAME      : logadv.php
+**      SYSTEM NAME    : Gnucomo - Gnu Computer Monitoring
+**      VERSION NUMBER : $Revision: 1.1 $
+**
+**  DESCRIPTION      : Log analysis page
+**
+**  EXPORTED OBJECTS : 
+**  LOCAL    OBJECTS : 
+**  MODULES  USED    :
+***************************************************************************
+**  ADMINISTRATIVE INFORMATION *
+********************************
+**      ORIGINAL AUTHOR : Arjen Baart - arjen@andromeda.nl
+**      CREATION DATE   : Apr 10, 2004
+**      LAST UPDATE     : Apr 10, 2004
+**      MODIFICATIONS   : 
+**************************************************************************/
+
+/*****************************
+   $Log: logadv.php,v $
+   Revision 1.1  2005-06-04 07:18:25  arjen
+   Added a view for the log analysis with a link from the log page.
+
+******************************/
+
+// RCSID = "$Id: logadv.php,v 1.1 2005-06-04 07:18:25 arjen Exp $";
+
+ini_set('include_path', '.:./classes:../phpclasses');
+
+require_once('page.class.php');
+
+
+class logadv_page extends page
+{
+
+   function Body()
+   {
+      if (!empty($_GET['logid']))
+      {
+         echo "<h1>Log Analysis</h1><hr>";
+
+         $log = pg_fetch_object(pg_exec($this->database, "SELECT rawdata FROM log
+                                  WHERE logid='". $_GET['logid'] ."'"), 0);
+
+         $res = pg_exec($this->database, "SELECT * FROM log_adv*
+                                  WHERE logid='". $_GET['logid'] ."'");
+
+         echo "<pre>" . htmlentities($log->rawdata) . "\n</pre>\n";
+
+         echo pg_numrows($res) . " records found.<br>";
+
+         $analysis = pg_fetch_object($res, 0);
+
+         echo "<hr>\n";
+
+         $res = pg_exec($this->database, "SELECT * FROM " . $analysis->detailed_table
+                                     . " WHERE log_advid = '" . $analysis->log_advid . "'");
+         $analysis = pg_fetch_array($res, 0);
+
+         echo "<table>";
+         echo "<tr><th>Item</th><th>Value</th></tr>\n";
+
+         for ($fld = 0; $fld < pg_numfields($res); $fld++)
+         {
+            $name = pg_fieldname($res , $fld);
+            $value = $analysis[$name];
+
+            echo "<tr><td>" . $name . "</td><td>" . htmlentities($value) . "</td></tr>";
+         }
+         echo "</table>";
+
+      }
+   }
+}
+
+$page = new logadv_page("Gnucomo log analysis");
+
+$page->Showpage();
+
+?>
-- 
2.11.0