source: trunk/Modules/Network/Subnet.php

<?php

class PageSubnet extends Page
{
  function __construct(System $System)
  {
    parent::__construct($System);
    $this->Title = 'Podsítě';
    $this->Description = 'Informace o podsítích';
    $this->ParentClass = 'PageNetwork';
  }

  function Show(): string
  {
    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `NetworkSubnet`');
    $DbRow = $DbResult->fetch_row();
    $PageList = GetPageList('Subnets', $DbRow[0]);

    $Output = $PageList['Output'];
    $Output .= '<table class="WideTable" style="font-size: small;">';

    $TableColumns = array(
      array('Name' => 'Name', 'Title' => 'Název'),
      array('Name' => 'AddressRange', 'Title' => 'IP rozsah'),
      array('Name' => 'DHCP', 'Title' => 'Adresa DHCP'),
      array('Name' => 'Gateway', 'Title' => 'Výchozí brána'),
      array('Name' => '', 'Title' => 'Max. adres'),
      array('Name' => '', 'Title' => 'Registrovaných adres'),
      array('Name' => '', 'Title' => 'Využití'),
      array('Name' => 'SubjectName', 'Title' => 'Účastník'),
    );
    $Order = GetOrderTableHeader('Subnets', $TableColumns, 'AddressRange', 0);
    $Output .= $Order['Output'];

    $Query = 'SELECT NetworkSubnet.*, Subject.Name AS SubjectName FROM NetworkSubnet LEFT JOIN Member ON Member.Id = NetworkSubnet.Member LEFT JOIN Subject ON Subject.Id = Member.Subject '.$Order['SQL'].$PageList['SQLLimit'];

    $DbResult = $this->Database->query($Query);
    while ($Subnet = $DbResult->fetch_assoc())
    {
      $DbResult2 = $this->Database->query('SELECT COUNT(*) FROM NetworkInterface WHERE CompareNetworkPrefix(INET_ATON("'.$Subnet['AddressRange'].'"), INET_ATON(LocalIP), '.$Subnet['Mask'].')');
      $DbRow = $DbResult2->fetch_row();
      $AddressCount = $DbRow[0];
      $MaxAddressCount = $SubnetMask = pow(2, 32 - $Subnet['Mask']) - 2;

      $Output .= '<tr><td>'.$Subnet['Name'].'</td>'.
      '<td>'.$Subnet['AddressRange'].'/'.$Subnet['Mask'].'</td>'.
      '<td>'.$Subnet['DHCP'].'</td>'.
      '<td>'.$Subnet['Gateway'].'</td>'.
      '<td>'.$MaxAddressCount.'</td>'.
      '<td>'.$AddressCount.'</td>'.
      '<td>'.round($AddressCount / $MaxAddressCount * 100).'</td>'.
      '<td>'.$Subnet['SubjectName'].'</td></tr>';
    }
    $Output .= '</table>';
    $Output .= $PageList['Output'];
    return $Output;
  }
}