--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/inc/info_tab_ins.inc.php	Wed Aug 31 14:22:19 2011 +0200
@@ -0,0 +1,63 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer
+ * @copyright 08/2011
+ *
+ * INSERT Infodaten in n:m-Tabellen fuer INSERT und UPDATE Infodaten 
+ */
+
+            // Produkt
+            $retp = true;
+            if (is_array($inf["prid"]) && array_sum($inf["prid"])>0)
+            { // nur Produkte, keine Gruppen, Bereiche
+            
+                // Loeschen altes Produkt, INSERT neues
+                $sql = "DELETE FROM Info_Produkt WHERE info_ID = $infid";
+                $retpd = $dbc -> execute($sql);
+                if ($retpd)
+                {
+                    foreach ($inf["prid"] as $pid)
+                    {
+                        //INSERT in Produkt_Vertrag
+                        $sql = "INSERT INTO Info_Produkt VALUES($infid,$pid)";
+                        $retpi = $dbc -> execute($sql); 
+                        if (!$retpi) $retp=false;
+                    }
+                    if (!$retp) echo "error INSERT Info_Produkt<br />\n";
+                }
+                else
+                { 
+                    echo "error INSERT Info_Produkt: " . $dbc -> error . " <br />\n";
+                    $retp = false;
+                }
+            }
+            // Adressat
+            $reta = true;
+            $sql = "DELETE FROM Info_Adressat WHERE info_ID = $infid";
+            $retd = $dbc -> execute($sql);
+            if ($retd)
+            {
+                if (is_array($inf['adr']))
+                {
+                    foreach ($inf['adr'] as $adr)
+                    {
+                        if ($adr != -1)
+                        { 
+                            $sql = "INSERT INTO Info_Adressat VALUES($infid, $adr)";
+                            $retai = $dbc -> execute($sql);
+                            if (!$retai) $reta = false;
+                        }
+                    }
+                    if (!$reta) echo "error INSERT Info_Adressat<br />\n";
+                }
+
+            }
+            else
+            { 
+                echo "error INSERT Info_Adressat: " . $dbc -> error . " <br />\n";
+                $reta = false;
+            }
+
+
+?>
\ No newline at end of file