EliteConf
 All Data Structures Namespaces Files Functions Variables Pages
RefereetableviewController.php
Go to the documentation of this file.
1 <?php
2 
7 class RefereetableviewController extends Controller
8 {
9  public function actionIndex()
10  {
11  $this->render('index');
12  }
13 
14  /*
15  public function viewall()
16  {
17 
18  $sorting = $_GET['sort'];
19 
20 
21 
22  echo("");
23 
24  echo("<BR>");
25  echo("<table border=3>");
26 
27  echo("<tr>
28  <th><a href=./index.php?r=refereetableview/index&sort=1><h3>Paper Id </h3></a></th>
29  <th><a href=./index.php?r=refereetableview/index&sort=2><h3>Paper Name </h3></a></th>
30  <th><a href=./index.php?r=refereetableview/index&sort=3><h3>Paper Size </h3></a></th>
31  <th><a href=./index.php?r=refereetableview/index&sort=4><h3>Author </h3></a></th>
32  <th><a href=./index.php?r=refereetableview/index&sort=5><h3>Conference</h3> </a></tr>");
33 
34 
35 
36  Connect_DatabaseController::connect();
37 
38  if(Yii::app()->user->id != NULL)
39  $usid = Yii::app()->user->id;
40  else
41  $usid = 0;
42 
43 
44  if($sorting==1)
45  {
46  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM paper_referee WHERE userid='$usid')");
47 
48  while($row = mysql_fetch_array($allpapers))
49  {
50 
51  $papername = $row['paper_name'];
52  $paperid = $row['id'];
53  $papersize = $row['paper_size'];
54  $authors = mysql_query("SELECT * FROM users WHERE userid
55  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
56 
57  while($row2 = mysql_fetch_array($authors))
58  {
59 
60  $authorname = $row2['username'];
61 
62  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
63  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
64 
65  while($row3 = mysql_fetch_array($conferences))
66  {
67 
68  $conferencename = $row3['name'];
69 
70  echo(" <tr><th>");
71  echo($paperid);
72  echo(" </th><th>");
73  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
74  echo(" </th><th>");
75  echo("$papersize");
76  echo("</th> <th>");
77  echo("$authorname");
78  echo("</th> <th>");
79  echo("$conferencename");
80  echo("</tr> ");
81 
82  }
83 
84 
85  }
86  }
87  }
88 
89  else if($sorting==2)
90  {
91  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM paper_referee WHERE userid='$usid') ORDER BY paper_name");
92 
93  while($row = mysql_fetch_array($allpapers))
94  {
95 
96  $papername = $row['paper_name'];
97  $paperid = $row['id'];
98  $papersize = $row['paper_size'];
99  $authors = mysql_query("SELECT * FROM users WHERE userid
100  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
101 
102  while($row2 = mysql_fetch_array($authors))
103  {
104 
105  $authorname = $row2['username'];
106 
107  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
108  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
109 
110  while($row3 = mysql_fetch_array($conferences))
111  {
112 
113  $conferencename = $row3['name'];
114 
115  echo(" <tr><th>");
116  echo($paperid);
117  echo(" </th><th>");
118  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
119  echo(" </th><th>");
120  echo("$papersize");
121  echo("</th> <th>");
122  echo("$authorname");
123  echo("</th> <th>");
124  echo("$conferencename");
125  echo("</tr> ");
126 
127  }
128 
129 
130  }
131  }
132  }
133 
134  else if($sorting==3)
135  {
136  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM paper_referee WHERE userid='$usid') ORDER BY paper_size");
137 
138  while($row = mysql_fetch_array($allpapers))
139  {
140 
141  $papername = $row['paper_name'];
142  $paperid = $row['id'];
143  $papersize = $row['paper_size'];
144  $authors = mysql_query("SELECT * FROM users WHERE userid
145  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
146 
147  while($row2 = mysql_fetch_array($authors))
148  {
149 
150  $authorname = $row2['username'];
151 
152  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
153  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
154 
155  while($row3 = mysql_fetch_array($conferences))
156  {
157 
158  $conferencename = $row3['name'];
159 
160  echo(" <tr><th>");
161  echo($paperid);
162  echo(" </th><th>");
163  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
164  echo(" </th><th>");
165  echo("$papersize");
166  echo("</th> <th>");
167  echo("$authorname");
168  echo("</th> <th>");
169  echo("$conferencename");
170  echo("</tr> ");
171 
172  }
173 
174 
175  }
176  }
177  }
178 
179  else if($sorting==4)
180  {
181 
182  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM paper_referee WHERE userid=$usid AND paperid IN
183  (SELECT paperid FROM paper_author WHERE userid IN
184  (SELECT userid FROM users ORDER BY username)))");
185 
186  while($row = mysql_fetch_array($allpapers))
187  {
188 
189  $papername = $row['paper_name'];
190  $paperid = $row['id'];
191  $papersize = $row['paper_size'];
192  $authors = mysql_query("SELECT * FROM users WHERE userid
193  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
194 
195  while($row2 = mysql_fetch_array($authors))
196  {
197 
198  $authorname = $row2['username'];
199 
200  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
201  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
202 
203  while($row3 = mysql_fetch_array($conferences))
204  {
205 
206  $conferencename = $row3['name'];
207 
208  echo(" <tr><th>");
209  echo($paperid);
210  echo(" </th><th>");
211  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
212  echo(" </th><th>");
213  echo("$papersize");
214  echo("</th> <th>");
215  echo("$authorname");
216  echo("</th> <th>");
217  echo("$conferencename");
218  echo("</tr> ");
219 
220  }
221 
222 
223  }
224  }
225  }
226  else if($sorting==5)
227  {
228 
229  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM paper_referee WHERE userid=$usid AND paperid IN
230  (SELECT paperid FROM conference_paper WHERE conferenceid IN
231  (SELECT conferenceid FROM conference ORDER BY name)))");
232 
233  while($row = mysql_fetch_array($allpapers))
234  {
235 
236  $papername = $row['paper_name'];
237  $paperid = $row['id'];
238  $papersize = $row['paper_size'];
239  $authors = mysql_query("SELECT * FROM users WHERE userid
240  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
241 
242  while($row2 = mysql_fetch_array($authors))
243  {
244 
245  $authorname = $row2['username'];
246 
247  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
248  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
249 
250  while($row3 = mysql_fetch_array($conferences))
251  {
252 
253  $conferencename = $row3['name'];
254 
255  echo(" <tr><th>");
256  echo($paperid);
257  echo(" </th><th>");
258  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
259  echo(" </th><th>");
260  echo("$papersize");
261  echo("</th> <th>");
262  echo("$authorname");
263  echo("</th> <th>");
264  echo("$conferencename");
265  echo("</tr> ");
266 
267  }
268 
269 
270  }
271  }
272  }
273  echo("</table>");
274 
275  }
276  */
277  // Uncomment the following methods and override them if needed
278  /*
279  public function filters()
280  {
281  // return the filter configuration for this controller, e.g.:
282  return array(
283  'inlineFilterName',
284  array(
285  'class'=>'path.to.FilterClass',
286  'propertyName'=>'propertyValue',
287  ),
288  );
289  }
290 
291  public function actions()
292  {
293  // return external action classes, e.g.:
294  return array(
295  'action1'=>'path.to.ActionClass',
296  'action2'=>array(
297  'class'=>'path.to.AnotherActionClass',
298  'propertyName'=>'propertyValue',
299  ),
300  );
301  }
302  */
303 
304 
305 
306  public function viewall()
307  {
308 
309  $sorting = $_GET['sort'];
310 
311  echo "<form action='index.php?r=approvepaper/index' method='post'>";
312 
313  echo("");
314 
315  echo("<BR>");
316  echo("<table border=3>");
317 
318  echo("<tr>
319  <th><a href=./index.php?r=refereetableview/index&sort=1><h3>Paper Id </h3></a></th>
320  <th><a href=./index.php?r=refereetableview/index&sort=2><h3>Paper Name </h3></a></th>
321  <th><h3>Evaluate Paper</h3></th>
322  <th><a href=./index.php?r=refereetableview/index&sort=4><h3>Author </h3></a></th>
323  <th><a href=./index.php?r=refereetableview/index&sort=5><h3>Conference</h3> </a></th>
324  </tr>");
325 
326 
327 
328  Connect_DatabaseController::connect();
329 
330  if(Yii::app()->user->id != NULL)
331  $usid = Yii::app()->user->id;
332  else
333  $usid = 0;
334 
335  $app = "not approved";
336 
337  if($sorting==1)
338  {
339  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM paper_referee WHERE userid = $usid)");
340 
341  while($row = mysql_fetch_array($allpapers))
342  {
343 
344  $papername = $row['paper_name'];
345  $paperid = $row['id'];
346  $papersize = $row['paper_size'];
347  $approved = $row['approved'];
348  $authors = mysql_query("SELECT * FROM users WHERE userid
349  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
350 
351  if($approved == 0) $app = "not approved";
352  else if($approved == 1) $app = "approved";
353  else if($approved == 2) $app = "rejected";
354 
355  $eval = mysql_query("SELECT * FROM paper_evaluation_referee WHERE referee_id=$usid AND evaluation_id IN
356  (SELECT evaluation_id FROM paper_evaluation WHERE paper_id=$paperid)");
357 
358  if($ro = mysql_fetch_array($eval))
359  {
360 
361  $evaluated = 1;
362 
363  }
364  else $evaluated = 0;
365 
366  if($evaluated==1) $ev="(evaluated)";
367  else $ev="(not evaluated)";
368 
369  while($row2 = mysql_fetch_array($authors))
370  {
371 
372  $authorname = $row2['username'];
373 
374  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
375  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
376 
377  while($row3 = mysql_fetch_array($conferences))
378  {
379 
380 
381 
382  $conferencename = $row3['name'];
383 
384 
385 
386 // echo "<a href='javascript:popup()'>Here is a popup window.</a>";
387  echo(" <tr><th>");
388  echo($paperid . $ev );
389  echo(" </th><th>");
390  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
391 
392  echo(" </th><th>");
393  echo "<a href='javascript:popup($paperid)'>Evaluate (Opens Popup)</a>";
394  echo "<script type='text/javascript'>";
395  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=evaluatePaper/index&va=' + paperid, 'littleWindow', 'location=no,width=800,height=900'); }";
396  echo "</script>";
397 
398  echo("</th> <th>");
399  echo("$authorname");
400  echo("</th> <th>");
401  echo("$conferencename");
402  echo("</th> <th>");
403  echo "<input hidden name='val' value='$paperid'>";
404  echo("</th> </tr> ");
405  }
406 
407 
408  }
409  }
410  }
411 
412  else if($sorting==2)
413  {
414  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM paper_referee WHERE userid=$usid) ORDER BY paper_name");
415 
416  while($row = mysql_fetch_array($allpapers))
417  {
418 
419  $papername = $row['paper_name'];
420  $paperid = $row['id'];
421  $papersize = $row['paper_size'];
422  $approved = $row['approved'];
423 
424  if($approved == 0) $app = "not approved";
425  else if($approved == 1) $app = "approved";
426  else if($approved == 2) $app = "rejected";
427 
428  $eval = mysql_query("SELECT * FROM paper_evaluation_referee WHERE referee_id=$usid AND evaluation_id IN
429  (SELECT evaluation_id FROM paper_evaluation WHERE paper_id=$paperid)");
430 
431  if($ro = mysql_fetch_array($eval))
432  {
433 
434  $evaluated = 1;
435 
436  }
437  else $evaluated = 0;
438 
439  if($evaluated==1) $ev="(evaluated)";
440  else $ev="(not evaluated)";
441 
442 
443  $authors = mysql_query("SELECT * FROM users WHERE userid
444  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
445 
446  while($row2 = mysql_fetch_array($authors))
447  {
448 
449  $authorname = $row2['username'];
450 
451  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
452  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
453 
454  while($row3 = mysql_fetch_array($conferences))
455  {
456 
457  $conferencename = $row3['name'];
458 
459 
460  echo(" <tr><th>");
461  echo($paperid . $ev );
462  echo(" </th><th>");
463  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
464 
465  echo(" </th><th>");
466  echo "<a href='javascript:popup($paperid)'>Evaluate (Opens Popup)</a>";
467  echo "<script type='text/javascript'>";
468  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=evaluatePaper/index&va=' + paperid, 'littleWindow', 'location=no,width=800,height=900'); }";
469  echo "</script>";
470 
471  echo("</th> <th>");
472  echo("$authorname");
473  echo("</th> <th>");
474  echo("$conferencename");
475  echo("</th> <th>");
476  echo "<input hidden name='val' value='$paperid'>";
477  echo("</th> </tr> ");
478 
479  }
480 
481 
482  }
483  }
484  }
485 
486  else if($sorting==4)
487  {
488  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM paper_author ORDER BY userid)
489  AND id IN (SELECT paperid FROM paper_referee WHERE userid=$usid)");
490 
491  while($row = mysql_fetch_array($allpapers))
492  {
493 
494  $papername = $row['paper_name'];
495  $paperid = $row['id'];
496  $papersize = $row['paper_size'];
497  $approved = $row['approved'];
498 
499  if($approved == 0) $app = "not approved";
500  else if($approved == 1) $app = "approved";
501  else if($approved == 2) $app = "rejected";
502 
503 
504  $eval = mysql_query("SELECT * FROM paper_evaluation_referee WHERE referee_id=$usid AND evaluation_id IN
505  (SELECT evaluation_id FROM paper_evaluation WHERE paper_id=$paperid)");
506 
507  if($ro = mysql_fetch_array($eval))
508  {
509 
510  $evaluated = 1;
511 
512  }
513  else $evaluated = 0;
514 
515  if($evaluated==1) $ev="(evaluated)";
516  else $ev="(not evaluated)";
517 
518 
519  $authors = mysql_query("SELECT * FROM users WHERE userid
520  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
521 
522  while($row2 = mysql_fetch_array($authors))
523  {
524 
525  $authorname = $row2['username'];
526 
527  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
528  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
529 
530  while($row3 = mysql_fetch_array($conferences))
531  {
532 
533  $conferencename = $row3['name'];
534 
535  echo(" <tr><th>");
536  echo($paperid . $ev );
537  echo(" </th><th>");
538  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
539 
540  echo(" </th><th>");
541  echo "<a href='javascript:popup($paperid)'>Evaluate (Opens Popup)</a>";
542  echo "<script type='text/javascript'>";
543  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=evaluatePaper/index&va=' + paperid, 'littleWindow', 'location=no,width=800,height=900'); }";
544  echo "</script>";
545 
546  echo("</th> <th>");
547  echo("$authorname");
548  echo("</th> <th>");
549  echo("$conferencename");
550  echo("</th> <th>");
551  echo "<input hidden name='val' value='$paperid'>";
552  echo("</th> </tr> ");
553  }
554 
555 
556  }
557  }
558  }
559 
561  else if($sorting==5)
562  {
563 
564  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM paper_referee WHERE userid=$usid)");
565 
566  while($row = mysql_fetch_array($allpapers))
567  {
568 
569  $papername = $row['paper_name'];
570  $paperid = $row['id'];
571  $papersize = $row['paper_size'];
572  $approved = $row['approved'];
573 
574  if($approved == 0) $app = "not approved";
575  else if($approved == 1) $app = "approved";
576  else if($approved == 2) $app = "rejected";
577 
578  $eval = mysql_query("SELECT * FROM paper_evaluation_referee WHERE referee_id=$usid AND evaluation_id IN
579  (SELECT evaluation_id FROM paper_evaluation WHERE paper_id=$paperid)");
580 
581  if($ro = mysql_fetch_array($eval))
582  {
583 
584  $evaluated = 1;
585 
586  }
587  else $evaluated = 0;
588 
589  if($evaluated==1) $ev="(evaluated)";
590  else $ev="(not evaluated)";
591 
592  $authors = mysql_query("SELECT * FROM users WHERE userid
593  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
594 
595  while($row2 = mysql_fetch_array($authors))
596  {
597 
598  $authorname = $row2['username'];
599 
600  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
601  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
602 
603  while($row3 = mysql_fetch_array($conferences))
604  {
605 
606  $conferencename = $row3['name'];
607 
608  echo(" <tr><th>");
609  echo($paperid . $ev );
610  echo(" </th><th>");
611  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
612 
613  echo(" </th><th>");
614  echo "<a href='javascript:popup($paperid)'>Evaluate (Opens Popup)</a>";
615  echo "<script type='text/javascript'>";
616  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=evaluatePaper/index&va=' + paperid, 'littleWindow', 'location=no,width=800,height=900'); }";
617  echo "</script>";
618 
619  echo("</th> <th>");
620  echo("$authorname");
621  echo("</th> <th>");
622  echo("$conferencename");
623  echo("</th> <th>");
624  echo "<input hidden name='val' value='$paperid'>";
625  echo("</th> </tr> ");
626  }
627 
628 
629  }
630  }
631  }
632  echo("</table>");
633 
634  echo"</form>";
635 
636  }
637 
638 }
Generated on Sun Jun 2 2013 05:35:38 for EliteConf by   doxygen 1.8.4