1 <?php

     2 

     3 /**

     4  * @author Bettina Schwarzer, Fritz-Haber-Institut

     5  * @copyright 11/2011

     6  * 

     7  * Bestaetigen Anlagen - INSERT/UPDATE-Daten

     8  */

     9 

    10             echo "<table>\n";

    11             echo "<tr><td>Anlagen-ID: </td><td>" . $alid . "<td></td></tr>\n";

    12             echo "<tr><td>Anlagenbezeichnung: </td><td>" . $al['bez'] . "<td></td></tr>\n";

    13             echo "<tr><td>Anlagenbeschreibung: </td><td>" . nl2br($al['beschr']) . "<td></td></tr>\n";

    14             // Kategorie

    15             $sql = "SELECT al_kat_ID,al_kat_bez FROM fhiiqm.A_Kategorie WHERE al_kat_ID = '" . $al["kat"] . "'";

    16             if ($result = $dbc->queryObjectArray($sql))

    17             {

    18                 foreach ($result as $row)

    19                     echo "<tr><td>Anlagen-Kategorie: </td><td>" . $row->al_kat_ID.": " . $row->al_kat_bez . "</td></tr>\n";

    20             }

    21             // Befaehigungsgrad

    22             $sql = "SELECT al_befgrad_ID,al_befgrad_bez FROM fhiiqm.A_BefGrad WHERE al_befgrad_ID = '" . $al["befg"] . "'";

    23             if ($result = $dbc->queryObjectArray($sql))

    24             {

    25                 foreach ($result as $row)

    26                     echo "<tr><td>Bef&auml;higungsgrad: </td><td>" . $row->al_befgrad_ID.": " . $row->al_befgrad_bez . "</td></tr>\n";

    27             }

    28             // Pruefart

    29             $sql = "SELECT al_pruefart_ID,al_pruefart_bez FROM fhiiqm.A_PruefArt WHERE al_pruefart_ID = '" . $al["part"] . "'";

    30             if ($result = $dbc->queryObjectArray($sql))

    31             {

    32                 foreach ($result as $row)

    33                     echo "<tr><td>Pr&uuml;fart: </td><td>" . $row->al_pruefart_ID.": " . $row->al_pruefart_bez . "</td></tr>\n";

    34             }

    35             // Raum

    36             $sql = "SELECT raum_nr,raum_name,r.geb_ID,geb_name 

    37                     FROM fhiiqm.Raum r INNER JOIN fhiiqm.Haus h ON r.geb_ID = h.geb_ID 

    38                     WHERE raum_ID = '" . $al["raum"] . "'";

    39             if ($result = $dbc->queryObjectArray($sql))

    40             {

    41                 foreach ($result as $row)

    42                     echo "<tr><td>Standort: </td><td>" . $row->geb_ID.": " . $row->geb_name . " - Raum: " . $row->raum_nr . "</td></tr>\n";

    43             }

    44             // Verantwortlicher

    45             $sql = "SELECT CONCAT (nachname, ', ',vorname) AS ma FROM fhiiqm.Mitarbeiter WHERE persknr = " . $al["pid"];

    46             if ($result = $dbc->queryObjectArray($sql))

    47             {

    48                 foreach ($result as $row)

    49                     echo "<tr><td>Verantwortlicher: </td><td>" . $row->ma . "</td></tr>\n";

    50             }

    51 

    52             echo "</table>\n";

    53 ?>