equal
deleted
inserted
replaced
111 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID WHERE aktiv < 2 ORDER BY 2"; |
111 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID WHERE aktiv < 2 ORDER BY 2"; |
112 if ($result = $dbc->queryObjectArray($sql)) |
112 if ($result = $dbc->queryObjectArray($sql)) |
113 { |
113 { |
114 foreach ($result as $row) |
114 foreach ($result as $row) |
115 { |
115 { |
116 $select = ( $row->persknr==$rag['ma'][0] ) ? ' selected' : null; |
116 $select = ( $row->persknr==$rag['ma'][0] ) ? "selected='selected' class='selected" : null; |
117 echo "<option $select value=\"$row->persknr\">$row->ma</option>\n"; |
117 if (strpos($row->ma,"inaktiv")) |
|
118 { |
|
119 if ($select) $class = " red'"; else $class=" class='red'"; |
|
120 } |
|
121 else if ($select) $class="'"; else $class=""; |
|
122 echo "<option $select$class value=\"$row->persknr\">$row->ma</option>\n"; |
118 $sma .= "'".$row->persknr."':'".$row->ma."',"; |
123 $sma .= "'".$row->persknr."':'".$row->ma."',"; |
119 } |
124 } |
120 } |
125 } |
121 $sma = substr($sma,0,strlen($sma)-1); |
126 $sma = substr($sma,0,strlen($sma)-1); |
122 ?> |
127 ?> |
144 |
149 |
145 $select = ( "-1" == $mae ) ? ' selected' : null; |
150 $select = ( "-1" == $mae ) ? ' selected' : null; |
146 echo "<option $select value=\"-1\"></option>\n"; |
151 echo "<option $select value=\"-1\"></option>\n"; |
147 foreach ($result as $row) |
152 foreach ($result as $row) |
148 { |
153 { |
149 $select = ( $row->persknr == $mae ) ? ' selected' : null; |
154 $select = ( $row->persknr == $mae ) ? "selected='selected' class='selected" : null; |
150 echo "<option $select value=\"$row->persknr\">$row->ma</option>\n"; |
155 if (strpos($row->ma,"inaktiv")) |
|
156 { |
|
157 if ($select) $class = " red'"; else $class=" class='red'"; |
|
158 } |
|
159 else if ($select) $class="'"; else $class=""; |
|
160 echo "<option $select$class value=\"$row->persknr\">$row->ma</option>\n"; |
151 } |
161 } |
152 echo "</select><br/>\n"; |
162 echo "</select><br/>\n"; |
153 } |
163 } |
154 $i++; |
164 $i++; |
155 } |
165 } |