|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 03/2012 |
|
6 * |
|
7 * Form Prozess |
|
8 * |
|
9 */ |
|
10 |
|
11 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
|
12 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
|
13 $okn = true; |
|
14 |
|
15 |
|
16 echo "<div align=\"center\">"; |
|
17 |
|
18 ?> |
|
19 <h5>* - Felder sind erforderlich!</h5> |
|
20 </div> |
|
21 <!-- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_svc"> --> |
|
22 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_info" target="_self"> |
|
23 <div align="center"> |
|
24 <table width="60%" border="0" cellspacing="3" cellpadding="3"> |
|
25 <tr> |
|
26 <td>Projekt-Bezeichnung *</td> |
|
27 <td><input name="pz[bez]" id="bez" type="text" size="50" maxlength="50" value="<?php echo $pz['bez']; ?>" /> |
|
28 <?php |
|
29 if (isset($pz['bez']) && $pz['bez']<'!') |
|
30 { |
|
31 echo "<br><span class=\"red\">Projektbezeichnung ist erforderlich!</span>\n"; |
|
32 $okn = false; |
|
33 } |
|
34 if ($pzid) |
|
35 { |
|
36 echo " Projekt-ID"; |
|
37 echo " <input class='read right' name='pz[pzid]' type='text' size='5' value='" .$pz['pzid']."' readonly='readonly' />"; |
|
38 } |
|
39 ?> |
|
40 </td> |
|
41 </tr> |
|
42 <tr> |
|
43 <td>Projekt-Beschreibung</td> |
|
44 <td><textarea name="pz[bezl]" cols="80" rows="3"><?php echo $pz["bezl"]; ?></textarea> |
|
45 </td> |
|
46 </tr> |
|
47 <tr> |
|
48 <td>zugeordnet zu Produkt *</td> |
|
49 <td> |
|
50 <select name="pz[prid]" size="1"> |
|
51 <?php |
|
52 if (is_array($pz['prid'])) $select = in_array( "-1", $pz['prid'] ) ? ' selected' : null; |
|
53 echo "<option $select value=\"-1\"></option>\n"; |
|
54 /* $sql = "SELECT DISTINCT ip.produkt_ID,prod_name |
|
55 FROM Info i LEFT OUTER JOIN Info_Produkt ip |
|
56 ON i.info_ID=ip.info_ID LEFT OUTER JOIN Info_Verantwortlich v |
|
57 ON i.info_ID=v.info_ID INNER JOIN Produkt p |
|
58 ON ip.produkt_ID=p.produkt_ID INNER JOIN Mitarbeiter m |
|
59 ON v.persknr=m.persknr |
|
60 WHERE i.infotyp_ID=6 and v.persknr=$persknr |
|
61 ORDER BY ip.produkt_ID"; |
|
62 if ($result = $dbc->queryObjectArray($sql)) |
|
63 { |
|
64 foreach ($result as $row) |
|
65 { |
|
66 if (strlen($row->prod_name) > 70) |
|
67 $prod=str_replace(" "," ",htmlentities(substr($row->prod_name,0,70))) ."..."; |
|
68 else |
|
69 $prod=str_replace(" "," ",htmlentities($row->prod_name)); |
|
70 $select = ($row->produkt_ID == $pz['prid'] && $pz['prid']>0) ? ' selected' : null; |
|
71 echo "<option $select value=\"$row->produkt_ID\">$prod</option>\n"; |
|
72 } |
|
73 } |
|
74 */ |
|
75 // Recht Produktgruppe beruecksichtigen |
|
76 if (is_array($_SESSION["prodg"])) |
|
77 { |
|
78 foreach ($_SESSION["prodg"] as $val) |
|
79 $listg .= "," .$val; |
|
80 $listg = substr($listg,1); |
|
81 echo "prodg = $listg<br />"; |
|
82 $sql = "CALL fhiiqm.hier_prodgroup('$listg')"; |
|
83 } |
|
84 else |
|
85 $sql = "CALL fhiiqm.prod_hiera_all(0,0)"; |
|
86 if ($result = $dbc->queryObjectArray($sql)) |
|
87 { |
|
88 foreach ($result as $row) |
|
89 { |
|
90 if (strlen($row->bez) > 70) |
|
91 $prod=str_replace(" "," ",htmlentities(substr($row->bez,0,70))) ."..."; |
|
92 else |
|
93 $prod=str_replace(" "," ",htmlentities($row->bez)); |
|
94 if ($row->prid >0) $color=" class='green'"; else $color=""; |
|
95 if ($row->prid == $pz['prid']) |
|
96 echo "<option $color selected value=\"$row->prid\">$prod</option>\n"; |
|
97 else |
|
98 echo "<option $color value=\"$row->prid\">$prod</option>\n"; |
|
99 } |
|
100 } |
|
101 echo " |
|
102 </select>\n"; |
|
103 echo "<br />bitte 1 <font color='green'>grünen</font> Eintrag wählen"; |
|
104 |
|
105 if (isset($pz) && $pz['prid']<1) |
|
106 { |
|
107 echo "<br><span class=\"red\">Produktzuordnung muss erfolgen!</span>\n"; |
|
108 $okn = false; |
|
109 } |
|
110 ?> |
|
111 </td> |
|
112 </tr> |
|
113 <tr> |
|
114 <td>Auftraggeber</td> |
|
115 <td><input type="text" name="pz[persa]" id="persa" value="<?php echo $pz['persa']; ?>"/> |
|
116 Eingabe von mind. 2 Zeichen -> Namensliste |
|
117 </td> |
|
118 </tr> |
|
119 <tr> |
|
120 <td>Verantwortlicher</td> |
|
121 <td><input type="text" name="pz[pers]" id="pers" value="<?php echo $pz['pers']; ?>"/> |
|
122 Eingabe von mind. 2 Zeichen -> Namensliste |
|
123 </td> |
|
124 </tr> |
|
125 <tr><td>gehört zu Projekt</td> |
|
126 <td><select name="pz[pzref]"> |
|
127 <?php |
|
128 if ($pz['pzref'] == -1) $select = " selected "; else $select = ""; |
|
129 echo "<option $select value=\"-1\"></option>\n"; |
|
130 if (isset($pz["pzid"]) && $pz["pzid"]>0) $where = " WHERE proz_ID != " . $pz["pzid"]; else $where=""; |
|
131 $sql = "SELECT proz_ID, proz_bez FROM Prozess $where ORDER BY 2"; |
|
132 if ($result = $dbc -> queryObjectArray($sql)) |
|
133 { |
|
134 foreach ($result as $row) |
|
135 { |
|
136 if ($row->proz_ID == $pz['pzref']) |
|
137 echo "<option selected value=\"$row->proz_ID\">$row->proz_ID - $row->proz_bez</option>\n"; |
|
138 else |
|
139 echo "<option value=\"$row->proz_ID\">$row->proz_ID - $row->proz_bez</option>\n"; |
|
140 } |
|
141 } |
|
142 ?> |
|
143 </select> |
|
144 </td> |
|
145 </tr> |
|
146 <tr> |
|
147 <td>Plan Start-Datum</td> |
|
148 <td><input class="long10" name="pz[psdat]" id="psdat" value="<?php echo $pz['psdat']; ?>" /> |
|
149 Plan Ende-Datum |
|
150 <input class="long10" name="pz[pedat]" id="pedat" value="<?php echo $pz['pedat']; ?>" /> |
|
151 Plan Kosten (€) |
|
152 <input class='right' name="pz[pkost]" type="text" value="<?php echo $pz["pkost"]; ?>" /></td> |
|
153 </tr> |
|
154 <tr> |
|
155 <td>Start-Datum</td> |
|
156 <td><input class="long10" name="pz[sdat]" id="sdat" value="<?php echo $pz['sdat']; ?>" /> |
|
157 Ende-Datum |
|
158 <input class="long10" name="pz[edat]" id="edat" value="<?php echo $pz['edat']; ?>" /> |
|
159 Kosten (€) |
|
160 <input class='right' name="pz[kost]" type="text" value="<?php echo $pz["kost"]; ?>" /></td> |
|
161 </tr> |
|
162 <!-- <tr> |
|
163 <td>Prozess-Kategorie</td> |
|
164 <td><select name="pz[kat]"> |
|
165 <?php |
|
166 /* if ($pz['kat'] == -1) $select = " selected "; else $select = ""; |
|
167 echo "<option $select value=\"-1\"></option>\n"; |
|
168 $sql = "SELECT proz_kat_ID,proz_kat_bez FROM Proz_Kategorie ORDER BY 2"; |
|
169 if ($result = $dbc -> queryObjectArray($sql)) |
|
170 { |
|
171 foreach ($result as $row) |
|
172 { |
|
173 if ($row->proz_kat_ID == $pz['kat']) |
|
174 echo "<option selected value=\"$row->proz_kat_ID\">$row->proz_kat_bez</option>\n"; |
|
175 else |
|
176 echo "<option value=\"$row->proz_kat_ID\">$row->proz_kat_bez</option>\n"; |
|
177 } |
|
178 } |
|
179 */ ?> |
|
180 </select> |
|
181 </td> |
|
182 </tr> --> |
|
183 <tr> |
|
184 <td>Arbeitschritte</td> |
|
185 <td> |
|
186 <div id="add"> |
|
187 <input name="pz[step][]" type="text" size="50" maxlength="50" value="<?php echo $pz['step'][0]; ?>" /> |
|
188 Status <select name="pz[ststat][]"> |
|
189 <?php |
|
190 if (isset($pz['step'])) $anzstep = count($pz['step']); else $anzstep = 1; |
|
191 if ($pz['ststat'][0] == -1) $select = " selected "; else $select = ""; |
|
192 echo "<option $select value=\"-1\"></option>\n"; |
|
193 $sql = "SELECT proz_stat_ID,proz_stat_bez FROM Proz_Status ORDER BY 1"; |
|
194 if ($result = $dbc -> queryObjectArray($sql)) |
|
195 { |
|
196 foreach ($result as $row) |
|
197 { |
|
198 if ($row->proz_stat_ID == $pz['ststat'][0]) |
|
199 echo "<option selected value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n"; |
|
200 else |
|
201 echo "<option value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n"; |
|
202 $stat .= "'".$row->proz_stat_ID. "':'" . $row->proz_stat_bez . "',"; |
|
203 $sta[$row->proz_stat_ID] = $row->proz_stat_bez; |
|
204 } |
|
205 } |
|
206 $stat = substr($stat,0,strlen($stat)-1); |
|
207 echo "</select>"; |
|
208 echo " Sort <input type='text' name=\"pz[sort][]\" class='right' size=\"2\" maxlen=\"2\" value=\"". $pz['sort'][0]. "\" /><br />\n"; |
|
209 echo " Bemerkung zu Schritt "; |
|
210 echo "<input name=\"pz[stbem][]\" maxlen=\"50\" size=\"50\" value='".$pz["stbem"][0]."' />"; |
|
211 ?> |
|
212 <script type="text/javascript"> |
|
213 <!-- |
|
214 arr = {<?php echo ($stat); ?>}; // Ergebnis: {key:'value',key:'value',...} |
|
215 //--> |
|
216 </script> |
|
217 |
|
218 |
|
219 |
|
220 <a href="<?php echo "javascript:addInput('add',$anzstep);" ?>" id="badd" title="Schritt hinzufügen"><img src="/fhiiqm/img/add.png" border="0" /></a> |
|
221 <a href="<?php echo "javascript:markdelInput('add',$anzstep);" ?>" id="bdel" title="Schritt entfernen"><img src="/fhiiqm/img/delete.png" border="0" /></a> |
|
222 <?php |
|
223 if ($pzid || ($sub && isset($pz) && !$ok)) |
|
224 { |
|
225 if (count($pz['step'])>1) |
|
226 { |
|
227 $i=0; |
|
228 foreach ($pz['step'] as $akt) |
|
229 { |
|
230 if ($i>0) |
|
231 { |
|
232 echo "<span></span><br /><input name=\"pz[step][]\" type=\"text\" size=\"50\" maxlength=\"50\" value=\"" .$pz['step'][$i] . "\" />\n"; |
|
233 echo " Status <select name='pz[ststat][]'>"; |
|
234 if ($pz['ststat'][$i] == -1) $select = " selected "; else $select = ""; |
|
235 echo "<option $select value=\"-1\"></option>\n"; |
|
236 foreach ($sta as $key => $value) |
|
237 { |
|
238 $select = ($key == $pz['ststat'][$i])? " selected='selected'" : ""; |
|
239 echo "<option$select value=\"$key\">$value</option>\n"; |
|
240 } |
|
241 echo "</select>"; |
|
242 echo " Sort <input type='text' name='pz[sort][]' class='right' size='2' maxlen='2' value='".$pz['sort'][$i] ."' />"; |
|
243 if (isset($pz['del'])) $cls = "dispil"; else $cls = "pr"; |
|
244 if (isset($pz['del'][$i])) $chk = "checked = ' checked'"; else $chk =""; |
|
245 echo "<span id='cbl_$i'> <input class='$cls' type='checkbox' id='del_$i' name='pz[del][$i]' value='1'$chk /></span> |
|
246 <span id='lb_$i' class='$cls'> löschen?</span>"; |
|
247 echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n"; |
|
248 echo "<br /> Bemerkung zu Schritt "; |
|
249 echo "<input name=\"pz[stbem][]\" maxlen=\"50\" size=\"50\" value=\"".$pz["stbem"][$i]."\" />\n"; |
|
250 } |
|
251 $i++; |
|
252 } |
|
253 } |
|
254 } |
|
255 ?> |
|
256 </div> |
|
257 </td> |
|
258 </tr> |
|
259 <tr> |
|
260 <td>Projekt-Dringlichkeit</td> |
|
261 <td><select name="pz[urg]"> |
|
262 <?php |
|
263 if ($pz['urg'] == -1) $select = " selected "; else $select = ""; |
|
264 echo "<option $select value=\"-1\"></option>\n"; |
|
265 $sql = "SELECT proz_urg_ID,proz_urg_bez FROM Proz_Dringlichkeit ORDER BY 1"; |
|
266 if ($result = $dbc -> queryObjectArray($sql)) |
|
267 { |
|
268 foreach ($result as $row) |
|
269 { |
|
270 if ($row->proz_urg_ID == $pz['urg']) |
|
271 echo "<option selected value=\"$row->proz_urg_ID\">$row->proz_urg_bez</option>\n"; |
|
272 else |
|
273 echo "<option value=\"$row->proz_urg_ID\">$row->proz_urg_bez</option>\n"; |
|
274 } |
|
275 } |
|
276 ?> |
|
277 </select> |
|
278 </td> |
|
279 </tr> |
|
280 <tr> |
|
281 <td>Projekt-Status</td> |
|
282 <td><select name="pz[stat]"> |
|
283 <?php |
|
284 if ($pz['stat'] == -1) $select = " selected "; else $select = ""; |
|
285 echo "<option $select value=\"-1\"></option>\n"; |
|
286 $sql = "SELECT proz_stat_ID,proz_stat_bez FROM Proz_Status ORDER BY 1"; |
|
287 if ($result = $dbc -> queryObjectArray($sql)) |
|
288 { |
|
289 foreach ($result as $row) |
|
290 { |
|
291 if ($row->proz_stat_ID == $pz['stat']) |
|
292 echo "<option selected value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n"; |
|
293 else |
|
294 echo "<option value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n"; |
|
295 } |
|
296 } |
|
297 ?> |
|
298 </select> |
|
299 </td> |
|
300 </tr> |
|
301 <tr> |
|
302 <td>betroffene AGs</td> |
|
303 <td> |
|
304 <div id="addrag"> |
|
305 <select name="pz[rag][]"> |
|
306 <?php |
|
307 if (isset($pz['rag'])) $anzrag = count($pz['rag']); else $anzrag = 1; |
|
308 if ($pz['rag'] == -1) $select = " selected "; else $select = ""; |
|
309 echo "<option $select value=\"-1\"></option>\n"; |
|
310 $sql = "SELECT rag_ID,rag_bez,rag_bezk,abt_name,rag.abt_ID |
|
311 FROM fhiiqm.RaumArb_Gruppe rag |
|
312 LEFT OUTER JOIN Abteilung a ON rag.abt_ID=a.abt_ID |
|
313 ORDER BY rag.abt_ID,rag_bez"; |
|
314 if ($result = $dbc -> queryObjectArray($sql)) |
|
315 { |
|
316 foreach ($result as $row) |
|
317 { |
|
318 if ($row->rag_ID == $pz['rag'][0]) $select = " selected "; else $select = ""; |
|
319 echo "<option$select value=\"$row->rag_ID\">$row->abt_name: $row->rag_bez</option>\n"; |
|
320 $faktor = ($row->abt_ID*1000)+$row->rag_ID; // wegen sort nach Abt. fuer JS, z.B. 7047 |
|
321 $rag .= "'".$faktor. "':'" . $row->abt_name.": ". $row->rag_bez . "',"; |
|
322 $ag[$row->rag_ID] = $row->abt_name.": ". $row->rag_bez; |
|
323 } |
|
324 } |
|
325 $rag = substr($rag,0,strlen($rag)-1); |
|
326 ?> |
|
327 </select> |
|
328 <script type="text/javascript"> |
|
329 <!-- |
|
330 arrag = {<?php echo ($rag); ?>}; // Ergebnis: {key:'value',key:'value',...} |
|
331 //--> |
|
332 </script> |
|
333 |
|
334 |
|
335 <a href="<?php echo "javascript:addInput('addrag',$anzrag);" ?>" id="badd" title="AG hinzufügen"><img src="/fhiiqm/img/add.png" border="0" /></a> |
|
336 <a href="<?php echo "javascript:markdelInput('addrag',$anzrag);" ?>" id="bdel" title="AG entfernen"><img src="/fhiiqm/img/delete.png" border="0" /></a> |
|
337 <?php |
|
338 if ($pzid || ($sub && isset($pz) && !$ok)) |
|
339 { |
|
340 if (count($pz['rag'])>1) |
|
341 { |
|
342 $i=0; |
|
343 foreach ($pz['rag'] as $akt) |
|
344 { |
|
345 if ($i>0) |
|
346 { |
|
347 echo "<span></span><br /><select name='pz[rag][]'>"; |
|
348 if ($pz['rag'][$i] == -1) $select = " select='selected' "; else $select = ""; |
|
349 echo "<option $select value=\"-1\"></option>\n"; |
|
350 foreach ($ag as $key => $value) |
|
351 { |
|
352 $select = ($key == $pz['rag'][$i])? " selected='selected'" : ""; |
|
353 echo "<option$select value=\"$key\">$value</option>\n"; |
|
354 } |
|
355 echo "</select>"; |
|
356 if (isset($pz['delag'])) $cls = "dispil"; else $cls = "pr"; |
|
357 if (isset($pz['delag'][$i])) $chk = "checked = ' checked'"; else $chk =""; |
|
358 echo "<span id='cblag_$i'> <input class='$cls' type='checkbox' id='delag_$i' name='pz[delag][$i]' value='1'$chk /></span> |
|
359 <span id='lbag_$i' class='$cls'> löschen?</span>"; |
|
360 echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n"; |
|
361 } |
|
362 $i++; |
|
363 } |
|
364 } |
|
365 } |
|
366 ?> |
|
367 </div> |
|
368 </td> |
|
369 </tr> |
|
370 <tr> |
|
371 <td>Bemerkung</td> |
|
372 <td><textarea name="pz[bem]" cols="80" rows="6"><?php echo $pz["bem"]; ?></textarea> |
|
373 </td> |
|
374 </tr> |
|
375 |
|
376 <input type="hidden" name="pz[persknr]" id="pid" value="<?php echo $pz['persknr']; // Verantwortlicher?>"/> |
|
377 <input type="hidden" name="pz[persknra]" id="paid" value="<?php echo $pz['persknra']; // Auftraggeber?>"/> |
|
378 <input type="hidden" name="pz[okn]" value="<?php echo $okn; ?>"/> |
|
379 <!-- </table> |
|
380 </div> |
|
381 </form> --> |