--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/inc/vertragtab_ins.inc.php	Wed Aug 31 14:22:19 2011 +0200
@@ -0,0 +1,131 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 06/2011
+ *   
+ * INSERT Vertragsdaten in n:m-Tabellen fuer INSERT und UPDATE Vertragsdaten 
+ */
+
+            // Loeschen der alten Bearbeiter, Hinzufuegen der neuen
+            $retb = true;
+            $sql = "DELETE FROM Vertrag_Bearbeiter WHERE contract_ID = $cid";
+            $retd = $dbc -> execute($sql);
+            if ($retd)
+            {
+                if (is_array($vtr['cpers']))
+                {
+                    foreach ($vtr['cpers'] as $pers)
+                    {
+                        if ($pers != -1)
+                        { 
+                            $sql = "INSERT INTO Vertrag_Bearbeiter VALUES($cid, $pers)";
+                //                        echo "INSERT Bearbeiter: $sql<br><br>\n";
+                            $retb = $dbc -> execute($sql);
+                        }
+                    }
+                }
+
+            }
+
+             // Partner
+            $retp = true;
+            if ($vtr['partid'] != -1)
+            {
+                // Loeschen alter Partner, INSERT neuer
+                $sql = "DELETE FROM Vertrag_Partner WHERE contract_ID = $cid";
+                $retdp = $dbc -> execute($sql);
+                if ($retdp)
+                {
+                    $sql = "INSERT INTO Vertrag_Partner VALUES($cid," . $vtr['partid'] .")";
+                    $retp = $dbc -> execute($sql);
+                    if (!$retp) echo "error INSERT Vertrag_Partner: " . $dbc -> error . " <br />\n";
+                }
+                $pid = $vtr['partid'];
+            }
+            if ($vtr['partner'])
+            {
+                // Test, ob Eintrag schon vorhanden
+                $sql = "SELECT part_ID, part_firma FROM Partner WHERE part_firma = '" . ltrim($vtr['partner']) . "'";
+                if ($res = $dbc -> queryObjectArray($sql))
+                {
+                    foreach ($res as $row)
+                        $pid = $row->part_ID;
+                }        
+                else
+                {
+                    // INSERT in Partner, ID INSERT in Vertrag_Partner
+                    $sql = "INSERT INTO Partner (part_firma) VALUES (LEFT(TRIM('" . $vtr['partner'] . "'),50))";
+                    $retp = $dbc -> execute($sql); 
+    //                    echo "Partner INSERT: $sql<br />\n";           
+                    if ($retp) $pid = $dbc -> insertId();
+                }
+                if ($pid)
+                { 
+                    // Loeschen alter Partner, INSERT neuer
+                    $sql = "DELETE FROM Vertrag_Partner WHERE contract_ID = $cid";
+                    $retdp = $dbc -> execute($sql);
+                    if ($retdp)
+                    {
+                            $sql = "INSERT INTO Vertrag_Partner VALUES($cid,$pid)";
+                            $retp = $dbc -> execute($sql);
+                            if (!$retp) echo "error INSERT Vertrag_Partner: " . $dbc -> error . " <br />\n";
+                    }
+                }
+            }
+            
+            // Produkt
+            $retd = true;
+            if ($vtr['prodid'] > 0 || $vtr['prodid'] = -1) // nur Produkte, keine Gruppen, Bereiche
+            {
+                // Loeschen altes Produkt, INSERT neues
+                $sql = "DELETE FROM Produkt_Vertrag WHERE contract_ID = $cid";
+                $retdd = $dbc -> execute($sql);
+                if ($retdd && $vtr['prodid'] > 0)
+                {
+                    //INSERT in Produkt_Vertrag
+                    $sql = "INSERT INTO Produkt_Vertrag VALUES(".$vtr['prodid'].",$cid)";
+                    $retd = $dbc -> execute($sql); 
+                    if (!$retd) echo "error INSERT Produkt_Vertrag: " . $dbc -> error . " <br />\n";
+                }
+                
+            }
+            
+            // Kosten
+            $retk = true;
+            if ($vtr['kost'] && $vtr['bjahr']) // Kosten fuer mindestens Startjahr
+            {
+                // alle bisherigen Angaben loeschen
+                $sql = "DELETE FROM Vertrag_Kosten WHERE contract_ID = $cid";
+                $retdk = $dbc -> execute($sql);   
+                if ($retdk)
+                {
+                    $j=0;
+                    if ($vtr['ejahr']) // Endjahr angegeben
+                    {
+                        for ($i=(int)$vtr['bjahr']; $i< (int)$vtr['ejahr'] +1; $i++)
+                        {
+                            if ($vtr['kost'][$j])
+                            {
+                                $kost = str_replace(',','.',$vtr['kost'][$j]);
+                                $sql = "INSERT INTO Vertrag_Kosten (contract_ID,k_year,kosten) VALUES($cid,$i,$kost)";
+                                $retk = $dbc -> execute($sql);
+                            }
+                            $j++;   
+                        }
+                    }
+                    else // nur fuer Startjahr
+                    {
+                        if ($vtr['kost'][0])
+                        {
+                            $kost = str_replace(',','.',$vtr['kost'][0]);
+                            $sql = "INSERT INTO Vertrag_Kosten (contract_ID,k_year,kosten) VALUES($cid,".(int)$vtr['bjahr'].",$kost)";
+                            $retk = $dbc -> execute($sql);
+                        }   
+                    }
+                    if (!$retk) echo "error INSERT Vertrag_Kosten: " . $dbc -> error . "<br />$sql<br />\n";
+                }
+            }
+
+
+?>
\ No newline at end of file