82 } |
82 } |
83 } |
83 } |
84 ?> |
84 ?> |
85 </select> |
85 </select> |
86 </td> |
86 </td> |
87 <tr> |
87 </tr> |
88 <td>Reinigungs-Typ</td> |
88 <tr> |
|
89 <td> Reinigungs-Typ</td> |
89 <td><select name="raum[reityp]"> |
90 <td><select name="raum[reityp]"> |
90 <?php |
91 <?php |
91 if ($raum['reityp'] == -1) $select = " selected "; else $select = ""; |
92 if ($raum['reityp'] == -1) $select = " selected "; else $select = ""; |
92 echo "<option $select value=\"-1\"></option>\n"; |
93 echo "<option $select value=\"-1\"></option>\n"; |
93 $sql = "SELECT reinigung_typ_ID, reinigung_typ_bez FROM fhiiqm.Reinigung_Typ ORDER BY 1"; |
94 $sql = "SELECT reinigung_typ_ID, reinigung_typ_bez FROM fhiiqm.Reinigung_Typ ORDER BY 1"; |
98 if ($row->reinigung_typ_ID == $raum['reityp']) |
99 if ($row->reinigung_typ_ID == $raum['reityp']) |
99 echo "<option selected value=\"$row->reinigung_typ_ID\">$row->reinigung_typ_ID: $row->reinigung_typ_bez</option>\n"; |
100 echo "<option selected value=\"$row->reinigung_typ_ID\">$row->reinigung_typ_ID: $row->reinigung_typ_bez</option>\n"; |
100 else |
101 else |
101 echo "<option value=\"$row->reinigung_typ_ID\">$row->reinigung_typ_ID: $row->reinigung_typ_bez</option>\n"; |
102 echo "<option value=\"$row->reinigung_typ_ID\">$row->reinigung_typ_ID: $row->reinigung_typ_bez</option>\n"; |
102 } |
103 } |
103 } |
104 } |
|
105 ?> |
|
106 </select> |
|
107 </td> |
|
108 </tr> |
|
109 <tr> |
|
110 <td> Bodentyp</td> |
|
111 <td><select name="raum[boden]"> |
|
112 <?php |
|
113 if ($raum['boden'] == -1) $select = " selected "; else $select = ""; |
|
114 echo "<option $select value=\"-1\"></option>\n"; |
|
115 $sql = "SELECT boden_typ_ID, boden_typ_bez FROM fhiiqm.Boden_Typ ORDER BY 2"; |
|
116 if ($result = $dbc->queryObjectArray($sql)) |
|
117 { |
|
118 foreach ($result as $row) |
|
119 { |
|
120 if ($row->boden_typ_ID == $raum['boden']) |
|
121 echo "<option selected value=\"$row->boden_typ_ID\">$row->boden_typ_bez</option>\n"; |
|
122 else |
|
123 echo "<option value=\"$row->boden_typ_ID\">$row->boden_typ_bez</option>\n"; |
|
124 } |
|
125 } |
|
126 ?> |
|
127 </select> |
|
128 </td> |
|
129 </tr> |
|
130 <tr> |
|
131 <td> Reinigungs-Kategorie</td> |
|
132 <td><select name="raum[reikat]"> |
|
133 <?php |
|
134 if ($raum['reikat'] == -1) $select = " selected "; else $select = ""; |
|
135 echo "<option $select value=\"-1\"></option>\n"; |
|
136 $sql = "SHOW COLUMNS FROM Raum WHERE Field = 'reinigung_kat'"; |
|
137 if ($result = $dbc->queryRow($sql)) |
|
138 { |
|
139 //print_r($result); |
|
140 foreach ($result as $row) |
|
141 $arr=explode("','",preg_replace("/(enum|set)\('(.+?)'\)/","\\2",$row[1])); |
|
142 //print "werte =";print_r($werte); |
|
143 foreach ($arr as $kat) |
|
144 { |
|
145 if ($kat == $raum["reikat"]) |
|
146 echo "<option selected value=\"$kat\">$kat</option>\n"; |
|
147 else |
|
148 echo "<option value=\"$kat\">$kat</option>\n"; |
|
149 } |
|
150 } |
|
151 ?> |
|
152 </select> |
|
153 </td> |
|
154 </tr> |
|
155 <tr> |
|
156 <td> Reinigungs-Turnus</td> |
|
157 <td><select name="raum[reitur]"> |
|
158 <?php |
|
159 if ($raum['reitur'] == -1) $select = " selected "; else $select = ""; |
|
160 echo "<option $select value=\"-1\"></option>\n"; |
|
161 $sql = "SELECT reinigung_turnus_ID, reinigung_turnus_bez FROM fhiiqm.Reinigung_Turnus ORDER BY 1"; |
|
162 if ($result = $dbc->queryObjectArray($sql)) |
|
163 { |
|
164 foreach ($result as $row) |
|
165 { |
|
166 if ($row->reinigung_turnus_ID == $raum['reitur']) |
|
167 echo "<option selected value=\"$row->reinigung_turnus_ID\">$row->reinigung_turnus_bez</option>\n"; |
|
168 else |
|
169 echo "<option value=\"$row->reinigung_turnus_ID\">$row->reinigung_turnus_bez</option>\n"; |
|
170 } |
|
171 } |
104 ?> |
172 ?> |
105 </select> |
173 </select> |
106 </td> |
174 </td> |
107 </tr> |
175 </tr> |
108 <tr> |
176 <tr> |