|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 11/2012, 12/2013 |
|
6 * |
|
7 * Form Mitarbeiter/Objekte FHI |
|
8 */ |
|
9 |
|
10 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
|
11 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
|
12 $okn = true; |
|
13 if (!$ma) |
|
14 { |
|
15 $ma['geb'] = 'A'; |
|
16 $ma['fhi'] = '1'; |
|
17 $ma['abt'][0] = $dbc -> querySingleItem("SELECT abt_ID FROM Abteilung ORDER BY abt_ID+0 LIMIT 0,1"); |
|
18 $ma['so'][0] = 1; |
|
19 } |
|
20 |
|
21 ?> |
|
22 <div align="center"> |
|
23 <h5>* - Felder sind erforderlich!</h5> |
|
24 </div> |
|
25 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_ma"> |
|
26 <div align="center"> |
|
27 <table width="65%" border="0" cellspacing="3" cellpadding="3"> |
|
28 <tr> |
|
29 <td> |
|
30 <u>Mitarbeiter</u> FHI? |
|
31 </td> |
|
32 <td><select name="ma[fhi]" id="fhi" size="1" onchange="this.form.submit();" > |
|
33 <?php |
|
34 $akt = array("0"=>"inaktiv","1"=>"aktiv","2"=>"Objekt","-1"=>"Gast"); |
|
35 foreach ($akt as $key=>$value) |
|
36 { |
|
37 if ($ma['fhi'] == $key) $select = " selected='selected'"; else $select=""; |
|
38 echo "<option$select value='$key'>$value</option>\n"; |
|
39 } |
|
40 ?> |
|
41 </select> |
|
42 </td> |
|
43 </tr> |
|
44 <tr> |
|
45 <?php if ($ma["fhi"] == 2) echo "<td>Bezeichnung 1 *</td>\n"; |
|
46 else echo "<td>Name *</td>\n"; ?> |
|
47 <td><input name="ma[name]" id="nname" type="text" size="30" maxlength="50" value="<?php echo $ma['name']; ?>" /> |
|
48 <?php |
|
49 if (isset($ma['name']) && $ma['name']<'!') |
|
50 { |
|
51 echo "<br><span class=\"red\">Name ist erforderlich!</span>\n"; |
|
52 $okn = false; |
|
53 } |
|
54 ?> |
|
55 </td> |
|
56 </tr> |
|
57 <tr> |
|
58 <?php if ($ma["fhi"] == 2) echo "<td>Bezeichnung 2 </td>\n"; |
|
59 else echo "<td>Vorname </td>\n"; ?> |
|
60 <td><input name="ma[vname]" id="vname" type="text" size="30" maxlength="50" value="<?php echo $ma['vname']; ?>" /> |
|
61 <?php |
|
62 /* if (isset($ma['vname']) && $ma['vname']<'!') |
|
63 { |
|
64 echo "<br><span class=\"red\">Vorname ist erforderlich!</span>\n"; |
|
65 $okn = false; |
|
66 } */ |
|
67 ?> |
|
68 </td> |
|
69 </tr> |
|
70 <?php if ($ma["fhi"] != 2) { ?> |
|
71 <tr> |
|
72 <td>Titel</td> |
|
73 <td><input name="ma[titel]" type="text" size="30" maxlength="30" value="<?php echo $ma['titel']; ?>" /></td> |
|
74 </tr> |
|
75 <?php } ?> |
|
76 <tr><td>Ort</td> |
|
77 <td valign="top">Haus |
|
78 <select name="ma[geb]" onchange="this.form.submit();"> |
|
79 <?php |
|
80 if ($ma['geb'] == -1) $select = " selected "; else $select = ""; |
|
81 echo "<option $select value=\"-1\"></option>\n"; |
|
82 $sql = "SELECT geb_ID, geb_name FROM `fhiiqm`.`Haus` ORDER BY 1"; |
|
83 if ($result = $dbc->queryObjectArray($sql)) |
|
84 { |
|
85 foreach ($result as $row) |
|
86 { |
|
87 if ($row->geb_ID == $ma['geb']) |
|
88 echo "<option selected value=\"$row->geb_ID\">$row->geb_ID: $row->geb_name</option>\n"; |
|
89 else |
|
90 echo "<option value=\"$row->geb_ID\">$row->geb_ID: $row->geb_name</option>\n"; |
|
91 } |
|
92 } |
|
93 ?> |
|
94 </select> |
|
95 Raum |
|
96 <select name="ma[raum]"> |
|
97 <?php |
|
98 if ($ma['raum'] == -1) $select = " selected "; else $select = ""; |
|
99 echo "<option $select value=\"-1\"></option>\n"; |
|
100 $sql = "SELECT raum_ID, raum_nr, raum_name FROM `fhiiqm`.`Raum` WHERE geb_ID='" . $ma['geb'] ."' ORDER BY 2"; |
|
101 if ($result = $dbc->queryObjectArray($sql)) |
|
102 { |
|
103 foreach ($result as $row) |
|
104 { |
|
105 if ($row->raum_ID == $ma['raum']) |
|
106 echo "<option selected value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n"; |
|
107 else |
|
108 echo "<option value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n"; |
|
109 } |
|
110 } |
|
111 ?> |
|
112 </select> |
|
113 </td> |
|
114 </tr> |
|
115 <?php |
|
116 /* // deaktiviert am 08.01.2013, Kaendler, Schwarzer |
|
117 echo |
|
118 "<tr> |
|
119 <td>Arbeitsgruppe</td> |
|
120 <td><select name=\"ma[rag]\">"; |
|
121 if ($ma['rag'] == -1) $select = " selected "; else $select = ""; |
|
122 echo "<option $select value=\"-1\"></option>\n"; |
|
123 $sql = "SELECT rag_ID, rag_bez, abt_name FROM RaumArb_Gruppe g INNER JOIN Abteilung a |
|
124 ON g.abt_ID = a.abt_ID ORDER BY g.abt_ID,rag_ID"; |
|
125 if ($result = $dbc->queryObjectArray($sql)) |
|
126 { |
|
127 foreach ($result as $row) |
|
128 { |
|
129 if ($row->rag_ID == $ma['rag']) |
|
130 { |
|
131 echo "<option selected value=\"$row->rag_ID\">$row->abt_name: $row->rag_bez</option>\n"; |
|
132 } |
|
133 else |
|
134 echo "<option value=\"$row->rag_ID\">$row->abt_name: $row->rag_bez</option>\n"; |
|
135 } |
|
136 } |
|
137 echo |
|
138 "</select> |
|
139 </td> |
|
140 </tr>"; |
|
141 */ |
|
142 ?> |
|
143 <tr> |
|
144 <td>Telefon</td> |
|
145 <td><div id="addtel"> |
|
146 <select name="ma[tel][]" size="1"> |
|
147 <?php |
|
148 $select = null; |
|
149 $select = ( "-1"==$ma['tel'][0] ) ? " selected='selected'" : ""; |
|
150 echo "<option $select value=\"-1\"></option>\n"; |
|
151 /* $sql = "SELECT telefon_nr,geb_ID,raum_nr, telefon_typ FROM fhiiqm.Telefon t |
|
152 LEFT OUTER JOIN Raum r ON t.raum_ID=r.Raum_ID |
|
153 ORDER BY telefon_nr"; */ |
|
154 $sql = "SELECT telefon_nr, telefon_typ FROM fhiiqm.Telefon |
|
155 ORDER BY telefon_nr"; |
|
156 if ($result = $dbc->queryObjectArray($sql)) |
|
157 { |
|
158 foreach ($result as $row) |
|
159 { |
|
160 if ($row->telefon_typ == "fax") $teln = $row->telefon_nr." FAX"; else $teln = $row->telefon_nr; |
|
161 // if ($row->raum_nr) $telr = "[". $row->geb_ID. " ". $row->raum_nr . "]"; else $telr = ""; |
|
162 $select = ( $row->telefon_nr==$ma['tel'][0] ) ? " selected='selected'" : ""; |
|
163 echo "<option $select value=\"$row->telefon_nr\">$teln</option>\n"; |
|
164 // $tel .= "'".$row->telefon_nr. "':'" . $teln ." ". $telr. "',"; |
|
165 $tel .= "'".$row->telefon_nr. "':'" . $teln . "',"; |
|
166 } |
|
167 } |
|
168 $tel = substr($tel,0,strlen($tel)-1); |
|
169 ?> |
|
170 </select> |
|
171 <script type="text/javascript"> |
|
172 <!-- |
|
173 arr = {<?php echo ($tel); ?>}; // Ergebnis: {key:'value',key:'value',...} |
|
174 //--> |
|
175 </script> |
|
176 oder neu <input name="ma[ntel][]" type="text" size="20" maxlength="20" value="<?php echo $ma['ntel'][0]; ?>" /> |
|
177 Priorität <select name="ma[so][]" size="1"> |
|
178 <?php |
|
179 $select = ($ma["so"][0] == '-1')? " selected='selected'" : ""; |
|
180 echo "<option$select value=-1></option>\n"; |
|
181 for ($i=1; $i<10; $i++) |
|
182 { |
|
183 $select=($ma["so"][0] == $i)? " selected='selected'" : ""; |
|
184 echo "<option$select value=$i>$i</option>\n"; |
|
185 } |
|
186 ?> |
|
187 </select> |
|
188 öffentlich <input name="ma[pub][]" type="checkbox" value="1" <?php if ($ma['pub'][0]) echo "checked"; ?> /> |
|
189 <a href="<?php echo "javascript:addInput('addtel');" ?>" title="weitere Telefon-Nr."><img src="/fhiiqm/img/add.png" /></a> |
|
190 <a href="<?php echo "javascript:delInput('addtel');" ?>" title="löschen letzte Telefon-Nr."><img src="/fhiiqm/img/delete.png" /></a><br /> |
|
191 <?php |
|
192 if (isset($ma) && (!$ok || $sub)) |
|
193 { |
|
194 if (count($ma['ntel'])>1 || count($ma['tel'])>1) |
|
195 { |
|
196 $i=0; |
|
197 foreach ($ma['tel'] as $atel) |
|
198 { |
|
199 if ($i>0) |
|
200 { |
|
201 echo "<span></span><select name=\"ma[tel][]\" size=\"1\">"; |
|
202 |
|
203 $select = ( "-1" == $atel ) ? ' selected' : null; |
|
204 echo "<option $select value=\"-1\"></option>\n"; |
|
205 foreach ($result as $row) |
|
206 { |
|
207 if ($row->telefon_typ == "fax") $teln = $row->telefon_nr." FAX"; else $teln = $row->telefon_nr; |
|
208 // if ($row->raum_nr) $telr = "[". $row->geb_ID. " ". $row->raum_nr . "]"; else $telr = ""; |
|
209 $select = ( $row->telefon_nr == $atel ) ? ' selected' : null; |
|
210 echo "<option $select value=\"$row->telefon_nr\">$teln</option>\n"; |
|
211 } |
|
212 echo "</select>"; |
|
213 echo " oder neu <input name=\"ma[ntel][]\" type=\"text\" size=\"20\" maxlength=\"20\" value=\"".$ma['ntel'][$i]."\" />"; |
|
214 echo " Priorität <select name=\"ma[so][]\" size=\"1\">"; |
|
215 |
|
216 $select = ( $ma["so"][$i] == "-1" ) ? " selected='selected'" : ""; |
|
217 echo "<option$select value=\"-1\"></option>\n"; |
|
218 for ($j=1; $j<10; $j++) |
|
219 { |
|
220 $select=($ma["so"][$i] == $j)? " selected='selected'" : ""; |
|
221 echo "<option$select value=$j>$j</option>\n"; |
|
222 } |
|
223 echo "</select>\n"; |
|
224 echo " öffentlich <input name=\"ma[pub][$i]\" type=\"checkbox\" value=\"1\""; |
|
225 $check = ($ma['pub'][$i]) ? " checked='checked'" : "" ; |
|
226 echo "$check /><br />\n"; |
|
227 } |
|
228 $i++; |
|
229 } |
|
230 } |
|
231 } |
|
232 ?> |
|
233 </div> |
|
234 </td> |
|
235 </tr> |
|
236 <?php if ($ma["fhi"]) { ?> |
|
237 <tr> |
|
238 <td>E-Mail</td> |
|
239 <td><input name="ma[email]" id="email" type="text" size="30" maxlength="100" value="<?php echo $ma['email']; ?>" /></td> |
|
240 </tr> |
|
241 <?php } ?> |
|
242 <tr><td>Abteilung *</td> |
|
243 <td valign="top"><div id="addabt"> |
|
244 <select name="ma[abt][]" onchange="this.form.submit();"> |
|
245 <?php |
|
246 $sql = "SELECT abt_ID, abt_name, abt_long FROM `fhiiqm`.`Abteilung` ORDER BY abt_ID+0"; |
|
247 if ($result = $dbc->queryObjectArray($sql)) |
|
248 { |
|
249 foreach ($result as $row) |
|
250 { |
|
251 if ($row->abt_ID == $ma['abt'][0]) |
|
252 echo "<option selected value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n"; |
|
253 else |
|
254 echo "<option value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n"; |
|
255 $abt .= "'".$row->abt_ID. "':'" . $row->abt_name .": ". $row->abt_long . "',"; |
|
256 } |
|
257 $abt = substr($abt,0,strlen($abt)-1); |
|
258 } |
|
259 ?> |
|
260 </select> |
|
261 |
|
262 Arbeitsgruppe |
|
263 <select name="ma[rag][]"> |
|
264 <?php |
|
265 if ($ma['rag'] == -1) $select = " selected "; else $select = ""; |
|
266 echo "<option $select value=\"-1\"></option>\n"; |
|
267 $sql = "SELECT rag_ID, rag_bez FROM `fhiiqm`.`RaumArb_Gruppe` WHERE abt_ID = " .$ma["abt"][0] . " ORDER BY rag_bez"; |
|
268 if ($resrag = $dbc->queryObjectArray($sql)) |
|
269 { |
|
270 foreach ($resrag as $row) |
|
271 { |
|
272 if ($row->rag_ID == $ma['rag'][0]) |
|
273 echo "<option selected value=\"$row->rag_ID\">$row->rag_bez</option>\n"; |
|
274 else |
|
275 echo "<option value=\"$row->rag_ID\">$row->rag_bez</option>\n"; |
|
276 // $rag .= "'".$row->rag_ID. "':'" . $row->rag_bez . "',"; |
|
277 } |
|
278 // $rag = substr($rag,0,strlen($rag)-1); |
|
279 } |
|
280 $sql = "SELECT rag_ID, rag_bez, abt_name, g.abt_ID FROM RaumArb_Gruppe g INNER JOIN Abteilung a |
|
281 ON g.abt_ID = a.abt_ID ORDER BY g.abt_ID,rag_ID"; |
|
282 if ($res = $dbc->queryObjectArray($sql)) |
|
283 { |
|
284 foreach ($res as $row) |
|
285 { |
|
286 $faktor = ($row->abt_ID*1000)+$row->rag_ID; // wegen sort nach Abt. fuer JS, z.B. 7047 |
|
287 $rag .= "'".$faktor. "':'" . $row->abt_name . ": ". $row->rag_bez . "',"; |
|
288 } |
|
289 $rag = substr($rag,0,strlen($rag)-1); |
|
290 } |
|
291 ?> |
|
292 </select> |
|
293 <script type="text/javascript"> |
|
294 <!-- |
|
295 arra = {<?php echo ($abt); ?>}; // Ergebnis: {key:'value',key:'value',...} |
|
296 arrg = {<?php echo ($rag); ?>}; // Ergebnis: {key:'value',key:'value',...} |
|
297 //--> |
|
298 </script> |
|
299 <a href="<?php echo "javascript:addInput('addabt');" ?>" title="weitere Arbeitsgruppe"><img src="/fhiiqm/img/add.png" /></a> |
|
300 <a href="<?php echo "javascript:delInput('addabt');" ?>" title="löschen letzte Arbeitsgruppe"><img src="/fhiiqm/img/delete.png" /></a><br /> |
|
301 <?php |
|
302 if (isset($ma) && (!$ok || $sub)) |
|
303 { |
|
304 if (count($ma['abt'])>1 || count($ma['rag'])>1) |
|
305 { |
|
306 $i=0; |
|
307 foreach ($ma['abt'] as $eabt) |
|
308 { |
|
309 if ($i>0) |
|
310 { |
|
311 echo "<span></span><select name=\"ma[abt][]\" size=\"1\">"; |
|
312 |
|
313 foreach ($result as $row) |
|
314 { |
|
315 $select = ( $row->abt_ID == $eabt ) ? ' selected' : null; |
|
316 echo "<option $select value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n"; |
|
317 } |
|
318 echo "</select>"; |
|
319 echo " Arbeitsgruppe "; |
|
320 echo "<select name='ma[rag][]' size=1>"; |
|
321 $select = ( $ma["rag"][$i] == "-1" ) ? " selected='selected'" : ""; |
|
322 echo "<option$select value=\"-1\"></option>\n"; |
|
323 foreach ($res as $row) |
|
324 { |
|
325 $select = ( $row->rag_ID == $ma['rag'][$i] ) ? ' selected' : null; |
|
326 echo "<option $select value=\"$row->rag_ID\">$row->abt_name: $row->rag_bez</option>\n"; |
|
327 } |
|
328 echo "</select>"; |
|
329 echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' /><br />\n"; |
|
330 } |
|
331 $i++; |
|
332 } |
|
333 } |
|
334 } |
|
335 ?> |
|
336 </div> |
|
337 </td> |
|
338 </tr> |
|
339 <?php |
|
340 if ($ma["tstmp"] && $ma["tstmp"]>0) |
|
341 { |
|
342 echo "<tr><td>letzte Änderung</td>"; |
|
343 $ts = new DateTime($ma["tstmp"]); |
|
344 echo "<td>".$ts->format('d.m.Y H:i:s'); |
|
345 } |
|
346 if (isset($ma["uid"]) && $ma["uid"]) |
|
347 echo " (".$ma["uid"] .")"; |
|
348 echo "</td></tr>\n"; |
|
349 ?> |
|
350 <input type="hidden" name="ma[abtm]" value="<?php echo $ma['abtm']; ?>" /> |
|
351 <input type="hidden" name="okn" value="<?php echo $okn; ?>" /> |
|
352 <!-- |
|
353 </table> |
|
354 </div> |
|
355 </form> |
|
356 --> |