1 <?php

     2 

     3 /**

     4  * @author Bettina Schwarzer, Fritz-Haber-Institut

     5  * @copyright 08/2012

     6  * 

     7  * prod_hier.php fuer tab

     8  */

     9 

    10     error_reporting(E_ALL ^ E_NOTICE);

    11     header('Content-type: text/html; charset="iso-8859-1',true);    

    12 

    13     session_start();

    14     if (! isset($_SESSION["userid"]))

    15     { 

    16         include_once ($_SERVER["DOCUMENT_ROOT"]."/fhiiqm/inc/func_lib.inc.php");	

    17         login($_SERVER["PHP_SELF"]);

    18         exit;

    19     }

    20     

    21     if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("pr",$_SESSION["recht"]) && !in_array("pe",$_SESSION["recht"])))

    22     {

    23         header("Location: start.php");

    24         exit;

    25     }    

    26     // Recht Produktgruppe beruecksichtigen

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

    28     {

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

    30             $listg .= "," .$val;

    31         $listg = substr($listg,1);

    32     }

    33     else

    34         $listg="";

    35 

    36     echo " ";  

    37     echo "<div class=\"float-br smaller\" valign='top'>";

    38     echo "   user: " . $_SESSION["userid"];

    39     echo "&nbsp;&nbsp;&nbsp;<a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";

    40     echo "<div class=\"float-r\"><img src=\"/fhiiqm/img/node-tree.png\" border=\"0\" alt=\"Produkte\" title=\"Produkte\"/></div>\n";

    41 

    42     $prods = $_POST['prods'];

    43     if (!$prods)

    44     { 

    45         $prods['ber'] = $_GET["p"];

    46         $prods['grp'] = $_GET["p"];

    47     }   

    48     $submit = $_POST['search'];

    49     if (!$submit) $submit = $_GET["s"];

    50 

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

    52 	$dbc = new dbconnection();

    53 

    54     

    55     if (!$submit)

    56     {

    57         echo "<div align='center'>\n";

    58    ?>

    59         <p><b>Produkthierarchie</b><br /><br />

    60             Sie können einen Produktbereich und/oder eine Produktgruppe wählen oder<br />

    61             die gesamte Hierarchie anschauen, indem Sie nur auf 'zeigen' klicken.  

    62         </p>

    63         <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_prod_search" target="_self">	

    64         <!-- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_prod_search" target="_self"> -->	

    65         <table width="50%" border="0" cellspacing="3" cellpadding="3">

    66         <tr>

    67             <td>Produktbereich</td>

    68             <td><select name="prods[ber]" onchange="this.form.submit();">

    69                 <?php 

    70                     if ($prods['ber'] == 0) $select = " selected "; else $select = "";

    71                     echo "<option $select value=\"0\"></option>\n";

    72                     if ($listg > "")

    73                         $sql = "SELECT DISTINCT b.prod_ber_ID,prod_ber_name FROM

    74                                 fhiiqm.Produkt_Bereich b INNER JOIN fhiiqm.Produkt_Gruppe g ON b.prod_ber_ID=g.prod_ber_ID

    75                                 WHERE prod_group_ID IN ($listg)

    76                                 ORDER BY 2";

    77                     else

    78                         $sql = "SELECT prod_ber_ID, prod_ber_name FROM Produkt_Bereich ORDER BY 1";

    79                     if ($result = $dbc->queryObjectArray($sql))

    80                     {

    81                         foreach ($result as $row)

    82                         {

    83                             if ($row->prod_ber_ID == $prods['ber'])

    84         					   echo "<option selected value=\"$row->prod_ber_ID\">$row->prod_ber_ID $row->prod_ber_name</option>\n";

    85         				    else

    86         					   echo "<option value=\"$row->prod_ber_ID\">$row->prod_ber_ID $row->prod_ber_name</option>\n";

    87                         }

    88                 }

    89                 ?>

    90                 </select>

    91             </td>

    92         </tr>

    93         <tr>

    94             <td>Produktgruppe</td>

    95             <td><select name="prods[grp]">

    96                 <?php 

    97                     if ($prods['grp'] == 0) $select = " selected "; else $select = "";

    98                     echo "<option $select value=\"0\"></option>\n";

    99                     if (isset($prods['ber']))

   100                     { 

   101                         $where = "WHERE prod_ber_ID = " . $prods['ber'];

   102                         if ($listg > "")

   103                             $where = "WHERE prod_group_ID IN ($listg) ";

   104                     }     

   105                     elseif ($listg > "")

   106                         $where = "WHERE prod_group_ID IN ($listg) ";

   107                     else 

   108                         $where = "";

   109                     $sql = "SELECT prod_group_ID, prod_group_name, prod_group_hier FROM Produkt_Gruppe $where ORDER BY 3";

   110                     if ($result = $dbc->queryObjectArray($sql))

   111                     {

   112                         foreach ($result as $row)

   113                         {

   114                             if ($row->prod_group_ID == $prods['grp'])

   115         					   echo "<option selected value=\"$row->prod_group_ID\">$row->prod_group_hier $row->prod_group_name</option>\n";

   116         				    else

   117         					   echo "<option value=\"$row->prod_group_ID\">$row->prod_group_hier $row->prod_group_name</option>\n";

   118                         }

   119                 }

   120                 ?>

   121                 </select>

   122             </td>

   123         </tr>

   124     <?php

   125 		echo "<tr>\n";

   126 		echo "

   127 		  <td>&nbsp;</td>

   128 		  <td align=\"left\"><input class=\"button\" type=\"submit\" value=\"zeigen\" name=\"search\" title=\"search\" /></td>\n";

   129 		echo "</tr>\n";

   130         echo "</table>\n";

   131         echo "</div>\n";

   132         echo "</form>\n";	

   133         echo "</div>\n";

   134     }

   135     else

   136     {

   137 //        echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/prod_hier.php\" target=\"_self\" title=\"Produkthierarchie\">neue Auswahl Produkthierarchie</a></p>\n";    

   138         echo "<div align='center'>\n";

   139         if ($prods['ber'] || $prods['grp'])

   140         {

   141             if (!$prods['grp']) $prods['grp']=0;

   142             if (!$prods['ber']) $prods['ber']=0;

   143         }

   144         else

   145         {

   146             $prods['ber']=0;

   147             $prods['grp']=0;

   148         }

   149         

   150         // Recht Produktgruppe beruecksichtigen

   151         if ($listg > "")

   152         {

   153             if ($prods['grp'])    

   154                 $sql = "CALL fhiiqm.hier_prodgroup('" . $prods['grp'] ."')";

   155             else                

   156                 $sql = "CALL fhiiqm.hier_prodgroup('$listg')";                

   157         }

   158         else 

   159         $sql = "CALL prod_hiera_all(" .$prods['ber'].",".$prods['grp'].")";

   160 		if ($result = $dbc->queryObjectArray($sql))

   161 		{

   162 //			printf ("<p>Es wurden %s Saetze gefunden.</p>", $dbc->numrows($sql));

   163 			$bg1 = "#F8F8F8";

   164 			$bg2 = "#DEDFE1";

   165 			$bg = "#FFFFFF";

   166 			echo "<p><b>Produkthierarchie</b></p>\n";

   167 //            echo "<p>Die Produkte (unterste Hierarchieebene) können Sie mittels Klick auf '<img src=\"img/edit.gif\" alt='edit' title='edit' border='0'/>' editiern</p>\n";

   168 			echo "<table cellpadding='2' width='99%'>";

   169 			echo "<tr bgcolor='#68ACBF'><th align='left'>Hierarchie</th>

   170 				<th align='left'>Produkt-Kategorie</th><th align='left'>AG (Abteilung)</th><th align='left'>Wichtigkeit</th><th align='left'>Bindungsst&auml;rke</th><th align='left'>Bemerkung</th></tr>\n";

   171 			foreach($result as $row)

   172 			{

   173 				if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;

   174                 if (strlen($row->bez) > 70) 

   175                     $prod=str_replace(" ","  ",htmlentities(substr($row->bez,0,70))) ."..."; 

   176                 else 

   177                     $prod=str_replace(" ","  ",htmlentities($row->bez));

   178                 if ($row->level == 4)

   179                 {

   180                     $hier="<a href='produkt_upd.php?uid=$row->prid'><img src=\"img/edit.gif\" alt='edit' title='edit' border='0'/></a>";

   181                     $class = " class='green'";

   182                 }    

   183                 else

   184                 {

   185                     $hier=" ";

   186                     $class = "";

   187                 }    

   188 				print "<tr bgcolor='" . $bg . "'><td>$row->hier</td>

   189                     <td$class>$prod</td><td>$row->ag</td><td>$row->imp</td><td>$row->conn</td><td>$row->bem</td></tr>";

   190 			}

   191 				echo "</table>\n";

   192 //			$dbc->close();

   193 		}

   194 		else

   195 			echo "leider kein Ergebnis!<br>\n";

   196 /*    		if ($result = $dbc -> querySingleItem("SELECT COUNT(*) FROM Produkt"))

   197 		{

   198 			echo "<p>Tabelle 'produkt' enthaelt $result Eintraege</p>\n";

   199 		} */

   200         echo "</div>\n";

   201 /*

   202         echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/prod_hier.php\" target=\"_self\" title=\"Produkthierarchie\">neue Auswahl Produkthierarchie</a></p>\n";    

   203         if (!is_null($_SESSION["recht"]) && in_array("pe",$_SESSION["recht"]))

   204             echo "<p class='sc'>&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/produkt_ins.php\" target=\"_self\" title=\"Produkt erfassen\">Produkt erfassen</a></p>\n";    

   205 */

   206     }

   207 

   208 ?>