14 |
14 |
15 |
15 |
16 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
16 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
17 $dbc = new dbconnection(); |
17 $dbc = new dbconnection(); |
18 // label = angezeigter ListenWert, val = Wert im Eingabefeld nach Klick |
18 // label = angezeigter ListenWert, val = Wert im Eingabefeld nach Klick |
19 $sql = "SELECT CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as label, |
19 /* $sql = "SELECT CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as label, |
20 CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as val,persknr as id |
20 CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as val,persknr as id |
21 FROM fhiiqm.Mitarbeiter |
21 FROM fhiiqm.Mitarbeiter |
|
22 WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
|
23 ORDER BY 1"; |
|
24 */ |
|
25 $sql = "SELECT CONCAT (nachname, ', ',vorname, ', ' , abt_name,' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as label, |
|
26 CONCAT (nachname, ', ',vorname, ', ' , abt_name, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as val,persknr as id |
|
27 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID |
22 WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
28 WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
23 ORDER BY 1"; |
29 ORDER BY 1"; |
24 $result = $dbc ->queryObjectArray($sql); |
30 $result = $dbc ->queryObjectArray($sql); |
25 if ($result) |
31 if ($result) |
26 { |
32 { |