diff($start_time,true);
$delta = $interval->format("%a");
$l3_interfaces = get_wan_interfaces($db,$device_id);
#for day - show hour statistics
$dt_template = '%Y-%m-%d %H:00:00';
if ($delta == 1) { $dt_template = '%Y-%m-%d %H:00:00'; }
elseif ($delta >1 and $delta<=31) { $dt_template = '%Y-%m-%d'; }
elseif ($delta >31) { $dt_template = '%Y-%m'; }
$global_int_in = 0;
$global_int_out = 0;
$global_int_f_in = 0;
$global_int_f_out = 0;
print "| ".$device_name." |
\n";
foreach ($l3_interfaces as $row) {
if (!empty($row['comment'])) {
print "| ".$row['name']." (".$row['comment'].") |
\n";
} else {
print "| ".$row['name']." |
\n";
}
print "\n";
print "| ".WEB_date." | \n";
print "".WEB_title_input." | \n";
print "".WEB_title_output." | \n";
print "".WEB_title_forward_input." | \n";
print "".WEB_title_forward_output." | \n";
print "
\n";
$trafSQL="SELECT DATE_FORMAT(`time`, '".$dt_template."' ) AS dt,SUM(`in`) as byte_in,SUM(`out`) as byte_out, SUM(`forward_in`) as byte_f_in,SUM(`forward_out`) as byte_f_out FROM Wan_stats ";
$trafSQL .=" WHERE router_id='".$device_id."' AND interface_id='".$row['snmpin']."' AND time>='$date1' AND time<'$date2'";
$trafSQL .=" GROUP BY DATE_FORMAT(`time`, '".$dt_template."' ) ORDER BY dt;";
$int_statistics = get_records_sql($db,$trafSQL);
$int_in = 0;
$int_out = 0;
$int_f_in = 0;
$int_f_out = 0;
foreach ($int_statistics as $stat) {
print "\n";
print "| ".$stat['dt']." | \n";
print "".fbytes($stat['byte_in'])." | \n";
print "".fbytes($stat['byte_out'])." | \n";
print "".fbytes($stat['byte_f_in'])." | \n";
print "".fbytes($stat['byte_f_out'])." | \n";
print "
\n";
$int_in +=$stat['byte_in'];
$int_out +=$stat['byte_out'];
$int_f_in +=$stat['byte_f_in'];
$int_f_out +=$stat['byte_f_out'];
}
print "\n";
print "| ".WEB_title_itog." | \n";
print "".fbytes($int_in)." | \n";
print "".fbytes($int_out)." | \n";
print "".fbytes($int_f_in)." | \n";
print "".fbytes($int_f_out)." | \n";
print "
\n";
$global_int_in += $int_in;
$global_int_out += $int_out;
$global_int_f_in += $int_f_in;
$global_int_f_out += $int_f_out;
}
print "\n";
print "| ".WEB_title_itog." |
\n";
print "\n";
print " | \n";
print "".fbytes($global_int_in)." | \n";
print "".fbytes($global_int_out)." | \n";
print "".fbytes($global_int_f_in)." | \n";
print "".fbytes($global_int_f_out)." | \n";
print "
\n";
}
?>
$val) {
print_gateway_statistics($db_link,$key,$val,$date1,$date2);
}
} else {
$router = get_record_sql($db_link,"SELECT device_name FROM devices WHERE id='".$rgateway."'");
print_gateway_statistics($db_link,$rgateway,$router['device_name'],$date1,$date2);
}
?>