|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 08/2011 |
|
6 * |
|
7 * Form Info |
|
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 |
|
14 ?> |
|
15 <div align="center"> |
|
16 <?php |
|
17 if (strpos($_SERVER['PHP_SELF'],"ins") > -1) $text = "Eingabe"; else $text="Ändern / Löschen"; |
|
18 ?> |
|
19 <h3><font face="Verdana, Arial, Helvetica, sans-serif"><?php echo $text;?> Informationen </font></h3> |
|
20 <h5>* - Felder sind erforderlich!</h5> |
|
21 </div> |
|
22 <!-- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_svc"> --> |
|
23 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_info" target="_self"> |
|
24 <div align="center"> |
|
25 <table width="50%" border="0" cellspacing="3" cellpadding="3"> |
|
26 <tr> |
|
27 <td>Titel *</td> |
|
28 <td><textarea name="inf[iname]" cols="50" rows="2"><?php echo $inf['iname']; ?></textarea> |
|
29 <?php |
|
30 if (isset($inf['iname']) && $inf['iname']<'!') |
|
31 { |
|
32 echo "<br><span class=\"red\">Titel ist erforderlich!</span>\n"; |
|
33 $okn = false; |
|
34 } |
|
35 ?> |
|
36 <div>max. 300 Zeichen sind möglich</div></td> |
|
37 </tr> |
|
38 <tr> |
|
39 <td>Kurzinformation</td> |
|
40 <td><textarea name="inf[ilong]" cols="50" rows="10"><?php echo $inf['ilong']; ?></textarea> |
|
41 </td> |
|
42 </tr> |
|
43 <tr> |
|
44 <td>Info-Typ</td> |
|
45 <td><select name="inf[ityp]"> |
|
46 <?php |
|
47 if ($inf['ityp'] == -1) $select = " selected "; else $select = ""; |
|
48 echo "<option $select value=\"-1\"></option>\n"; |
|
49 $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ ORDER BY 2"; |
|
50 if ($result = $dbc->queryObjectArray($sql)) |
|
51 { |
|
52 foreach ($result as $row) |
|
53 { |
|
54 if ($row->infotyp_ID == $inf['ityp']) |
|
55 echo "<option selected value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n"; |
|
56 else |
|
57 echo "<option value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n"; |
|
58 } |
|
59 } |
|
60 ?> |
|
61 </select> |
|
62 </td> |
|
63 </tr> |
|
64 <tr> |
|
65 <td>Erstellungsdatum *</td> |
|
66 <td align="left"><select name="inf[itag]" size="1"> |
|
67 <?php |
|
68 if (!$inf['itag'] ) $ta1=date('d'); else $ta1 = $inf['itag']; |
|
69 for ($i=1; $i<32; $i++) |
|
70 { if ($i==intval($ta1)) |
|
71 { |
|
72 if ($i == 0) |
|
73 echo "<option selected></option>\n"; |
|
74 else |
|
75 echo "<option selected>$ta1</option>\n"; |
|
76 } |
|
77 else { |
|
78 if ($i<10) |
|
79 { |
|
80 if ($i == 0) |
|
81 echo "<option></option>\n"; |
|
82 else |
|
83 echo "<option>0$i</option>\n"; |
|
84 } |
|
85 else |
|
86 echo "<option>$i</option>\n"; |
|
87 } |
|
88 } |
|
89 ?> |
|
90 </select>. |
|
91 <select name="inf[imon]" size="1"> |
|
92 <?php |
|
93 if (!$inf['imon'] ) $mo1=date('m'); else $mo1 = $inf['imon']; |
|
94 for ($i=1; $i<13; $i++) |
|
95 { if ($i==intval($mo1)) |
|
96 { |
|
97 if ($i == 0) |
|
98 echo "<option selected></option>\n"; |
|
99 else |
|
100 echo "<option selected>$mo1</option>\n"; |
|
101 } |
|
102 else { |
|
103 if ($i<10) |
|
104 { |
|
105 if ($i == 0) |
|
106 echo "<option></option>\n"; |
|
107 else |
|
108 echo "<option>0$i</option>\n"; |
|
109 } |
|
110 else |
|
111 echo "<option>$i</option>\n"; |
|
112 } |
|
113 } |
|
114 ?> |
|
115 </select>. |
|
116 <select name="inf[ijahr]" size="1"> |
|
117 <?php |
|
118 |
|
119 if (!$inf['ijahr'] ) |
|
120 $ja1 = date('Y') . "</option>\n"; |
|
121 else |
|
122 $ja1 = $inf['ijahr']; |
|
123 for ($i=2000; $i<2036; $i++) |
|
124 { if ($i==intval($ja1)) |
|
125 echo "<option selected>$ja1</option>\n"; |
|
126 else |
|
127 echo "<option>$i</option>\n"; |
|
128 } |
|
129 ?> |
|
130 </select> |
|
131 </td> |
|
132 </tr> |
|
133 <tr> |
|
134 <td>gültig ab</td> |
|
135 <td align="left"><select name="inf[btag]" size="1"> |
|
136 <?php |
|
137 if (!$inf['btag'] ) $ta1=0; else $ta1 = $inf['btag']; |
|
138 for ($i=0; $i<32; $i++) |
|
139 { if ($i==intval($ta1)) |
|
140 { |
|
141 if ($i == 0) |
|
142 echo "<option selected></option>\n"; |
|
143 else |
|
144 echo "<option selected>$ta1</option>\n"; |
|
145 } |
|
146 else { |
|
147 if ($i<10) |
|
148 { |
|
149 if ($i == 0) |
|
150 echo "<option></option>\n"; |
|
151 else |
|
152 echo "<option>0$i</option>\n"; |
|
153 } |
|
154 else |
|
155 echo "<option>$i</option>\n"; |
|
156 } |
|
157 } |
|
158 ?> |
|
159 </select>. |
|
160 <select name="inf[bmon]" size="1"> |
|
161 <?php |
|
162 if (!$inf['bmon'] ) $mo1=0; else $mo1 = $inf['bmon']; |
|
163 for ($i=0; $i<13; $i++) |
|
164 { if ($i==intval($mo1)) |
|
165 { |
|
166 if ($i == 0) |
|
167 echo "<option selected></option>\n"; |
|
168 else |
|
169 echo "<option selected>$mo1</option>\n"; |
|
170 } |
|
171 else { |
|
172 if ($i<10) |
|
173 { |
|
174 if ($i == 0) |
|
175 echo "<option></option>\n"; |
|
176 else |
|
177 echo "<option>0$i</option>\n"; |
|
178 } |
|
179 else |
|
180 echo "<option>$i</option>\n"; |
|
181 } |
|
182 } |
|
183 ?> |
|
184 </select>. |
|
185 <select name="inf[bjahr]" size="1"> |
|
186 <?php |
|
187 |
|
188 if (!$inf['bjahr'] ) |
|
189 echo "<option selected></option>\n"; |
|
190 else |
|
191 echo "<option></option>\n"; |
|
192 $ja1 = $inf['bjahr']; |
|
193 for ($i=2000; $i<2036; $i++) |
|
194 { if ($i==intval($ja1)) |
|
195 echo "<option selected>$ja1</option>\n"; |
|
196 else |
|
197 echo "<option>$i</option>\n"; |
|
198 } |
|
199 ?> |
|
200 </select> |
|
201 </td> |
|
202 </tr> |
|
203 <tr> |
|
204 <td>gültig bis</td> |
|
205 <td align="left"><select name="inf[etag]" size="1"> |
|
206 <?php |
|
207 if (!$inf['etag'] ) $ta1=0; else $ta1 = $inf['etag']; |
|
208 for ($i=0; $i<32; $i++) |
|
209 { if ($i==intval($ta1)) |
|
210 { |
|
211 if ($i == 0) |
|
212 echo "<option selected></option>\n"; |
|
213 else |
|
214 echo "<option selected>$ta1</option>\n"; |
|
215 } |
|
216 else { |
|
217 if ($i<10) |
|
218 { |
|
219 if ($i == 0) |
|
220 echo "<option></option>\n"; |
|
221 else |
|
222 echo "<option>0$i</option>\n"; |
|
223 } |
|
224 else |
|
225 echo "<option>$i</option>\n"; |
|
226 } |
|
227 } |
|
228 ?> |
|
229 </select>. |
|
230 <select name="inf[emon]" size="1"> |
|
231 <?php |
|
232 if (!$inf['emon'] ) $mo1=0; else $mo1 = $inf['emon']; |
|
233 for ($i=0; $i<13; $i++) |
|
234 { if ($i==intval($mo1)) |
|
235 { |
|
236 if ($i == 0) |
|
237 echo "<option selected></option>\n"; |
|
238 else |
|
239 echo "<option selected>$mo1</option>\n"; |
|
240 } |
|
241 else { |
|
242 if ($i<10) |
|
243 { |
|
244 if ($i == 0) |
|
245 echo "<option></option>\n"; |
|
246 else |
|
247 echo "<option>0$i</option>\n"; |
|
248 } |
|
249 else |
|
250 echo "<option>$i</option>\n"; |
|
251 } |
|
252 } |
|
253 ?> |
|
254 </select>. |
|
255 <select name="inf[ejahr]" size="1"> |
|
256 <?php |
|
257 |
|
258 if (!$inf['ejahr'] ) |
|
259 echo "<option selected></option>\n"; |
|
260 else |
|
261 echo "<option></option>\n"; |
|
262 $ja1 = $inf['ejahr']; |
|
263 for ($i=2000; $i<2036; $i++) |
|
264 { if ($i==intval($ja1)) |
|
265 echo "<option selected>$ja1</option>\n"; |
|
266 else |
|
267 echo "<option>$i</option>\n"; |
|
268 } |
|
269 ?> |
|
270 </select> |
|
271 </td> |
|
272 </tr> |
|
273 <tr> |
|
274 <td>Autor</td> |
|
275 <td> |
|
276 <select name="inf[pers]" size="1"> |
|
277 <?php |
|
278 $select = $inf['pers'] == "-1" ? ' selected' : null; |
|
279 echo "<option $select value=\"-1\"></option>\n"; |
|
280 $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter ORDER BY 2"; |
|
281 if ($result = $dbc->queryObjectArray($sql)) |
|
282 { |
|
283 foreach ($result as $row) |
|
284 { |
|
285 $select = $row->persknr == $inf['pers'] ? ' selected' : null; |
|
286 echo "<option $select value=\"$row->persknr\">$row->pname</option>\n"; |
|
287 } |
|
288 } |
|
289 ?> |
|
290 </select> |
|
291 </td> |
|
292 </tr> |
|
293 <tr> |
|
294 <td>zugeordnet zu Produkt<br /><br /> |
|
295 Mehrfachauswahl möglich:<br /> |
|
296 [Strg]-Taste + Anklicken der<br /> |
|
297 gewünschten Listeneinträge</td> |
|
298 <td> |
|
299 <select name="inf[prid][]" size="8" multiple="multiple"> |
|
300 <?php |
|
301 if (is_array($inf['prid'])) $select = in_array( "-1", $inf['prid'] ) ? ' selected' : null; |
|
302 echo "<option $select value=\"-1\"></option>\n"; |
|
303 // $sql = "SELECT produkt_ID, LEFT(prod_name,70) AS prod, LENGTH(prod_name) AS lenp FROM Produkt ORDER BY 2"; |
|
304 $sql = "CALL prod_hiera_all(0,0)"; |
|
305 if ($result = $dbc->queryObjectArray($sql)) |
|
306 { |
|
307 foreach ($result as $row) |
|
308 { |
|
309 if (strlen($row->bez) > 70) |
|
310 $prod=str_replace(" "," ",htmlentities(substr($row->bez,0,70))) ."..."; |
|
311 else |
|
312 $prod=str_replace(" "," ",htmlentities($row->bez)); |
|
313 if ($row->prid >0) $color=" class='green'"; else $color=""; |
|
314 if (is_array($inf['prid'])) $select = in_array($row->prid, $inf['prid']) ? ' selected' : null; |
|
315 echo "<option $color $select value=\"$row->prid\">$prod</option>\n"; |
|
316 } |
|
317 } |
|
318 unset($result); |
|
319 ?> |
|
320 </select> |
|
321 <br />bitte nur die <font color="green">grünen</font> Einträge wählen |
|
322 </td> |
|
323 </tr> |
|
324 <tr><td>Adressat<br /><br /> |
|
325 Mehrfachauswahl möglich</td> |
|
326 <td><select name="inf[adr][]" size="4" multiple="multiple"> |
|
327 <?php |
|
328 if (is_array($inf['adr'])) $select = in_array( "-1", $inf['adr'] ) ? ' selected' : null; |
|
329 echo "<option $select value=\"-1\"></option>\n"; |
|
330 $sql = "SELECT info_adr_ID, info_adr_name FROM Adressat ORDER BY 2"; |
|
331 if ($result = $dbc -> queryObjectArray($sql)) |
|
332 { |
|
333 foreach ($result as $row) |
|
334 { |
|
335 if (is_array($inf['adr'])) $select = in_array( $row->info_adr_ID, $inf['adr'] ) ? ' selected' : null; |
|
336 echo "<option $select value=\"$row->info_adr_ID\">$row->info_adr_name</option>\n"; |
|
337 } |
|
338 } |
|
339 ?> |
|
340 </select> |
|
341 </td> |
|
342 </tr> |
|
343 <tr><td>gehört zu Info</td> |
|
344 <td><select name="inf[infrel]"> |
|
345 <?php |
|
346 if ($inf['adr'] == -1) $select = " selected "; else $select = ""; |
|
347 echo "<option $select value=\"-1\"></option>\n"; |
|
348 if (isset($inf["infid"]) && $inf["infid"]>0) $where = " WHERE info_ID != " . $inf["infid"]; else $where=""; |
|
349 $sql = "SELECT info_ID, LEFT(info_name_s,50) AS iname FROM Info $where ORDER BY 2"; |
|
350 if ($result = $dbc -> queryObjectArray($sql)) |
|
351 { |
|
352 foreach ($result as $row) |
|
353 { |
|
354 if ($row->info_ID == $inf['infrel']) |
|
355 echo "<option selected value=\"$row->info_ID\">$row->iname</option>\n"; |
|
356 else |
|
357 echo "<option value=\"$row->info_ID\">$row->iname</option>\n"; |
|
358 } |
|
359 } |
|
360 ?> |
|
361 </select> |
|
362 </td> |
|
363 </tr> |
|
364 <tr><td>Sprache</td> |
|
365 <td><select name="inf[lang]"> |
|
366 <?php |
|
367 if ($inf['lang'] == -1) $select = " selected "; else $select = ""; |
|
368 echo "<option $select value=\"-1\"></option>\n"; |
|
369 $alang = array("de"=>"deutsch","en"=>"englisch"); |
|
370 foreach ($alang as $key=>$value) |
|
371 { |
|
372 if ($inf['lang'] == $key) $select = " selected "; else $select = ""; |
|
373 echo "<option $select value=\"$key\">$value</option>\n"; |
|
374 } |
|
375 ?> |
|
376 </select></td> |
|
377 </tr> |
|
378 <tr> |
|
379 <td>Dateibezeichnung Dokument (*)</td> |
|
380 <td><input name="inf[ifname]" type="text" size="50" maxlength="50" value="<?php echo $inf['ifname']; ?>"> |
|
381 <?php |
|
382 echo "<br />bitte <u>keine</u> Umlaute im Dateinamen angeben!"; |
|
383 if (isset($inf['ifname']) && $upd && is_uploaded_file($_FILES["ifile"]["tmp_name"]) && $inf['ifname']<'!') |
|
384 { |
|
385 echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n"; |
|
386 $okn = false; |
|
387 } |
|
388 else |
|
389 { |
|
390 if ($inf['ifname']>='!' && file_exists("infos/".$inf['ifname'])) |
|
391 echo "<br />Dokument anschauen: <a href='infos/" . $inf['ifname'] ."'>" . $inf['ifname'] . "</a>"; |
|
392 if ($okn) $okn = true; else $okn=false; |
|
393 } |
|
394 ?> |
|
395 </td> |
|
396 </tr> |
|
397 |
|
398 <input type="hidden" name="inf[infid]" value="<?php echo $inf['infoid']; ?>"/> |
|
399 <input type="hidden" name="MAX_FILE_SIZE" value="6000000"/> |
|
400 <input type="hidden" name="inf[okn]" value="<?php echo $okn; ?>"/> |
|
401 <!-- </table> |
|
402 </div> |
|
403 </form> --> |