Clean up: remove old stuff.
Change-Id: I4b8c1efffc110c5e021effecb712eab59ae6741e
diff --git a/xml/download_paths.php b/xml/download_paths.php
deleted file mode 100644
index dfe4135..0000000
--- a/xml/download_paths.php
+++ /dev/null
@@ -1,29 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2010 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Wayne Beaton - initial API and implementation
- *******************************************************************************/
-
-header("Content-type: text/xml");
-
-require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
-$App = new App();
-
-echo "<download-paths>\n";
-
-$result = $App->eclipse_sql("select project_id, file_path from project_disk_space_usage");
-while($row = mysql_fetch_assoc($result)) {
- $id = $row['project_id'];
- $path = $row['file_path'];
-
- echo "\t<path projectId=\"$id\" path=\"$path\"/>\n";
-}
-
-echo "</download-paths>\n";
-?>
\ No newline at end of file
diff --git a/xml/iplog.xsd b/xml/iplog.xsd
deleted file mode 100644
index a2ba09c..0000000
--- a/xml/iplog.xsd
+++ /dev/null
@@ -1,189 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<schema targetNamespace="http://www.eclipse.org/projects/xml/iplog"
- elementFormDefault="qualified" xmlns="http://www.w3.org/2001/XMLSchema"
- xmlns:iplog="http://www.eclipse.org/projects/xml/iplog">
-
- <element name="iplog" type="iplog:iplog"></element>
-
- <complexType name="iplog">
- <sequence>
- <element name="project" type="iplog:project" minOccurs="1"
- maxOccurs="1">
- <annotation>
- <documentation>This entity contains information about the "root"
- project.
-
- An IP Log can be created with information from multiple
- projects, but the log itself is created for a common
- ancestor of
- the included projects. e.g. the IP Log
- for the webtools "root"
- project includes IP
- information for webtools.common, webtools.dali,
- webtools.ejbtools, webtools.jeetools, webtools.jsdt,
- webtools.jsf,
- webtools.servertools,
- webtools.sourceediting, and
- webtools.webservices</documentation>
- </annotation>
- </element>
- <element name="includes" type="iplog:project" maxOccurs="unbounded"
- minOccurs="0">
- <annotation>
- <documentation>
- The projects that this IP Log holds values for
- are
- contained here.
-
- The IP Log, for example, for the webtools "root"
- project includes IP information for
- webtools.common, webtools.dali,
- webtools.ejbtools, webtools.jeetools,
- webtools.jsdt, webtools.jsf,
- webtools.servertools, webtools.sourceediting,
- and
- webtools.webservices.
- </documentation>
- </annotation>
- </element>
- <element name="consumes" type="iplog:project" maxOccurs="unbounded"
- minOccurs="0">
- <annotation>
- <documentation>
- What other Eclipse projects does this project
- consume? A "consumes" entry should be created
- for each project that
- this project uses in some
- form. Note that there is no notion of
- "optional"; from an IP Log point-of-view, a
- project is either
- consumed or not.
- </documentation>
- </annotation>
- </element>
- <element name="meta" type="iplog:meta" maxOccurs="unbounded"
- minOccurs="0">
- <annotation>
- <documentation>
- Use "meta" elements to provide any sort of
- random
- information that doesn't nicely fit
- elsewhere. Consider using
- "comment" elements for
- unstructured information.
- </documentation>
- </annotation>
- </element>
- <element name="license" type="iplog:license" maxOccurs="unbounded"
- minOccurs="0">
- </element>
- <element name="cq" type="iplog:cq" maxOccurs="unbounded"
- minOccurs="0">
- </element>
- <element name="committer" type="iplog:committer" maxOccurs="unbounded"
- minOccurs="0">
- </element>
- <element name="contributor" type="iplog:contributor"
- maxOccurs="unbounded" minOccurs="0">
- </element>
- <element name="comment" type="string" maxOccurs="unbounded"
- minOccurs="0">
- <annotation>
- <documentation>
- Any extra textual information that you wish to
- convey.
- </documentation>
- </annotation>
- </element>
- </sequence>
- <attribute name="name" type="string" use="optional"></attribute>
- </complexType>
-
- <complexType name="project">
- <attribute name="id" type="string" use="required">
- <annotation>
- <documentation>This field contains the id of the project as it is represented in the Eclipse Foundation Database (e.g. rt.equinox.scalamodules).</documentation>
- </annotation></attribute>
- <attribute name="name" type="string" use="optional"></attribute>
- <attribute name="version" type="string" use="optional"></attribute>
- <attribute name="comment" type="string" use="optional"></attribute>
- </complexType>
-
- <complexType name="cq">
- <attribute name="id" type="string" use="required"></attribute>
- <attribute name="description" type="string" use="required"></attribute>
- <attribute name="license" type="string"></attribute>
- <attribute name="use" type="string"></attribute>
- <attribute name="state">
- <simpleType>
- <restriction base="string">
- <enumeration value="active"></enumeration>
- <enumeration value="prereq"></enumeration>
- <enumeration value="closed"></enumeration>
- <enumeration value="pending"></enumeration>
- <enumeration value="unused"></enumeration>
- </restriction>
- </simpleType>
- </attribute>
- <attribute name="comment" type="string" use="optional"></attribute>
- </complexType>
-
- <complexType name="committer">
- <attribute name="id" type="string" use="required"></attribute>
- <attribute name="firstName" type="string" use="required"></attribute>
- <attribute name="lastName" type="string" use="required"></attribute>
- <attribute name="affiliation" type="string" use="required"></attribute>
- <attribute name="active" type="boolean" use="required"></attribute>
- <attribute name="hasCommits" type="boolean" use="required"></attribute>
- <attribute name="comment" type="string" use="optional"></attribute>
- </complexType>
-
- <complexType name="contributor">
- <sequence>
- <element name="contribution" type="iplog:contribution"
- maxOccurs="unbounded" minOccurs="1">
- </element>
- </sequence>
- <attribute name="id" type="string" use="required">
- <annotation>
- <documentation>
- The id field uniquely identifies the individual
- committer.
- </documentation>
- </annotation>
- </attribute>
- <attribute name="name" type="string" use="optional"></attribute>
- <attribute name="comment" type="string" use="optional"></attribute>
- </complexType>
-
- <complexType name="contribution">
- <attribute name="id" type="string" use="required"></attribute>
- <attribute name="description" type="string" use="optional"></attribute>
- <attribute name="size" type="string" use="required"></attribute>
- <attribute name="url" type="string" use="optional"></attribute>
- <attribute name="comment" type="string" use="optional">
- </attribute>
- </complexType>
-
- <complexType name="license">
- <attribute name="id" type="string" use="required">
- <annotation>
- <documentation>An identifier of the license. e.g. "EPL1.0", or "EDL1.0".</documentation>
- </annotation></attribute>
- <attribute name="description" type="string">
- <annotation>
- <documentation>A human-readable, textual description of the license. e.g. "Eclipse Public License v1.0", or "Eclipse Distribution License v1.0".</documentation>
- </annotation></attribute>
- <attribute name="comment" type="string" use="optional"></attribute>
- </complexType>
-
- <complexType name="meta">
- <annotation>
- <documentation>Use instances of this optional tag to provide extra information for your log.</documentation>
- </annotation>
- <attribute name="key" type="string" use="required"></attribute>
- <attribute name="value" type="string"></attribute>
- </complexType>
-
-
-</schema>
\ No newline at end of file
diff --git a/xml/iplog.xsl b/xml/iplog.xsl
deleted file mode 100644
index 3f935b0..0000000
--- a/xml/iplog.xsl
+++ /dev/null
@@ -1,311 +0,0 @@
-<?xml version="1.0"?>
-
-<xsl:stylesheet version="1.0"
- xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:iplog="http://www.eclipse.org/projects/xml/iplog">
-
- <xsl:template match="/">
- <html>
- <body>
- <style>
- table,td,th {border-width:1px;border-style:solid}
- th {border-color:#7A79A7; background-color:#7A79A7}
- table {cellpadding: 0; cellspacing: 0}
- </style>
- <h1>IP Log for the
- <xsl:for-each select="iplog:iplog/iplog:project">
- <a href="http://www.eclipse.org/projects/project.php?id={@id}">
- <xsl:choose>
- <xsl:when test="@name">
- <xsl:value-of select="@name" />
- </xsl:when>
- <xsl:otherwise>
- <xsl:value-of select="@id" />
- </xsl:otherwise>
- </xsl:choose>
- </a> Project<xsl:if test="@version">, version <xsl:value-of select="@version"/></xsl:if>
- </xsl:for-each>
- </h1>
- <p>This Log includes information about the following projects:</p>
- <ul>
- <xsl:for-each select="iplog:iplog/iplog:project">
- <li><a href="http://www.eclipse.org/projects/project.php?id={@id}"><xsl:value-of select="@name" /></a></li>
- </xsl:for-each>
- <xsl:for-each select="iplog:iplog/iplog:includes">
- <li><a href="http://www.eclipse.org/projects/project.php?id={@id}"><xsl:value-of select="@name" /></a></li>
- </xsl:for-each>
- </ul>
-
- <xsl:if test="count(iplog:iplog/iplog:consumes)>0">
- <p>This project consumes the following Eclipse projects:</p>
- <ul>
- <xsl:for-each select="iplog:iplog/iplog:consumes">
- <li>
- <a
- href="http://www.eclipse.org/projects/project.php?id={@id}">
- <xsl:value-of select="@name" />
- </a>
- </li>
- </xsl:for-each>
- </ul>
- </xsl:if>
-
- <h2>Licenses</h2>
- <ul>
- <xsl:for-each select="iplog:iplog/iplog:license">
- <li>
- <xsl:choose>
- <xsl:when test="@description">
- <xsl:value-of select="@description" />
- </xsl:when>
- <xsl:otherwise>
- <xsl:value-of select="@id" />
- </xsl:otherwise>
- </xsl:choose>
-
- </li>
- </xsl:for-each>
- </ul>
-
- <!-- Third-party Code (Contribution Questionnaires) -->
-
- <h2>Third-Party Code</h2>
- <table>
- <tr>
- <th>CQ</th>
- <th>Third-Party Code</th>
- <th>License</th>
- <th>Use</th>
- </tr>
- <xsl:for-each select="iplog:iplog/iplog:cq[@state='active']">
- <xsl:sort select="@id" data-type="number" />
- <tr>
- <td>
- <a href="https://dev.eclipse.org/ipzilla/show_bug.cgi?id={@id}">
- <xsl:value-of select="@id" />
- </a>
- </td>
- <td>
- <xsl:value-of select="@description" />
- </td>
- <td>
- <xsl:value-of select="@license" />
- </td>
- <td>
- <xsl:value-of select="@use" />
- </td>
- </tr>
- </xsl:for-each>
- </table>
-
- <xsl:if test="count(iplog:iplog/iplog:cq[@state='prereq'])>0">
- <h2>Pre-Req Dependencies</h2>
- <table>
- <tr>
- <th>CQ</th>
- <th>Third-Party Code</th>
- <th>License</th>
- <th>Dependencies</th>
- </tr>
- <xsl:for-each select="iplog:iplog/iplog:cq[@state='prereq']">
- <xsl:sort select="@id" data-type="number" />
- <tr>
- <td>
- <a href="https://dev.eclipse.org/ipzilla/show_bug.cgi?id={@id}">
- <xsl:value-of select="@id" />
- </a>
- </td>
- <td>
- <xsl:value-of select="@description" />
- </td>
- <td>
- <xsl:value-of select="@license" />
- </td>
- <td>
- <xsl:choose>
- <xsl:when test="@use='exempt_prereq'">
- Exempt pre-req
- </xsl:when>
- <xsl:when test="@use='workswith'">
- Works with
- </xsl:when>
- <xsl:otherwise>
- Pre-req
- </xsl:otherwise>
- </xsl:choose>
- </td>
- </tr>
- </xsl:for-each>
- </table>
- </xsl:if>
-
- <xsl:if test="count(iplog:iplog/iplog:cq[@state='unused'])>0">
- <h2>Unused Approved Contributions</h2>
- <table>
- <tr>
- <th>CQ</th>
- <th>Third-Party Code</th>
- <th>License</th>
- <th>Use</th>
- </tr>
- <xsl:for-each select="iplog:iplog/iplog:cq[@state='unused']">
- <xsl:sort select="@id" data-type="number" />
- <tr>
- <td>
- <a href="https://dev.eclipse.org/ipzilla/show_bug.cgi?id={@id}">
- <xsl:value-of select="@id" />
- </a>
- </td>
- <td>
- <xsl:value-of select="@description" />
- </td>
- <td>
- <xsl:value-of select="@license" />
- </td>
- <td>
- <xsl:value-of select="@use" />
- </td>
- </tr>
- </xsl:for-each>
- </table>
- </xsl:if>
-
- <xsl:if test="count(iplog:iplog/iplog:cq[@state='pending'])>0">
- <h2>Pending Contribution Questionnaires</h2>
- <table>
- <tr>
- <th>CQ</th>
- <th>Third-Party Code</th>
- <th>License</th>
- <th>Use</th>
- </tr>
- <xsl:for-each select="iplog:iplog/iplog:cq[@state='pending']">
- <xsl:sort select="@id" data-type="number" />
- <tr>
- <td>
- <a href="https://dev.eclipse.org/ipzilla/show_bug.cgi?id={@id}">
- <xsl:value-of select="@id" />
- </a>
- </td>
- <td>
- <xsl:value-of select="@description" />
- </td>
- <td>
- <xsl:value-of select="@license" />
- </td>
- <td>
- <xsl:value-of select="@use" />
- </td>
- </tr>
- </xsl:for-each>
- </table>
- </xsl:if>
-
- <!-- Committers -->
-
- <h2>Committers Past and Present</h2>
- <xsl:if test="count(iplog:iplog/iplog:committer[@hasCommits='true'])>0">
- <!-- What if this is false? Should probably print something like "No active committers" -->
- <h3>Active Committers</h3>
- <table>
- <tr>
- <th>Name</th>
- <th>Committer ID</th>
- <th>Organization</th>
- <th>Active?</th>
- </tr>
- <xsl:for-each select="iplog:iplog/iplog:committer[@hasCommits='true']">
- <xsl:sort select="@lastName" data-type="text" />
- <tr>
- <td>
- <xsl:value-of select="@firstName" />
- <xsl:text> </xsl:text>
- <xsl:value-of select="@lastName" />
- </td>
- <td>
- <xsl:value-of select="@id" />
- </td>
- <td>
- <xsl:value-of select="@affiliation" />
- </td>
- <td>
- <xsl:choose>
- <xsl:when test="@active='true'">
- Yes
- </xsl:when>
- <xsl:otherwise>
- No
- </xsl:otherwise>
- </xsl:choose>
- </td>
- </tr>
- </xsl:for-each>
- </table>
- </xsl:if>
-
- <xsl:if test="count(iplog:iplog/iplog:committer[@hasCommits!='true'])>0">
- <h3>Never Active</h3>
- <table>
- <tr>
- <th>Name</th>
- <th>Committer ID</th>
- <th>Organization</th>
- </tr>
- <xsl:for-each select="iplog:iplog/iplog:committer[@hasCommits!='true']">
- <xsl:sort select="@lastName" data-type="text" />
- <tr>
- <td>
- <xsl:value-of select="@firstName" />
- <xsl:text> </xsl:text>
- <xsl:value-of select="@lastName" />
- </td>
- <td>
- <xsl:value-of select="@id" />
- </td>
- <td>
- <xsl:value-of select="@affiliation" />
- </td>
- </tr>
- </xsl:for-each>
- </table>
- </xsl:if>
-
- <!-- Contributors -->
-
- <h2>Contributors and Their Contributions</h2>
-
- <table>
- <tr>
- <th>Contribution</th>
- <th>Size</th>
- <th>Description</th>
- </tr>
- <xsl:for-each select="iplog:iplog/iplog:contributor">
- <xsl:sort select="@name" data-type="text" />
- <tr>
- <td colspan="3">
- <xsl:value-of select="@name" />
- </td>
- </tr>
- <xsl:for-each select="iplog:contribution">
- <tr>
- <td>
- <a href="{@url}">
- <xsl:value-of select="@id" />
- </a>
- </td>
- <td>
- <xsl:value-of select="@size" />
- </td>
- <td>
- <xsl:value-of select="@description" />
- </td>
- </tr>
- </xsl:for-each>
- </xsl:for-each>
- </table>
-
- </body>
- </html>
- </xsl:template>
-
-</xsl:stylesheet>
\ No newline at end of file
diff --git a/xml/ipzilla_projects.php b/xml/ipzilla_projects.php
deleted file mode 100644
index 200d804..0000000
--- a/xml/ipzilla_projects.php
+++ /dev/null
@@ -1,48 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2011 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Wayne Beaton (Eclipse Foundation)- initial API and implementation
- *******************************************************************************/
-
-/*
- * This file generates XML content describing the projects we
- * have in IPZilla. This is potentially different from what we
- * have in the foundation database.
- */
-require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
-$App = new App();
-
-require_once($_SERVER['DOCUMENT_ROOT'] . "/projects/classes/Project.class.php");
-
-header("Content-type: text/xml");
-
-$sql = "SELECT distinct name from components";
-
-$result = $App->ipzilla_sql( $sql );
-
-$projects = array();
-
-while( $row = mysql_fetch_assoc($result) ) {
- $id = $row['name'];
- $project = get_project($id);
- if (!$project) continue;
- $projects[] = $id;
-}
-
-sort($projects);
-
-echo "<ipzilla-projects>\n";
-
-foreach($projects as $project) {
- echo "\t<project id=\"$project\"/>\n";
-}
-
-echo "</ipzilla-projects>\n";
-
-?>
\ No newline at end of file
diff --git a/xml/projects.php b/xml/projects.php
deleted file mode 100644
index db672a6..0000000
--- a/xml/projects.php
+++ /dev/null
@@ -1,45 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2009, 2016 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *******************************************************************************/
-
-/*
- * This file generates XML content describing the hierarchy of projects.
- * All projects are reported regardless of their state (i.e. archived projects
- * are included).
- */
-
-require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
-require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/nav.class.php");
-require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/menu.class.php");
-$App = new App();
-$Nav = new Nav();
-$Menu = new Menu();
-include($App->getProjectCommon());
-
-require_once($_SERVER['DOCUMENT_ROOT'] . "/projects/classes/Project.class.php");
-//error_reporting(E_NONE);
-
-header("Content-type: text/xml");
-
-echo "<projects>";
-
-function list_projects(&$list) {
- foreach($list as $project) {
- $id = $project->getId();
- $name = htmlspecialchars($project->getName());
- echo "<project name=\"$name\" id=\"$id\">";
- list_projects($project->getChildren());
- echo "</project>";
- }
-}
-
-list_projects(Project::getTopLevelProjects());
-
-echo "</projects>";
-
-?>
\ No newline at end of file
diff --git a/xml/releasetrain.php b/xml/releasetrain.php
deleted file mode 100644
index 61491cb..0000000
--- a/xml/releasetrain.php
+++ /dev/null
@@ -1,31 +0,0 @@
-<?php
-require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
-//require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/nav.class.php");
-//require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/menu.class.php");
-
-// ----------------------------------------------------------------------------
-// PHOENIX STUFF
-
-header("Content-type: text/xml");
-
-$release = 'Helios';
-
-echo "<release-train name=\"$release\">\n";
-
-$App = new App();
-include($App->getProjectCommon());
-
-$result = $App->eclipse_sql("
- SELECT distinct ProjectID FROM ProjectInfo, ProjectInfoValues
- WHERE ProjectInfo.ProjectInfoID = ProjectInfoValues.ProjectInfoID
- AND MainKey = 'simultaneousrelease'
- AND SubKey = LOWER('$release')
- AND Value = 1
- ORDER BY ProjectID
-");
-
-while($row = mysql_fetch_object($result)) {
- echo "\t<project id=\"$row->ProjectID\"/>\n";
-}
-echo "</release-train>";
-?>
\ No newline at end of file
diff --git a/xml/releasetrain_txt.php b/xml/releasetrain_txt.php
deleted file mode 100644
index a4abbf6..0000000
--- a/xml/releasetrain_txt.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
-
-header("Content-type: text/plain");
-
-$release = 'Indigo';
-
-$App = new App();
-include($App->getProjectCommon());
-
-$result = $App->eclipse_sql("
- SELECT distinct ProjectID FROM ProjectInfo, ProjectInfoValues
- WHERE ProjectInfo.ProjectInfoID = ProjectInfoValues.ProjectInfoID
- AND MainKey = 'simultaneousrelease'
- AND SubKey = LOWER('$release')
- AND Value = 1
- ORDER BY ProjectID
-");
-
-while($row = mysql_fetch_object($result)) {
- echo "$row->ProjectID\n";
-}
-?>
\ No newline at end of file
diff --git a/xml/review_status.php b/xml/review_status.php
deleted file mode 100644
index 40fc7a1..0000000
--- a/xml/review_status.php
+++ /dev/null
@@ -1,125 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2010 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * Wayne Beaton (Eclipse Foundation)- initial API and implementation
- *******************************************************************************/
-
-/*
- * This script returns--in XML format--information about reviews.
- *
- * The following parameters can be used:
- *
- * date
- * Include only information about reviews occurring on this date. This
- * parameter is optional; if it is specified, it overrides the value of
- * the 'start' parameter.
- *
- * start
- * The start date; information for all reviews from this date forward are
- * included in the results. The 'date' parameter overrides this value. If
- * neither the 'date' nor the 'start' field are specified, the script
- * will report on those reviews that occur from the future date forward.
- *
- * name
- * Name of the review. The text provided is used to attempt a partial match
- * on the name of the review. More specifically, the name is used in an SQL
- * "like" statement.
- *
- * test
- * Include this parameter if you want to include some test data in the output;
- * handy if you're testing locally and just want to have some data to play with.
- *
- * Example:
- * http://www.eclipse.org/projects/xml/review_status.php?name=Helios
- *
- * returns something along the lines of:
- *
- * <review-status start-date="2010-05-26" review-name="Helios">
- * <review name="Helios Release" projectid="soa.jwt" iplog="" posted="" slides=""/>
- * <review name="Helios Graduation/Release" projectid="dsdp.sequoyah" iplog="" posted="" slides=""/>
- * </review-status>
- *
- * Note that only review entries that have a date explicitly set will be included in
- * the response. This information is all set in the Foundation Portal.
- */
-
-header("Content-type: text/xml");
-header("Content-Disposition: inline; filename=reviews.xml");
-
-echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
-
-require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
-if (!isset($App)) $App = new App();
-
-$reviewDate = $App->getHttpParameter('date');
-if ($reviewDate) {
- $reviewDate = strtotime($reviewDate);
- $reviewDate = date('Y-m-d', $reviewDate);
-}
-
-$startDate = $App->getHttpParameter('start');
-if (!$startDate) $startDate = strtotime('now');
-$startDate = date('Y-m-d', $startDate);
-
-$reviewName = $App->getHttpParameter('name');
-$reviewName = $App->sqlSanitize($reviewName);
-
-$testing = $App->getHttpParameter('test');
-
-$sql = "SELECT distinct
- r.ProjectName, r.ProjectId,
- r.ReviewName, r.SlidesURL, r.IPLogURL,
- iplog.value as IPLogDate,
- docuware.value as DocuwareDate
- FROM
- ProjectReviews as r
- left join ProjectReviewStatus as iplog on (r.id = iplog.id and iplog.Status = 'Legal Review Requested')
- left join ProjectReviewStatus as docuware on (r.id = docuware.id and docuware.Status = 'Slides Posted')
- WHERE 1=1";
-
-$summary = '';
-
-//if ($reviewDate) {
-// $sql .= " and ReviewDate = '$reviewDate'";
-// $summary .= " review-date=\"$reviewDate\"";
-//} else {
-// $sql .= " and ReviewDate > '$startDate'";
-// $summary .= " start-date=\"$startDate\"";
-//}
-
-if ($reviewName) {
- $sql .= " and reviewName like '%$reviewName%'";
- $summary .= " review-name=\"$reviewName\"";
-} else {
- $sql .= " and reviewName is not null";
-}
-
-echo "<!-- \n$sql\n-->";
-
-$result = $App->foundation_sql($sql);
-
-echo "<review-status $summary>";
-
-if ($test)
- echo "<review name=\"Bogus\" projectid=\"technology.bogus\" iplog=\"http://www.place.com\" posted=\"2010-10-10\" slides=\"http://slides.url.com\"/>";
-
-while ($row = mysql_fetch_assoc($result)) {
- $id = $row['ProjectId'];
- $iplog_url = $row['IPLogURL'];
- $iplog_date = $row['IPLogDate'];
- $docuware_url = $row['SlidesURL'];
- $docuware_date = $row['DocuwareDate'];
- $review_name = $row['ReviewName'];
-
- echo "<review name=\"$review_name\" projectid=\"$id\" iplog=\"$iplog_url\" iplog-date=\"$iplog_date\" docuware=\"$docuware_url\" docuware-date=\"$docuware_date\"/>";
-}
-
-echo "</review-status>";
-
-?>
\ No newline at end of file