HomeController.php

Go to the documentation of this file.

<?php

class HomeController extends Controller
{
    
        public $conferenceid;
        
    public function actionIndex()
    {
                $userid = Yii::app()->user->id;
                //$conferenceid = 0;
                $command = Yii::app()->db->createCommand();
                $command ->select('conferenceid')
                        ->from('conference_user_type')
                        ->where('userid'==$userid, array($this->conferenceid => 'conferenceid'))
                        ->queryRow();
                echo $this->conferenceid;
        $this->render('index');
                
                //$result = mysql_query("SELECT DISTINCT conferenceid FROM conference_user WHERE userid=$userid");
    }
        
        public function viewIfNewMessage()
        {
            
            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
            $message = mysql_query("SELECT id FROM message WHERE receiverid='$usid' AND read_unread='0'");          
            
            $i=0;

            while($row = mysql_fetch_array($message))
                    {
                       if($i==0) echo " " . "(!)<br>";
                       
                       $i++;
                    }
  
        }
        
        public function links()
        {

            if(Yii::app()->user->id != NULL)
            $usid = Yii::app()->user->id;
            else
            $usid = 0; 

            if($usid == 5)     
            echo "<a href=./index.php?r=interests_confirmation>Confirm New Interest Requests</a> <br/><br/>"; 

            echo "<a href=./index.php?r=user_profile&usid=$usid>My Profile</a> <br/><br/>" ;
            echo "<a href=./index.php?r=site/request_conference>Request Conference</a> <br/><br/>";
            echo "<a href=./index.php?r=myconferences>My Conferences</a><br/><br/>" ;
            echo "<a href=./index.php?r=mypapers>My Papers</a><br/><br>";
            echo "<a href=./index.php?r=myInvitations>My Invitations</a><br/><br>" ;
            echo "<a href=./index.php?r=mymessages>My Messages</a>" . " " ;
            echo "<a>" . $this->viewIfNewMessage() . "</a>";
            
        }
        

    
    // 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',
            ),
        );
    }
    */
}