From 7cde8e93c0ef88908e5dc854ef20f2cdb0b8c54c Mon Sep 17 00:00:00 2001
From: arjen <arjen>
Date: Sat, 4 Jun 2005 07:25:59 +0000
Subject: [PATCH] Added an interface to edit check patterns

---
 src/web/services.php | 75 +++++++++++++++++++++++++++++++++++++++++++++++++---
 1 file changed, 72 insertions(+), 3 deletions(-)

diff --git a/src/web/services.php b/src/web/services.php
index dd10654..d6c897e 100644
--- a/src/web/services.php
+++ b/src/web/services.php
@@ -9,7 +9,7 @@
 ***********************
 **      FILE NAME      : services.php
 **      SYSTEM NAME    : Gnucomo - Gnu Computer Monitoring
-**      VERSION NUMBER : $Revision: 1.1 $
+**      VERSION NUMBER : $Revision: 1.2 $
 **
 **  DESCRIPTION      :  Service Administration page.
 **                      Input parameters: action (POST) : empty, 'Create'
@@ -29,12 +29,15 @@
 
 /*****************************
    $Log: services.php,v $
-   Revision 1.1  2003-09-01 06:53:22  arjen
+   Revision 1.2  2005-06-04 07:25:59  arjen
+   Added an interface to edit check patterns
+
+   Revision 1.1  2003/09/01 06:53:22  arjen
    New page to enter and modify services.
 
 ******************************/
 
-// RCSID = "$Id: services.php,v 1.1 2003-09-01 06:53:22 arjen Exp $";
+// RCSID = "$Id: services.php,v 1.2 2005-06-04 07:25:59 arjen Exp $";
 
 ini_set('include_path', '.:./classes:../phpclasses');
 
@@ -106,6 +109,33 @@ class service_page extends page
 
          pg_exec($this->database, $qry);
       }
+      if (isset($_POST['action']) && $_POST['action'] == 'Add')
+      {
+         $qry = "INSERT INTO service_pattern VALUES ('". $_GET['servcode'] . "'";
+         $qry .= ", '" . $_POST['Rank'] . "'";
+         $qry .= ", '" . $_POST['Pattern'] . "'";
+         $qry .= ", '" . $_POST['Pat_Action'] . "'";
+         $qry .= ", '" . $_POST['Argument'] . "')";
+
+         pg_exec($this->database, $qry);
+      }
+      if (isset($_POST['action']) && $_POST['action'] == 'Change')
+      {
+         $qry = "UPDATE service_pattern SET rank = '" . $_POST['Rank'] . "'";
+         $qry .= ", pattern = '" . $_POST['Pattern'] . "'";
+         $qry .= ", action = '" . $_POST['Pat_Action'] . "'";
+         $qry .= ", argument = '" . $_POST['Argument'] . "'";
+         $qry .= " WHERE service = '" . $_GET['servcode'] . "' AND rank = '" . $_POST['Rank'] . "'";
+
+         pg_exec($this->database, $qry);
+      }
+      if (isset($_POST['action']) && $_POST['action'] == 'Delete')
+      {
+         $qry = "DELETE FROM service_pattern WHERE service = '". $_GET['servcode'] . "'";
+         $qry .= " AND rank =  '" . $_POST['Rank'] . "'";
+
+         pg_exec($this->database, $qry);
+      }
 
       $res = pg_exec($this->database, "SELECT * FROM service
                                        WHERE servicecode='" . $_GET['servcode'] . "'");
@@ -141,6 +171,45 @@ class service_page extends page
       echo "</table>";
       echo "<input type='submit' name='action' value='Save Changes'>";
       echo "</form>";
+
+      echo "<h1>Patterns to check logs of " . $srv->servicename . "</h1>\n";
+
+      echo "<table>";
+      echo "<tr><th>Rank</th><th>Pattern</th><th>Action</th>";
+      echo "<th>Argument</th><th>&nbsp;</th><th>&nbsp;</th></tr>\n";
+
+      $pat_res = pg_exec($this->database, "SELECT * FROM service_pattern
+                                           WHERE service = '" . $srv->servicecode . "' ORDER BY rank");
+      for ($pat_row = 0; $pat_row < pg_numrows($pat_res); $pat_row++)
+      {
+         $pat = pg_fetch_object($pat_res, $pat_row);
+         echo "<tr><form action='services.php?servcode=" . $srv->servicecode . "' method='POST'><td>";
+         echo "<input type='text' name='Rank' value='" . $pat->rank . "'>";
+         echo "</td><td>";
+         echo "<input type='text' size='40' name='Pattern' value='" . $pat->pattern . "'>";
+         echo "</td><td>";
+         echo "<input type='text' name='Pat_Action' value='" . $pat->action . "'>";
+         echo "</td><td>";
+         echo "<input type='text' name='Argument' value='" . $pat->argument . "'>";
+         echo "</td><td>";
+         echo "<input type='submit' name='action' value='Change'>";
+         echo "</td><td>";
+         echo "<input type='submit' name='action' value='Delete'>";
+         echo "</td></form></tr>";
+      }
+      echo "<tr><form action='services.php?servcode=" . $srv->servicecode . "' method='POST'><td>";
+      echo "<input type='text' name='Rank' value=''>";
+      echo "</td><td>";
+      echo "<input type='text' size='40' name='Pattern' value=''>";
+      echo "</td><td>";
+      echo "<input type='text' name='Pat_Action' value=''>";
+      echo "</td><td>";
+      echo "<input type='text' name='Argument' value=''>";
+      echo "</td><td>";
+      echo "<input type='submit' name='action' value='Add'>";
+      echo "</td><td>&nbsp;";
+      echo "</td></form></tr>";
+      echo "</table>";
    }
    else
    {
-- 
2.11.0