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>"; }