|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 07/2012 |
|
6 * |
|
7 * Form Info Betriebsstoerung |
|
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 <h5>* - Felder sind erforderlich!</h5> |
|
17 </div> |
|
18 <!-- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_svc"> --> |
|
19 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_info" target="_self"> |
|
20 <div align="center"> |
|
21 <table width="60%" border="0" cellspacing="3" cellpadding="3"> |
|
22 <tr> |
|
23 <td>Titel *<br/><br /> |
|
24 max. 300 Zeichen möglich</td> |
|
25 <td><textarea name="inf[iname]" id="titel" cols="50" rows="2"><?php echo $inf['iname']; ?></textarea> |
|
26 <?php |
|
27 if (isset($inf['iname']) && $inf['iname']<'!') |
|
28 { |
|
29 echo "<br><span class=\"red\">Titel ist erforderlich!</span>\n"; |
|
30 $okn = false; |
|
31 } |
|
32 if ($infid) |
|
33 { |
|
34 echo " Info-ID"; |
|
35 echo " <input class='read right' name='inf[infid]' type='text' size='5' value='" .$inf['infid']."' readonly='readonly' />"; |
|
36 } |
|
37 ?> |
|
38 </td> |
|
39 </tr> |
|
40 <tr> |
|
41 <td>Kurzinformation<br/><br /> |
|
42 max. 8000 Zeichen möglich<br /><br /> |
|
43 erforderlich für <br /> |
|
44 Geschäftsverteilungsplan |
|
45 </td> |
|
46 <td><textarea name="inf[ilong]" cols="80" rows="6"><?php echo $inf['ilong']; ?></textarea> |
|
47 </td> |
|
48 </tr> |
|
49 <?php if ($ityp != 8) |
|
50 { ?> |
|
51 <tr> |
|
52 <td>Kennzeichen(Sort.)</td> |
|
53 <td><input name="inf[sort]" type="text" size="10" maxlength="10" value="<?php echo $inf['sort']; ?>" /></td> |
|
54 </tr> |
|
55 <?php |
|
56 } ?> |
|
57 <tr><td>gehört zu Info</td> |
|
58 <td><select name="inf[infrel]"> |
|
59 <?php |
|
60 if ($inf['infid'] == -1) $select = " selected "; else $select = ""; |
|
61 echo "<option $select value=\"-1\"></option>\n"; |
|
62 if (isset($inf["infid"]) && $inf["infid"]>0) $where = " WHERE info_ID != " . $inf["infid"]; else $where=""; |
|
63 $sql = "SELECT info_ID, LEFT(info_name_s,50) AS iname FROM Info $where ORDER BY 2"; |
|
64 if ($result = $dbc -> queryObjectArray($sql)) |
|
65 { |
|
66 foreach ($result as $row) |
|
67 { |
|
68 if ($row->info_ID == $inf['infrel']) |
|
69 echo "<option selected value=\"$row->info_ID\">$row->info_ID - $row->iname</option>\n"; |
|
70 else |
|
71 echo "<option value=\"$row->info_ID\">$row->info_ID - $row->iname</option>\n"; |
|
72 } |
|
73 } |
|
74 ?> |
|
75 </select> |
|
76 </td> |
|
77 </tr> |
|
78 <tr> |
|
79 <td>Info-Typ</td> |
|
80 <td><select name="inf[ityp]"> |
|
81 <?php |
|
82 if (!$ityp) |
|
83 { |
|
84 $wher = ""; |
|
85 if ($inf['ityp'] == -1) $select = " selected "; else $select = ""; |
|
86 echo "<option $select value=\"-1\"></option>\n"; |
|
87 } |
|
88 else $wher = " WHERE infotyp_ID = $ityp"; |
|
89 $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ $wher ORDER BY 2"; |
|
90 if ($result = $dbc->queryObjectArray($sql)) |
|
91 { |
|
92 foreach ($result as $row) |
|
93 { |
|
94 if ($row->infotyp_ID == $inf['ityp']) |
|
95 echo "<option selected value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n"; |
|
96 else |
|
97 echo "<option value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n"; |
|
98 } |
|
99 } |
|
100 ?> |
|
101 </select> |
|
102 </td> |
|
103 </tr> |
|
104 <tr><td>Ort</td> |
|
105 <td valign="top">Haus |
|
106 <select name="inf[geb]" onchange="this.form.submit();"> |
|
107 <?php |
|
108 if ($inf['geb'] == -1) $select = " selected "; else $select = ""; |
|
109 echo "<option $select value=\"-1\"></option>\n"; |
|
110 $sql = "SELECT geb_ID, geb_name FROM `fhiiqm`.`Haus` ORDER BY 1"; |
|
111 if ($result = $dbc->queryObjectArray($sql)) |
|
112 { |
|
113 foreach ($result as $row) |
|
114 { |
|
115 if ($row->geb_ID == $inf['geb']) |
|
116 echo "<option selected value=\"$row->geb_ID\">$row->geb_ID: $row->geb_name</option>\n"; |
|
117 else |
|
118 echo "<option value=\"$row->geb_ID\">$row->geb_ID: $row->geb_name</option>\n"; |
|
119 } |
|
120 } |
|
121 ?> |
|
122 </select> |
|
123 Raum |
|
124 <select name="inf[raum]"> |
|
125 <?php |
|
126 if (!$inf['geb']) $wher = ""; else $wher = " WHERE geb_ID = '".$inf['geb']."'"; |
|
127 if ($inf['raum'] == -1) $select = " selected "; else $select = ""; |
|
128 echo "<option $select value=\"-1\"></option>\n"; |
|
129 $sql = "SELECT raum_ID, raum_nr, raum_name, geb_ID FROM `fhiiqm`.`Raum` $wher ORDER BY 4,2"; |
|
130 if ($result = $dbc->queryObjectArray($sql)) |
|
131 { |
|
132 foreach ($result as $row) |
|
133 { |
|
134 if ($row->raum_ID == $inf['raum']) |
|
135 echo "<option selected value=\"$row->raum_ID\">$row->geb_ID: $row->raum_nr $row->raum_name</option>\n"; |
|
136 else |
|
137 echo "<option value=\"$row->raum_ID\">$row->geb_ID: $row->raum_nr $row->raum_name</option>\n"; |
|
138 } |
|
139 } |
|
140 ?> |
|
141 </select> |
|
142 </td> |
|
143 </tr> |
|
144 <tr> |
|
145 <td>Erstellungsdatum *</td> |
|
146 <?php if (!$sub && !$del && !$dup && !$infid) $inf['cdat'] = date('Y-m-d'); |
|
147 ?> |
|
148 <td><input class="long10" name="inf[cdat]" id="cdat" value="<?php echo $inf['cdat']; ?>" /> |
|
149 <?php |
|
150 if (isset($inf['cdat']) && $inf['cdat']< "!") |
|
151 { |
|
152 echo "<br><span class=\"red\">Erstellungsdatum ist erforderlich!</span>\n"; |
|
153 $okn = false; |
|
154 } |
|
155 ?> |
|
156 </td> |
|
157 </tr> |
|
158 <tr> |
|
159 <td>gültig ab</td> |
|
160 <td><input class="long10" name="inf[vdat]" id="vdat" value="<?php echo $inf['vdat']; ?>" /></td> |
|
161 </tr> |
|
162 <tr> |
|
163 <td>gültig bis</td> |
|
164 <td><input class="long10" name="inf[bdat]" id="bdat" value="<?php echo $inf['bdat']; ?>" /></td> |
|
165 </tr> |
|
166 <tr><td>Status Freigabe</td> |
|
167 <td><select name="inf[fg]" size="1"> |
|
168 <?php |
|
169 if (!isset($inf["fg"])) $inf["fg"] = 1; |
|
170 if ($inf['fg']) $select = ( "-1" == $inf['fg'] ) ? ' selected' : null; |
|
171 echo "<option $select value=\"-1\"></option>\n"; |
|
172 $sql = "SELECT info_freigabe_ID, info_freigabe_bez FROM Info_Freigabe ORDER BY 2"; |
|
173 if ($result = $dbc -> queryObjectArray($sql)) |
|
174 { |
|
175 foreach ($result as $row) |
|
176 { |
|
177 if ($inf['fg']) $select = ( $row->info_freigabe_ID == $inf['fg'] ) ? ' selected' : null; |
|
178 echo "<option $select value=\"$row->info_freigabe_ID\">$row->info_freigabe_bez</option>\n"; |
|
179 } |
|
180 } |
|
181 ?> |
|
182 </select> |
|
183 </td> |
|
184 </tr> |
|
185 <tr> |
|
186 <td>Autor</td> |
|
187 <td><input class="long20" type="text" name="inf[persknr]" id="persknr" value="<?php echo $inf['persknr']; ?>"/> |
|
188 Eingabe von mind. 2 Zeichen -> Namensliste |
|
189 </td> |
|
190 </tr> |
|
191 <tr><td>Sprache</td> |
|
192 <td><select name="inf[lang]"> |
|
193 <?php |
|
194 if (!$sub && !$del && !$dup && !$infid) $inf['lang'] = 'de'; |
|
195 if ($inf['lang'] == -1) $select = " selected "; else $select = ""; |
|
196 echo "<option $select value=\"-1\"></option>\n"; |
|
197 $alang = array("de"=>"deutsch","en"=>"englisch"); |
|
198 foreach ($alang as $key=>$value) |
|
199 { |
|
200 if ($inf['lang'] == $key) $select = " selected "; else $select = ""; |
|
201 echo "<option $select value=\"$key\">$value</option>\n"; |
|
202 } |
|
203 ?> |
|
204 </select></td> |
|
205 </tr> |
|
206 <tr> |
|
207 <td>zugeordnet zu Produkt<br /><br /> |
|
208 Mehrfachauswahl möglich:<br /> |
|
209 [Strg]-Taste + Anklicken der<br /> |
|
210 gewünschten Listeneinträge</td> |
|
211 <td> |
|
212 <select name="inf[prid][]" size="9" multiple="multiple"> |
|
213 <?php |
|
214 if (is_array($inf['prid'])) $select = in_array( "-1", $inf['prid'] ) ? ' selected' : null; |
|
215 echo "<option $select value=\"-1\"></option>\n"; |
|
216 // $sql = "SELECT produkt_ID, LEFT(prod_name,70) AS prod, LENGTH(prod_name) AS lenp FROM Produkt ORDER BY 2"; |
|
217 if ($ityp == 7) $sql = "CALL prod_hiera_all(4,41)"; |
|
218 elseif (substr($ityp,0,1) == 8) $sql = "CALL prod_hiera_all(1,15)"; |
|
219 if ($result = $dbc->queryObjectArray($sql)) |
|
220 { |
|
221 foreach ($result as $row) |
|
222 { |
|
223 if (strlen($row->bez) > 70) |
|
224 $prod=str_replace(" "," ",htmlentities(substr($row->bez,0,70))) ."..."; |
|
225 else |
|
226 $prod=str_replace(" "," ",htmlentities($row->bez)); |
|
227 if ($row->prid >0) $color=" class='green'"; else $color=""; |
|
228 if (is_array($inf['prid'])) $select = in_array($row->prid, $inf['prid']) ? ' selected' : null; |
|
229 echo "<option $color $select value=\"$row->prid\">$prod</option>\n"; |
|
230 } |
|
231 } |
|
232 unset($result); |
|
233 ?> |
|
234 </select> |
|
235 <br />bitte nur die <font color="green">grünen</font> Einträge wählen |
|
236 </td> |
|
237 </tr> |
|
238 <?php if (substr($ityp,0,1) != 8) // 8 - Betriebsanweisung |
|
239 { ?> |
|
240 <tr><td>Adressat (Beauftragte)<br /> |
|
241 leeres Feld = Löschen</td> |
|
242 <td> |
|
243 <div id="add"> |
|
244 <select name="inf[adr][]" size="1"> |
|
245 <?php |
|
246 $select = ( "-1" == $inf['adr'][0] ) ? ' selected' : null; |
|
247 echo "<option $select value=\"-1\"></option>\n"; |
|
248 $sql = "SELECT fkt_ID, fkt_bez FROM Funktion ORDER BY 2"; |
|
249 if ($result = $dbc -> queryObjectArray($sql)) |
|
250 { |
|
251 foreach ($result as $row) |
|
252 { |
|
253 $select = ( $row->fkt_ID == $inf['adr'][0] ) ? ' selected' : null; |
|
254 echo "<option $select value=\"$row->fkt_ID\">$row->fkt_ID - $row->fkt_bez</option>\n"; |
|
255 $sf .= "'".$row->fkt_ID."':'".$row->fkt_bez."',"; |
|
256 } |
|
257 } |
|
258 $sf = substr($sf,0,strlen($sgf)-1); |
|
259 ?> |
|
260 </select> |
|
261 <script type="text/javascript"> |
|
262 <!-- |
|
263 arr = {<?php echo ($sf); ?>}; // Ergebnis: {'key':'value','key':'value',...} |
|
264 //--> |
|
265 </script> |
|
266 |
|
267 <a href="<?php echo "javascript:addInput('add');" ?>" title="weiterer Adressat"><img src="/fhiiqm/img/add.png" /></a> |
|
268 <a href="<?php echo "javascript:delInput('add');" ?>" title="löschen letzter Adressat"><img src="/fhiiqm/img/delete.png" /></a><br /> |
|
269 <?php |
|
270 if ($infid || ($sub && isset($inf) && !$ok)) |
|
271 { |
|
272 if (count($inf['adr'])>1) |
|
273 { |
|
274 $i=0; |
|
275 foreach ($inf['adr'] as $fe) |
|
276 { |
|
277 if ($i>0) |
|
278 { |
|
279 echo "<select name=\"inf[adr][]\" size=\"1\">"; |
|
280 |
|
281 $select = ( "-1" == $fe ) ? ' selected' : null; |
|
282 echo "<option $select value=\"-1\"></option>\n"; |
|
283 foreach ($result as $row) |
|
284 { |
|
285 $select = ( $row->fkt_ID == $fe ) ? ' selected' : null; |
|
286 echo "<option $select value=\"$row->fkt_ID\">$row->fkt_ID - $row->fkt_bez</option>\n"; |
|
287 } |
|
288 echo "</select><br/>\n"; |
|
289 } |
|
290 $i++; |
|
291 } |
|
292 } |
|
293 } |
|
294 ?> |
|
295 </div> |
|
296 </td> |
|
297 </tr> |
|
298 <?php |
|
299 } |
|
300 if ($ityp == 81) // Betriebsanweisung Anlage |
|
301 { |
|
302 echo "<tr> |
|
303 <td>gehört zu Anlage</td>"; |
|
304 echo " <td> |
|
305 <select name=\"inf[anl]\" size=\"1\">"; |
|
306 $sql = "SELECT al_ID,al_bez,al_kat_bez FROM fhiiqm.Anlage a |
|
307 LEFT JOIN A_Kategorie k ON a.al_kat_ID=k.al_kat_ID WHERE a.al_kat_ID < 6"; |
|
308 $select = ( "-1" == $inf['adr'][0] ) ? ' selected' : null; |
|
309 echo "<option $select value=\"-1\"></option>\n"; |
|
310 if ($result = $dbc -> queryObjectArray($sql)) |
|
311 { |
|
312 foreach ($result as $row) |
|
313 { |
|
314 $select = ( $row->al_ID == $inf['anl']) ? ' selected' : null; |
|
315 echo "<option $select value=\"$row->al_ID\">$row->al_bez ($row->al_kat_bez)</option>\n"; |
|
316 } |
|
317 } |
|
318 echo " </select> |
|
319 </td> |
|
320 </tr>\n"; |
|
321 } |
|
322 ?> |
|
323 |
|
324 <tr> |
|
325 <td>Dateibezeichnung Dokument (*)</td> |
|
326 <td><input name="inf[ifname]" type="text" size="50" maxlength="50" value="<?php echo $inf['ifname']; ?>" /> |
|
327 <?php |
|
328 echo "<br />bitte <u>keine</u> Umlaute im Dateinamen angeben!"; |
|
329 if (isset($inf['ifname']) && $upd && is_uploaded_file($_FILES["ifile"]["tmp_name"]) && $inf['ifname']<'!') |
|
330 { |
|
331 echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n"; |
|
332 $okn = false; |
|
333 } |
|
334 else |
|
335 { |
|
336 if ($inf['ifname']>='!' && file_exists("infos/".$inf['ifname'])) |
|
337 echo "<br />Dokument anschauen: <a href='infos/" . $inf['ifname'] ."'>" . $inf['ifname'] . "</a>"; |
|
338 if ($okn) $okn = true; else $okn=false; |
|
339 } |
|
340 ?> |
|
341 </td> |
|
342 </tr> |
|
343 |
|
344 <input type="hidden" name="inf[pers]" id="pid" value="<?php echo $inf['pers']; // Author ?>"/> |
|
345 <input type="hidden" name="MAX_FILE_SIZE" value="6000000"/> |
|
346 <input type="hidden" name="inf[okn]" value="<?php echo $okn; ?>"/> |
|
347 <!-- </table> |
|
348 </div> |
|
349 </form> --> |