Eye/html/admin/customers/control-subnets-usage.php

<?php

require_once ($_SERVER['DOCUMENT_ROOT']."/inc/auth.php");
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/languages/" . HTML_LANG . ".php");
unset($_POST);
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/header.php");
print_control_submenu($page_url);
$zombi_days = get_option($db_link, 35);

?>
<div id="cont">
<br>
<b><?php echo WEB_network_usage_title; ?></b> <br>
<table class="data">
<tr align="center">
	<td><b><?php echo WEB_network_subnet; ?></b></td>
	<td><b><?php echo WEB_network_all_ip; ?></b></td>
	<td><b><?php echo WEB_network_used_ip; ?></b></td>
	<td><b><?php echo WEB_network_free_ip; ?></b></td>
	<td><b><?php echo WEB_network_dhcp_size; ?></b></td>
	<td><b><?php echo WEB_network_dhcp_used; ?></b></td>
	<td><b><?php echo WEB_network_dhcp_free; ?></b></td>
	<td><b><?php echo WEB_network_static_free; ?></b></td>
	<td><b><?php echo WEB_network_zombi; ?><br><?php print "(> ".$zombi_days." ".WEB_days.")"; ?></b></td>
	<td><b><?php echo WEB_network_zombi_dhcp; ?><br><?php print "(> ".$zombi_days." ".WEB_days.")"; ?></b></td>
</tr>
<?php
$t_subnets = get_records($db_link,'subnets','office=1 ORDER BY ip_int_start');
if (!empty($t_subnets)) {
foreach ( $t_subnets as $row ) {
    print "<tr align=center>\n";
    $cl="data";
    print "<td class=\"$cl\"><a href=/admin/iplist/index.php?ou=0&cidr=".$row['subnet'].">".$row['subnet']."</a></td>\n";
    $all_ips = $row['ip_int_stop']-$row['ip_int_start']-3;
    print "<td class=\"$cl\">".$all_ips."</td>\n";
#used
    $used_all = get_count_records($db_link,'User_auth','deleted=0 and ip_int>='.$row['ip_int_start'].' and ip_int<='.$row['ip_int_stop']);
    print "<td class=\"$cl\">".$used_all."</td>\n";
    $free_all = $all_ips - $used_all;
    print "<td class=\"$cl\">".$free_all."</td>\n";
    $dhcp_pool = $row['dhcp_stop']-$row['dhcp_start']+1;
    print "<td class=\"$cl\">".$dhcp_pool."</td>\n";
#used pool
    $used_dhcp = get_count_records($db_link,'User_auth','deleted=0 and ip_int>='.$row['dhcp_start'].' and ip_int<='.$row['dhcp_stop']);
    print "<td class=\"$cl\">".$used_dhcp."</td>\n";
    $free_dhcp = $dhcp_pool - $used_dhcp;
    print "<td class=\"$cl\">".$free_dhcp."</td>\n";
    $free_static = $free_all -  $free_dhcp;
    print "<td class=\"$cl\">".$free_static."</td>\n";
    $zombi = get_count_records($db_link,'User_auth','deleted=0 and ip_int>='.$row['ip_int_start'].' and ip_int<='.$row['ip_int_stop'].' and last_found<=(NOW() - INTERVAL '.$zombi_days.' DAY)');
    print "<td class=\"$cl\">".$zombi."</td>\n";
    $zombi = get_count_records($db_link,'User_auth','deleted=0 and ip_int>='.$row['dhcp_start'].' and ip_int<='.$row['dhcp_stop'].' and last_found<=(NOW() - INTERVAL '.$zombi_days.' DAY)');
    print "<td class=\"$cl\">".$zombi."</td>\n";
    print "</tr>\n";
    }
}
?>
</table>
<?php require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php"); ?>