--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/keytyp_ed.php Mon Jul 01 14:36:18 2013 +0200
@@ -0,0 +1,186 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2013
+ *
+ * INSERT, UPDATE Keytype
+ */
+
+
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ session_start();
+ if (! isset($_SESSION["userid"]))
+ {
+ include_once ("inc/func_lib.inc.php");
+ login($_SERVER["PHP_SELF"]);
+ exit;
+ }
+
+ if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("kr",$_SESSION["recht"]) && !in_array("ke",$_SESSION["recht"])))
+ {
+ header("Location: start.php");
+ exit;
+ }
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+ // userid: Depot 'FHI', 'edit' = 1 -> Keytyp bearbeitbar
+ $redit = 0;
+ $uid = $_SESSION["userid"];
+ $sql = "SELECT edit FROM KeyDepot_userweb WHERE depot_ID = 'FHI' AND userid = '$uid'";
+ $redit = $dbc -> querySingleItem($sql);
+
+ $sub = $_POST["eintragen"];
+ $del = $_POST["del"];
+ $ky = $_POST["ky"];
+ $okn = $ky["okn"];
+ $ok = $_POST["ok"];
+ if (!$okn) $ok=0;
+ $kid = $_GET["i"]; // keytyp
+ $getp = "s=1&k=$kid"
+
+?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+
+<head>
+ <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
+ <link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
+ <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
+ <title>Keytyp bearbeiten</title>
+</head>
+
+<body>
+
+<?php
+ echo " ";
+ echo "<div class=\"float-br smaller\" valign='top'>";
+ echo " user: " . $_SESSION["userid"];
+ echo " <a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
+ echo "<div class=\"float-r\"><img src=\"img/key.png\" border=\"0\" alt=\"Keytyp bearbeiten\" title=\"Schlüsseltyp bearbeiten\"/></div>\n";
+
+ if ($redit)
+ if ($kid) $text = "editieren"; else $text = "erfassen";
+ else $text = "Ansicht";
+ echo "<div align=\"center\">";
+ echo "<h3>Schlüsseltyp $text</h3>";
+ echo "</div>\n";
+ if ((!$sub && !$del) || !isset($ky) || !$ok)
+ {
+ if ($kid && (!$sub || !$del) && !isset($ma))
+ {
+ $sql = "SELECT keytyp_ID,key_level,key_parent,key_hiertyp_ID,keytyp_bez,key_anl_ID FROM Keytyp WHERE keytyp_ID='$kid'";
+ if ($result = $dbc -> queryObjectArray($sql))
+ foreach ($result as $row)
+ {
+ $ky['typ'] = $row->keytyp_ID;
+ $ky['level'] = $row->key_level;
+ $ky['parent'] = $row->key_parent;
+ $ky['hier'] = $row->key_hiertyp_ID;
+ $ky['bez'] = $row->keytyp_bez;
+ $ky['anl'] = $row->key_anl_ID;
+ }
+ }
+ include ($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/form/keytyp_form.inc.php");
+
+ if ($sub || $del)
+ {
+ if ($sub)
+ $frage = "Alle Angaben ok?";
+ elseif ($del)
+ $frage = "Schlüsseltyp wirklich löschen?";
+ echo "<tr>
+ <td class=\"red\" valign=\"top\" align=\"left\">$frage</td>
+ <td><input type=\"checkbox\" name=\"ok\" value=\"1\"";
+ if ($ok) echo "checked=\"checked\"";
+ echo " /></td>\n</tr>\n";
+ }
+ if (!is_null($_SESSION["recht"]) && in_array("ke",$_SESSION["recht"]) && $redit)
+ {
+ echo "
+ <tr><td> </td>\n
+ <td><input class=\"button\" type=\"submit\" name=\"eintragen\" value=\" eintragen \" />";
+ if ($kid)
+ {
+ echo " <input class=\"buttonr\" type=\"submit\" value=\"löschen\" name=\"del\" title=\"delete\" />";
+// echo " <input class=\"button\" type=\"submit\" value=\"duplizieren\" name=\"dup\" title=\"delete\" />";
+ }
+ echo "</td></tr>\n";
+ }
+ echo "</table>\n";
+ echo "</div>\n";
+ echo "<p class='sc'> <a href=\"keytyp_search.php?$getp\" target=\"_self\" title=\"Schlüsseltyp-Suche\">« zur Schlüsseltyp-Suche</a></p>\n";
+ echo "</form>\n";
+ }
+ else
+ {
+ echo "<div align='center'>\n";
+
+ if ($del)
+ {
+ $sql = "DELETE FROM Keytyp WHERE keytyp_ID='$kid'";
+ if ($dbc -> execute($sql))
+ echo "<p class='green'><b>DELETE: Daten zu '$kid' wurden erfolgreich gelöscht.</b></p>\n";
+ else
+ {
+ echo "<p class='red'><b>DELETE: Daten zu '$kid' konnten nicht gelöscht werden!</b></p>\n";
+ echo "sql = $sql<br />";
+ echo "error DELETE: " . $dbc->error . "<br />";
+ }
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/keytyp_dat_show.inc.php");
+ }
+ else
+ {
+ if ($ky['hier'] == -1) $ky['hier'] = null;
+ if ($ky['anl'] == -1) $ky['anl'] = null;
+ foreach ($ky as &$elem) if (!$elem) $elem = null; // NULL-Eintrag in Leerfelder
+ $stmt = $dbc -> stmtinit();
+ if (is_object($stmt))
+ {
+ if ($kid) // UPDATE
+ {
+ $stmt -> prepare("UPDATE Keytyp SET
+ key_level = ?,
+ key_parent = ?,
+ key_hiertyp_ID = ?,
+ keytyp_bez = ?,
+ key_anl_ID = ?
+ WHERE keytyp_ID = '$kid'");
+ $stmt -> bind_param('sssss',$ky['level'],$ky['parent'],$ky['hier'],$ky['bez'],$ky['anl']);
+// echo "UPDATE: ". var_dump($stmt);
+ $result = $stmt -> execute();
+ if ($stmt->error) echo "error UPDATE Keytyp: " . $stmt->error . "<br><br>\n";
+ }
+ else
+ {
+ $stmt -> prepare("INSERT INTO Keytype (keytyp_ID,key_level,key_parent,key_hier_ID,key_bez,key_anl_ID) VALUES(?,?,?,?,?,?)");
+ $stmt -> bind_param('ssssss',$ky['typ'],$ky['level'],$ky['parent'],$ky['hier'],$ky['bez'],$ky['anl']);
+ $result = $stmt -> execute();
+ if ($stmt->error) echo "error INSERT Keytyp: " . $stmt->error . "<br><br>\n";
+ }
+ if ($result) // INSERT/UPDATE Keytyp
+ {
+ //Eingabe Daten erfolgreich
+ echo "<p class='green'><b>Keytypdaten zu '" . $ky['typ']. "', Level = '". $ky['level'] . "' wurden erfolgreich gespeichert.</b></p>\n";
+ echo "<br /><br />\n";
+ }
+ else
+ {
+ echo "<p class='red'><b>Keytypdaten zu '" . $ky['typ']. "', Level = '". $ky['level'] . "' konnten nicht gespeichert werden.</b></p>\n";
+ echo "error: ". $dbc -> error;
+ echo "<br /><br />\n";
+ }
+ include ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/keytyp_dat_show.inc.php");
+ }
+
+ }
+ echo "</div>";
+ echo "<p class='sc'> <a href=\"keytyp_search.php?$getp\" target=\"_self\" title=\"Schlüsseltyp-Suche\">« zur Schlüsseltyp-Suche</a></p>\n";
+ echo "<p class='sc'> <a href=\"".$_SERVER["PHP_SELF"]."\" target=\"_self\" title=\"Schlüsseltyp erfassen\">Neuen Schlüsseltyp erfassen</a></p>\n";
+ }
+?>
+</body>
+</html>
\ No newline at end of file