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