***********************
** FILE NAME : objects.php
** SYSTEM NAME : Gnucomo - Gnu Computer Monitoring
-** VERSION NUMBER : $Revision: 1.7 $
+** VERSION NUMBER : $Revision: 1.8 $
**
** DESCRIPTION : Objects Administration page.
** Input parameters: action (POST) : empty, 'Create'
-** objname (POST) : name of the object to create or remove
+** objname (POST) : name of the object to create or remove
**
** EXPORTED OBJECTS :
** LOCAL OBJECTS :
********************************
** ORIGINAL AUTHOR : Arjen Baart - arjen@andromeda.nl
** CREATION DATE : Dec 04, 2002
-** LAST UPDATE : Feb 14, 2003
+** LAST UPDATE : Aug 04, 2003
** MODIFICATIONS :
**************************************************************************/
/*****************************
$Log: objects.php,v $
- Revision 1.7 2003-07-15 11:02:25 arjen
+ Revision 1.8 2003-08-14 10:35:07 arjen
+ Added editing of detailed object information.
+
+ Revision 1.7 2003/07/15 11:02:25 arjen
Use the new object_statistics table.
Revision 1.6 2003/02/21 08:46:58 arjen
******************************/
-// RCSID = "$Id: objects.php,v 1.7 2003-07-15 11:02:25 arjen Exp $";
+// RCSID = "$Id: objects.php,v 1.8 2003-08-14 10:35:07 arjen Exp $";
ini_set('include_path', '.:./classes:../phpclasses');
{
clientscripts();
- echo "<h1>Objects Administration</h1><hr>";
-
if (isset($_POST['action']) && $_POST['action'] == 'Create' && !empty($_POST['objectname']))
{
pg_exec($this->database, "INSERT INTO object (objectname, log_count, parameter_count, notification_count)
pg_exec($this->database, "DELETE FROM object WHERE objectname='" . $_POST['objectname'] . "'");
}
- $res = pg_exec($this->database, "SELECT objectid,objectname, log_count, notification_count
- FROM object ORDER BY objectname");
+ if (isset($_GET['oid']))
+ {
+ echo "<h1>Detailed information for object " . $_GET['oid'] . "</h1><hr>";
+
+ if (isset($_POST['action']) && $_POST['action'] == 'Save Changes')
+ {
+ $qry = "UPDATE object SET objectname='" . $_POST['oname'] . "'";
+ $qry .= ", objectcode='" . $_POST['ocode'] . "'";
+ $qry .= ", object_description='" . $_POST['odescription'] . "'";
+ $qry .= ", object_owner='" . $_POST['oowner'] . "'";
+ $qry .= ", physical_location='" . $_POST['olocation'] . "'";
+ $qry .= ", remark='" . $_POST['oremark'] . "'";
+ $qry .= ", timezone='" . $_POST['otimezone'] . "'";
+ $qry .= " WHERE objectid=" . $_GET['oid'];
+
+ pg_exec($this->database, $qry);
+ }
+
+ $res = pg_exec($this->database, "SELECT * FROM object
+ WHERE objectid='" . $_GET['oid'] . "'");
+ $obj = pg_fetch_object($res, 0);
+
+ echo "<form action='objects.php?oid=" . $obj->objectid . "' method='POST'>";
+ echo "<table>";
+
+ echo "<tr><td>Name</td><td><input name='oname' type='text' value='";
+ echo $obj->objectname . "'></td></tr>";
+ echo "<tr><td>Identification code</td><td><input name='ocode' type='text' value='";
+ echo $obj->objectcode . "'></td></tr>";
+ echo "<tr><td>Description</td><td><textarea name='odescription'>";
+ echo $obj->object_description . "</textarea></td></tr>";
+ echo "<tr><td>Owner</td><td><textarea name='oowner'>";
+ echo $obj->object_owner . "</textarea></td></tr>";
+ echo "<tr><td>Physical location</td><td><textarea name='olocation'>";
+ echo $obj->physical_location . "</textarea></td></tr>";
+ echo "<tr><td>Remarks</td><td><textarea name='oremark'>";
+ echo $obj->remark . "</textarea></td></tr>";
+ echo "<tr><td>Timezone</td><td><input name='otimezone' type='text' value='";
+ echo $obj->timezone . "'></td></tr>";
+
+ echo "</table>";
+ echo "<input type='submit' name='action' value='Save Changes'>";
+ echo "</form>";
+ }
+ else
+ {
+ echo "<h1>Objects Administration</h1><hr>";
+
+ $res = pg_exec($this->database, "SELECT * FROM object ORDER BY objectname");
?>
- <table>
- <tr><th>Object</th><th>Log entries</th>
- <th>Parameters</th><th>Notifications</th>
- </tr>
+ <table>
+ <tr><th>Object</th><th>Description</th><th>Log entries</th>
+ <th>Parameters</th><th>Notifications</th></tr>
<?php
- $obj = 0;
-
- //The counters are set to zero
- $count_logs = 0;
- $count_notifications = 0;
- $closed_notifications = 0;
- $count_parameters = 0;
- $removed_parameters = 0;
-
- while ($obj < pg_numrows($res))
- {
- $u = pg_fetch_object($res, $obj);
-
- $this->GatherStatistics($u->objectid);
-
- $count_parameters += $this->nr_parameters;
- $removed_parameters += $this->removed_parameters;
- $count_logs = $count_logs + $this->nr_logs;
-
- //$nr_notifications = $u->notification_count;
- $count_notifications += $this->nr_notifications;
- $closed_notifications += $this->closed_notifications;
- ?>
- <tr><td><center><img src='server.png'><br>
- <b><?php echo $u->objectname ?></b></center>
- </td><td class='number'>
- <?php echo "<a href='log.php?oid=$u->objectid'> $this->nr_logs </a>" ?>
- </td><td class='number'>
- <?php echo "<a href='parameter.php?oid=$u->objectid'>" . $this->nr_parameters
- . " (" . $this->removed_parameters . " removed)</a>" ?>
- </td><td class='number'>
- <?php echo "<a href='notification.php?oid=$u->objectid'>" . $this->nr_notifications . " (" . $this->closed_notifications . " closed)</a>" ?>
- </td><td>
- <form action='objects.php' method='post' onSubmit='return CheckRemove(this)'>
- <input type='hidden' name='objectname' value='<?php echo $u->objectname ?>'>
- <input type='submit' name='action' value='Remove'>
- </form>
- </td></tr>
- <?php
- $obj++;
- }
-
- //Show the totals
- echo "<tr><td><strong><B><br><br>TOTALS</B></strong></td>";
- echo "<td class='number'>$count_logs</td>";
- echo "<td class='number'>$count_parameters ($removed_parameters removed)</td>";
- echo "<td class='number'>$count_notifications ($closed_notifications closed)</td></tr>";
- echo "</table>";
+ $obj = 0;
+
+ //The counters are set to zero
+ $count_logs = 0;
+ $count_notifications = 0;
+ $closed_notifications = 0;
+ $count_parameters = 0;
+ $removed_parameters = 0;
+
+ while ($obj < pg_numrows($res))
+ {
+ $u = pg_fetch_object($res, $obj);
+
+ $this->GatherStatistics($u->objectid);
+
+ $count_parameters += $this->nr_parameters;
+ $removed_parameters += $this->removed_parameters;
+ $count_logs = $count_logs + $this->nr_logs;
+
+ $count_notifications += $this->nr_notifications;
+ $closed_notifications += $this->closed_notifications;
+ ?>
+ <tr><td><center><a href='objects.php?oid=<?php echo $u->objectid?>'<img src='server.png'></a><br>
+ <b><?php echo $u->objectname ?></b></center>
+ </td><td>
+ <?php echo nl2br($u->object_description) ?>
+ </td><td class='number'>
+ <?php echo "<a href='log.php?oid=$u->objectid'> $this->nr_logs </a>" ?>
+ </td><td class='number'>
+ <?php echo "<a href='parameter.php?oid=$u->objectid'>" . $this->nr_parameters
+ . " (" . $this->removed_parameters . " removed)</a>" ?>
+ </td><td class='number'>
+ <?php echo "<a href='notification.php?oid=$u->objectid'>" . $this->nr_notifications
+ . " (" . $this->closed_notifications . " closed)</a>" ?>
+ </td><td>
+ <form action='objects.php' method='post' onSubmit='return CheckRemove(this)'>
+ <input type='hidden' name='objectname' value='<?php echo $u->objectname ?>'>
+ <input type='submit' name='action' value='Remove'>
+ </form>
+ </td></tr>
+ <?php
+ $obj++;
+ }
+
+ //Show the totals
+ echo "<tr><td><strong><B><br><br>TOTALS</B></strong></td>";
+ echo "<td> </td>";
+ echo "<td class='number'>$count_logs</td>";
+ echo "<td class='number'>$count_parameters ($removed_parameters removed)</td>";
+ echo "<td class='number'>$count_notifications ($closed_notifications closed)</td></tr>";
+ echo "</table>";
?>
<input type='submit' name='action' value='Create'>
</form>
</p>
+
<?php
}
+ }
}
$obj_page = new object_page("Gnucomo Objects Administration");