goIfInvalid("../index.php"); $Me -> goIfNotChair('../index.php'); $Conf -> connect(); ?> header("Check on A Single PC's Reviewing Progress ") ?> 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 ""; $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 ""; print " "; print " "; print ""; print ""; } print "
Review # Paper # Info
" ; var_dump($row); print "
$i $paperId $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 "

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 ""; $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 ""; print " "; print " "; print ""; print ""; } print "
Review # Paper # Info
" ; var_dump($row); print "
$i $paperId $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 "
"; } ?> footer() ?>