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, SubmittedTS ';
  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         $maintainer_unsupported_count = db_cache_value($base_q,
  43                 'user_unsupported_count:' . $userid);
  44
  45         $q = "SELECT COUNT(*) FROM PackageBases ";
  46         $q.= "WHERE OutOfDateTS IS NOT NULL ";
  47         $q.= "AND MaintainerUID = " . $userid . " ";
  48         $q.= "AND PackagerUID IS NOT NULL";
  49
  50         $flagged_outdated = db_cache_value($q, 'user_flagged_outdated:' . $userid);
  51
  52         include('stats/user_table.php');
  53 }
  54
  55 /**
  56  * Display the general package statistics table
  57  *
  58  * @return void
  59  */
  60 function general_stats_table() {
  61         # AUR statistics
  62         $q = "SELECT COUNT(*) FROM PackageBases WHERE PackagerUID IS NOT NULL";
  63         $unsupported_count = db_cache_value($q, 'unsupported_count');
  64
  65         $q = "SELECT COUNT(*) FROM PackageBases ";
  66         $q.= "WHERE MaintainerUID IS NULL ";
  67         $q.= "AND PackagerUID IS NOT NULL";
  68         $orphan_count = db_cache_value($q, 'orphan_count');
  69
  70         $q = "SELECT count(*) FROM Users";
  71         $user_count = db_cache_value($q, 'user_count');
  72
  73         $q = "SELECT count(*) FROM Users,AccountTypes WHERE Users.AccountTypeID = AccountTypes.ID AND (AccountTypes.AccountType = 'Trusted User' OR AccountTypes.AccountType = 'Trusted User & Developer')";
  74         $tu_count = db_cache_value($q, 'tu_count');
  75
  76         $targstamp = intval(strtotime("-7 days"));
  77         $yearstamp = intval(strtotime("-1 year"));
  78
  79         $q = "SELECT COUNT(*) FROM PackageBases ";
  80         $q.= "WHERE SubmittedTS >= $targstamp ";
  81         $q.= "AND PackagerUID IS NOT NULL";
  82         $add_count = db_cache_value($q, 'add_count');
  83
  84         /*
  85          * A package whose last modification time differs less than an hour
  86          * from the initial submission time is considered new.
  87          */
  88
  89         $q = "SELECT COUNT(*) FROM PackageBases ";
  90         $q.= "WHERE ModifiedTS >= $targstamp ";
  91         $q.= "AND ModifiedTS - SubmittedTS >= 3600 ";
  92         $q.= "AND PackagerUID IS NOT NULL";
  93         $update_count = db_cache_value($q, 'update_count');
  94
  95         $q = "SELECT COUNT(*) FROM PackageBases ";
  96         $q.= "WHERE ModifiedTS >= $yearstamp ";
  97         $q.= "AND ModifiedTS - SubmittedTS >= 3600 ";
  98         $q.= "AND PackagerUID IS NOT NULL";
  99         $update_year_count = db_cache_value($q, 'update_year_count');
 100
 101         $q = "SELECT COUNT(*) FROM PackageBases ";
 102         $q.= "WHERE ModifiedTS - SubmittedTS < 3600 ";
 103         $q.= "AND PackagerUID IS NOT NULL";
 104         $never_update_count = db_cache_value($q, 'never_update_count');
 105
 106         include('stats/general_stats_table.php');
 107 }