<?php
/**
* @author Bettina Schwarzer, Fritz-Haber-Institut
* @copyright 02/2012
*
* hierarchie
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/>
<link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/>
<title>Hierarchie</title>
</head>
<body>
<?php
include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
$dbc = new dbconnection();
$id = $_GET["i"];
if (!$id) $id=0;
$stat = $_GET["s"];
if (!isset($stat)) $stat=1;
echo "<div align='center'>\n";
echo "<h3>Test: Hierarchie</h3>\n";
// lineage der gesuchten ID
if ($id > 0)
{
$sql = "SELECT h_lineage FROM hierarchie WHERE h_ID=$id";
$lin = $dbc->querySingleItem($sql);
}
echo "<table cellspacing='10'><tr><td>";
// Hierarchie
echo "<p> hierarchische Sicht</p>\n";
$sql = "CALL hier4id($id,$stat)";
if ($result = $dbc -> queryObjectArray($sql))
{
$bg1 = "#F8F8F8";
$bg2 = "#DEDFE1";
$bg = "#FFFFFF";
echo "<table><tr bgcolor='#68ACBF'><th>ID</th><th>Bezeichnung</th></tr>\n";
foreach ($result as $row)
{
if (strpos($lin,$row->h_lineage) !== false) //liegt ueber betrachteter ID
{
//echo "oberhalb: ". $row->h_lineage . " in $lin<br />";
$status = 0;
$sign = "<img src='/fhiiqm/img/minus.gif' />";
$title = "reduzieren";
if ($row->h_lineage == $lin && $stat == 0)
{
$status = 1;
$sign = "<img src='/fhiiqm/img/plus.gif' />";
$title = "erweitern";
}
}
else
{
//echo "andere: $lin (aktuell) ". $row->h_lineage . "<br />";
$status = 1;
$sign = "<img src='/fhiiqm/img/plus.gif' />";
$title = "erweitern";
}
//$sign = ($id == $row->h_ID)? '-':'+';
if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
echo "<tr bgcolor='" . $bg . "'>";
echo "<td><a href='".$_SERVER["PHP_SELF"]."?i=".trim($row->h_ID)."&s=$status' title='$title'>". str_repeat(" ",($row->h_deep*2));
echo " $sign </a>";
echo "$row->h_ID</td><td>$row->h_bez</td></tr>\n";
}
echo "</table>\n";
}
echo "</td><td>";
// gesamte Tabelle
echo "<p> gesamte Tabelle</p>\n";
$sql = "SELECT CONCAT(REPEAT(' ',h_deep*2),h_ID) AS ID,h_bez,h_par_ID,h_deep,h_lineage FROM fhiiqm.hierarchie ORDER BY h_lineage";
if ($result = $dbc -> queryObjectArray($sql))
{
$bg1 = "#F8F8F8";
$bg2 = "#DEDFE1";
$bg = "#FFFFFF";
echo "<table><tr bgcolor='#68ACBF'><th>ID</th><th>Bezeichnung</th></tr>\n";
foreach ($result as $row)
{
if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
echo "<tr bgcolor='" . $bg . "'>";
echo "<td>$row->ID</td><td>$row->h_bez</td></tr>\n";
}
echo "</table>\n";
}
echo "</td></tr></table>";
echo "</div>\n";
?>
</body></html>