<?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";

?>