EliteConf
 All Data Structures Namespaces Files Functions Variables Pages
MyInvitationsController.php
Go to the documentation of this file.
1 <?php
2 
7 class MyInvitationsController extends Controller
8 {
9  public function actionIndex()
10  {
11  $this->render('index');
12  }
13 
17  public function view_pending_authoring_invitations()
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 
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 invitations WHERE userid=$usid AND usertype=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['accepted_rejected']==0)
40  {
41  $asd = $row['conferenceid'];
42 
43 
44  $result1 = mysql_query("SELECT * FROM conference WHERE conferenceid='$asd'");
45  if($result1!=NULL){
46  while($row2 = mysql_fetch_array($result1))
47  {
48  echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
49  echo " ";
50  }
51 
52  // echo "<br />";
53  // echo "Conference ID : " . $row['conferenceid'];
54  $confid = $row['conferenceid'];
55  echo "<br />";
56 
57  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
58  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=2&accept=1\">AcceptRequest </a>";
59  echo " <br/> ";
60  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=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_invitations()
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 
85  //select all conferences that the user has admin as his user type
86  //type 2 = author
87  //type 3 = referee
88 
89  $author = mysql_query("SELECT DISTINCT * FROM invitations WHERE userid=$usid AND usertype=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['accepted_rejected']==1)
98  {
99  $asd = $row['conferenceid'];
100 
101 
102  $result1 = mysql_query("SELECT * FROM conference WHERE conferenceid='$asd'");
103  if($result1!=NULL){
104  while($row2 = mysql_fetch_array($result1))
105  {
106  echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
107  echo " ";
108  }
109 
110  // echo "<br />";
111  // echo "Conference ID : " . $row['conferenceid'];
112  $confid = $row['conferenceid'];
113  echo "<br />";
114 
115  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
116 
117  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=2&accept=2\">Reject Request </a>";
118 
119  echo "<br />";
120  echo "<br />";
121  $i++;
122 
123  }}}}
124 
125  if($i==0) echo "No Accepted Requests<br><br>";
126 
127  }
128 
132  public function view_rejected_authoring_invitations()
133  {
134  Connect_DatabaseController::connect();
135 
136  if(Yii::app()->user->id != NULL)
137  $usid = Yii::app()->user->id;
138  else
139  $usid = 0;
140 
141 
142  //select all conferences that the user has admin as his user type
143  //type 2 = author
144  //type 3 = referee
145 
146  $author = mysql_query("SELECT DISTINCT * FROM invitations WHERE userid=$usid AND usertype=2");
147  $i=0;
148 
149  //pending 0, accepted 1, rejected 2
150  if($author!=NULL){
151  while($row = mysql_fetch_array($author))
152  {
153 
154  if($row['accepted_rejected']==2)
155  {
156  $asd = $row['conferenceid'];
157 
158 
159  $result1 = mysql_query("SELECT * FROM conference WHERE conferenceid='$asd'");
160  if($result1!=NULL){
161  while($row2 = mysql_fetch_array($result1))
162  {
163  echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
164  echo " ";
165  }
166 
167  // echo "<br />";
168  // echo "Conference ID : " . $row['conferenceid'];
169  $confid = $row['conferenceid'];
170  echo "<br />";
171 
172  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
173 
174  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=2&accept=1\">Accept Request </a>";
175 
176  echo "<br />";
177  echo "<br />";
178  $i++;
179 
180  }}}}
181 
182  if($i==0) echo "No Rejected Requests<br><br>";
183 
184  }
185 
186 
190  public function view_pending_refereeing_invitations()
191  {
192  Connect_DatabaseController::connect();
193 
194  if(Yii::app()->user->id != NULL)
195  $usid = Yii::app()->user->id;
196  else
197  $usid = 0;
198 
199 
200  //select all conferences that the user has admin as his user type
201  //type 2 = author
202  //type 3 = referee
203 
204  $author = mysql_query("SELECT DISTINCT * FROM invitations WHERE userid=$usid AND usertype=3");
205  $i=0;
206 
207  //pending 0, accepted 1, rejected 2
208  if($author!=NULL){
209  while($row = mysql_fetch_array($author))
210  {
211 
212  if($row['accepted_rejected']==0)
213  {
214  $asd = $row['conferenceid'];
215 
216 
217  $result1 = mysql_query("SELECT * FROM conference WHERE conferenceid='$asd'");
218  if($result1!=NULL){
219  while($row2 = mysql_fetch_array($result1))
220  {
221  echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
222  echo " ";
223  }
224 
225  // echo "<br />";
226  // echo "Conference ID : " . $row['conferenceid'];
227  $confid = $row['conferenceid'];
228  echo "<br />";
229 
230  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
231  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=3&accept=1\">AcceptRequest </a>";
232  echo " <br/> ";
233  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=3&accept=2\">Reject Request </a>";
234 
235  echo "<br />";
236  echo "<br />";
237  $i++;
238 
239  }}}}
240 
241  if($i==0) echo "No Pending Requests<br><br>";
242 
243  }
244 
248  public function view_accepted_refereeing_invitations()
249  {
250  Connect_DatabaseController::connect();
251 
252  if(Yii::app()->user->id != NULL)
253  $usid = Yii::app()->user->id;
254  else
255  $usid = 0;
256 
257 
258  //select all conferences that the user has admin as his user type
259  //type 2 = author
260  //type 3 = referee
261 
262  $author = mysql_query("SELECT DISTINCT * FROM invitations WHERE userid=$usid AND usertype=3");
263  $i=0;
264 
265  //pending 0, accepted 1, rejected 2
266  if($author!=NULL){
267  while($row = mysql_fetch_array($author))
268  {
269 
270  if($row['accepted_rejected']==1)
271  {
272  $asd = $row['conferenceid'];
273 
274 
275  $result1 = mysql_query("SELECT * FROM conference WHERE conferenceid='$asd'");
276  if($result1!=NULL){
277  while($row2 = mysql_fetch_array($result1))
278  {
279  echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
280  echo " ";
281  }
282 
283  // echo "<br />";
284  // echo "Conference ID : " . $row['conferenceid'];
285  $confid = $row['conferenceid'];
286  echo "<br />";
287 
288  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
289 
290  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=3&accept=2\">Reject Request </a>";
291 
292  echo "<br />";
293  echo "<br />";
294  $i++;
295 
296  }}}}
297 
298  if($i==0) echo "No Accepted Requests<br><br>";
299 
300  }
301 
305  public function view_rejected_refereeing_invitations()
306  {
307  Connect_DatabaseController::connect();
308 
309  if(Yii::app()->user->id != NULL)
310  $usid = Yii::app()->user->id;
311  else
312  $usid = 0;
313 
314 
315  //select all conferences that the user has admin as his user type
316  //type 2 = author
317  //type 3 = referee
318 
319  $author = mysql_query("SELECT DISTINCT * FROM invitations WHERE userid=$usid AND usertype=3");
320  $i=0;
321 
322  //pending 0, accepted 1, rejected 2
323  if($author!=NULL){
324  while($row = mysql_fetch_array($author))
325  {
326 
327  if($row['accepted_rejected']==2)
328  {
329  $asd = $row['conferenceid'];
330 
331 
332  $result1 = mysql_query("SELECT * FROM conference WHERE conferenceid='$asd'");
333  if($result1!=NULL){
334  while($row2 = mysql_fetch_array($result1))
335  {
336  echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
337  echo " ";
338  }
339 
340  // echo "<br />";
341  // echo "Conference ID : " . $row['conferenceid'];
342  $confid = $row['conferenceid'];
343  echo "<br />";
344 
345  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
346  echo "<a href=\" /test/index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=3&accept=1\">AcceptRequest </a>";
347 
348  echo "<br />";
349  echo "<br />";
350  $i++;
351 
352  }}}}
353 
354  if($i==0) echo "No Rejected Requests<br><br>";
355  }
356 
360  public function view_pending_attendance_invitations()
361  {
362  Connect_DatabaseController::connect();
363 
364  if(Yii::app()->user->id != NULL)
365  $usid = Yii::app()->user->id;
366  else
367  $usid = 0;
368 
369 
370  //select all conferences that the user has admin as his user type
371  //type 2 = author
372  //type 3 = referee
373 
374  $author = mysql_query("SELECT DISTINCT * FROM invitations WHERE userid=$usid AND usertype=4");
375  $i=0;
376 
377  //pending 0, accepted 1, rejected 2
378  if($author!=NULL){
379  while($row = mysql_fetch_array($author))
380  {
381 
382  if($row['accepted_rejected']==0)
383  {
384  $asd = $row['conferenceid'];
385 
386 
387  $result1 = mysql_query("SELECT * FROM conference WHERE conferenceid='$asd'");
388  if($result1!=NULL){
389  while($row2 = mysql_fetch_array($result1))
390  {
391  echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
392  echo " ";
393  }
394 
395  // echo "<br />";
396  // echo "Conference ID : " . $row['conferenceid'];
397  $confid = $row['conferenceid'];
398  echo "<br />";
399 
400  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
401  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=4&accept=1\">AcceptRequest </a>";
402  echo " <br/> ";
403  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=4&accept=2\">Reject Request </a>";
404 
405  echo "<br />";
406  echo "<br />";
407  $i++;
408 
409  }}}}
410 
411  if($i==0) echo "No Pending Requests<br><br>";
412  }
413 
414 
418  public function view_accepted_attendance_invitations()
419  {
420  Connect_DatabaseController::connect();
421 
422  if(Yii::app()->user->id != NULL)
423  $usid = Yii::app()->user->id;
424  else
425  $usid = 0;
426 
427 
428  //select all conferences that the user has admin as his user type
429  //type 2 = author
430  //type 3 = referee
431 
432  $author = mysql_query("SELECT DISTINCT * FROM invitations WHERE userid=$usid AND usertype=4");
433  $i=0;
434 
435  //pending 0, accepted 1, rejected 2
436  if($author!=NULL){
437  while($row = mysql_fetch_array($author))
438  {
439 
440  if($row['accepted_rejected']==1)
441  {
442  $asd = $row['conferenceid'];
443 
444 
445  $result1 = mysql_query("SELECT * FROM conference WHERE conferenceid='$asd'");
446  if($result1!=NULL){
447  while($row2 = mysql_fetch_array($result1))
448  {
449  echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
450  echo " ";
451  }
452 
453  // echo "<br />";
454  // echo "Conference ID : " . $row['conferenceid'];
455  $confid = $row['conferenceid'];
456  echo "<br />";
457 
458  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
459 
460  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=4&accept=2\">Reject Request </a>";
461 
462  echo "<br />";
463  echo "<br />";
464  $i++;
465 
466  }}}}
467 
468  if($i==0) echo "No Accepted Requests<br><br>";
469 
470  }
471 
475  public function view_rejected_attendance_invitations()
476  {
477  Connect_DatabaseController::connect();
478 
479  if(Yii::app()->user->id != NULL)
480  $usid = Yii::app()->user->id;
481  else
482  $usid = 0;
483 
484 
485  //select all conferences that the user has admin as his user type
486  //type 2 = author
487  //type 3 = referee
488 
489  $author = mysql_query("SELECT DISTINCT * FROM invitations WHERE userid=$usid AND usertype=4");
490  $i=0;
491 
492  //pending 0, accepted 1, rejected 2
493  if($author!=NULL){
494  while($row = mysql_fetch_array($author))
495  {
496 
497  if($row['accepted_rejected']==2)
498  {
499  $asd = $row['conferenceid'];
500 
501 
502  $result1 = mysql_query("SELECT * FROM conference WHERE conferenceid='$asd'");
503  if($result1!=NULL){
504  while($row2 = mysql_fetch_array($result1))
505  {
506  echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
507  echo " ";
508  }
509 
510  // echo "<br />";
511  // echo "Conference ID : " . $row['conferenceid'];
512  $confid = $row['conferenceid'];
513  echo "<br />";
514 
515  // echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
516 
517  echo "<a href=\" ./index.php?r=myInvitationsFunction/index&confid=$confid&usid=$usid&usertype=4&accept=1\">Accept Request </a>";
518 
519  echo "<br />";
520  echo "<br />";
521  $i++;
522 
523  }}}}
524 
525  if($i==0) echo "No Rejected Requests<br><br>";
526 
527  }
528 
532  public function attend_inv()
533  {
534  Connect_DatabaseController::connect();
535 
536  if(Yii::app()->user->id != NULL)
537  $usid = Yii::app()->user->id;
538  else
539  $usid = 0;
540 
541  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=4 AND (accepted_rejected=0 OR accepted_rejected=1 OR accepted_rejected=2)");
542 
543  if(mysql_num_rows($pending_attend)==0)
544  echo "hidden";
545  else echo "visible";
546 
547  }
548 
549  public function attend_pending()
550  {
551 
552  Connect_DatabaseController::connect();
553 
554  if(Yii::app()->user->id != NULL)
555  $usid = Yii::app()->user->id;
556  else
557  $usid = 0;
558 
559  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=4 AND accepted_rejected=0");
560 
561  if(mysql_num_rows($pending_attend)==0)
562  echo "hidden";
563  else echo "visible";
564 
565  }
566 
567  public function attend_accepted()
568  {
569 
570  Connect_DatabaseController::connect();
571 
572  if(Yii::app()->user->id != NULL)
573  $usid = Yii::app()->user->id;
574  else
575  $usid = 0;
576 
577  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=4 AND accepted_rejected=1");
578 
579  if(mysql_num_rows($pending_attend)==0)
580  echo "hidden";
581  else echo "visible";
582 
583  }
584 
585  public function attend_rejected()
586  {
587 
588  Connect_DatabaseController::connect();
589 
590  if(Yii::app()->user->id != NULL)
591  $usid = Yii::app()->user->id;
592  else
593  $usid = 0;
594 
595  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=4 AND accepted_rejected=2");
596 
597  if(mysql_num_rows($pending_attend)==0)
598  echo "hidden";
599  else echo "visible";
600 
601  }
602 
606  public function author_inv()
607  {
608  Connect_DatabaseController::connect();
609 
610  if(Yii::app()->user->id != NULL)
611  $usid = Yii::app()->user->id;
612  else
613  $usid = 0;
614 
615  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=2 AND (accepted_rejected=0 OR accepted_rejected=1 OR accepted_rejected=2)");
616 
617  if(mysql_num_rows($pending_attend)==0)
618  echo "hidden";
619  else echo "visible";
620 
621  }
622 
623  public function author_pending()
624  {
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  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=2 AND accepted_rejected=0");
634 
635  if(mysql_num_rows($pending_attend)==0)
636  echo "hidden";
637  else echo "visible";
638 
639  }
640 
641  public function author_accepted()
642  {
643 
644  Connect_DatabaseController::connect();
645 
646  if(Yii::app()->user->id != NULL)
647  $usid = Yii::app()->user->id;
648  else
649  $usid = 0;
650 
651  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=2 AND accepted_rejected=1");
652 
653  if(mysql_num_rows($pending_attend)==0)
654  echo "hidden";
655  else echo "visible";
656 
657  }
658 
659  public function author_rejected()
660  {
661 
662  Connect_DatabaseController::connect();
663 
664  if(Yii::app()->user->id != NULL)
665  $usid = Yii::app()->user->id;
666  else
667  $usid = 0;
668 
669  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=2 AND accepted_rejected=2");
670 
671  if(mysql_num_rows($pending_attend)==0)
672  echo "hidden";
673  else echo "visible";
674 
675  }
676 
680  public function referee_inv()
681  {
682  Connect_DatabaseController::connect();
683 
684  if(Yii::app()->user->id != NULL)
685  $usid = Yii::app()->user->id;
686  else
687  $usid = 0;
688 
689  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=3 AND (accepted_rejected=0 OR accepted_rejected=1 OR accepted_rejected=2)");
690 
691  if(mysql_num_rows($pending_attend)==0)
692  echo "hidden";
693  else echo "visible";
694 
695  }
696 
697  public function referee_pending()
698  {
699 
700  Connect_DatabaseController::connect();
701 
702  if(Yii::app()->user->id != NULL)
703  $usid = Yii::app()->user->id;
704  else
705  $usid = 0;
706 
707  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=3 AND accepted_rejected=0");
708 
709  if(mysql_num_rows($pending_attend)==0)
710  echo "hidden";
711  else echo "visible";
712 
713  }
714 
715  public function referee_accepted()
716  {
717 
718  Connect_DatabaseController::connect();
719 
720  if(Yii::app()->user->id != NULL)
721  $usid = Yii::app()->user->id;
722  else
723  $usid = 0;
724 
725  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=3 AND accepted_rejected=1");
726 
727  if(mysql_num_rows($pending_attend)==0)
728  echo "hidden";
729  else echo "visible";
730 
731  }
732 
733  public function referee_rejected()
734  {
735 
736  Connect_DatabaseController::connect();
737 
738  if(Yii::app()->user->id != NULL)
739  $usid = Yii::app()->user->id;
740  else
741  $usid = 0;
742 
743  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid AND usertype=3 AND accepted_rejected=2");
744 
745  if(mysql_num_rows($pending_attend)==0)
746  echo "hidden";
747  else echo "visible";
748 
749  }
750 
751 
752  public function any_inv()
753  {
754  Connect_DatabaseController::connect();
755 
756  if(Yii::app()->user->id != NULL)
757  $usid = Yii::app()->user->id;
758  else
759  $usid = 0;
760 
761  $pending_attend = mysql_query("SELECT * FROM invitations WHERE userid=$usid");
762 
763  if(mysql_num_rows($pending_attend)==0)
764  echo "visible";
765  else echo "hidden";
766 
767  }
768 
769  // Uncomment the following methods and override them if needed
770  /*
771  public function filters()
772  {
773  // return the filter configuration for this controller, e.g.:
774  return array(
775  'inlineFilterName',
776  array(
777  'class'=>'path.to.FilterClass',
778  'propertyName'=>'propertyValue',
779  ),
780  );
781  }
782 
783  public function actions()
784  {
785  // return external action classes, e.g.:
786  return array(
787  'action1'=>'path.to.ActionClass',
788  'action2'=>array(
789  'class'=>'path.to.AnotherActionClass',
790  'propertyName'=>'propertyValue',
791  ),
792  );
793  }
794  */
795 }
Generated on Sun Jun 2 2013 05:35:37 for EliteConf by   doxygen 1.8.4