\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $sort_sql=" ORDER BY tin DESC"; if (!empty($sort_field) and !empty($order)) { $sort_sql = " ORDER BY $sort_field $order"; } $gateway_list = get_gateways($db_link); $trafSQL = "SELECT User_list.login,User_list.ou_id,User_auth.user_id, User_stats.auth_id, User_stats.router_id, SUM( byte_in ) AS tin, SUM( byte_out ) AS tout FROM User_stats,User_auth,User_list WHERE User_list.id=User_auth.user_id AND User_stats.auth_id = User_auth.id AND User_stats.timestamp>='$date1' AND User_stats.timestamp<'$date2' "; if ($rou !== 0) { $trafSQL = $trafSQL . " AND User_list.ou_id=$rou"; } if ($rgateway == 0) { $trafSQL = $trafSQL . " GROUP by User_auth.user_id,User_stats.router_id"; } else { $trafSQL = $trafSQL . " AND User_stats.router_id=$rgateway GROUP by User_auth.user_id,User_stats.router_id"; } #set sort $trafSQL=$trafSQL ." $sort_sql"; $total_in = 0; $total_out = 0; $traf = mysqli_query($db_link, $trafSQL); while (list ($s_login,$s_ou_id,$u_id,$s_auth_id, $s_router_id, $traf_day_in, $traf_day_out) = mysqli_fetch_array($traf)) { if ($traf_day_in + $traf_day_out ==0) { continue; } $total_in += $traf_day_in; $total_out += $traf_day_out; $s_router = $gateway_list[$s_router_id]; $cl = "data"; if ($traf_day_out > 2 * $traf_day_in) { $cl = "nb"; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; ?>

Логин	Gate	Входящий	Исходящий
$s_login	$s_router	" . fbytes($traf_day_in) . "	" . fbytes($traf_day_out) . "
Итого		" . fbytes($total_in) . "	" . fbytes($total_out) . "