" . $user['login'] . ""; ?>
> : 

0) { $gateway_filter="(User_stats.router_id=$rgateway) AND"; } $sSQL = "SELECT id,ip,comments FROM User_auth WHERE (User_auth.user_id=$id) Order by IP"; $usersip = get_records_sql($db_link, $sSQL); $ipcount = 0; $itog_in = 0; $itog_out = 0; foreach ($usersip as $row) { $fid = $row["id"]; $fip = $row["ip"]; $fcomm = $row["comments"]; $sSQL = "SELECT SUM(byte_in)+SUM(byte_out) as t_sum FROM User_stats WHERE $gateway_filter User_stats.timestamp>='$date1' AND User_stats.timestamp<'$date2'AND auth_id=$fid"; $day_summary = get_record_sql($db_link, $sSQL); if (!empty($day_summary)) { $summ = $day_summary['t_sum']; } else { $summ = 0; } if ($summ > 0) { $ipcount++; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $display_date_format='%Y-%m-%d %H'; if ($days_shift <=1) { $display_date_format='%Y-%m-%d %H'; } if ($days_shift >1 and $days_shift <=30) { $display_date_format='%Y-%m-%d'; } if ($days_shift >30 and $days_shift <=730) { $display_date_format='%Y-%m'; } if ($days_shift >730) { $display_date_format='%Y'; } $sSQL = "SELECT User_stats.router_id, DATE_FORMAT(User_stats.timestamp,'$display_date_format') as tHour, SUM(byte_in) as byte_in_sum, SUM(byte_out) as byte_out_sum FROM User_stats WHERE User_stats.timestamp>='$date1' AND User_stats.timestamp<'$date2' and auth_id=$fid"; if ($rgateway == 0) { $sSQL = $sSQL . " GROUP BY DATE_FORMAT(User_stats.timestamp,'$display_date_format'),User_stats.router_id ORDER BY tHour,User_stats.router_id"; } else { $sSQL = $sSQL . " and User_stats.router_id=$rgateway GROUP BY DATE_FORMAT(User_stats.timestamp,'$display_date_format'),User_stats.router_id ORDER BY tHour"; } $userdata = get_records_sql($db_link, $sSQL); $sum_in = 0; $sum_out = 0; foreach ($userdata as $userrow) { print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $sum_in += $userrow['byte_in_sum']; $sum_out += $userrow['byte_out_sum']; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $itog_in += $sum_in; $itog_out += $sum_out; } } if ($ipcount > 1) { print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } ?>
$fip$fcommTOP 10".WEB_report_detail."
" . $gateway_list[$userrow['router_id']] . "" . $userrow['tHour'] . "" . fbytes($userrow['byte_in_sum']) . "" . fbytes($userrow['byte_out_sum']) . "
" . WEB_title_sum . " " . fbytes($sum_in) . "" . fbytes($sum_out) . "
".WEB_title_itog." " . fbytes($itog_in) . "" . fbytes($itog_out) . "