fhiiqm/inc/raum_dat_show.inc.php
changeset 1 6288d5685bff
child 23 a382de56a8e4
--- /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"] = "&nbsp;";
+            echo "<tr><td>Raum-Fl&auml;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