***********************
** FILE NAME : log.php
** SYSTEM NAME : Gnucomo - Gnu Computer Monitoring
-** VERSION NUMBER : $Revision: 1.7 $
+** VERSION NUMBER : $Revision: 1.8 $
**
** DESCRIPTION : Logs page
**
/*****************************
$Log: log.php,v $
- Revision 1.7 2007-10-27 08:38:18 arjen
+ Revision 1.8 2007-11-21 14:38:06 arjen
+ The buttonbar at the top of each page is now a fixed 'div' element
+ instead of a framed page.
+ Contributed by Edwin Nadorp.
+
+ Revision 1.7 2007/10/27 08:38:18 arjen
Removed link to advanced log analysis
Revision 1.6 2005/06/04 07:18:26 arjen
******************************/
-// RCSID = "$Id: log.php,v 1.7 2007-10-27 08:38:18 arjen Exp $";
+// RCSID = "$Id: log.php,v 1.8 2007-11-21 14:38:06 arjen Exp $";
ini_set('include_path', '.:./classes:../phpclasses');
{
if (!empty($_GET['oid']))
{
+ $oid = $_GET['oid'];
$res = pg_exec($this->database, "SELECT objectname FROM object
- WHERE objectid=CAST('" . $_GET['oid']. "' AS BIGINT)");
+ WHERE objectid=CAST('$oid' AS BIGINT)");
$obj = pg_fetch_object($res, 0);
- echo "<h1>Log for " . $obj->objectname . "</h1><hr>";
+ echo "<script type='text/ecmascript'>
+ document.getElementById('menu_title').innerHTML = \"<h1>Log for "
+ . $obj->objectname . "<\/h1>\"
+ </script>";
// Determine which day to display.
// This is either from a previous button though a _POST[] variable
// or the last day in the log table by default.
- if (empty($_POST['logday']))
+ if (empty($_GET['logday']))
{
$res = pg_exec($this->database, "SELECT date_trunc('day',object_timestamp) FROM log
- WHERE objectid='". $_GET['oid'] ."'
+ WHERE objectid='$oid'
ORDER BY object_timestamp DESC LIMIT 1");
- $last_time = pg_fetch_object($res, 0);
- $logday = strtotime($last_time->date_trunc);
+ if( pg_num_rows($res) > 0 )
+ {
+ $last_time = pg_fetch_object($res, 0);
+ $logday = strtotime($last_time->date_trunc);
+ }
+ else
+ {
+ $logday = "";
+ }
}
else
{
- $logday = $_POST['logday'];
+ $logday = $_GET['logday'];
}
// Make buttons to request the previous and the next day of logs.
- echo "<form method='POST'>";
- echo "<input type='submit' value='<<'>";
- echo "<input type='hidden' name='logday' value='" . ($logday - 24 * 60 * 60) . "'>";
- echo "</form>";
-
- echo "<h3>" . date('F d, Y', $logday) ."</h3>";
-
- echo "<form method='POST'>";
- echo "<input type='submit' value='>>'>";
- echo "<input type='hidden' name='logday' value='" . ($logday + 24 * 60 * 60) . "'>";
- echo "</form>";
+ echo "<div id=\"log_date\">";
+ $logday1 = $logday - 24 * 60 * 60;
+ echo "<a href=\"log.php?oid=$oid&logday=$logday1\" title=\"previous day\"><<</a>";
+ echo " " . date('F d, Y', $logday) . " ";
+ $logday2 = $logday + 24 * 60 * 60;
+ echo "<a href=\"log.php?oid=$oid&logday=$logday2\" title=\"next day\">>></a>";
+ echo "</div>";
// Show the log for one day only.
$res = pg_exec($this->database, "SELECT logid, object_timestamp, servicecode, rawdata FROM log "
- ."WHERE objectid = CAST('" . $_GET['oid'] . "' AS BIGINT)
+ ."WHERE objectid = CAST('$oid' AS BIGINT)
AND date_trunc('day', object_timestamp)='" . date('Y-m-d', $logday) . "'
ORDER BY object_timestamp, logid");