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                 if ($result) {
  23                         while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
  24                                 $newest_packages->append($row);
  25                         }
  26                         set_cache_value($key, $newest_packages);
  27                 }
  28         }
  29         include('stats/updates_table.php');
  30 }
  31
  32 /**
  33  * Display a user's statistics table
  34  *
  35  * @param string $userid The user ID of the person to get package statistics for
  36  *
  37  * @return void
  38  */
  39 function user_table($userid) {
  40         $base_q = "SELECT COUNT(*) FROM PackageBases ";
  41         $base_q.= "WHERE MaintainerUID = " . $userid . " ";
  42         $base_q.= "AND PackagerUID IS NOT NULL";
  43
  44         $user_pkg_count = db_cache_value($base_q, 'user_pkg_count:' . $userid);
  45
  46         $q = "SELECT COUNT(*) FROM PackageBases ";
  47         $q.= "WHERE OutOfDateTS IS NOT NULL ";
  48         $q.= "AND MaintainerUID = " . $userid . " ";
  49         $q.= "AND PackagerUID IS NOT NULL";
  50
  51         $flagged_outdated = db_cache_value($q, 'user_flagged_outdated:' . $userid);
  52
  53         include('stats/user_table.php');
  54 }
  55
  56 /**
  57  * Display the general package statistics table
  58  *
  59  * @return void
  60  */
  61 function general_stats_table() {
  62         # AUR statistics
  63         $q = "SELECT COUNT(*) FROM PackageBases WHERE PackagerUID IS NOT NULL";
  64         $pkg_count = db_cache_value($q, 'pkg_count');
  65
  66         $q = "SELECT COUNT(*) FROM PackageBases ";
  67         $q.= "WHERE MaintainerUID IS NULL ";
  68         $q.= "AND PackagerUID IS NOT NULL";
  69         $orphan_count = db_cache_value($q, 'orphan_count');
  70
  71         $q = "SELECT count(*) FROM Users";
  72         $user_count = db_cache_value($q, 'user_count');
  73
  74         $q = "SELECT count(*) FROM Users,AccountTypes WHERE Users.AccountTypeID = AccountTypes.ID AND (AccountTypes.AccountType = 'Trusted User' OR AccountTypes.AccountType = 'Trusted User & Developer')";
  75         $tu_count = db_cache_value($q, 'tu_count');
  76
  77         $targstamp = intval(strtotime("-7 days"));
  78         $yearstamp = intval(strtotime("-1 year"));
  79
  80         $q = "SELECT COUNT(*) FROM PackageBases ";
  81         $q.= "WHERE SubmittedTS >= $targstamp ";
  82         $q.= "AND PackagerUID IS NOT NULL";
  83         $add_count = db_cache_value($q, 'add_count');
  84
  85         /*
  86          * A package whose last modification time differs less than an hour
  87          * from the initial submission time is considered new.
  88          */
  89
  90         $q = "SELECT COUNT(*) FROM PackageBases ";
  91         $q.= "WHERE ModifiedTS >= $targstamp ";
  92         $q.= "AND ModifiedTS - SubmittedTS >= 3600 ";
  93         $q.= "AND PackagerUID IS NOT NULL";
  94         $update_count = db_cache_value($q, 'update_count');
  95
  96         $q = "SELECT COUNT(*) FROM PackageBases ";
  97         $q.= "WHERE ModifiedTS >= $yearstamp ";
  98         $q.= "AND ModifiedTS - SubmittedTS >= 3600 ";
  99         $q.= "AND PackagerUID IS NOT NULL";
 100         $update_year_count = db_cache_value($q, 'update_year_count');
 101
 102         $q = "SELECT COUNT(*) FROM PackageBases ";
 103         $q.= "WHERE ModifiedTS - SubmittedTS < 3600 ";
 104         $q.= "AND PackagerUID IS NOT NULL";
 105         $never_update_count = db_cache_value($q, 'never_update_count');
 106
 107         include('stats/general_stats_table.php');
 108 }