goIfInvalid($Conf->paperSite); $Me -> goIfNotPC($Conf->paperSite); $Conf -> connect(); function Check($var) { if ($var) { print ""; } else { print " "; } } function Num($var) { if ($var) { print $var; } else { print " "; } } function countPapers($array, $table, $where) { global ${$array}; global $Conf; $query = "SELECT $table.paperId, COUNT(*) " . " FROM $table " . $where . " GROUP BY $table.paperId "; $result=$Conf->qe($query); if (DB::isError($result)) { $Conf->errorMsg("Error in retrieving $table count " . $result->getMessage()); } else { while ($row = $result->fetchRow()) { $id=$row[0]; ${$array}[$id] = $row[1]; } } } ?> header("See Reviews for All Papers") ?> infoMsg("If you have the word 'CONFLICT' next to a paper, " . " the program chairs have registered a conflict of " . " interest with you seeing those reviews. If you think " . " this is an error, please contact the program chairs."); // // Process actions from this form.. // // // Make an array of all the valid paper indicies. // $allPapers=array(); $allPaperTitles=array(); $allPrimary=array(); $allSecondary=array(); $allReviewRequest=array(); $allStartedReviews=array(); $allFinishedReviews=array(); $result=$Conf->qe("SELECT Paper.paperId, Paper.title, " . " Paper.acknowledged, Paper.withdrawn " . " FROM Paper ORDER BY paperId"); $i = 0; if (DB::isError($result)) { $Conf->errorMsg("Error in retrieving paper list " . $result->getMessage()); } else { while ($row = $result->fetchRow()) { $f = 0; $id = $row[$f++]; $allPapers[$i] = $id; $allPaperTitles[$id] = $Conf->safeHtml($row[$f++]); $allSubmitted[$id] = $row[$f++]; $allWithdrawn[$id] = $row[$f++]; $i++; } } $countpapersforreview = $i; countPapers("allPrimary", "PrimaryReviewer", ""); countPapers("allSecondary", "SecondaryReviewer", ""); countPapers("allReviewRequest", "ReviewRequest", ""); countPapers("allStartedReviews", "PaperReview", "WHERE (PaperReview.finalized!=0)"); countPapers("allFinishedReviews", "PaperReview", "WHERE (PaperReview.finalized=0)"); $allConflicts = $Conf->allMyConflicts($Me->contactId); $pcConflicts = $Conf->allPCConflicts(); // // Determine the number of completed and started reviews for all papers // ?> Found papers. \n"; if ( $conflict ) { print ""; print " "; print "\n"; } else { if ( $Conf->validTimeFor('AtTheMeeting', 0) && $pcConflicts[$paperId] && ( $Me -> isPC && ! $Me -> isChair ) ) { // // Don't show anything // } else { print "\n"; print "\n"; print ""; } } print "\n"; } ?>
Paper # Title Reviews
$paperId $title CONFLICT $paperId "; print ""; print "$title "; print "See Reviews
footer() ?>