1 <?php

     2 

     3 /**

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

     5  * @copyright 07/2011

     6  * 

     7  * Anlisten Produkt - INSERT/UPDATE-Daten

     8  */

     9 

    10             echo "<table>\n";

    11             echo "<tr><td>Produkt-ID: </td><td>" . $prod['pnr'] . "<td></td></tr>\n";

    12             echo "<tr><td>Produkt-Name: </td><td>" . $prod['pname'] . "<td></td></tr>\n";

    13             // Produkt-Gruppe, Bereich

    14             $sql = "SELECT prod_group_ID, prod_group_name, prod_ber_name FROM Produkt_Gruppe g 

    15                         INNER JOIN Produkt_Bereich b ON g.prod_ber_ID=b.prod_ber_ID

    16                         WHERE prod_group_ID = " . $prod['grp'];

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

    18             {

    19                 foreach ($result as $row)

    20                 echo "<tr><td>Produkt-Gruppe: </td><td>" . $row->prod_group_name . "</td></tr>\n";

    21                 echo "<tr><td>Produkt-Bereich: </td><td>" . $row->prod_ber_name . "<td></td></tr>\n";

    22             }

    23             echo "<tr><td>Produkt-Hierarchie: </td><td>" . $phier . "<td></td></tr>\n";

    24             // Arbeitsgruppe

    25             $sql = "SELECT ag_ID, ag_name, abt_name FROM Arbeitsgruppe g INNER JOIN Abteilung a 

    26                         ON g.abt_ID = a.abt_ID

    27                         WHERE ag_ID = '" . $prod["ag"] ."' ";

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

    29             {

    30                 foreach ($result as $row)

    31                 echo "<tr><td>zugeordnet zu AG: </td><td>" . $row->ag_name . "</td></tr>\n";

    32             }

    33             // Wichtigkeit

    34             $sql = "SELECT imp_ID, imp_name_s FROM Wichtigkeit WHERE imp_ID = " . $prod["imp"];

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

    36             {

    37                 foreach ($result as $row)

    38                 echo "<tr><td>Wichtigkeit: </td><td>" . $row->imp_name_s . "</td></tr>\n";

    39             }

    40             // Bindungsstaerke

    41             $sql = "SELECT conn_ID, conn_name_s FROM Bindungsstaerke WHERE conn_ID = " . $prod["conn"];

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

    43             {

    44                 foreach ($result as $row)

    45                 echo "<tr><td>Bindungsst&auml;rke: </td><td>" . $row->conn_name_s . "</td></tr>\n";

    46             }

    47             echo "<tr><td>Bemerkung: </td><td>" . $prod['pbem'] . "<td></td></tr>\n";

    48             echo "</table>\n";

    49 

    50 

    51 ?>