| changeset 17 | f990704af47b |
| parent 7 | d2fe4fb36670 |
| child 18 | d0aa14180761 |
| 16:3ebe66308a00 | 17:f990704af47b |
|---|---|
13 $q = strtolower($_GET["term"]); // wird in jquery in 'term' uebergeben |
13 $q = strtolower($_GET["term"]); // wird in jquery in 'term' uebergeben |
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 |
18 // label = angezeigter ListenWert, val = Wert im Eingabefeld nach Klick |
19 $sql = "SELECT CONCAT (nachname, ', ',vorname) as label, CONCAT (nachname, ', ',vorname) as val,persknr as id |
19 $sql = "SELECT CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'ehemals' END, ')') as label, |
20 CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'ehemals' END, ')') as val,persknr as id |
|
20 FROM fhiiqm.Mitarbeiter |
21 FROM fhiiqm.Mitarbeiter |
21 WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
22 WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
22 ORDER BY 1"; |
23 ORDER BY 1"; |
23 $result = $dbc ->queryObjectArray($sql); |
24 $result = $dbc ->queryObjectArray($sql); |
24 if ($result) |
25 if ($result) |