fhiiqm/ma_tel_ed.php
changeset 42 cfc409017ba8
parent 41 9c668cd391fa
child 44 d652bbba2d43
--- a/fhiiqm/ma_tel_ed.php	Fri Dec 20 15:19:32 2013 +0100
+++ b/fhiiqm/ma_tel_ed.php	Fri Jan 17 08:50:55 2014 +0100
@@ -292,7 +292,8 @@
                 if ($ma['email'])
                 {
                     if (strpos($ma['email'],"@") > 0) $ma['email'] = $ma['email']; else $ma['email'] = $ma['email'] . "@fhi-berlin.mpg.de";
-                } 
+                }
+                $aktiv = $ma['fhi']; 
                 foreach ($ma as &$elem) if (!$elem) $elem = null;  // NULL-Eintrag in Leerfelder  
                 if ($pid) //UPDATE
                 {
@@ -307,7 +308,7 @@
                                         aktiv = ?,
                                         userid = ?
                                         WHERE persknr = $pid");
-                    $stmt -> bind_param('ssssiis',$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abtm'], $ma['fhi'], $userid);
+                    $stmt -> bind_param('ssssiis',$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abtm'], $aktiv, $userid);
 //                    echo "UPDATE: ". var_dump($stmt);
                     $result = $stmt -> execute();
                     if ($stmt->error) echo "error UPDATE Mitarbeiter: " . $stmt->error . "<br><br>\n";
@@ -317,7 +318,7 @@
                     $sql = "SELECT MAX(persknr) FROM Mitarbeiter WHERE persknr < 9500";
                     $pid = $dbc -> querySingleItem($sql) + 1;
                     $stmt -> prepare ("INSERT INTO Mitarbeiter (persknr, nachname, vorname, titel,email,abt_tel,aktiv,userid) VALUES (?,?,?,?,?,?,?,?)"); 
-                    $stmt -> bind_param('issssiis',$pid,$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abt'][0], $ma['fhi'], $userid);
+                    $stmt -> bind_param('issssiis',$pid,$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abt'][0], $aktiv, $userid);
                     $result = $stmt -> execute();
                     if ($stmt->error) echo "error INSERT Mitarbeiter: " . $stmt->error . "<br><br>\n";
                     $ma['abtm'] = $ma['abt'][0];