1<?php 2include('../Code/confHeader.inc'); 3$_SESSION[Me] -> goIfInvalid("../index.php"); 4$_SESSION[Me] -> goIfNotAssistant('../index.php'); 5$Conf -> connect(); 6 7function olink($key,$string) 8{ 9 return "<a href=\"$_SERVER[PHP_SELF]?orderBy=$key\"> $string </a>"; 10} 11 12?> 13 14<html> 15 16<?php $Conf->header("List All Submitted Papers") ?> 17 18<body> 19<?php 20if (!IsSet($_REQUEST[ORDER])) { 21 $_REQUEST[ORDER]="ORDER BY Paper.paperId"; 22} 23if (IsSet($_REQUEST[orderBy])) { 24 $_REQUEST[ORDER] = "ORDER BY " . $_REQUEST[orderBy]; 25} 26?> 27<h2> List of submitted papers and authors </h2> 28<p> 29This page shows you all the papers that have been entered into the database. 30<br> 31If you click on the paper title, a window will pop up with the paper 32abstract and a link to download the paper. 33<br> 34If you click on the contact author email address, you can send them email. 35<br> 36If you click on the table headers, the table will be sorted using 37that specified criteria. 38</p> 39 40<?php 41 42// jl: where is updateFinalized/markFinalized/allPapers defined? is 43// this code used? 44 45if ($_SESSION[Me]->isChair && 46 IsSet($updateFinalized) && IsSet($markFinalized) && IsSet($allPapers)) { 47 for ($i = 0; $i < sizeof($allPapers); $i++) { 48 $p = $allPapers[$i]; 49 $mark=0; 50 if ( IsSet($markFinalized[$p] ) ) { 51 $mark = 1; 52 } else { 53 $mark = 0; 54 } 55 $query="UPDATE Paper SET acknowledged=$mark WHERE paperId=$p"; 56 $Conf->qe($query); 57 } 58} 59 60$finalizedStr = ""; 61if ( $_REQUEST[onlyFinalized] ) { 62 $finalizedStr = " AND Paper.acknowledged!=0 "; 63} 64 65$withdrawnStr = ""; 66if ( $_REQUEST[onlyWithdrawn] ) { 67 $withdrawnStr = " AND Paper.withdrawn!=0 "; 68} 69 70 71 $query="SELECT Paper.paperId, Paper.title, " 72 . " Paper.acknowledged, Paper.withdrawn, " 73 . " Paper.authorInformation, Paper.contactId, " 74 . " ContactInfo.firstName, ContactInfo.lastName, " 75 . " ContactInfo.email, ContactInfo.affiliation, Paper.collaborators, " 76 . " LENGTH(PaperStorage.paper), PaperStorage.mimetype " 77 . " FROM Paper, ContactInfo " 78 . " LEFT JOIN PaperStorage ON (PaperStorage.paperId=Paper.paperId)" 79 . " WHERE ContactInfo.contactId = Paper.ContactId " 80 . $finalizedStr . $withdrawnStr 81 . $_REQUEST[ORDER]; 82 83$result=$Conf->q($query); 84 85 if (DB::isError($result)) { 86 $Conf->errorMsg("Error in retrieving paper list " 87 . $result -> getMessage() . " query was: " . $query); 88 } else { 89 90 $numpapers = $result->numRows($result); 91?> 92 93Found <?php echo $numpapers ?> papers. 94 95<FORM method="POST" action="<?php echo $_SERVER[PHP_SELF] ?>"> 96 97<INPUT type=checkbox name=SeeAuthorInfo value=1 98 <?php if ($_REQUEST[SeeAuthorInfo]) {echo "checked";}?> > See author info </br> 99 100<INPUT type=checkbox name=onlyWithdrawn value=1 101 <?php if ($_REQUEST[onlyWithdrawn]) {echo "checked";}?> > Only show withdrawn </br> 102 103<INPUT type=checkbox name=onlyFinalized value=1 104 <?php if ($_REQUEST[onlyFinalized]) {echo "checked";}?> > Only show finalized </br> 105 106<input type=hidden name="ORDER" value="<?php echo $_REQUEST[ORDER] ?>"> 107 108<input type="submit" value="Update View" name="submit"> 109 110</p> 111 112<table border="1" width="100%" cellpadding=0 cellspacing=0> 113<thead> 114<tr> 115<th width= 5%> <?php echo olink("Paper.paperId", "Paper #") ?></th> 116<th> 117 <?php echo olink("Paper.title", "Title") ?> <br> 118 <?php echo olink("LENGTH(PaperStorage.paper)", "(size)") ?> 119</th> 120 <?php if ($_REQUEST[SeeAuthorInfo]) { ?> 121<th width=30%> 122<?php echo olink("ContactInfo.lastName", "Author") ?> 123<br> 124<?php echo olink("ContactInfo.email", "(email)") ?> 125</th> 126<th width=30%> 127<?php echo olink("ContactInfo.affiliation", "Affiliation") ?> 128</th> 129 <?php }?> 130</tr> 131 132<?php 133 $i = 0; 134 while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC) ){ 135 136 $paperId=$row['paperId']; 137 $title=$row['title']; 138 $author=nl2br($row['affiliation']); 139 $authorInfo = " " 140 . $row['firstName'] . " " . $row['lastName'] 141 . "<br> ( <a href=\"mailto:" 142 . $row['email'] 143 . "\"" 144 . " TITLE=\"Concerning paper#$paperId\" " 145 . ">" 146 . $row['email'] . "</a> ) "; 147 148 $collaborators=nl2br($row['collaborators']); 149 150 $finalized = ""; 151 152 if ( $row['acknowledged'] ) { 153 $finalized = "\nFINALIZED"; 154 } 155 156 if ($row['mimetype'] == NULL) { 157 $withdrawn = "\nWITHDRAWN "; 158 } else { 159 $withdrawn = "\n(" . $row['LENGTH(PaperStorage.paper)'] 160 . " bytes) " 161 . $row['mimetype'] . " "; 162 } 163 164 ?> 165 <tr> 166 <td ROWSPAN=2> <?php echo $paperId; ?></td> 167 <td> 168 <?php 169 if ($_SESSION[Me]->isChair) { 170 $link="../PC/PCAllAnonReviewsForPaper.php"; 171 } else { 172 $link="AssistantViewSinglePaper.php"; 173 } 174 ?> 175 176 <?php 177 $Conf->linkWithPaperId($title . $withdrawn . $finalized, $link, $paperId); 178 179 ?> 180 </td> 181 <?php if ($_REQUEST[SeeAuthorInfo]) { ?> 182 <td> <?php echo $authorInfo?> </td> 183 <td> <?php echo $author ?> </td> 184 <?php } ?> 185 </tr> 186 </tr> 187 <TR><TD COLSPAN=3> 188 <?php 189 $Conf->paperTable( $_REQUEST[SeeAuthorInfo], false, $paperId ); 190 echo '</TD></TR>'; 191} 192} 193?> 194 </table> 195</FORM> 196</body> 197<?php $Conf->footer() ?> 198</html> 199 200