EliteConf
 All Data Structures Namespaces Files Functions Variables Pages
Participation_confirmationController.php
Go to the documentation of this file.
1 <?php
2 
7 class Participation_confirmationController extends Controller
8 {
9  public function actionIndex()
10  {
11  $this->render('index');
12  }
13 
17  public function view_pending_authoring_requests()
18  {
19  Connect_DatabaseController::connect();
20 
21  if(Yii::app()->user->id != NULL)
22  $usid = Yii::app()->user->id;
23  else
24  $usid = 0;
25 
26  $co = $_GET['va'];
27  //select all conferences that the user has admin as his user type
28  //type 2 = author
29  //type 3 = referee
30 
31  $author = mysql_query("SELECT DISTINCT * FROM request_type WHERE conferenceid=$co AND type=2");
32  $i=0;
33 
34  //pending 0, accepted 1, rejected 2
35  if($author!=NULL){
36  while($row = mysql_fetch_array($author))
37  {
38 
39  if($row['accept']==0)
40  {
41  $asd = $row['userid'];
42 
43 
44  $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");
45  if($result1!=NULL){
46  while($row2 = mysql_fetch_array($result1))
47  {
48  echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
49  echo " ";
50  }
51 
52  // echo "<br />";
53  // echo "Conference ID : " . $row['conferenceid'];
54  $uid = $row['userid'];
55  echo "<br />";
56 
57  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
58  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=2&accept=1\">AcceptRequest </a>";
59  echo " <br/> ";
60  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=2&accept=2\">Reject Request </a>";
61 
62  echo "<br />";
63  echo "<br />";
64  $i++;
65 
66  }}}}
67 
68  if($i==0) echo "No Pending Requests<br><br>";
69  }
70 
71 
75  public function view_accepted_authoring_requests()
76  {
77  Connect_DatabaseController::connect();
78 
79  if(Yii::app()->user->id != NULL)
80  $usid = Yii::app()->user->id;
81  else
82  $usid = 0;
83 
84  $co = $_GET['va'];
85  //select all conferences that the user has admin as his user type
86  //type 1 = author
87  //type 2 = referee
88 
89 $author = mysql_query("SELECT DISTINCT * FROM request_type WHERE conferenceid=$co AND type=2");
90 $i=0;
91 
92 //pending 0, accepted 1, rejected 2
93 if($author!=NULL){
94 while($row = mysql_fetch_array($author))
95  {
96 
97  if($row['accept']==1)
98  {
99  $asd = $row['userid'];
100 
101 
102  $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");
103 if($result1!=NULL){
104  while($row2 = mysql_fetch_array($result1))
105  {
106  echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
107  echo " ";
108  }
109 
110 // echo "<br />";
111 // echo "Conference ID : " . $row['conferenceid'];
112  $uid = $row['userid'];
113  echo "<br />";
114 
115 // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
116 
117  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=2&accept=2\">Reject Request </a>";
118 
119  echo "<br />";
120  echo "<br />";
121 
122  $i++;
123 
124 
125  }}}}
126 
127  if ($i==0) echo "No Accepted Requests<br/><br>";
128 
129 
130  }
131 
135  public function view_rejected_authoring_requests()
136  {
137  Connect_DatabaseController::connect();
138 
139  if(Yii::app()->user->id != NULL)
140  $usid = Yii::app()->user->id;
141  else
142  $usid = 0;
143 
144  $co = $_GET['va'];
145  //select all conferences that the user has admin as his user type
146  //type 2 = author
147  //type 3 = referee
148 
149 $author = mysql_query("SELECT DISTINCT * FROM request_type WHERE conferenceid=$co AND type=2");
150 $i=0;
151 
152 //pending 0, accepted 1, rejected 2
153 if($author!=NULL){
154 while($row = mysql_fetch_array($author))
155  {
156 
157  if($row['accept']==2)
158  {
159  $asd = $row['userid'];
160 
161 
162  $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");
163 if($result1!=NULL){
164  while($row2 = mysql_fetch_array($result1))
165  {
166  echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
167  echo " ";
168  }
169 
170 // echo "<br />";
171 // echo "Conference ID : " . $row['conferenceid'];
172  $uid = $row['userid'];
173  echo "<br />";
174 
175 // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
176  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=2&accept=1\">Accept Request </a>";
177 
178  echo "<br />";
179  echo "<br />";
180 
181  $i++;
182 
183  }}}}
184 
185  if($i==0) echo "No Rejected Requests<br/><br>";
186  }
187 
188 
192  public function view_pending_refereeing_requests()
193  {
194  Connect_DatabaseController::connect();
195 
196  if(Yii::app()->user->id != NULL)
197  $usid = Yii::app()->user->id;
198  else
199  $usid = 0;
200 
201  $co = $_GET['va'];
202  //select all conferences that the user has admin as his user type
203  //type 1 = author
204  //type 2 = referee
205 
206 $referee = mysql_query("SELECT DISTINCT * FROM request_type WHERE conferenceid=$co AND type=3");
207 $i=0;
208 
209 //pending 0, accepted 1, rejected 2
210 if($referee!=NULL){
211 
212 while($row = mysql_fetch_array($referee))
213  {
214 
215  if($row['accept']==0)
216  {
217  $asd = $row['userid'];
218 
219 
220  $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");
221  if($result1!=NULL){
222  while($row2 = mysql_fetch_array($result1))
223  {
224  echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
225  echo " ";
226  }
227 
228 // echo "<br />";
229 // echo "Conference ID : " . $row['conferenceid'];
230  $uid = $row['userid'];
231  echo "<br />";
232 
233 // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
234  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=3&accept=1\">Accept Request </a>";
235  echo " <br/> ";
236  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=3&accept=2\">Reject Request </a>";
237 
238  echo "<br />";
239  echo "<br />";
240  $i++;
241 
242  }}}}
243 
244  if($i==0) echo "No Pending Requests<br><br>";
245 
246 
247  }
248 
252  public function view_accepted_refereeing_requests()
253  {
254  Connect_DatabaseController::connect();
255 
256  if(Yii::app()->user->id != NULL)
257  $usid = Yii::app()->user->id;
258  else
259  $usid = 0;
260 
261  $co = $_GET['va'];
262  //select all conferences that the user has admin as his user type
263  //type 1 = author
264  //type 2 = referee
265 
266 $referee = mysql_query("SELECT DISTINCT * FROM request_type WHERE conferenceid=$co AND type=3");
267 $i=0;
268 
269 //pending 0, accepted 1, rejected 2
270 if($referee!=NULL){
271 
272 while($row = mysql_fetch_array($referee))
273  {
274 
275  if($row['accept']==1)
276  {
277  $asd = $row['userid'];
278 
279 
280  $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");
281 if($result1!=NULL){
282  while($row2 = mysql_fetch_array($result1))
283  {
284  echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
285  echo " ";
286  }
287 
288 // echo "<br />";
289 // echo "Conference ID : " . $row['conferenceid'];
290  $uid = $row['userid'];
291  echo "<br />";
292 
293 // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
294 
295  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=3&accept=2\">Reject Request </a>";
296 
297  echo "<br />";
298  echo "<br />";
299 
300  $i++;
301 
302 
303  }}}}
304 
305  if($i==0) echo "No Accepted Requests<br/><br>";
306 
307 
308  }
309 
313  public function view_rejected_refereeing_requests()
314  {
315  Connect_DatabaseController::connect();
316 
317  if(Yii::app()->user->id != NULL)
318  $usid = Yii::app()->user->id;
319  else
320  $usid = 0;
321 
322  $co = $_GET['va'];
323  //select all conferences that the user has admin as his user type
324  //type 1 = author
325  //type 2 = referee
326 
327 $referee = mysql_query("SELECT DISTINCT * FROM request_type WHERE conferenceid=$co AND type=3");
328 $i=0;
329 
330 //pending 0, accepted 1, rejected 2
331 if($referee!=NULL){
332 
333 while($row = mysql_fetch_array($referee))
334  {
335 
336  if($row['accept']==2)
337  {
338  $asd = $row['userid'];
339 
340 
341  $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");
342 if($result1!=NULL){
343  while($row2 = mysql_fetch_array($result1))
344  {
345  echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
346  echo " ";
347  }
348 
349 // echo "<br />";
350 // echo "Conference ID : " . $row['conferenceid'];
351  $uid = $row['userid'];
352  echo "<br />";
353 
354 // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
355  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=3&accept=1\">Accept Request </a>";
356 
357  echo "<br />";
358  echo "<br />";
359 
360  $i++;
361 
362  }}}}
363 
364  if($i==0) echo "No Rejected Requests<br/><br>";
365  }
366 
367 
371  public function view_pending_attendance_requests()
372  {
373  Connect_DatabaseController::connect();
374 
375  if(Yii::app()->user->id != NULL)
376  $usid = Yii::app()->user->id;
377  else
378  $usid = 0;
379 
380  $co = $_GET['va'];
381  //select all conferences that the user has admin as his user type
382  //type 2 = author
383  //type 3 = referee
384  //type 4 = attendee
385 
386  $author = mysql_query("SELECT DISTINCT * FROM request_type WHERE conferenceid=$co AND type=4");
387  $i=0;
388 
389  //pending 0, accepted 1, rejected 2
390  if($author!=NULL){
391  while($row = mysql_fetch_array($author))
392  {
393 
394  if($row['accept']==0)
395  {
396  $asd = $row['userid'];
397 
398 
399  $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");
400  if($result1!=NULL){
401  while($row2 = mysql_fetch_array($result1))
402  {
403  echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
404  echo " ";
405  }
406 
407  // echo "<br />";
408  // echo "Conference ID : " . $row['conferenceid'];
409  $uid = $row['userid'];
410  echo "<br />";
411 
412  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
413  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=4&accept=1\">AcceptRequest </a>";
414  echo " <br/> ";
415  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=4&accept=2\">Reject Request </a>";
416 
417  echo "<br />";
418  echo "<br />";
419  $i++;
420 
421  }}}}
422 
423  if($i==0) echo "No Pending Requests<br><br>";
424  }
425 
429  public function view_accepted_attendance_requests()
430  {
431  Connect_DatabaseController::connect();
432 
433  if(Yii::app()->user->id != NULL)
434  $usid = Yii::app()->user->id;
435  else
436  $usid = 0;
437 
438  $co = $_GET['va'];
439  //select all conferences that the user has admin as his user type
440  //type 1 = author
441  //type 2 = referee
442 
443 $author = mysql_query("SELECT DISTINCT * FROM request_type WHERE conferenceid=$co AND type=4");
444 $i=0;
445 
446 //pending 0, accepted 1, rejected 2
447 if($author!=NULL){
448 while($row = mysql_fetch_array($author))
449  {
450 
451  if($row['accept']==1)
452  {
453  $asd = $row['userid'];
454 
455 
456  $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");
457 if($result1!=NULL){
458  while($row2 = mysql_fetch_array($result1))
459  {
460  echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
461  echo " ";
462  }
463 
464 // echo "<br />";
465 // echo "Conference ID : " . $row['conferenceid'];
466  $uid = $row['userid'];
467  echo "<br />";
468 
469 // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
470 
471  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=4&accept=2\">Reject Request </a>";
472 
473  echo "<br />";
474  echo "<br />";
475 
476  $i++;
477 
478 
479  }}}}
480 
481  if ($i==0) echo "No Accepted Requests<br/><br>";
482 
483 
484  }
485 
489  public function view_rejected_attendance_requests()
490  {
491  Connect_DatabaseController::connect();
492 
493  if(Yii::app()->user->id != NULL)
494  $usid = Yii::app()->user->id;
495  else
496  $usid = 0;
497 
498  $co = $_GET['va'];
499  //select all conferences that the user has admin as his user type
500  //type 2 = author
501  //type 3 = referee
502 
503 $author = mysql_query("SELECT DISTINCT * FROM request_type WHERE conferenceid=$co AND type=4");
504 $i=0;
505 
506 //pending 0, accepted 1, rejected 2
507 if($author!=NULL){
508 while($row = mysql_fetch_array($author))
509  {
510 
511  if($row['accept']==2)
512  {
513  $asd = $row['userid'];
514 
515 
516  $result1 = mysql_query("SELECT * FROM users WHERE userid='$asd'");
517 if($result1!=NULL){
518  while($row2 = mysql_fetch_array($result1))
519  {
520  echo "<B>".($i+1)."</B>" . ") User Name : " . $row2['firstname'] . " " . $row2['lastname'];
521  echo " ";
522  }
523 
524 // echo "<br />";
525 // echo "Conference ID : " . $row['conferenceid'];
526  $uid = $row['userid'];
527  echo "<br />";
528 
529 // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
530  echo "<a href=\" ./index.php?r=requestfunction/index&id=$co&uid=$uid&type=4&accept=1\">Accept Request </a>";
531 
532  echo "<br />";
533  echo "<br />";
534 
535  $i++;
536 
537  }}}}
538 
539  if($i==0) echo "No Rejected Requests<br/><br>";
540  }
541 
545  public function attend_req()
546  {
547  Connect_DatabaseController::connect();
548 
549  if(Yii::app()->user->id != NULL)
550  $usid = Yii::app()->user->id;
551  else
552  $usid = 0;
553 
554  $co = $_GET['va'];
555 
556  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=4");
557 
558  if(mysql_num_rows($pending_attend)==0)
559  echo "hidden";
560  else echo "visible";
561 
562  }
563 
564  public function attend_pending()
565  {
566 
567  Connect_DatabaseController::connect();
568 
569  if(Yii::app()->user->id != NULL)
570  $usid = Yii::app()->user->id;
571  else
572  $usid = 0;
573  $co = $_GET['va'];
574 
575  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=4 AND accept=0");
576 
577  if(mysql_num_rows($pending_attend)==0)
578  echo "hidden";
579  else echo "visible";
580 
581  }
582 
583  public function attend_accepted()
584  {
585 
586  Connect_DatabaseController::connect();
587 
588  if(Yii::app()->user->id != NULL)
589  $usid = Yii::app()->user->id;
590  else
591  $usid = 0;
592  $co = $_GET['va'];
593 
594  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=4 AND accept=1");
595 
596  if(mysql_num_rows($pending_attend)==0)
597  echo "hidden";
598  else echo "visible";
599 
600  }
601 
602  public function attend_rejected()
603  {
604 
605  Connect_DatabaseController::connect();
606 
607  if(Yii::app()->user->id != NULL)
608  $usid = Yii::app()->user->id;
609  else
610  $usid = 0;
611  $co = $_GET['va'];
612 
613  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=4 AND accept=2");
614 
615  if(mysql_num_rows($pending_attend)==0)
616  echo "hidden";
617  else echo "visible";
618 
619  }
620 
624  public function author_req()
625  {
626  Connect_DatabaseController::connect();
627 
628  if(Yii::app()->user->id != NULL)
629  $usid = Yii::app()->user->id;
630  else
631  $usid = 0;
632 
633  $co = $_GET['va'];
634 
635  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=2");
636 
637  if(mysql_num_rows($pending_attend)==0)
638  echo "hidden";
639  else echo "visible";
640 
641  }
642 
643  public function author_pending()
644  {
645 
646  Connect_DatabaseController::connect();
647 
648  if(Yii::app()->user->id != NULL)
649  $usid = Yii::app()->user->id;
650  else
651  $usid = 0;
652  $co = $_GET['va'];
653 
654  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=2 AND accept=0");
655 
656  if(mysql_num_rows($pending_attend)==0)
657  echo "hidden";
658  else echo "visible";
659 
660  }
661 
662  public function author_accepted()
663  {
664 
665  Connect_DatabaseController::connect();
666 
667  if(Yii::app()->user->id != NULL)
668  $usid = Yii::app()->user->id;
669  else
670  $usid = 0;
671  $co = $_GET['va'];
672 
673  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=2 AND accept=1");
674 
675  if(mysql_num_rows($pending_attend)==0)
676  echo "hidden";
677  else echo "visible";
678 
679  }
680 
681  public function author_rejected()
682  {
683 
684  Connect_DatabaseController::connect();
685 
686  if(Yii::app()->user->id != NULL)
687  $usid = Yii::app()->user->id;
688  else
689  $usid = 0;
690  $co = $_GET['va'];
691 
692  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=2 AND accept=2");
693 
694  if(mysql_num_rows($pending_attend)==0)
695  echo "hidden";
696  else echo "visible";
697 
698  }
699 
703  public function referee_req()
704  {
705  Connect_DatabaseController::connect();
706 
707  if(Yii::app()->user->id != NULL)
708  $usid = Yii::app()->user->id;
709  else
710  $usid = 0;
711 
712  $co = $_GET['va'];
713 
714  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=3");
715 
716  if(mysql_num_rows($pending_attend)==0)
717  echo "hidden";
718  else echo "visible";
719 
720  }
721 
722  public function referee_pending()
723  {
724 
725  Connect_DatabaseController::connect();
726 
727  if(Yii::app()->user->id != NULL)
728  $usid = Yii::app()->user->id;
729  else
730  $usid = 0;
731  $co = $_GET['va'];
732 
733  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=3 AND accept=0");
734 
735  if(mysql_num_rows($pending_attend)==0)
736  echo "hidden";
737  else echo "visible";
738 
739  }
740 
741  public function referee_accepted()
742  {
743 
744  Connect_DatabaseController::connect();
745 
746  if(Yii::app()->user->id != NULL)
747  $usid = Yii::app()->user->id;
748  else
749  $usid = 0;
750  $co = $_GET['va'];
751 
752  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=3 AND accept=1");
753 
754  if(mysql_num_rows($pending_attend)==0)
755  echo "hidden";
756  else echo "visible";
757 
758  }
759 
760  public function referee_rejected()
761  {
762 
763  Connect_DatabaseController::connect();
764 
765  if(Yii::app()->user->id != NULL)
766  $usid = Yii::app()->user->id;
767  else
768  $usid = 0;
769  $co = $_GET['va'];
770 
771  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co AND type=3 AND accept=2");
772 
773  if(mysql_num_rows($pending_attend)==0)
774  echo "hidden";
775  else echo "visible";
776 
777  }
778 
779  public function any_req()
780  {
781  Connect_DatabaseController::connect();
782 
783  if(Yii::app()->user->id != NULL)
784  $usid = Yii::app()->user->id;
785  else
786  $usid = 0;
787 
788  $co = $_GET['va'];
789 
790  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co");
791 
792  if(mysql_num_rows($pending_attend)==0)
793  echo "hidden";
794  else echo "visible";
795 
796  }
797 
798  public function no_req()
799  {
800  Connect_DatabaseController::connect();
801 
802  if(Yii::app()->user->id != NULL)
803  $usid = Yii::app()->user->id;
804  else
805  $usid = 0;
806 
807  $co = $_GET['va'];
808 
809  $pending_attend = mysql_query("SELECT * FROM request_type WHERE conferenceid=$co");
810 
811  if(mysql_num_rows($pending_attend)==0)
812  echo "visible";
813  else echo "hidden";
814 
815  }
816  // Uncomment the following methods and override them if needed
817  /*
818  public function filters()
819  {
820  // return the filter configuration for this controller, e.g.:
821  return array(
822  'inlineFilterName',
823  array(
824  'class'=>'path.to.FilterClass',
825  'propertyName'=>'propertyValue',
826  ),
827  );
828  }
829 
830  public function actions()
831  {
832  // return external action classes, e.g.:
833  return array(
834  'action1'=>'path.to.ActionClass',
835  'action2'=>array(
836  'class'=>'path.to.AnotherActionClass',
837  'propertyName'=>'propertyValue',
838  ),
839  );
840  }
841  */
842 }
Generated on Sun Jun 2 2013 05:35:37 for EliteConf by   doxygen 1.8.4