--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/raum_upd.php Wed Aug 31 14:22:19 2011 +0200
@@ -0,0 +1,209 @@
+<!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="css/db.css" rel="STYLESHEET" type="TEXT/CSS" />
+
+ <title>Aktualisieren Raumdaten</title>
+</head>
+
+<body>
+ <div class="float-r"><img src="img/house.png" border="0" alt="Raumdaten bearbeiten" title="Raumdaten bearbeiten"/></div>
+
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 07/2011
+ *
+ * UPDATE(/DELETE) Raumdaten
+ */
+
+ error_reporting(E_ALL ^ E_NOTICE);
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ $dbc = new dbconnection();
+
+ $rid = $_GET["uid"];
+ if (!$rid) $rid=1;
+ $ok = $_POST["ok"];
+ $upd = $_POST["upd"];
+ $del = $_POST["del"];
+ $raum = $_POST["raum"];
+ if (!$raum['okn']) $ok=false;
+
+// print_r($raum);
+// echo "<br><br>\n";
+// echo "Vertragsbezeichnung: " . $raum['cname'] ."<br><br>\n";
+
+ if ((!$ok && ((!$upd && !$del) || $upd || $del)) || ($upd && is_uploaded_file($_FILES["rfile"]["tmp_name"]) && $raum['rfname']<'!'))
+ {
+ if (!$upd && !$del)
+ {
+ $sql = "SELECT raum_ID,raum_nr,raum_name,geb_ID,raumtyp_ID,raum_flaeche,raum_file
+ FROM fhiiqm.Raum WHERE raum_ID = $rid";
+ if ($result = $dbc ->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ $raum['rnum'] = $row->raum_nr;
+ $raum['rbez'] = $row->raum_name;
+ $raum['geb'] = $row->geb_ID;
+ $raum['rtyp'] = $row->raumtyp_ID;
+ $raum['rflae'] = str_replace(".",",",$row->raum_flaeche);
+ $raum['rfname'] = $row->raum_file;
+ }
+ }
+ }
+
+ include_once("form/raum_form.inc.php");
+
+ if ($upd)
+ {
+ echo
+ "<tr>
+ <td>Upload Raumplan </td>
+ <td><input type=\"file\" name=\"rfile\" size=\"50\" maxlength=\"50\" value=\"" .
+ $_FILES["rfile"]["name"] . "\"/></td>
+ </tr>";
+
+ }
+ if ($upd || $del)
+ {
+ if ($upd)
+ $frage = "Alle Angaben ok?<br>
+ erst wenn Haken gesetzt, Upload-File wählen!";
+ elseif ($del)
+ $frage = "Raum 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";
+ echo "></td>\n</tr>\n";
+ }
+
+ echo "<tr>\n";
+ echo "
+ <td> </td>
+ <td><input class=\"button\" type=\"submit\" value=\"ändern\" name=\"upd\" title=\"update\" />
+ <input class=\"button\" type=\"submit\" value=\"löschen\" name=\"del\" title=\"delete\" /></td>\n";
+ echo "</tr>\n";
+ echo "</table>\n";
+ echo "</div>\n";
+ echo "</form>\n";
+
+ }
+ elseif ($ok && $upd)
+ {
+ echo "<div align='center'>\n";
+ //daten speichern
+
+ //UPDATE Raum
+ $raum['rbez'] = substr($raum['rbez'],0,50);
+ $raum['rnum'] = substr($raum['rnum'],0,10);
+ if ($raum['rtyp']== -1) $raum['rtyp'] = null;
+ // Filename Vertrag
+ $raum['rfname'] = substr($raum['rfname'],0,50);
+ if (isset($raum['rflae']) && $raum['rflae']>"0")
+ $raum['rflae'] = str_replace(",",".",$raum['rflae']);
+ else
+ $raum['rflae'] = null;
+
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+
+ // upload File, wenn vorhanden
+ if (is_uploaded_file($_FILES["rfile"]["tmp_name"]) && isset($_FILES["rfile"]["name"]) && $_FILES["rfile"]["name"] )
+ {
+ include ("inc/file_upload.inc.php");
+ $fname = gen_filename($raum['rfname'],"rfile",$rid); // Dateinamen generieren
+ $retdf = mod_file("/var/www/fhiiqm/raeume",$rid,"","del"); // Loeschen alte Datei
+ $retf = upload("rfile", $fname, $rid, "raeume"); // Datei prüfen und in Dokumentenverzeichnis verschieben
+ }
+
+ if (isset($fname) && $retf) $rfile = $rid . "_" . $fname; else $rfile = $raum['rfname'];
+/*
+ if ($raum['rtyp']== -1) $rtyp = "NULL"; else $rtyp = "'" . $raum['rtyp'] . "'";
+ if (isset($raum['rflae']) && $raum['rflae']>"0")
+ $raum['rflae'] = str_replace(",",".",$raum['rflae']);
+ else
+ $raum['rflae'] = "NULL";
+ if (isset($fname) && $retf) $rfile = "raum_file = '" . $rid . "_" . $fname . "' "; else $rfile = "raum_file = '" . $raum['rfname'] . "'";
+ $sql = "UPDATE fhiiqm.Raum SET
+ raum_nr ='" . $raum['rnum'] ."',
+ raum_name ='" . $raum['rbez'] ."',
+ geb_ID = '" . $raum['geb'] . "',
+ raumtyp_ID = " . $rtyp . ",
+ raum_flaeche = " . $raum['rflae'] . ", " .
+ $rfile .
+ " WHERE raum_ID = $rid" ;
+ $retr = $dbc -> execute($sql);
+*/
+ $stmt = $dbc -> stmtinit();
+ if (is_object($stmt))
+ {
+ $stmt -> prepare("UPDATE fhiiqm.Raum SET
+ raum_nr = ?,
+ raum_name = ?,
+ geb_ID = ?,
+ raumtyp_ID = ?,
+ raum_flaeche = ?,
+ raum_file = ? WHERE raum_ID = $rid");
+
+ $stmt -> bind_param('ssssds',$raum["rnum"],$aum["rbez"],$raum["geb"],$raum["rtyp"],$raum["rflae"],$rfile);
+ $retr = $stmt -> execute();
+ }
+// echo "UPDATE-sql = $sql<br />\n";
+ if (!$retr) echo "error update" . $dbc -> error ."<br />\n";
+ if ($retr)
+ {//Eingabe Daten, Upload File erfolgreich
+ echo "<p class='green'><b>Raumdaten zu ID '$rid' wurden erfolgreich gespeichert.</b></p>\n";
+ echo "<br /><br />\n";
+
+ // Anzeigen gespeicherte Vertragsdaten
+ if ($fname)
+ $rfile = $rid . "_" . $fname;
+ else
+ $rfile = $raum['rfname'];
+ include ("inc/raum_dat_show.inc.php");
+ }
+ }
+
+ elseif ($ok && $del)
+ {
+ // DELETE aus Tab Vertrag und abhaengigen Tabellen
+ echo "<div align='center'>\n";
+
+ $sql = "DELETE FROM Raum WHERE raum_ID = $rid";
+ $retrd = $dbc -> execute($sql);
+ if ($retrd)
+ {
+ echo "<p class='green'><b>Raum " . $raum['rnum'] . " (ID '$rid') wurde gelöscht.</b></p>\n";
+ include ("inc/file_upload.inc.php");
+ $retdf = mod_file("/var/www/fhiiqm/raeume",$rid,"","del"); // Loeschen Dokument
+ if ($retdf) echo "<p class='green'><b>Raumplan zu ID '$rid' wurde gelöscht.</b></p>\n";
+ echo "<br /><br />\n";
+
+ // Anzeigen geloeschter Vertragsdaten
+ if ($fname)
+ $rfile = $rid . "_" . $fname;
+ else
+ $rfile = $raum['rfname'];
+ include ("inc/raum_dat_show.inc.php");
+ }
+ }
+
+ if ($ok && ($upd || $del))
+ {
+ // Raumliste filtern mit zuletzt eingegeben Haus
+ $liste="?s=2&f=4&b=" . substr($raum["geb"],0,3);
+ echo "</div><br /><br />\n";
+ echo "<p> <a href=\"raum_flist.php$liste\" target=\"_self\" title=\"Raumliste\">Zurück zur Raumliste</a></p>\n";
+ echo "<p> <a href=\"raum_ins.php\" target=\"_self\" title=\"Raum erfassen\">Weiteren Raum erfassen</a></p>\n";
+ }
+
+?>
+
+</body>
+</html>
\ No newline at end of file