From: arjen Date: Mon, 1 Sep 2003 06:53:22 +0000 (+0000) Subject: New page to enter and modify services. X-Git-Tag: V0_0_8~16 X-Git-Url: http://www.andromeda.nl/gitweb/?p=gnucomo.git;a=commitdiff_plain;h=c86cbe1efa06e13a03e32cccdb0b6654f220e26a New page to enter and modify services. --- diff --git a/src/web/menu.html b/src/web/menu.html index 8c6d9a2..6b80d44 100644 --- a/src/web/menu.html +++ b/src/web/menu.html @@ -8,6 +8,7 @@ Objects Users + Services Logout
diff --git a/src/web/services.php b/src/web/services.php new file mode 100644 index 0000000..dd10654 --- /dev/null +++ b/src/web/services.php @@ -0,0 +1,213 @@ + + + + +database, "INSERT INTO service + (servicecode, servicename, default_priority, max_priority) VALUES ('" + . $_POST['servcode'] . "','" . $_POST['servname'] . "','" + . $_POST['defprior'] . "','" . $_POST['maxprior'] . "')"); + } + + if (isset($_POST['action']) && $_POST['action'] == 'Remove' && !empty($_POST['servcode'])) + { + pg_exec($this->database, "DELETE FROM service WHERE servicecode='" + . $_POST['servcode'] . "'"); + } + + if (isset($_GET['servcode'])) + { + echo "

Detailed information for service " . $_GET['servcode'] . "


\n"; + + if (isset($_POST['action']) && $_POST['action'] == 'Save Changes') + { + $qry = "UPDATE service SET servicename='" . $_POST['servname'] . "'"; + $qry .= ", default_priority='" . $_POST['defprior'] . "'"; + $qry .= ", max_priority='" . $_POST['maxprior'] . "'"; + $qry .= " WHERE servicecode='" . $_GET['servcode'] . "'"; + + pg_exec($this->database, $qry); + } + + $res = pg_exec($this->database, "SELECT * FROM service + WHERE servicecode='" . $_GET['servcode'] . "'"); + $srv = pg_fetch_object($res, 0); + + echo "
"; + echo ""; + + echo ""; + echo "
Service name
Default priority"; + echo "
Maximum priority"; + echo "
"; + echo ""; + echo "
"; + } + else + { + echo "

Service Administration

"; + + $res = pg_exec($this->database, "SELECT * FROM service ORDER BY servicecode"); + + echo ""; + echo ""; + $srv = 0; + while ($srv < pg_numrows($res)) + { + $u = pg_fetch_object($res, $srv); + ?> + + "; + +?> + +

Create new service:

+

+ +
+Service code: +Service name: +Default priority: +Maximum priority: +
+ + +

+ +Showpage(); + +?>
Service codeNamePriorityMax priority

+ servicecode ?> + 		+ servicename ?> + + default_priority ?> + + max_priority ?> + +
+ + +
+