<?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></tr>\n";
            echo "<tr><td>Anlagenbezeichnung: </td><td>" . $al['bez'] . "</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";
            }
            // Pruefintervall
            if (!is_null($al["pintv"]))
            {
                $sql = "SELECT al_pruefintv_ID,al_pruefintv_bez FROM fhiiqm.A_PruefIntv WHERE al_pruefintv_ID = '" . $al["pintv"] . "'";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                        echo "<tr><td>Pr&uuml;fintervall: </td><td>" . $row->al_pruefintv_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";
?>