source: newwww/finance/strom.php@ 3

<?
include('../style.php');
include('../db.php');
DB_Init('localhost','root','','is');
ShowHeader('Zaøízení sítì','Zaøízení');

// Seznam segmentù a zaøízení
echo('Stromový výpis struktury sítì:<br>');
DB_Query("SELECT * FROM network_segments WHERE parent = 0");
$root = DB_Row();
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);
DB_Query("SELECT * FROM users WHERE network_segment = ".$parent[$level]);
$count[0]+=DB_NumRows();
DB_Query("SELECT * FROM network_devices WHERE segment = ".$parent[$level]);
$count[0]+=DB_NumRows();
DB_Query("SELECT * FROM network_segments WHERE parent = ".$parent[$level]);
$count[0]+=DB_NumRows();


function showlines($type) {
  global $count, $position, $level;
  $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) {
    DB_Query("SELECT * FROM users WHERE network_segment = ".$parent[$level]);
    $devs = 0;
    while ($item=DB_Row()) {
      $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) {
    DB_Query("SELECT * FROM network_devices WHERE segment = ".$parent[$level]);
    $devs = 0;
    while ($item=DB_Row()) {
      $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]) {
    DB_Query("SELECT * FROM network_segments WHERE parent = ".$parent[$level].' LIMIT '.$position[$level].',1');
    $item = DB_Row();
    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;
    DB_Query("SELECT * FROM users WHERE network_segment = ".$parent[$level]);
    $count[$level]+=DB_NumRows();
    DB_Query("SELECT * FROM network_devices WHERE segment = ".$parent[$level]);
    $count[$level]+=DB_NumRows();
    DB_Query("SELECT * FROM network_segments WHERE parent = ".$parent[$level]);
    $count[$level]+=DB_NumRows();
  } else {
    $level--;
  }
} while ($level>=0);

ShowFooter();
?>