:  : 

= $config["traffic_ipstat_history"]) { $traffic_stat_table = 'user_stats'; } $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); $sql_params=[]; $trafSQL = "SELECT user_auth.id, ".$traffic_stat_table.".router_id, SUM( byte_in ) AS tin, SUM( byte_out ) AS tout, MAX(ROUND(pkt_in/step)) as pin, MAX(ROUND(pkt_out/step)) as pout FROM ".$traffic_stat_table.",user_auth,user_list WHERE user_list.id=user_auth.user_id AND ".$traffic_stat_table.".auth_id = user_auth.id AND ".$traffic_stat_table.".ts>= ? AND ".$traffic_stat_table.".ts< ?"; array_push($sql_params,$date1); array_push($sql_params,$date2); if ($rou !== 0) { $trafSQL = $trafSQL . " AND user_list.ou_id=?"; array_push($sql_params,$rou); } if ($rgateway >0) { $trafSQL = $trafSQL . " AND ".$traffic_stat_table.".router_id= ?"; array_push($sql_params,$rgateway); } $trafSQL = $trafSQL . " GROUP by user_auth.id,".$traffic_stat_table.".router_id"; $countSQL = "SELECT Count(*) FROM ($trafSQL) A"; $count_records = get_single_field($db_link,$countSQL,$sql_params); $total=ceil($count_records/$displayed); if ($page>$total) { $page=$total; } if ($page<1) { $page=1; } $start = ($page * $displayed) - $displayed; #set sort $trafSQL=$trafSQL ." $sort_sql LIMIT ? OFFSET ?"; array_push($sql_params,$displayed); array_push($sql_params,$start); print_navigation($page_url,$page,$displayed,$count_records,$total); print "

\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $total_in = 0; $total_out = 0; $traf = get_records_sql($db_link, $trafSQL, $sql_params); foreach ($traf as $row) { if ($row['tin'] + $row['tout'] == 0) { continue; } $total_in += $row['tin']; $total_out += $row['tout']; $s_router = !empty($gateway_list[$row['router_id']]) ? $gateway_list[$row['router_id']] : ''; $cl = $row['tout'] > 2 * $row['tin'] ? "nb" : "data"; $a_SQL='SELECT ip,U.login FROM user_auth, user_list as U where user_auth.user_id=U.id and user_auth.id=?'; $auth_record = get_record_sql($db_link,$a_SQL,[$row['id']]); print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; ?>

".WEB_cell_login."	".WEB_cell_ip."	".WEB_cell_gateway."	".WEB_title_input."	".WEB_title_output."	".WEB_title_maxpktin."	".WEB_title_maxpktout."
" . $auth_record['login'] . "	" . $auth_record['ip'] . "	$s_router	" . fbytes($row['tin']) . "	" . fbytes($row['tout']) . "	" . fpkts($row['pin']) . "	" . fpkts($row['pout']) . "
".WEB_title_itog."			" . fbytes($total_in) . "	" . fbytes($total_out) . "