3 /**************************************************************************
4 ** This is free software; you can redistribute it and/or modify it under the
5 ** terms of the GNU General Public License, see the file COPYING.
6 ***************************************************************************/
10 * Objects Administration page.
11 * Input parameters: action (POST) : empty, 'Create'
12 * objname (POST) : name of the object to create or remove
16 require_once('classes/gnucomo_config.php');
20 function object_selection($db, $skip_oid)
22 /* Create and print an HTML option list of objects */
24 $res = pg_exec("SELECT objectid, objectname FROM object WHERE objectid != " . $skip_oid);
25 for ($row = 0; $row < pg_numrows($res); $row++)
27 $obj = pg_fetch_object($res, $row);
28 echo "<option value='" . $obj->objectid . "'>";
29 echo $obj->objectname;
35 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
38 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
39 <link rel='stylesheet' href='gnucomo.css' type='text/css'>
40 <title>GNUCoMo login</title>
42 <script language='JavaScript'>
43 function CheckCreate(f)
45 if (f.objectname.value == "")
47 alert("You must supply a name");
53 function CheckRemove(f)
55 var message = "Are you sure you want to remove object ";
56 message += f.objectname.value;
59 return confirm(message);
67 if (empty($_SESSION['username']))
69 echo "Please log in first.";
74 $config = new gnucomo_config;
76 $config->read("gnucomo");
78 // Connect to the database
79 $conn = pg_connect($config->Database($_SESSION['username'], $_SESSION['password']));
81 if (!empty($_GET['oid']))
83 $res = pg_exec($conn, "SELECT objectname FROM object WHERE objectid=" . $_GET['oid']);
84 $obj = pg_fetch_object($res, 0);
85 echo "<h1>Parameters for " . $obj->objectname . "</h1>";
87 $res = pg_exec("SELECT paramid, class, name, description FROM parameter "
88 ."WHERE objectid=" . $_GET['oid']);
91 <form action='parameter_compare.php' method='post'>
92 <input type='hidden' name='oid' value='<?php echo $_GET['oid'] ?>'>
95 <?php object_selection($conn, $_GET['oid']); ?>
97 <input type='submit' value=' Show Difference'>
103 while ($row < pg_numrows($res))
105 $par = pg_fetch_object($res, $row);
107 <tr><td align='center'>
108 <?php echo $par->class?>
110 <?php echo $par->name?>
112 <?php echo $par->description?>
115 $r = pg_exec($conn, "SELECT name, value FROM property WHERE paramid='" . $par->paramid . "'");
116 for ($p = 0; $p < pg_numrows($r); $p++)
118 $prop = pg_fetch_object($r, $p);
119 echo $prop->name . "=" . $prop->value . " ";