Changeset 710

Timestamp:

11/10/09 14:20:55 (10 months ago)

Author:

DmitryChemerik

Message:

переписан отчет по трафику пользователей в %

Location:

trunk/php

Files:

• lib/piegraph.class.php (added)
• src/usersbuttom_4_percent.php (modified) (5 diffs)

trunk/php/src/usersbuttom_4_percent.php

@@ -53 +53 @@
 }
 
+
 function UsersChartGB()
 {
-  require('lib/chart.php');
+  require('lib/piegraph.class.php');
   
   global $SAMSConf;
@@ -74 +75 @@
         $full_utraffic_size=$row['user_size'];
         $DB->free_samsdb_query();
-
+         $colors=array("#FF0000","#0000FF","#FFFF00","#009000","#C3690F","#CC009C","#99CC33","#3C3CFF","#C9960C","#FF6F00","#C6C63C","#CC033C","#00FFFF","#636F66","#6FFF00","#96693F","#009C9C","#FFCC00","#9F9F6F","#CC60CC");
+        $usercolors=array();
 
         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;";
-
-
-//      $QUERY="SELECT s_user,sum(s_size) as user_size,sum(s_hit) as hit_size FROM cachesum WHERE s_date>='$sdate' AND s_date<='$edate' GROUP BY s_user ORDER BY user_size DESC";
+                $QUERY="SELECT sum.sum_name as s_user,sum(sum.sum_size) as user_size, sum(sum.sum_hit) as hit_size, 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;
@@ -93 +93 @@
                 if($row['user_size']>=($full_utraffic_size/100))
                 {
-                        $user[$count]=$row['s_user']." ( ".round($row['user_size']/($full_utraffic_size/100),2)."% )";
+                        if($count<count($colors))
+                        {
+                                $usercolors[$count]=$colors[$count];
+                        }
+                        else
+                        {
+                                $r=mt_rand(10,240);
+                                $g=mt_rand(10,240);
+                                $b=mt_rand(10,240);
+                                $usercolors[$count]="#".sprintf("%X%X%X",mt_rand(20,200),mt_rand(20,200),mt_rand(20,200));
+                        }
+                        $user[$count]=$row['s_user'];
                         $size[$count]=$row['user_size'];
                         $count++;
@@ -102 +113 @@
                 }
         }
-        $user[$count]="another users ( ".round($another_utraffic_size/($full_utraffic_size/100),2)."% )";
-        $size[$count]=$another_utraffic_size;
-        $count++;
-
-//round($size[$i]/($sum_size/100),2)
-  $circle=new CIRCLE3D(500, $count*15, $size, $count, $user);
-  $circle->ShowCircle();
-}
+        if($another_utraffic_size>0)
+        {
+                $user[$count]="another users";
+                $size[$count]=$another_utraffic_size;
+                $count++;
+        }
+
+        $pie = new PieGraph(400, 250, $size);
+        $pie->setColors($usercolors);
+        // legends for the data
+        $pie->setLegends($user);
+        // Display creation time of the graph
+        $pie->DisplayCreationTime();
+        // Height of the pie 3d effect
+        $pie->set3dHeight(15);
+        // Display the graph
+        $pie->display();
+}
+
 
 
@@ -138 +160 @@
   $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");