fhiiqm/inc/vertrag_prod_list_ac.inc.php
changeset 32 c2d325791e24
equal deleted inserted replaced
31:0a1eb975fbd9 32:c2d325791e24
       
     1 <?php
       
     2 
       
     3 /**
       
     4  * @author Bettina Schwarzer, Fritz-Haber-Institut
       
     5  * @copyright 10/2012
       
     6  *
       
     7  * Autocomplete Vertragssuche Produkt
       
     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     // Recht Produktgruppe beruecksichtigen
       
    14     session_start();
       
    15     if (is_array($_SESSION["prodg"]))
       
    16     {
       
    17             foreach ($_SESSION["prodg"] as $val)
       
    18                 $listg .= "," .$val;
       
    19             $listg = substr($listg,1);
       
    20     }
       
    21     else $listg = "";
       
    22     
       
    23     $q = strtolower(utf8_decode($_GET["term"])); // wird in jquery in 'term' uebergeben, term UTF-8 codiert
       
    24 
       
    25     $su = array("ä","ö","ü","ß","Ä","Ö","Ü");
       
    26     $er = array("&auml;","&ouml;","&uuml;","&szlig;","&Auml;","&Ouml;","&Uuml;");
       
    27 //    $er = array("ae","oe","ue","ss","Ae;","Oe","Ue");
       
    28     
       
    29 	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
       
    30 	$dbc = new dbconnection();
       
    31 
       
    32     $sql = "SELECT v.contract_ID,contract_name,prod_name,part_firma,t.vtyp_kurz,contract_begin
       
    33             FROM fhiiqm.Vertrag v LEFT OUTER JOIN fhiiqm.Vertrag_Typ t ON v.vtyp_ID=t.vtyp_ID 
       
    34             LEFT OUTER JOIN Vertrag_Partner vp ON v.contract_ID=vp.contract_ID
       
    35             LEFT OUTER JOIN Partner p ON vp.part_ID=p.part_ID 
       
    36             LEFT OUTER JOIN Produkt_Vertrag prv ON v.contract_ID=prv.contract_ID
       
    37             LEFT OUTER JOIN Produkt pr ON prv.produkt_ID=pr.produkt_ID";
       
    38     if ($listg > "")
       
    39         $sql .= " WHERE prod_group_ID IN ($listg) ";
       
    40     else
       
    41         $sql .= " WHERE 1=1 ";
       
    42     
       
    43     $sql .= " AND prod_name LIKE '%".$q."%' COLLATE latin1_general_ci 
       
    44             ORDER BY contract_name";
       
    45 
       
    46     $result = $dbc ->queryObjectArray($sql);
       
    47     if ($result)
       
    48     {
       
    49         foreach ($result as $row)
       
    50         {
       
    51             $cb = new DateTime($row->contract_begin);
       
    52 // 			$clist[] = "\"" . $row->contract_ID . " - " . str_replace($su,$er,$row->contract_name) . " | " . 
       
    53 //               str_replace($su,$er,$row->vtyp_bezeichnung) . " | VBeginn: " . $cb->format('d.m.Y') . "\"";
       
    54  			$clist[] = "\"" . $row->contract_ID . " - " . $row->contract_name . " | "  . strtoupper($row->prod_name) . " | " . $row->part_firma. " | " . 
       
    55              $row->vtyp_kurz . " | VBeginn: " . $cb->format('d.m.Y') . "\"";
       
    56 		}
       
    57         echo "[" . implode(", ", $clist) . "]"; // Format, das jquery source erwartet
       
    58     }
       
    59     $dbc -> close();
       
    60 ?>