--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/inc/produkt_dat_show.inc.php	Wed Aug 31 14:22:19 2011 +0200
@@ -0,0 +1,51 @@
+<?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";
+
+
+?>
\ No newline at end of file