|
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("ä","ö","ü","ß","Ä","Ö","Ü"); |
|
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 ?> |