include('../Code/confHeader.inc');
$Me -> goIfInvalid("../index.php");
$Me -> goIfNotChair('../index.php');
$Conf -> connect();
?>
$Conf->header("Check on A Single PC's Reviewing Progress ") ?>
$Conf->reviewerSummary($pcId, 1);
print "
";
print "
Primary Reviews
\n";
$query="SELECT "
. " ContactInfo.firstName, ContactInfo.lastName, ContactInfo.email, "
. " ContactInfo.contactId, "
. " Paper.paperId, Paper.title "
. " FROM PrimaryReviewer, ContactInfo, Paper "
. " WHERE ContactInfo.contactId=$pcId "
. " AND PrimaryReviewer.reviewer=ContactInfo.contactId "
. " AND PrimaryReviewer.paperId=Paper.paperId "
. " ORDER BY Paper.paperId "
;
$result = $Conf->qe($query);
if ( !DB::isError($result) ) {
print "";
print " Review # | Paper # | Info |
";
$i = 0;
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
$i++;
$first=$row['firstName'];
$last=$row['lastName'];
$email=$row['email'];
$id=$row['contactId'];
$paperId=$row['paperId'];
$title=$row['title'];
# print " " ; var_dump($row); print " | ";
print " $i | ";
print " $paperId | ";
print " $title ";
print " review requested of $first $last ($email) ";
$query2="SELECT finalized FROM PaperReview "
. " WHERE paperId=$paperId AND reviewer=$id";
$r2 = $Conf->qe($query2);
if ($r2) {
$foo = $r2->fetchRow();
if ($foo == null) {
print " not started ";
} else {
if ($foo[0] != 0) {
print " started and finished ";
} else {
print " started, not finished ";
}
}
}
print " | ";
print "
";
}
print "
";
}
print " Secondary Reviews
\n";
$query="SELECT "
. " ContactInfo.firstName, ContactInfo.lastName, ContactInfo.email, "
. " ContactInfo.contactId, "
. " Paper.paperId, Paper.title "
. " FROM ReviewRequest, ContactInfo, Paper "
. " WHERE ReviewRequest.requestedBy=$pcId "
. " AND ReviewRequest.asked=ContactInfo.contactId "
. " AND ReviewRequest.paperId=Paper.paperId "
. " ORDER BY Paper.paperId "
;
$result = $Conf->qe($query);
if ( ! DB::isError($result) ) {
print "";
print " Review # | Paper # | Info |
";
$i = 0;
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
$i++;
$first=$row['firstName'];
$last=$row['lastName'];
$email=$row['email'];
$id=$row['contactId'];
$paperId=$row['paperId'];
$title=$row['title'];
# print " " ; var_dump($row); print " | ";
print " $i | ";
print " $paperId | ";
print " $title ";
print " review requested of $first $last ($email) ";
$query2="SELECT finalized FROM PaperReview "
. " WHERE paperId=$paperId AND reviewer=$id";
$r2 = $Conf->qe($query2);
if ($r2) {
$foo = $r2->fetchRow();
if ($foo == null) {
print " not started ";
} else {
if ($foo[0] != 0) {
print " started and finished ";
} else {
print " started, not finished ";
}
}
}
print " | ";
print "
";
}
print "
";
}
?>
$Conf->footer() ?>