25 </td> |
25 </td> |
26 </tr> |
26 </tr> |
27 <tr><td>Funktion *</td> |
27 <tr><td>Funktion *</td> |
28 <td valign="top"> |
28 <td valign="top"> |
29 <!--<input class="long20" type="text" name="fkt[func]" id="func" value="<?php echo $fkt['func']; ?>"/> --> |
29 <!--<input class="long20" type="text" name="fkt[func]" id="func" value="<?php echo $fkt['func']; ?>"/> --> |
30 <select name="fkt[func]"> |
30 <select name="fkt[func]" onchange="this.form.submit();"> |
31 <?php |
31 <?php |
32 $sql = "SELECT fkt_bez, fkt_ID FROM `fhiiqm`.`Funktion` ORDER BY 1"; |
32 $sql = "SELECT fkt_bez, fkt_ID FROM `fhiiqm`.`Funktion` ORDER BY 1"; |
33 if ($result = $dbc->queryObjectArray($sql)) |
33 if ($result = $dbc->queryObjectArray($sql)) |
34 { |
34 { |
35 foreach ($result as $row) |
35 foreach ($result as $row) |
43 ?> |
43 ?> |
44 </select> |
44 </select> |
45 </td> |
45 </td> |
46 </tr> |
46 </tr> |
47 <tr><td>Geltungsbereich</td> |
47 <tr><td>Geltungsbereich</td> |
48 <td valign="top"><input class="long20" type="text" name="fkt[ber]" id="ber" maxlength="50" value="<?php echo $fkt['ber']; ?>"/> |
48 <td valign="top"> |
|
49 <?php |
|
50 if (isset($fkt['func']) && $fkt["func"]=='AL') |
|
51 { |
|
52 echo "<select name='fkt[ber]'>\n"; |
|
53 $sql = "SELECT abt_ID,abt_name,abt_long FROM `fhiiqm`.`Abteilung`"; |
|
54 if ($result = $dbc->queryObjectArray($sql)) |
|
55 { |
|
56 foreach ($result as $row) |
|
57 { |
|
58 if ($row->abt_name == $fkt['ber']) |
|
59 echo "<option selected value=\"$row->abt_name\">$row->abt_name</option>\n"; |
|
60 else |
|
61 echo "<option value=\"$row->abt_name\">$row->abt_name</option>\n"; |
|
62 } |
|
63 } |
|
64 echo "</select>"; |
|
65 } |
|
66 elseif (isset($fkt['func']) && $fkt["func"]=='AGL') |
|
67 { |
|
68 echo "<select name='fkt[ber]'>\n"; |
|
69 $sql = "SELECT ag_name, abt_name FROM `fhiiqm`.`Arbeitsgruppe` ag INNER JOIN fhiiqm.Abteilung a |
|
70 ON ag.abt_ID=a.abt_ID ORDER BY ag.abt_ID, ag_ID"; |
|
71 if ($result = $dbc->queryObjectArray($sql)) |
|
72 { |
|
73 foreach ($result as $row) |
|
74 { |
|
75 if ($row->ag_name == $fkt['ber']) |
|
76 echo "<option selected value=\"$row->ag_name\">$row->ag_name, $row->abt_name</option>\n"; |
|
77 else |
|
78 echo "<option value=\"$row->ag_name\">$row->ag_name, $row->abt_name</option>\n"; |
|
79 } |
|
80 } |
|
81 echo "</select>"; |
|
82 } |
|
83 else |
|
84 { |
|
85 ?> |
|
86 <input class="long20" type="text" name="fkt[ber]" id="ber" maxlength="50" value="<?php echo $fkt['ber']; ?>" onfocus="this.select();"/> |
|
87 <?php } ?> |
49 </td> |
88 </td> |
50 </tr> |
89 </tr> |
51 <tr><td>Beginn</td> |
90 <tr><td>Beginn</td> |
52 <td valign="top"><input class="long10" type="text" name="fkt[von]" id="von" value="<?php echo $fkt['von']; ?>"/> |
91 <td valign="top"><input class="long10" type="text" name="fkt[von]" id="von" value="<?php echo $fkt['von']; ?>"/> |
53 </td> |
92 </td> |