<?php

/**

 * @author Bettina Schwarzer, Fritz-Haber-Institut

 * @copyright 08/2012

 * 

 * prod_hier.php fuer tab

 */

    error_reporting(E_ALL ^ E_NOTICE);

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

    session_start();

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

    { 

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

        login($_SERVER["PHP_SELF"]);

        exit;

    }

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

    {

        header("Location: start.php");

        exit;

    }    

    // Recht Produktgruppe beruecksichtigen

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

    {

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

            $listg .= "," .$val;

        $listg = substr($listg,1);

    }

    else

        $listg="";

    echo " ";  

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

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

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

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

    $prods = $_POST['prods'];

    if (!$prods)

    { 

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

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

    }   

    $submit = $_POST['search'];

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

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

	$dbc = new dbconnection();

    if (!$submit)

    {

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

   ?>

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

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

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

        </p>

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

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

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

        <tr>

            <td>Produktbereich</td>

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

                <?php 

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

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

                    if ($listg > "")

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

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

                                WHERE prod_group_ID IN ($listg)

                                ORDER BY 2";

                    else

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

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

                    {

                        foreach ($result as $row)

                        {

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

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

        				    else

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

                        }

                }

                ?>

                </select>

            </td>

        </tr>

        <tr>

            <td>Produktgruppe</td>

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

                <?php 

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

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

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

                    { 

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

                        if ($listg > "")

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

                    }     

                    elseif ($listg > "")

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

                    else 

                        $where = "";

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

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

                    {

                        foreach ($result as $row)

                        {

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

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

        				    else

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

                        }

                }

                ?>

                </select>

            </td>

        </tr>

    <?php

		echo "<tr>\n";

		echo "

		  <td>&nbsp;</td>

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

		echo "</tr>\n";

        echo "</table>\n";

        echo "</div>\n";

        echo "</form>\n";	

        echo "</div>\n";

    }

    else

    {

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

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

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

        {

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

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

        }

        else

        {

            $prods['ber']=0;

            $prods['grp']=0;

        }

        // Recht Produktgruppe beruecksichtigen

        if ($listg > "")

        {

            if ($prods['grp'])    

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

            else                

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

        }

        else 

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

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

		{

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

			$bg1 = "#F8F8F8";

			$bg2 = "#DEDFE1";

			$bg = "#FFFFFF";

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

//            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";

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

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

				<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";

			foreach($result as $row)

			{

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

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

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

                else 

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

                if ($row->level == 4)

                {

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

                    $class = " class='green'";

                }    

                else

                {

                    $hier=" ";

                    $class = "";

                }    

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

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

			}

				echo "</table>\n";

//			$dbc->close();

		}

		else

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

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

		{

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

		} */

        echo "</div>\n";

/*

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

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

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

*/

    }

?>