--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/inc/raum_dat_show.inc.php Wed Aug 31 14:22:19 2011 +0200
@@ -0,0 +1,38 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 07/2011
+ *
+ * Anlisten Raum - INSERT/UPDATE-Daten
+ */
+
+ echo "<table>\n";
+ echo "<tr><td>Raum-Nr: </td><td>" . $raum['rnum'] . "<td></td></tr>\n";
+ echo "<tr><td>Raum-Bezeichnung: </td><td>" . $raum['rbez'] . "<td></td></tr>\n";
+ // Gebaeude
+ $sql = "SELECT geb_ID, geb_name FROM Haus
+ WHERE geb_ID = '" . $raum['geb'] . "'";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ echo "<tr><td>Haus: </td><td>" . $row->geb_ID . " - " . $row->geb_name . "</td></tr>\n";
+ }
+ // Raumtyp
+ $sql = "SELECT raumtyp_ID, raumtyp_bez FROM Raum_Typ
+ WHERE raumtyp_ID = '" . $raum['rtyp'] . "'";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ echo "<tr><td>Raumtyp: </td><td>" . $row->raumtyp_bez . "</td></tr>\n";
+ }
+ if ($raum["rflae"] == "NULL") $raum["rflae"] = " ";
+ echo "<tr><td>Raum-Fläche (m<sup>2</sup>): </td><td>" . str_replace(".",",",$raum['rflae']) . "<td></td></tr>\n";
+ if (file_exists("raeume/$rfile"))
+ echo "<tr><td>Dateibezeichnung Raumplan: </td><td><a href='raeume/$rfile'>" . $rfile. "</a></td></tr>\n";
+ else
+ echo "<tr><td>Dateibezeichnung Raumplan: </td><td>$rfile</td></tr>\n";
+ echo "</table>\n";
+
+
+?>
\ No newline at end of file