S-ID
" . $OC_sortImg; $psort='Submission'; $rsort='Reviewer'; $ridsort='R-ID'; $_GET['s'] = 'pid'; } elseif ($_GET['s'] == "paper") { $q = $pq . " ORDER BY `" . OCC_TABLE_PAPER . "`.`title`, `" . OCC_TABLE_REVIEWER . "`.`reviewerid`"; $sortid = "paper"; $pidsort='S-ID'; $psort="Submission
" . $OC_sortImg; $rsort='Reviewer'; $ridsort='R-ID'; } elseif ($_GET['s'] == "rid") { $q = $pq . " ORDER BY `" . OCC_TABLE_REVIEWER . "`.`reviewerid`, `" . OCC_TABLE_PAPER . "`.`paperid`"; $sortid = "reviewer"; $pidsort='S-ID'; $psort='Submission'; $rsort='Reviewer'; $ridsort="R-ID
" . $OC_sortImg; } elseif ($_GET['s'] == "reviewer") { $q = $pq . " ORDER BY `" . OCC_TABLE_REVIEWER . "`.`name_last`, `" . OCC_TABLE_REVIEWER . "`.`name_first`, `" . OCC_TABLE_PAPER . "`.`paperid`"; $sortid = "reviewer"; $pidsort='S-ID'; $psort='Submission'; $rsort="Reviewer
" . $OC_sortImg; $ridsort= 'R-ID'; } else { err("Unknown sort source"); } // Display Filter $aAR = array_keys($OC_acceptanceColorAR); $aAR[] = 'Pending'; print '
 '; if (count($subTypeAR) > 0) { print '  '; } print '

'; $r = ocsql_query($q) or err("Unable to get information"); if (ocsql_num_rows($r) == 0) { print 'No reviews found.

'; } else { $s = substr($sortid,0,1); print '

Links:
'; if ($s == "p") { print '
R-ID – Show review
'; } else { print '
S-ID – Show review
'; } print '
Reviewer – Show Reviewer info
Submission – Show Submission info

Legend:
Review Status:           Marked as Complete            Started            Not Yet Saved
'; if (isset($OC_reviewQuestionsAR['recommendation'])) { print '

Recommendation: '; foreach ($OC_reviewQuestionsAR['recommendation']['values'] as $k => $v) { print '(' . $k . ') ' . safeHTMLstr(preg_match('/:/', $v) ? substr($v,0,strpos($v,':')) : substr($v,0,30)) . '   '; } print '
'; } print '

'; if (isset($OC_reviewQuestionsAR['recommendation'])) { print ''; } print ' '; $currid = -1; $row = 1; while ($l = ocsql_fetch_array($r)) { if ($l['completed'] == "F" ) { if ($l['updated']) { $reccolor = ' bgcolor="#ffffcc"'; $rectitle = 'started'; } else { $reccolor = ' bgcolor="#ffcccc"'; $rectitle = 'not yet saved'; } } elseif (isset($l['completed'])) { $reccolor = ' bgcolor="#ccffcc"'; $rectitle = 'marked as complete'; } else { $reccolor = ''; $rectitle = '';} if ($sortid == "reviewer") { $ptags = ''; $rtags = ''; } else { $ptags = ''; $rtags = ''; } $blanktags = ''; if ($currid != $l[$sortid.'id']) { if ($currid != -1) { if ($row==1) { $row=2; } else { $row=1; } } $currid = $l[$sortid.'id']; } else { if ($sortid == "reviewer") { $rtags = $blanktags; } else { $ptags = $blanktags; } } print '' . $ptags; if (isset($OC_reviewQuestionsAR['recommendation'])) { print ''; }; print $rtags . ''; print "\n"; } print '
' . $pidsort . '' . $psort . 'Recom.' . $ridsort . '' . $rsort . '
'.$l['paperid'].'' . safeHTMLstr($l['title']) . '' . $l['reviewerid'] . '' . safeHTMLstr($l['name']) . '' . $l['paperid'] . '' . safeHTMLstr($l['title']) . ''.$l['reviewerid'].'' . safeHTMLstr($l['name']) . '  
' . safeHTMLstr($l['recommendation']) . ' '; if (empty($l['reviewerid'])) { print ' '; } else { print ''; } print '
'; } printFooter(); ?>