fhiiqm/vertrag_upd.php
changeset 24 15f33315f045
parent 21 97dba0fe820c
child 31 0a1eb975fbd9
--- a/fhiiqm/vertrag_upd.php	Mon Feb 06 13:44:00 2012 +0100
+++ b/fhiiqm/vertrag_upd.php	Fri Mar 02 13:54:32 2012 +0100
@@ -64,7 +64,7 @@
         if (!$upd && !$del)
         {
             $sql = "SELECT contract_ID,contract_name,contract_s,contract_l,vtyp_ID,contract_begin,contract_end,
-                    contract_autoend,contract_mon_notice,contract_file,Bemerkung 
+                    contract_autoend,contract_mon_notice,contract_file,Bemerkung,email_send 
                     FROM fhiiqm.Vertrag WHERE contract_ID = $cid";
             if ($result = $dbc ->queryObjectArray($sql))
             {
@@ -84,6 +84,7 @@
                     $vtr['cnot']    = $row->contract_mon_notice;
                     $vtr['cfname']  = $row->contract_file;
                     $vtr['cbem']    = $row->Bemerkung;
+                    $vtr['email']   = $row->email_send;
                 }  
             }
             // Bearbeiter
@@ -255,9 +256,10 @@
                     contract_autoend = ?, 
                     contract_mon_notice = ?,
                     contract_file = ?,  
-                    Bemerkung = ? 
+                    Bemerkung = ?,
+                    email_send = ? 
                     WHERE contract_ID = $cid") ;
-            $stmt -> bind_param('ssissiiss',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vbegin,$vend,$vtr['cautoend'],$vtr['cnot'],$cfile,$vtr['cbem']);
+            $stmt -> bind_param('ssissiissi',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vbegin,$vend,$vtr['cautoend'],$vtr['cnot'],$cfile,$vtr['cbem'],$vtr["email"]);
             $retv = $stmt -> execute();
         }       
 //        echo "UPDATE-sql = \n";print_r($stmt); echo "<br />";