Exemplo n.º 1
0
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>";
}
Exemplo n.º 2
0
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>";
}
Exemplo n.º 3
0
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++;
        }
    }
}
Exemplo n.º 4
0
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";
}
Exemplo n.º 5
0
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>";
    }
}
Exemplo n.º 6
0
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>";
}
Exemplo n.º 7
0
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>";
}
Exemplo n.º 8
0
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);
    }
}
Exemplo n.º 9
0
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']}\")> &nbsp;{$row['3']} \n";
    }
    print "</TABLE>";
}