function UserTimeTraffic()
{
global $SAMSConf;
global $DATE;
global $USERConf;
global $SquidUSERConf;
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
$SquidUSERConf = new SAMSUSER();
$SquidUSERConf->sams_user($id);
if ($USERConf->ToWebInterfaceAccess("GSC") != 1 && ($USERConf->s_user_id != $SquidUSERConf->s_user_id && $USERConf->ToWebInterfaceAccess("W") != 1)) {
exit(0);
}
$DB = new SAMSDB();
$sdate = $DATE->sdate();
$edate = $DATE->edate();
$bdate = $DATE->BeginDate();
$eddate = $DATE->EndDate();
$sday = $DATE->sday;
$smon = $DATE->smon;
$syea = $DATE->syea;
$shou = $DATE->shou;
$eday = $DATE->eday;
$emon = $DATE->emon;
$eyea = $DATE->eyea;
require "reportsclass.php";
$dateselect = new DATESELECT($DATE->sdate(), $DATE->edate());
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if ($USERConf->ToWebInterfaceAccess("WAUC") != 1) {
exit(0);
}
PageTop("ttraffic_48.jpg", "{$traffic_1} <FONT COLOR=\"BLUE\"> {$SquidUSERConf->s_nick}</FONT><BR>{$URLTimeForm_userbuttom_4_time_1}<BR>{$bdate}");
print "<TABLE WIDTH=\"90%\"><TR><TD>";
print "<FORM NAME=\"UserIDForm\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" id=id value=\"{$SquidUSERConf->s_user_id}\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"usertimetraffic\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"userbuttom_3_time.php\">\n";
$dateselect->SetDate();
print "<TD><IMG SRC=\"{$SAMSConf->ICONSET}/printer.gif\" TITLE=\"Print\" ALT=\"Print\" onClick=\"JavaScript:window.print();\"></TABLE>\n";
print "</FORM>\n";
$URL = array("time" => array(), "url" => array(), "method" => array());
$count = 0;
$QUERY = "SELECT * FROM (SELECT substring(s_time from 1 for 5) as time , substring( s_url from position('//' in s_url)+2 for position('/' in substring(s_url from position('/' in s_url)+2 )) ) as url_domain, s_method FROM squidcache WHERE s_user='******' AND s_date='{$sdate}' AND s_method!='CONNECT' ORDER BY s_time) AS _cache GROUP BY _cache.time,_cache.url_domain ORDER BY _cache.time";
$num_rows = $DB->samsdb_query_value($QUERY);
while ($row = $DB->samsdb_fetch_array()) {
$URL["time"][$count] = $row['time'];
$URL["url"][$count] = str_replace("/", "", $row['url_domain']);
$URL["method"][$count] = $row['s_method'];
$count++;
}
$QUERY = "SELECT * FROM (SELECT substring(s_time from 1 for 5) as time, s_url as url_domain, s_method FROM squidcache WHERE s_user='******' AND s_date='{$sdate}' AND s_method='CONNECT' ORDER BY s_time) AS _cache GROUP BY _cache.time,_cache.url_domain ORDER BY _cache.time";
$num_rows = $DB->samsdb_query_value($QUERY);
while ($row = $DB->samsdb_fetch_array()) {
$URL["time"][$count] = $row['time'];
$URL["url"][$count] = str_replace("/", "", $row['url_domain']);
$URL["method"][$count] = $row['s_method'];
$count++;
}
print "<CENTER>\n";
print "<script type=\"text/javascript\" src=\"lib/jquery-1.2.6.js\"></script>\n";
print "<script type=\"text/javascript\" src=\"lib/jquery.dataTables.js\"></script>\n";
print "<script type=\"text/javascript\">\n";
print "\$(document).ready(function(){\n";
print " \$(\"#urltime\").dataTable({\n";
print "\t\"bInfo\": 0,\n";
print "\t\"iDisplayLength\": {$count},\n";
print "\t\"iDisplayStart\": 0,\n";
print "\t\"iDisplayEnd\": {$count},\n";
print "\t\"oLanguage\": {\n";
print "\t\t\"sSearch\": \"search\", \n";
print "\t\t\"sLengthMenu\": \"Show _MENU_ entries\"\n";
print "\t\t},\n";
print "\t\"aoColumns\": [ \n";
print "\t\t{ \"sType\": \"numeric\", \"sWidth\": \"15%\" },\n";
print "\t\t{ \"sType\": \"html\", \"sWidth\": \"75%\"},\n";
print "\t\t{ \"sType\": \"html\", \"sWidth\": \"10%\"},\n";
print " ]\n";
print " });\n";
print "});\n";
print "</script>\n";
print "</CENTER>\n";
asort($URL["time"]);
reset($URL["time"]);
$cache = 0;
print "<TABLE CLASS=samstable id=\"urltime\" WIDTH=80%>";
print "<THEAD>\n";
print "<TH>Time";
print "<TH>URL";
print "<TH>Method";
print "</THEAD>\n";
print "<TBODY>\n";
$size = 0;
asort($URL["time"]);
reset($URL["time"]);
while (list($key, $val) = each($URL["time"])) {
print "<TR>";
LTableCell($URL['time'][$key], 15);
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
RTableCell($URL['url'][$key], 75);
}
RTableCell($URL['method'][$key], 15);
print "</TR>\n";
}
print "</TBODY>\n";
print "</TABLE>";
}
