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);
// Создаём временную метку: сейчас минус $zombi_days дней
$zombi_threshold = date('Y-m-d H:i:s', strtotime("-$zombi_days days"));
?>
<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_SQL($db_link,'SELECT * FROM subnets WHERE 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 >= ? AND ip_int <= ?', [ $row['ip_int_start'], $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 >= ? AND ip_int <= ?', [$row['dhcp_start'], $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 >= ? AND ip_int <= ? AND last_found <= ?', [ $row['ip_int_start'], $row['ip_int_stop'], $zombi_threshold]);
    print "<td class=\"$cl\">".$zombi."</td>\n";
    $zombi = get_count_records( $db_link, 'user_auth', 'deleted = 0 AND ip_int >= ? AND ip_int <= ? AND last_found <= ?', [ $row['dhcp_start'], $row['dhcp_stop'], $zombi_threshold]);
    print "<td class=\"$cl\">".$zombi."</td>\n";
    print "</tr>\n";
    }
}
?>
</table>
<?php require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php"); ?>