100 lines
4.3 KiB
PHP
100 lines
4.3 KiB
PHP
<?php
|
|
|
|
// +----------------------------------------------------------------------+
|
|
// | OpenConf |
|
|
// +----------------------------------------------------------------------+
|
|
// | Copyright (c) 2002-2020 Zakon Group LLC. All Rights Reserved. |
|
|
// +----------------------------------------------------------------------+
|
|
// | This source file is subject to the OpenConf License, available on |
|
|
// | the OpenConf web site: www.OpenConf.com |
|
|
// +----------------------------------------------------------------------+
|
|
|
|
require_once OCC_FORM_INC_FILE;
|
|
require_once OCC_REVIEW_INC_FILE;
|
|
|
|
$authorcomments = array();
|
|
$reviewfields = array();
|
|
$advocatecomment = array();
|
|
$advocatename = array();
|
|
$advocateemail = array();
|
|
$chairnotes = array();
|
|
|
|
// get acceptance type
|
|
if (preg_match("/^authors\_(\d+)$/", $_POST['recipient'], $matches) && isset($OC_acceptanceValuesAR[$matches[1]])) {
|
|
$accval = $OC_acceptanceValuesAR[$matches[1]]['value'];
|
|
$accSQL = "`" . OCC_TABLE_PAPER . "`.`accepted`='" . safeSQLstr($accval) . "'";
|
|
} else {
|
|
$accSQL = '';
|
|
}
|
|
|
|
// get review fields to display
|
|
$displayFieldAR = array();
|
|
foreach ($OC_reviewQuestionsAR as $fid => $far) {
|
|
if (isset($far['showauthor']) && $far['showauthor']) {
|
|
$displayFieldAR[] = $fid;
|
|
}
|
|
}
|
|
|
|
// get review fields and reviewer comments
|
|
$tempq = "SELECT `" . OCC_TABLE_PAPER . "`.`paperid`, `" . OCC_TABLE_PAPERREVIEWER . "`.* FROM `" . OCC_TABLE_PAPER . "`, `" . OCC_TABLE_PAPERREVIEWER . "` WHERE " . (!empty($accSQL) ? ($accSQL . " AND ") : '') . "`" . OCC_TABLE_PAPER . "`.`paperid`=`" . OCC_TABLE_PAPERREVIEWER . "`.`paperid`";
|
|
$tempr = ocsql_query($tempq) or err("Unable to get " . oc_strtolower(OCC_WORD_AUTHOR) . " comments");
|
|
while ($templ = ocsql_fetch_array($tempr)) {
|
|
// init vars for paperid
|
|
if (!isset($authorcomments[$templ['paperid']])) {
|
|
$authorcomments[$templ['paperid']] = "";
|
|
}
|
|
if (!isset($reviewfields[$templ['paperid']])) {
|
|
$reviewfields[$templ['paperid']] = "";
|
|
}
|
|
// set author comments
|
|
if (!empty($templ['authorcomments'])) {
|
|
$authorcomments[$templ['paperid']] .= $commentSeparator . "\n" . $templ['authorcomments'] . "\n";
|
|
}
|
|
// set review fields
|
|
$reviewInfo = '';
|
|
foreach ($displayFieldAR as $fid) {
|
|
if (!empty($templ[$fid])) {
|
|
$reviewInfo .= oc_strtoupper(oc_($OC_reviewQuestionsAR[$fid]['short'])) . ': ' . oc_getFieldValue($OC_reviewQuestionsAR, $templ, $fid) ."\n\n";
|
|
}
|
|
}
|
|
if (!empty($reviewInfo)) {
|
|
$reviewfields[$templ['paperid']] .= $commentSeparator . "\n" . $reviewInfo . "\n";
|
|
}
|
|
}
|
|
|
|
// get advocate and comments
|
|
$tempq = "SELECT `" . OCC_TABLE_PAPER . "`.`paperid`, `" . OCC_TABLE_REVIEWER . "`.`name_first`, `" . OCC_TABLE_REVIEWER . "`.`name_last`, `" . OCC_TABLE_REVIEWER . "`.`email`, `" . OCC_TABLE_PAPERADVOCATE . "`.`adv_comments` FROM `" . OCC_TABLE_PAPER . "`, `" . OCC_TABLE_PAPERADVOCATE . "`, `" . OCC_TABLE_REVIEWER . "` WHERE " . (!empty($accSQL) ? ($accSQL . " AND ") : '') . "`" . OCC_TABLE_PAPER . "`.`paperid`=`" . OCC_TABLE_PAPERADVOCATE . "`.`paperid` AND `" . OCC_TABLE_REVIEWER . "`.`reviewerid`=`" . OCC_TABLE_PAPERADVOCATE . "`.`advocateid`";
|
|
$tempr = ocsql_query($tempq) or err("Unable to get advocate comments");
|
|
while ($templ = ocsql_fetch_array($tempr)) {
|
|
if ($OC_configAR['OC_paperAdvocates'] && !empty($templ['email'])) {
|
|
$advocatename[$templ['paperid']] = $templ['name_first'] . ' ' . $templ['name_last'];
|
|
$advocateemail[$templ['paperid']] = $templ['email'];
|
|
}
|
|
if (!empty($templ['adv_comments'])) {
|
|
$advocatecomment[$templ['paperid']] = "\n" . $templ['adv_comments'] . "\n";
|
|
}
|
|
}
|
|
|
|
// get chair comments
|
|
$tempq = "SELECT `paperid`, `pcnotes` FROM `" . OCC_TABLE_PAPER . "`" . (!empty($accSQL) ? ( " WHERE " . $accSQL) : '');
|
|
$tempr = ocsql_query($tempq) or err("Unable to get chair comments");
|
|
while ($templ = ocsql_fetch_array($tempr)) {
|
|
if (!empty($templ['pcnotes'])) {
|
|
$chairnotes[$templ['paperid']] = "\n" . $templ['pcnotes'] . "\n";
|
|
}
|
|
}
|
|
|
|
$specialIndexAR['authorcomments'] = 'paperid';
|
|
$specialIndexAR['reviewfields'] = 'paperid';
|
|
$specialIndexAR['advocatecomment'] = 'paperid';
|
|
$specialIndexAR['advocatename'] = 'paperid';
|
|
$specialIndexAR['advocateemail'] = 'paperid';
|
|
$specialIndexAR['chairnotes'] = 'paperid';
|
|
|
|
// Check for addt'l (hook) special variables
|
|
if (oc_hookSet('chair-email-authors')) {
|
|
foreach ($OC_hooksAR['chair-email-authors'] as $f) {
|
|
require_once $f;
|
|
}
|
|
}
|