function SysInfo()
{
$result = "";
$result .= $this->SamsTools->PageTop("stat_48.jpg", "System Information");
$hostname = $this->SamsTools->GetHostName();
$ipaddr = $this->SamsTools->GetIPAddr();
$uptime = $this->SamsTools->GetUpTime();
$result .= "<TABLE WIDTH=90% CLASS=samstable>";
$result .= "<TR>";
$result .= "<TD WIDTH=\"25%\"><B>Hostname</B>";
$result .= "<TD WIDTH=\"75%\">" . $hostname;
$result .= "<TR>";
$result .= "<TD WIDTH=\"25%\"><B>IP addr</B>";
$result .= "<TD WIDTH=\"75%\">" . $ipaddr;
$result .= "<TR>";
$result .= "<TD WIDTH=\"25%\"><B>Uptime</B>";
$result .= "<TD WIDTH=\"75%\">" . $uptime;
$result .= "</TABLE>";
$result .= $this->SamsTools->MemoryUsage();
$result .= $this->SamsTools->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";
$result .= "<P><TABLE CLASS=samstable>\n";
$result .= "<TH>\n";
$result .= "<TH width=\"33%\" >All traffic\n";
$result .= "<TH width=\"33%\" >From cache\n";
$result .= "<TH width=\"33%\" >Traffic\n";
$num_rows = $this->SamsDb->samsdb_query_value("SELECT sum(s_size),sum(s_hit) FROM " . $SAMSConf->SAMSDB . ".cachesum WHERE s_date>=\"{$sdate}\" && s_date<=\"{$edate}\" ");
$row = $this->SamsDb->samsdb_fetch_array();
$result .= "<TR>\n";
$result .= "<TD > This month\n";
$aaa = FormattedString("{$row['0']}");
$result .= $this->SamsTools->RTableCell($aaa, 33);
$aaa = FormattedString("{$row['1']}");
$result .= $this->SamsTools->RTableCell($aaa, 33);
$aaa = $row[0] - $row[1];
$aaa = FormattedString($row[0] - $row[1]);
$result .= $this->SamsTools->RTableCell($aaa, 33);
$num_rows = $this->SamsDb->samsdb_query_value("SELECT sum(s_size),sum(s_hit) FROM " . $SAMSConf->SAMSDB . ".cachesum WHERE s_date=\"{$edate}\" ");
$row = $this->SamsDb->samsdb_fetch_array();
$result .= "<TR>\n";
$result .= "<TD > This day\n";
$aaa = FormattedString("{$row['0']}");
$result .= $this->SamsTools->RTableCell($aaa, 33);
$aaa = FormattedString("{$row['1']}");
$result .= $this->SamsTools->RTableCell($aaa, 33);
$aaa = $row[0] - $row[1];
$aaa = FormattedString($row[0] - $row[1]);
$result .= $this->SamsTools->RTableCell($aaa, 33);
$result .= "</TABLE>\n";
return $result;
}
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 UsersTrafficPeriod()
{
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"];
}
require "reportsclass.php";
$dateselect = new DATESELECT($DATE->sdate(), $DATE->edate());
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
PageTop("usergroup_48.jpg", "{$usersbuttom_2_traffic_UsersTrafficPeriod_1}<BR>{$usersbuttom_2_traffic_UsersTrafficPeriod_2}");
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=\"userstrafficperiod\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"usersbuttom_2_traffic.php\">\n";
$dateselect->SetPeriod();
print "<TD><IMG SRC=\"{$SAMSConf->ICONSET}/printer.gif\" TITLE=\"Print\" ALT=\"Print\" onClick=\"JavaScript:window.print();\">";
print "<A HREF=\"main.php?show=exe&function=userstrafficperiodpdf&filename=usersbuttom_2_traffic.php\"> pdf</a> </TABLE>\n";
print "</FORM>\n";
printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> ");
printf("<P><IMG SRC=\"main.php?show=exe&function=userstrafficperiodgb&filename=usersbuttom_2_traffic.php&gb=1&sdate={$sdate}&edate={$edate}\"><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\", \"sWidth\": \"8%\" },\n";
print "\t\t{ \"sType\": \"html\", \"sWidth\": \"16%\"},\n";
print "\t\t{ \"sType\": \"formatted-num\", \"sWidth\": \"15%\" },\n";
print "\t\t{ \"sType\": \"formatted-num\", \"sWidth\": \"15%\" },\n";
print "\t\t{ \"sType\": \"formatted-num\", \"sWidth\": \"30%\" }\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>No\n";
print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_4}\n";
if ($size == "On") {
print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_8}\n";
} else {
if (($SAMSConf->AUTH = "ntlm" || ($SAMSConf->AUTH = "adld")) && $SAMSConf->NTLMDOMAIN == "Y") {
print "<TH>Domain\n";
}
}
if ($USERConf->ToWebInterfaceAccess("C") == 1) {
print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_6}\n";
print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_5}\n";
}
print "<TH>{$usersbuttom_2_traffic_UsersTrafficPeriod_7}\n";
print "</THEAD>\n";
print "<TBODY>\n";
$QUERY = "SELECT sum(cachesum.s_size),sum(cachesum.s_hit),cachesum.s_user,cachesum.s_domain, squiduser.s_nick, squiduser.s_family, squiduser.s_name, squiduser.s_user_id FROM cachesum LEFT JOIN squiduser ON cachesum.s_user=squiduser.s_nick WHERE cachesum.s_date>='{$sdate}'AND cachesum.s_date<='{$edate}' GROUP BY cachesum.s_user,cachesum.s_domain,squiduser.s_nick,squiduser.s_family, squiduser.s_name, squiduser.s_user_id order by sum(cachesum.s_size) desc";
$num_rows = $DB->samsdb_query_value($QUERY);
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>\n";
//LTableCell($count,8);
print "<TD>{$count}";
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']}");
LTableCell("{$aaa}", 15);
$aaa = FormattedString("{$row['1']}");
LTableCell("{$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><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></TABLE>\n";
}
function UsersTrafficStat()
{
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["type"])) {
$type = $_GET["type"];
}
if (isset($_GET["text"])) {
$text = $_GET["text"];
}
require "reportsclass.php";
$dateselect = new DATESELECT($DATE->sdate(), $DATE->edate());
$lang = "./lang/lang.{$SAMSConf->LANG}";
require $lang;
PageTop("filesize_48.jpg", "{$usersbuttom_3_file_usersbuttom_3_file_1}");
print "<BR>\n";
print "<TABLE WIDTH=\"90%\" ALIGN=CENTER><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=\"userstrafficstat\">\n";
print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" id=filename value=\"usersbuttom_4_file.php\">\n";
$dateselect->SetPeriod();
print "<SELECT NAME=\"type\">";
if ($type == "size") {
print "<OPTION VALUE=\"size\" SELECTED> {$mysqltools_dateselect5}";
print "<OPTION VALUE=\"url\"> {$mysqltools_dateselect6}";
} else {
print "<OPTION VALUE=\"size\"> {$mysqltools_dateselect5}";
print "<OPTION VALUE=\"url\" SELECTED> {$mysqltools_dateselect6}";
}
print " <INPUT TYPE=\"TEXT\" NAME=\"text\" VALUE=\"{$text}\">\n";
print "</FORM>\n";
print "</TABLE>\n";
printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> ");
if ($type == "size") {
$count = 1;
$bytes = $text * 1024;
$QUERY = "SELECT squidcache.s_user, squidcache.s_url, squidcache.s_size, squidcache.s_hit, squidcache.s_date, squiduser.s_family, squiduser.s_name, squiduser.s_domain, squiduser.s_nick FROM squidcache LEFT JOIN squiduser ON squidcache.s_user=squiduser.s_nick WHERE squidcache.s_size>='" . $bytes . "' ORDER BY squidcache.s_size";
$num_rows = $DB->samsdb_query_value($QUERY);
print "<TABLE CLASS=samstable id=\"userstraffic\">\n";
print "<THEAD>\n";
print "<TH>No\n";
print "<TH>{$usersbuttom_3_file_UsersFileSizePeriod_4}\n";
print "<TH>{$usersbuttom_3_file_UsersFileSizePeriod_5}\n";
print "<TH>{$usersbuttom_3_file_UsersFileSizePeriod_6}\n";
print "<TH>{$squidbuttom_5_readcache_LoadFileForm_2}\n";
print "<TH>URL\n";
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>\n";
print "<TD>{$count}";
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_user'];
}
}
}
LTableCell($name, 15);
LTableCell($row['s_date'], 10);
$aaa = FormattedString($row['s_size']);
LTableCell($aaa, 10);
$aaa = FormattedString($row['s_hit']);
LTableCell($aaa, 10);
LTableCell($row['s_url'], 16);
$count++;
}
} else {
$count = 1;
$QUERY = "SELECT squidcache.s_user, squidcache.s_url, squidcache.s_size, squidcache.s_hit, squidcache.s_date, squiduser.s_family, squiduser.s_name, squiduser.s_domain, squiduser.s_nick FROM squidcache LEFT JOIN squiduser ON squidcache.s_user=squiduser.s_nick WHERE squidcache.s_url like '%" . $text . "%' ORDER BY squidcache.s_size";
$num_rows = $DB->samsdb_query_value($QUERY);
print "<TABLE CLASS=samstable id=\"userstraffic\">\n";
print "<THEAD>\n";
print "<TH>No\n";
print "<TH>{$usersbuttom_3_file_UsersFileSizePeriod_4}\n";
print "<TH>{$usersbuttom_3_file_UsersFileSizePeriod_5}\n";
print "<TH>URL\n";
print "<TH>{$usersbuttom_3_file_UsersFileSizePeriod_6}\n";
print "<TH>{$squidbuttom_5_readcache_LoadFileForm_2}\n";
while ($row = $DB->samsdb_fetch_array()) {
print "<TR>\n";
print "<TD>{$count}";
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']}";
}
}
}
LTableCell($name, 15);
LTableCell($row['s_date'], 10);
LTableCell($row['s_url'], 16);
$aaa = FormattedString($row['s_size']);
LTableCell($aaa, 10);
$aaa = FormattedString($row['s_hit']);
LTableCell($aaa, 10);
$count++;
}
}
}
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>";
}
