<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 07/2011
 * 
 * Anlisten Produkt - INSERT/UPDATE-Daten
 */

            echo "<table>\n";
            echo "<tr><td>Produkt-ID: </td><td>" . $prod['pnr'] . "<td></td></tr>\n";
            echo "<tr><td>Produkt-Name: </td><td>" . $prod['pname'] . "<td></td></tr>\n";
            // Produkt-Gruppe, Bereich
            $sql = "SELECT prod_group_ID, prod_group_name, prod_ber_name FROM Produkt_Gruppe g 
                        INNER JOIN Produkt_Bereich b ON g.prod_ber_ID=b.prod_ber_ID
                        WHERE prod_group_ID = " . $prod['grp'];
            if ($result = $dbc->queryObjectArray($sql))
            {
                foreach ($result as $row)
                echo "<tr><td>Produkt-Gruppe: </td><td>" . $row->prod_group_name . "</td></tr>\n";
                echo "<tr><td>Produkt-Bereich: </td><td>" . $row->prod_ber_name . "<td></td></tr>\n";
            }
            echo "<tr><td>Produkt-Hierarchie: </td><td>" . $phier . "<td></td></tr>\n";
            // Arbeitsgruppe
            $sql = "SELECT ag_ID, ag_name, abt_name FROM Arbeitsgruppe g INNER JOIN Abteilung a 
                        ON g.abt_ID = a.abt_ID
                        WHERE ag_ID = '" . $prod["ag"] ."' ";
            if ($result = $dbc->queryObjectArray($sql))
            {
                foreach ($result as $row)
                echo "<tr><td>zugeordnet zu AG: </td><td>" . $row->ag_name . "</td></tr>\n";
            }
            // Wichtigkeit
            $sql = "SELECT imp_ID, imp_name_s FROM Wichtigkeit WHERE imp_ID = " . $prod["imp"];
            if ($result = $dbc->queryObjectArray($sql))
            {
                foreach ($result as $row)
                echo "<tr><td>Wichtigkeit: </td><td>" . $row->imp_name_s . "</td></tr>\n";
            }
            // Bindungsstaerke
            $sql = "SELECT conn_ID, conn_name_s FROM Bindungsstaerke WHERE conn_ID = " . $prod["conn"];
            if ($result = $dbc->queryObjectArray($sql))
            {
                foreach ($result as $row)
                echo "<tr><td>Bindungsst&auml;rke: </td><td>" . $row->conn_name_s . "</td></tr>\n";
            }
            echo "<tr><td>Bemerkung: </td><td>" . $prod['pbem'] . "<td></td></tr>\n";
            echo "</table>\n";


?>