<?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: $dbc->error<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: $dbc->error<br />\n";

                }

            }

            else

            { 

                echo "error INSERT Info_Adressat: " . $dbc -> error . " <br />\n";

                $reta = false;

            }

            // Verantwortliche + Bemerkung (ehemals Prioritaet)

            $retv = true;

            $sql = "DELETE FROM Info_Verantwortlich WHERE info_ID = $infid";

            $retv = $dbc -> execute($sql);

            if ($retv)

            {

                if (!is_object($stmt)) $stmt = $dbc -> stmtinit();

                if (is_array($inf['vpers']))

                {

                    $stmt -> prepare("INSERT INTO Info_Verantwortlich (info_ID,persknr,prioritaet) VALUES(?,?,?)");

                    for ($k=0; $k<count($inf['vpers']); $k++)

                    {

                        if ($inf['vpers'] != -1)

                        { 

                            $retvi = $stmt -> execute();

                            if (!$retvi) $retv = false;

                        }

                    }

                    if (!$retv) echo "error INSERT Info_Verantwortlich: $stmt->error<br />\n";

                }

            }

            else

            { 

                echo "error INSERT Info_Verantwortlich: " . $dbc -> error . " <br />\n";

                $retv = false;

            }

?>