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>";
}
function GroupTrafficPeriod()
{
global $SAMSConf;
global $USERConf;
global $DATE;
if ($USERConf->ToWebInterfaceAccess("CS") != 1) {
exit(0);
}
$DB = new SAMSDB();
$sdate = $DATE->sdate();
$edate = $DATE->edate();
$bdate = $DATE->BeginDate();
$eddate = $DATE->EndDate();
$size = "";
if (isset($_GET["size"])) {
$size = $_GET["size"];
}
if (isset($_GET["sort"])) {
$sort = $_GET["sort"];
}
if (isset($_GET["desc"])) {
$desc = $_GET["desc"];
}
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
require "reportsclass.php";
$dateselect = new DATESELECT($DATE->sdate(), $DATE->edate());
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
$a = array(array($usersbuttom_2_traffic_UsersTrafficForm_4, 'all_sum', 'desc', 'CHECKED'), array($usersbuttom_2_traffic_UsersTrafficForm_5, 's_nick', '', ''));
$num_rows = $DB->samsdb_query_value("SELECT * FROM sgroup WHERE s_group_id='{$id}' ");
$row = $DB->samsdb_fetch_array();
PageTop("usergroup_48.jpg", "{$grptraffic_1} <FONT COLOR=\"BLUE\"> {$row['s_name']} </FONT><BR> {$groupbuttom_1_traffic_GroupTrafficPeriod_1}");
print "<BR>\n";
print "<TABLE WIDTH=\"90%\"><TR><TD>";
print "<FORM NAME=\"UserIDForm\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"grouptrafficperiod\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"groupbuttom_2_traffic.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" value=\"{$id}\">\n";
$dateselect->SetPeriod2("{$usersbuttom_2_traffic_UsersTrafficForm_3}", $a);
print "<TD><IMG SRC=\"{$SAMSConf->ICONSET}/printer.gif\" TITLE=\"Print\" ALT=\"Print\" onClick=\"JavaScript:window.print();\"></TABLE>\n";
print "</FORM>\n";
printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> ");
printf("<P><IMG SRC=\"main.php?show=exe&function=grouptrafficperiodgb&filename=groupbuttom_2_traffic.php&gb=1&sdate={$sdate}&edate={$edate}&sort={$sort}&desc={$desc}&id={$id} \"><P>");
$count = 1;
$size2 = 0;
$hitsize = 0;
$traf = 0;
print "<script type=\"text/javascript\" src=\"lib/jquery-1.2.6.js\"></script>";
print "<script type=\"text/javascript\" src=\"lib/jquery.dataTables.js\"></script>\n";
print "<script type=\"text/javascript\">\n";
print "\$(document).ready(function(){\n";
print " \$(\"#userstraffic\").dataTable({\n";
print "\t\"bInfo\": 0,\n";
print "\t\"iDisplayLength\": 100,\n";
print "\t\"iDisplayStart\": 0,\n";
print "\t\"iDisplayEnd\": 100,\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\" },\n";
print "\t\t{ \"sType\": \"html\" },\n";
print "\t\t{ \"sType\": \"formatted-num\" },\n";
print "\t\t{ \"sType\": \"formatted-num\" },\n";
print "\t\t{ \"sType\": \"formatted-num\" }\n";
print " ]\n";
print " });\n";
print "});\n";
print "</script>\n";
print "<TABLE CLASS=samstable id=\"userstraffic\">\n";
$item = array("head" => "squid", "access" => "pobject.gif", "target" => "tray", "url" => "tray.php?show=exe&filename=squidtray.php&function=squidtray", "text" => "SQUID");
print "<THEAD>\n";
print "<TH width=8%>No\n";
print "<TH width=16%>{$usersbuttom_2_traffic_UsersTrafficPeriod_4}\n";
if ($size == "On") {
print "<TH width=16%>{$usersbuttom_2_traffic_UsersTrafficPeriod_8}\n";
} else {
if (($SAMSConf->AUTH = "ntlm" || ($SAMSConf->AUTH = "adld")) && $SAMSConf->NTLMDOMAIN == "Y") {
print "<TH width=16%>Domain\n";
}
}
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<TH width=15%>{$usersbuttom_2_traffic_UsersTrafficPeriod_6}\n";
print "<TH width=15%>{$usersbuttom_2_traffic_UsersTrafficPeriod_5}\n";
}
print "<TH width=30%>{$usersbuttom_2_traffic_UsersTrafficPeriod_7}\n";
print "</THEAD>\n";
print "<TBODY>\n";
$QUERY = "SELECT sum(c.s_size) as all_sum, sum(c.s_hit) as hit_sum, c.s_user, c.s_domain, s.s_nick, s.s_family, s.s_name, s.s_user_id FROM cachesum c, squiduser s WHERE lower(c.s_user)=lower(s.s_nick) AND c.s_date>='{$sdate}' AND c.s_date<='{$edate}' AND s.s_group_id='{$id}' GROUP BY lower(c.s_user), c.s_domain, s.s_nick, s.s_family, s.s_name, s.s_user_id ORDER BY all_sum DESC";
$num_rows = $DB->samsdb_query_value($QUERY);
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>\n";
LTableCell($count, 8);
if ($SAMSConf->SHOWNAME == "fam") {
$name = "{$row['s_family']}";
} else {
if ($SAMSConf->SHOWNAME == "famn") {
$name = "{$row['s_family']} {$row['s_name']}";
} else {
if ($SAMSConf->SHOWNAME == "nickd") {
$name = "{$row['s_nick']} / {$row['s_domain']}";
} else {
$name = "{$row['s_nick']}";
}
}
}
$str = "<A HREF=\"tray.php?show=exe&filename=usertray.php&function=usertray&id={$row['s_user_id']}\" TARGET=\"tray\">{$name}</A>\n";
LTableCell($str, 16);
if ($size == "On") {
LTableCell($row['s_family'], 16);
} else {
if (($SAMSConf->AUTH = "ntlm" || ($SAMSConf->AUTH = "adld")) && $SAMSConf->NTLMDOMAIN == "Y") {
TableCell($row['s_domain'], 16);
}
}
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
$aaa = FormattedString("{$row['0']}");
RTableCell($aaa, 15);
$aaa = FormattedString("{$row['1']}");
RTableCell($aaa, 15);
}
if ($SAMSConf->realtraffic == "real") {
PrintFormattedSize($row[0] - $row[1]);
} else {
PrintFormattedSize($row[0]);
}
print "</TR>\n";
$count = $count + 1;
$size2 = $size2 + $row[0];
$hitsize = $hitsize + $row[1];
}
print "</TBODY>\n";
print "<TFOOT>\n";
print "<TR>\n";
print "<TD>";
RBTableCell("{$vsego}", 16);
if (($SAMSConf->AUTH = "ntlm" || ($SAMSConf->AUTH = "adld")) && $SAMSConf->NTLMDOMAIN == "Y" || $size == "On") {
print "<TD>";
}
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
$aaa = FormattedString("{$size2}");
RBTableCell($aaa, 15);
$aaa = FormattedString("{$hitsize}");
RBTableCell($aaa, 15);
}
if ($SAMSConf->realtraffic == "real") {
PrintFormattedSize($size2 - $hitsize);
} else {
PrintFormattedSize($size2);
}
print "</TFOOT>\n";
print "</TABLE>\n";
}
function UserTrafficPeriod()
{
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();
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("usertraffic_48.jpg", "{$traffic_1} <FONT COLOR=\"BLUE\"> {$SquidUSERConf->s_nick}</FONT><BR>{$userbuttom_2_traffic_UserTrafficPeriod_2}");
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=\"usertrafficperiod\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"userbuttom_2_traffic.php\">\n";
$dateselect->SetPeriod();
print "<TD><IMG SRC=\"{$SAMSConf->ICONSET}/printer.gif\" TITLE=\"Print\" ALT=\"Print\" onClick=\"JavaScript:window.print();\"></TABLE>\n";
print "</FORM>\n";
printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> ");
printf("<P><IMG SRC=\"main.php?show=exe&function=usertrafficperiodgb&filename=userbuttom_2_traffic.php&id={$SquidUSERConf->s_user_id}&gb=1&sdate={$sdate}&edate={$edate}\"><P>");
$count = 1;
$cache = 0;
print "<TABLE CLASS=samstable>";
print "<THEAD>\n";
print "<TH>No";
print "<TH>{$traffic_data}";
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_3}";
print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_4}";
}
print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_5}";
print "</THEAD>\n";
print "<TBODY>\n";
$size = 0;
$QUERY = "SELECT sum(s_size),s_date,s_user,s_domain,sum(s_hit) FROM cachesum WHERE lower(s_user)=lower('" . $SquidUSERConf->s_nick . "') AND s_date>='{$sdate}' AND s_date<='{$edate}' GROUP BY s_date,s_user,s_domain ORDER BY s_date";
$num_rows = $DB->samsdb_query_value($QUERY);
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>";
LTableCell($count, 10);
$aaa = ReturnDate($row['s_date']);
LTableCell($aaa, 15);
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
$aaa = FormattedString("{$row['0']}");
RTableCell($aaa, 25);
$aaa = FormattedString("{$row['4']}");
RTableCell($aaa, 25);
}
// if($SAMSConf->realtraffic=="real")
PrintFormattedSize($row[0] - $row[4]);
// else
// PrintFormattedSize($row[0]);
print "</TR>";
$count = $count + 1;
$size = $size + $row[0];
$cache = $cache + $row[4];
}
print "<TR>";
print "</TBODY>\n";
print "<TD>";
RBTableCell("{$vsego}", 25);
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
// $aaa=FormattedString("$size");
// RBTableCell("$aaa",25);
PrintFormattedSize($size);
// $aaa=FormattedString("$cache");
// RBTableCell("$aaa",25);
PrintFormattedSize($cache);
}
// if($SAMSConf->realtraffic=="real")
PrintFormattedSize($size - $cache);
// else
// PrintFormattedSize($size);
// echo "$SAMSConf->realtraffic";
print "</TABLE>";
}
function ShowLogPeriod()
{
global $SAMSConf;
global $DATE;
global $USERConf;
global $SquidUSERConf;
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
if (isset($_GET["clear"])) {
$clear = $_GET["clear"];
}
$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();
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("samslog_48.jpg", "{$configbuttom_7_log_1}");
if ($clear == "on") {
$QUERY = "DELETE FROM samslog WHERE s_date>='{$sdate}' AND s_date<='{$edate}'";
$num_rows = $DB->samsdb_query($QUERY);
$SAMSConf->AddLog("webinterface", "User " . $USERConf->s_nick . " " . $SAMSConf->adminname . " clear the SAMS logs ({$sdate} to {$edate})", $DATE->today, $DATE->thistime);
printf("<h3>{$configbuttom_7_log_9}</h3>");
} else {
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=\"showlogperiod\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"configbuttom_7_log.php\">\n";
$dateselect->SetPeriod();
print "<B>{$configbuttom_7_log_8}</B> <INPUT TYPE=\"checkbox\" NAME=\"clear\"><br>";
print "<TD><IMG SRC=\"{$SAMSConf->ICONSET}/printer.gif\" TITLE=\"Print\" ALT=\"Print\" onClick=\"JavaScript:window.print();\"></TABLE>\n";
print "</FORM>\n";
printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> ");
$count = 1;
$cache = 0;
print "<TABLE CLASS=samstable>";
print "<THEAD>\n";
// if($USERConf->ToWebInterfaceAccess("C")==1)
// {
print "<TH>{$configbuttom_7_log_2}";
print "<TH>{$configbuttom_7_log_3}";
print "<TH>{$configbuttom_7_log_4}";
print "<TH>{$configbuttom_7_log_5}";
print "<TH>{$configbuttom_7_log_6}";
// }
print "<TH>{$configbuttom_7_log_7}";
print "</THEAD>\n";
print "<TBODY>\n";
$size = 0;
$QUERY = "SELECT * FROM samslog WHERE s_date>='{$sdate}' AND s_date<='{$edate}' ORDER BY s_date, s_time";
$num_rows = $DB->samsdb_query_value($QUERY);
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>";
RTableCell($row['s_log_id'], 25);
LTableCell($row['s_date'], 15);
RTableCell($row['s_time'], 25);
RTableCell($row['s_issuer'], 25);
RTableCell($row['s_value'], 25);
RTableCell($row['s_code'], 25);
print "</TR>";
$count = $count + 1;
$size = $size + $row[0];
$cache = $cache + $row[4];
}
print "<TR>";
print "</TBODY>\n";
print "<TD>";
print "</TABLE>";
}
}
function UserFileSize()
{
global $SAMSConf;
global $DATE;
global $USERConf;
global $SquidUSERConf;
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
if (isset($_GET["size"])) {
$size = $_GET["size"];
}
$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("filesize_48.jpg", "{$traffic_1} <FONT COLOR=\"BLUE\">{$SquidUSERConf->s_nick}</FONT> <BR>{$userbuttom_3_file_UserFileSizeForm_1}");
print "<FORM NAME=\"UserIDForm\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" id=UserName 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=\"userfilesize\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"userbuttom_3_file.php\">\n";
$dateselect->SetPeriod();
print "<B>{$usersbuttom_3_file_UsersFileSizePeriod_3}</B> <INPUT TYPE=\"TEXT\" NAME=\"size\"><br>";
print "</FORM>\n";
$URL = array("time" => array(), "url" => array(), "method" => array());
$fsize = $size * 1024;
$QUERY = "select s_date, s_time, s_user, s_size, s_url from squidcache where s_user='******'AND s_date>='{$sdate}' AND s_date<='{$edate}' AND s_size>'{$fsize}' ORDER BY s_size";
$num_rows = $DB->samsdb_query_value($QUERY);
print "<TABLE CLASS=samstable>";
print "<TH>No";
print "<TH>{$traffic_data}";
print "<TH>{$userbuttom_3_file_UserFileSizePeriod_4}";
print "<TH>URL";
$count = 1;
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>";
LTableCell($count, 8);
$aaa = ReturnDate($row['s_date']);
LTableCell($aaa, 15);
$aaa = FormattedString($row['s_size']);
RTableCell($aaa, 20);
LTableCell($row['s_url'], 57);
$count = $count + 1;
}
print "</TABLE>";
}
function SysInfo()
{
global $SAMSConf;
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
PageTop("stat_48.jpg", "{$configtray_0_Head}");
$hostname = GetSamsHostName();
$ipaddr = GetIPAddr();
$uptime = ExecuteShellScript("uptime", "");
print "<TABLE WIDTH=90%>";
print "<TR>";
print "<TD WIDTH=\"25%\"><B>{$configtray_0_Hostname}</B>";
print "<TD WIDTH=\"75%\">{$hostname}";
print "<TR>";
print "<TD WIDTH=\"25%\"><B>{$configtray_0_IP}</B>";
print "<TD WIDTH=\"75%\">{$ipaddr}";
print "<TR>";
print "<TD WIDTH=\"25%\"><B>{$configtray_0_Uptime}</B>";
print "<TD WIDTH=\"75%\">{$uptime}";
print "</TABLE>";
MemoryUsage();
FileSystemUsage();
$syea = strftime("%Y");
$smon = strftime("%m");
$eday = strftime("%d");
$sdate = "{$syea}-{$smon}-1";
$edate = "{$syea}-{$smon}-{$eday}";
$stime = "0:00:00";
$etime = "0:00:00";
print "<P><TABLE CLASS=samstable>\n";
print "<TH>\n";
print "<TH width=\"33%\" >{$configtray_3_SumTraffic}\n";
print "<TH width=\"33%\" >{$configtray_3_FromCache}\n";
print "<TH width=\"33%\" >{$configtray_3_Traffic}\n";
$num_rows = $DB->samsdb_query_value("SELECT sum(s_size),sum(s_hit) FROM cachesum WHERE s_date>='{$sdate}' AND s_date<='{$edate}' ");
$row = $DB->samsdb_fetch_array();
print "<TR>\n";
print "<TD >{$configtray_3_M}\n";
$aaa = FormattedString("{$row['0']}");
RTableCell($aaa, 33);
$aaa = FormattedString("{$row['1']}");
RTableCell($aaa, 33);
$aaa = $row[0] - $row[1];
$aaa = FormattedString($row[0] - $row[1]);
RTableCell($aaa, 33);
$num_rows = $DB->samsdb_query_value("SELECT sum(s_size),sum(s_hit) FROM cachesum WHERE s_date='{$edate}' ");
$row = $DB->samsdb_fetch_array();
print "<TR>\n";
print "<TD >{$configtray_3_D}\n";
$aaa = FormattedString("{$row['0']}");
RTableCell($aaa, 33);
$aaa = FormattedString("{$row['1']}");
RTableCell($aaa, 33);
$aaa = $row[0] - $row[1];
$aaa = FormattedString($row[0] - $row[1]);
RTableCell($aaa, 33);
print "</TABLE>\n";
}
function UsersChart()
{
global $SAMSConf;
global $DATE;
global $USERConf;
if ($USERConf->ToWebInterfaceAccess("CS") != 1) {
exit(0);
}
$DB = new SAMSDB();
$sdate = $DATE->sdate();
$edate = $DATE->edate();
$bdate = $DATE->BeginDate();
$eddate = $DATE->EndDate();
$size = "";
if (isset($_GET["size"])) {
$size = $_GET["size"];
}
if (isset($_GET["sort"])) {
$sort = $_GET["sort"];
}
if (isset($_GET["desc"])) {
$desc = $_GET["desc"];
}
require "reportsclass.php";
$dateselect = new DATESELECT($DATE->sdate(), $DATE->edate());
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
$a = array(array('users', 'users', 'desc', 'CHECKED'), array('groups', 'groups', '', ''));
PageTop("persent_48.jpg", "{$usersbuttom_4_percent_UsersPercentTraffic_1}<BR>{$usersbuttom_4_percent_UsersPercentTraffic_2}");
print "<FORM NAME=\"UserIDForm\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"userschart\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"usersbuttom_4_percent.php\">\n";
$dateselect->SetPeriod2("select sort mode", $a);
print "</FORM>\n";
printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> ");
printf("<P><IMG SRC=\"main.php?show=exe&function=userschartgb&filename=usersbuttom_4_percent.php&gb=1&sdate={$sdate}&edate={$edate}&sort={$sort} \"><P>");
if ($sort == "users") {
$QUERY = "SELECT c.s_user,sum(c.s_size) as user_size,sum(c.s_hit) as hit_size, s.s_user_id as s_id FROM cachesum c, squiduser s WHERE c.s_user=s.s_nick AND c.s_date>='{$sdate}' AND c.s_date<='{$edate}' GROUP BY c.s_user, s.s_user_id ORDER BY user_size DESC;";
} else {
$QUERY = "SELECT sum(sum.sum_size) as user_size, sum(sum.sum_hit) as hit_size, sum.sum_name as s_user, sum.sum_group_id as s_id FROM ( SELECT sum(c.s_size) as sum_size, sum(c.s_hit) as sum_hit, c.s_user as sum_user, s.s_group_id as sum_group_id, g.s_name as sum_name FROM cachesum c, squiduser s, sgroup g WHERE c.s_user=s.s_nick AND s.s_group_id=g.s_group_id AND s_date>='{$sdate}' AND s_date<='{$edate}' GROUP BY c.s_user, s.s_group_id, g.s_name ORDER BY g.s_name ) as sum GROUP BY s_user, sum.sum_group_id;";
}
$num_rows = $DB->samsdb_query_value($QUERY);
$count = 0;
$sum_size = 0;
$sum_hit = 0;
$sum_pc = 0;
while ($row = $DB->samsdb_fetch_array()) {
$user[$count] = $row['s_user'];
$size[$count] = $row['user_size'];
$userid[$count] = $row['s_id'];
$sum_size += $size[$count];
$hit[$count] = $row['hit_size'];
$sum_hit += $hit[$count];
$count++;
}
print "<TABLE CLASS=samstable>";
print "<TH width=8%>No";
print "<TH width=16%>{$usersbuttom_2_traffic_UsersTrafficPeriod_4}";
print "<TH width=16%>{$usersbuttom_2_traffic_UsersTrafficPeriod_6}";
print "<TH width=16%>{$usersbuttom_2_traffic_UsersTrafficPeriod_5}";
print "<TH width=16%>%";
for ($i = 0; $i < $count; $i++) {
print "<TR>";
LTableCell($i, 8);
if ($sort == "users") {
LTableCell("<A HREF=\"tray.php?show=exe&filename=usertray.php&function=usertray&auth=adld&id=" . $userid[$i] . "\" TARGET=\"tray\" >" . $user[$i] . "</A>", 16);
} else {
LTableCell("<A HREF=\"tray.php?show=exe&filename=grouptray.php&function=grouptray&id=" . $userid[$i] . "\" TARGET=\"tray\" >" . $user[$i] . "</A>", 16);
}
RTableCell(FormattedString($size[$i]), 16);
RTableCell(FormattedString($hit[$i]), 16);
$pc[$i] = round($size[$i] / ($sum_size / 100), 2);
$sum_pc += $pc[$i];
RTableCell($pc[$i], 16);
}
print "<TR><TD><TD>";
RBTableCell(FormattedString($sum_size), 16);
RBTableCell(FormattedString($sum_hit), 16);
print "<TD>";
print "</TABLE>";
}
function UserSitesPeriod_new()
{
global $SAMSConf;
global $DATE;
global $USERConf;
global $SquidUSERConf;
if (isset($_GET["id"])) {
$id = $_GET["id"];
}
$SquidUSERConf = new SAMSUSER();
$SquidUSERConf->sams_user($id);
require "reportsclass.php";
$DB = new SAMSDB();
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
if (isset($_GET["username"])) {
$username = $_GET["username"];
}
if (isset($_GET["userdomain"])) {
$userdomain = $_GET["userdomain"];
}
if (isset($_GET["userid"])) {
$userid = $_GET["userid"];
}
if (isset($_GET["usergroup"])) {
$usergroup = $_GET["usergroup"];
}
if ($USERConf->ToWebInterfaceAccess("GSC") != 1 && ($USERConf->s_user_id != $SquidUSERConf->s_user_id && $USERConf->ToWebInterfaceAccess("W") != 1)) {
exit(0);
}
$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;
$dateselect = new DATESELECT($DATE->sdate(), $DATE->edate());
PageTop("straffic_48.jpg", "{$traffic_1} <FONT COLOR=\"BLUE\">{$SquidUSERConf->s_nick}</FONT><BR>{$userbuttom_4_site_UserSitesPeriod_2}");
print "<TABLE WIDTH=\"90%\"><TR><TD>";
print "<FORM NAME=\"UserIDForm\" ACTION=\"main.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" id=Show value=\"exe\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" id=function value=\"usersitesperiod\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"userbuttom_4_site.php\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"id\" id=id value=\"{$SquidUSERConf->s_user_id}\">\n";
$dateselect->SetPeriod();
print "<TD><IMG SRC=\"{$SAMSConf->ICONSET}/printer.gif\" TITLE=\"Print\" ALT=\"Print\" onClick=\"JavaScript:window.print();\"></TABLE>\n";
print "</FORM>\n";
printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> ");
print "<TABLE CLASS=samstable>";
print "<TH WIDTH=6%>No";
print "<TH WIDTH=20%>Domain";
print "<TH WIDTH=20%>URL";
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<TH WIDTH=15%>{$userbuttom_4_site_UserSitesPeriod_3}";
print "<TH WIDTH=15%>{$userbuttom_4_site_UserSitesPeriod_4}";
}
print "<TH WIDTH=15%>{$userbuttom_4_site_UserSitesPeriod_5}";
$URL = array("url_domain" => array(), "norm_url" => array(), "url_size" => array(), "hit_size" => array(), "sum_size" => array());
$query = "SELECT substring( s_url from position('//' in s_url)+2 for position('/' in substring(s_url from position('/' in s_url)+2 )) ) as url_domain,sum(s_size) as url_size,sum(s_hit) as hit_size FROM squidcache WHERE lower(s_user)=lower('" . $SquidUSERConf->s_nick . "') AND s_date>='{$sdate}'AND s_date<='{$edate}' AND s_method!='CONNECT' GROUP BY url_domain ORDER BY url_domain desc limit 25000";
$num_rows = $DB->samsdb_query_value($query);
$count = 0;
$cache = 0;
$counter = 0;
$url_domain = "";
while ($row = $DB->samsdb_fetch_array()) {
if (strlen($row['url_domain']) > 0) {
$url_domain = explode(".", str_replace("/", "", $row['url_domain']));
$ucount = count($url_domain);
$URL["url_domain"][$count] = $url_domain[$ucount - 2] . "." . $url_domain[$ucount - 1];
$URL["norm_url"][$count] = str_replace("/", "", $row['url_domain']);
$URL["url_size"][$count] = $row['url_size'];
$URL["hit_size"][$count] = $row['hit_size'];
// if($SAMSConf->realtraffic=="real")
$URL["sum_size"][$count] = $row['url_size'] - $row['hit_size'];
// else
// $URL["sum_size"][$count]=$row['url_size'];
$count++;
}
}
$query = "SELECT substring( s_url from 0 for position(':' in s_url) ) as url_domain,sum(s_size) as url_size,sum(s_hit) as hit_size FROM squidcache WHERE lower(s_user)=lower('" . $SquidUSERConf->s_nick . "') AND s_date>='{$sdate}'AND s_date<='{$edate}' AND s_method='CONNECT' GROUP BY url_domain ORDER BY url_domain desc limit 25000;";
$num_rows = $DB->samsdb_query_value($query);
while ($row = $DB->samsdb_fetch_array()) {
if (strlen($row['url_domain']) > 0) {
$url_domain = explode(".", str_replace("/", "", $row['url_domain']));
$ucount = count($url_domain);
$URL["url_domain"][$count] = $url_domain[$ucount - 2] . "." . $url_domain[$ucount - 1];
$URL["norm_url"][$count] = str_replace("/", "", $row['url_domain']);
$URL["url_size"][$count] = $row['url_size'];
$URL["hit_size"][$count] = $row['hit_size'];
// if($SAMSConf->realtraffic=="real")
$URL["sum_size"][$count] = $row['url_size'] - $row['hit_size'];
// else
// $URL["sum_size"][$count]=$row['url_size'];
$count++;
}
}
asort($URL["url_domain"]);
reset($URL["url_domain"]);
$count = 0;
$url_size_value = 0;
$hit_size_value = 0;
$sum_size_value = 0;
$url_domain_size_value = 0;
$hit_domain_size_value = 0;
$sum_domain_size_value = 0;
while (list($key, $val) = each($URL["url_domain"])) {
print "<TR>";
if ($url_domain != $val) {
if ($count != 0) {
echo "<TD colspan=3> ";
RBTableCell(FormattedString($url_domain_size_value), 15);
RBTableCell(FormattedString($hit_domain_size_value), 15);
RBTableCell(FormattedString($sum_domain_size_value), 15);
$url_domain_size_value = 0;
$hit_domain_size_value = 0;
$sum_domain_size_value = 0;
echo "<TR>";
}
$q = $count + 1;
echo "<TD>{$q}\n";
if (ctype_alpha($val[strlen($val) - 1]) == TRUE) {
print "<TD colspan=5><A HREF=\"http://{$val}\" TARGET=\"BLANK\"><B>{$val}</B></A>\n";
} else {
print "<TD colspan=5><A HREF=\"http://" . $URL["norm_url"][$key] . "\" TARGET=\"BLANK\"><B>" . $URL["norm_url"][$key] . "</B></A>\n";
}
$url_domain = $val;
$count++;
print "<TR>";
print "<TD colspan=2>\n";
RTableCell("<A HREF=\"main.php?show=exe&filename=userbuttom_4_site.php&function=showloadingfilesfromdomain&id={$id}&SDay={$sday}&SMon={$smon}&SYea={$syea}&EDay={$eday}&EMon={$emon}&EYea={$eyea}&url=" . $URL["norm_url"][$key] . "\" TARGET=\"BLANK\" >" . $URL["norm_url"][$key] . "</A>\n", 15);
RTableCell(FormattedString($URL["url_size"][$key]), 15);
RTableCell(FormattedString($URL["hit_size"][$key]), 15);
RTableCell(FormattedString($URL["sum_size"][$key]), 15);
$url_size_value += $URL["url_size"][$key];
$hit_size_value += $URL["hit_size"][$key];
$sum_size_value += $URL["sum_size"][$key];
$url_domain_size_value += $URL["url_size"][$key];
$hit_domain_size_value += $URL["hit_size"][$key];
$sum_domain_size_value += $URL["sum_size"][$key];
} else {
print "<TD colspan=2>\n";
RTableCell("<A HREF=\"main.php?show=exe&filename=userbuttom_4_site.php&function=showloadingfilesfromdomain&id={$id}&SDay={$sday}&SMon={$smon}&SYea={$syea}&EDay={$eday}&EMon={$emon}&EYea={$eyea}&url=" . $URL["norm_url"][$key] . "\" TARGET=\"BLANK\" >" . $URL["norm_url"][$key] . "</A>\n", 15);
RTableCell(FormattedString($URL["url_size"][$key]), 15);
RTableCell(FormattedString($URL["hit_size"][$key]), 15);
RTableCell(FormattedString($URL["sum_size"][$key]), 15);
$url_size_value += $URL["url_size"][$key];
$hit_size_value += $URL["hit_size"][$key];
$sum_size_value += $URL["sum_size"][$key];
$url_domain_size_value += $URL["url_size"][$key];
$hit_domain_size_value += $URL["hit_size"][$key];
$sum_domain_size_value += $URL["sum_size"][$key];
}
}
print "<TR>";
echo "<TD colspan=3> ";
RBTableCell(FormattedString($url_domain_size_value), 15);
RBTableCell(FormattedString($hit_domain_size_value), 15);
RBTableCell(FormattedString($sum_domain_size_value), 15);
print "<TR>";
print "<TD colspan=3>\n";
// RBTableCell(FormattedString($url_size_value),15);
PrintFormattedSize($url_size_value);
// RBTableCell(FormattedString($hit_size_value),15);
PrintFormattedSize($hit_size_value);
// RBTableCell(FormattedString($sum_size_value),15);
// if($SAMSConf->realtraffic=="real")
PrintFormattedSize($url_size_value - $hit_size_value);
// else
// PrintFormattedSize($url_size_value);
print "</TABLE>";
}
