fhiiqm/form/raumarbgr_form.inc.php
changeset 33 f1a8785434e4
parent 28 8d8bce56918f
child 34 fc60ef80a7ad
--- a/fhiiqm/form/raumarbgr_form.inc.php	Fri Nov 16 10:40:03 2012 +0100
+++ b/fhiiqm/form/raumarbgr_form.inc.php	Fri Dec 21 15:31:50 2012 +0100
@@ -108,7 +108,7 @@
                 $select = ( "-1"==$rag['ma'][0] ) ? ' selected' : null;
                 echo "<option $select value=\"-1\"></option>\n";
                 $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') AS ma
-                 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID ORDER BY 2";
+                 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID WHERE aktiv < 2 ORDER BY 2";
                 if ($result = $dbc->queryObjectArray($sql))
                 {
                     foreach ($result as $row)