<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 12/2011
 *
 * Autocomplete Vertraege Anlagen
 */

    header('Content-type: text/html; charset="iso-8859-1',true); //wg. jquery ui autocomplete
    error_reporting(E_ALL ^ E_NOTICE);
    
    $q = strtolower($_GET["term"]); // wird in jquery in 'term' uebergeben

    
	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
	$dbc = new dbconnection();
    // label = angezeigter ListenWert, val = Wert im Eingabefeld nach Klick
    $sql = "SELECT contract_name as label, contract_name as val, contract_ID as id 
            FROM fhiiqm.Vertrag
            WHERE contract_name LIKE '%".$q."%' COLLATE latin1_general_ci 
            ORDER BY 1";
    $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();
?>