function GroupTrafficPeriodGB() { require 'lib/chart.php'; global $SAMSConf; global $DATE; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; if (isset($_GET["sort"])) { $sort = $_GET["sort"]; } if (isset($_GET["desc"])) { $desc = $_GET["desc"]; } if (isset($_GET["id"])) { $id = $_GET["id"]; } $sdate = $DATE->sdate(); $edate = $DATE->edate(); $bdate = $DATE->BeginDate(); $eddate = $DATE->EndDate(); $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); $count = 0; while ($row = $DB->samsdb_fetch_array()) { $SIZE[$count] = floor($row[0] / ($SAMSConf->KBSIZE * $SAMSConf->KBSIZE)); $HIT[$count] = floor($row[1] / ($SAMSConf->KBSIZE * $SAMSConf->KBSIZE)); $USERS[$count] = $row["s_user"]; $count++; } $showbar = new BAR(500, 200, 30, 20, $SIZE, $HIT, $count, $USERS); $showbar->CreateBars(); }
function UsersTrafficPeriodGB() { require 'lib/chart.php'; global $SAMSConf; global $DATE; $DB = new SAMSDB(); $lang = "./lang/lang.{$SAMSConf->LANG}"; require $lang; $sdate = $DATE->sdate(); $edate = $DATE->edate(); $bdate = $DATE->BeginDate(); $eddate = $DATE->EndDate(); $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); $count = 0; while ($row = $DB->samsdb_fetch_array()) { $SIZE[$count] = floor($row[0] / ($SAMSConf->KBSIZE * $SAMSConf->KBSIZE)); $HIT[$count] = floor($row[1] / ($SAMSConf->KBSIZE * $SAMSConf->KBSIZE)); $USERS[$count] = $row["s_user"]; $count++; } $showbar = new BAR(500, 200, 30, 20, $SIZE, $HIT, $count, $USERS); $showbar->CreateBars(); }