goIfInvalid("../index.php");
$Me -> goIfNotAssistant('../index.php');
$Conf -> connect();
function olink($key,$string)
{
return " $string ";
}
?>
header("List All Submitted Papers") ?>
List of submitted papers and authors
This page shows you all the papers that have been entered into the database.
If you click on the paper title, a window will pop up with the paper
abstract and a link to download the paper.
If you click on the contact author email address, you can send them email.
If you click on the table headers, the table will be sorted using
that specified criteria.
isChair &&
IsSet($updateFinalized) && IsSet($markFinalized) && IsSet($allPapers)) {
for ($i = 0; $i < sizeof($allPapers); $i++) {
$p = $allPapers[$i];
$mark=0;
if ( IsSet($markFinalized[$p] ) ) {
$mark = 1;
} else {
$mark = 0;
}
$query="UPDATE Paper SET acknowledged=$mark WHERE paperId=$p";
$Conf->qe($query);
}
}
$finalizedStr = "";
if ( $onlyFinalized ) {
$finalizedStr = " AND Paper.acknowledged!=0 ";
}
$withdrawnStr = "";
if ( $onlyWithdrawn ) {
$withdrawnStr = " AND Paper.withdrawn!=0 ";
}
$query="SELECT Paper.paperId, Paper.title, "
. " Paper.acknowledged, Paper.withdrawn, "
. " Paper.authorInformation, Paper.contactId, "
. " ContactInfo.firstName, ContactInfo.lastName, "
. " ContactInfo.email, ContactInfo.affiliation, "
. " LENGTH(PaperStorage.paper), PaperStorage.mimetype "
. " FROM Paper, ContactInfo "
. " LEFT JOIN PaperStorage ON (PaperStorage.paperId=Paper.paperId)"
. " WHERE ContactInfo.contactId = Paper.ContactId "
. $finalizedStr . $withdrawnStr
. $ORDER;
$result=$Conf->q($query);
if (DB::isError($result)) {
$Conf->errorMsg("Error in retrieving paper list "
. $result -> getMessage());
} else {
$numpapers = $result->numRows($result);
?>
Found papers.
footer() ?>