MyconferencesController.php

Go to the documentation of this file.

<?php

class MyconferencesController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
    
        public function administering()
        {
            
            Connect_DatabaseController::connect();
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;

            //select all conferences that the user has admin as his user type
            $admin = mysql_query("SELECT DISTINCT conferenceid FROM conference_user_type WHERE userid='$usid' AND usertype=1");
            
            $i=0;

            while($row = mysql_fetch_array($admin))
                    {

                    $asd = $row['conferenceid'];
                    $result1 = mysql_query("SELECT name FROM conference WHERE conferenceid='$asd'");

                    while($row2 = mysql_fetch_array($result1))
                            {
                            echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
                            echo "  ";
                            }

            //  echo "<br />";
            //  echo "Conference ID   : " . $row['conferenceid'];
                    $co = $row['conferenceid'];
                    echo "<br />";
            //      echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
                            echo "<a href=\" ./index.php?r=conference/view&id=$co\">View Conference </a>";
/*                            echo " <br/> ";
                            echo "<a href=\" ./index.php?r=editConference/index&va=$co\">Edit Conference </a>";
                            echo "<br/>";
                            echo "<a href=\" ./index.php?r=inviteuser/index&va=$co\">Invite Users </a>";
                            echo "<br/>";
                            echo "<a href=\" ./index.php?r=participation_confirmation/index&va=$co\">View Participation Requests</a>";
*/                  echo "<br />";
                    echo "<br />";
            $i++;
                    }
                    
            if($i==0) echo "You are not administering any conference.";

        }
        
        public function authoring()
        {
            
            Connect_DatabaseController::connect();
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $i=0;
            
            //select all conferences that the user has author as his user type
            $author = mysql_query("SELECT DISTINCT conferenceid FROM conference_user_type WHERE userid='$usid' AND usertype=2");

            while($row = mysql_fetch_array($author))
                    {

                    $asd = $row['conferenceid'];
                    $result1 = mysql_query("SELECT name FROM conference WHERE conferenceid='$asd'");

                    while($row2 = mysql_fetch_array($result1))
                            {
                            echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
                            echo "  ";
                            }

            //  echo "<br />";
            //  echo "Conference ID   : " . $row['conferenceid'];
                    $co = $row['conferenceid'];
                    echo "<br />";
            //      echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
                            echo "<a href=\" ./index.php?r=conference/view&id=$co\">View Conference </a>";
                    echo "<br />";
                    echo "<br />";
            $i++;

                    }
            
            if($i==0) echo "You are not authoring in any conference.";
   
                    
        }
        
        public function refereeing()
        {
            
            Connect_DatabaseController::connect();
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $i=0;

        //select all conferences that the user has referee as his user type
        $referee = mysql_query("SELECT DISTINCT conferenceid FROM conference_user_type WHERE userid='$usid' AND usertype=3");

        while($row = mysql_fetch_array($referee))
                {

                $asd = $row['conferenceid'];
                $result1 = mysql_query("SELECT name FROM conference WHERE conferenceid='$asd'");

                while($row2 = mysql_fetch_array($result1))
                        {
                        echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
                        echo "  ";
                        }

        //  echo "<br />";
        //  echo "Conference ID   : " . $row['conferenceid'];
                $co = $row['conferenceid'];
                echo "<br />";
        //      echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
                        echo "<a href=\" ./index.php?r=conference/view&id=$co\">View Conference </a>";

                echo "<br />";
                echo "<br />";
        $i++;
                }
        
        if($i==0) echo "You are not refereeing in any conference.";
          
        }

        
        public function attending()
        {
            
            Connect_DatabaseController::connect();
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
        $i=0;            

        //select all conferences that the user has attendee as his user type    
        $attendee = mysql_query("SELECT DISTINCT conferenceid FROM conference_user_type WHERE userid='$usid' AND usertype=4");

        while($row = mysql_fetch_array($attendee))
                {

                $asd = $row['conferenceid'];
                $result1 = mysql_query("SELECT name FROM conference WHERE conferenceid='$asd'");

                while($row2 = mysql_fetch_array($result1))
                        {
                        echo "<B>".($i+1)."</B>" . ") Conference Name : " . $row2['name'];
                        echo "  ";
                        }

        //  echo "<br />";
        //  echo "Conference ID   : " . $row['conferenceid'];
                $co = $row['conferenceid'];
                echo "<br />";
        //      echo CHtml::link("View Conference",array('conference/index', '&va'=>$co));
                        echo "<a href=\" ./index.php?r=conference/view&id=$co\">View Conference </a>";

                echo "<br />";
                echo "<br />";
        $i++;
                }            
                
        if($i==0) echo "You are not attending any conference.";


    
    }

    // Uncomment the following methods and override them if needed
    /*
    public function filters()
    {
        // return the filter configuration for this controller, e.g.:
        return array(
            'inlineFilterName',
            array(
                'class'=>'path.to.FilterClass',
                'propertyName'=>'propertyValue',
            ),
        );
    }

    public function actions()
    {
        // return external action classes, e.g.:
        return array(
            'action1'=>'path.to.ActionClass',
            'action2'=>array(
                'class'=>'path.to.AnotherActionClass',
                'propertyName'=>'propertyValue',
            ),
        );
    }
    */
}