162 if (!$ok && ((!$sub && !$del) || $sub || $del)) |
162 if (!$ok && ((!$sub && !$del) || $sub || $del)) |
163 { |
163 { |
164 if (!$sub && !$del) |
164 if (!$sub && !$del) |
165 { |
165 { |
166 $sql = "SELECT contract_ID,contract_name,contract_s,contract_l,vtyp_ID,contract_begin,contract_end, |
166 $sql = "SELECT contract_ID,contract_name,contract_s,contract_l,vtyp_ID,contract_begin,contract_end, |
167 contract_autoend,contract_mon_notice,contract_file,Bemerkung,email_send |
167 contract_autoend,contract_mon_notice,contract_file,Bemerkung,email_send,timestamp,userid |
168 FROM fhiiqm.Vertrag WHERE contract_ID = $cid"; |
168 FROM fhiiqm.Vertrag WHERE contract_ID = $cid"; |
169 if ($result = $dbc ->queryObjectArray($sql)) |
169 if ($result = $dbc ->queryObjectArray($sql)) |
170 { |
170 { |
171 foreach ($result as $row) |
171 foreach ($result as $row) |
172 { |
172 { |
179 $vtr['cautoend']= $row->contract_autoend; |
179 $vtr['cautoend']= $row->contract_autoend; |
180 $vtr['cnot'] = $row->contract_mon_notice; |
180 $vtr['cnot'] = $row->contract_mon_notice; |
181 // $vtr['cfname'][0] = $row->contract_file; |
181 // $vtr['cfname'][0] = $row->contract_file; |
182 $vtr['cbem'] = $row->Bemerkung; |
182 $vtr['cbem'] = $row->Bemerkung; |
183 $vtr['email'] = $row->email_send; |
183 $vtr['email'] = $row->email_send; |
|
184 $vtr['tstmp'] = $row->timestamp; |
|
185 $vtr['uid'] = $row->userid; |
184 } |
186 } |
185 } |
187 } |
186 // Bearbeiter |
188 // Bearbeiter |
187 $sql = "SELECT persknr FROM Vertrag_Bearbeiter WHERE contract_ID = $cid"; |
189 $sql = "SELECT persknr FROM Vertrag_Bearbeiter WHERE contract_ID = $cid"; |
188 if ($result = $dbc ->queryObjectArray($sql)) |
190 if ($result = $dbc ->queryObjectArray($sql)) |
287 } |
289 } |
288 elseif ($ok && $sub) |
290 elseif ($ok && $sub) |
289 { |
291 { |
290 echo "<div align='center'>\n"; |
292 echo "<div align='center'>\n"; |
291 //daten speichern |
293 //daten speichern |
|
294 $userid = $_SESSION["userid"]; |
292 |
295 |
293 $vtr['cname'] = substr($vtr['cname'],0,50); |
296 $vtr['cname'] = substr($vtr['cname'],0,50); |
294 // $vtr['cshort'] = substr($vtr['cshort'],0,50); |
297 // $vtr['cshort'] = substr($vtr['cshort'],0,50); |
295 $vtr['clong'] = substr($vtr['clong'],0,100); |
298 $vtr['clong'] = substr($vtr['clong'],0,100); |
296 if ($vtr['vtyp']== -1 || !(is_numeric($vtr['vtyp']))) $vtr['vtyp'] = null; |
299 if ($vtr['vtyp']== -1 || !(is_numeric($vtr['vtyp']))) $vtr['vtyp'] = null; |
315 contract_begin = ?, |
318 contract_begin = ?, |
316 contract_end = ?, |
319 contract_end = ?, |
317 contract_autoend = ?, |
320 contract_autoend = ?, |
318 contract_mon_notice = ?, |
321 contract_mon_notice = ?, |
319 Bemerkung = ?, |
322 Bemerkung = ?, |
320 email_send = ? |
323 email_send = ?, |
|
324 userid = ? |
321 WHERE contract_ID = $cid") ; |
325 WHERE contract_ID = $cid") ; |
322 $stmt -> bind_param('ssissiisi',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vtr['bdat'],$vtr['edat'],$vtr['cautoend'],$vtr['cnot'],$vtr['cbem'],$vtr["email"]); |
326 $stmt -> bind_param('ssissiisis',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vtr['bdat'],$vtr['edat'],$vtr['cautoend'],$vtr['cnot'],$vtr['cbem'],$vtr["email"],$userid); |
323 $retv = $stmt -> execute(); |
327 $retv = $stmt -> execute(); |
324 if (!$retv) echo "UPDATE Vertrag, error: " . $stmt->errno . " - ". $stmt->error ."<br />\n"; |
328 if (!$retv) echo "UPDATE Vertrag, error: " . $stmt->errno . " - ". $stmt->error ."<br />\n"; |
325 } |
329 } |
326 else |
330 else |
327 { |
331 { |
328 $stmt -> prepare("INSERT INTO Vertrag (contract_name, contract_l,vtyp_ID,contract_begin, contract_end, contract_autoend, |
332 $stmt -> prepare("INSERT INTO Vertrag (contract_name, contract_l,vtyp_ID,contract_begin, contract_end, contract_autoend, |
329 contract_mon_notice, bemerkung,email_send) |
333 contract_mon_notice, bemerkung,email_send,userid) |
330 VALUES(?,?,?,?,?,?,?,?,?)"); |
334 VALUES(?,?,?,?,?,?,?,?,?,?)"); |
331 $stmt -> bind_param('ssissiisi',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vtr['bdat'],$vtr['edat'],$vtr['cautoend'],$vtr['cnot'],$vtr['cbem'],$vtr["email"]); |
335 $stmt -> bind_param('ssissiisis',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vtr['bdat'],$vtr['edat'],$vtr['cautoend'],$vtr['cnot'],$vtr['cbem'],$vtr["email"],$userid); |
332 $retv = $stmt -> execute(); |
336 $retv = $stmt -> execute(); |
333 if (!$retv || $stmt->error) echo "INSERT Vertrag, error: " . $stmt->errno . " - ". $stmt->error . "<br><br>\n"; |
337 if (!$retv || $stmt->error) echo "INSERT Vertrag, error: " . $stmt->errno . " - ". $stmt->error . "<br><br>\n"; |
334 if ($retv) |
338 if ($retv) |
335 { // INSERT o.k. |
339 { // INSERT o.k. |
336 // contract_ID ermitteln |
340 // contract_ID ermitteln |