50 |
50 |
51 <head> |
51 <head> |
52 <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
52 <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
53 <link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/> |
53 <link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/> |
54 <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/> |
54 <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/> |
|
55 <link type="text/css" href="/fhiiqm/css/jquery/ui-lightness-1.8.21/jquery-ui-1.8.21.custom.css" rel="Stylesheet" /> |
|
56 <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-1.7.2.min.js"></script> |
|
57 <script type="text/javascript" src="/fhiiqm/js/jquery/jquery-ui-1.8.21.custom.min.js"></script> |
55 <title>MA/O bearbeiten</title> |
58 <title>MA/O bearbeiten</title> |
56 |
59 |
57 <script type="text/javascript"> |
60 <script type="text/javascript"> |
58 <!-- |
61 <!-- |
59 var counter = 0; |
62 var counter = 0; |
127 </script> |
130 </script> |
128 |
131 |
129 </head> |
132 </head> |
130 |
133 |
131 <body> |
134 <body> |
|
135 <script type="text/javascript"> |
|
136 <!-- |
|
137 $(document).ready(function() { |
|
138 $("#fhi").focus(); |
|
139 $("#nname").autocomplete({ |
|
140 source: "/fhiiqm/inc/ma_ldap_ac.inc.php", |
|
141 minLength: 2, |
|
142 select: function(event,ui){// $("#nname").val(ui.item.id); |
|
143 $("#vname").val(ui.item.id2); |
|
144 $("#email").val(ui.item.id3); } |
|
145 }); |
|
146 }); |
|
147 //--> |
|
148 </script> |
132 |
149 |
133 <?php |
150 <?php |
134 echo " "; |
151 echo " "; |
135 echo "<div class=\"float-br smaller\" valign='top'>"; |
152 echo "<div class=\"float-br smaller\" valign='top'>"; |
136 echo " user: " . $_SESSION["userid"]; |
153 echo " user: " . $_SESSION["userid"]; |
144 if ((!$sub && !$del) || !isset($ma) || !$ok) |
161 if ((!$sub && !$del) || !isset($ma) || !$ok) |
145 { |
162 { |
146 |
163 |
147 if ($pid && (!$sub || !$del) && !isset($ma)) |
164 if ($pid && (!$sub || !$del) && !isset($ma)) |
148 { |
165 { |
149 $sql = "SELECT nachname,vorname,titel,abt_tel,email,aktiv FROM Mitarbeiter WHERE persknr=$pid"; |
166 $sql = "SELECT nachname,vorname,titel,abt_tel,email,aktiv,timestamp,userid FROM Mitarbeiter WHERE persknr=$pid"; |
150 if ($result = $dbc -> queryObjectArray($sql)) |
167 if ($result = $dbc -> queryObjectArray($sql)) |
151 { |
168 { |
152 foreach ($result as $row) |
169 foreach ($result as $row) |
153 { |
170 { |
154 $ma['name'] = $row->nachname; |
171 $ma['name'] = $row->nachname; |
155 $ma['vname'] = $row->vorname; |
172 $ma['vname'] = $row->vorname; |
156 $ma['titel'] = $row->titel; |
173 $ma['titel'] = $row->titel; |
157 $ma['abtm'] = $row->abt_tel; |
174 $ma['abtm'] = $row->abt_tel; |
158 $ma['email'] = $row->email; |
175 $ma['email'] = $row->email; |
159 $ma['fhi'] = ($row->aktiv == 1)? 1 : 0; |
176 $ma['fhi'] = ($row->aktiv == 1)? 1 : 0; |
|
177 $ma["tstmp"] = $row->timestamp; |
|
178 $ma["uid"] = $row->userid; |
160 } |
179 } |
161 } |
180 } |
162 // Arbeitsgruppe, Abteilung |
181 // Arbeitsgruppe, Abteilung |
163 $sql = "SELECT mr.rag_ID, abt_ID FROM fhiiqm.MA_RaumArbGruppe mr INNER JOIN RaumArb_Gruppe r ON mr.rag_ID=r.rag_ID |
182 $sql = "SELECT mr.rag_ID, abt_ID FROM fhiiqm.MA_RaumArbGruppe mr INNER JOIN RaumArb_Gruppe r ON mr.rag_ID=r.rag_ID |
164 WHERE persknr=$pid"; |
183 WHERE persknr=$pid"; |
228 echo "</form>\n"; |
247 echo "</form>\n"; |
229 } |
248 } |
230 else |
249 else |
231 { |
250 { |
232 echo "<div align='center'>\n"; |
251 echo "<div align='center'>\n"; |
233 |
252 $userid = $_SESSION["userid"]; |
234 if ($del) |
253 if ($del) |
235 { |
254 { |
236 if ($ma["fhi"]) |
255 if ($ma["fhi"]) |
237 { |
256 { |
238 // nur aktiv auf 0 setzen |
257 // nur aktiv auf 0 setzen |
239 $sql = "UPDATE Mitarbeiter SET aktiv=0 WHERE persknr = $pid"; |
258 $sql = "UPDATE Mitarbeiter SET aktiv=0, userid=$userid WHERE persknr = $pid"; |
240 $retdi = $dbc -> execute($sql); |
259 $retdi = $dbc -> execute($sql); |
241 $sql = "DELETE FROM Mitarbeiter_Raum WHERE persknr = $pid"; |
260 $sql = "DELETE FROM Mitarbeiter_Raum WHERE persknr = $pid"; |
242 $retdi = $dbc -> execute($sql); |
261 $retdi = $dbc -> execute($sql); |
243 $sql = "DELETE FROM MA_Telefon WHERE persknr = $pid"; |
262 $sql = "DELETE FROM MA_Telefon WHERE persknr = $pid"; |
244 $retdi = $dbc -> execute($sql); |
263 $retdi = $dbc -> execute($sql); |
281 nachname = ?, |
300 nachname = ?, |
282 vorname = ?, |
301 vorname = ?, |
283 titel = ?, |
302 titel = ?, |
284 email = ?, |
303 email = ?, |
285 abt_tel = ?, |
304 abt_tel = ?, |
286 aktiv = ? |
305 aktiv = ?, |
|
306 userid = ? |
287 WHERE persknr = $pid"); |
307 WHERE persknr = $pid"); |
288 $stmt -> bind_param('ssssii',$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abtm'], $aktiv); |
308 $stmt -> bind_param('ssssiis',$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abtm'], $aktiv, $userid); |
289 // echo "UPDATE: ". var_dump($stmt); |
309 // echo "UPDATE: ". var_dump($stmt); |
290 $result = $stmt -> execute(); |
310 $result = $stmt -> execute(); |
291 if ($stmt->error) echo "error UPDATE Mitarbeiter: " . $stmt->error . "<br><br>\n"; |
311 if ($stmt->error) echo "error UPDATE Mitarbeiter: " . $stmt->error . "<br><br>\n"; |
292 } |
312 } |
293 else |
313 else |
294 { |
314 { |
295 $sql = "SELECT MAX(persknr) FROM Mitarbeiter WHERE persknr < 9500"; |
315 $sql = "SELECT MAX(persknr) FROM Mitarbeiter WHERE persknr < 9500"; |
296 $pid = $dbc -> querySingleItem($sql) + 1; |
316 $pid = $dbc -> querySingleItem($sql) + 1; |
297 $stmt -> prepare ("INSERT INTO Mitarbeiter (persknr, nachname, vorname, titel,email,abt_tel,aktiv) VALUES (?,?,?,?,?,?,?)"); |
317 $stmt -> prepare ("INSERT INTO Mitarbeiter (persknr, nachname, vorname, titel,email,abt_tel,aktiv,userid) VALUES (?,?,?,?,?,?,?,?)"); |
298 $stmt -> bind_param('issssii',$pid,$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abt'][0], $aktiv); |
318 $stmt -> bind_param('issssiis',$pid,$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abt'][0], $aktiv, $userid); |
299 $result = $stmt -> execute(); |
319 $result = $stmt -> execute(); |
300 if ($stmt->error) echo "error INSERT Mitarbeiter: " . $stmt->error . "<br><br>\n"; |
320 if ($stmt->error) echo "error INSERT Mitarbeiter: " . $stmt->error . "<br><br>\n"; |
301 $ma['abtm'] = $ma['abt'][0]; |
321 $ma['abtm'] = $ma['abt'][0]; |
302 } |
322 } |
303 if ($result) |
323 if ($result) |