');
$DbResult = $Database->query("SELECT * FROM network_segments WHERE parent = 0");
$root = $DbResult->fetch_array();
echo '
'.$root['name'].'
';
$level = 0;
$parent = array($root['id']);
$position = array(0);
$count = array(0);
$DbResult = $Database->query("SELECT * FROM users WHERE network_segment = ".$parent[$level]);
$count[0] += $DbResult->fetch_array();
$DbResult = $Database->query("SELECT * FROM network_devices WHERE segment = ".$parent[$level]);
$count[0] += $DbResult->fetch_array();
$DbResult = $Database->query("SELECT * FROM network_segments WHERE parent = ".$parent[$level]);
$count[0] += $DbResult->fetch_array();
function showlines($type)
{
global $count, $position, $level, $Database;
$i = 0;
while ($i < $level)
{
if ($position[$i]<$count[$i])
{
echo '
';
} else
{
echo '
';
}
$i++;
}
if ($type==0)
{
if ($position[$i]<$count[$i])
{
echo '
';
} else
{
echo '
';
}
} else
{
if ($position[$i]<$count[$i])
{
echo '
';
} else {
echo '
';
}
}
return 0;
}
do
{
if ($position[$level]==0)
{
$DbResult = $Database->query("SELECT * FROM users WHERE network_segment = ".$parent[$level]);
$devs = 0;
while ($item = $DbResult->fetch_array)
{
$position[$level]++;
$devs++;
showlines(0);
echo '
'.$item['fullname'].'
';
}
$position[$level] = 0;
$count[$level] -= $devs;
}
if ($position[$level]==0)
{
$DbResult = $Database->query("SELECT * FROM network_devices WHERE segment = ".$parent[$level]);
$devs = 0;
while ($item = $DbResult->fetch_array())
{
$position[$level]++;
$devs++;
if ($item['used']==1)
{
showlines(0);
echo '
'.$item['name'].'
';
} else {
// showlines(0);
// echo '
'.$item['name'].'
';
}
}
$position[$level] = 0;
$count[$level] -= $devs;
}
if ($position[$level]<$count[$level])
{
$DbResult = $Database->query("SELECT * FROM network_segments WHERE parent = ".$parent[$level].' LIMIT '.$position[$level].',1');
$item = $DbResult->fetch_array;
if (!$item)
{
echo '
Došlo k chybě!!';
break;
}
$position[$level]++;
showlines(1);
echo '
'.$item['name'].'
';
$level++;
$parent[$level]=$item['id'];
$position[$level] = 0;
$count[$level] = 0;
$DbResult = $Database->query("SELECT * FROM users WHERE network_segment = ".$parent[$level]);
$count[$level] += $DbResult->fetch_array;
$DbResult = $Database->query("SELECT * FROM network_devices WHERE segment = ".$parent[$level]);
$count[$level] += $DbResult->fetch_array;
$DbResult = $Database->query("SELECT * FROM network_segments WHERE parent = ".$parent[$level]);
$count[$level] += $DbResult->fetch_array;
} else
{
$level--;
}
} while($level >= 0);
ShowFooter();
?>