goIfInvalid($Conf->paperSite);
$Me -> goIfNotPC($Conf->paperSite);
$Conf -> connect();
function spotSecondaryReviewers($howmany)
{
global $Conf;
global $Me;
if ( $howmany == 0 ) {
$result =$Conf->qe(
" SELECT Paper.paperId, Paper.title "
. " FROM Paper, SecondaryReviewer "
. " LEFT JOIN ReviewRequest "
. " ON ReviewRequest.paperId=Paper.paperId "
. " WHERE ReviewRequest.paperId IS NULL "
. " AND SecondaryReviewer.paperId=Paper.paperId "
. " AND SecondaryReviewer.reviewer=$Me->contactId "
. " ORDER BY Paper.paperId ");
} else {
$result =$Conf->qe(
" SELECT Paper.paperId, Paper.title "
. " FROM Paper, SecondaryReviewer "
. " LEFT JOIN ReviewRequest "
. " ON ReviewRequest.paperId=Paper.paperId "
. " WHERE SecondaryReviewer.paperId=Paper.paperId "
. " AND SecondaryReviewer.reviewer=$Me->contactId "
. " GROUP BY ReviewRequest.paperId "
. " HAVING COUNT(ReviewRequest.paperId)=$howmany "
. " ORDER BY Paper.paperId ");
}
if (!DB::isError($result)) {
print " ";
print " | Papers With $howmany Assigned Secondary |
";
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
$paperId=$row['paperId'];
$title=$row['title'];
print " | $paperId | ";
print "";
print "$title |
";
}
print "
";
}
}
function spotReviews($howmany, $finalized, $table)
{
global $Conf;
global $Me;
if ( $howmany == 0 ) {
$query=
" SELECT Paper.paperId, Paper.title "
. " FROM Paper, $table "
. " LEFT JOIN PaperReview "
. " ON PaperReview.paperId=Paper.paperId "
. " WHERE PaperReview.paperId IS NULL "
. " AND $table" . ".paperId=Paper.paperId "
. " AND $table" . ".reviewer=$Me->contactId "
. " ORDER BY Paper.paperId ";
} else {
if ( $finalized ) {
$fin = " AND PaperReview.finalized=1 ";
}
$query=
" SELECT Paper.paperId, Paper.title "
. " FROM Paper,$table "
. " LEFT JOIN PaperReview "
. " ON PaperReview.paperId=Paper.paperId "
. " WHERE "
. " $table" . ".paperId=Paper.paperId "
. " AND $table" . ".reviewer=$Me->contactId "
. $fin
. " GROUP BY PaperReview.paperId "
. " HAVING COUNT(PaperReview.paperId)=$howmany "
. " ORDER BY Paper.paperId ";
}
// print " query is $query
";
$result=$Conf->qe($query);
if (!DB::isError($result)) {
print " ";
if ( $finalized ) {
print " | Papers With $howmany Finalized $table Reviews |
";
} else {
print " | Papers With $howmany Started $table Reviews |
";
}
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
$paperId=$row['paperId'];
$title=$row['title'];
print " | $paperId | ";
print "";
print "$title |
";
}
print "
";
}
}
?>
header("Spot Problem Papers") ?>
Which papers do not have enough assigned secondary reviewers?
These are papers for which you are supposed to find a secondary reviewer.
These tables simply show you how many "review requests" have been made.
If you've assigned all your secondary reviews, the tables should
be blank and you can ignore this.
";
spotSecondaryReviewers(1);
?>
Which papers do not have enough started reviews?
You're supposed to be reviewing the following papers (you're a primary reviewer)
If you haven't done your reviews and you see entries in the "0" or "1" started
reviews, you
should get to work!
";
spotReviews(1,0,"PrimaryReviewer");
print "
";
spotReviews(2,0,"PrimaryReviewer");
print "
";
spotReviews(3,0,"PrimaryReviewer");
?>
You're supposed to be have assigned reviews for the following papers.
If you see entries in these tables, it means your reviewers haven't started
and neither has anyone else -- start nagging now!
";
spotReviews(1,0,"SecondaryReviewer");
print "
";
spotReviews(2,0,"SecondaryReviewer");
print "
";
spotReviews(3,0,"SecondaryReviewer");
?>
Which papers do not have enough finished reviews?
You're supposed to be reviewing the following papers (you're a primary reviewer)
If you haven't done your reviews and you see entries in the "0" or "1" started
reviews, you
should get to work!
";
spotReviews(1,1,"PrimaryReviewer");
print "
";
spotReviews(2,1,"PrimaryReviewer");
print "
";
spotReviews(3,1,"PrimaryReviewer");
?>
You're supposed to be have assigned reviews for the following papers.
If you see entries in these tables, it means your reviewers haven't started
and neither has anyone else -- start nagging now!
";
spotReviews(1,1,"SecondaryReviewer");
print "
";
spotReviews(2,1,"SecondaryReviewer");
print "
";
spotReviews(3,1,"SecondaryReviewer");
?>
footer() ?>