Трафик пользователей

Группа:  Начало:  Конец:  Шлюз: 

\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $gateway_list = get_gateways($db_link); $trafSQL = "SELECT User_stats.auth_id, User_stats.router_id, SUM( byte_in ) AS tin, SUM( byte_out ) AS tout FROM User_stats WHERE (date(User_stats.timestamp)>='$date1') AND (date(User_stats.timestamp)<'$date2') AND (byte_in>0 or byte_out>0)"; if ($rgateway == 0) { $trafSQL = $trafSQL . " GROUP by User_stats.auth_id,User_stats.router_id"; } else { $trafSQL = $trafSQL . " AND User_stats.router_id=$rgateway GROUP by User_stats.auth_id,User_stats.router_id"; } $userSQL = "SELECT User_list.login as login, User_auth.user_id as user_id, User_auth.id as auth_id FROM User_list,User_auth WHERE User_list.id=User_auth.user_id"; if ($rou == 0) { $userSQL = $userSQL . " ORDER BY User_auth.id"; } else { $userSQL = $userSQL . " AND User_list.ou_id=$rou ORDER BY User_auth.id"; } $users = mysqli_query($db_link, $userSQL); while (list ($f_login, $f_user_id, $f_auth_id) = mysqli_fetch_array($users)) { $user_ref[$f_auth_id][id] = $f_user_id; $user_ref[$f_auth_id][login] = $f_login; } $total_in = 0; $total_out = 0; unset($user_traf); $traf = mysqli_query($dbt_link, $trafSQL); while (list ($s_auth_id, $s_router_id, $traf_day_in, $traf_day_out) = mysqli_fetch_array($traf)) { if (! isset($user_ref{$s_auth_id}{id})) { continue; } if ($traf_day_in + $traf_day_out > 0) { $u_id = $user_ref[$s_auth_id][id]; if (! isset($user_traf[$u_id][$s_router_id][in])) { $user_traf[$u_id][$s_router_id][in] = 0; } if (! isset($user_traf[$u_id][$s_router_id][out])) { $user_traf[$u_id][$s_router_id][out] = 0; } if (! isset($user_traf[$u_id][$s_router_id][login])) { $user_traf[$u_id][$s_router_id][login] = $user_ref[$s_auth_id][login]; } $user_traf[$u_id][$s_router_id][in] += $traf_day_in; $user_traf[$u_id][$s_router_id][out] += $traf_day_out; $total_in += $traf_day_in; $total_out += $traf_day_out; } } $tmp_table = "month_stats_" . $_SESSION['session_id']; $tSQL = "CREATE TEMPORARY TABLE $tmp_table (`id` int(11) unsigned NOT NULL,`login` varchar(50) not null,`router` varchar(50) not null, `in` bigint, `out` bigint) DEFAULT CHARSET=utf8"; mysqli_query($db_link, $tSQL); foreach ($user_traf as $u_id => $user_stats) { foreach ($user_stats as $s_router_id => $user_info) { $tSQL = "insert into $tmp_table (`id`,`login`,`router`,`in`,`out`) values('$u_id','$user_info[login]','$gateway_list[$s_router_id]','$user_info[in]','$user_info[out]')"; $result = mysqli_query($db_link, $tSQL); } } $tSQL = "Select `id`,`login`,`router`,`in`,`out` from `$tmp_table` order by `$sort_field` $order"; $user_stats = mysqli_query($db_link, $tSQL); while (list ($s_id, $s_login, $s_router, $s_in, $s_out) = mysqli_fetch_array($user_stats)) { $cl = "data"; if ($s_out > 2 * $s_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($s_in) . "	" . fbytes($s_out) . "
Итого		" . fbytes($total_in) . "	" . fbytes($total_out) . "