22 FROM fhiiqm.Mitarbeiter |
22 FROM fhiiqm.Mitarbeiter |
23 WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
23 WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
24 ORDER BY 1"; |
24 ORDER BY 1"; |
25 */ |
25 */ |
26 if (isset($abt) && $abt == "a") $ord = "abt_ID, "; else $ord = ""; |
26 if (isset($abt) && $abt == "a") $ord = "abt_ID, "; else $ord = ""; |
27 $sql = "SELECT CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') as label, |
27 $sql = "SELECT CONCAT (nachname, ', ',IFNULL(vorname,''), ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') as label, |
28 CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''), ' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') as val,persknr as id |
28 CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''), ' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') as val,persknr as id |
29 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID |
29 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID |
30 WHERE aktiv < 2 AND nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
30 WHERE aktiv < 2 AND nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
31 ORDER BY ". $ord ."1"; |
31 ORDER BY ". $ord ."1"; |
32 $result = $dbc ->queryObjectArray($sql); |
32 $result = $dbc ->queryObjectArray($sql); |