13 if (!$la["geb"]) $la["geb"]="A"; |
13 if (!$la["geb"]) $la["geb"]="A"; |
14 |
14 |
15 ?> |
15 ?> |
16 <div align="center"> |
16 <div align="center"> |
17 <table> |
17 <table> |
18 <tr><td class="bigger">Die Auswahl eines Verantwortlichen geschieht durch<br />Eingeben von mindesten 2 Zeichen in das entsprechende Feld. |
18 <tr><td class="bigger">Die Auswahl eines Verantwortlichen geschieht durch Eingeben von<br />mindesten 2 Zeichen in das entsprechende Feld. |
19 </td></tr> |
19 </td></tr> |
20 <tr><td class="bigger">Umlaute wie 'ä', 'ü', 'ö', 'ß' werden nicht gefunden, bitte benachbarte Zeichen eingeben.</td></tr> |
20 <tr><td class="bigger">Umlaute wie 'ä', 'ü', 'ö', 'ß' werden nicht gefunden, bitte benachbarte Zeichen eingeben.</td></tr> |
21 <tr><td class="bigger"> </td></tr> |
21 <tr><td class="bigger"> </td></tr> |
22 </table> |
22 </table> |
23 </div> |
23 </div> |
24 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="fanl"> |
24 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="fanl"> |
25 <div align="center"> |
25 <div align="center"> |
26 <table border="0" cellspacing="3" cellpadding="3"> |
26 <table border="0" cellspacing="3" cellpadding="3"> |
27 <!-- <div class="ui-widget"> --> |
27 <!-- <div class="ui-widget"> --> |
|
28 <tr> |
|
29 <td> |
|
30 <? if ($laid) |
|
31 { |
|
32 echo "Laser-ID</td>"; |
|
33 echo "<td><input class='read' name='la[lid]' type='text' size='5' value='" .$la['lid']."' readonly='readonly' />"; |
|
34 echo " "; |
|
35 } |
|
36 echo "gehört zu Laser "; |
|
37 if (!$laid) echo "</td><td>"; |
|
38 echo "<select name=\"la[lidref]\">"; |
|
39 if ($la["lidref"] == -1) $select = " selected "; else $select = ""; |
|
40 echo "<option $select value=\"-1\"></option>\n"; |
|
41 if ($laid) $wher = " WHERE las_ID <> $laid "; else $wher = ""; |
|
42 $sql = "SELECT las_ID, las_bez FROM Laser $wher ORDER BY 2"; |
|
43 if ($res = $dbc -> queryObjectArray($sql)) |
|
44 { |
|
45 $select = ""; |
|
46 foreach ($res as $row) |
|
47 { |
|
48 if ($row->las_ID == $la['lidref']) $select="selected"; else $select=""; |
|
49 echo "<option $select value='$row->las_ID'>$row->las_ID - $row->las_bez</option>\n"; |
|
50 } |
|
51 } |
|
52 ?> |
|
53 </td> |
|
54 </tr> |
28 <tr><td>Laserbezeichnung *</td> |
55 <tr><td>Laserbezeichnung *</td> |
29 <td valign="top"><input type="text" name="la[lbez]" id="lbez" size="30" maxlength="250" value="<?php echo $la['lbez']; ?>"/> |
56 <td valign="top"><input type="text" name="la[lbez]" id="lbez" size="50" maxlength="250" value="<?php echo $la['lbez']; ?>"/> |
30 <?php |
57 <?php |
31 if (isset($la['lbez']) && $la['lbez']<'!') |
58 if (isset($la['lbez']) && $la['lbez']<'!') |
32 { |
59 { |
33 echo "<br><span class=\"red\">Laserbezeichnung ist erforderlich!</span>\n"; |
60 echo "<br><span class=\"red\">Laserbezeichnung ist erforderlich!</span>\n"; |
34 $okn = false; |
61 $okn = false; |
36 else |
63 else |
37 if ($okn) $okn = true; else $okn=false; |
64 if ($okn) $okn = true; else $okn=false; |
38 ?> |
65 ?> |
39 </td> |
66 </td> |
40 </tr> |
67 </tr> |
|
68 <tr><td>Inventar-Nr.</td> |
|
69 <td valign="top"><input type="text" name="la[invnr]" size="20" maxlength="20" value="<?php echo $la['invnr']; ?>"/> |
|
70 </td> |
|
71 </tr> |
|
72 <tr><td>in Betrieb</td> |
|
73 <td><input type="checkbox" name="la[akt]" value="1" <?php echo ($la["akt"] )? "checked=\"checked\"" : "";?> /> |
|
74 </td> |
|
75 </tr> |
41 <tr><td>Laserwelle von</td> |
76 <tr><td>Laserwelle von</td> |
42 <td valign="top"><input type="text" name="la[wvon]" size="10" maxlength="7" value="<?php echo $la['wvon']; ?>"/> |
77 <td valign="top"><input type="text" name="la[wvon]" size="10" maxlength="7" value="<?php echo $la['wvon']; ?>"/> |
43 Laserwelle bis |
78 Laserwelle bis |
44 <input type="text" name="la[wbis]" size="10" maxlength="7" value="<?php echo $la['wbis']; ?>"/></td> |
79 <input type="text" name="la[wbis]" size="10" maxlength="7" value="<?php echo $la['wbis']; ?>"/></td> |
45 </tr> |
80 </tr> |
|
81 <tr><td>Laserart</td> |
|
82 <td><select name="la[lart]"> |
|
83 <?php |
|
84 if ($la['lart'] == -1) $select = " selected "; else $select = ""; |
|
85 echo "<option $select value=\"-1\"></option>\n"; |
|
86 $sql = "SELECT las_art_ID, las_art_bez FROM Laser_Art ORDER BY 2"; |
|
87 if ($res = $dbc -> queryObjectArray($sql)) |
|
88 { |
|
89 $select = ""; |
|
90 foreach ($res as $row) |
|
91 { |
|
92 if ($row->las_art_ID == $la['lart']) $select="selected"; else $select=""; |
|
93 echo "<option $select value='$row->las_art_ID'>$row->las_art_bez</option>\n"; |
|
94 } |
|
95 } |
|
96 ?> |
|
97 </select> oder neu |
|
98 <input name="la[lartnew]" type="text" size="30" maxlength="50" value="<?php echo $la['lartnew']; ?>"/> </td> |
|
99 </tr> |
|
100 <tr><td>Lasertyp</td> |
|
101 <td><select name="la[ltyp]"> |
|
102 <?php |
|
103 if ($la['ltyp'] == -1) $select = " selected "; else $select = ""; |
|
104 echo "<option $select value=\"-1\"></option>\n"; |
|
105 $sql = "SELECT las_typ_ID, las_typ_bez FROM Laser_Typ ORDER BY 2"; |
|
106 if ($res = $dbc -> queryObjectArray($sql)) |
|
107 { |
|
108 $select = ""; |
|
109 foreach ($res as $row) |
|
110 { |
|
111 if ($row->las_typ_ID == $la['ltyp']) $select="selected"; else $select=""; |
|
112 echo "<option $select value='$row->las_typ_ID'>$row->las_typ_bez</option>\n"; |
|
113 } |
|
114 } |
|
115 ?> |
|
116 </select></td> |
|
117 </tr> |
|
118 <tr><td>Laserklasse</td> |
|
119 <td><select name="la[lkla]"> |
|
120 <?php |
|
121 if ($la['lkla'] == -1) $select = " selected "; else $select = ""; |
|
122 echo "<option $select value=\"-1\"></option>\n"; |
|
123 $sql = "SELECT las_klasse_ID, las_klasse_bez FROM Laser_Klasse ORDER BY 2"; |
|
124 if ($res = $dbc -> queryObjectArray($sql)) |
|
125 { |
|
126 $select = ""; |
|
127 foreach ($res as $row) |
|
128 { |
|
129 if ($row->las_klasse_ID == $la['lkla']) $select="selected"; else $select=""; |
|
130 echo "<option $select value='$row->las_klasse_ID'>$row->las_klasse_bez</option>\n"; |
|
131 } |
|
132 } |
|
133 ?> |
|
134 </select></td> |
|
135 </tr> |
46 <tr><td>Schutzstufe</td> |
136 <tr><td>Schutzstufe</td> |
47 <td><select name="la[suid]"> |
137 <td><select name="la[suid]"> |
48 <?php |
138 <?php |
49 if ($la['suid'] == -1) $select = " selected "; else $select = ""; |
139 if ($la['suid'] == -1) $select = " selected "; else $select = ""; |
50 echo "<option $select value=\"-1\"></option>\n"; |
140 echo "<option $select value=\"-1\"></option>\n"; |
51 $sql = "SELECT schutzst_ID, schutzst_bez FROM Schutzstufe ORDER BY 2"; |
141 $sql = "SELECT schutzst_ID, schutzst_bez FROM Schutzstufe WHERE LEFT(schutzst_bez,2)<>'OD' ORDER BY 2"; |
52 if ($res = $dbc -> queryObjectArray($sql)) |
142 if ($res = $dbc -> queryObjectArray($sql)) |
53 { |
143 { |
54 $select = ""; |
144 $select = ""; |
55 foreach ($res as $row) |
145 foreach ($res as $row) |
56 { |
146 { |
57 if ($row->schutzst_ID == $la['suid']) $select="selected"; else $select=""; |
147 if ($row->schutzst_ID == $la['suid']) $select="selected"; else $select=""; |
58 echo "<option $select value='$row->schutzst_ID'>$row->schutzst_bez</option>\n"; |
148 echo "<option $select value='$row->schutzst_ID'>$row->schutzst_bez</option>\n"; |
59 } |
149 } |
60 } |
150 } |
61 ?> |
151 ?> |
62 </select></td> |
152 </select> Schutzstufe OD |
63 </tr> |
153 <select name="la[suodid]"> |
64 <tr><td>Laserart</td> |
154 <?php |
65 <td><select name="la[lart]"> |
155 if ($la['suid'] == -1) $select = " selected "; else $select = ""; |
66 <?php |
156 echo "<option $select value=\"-1\"></option>\n"; |
67 if ($la['lart'] == -1) $select = " selected "; else $select = ""; |
157 $sql = "SELECT schutzst_ID, schutzst_bez FROM Schutzstufe WHERE LEFT(schutzst_bez,2)='OD' ORDER BY 2"; |
68 echo "<option $select value=\"-1\"></option>\n"; |
158 if ($res = $dbc -> queryObjectArray($sql)) |
69 $sql = "SELECT las_art_ID, las_art_bez FROM Laser_Art ORDER BY 2"; |
159 { |
70 if ($res = $dbc -> queryObjectArray($sql)) |
160 $select = ""; |
71 { |
161 foreach ($res as $row) |
72 $select = ""; |
162 { |
73 foreach ($res as $row) |
163 if ($row->schutzst_ID == $la['suodid']) $select="selected"; else $select=""; |
74 { |
164 echo "<option $select value='$row->schutzst_ID'>$row->schutzst_bez</option>\n"; |
75 if ($row->las_art_ID == $la['lart']) $select="selected"; else $select=""; |
|
76 echo "<option $select value='$row->las_art_ID'>$row->las_art_bez</option>\n"; |
|
77 } |
|
78 } |
|
79 ?> |
|
80 </select></td> |
|
81 </tr> |
|
82 <tr><td>Laserklasse</td> |
|
83 <td><select name="la[lkla]"> |
|
84 <?php |
|
85 if ($la['lkla'] == -1) $select = " selected "; else $select = ""; |
|
86 echo "<option $select value=\"-1\"></option>\n"; |
|
87 $sql = "SELECT las_klasse_ID, las_klasse_bez FROM Laser_Klasse ORDER BY 2"; |
|
88 if ($res = $dbc -> queryObjectArray($sql)) |
|
89 { |
|
90 $select = ""; |
|
91 foreach ($res as $row) |
|
92 { |
|
93 if ($row->las_klasse_ID == $la['lkla']) $select="selected"; else $select=""; |
|
94 echo "<option $select value='$row->las_klasse_ID'>$row->las_klasse_bez</option>\n"; |
|
95 } |
|
96 } |
|
97 ?> |
|
98 </select></td> |
|
99 </tr> |
|
100 <tr><td>Lasertyp</td> |
|
101 <td><select name="la[ltyp]"> |
|
102 <?php |
|
103 if ($la['ltyp'] == -1) $select = " selected "; else $select = ""; |
|
104 echo "<option $select value=\"-1\"></option>\n"; |
|
105 $sql = "SELECT las_typ_ID, las_typ_bez FROM Laser_Typ ORDER BY 2"; |
|
106 if ($res = $dbc -> queryObjectArray($sql)) |
|
107 { |
|
108 $select = ""; |
|
109 foreach ($res as $row) |
|
110 { |
|
111 if ($row->las_typ_ID == $la['ltyp']) $select="selected"; else $select=""; |
|
112 echo "<option $select value='$row->las_typ_ID'>$row->las_typ_bez</option>\n"; |
|
113 } |
165 } |
114 } |
166 } |
115 ?> |
167 ?> |
116 </select></td> |
168 </select></td> |
117 </tr> |
169 </tr> |
118 <tr><td>Leistung</td> |
170 <tr><td>Leistung</td> |
119 <td valign="top"><input type="text" name="la[leist]" size="10" maxlength="7" value="<?php echo $la['leist']; ?>"/> |
171 <td valign="top"><input type="text" name="la[leist]" size="10" maxlength="7" value="<?php echo $la['leist']; ?>"/> |
120 Einheit |
172 Einheit |
121 <select name="la[eleist]"> |
173 <select name="la[eleist]"> |
122 <?php |
174 <?php |
123 $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=1 ORDER BY right(einheit,1),2"; |
175 $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=1 ORDER BY sort"; |
124 if ($ree = $dbc -> queryObjectArray($sql)) |
176 if ($ree = $dbc -> queryObjectArray($sql)) |
125 { |
177 { |
126 $select = ""; |
178 $select = ""; |
127 foreach ($ree as $row) |
179 foreach ($ree as $row) |
128 { |
180 { |
129 if ($row->einheit_ID == $la['eleist']) $select="selected"; else $select=""; |
181 if ($row->einheit_ID == $la['eleist']) $select="selected"; else $select=""; |
|
182 echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n"; |
|
183 } |
|
184 } |
|
185 ?> |
|
186 </select></td> |
|
187 </tr> |
|
188 <tr><td>max. Leistung</td> |
|
189 <td valign="top"><input type="text" name="la[leistmax]" size="10" maxlength="7" value="<?php echo $la['leistmax']; ?>"/> |
|
190 Einheit |
|
191 <select name="la[eleistmax]"> |
|
192 <?php |
|
193 $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=1 ORDER BY sort"; |
|
194 if ($ree = $dbc -> queryObjectArray($sql)) |
|
195 { |
|
196 $select = ""; |
|
197 foreach ($ree as $row) |
|
198 { |
|
199 if ($row->einheit_ID == $la['eleistmax']) $select="selected"; else $select=""; |
130 echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n"; |
200 echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n"; |
131 } |
201 } |
132 } |
202 } |
133 ?> |
203 ?> |
134 </select></td> |
204 </select></td> |
187 <tr><td>Impulsbreite</td> |
260 <tr><td>Impulsbreite</td> |
188 <td valign="top"><input type="text" name="la[ipb]" size="10" maxlength="7" value="<?php echo $la['ipb']; ?>"/> |
261 <td valign="top"><input type="text" name="la[ipb]" size="10" maxlength="7" value="<?php echo $la['ipb']; ?>"/> |
189 Einheit |
262 Einheit |
190 <select name="la[eipb]"> |
263 <select name="la[eipb]"> |
191 <?php |
264 <?php |
192 if ($ree) |
265 $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=5 ORDER BY sort"; |
|
266 if ($ree = $dbc -> queryObjectArray($sql)) |
193 { |
267 { |
194 $select = ""; |
268 $select = ""; |
195 foreach ($ree as $row) |
269 foreach ($ree as $row) |
196 { |
270 { |
197 if ($row->einheit_ID == $la['eipb']) $select="selected"; else $select=""; |
271 if ($row->einheit_ID == $la['eipb']) $select="selected"; else $select=""; |
198 echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n"; |
272 echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n"; |
199 } |
273 } |
200 } |
274 } |
201 ?> |
275 ?> |
202 </select></td> |
276 </select></td> |
203 </tr> |
|
204 <tr><td>aktiv</td> |
|
205 <td><input type="checkbox" name="la[akt] <?php echo ($la["akt"] )? "checked" : "";?>"/></td> |
|
206 </tr> |
277 </tr> |
207 <tr> |
278 <tr> |
208 <td>Hersteller (Firma)</td> |
279 <td>Hersteller (Firma)</td> |
209 <td> |
280 <td> |
210 <select name="la[hstid]"> |
281 <select name="la[hstid]"> |
211 <?php |
282 <?php |
212 if ($la['hstid'] == -1) $select = " selected "; else $select = ""; |
283 if ($la['hstid'] == -1) $select = " selected "; else $select = ""; |
213 echo "<option $select value=\"-1\"></option>\n"; |
284 echo "<option $select value=\"-1\"></option>\n"; |
214 $sql = "SELECT las_hersteller_ID, las_hersteller_bez FROM Hersteller ORDER BY 2"; |
285 $sql = "SELECT las_hersteller_ID, las_hersteller_bez FROM fhiiqm.Laser_Hersteller ORDER BY 2"; |
215 if ($result = $dbc->queryObjectArray($sql)) |
286 if ($result = $dbc->queryObjectArray($sql)) |
216 { |
287 { |
217 foreach ($result as $row) |
288 foreach ($result as $row) |
218 { |
289 { |
219 if ($row->las_hersteller_ID == $la['hstid']) $select="selected"; else $select=""; |
290 if ($row->las_hersteller_ID == $la['hstid']) $select="selected"; else $select=""; |