goIfInvalid("../index.php");
$Me -> goIfNotPC('../index.php');
$Conf -> connect();
?>
header("Distribution of Overall Merit Scores By Reviewer ") ?>
infoMsg("This table is sorted by the number of reviews, "
. "then the desending merit within that group "
. "of reviewers. It's difficult to read much "
. "into this since the averages depend so much on "
. "the number of papers reviewed." );
$Conf->infoMsg("This display only shows the distribution of the "
. " 'overall merit' score, and only for finalized papers "
);
$Conf->toggleButtonUpdate('showPC');
print "";
$Conf->toggleButton('showPC',
"Show All Reviewers",
"Show Only PC Members");
print "";
if ($showPC) {
$extra = " AND ContactInfo.contactId=PCMember.contactId ";
}
$result=$Conf->qe("SELECT ContactInfo.firstName, ContactInfo.lastName,"
. " ContactInfo.email, ContactInfo.contactId,"
. " AVG(PaperReview.overAllMerit) as merit, "
. " COUNT(PaperReview.finalized) as count "
. " FROM ContactInfo, PCMember "
. " LEFT JOIN PaperReview "
. " ON PaperReview.reviewer=ContactInfo.contactId "
. " WHERE PaperReview.finalized=1 $extra "
. " GROUP BY ContactInfo.contactId "
. " ORDER BY merit DESC, count DESC, merit DESC, ContactInfo.lastName "
);
if (DB::isError($result)) {
$Conf->errorMsg("Error in sql " . $result->getMessage());
exit();
}
?>
contrastColorOne?>>
| Reviewer Ranking By Overall Merit |
| Row # |
Reviewer |
Merit |
reviewRange('overAllMerit', 'PaperReview');
$rowNum = 0;
while ($row=$result->fetchRow(DB_FETCHMODE_ASSOC)) {
$rowNum++;
$first=$row['firstName'];
$last=$row['lastName'];
$email=$row['email'];
$contactId=$row['contactId'];
print " | $rowNum | ";
print " ";
print "$first $last ($email) | \n";
print "";
$q = "SELECT overAllMerit FROM PaperReview "
. " WHERE reviewer=$contactId "
. " AND finalized = 1";
$Conf->graphValues($q, "overAllMerit", $meritRange['min'], $meritRange['max']);
print " | ";
print " \n";
}
?>
|
footer() ?>