Add projects in good standing to the page.
Change-Id: I2ffb2ce0d283997ac9e2d7849d55f6a0f924c8ee
diff --git a/tools/goodstanding-releases.php b/tools/goodstanding-releases.php
index 97ef3a5..3e58aa4 100755
--- a/tools/goodstanding-releases.php
+++ b/tools/goodstanding-releases.php
@@ -35,13 +35,45 @@
<h1><?=$pageTitle?></h1>
<p>
<strong>EXPERIMENTAL</strong>. This page shows a list of Eclipse open
- source releases from the last year that are believed to be in good
- standing. To be in good standing, the corresponding Eclipse open
- source project must have engaged in either a release or progress
- review in the year preceding the release.
+ source projects and releases from the last year that are believed to be in good
+ standing.
+ </p>
+<h2 id="projects">Projects</h2>
<p>
+ The projects listed below are considered to be in good standing and
+ are in active development. A project that conforms to the Eclipse
+ Foundation Development Process but is in active development (e.g.,
+ the code is stable) would be considered to be in good standing, but
+ is none-the-less excluded here. To be included in this list, the
+ corresponding Eclipse open source project must have engaged in either
+ a release or progress review in the year preceding the release.</p>
+ <ul>
+<?php
+$sql = <<<EOQ
+select
+ distinct p.id,
+ p.name,
+ p.url,
+ max(rev.date) as lastReviewDate
+from Project as p
+ join ProjectReleases as rel on p.id=rel.project
+ join ProjectReviews as rev on p.id=rev.project
+where
+ rev.type in ('release','graduation', 'other')
+ and rev.status = 'success'
+group by p.id
+having lastReviewDate >= date_sub(now(), interval 1 year)
+order by p.name;
+EOQ;
+query('dashboard', $sql, array (), function ($row) {
+ echo "<li><a href=\"{$row['url']}\">{$row['name']}</a></li>";
+});
+?>
+</ul>
+
+<h2 id="releases">Releases</h2>
<p>
Grayed out releases are have future dates (these releases have been
projected into the future by the corresponding project team); only
@@ -52,7 +84,7 @@
Note that service releases that are based on releases in good standing,
but are themselves dated more than one year after a review are
absent from this list.
- <p>
+ </p>
<p>
If you believe that your project's release should be listed here,
@@ -76,6 +108,7 @@
join ProjectReviews as rev on p.id=rev.project
where
rev.type in ('release','graduation', 'other')
+ and rev.status = 'success'
and
rel.date between date_sub(now(), interval 1 year) and date_add(now(), interval 1 month)
group by p.id, rel.name
