source: www/web/calculate_wlan.php@ 1

<?
include_once('db.php');
//include_once('../html/is/error.php');
DB_Init('localhost','root','','is');

ini_set('error_reporting', E_ALL);
ini_set('display_errors', true);
ini_set('display_startup_errors', true);


function DbById($Id)
{
  DB_Select('wlan_db', '*', 'id='.$Id);
  $Row = DB_Row();
  return($Row);
}

$Polozky = array('device', 'connector1', 'cable', 'connector2', 'antena');

echo('<table width="100%"><tr><td valign="top">');
echo('<table cellspacing="0" cellpadding="3" border="1"><tr><th>Oznaèení</th><th>Výkon [dB]</th><th>Výkon [mW]</tr>');
DB_Select('wlan_list', 'id,cable_length,name,'.implode(',', $Polozky));
while($Row = DB_Row())
{
  DB_Save();
  foreach($Polozky as $Item)
  {
    $Row2 = DbById($Row[$Item]);
    $Row[$Item.'_db'] = $Row2['value'];
    $Row[$Item] = $Row2['name'];
  } 
  $Row['cable_db'] = $Row['cable_db'] * $Row['cable_length']; 
  $Row['cable'] = $Row['cable'].' '.$Row['cable_length'].' m'; 
  
  $Total = 0;
  foreach($Polozky as $Item)
  {
    $Total = $Total + $Row[$Item.'_db'];
  }
  echo('<tr><td>'.$Row['name'].'</td><td>'.round($Total).'</td><td>'.round(pow(10, $Total/10)).'</td></tr>');
  echo('<tr><td colspan="3"><table style="font-size: smaller;" width="100%" cellspacing="0" cellpadding="3" border="1">');
  foreach($Polozky as $Item)
  {
    echo('<tr><td>'.$Row[$Item].'</td><td>'.$Row[$Item.'_db'].'</td></tr>');
  } 
  echo('</table></td></tr>');
  
  DB_Update('wlan_list', 'id='.$Row['id'], array('total' => $Total, 'total_passive' => ($Total-$Row['device_db'])));
  
  DB_Load();
}
echo('</table>');

echo('</td><td valign="top">');

echo('<table cellspacing="0" cellpadding="3" border="1">
<tr><th>Bod 1</th><th>Bod 2</th><th>Signál [dB]</tr>');
DB_Select('wlan_links', '*');
while($Row = DB_Row())
{
  DB_Save();
  
  DB_Select('wlan_list', '*', 'id='.$Row['point1']);
  $Point1 = DB_Row();
  DB_Select('wlan_list', '*', 'id='.$Row['point2']);
  $Point2 = DB_Row();
  
  $UtlumTrasy = -round(40 + 20*log10($Row['distance']));
  $Signal = $Point1['total'] + $UtlumTrasy + $Point2['total_passive'];
  echo('<tr><td>'.$Point1['name'].'</td><td>'.$Point2['name'].'</td><td>'.$Signal.'</td></tr>');
  echo('<tr><td colspan="3"><table style="font-size: smaller;" width="100%" cellspacing="0" cellpadding="3" border="1">');

  echo('<tr><td>Vyzáøený výkon</td><td>'.$Point1['total'].'</td></tr>');
  echo('<tr><td>Útlum trasy</td><td>'.$UtlumTrasy.'</td></tr>');
  echo('<tr><td>Zisk pøíjímaèe</td><td>'.$Point2['total_passive'].'</td></tr>');

  echo('</table></td></tr>');
  
  DB_Load();
}

echo('</td></tr></table>');

?>