EliteConf
 All Data Structures Namespaces Files Functions Variables Pages
ConferenceController.php
Go to the documentation of this file.
1 <?php
2 
3 class ConferenceController extends Controller
4 {
9  public $layout='//layouts/column2';
10 
14  public function filters()
15  {
16  return array(
17  'accessControl', // perform access control for CRUD operations
18  'postOnly + delete', // we only allow deletion via POST request
19  );
20  }
21 
27  public function accessRules()
28  {
29  return array(
30  array('allow', // allow all users to perform 'index' and 'view' actions
31  'actions'=>array('index','view'),
32  'users'=>array('*'),
33  ),
34  array('allow', // allow authenticated user to perform 'create' and 'update' actions
35  'actions'=>array('create','update'),
36  'users'=>array('@'),
37  ),
38  array('allow', // allow admin user to perform 'admin' and 'delete' actions
39  'actions'=>array('admin','delete'),
40  'users'=>array('admin'),
41  ),
42  array('deny', // deny all users
43  'users'=>array('*'),
44  ),
45  );
46  }
47 
52  public function actionView($id)
53  {
54  $this->render('view',array(
55  'model'=>$this->loadModel($id),
56  ));
57  }
58 
63  public function actionCreate()
64  {
65  $model=new Conference;
66 
67  // Uncomment the following line if AJAX validation is needed
68  // $this->performAjaxValidation($model);
69 
70  if(isset($_POST['Conference']))
71  {
72  $model->attributes=$_POST['Conference'];
73  if($model->save())
74  $this->redirect(array('view','id'=>$model->conferenceid));
75  }
76 
77  $this->render('create',array(
78  'model'=>$model,
79  ));
80  }
81 
87  public function actionUpdate($id)
88  {
89  $model=$this->loadModel($id);
90 
91  // Uncomment the following line if AJAX validation is needed
92  // $this->performAjaxValidation($model);
93 
94  if(isset($_POST['Conference']))
95  {
96  $model->attributes=$_POST['Conference'];
97  if($model->save())
98  $this->redirect(array('view','id'=>$model->conferenceid));
99  }
100 
101  $this->render('update',array(
102  'model'=>$model,
103  ));
104  }
105 
111  public function actionDelete($id)
112  {
113  $this->loadModel($id)->delete();
114 
115  // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
116  if(!isset($_GET['ajax']))
117  $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
118  }
119 
123  public function actionIndex()
124  {
125  $dataProvider=new CActiveDataProvider('Conference');
126  $this->render('index',array(
127  'dataProvider'=>$dataProvider,
128  ));
129  }
130 
134  public function actionAdmin()
135  {
136  $model=new Conference('search');
137  $model->unsetAttributes(); // clear any default values
138  if(isset($_GET['Conference']))
139  $model->attributes=$_GET['Conference'];
140 
141  $this->render('admin',array(
142  'model'=>$model,
143  ));
144  }
145 
151  public function loadModel($id)
152  {
153  $model=Conference::model()->findByPk($id);
154  if($model===null)
155  throw new CHttpException(404,'The requested page does not exist.');
156  return $model;
157  }
158 
163  protected function performAjaxValidation($model)
164  {
165  if(isset($_POST['ajax']) && $_POST['ajax']==='conference-form')
166  {
167  echo CActiveForm::validate($model);
168  Yii::app()->end();
169  }
170  }
171 
175  public function attends()
176  {
177 
178  Connect_DatabaseController::connect();
179 
180  if(Yii::app()->user->id != NULL)
181  $usid = Yii::app()->user->id;
182  else
183  $usid = 0;
184 
185  $id = $_GET['id'];
186 
187  $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND userid=$usid AND usertype=4");
188 
189  while($row = mysql_fetch_array($participates))
190  {
191  if($usid == $row['userid']) {echo "hidden";}
192  else echo "visible";
193  }
194  }
195 
196  public function attends2()
197  {
198 
199  Connect_DatabaseController::connect();
200 
201  if(Yii::app()->user->id != NULL)
202  $usid = Yii::app()->user->id;
203  else
204  $usid = 0;
205 
206  $id = $_GET['id'];
207 
208  $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND usertype=4");
209 
210  $i=0;
211  while($row = mysql_fetch_array($participates))
212  {
213 
214  if($row['userid']==$usid) $i++;
215  else "";
216 
217  }
218 
219  if($i==0) echo "hidden";
220  else echo "visible";
221  }
222 
226  public function authors()
227  {
228 
229  Connect_DatabaseController::connect();
230 
231  if(Yii::app()->user->id != NULL)
232  $usid = Yii::app()->user->id;
233  else
234  $usid = 0;
235 
236  $id = $_GET['id'];
237 
238  $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND userid=$usid AND usertype=2");
239 
240  while($row = mysql_fetch_array($participates))
241  {
242  if($usid == $row['userid']) {echo "hidden";}
243  else echo "visible";
244  }
245  }
246 
247 
248  public function authors2()
249  {
250 
251  Connect_DatabaseController::connect();
252 
253  if(Yii::app()->user->id != NULL)
254  $usid = Yii::app()->user->id;
255  else
256  $usid = 0;
257 
258  $id = $_GET['id'];
259 
260  $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND usertype=2");
261 
262  $i=0;
263  while($row = mysql_fetch_array($participates))
264  {
265 
266  if($row['userid']==$usid) $i++;
267  else "";
268 
269  }
270 
271  if($i==0) echo "hidden";
272  else echo "visible";
273 
274  }
275 
279  public function referees()
280  {
281 
282  Connect_DatabaseController::connect();
283 
284  if(Yii::app()->user->id != NULL)
285  $usid = Yii::app()->user->id;
286  else
287  $usid = 0;
288 
289  $id = $_GET['id'];
290 
291  $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND userid=$usid AND usertype=3");
292 
293  while($row = mysql_fetch_array($participates))
294  {
295  if($usid == $row['userid']) {echo "hidden";}
296  else echo "visible";
297  }
298  }
299 
300  public function referees2()
301  {
302 
303  Connect_DatabaseController::connect();
304 
305  if(Yii::app()->user->id != NULL)
306  $usid = Yii::app()->user->id;
307  else
308  $usid = 0;
309 
310  $id = $_GET['id'];
311 
312  $participates = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id AND usertype=3");
313 
314  $i=0;
315  while($row = mysql_fetch_array($participates))
316  {
317 
318  if($row['userid']==$usid) $i++;
319  else "";
320 
321  }
322 
323  if($i==0) echo "hidden";
324  else echo "visible";
325 
326 
327  }
328 
332  public function usersView($id)
333  {
334 
335  Connect_DatabaseController::connect();
336 
337 
338 //
340 // KONFERANS KULLANICILARINI GORUNTULE
341 
342 if(Yii::app()->user->id != NULL)
343 $usid = Yii::app()->user->id;
344 else
345 $usid = 0;
346 
347 
348 //select all users that participate in this conference
349 $participants = mysql_query("SELECT DISTINCT userid FROM conference_user_type WHERE conferenceid=$id");
350 $i=0;
351 
352 
353 
354 while($row = mysql_fetch_array($participants))
355  {
356 
357  $asd = $row['userid'];
358 
359  $result1 = mysql_query("SELECT * FROM users WHERE userid=$asd");
360  if($result1!=NULL){
361  while($row2 = mysql_fetch_array($result1))
362  {
363 
364  $co = $row2['userid'];
365  echo "<B>".($i+1)."</B>" . ") User Name : " ;//. $row2['username'];
366  echo "<a href=\" ./index.php?r=user_profile/index&usid=$co\">" . $row2['firstname'] . " " . $row2['lastname'] . "</a>";
367  echo "<br/>";
368  echo "<br/>";
369  $i++;
370  }
371  }
372  else {echo "<br/>";echo "<br/>";echo "<br/>";}
373  }
374 }
375 
376 
380  public function papersView($id)
381  {
382  Connect_DatabaseController::connect();
383 
384 //
386 // KONFERANS PAPER'LARINI GORUNTULE
387 
388 if(Yii::app()->user->id != NULL)
389 $usid = Yii::app()->user->id;
390 else
391 $usid = 0;
392 
393 
394 
395 
396 //select all papers that belong to the conference
397 $papers = mysql_query("SELECT DISTINCT paperid FROM conference_paper WHERE conferenceid=$id");
398 $i=0;
399 
400 
401 while($row = mysql_fetch_array($papers))
402  {
403 
404  $asd = $row['paperid'];
405 
406  $result1 = mysql_query("SELECT * FROM paper WHERE id=$asd");
407  if($result1!=NULL){
408  while($row2 = mysql_fetch_array($result1))
409  {
410 
411  $co = $row2['id'];
412  echo "<B>".($i+1)."</B>" . ") Paper Name : " ;//. $row2['username'];
413  echo "<a href=\" ./index.php?r=paper/view&id=$co\">" . $row2['name'] . "</a>";
414  echo "<br/>";
415  echo "<br/>";
416 
417  $i++;
418 
419  }
420 
421  }
422  else {echo "<br/>";}
423 
424 }
425  if($i==0) echo "No Papers Submitted Yet<br>";
426  else ;
427 
428 
429  }
430 
431 
435  public function adminFunctions()
436  {
437 
438  Connect_DatabaseController::connect();
439 
440  if(Yii::app()->user->id != NULL)
441  $usid = Yii::app()->user->id;
442  else
443  $usid = 0;
444 
445  $confid = $_GET['id'];
446 
447  $admin = mysql_query("SELECT * FROM conference_user_type WHERE userid='$usid' AND conferenceid='$confid' AND usertype=1");
448 
449  if(mysql_num_rows($admin)==0)
450  {
451 
452  }
453  else
454  {
455 
456  echo "<a href=\" ./index.php?r=editConference/index&va=$confid\">Edit Conference </a>";
457  echo "<br/>";
458  echo "<a href=\" ./index.php?r=conferenceTopics/index&va=$confid\">Edit Conference Topics</a>";
459  echo "<br />";
460  echo "<a href=\" ./index.php?r=inviteuser/index&va=$confid\">Invite Users </a>";
461  echo "<br/>";
462  echo "<a href=\" ./index.php?r=participation_confirmation/index&va=$confid\">View Participation Requests</a>";
463  echo "<br />";
464  echo "<a href=\" ./index.php?r=announcement/index&confid=$confid\">Make An Announcement</a>";
465  echo "<br />";
466  echo "<a href=\" ./index.php?r=assignment_function_conference/index&confid=$confid\">Assign Referees Automatically</a>";
467  echo "<br />";
468  echo "<a href=\" ./index.php?r=schedule/index&confid=$confid\">Schedule This Conference</a>";
469  echo "<br />";
470 
471  }
472 
473 
474 
475  }
476 
480  public function isAdmin()
481  {
482 
483  Connect_DatabaseController::connect();
484 
485  if(Yii::app()->user->id != NULL)
486  $usid = Yii::app()->user->id;
487  else
488  $usid = 0;
489 
490  $confid = $_GET['id'];
491 
492  $admin = mysql_query("SELECT * FROM conference_user_type WHERE userid='$usid' AND conferenceid='$confid' AND usertype=1");
493 
494  if(mysql_num_rows($admin)==0)
495  {
496  echo "hidden";
497  }
498  else
499  {
500 
501  echo "visible";
502 
503  }
504 
505  }
506 
510  public function authorFunctions()
511  {
512 
513  Connect_DatabaseController::connect();
514 
515  if(Yii::app()->user->id != NULL)
516  $usid = Yii::app()->user->id;
517  else
518  $usid = 0;
519 
520  $confid = $_GET['id'];
521 
522  $author = mysql_query("SELECT * FROM conference_user_type WHERE userid='$usid' AND conferenceid='$confid' AND usertype=2");
523 
524  if(mysql_num_rows($author)==0)
525  {
526 
527  }
528  else
529  {
530 
531  echo "<a href=\" ./index.php?r=paper/uploadPaper&va=$confid&type=0\">Submit Paper </a>";
532  echo " <br/> ";
533  }
534 
535 
536 
537  }
538 
542  public function isAuthor()
543  {
544 
545  Connect_DatabaseController::connect();
546 
547  if(Yii::app()->user->id != NULL)
548  $usid = Yii::app()->user->id;
549  else
550  $usid = 0;
551 
552  $confid = $_GET['id'];
553 
554  $author = mysql_query("SELECT * FROM conference_user_type WHERE userid='$usid' AND conferenceid='$confid' AND usertype=2");
555 
556  if(mysql_num_rows($author)==0)
557  {
558  echo "hidden";
559  }
560  else
561  {
562 
563  echo "visible";
564 
565  }
566 
567  }
568 
569 
573  public function refereeFunctions()
574  {
575 
576  Connect_DatabaseController::connect();
577 
578  if(Yii::app()->user->id != NULL)
579  $usid = Yii::app()->user->id;
580  else
581  $usid = 0;
582 
583  $confid = $_GET['id'];
584 
585  $referee = mysql_query("SELECT * FROM conference_user_type WHERE userid='$usid' AND conferenceid='$confid' AND usertype=3");
586 
587  if(mysql_num_rows($referee)==0)
588  {
589 
590  }
591  else
592  {
593 
594  echo "<a href=\" ./index.php?r=refereepaperinterest/index&confid=$confid&sort=1\">Select papers that you are interested in </a>";
595  echo " <br/> ";
596  }
597 
598 
599 
600  }
601 
605  public function isReferee()
606  {
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  $confid = $_GET['id'];
616 
617  $author = mysql_query("SELECT * FROM conference_user_type WHERE userid='$usid' AND conferenceid='$confid' AND usertype=3");
618 
619  if(mysql_num_rows($author)==0)
620  {
621  echo "hidden";
622  }
623  else
624  {
625 
626  echo "visible";
627 
628  }
629 
630  }
631 
635  public function viewTopics($confid)
636  {
637 
638  Connect_DatabaseController::connect();
639 
640  if(Yii::app()->user->id != NULL)
641  $usid = Yii::app()->user->id;
642  else
643  $usid = 0;
644 
645 
646 
647  $topicname = mysql_query("SELECT * FROM interests_topics WHERE id IN
648  (SELECT topicid FROM topic_subtopic WHERE subtopicid IN
649  (SELECT titleid FROM conference_title WHERE conferenceid=$confid))");
650 
651  $i=0;
652  while ($row4 = mysql_fetch_array($topicname))
653  {
654 
655  echo "<b>" . $row4['name'] . "</b><br>";
656  $topid = $row4['id'];
657 
658  $interest = mysql_query("SELECT * FROM interests_subtopics WHERE id IN
659  (SELECT subtopicid FROM topic_subtopic WHERE topicid=$topid AND subtopicid IN
660  (SELECT titleid FROM conference_title WHERE conferenceid=$confid))");
661 
662  while($row5 = mysql_fetch_array($interest))
663  {
664 
665  echo $row5['name'] . "<br>";
666 
667  }
668 
669  echo "<br>";
670  $i++;
671  }
672  /*
673  $interestname = mysql_query("SELECT name FROM interests_subtopics WHERE id IN (SELECT interestid FROM interest_user WHERE userid=$usid)");
674 
675  while ($row3 = mysql_fetch_array($interestname))
676  {
677 
678  echo $row3['name'] . "<br>";
679 
680  }
681  */
682  if($i==0) echo "This conference does not have any topics yet.";
683 
684  }
685 
689  public function announcementFunctions()
690  {
691 
692  Connect_DatabaseController::connect();
693 
694 
695  $confid = $_GET['id'];
696 
697  $ann = mysql_query("SELECT * FROM announcements WHERE announcementid IN
698  (SELECT announcementid
699  FROM conference_announcement
700  WHERE conferenceid='$confid') ORDER BY announcementdate");
701 
702  if(mysql_num_rows($ann)==0)
703  {
704 
705  }
706  else
707  {
708 
709  while($row = mysql_fetch_array($ann))
710  {
711  $title = $row['header'];
712  $date = $row['announcementdate'];
713  $text = $row['text'];
714 
715  echo "<b>" . $title . " " . "(" . $date . ")</b><br>";
716  echo $text . "<br><br>";
717 
718 
719  }
720  }
721 
722 
723 
724  }
725 
729  public function hasAnnouncement()
730  {
731 
732  Connect_DatabaseController::connect();
733 
734 
735  $confid = $_GET['id'];
736 
737  $ann = mysql_query("SELECT * FROM conference_announcement WHERE conferenceid='$confid'");
738 
739  if(mysql_num_rows($ann)==0)
740  {
741  echo "hidden";
742  }
743  else
744  {
745 
746  echo "visible";
747 
748  }
749 
750  }
751 
752 
753 }
Generated on Sun Jun 2 2013 05:35:37 for EliteConf by   doxygen 1.8.4