41 <tr><td>Anlagenbeschreibung</td> |
41 <tr><td>Anlagenbeschreibung</td> |
42 <td><textarea name="al[beschr]" cols="50" rows="5"><?php echo $al['beschr']; ?></textarea></td> |
42 <td><textarea name="al[beschr]" cols="50" rows="5"><?php echo $al['beschr']; ?></textarea></td> |
43 </tr> |
43 </tr> |
44 <tr><td>Kategorie</td> |
44 <tr><td>Kategorie</td> |
45 <td valign="top"> |
45 <td valign="top"> |
46 <select name="al[kat]"> |
46 <select name="al[kat]" onchange="this.form.submit();"> |
47 <?php |
47 <?php |
48 if ($al['kat'] == -1) $select = " selected "; else $select = ""; |
48 if ($al['kat'] == -1) $select = " selected "; else $select = ""; |
49 echo "<option $select value=\"-1\"></option>\n"; |
49 echo "<option $select value=\"-1\"></option>\n"; |
50 $sql = "SELECT al_kat_bez, al_kat_ID FROM `fhiiqm`.`A_Kategorie` ORDER BY 1"; |
50 $sql = "SELECT al_kat_bez, al_kat_ID FROM `fhiiqm`.`A_Kategorie` ORDER BY 2"; |
51 if ($result = $dbc->queryObjectArray($sql)) |
51 if ($result = $dbc->queryObjectArray($sql)) |
52 { |
52 { |
53 foreach ($result as $row) |
53 foreach ($result as $row) |
54 { |
54 { if (strlen($row->al_kat_ID) == 1) $katid = $row->al_kat_ID . " "; else $katid = $row->al_kat_ID; |
55 if ($row->al_kat_ID == $al['kat']) |
55 if ($row->al_kat_ID == $al['kat']) |
56 echo "<option selected value=\"$row->al_kat_ID\">$row->al_kat_ID: $row->al_kat_bez</option>\n"; |
56 echo "<option selected value=\"$row->al_kat_ID\">$katid: $row->al_kat_bez</option>\n"; |
57 else |
57 else |
58 echo "<option value=\"$row->al_kat_ID\">$row->al_kat_ID: $row->al_kat_bez</option>\n"; |
58 echo "<option value=\"$row->al_kat_ID\">$katid: $row->al_kat_bez</option>\n"; |
59 } |
59 } |
60 } |
60 } |
61 ?> |
61 ?> |
62 </select> |
62 </select> |
63 </td> |
63 </td> |
64 </tr> |
64 </tr> |
|
65 <?php |
|
66 if ($al["kat"] != 4) |
|
67 { |
|
68 ?> |
65 <tr><td>Befähigungsgrad</td> |
69 <tr><td>Befähigungsgrad</td> |
66 <td valign="top"> |
70 <td valign="top"> |
67 <select name="al[befg]"> |
71 <select name="al[befg]"> |
68 <?php |
72 <?php |
69 if ($al['befg'] == -1) $select = " selected "; else $select = ""; |
73 if ($al['befg'] == -1) $select = " selected "; else $select = ""; |
72 if ($result = $dbc->queryObjectArray($sql)) |
76 if ($result = $dbc->queryObjectArray($sql)) |
73 { |
77 { |
74 foreach ($result as $row) |
78 foreach ($result as $row) |
75 { |
79 { |
76 if ($row->al_befgrad_ID == $al['befg']) |
80 if ($row->al_befgrad_ID == $al['befg']) |
77 echo "<option selected value=\"$row->al_befgrad_ID\">$row->al_befgrad_ID: $row->al_befgrad_bez</option>\n"; |
81 echo "<option selected value=\"$row->al_befgrad_ID\">$row->al_befgrad_bez</option>\n"; |
78 else |
82 else |
79 echo "<option value=\"$row->al_befgrad_ID\">$row->al_befgrad_ID: $row->al_befgrad_bez</option>\n"; |
83 echo "<option value=\"$row->al_befgrad_ID\">$row->al_befgrad_bez</option>\n"; |
80 } |
84 } |
81 } |
85 } |
82 ?> |
86 ?> |
83 </select> |
87 </select> |
84 </td> |
88 </td> |
93 if ($result = $dbc->queryObjectArray($sql)) |
97 if ($result = $dbc->queryObjectArray($sql)) |
94 { |
98 { |
95 foreach ($result as $row) |
99 foreach ($result as $row) |
96 { |
100 { |
97 if ($row->al_pruefart_ID == $al['part']) |
101 if ($row->al_pruefart_ID == $al['part']) |
98 echo "<option selected value=\"$row->al_pruefart_ID\">$row->al_pruefart_ID: $row->al_pruefart_bez</option>\n"; |
102 echo "<option selected value=\"$row->al_pruefart_ID\">$row->al_pruefart_bez</option>\n"; |
99 else |
103 else |
100 echo "<option value=\"$row->al_pruefart_ID\">$row->al_pruefart_ID: $row->al_pruefart_bez</option>\n"; |
104 echo "<option value=\"$row->al_pruefart_ID\">$row->al_pruefart_bez</option>\n"; |
101 } |
105 } |
102 } |
106 } |
103 ?> |
107 ?> |
104 </select> |
108 </select> |
105 </td> |
109 </td> |
106 </tr> |
110 </tr> |
|
111 <tr><td>Prüfintervall</td> |
|
112 <td valign="top"> |
|
113 <select name="al[pintv]"> |
|
114 <?php |
|
115 if ($al['pintv'] == -1) $select = " selected "; else $select = ""; |
|
116 echo "<option $select value=\"-1\"></option>\n"; |
|
117 $sql = "SELECT al_pruefintv_bez, al_pruefintv_ID FROM `fhiiqm`.`A_PruefIntv` ORDER BY 2"; |
|
118 if ($result = $dbc->queryObjectArray($sql)) |
|
119 { |
|
120 foreach ($result as $row) |
|
121 { |
|
122 if ($row->al_pruefintv_ID == $al['pintv']) |
|
123 echo "<option selected value=\"$row->al_pruefintv_ID\">$row->al_pruefintv_bez</option>\n"; |
|
124 else |
|
125 echo "<option value=\"$row->al_pruefintv_ID\">$row->al_pruefintv_bez</option>\n"; |
|
126 } |
|
127 } |
|
128 ?> |
|
129 </select> |
|
130 </td> |
|
131 </tr> |
|
132 <?php |
|
133 } |
|
134 ?> |
107 <tr><td>Standort</td> |
135 <tr><td>Standort</td> |
108 <td valign="top">Haus |
136 <td valign="top">Haus |
109 <select name="al[geb]" onchange="this.form.submit();"> |
137 <select name="al[geb]" onchange="this.form.submit();"> |
110 <?php |
138 <?php |
111 $sql = "SELECT geb_ID, geb_name FROM `fhiiqm`.`Haus` ORDER BY 1"; |
139 $sql = "SELECT geb_ID, geb_name FROM `fhiiqm`.`Haus` ORDER BY 1"; |