<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 10/2012
 *
 * Autocomplete Vertragssuche Produkt
 */

    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(utf8_decode($_GET["term"])); // wird in jquery in 'term' uebergeben, term UTF-8 codiert

    $su = array("ä","ö","ü","ß","Ä","Ö","Ü");
    $er = array("&auml;","&ouml;","&uuml;","&szlig;","&Auml;","&Ouml;","&Uuml;");
//    $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,prod_name,part_firma,t.vtyp_kurz,contract_begin
            FROM fhiiqm.Vertrag v LEFT OUTER JOIN fhiiqm.Vertrag_Typ t ON v.vtyp_ID=t.vtyp_ID 
            LEFT OUTER JOIN Vertrag_Partner vp ON v.contract_ID=vp.contract_ID
            LEFT OUTER JOIN Partner p ON vp.part_ID=p.part_ID 
            LEFT OUTER JOIN Produkt_Vertrag prv ON v.contract_ID=prv.contract_ID
            LEFT OUTER JOIN Produkt pr ON prv.produkt_ID=pr.produkt_ID";
    if ($listg > "")
        $sql .= " WHERE prod_group_ID IN ($listg) ";
    else
        $sql .= " WHERE 1=1 ";
    
    $sql .= " AND prod_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 . " | "  . strtoupper($row->prod_name) . " | " . $row->part_firma. " | " . 
             $row->vtyp_kurz . " | VBeginn: " . $cb->format('d.m.Y') . "\"";
		}
        echo "[" . implode(", ", $clist) . "]"; // Format, das jquery source erwartet
    }
    $dbc -> close();
?>