diff -N plugins/reports/reviews/ReviewReportDAO.inc.php
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ plugins/reports/reviews/ReviewReportDAO.inc.php	15 May 2009 20:56:44 -0000
@@ -0,0 +1,83 @@
+<?php
+
+/**
+ * @file ReviewReportDAO.inc.php
+ *
+ * Copyright (c) 2003-2009 John Willinsky
+ * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
+ * 
+ * @class ReviewReportDAO
+ * @ingroup plugins_reports_review
+ * @see ReviewReportPlugin
+ *
+ * @brief Review report DAO
+ */
+
+//$Id: ReviewReportDAO.inc.php,v 1.6 2009/04/08 20:01:36 asmecher Exp $
+
+
+import('classes.article.ArticleComment');
+import('db.DBRowIterator');
+
+class ReviewReportDAO extends DAO {
+	/**
+	 * Get the review report data.
+	 * @param $journalId int
+	 * @return array
+	 */
+	function getReviewReport($journalId) {
+		$primaryLocale = Locale::getPrimaryLocale();
+		$locale = Locale::getLocale();
+
+		$result =& $this->retrieve(
+			'SELECT	article_id,
+				comments,
+				author_id
+			FROM	article_comments
+			WHERE	comment_type = ?',
+			array(
+				COMMENT_TYPE_PEER_REVIEW
+			)
+		);
+		import('db.DBRowIterator');
+		$commentsReturner = new DBRowIterator($result);
+
+		$result =& $this->retrieve(
+			'SELECT r.round AS round,
+				COALESCE(asl.setting_value, aspl.setting_value) AS article,
+				a.article_id AS articleId,
+				u.user_id AS reviewerId,
+				u.username AS reviewer,
+				u.first_name AS firstName,
+				u.middle_name AS middleName,
+				u.last_name AS lastName,
+				r.date_assigned AS dateAssigned,
+				r.date_notified AS dateNotified,
+				r.date_confirmed AS dateConfirmed,
+				r.date_completed AS dateCompleted,
+				r.date_reminded AS dateReminded,
+				(r.declined=1) AS declined,
+				(r.cancelled=1) AS cancelled,
+				r.recommendation AS recommendation
+			FROM	review_assignments r
+				LEFT JOIN articles a ON r.article_id = a.article_id
+				LEFT JOIN article_settings asl ON (a.article_id=asl.article_id AND asl.locale=? AND asl.setting_name=?)
+				LEFT JOIN article_settings aspl ON (a.article_id=aspl.article_id AND aspl.locale=? AND aspl.setting_name=?),
+				users u
+			WHERE	u.user_id=r.reviewer_id AND a.journal_id= ?
+			ORDER BY article',
+			array(
+				$locale,
+				'title',
+				$primaryLocale,
+				'title',
+				$journalId
+			)
+		);
+		$reviewsReturner = new DBRowIterator($result);
+
+		return array($commentsReturner, $reviewsReturner);
+	}
+}
+
+?>
Index: plugins/reports/reviews/ReviewReportPlugin.inc.php
===================================================================
RCS file: plugins/reports/reviews/ReviewReportPlugin.inc.php
diff -N plugins/reports/reviews/ReviewReportPlugin.inc.php
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ plugins/reports/reviews/ReviewReportPlugin.inc.php	15 May 2009 20:56:44 -0000
@@ -0,0 +1,125 @@
+<?php
+
+/**
+ * @file ReviewReportPlugin.inc.php
+ *
+ * Copyright (c) 2003-2009 John Willinsky
+ * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
+ * 
+ * @class ReviewReportPlugin
+ * @ingroup plugins_reports_review
+ * @see ReviewReportDAO
+ *
+ * @brief Review report plugin
+ */
+
+//$Id: ReviewReportPlugin.inc.php,v 1.6 2009/04/08 20:01:36 asmecher Exp $
+
+import('classes.plugins.ReportPlugin');
+
+class ReviewReportPlugin extends ReportPlugin {
+	/**
+	 * Called as a plugin is registered to the registry
+	 * @param $category String Name of category plugin was registered to
+	 * @return boolean True if plugin initialized successfully; if false,
+	 * 	the plugin will not be registered.
+	 */
+	function register($category, $path) {
+		$success = parent::register($category, $path);
+		if ($success) {
+			$this->import('ReviewReportDAO');
+			$reviewReportDAO = new ReviewReportDAO();
+			DAORegistry::registerDAO('ReviewReportDAO', $reviewReportDAO);
+		}
+		$this->addLocaleData();
+		return $success;
+	}
+
+	/**
+	 * Get the name of this plugin. The name must be unique within
+	 * its category.
+	 * @return String name of plugin
+	 */
+	function getName() {
+		return 'ReviewReportPlugin';
+	}
+
+	function getDisplayName() {
+		return Locale::translate('plugins.reports.reviews.displayName');
+	}
+
+	function getDescription() {
+		return Locale::translate('plugins.reports.reviews.description');
+	}
+
+	function display(&$args) {
+		$journal =& Request::getJournal();
+
+		header('content-type: text/comma-separated-values');
+		header('content-disposition: attachment; filename=report.csv');
+
+		$reviewReportDao =& DAORegistry::getDAO('ReviewReportDAO');
+		list($commentsIterator, $reviewsIterator) = $reviewReportDao->getReviewReport($journal->getJournalId());
+
+		$comments = array();
+		while ($row =& $commentsIterator->next()) {
+			if (isset($comments[$row['article_id']][$row['author_id']])) {
+				$comments[$row['article_id']][$row['author_id']] .= "; " . $row['comments'];
+			} else {
+				$comments[$row['article_id']][$row['author_id']] = $row['comments'];
+			}
+		}
+
+		$yesnoMessages = array( 0 => Locale::translate('common.no'), 1 => Locale::translate('common.yes'));
+
+		import('submission.reviewAssignment.ReviewAssignment');
+		$recommendations = ReviewAssignment::getReviewerRecommendationOptions();
+
+		$columns = array(
+			'round' => Locale::translate('plugins.reports.reviews.round'),
+			'article' => Locale::translate('article.articles'),
+			'articleid' => Locale::translate('article.submissionId'),
+			'reviewerid' => Locale::translate('plugins.reports.reviews.reviewerId'),
+			'reviewer' => Locale::translate('plugins.reports.reviews.reviewer'),
+			'firstname' => Locale::translate('user.firstName'),
+			'middlename' => Locale::translate('user.middleName'),
+			'lastname' => Locale::translate('user.lastName'),
+			'dateassigned' => Locale::translate('plugins.reports.reviews.dateAssigned'),
+			'datenotified' => Locale::translate('plugins.reports.reviews.dateNotified'),
+			'dateconfirmed' => Locale::translate('plugins.reports.reviews.dateConfirmed'),
+			'datecompleted' => Locale::translate('plugins.reports.reviews.dateCompleted'),
+			'datereminded' => Locale::translate('plugins.reports.reviews.dateReminded'),
+			'declined' => Locale::translate('submissions.declined'),
+			'cancelled' => Locale::translate('common.cancelled'),
+			'recommendation' => Locale::translate('reviewer.article.recommendation'),
+			'comments' => Locale::translate('comments.commentsOnArticle')
+		);
+		$yesNoArray = array('declined', 'cancelled');
+
+		$fp = fopen('php://output', 'wt');
+		String::fputcsv($fp, array_values($columns));
+
+		while ($row =& $reviewsIterator->next()) {
+			foreach ($columns as $index => $junk) {
+				if (in_array($index, $yesNoArray)) {
+					$columns[$index] = $yesnoMessages[$row[$index]];
+				} elseif ($index == "recommendation") {
+					$columns[$index] = (!isset($row[$index])) ? Locale::translate('common.none') : Locale::translate($recommendations[$row[$index]]);
+				} elseif ($index == "comments") {
+					if (isset($comments[$row['articleid']][$row['reviewerid']])) {
+						$columns[$index] = $comments[$row['articleid']][$row['reviewerid']];
+					} else {
+						$columns[$index] = "";
+					}
+				} else {
+					$columns[$index] = $row[$index];
+				}
+			}
+			String::fputcsv($fp, $columns);
+			unset($row);
+		}
+		fclose($fp);
+	}
+}
+
+?>
Index: plugins/reports/reviews/index.php
===================================================================
RCS file: plugins/reports/reviews/index.php
diff -N plugins/reports/reviews/index.php
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ plugins/reports/reviews/index.php	15 May 2009 20:56:44 -0000
@@ -0,0 +1,24 @@
+<?php
+
+/**
+ * @defgroup plugins_reports_reviews
+ */
+ 
+/**
+ * @file index.php
+ *
+ * Copyright (c) 2003-2009 John Willinsky
+ * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
+ *
+ * @brief Wrapper for review report plugin.
+ *
+ * @ingroup plugins_reports_reviews
+ */
+
+//$Id: index.php,v 1.4 2009/04/08 20:01:36 asmecher Exp $
+
+require_once('ReviewReportPlugin.inc.php');
+
+return new ReviewReportPlugin();
+
+?>
Index: plugins/reports/reviews/locale/en_US/locale.xml
===================================================================
RCS file: plugins/reports/reviews/locale/en_US/locale.xml
diff -N plugins/reports/reviews/locale/en_US/locale.xml
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ plugins/reports/reviews/locale/en_US/locale.xml	15 May 2009 20:56:44 -0000
@@ -0,0 +1,27 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE locale SYSTEM "../../../../../lib/pkp/dtd/locale.dtd">
+
+<!--
+  * locale.xml
+  *
+  * Copyright (c) 2003-2009 John Willinsky
+  * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
+  *
+  * Localization strings for the en_US (U.S. English) locale.
+  *
+  * $Id: locale.xml,v 1.4 2009/04/08 20:01:36 asmecher Exp $
+  -->
+
+<locale name="en_US" full_name="U.S. English">
+	<message key="plugins.reports.reviews.displayName">Review Report</message>
+	<message key="plugins.reports.reviews.description">This plugin implements a CSV report containing a list of review assignments for a journal.</message>
+	<message key="plugins.reports.reviews.round">Round</message>
+	<message key="plugins.reports.reviews.reviewerId">Reviewer ID</message>
+	<message key="plugins.reports.reviews.reviewer">Reviewer</message>
+	<message key="plugins.reports.reviews.dateAssigned">Date Assigned</message>
+	<message key="plugins.reports.reviews.dateNotified">Date Notified</message>
+	<message key="plugins.reports.reviews.dateConfirmed">Date Confirmed</message>
+	<message key="plugins.reports.reviews.dateCompleted">Date Completed</message>
+	<message key="plugins.reports.reviews.dateReminded">Date Reminded</message>
+</locale>
+