--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/inc/anlage_dat_show.inc.php	Mon Nov 21 16:24:43 2011 +0100
@@ -0,0 +1,53 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 11/2011
+ * 
+ * Bestaetigen Anlagen - INSERT/UPDATE-Daten
+ */
+
+            echo "<table>\n";
+            echo "<tr><td>Anlagen-ID: </td><td>" . $alid . "<td></td></tr>\n";
+            echo "<tr><td>Anlagenbezeichnung: </td><td>" . $al['bez'] . "<td></td></tr>\n";
+            echo "<tr><td>Anlagenbeschreibung: </td><td>" . nl2br($al['beschr']) . "<td></td></tr>\n";
+            // Kategorie
+            $sql = "SELECT al_kat_ID,al_kat_bez FROM fhiiqm.A_Kategorie WHERE al_kat_ID = '" . $al["kat"] . "'";
+            if ($result = $dbc->queryObjectArray($sql))
+            {
+                foreach ($result as $row)
+                    echo "<tr><td>Anlagen-Kategorie: </td><td>" . $row->al_kat_ID.": " . $row->al_kat_bez . "</td></tr>\n";
+            }
+            // Befaehigungsgrad
+            $sql = "SELECT al_befgrad_ID,al_befgrad_bez FROM fhiiqm.A_BefGrad WHERE al_befgrad_ID = '" . $al["befg"] . "'";
+            if ($result = $dbc->queryObjectArray($sql))
+            {
+                foreach ($result as $row)
+                    echo "<tr><td>Bef&auml;higungsgrad: </td><td>" . $row->al_befgrad_ID.": " . $row->al_befgrad_bez . "</td></tr>\n";
+            }
+            // Pruefart
+            $sql = "SELECT al_pruefart_ID,al_pruefart_bez FROM fhiiqm.A_PruefArt WHERE al_pruefart_ID = '" . $al["part"] . "'";
+            if ($result = $dbc->queryObjectArray($sql))
+            {
+                foreach ($result as $row)
+                    echo "<tr><td>Pr&uuml;fart: </td><td>" . $row->al_pruefart_ID.": " . $row->al_pruefart_bez . "</td></tr>\n";
+            }
+            // Raum
+            $sql = "SELECT raum_nr,raum_name,r.geb_ID,geb_name 
+                    FROM fhiiqm.Raum r INNER JOIN fhiiqm.Haus h ON r.geb_ID = h.geb_ID 
+                    WHERE raum_ID = '" . $al["raum"] . "'";
+            if ($result = $dbc->queryObjectArray($sql))
+            {
+                foreach ($result as $row)
+                    echo "<tr><td>Standort: </td><td>" . $row->geb_ID.": " . $row->geb_name . " - Raum: " . $row->raum_nr . "</td></tr>\n";
+            }
+            // Verantwortlicher
+            $sql = "SELECT CONCAT (nachname, ', ',vorname) AS ma FROM fhiiqm.Mitarbeiter WHERE persknr = " . $al["pid"];
+            if ($result = $dbc->queryObjectArray($sql))
+            {
+                foreach ($result as $row)
+                    echo "<tr><td>Verantwortlicher: </td><td>" . $row->ma . "</td></tr>\n";
+            }
+
+            echo "</table>\n";
+?>
\ No newline at end of file