source: www/finance/strom.php@ 8

<?php
include('../global.php');
include('../style.php');
ShowHeader('Zařízení sítě', 'Zařízení');

// Seznam segmentů a zařízení
echo('Stromový výpis struktury sítě:<br>');
$DbResult = $Database->query("SELECT * FROM network_segments WHERE parent = 0");
$root = $DbResult->fetch_array();
echo '<img src="../images/strom/server.png" width="16" height="16"/>&nbsp;'.$root['name'].'<br/>';
$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 '<img src="../images/strom/line.gif" width="16" height="16"/>';
    } else 
    {
      echo '<img src="../images/strom/null.gif" width="16" height="16"/>';
    }
    $i++;
  }
  if ($type==0) 
  {
    if ($position[$i]<$count[$i]) 
    {
      echo '<img src="../images/strom/sub.gif" width="16" height="16"/>';
    } else 
    {
      echo '<img src="../images/strom/sub_.gif" width="16" height="16"/>';
    }
  } else 
  {
    if ($position[$i]<$count[$i]) 
    {
      echo '<img src="../images/strom/plus.gif" width="16" height="16"/>';
    } else {
      echo '<img src="../images/strom/plus_.gif" width="16" height="16"/>';
    }
  }
  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 '<img src="../images/strom/comp.png" width="16" height="16"/>&nbsp;'.$item['fullname'].'<br/>';
    }
    $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 '<img src="../images/strom/device.png" width="16" height="16"/>&nbsp;'.$item['name'].'<br/>';
      } else {
//        showlines(0);
//        echo '<img src="../images/strom/device_.png" width="16" height="16"/>&nbsp;'.$item['name'].'<br/>';
      }
    }
    $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 '<br/>Došlo k chybě!!</br>';
      break;
    }
    $position[$level]++;
    showlines(1);
    echo '<img src="../images/strom/volume.png" width="16" height="16"/>&nbsp;'.$item['name'].'<br/>';
    $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();
?>