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 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 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 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 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 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 ShowLoadingFilesFromDomain() { 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["url"])) { $url = $_GET["url"]; } 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", "{$userbuttom_4_site_SiteUserList_1} {$url} <BR>{$userbuttom_4_site_SiteUserList_6} <FONT COLOR=\"BLUE\">{$SquidUSERConf->s_nick}</FONT>"); printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> "); $QUERY = "select * from squidcache where lower(s_user)=lower('" . $SquidUSERConf->s_nick . "') AND s_url like '%{$url}%' AND s_date>='{$sdate}' AND s_date<='{$edate}' ORDER BY s_url"; $num_rows = $DB->samsdb_query_value($QUERY); print "<TABLE CLASS=samstable>"; print "<TH WIDTH=10%>Date"; print "<TH WIDTH=10%>{$usersbuttom_2_traffic_UsersTrafficPeriod_4}"; print "<TH WIDTH=60%>URL"; print "<TH WIDTH=10%>{$usersbuttom_2_traffic_UsersTrafficPeriod_7}"; print "<TH WIDTH=10%>{$usersbuttom_2_traffic_UsersTrafficPeriod_5}"; while ($row = $DB->samsdb_fetch_array()) { echo "<TR>\n"; RTableCell($row['s_date'], 10); RTableCell($row['s_user'], 10); LTableCell(" " . $row['s_url'], 60); RTableCell(FormattedString($row['s_size']), 10); RTableCell(FormattedString($row['s_hit']), 10); } }
function SiteUsersList() { global $SAMSConf; global $DATE; global $USERConf; require "reportsclass.php"; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["site"])) { $site = $_GET["site"]; } if (isset($_GET["id"])) { $id = $_GET["id"]; } $sdate = $DATE->sdate(); $edate = $DATE->edate(); $bdate = $DATE->BeginDate(); $eddate = $DATE->EndDate(); if ($USERConf->ToWebInterfaceAccess("GSC") != 1 && ($USERConf->s_user_id != $SquidUSERConf->s_user_id && $USERConf->ToWebInterfaceAccess("W") != 1)) { exit(0); } $dateselect = new DATESELECT($DATE->sdate(), $DATE->edate()); PageTop("usergroup_48.jpg", "{$userbuttom_4_site_SiteUserList_1} <BR>{$site} {$USERConf->s_nick}"); printf("<BR><B>{$traffic_2} {$bdate} {$traffic_3} {$eddate}</B> "); print "<script language=JAVASCRIPT>\n"; print "function EditURL(URL)\n"; print "{\n"; print "document.forms[\"REDIRECT\"].elements[\"addurl\"].value=URL;\n"; print "}\n"; print "function CloseWindow()\n"; print "{\n"; print "this.document.forms[\"REDIRECT\"].submit();\n"; print "window.close;\n"; print "}\n"; print "</script>\n"; print "<FORM NAME=\"REDIRECT\" ACTION=\"main.php\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"show\" value=\"exe\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"function\" value=\"addurltolist\">\n"; print "<INPUT TYPE=\"HIDDEN\" NAME=\"filename\" value=\"usersbuttom_3_site.php\">\n"; print "<TABLE>\n"; print "<TR>\n"; print "<TD>\n"; print "<B>{$userbuttom_4_site_SiteUserList_2}:\n"; print "<TD>\n"; print "<INPUT TYPE=\"TEXT\" NAME=\"addurl\" SIZE=30> \n"; print "<TR>\n"; print "<TD>\n"; print "<B>{$userbuttom_4_site_SiteUserList_3}:\n"; print "<TD>\n"; print "<SELECT NAME=\"type\" >\n"; $num_rows = $DB->samsdb_query_value("SELECT s_redirect_id,s_name FROM redirect"); while ($row2 = $DB->samsdb_fetch_array()) { print "<OPTION VALUE={$row2['s_redirect_id']}> {$row2['s_name']}"; } print "</SELECT>\n"; $DB->free_samsdb_query(); print "</TABLE>\n"; print "<BR><INPUT TYPE=\"SUBMIT\" value=\"{$userbuttom_4_site_SiteUserList_4}\" onsubmit=CloseWindow()>\n"; print "</FORM>\n"; print "<P><TABLE CLASS=samstable>"; print "<TR>"; print "<TH>{$grptraffic_2}</b></TD>"; print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_3}"; print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_4}"; print "<TH>{$userbuttom_2_traffic_UserTrafficPeriod_5}"; print "<TH>URL"; $QUERY = "SELECT s_date,s_user,s_size,s_url FROM squidcache WHERE s_date>='{$sdate}' AND s_date<='{$edate}' AND s_url like '%{$site}%' ORDER BY s_size desc limit 250"; $num_rows = $DB->samsdb_query_value($QUERY); $counter = 0; while ($row = $DB->samsdb_fetch_array()) { print "<TR>"; LTableCell("{$row['s_date']}", 10); LTableCell("{$row['s_user']}", 20); $aaa = FormattedString("{$row['s_size']}"); RTableCell($aaa, 20); if ($SAMSConf->realtraffic == "real") { PrintFormattedSize($row['s_size'] - $row['s_hit']); } else { PrintFormattedSize($row['s_size']); } print "<TD ALIGN=\"LEFT\" bgcolor=blanchedalmond onclick=EditURL(\"{$row['s_url']}\")> {$row['3']} \n"; } print "</TABLE>"; }