web/lib/stats.inc.php

   1 <?php
   2
   3 include_once('aur.inc.php');
   4
   5 /**
   6  * Display the most recent 10 packages
   7  *
   8  * @return void
   9  */
  10 function updates_table() {
  11         $dbh = DB::connect();
  12         $key = 'recent_updates';
  13         if(!($newest_packages = get_cache_value($key))) {
  14                 $q = 'SELECT Packages.Name, Version, ModifiedTS ';
  15                 $q.= 'FROM Packages INNER JOIN PackageBases ON ';
  16                 $q.= 'Packages.PackageBaseID = PackageBases.ID ';
  17                 $q.= 'WHERE PackageBases.PackagerUID IS NOT NULL ';
  18                 $q.= 'ORDER BY ModifiedTS DESC LIMIT 15';
  19                 $result = $dbh->query($q);
  20
  21                 $newest_packages = new ArrayObject();
  22                 while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
  23                         $newest_packages->append($row);
  24                 }
  25                 set_cache_value($key, $newest_packages);
  26         }
  27         include('stats/updates_table.php');
  28 }
  29
  30 /**
  31  * Display a user's statistics table
  32  *
  33  * @param string $userid The user ID of the person to get package statistics for
  34  *
  35  * @return void
  36  */
  37 function user_table($userid) {
  38         $base_q = "SELECT COUNT(*) FROM PackageBases ";
  39         $base_q.= "WHERE MaintainerUID = " . $userid . " ";
  40         $base_q.= "AND PackagerUID IS NOT NULL";
  41
  42         $user_pkg_count = db_cache_value($base_q, 'user_pkg_count:' . $userid);
  43
  44         $q = "SELECT COUNT(*) FROM PackageBases ";
  45         $q.= "WHERE OutOfDateTS IS NOT NULL ";
  46         $q.= "AND MaintainerUID = " . $userid . " ";
  47         $q.= "AND PackagerUID IS NOT NULL";
  48
  49         $flagged_outdated = db_cache_value($q, 'user_flagged_outdated:' . $userid);
  50
  51         include('stats/user_table.php');
  52 }
  53
  54 /**
  55  * Display the general package statistics table
  56  *
  57  * @return void
  58  */
  59 function general_stats_table() {
  60         # AUR statistics
  61         $q = "SELECT COUNT(*) FROM PackageBases WHERE PackagerUID IS NOT NULL";
  62         $pkg_count = db_cache_value($q, 'pkg_count');
  63
  64         $q = "SELECT COUNT(*) FROM PackageBases ";
  65         $q.= "WHERE MaintainerUID IS NULL ";
  66         $q.= "AND PackagerUID IS NOT NULL";
  67         $orphan_count = db_cache_value($q, 'orphan_count');
  68
  69         $q = "SELECT count(*) FROM Users";
  70         $user_count = db_cache_value($q, 'user_count');
  71
  72         $q = "SELECT count(*) FROM Users,AccountTypes WHERE Users.AccountTypeID = AccountTypes.ID AND (AccountTypes.AccountType = 'Trusted User' OR AccountTypes.AccountType = 'Trusted User & Developer')";
  73         $tu_count = db_cache_value($q, 'tu_count');
  74
  75         $targstamp = intval(strtotime("-7 days"));
  76         $yearstamp = intval(strtotime("-1 year"));
  77
  78         $q = "SELECT COUNT(*) FROM PackageBases ";
  79         $q.= "WHERE SubmittedTS >= $targstamp ";
  80         $q.= "AND PackagerUID IS NOT NULL";
  81         $add_count = db_cache_value($q, 'add_count');
  82
  83         /*
  84          * A package whose last modification time differs less than an hour
  85          * from the initial submission time is considered new.
  86          */
  87
  88         $q = "SELECT COUNT(*) FROM PackageBases ";
  89         $q.= "WHERE ModifiedTS >= $targstamp ";
  90         $q.= "AND ModifiedTS - SubmittedTS >= 3600 ";
  91         $q.= "AND PackagerUID IS NOT NULL";
  92         $update_count = db_cache_value($q, 'update_count');
  93
  94         $q = "SELECT COUNT(*) FROM PackageBases ";
  95         $q.= "WHERE ModifiedTS >= $yearstamp ";
  96         $q.= "AND ModifiedTS - SubmittedTS >= 3600 ";
  97         $q.= "AND PackagerUID IS NOT NULL";
  98         $update_year_count = db_cache_value($q, 'update_year_count');
  99
 100         $q = "SELECT COUNT(*) FROM PackageBases ";
 101         $q.= "WHERE ModifiedTS - SubmittedTS < 3600 ";
 102         $q.= "AND PackagerUID IS NOT NULL";
 103         $never_update_count = db_cache_value($q, 'never_update_count');
 104
 105         include('stats/general_stats_table.php');
 106 }