EliteConf
 All Data Structures Namespaces Files Functions Variables Pages
AdmintableviewallController.php
Go to the documentation of this file.
1 <?php
2 
8 class AdmintableviewallController extends Controller
9 {
10  public function actionIndex()
11  {
12  $this->render('index');
13  }
14 
18  public function viewall()
19  {
20 
21  $sorting = $_GET['sort'];
22 
23  echo "<form action='index.php?r=approvepaper/index' method='post'>";
24 
25  echo("");
26 
27  echo("<BR>");
28  echo("<table border=3>");
29 
30  echo("<tr>
31  <th><a href=./index.php?r=admintableviewall/index&sort=1><h3>Paper Id </h3></a></th>
32  <th><a href=./index.php?r=admintableviewall/index&sort=2><h3>Paper Name </h3></a></th>
33  <th><h3>Assignment</h3></th>
34  <th><a href=./index.php?r=admintableviewall/index&sort=4><h3>Author </h3></a></th>
35  <th><a href=./index.php?r=admintableviewall/index&sort=5><h3>Conference</h3> </a></th>
36  </tr>");
37 
38 
39 
40  Connect_DatabaseController::connect();
41 
42  if(Yii::app()->user->id != NULL)
43  $usid = Yii::app()->user->id;
44  else
45  $usid = 0;
46 
47  $app = "not approved";
48 
49  if($sorting==1)
50  {
51  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM conference_paper WHERE conferenceid IN
52  (SELECT conferenceid FROM conference_user_type WHERE userid=$usid AND usertype=1))");
53 
54  while($row = mysql_fetch_array($allpapers))
55  {
56 
57  $papername = $row['name'];
58  $paperid = $row['id'];
59  $papersize = $row['paper_size'];
60  $approved = $row['approved'];
61  $authors = mysql_query("SELECT * FROM users WHERE userid
62  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
63 
64  if($approved == 0) $app = "not approved";
65  else if($approved == 1) $app = "approved";
66  else if($approved == 2) $app = "rejected";
67 
68  //view if paper assigned or not
69  $eval = mysql_query("SELECT * FROM paper_referee WHERE userid=$usid AND paperid=$paperid");
70 
71  if(mysql_num_rows($eval)!=0)
72  {
73 
74  $evaluated = 1;
75 
76  }
77  else $evaluated = 0;
78 
79  if($evaluated==1) $ev="(assigned)";
80  else $ev="(not assigned)";
81 
82  while($row2 = mysql_fetch_array($authors))
83  {
84 
85  $authorname = $row2['username'];
86 
87  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
88  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
89 
90  while($row3 = mysql_fetch_array($conferences))
91  {
92 
93 
94 
95  $conferencename = $row3['name'];
96 
97 
98 
99 // echo "<a href='javascript:popup()'>Here is a popup window.</a>";
100  echo(" <tr><th>");
101  echo($paperid . $ev);
102  echo(" </th><th>");
103  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
104 
105  echo(" </th><th>");
106  echo "<a href='javascript:popup($paperid)'>Assign Referee</a>";
107  echo "<script type='text/javascript'>";
108  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=assignReferee/index&va=' + paperid, 'littleWindow', 'location=no,width=800,height=900'); }";
109  echo "</script>";
110 
111  echo("</th> <th>");
112  echo("$authorname");
113  echo("</th> <th>");
114  echo("$conferencename");
115  echo("</th> <th>");
116  echo "<input hidden name='val' value='$paperid'>";
117  echo("</th> </tr> ");
118  }
119 
120 
121  }
122  }
123  }
124 
125  else if($sorting==2)
126  {
127  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM conference_paper WHERE conferenceid IN
128  (SELECT conferenceid FROM conference_user_type WHERE userid=$usid AND usertype=1)) ORDER BY paper_name");
129 
130  while($row = mysql_fetch_array($allpapers))
131  {
132 
133  $papername = $row['name'];
134  $paperid = $row['id'];
135  $papersize = $row['paper_size'];
136  $approved = $row['approved'];
137 
138  if($approved == 0) $app = "not approved";
139  else if($approved == 1) $app = "approved";
140  else if($approved == 2) $app = "rejected";
141 
142  //view if paper assigned or not
143  $eval = mysql_query("SELECT * FROM paper_referee WHERE userid=$usid AND paperid=$paperid");
144 
145  if(mysql_num_rows($eval)!=0)
146  {
147 
148  $evaluated = 1;
149 
150  }
151  else $evaluated = 0;
152 
153  if($evaluated==1) $ev="(assigned)";
154  else $ev="(not assigned)";
155 
156 
157  $authors = mysql_query("SELECT * FROM users WHERE userid
158  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
159 
160  while($row2 = mysql_fetch_array($authors))
161  {
162 
163  $authorname = $row2['username'];
164 
165  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
166  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
167 
168  while($row3 = mysql_fetch_array($conferences))
169  {
170 
171  $conferencename = $row3['name'];
172 
173 
174  echo(" <tr><th>");
175  echo($paperid . $ev);
176  echo(" </th><th>");
177  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
178 
179  echo(" </th><th>");
180  echo "<a href='javascript:popup($paperid)'>Assign Referee</a>";
181  echo "<script type='text/javascript'>";
182  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=assignReferee/index&va=' + paperid, 'littleWindow', 'location=no,width=800,height=900'); }";
183  echo "</script>";
184 
185  echo("</th> <th>");
186  echo("$authorname");
187  echo("</th> <th>");
188  echo("$conferencename");
189  echo("</th> <th>");
190  echo "<input hidden name='val' value='$paperid'>";
191  echo("</th> </tr> ");
192 
193  }
194 
195 
196  }
197  }
198  }
199 
200  else if($sorting==3)
201  {
202  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM conference_paper WHERE conferenceid IN
203  (SELECT conferenceid FROM conference_user_type WHERE userid=$usid AND usertype=1)) ORDER BY paper_size");
204 
205  while($row = mysql_fetch_array($allpapers))
206  {
207 
208  $papername = $row['name'];
209  $paperid = $row['id'];
210  $papersize = $row['paper_size'];
211  $approved = $row['approved'];
212 
213  if($approved == 0) $app = "not approved";
214  else if($approved == 1) $app = "approved";
215  else if($approved == 2) $app = "rejected";
216 
217  //view if paper assigned or not
218  $eval = mysql_query("SELECT * FROM paper_referee WHERE userid=$usid AND paperid=$paperid");
219 
220  if(mysql_num_rows($eval)!=0)
221  {
222 
223  $evaluated = 1;
224 
225  }
226  else $evaluated = 0;
227 
228  if($evaluated==1) $ev="(assigned)";
229  else $ev="(not assigned)";
230 
231 
232  $authors = mysql_query("SELECT * FROM users WHERE userid
233  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
234 
235  while($row2 = mysql_fetch_array($authors))
236  {
237 
238  $authorname = $row2['username'];
239 
240  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
241  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
242 
243  while($row3 = mysql_fetch_array($conferences))
244  {
245 
246  $conferencename = $row3['name'];
247 
248  echo(" <tr><th>");
249  echo($paperid . $ev);
250  echo(" </th><th>");
251  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
252 
253  echo(" </th><th>");
254  echo "<a href='javascript:popup($paperid)'>Assign Referee</a>";
255  echo "<script type='text/javascript'>";
256  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=assignReferee/index&va=' + paperid, 'littleWindow', 'location=no,width=800,height=900'); }";
257  echo "</script>";
258 
259  echo("</th> <th>");
260  echo("$authorname");
261  echo("</th> <th>");
262  echo("$conferencename");
263  echo("</th> <th>");
264  echo "<input hidden name='val' value='$paperid'>";
265  echo("</th> </tr> ");
266 
267  }
268 
269 
270  }
271  }
272  }
273 
274  else if($sorting==4)
275  {
276  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM conference_paper WHERE conferenceid IN
277  (SELECT conferenceid FROM conference_user_type WHERE userid=$usid AND usertype=1
278  AND paperid IN
279  (SELECT paperid FROM paper_author WHERE userid IN
280  (SELECT userid FROM users ORDER BY username))))");
281 
282  while($row = mysql_fetch_array($allpapers))
283  {
284 
285  $papername = $row['name'];
286  $paperid = $row['id'];
287  $papersize = $row['paper_size'];
288  $approved = $row['approved'];
289 
290  if($approved == 0) $app = "not approved";
291  else if($approved == 1) $app = "approved";
292  else if($approved == 2) $app = "rejected";
293 
294  //view if paper assigned or not
295  $eval = mysql_query("SELECT * FROM paper_referee WHERE userid=$usid AND paperid=$paperid");
296 
297  if(mysql_num_rows($eval)!=0)
298  {
299 
300  $evaluated = 1;
301 
302  }
303  else $evaluated = 0;
304 
305  if($evaluated==1) $ev="(assigned)";
306  else $ev="(not assigned)";
307 
308 
309 
310  $authors = mysql_query("SELECT * FROM users WHERE userid
311  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
312 
313  while($row2 = mysql_fetch_array($authors))
314  {
315 
316  $authorname = $row2['username'];
317 
318  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
319  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
320 
321  while($row3 = mysql_fetch_array($conferences))
322  {
323 
324  $conferencename = $row3['name'];
325 
326  echo(" <tr><th>");
327  echo($paperid . $ev);
328  echo(" </th><th>");
329  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
330 
331  echo(" </th><th>");
332  echo "<a href='javascript:popup($paperid)'>Assign Referee</a>";
333  echo "<script type='text/javascript'>";
334  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=assignReferee/index&va=' + paperid, 'littleWindow', 'location=no,width=800,height=900'); }";
335  echo "</script>";
336 
337  echo("</th> <th>");
338  echo("$authorname");
339  echo("</th> <th>");
340  echo("$conferencename");
341  echo("</th> <th>");
342  echo "<input hidden name='val' value='$paperid'>";
343  echo("</th> </tr> ");
344  }
345 
346 
347  }
348  }
349  }
350 
351 
352  else if($sorting==5)
353  {
354 
355  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM conference_paper WHERE conferenceid IN
356  (SELECT conferenceid FROM conference_user_type WHERE userid=$usid AND usertype=1 ORDER BY conferenceid))");
357 
358  while($row = mysql_fetch_array($allpapers))
359  {
360 
361  $papername = $row['name'];
362  $paperid = $row['id'];
363  $papersize = $row['paper_size'];
364  $approved = $row['approved'];
365 
366  if($approved == 0) $app = "not approved";
367  else if($approved == 1) $app = "approved";
368  else if($approved == 2) $app = "rejected";
369 
370  //view if paper assigned or not
371  $eval = mysql_query("SELECT * FROM paper_referee WHERE userid=$usid AND paperid=$paperid");
372 
373  if(mysql_num_rows($eval)!=0)
374  {
375 
376  $evaluated = 1;
377 
378  }
379  else $evaluated = 0;
380 
381  if($evaluated==1) $ev="(assigned)";
382  else $ev="(not assigned)";
383 
384 
385  $authors = mysql_query("SELECT * FROM users WHERE userid
386  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
387 
388  while($row2 = mysql_fetch_array($authors))
389  {
390 
391  $authorname = $row2['username'];
392 
393  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
394  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
395 
396  while($row3 = mysql_fetch_array($conferences))
397  {
398 
399  $conferencename = $row3['name'];
400 
401  echo(" <tr><th>");
402  echo($paperid . $ev);
403  echo(" </th><th>");
404  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
405 
406  echo(" </th><th>");
407  echo "<a href='javascript:popup($paperid)'>Assign Referee</a>";
408  echo "<script type='text/javascript'>";
409  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=assignReferee/index&va=' + paperid, 'littleWindow', 'location=no,width=800,height=900'); }";
410  echo "</script>";
411 
412  echo("</th> <th>");
413  echo("$authorname");
414  echo("</th> <th>");
415  echo("$conferencename");
416  echo("</th> <th>");
417  echo "<input hidden name='val' value='$paperid'>";
418  echo("</th> </tr> ");
419  }
420 
421 
422  }
423  }
424  }
425  echo("</table>");
426 
427  echo"</form>";
428 
429  }
430 
431  // Uncomment the following methods and override them if needed
432  /*
433  public function filters()
434  {
435  // return the filter configuration for this controller, e.g.:
436  return array(
437  'inlineFilterName',
438  array(
439  'class'=>'path.to.FilterClass',
440  'propertyName'=>'propertyValue',
441  ),
442  );
443  }
444 
445  public function actions()
446  {
447  // return external action classes, e.g.:
448  return array(
449  'action1'=>'path.to.ActionClass',
450  'action2'=>array(
451  'class'=>'path.to.AnotherActionClass',
452  'propertyName'=>'propertyValue',
453  ),
454  );
455  }
456  */
457 }
Generated on Sun Jun 2 2013 05:35:37 for EliteConf by   doxygen 1.8.4