<?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 " <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> </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'> <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ä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'> <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'> <a href=\"/fhiiqm/produkt_ins.php\" target=\"_self\" title=\"Produkt erfassen\">Produkt erfassen</a></p>\n";
*/
}
?>