<?php

/**

 * @author Bettina Schwarzer, Fritz-Haber-Institut

 * @copyright 04/2012

 *

 * Autocomplete Mitarbeitersuche

 */

    header('Content-type: text/html; charset="iso-8859-1',true); //wg. jquery ui autocomplete

    error_reporting(E_ALL ^ E_NOTICE);

    $q = strtolower(utf8_decode($_GET["term"])); // wird in jquery in 'term' uebergeben

//    echo "q = $q<br />";

    $abt = $_GET["s"]; // Sortierung zuerst nach Abteilung (laser)

	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");

	$dbc = new dbconnection();

    // label = angezeigter ListenWert, val = Wert im Eingabefeld nach Klick

/*    $sql = "SELECT  CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as label, 

            CONCAT (nachname, ', ',vorname, ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as val,persknr as id 

            FROM fhiiqm.Mitarbeiter

            WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci 

            ORDER BY 1";

*/

    if (isset($abt) && $abt == "a") $ord = "abt_ID, "; else $ord = "";

    $sql = "SELECT CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as label, 

            CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''), ' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as val,persknr as id 

            FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID

            WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci 

            ORDER BY ". $ord ."1";

//    echo "sql = $sql<br />";

    $result = $dbc ->queryObjectArray($sql);

    if ($result)

    {

        foreach ($result as $row)

        {

 			$clist[] = "{\"label\": \"" . $row->label . "\",\"value\": \"" . $row->val . "\",\"id\": " . $row->id . "}";

		}

        echo "[" . implode(", ", $clist) . "]"; // Format, das jquery source erwartet

    }

    $dbc -> close();

?>