|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 05/2011 |
|
6 * |
|
7 * Form Vertrag |
|
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;?> Vertragsdaten</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_vertrag" target="_self"> |
|
24 <div align="center"> |
|
25 <table width="50%" border="0" cellspacing="3" cellpadding="3"> |
|
26 <!-- <tr> |
|
27 <td>Vertrag-ID *</td> |
|
28 <td><input name="vertrag[cid]" type="text" size="10" maxlength="6" value="<?php echo $vtr['cid']; ?>"/> |
|
29 <?php |
|
30 /* if (isset($vtr['cid']) && $vtr['cid']<'!') |
|
31 { |
|
32 echo "<br><span class=\"red\">ID ist erforderlich!</span>\n"; |
|
33 $okn = false; |
|
34 } |
|
35 else |
|
36 $okn = true; */ |
|
37 ?> |
|
38 </td> |
|
39 </tr> |
|
40 --> |
|
41 <tr> |
|
42 <td>Vertragsbezeichnung *</td> |
|
43 <td><input name="vertrag[cname]" type="text" size="50" maxlength="50" value="<?php echo $vtr['cname']; ?>"/> |
|
44 <?php |
|
45 if (isset($vtr['cname']) && $vtr['cname']<'!') |
|
46 { |
|
47 echo "<br><span class=\"red\">Bezeichnung ist erforderlich!</span>\n"; |
|
48 $okn = false; |
|
49 } |
|
50 else |
|
51 if ($okn) $okn = true; else $okn=false; |
|
52 ?> |
|
53 </td> |
|
54 </tr> |
|
55 <!-- <tr> |
|
56 <td>Vertrag Titel</td> |
|
57 <td><input name="vertrag[cshort]" type="text" size="30" maxlength="50" value="<?php echo $vtr['cshort']; ?>"/></td> |
|
58 </tr> |
|
59 --> |
|
60 <tr> |
|
61 <td>Vertrag Beschreibung</td> |
|
62 <td><textarea name="vertrag[clong]" cols="50" rows="2"><?php echo $vtr['clong']; ?></textarea> |
|
63 <div>max. 100 Zeichen sind möglich</div></td> |
|
64 </tr> |
|
65 <tr> |
|
66 <td>Vertrag-Typ</td> |
|
67 <td><select name="vertrag[vtyp]"> |
|
68 <?php |
|
69 if ($vtr['vtyp'] == -1) $select = " selected "; else $select = ""; |
|
70 echo "<option $select value=\"-1\"></option>\n"; |
|
71 $sql = "SELECT vtyp_ID, vtyp_bezeichnung FROM Vertrag_Typ ORDER BY 2"; |
|
72 if ($result = $dbc->queryObjectArray($sql)) |
|
73 { |
|
74 foreach ($result as $row) |
|
75 { |
|
76 if ($row->vtyp_ID == $vtr['vtyp']) |
|
77 echo "<option selected value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n"; |
|
78 else |
|
79 echo "<option value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n"; |
|
80 } |
|
81 } |
|
82 ?> |
|
83 </select> |
|
84 </td> |
|
85 </tr> |
|
86 <tr> |
|
87 <td>Datum Vertragbeginn</td> |
|
88 <td align="left"><select name="vertrag[btag]" size="1"> |
|
89 <?php |
|
90 if (!$vtr['btag'] ) $ta1=0; else $ta1 = $vtr['btag']; |
|
91 for ($i=0; $i<32; $i++) |
|
92 { if ($i==intval($ta1)) |
|
93 { |
|
94 if ($i == 0) |
|
95 echo "<option selected></option>\n"; |
|
96 else |
|
97 echo "<option selected>$ta1</option>\n"; |
|
98 } |
|
99 else { |
|
100 if ($i<10) |
|
101 { |
|
102 if ($i == 0) |
|
103 echo "<option></option>\n"; |
|
104 else |
|
105 echo "<option>0$i</option>\n"; |
|
106 } |
|
107 else |
|
108 echo "<option>$i</option>\n"; |
|
109 } |
|
110 } |
|
111 ?> |
|
112 </select>. |
|
113 <select name="vertrag[bmon]" size="1"> |
|
114 <?php |
|
115 if (!$vtr['bmon'] ) $mo1=0; else $mo1 = $vtr['bmon']; |
|
116 for ($i=0; $i<13; $i++) |
|
117 { if ($i==intval($mo1)) |
|
118 { |
|
119 if ($i == 0) |
|
120 echo "<option selected></option>\n"; |
|
121 else |
|
122 echo "<option selected>$mo1</option>\n"; |
|
123 } |
|
124 else { |
|
125 if ($i<10) |
|
126 { |
|
127 if ($i == 0) |
|
128 echo "<option></option>\n"; |
|
129 else |
|
130 echo "<option>0$i</option>\n"; |
|
131 } |
|
132 else |
|
133 echo "<option>$i</option>\n"; |
|
134 } |
|
135 } |
|
136 ?> |
|
137 </select>. |
|
138 <select name="vertrag[bjahr]" size="1"> |
|
139 <?php |
|
140 |
|
141 if (!$vtr['bjahr'] ) |
|
142 echo "<option selected></option>\n"; |
|
143 else |
|
144 echo "<option></option>\n"; |
|
145 $ja1 = $vtr['bjahr']; |
|
146 for ($i=2000; $i<2036; $i++) |
|
147 { if ($i==intval($ja1)) |
|
148 echo "<option selected>$ja1</option>\n"; |
|
149 else |
|
150 echo "<option>$i</option>\n"; |
|
151 } |
|
152 ?> |
|
153 </select> |
|
154 </td> |
|
155 </tr> |
|
156 <tr> |
|
157 <td>Datum Vertragende</td> |
|
158 <td align="left"><select name="vertrag[etag]" size="1"> |
|
159 <?php |
|
160 if (!$vtr['etag'] ) $ta1=0; else $ta1 = $vtr['etag']; |
|
161 for ($i=0; $i<32; $i++) |
|
162 { if ($i==intval($ta1)) |
|
163 { |
|
164 if ($i == 0) |
|
165 echo "<option selected></option>\n"; |
|
166 else |
|
167 echo "<option selected>$ta1</option>\n"; |
|
168 } |
|
169 else { |
|
170 if ($i<10) |
|
171 { |
|
172 if ($i == 0) |
|
173 echo "<option></option>\n"; |
|
174 else |
|
175 echo "<option>0$i</option>\n"; |
|
176 } |
|
177 else |
|
178 echo "<option>$i</option>\n"; |
|
179 } |
|
180 } |
|
181 ?> |
|
182 </select>. |
|
183 <select name="vertrag[emon]" size="1"> |
|
184 <?php |
|
185 if (!$vtr['emon'] ) $mo1=0; else $mo1 = $vtr['emon']; |
|
186 for ($i=0; $i<13; $i++) |
|
187 { if ($i==intval($mo1)) |
|
188 { |
|
189 if ($i == 0) |
|
190 echo "<option selected></option>\n"; |
|
191 else |
|
192 echo "<option selected>$mo1</option>\n"; |
|
193 } |
|
194 else { |
|
195 if ($i<10) |
|
196 { |
|
197 if ($i == 0) |
|
198 echo "<option></option>\n"; |
|
199 else |
|
200 echo "<option>0$i</option>\n"; |
|
201 } |
|
202 else |
|
203 echo "<option>$i</option>\n"; |
|
204 } |
|
205 } |
|
206 ?> |
|
207 </select>. |
|
208 <select name="vertrag[ejahr]" size="1"> |
|
209 <?php |
|
210 |
|
211 if (!$vtr['ejahr'] ) |
|
212 echo "<option selected></option>\n"; |
|
213 else |
|
214 echo "<option></option>\n"; |
|
215 $ja1 = $vtr['ejahr']; |
|
216 for ($i=2000; $i<2036; $i++) |
|
217 { if ($i==intval($ja1)) |
|
218 echo "<option selected>$ja1</option>\n"; |
|
219 else |
|
220 echo "<option>$i</option>\n"; |
|
221 } |
|
222 ?> |
|
223 </select> |
|
224 <?php |
|
225 if ($vtr['bjahr'] && $vtr['bmon'] && $vtr['btag'] && $vtr['ejahr'] && $vtr['emon'] && $vtr['etag']) |
|
226 { |
|
227 $dat = $vtr['ejahr']."-".$vtr['emon']."-".$vtr['etag']; |
|
228 $edate = new DateTime("$dat"); |
|
229 $edate = $edate->add(new DateInterval('P1D')); |
|
230 $dat = $vtr['bjahr']."-".$vtr['bmon']."-".$vtr['btag']; |
|
231 $bdate = new DateTime("$dat"); |
|
232 $diff = $edate->diff($bdate); |
|
233 echo "<br />Vertragsdauer: ".$diff->format('%y Jahr(e), %m Monat(e), %d Tag(e)'); |
|
234 } |
|
235 ?> |
|
236 </td> |
|
237 </tr> |
|
238 <tr> |
|
239 <td>Kündigungsfrist<br />(Monate vor Ablauf)</td> |
|
240 <td><input name="vertrag[cnot]" type="text" size="10" maxlength="3" value="<?php echo $vtr['cnot']; ?>"/></td> |
|
241 </tr> |
|
242 <tr> |
|
243 <td>Partner (Firma)</td> |
|
244 <td> |
|
245 <select name="vertrag[partid]"> |
|
246 <?php |
|
247 if ($vtr['partid'] == -1) $select = " selected "; else $select = ""; |
|
248 echo "<option $select value=\"-1\"></option>\n"; |
|
249 $sql = "SELECT part_ID, part_firma FROM Partner ORDER BY 2"; |
|
250 if ($result = $dbc->queryObjectArray($sql)) |
|
251 { |
|
252 foreach ($result as $row) |
|
253 { |
|
254 if ($row->part_ID == $vtr['partid']) |
|
255 echo "<option selected value=\"$row->part_ID\">$row->part_firma</option>\n"; |
|
256 else |
|
257 echo "<option value=\"$row->part_ID\">$row->part_firma</option>\n"; |
|
258 } |
|
259 //$result->free(); |
|
260 } |
|
261 ?> |
|
262 </select> oder neu |
|
263 <input name="vertrag[partner]" type="text" size="30" maxlength="50" value="<?php echo $vtr['partner']; ?>"/> |
|
264 </td> |
|
265 </tr> |
|
266 <tr> |
|
267 <td>Ansprechpartner FHI <br /><br /> |
|
268 Mehrfachauswahl möglich:<br /> |
|
269 [Strg]-Taste + Anklicken der<br /> |
|
270 gewünschten Listeneinträge |
|
271 </td> |
|
272 <td> |
|
273 <select name="vertrag[cpers][]" size="7" multiple="multiple"> |
|
274 <?php |
|
275 if (is_array($vtr['cpers'])) $select = in_array( "-1", $vtr['cpers'] ) ? ' selected' : null; |
|
276 echo "<option $select value=\"-1\"></option>\n"; |
|
277 $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter ORDER BY 2"; |
|
278 if ($result = $dbc->queryObjectArray($sql)) |
|
279 { |
|
280 foreach ($result as $row) |
|
281 { |
|
282 if (is_array($vtr['cpers'])) $select = in_array( $row->persknr, $vtr['cpers'] ) ? ' selected' : null; |
|
283 echo "<option $select value=\"$row->persknr\">$row->pname</option>\n"; |
|
284 } |
|
285 } |
|
286 ?> |
|
287 </select> |
|
288 </td> |
|
289 </tr> |
|
290 <?php |
|
291 if ($vtr['bjahr']) |
|
292 { |
|
293 echo "<tr> |
|
294 <td>jährliche Kosten (€)</td><br /> |
|
295 <td>"; |
|
296 $j=0; |
|
297 if ($vtr['ejahr']) |
|
298 { |
|
299 for ($i=(int)$vtr['bjahr']; $i<(int)$vtr['ejahr']+1; $i++ ) |
|
300 { |
|
301 echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"$i\"/> "; |
|
302 echo "<input name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/><br />"; |
|
303 $j++; |
|
304 } |
|
305 } |
|
306 else |
|
307 { |
|
308 echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"" . $vtr['bjahr'] . "\"/> "; |
|
309 echo "<input name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/>"; |
|
310 } |
|
311 |
|
312 echo "</td> |
|
313 </tr>"; |
|
314 } |
|
315 ?> |
|
316 <tr> |
|
317 <td>zugeordnet zu </td> |
|
318 <td> |
|
319 <select name="vertrag[prodid]"> |
|
320 <?php |
|
321 if ($vtr['prodid'] == -1) $select = " selected "; else $select = ""; |
|
322 echo "<option $select value=\"-1\"></option>\n"; |
|
323 // $sql = "SELECT produkt_ID, LEFT(prod_name,70) AS prod, LENGTH(prod_name) AS lenp FROM Produkt ORDER BY 2"; |
|
324 /* if ($result = $dbc->queryObjectArray($sql)) |
|
325 { |
|
326 foreach ($result as $row) |
|
327 { |
|
328 if ($row->lenp > 70) $prod=$row->prod ."..."; else $prod=$row->prod; |
|
329 if ($row->produkt_ID == $vtr['prodid']) |
|
330 echo "<option selected value=\"$row->produkt_ID\">$prod</option>\n"; |
|
331 else |
|
332 echo "<option value=\"$row->produkt_ID\">$prod</option>\n"; |
|
333 } |
|
334 } |
|
335 */ |
|
336 $sql = "CALL prod_hiera_all(0,0)"; |
|
337 if ($result = $dbc->queryObjectArray($sql)) |
|
338 { |
|
339 foreach ($result as $row) |
|
340 { |
|
341 if (strlen($row->bez) > 70) |
|
342 $prod=str_replace(" "," ",htmlentities(substr($row->bez,0,70))) ."..."; |
|
343 else |
|
344 $prod=str_replace(" "," ",htmlentities($row->bez)); |
|
345 if ($row->prid >0) $color=" class='green'"; else $color=""; |
|
346 if ($row->prid == $vtr['prodid']) |
|
347 echo "<option $color selected value=\"$row->prid\">$prod</option>\n"; |
|
348 else |
|
349 echo "<option $color value=\"$row->prid\">$prod</option>\n"; |
|
350 } |
|
351 } |
|
352 unset($row); |
|
353 unset($result); |
|
354 $sql=null; |
|
355 ?> |
|
356 </select> |
|
357 <br />bitte nur die <font color="green">grünen</font> Einträge wählen |
|
358 </td> |
|
359 </tr> |
|
360 <tr> |
|
361 <td>Dateibezeichnung Dokument *</td> |
|
362 <td><input name="vertrag[cfname]" type="text" size="50" maxlength="50" value="<?php echo $vtr['cfname']; ?>"> |
|
363 <?php |
|
364 echo "<br />bitte <u>keine</u> Umlaute im Dateinamen angeben!"; |
|
365 if (isset($vtr['cfname']) && $vtr['cfname']<'!') |
|
366 { |
|
367 echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n"; |
|
368 $okn = false; |
|
369 } |
|
370 else |
|
371 { |
|
372 if ($vtr['cfname']>='!' && file_exists("documents/".$vtr['cfname'])) |
|
373 echo "<br />Dokument anschauen: <a href='documents/" . $vtr['cfname'] ."'>" . $vtr['cfname'] . "</a>"; |
|
374 if ($okn) $okn = true; else $okn=false; |
|
375 } |
|
376 ?> |
|
377 </td> |
|
378 </tr> |
|
379 <tr> |
|
380 <td>Bemerkung</td> |
|
381 <td><textarea name="vertrag[cbem]" cols="50" rows="5"><?php echo $vtr['cbem']; ?></textarea> |
|
382 <div>max. 500 Zeichen sind möglich</div></td> |
|
383 </tr> |
|
384 |
|
385 <input type="hidden" name="MAX_FILE_SIZE" value="6000000"/> |
|
386 <input type="hidden" name="vertrag[okn]" value="<?php echo $okn; ?>"/> |
|
387 |
|
388 <!-- </table> |
|
389 </div> |
|
390 </form> --> |