source: trunk/system/generators/queue.php@ 507

<?php
if(isset($_SERVER['REMOTE_ADDR'])) die();

$Enabled = 1;
$ClassesEnabled = 1;
$SessionDisable = true;
include('../../Common/Global.php');
include('../routerboard.php');
include('common.php');
$PathQueue = array('queue', 'tree');
$Database = &$System->Database;

$Routerboard = new Routerboard();
$Routerboard->UserName = $Config['MainRouter']['UserName'];
$Routerboard->Timeout = $Config['MainRouter']['ConnectTimeout'];
$Routerboard->HostName = $Config['MainRouter']['HostName'];
$Routerboard->Debug = true;

$Finance = &$System->Modules['Finance'];
$Finance->LoadMonthParameters(0);

// Generate traffic shaping rules
//$TotalMaxSpeedIn = 4048; //$RealMaxSpeed; //1536;
//TotalMaxSpeedOut = 3048; //$RealMaxSpeed; //1536;
//$UsersMaxSpeedIn = 1900; //$MaxSpeed;
//$UsersMaxSpeedOut = 1900; //$MaxSpeed;

$InDivider = 1;
$OutDivider = 1;
$TotalMaxSpeedIn = round($Finance->RealMaxSpeed / $InDivider) * 1000;
$TotalMaxSpeedOut = round($Finance->RealMaxSpeed / $OutDivider) * 1000;
$UsersMaxSpeedIn = round($Finance->MaxSpeed / $InDivider) * 1000;
$UsersMaxSpeedOut = round($Finance->MaxSpeed / $OutDivider) * 1000;
$VoipMaxSpeedIn = $TotalMaxSpeedIn - 136;
$VoipMaxSpeedOut = $TotalMaxSpeedOut - 136;
$VoipSpeedIn = 100; //$SpeedReserve;
$VoipSpeedOut = 100; //$SpeedReserve;
$OutInterface = 'eth1';
$InInterface = 'ifb0';
$InetInterface = $Config['MainRouter']['InetInterface'];
$FreeInetSpeed = $Finance->Tariffs[TARIFF_FREE]['InternetSpeedMax'];

$ItemsQueue = array();

// Root of tree and main limit
$ItemsQueue[] = array('name' => 'main-out', 'limit-at' => $UsersMaxSpeedIn, 'max-limit' => $UsersMaxSpeedIn, 'parent' => 'global-out');
$ItemsQueue[] = array('name' => 'main-in', 'limit-at' => $UsersMaxSpeedOut, 'max-limit' => $UsersMaxSpeedOut, 'parent' => 'global-out');

// Divide rules by subnet number
$DbResult = $Database->query('SELECT `Id`, `Name`, `AddressRange`, `Mask` FROM `NetworkSubnet`');
// Slow free internet
$PacketMark = GetMarkByComment('free-out');
$ItemsQueue[] = array('name' => 'free-out', 'limit-at' => $FreeInetSpeed, 'max-limit' => $FreeInetSpeed, 'parent' => 'main-out', 'packet-mark' => $PacketMark);
$PacketMark = GetMarkByComment('free-in');
$ItemsQueue[] = array('name' => 'free-in', 'limit-at' => $FreeInetSpeed, 'max-limit' => $FreeInetSpeed, 'parent' => 'main-in', 'packet-mark' => $PacketMark);

// Process users
$DbResult = $Database->query('SELECT `Member`.*, `Subject`.`Name` FROM `Member` LEFT JOIN `Subject` ON `Subject`.`Id` = `Member`.`Subject` WHERE `Member`.`Blocked`=0');
while($Member = $DbResult->fetch_assoc())
{
  $Member['Name'] = RouterOSIdent($Member['Name'].'-'.$Member['Id'] );

  echo('Zákazník '.$Member['Name']."\n");
  $DbResult4 = $Database->query('SELECT `Service`.*, `ServiceCustomerRel`.`Id` AS `RelId` FROM `ServiceCustomerRel` JOIN `Service` ON `Service`.`Id` = `ServiceCustomerRel`.`Service` '.
    'WHERE (`ServiceCustomerRel`.`Customer` = '.$Member['Id'].') AND (`ServiceCustomerRel`.`Action` IS NULL)');
  while($Service = $DbResult4->fetch_assoc())
  {
    echo('Služba '.$Service['Name'].': ');
    $SpeedIn = round($Service['InternetSpeedMin'] / $InDivider) * 1000;
    $SpeedOut = round($Service['InternetSpeedMin'] / $OutDivider) * 1000;
    $UserMaxSpeedIn = round($Service['InternetSpeedMax'] / $InDivider) * 1000;
    $UserMaxSpeedOut = round($Service['InternetSpeedMax'] / $OutDivider) * 1000;
    $ItemsQueue[] = array('name' => $Member['Name'].'-out', 'limit-at' => $SpeedIn, 'max-limit' => $UserMaxSpeedIn, 'parent' => 'main-out');
    $ItemsQueue[] = array('name' => $Member['Name'].'-in', 'limit-at' => $SpeedOut, 'max-limit' => $UserMaxSpeedOut, 'parent' => 'main-in');

    $Filter = '(`Used` = 1) AND (`Service` = '.$Service['RelId'].')';
    $DbResult2 = $Database->select('NetworkDevice', 'COUNT(*)', $Filter);
    $Row = $DbResult2->fetch_row();
    $HostCount = $Row[0];
    if($HostCount > 0)
    {
      $HostSpeedIn = round($SpeedIn / $HostCount);
      $HostSpeedOut = round($SpeedOut / $HostCount);
    } else
    {
      $HostSpeedIn = $SpeedIn;
      $HostSpeedOut = $SpeedOut;
    }

    $DbResult2 = $Database->select('NetworkDevice', '*', $Filter);
    while($Device = $DbResult2->fetch_assoc())
    {
      $DbResult3 = $Database->select('NetworkInterface', '*', '`Device` = '.$Device['Id'].' AND `LocalIP` != ""');
      while($Interface = $DbResult3->fetch_assoc())
      {
        $Name = $Device['Name'];
        if($Interface['Name'] != '') $Name .= '-'.$Interface['Name'];
        $Name = RouterOSIdent($Name);
        echo($Name.', ');
        $IPParts = explode('.', $Interface['LocalIP']);
        $Subnet = $IPParts[2];
        $PacketMark = GetMarkByComment($Name.'-out');
        $ItemsQueue[] = array('name' => $Name.'-out', 'limit-at' => $HostSpeedIn, 'max-limit' => $UserMaxSpeedIn, 'parent' => $Member['Name'].'-out', 'packet-mark' => $PacketMark);
        $PacketMark = GetMarkByComment($Name.'-in');
        $ItemsQueue[] = array('name' => $Name.'-in', 'limit-at' => $HostSpeedOut, 'max-limit' => $UserMaxSpeedOut, 'parent' => $Member['Name'].'-in', 'packet-mark' => $PacketMark);
      }
    }
  
    $DbResult2 = $Database->select('NetworkSubnet', '*', '`Service`='.$Service['RelId']);
    while($Subnet = $DbResult2->fetch_assoc())
    {
      $Subnet['Name'] = RouterOSIdent('subnet-'.$Subnet['Name']);
      echo($Subnet['Name'].', ');
      $IPParts = explode('.', $Subnet['AddressRange']);
      $SubnetNumber = $IPParts[2];
      $PacketMark = GetMarkByComment($Subnet['Name'].'-out');
      $ItemsQueue[] = array('name' => $Subnet['Name'].'-out', 'limit-at' => $HostSpeedIn, 'max-limit' => $UserMaxSpeedIn, 'parent' => $Member['Name'].'-out', 'packet-mark' => $PacketMark);
      $PacketMark = GetMarkByComment($Subnet['Name'].'-in');
      $ItemsQueue[] = array('name' => $Subnet['Name'].'-in', 'limit-at' => $HostSpeedOut, 'max-limit' => $UserMaxSpeedOut, 'parent' => $Member['Name'].'-in', 'packet-mark' => $PacketMark);
    }
    echo("\n");
  }
}

//print_r($ItemsQueue);
$Routerboard->ListUpdate($PathQueue, array('name', 'limit-at', 'max-limit', 'parent', 'packet-mark'), $ItemsQueue, array(), true);

?>