Eye/html/admin/reports/authday.php

<?php
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/auth.php");
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/languages/" . HTML_LANG . ".php");
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/header.php");
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/idfilter.php");
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/datetimefilter.php");
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/oufilter.php");
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/gatefilter.php");
$auth=get_record_sql($db_link,'SELECT * FROM user_auth WHERE id='.$id);
$user=get_record_sql($db_link,'SELECT * FROM user_list WHERE id='.$auth['user_id']);

?>
<div id="cont">
<b>
<?php
print WEB_report_user_traffic."&nbsp<a href=../users/edituser.php?id=".$auth['user_id'].">" . $user['login'] . "</a>&nbsp"; 
print WEB_report_traffic_for_ip."&nbsp<a href=../users/editauth.php?id=$id>".$auth['ip']."</a>";
?>
</b>
<br>
<form action="<?php print $_SERVER['PHP_SELF']; ?>" method="post">
<input type="hidden" name="id" value=<?php echo $id; ?>>
<?php print_date_fields($date1,$date2,$date_shift); ?>
<?php echo WEB_cell_gateway; ?>:&nbsp <?php print_gateway_select($db_link, 'gateway', $rgateway); ?>
<input type="submit" value="<?php echo WEB_btn_show; ?>">
</form>
<br>
<table class="data" width=700>
<tr align="center">
<td class="data"><b><?php echo WEB_cell_gateway; ?></b></td>
<td class="data"><b><?php print WEB_title_date; ?></b></td>
<td class="data"><b><?php print WEB_title_input; ?></b></td>
<td class="data"><b><?php print WEB_title_output; ?></b></td>
<td class="data"><b><?php print WEB_title_maxpktin; ?></b></td>
<td class="data"><b><?php print WEB_title_maxpktout; ?></b></td>
</tr>
<?php

$gateway_list = get_gateways($db_link);
$gateway_filter='';
if (!empty($rgateway) and $rgateway>0) { $gateway_filter="(router_id=$rgateway) AND"; }

print "<tr align=center class=\"tr1\" onmouseover=\"className='tr2'\" onmouseout=\"className='tr1'\">\n";
print "<td class=\"data\" colspan=2>".$auth['comments']."</td>\n";
print "<td class=\"data\" colspan=2><a href=/admin/reports/userdaydetail.php?id=$id&date_start=$date1&date_stop=$date2>TOP 10</a></td>\n";
print "<td class=\"data\" colspan=2><a href=/admin/reports/userdaydetaillog.php?id=$id&date_start=$date1&date_stop=$date2>".WEB_report_detail."</a></td>\n";
print "</tr>\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 router_id, DATE_FORMAT(`timestamp`,'$display_date_format') as tHour, 
         SUM(`byte_in`) as byte_in_sum, SUM(`byte_out`) as byte_out_sum,
         MAX(ROUND(`pkt_in`/`step`)) as pkt_in_max, MAX(ROUND(`pkt_out`/`step`)) as pkt_out_max
         FROM user_stats_full WHERE `timestamp`>='$date1' AND `timestamp`<'$date2' AND auth_id=$id";
if ($rgateway == 0) {
    $sSQL = $sSQL . " GROUP BY DATE_FORMAT(`timestamp`,'$display_date_format'),router_id ORDER BY tHour,router_id";
} else {
    $sSQL = $sSQL . " AND router_id=$rgateway GROUP BY DATE_FORMAT(`timestamp`,'$display_date_format'),router_id ORDER BY tHour";
}

$userdata = get_records_sql($db_link, $sSQL);
$sum_in = 0;
$sum_out = 0;
foreach ($userdata as $row) {
    print "<tr align=center class=\"tr1\" onmouseover=\"className='tr2'\" onmouseout=\"className='tr1'\">\n";
    print "<td class=\"data\">" . $gateway_list[$row['router_id']] . "</td>\n";
    print "<td class=\"data\">" . $row['tHour'] . "</td>\n";
    print "<td class=\"data\">" . fbytes($row['byte_in_sum']) . "</td>\n";
    print "<td class=\"data\">" . fbytes($row['byte_out_sum']) . "</td>\n";
    print "<td class=\"data\">" . fpkts($row['pkt_in_max']) . "</td>\n";
    print "<td class=\"data\">" . fpkts($row['pkt_out_max']) . "</td>\n";
    print "</tr>\n";
    $sum_in += $row['byte_in_sum'];
    $sum_out += $row['byte_out_sum'];
}

print "<tr align=center class=\"tr1\" onmouseover=\"className='tr2'\" onmouseout=\"className='tr1'\">\n";
print "<td class=\"data\"><b>" . WEB_title_itog . "</b></td>\n";
print "<td class=\"data\"><b> </b></td>\n";
print "<td class=\"data\"><b>" . fbytes($sum_in) . "</b></td>\n";
print "<td class=\"data\"><b>" . fbytes($sum_out) . "</b></td>\n";
print "<td class=\"data\"><b></b></td>\n";
print "<td class=\"data\"><b></b></td>\n";
print "</tr>\n";
?>
</table>
<?php
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php");
?>