<?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;
            }


?>