\n"; } // delete paper deletePaper($paperid); } } else { print "Unable to process submission id " . safeHTMLstr($paperid) . ".
\n"; } } print ' Submission(s) have been ' . $verbAR[$action] . '.
';
printFooter();
exit;
}
$rsortstr = 'ID';
$tsortstr = 'Title';
$nsortstr = 'Contact Author';
$ssortstr = 'Stud.';
$subtypesortstr = 'Type';
if (!isset($_GET['s']) || ($_GET['s'] == "id")) {
$sortby = "`paperid`";
$rsortstr = 'ID
' . $OC_sortImg;
} elseif ($_GET['s'] == "title") {
$sortby = "`title`";
$tsortstr = 'Title
' . $OC_sortImg;
} elseif ($_GET['s'] == "student") {
$sortby = "`student`, `paperid`";
$ssortstr = 'Stud.
' . $OC_sortImg;
} elseif ($_GET['s'] == "subtype") {
$sortby = "`module_oc_subtype_type`, `paperid`";
$subtypesortstr = 'Type
' . $OC_sortImg;
} else { // name sort
$sortby = "`name_last`, `name_first`";
$nsortstr = 'Contact Author
' . $OC_sortImg;
}
$extraFields = '';
if (oc_moduleActive('oc_subtype')) {
$extraFields .= ", `module_oc_subtype_type`";
}
if (oc_hookSet('chair-list_papers-preprocess')) {
foreach ($OC_hooksAR['chair-list_papers-preprocess'] as $v) {
require_once $v;
}
}
$q = "SELECT `" . OCC_TABLE_PAPER . "`.`paperid`, CONCAT_WS(' ', `name_first`, `name_last`) AS `name`, `title`, " . $formatField . ", `student`" . $extraFields . " FROM `" . OCC_TABLE_PAPER . "` LEFT JOIN `" . OCC_TABLE_AUTHOR . "` ON `" . OCC_TABLE_AUTHOR . "`.`paperid`=`" . OCC_TABLE_PAPER . "`.`paperid` AND `" . OCC_TABLE_AUTHOR . "`.`position`=`" . OCC_TABLE_PAPER . "`.`contactid` ORDER BY $sortby";
$r = ocsql_query($q) or err("Unable to get submissions");
if (mysql_num_rows($r) == 0) {
print 'No submissions have been made yet.
'; } else { print "Count: " . mysql_num_rows($r) . "
\n"; print ' Note: When deleting a submission, all records associated with the submission are permanently removed. When withdrawing a submission, all reviews and assignments, uploaded files, etc, are permanently removed; the submission and author table data however may be restored.
'; } $q = "SELECT `paperid`, `title`, `contact_author`, `contact_email`, `withdraw_date`, `withdrawn_by` FROM `" . OCC_TABLE_WITHDRAWN . "` ORDER BY `paperid`"; $r = ocsql_query($q) or err('Unable to check for withdrawn submissions'); if (mysql_num_rows($r) > 0) { print '
Withdrawn Submissions
Note: Restoring a withdrawn submission will not restore all the submission data, only the information stored in the submission (paper) and authors table.
'; } printFooter(); ?>