" . $login . ""; ?>

> Начало:  Конец:  Шлюз: 

='$date1' and date(User_stats.timestamp)<'$date2'and auth_id=$fid"; $day_summary = mysqli_query($dbt_link, $sSQL); list ($summ) = mysqli_fetch_array($day_summary); if ($summ > 0) { $ipcount ++; 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),SUM(byte_out) from User_stats where date(User_stats.timestamp)>='$date1' and date(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 = mysqli_query($dbt_link, $sSQL); $sum_in = 0; $sum_out = 0; while (list ($u_router_id, $udata, $uin, $uout) = mysqli_fetch_array($userdata)) { print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $sum_in += $uin; $sum_out += $uout; } 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"; } ?>

	Gateway
$fip	$fcomm		Детализация
	$gateway_list[$u_router_id]	" . $udata . "	" . fbytes($uin) . "	" . fbytes($uout) . "
" . userinfo9 . "			" . fbytes($sum_in) . "	" . fbytes($sum_out) . "
Итого		" . fbytes($itog_in) . "	" . fbytes($itog_out) . "