|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 04/2012 |
|
6 * |
|
7 * Autocomplete Mitarbeitersuche |
|
8 */ |
|
9 |
|
10 header('Content-type: text/html; charset="iso-8859-1',true); //wg. jquery ui autocomplete |
|
11 error_reporting(E_ALL ^ E_NOTICE); |
|
12 |
|
13 $q = strtolower(utf8_decode($_GET["term"])); // wird in jquery in 'term' uebergeben |
|
14 // echo "q = $q<br />"; |
|
15 |
|
16 $abt = $_GET["s"]; // Sortierung zuerst nach Abteilung (laser) |
|
17 |
|
18 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
|
19 $dbc = new dbconnection(); |
|
20 // label = angezeigter ListenWert, val = Wert im Eingabefeld nach Klick |
|
21 /* $sql = "SELECT CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as label, |
|
22 CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as val,persknr as id |
|
23 FROM fhiiqm.Mitarbeiter |
|
24 WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
|
25 ORDER BY 1"; |
|
26 */ |
|
27 if (isset($abt) && $abt == "a") $ord = "abt_ID, "; else $ord = ""; |
|
28 $sql = "SELECT CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as label, |
|
29 CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''), ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as val,persknr as id |
|
30 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID |
|
31 WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci |
|
32 ORDER BY ". $ord ."1"; |
|
33 // echo "sql = $sql<br />"; |
|
34 $result = $dbc ->queryObjectArray($sql); |
|
35 if ($result) |
|
36 { |
|
37 foreach ($result as $row) |
|
38 { |
|
39 $clist[] = "{\"label\": \"" . $row->label . "\",\"value\": \"" . $row->val . "\",\"id\": " . $row->id . "}"; |
|
40 } |
|
41 echo "[" . implode(", ", $clist) . "]"; // Format, das jquery source erwartet |
|
42 } |
|
43 $dbc -> close(); |
|
44 ?> |