Changeset 1413 for trunk/bureau/admin/stats_show_per_month.php

Timestamp:

08/02/05 16:56:51 (8 years ago)

Author:

anarcat

Message:

ne pas load la liste d'usager avec admin->get_list() mais avec un join
dans la requete

trier par username

File:

• trunk/bureau/admin/stats_show_per_month.php (modified) (2 diffs)

trunk/bureau/admin/stats_show_per_month.php

@@ -91 +91 @@
 }
 
-if (! ($user_list = $admin->get_list())) {
-        $error = $err->errstr();
-}
-$u = array();
-foreach ($user_list as $user) {
-  $u[$user['uid']] = $user['login'];
-}
-$u[0] = 'inconnu';
-
 // the stats in the last $count months for all accounts
 $db->query("
-SELECT SUM( size ) AS cnt, uid, date_format(
-DAY , '%Y-%m' ) AS `month`
-FROM `stat_http`
+SELECT SUM( s.size ) AS cnt, s.uid, date_format(
+DAY , '%Y-%m' ) AS `month`, m.login
+FROM `stat_http` s, membres m
 WHERE `day` < CONCAT( date_format( DATE_ADD( NOW( ) , INTERVAL 1 
 MONTH ) , '%Y-%m' ) , '-01' )
 AND `day` >= CONCAT( date_format( DATE_SUB( NOW( ) , INTERVAL " . (int) ($count - 1) .
-" MONTH ) , '%Y-%m' ) , '-01' )
+" MONTH ) , '%Y-%m' ) , '-01' ) 
+AND m.uid = s.uid
 GROUP BY `uid` , `month`
-ORDER BY `uid` 
+ORDER BY `login`
 ");
 
@@ -118 +110 @@
     if (!is_null($current_user)) { // not the first time we enter this block
       $class = ($class== 'lst1' ? 'lst2' : 'lst1');
-      print "<tr class=\"$class\"><td><acronym title=\"$u[$current_user]\">" . $current_user . "</acronym></td>\n";
+      print "<tr class=\"$class\"><td><acronym title=\"$current_user\">".$db->f("login")."</acronym></td>\n";
       foreach ($months as $m) {
         print "<td>" . m_quota::display_val('bw_web', $entries[$m]) . "</td>\n";