| Server IP : 104.20.45.2 / Your IP : 172.16.20.3 Web Server : Apache/2.4.25 (Debian) System : Linux f64a392e70de 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : application ( 1000) PHP Version : 5.6.40 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /app/plugins/reports/reviews/ |
Upload File : |
<?php
/**
* @file plugins/reports/reviews/ReviewReportDAO.inc.php
*
* Copyright (c) 2013-2019 Simon Fraser University
* Copyright (c) 2003-2019 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
*/
import('classes.article.ArticleComment');
import('lib.pkp.classes.db.DBRowIterator');
class ReviewReportDAO extends DAO {
/**
* Get the review report data.
* @param $journalId int
* @return array
*/
function getReviewReport($journalId) {
$primaryLocale = AppLocale::getPrimaryLocale();
$locale = AppLocale::getLocale();
$result =& $this->retrieve(
'SELECT article_id,
comments,
author_id
FROM article_comments
WHERE comment_type = ?',
array(
COMMENT_TYPE_PEER_REVIEW
)
);
import('lib.pkp.classes.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.submission_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=a.locale AND aspl.setting_name=?),
users u
WHERE u.user_id=r.reviewer_id AND a.journal_id= ?
ORDER BY article',
array(
$locale, // Article title
'title',
'title',
$journalId
)
);
$reviewsReturner = new DBRowIterator($result);
return array($commentsReturner, $reviewsReturner);
}
}
?>