[aur-dev] [PATCH 5/5] Add more stats to the front page table

[Dan McGee]

Signed-off-by: Dan McGee <d...@archlinux.org>
---
 web/lib/stats.inc                          |   18 ++++++++++++++++--
 web/template/stats/general_stats_table.php |   20 ++++++++++++++++++--
 2 files changed, 34 insertions(+), 4 deletions(-)

diff --git a/web/lib/stats.inc b/web/lib/stats.inc
index a345c40..75b2537 100644
--- a/web/lib/stats.inc
+++ b/web/lib/stats.inc
@@ -36,7 +36,7 @@ function updates_table($dbh)
        global $apc_prefix, $apc_ttl;
        $key = $apc_prefix . 'recent_updates';
        if(!(EXTENSION_LOADED_APC && ($newest_packages = apc_fetch($key)))) {
-               $q = 'SELECT * FROM Packages ORDER BY ModifiedTS DESC LIMIT 0 , 
10';
+               $q = 'SELECT * FROM Packages ORDER BY ModifiedTS DESC LIMIT 10';
                $result = db_query($q, $dbh);
 
                $newest_packages = new ArrayObject();
@@ -77,6 +77,9 @@ function general_stats_table($dbh)
        $q = "SELECT count(*) FROM Packages";
        $unsupported_count = db_cache_value($q, $dbh, $apc_prefix . 
'unsupported_count');
 
+       $q = "SELECT count(*) FROM Packages WHERE MaintainerUID IS NULL";
+       $orphan_count = db_cache_value($q, $dbh, $apc_prefix . 'orphan_count');
+
        $q = "SELECT count(*) from Users";
        $user_count = db_cache_value($q, $dbh, $apc_prefix . 'user_count');
 
@@ -84,9 +87,20 @@ function general_stats_table($dbh)
        $tu_count = db_cache_value($q, $dbh, $apc_prefix . 'tu_count');
 
        $targstamp = intval(strtotime("-7 days"));
-       $q = "SELECT count(*) from Packages WHERE Packages.ModifiedTS >= 
$targstamp";
+       $yearstamp = intval(strtotime("-1 year"));
+
+       $q = "SELECT count(*) from Packages WHERE Packages.ModifiedTS >= 
$targstamp AND Packages.ModifiedTS = Packages.SubmittedTS";
+       $add_count = db_cache_value($q, $dbh, $apc_prefix . 'add_count');
+
+       $q = "SELECT count(*) from Packages WHERE Packages.ModifiedTS >= 
$targstamp AND Packages.ModifiedTS != Packages.SubmittedTS";
        $update_count = db_cache_value($q, $dbh, $apc_prefix . 'update_count');
 
+       $q = "SELECT count(*) from Packages WHERE Packages.ModifiedTS >= 
$yearstamp AND Packages.ModifiedTS != Packages.SubmittedTS";
+       $update_year_count = db_cache_value($q, $dbh, $apc_prefix . 
'update_year_count');
+
+       $q = "SELECT count(*) from Packages WHERE Packages.ModifiedTS = 
Packages.SubmittedTS";
+       $never_update_count = db_cache_value($q, $dbh, $apc_prefix . 
'never_update_count');
+
        include('stats/general_stats_table.php');
 }
 
diff --git a/web/template/stats/general_stats_table.php 
b/web/template/stats/general_stats_table.php
index c136111..a100dfe 100644
--- a/web/template/stats/general_stats_table.php
+++ b/web/template/stats/general_stats_table.php
@@ -3,14 +3,30 @@
                <th colspan='2' class='boxSoftTitle'><span class='f3'><?php 
print __("Statistics") ?></span></th>
        </tr>
        <tr>
-               <td class='boxSoft'><span class='f4'><?php print __("Packages 
in unsupported"); ?></span></td>
+               <td class='boxSoft'><span class='f4'><?php print 
__("Packages"); ?></span></td>
                <td class='boxSoft'><span class='f4'><?php print 
$unsupported_count; ?></span></td>
        </tr>
        <tr>
-               <td class='boxSoft'><span class='f4'><?php print __("Packages 
added or updated in the past 7 days"); ?></span></td>
+               <td class='boxSoft'><span class='f4'><?php print __("Orphan 
Packages"); ?></span></td>
+               <td class='boxSoft'><span class='f4'><?php print $orphan_count; 
?></span></td>
+       </tr>
+       <tr>
+               <td class='boxSoft'><span class='f4'><?php print __("Packages 
added in the past 7 days"); ?></span></td>
+               <td class='boxSoft'><span class='f4'><?php print $add_count; 
?></span></td>
+       </tr>
+       <tr>
+               <td class='boxSoft'><span class='f4'><?php print __("Packages 
updated in the past 7 days"); ?></span></td>
                <td class='boxSoft'><span class='f4'><?php print $update_count; 
?></span></td>
        </tr>
        <tr>
+               <td class='boxSoft'><span class='f4'><?php print __("Packages 
updated in the past year"); ?></span></td>
+               <td class='boxSoft'><span class='f4'><?php print 
$update_year_count; ?></span></td>
+       </tr>
+       <tr>
+               <td class='boxSoft'><span class='f4'><?php print __("Packages 
never updated"); ?></span></td>
+               <td class='boxSoft'><span class='f4'><?php print 
$never_update_count; ?></span></td>
+       </tr>
+       <tr>
                <td class='boxSoft'><span class='f4'><?php print __("Registered 
Users"); ?></span></td>
                <td class='boxSoft'><span class='f4'><?php print $user_count; 
?></span></td>
        </tr>
-- 
1.7.4.2