<?php

/**

 * @author Bettina Schwarzer, Fritz-Haber-Institut

 * @copyright 09/2011

 *

 * Autocomplete Vertragssuche

 */

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

    error_reporting(E_ALL ^ E_NOTICE);

    // Recht Produktgruppe beruecksichtigen

    session_start();

    if (is_array($_SESSION["prodg"]))

    {

            foreach ($_SESSION["prodg"] as $val)

                $listg .= "," .$val;

            $listg = substr($listg,1);

    }

    else $listg = "";

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

    $su = array("ä","ö","ü","ß","Ä","Ö","Ü");

    $er = array("ä","ö","ü","ß","Ä","Ö","Ü");

//    $er = array("ae","oe","ue","ss","Ae;","Oe","Ue");

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

	$dbc = new dbconnection();

    $sql = "SELECT v.contract_ID,contract_name,t.vtyp_bezeichnung,contract_begin

            FROM fhiiqm.Vertrag v LEFT OUTER JOIN fhiiqm.Vertrag_Typ t ON v.vtyp_ID=t.vtyp_ID ";

    if ($listg > "")

        $sql .= " LEFT OUTER JOIN fhiiqm.Produkt_Vertrag pv ON v.contract_ID=pv.contract_ID

            LEFT JOIN fhiiqm.Produkt p ON pv.produkt_ID=p.produkt_ID 

            WHERE prod_group_ID IN ($listg) ";

    else

        $sql .= " WHERE 1=1 ";

    $sql .= " AND contract_name LIKE '%".$q."%' COLLATE latin1_general_ci 

            ORDER BY contract_name";

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

    if ($result)

    {

        foreach ($result as $row)

        {

            $cb = new DateTime($row->contract_begin);

// 			$clist[] = "\"" . $row->contract_ID . " - " . str_replace($su,$er,$row->contract_name) . " | " . 

//               str_replace($su,$er,$row->vtyp_bezeichnung) . " | VBeginn: " . $cb->format('d.m.Y') . "\"";

 			$clist[] = "\"" . $row->contract_ID . " - " . $row->contract_name . " | " . 

             $row->vtyp_bezeichnung . " | VBeginn: " . $cb->format('d.m.Y') . "\"";

		}

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

    }

    $dbc -> close();

?>